根付款相关的表

Payments and it's tables:
You can create either single payments or payments batches containing multiple payments.
  Payment Types
-- Manual Payment: When you create a single payment, rather than an entire payment
batch, you either record a manual payment that you generated outside of Payables.
-- Quick Payment: When you create a single payment, rather than an entire payment batch,
you can create a Quick payment (single computer-generated payment).
-- Refund:(退款) Used to record payments you receive from suppliers for refunds and rebates(折扣).
-- Payment Batches: Used to create payments for multiple invoices that meet the specified
selection criteria, to control which invoices Oracle Payables selects for payment in the
batch, to set payment amount limits, and to take applicable discounts. Payment batches
require confirming electronic batches and successful check printing.
Payment Methods
-- Check/Printed
-- Electronic: Use Quick Payments or Payment Batches
-- Wire
-- Clearing: Used to account for intercompany集团内部 expenses when you do not actually disburse支付
funds through banks.

The following tables store information pertaining to the payments made against supplier
invoices:
-- AP_BANK_ACCOUNTS_ALL
-- AP_CHECKS_ALL
-- AP_INVOICE_PAYMENTS_ALL
-- AP_ACCOUNTING_EVENTS_ALL
-- AP_PAYMENT_HISTORY_ALL
-----------------------------------------------------------------------------------------------------------------
AP_BANK_ACCOUNTS_ALL:
--this table stores information about the bank accounts of your company, suppliers,and
customers.
(N) Setup > Payment > Banks (B) Bank Accounts
Major Columns
-- BANK_ACCOUNT_ID
-- BANK_ACCOUNT_NAME
-- BANK_ACCOUNT_NUM
-- BANK_BRANCH_ID
-- SET_OF_BOOKS_ID
-- CURRENCY_CODE
-- ACCOUNT_TYPE
-- ASSET_CODE_COMBINATION_ID
Foreign Keys
Primary Key Table            Primary Key Column             Foreign Key Column
AP_BANK_BRANCHES              BANK_BRANCH_ID                   BANK_BRANCH_ID
FND_CURRENCIES                CURRENCY_CODE                     CURRENCY_CODE
GL_CODE_COMBINATIONS        CODE_COMBINATION_ID                ASSET_CODE_COMBINATION_ID
GL_CODE_COMBINATIONS        CODE_COMBINATION_ID                LOSS_CODE_COMBINATION_ID
GL_CODE_COMBINATION         CODE_COMBINATION_ID                 GAIN_CODE_COMBINATION_ID
GL_CODE_COMBINATIONS        CODE_COMBINATION_ID                  CASH_CLEARING_CCID
GL_CODE_COMBINATION         CODE_COMBINATION_ID                  BANK_CHARGES_CCID
AP_BANK_BRANCHES             BANK_BRANCH_ID                      BANK_BRANCH_ID
FND_CURRENCIES                 CURRENCY_CODE                     CURRENCY_CODE
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   ASSET_CODE_COMBINATION_ID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                  LOSS_CODE_COMBINATION_ID
GL_CODE_COMBINATION        CODE_COMBINATION_ID                  GAIN_CODE_COMBINATION_ID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   CASH_CLEARING_CCID
GL_CODE_COMBINATION        CODE_COMBINATION_ID                   BANK_CHARGES_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   BANK_ERRORS_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   EARNED_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   UNEARNED_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   ON_ACOUNT_CCID
GL_CODE_COMBINATION        CODE_COMBINATION_ID                   UNAPPLIED_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   UNIDENTIFIED_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                   FACTOR_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                 RECDIPT_CLEARING_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                  REMITTANCE_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                 SHORT_TERM_DEPOSIT_CCID
GL_CODE_COMBINATIONS       CODE_COMBINATION_ID                 FUTURE_DATED_PAYMENT_CCID
GL_SETS_OF_BOOKS           CODE_COMBINATION_ID                   SET_OF_BOOKS_ID
PAY_EXTERNAL_ACCOUNTS      EXTERNAL_ACCOUNT_ID                  PAYROLL_BANK_ACCOUNT_ID
------------------------------------------------------------------------------------------------------------------
AP_checks_all:
--this table stores information about payments issued to suppliers.
--each row includes the supplier name,address,and bank account name. if the
payment is electronic ,the supplier bank account information is stored in the payment record.
(N) Payments > Entry > Payments
-- CHECK_ID (PK)
-- CURRENCY_CODE
-- AMOUNT (Transaction currency)
-- BASE_AMOUNT (Functional currency)
-- BANK_ACCOUNT_ID
-- BANK_ACCOUNT_NAME
-- CHECK_DATE
-- CHECK_NUMBER
-- PAYMENT_METHOD_LOOKUP_CODE *
-- VENDOR_NAME
-- CHECK_STOCK_ID
-- CHECK_FORMAT_ID
-- ORG_ID
-- PAYMENT_TYPE_FLAG [A/M/Q]
-- VENDOR_ID
-- VENDOR_SITE_ID
CHECK/CLEARING/ELECTRONIC/WIRE
Foreign Keys
Primary Key Table                  Primary Key Column               Foreign Key Column
AP_BANK_ACCOUNTS_ALL                BANK_ACCOUNT_ID                  BANK_ACCOUNT_ID
AP_BANK_ACCOUNTS_ALL                BANK_ACCOUNT_ID               EXTERNAL_BANK_ACCOUNT_ID
AP_CHECK_FORMATS                    CHECK_FORMAT_ID                  CHECK_FORMAT_ID
AP_DOC_SEQUENCE_AUDIT                DOC_SEQUENCE_ID                 DOC_SEQUENCE_ID
                                     DOC_SEQUENCE_VALUE             DOC_SEQUENCE_VALUE
