Data Structure of Oracle Payables

Data Structure of Oracle Payables

Ap_invoices_all

: Invoices > Entry > Invoices

This table stores all the invoices you enter.  For an invoice to be approved, the total invoice amount must be stored in ap_invoice_distributions_all and ap_payment_schedules_all.

Some columns of interest includes :

·         Invoice_num

·         Invoice_date

·         Amount_paid

·         Invoice_currency_code

·         Invoice_type_lookup_code

·         Payment_status_flag

Ap_invoice_distributions_all

: Invoices > Entry > Invoices

This table stores the accounting information for the invoice you have entered. There is one row for each invoice disribution, that is this table corresponds to the Distributions window.

Some columns of interest includes :

·         Line_type_lookup_code

·         Dist_code_combination_id (credit entry)

·         Accts_pay_code_combination_id (debit_entry)

·         Base_amount (in functional currency)

Ap_checks_all

: Payments > Entry > Payments

This table stores payments to suppliers.

Some columns of interest includes :

·         Amount (in functional currency)

·         Check_date

·         Bank_account_name

·         Check_number

·         Payment_method_lookup_code

·         Payment_type_flag

Ap_invoice_payments_all

: Payments > Entry > Payments

This table stores invoice payments to suppliers.  This table is updated when you confirm an automatic payment batch, enter a manual payment or process a Quick Payment.  Void payments are represented as a negative of the original payment line.

Some columns of interest includes :

·         Accounting_date

·         Period_name

·         Amount

·         Payment_num

Ap_payment_distributions_all

: Payments > Entry > Payments

This table stores accounting information for payments.  There is at least one CASH payment distribution for each invoice payment.  Additional rows may include DISCOUNT, GAIN and LOSS distributions where appropriate.

Some columns of interest includes :

·         Line_type_lookup_code (CASH/DISCOUNT/GAIN/LOSS)

·         Base_amount