3Payables Configuration

This chapter contains the following:

• Distribution Sets

• Payment Terms

• Payment Terms and Reference Data Sharing

• Example of Creating Payment Terms Based on Days

• Invoice Tolerances

• Invoice Holds and Releases

• Considerations for Payables Calendar Period Frequencies

• How Periods for Payables Calendars Are Generated

• How You Set Up Third-Party Payments

• Auditing Payables Business Objects

• FAQs for Payables Configuration

Distribution Sets

Distribution sets automatically create distributions for invoices that aren't matched to purchase orders. For example, you can create a distribution set for an advertising supplier that allocates the advertising expense on an invoice to four departments.

You can specify a default distribution set on the Site Assignments tab on the Supplier Site page. If you don't assign a distribution set to a supplier site, you can still assign a set to an invoice during invoice entry.

A distribution set can include:

• Income tax types: If you're creating a distribution set for a federally reported supplier, you can enter an income tax type.

• Project information: If you use Oracle Fusion Project Costing, invoice distributions can include project information. If you use a project-related distribution set, the project information is automatically entered on the invoice distribution. You can override project fields on the distribution.

• Descriptive flexfields: If you use a descriptive flexfield with your distribution set lines, the descriptive flexfield information is copied to the invoice distributions created by the set.

You can define distribution sets for invoice business units with and without percentages.

Distribution Sets with Percentages

Use a 100 percent distribution set when you know the allocation percentages. For example, you can create a distribution set to allocate rent expense across two departments. You can allocate 70 percent of the invoice amount to the sales facility expense account and 30 percent to the administration facility expense account.

Note: Percentage distribution sets can include both positive and negative percentages.

Distribution Sets Without Percentages

Use a 0 percent distribution set when you don't know the allocation percentages. For example, you might allocate facility expenses based on monthly headcount. You can define a zero percent distribution set that includes the expense distributions for each department. You can then provide the distribution amounts during invoice entry.

Payment Terms

Payment terms are used to automatically create invoice installments. You can define payment terms to create multiple installments and multiple levels of discounts.

Payment terms consist of one or more lines, each of which creates one invoice installment. When you define a payment term, you can specify either percentages or fixed amounts. A payment term line can have up to three discounts. Each line and corresponding installment have a due date and up to three discount dates. Each line and corresponding installment also have due or discount amounts. You can assign a payment term to one or more sets to share that payment term across business units.

This figure shows the components of a payment term.

Tip: If you change the payment terms on an invoice, the installments are automatically recalculated and you must reenter any manual adjustments made previously.

Payment Terms Due Dates and Discount Dates

Payment terms due dates and discount dates are based on one of the following methods:

• Fixed Date: A specific day, month, and year that an installment is due for payment.

• Days: A number of days added to the invoice terms date.

• Calendar: A Payables calendar that's divided into periods. You can assign a due date to the period that includes the invoice terms date. You can assign due dates to avoid weekends, holidays, and so on. You can't assign calendar-based terms to an invoice if a period isn't defined for the terms date.

• Day of Month: A type of payment term with the following attributes:

  • Day of Month: A specific day of the month when an installment is due for payment. For example, enter 15 to schedule payment on the fifteenth day of the month. Enter 31 to schedule payment for the last day of the month, including months with less than 31 days.

  • Cutoff Day: The day of the month after which the installment due and discount dates advance to a future month. If you don't specify a cutoff day, the current accounting month is used to determine due and discount dates.

  • Months Ahead: The number that's used to determine the month the installment is due. If you enter 0 and the terms date is the same as, or later than, the cutoff day, the installment is due the following month.

    For example, a payment term has a Cutoff Day of 11, the Day of Month is 15, and Months Ahead is 0. If you enter an invoice with a terms date of January 12, the installment is due February 15. If you enter an invoice with a terms date of January 10, the installment is due January 15. If the terms date is January 12 and Months Ahead is set to 1, the installment is due March 15.

Note: Only due dates, not discount dates, can be based on a calendar.

Default Payment Terms

If you enter an Identifying PO on an invoice, the purchase order provides the default payment terms for the invoice. If you don't enter an Identifying PO, the supplier site provides the default payment terms. If the supplier site doesn't have payment terms, the payment terms from the Manage Invoice Options page are used. You can override the default payment terms on any invoice.

This figure shows how payment terms flow to the invoice.

• How Invoice Installments Are Recalculated

• Reference Data Sets and Sharing Methods

Payment Terms and Reference Data Sharing

Payment terms are enabled for reference data sharing using the method of assignment to multiple sets, no common values allowed. The predefined reference group is called Payables Payment Terms and the determinant type for the reference group is business unit. Before you can use a payment term, you must assign the payment term to a reference data set.

This figure provides an example of how the payment terms Net 45 and Net 30 are shared across different business units.

The Net 45 payment term is assigned to the North America reference data set. The North America reference data set is assigned to the United States and Canada business units. Invoices for these business units can then use the Net 45 payment term. The Net 30 payment term is assigned to the North America and Europe reference data sets. The Europe reference data set is assigned to the France business unit. Invoices for the United States, Canada, and France business units can use the Net 30 payment term.

Setting up Payment Terms for Reference Data Sharing

The setup for payment term reference data sharing includes:

• Assigning a reference data set to a business unit: When you define a business unit, assign the business unit a reference data set for the Payables Payment Terms reference group.

• Generating a data role for a reference data set: To assign a reference data set to a payment term, you must first generate a data role for that reference data set. Generate the data role using the predefined data role template called Financials Common Module Template for SetID.

• Provisioning a data role to the implementor: Assign the reference data set data role to the implementor who creates the payment terms.

• Creating a payment term: Assign one or more reference data sets to a payment term in the Set Assignment section on the Create Payment Terms page.

Tip: Before you define common options for Payables and Procurement, you must assign the Immediate payment term to the reference data set for the business unit.

Note: You can assign a payment term to the predefined common set, which works like any other set. Unless you assign the payment term to other reference data sets, that payment term is available only to the business units with the common set.

• Reference Data Sets and Sharing Methods

• Reference Data Sharing

Example of Creating Payment Terms Based on Days

This example demonstrates how to create payment terms that are based on a certain number of days from the invoice terms date.

This table summarizes key decisions for the scenario.

Decisions to Consider	In This Example
Are terms based on amounts or percentages?	Percentages
What are the due dates and discounts?	The due dates and discounts are as follows: First installment: 40 percent due in 10 days, with a discount of 5 percent if paid in 7 days Second installment: 35 percent due in 20 days, with a discount of 3 percent if paid in 15 days Third installment: 25 percent due in 30 days, with a discount of 2 percent if paid in 25 days

Creating Payment Terms Based on Days

1. Navigate to the Manage Payment Terms page.

2. Click Create to open the Create Payment Terms page.

3. In the Name field, enter the payment term name.

4. Click Add Row in the Installments section to create the first installment.

5. Complete the fields, as shown in this table.

   Field	Value
   Due Percent	40
   Days	10
   First Discount Percent	5
   First Discount Days	7

6. Click Add Row in the Installments section to create the second installment.

7. Complete the fields, as shown in this table.

   Field	Value
   Due Percent	35
   Days	20
   First Discount Percent	3
   First Discount Days	15

8. Click Add Row in the Installments section to create the third installment.

9. Complete the fields, as shown in this table.

   Field	Value
   Due Percent	25
   Days	30
   First Discount Percent	2
   First Discount Days	25

10. Click Save.

Invoice Tolerances

Invoice tolerances determine whether matching holds are placed on invoices for variances between invoices and the documents you match them to, such as purchase orders. When you run the invoice validation process for a matched invoice, the process checks that matching occurs within the defined tolerances. For example, if the billed amount of an item exceeds a tolerance, a hold is placed on the invoice. You can't pay the invoice until the hold is released.

You can define tolerances based on quantity or amount. For each type of tolerance, you can specify percentages or amounts. Once you define the tolerances, assign them to a supplier site.

Note: If you specify a percentage tolerance of zero, variance isn't allowed. If you want a low tolerance, specify a small percentage. If an active tolerance doesn't have a value, then infinite variance is allowed.

Quantity-Based Tolerances

Quantity-based tolerances apply to invoices with a match basis of Quantity.

This table describes each quantity-based tolerance.

Tolerance	Description
Ordered Percentage	The percentage difference more than the ordered quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the ordered quantity without considering price.
Maximum Ordered	The quantity difference more than the ordered quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the ordered quantity without considering price. You can use this tolerance if most of your purchase orders have the same relative value.
Received Percentage	The percentage difference more than the received quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the received quantity without considering price.
Maximum Received	The quantity difference more than the received quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the received quantity without considering price. You can use this tolerance if most of your purchase orders have the same relative value.
Price Percentage	The percentage difference more than the unit price on a purchase order schedule line that you allow suppliers to invoice.
Conversion Rate Amount	The variance that you allow between an invoice amount and the amount of a purchase order schedule. Validation compares the ledger currency amounts, using the invoice and purchase order conversion rates, respectively. You can use this tolerance if you create foreign currency invoices.
Schedule Amount	The variance that you allow between all invoice amounts in the entered currency and the purchase order schedule amount.
Total Amount	The total variance that you allow for both the Conversion Rate Amount and Schedule Amount tolerances combined. You can use this tolerance if you create foreign currency invoices.
Consumed Percentage	The percentage difference more than the consumed quantity on a consumption advice that you allow suppliers to invoice. Validation checks the billed quantity against the consumed quantity without considering price.
Maximum Consumed	The quantity difference more than the consumed quantity on a consumption advice that you allow suppliers to invoice. Validation checks the billed quantity against the consumed quantity without considering price.

Amount-Based Tolerances

Amount-based tolerances apply to invoices that have a match basis of Amount.

This table describes each amount-based tolerance.

Tolerance	Description
Ordered Percentage	The percentage difference more than the ordered amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the ordered amount.
Maximum Ordered	The amount difference more than the ordered amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the ordered amount.
Received Percentage	The percentage difference more than the received amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the received amount.
Maximum Received	The amount difference more than the received amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the received amount.
Conversion Rate Amount	The variance that you allow between the invoice amount and the amount on a purchase order schedule. Validation compares the ledger currency amounts, using the invoice and purchase order conversion rates, respectively. You can use this tolerance if you create foreign currency invoices.
Total Amount	The total variance that you allow for both the Conversion Rate Amount and Schedule Amount tolerances combined. You can use this tolerance if you create foreign currency invoices.

Invoice Holds and Releases

Use the Manage Invoice Holds and Releases page to define holds and releases for invoices. You can assign the holds that you define to invoices, and the invoices can't be paid until you release the holds.

Note: The invoice validation process uses the predefined holds and releases, which you can query on the Manage Invoice Holds and Releases page.

For each hold that you define, you can indicate whether accounting entries can be created. For example, if you assign a hold that doesn't allow accounting to an invoice, you must remove the hold before accounting entries can be created. You can also indicate whether to use the holds and releases in the holds resolution workflow process. The holds resolution workflow routes invoices with manually-releasable holds.

When you define a hold or release, you must associate it with a hold or release type.

Hold Types

This table lists the predefined invoice hold types and indicates whether you can define holds for them.

Hold Type	Allows User-Defined Holds?
Account Hold Reason	No
Future Period Hold Type	No
Insufficient Information	No
Invoice Hold Reason	Yes
Invoice Line Reason	Yes
Matching Hold Reason	No
Variance Hold Reason	No

Release Types

This table lists the predefined invoice release types and indicates whether you can define releases for them.

Release Type	Allows User-Defined Releases?
Account Release Reason	No
Future Period Release	No
Hold Quick Release Reason	Yes
Invoice Quick Release Reason	Yes
Invoice Release Reason	Yes
Matching Release Reason	Yes
Sufficient Information	No
Variance Release Reason	Yes

Considerations for Payables Calendar Period Frequencies

When you create a calendar using the Manage Payables Calendars task, you must select a period frequency. Period frequencies determine the number of periods per year and the period name format for the calendar.

Period Frequency

The following table describes each period frequency.

Frequency	Periods Per Year	Description
4-4-5	12	All periods have four weeks except the third, sixth, ninth, and twelfth periods, which have five weeks.
4-5-4	12	All periods have four weeks except the second, fifth, eighth, and eleventh periods, which have five weeks.
5-4-4	12	All periods have four weeks except the first, fourth, seventh and tenth periods, which have five weeks.
Monthly	12	Each month is a period.
Quarterly	4	Each period has three months.
Weekly	52	Each period has seven days.
Other	Specified by user	Periods are manually defined.

How Periods for Payables Calendars Are Generated

You can define a Payables calendar to generate periods automatically.

Settings That Affect Period Generation

When you create a calendar or add years to an existing calendar, the following attributes control how the periods are generated:

• Period frequency

• Periods per year

• Start date

• Period name format

How Periods Are Generated

This table describes the attributes that are used to generate periods.

Calendar Attribute	Description
Period frequency	Type of period, such as Monthly or 5-4-4. Note: If you select Other, you must enter periods manually
Periods per year	Calculated number of periods per year.
Start date	First day of the calendar and start date of the first period.
Period name format	Naming convention for periods.

Note: For weekly or quarterly period frequencies, the generated period name is the frequency combined with the number of periods per year, plus the year. For example, for a period frequency of Quarterly and a start date of 1/1/2015, the period name for the first quarter is Quarter1-15.

Example Calendar with a Period Frequency of 4-4-5

This example shows the generated periods for a calendar with a:

• Period frequency of 4-4-5

• Start date of 1/1/2015

• Period name format of MMM