AP_INV_SELECTION_CRITERIA_ALL        CHECKRUN_NAME                    CHECKRUN_NAME
                                     CHECKRUN_ID                      CHECKRUN_ID
FND_CURRENCIES                      CURRENCY_CODE                     CURRENCY_CODE
FND_DOCUMENT_SEQUENCES               DOC_SEQUENCE_ID                DOC_SEQUENCE_ID
FND_DOC_SEQUENCE_CATEGORIES         DOC_CATEGORY_CODE               DOC_CATEGORY_CODE
GL_DAILY_CONVERSION_TYPES           CONVERSION_TYPE                 EXCHANGE_RATE_TYPE
GL_DAILY_CONVERSION_TYPES          CONVERSION_TYPE                 CLEARED_EXCHANGE_RATE_TYPE
GL_DAILY_CONVERSION_TYPE           CONVERSION_TYPE                   MATURITY_EXCHANGE_RATE
GL_USSGL_TRANSACTION_CODES          USSGL_TRANSACTION_ CODE         USSGL_TRANSACTION_ CODE
PO_VENDORS                          VENDOR_ID                            VENDOR_ID
PO_VENDOR_SITES_ALL                  VENDOR_SITE_ID                       VENDOR_SITE_ID
--------------------------------------------------------------------------------------
AP_INVOICE_PAYMENTS_ALL
--this table provides the link between a payment(check_id)and the invoice(s)paid by that
payment.
--oracle payables updates this table when you confirm an automatic payment batch,
enter a manual payment,or process a Quick payment.
--this table contains records of invoice payments that you make to suppliers,
--this table contains one row for each payment made for each invoice.
--void(作废的) payments are also entered into this table as a negative record of the
original payment line
(N) Payments > Entry > Payments > (B) Enter/Adjust Invoices
   Major Columns
-- INVOICE_PAYMENT_ID (PK)
-- CHECK_ID
-- INVOICE_ID
-- AMOUNT
-- ACCOUNTING_DATE
-- ACCRUAL_POSTED_FLAG
-- CASH_POSTED_FLAG
-- PAYMENT_NUM
-- PERIOD_NAME
-- SET_OF_BOOKS_ID
-- DISCOUNT_LOST
-- DISCOUNT_TAKEN
-- ORG_ID
Foreign Keys
Primary Key Table            Primary Key Column            Foreign Key Column
AP_ACCOUNTING_EVENTS_ALL       ACCOUNTING_EVENT_ID          ACCOUNTING_EVENT_ ID
AP_CHECKS_ALL                   CHECK_ID                      CHECK_ID
AP_INVOICES_ALL               INVOICE_ID                     INVOICE_ID
GL_DAILY_CONVERSION_TYPES      CONVERSION_TYPE              EXCHANGE_RATE_TYPE
GL_PERIODS                    PERIOD_NAME                    PERIOD_NAME
GL_SETS_OF_BOOKS              SET_OF_BOOKS_ID              SET_OF_BOOKS_ID
----------------------------------------------------------------------------------------------------------------
AP_ACCOUNTING_EVENTS_ALL
--an accounting event is a transaction activity that has an accounting impact,for example,
invoice adjustment ,preparyment application ,or payment.
--the type of event controls the accounting created for a transaction and its appearance
in the subledger.
--the accounting events in payables are divided into two document classes: invoices and
payments.
Major Columns
-- ACCOUNTING_EVENT_ID (PK)
-- EVENT_TYPE_CODE
-- ACCOUNTING_DATE
-- EVENT_NUMBER
-- EVENT_STATUS_CODE
-- SOURCE_ID
-- ORG_ID

-------------------------------------------------------------------------------------------------------------------------
GL Tables Used in Payables
-- GL_PERIOD_STATUSES: This table stores the statuses for your accounting periods.
You open and close periods in your primary set of books only. You cannot close a period
until you have posted all outstanding transactions to General Ledger in both your primary
and associated reporting sets of books. Each row in this table includes the accounting
period name status, and application ID since other applications maintain their calendars
in this table. This table is discussed in he Oracle General Ledger module.
-- GL_DAILY_RATES: This table stores the daily conversion rates for foreign currency
transactions. The AutoRate program uses the exchange rate information in this table to
enter exchange rates for any foreign currency invoices or payments that have no
exchange rates. AutoRate cannot update exchange rates unless you have first defined
exchange rates in the GL Daily Rates table that match the invoice or payment currency,
rate date, and rate type.