3Payables Configuration
This chapter contains the following:
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.
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.

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.
-
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.

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.
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:
|
Creating Payment Terms Based on Days
-
Navigate to the Manage Payment Terms page.
-
Click Create to open the Create Payment Terms page.
-
In the Name field, enter the payment term name.
-
Click Add Row in the Installments section to create the first installment.
-
Complete the fields, as shown in this table.
Field Value Due Percent
40
Days
10
First Discount Percent
5
First Discount Days
7
-
Click Add Row in the Installments section to create the second installment.
-
Complete the fields, as shown in this table.
Field Value Due Percent
35
Days
20
First Discount Percent
3
First Discount Days
15
-
Click Add Row in the Installments section to create the third installment.
-
Complete the fields, as shown in this table.
Field Value Due Percent
25
Days
30
First Discount Percent
2
First Discount Days
25
-
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.
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.
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. |
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
-
In the Suppliers work area, click Create Supplier.
-
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.
-
Defining the Relationship Between the Third Party and the Supplier
-
In the Suppliers work area, click Manage Suppliers.
-
Search for the supplier on whose behalf the third party receives payment.
-
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.
(Optional) Setting the Remit-to Supplier Override Option
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Payables
-
Task: Manage Invoice Options, with the business unit scope set
-
Click Apply and Go to Task.
-
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
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Payables
-
Task: Manage Payment Options, with the business unit scope set
-
Click Apply and Go to Task.
-
Select the Allow payee override for third-party payments option to allow override of the payee on the 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.
- 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 Setup Business Objects
- 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
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.