title: 01_GLM001(GLM001A)傳票維護_ER-Model
date: 2024-09-28 21:23:37
permalink: /GL/GLM001/GLM001_ERmodel/
categories: WDS
tags: [C# , SA , UML ,GL]
description: 01_GLM001(GLM001A)傳票維護_ER-Model

01_GLM001(GLM001A)傳票維護_ER-Model

GLM001(GLM001A)傳票維護 中提到的資料表：

1. GL_VOUCHER_MASTER（傳票主檔）

2. GL_VOUCHER_DETAIL（傳票明細檔）

3. AP_DETAIL（應付帳款明細檔）

4. AR_DETAIL（應收帳款明細檔）

5. NP_DETAIL（應付票據明細檔）

6. NR_DETAIL（應收票據明細檔）

7. PIV_INCOME_EVIDENCE（進項憑證檔）

8. PPY_MASTER（暫付款主檔）

9. PPY_DETAIL（暫付款明細檔）

10. SI2_INVOICE_MASTER（發票主檔）

11. SYS_PARM_D（系統參數檔）

12. NP_CODE_REFERENCE（代碼參考檔）

備註

1. 根據 GLM001 的 stored procedure，以上列出的資料表包含傳票維護作業中涉及的各種應付、應收、暫付款、發票等相關表格，以及檢查程序所需的系統參數表與代碼參考表。
2. 在進行傳票刪除、檢查等操作時，會使用這些資料表中的欄位來進行驗證和邏輯處理。

Table GL_VOUCHER_MASTER {
  VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  ACCNT_YEAR VARCHAR2(4) [note: '年度']
  ACCNT_PERIOD VARCHAR2(2) [note: '會計期間']
  VOUCHER_DATE DATE [note: '傳票日期']
  COMPANY_ID VARCHAR2(4) [note: '公司別']
  ACCNT_CREATOR VARCHAR2(10) [note: '製票員']
  LAST_UPDATE_DATE DATE [note: '最近維護日']
  PRINT_CODE VARCHAR2(1) [note: '列印碼']
  DELETE_CODE VARCHAR2(1) [note: '刪除碼']
}

Table GL_VOUCHER_DETAIL {
  COMPANY_ID VARCHAR2(4) [note: '公司別']
  VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  ACCNT_NO VARCHAR2(10) [note: '科目代號']
  SEQ_NO NUMBER(4) [note: '序號']
  UNIT_ID VARCHAR2(7) [note: '單位別']
  OBJECT_NO VARCHAR2(10) [note: '對象代號']
  RELATION_NO VARCHAR2(15) [note: '相關號碼']
  RELATION_DATE DATE [note: '相關日期']
  DEBIT_AMT NUMBER [note: '借方金額']
  CREDIT_AMT NUMBER [note: '貸方金額']
  ACCNT_NAME VARCHAR2(100) [note: '科目名稱']
  UNIT_NAME VARCHAR2(100) [note: '單位名稱']
  OBJECT_NAME VARCHAR2(300) [note: '對象名稱']
  VOUCHER_DESC VARCHAR2(1000) [note: '摘要']
  OFFSET_NO VARCHAR2(10) [note: '沖銷代號']
  OFFSET_VOUCHER_NO VARCHAR2(12) [note: '沖銷傳票號']
  OFFSET_DUE_DATE DATE [note: '沖銷到期日']
  CREATE_OFFSET_SEQ NUMBER(2) [note: '立沖序號']
  ORDER_SEQ NUMBER [note: '排列序號']
  LAST_UPDATE_DATE DATE [note: '最近維護日']
}

Table AP_DETAIL {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  CREATE_VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  VOUCHER_SEQ NUMBER [note: '傳票序號']
  MASTER_SEQ NUMBER [note: '主檔序號']
  SECOND_SEQ NUMBER [note: '二級序號']
  OFFSET_AMT NUMBER [note: '抵消金額']
  LAST_UPDATE_DATE DATE [note: '最後更新日期']
}

Table AR_DETAIL {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  CREATE_VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  VOUCHER_SEQ NUMBER [note: '傳票序號']
  OFFSET_VOUCHER_NO VARCHAR2(12) [note: '沖銷傳票編號']
}

Table NP_DETAIL {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  CREATE_VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  CREATE_VOUCHER_SEQ NUMBER [note: '傳票序號']
  OFFSET_VOUCHER_NO VARCHAR2(12) [note: '沖銷傳票編號']
}

Table NR_DETAIL {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  CREATE_VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  CREATE_VOUCHER_SEQ NUMBER [note: '傳票序號']
  OFFSET_VOUCHER_NO VARCHAR2(12) [note: '沖銷傳票編號']
}

Table PIV_INCOME_EVIDENCE {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  VOUCHER_SEQ NUMBER [note: '傳票序號']
}

Table PPY_MASTER {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  CREATE_VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  VOUCHER_SEQ NUMBER [note: '傳票序號']
  DOCUMENT_NO VARCHAR2(20) [note: '文件編號']
}

Table PPY_DETAIL {
  DOCUMENT_NO VARCHAR2(20) [note: '文件編號']
  OFFSET_VOUCHER_NO VARCHAR2(12) [note: '沖銷傳票編號']
}

Table SI2_INVOICE_MASTER {
  COMPANY_ID VARCHAR2(8) [note: '公司別']
  VOUCHER_NO VARCHAR2(12) [note: '傳票編號']
  VOUCHER_SEQ NUMBER [note: '傳票序號']
}

Table SYS_PARM_D {
  PARM_ID VARCHAR2(10) [note: '參數 ID']
  PARM_ID_CODE VARCHAR2(10) [note: '參數代號']
  PARM_REMARK VARCHAR2(100) [note: '參數描述']
  PARM_VALUE1 VARCHAR2(20) [note: '參數值 1']
  PARM_VALUE2 VARCHAR2(20) [note: '參數值 2']
}

Table NP_CODE_REFERENCE {
  CODE_KIND VARCHAR2(2) [note: '代號類型']
  CODE_NO VARCHAR2(10) [note: '代號']
}

Ref: GL_VOUCHER_MASTER.VOUCHER_NO > GL_VOUCHER_DETAIL.VOUCHER_NO
Ref: GL_VOUCHER_MASTER.COMPANY_ID > GL_VOUCHER_DETAIL.COMPANY_ID
Ref: AP_DETAIL.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID
Ref: AR_DETAIL.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID
Ref: NP_DETAIL.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID
Ref: NR_DETAIL.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID
Ref: PIV_INCOME_EVIDENCE.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID
Ref: PPY_MASTER.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID
Ref: SI2_INVOICE_MASTER.COMPANY_ID > GL_VOUCHER_MASTER.COMPANY_ID