title: 01_GLM002(GLM001)過帳傳票維護_ER-Model
date: 2024-09-29 05:14:32
permalink: /GL/GLM002/GLM002_ERmodel/
categories: WDS
tags: [C# , SA , UML ,GL]
description: 01_GLM002(GLM001)過帳傳票維護_ER-Model

01_GLM002(GLM001)過帳傳票維護_ER-Model

根據 GLM001 stored procedure 和 "GLM002(GLM001)過帳傳票維護.doc" 文件的內容，以下是相關的 Table 及欄位名稱，加上中文欄位備註：

1. GL_VOUCHER_MASTER（傳票主檔）

2. GL_VOUCHER_DETAIL（傳票明細檔）

3. GL_CREATE_OFFSET_BALANCE（立沖餘額檔）

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

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

6. NP_DETAIL（核銷應付款項明細檔）

7. NR_DETAIL（核銷應收款項明細檔）

8. PIV_INCOME_EVIDENCE（進項憑證檔）

9. PPY_MASTER（應付款項主檔）

10. PPY_DETAIL（應付款項明細檔）

11. SI2_INVOICE_MASTER（發票主檔）

12. SYS_PARM_D（系統參數檔）

13. NP_CODE_REFERENCE（單位代號參考檔）

| 代碼類型 |
| CODE_NO | VARCHAR2(10) | 代號 |

Table ap_detail {
  company_id varchar(8) [note: '公司別']
  create_voucher_no varchar(12) [note: '傳票號碼']
  voucher_seq number [note: '傳票序號']
  master_seq number [note: '主檔序號']
  second_seq number [note: '二級序號']
  offset_amt number [note: '抵消金額']
  last_update_date date [note: '最後更新日期']
}

Table ap_master {
  company_id varchar(8) [note: '公司別']
  create_voucher_no varchar(12) [note: '傳票號碼']
  voucher_seq number [note: '傳票序號']
  master_seq number [note: '主檔序號']
  object_no varchar(10) [note: '交易方代號']
  accnt_no varchar(10) [note: '帳號']
  effect_date date [note: '生效日期']
  ap_amt number [note: '應付款項金額']
  mortgage_amt number [note: '抵押金額']
  ap_offset_amt number [note: '應付沖帳金額']
}

Table ar_master {
  company_id varchar2 [note: '公司代號']
  create_voucher_no varchar2 [note: '傳票號碼']
  unit_id varchar2 [note: '單位代號']
  accnt_no varchar2 [note: '科目代號']
  document_no varchar2 [note: '文件號碼']
  source_type varchar2 [note: '來源類型']
  customer_no varchar2 [note: '客戶編號']
  effect_date date [note: '生效日期']
  ar_amt number [note: '應收金額']
  ar_remark varchar2 [note: '應收備註']
  invoice_no varchar2 [note: '發票號碼']
  ar_responser varchar2 [note: '負責人']
  pay_type varchar2 [note: '付款方式']
  ar_offset_amt number [note: '應收沖帳金額']
  voucher_seq number [note: '傳票序號']
  master_seq number [note: '主檔序號']
  last_update_date date [note: '最後更新日期']
}

Table gl_voucher_detail {
  maintain_code varchar2 [note: '維護代碼']
  company_id varchar2 [note: '公司代號']
  voucher_no varchar2 [note: '傳票號碼']
  accnt_year varchar2 [note: '會計年度']
  accnt_period varchar2 [note: '會計期間']
  voucher_date date [note: '傳票日期']
  unit_id varchar2 [note: '單位代號']
  seq_no number [note: '序號']
  accnt_no varchar2 [note: '科目代號']
  object_no varchar2 [note: '對象代號']
  relation varchar2 [note: '關聯號碼']
  relation_date date [note: '關聯日期']
  amount number [note: '金額']
  description varchar2 [note: '描述']
  print_code varchar2 [note: '列印代碼']
  delete_code varchar2 [note: '刪除代碼']
  voucher_seq number [note: '傳票序號']
  last_update_date date [note: '最後更新日期']
}

Table gl_voucher_master {
  maintain_code varchar2 [note: '維護代碼']
  company_id varchar2 [note: '公司代號']
  voucher_no varchar2 [note: '傳票號碼']
  accnt_year varchar2 [note: '會計年度']
  accnt_period varchar2 [note: '會計期間']
  voucher_date date [note: '傳票日期']
  last_update_date date [note: '最後更新日期']
  accnt_creator varchar2 [note: '傳票創建者']
  accnt_version varchar2 [note: '傳票版本']
  print_code varchar2 [note: '列印代碼']
  delete_code varchar2 [note: '刪除代碼']
  source_type varchar2 [note: '資料來源']
}

Table np_code_reference {
  code_kind varchar(2) [note: '代碼種類']
  code_no varchar(10) [note: '代碼']
}

Table np_detail {
  company_id varchar(8) [note: '公司別']
  create_voucher_no varchar(12) [note: '傳票號碼']
  create_voucher_seq number [note: '傳票序號']
  offset_voucher_no varchar(12) [note: '沖銷傳票號']
}

Table nr_detail {
  company_id varchar(8) [note: '公司別']
  create_voucher_no varchar(12) [note: '傳票號碼']
  create_voucher_seq number [note: '傳票序號']
  offset_voucher_no varchar(12) [note: '沖銷傳票號']
}

Table piv_income_evidence {
  invoice_no varchar(10) [note: '進項發票號']
  sale_amt number [note: '銷售金額（未稅）']
  invoice_date date [note: '發票日期']
  tax_amt number [note: '稅額']
}

Table ppy_detail {
  document_no varchar(10) [note: '文件號碼']
  offset_voucher_no varchar(12) [note: '沖銷傳票號']
}

Table ppy_master {
  company_id varchar(8) [note: '公司別']
  create_voucher_no varchar(12) [note: '傳票號碼']
  voucher_seq number [note: '傳票序號']
  document_no varchar(10) [note: '文件號碼']
}

Table sys_parm_d {
  parm_id varchar(10) [note: '參數 ID']
  parm_id_code varchar(10) [note: '參數代號']
  parm_remark varchar(100) [note: '參數描述']
  parm_value1 varchar(10) [note: '參數值 1']
  parm_value2 varchar(10) [note: '參數值 2']
}

Ref: ap_detail.company_id > ap_master.company_id
Ref: ap_detail.create_voucher_no > ap_master.create_voucher_no
Ref: ap_detail.voucher_seq > ap_master.voucher_seq
Ref: ap_detail.master_seq > ap_master.master_seq

Ref: ar_master.create_voucher_no > gl_voucher_master.voucher_no
Ref: gl_voucher_master.voucher_no > gl_voucher_detail.voucher_no
Ref: np_detail.create_voucher_no > gl_voucher_master.voucher_no
Ref: nr_detail.create_voucher_no > gl_voucher_master.voucher_no
Ref: piv_income_evidence.invoice_no > gl_voucher_detail.object_no

Ref: ppy_master.create_voucher_no > gl_voucher_master.voucher_no
Ref: ppy_master.document_no > ppy_detail.document_no

Ref: sys_parm_d.parm_id_code > np_code_reference.code_no