Oracle Accounts Payables (AP) – Key Tables 2

AP_PAYMENT_SCHEDULES_ALL contains information about
scheduled payments for an invoice. You need one row for each time you
intend to make a payment on an invoice. Your Oracle Payables
application uses this information to determine when to make payments
on an invoice and how much to pay in an automatic payment batch.
Values for HOLD_FLAG may be ’Y’ to place a hold on the scheduled
payment, or ’N’ not to do so. Values for PAYMENT_STATUS_FLAG
may be ’Y’ for fully paid payment schedules, ’N’ for unpaid scheduled
payments, or ’P’ for partially paid scheduled payments. For converted
records, enter a value for AMOUNT_REMAINING.

AP_HOLDS_ALL contains information about holds that you or your
Oracle Payables application place on an invoice. For non–matching
holds, there is one row for each hold placed on an invoice. For matching
holds, there is one row for each hold placed on an invoice–shipment
match. An invoice may have one or more corresponding rows in this
table. Your Oracle Payables application does not pay invoices that have
one or more unreleased holds recorded in this table.
This table holds information referenced by the Invoice Holds window.
In the strictest sense, AP_HOLDS_ALL has no primary key. It is
possible for your Oracle Payables application to place a certain type of
hold on an invoice, then release it, then place another hold of the same
type (if data changes before each submission of Approval), which would
result in a duplicate primary key. But for practical purposes, the
primary key is a concatenation of INVOICE_ID, LINE_LOCATION_ID,

An accounting entry line is an entity containing a proper accounting
entry with debits or credits both in transaction currency as well as
functional currency along with an account and other reference
information pointing to the transaction data that originated the
accounting entry line. An accounting entry line is grouped with other
accounting entry lines for a specific accounting entry header. Any such
group of accounting entry lines should result in balanced entries in the
functional currency.

An accounting entry header is an entity grouping all accounting entry
lines created for a given accounting event and a particular set of books.
An accounting entry header can either be transferred over to GL or not
at all. That is, either all its accounting entry lines are transferred or none
at all. The transferred to GL status is marked in the
GL_TRANSFER_FLAG. Possible values for GL_TRANSFER_FLAG are
Y, N, or E. Y indicates that the accounting entry header has been
transferred to GL. N indicates that the accounting entry header has not
been transferred to GL due to 2 possible reasons: either the transfer
process has not run or it has run but the accounting entry had an
accounting error on it. E indicates that an error was encountered during
the transfer to GL process.

Leave a Comment