Period Name Prefix	Year	Sequence	Start Date	End Date	Period Name
Jan	2015	1	1/1/15	1/28/15	Jan-15
Feb	2015	2	1/29/15	2/25/15	Feb-15
Mar	2015	3	2/26/15	4/1/15	Mar-15
Apr	2015	4	4/2/15	4/29/15	Apr-15
May	2015	5	4/30/15	5/27/15	May-15
Jun	2015	6	5/28/15	7/1/15	Jun-15
Jul	2015	7	7/2/15	7/29/15	Jul-15
Aug	2015	8	7/30/15	8/26/15	Aug-15
Sep	2015	9	8/27/15	9/30/15	Sep-15
Oct	2015	10	10/1/15	10/28/15	Oct-15
Nov	2015	11	10/29/15	11/25/15	Nov-15
Dec	2015	12	11/26/15	12/30/15	Dec-15

How You Set Up Third-Party Payments

A third-party payment is a payment that you make to a supplier on behalf of another supplier. Setting up third-party payments includes the following tasks:

Creating the Third Party

1. In the Suppliers work area, click Create Supplier.

2. Complete the information on the Profile and Address tabs.

   • Set the Address Purpose field to Remit to.

   • (Optional) Associate a bank account and default payment method with the address.

Note: You don't have to create a supplier site unless the third party is a supplier that sends you invoices.

Defining the Relationship Between the Third Party and the Supplier

1. In the Suppliers work area, click Manage Suppliers.

2. Search for the supplier on whose behalf the third party receives payment.

3. Add the third party to the Third-Party Payment Relationship section on the Invoicing tab on the Edit Site page. Consider marking the relationship as the default relationship for new invoices and payments.

   This table describes each attribute of a third-party payment relationship.

   Attribute	Description
   Remit-to Supplier	Enter the party designated to receive payment on behalf of the supplier on the invoice.
   Address Name	Enter the address of the party designated to receive payment on behalf of the supplier on the invoice.
   From Date, To Date	Specify an inclusive date range for the relationship. When you create an invoice or payment, the invoice and payment dates are used to identify valid third-party payment relationships for the supplier site. Note: When you end date an existing relationship, you must review all unpaid or partially paid invoices for that relationship.
   Description	Enter text to include in the payment file. For example, you can enter text to print on the payment document as reference information.

Note: The Merge Supplier process doesn't merge third-party payment relationships.

(Optional) Setting the Remit-to Supplier Override Option

1. In the Setup and Maintenance work area, go to the following:

2. Offering: Financials

3. Functional Area: Payables

4. Task: Manage Invoice Options, with the business unit scope set

5. Click Apply and Go to Task.

6. Select the Allow remit-to supplier override for third-party payments option to allow override of the remit-to supplier on the invoice.

(Optional) Setting the Payee Override Option

1. In the Setup and Maintenance work area, go to the following:

2. Offering: Financials

3. Functional Area: Payables

4. Task: Manage Payment Options, with the business unit scope set

5. Click Apply and Go to Task.

6. Select the Allow payee override for third-party payments option to allow override of the payee on the payment.

• Guidelines For Invoice Options

• What's a third-party payment

Auditing Payables Business Objects

You can audit specific business objects and attributes in Oracle Fusion Payables to monitor user activity and data changes. Auditing includes recording and retrieving information pertaining to the creation, modification, or removal of business objects. However, for transaction business objects the auditing will record modification, or removal of business objects. All actions the user performs on an audited business object and its attributes are recorded and logged in a table. From the table, you can run a report that indicates changes made to attributes by users. Changes made by any user to the audit-enabled attributes are recorded and retrievable.

To enable auditing on Payables business objects, navigate to: Setup and Maintenance > Search Tasks: Manage Audit Policies > Manage Audit Policies page > Configure Business Object Attributes button > Configure Business Object Attributes page > Product choice list: Payables.

Payables Setup Business Objects

AP_SYSTEM_PARAMETERS_ALL

Object name on the Configure Business Object Attributes page: General Payables Options

The AP_SYSTEM_PARAMETERS_ALL table stores the parameters and defaults you define for operating your Oracle Fusion Payables application. This table contains information such as your set of books, functional currency and payment terms. Your Oracle Fusion Payables application also uses this information to determine default values that cascade down to supplier and invoice entry. This table corresponds to the Manage Invoice Options and Manage Payment Options tasks under Define General Payables Options task. AP_SYSTEM_PARAMETERS_ALL_ is the audit table for AP_SYSTEM_PARAMETERS_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Create interest invoices	AUTO_CALCULATE_INTEREST_FLAG	Option that indicates whether interest invoices are automatically created for past due invoice payments (Y or N).	Yes
Invoice Currency	INVOICE_CURRENCY_CODE	Default invoice currency code that defaults on the supplier sites associated with the business unit.	Yes
Always take discount	ALWAYS_TAKE_DISC_FLAG	Option that indicates if an available discount for a supplier will be taken, regardless of when the invoice is paid (Y or N).	Yes
Accounting Date Basis	GL_DATE_FROM_RECEIPT_FLAG	Date used as the accounting date during invoice entry.	No
Exclude tax from calculation	DISC_IS_INV_LESS_TAX_FLAG	Option that indicates if tax amount excluded from invoice amount when invoice amount applicable to discount calculated (Y or N).	Yes
Allow payment date before the system date	POST_DATED_PAYMENTS_FLAG	Option that indicates if the payment date can be prior to system date (Y or N).	Yes
Minimum interest amount	INTEREST_TOLERANCE_AMOUNT	Minimum interest amount owed on past due invoice for interest invoice to be automatically created.	Yes
Interest Expense Distribution	INTEREST_CODE_COMBINATION_ID	Accounting Flexfield identifier for interest expense account.	Yes
Discount Allocation Method	DISCOUNT_DISTRIBUTION_METHOD	Method for distributing discount amounts taken on invoice payments.	Yes
Use combined filing program	COMBINED_FILING_FLAG	Option that indicates whether your organization participates in the Combined Filing Program for income tax reporting.	Yes
Income Tax Region	INCOME_TAX_REGION	Default income tax region assigned to invoice lines for 1099 suppliers.	Yes
Use supplier tax region	INCOME_TAX_REGION_FLAG	A value of Y indicates that you use supplier tax region as the default Income Tax Region for 1099. invoice lines.	Yes
Allow Final Matching	ALLOW_FINAL_MATCH_FLAG	Option that indicates whether you allow final matching to purchase orders.	Yes
Allow Matching distribution override	ALLOW_FLEX_OVERRIDE_FLAG	Option that indicates whether you can override the matching Accounting Flexfield for an invoice distribution matched to a purchase order distribution line.	Yes
Allow adjustments to paid invoices	ALLOW_PAID_INVOICE_ADJUST	Option that indicates whether you allow adjustments to paid invoices.	Yes
Allow document category override	INV_DOC_CATEGORY_OVERRIDE	Option that indicates whether you can override the default document category (Sequential Numbering) for invoices.	Yes
Transfer PO distribution additional information	TRANSFER_DESC_FLEX_FLAG	A value of Y indicates the application will transfer descriptive flexfield information from a purchase order shipment to an invoice line and from the purchase order distribution to an invoice distribution during purchase order matching.	Yes
Use withholding tax	ALLOW_AWT_FLAG	Option to indicate whether Automatic Withholding Tax is allowed (Y or N).	Yes
Withholding Tax Group	DEFAULT_AWT_GROUP_ID	Default Withholding Tax group for new suppliers.	Yes
Allow manual withholding	ALLOW_AWT_OVERRIDE	Option to indicate whether override of withholding tax amount is allowed (Y, N, null).	Yes
Apply withholding tax	CREATE_AWT_DISTS_TYPE	Indicates when the application should automatically create withholding tax invoices. Possible values are Never, Validation, or Payment.	Yes
Create Withholding Invoice	CREATE_AWT_INVOICES_TYPE	Indicates when the application should automatically create withholding tax invoices (Never, Invoice Validation, Payment).	Yes
Withholding Amount Basis to include discount amount	AWT_INCLUDE_DISCOUNT_AMT	Option to indicate whether the discount amount is included in withholding tax calculation.	Yes
Withholding Amount Basis to include tax amount	AWT_INCLUDE_TAX_AMT	Option to indicate whether the tax amount is included in the withholding tax calculation.	Yes
Allow override of supplier site bank account	ALLOW_SUPPLIER_BANK_OVERRIDE	Option to indicate whether user can charge remit-to bank at payment creation time.	Yes
Account for Payment	WHEN_TO_ACCOUNT_PMT	Defines when accounting entries for payments will be created.	Yes
Enable invoice approval	APPROVAL_WORKFLOW_FLAG	Select this check box value to enable invoice approval.	Yes
Allow Force Approval	ALLOW_FORCE_APPROVAL_FLAG	Select this check box value if you use the Invoice Approval Workflow Program and want to allow accounts payable processors to override the workflow and manually approve invoices.	Yes
Include withholding distributions in income tax reports	ENABLE_1099_ON_AWT_FLAG	Select this check box value is you want to include Withholding Distribution in Income Tax Reports.	Yes
Quantity Tolerances	TOLERANCE_ID	A unique identifier for tolerance template that's used for goods tolerance.	Yes
Amount Tolerances	SERVICES_TOLERANCE_ID	Services tolerance template identifier.	Yes
Receipt Acceptance Days	RECEIPT_ACCEPTANCE_DAYS	Number of days in receipt acceptance period.	Yes
Exclude Freight from Discount	EXCLUDE_FREIGHT_FROM_DISCOUNT	Exclude Freight From Discount Identifier.	Yes
Interest Allocation Method	PRORATE_INT_INV_ACROSS_DISTS	Used to display the 'Interest' Allocation method in Accounting Option label.	Yes
Allow Unit Price change for Quantity-Based Matches	SS_UPRICE_CHANGE_FOR_QTYMATCH	Setting that indicates whether unit price change is allowed for purchase order matched self-service invoice.	Yes
Allow invoice backdating	SS_INVOICE_BACKDATING_FLAG	Indicates whether a self-service invoice can have invoice date prior to system date.	Yes
Self Service Invoices to limit invoices to a single purchase order	SS_LIMIT_TO_SINGLE_PO_FLAG	Indicates whether a self-service invoice can be matched to multiple purchase orders.	Yes
Require Invoice Grouping	REQUIRE_INVOICE_GROUP_FLAG	Setting that indicates whether invoice group is mandatory during invoice entry.	Yes
Recalculate invoice installments	RECALC_PAY_SCHEDULE_FLAG	Option that indicates whether Recalculate Payment Installments (Y or N).	Yes
Budget Date Basis	BUDGET_DATE_BASIS	Budget Date Basis to default the budget date on invoice transactions.	Yes

FINANCIALS_SYSTEM_PARAMS_ALL

Object name on the Configure Business Object Attributes page: Common Options for Payables and Procurement

The FINANCIALS_SYSTEM_PARAMETERS_ALL table stores options and defaults you share between your Oracle Fusion Payables application, and your Oracle Fusion Purchasing and Oracle Fusion Assets applications. You can define these options and defaults according to the way you run your business. This table corresponds to the Manage Common Options for Payables and Procurement task. FINANCIALS_SYSTEM_PARAMS_ALL_ is the audit table for FINANCIALS_SYSTEM_PARAMS_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Bill-to Location	BILL_TO_LOCATION_ID	Bill-to location identifier, default used during supplier entry.	Yes
Liability Distribution	ACCTS_PAY_CODE_COMBINATION_ID	Accounting Flexfield identifier for the accounts payable liability account and default used during supplier entry.	Yes
Prepayment Distribution	PREPAY_CODE_COMBINATION_ID	Accounting Flexfield identifier for the prepayment account and default used during supplier entry.	Yes
Discount Taken Distribution	DISC_TAKEN_CODE_COMBINATION_ID	Accounting Flexfield identifier for the discount taken account.	Yes
VAT Registration Number	VAT_REGISTRATION_NUM	Value-Added Tax registration number for your organization.	Yes
VAT Registration Member State	VAT_COUNTRY_CODE	European Union (EU) member state for your organization.	Yes
Conversion Rate Variance Gain	RATE_VAR_GAIN_CCID	Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders.	Yes
Conversion Rate Variance Loss	RATE_VAR_LOSS_CCID	Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase orders.	Yes
Bill Payable Distribution	FUTURE_DATED_PAYMENT_CCID	Accounting Flexfield identifier for future dated payment account default for Suppliers and Bank accounts.	Yes
Miscellaneous Distribution	MISC_CHARGE_CCID	Accounting flexfield identifier for the accounts payable miscellaneous account, which is used for supplier portal Invoices.	Yes
Buying Company Identifier	BUYING_COMPANY_IDENTIFIER	A unique identifier that identifies the buying business unit. The identifier is included on the invoice number of invoices created by the pay on receipt process or debit memos from return on receipt transactions.	Yes
Expense Accrual Distributions	EXPENSE_ACCRUAL_CCID	Expense Accrual Account Code Combination Identifier.	Yes
Gapless Invoice Numbering	GAPLESS_INV_NUM_FLAG	Gapless Invoice Numbering Option.	Yes
Accrue Expense Items	EXPENSE_ACCRUAL_CODE	Defines accrue expense items options.	Yes
Conversion Rate type	DEFAULT_EXCHANGE_RATE_TYPE	Specifies the default conversion rate type when you enter invoices or create payments.	Yes
Automatic Offsets	AUTOMATIC_OFFSETS_FLAG	An option that allows overriding of either the primary balancing segment or all segments, except the natural account segment when creating the liability account.	Yes
Realized Gain Distribution	GAIN_CODE_COMBINATION_ID	Accounting Flexfield identifier for account to which realized exchange rate gains are posted.	Yes
Realized Loss Distribution	LOSS_CODE_COMBINATION_ID	Accounting Flexfield identifier for account to which realized exchange rate losses are posted.	Yes
Require conversion rate entry	MAKE_RATE_MANDATORY_FLAG	Option that indicates if exchange rates must be entered for multiple currency invoices and payments (Y or N).	Yes
Freight Distribution	FREIGHT_CODE_COMBINATION_ID	Accounting Flexfield identifier for accounts payable freight account.	Yes
Prepayment Tax Difference	PREPAY_TAX_DIFF_CCID	Account to which any prepayment tax difference amount will be charged.	Yes
Require Conversion Rate Entry	MAKE_RATE_MANDATORY_PMT_FLAG	Require Conversion Rate Information for Payments.	No
Payment Conversion Rate Type	DEFAULT_PMT_EXCHANGE_RATE_TYPE	Payment Conversion Rate Type.	No

