EBS:AP_PAYMENT_HISTORY_ALL

描述：付款期限和对账历史

Primary Key: AP_PAYMENT_HISTORY_PK

1. PAYMENT_HISTORY_ID

Foreign Keys from this table:

Foreign Key Column	Foreign Table
AP_PAYMENT_HISTORY_ALL.CHECK_ID	AP_CHECKS_ALL
AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID	AP_ACCOUNTING_EVENTS_ALL
AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID	AP_PAYMENT_HISTORY_ALL

Foreign Keys to this table:

Foreign Key Column	Foreign Table
AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID	AP_PAYMENT_HISTORY_ALL

Comments：

AP_PAYMENT_HISTORY_ALL存储支付的清算/未清算历史记录。它还存储未来付款的到期日历史。这个表包含了一个行，每个未来日期付款，一旦未来日期付款到期，即成为可流通的。每当支付被清除或未清除时，就会在该表中插入一行用于支付。TRANSACTION_TYPE的值可以是付款期限、付款结算或付款未结算。该表中的每一行还包含到期、结清或未结清事件的会计状态。