EBS:AP_PAYMENT_SCHEDULES_ALL

最新推荐文章于 2025-11-06 20:14:35 发布

原创最新推荐文章于 2025-11-06 20:14:35 发布 · 523 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

EBS 专栏收录该内容

88 篇文章

订阅专栏

这篇博客探讨了数据库中预付信息的管理，主要涉及AP_PAYMENT_SCHEDULES_PK表，其中包括INVOICE_ID和PAYMENT_NUM等关键字段。此表与其他表如AP_INVOICES_ALL、AP_BATCHES_ALL和AP_BANK_ACCOUNTS_ALL通过外键关联。此外，它还与AP_INVOICE_PAYMENTS_ALL和JL_BR_AP_COLLECTION_DOCS_ALL表相互关联，用于处理发票支付和收款文档。内容着重于数据库设计和企业支付结算流程的细节。

描述：发票上的预定付款信息

Primary Key: AP_PAYMENT_SCHEDULES_PK

INVOICE_ID
PAYMENT_NUM

Foreign Keys from this table:

Foreign Key Column	Foreign Table
AP_PAYMENT_SCHEDULES_ALL.INVOICE_ID	AP_INVOICES_ALL
AP_PAYMENT_SCHEDULES_ALL.BATCH_ID	AP_BATCHES_ALL
AP_PAYMENT_SCHEDULES_ALL.EXTERNAL_BANK_ACCOUNT_ID	AP_BANK_ACCOUNTS_ALL

Foreign Keys to this table:

Foreign Key Column	Foreign Table
AP_INVOICE_PAYMENTS_ALL.INVOICE_ID AP_INVOICE_PAYMENTS_ALL.PAYMENT_NUM	AP_PAYMENT_SCHEDULES_ALL
JL_BR_AP_COLLECTION_DOCS_ALL.INVOICE_ID JL_BR_AP_COLLECTION_DOCS_ALL.PAYMENT_NUM	AP_PAYMENT_SCHEDULES_ALL