AP_TOLERANCE_TEMPLATES

Object name on the Configure Business Object Attributes page: Invoice Tolerances

The AP_TOLERANCE_TEMPLATES table stores the tolerance levels you set for matching and invoice variance testing. Oracle Fusion Payables uses this information to determine during Invoice Validation to hold an invoice for exceeding tolerance. AP_TOLERANCE_TEMPLATES_ is the audit table for AP_TOLERANCE_TEMPLATES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	TOLERANCE_NAME	Name of the tolerance template.	Yes
Description	DESCRIPTION	Description of the tolerance template.	No
Price Percentage	PRICE_TOLERANCE	Percentage based tolerance level for price variance.	Yes
Ordered Percentage	QUANTITY_TOLERANCE	Percentage based tolerance level for quantity variance.	Yes
Received Percentage	QTY_RECEIVED_TOLERANCE	Percentage based tolerance level for quantity received tolerance.	Yes
Maximum Ordered	MAX_QTY_ORD_TOLERANCE	Tolerance level for maximum quantity ordered variance.	Yes
Maximum Received	MAX_QTY_REC_TOLERANCE	Tolerance level for maximum quantity received variance.	Yes
Schedule Amount	SHIP_AMT_TOLERANCE	Tolerance level for purchase order shipment amount variance	Yes
Conversion Rate Amount	RATE_AMT_TOLERANCE	Tolerance level for exchange rate amount variance.	Yes
Total Amount	TOTAL_AMT_TOLERANCE	Tolerance level for total amount variance.	Yes
Type	TOLERANCE_TYPE	Designates the type of tolerance template as either Goods or Services.	Yes
Consumed Percentage	QTY_CONSUMED_TOLERANCE	Tolerance level for comparison of billed quantity with consumed quantity expressed as a percentage.	Yes
Maximum Consumed	MAX_QTY_CON_TOLERANCE	Tolerance level for comparison of billed quantity with consumed quantity expressed as an absolute value.	Yes

AP_REPORTING_ENTITIES_ALL

Object name on the Configure Business Object Attributes page: Reporting Entities

The AP_REPORTING_ENTITIES_ALL table stores the information about the reporting entities you define for 1099 reporting. This table corresponds to the Manage Reporting Entities task. AP_REPORTING_ENTITIES_ALL_ is the audit table for AP_REPORTING_ENTITIES_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Taxpayer ID	TAX_IDENTIFICATION_NUM	Tax identification number for reporting entity.	Yes
Name	ENTITY_NAME	Name of the reporting entity for tax reporting.	Yes
Location	LOCATION_ID	Location identifier for reporting entity.	Yes
Business Unit	ORG_ID	Indicates the identifier of the business unit associated to the row.	Yes
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No

AP_REPORTING_ENTITY_LINES_ALL

Object name on the Configure Business Object Attributes page: Balancing Segment Values

The AP_REPORTING_ENTITY_LINES_ALL table stores the line information for the tax reporting entities you define. This table corresponds to the Balancing Segment Values section of the Manage Reporting Entities task. AP_REPORTING_ENTITY_LINES_ALL_ is the audit table for AP_REPORTING_ENTITY_LINES_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Primary Balancing Segment Value	BALANCING_SEGMENT_VALUE	Balancing segment value for reporting entity Accounting Flexfield.	Yes
Business Unit	ORG_ID	Indicates the identifier of the business unit associated to the row.	Yes

AP_BANK_CHARGES

Object name on the Configure Business Object Attributes page: Bank Charges

The AP_BANK_CHARGES table stores header information that you enter on the bank charges page. This table corresponds to the Manage Bank Charges task. AP_BANK_CHARGES_ is the audit table for AP_BANK_CHARGES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Transferring Bank Branch ID	TRANSFERRING_BANK_BRANCH_ID	Transferring bank branch identifier.	Yes
Transferring Bank Name	TRANSFERRING_BANK_NAME	Bank of customer, which transfers payment to supplier bank.	Yes
Transferring Bank Option	TRANSFERRING_BANK	Transferring bank. Valid values are ONE for specific bank and ALL when bank charge is applicable to all transferring banks.	Yes
Transferring Branch Option	TRANSFERRING_BRANCH	Transferring branch. Valid values are ONE for specific branch and ALL when bank charge is applicable to all transferring branches of transferring bank specified.	Yes
Receiving Bank Branch ID	RECEIVING_BANK_BRANCH_ID	Receiving bank branch identifier.	Yes
Receiving Bank Name	RECEIVING_BANK_NAME	Bank of supplier, which receives payment from customer bank.	Yes
Receiving Bank Option	RECEIVING_BANK	Receiving branch. Valid values are ONE for specific bank, ALL for when charge is applicable to all receiving banks, and OTHER for bank other than the transferring bank.	Yes
Receiving Branch Option	RECEIVING_BRANCH	Receiving branch. Valid values are ONE for specific branch, ALL for when charge is applicable to all receiving branches, and OTHER for branch other than the transferring branch.	Yes
Settlement Priority	SETTLEMENT_PRIORITY	Settlement priority. Valid values are EXPRESS and NORMAL.	Yes
Currency	CURRENCY_CODE	Currency used to define bank charges.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 1	ATTRIBUTE_NUMBER1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 2	ATTRIBUTE_NUMBER2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 3	ATTRIBUTE_NUMBER3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 4	ATTRIBUTE_NUMBER4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 5	ATTRIBUTE_NUMBER5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 1	ATTRIBUTE_DATE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 2	ATTRIBUTE_DATE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 3	ATTRIBUTE_DATE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 4	ATTRIBUTE_DATE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 5	ATTRIBUTE_DATE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Legal Entity	LEGAL_ENTITY_ID	Legal entity identifier.	Yes

AP_BANK_CHARGE_LINES

Object name on the Configure Business Object Attributes page: Bank Charges Details

The AP_BANK_CHARGE_LINES table stores ranges for bank charges. This table corresponds to the Bank Charge Details section of the Manage Bank Charges task. AP_BANK_CHARGE_LINES_ is the audit table for AP_BANK_CHARGE_LINES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
From Payment Amount	TRANS_AMOUNT_FROM	The end payment amount (lower amount) for given amount range.	Yes
To Payment Amount	TRANS_AMOUNT_TO	The start payment amount (higher amount) for given amount range.	Yes
Standard Bank Charge Amount	BANK_CHARGE_STANDARD	The bank charge amount at standard rate.	Yes
Negotiated Bank Charge Amount	BANK_CHARGE_NEGOTIATED	The bank charge amount at negotiated rate.	Yes
From Date	START_DATE	The start date to apply the bank charge at the specified amount.	Yes
To Date	END_DATE	The end date to apply the bank charge at the specified amount.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 1	ATTRIBUTE_NUMBER1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 2	ATTRIBUTE_NUMBER2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 3	ATTRIBUTE_NUMBER3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 4	ATTRIBUTE_NUMBER4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Number 5	ATTRIBUTE_NUMBER5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 1	ATTRIBUTE_DATE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 2	ATTRIBUTE_DATE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 3	ATTRIBUTE_DATE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 4	ATTRIBUTE_DATE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute Date 5	ATTRIBUTE_DATE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No

AP_INTEREST_PERIODS

Object name on the Configure Business Object Attributes page: Interest Rates

The AP_INTEREST_PERIODS table stores information about interest rates and periods that Payables uses to create invoices to pay interest owed on overdue invoices. This interest is calculated in accordance with the U.S. Prompt Payment Act. This table corresponds to the Manage Interest Rates task. AP_INTEREST_PERIODS is the audit table for AP_INTEREST_PERIODS. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Rate	ANNUAL_INTEREST_RATE	Interest rate applicable for a given period.	Yes
From Date	START_DATE	Start date of a given interest period.	Yes
To Date	END_DATE	End date of a given interest period.	Yes

AP_TERMS_B

Object name on the Configure Business Object Attributes page: Payment Terms

The AP_TERMS_B table stores header information about payment terms you define. You need one row for each type of terms you use to create scheduled payments for invoices. When you enter suppliers or invoices, you can select payment terms you have defined in this table. Each terms must have one or more terms lines. This table corresponds to the Manage Payment Terms task. AP_TERMS_B_ is the audit table for AP_TERMS_B. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	TERM_ID	A unique identifier for the payment term.	Yes
From Date	START_DATE_ACTIVE	Date from which payment term is valid.	Yes
To Date	END_DATE_ACTIVE	Date after which payment term is invalid.	Yes
Cutoff Day	DUE_CUTOFF_DAY	Used for certain terms only, day of a month after which Oracle Fusion Payables schedules payment using a day after the current month.	Yes
Rank	RANK	Unique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No

AP_TERMS_LINES

Object name on the Configure Business Object Attributes page: Installments

The AP_TERMS_LINES table stores detail information about payment terms you define. This table corresponds to the Installments and Discount sections of the Manage Payment Terms task. AP_TERMS_LINES_ is the audit table for AP_TERMS_LINES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	TERM_ID	A unique identifier for the payment term.	Yes
Sequence Number	SEQUENCE_NUM	Number of the payment term line.	Yes
Due Percentage	DUE_PERCENT	Percentage of payment due by a certain date.	Yes
Amount Due	DUE_AMOUNT	Maximum of payment amount due by a certain date.	Yes
Days	DUE_DAYS	Number of days after terms date, used to calculate due date of invoice payment line.	Yes
Day of Month	DUE_DAY_OF_MONTH	Day of month used to calculate due date of invoice payment line.	Yes
Months Ahead	DUE_MONTHS_FORWARD	Number of months ahead, used to calculate due date of invoice payment line.	Yes
First Discount Percentage	DISCOUNT_PERCENT	Percentage used to calculate discount available for invoice payment line.	Yes
First Discount Days	DISCOUNT_DAYS	Number of days after terms date, used to calculate discount date for invoice payment line.	Yes
First Discount Day of Month	DISCOUNT_DAY_OF_MONTH	Day of month used to calculate discount date for invoice payment line.	Yes
First Discount Months Ahead	DISCOUNT_MONTHS_FORWARD	Number of months ahead used to calculate discount date for invoice payment line.	Yes
Second Discount Percentage	DISCOUNT_PERCENT_2	Percentage used to calculate second discount available for invoice payment line.	Yes
Second Discount Days	DISCOUNT_DAYS_2	Number of days after terms date, used to calculate second discount available for invoice payment line	Yes
Second Discount Day of Month	DISCOUNT_DAY_OF_MONTH_2	Day of month used to calculate second discount available for invoice payment line.	Yes
Second Discount Months Ahead	DISCOUNT_MONTHS_FORWARD_2	Number of months ahead, used to calculate discount available for invoice payment line.	Yes
Third Discount Percentage	DISCOUNT_PERCENT_3	Percentage used to calculate third discount available for invoice payment line.	Yes
Third Discount Days	DISCOUNT_DAYS_3	Number of days after terms date, used to calculate third discount for invoice payment line.	Yes
Third Discount Day of Month	DISCOUNT_DAY_OF_MONTH_3	Day of month used to calculate third discount for invoice payment line.	Yes
Third Discount Months Ahead	DISCOUNT_MONTHS_FORWARD_3	Number of months ahead, used to calculate third discount for invoice payment line.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Fixed Date	FIXED_DATE	Payment term attribute that indicates the payment due date.	Yes
Calendar	CALENDAR	Name of special calendar associated with the term line.	Yes

AP_TERMS_ST

Object name on the Configure Business Object Attributes page: Set Assignments

The AP_TERMS_ST table stores Set ID information for the payment terms you define. This table corresponds to the Set Assignments section of the Manage Payment Terms task. AP_TERMS_ST_ is the audit table for AP_TERMS_ST. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	TERM_ID	Payment term unique identifier.	Yes
Set Code	SET_ID	Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they're used to filter reference data in transactional UIs.	Yes

AP_HOLD_CODES

Object name on the Configure Business Object Attributes page: Invoice Holds and Releases

The AP_HOLD_CODES table stores information about hold codes and release codes that you or your Oracle Fusion Payables application can place on an invoice. This table corresponds to the Manage Invoice Holds and Releases task. AP_HOLD_CODES_ is the audit table for AP_HOLD_CODES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	HOLD_LOOKUP_CODE	Name of the hold code created to be applied on an invoice.	Yes
Type	HOLD_TYPE	Hold type that's to be applied on an invoice.	Yes
Allow Manual Release	USER_RELEASEABLE_FLAG	Indicates if a hold can be released by a user (Y or N).	Yes
Inactive Date	INACTIVE_DATE	Date when the hold will be inactive.	Yes
Allow Accounting	POSTABLE_FLAG	Indicates whether this hold should prevent the invoice from being accounted.	Yes
Hold Instruction	HOLD_INSTRUCTION	Instruction to resolve the hold.	Yes
Days Before Notifying	WAIT_BEFORE_NOTIFY_DAYS	Specify the number of days to wait before sending the notification.	Yes
Days Before Reminding	REMINDER_DAYS	Specify the number of days to wait before sending the reminder notification.	Yes
Allow Holds Resolution Routing	INITIATE_WORKFLOW_FLAG	Enable this to initiate the Hold Negotiation Workflow for the hold.	Yes

AP_DISTRIBUTION_SETS_ALL

Object name on the Configure Business Object Attributes page: Distribution Sets

The AP_DISTRIBUTION_SETS_ALL table stores information about Distribution Sets you define to distribute invoices automatically. AP_DISTRIBUTION_SETS_ALL_ is the audit table for AP_DISTRIBUTION_SETS_ALL. This table corresponds to the Manage Distribution Sets task. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	DISTRIBUTION_SET_NAME	Name of invoice distribution set created.	Yes
Description	DESCRIPTION	Description of invoice distribution set created.	Yes
Distribution Percentage	TOTAL_PERCENT_DISTRIBUTION	Sum of the distribution percents for each of the distribution set lines.	Yes
Inactive Date	INACTIVE_DATE	Date by when the distribution set will become inactive.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Business Unit	ORG_ID	Indicates the identifier of the business unit associated to the row.	Yes

AP_DISTRIBUTION_SET_LINES_ALL

Object name on the Configure Business Object Attributes page: Distribution Set Details

The AP_DISTRIBUTION_SET_LINES_ALL table stores detailed information about individual distribution lines you define for a Distribution Set. This table corresponds to the Distribution Set Details section of the Manage Distribution Sets task. AP_DISTRIBUTION_SET_LINES_ALL_ is the audit table for AP_DISTRIBUTION_SET_LINES_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Distribution Combination	DIST_CODE_COMBINATION_ID	Accounting Flexfield identifier for account associated with Distribution Set line.	Yes
Distribution	PERCENT_DISTRIBUTION	Percent of invoice amount to allocate to Distribution Set line.	Yes
Income Tax Type	TYPE_1099	Type of 1099 tax associated with distribution line.	Yes
Description	DESCRIPTION	Description of distribution set line.	No
Line	DISTRIBUTION_SET_LINE_NUMBER	Invoice Distribution Set line identifier.	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Project Accounting Context	PROJECT_ACCOUNTING_CONTEXT	Oracle Fusion Projects Descriptive Flexfield context column.	No
Task Number	TASK_ID	Identifier for project task used to build Accounting Flexfield for Distribution Set line.	No
Project Number	PROJECT_ID	Identifier for project used to build Accounting Flexfield for Distribution Set line.	No
Expenditure Organization	EXPENDITURE_ORGANIZATION_ID	Identifier for project organization used to build Accounting Flexfield for Distribution Set line	No
Expenditure Type	EXPENDITURE_TYPE	Project expenditure type used to build Accounting Flexfield for Distribution Set line.	No
Business Unit	ORG_ID	Indicates the identifier of the business unit associated to the row.	Yes
Award Number	AWARD_ID	If Oracle Fusion Grants Accounting is installed, the award ID is used with data in project columns to track grant information.	No

AP_AGING_PERIODS

Object name on the Configure Business Object Attributes page: Aging Periods

The AP_AGING_PERIODS table stores aging periods that you define for use in the Invoice Aging Report. This table corresponds to the Manage Aging Periods task. AP_AGING_PERIODS_ is the audit table for AP_AGING_PERIODS. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Aging Period ID	AGING_PERIOD_ID	Unique identifier of aging period defined in application.	Yes
Name	PERIOD_NAME	Name of aging period defined in system.	Yes
Description	DESCRIPTION	Description of aging period defined.	No
Active	STATUS	Status of aging period.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No

AP_AGING_PERIOD_LINES

Object name on the Configure Business Object Attributes page: Aging Period Details

The AP_AGING_PERIOD_LINES table stores information on individual aging periods. This table corresponds to the Aging Period Details section of the Manage Aging Periods task. AP_AGING_PERIOD_LINES_ is the audit table for AP_AGING_PERIOD_LINES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Aging Period Line ID	AGING_PERIOD_LINE_ID	Unique identifier of aging period line defined as part of aging period setup.	Yes
Column Order	PERIOD_SEQUENCE_NUM	Order of this particular date range within the entire period.	Yes
From	DAYS_START	Starting day number for aging period line.	Yes
To	DAYS_TO	Ending day number for aging period line.	Yes
First	REPORT_HEADING1	First column heading for aging period line.	Yes
Second	REPORT_HEADING2	Second column heading for aging period line.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No

AP_INCOME_TAX_REGIONS

Object name on the Configure Business Object Attributes page: Tax Regions

The AP_INCOME_TAX_REGIONS table stores information about the tax regions you use to record payment information for 1099 suppliers when your organization participates in the Combined Filing Program. This table corresponds to the Manage Tax Regions task. AP_INCOME_TAX_REGIONS_ is the audit table for AP_INCOME_TAX_REGIONS. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
State	REGION_SHORT_NAME	Abbreviated income tax region name (identifies income tax region for 1099 supplier sites).	Yes
Description	REGION_LONG_NAME	Full name of income tax region applicable for 1099 taxes.	Yes
Code	REGION_CODE	Region code for income tax regions participating in the Combined Filing Program.	Yes
Amount	REPORTING_LIMIT	Minimum reporting amount for income tax region participating in the Combined Filing Program.	Yes
From Date	ACTIVE_DATE	Date from when the income tax region is active.	Yes
To Date	INACTIVE_DATE	Date income tax region inactive.	Yes
Method	REPORTING_LIMIT_METHOD_CODE	Method for calculating reporting limit for region.	Yes

AP_OTHER_PERIOD_TYPES

Object name on the Configure Business Object Attributes page: Payables Calendars

The AP_OTHER_PERIOD_TYPES table stores the period type you define and use to create recurring invoice, automatic withholding tax, key indicators and payment terms periods. This table corresponds to the Manage Payables Calendars task. AP_OTHER_PERIOD_TYPES_ is the audit table for AP_OTHER_PERIOD_TYPES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Name	CALENDAR_NAME	Name given to a calendar that's used in Oracle Fusion Payables.	Yes
To Date	EFFECTIVE_TO	Effective To date of the calendar.	Yes
From Date	EFFECTIVE_FROM	Effective From date of the calendar.	Yes
Calendar Type	CALENDAR_TYPE	Type of the calendar, either GENERAL or PAYMENT TERMS.	Yes
Description	DESCRIPTION	Statement, picture in words, or account that describes; descriptive representation.	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No

AP_OTHER_PERIODS

Object name on the Configure Business Object Attributes page: Period Information

The AP_OTHER_PERIODS table stores information about the time periods you define for use in recurring invoices, withholding taxes, key indicators and payment terms. This table corresponds to the Period Information section of the Manage Payables Calendars task. AP_OTHER_PERIODS_ is the audit table for AP_OTHER_PERIODS. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Start Date	START_DATE	Date from when a record isn't available for transacting. Use date enabled entities when history isn't stored.	Yes
End Date	END_DATE	Date from when a record isn't available for transacting. Use date enabled entities when history isn't stored.	Yes
Sequence	PERIOD_NUM	Order of periods within a payables calendar.	Yes
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Due Date	DUE_DATE	Date associated with a payables calendar period that indicates when an invoice payment is due. This is only applicable to payables calendars with a type of payment terms.	Yes
Calendar Name	PERIOD_ID	Identifier of the created period.	Yes

Payables Transaction Business Objects

Auditing takes into account update and delete operations performed by the user on an object and its attributes. It won't record the data that's not updated by the user. For example, data updated by a schedule process.

AP_INVOICES_INTERFACE

Object name on the Configure Business Object Attributes page: Correct Import Errors Invoice Headers

AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import. Invoice data comes from sources including: supplier invoices that you transfer through the Oracle XML Gateway, and invoices that you enter through the Invoice Gateway. There's one row for each invoice you import. Your Oracle Payables application uses this information to create invoice header information when you submit the Payables Open Interface program. AP_INVOICES_INTERFACE_ is the audit table for AP_INVOICES_INTERFACE. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Liability Distribution ID	ACCTS_PAY_CODE_COMBINATION_ID	Accounting Flexfield identifier for accounts payable liability account. If the identifier isn't available, use the ACCTS_PAY_CODE_CONCATENATED column. Validated against.GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.	No
Add Tax to Invoice Amount	ADD_TAX_TO_INV_AMT_FLAG	Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y, N, NULL.	No
Discountable Amount	AMOUNT_APPLICABLE_TO_DISCOUNT	Amount of invoice applicable to a discount. Not validated.	No
Application ID	APPLICATION_ID	Oracle internal use only. For Oracle Fusion applications interfacing to Oracle Fusion Payables.	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Withholding Tax Group ID	AWT_GROUP_ID	Withholding tax group identifier. If the identifier isn't available, use the AWT_GROUP_NAME column. Validated against AP_AWT_GROUPS.AWT_GROUP_ID.	No
Bank Charge Bearer	BANK_CHARGE_BEARER	Bearer of bank charge cost. Uses the Manage Payables Lookup task, lookup type BANK BEARER CHARGE to identify valid values.	No
Budget Date	BUDGET_DATE	Budgetary Calendar Period Date applicable for funds check.	No
Calculate Tax During Import	CALC_TAX_DURING_IMPORT_FLAG	Indicates whether tax should be calculated for the invoice during import. Valid values: Y,N, NULL.	No
Tax Control Amount	CONTROL_AMOUNT	Total tax amount. Cannot be more than the invoice amount.	No
Correction Period	CORRECTION_PERIOD	Correction period for the invoice being corrected. Not validated.	No
Correction Year	CORRECTION_YEAR	Correction year for the invoice. Valid format: four numbers. Example: 2010.	No
Delivery Channel	DELIVERY_CHANNEL_CODE	Information displayed for an electronic payment that instruct the bank about carrying out the payment. Example: print a check and hold it for collection by the payee. Use the Manage Payment Codes task to identify valid values. The corresponding Payment Code Type must be Delivery Channel.	No
Description	DESCRIPTION	Invoice description. Free text field. Not validated.	No
Document Category	DOC_CATEGORY_CODE	Sequential numbering (voucher number) document category. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE.	No
Document Subtype	DOCUMENT_SUB_TYPE	A document type required by a tax or governmental authority.	No
Conversion Date	EXCHANGE_DATE	Date exchange rate is effective. Usually the accounting date of the transaction. Date format: YYYY/MM/DD.	No
Conversion Rate	EXCHANGE_RATE	Exchange rate used for foreign currency invoices. User entered conversion rate. Not validated.	No
Conversion Rate Type	EXCHANGE_RATE_TYPE	Exchange rate type for foreign currency invoices. Use the Manage Conversion Rate Types task to identify valid values. Validated against GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE.	No
Pay Alone	EXCLUSIVE_PAYMENT_FLAG	Indicates whether to pay invoice on a separate payment document. Valid values: Y,N, NULL.	No
Remit-to Account	EXTERNAL_BANK_ACCOUNT_ID	External bank account identifier. Defaulted from supplier setup. Do not populate during interface.	No
First-Party Tax Registration ID	FIRST_PARTY_REGISTRATION_ID	First party tax registration identifier.	No
First-Party Tax Registration Number	FIRST_PARTY_REGISTRATION_NUM	First party tax registration number.	No
Accounting Date	GL_DATE	Default accounting date for invoice distributions. Date format: YYYY/MM/DD. The date must be in an open or future open accounting period.	No
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute Date 1	GLOBAL_ATTRIBUTE_DATE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Date 2	GLOBAL_ATTRIBUTE_DATE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Date 3	GLOBAL_ATTRIBUTE_DATE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Date 4	GLOBAL_ATTRIBUTE_DATE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Date 5	GLOBAL_ATTRIBUTE_DATE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Number 1	GLOBAL_ATTRIBUTE_NUMBER1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Number 2	GLOBAL_ATTRIBUTE_NUMBER2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Number 3	GLOBAL_ATTRIBUTE_NUMBER3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Number 4	GLOBAL_ATTRIBUTE_NUMBER4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute Number 5	GLOBAL_ATTRIBUTE_NUMBER5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Goods Received Date	GOODS_RECEIVED_DATE	Date when goods on the invoice were received. Date format: YYYY/MM/DD. Required if the terms date basis is Goods Received.	No
Invoice Amount	INVOICE_AMOUNT	Invoice amount in transaction currency. Should be positive for standard and prepayment invoices. Should be negative for credit memos.	No
Invoice Currency	INVOICE_CURRENCY_CODE	Currency of invoice. Use the Manage Currencies task to identify valid values. Use the three character ISO currency code. Example: US Dollars is USD.	No
Invoice Date	INVOICE_DATE	Invoice date used to calculate due date per payment terms. Date format: YYYY/MM/DD.	No
Invoice ID	INVOICE_ID	Invoice identifier. Must be unique.	No
Invoice Includes Prepayment	INVOICE_INCLUDES_PREPAY_FLAG	Prepayment included in invoice amount. Valid values: Y,N, NULL.	No
Invoice Number	INVOICE_NUM	Supplier invoice number. Validation: must be unique for the supplier site.	No
Invoice Received Date	INVOICE_RECEIVED_DATE	Date when the invoice was received. Also known as terms date. Date format: YYYY/MM/DD. Required if the terms date basis is Invoice Received Date.	No
Invoice Type	INVOICE_TYPE_LOOKUP_CODE	Type of invoice. Use the Manage Payables Lookups task, lookup type INVOICE TYPE to identify valid values.	No
Legal Entity ID	LEGAL_ENTITY_ID	Unique identifier of the legal entity. If the identifier isn't available, use the LEGAL_ENTITY_NAME column.	No
Legal Entity Name	LEGAL_ENTITY_NAME	Name of the legal entity on the invoice. Use the Manage Legal Entities task to identify valid values.	No
No Conversion Rate Accounted Amount	NO_XRATE_BASE_AMOUNT	Invoice amount in the functional currency. Used to calculate exchange rate. Used only when Calculate User Exchange Rate option is enabled for foreign currency invoices with exchange rate type of User.	No
Business Unit	OPERATING_UNIT	Business unit to which the invoice refers.	No
Business Unit	ORG_ID	Identifier of the business unit associated with the row. If the identifier isn't available, use the OPERATING_UNIT column.	No
Pay Group	PAY_GROUP_LOOKUP_CODE	Groups suppliers or invoices for a single pay run. Examples: employees, merchandise, nonmerchandise. Use the Manage Payables Lookups task, lookup type PAY GROUP to identify valid values.	No
Payment Currency	PAYMENT_CURRENCY_CODE	Oracle internal use only.	No
Payment Method	PAYMENT_METHOD_CODE	Payment method, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values.	No
Payment Reason	PAYMENT_REASON_CODE	Code to provide the payment system or bank with additional details for the payment. Use the Manage Payment Codes task to identify valid values. The corresponding Payment Code Type must be Payment Reason.	No
Payment Reason Comments	PAYMENT_REASON_COMMENTS	Reason for the payment. Free text field. Not validated.	No
Customs Location Code	PORT_OF_ENTRY_CODE	Identifies the location or port through which the invoiced goods entered the country. Free text field. Not validated.	No
Prepayment Application Amount	PREPAY_APPLY_AMOUNT	Amount of prepayment to apply to the invoice. Must be positive. Cannot exceed the unpaid invoice amount or the amount of available prepayments.	No
Prepayment Accounting Date	PREPAY_GL_DATE	Accounting date for the prepayment application. If NULL, the value for the column GL_DATE is used. Date format: YYYY/MM/DD.	No
Prepayment Line	PREPAY_LINE_NUM	The invoice line of an existing prepayment to be applied to the invoice.	No
Prepayment Number	PREPAY_NUM	Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. Validations: settlement date must be on or before the system date, if the type is Temporary, it must have the same invoice and payment currency as the invoice, the prepayment must not be fully applied.	No
Product Table	PRODUCT_TABLE	Name of the product source table used to generate an invoice. Free text field. Not validated.	No
Reference Key 1	REFERENCE_KEY1	Captures invoice reference information from non-Oracle application. Free text field. Not validated.	No
Reference Key 2	REFERENCE_KEY2	Captures invoice reference information from non-Oracle application. Free text field. Not validated.	No
Reference Key 3	REFERENCE_KEY3	Captures invoice reference information from non-Oracle application. Free text field. Not validated.	No
Reference Key 4	REFERENCE_KEY4	Captures invoice reference information from non-Oracle application. Free text field. Not validated.	No
Reference Key 5	REFERENCE_KEY5	Captures invoice reference information from non-Oracle application. Free text field. Not validated.	No
Remit-to Address Name	REMIT_TO_ADDRESS_NAME	Remit-to address where the payment should be sent	No
Remit-to Supplier	REMIT_TO_SUPPLIER_NAME	Third party supplier	No
Remit-to Supplier Number	REMIT_TO_SUPPLIER_NUM	Third party supplier number	No
Remittance Message 1	REMITTANCE_MESSAGE1	Remittance message for use in payment processing. Free text field. Not validated.	No
Remittance Message 2	REMITTANCE_MESSAGE2	Remittance message for use in payment processing. Free text field. Not validated.	No
Remittance Message 3	REMITTANCE_MESSAGE3	Remittance message for use in payment processing. Free text field. Not validated.	No
Requester Employee Number	REQUESTER_EMPLOYEE_NUM	Oracle internal use only.	No
Requester First Name	REQUESTER_FIRST_NAME	The first name of the employee who requested goods or services on the invoice line. Both REQUESTER_FIRST_NAME and REQUESTER_LAST_NAME must be populated to determine a valid employee identifier if REQUESTER_ID isn't used.	No
Requester ID	REQUESTER_ID	Requester of invoice: used by the Invoice Approval workflow process to generate the list of approvers. If the identifier isn't available, use the REQUESTOR_NAME column.	No
Requester Last Name	REQUESTER_LAST_NAME	The last name of the employee who requested goods or services on the invoice line. . Both REQUESTER_FIRST_NAME and REQUESTER_LAST_NAME must be populated to determine a valid employee identifier if REQUESTER_ID isn't used.	No
Settlement Priority	SETTLEMENT_PRIORITY	Priority to settle payment for the transaction. Use the Manage Payables Lookups task, lookup type IBY_SETTLEMENT_PRIORITY to identify valid values.	No
Supplier Tax Invoice Conversion Rate	SUPPLIER_TAX_EXCHANGE_RATE	Supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices.	No
Supplier Tax Invoice Date	SUPPLIER_TAX_INVOICE_DATE	Tax invoice date on the supplier-issued tax invoice. Date format: YYYY/MM/DD.	No
Supplier Tax Invoice Number	SUPPLIER_TAX_INVOICE_NUMBER	The invoice number used to report on a supplier issued tax invoice that's distinct from the regular invoice. Free text field. Not validated.	No
Internal Sequence Number	TAX_INVOICE_INTERNAL_SEQ	Company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. Free text field. Not validated.	No
Internal Recording Date	TAX_INVOICE_RECORDING_DATE	If company-specific tax invoice date and number is captured, the date the company receives or records the supplier-issued tax invoice. Date format: YYYY/MM/DD.	No
Tax Related Invoice	TAX_RELATED_INVOICE_ID	Oracle internal use only.	No
Taxation Country	TAXATION_COUNTRY	Sets the context for tax drivers such as Product Classification Code. If no value is entered, it will display the legal entity country by default.	No
Terms Date	TERMS_DATE	Used with payment terms to calculate scheduled payment of an invoice. Date format: YYYY/MM/DD.	No
Payment Terms ID	TERMS_ID	Payment terms identifier. If the identifier isn't available, use the TERMS_NAME column. Validated against AP_TERMS_TL.TERM_ID.	No
Payment Terms	TERMS_NAME	Name of payment term for an invoice. Use the Manage Payment Terms task to identify valid values.	No
Supplier Tax Registration ID	THIRD_PARTY_REGISTRATION_ID	Third party tax registration identifier.	No
Supplier Tax Registration Number	THIRD_PARTY_REGISTRATION_NUM	Third party tax registration number.	No
Unique Remittance Identifier	UNIQUE_REMITTANCE_IDENTIFIER	Unique remittance identifier provided by the payee. Not validated.	No
Unique Remittance Identifier Check Digit	URI_CHECK_DIGIT	Unique remittance identifier check digit. Free text field. Not validated.	No
Supplier	VENDOR_NAME	Supplier name. Use the Manage Suppliers task to identify valid values.	No
Supplier Number	VENDOR_NUM	Unique number to identify a supplier. Use the Manage Suppliers task to identify valid values.	No
Supplier Site	VENDOR_SITE_CODE	Physical location of the supplier. Use the Manage Suppliers task to identify valid values.	No
Voucher Number	VOUCHER_NUM	Unique internal identifier assigned to a document. Required if document category code has assignment type of manual.	No

AP_INVOICE_LINES_INTERFACE

Object name on the Configure Business Object Attributes page: Correct Import Errors Invoice Lines

AP_INVOICE_LINES_INTERFACE stores information used to create one or more invoice lines. AP_INVOICE_LINES_INTERFACE_ is the audit table for AP_INVOICE_LINES_INTERFACE. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Overlay Account Segment	ACCOUNT_SEGMENT	Overrides account segment of the default liability account combination for the invoice line. Must be a valid value for the accounting flexfield.	No
Accounting Date	ACCOUNTING_DATE	Date when the invoice line is to be accounted. Date format: YYYY/MM/DD.	No
Amount	AMOUNT	Amount of the invoice line. Validated against the invoice type. Example: standard invoices must have positive amounts. Amount precision is validated against the currency.	No
Application ID	APPLICATION_ID	Oracle internal use only. Value will be derived.	No
Assessable Value	ASSESSABLE_VALUE	Enter the amount to be used as taxable basis. Free text field. Not validated.	No
Book	ASSET_BOOK_TYPE_CODE	Default asset book for transfers to Oracle Fusion Assets. Use the Manage Assets Books task to identify valid values.	No
Track as Asset	ASSETS_TRACKING_FLAG	A distribution line is tracked in Oracle Fusion Assets. Valid values: Y, N.	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Withholding Tax Group ID	AWT_GROUP_ID	Withholding tax group identifier. If the identifier isn't available, use the AWT_GROUP_NAME column. Validated against AP_AWT_GROUPS.GROUP_ID.	No
Withholding Tax Group	AWT_GROUP_NAME	Used to apply multiple withholding taxes to an invoice line. Use the Manage Withholding Groups task to identify valid values.	No
Overlay Primary Balancing Segment	BALANCING_SEGMENT	Overrides balancing segment of the default liability account for the invoice line. Must be a valid value for the accounting flexfield.	No
Budget Date	BUDGET_DATE	Budgetary Calendar Period Date applicable for funds check	No
Consumption Advice Line Number	CONSUMPTION_ADVICE_LINE_NUMBER	Consumption advice line number. Used for consumption advice matching.	No
Consumption Advice	CONSUMPTION_ADVICE_NUMBER	Consumption advice number. Used for consumption advice matching.	No
Overlay Cost Center Segment	COST_CENTER_SEGMENT	Overrides cost center of the default liability account combination for the invoice line. Must be a valid value for the accounting flexfield.	No
Multiperiod Accounting Accrual Account	DEF_ACCTG_ACCRUAL_CCID	Accrual account that's initially debited for deferred expenses	No
Multiperiod Accounting End Date	DEF_ACCTG_END_DATE	Oracle internal use only.	No
Multiperiod Accounting Start Date	DEF_ACCTG_START_DATE	Oracle internal use only.	No
Distribution Combination ID	DIST_CODE_COMBINATION_ID	Valid account combination for the accounting flexfield identifier distribution line. If the identifier isn't available, use the DIST_CODE_CONCATENATED column. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.	No
Distribution Set ID	DISTRIBUTION_SET_ID	Distribution set identifier. If the identifier isn't available, use the DISTRIBUTION_SET_NAME column. Validated against AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID.	No
Distribution Set	DISTRIBUTION_SET_NAME	Distribution set name. Use the Manage Distribution Sets task to identify valid values.	No
Location of Final Discharge	FINAL_DISCHARGE_LOCATION_CODE	Final discharge location code.	No
Location of Final Discharge ID	FINAL_DISCHARGE_LOCATION_ID	Final discharge location identifier.	No
Final Match	FINAL_MATCH_FLAG	Final match indicator for distribution line matched to purchase order. Valid values: Y, N, NULL. NULL means N.	No
Fiscal Charge Type	FISCAL_CHARGE_TYPE	Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE.	No
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Included in Taxable Line Indicator	INCL_IN_TAXABLE_LINE_FLAG	The amount in the tax line is included in the taxable line. Valid values: Y, N, NULL.	No
Income Tax Region	INCOME_TAX_REGION	Reporting region for distribution line for 1099 supplier. Use the Manage Tax Regions task to identify valid values. Validated against AP_INCOME_TAX_REGIONS.REGION_SHORT_NAME.	No
Item ID	INVENTORY_ITEM_ID	Oracle internal use only. Inventory item identifier.	No
Item Description	ITEM_DESCRIPTION	Item description. Free text field. Not validated.	No
Landed Cost Enabled	LCM_ENABLED_FLAG	Indicates whether invoice line is enabled for landed cost management.	No
Line Group Number	LINE_GROUP_NUMBER	Line group number. Used to prorate charges across a group of lines. Must be a positive integer.	No
Line Number	LINE_NUMBER	Invoice line number. Must be a positive integer. Must be unique per invoice.	No
Line Type	LINE_TYPE_LOOKUP_CODE	Type of invoice line. Use the Manage Payables Lookups task, lookup type INVOICE LINE TYPE to identify valid values.	No
Manufacturer	MANUFACTURER	Name of a manufacturer of an asset or item. Free text field. Not validated.	No
Match Option	MATCH_OPTION	The value of the Invoice Match option on the PO shipment. Valid values: P, R. P used for purchase order. R used for receipt.	No
Model	MODEL_NUMBER	Model number of the invoice line item. Free text field. Not validated.	No
Billable	PJC_BILLABLE_FLAG	Oracle internal use only. Project-related item is available for customer billing.	No
Capitalizable	PJC_CAPITALIZABLE_FLAG	Oracle internal use only. Project-related item is eligible for capitalization.	No
Projects related	PJC_CONTEXT_CATEGORY	Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.	No
Purchase Order Distribution ID	PO_DISTRIBUTION_ID	Purchase order distribution line identifier for matching. If the identifier isn't available, use the PO_DISTRIBUTION_NUM column. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID.	No
Purchase Order Distribution Number	PO_DISTRIBUTION_NUM	Purchase order distribution line number for matching. Use the Manage Purchase Orders task to identify valid values.	No
Purchase Order Header ID	PO_HEADER_ID	Purchase order header identifier used for purchase order matching. If the identifier isn't available, use the PURCHASE_ORDER_NUMBER column. Validated against PO_HEADERS_ALL.PO_HEADER_ID.	No
Purchase Order Line ID	PO_LINE_ID	Purchase order line identifier for matching. If the identifier isn't available, use the PO_LINE_NUMBER column. Validated against PO_LINES_ALL.PO_LINE_ID.	No
Purchase Order Line Location ID	PO_LINE_LOCATION_ID	Purchase order line location identifier for matching. If the identifier isn't available, use the PO_SHIPMENT_NUM column. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID.	No
Purchase Order Line Number	PO_LINE_NUMBER	Purchase order line number for matching. Use the Manage Purchase Orders task to identify valid values.	No
Purchase Order	PO_NUMBER	Purchase order number for matching. Use the Manage Purchase Orders task to identify valid values.	No
Purchase Order Schedule Number	PO_SHIPMENT_NUM	Purchase order shipment number for matching. Use the Manage Purchase Orders task to identify valid values.	No
Price Correction Invoice Line	PRICE_CORRECT_INV_LINE_NUM	Invoice line dependent on price correction. Use the Manage Invoices task to identify valid values.	No
Price Correction Invoice	PRICE_CORRECT_INV_NUM	Number of the invoice that price correction invoice is updating. Use the Manage Invoices task to identify valid values. Validated against AP_INVOICES_ALL.INVOICE_NUM.	No
Price Correction Indicator	PRICE_CORRECTION_FLAG	Indicates if a line creates a price correction. Valid values: Y, N, NULL.	No
Product Category	PRODUCT_CATEGORY	Identifies the taxable nature of a noninventory item. Free text field. Not validated.	No
Product Fiscal Classification	PRODUCT_FISC_CLASSIFICATION	Product fiscal classification for tax. Free text field. Not validated.	No
Product Table	PRODUCT_TABLE	Oracle internal use only.	No
Product Type	PRODUCT_TYPE	Override product type default from the inventory item for tax calculations. Valid values: GOODS, SERVICES.	No
Prorate Across All Item Lines	PRORATE_ACROSS_FLAG	Prorate indicator: prorate all lines with the same LINE_GROUP_NUMBER. Valid values: Y, N, NULL. NULL means Y.	No
Purchasing Category ID	PURCHASING_CATEGORY_ID	Oracle internal use only.	No
Invoiced Quantity	QUANTITY_INVOICED	Quantity invoiced against purchase order shipment.	No
Receipt Line Number	RECEIPT_LINE_NUMBER	The receipt line number with which an invoice will be matched. Use the Receive Expected Shipments task to identify valid values. Validated against RCV_SHIPMENT_LINES.LINE_NUM.	No
Receipt Number	RECEIPT_NUMBER	The receipt number with which an invoice will be matched. Use the Receive Expected Shipments task to identify valid values. Validated against RCV_SHIPMENT_HEADERS.RECEIPT_NUM.	No
Reference Key 1	REFERENCE_KEY1	Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.	No
Reference Key 2	REFERENCE_KEY2	Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.	No
Reference Key 3	REFERENCE_KEY3	Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.	No
Reference Key 4	REFERENCE_KEY4	Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.	No
Reference Key 5	REFERENCE_KEY5	Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.	No
Requester Employee Number	REQUESTER_EMPLOYEE_NUM	Oracle internal use only.	No
Requester First Name	REQUESTER_FIRST_NAME	Oracle internal use only.	No
Requester ID	REQUESTER_ID	Oracle internal use only.	No
Requester Last Name	REQUESTER_LAST_NAME	Oracle internal use only.	No
Serial Number	SERIAL_NUMBER	Serial number for an item. Free text field. Not validated.	No
Ship-from Location	SHIP_FROM_LOCATION_CODE	Ship-from location code.	No
Ship-from Location ID	SHIP_FROM_LOCATION_ID	Ship-from location identifier.	No
Ship-to Location	SHIP_TO_LOCATION_CODE	Location where goods are received from supplier. Use the Manage Locations task to identify valid values.	No
Ship-to Location ID	SHIP_TO_LOCATION_ID	Ship-to location identifier for tax calculations. Used only if the invoice line isn't PO matched. If the identifier isn't available, use the SHIP_TO_LOCATION column.	No
Tax Name	TAX	Classification of a charge imposed by a government. Use the Manage Taxes task to identify valid values.	No
Tax Classification	TAX_CLASSIFICATION_CODE	Classification code of the invoice line in the interface data. Use the Manage Tax Rates task to identify valid values.	No
Tax Jurisdiction Code	TAX_JURISDICTION_CODE	Internal identifier of a tax jurisdiction. Use the Manage Tax Jurisdictions task to identify valid values.	No
Tax Rate	TAX_RATE	The rate specified for a tax status in effect for a period of time. Use the Manage Tax Rates task to identify valid values.	No
Tax Rate Code	TAX_RATE_CODE	Tax rate name associated with tax rate identifier. The value of the identifier is unique, but the TAX_RATE_CODE may have different tax rates based on date ranges. Use the Manage Tax Rates task to identify valid values.	No
Tax Rate ID	TAX_RATE_ID	Oracle internal use only. Internal identifier for tax rate effective on the invoice date.	No
Tax Regime Code	TAX_REGIME_CODE	Set of tax rules for a tax authority. Use the Manage Tax Regimes task to identify valid values.	No
Tax Status Code	TAX_STATUS_CODE	Tax status code. Examples: taxable standard rate, zero rated, exempt, nontaxable. Use the Manage Tax Statuses task to identify valid values.	No
Taxable Indicator	TAXABLE_FLAG	Indicates whether a line is taxable. Valid values: Y, N, NULL.	No
Transaction Business Category	TRX_BUSINESS_CATEGORY	Transaction category for tax. Free text field. Not validated.	No
Income Tax Type	TYPE_1099	Payments of type 1099 made to a supplier. Use the Income Tax Types task to identify valid values.	No
UOM	UNIT_OF_MEAS_LOOKUP_CODE	Unit of measure for the quantity on an invoice. Validated against purchase order matching option, unit of measure, and quantity. Codependency with QUANTITY_INVOICED and UNIT_PRICE: all three columns must be consistent, either populated or not populated. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE.	No
Unit Price	UNIT_PRICE	Unit price for purchase order matched invoice items. Must be positive for standard invoices; negative for credit and debit memos.	No
User-Defined Fiscal Classification	USER_DEFINED_FISC_CLASS	Fiscal class for tax. Free text field. Not validated.	No
Project Contract ID	PJC_CONTRACT_ID	Oracle internal use only. Contract identifier: used when Oracle Fusion Project Billing or Oracle Fusion Project Billing or Oracle Fusion Grants Accounting is installed.	No
Project Contract Name	PJC_CONTRACT_NAME	Contract name used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.	No
Project Contract Number	PJC_CONTRACT_NUMBER	Contract number used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.	No
Project Expenditure Item Date	PJC_EXPENDITURE_ITEM_DATE	Oracle internal use only. Date on which project-related transaction occurred. Date format: YYYY/MM/DD.	No
Project Expenditure Type ID	PJC_EXPENDITURE_TYPE_ID	Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.	No
Project Expenditure Type	PJC_EXPENDITURE_TYPE_NAME	A classification of cost that's assigned to each expenditure item.	No
Project Funding Allocation ID	PJC_FUNDING_ALLOCATION_ID	Oracle internal use only. Name of project funding override.	No
Project Funding Source Name	PJC_FUNDING_SOURCE_NAME	Name of the source funding the project.	No
Project Funding Source Number	PJC_FUNDING_SOURCE_NUMBER	Number of the source funding the project.	No
Project Expenditure Organization ID	PJC_ORGANIZATION_ID	Oracle internal use only. Organization identifier to build transaction descriptive flexfield for project-related transaction distributions.	No
Project Expenditure Organization	PJC_ORGANIZATION_NAME	Organization to which the project is assigned.	No
Project ID	PJC_PROJECT_ID	Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.	No
Project Name	PJC_PROJECT_NAME	Name of the project to which the invoice expense is charged.	No
Project Number	PJC_PROJECT_NUMBER	Number of the project to which the invoice expense is charged.	No
Project Reserved Attribute 1	PJC_RESERVED_ATTRIBUTE1	Reserved for future project-related functionality.	No
Project Reserved Attribute 10	PJC_RESERVED_ATTRIBUTE10	Reserved for future project-related functionality.	No
Project Reserved Attribute 2	PJC_RESERVED_ATTRIBUTE2	Reserved for future project-related functionality.	No
Project Reserved Attribute 3	PJC_RESERVED_ATTRIBUTE3	Reserved for future project-related functionality.	No
Project Reserved Attribute 4	PJC_RESERVED_ATTRIBUTE4	Reserved for future project-related functionality.	No
Project Reserved Attribute 5	PJC_RESERVED_ATTRIBUTE5	Reserved for future project-related functionality.	No
Project Reserved Attribute 6	PJC_RESERVED_ATTRIBUTE6	Reserved for future project-related functionality.	No
Project Reserved Attribute 7	PJC_RESERVED_ATTRIBUTE7	Reserved for future project-related functionality.	No
Project Reserved Attribute 8	PJC_RESERVED_ATTRIBUTE8	Reserved for future project-related functionality.	No
Project Reserved Attribute 9	PJC_RESERVED_ATTRIBUTE9	Reserved for future project-related functionality.	No
Project Task ID	PJC_TASK_ID	Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.	No
Project Task Name	PJC_TASK_NAME	Name of the task used to build the transaction descriptive flexfield for project-related transaction distributions.	No
Project Task Number	PJC_TASK_NUMBER	A subdivision of project work. Task Number uniquely identifies the element within a project or structure.	No
Project User-Defined Attribute 1	PJC_USER_DEF_ATTRIBUTE1	Reserved for user definable project information.	No
Project User-Defined Attribute 10	PJC_USER_DEF_ATTRIBUTE10	Reserved for user definable project information.	No
Project User-Defined Attribute 2	PJC_USER_DEF_ATTRIBUTE2	Reserved for user definable project information.	No
Project User-Defined Attribute 3	PJC_USER_DEF_ATTRIBUTE3	Reserved for user definable project information.	No
Project User-Defined Attribute 4	PJC_USER_DEF_ATTRIBUTE4	Reserved for user definable project information.	No
Project User-Defined Attribute 5	PJC_USER_DEF_ATTRIBUTE5	Reserved for user definable project information.	No
Project User-Defined Attribute 6	PJC_USER_DEF_ATTRIBUTE6	Reserved for user definable project information.	No
Project User-Defined Attribute 7	PJC_USER_DEF_ATTRIBUTE7	Reserved for user definable project information.	No
Project User-Defined Attribute 8	PJC_USER_DEF_ATTRIBUTE8	Reserved for user definable project information.	No
Project User-Defined Attribute 9	PJC_USER_DEF_ATTRIBUTE9	Reserved for user definable project information.	No
Project Work Type	PJC_WORK_TYPE	Classification of project-related work performed.	No
Project Work Type ID	PJC_WORK_TYPE_ID	Oracle internal use only. Identifier for project-related classification of the worked performed.	No
Intended Use	PRIMARY_INTENDED_USE	Tax driver: the purpose for which a product may be used. Free text field. Not validated.	No
Purchasing Category	PURCHASING_CATEGORY	Item category concatenated segments for deriving purchasing category information. Use the Manage Catalogs task to identify valid values.	No
Invoice Id	INVOICE_ID	Invoice identifier. Must be unique.	No
Asset Category	ASSET_CATEGORY_ID	Default asset category for transfers to Oracle Fusion Assets. Use the Manage Asset Categories task to identify valid values.	No
Consumption Advice	CONSUMPTION_ADVICE_HEADER_ID	Consumption advice header identifier. Used for consumption advice matching.	No
Consumption Advice Line Number	CONSUMPTION_ADVICE_LINE_ID	Consumption advice line identifier. Used for consumption advice matching.	No

AP_INVOICES_ALL

Object name on the Configure Business Object Attributes page: Invoice

AP_INVOICES_ALL contains records for invoices you enter. There's one row for each invoice you enter. An invoice can have one or more lines and each line can have one or more distributions. An invoice can also have one or more installments. AP_INVOICES_ALL_ is the audit table for AP_INVOICES_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Liability Distribution	ACCTS_PAY_CODE_COMBINATION_ID	Accounting Flexfield identifier for accounts payable liability account.	No
Discountable Amount	AMOUNT_APPLICABLE_TO_DISCOUNT	Amount of invoice applicable to a discount.	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Bank Charge Bearer	BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.	No
Invoice Group	BATCH_ID	Unique invoice group identifier.	No
Budget Date	BUDGET_DATE	Budgetary Calendar Period Date applicable for funds check.	No
Control Amount	CONTROL_AMOUNT	Manually entered value to ensure that the calculated tax will be the same as on the physical document.	No
Correction Period	CORRECTION_PERIOD	The tax declaration period of a purchase transaction that's being corrected.	No
Correction Year	CORRECTION_YEAR	The tax declaration year of a purchase transaction that's being corrected.	No
First-Party Taxpayer ID	CUST_REGISTRATION_NUMBER	Customer legal registration number.	No
Delivery Channel	DELIVERY_CHANNEL_CODE	Text on electronic payment that instructs the bank about the execution of payment. For example, print a check and hold it for collection by the payee.	No
Description	DESCRIPTION	Statement that describes the invoice.	No
Document Category	DOC_CATEGORY_CODE	Sequential Numbering (voucher number) document category.	No
Document Fiscal Classification	DOCUMENT_SUB_TYPE	Classification to categorize a document associated with a transaction for tax. This affects the taxability of the transaction.	No
Apply After	EARLIEST_SETTLEMENT_DATE	Date associated with a prepayment after which you can apply the prepayment against invoices. Only used for temporary prepayments. Column is null for permanent prepayments and other invoice types.	No
Conversion Date	EXCHANGE_DATE	Date when a conversion rate is used to convert an amount into another currency for an invoice.	No
Conversion Rate	EXCHANGE_RATE	Ratio at which the principal unit of one currency is converted into another currency for an invoice.	No
Conversion Rate Type	EXCHANGE_RATE_TYPE	Source of currency conversion rate for an invoice. For example, user defined, spot, or corporate.	No
Pay Alone	EXCLUSIVE_PAYMENT_FLAG	Indicator to pay the invoice on a separate payment document.	No
First-Party Tax Registration Number	FIRST_PARTY_REGISTRATION_ID	First party tax registration identifier.	No
Accounting Date	GL_DATE	Accounting date to default to invoice distributions.	No
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Goods Received	GOODS_RECEIVED_DATE	Date when goods on the invoice were received.	No
Intercompany invoice	INTERCOMPANY_FLAG	Intercompany indicator added to incorporate FUN team's intercompany feature.	No
Amount	INVOICE_AMOUNT	Invoice amount in transaction currency.	No
Invoice Currency	INVOICE_CURRENCY_CODE	Currency code used on the invoice.	No
Date	INVOICE_DATE	Date when an event will occur or occurred.	No
Invoice ID	INVOICE_ID	Unique invoice identifier.	No
Number	INVOICE_NUM	Unique number for supplier invoice.	No
Invoice Received	INVOICE_RECEIVED_DATE	Date when the invoice was received. This is used to calculate when the invoice is due.	No
Type	INVOICE_TYPE_LOOKUP_CODE	Invoice category, such as standard, credit memo, or prepayment.	No
Legal Entity	LEGAL_ENTITY_ID	Unique identifier of the legal entity.	No
Pay Group	PAY_GROUP_LOOKUP_CODE	Groups a category of suppliers or invoices for single pay run. For example, employees, merchandise, nonmerchandise, government, domestic, and international.	No
Payment Currency	PAYMENT_CURRENCY_CODE	Currency code of payment (must be same as INVOICE_CURRENCY_CODE or have a fixed rate relationship).	No
Payment Reason	PAYMENT_REASON_CODE	Codes provided by the government or central bank of a country. These codes provide the payment system or bank with additional details about the reason for the payment and are used for regulatory reporting purposes.	No
Payment Reason Comments	PAYMENT_REASON_COMMENTS	Free text field available for entering a reason for the payment.	No
Customs Location Code	PORT_OF_ENTRY_CODE	Code that identifies the location or port through which the invoiced goods entered the country.	No
Requester	REQUESTER_ID	Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers.	No
Routing Attribute 2	ROUTING_ATTRIBUTE2	Captures additional attributes information that may have been used for routing payables invoice images.	No
Routing Attribute 3	ROUTING_ATTRIBUTE3	Captures additional attributes information that may have been used for routing payables invoice images.	No
Routing Attribute 4	ROUTING_ATTRIBUTE4	Captures additional attributes information that may have been used for routing payables invoice images.	No
Settlement Priority	SETTLEMENT_PRIORITY	The priority that the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.	No
Supplier Tax Invoice Conversion Rate	SUPPLIER_TAX_EXCHANGE_RATE	Conversion rate for taxes on a supplier invoice.	No
Supplier Tax Invoice Date	SUPPLIER_TAX_INVOICE_DATE	Date when the supplier charged tax, as shown on the purchase order.	No
Supplier Tax Invoice Number	SUPPLIER_TAX_INVOICE_NUMBER	Invoice supplier tax invoice number.	No
Internal Sequence Number	TAX_INVOICE_INTERNAL_SEQ	Invoice internal sequence number.	No
Internal Recording Date	TAX_INVOICE_RECORDING_DATE	Date when the invoice was recorded.	No
Related Invoice	TAX_RELATED_INVOICE_ID	Tax related to an invoice.	No
Taxation Country	TAXATION_COUNTRY	Country in which the transaction occurred. Oracle Fusion tax sets the context of other tax drivers, such as Product Fiscal Classification based on this value.	No
Terms Date	TERMS_DATE	Date used with payment terms to calculate scheduled payment of an invoice.	No
Payment Terms	TERMS_ID	Payment terms identifier used on the invoice.	No
Supplier Tax Registration Number	THIRD_PARTY_REGISTRATION_ID	Third party tax registration identifier.	No
Transaction Deadline	TRANSACTION_DEADLINE	Number of days to perform an intra-EU transaction. Used for Modelo reports for Spain.	No
Unique Remittance Identifier	UNIQUE_REMITTANCE_IDENTIFIER	Unique remittance identifier by the payee.	No
Unique Remittance Identifier Check Digit	URI_CHECK_DIGIT	Unique remittance identifier check digit.	No
Supplier	VENDOR_ID	Invoice supplier identifier.	Yes
Supplier Site	VENDOR_SITE_ID	Physical location of the supplier.	Yes
Voucher Number	VOUCHER_NUM	Voucher number; validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled).	No

AP_INVOICE_LINES_ALL

Object name on the Configure Business Object Attributes page: Invoice Lines

AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. An invoice can have one or more invoice lines. An invoice line can have one or more invoice distributions. An invoice line represents goods (direct or indirect materials), service or services, and either associated tax, freight, or miscellaneous charges invoiced from a supplier. AP_INVOICE_LINES_ALL_ is the audit table for AP_INVOICE_LINES_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Overlay Account Segment	ACCOUNT_SEGMENT	Account segment value for overlay in generation of accounting flexfield during distribution generation	No
Accounting Date	ACCOUNTING_DATE	Accounting date for invoice line. Used for defaulting to distributions	No
Amount	AMOUNT	Line amount in invoice currency	No
Assessable Value	ASSESSABLE_VALUE	User-enterable amount to be used as taxable basis.	No
Asset Book	ASSET_BOOK_TYPE_CODE	Asset Book. Defaults to the distributions candidate for transfer to Oracle Assets	No
Asset Category	ASSET_CATEGORY_ID	Asset Category. Defaults to the distributions candidate for transfer to Oracle Assets	No
Track as Asset	ASSETS_TRACKING_FLAG	Y indicates that the item should be treated as an asset	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Withholding	AWT_GROUP_ID	Withholding tax group identifier	No
Overlay Primary Balancing Segment	BALANCING_SEGMENT	Balancing segment value for overlay in generation of accounting flexfield during distribution generation	No
Budget Date	BUDGET_DATE	Budgetary Calendar Period Date applicable for funds check.	No
Tax Control Amount	CONTROL_AMOUNT	Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document.	No
Corrected Invoice Line	CORRECTED_LINE_NUMBER	Invoice line number for invoice line corrected via current line. For price, quantity, or invoice line corrections.	No
Overlay Cost Center Segment	COST_CENTER_SEGMENT	Cost Center segment value for overlay in generation of accounting flexfield during distribution generation	No
Multiperiod Accounting Accrual Account	DEF_ACCTG_ACCRUAL_CCID	Accrual account that's initially debited for deferred expenses.	No
Multiperiod Accounting End Date	DEF_ACCTG_END_DATE	The end date of the deferred expense period	No
Multiperiod Accounting Start Date	DEF_ACCTG_START_DATE	The start date of the deferred expense period	No
Distribution Combination	DEFAULT_DIST_CCID	Account to be used for automatic generation of a single distribution	No
Description	DESCRIPTION	Description of the invoice line.	No
Distribution Set	DISTRIBUTION_SET_ID	Distribution set identifier to be used in the generation of distributions for a line	No
Location of Final Discharge	FINAL_DISCHARGE_LOCATION_ID	Final discharge location identifier.	No
Final Match	FINAL_MATCH_FLAG	Indicates if an invoice is the last one being matched to a PO, so that the PO is no longer available for matching.	No
Fiscal Charge Type	FISCAL_CHARGE_TYPE	Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE.	No
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Income Tax Region	INCOME_TAX_REGION	Reporting region for invoice line for 1099 supplier. Defaults down to distributions	No
Intended Use	INTENDED_USE_CLASSIF_ID	Tax Driver: Intended use identifier.	No
Inventory Item	INVENTORY_ITEM_ID	Inventory item identifier. Validated against EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID	No
Invoice Id	INVOICE_ID	Unique invoice identifier.	No
Landed Cost Enabled	LCM_ENABLED_FLAG	Indicates whether invoice line is enabled for landed cost management.	No
Line Type	LINE_TYPE_LOOKUP_CODE	Type of invoice line. Valid values from INVOICE LINE TYPE lookup codes.	No
Manufacturer	MANUFACTURER	Manufacturer of an asset or item.	No
Model Number	MODEL_NUMBER	Model number of the invoice line item.	No
Overlay Distribution Combination	OVERLAY_DIST_CODE_CONCAT	Concatenated segments for overlay in generation of accounting flexfield during distribution generation	No
Project Billable	PJC_BILLABLE_FLAG	Option that indicates if a project related item is available to be billed to customers.	No
Project Capitalizable	PJC_CAPITALIZABLE_FLAG	Option that indicates if a project related item is eligible for capitalization.	No
Project Contract Number	PJC_CONTRACT_ID	Contract Identified. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.	No
Expenditure Item Date	PJC_EXPENDITURE_ITEM_DATE	Date on which a project related transaction is incurred.	No
Expenditure Item Type	PJC_EXPENDITURE_TYPE_ID	Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions.	No
Expenditure Organization	PJC_ORGANIZATION_ID	Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions.	No
Project Number	PJC_PROJECT_ID	Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions.	No
Task Number	PJC_TASK_ID	Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions.	No
Project User-Defined Attribute 1	PJC_USER_DEF_ATTRIBUTE1	Reserved for user definable project information.	No
Project User-Defined Attribute 10	PJC_USER_DEF_ATTRIBUTE10	Reserved for user definable project information.	No
Project User-Defined Attribute 2	PJC_USER_DEF_ATTRIBUTE2	Reserved for user definable project information.	No
Project User-Defined Attribute 3	PJC_USER_DEF_ATTRIBUTE3	Reserved for user definable project information.	No
Project User-Defined Attribute 4	PJC_USER_DEF_ATTRIBUTE4	Reserved for user definable project information.	No
Project User-Defined Attribute 5	PJC_USER_DEF_ATTRIBUTE5	Reserved for user definable project information.	No
Project User-Defined Attribute 6	PJC_USER_DEF_ATTRIBUTE6	Reserved for user definable project information.	No
Project User-Defined Attribute 7	PJC_USER_DEF_ATTRIBUTE7	Reserved for user definable project information.	No
Project User-Defined Attribute 8	PJC_USER_DEF_ATTRIBUTE8	Reserved for user definable project information.	No
Project User-Defined Attribute 9	PJC_USER_DEF_ATTRIBUTE9	Reserved for user definable project information.	No
Project Work Type	PJC_WORK_TYPE_ID	Identifier for project related classification of the worked performed.	No
Product Fiscal Classification	PROD_FC_CATEG_ID	Tax Driver: Product fiscal classification identifier.	No
Product Category	PRODUCT_CATEGORY	Identifies the taxable nature of a non-inventory based item for tax determination or tax reporting.	No
Product Type	PRODUCT_TYPE	Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user.	No
Prorate Across All Items	PRORATE_ACROSS_ALL_ITEMS	A value of Y indicates that the Freight or Miscellaneous type line should be prorated across all Item type lines	No
Quantity	QUANTITY_INVOICED	Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines	No
Requester	REQUESTER_ID	The name of the person who the requested items are intended for.	No
Serial Number	SERIAL_NUMBER	Number indicating place in a series, used for identification.	No
Ship-from Location	SHIP_FROM_LOCATION_ID	Ship-from location identifier.	No
Ship-to Location	SHIP_TO_CUST_LOCATION_ID	Location where the supplier should ship the goods.	No
Ship-to Location	SHIP_TO_LOCATION_ID	Tax Driver: Ship to location ID. Value entered by user only if line isn't PO matched.	No
Tax Classification	TAX_CLASSIFICATION_CODE	Tax classification code used by Procure To Pay products.	No
Transaction Business Category	TRX_BUSINESS_CATEGORY	Tax Driver: Transactions category assigned by user.	No
Income Tax Type	TYPE_1099	Indicates the category of the withholding tax rates.	No
UOM	UNIT_MEAS_LOOKUP_CODE	Unit of measure for QUANTITY_INVOICED. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE	No
Unit Price	UNIT_PRICE	Price charged per unit of a good or service.	No
User-Defined Fiscal Classification	USER_DEFINED_FISC_CLASS	Tax Driver: Fiscal Classification.	No

AP_INVOICE_DISTRIBUTIONS_ALL

Object name on the Configure Business Object Attributes page: Invoice Distributions

AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that's manually entered or system-generated. There's one row for each invoice distribution. A distribution must be associated with an invoice line. An invoice line can have multiple distributions. AP_INVOICE_DISTRIBUTIONS_ALL_ is the audit table for AP_INVOICE_DISTRIBUTIONS_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Accounting Date	ACCOUNTING_DATE	Accounting date for invoice line. Used for defaulting to distributions	No
Amount	AMOUNT	Line amount in invoice currency	No
Asset Book	ASSET_BOOK_TYPE_CODE	Asset Book. Defaults to the distributions candidate for transfer to Oracle Assets	No
Track as Asset	ASSETS_TRACKING_FLAG	Y indicates that the item should be treated as an asset	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Budget Date	BUDGET_DATE	Budgetary Calendar Period Date applicable for funds check.	No
Multiperiod Accounting Accrual Account	DEF_ACCTG_ACCRUAL_CCID	Accrual account that's initially debited for deferred expenses.	No
Multiperiod Accounting End Date	DEF_ACCTG_END_DATE	Deferred accounting end date.	No
Multiperiod Accounting Start Date	DEF_ACCTG_START_DATE	Deferred accounting start date.	No
Description	DESCRIPTION	Statement that describes the distribution.	No
Distribution Combination	DIST_CODE_COMBINATION_ID	Accounting Flexfield identifier for account associated with a distribution	No
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Income Tax Region	INCOME_TAX_REGION	Reporting region for distribution for 1099 supplier.	No
Intended Use	INTENDED_USE_CLASSIF_ID	Tax Driver: Intended use identifier.	No
Distribution Line Type	LINE_TYPE_LOOKUP_CODE	Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE	No
Project Billable	PJC_BILLABLE_FLAG	Option that indicates if a project related item is available to be billed to customers.	No
Project Capitalizable	PJC_CAPITALIZABLE_FLAG	Option that indicates if a project related item is eligible for capitalization.	No
Project Context Category	PJC_CONTEXT_CATEGORY	Segment used to identify the descriptive flexfield application context for project related standardized code collection.	No
Contract Number	PJC_CONTRACT_ID	Contract Identified. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.	No
Expenditure Item Date	PJC_EXPENDITURE_ITEM_DATE	Date on which a project related transaction is incurred.	No
Expenditure Item Type	PJC_EXPENDITURE_TYPE_ID	Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions.	No
Expenditure Organization	PJC_ORGANIZATION_ID	Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions.	No
Project Number	PJC_PROJECT_ID	Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions.	No
Task Number	PJC_TASK_ID	Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions.	No
Project User-Defined Attribute 1	PJC_USER_DEF_ATTRIBUTE1	Reserved for user definable project information.	No
Project User-Defined Attribute 10	PJC_USER_DEF_ATTRIBUTE10	Reserved for user definable project information.	No
Project User-Defined Attribute 2	PJC_USER_DEF_ATTRIBUTE2	Reserved for user definable project information.	No
Project User-Defined Attribute 3	PJC_USER_DEF_ATTRIBUTE3	Reserved for user definable project information.	No
Project User-Defined Attribute 4	PJC_USER_DEF_ATTRIBUTE4	Reserved for user definable project information.	No
Project User-Defined Attribute 5	PJC_USER_DEF_ATTRIBUTE5	Reserved for user definable project information.	No
Project User-Defined Attribute 6	PJC_USER_DEF_ATTRIBUTE6	Reserved for user definable project information.	No
Project User-Defined Attribute 7	PJC_USER_DEF_ATTRIBUTE7	Reserved for user definable project information.	No
Project User-Defined Attribute 8	PJC_USER_DEF_ATTRIBUTE8	Reserved for user definable project information.	No
Project User-Defined Attribute 9	PJC_USER_DEF_ATTRIBUTE9	Reserved for user definable project information.	No
Work Type	PJC_WORK_TYPE_ID	Identifier for project related classification of the worked performed.	No
Invoiced Quantity	QUANTITY_INVOICED	Quantity billed for purchase order or receipt matched invoice distributions.	No
Statistical Quantity	STAT_AMOUNT	Amount associated with a distribution for measuring statistical quantities.	No
Income Tax Type	TYPE_1099	Payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type.	No

AP_PAYMENT_SCHEDULES_ALL

Object name on the Configure Business Object Attributes page: Invoice Installments

AP_PAYMENT_SCHEDULES_ALL contains information about installments for an invoice. Your Oracle Payables application uses this information to determine when to make payments on an invoice and how much to pay. AP_PAYMENT_SCHEDULES_ALL_ is the audit table for AP_PAYMENT_SCHEDULES_ALL. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13	ATTRIBUTE13	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 14	ATTRIBUTE14	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 15	ATTRIBUTE15	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
First Discount Amount	DISCOUNT_AMOUNT_AVAILABLE	Discount amount available at first discount date.	No
First Discount Date	DISCOUNT_DATE	Date first discount is available.	No
Due Date	DUE_DATE	Date when the invoice or installment is due for payment.	No
Bank Account	EXTERNAL_BANK_ACCOUNT_ID	External bank account identifier.	No
Global Attribute Category	GLOBAL_ATTRIBUTE_CATEGORY	Global Descriptive Flexfield: structure definition of the global descriptive flexfield.	No
Global Attribute Date 1	GLOBAL_ATTRIBUTE_DATE1	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Date 2	GLOBAL_ATTRIBUTE_DATE2	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Date 3	GLOBAL_ATTRIBUTE_DATE3	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Date 4	GLOBAL_ATTRIBUTE_DATE4	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Date 5	GLOBAL_ATTRIBUTE_DATE5	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Number 1	GLOBAL_ATTRIBUTE_NUMBER1	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Number 2	GLOBAL_ATTRIBUTE_NUMBER2	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Number 3	GLOBAL_ATTRIBUTE_NUMBER3	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Number 4	GLOBAL_ATTRIBUTE_NUMBER4	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute Number 5	GLOBAL_ATTRIBUTE_NUMBER5	Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.	No
Global Attribute 1	GLOBAL_ATTRIBUTE1	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 10	GLOBAL_ATTRIBUTE10	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 11	GLOBAL_ATTRIBUTE11	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 12	GLOBAL_ATTRIBUTE12	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 13	GLOBAL_ATTRIBUTE13	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 14	GLOBAL_ATTRIBUTE14	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 15	GLOBAL_ATTRIBUTE15	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 16	GLOBAL_ATTRIBUTE16	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 17	GLOBAL_ATTRIBUTE17	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 18	GLOBAL_ATTRIBUTE18	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 19	GLOBAL_ATTRIBUTE19	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 2	GLOBAL_ATTRIBUTE2	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 20	GLOBAL_ATTRIBUTE20	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 3	GLOBAL_ATTRIBUTE3	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 4	GLOBAL_ATTRIBUTE4	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 5	GLOBAL_ATTRIBUTE5	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 6	GLOBAL_ATTRIBUTE6	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 7	GLOBAL_ATTRIBUTE7	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 8	GLOBAL_ATTRIBUTE8	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Global Attribute 9	GLOBAL_ATTRIBUTE9	Global Descriptive Flexfield: segment of the global descriptive flexfield.	No
Gross Amount	GROSS_AMOUNT	Gross amount due for a scheduled payment.	No
On Hold	HOLD_FLAG	Indicates if scheduled payment is on hold (Y or N).	No
Hold Reason	IBY_HOLD_REASON	An explanation or justification that explains the reason for performing actions, such as cancellation, apply hold, or close out.	No
Invoice Id	INVOICE_ID	Unique invoice identifier.	No
Payment Method	PAYMENT_METHOD_CODE	Indicates the payment method, such as check, cash, or credit.	No
Payment Priority	PAYMENT_PRIORITY	Number representing payment priority of a scheduled payment (1 to 99).	No
Remit-to Address Name	REMIT_TO_ADDRESS_NAME	Remit-to address where payment should be sent.	No
Remit-to Supplier	REMIT_TO_SUPPLIER_NAME	Third party supplier.	No
Remittance Message 1	REMITTANCE_MESSAGE1	Remittance message for use in payment processing.	No
Remittance Message 2	REMITTANCE_MESSAGE2	Remittance message for use in payment processing.	No
Remittance Message 3	REMITTANCE_MESSAGE3	Remittance message for use in payment processing.	No
Second Discount Amount	SECOND_DISC_AMT_AVAILABLE	Discount amount available at second discount date.	No
Second Discount Date	SECOND_DISCOUNT_DATE	Date second discount is available.	No
Third Discount Amount	THIRD_DISC_AMT_AVAILABLE	Discount amount available at third discount date.	No
Third Discount Date	THIRD_DISCOUNT_DATE	Date third discount is available.	No

AP_PAYMENT_TEMPLATES

Object name on the Configure Business Object Attributes page: Payment Process Request Templates

The AP_PAYMENT_TEMPLATES contains the user defined Payment Process Request Templates. AP_PAYMENT_TEMPLATES_ is the audit table for AP_PAYMENT_TEMPLATES. The following table shows the fields that you can enable for auditing.

Audit Attribute	Table Column	Description	Audit-Enabled by Default
Template ID	TEMPLATE_ID	System generated primary key for payment template.	No
Name	TEMPLATE_NAME	Payment Process Request Template Name	No
Type	TEMPLATE_TYPE	Payment Process Request Template Type. Values, from the lookup PAYMENT_TEMPLATE_TYPE	No
Description	DESCRIPTION	Payment Process Request Template Description	No
Inactive Date	INACTIVE_DATE	End Date for the Payment Process Request Template	No
Pay from Days	ADDL_PAY_FROM_DAYS	Number of pay from days defined in the payment template. The value can be either zero or a positive number.	No
Pay Through Days	ADDL_PAY_THRU_DAYS	End date in a date range that indicates the date until when the invoices are selected.	No
To Payment Priority	HI_PAYMENT_PRIORITY	Highest payment priority of the documents to select	No
From Payment Priority	LOW_PAYMENT_PRIORITY	Lowest payment priority of the documents to select	No
Date Basis	PAY_ONLY_WHEN_DUE_FLAG	Option that indicates if documents will be selected by their due date only (Y or N)	No
Include Zero Amount Invoices	ZERO_INV_ALLOWED_FLAG	Option indicating whether scheduled payments with zero amount remaining will be selected during a pay run	No
Supplier Type	VENDOR_TYPE_LOOKUP_CODE	Supplier Type. Based on PO Lookup Type VENDOR TYPES	No
Supplier	VENDOR_ID	Unique supplier identifier from the supplier tables.	No
Party	PARTY_ID	Party identifier of the payment template.	No
Payment Method	PAYMENT_METHOD_CODE	Indicates the payment methods, such as check, cash, or credit.	No
Invoice Conversion Rate Type	INV_EXCHANGE_RATE_TYPE	Type of conversion rate between the payment and your ledger currency.	No
Pay Group Selection Criteria	PAY_GROUP_OPTION	Pay Group Options, All and Specify	No
Currency Selection Criteria	CURRENCY_GROUP_OPTION	Currency Options, All and Specify	No
Legal Entity Selection Criteria	LE_GROUP_OPTION	Legal Entity Options, All and Specify	No
Business Unit Selection Criteria	OU_GROUP_OPTION	Business Unit Options, All and Specify	No
Payment Date	PAYMENT_DATE_OPTION	Payment Date Options, Same as the Request Date, Extra Days	No
Additional Payment Days	ADDL_PAYMENT_DAYS	Extra payment days in the payment template.	No
Disbursement Bank Account	BANK_ACCOUNT_ID	The Internal bank account identifier	No
Bank Charge Bearer Override	BANK_CHARGE_BEARER	Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER	No
Settlement Priority Override	SETTLEMENT_PRIORITY	Overrides the invoice value for Oracle Payments' bank charges feature.	No
Starting Voucher Number	FIRST_VOUCHER_NUMBER	First available voucher number in document sequence for payment batch document category	No
Transfer Priority	TRANSFER_PRIORITY	Transfer priority defined in payment template. This can be express, normal, and any.	No
Payment Conversion Rate Type	PAYMENT_EXCHANGE_RATE_TYPE	Exchange rate type for a foreign currency payment	No
Payment Process Profile	PAYMENT_PROFILE_ID	Payment process profile identifier	No
Apply credits up to zero amount payment	ZERO_AMOUNTS_ALLOWED	Option indicating whether zero payments allowed in run. Helps in Maximizing credits	No
Review installments	PAYABLES_REVIEW_SETTINGS	Stop Process for Review After Invoice Selection	No
Calculate Withholding and Interest	CALC_AWT_INT_FLAG	Option to indicate Calculate Payment Withholding and Interest During Scheduled Payment Selection	No
Review proposed payments	PAYMENTS_REVIEW_SETTINGS	If this check box is selected, the Build Payments program runs to group the invoices into payments and the pay run pauses after payments have been built to allow you to review the proposed payments.	No
Create payment files immediately	CREATE_INSTRS_FLAG	Payment Instruction Creation Program. This setting requires the user to select a payment process profile. This setting will also ensure that payments from this payment process request aren't combined with payments from other payment process requests when the application creates the payment instructions	No
Document	DOCUMENT_REJECTION_LEVEL_CODE	Indicates the validation failure handling option for payable documents. Possible values are: Reject All Documents for Payee, Reject All Documents in Request, Stop Process for Review	No
Payment	PAYMENT_REJECTION_LEVEL_CODE	Document used to pay an invoice.	No
Attribute Category	ATTRIBUTE_CATEGORY	Descriptive Flexfield: structure definition of the user descriptive flexfield.	No
Attribute 1	ATTRIBUTE1	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 2	ATTRIBUTE2	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 3	ATTRIBUTE3	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 4	ATTRIBUTE4	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 5	ATTRIBUTE5	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 6	ATTRIBUTE6	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 7	ATTRIBUTE7	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 8	ATTRIBUTE8	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 9	ATTRIBUTE9	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 10	ATTRIBUTE10	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 11	ATTRIBUTE11	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 12	ATTRIBUTE12	Descriptive Flexfield: segment of the user descriptive flexfield.	No
Attribute 13