3Payables Configuration

This chapter contains the following:

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

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

A distribution set can include:

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

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

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

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

Distribution Sets with Percentages

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

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

Distribution Sets Without Percentages

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

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

This graphic displays the Payment term components.

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

Payment Terms Due Dates and Discount Dates

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

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

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

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

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

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

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

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

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

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

Default Payment Terms

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

This figure shows how payment terms flow to the invoice.

This graphic displays the Payment terms flow for
an invoice.

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.

This graphic displays the Payment terms set assignment.

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

Setting up Payment Terms for Reference Data Sharing

The setup for payment term reference data sharing includes:

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

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

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

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

Tip: Before you define common options for Payables and Procurement, you must assign the Immediate payment term to the reference data set for the business unit.
Note: You can assign a payment term to the predefined common set, which works like any other set. Unless you assign the payment term to other reference data sets, that payment term is available only to the business units with the common set.

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

This table summarizes key decisions for the scenario.

Decisions to Consider In This Example

Are terms based on amounts or percentages?

Percentages

What are the due dates and discounts?

The due dates and discounts are as follows:

  • First installment: 40 percent due in 10 days, with a discount of 5 percent if paid in 7 days

  • Second installment: 35 percent due in 20 days, with a discount of 3 percent if paid in 15 days

  • Third installment: 25 percent due in 30 days, with a discount of 2 percent if paid in 25 days

Creating Payment Terms Based on Days

  1. Navigate to the Manage Payment Terms page.

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

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

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

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

    Field Value

    Due Percent

    40

    Days

    10

    First Discount Percent

    5

    First Discount Days

    7

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

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

    Field Value

    Due Percent

    35

    Days

    20

    First Discount Percent

    3

    First Discount Days

    15

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

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

    Field Value

    Due Percent

    25

    Days

    30

    First Discount Percent

    2

    First Discount Days

    25

  10. Click Save.

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

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

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

Quantity-Based Tolerances

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

This table describes each quantity-based tolerance.

Tolerance Description

Ordered Percentage

The percentage difference more than the ordered quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the ordered quantity without considering price.

Maximum Ordered

The quantity difference more than the ordered quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the ordered quantity without considering price. You can use this tolerance if most of your purchase orders have the same relative value.

Received Percentage

The percentage difference more than the received quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the received quantity without considering price.

Maximum Received

The quantity difference more than the received quantity on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed quantity against the received quantity without considering price. You can use this tolerance if most of your purchase orders have the same relative value.

Price Percentage

The percentage difference more than the unit price on a purchase order schedule line that you allow suppliers to invoice.

Conversion Rate Amount

The variance that you allow between an invoice amount and the amount of a purchase order schedule. Validation compares the ledger currency amounts, using the invoice and purchase order conversion rates, respectively. You can use this tolerance if you create foreign currency invoices.

Schedule Amount

The variance that you allow between all invoice amounts in the entered currency and the purchase order schedule amount.

Total Amount

The total variance that you allow for both the Conversion Rate Amount and Schedule Amount tolerances combined. You can use this tolerance if you create foreign currency invoices.

Consumed Percentage

The percentage difference more than the consumed quantity on a consumption advice that you allow suppliers to invoice. Validation checks the billed quantity against the consumed quantity without considering price.

Maximum Consumed

The quantity difference more than the consumed quantity on a consumption advice that you allow suppliers to invoice. Validation checks the billed quantity against the consumed quantity without considering price.

Amount-Based Tolerances

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

This table describes each amount-based tolerance.

Tolerance Description

Ordered Percentage

The percentage difference more than the ordered amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the ordered amount.

Maximum Ordered

The amount difference more than the ordered amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the ordered amount.

Received Percentage

The percentage difference more than the received amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the received amount.

Maximum Received

The amount difference more than the received amount on a purchase order schedule line that you allow suppliers to invoice. Validation checks the billed amount against the received amount.

Conversion Rate Amount

The variance that you allow between the invoice amount and the amount on a purchase order schedule. Validation compares the ledger currency amounts, using the invoice and purchase order conversion rates, respectively. You can use this tolerance if you create foreign currency invoices.

Total Amount

The total variance that you allow for both the Conversion Rate Amount and Schedule Amount tolerances combined. You can use this tolerance if you create foreign currency invoices.

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

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

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

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

Hold Types

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

Hold Type Allows User-Defined Holds?

Account Hold Reason

No

Future Period Hold Type

No

Insufficient Information

No

Invoice Hold Reason

Yes

Invoice Line Reason

Yes

Matching Hold Reason

No

Variance Hold Reason

No

Release Types

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

Release Type Allows User-Defined Releases?

Account Release Reason

No

Future Period Release

No

Hold Quick Release Reason

Yes

Invoice Quick Release Reason

Yes

Invoice Release Reason

Yes

Matching Release Reason

Yes

Sufficient Information

No

Variance Release Reason

Yes

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.

You can define a Payables calendar to generate periods automatically.

Settings That Affect Period Generation

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

  • Period frequency

  • Periods per year

  • Start date

  • Period name format

How Periods Are Generated

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

Calendar Attribute Description

Period frequency

Type of period, such as Monthly or 5-4-4.

Note: If you select Other, you must enter periods manually

Periods per year

Calculated number of periods per year.

Start date

First day of the calendar and start date of the first period.

Period name format

Naming convention for periods.

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

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

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

  • Period frequency of 4-4-5

  • Start date of 1/1/2015

  • Period name format of MMM

Period Name Prefix Year Sequence Start Date End Date Period Name

Jan

2015

1

1/1/15

1/28/15

Jan-15

Feb

2015

2

1/29/15

2/25/15

Feb-15

Mar

2015

3

2/26/15

4/1/15

Mar-15

Apr

2015

4

4/2/15

4/29/15

Apr-15

May

2015

5

4/30/15

5/27/15

May-15

Jun

2015

6

5/28/15

7/1/15

Jun-15

Jul

2015

7

7/2/15

7/29/15

Jul-15

Aug

2015

8

7/30/15

8/26/15

Aug-15

Sep

2015

9

8/27/15

9/30/15

Sep-15

Oct

2015

10

10/1/15

10/28/15

Oct-15

Nov

2015

11

10/29/15

11/25/15

Nov-15

Dec

2015

12

11/26/15

12/30/15

Dec-15

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

Creating the Third Party

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

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

    • Set the Address Purpose field to Remit to.

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

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

Defining the Relationship Between the Third Party and the Supplier

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

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

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

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

    Attribute Description

    Remit-to Supplier

    Enter the party designated to receive payment on behalf of the supplier on the invoice.

    Address Name

    Enter the address of the party designated to receive payment on behalf of the supplier on the invoice.

    From Date, To Date

    Specify an inclusive date range for the relationship. When you create an invoice or payment, the invoice and payment dates are used to identify valid third-party payment relationships for the supplier site.

    Note: When you end date an existing relationship, you must review all unpaid or partially paid invoices for that relationship.

    Description

    Enter text to include in the payment file. For example, you can enter text to print on the payment document as reference information.

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

(Optional) Setting the Remit-to Supplier Override Option

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

  2. Offering: Financials

  3. Functional Area: Payables

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

  5. Click Apply and Go to Task.

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

(Optional) Setting the Payee Override Option

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

  2. Offering: Financials

  3. Functional Area: Payables

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

  5. Click Apply and Go to Task.

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

Auditing Payables Business Objects

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

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

Payables Setup Business Objects

AP_SYSTEM_PARAMETERS_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Create interest invoices

AUTO_CALCULATE_INTEREST_FLAG

Option that indicates whether interest invoices are automatically created for past due invoice payments (Y or N).

Yes

Invoice Currency

INVOICE_CURRENCY_CODE

Default invoice currency code that defaults on the supplier sites associated with the business unit.

Yes

Always take discount

ALWAYS_TAKE_DISC_FLAG

Option that indicates if an available discount for a supplier will be taken, regardless of when the invoice is paid (Y or N).

Yes

Accounting Date Basis

GL_DATE_FROM_RECEIPT_FLAG

Date used as the accounting date during invoice entry.

No

Exclude tax from calculation

DISC_IS_INV_LESS_TAX_FLAG

Option that indicates if tax amount excluded from invoice amount when invoice amount applicable to discount calculated (Y or N).

Yes

Allow payment date before the system date

POST_DATED_PAYMENTS_FLAG

Option that indicates if the payment date can be prior to system date (Y or N).

Yes

Minimum interest amount

INTEREST_TOLERANCE_AMOUNT

Minimum interest amount owed on past due invoice for interest invoice to be automatically created.

Yes

Interest Expense Distribution

INTEREST_CODE_COMBINATION_ID

Accounting Flexfield identifier for interest expense account.

Yes

Discount Allocation Method

DISCOUNT_DISTRIBUTION_METHOD

Method for distributing discount amounts taken on invoice payments.

Yes

Use combined filing program

COMBINED_FILING_FLAG

Option that indicates whether your organization participates in the Combined Filing Program for income tax reporting.

Yes

Income Tax Region

INCOME_TAX_REGION

Default income tax region assigned to invoice lines for 1099 suppliers.

Yes

Use supplier tax region

INCOME_TAX_REGION_FLAG

A value of Y indicates that you use supplier tax region as the default Income Tax Region for 1099. invoice lines.

Yes

Allow Final Matching

ALLOW_FINAL_MATCH_FLAG

Option that indicates whether you allow final matching to purchase orders.

Yes

Allow Matching distribution override

ALLOW_FLEX_OVERRIDE_FLAG

Option that indicates whether you can override the matching Accounting Flexfield for an invoice distribution matched to a purchase order distribution line.

Yes

Allow adjustments to paid invoices

ALLOW_PAID_INVOICE_ADJUST

Option that indicates whether you allow adjustments to paid invoices.

Yes

Allow document category override

INV_DOC_CATEGORY_OVERRIDE

Option that indicates whether you can override the default document category (Sequential Numbering) for invoices.

Yes

Transfer PO distribution additional information

TRANSFER_DESC_FLEX_FLAG

A value of Y indicates the application will transfer descriptive flexfield information from a purchase order shipment to an invoice line and from the purchase order distribution to an invoice distribution during purchase order matching.

Yes

Use withholding tax

ALLOW_AWT_FLAG

Option to indicate whether Automatic Withholding Tax is allowed (Y or N).

Yes

Withholding Tax Group

DEFAULT_AWT_GROUP_ID

Default Withholding Tax group for new suppliers.

Yes

Allow manual withholding

ALLOW_AWT_OVERRIDE

Option to indicate whether override of withholding tax amount is allowed (Y, N, null).

Yes

Apply withholding tax

CREATE_AWT_DISTS_TYPE

Indicates when the application should automatically create withholding tax invoices. Possible values are Never, Validation, or Payment.

Yes

Create Withholding Invoice

CREATE_AWT_INVOICES_TYPE

Indicates when the application should automatically create withholding tax invoices (Never, Invoice Validation, Payment).

Yes

Withholding Amount Basis to include discount amount

AWT_INCLUDE_DISCOUNT_AMT

Option to indicate whether the discount amount is included in withholding tax calculation.

Yes

Withholding Amount Basis to include tax amount

AWT_INCLUDE_TAX_AMT

Option to indicate whether the tax amount is included in the withholding tax calculation.

Yes

Allow override of supplier site bank account

ALLOW_SUPPLIER_BANK_OVERRIDE

Option to indicate whether user can charge remit-to bank at payment creation time.

Yes

Account for Payment

WHEN_TO_ACCOUNT_PMT

Defines when accounting entries for payments will be created.

Yes

Enable invoice approval

APPROVAL_WORKFLOW_FLAG

Select this check box value to enable invoice approval.

Yes

Allow Force Approval

ALLOW_FORCE_APPROVAL_FLAG

Select this check box value if you use the Invoice Approval Workflow Program and want to allow accounts payable processors to override the workflow and manually approve invoices.

Yes

Include withholding distributions in income tax reports

ENABLE_1099_ON_AWT_FLAG

Select this check box value is you want to include Withholding Distribution in Income Tax Reports.

Yes

Quantity Tolerances

TOLERANCE_ID

A unique identifier for tolerance template that's used for goods tolerance.

Yes

Amount Tolerances

SERVICES_TOLERANCE_ID

Services tolerance template identifier.

Yes

Receipt Acceptance Days

RECEIPT_ACCEPTANCE_DAYS

Number of days in receipt acceptance period.

Yes

Exclude Freight from Discount

EXCLUDE_FREIGHT_FROM_DISCOUNT

Exclude Freight From Discount Identifier.

Yes

Interest Allocation Method

PRORATE_INT_INV_ACROSS_DISTS

Used to display the 'Interest' Allocation method in Accounting Option label.

Yes

Allow Unit Price change for Quantity-Based Matches

SS_UPRICE_CHANGE_FOR_QTYMATCH

Setting that indicates whether unit price change is allowed for purchase order matched self-service invoice.

Yes

Allow invoice backdating

SS_INVOICE_BACKDATING_FLAG

Indicates whether a self-service invoice can have invoice date prior to system date.

Yes

Self Service Invoices to limit invoices to a single purchase order

SS_LIMIT_TO_SINGLE_PO_FLAG

Indicates whether a self-service invoice can be matched to multiple purchase orders.

Yes

Require Invoice Grouping

REQUIRE_INVOICE_GROUP_FLAG

Setting that indicates whether invoice group is mandatory during invoice entry.

Yes

Recalculate invoice installments

RECALC_PAY_SCHEDULE_FLAG

Option that indicates whether Recalculate Payment Installments (Y or N).

Yes

Budget Date Basis

BUDGET_DATE_BASIS

Budget Date Basis to default the budget date on invoice transactions.

Yes

FINANCIALS_SYSTEM_PARAMS_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Bill-to Location

BILL_TO_LOCATION_ID

Bill-to location identifier, default used during supplier entry.

Yes

Liability Distribution

ACCTS_PAY_CODE_COMBINATION_ID

Accounting Flexfield identifier for the accounts payable liability account and default used during supplier entry.

Yes

Prepayment Distribution

PREPAY_CODE_COMBINATION_ID

Accounting Flexfield identifier for the prepayment account and default used during supplier entry.

Yes

Discount Taken Distribution

DISC_TAKEN_CODE_COMBINATION_ID

Accounting Flexfield identifier for the discount taken account.

Yes

VAT Registration Number

VAT_REGISTRATION_NUM

Value-Added Tax registration number for your organization.

Yes

VAT Registration Member State

VAT_COUNTRY_CODE

European Union (EU) member state for your organization.

Yes

Conversion Rate Variance Gain

RATE_VAR_GAIN_CCID

Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders.

Yes

Conversion Rate Variance Loss

RATE_VAR_LOSS_CCID

Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase orders.

Yes

Bill Payable Distribution

FUTURE_DATED_PAYMENT_CCID

Accounting Flexfield identifier for future dated payment account default for Suppliers and Bank accounts.

Yes

Miscellaneous Distribution

MISC_CHARGE_CCID

Accounting flexfield identifier for the accounts payable miscellaneous account, which is used for supplier portal Invoices.

Yes

Buying Company Identifier

BUYING_COMPANY_IDENTIFIER

A unique identifier that identifies the buying business unit. The identifier is included on the invoice number of invoices created by the pay on receipt process or debit memos from return on receipt transactions.

Yes

Expense Accrual Distributions

EXPENSE_ACCRUAL_CCID

Expense Accrual Account Code Combination Identifier.

Yes

Gapless Invoice Numbering

GAPLESS_INV_NUM_FLAG

Gapless Invoice Numbering Option.

Yes

Accrue Expense Items

EXPENSE_ACCRUAL_CODE

Defines accrue expense items options.

Yes

Conversion Rate type

DEFAULT_EXCHANGE_RATE_TYPE

Specifies the default conversion rate type when you enter invoices or create payments.

Yes

Automatic Offsets

AUTOMATIC_OFFSETS_FLAG

An option that allows overriding of either the primary balancing segment or all segments, except the natural account segment when creating the liability account.

Yes

Realized Gain Distribution

GAIN_CODE_COMBINATION_ID

Accounting Flexfield identifier for account to which realized exchange rate gains are posted.

Yes

Realized Loss Distribution

LOSS_CODE_COMBINATION_ID

Accounting Flexfield identifier for account to which realized exchange rate losses are posted.

Yes

Require conversion rate entry

MAKE_RATE_MANDATORY_FLAG

Option that indicates if exchange rates must be entered for multiple currency invoices and payments (Y or N).

Yes

Freight Distribution

FREIGHT_CODE_COMBINATION_ID

Accounting Flexfield identifier for accounts payable freight account.

Yes

Prepayment Tax Difference

PREPAY_TAX_DIFF_CCID

Account to which any prepayment tax difference amount will be charged.

Yes

Require Conversion Rate Entry

MAKE_RATE_MANDATORY_PMT_FLAG

Require Conversion Rate Information for Payments.

No

Payment Conversion Rate Type

DEFAULT_PMT_EXCHANGE_RATE_TYPE

Payment Conversion Rate Type.

No

AP_TOLERANCE_TEMPLATES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

TOLERANCE_NAME

Name of the tolerance template.

Yes

Description

DESCRIPTION

Description of the tolerance template.

No

Price Percentage

PRICE_TOLERANCE

Percentage based tolerance level for price variance.

Yes

Ordered Percentage

QUANTITY_TOLERANCE

Percentage based tolerance level for quantity variance.

Yes

Received Percentage

QTY_RECEIVED_TOLERANCE

Percentage based tolerance level for quantity received tolerance.

Yes

Maximum Ordered

MAX_QTY_ORD_TOLERANCE

Tolerance level for maximum quantity ordered variance.

Yes

Maximum Received

MAX_QTY_REC_TOLERANCE

Tolerance level for maximum quantity received variance.

Yes

Schedule Amount

SHIP_AMT_TOLERANCE

Tolerance level for purchase order shipment amount variance

Yes

Conversion Rate Amount

RATE_AMT_TOLERANCE

Tolerance level for exchange rate amount variance.

Yes

Total Amount

TOTAL_AMT_TOLERANCE

Tolerance level for total amount variance.

Yes

Type

TOLERANCE_TYPE

Designates the type of tolerance template as either Goods or Services.

Yes

Consumed Percentage

QTY_CONSUMED_TOLERANCE

Tolerance level for comparison of billed quantity with consumed quantity expressed as a percentage.

Yes

Maximum Consumed

MAX_QTY_CON_TOLERANCE

Tolerance level for comparison of billed quantity with consumed quantity expressed as an absolute value.

Yes

AP_REPORTING_ENTITIES_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Taxpayer ID

TAX_IDENTIFICATION_NUM

Tax identification number for reporting entity.

Yes

Name

ENTITY_NAME

Name of the reporting entity for tax reporting.

Yes

Location

LOCATION_ID

Location identifier for reporting entity.

Yes

Business Unit

ORG_ID

Indicates the identifier of the business unit associated to the row.

Yes

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

AP_REPORTING_ENTITY_LINES_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Primary Balancing Segment Value

BALANCING_SEGMENT_VALUE

Balancing segment value for reporting entity Accounting Flexfield.

Yes

Business Unit

ORG_ID

Indicates the identifier of the business unit associated to the row.

Yes

AP_BANK_CHARGES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Transferring Bank Branch ID

TRANSFERRING_BANK_BRANCH_ID

Transferring bank branch identifier.

Yes

Transferring Bank Name

TRANSFERRING_BANK_NAME

Bank of customer, which transfers payment to supplier bank.

Yes

Transferring Bank Option

TRANSFERRING_BANK

Transferring bank. Valid values are ONE for specific bank and ALL when bank charge is applicable to all transferring banks.

Yes

Transferring Branch Option

TRANSFERRING_BRANCH

Transferring branch. Valid values are ONE for specific branch and ALL when bank charge is applicable to all transferring branches of transferring bank specified.

Yes

Receiving Bank Branch ID

RECEIVING_BANK_BRANCH_ID

Receiving bank branch identifier.

Yes

Receiving Bank Name

RECEIVING_BANK_NAME

Bank of supplier, which receives payment from customer bank.

Yes

Receiving Bank Option

RECEIVING_BANK

Receiving branch. Valid values are ONE for specific bank, ALL for when charge is applicable to all receiving banks, and OTHER for bank other than the transferring bank.

Yes

Receiving Branch Option

RECEIVING_BRANCH

Receiving branch. Valid values are ONE for specific branch, ALL for when charge is applicable to all receiving branches, and OTHER for branch other than the transferring branch.

Yes

Settlement Priority

SETTLEMENT_PRIORITY

Settlement priority. Valid values are EXPRESS and NORMAL.

Yes

Currency

CURRENCY_CODE

Currency used to define bank charges.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 1

ATTRIBUTE_NUMBER1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 2

ATTRIBUTE_NUMBER2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 3

ATTRIBUTE_NUMBER3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 4

ATTRIBUTE_NUMBER4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 5

ATTRIBUTE_NUMBER5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 1

ATTRIBUTE_DATE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 2

ATTRIBUTE_DATE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 3

ATTRIBUTE_DATE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 4

ATTRIBUTE_DATE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 5

ATTRIBUTE_DATE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Legal Entity

LEGAL_ENTITY_ID

Legal entity identifier.

Yes

AP_BANK_CHARGE_LINES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

From Payment Amount

TRANS_AMOUNT_FROM

The end payment amount (lower amount) for given amount range.

Yes

To Payment Amount

TRANS_AMOUNT_TO

The start payment amount (higher amount) for given amount range.

Yes

Standard Bank Charge Amount

BANK_CHARGE_STANDARD

The bank charge amount at standard rate.

Yes

Negotiated Bank Charge Amount

BANK_CHARGE_NEGOTIATED

The bank charge amount at negotiated rate.

Yes

From Date

START_DATE

The start date to apply the bank charge at the specified amount.

Yes

To Date

END_DATE

The end date to apply the bank charge at the specified amount.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 1

ATTRIBUTE_NUMBER1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 2

ATTRIBUTE_NUMBER2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 3

ATTRIBUTE_NUMBER3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 4

ATTRIBUTE_NUMBER4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Number 5

ATTRIBUTE_NUMBER5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 1

ATTRIBUTE_DATE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 2

ATTRIBUTE_DATE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 3

ATTRIBUTE_DATE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 4

ATTRIBUTE_DATE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute Date 5

ATTRIBUTE_DATE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

AP_INTEREST_PERIODS

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Rate

ANNUAL_INTEREST_RATE

Interest rate applicable for a given period.

Yes

From Date

START_DATE

Start date of a given interest period.

Yes

To Date

END_DATE

End date of a given interest period.

Yes

AP_TERMS_B

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

TERM_ID

A unique identifier for the payment term.

Yes

From Date

START_DATE_ACTIVE

Date from which payment term is valid.

Yes

To Date

END_DATE_ACTIVE

Date after which payment term is invalid.

Yes

Cutoff Day

DUE_CUTOFF_DAY

Used for certain terms only, day of a month after which Oracle Fusion Payables schedules payment using a day after the current month.

Yes

Rank

RANK

Unique rank to rate invoice payment terms against purchase order payment terms in accordance with Prompt Payment Act.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

AP_TERMS_LINES

Object name on the Configure Business Object Attributes page: Installments

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

TERM_ID

A unique identifier for the payment term.

Yes

Sequence Number

SEQUENCE_NUM

Number of the payment term line.

Yes

Due Percentage

DUE_PERCENT

Percentage of payment due by a certain date.

Yes

Amount Due

DUE_AMOUNT

Maximum of payment amount due by a certain date.

Yes

Days

DUE_DAYS

Number of days after terms date, used to calculate due date of invoice payment line.

Yes

Day of Month

DUE_DAY_OF_MONTH

Day of month used to calculate due date of invoice payment line.

Yes

Months Ahead

DUE_MONTHS_FORWARD

Number of months ahead, used to calculate due date of invoice payment line.

Yes

First Discount Percentage

DISCOUNT_PERCENT

Percentage used to calculate discount available for invoice payment line.

Yes

First Discount Days

DISCOUNT_DAYS

Number of days after terms date, used to calculate discount date for invoice payment line.

Yes

First Discount Day of Month

DISCOUNT_DAY_OF_MONTH

Day of month used to calculate discount date for invoice payment line.

Yes

First Discount Months Ahead

DISCOUNT_MONTHS_FORWARD

Number of months ahead used to calculate discount date for invoice payment line.

Yes

Second Discount Percentage

DISCOUNT_PERCENT_2

Percentage used to calculate second discount available for invoice payment line.

Yes

Second Discount Days

DISCOUNT_DAYS_2

Number of days after terms date, used to calculate second discount available for invoice payment line

Yes

Second Discount Day of Month

DISCOUNT_DAY_OF_MONTH_2

Day of month used to calculate second discount available for invoice payment line.

Yes

Second Discount Months Ahead

DISCOUNT_MONTHS_FORWARD_2

Number of months ahead, used to calculate discount available for invoice payment line.

Yes

Third Discount Percentage

DISCOUNT_PERCENT_3

Percentage used to calculate third discount available for invoice payment line.

Yes

Third Discount Days

DISCOUNT_DAYS_3

Number of days after terms date, used to calculate third discount for invoice payment line.

Yes

Third Discount Day of Month

DISCOUNT_DAY_OF_MONTH_3

Day of month used to calculate third discount for invoice payment line.

Yes

Third Discount Months Ahead

DISCOUNT_MONTHS_FORWARD_3

Number of months ahead, used to calculate third discount for invoice payment line.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Fixed Date

FIXED_DATE

Payment term attribute that indicates the payment due date.

Yes

Calendar

CALENDAR

Name of special calendar associated with the term line.

Yes

AP_TERMS_ST

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

TERM_ID

Payment term unique identifier.

Yes

Set Code

SET_ID

Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they're used to filter reference data in transactional UIs.

Yes

AP_HOLD_CODES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

HOLD_LOOKUP_CODE

Name of the hold code created to be applied on an invoice.

Yes

Type

HOLD_TYPE

Hold type that's to be applied on an invoice.

Yes

Allow Manual Release

USER_RELEASEABLE_FLAG

Indicates if a hold can be released by a user (Y or N).

Yes

Inactive Date

INACTIVE_DATE

Date when the hold will be inactive.

Yes

Allow Accounting

POSTABLE_FLAG

Indicates whether this hold should prevent the invoice from being accounted.

Yes

Hold Instruction

HOLD_INSTRUCTION

Instruction to resolve the hold.

Yes

Days Before Notifying

WAIT_BEFORE_NOTIFY_DAYS

Specify the number of days to wait before sending the notification.

Yes

Days Before Reminding

REMINDER_DAYS

Specify the number of days to wait before sending the reminder notification.

Yes

Allow Holds Resolution Routing

INITIATE_WORKFLOW_FLAG

Enable this to initiate the Hold Negotiation Workflow for the hold.

Yes

AP_DISTRIBUTION_SETS_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

DISTRIBUTION_SET_NAME

Name of invoice distribution set created.

Yes

Description

DESCRIPTION

Description of invoice distribution set created.

Yes

Distribution Percentage

TOTAL_PERCENT_DISTRIBUTION

Sum of the distribution percents for each of the distribution set lines.

Yes

Inactive Date

INACTIVE_DATE

Date by when the distribution set will become inactive.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Business Unit

ORG_ID

Indicates the identifier of the business unit associated to the row.

Yes

AP_DISTRIBUTION_SET_LINES_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Distribution Combination

DIST_CODE_COMBINATION_ID

Accounting Flexfield identifier for account associated with Distribution Set line.

Yes

Distribution

PERCENT_DISTRIBUTION

Percent of invoice amount to allocate to Distribution Set line.

Yes

Income Tax Type

TYPE_1099

Type of 1099 tax associated with distribution line.

Yes

Description

DESCRIPTION

Description of distribution set line.

No

Line

DISTRIBUTION_SET_LINE_NUMBER

Invoice Distribution Set line identifier.

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Project Accounting Context

PROJECT_ACCOUNTING_CONTEXT

Oracle Fusion Projects Descriptive Flexfield context column.

No

Task Number

TASK_ID

Identifier for project task used to build Accounting Flexfield for Distribution Set line.

No

Project Number

PROJECT_ID

Identifier for project used to build Accounting Flexfield for Distribution Set line.

No

Expenditure Organization

EXPENDITURE_ORGANIZATION_ID

Identifier for project organization used to build Accounting Flexfield for Distribution Set line

No

Expenditure Type

EXPENDITURE_TYPE

Project expenditure type used to build Accounting Flexfield for Distribution Set line.

No

Business Unit

ORG_ID

Indicates the identifier of the business unit associated to the row.

Yes

Award Number

AWARD_ID

If Oracle Fusion Grants Accounting is installed, the award ID is used with data in project columns to track grant information.

No

AP_AGING_PERIODS

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Aging Period ID

AGING_PERIOD_ID

Unique identifier of aging period defined in application.

Yes

Name

PERIOD_NAME

Name of aging period defined in system.

Yes

Description

DESCRIPTION

Description of aging period defined.

No

Active

STATUS

Status of aging period.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

AP_AGING_PERIOD_LINES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Aging Period Line ID

AGING_PERIOD_LINE_ID

Unique identifier of aging period line defined as part of aging period setup.

Yes

Column Order

PERIOD_SEQUENCE_NUM

Order of this particular date range within the entire period.

Yes

From

DAYS_START

Starting day number for aging period line.

Yes

To

DAYS_TO

Ending day number for aging period line.

Yes

First

REPORT_HEADING1

First column heading for aging period line.

Yes

Second

REPORT_HEADING2

Second column heading for aging period line.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

AP_INCOME_TAX_REGIONS

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

State

REGION_SHORT_NAME

Abbreviated income tax region name (identifies income tax region for 1099 supplier sites).

Yes

Description

REGION_LONG_NAME

Full name of income tax region applicable for 1099 taxes.

Yes

Code

REGION_CODE

Region code for income tax regions participating in the Combined Filing Program.

Yes

Amount

REPORTING_LIMIT

Minimum reporting amount for income tax region participating in the Combined Filing Program.

Yes

From Date

ACTIVE_DATE

Date from when the income tax region is active.

Yes

To Date

INACTIVE_DATE

Date income tax region inactive.

Yes

Method

REPORTING_LIMIT_METHOD_CODE

Method for calculating reporting limit for region.

Yes

AP_OTHER_PERIOD_TYPES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Name

CALENDAR_NAME

Name given to a calendar that's used in Oracle Fusion Payables.

Yes

To Date

EFFECTIVE_TO

Effective To date of the calendar.

Yes

From Date

EFFECTIVE_FROM

Effective From date of the calendar.

Yes

Calendar Type

CALENDAR_TYPE

Type of the calendar, either GENERAL or PAYMENT TERMS.

Yes

Description

DESCRIPTION

Statement, picture in words, or account that describes; descriptive representation.

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

AP_OTHER_PERIODS

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Start Date

START_DATE

Date from when a record isn't available for transacting. Use date enabled entities when history isn't stored.

Yes

End Date

END_DATE

Date from when a record isn't available for transacting. Use date enabled entities when history isn't stored.

Yes

Sequence

PERIOD_NUM

Order of periods within a payables calendar.

Yes

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Due Date

DUE_DATE

Date associated with a payables calendar period that indicates when an invoice payment is due. This is only applicable to payables calendars with a type of payment terms.

Yes

Calendar Name

PERIOD_ID

Identifier of the created period.

Yes

Payables Transaction Business Objects

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

AP_INVOICES_INTERFACE

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Liability Distribution ID

ACCTS_PAY_CODE_COMBINATION_ID

Accounting Flexfield identifier for accounts payable liability account. If the identifier isn't available, use the ACCTS_PAY_CODE_CONCATENATED column. Validated against.GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.

No

Add Tax to Invoice Amount

ADD_TAX_TO_INV_AMT_FLAG

Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y, N, NULL.

No

Discountable Amount

AMOUNT_APPLICABLE_TO_DISCOUNT

Amount of invoice applicable to a discount. Not validated.

No

Application ID

APPLICATION_ID

Oracle internal use only. For Oracle Fusion applications interfacing to Oracle Fusion Payables.

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Withholding Tax Group ID

AWT_GROUP_ID

Withholding tax group identifier. If the identifier isn't available, use the AWT_GROUP_NAME column. Validated against AP_AWT_GROUPS.AWT_GROUP_ID.

No

Bank Charge Bearer

BANK_CHARGE_BEARER

Bearer of bank charge cost. Uses the Manage Payables Lookup task, lookup type BANK BEARER CHARGE to identify valid values.

No

Budget Date

BUDGET_DATE

Budgetary Calendar Period Date applicable for funds check.

No

Calculate Tax During Import

CALC_TAX_DURING_IMPORT_FLAG

Indicates whether tax should be calculated for the invoice during import. Valid values: Y,N, NULL.

No

Tax Control Amount

CONTROL_AMOUNT

Total tax amount. Cannot be more than the invoice amount.

No

Correction Period

CORRECTION_PERIOD

Correction period for the invoice being corrected. Not validated.

No

Correction Year

CORRECTION_YEAR

Correction year for the invoice. Valid format: four numbers. Example: 2010.

No

Delivery Channel

DELIVERY_CHANNEL_CODE

Information displayed for an electronic payment that instruct the bank about carrying out the payment. Example: print a check and hold it for collection by the payee. Use the Manage Payment Codes task to identify valid values. The corresponding Payment Code Type must be Delivery Channel.

No

Description

DESCRIPTION

Invoice description. Free text field. Not validated.

No

Document Category

DOC_CATEGORY_CODE

Sequential numbering (voucher number) document category. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE.

No

Document Subtype

DOCUMENT_SUB_TYPE

A document type required by a tax or governmental authority.

No

Conversion Date

EXCHANGE_DATE

Date exchange rate is effective. Usually the accounting date of the transaction. Date format: YYYY/MM/DD.

No

Conversion Rate

EXCHANGE_RATE

Exchange rate used for foreign currency invoices. User entered conversion rate. Not validated.

No

Conversion Rate Type

EXCHANGE_RATE_TYPE

Exchange rate type for foreign currency invoices. Use the Manage Conversion Rate Types task to identify valid values. Validated against GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE.

No

Pay Alone

EXCLUSIVE_PAYMENT_FLAG

Indicates whether to pay invoice on a separate payment document. Valid values: Y,N, NULL.

No

Remit-to Account

EXTERNAL_BANK_ACCOUNT_ID

External bank account identifier. Defaulted from supplier setup. Do not populate during interface.

No

First-Party Tax Registration ID

FIRST_PARTY_REGISTRATION_ID

First party tax registration identifier.

No

First-Party Tax Registration Number

FIRST_PARTY_REGISTRATION_NUM

First party tax registration number.

No

Accounting Date

GL_DATE

Default accounting date for invoice distributions. Date format: YYYY/MM/DD. The date must be in an open or future open accounting period.

No

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute Date 1

GLOBAL_ATTRIBUTE_DATE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Date 2

GLOBAL_ATTRIBUTE_DATE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Date 3

GLOBAL_ATTRIBUTE_DATE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Date 4

GLOBAL_ATTRIBUTE_DATE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Date 5

GLOBAL_ATTRIBUTE_DATE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Number 1

GLOBAL_ATTRIBUTE_NUMBER1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Number 2

GLOBAL_ATTRIBUTE_NUMBER2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Number 3

GLOBAL_ATTRIBUTE_NUMBER3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Number 4

GLOBAL_ATTRIBUTE_NUMBER4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute Number 5

GLOBAL_ATTRIBUTE_NUMBER5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Goods Received Date

GOODS_RECEIVED_DATE

Date when goods on the invoice were received. Date format: YYYY/MM/DD. Required if the terms date basis is Goods Received.

No

Invoice Amount

INVOICE_AMOUNT

Invoice amount in transaction currency. Should be positive for standard and prepayment invoices. Should be negative for credit memos.

No

Invoice Currency

INVOICE_CURRENCY_CODE

Currency of invoice. Use the Manage Currencies task to identify valid values. Use the three character ISO currency code. Example: US Dollars is USD.

No

Invoice Date

INVOICE_DATE

Invoice date used to calculate due date per payment terms. Date format: YYYY/MM/DD.

No

Invoice ID

INVOICE_ID

Invoice identifier. Must be unique.

No

Invoice Includes Prepayment

INVOICE_INCLUDES_PREPAY_FLAG

Prepayment included in invoice amount. Valid values: Y,N, NULL.

No

Invoice Number

INVOICE_NUM

Supplier invoice number. Validation: must be unique for the supplier site.

No

Invoice Received Date

INVOICE_RECEIVED_DATE

Date when the invoice was received. Also known as terms date. Date format: YYYY/MM/DD. Required if the terms date basis is Invoice Received Date.

No

Invoice Type

INVOICE_TYPE_LOOKUP_CODE

Type of invoice. Use the Manage Payables Lookups task, lookup type INVOICE TYPE to identify valid values.

No

Legal Entity ID

LEGAL_ENTITY_ID

Unique identifier of the legal entity. If the identifier isn't available, use the LEGAL_ENTITY_NAME column.

No

Legal Entity Name

LEGAL_ENTITY_NAME

Name of the legal entity on the invoice. Use the Manage Legal Entities task to identify valid values.

No

No Conversion Rate Accounted Amount

NO_XRATE_BASE_AMOUNT

Invoice amount in the functional currency. Used to calculate exchange rate. Used only when Calculate User Exchange Rate option is enabled for foreign currency invoices with exchange rate type of User.

No

Business Unit

OPERATING_UNIT

Business unit to which the invoice refers.

No

Business Unit

ORG_ID

Identifier of the business unit associated with the row. If the identifier isn't available, use the OPERATING_UNIT column.

No

Pay Group

PAY_GROUP_LOOKUP_CODE

Groups suppliers or invoices for a single pay run. Examples: employees, merchandise, nonmerchandise. Use the Manage Payables Lookups task, lookup type PAY GROUP to identify valid values.

No

Payment Currency

PAYMENT_CURRENCY_CODE

Oracle internal use only.

No

Payment Method

PAYMENT_METHOD_CODE

Payment method, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values.

No

Payment Reason

PAYMENT_REASON_CODE

Code to provide the payment system or bank with additional details for the payment. Use the Manage Payment Codes task to identify valid values. The corresponding Payment Code Type must be Payment Reason.

No

Payment Reason Comments

PAYMENT_REASON_COMMENTS

Reason for the payment. Free text field. Not validated.

No

Customs Location Code

PORT_OF_ENTRY_CODE

Identifies the location or port through which the invoiced goods entered the country. Free text field. Not validated.

No

Prepayment Application Amount

PREPAY_APPLY_AMOUNT

Amount of prepayment to apply to the invoice. Must be positive. Cannot exceed the unpaid invoice amount or the amount of available prepayments.

No

Prepayment Accounting Date

PREPAY_GL_DATE

Accounting date for the prepayment application. If NULL, the value for the column GL_DATE is used. Date format: YYYY/MM/DD.

No

Prepayment Line

PREPAY_LINE_NUM

The invoice line of an existing prepayment to be applied to the invoice.

No

Prepayment Number

PREPAY_NUM

Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. Validations: settlement date must be on or before the system date, if the type is Temporary, it must have the same invoice and payment currency as the invoice, the prepayment must not be fully applied.

No

Product Table

PRODUCT_TABLE

Name of the product source table used to generate an invoice. Free text field. Not validated.

No

Reference Key 1

REFERENCE_KEY1

Captures invoice reference information from non-Oracle application. Free text field. Not validated.

No

Reference Key 2

REFERENCE_KEY2

Captures invoice reference information from non-Oracle application. Free text field. Not validated.

No

Reference Key 3

REFERENCE_KEY3

Captures invoice reference information from non-Oracle application. Free text field. Not validated.

No

Reference Key 4

REFERENCE_KEY4

Captures invoice reference information from non-Oracle application. Free text field. Not validated.

No

Reference Key 5

REFERENCE_KEY5

Captures invoice reference information from non-Oracle application. Free text field. Not validated.

No

Remit-to Address Name

REMIT_TO_ADDRESS_NAME

Remit-to address where the payment should be sent

No

Remit-to Supplier

REMIT_TO_SUPPLIER_NAME

Third party supplier

No

Remit-to Supplier Number

REMIT_TO_SUPPLIER_NUM

Third party supplier number

No

Remittance Message 1

REMITTANCE_MESSAGE1

Remittance message for use in payment processing. Free text field. Not validated.

No

Remittance Message 2

REMITTANCE_MESSAGE2

Remittance message for use in payment processing. Free text field. Not validated.

No

Remittance Message 3

REMITTANCE_MESSAGE3

Remittance message for use in payment processing. Free text field. Not validated.

No

Requester Employee Number

REQUESTER_EMPLOYEE_NUM

Oracle internal use only.

No

Requester First Name

REQUESTER_FIRST_NAME

The first name of the employee who requested goods or services on the invoice line. Both REQUESTER_FIRST_NAME and REQUESTER_LAST_NAME must be populated to determine a valid employee identifier if REQUESTER_ID isn't used.

No

Requester ID

REQUESTER_ID

Requester of invoice: used by the Invoice Approval workflow process to generate the list of approvers. If the identifier isn't available, use the REQUESTOR_NAME column.

No

Requester Last Name

REQUESTER_LAST_NAME

The last name of the employee who requested goods or services on the invoice line. . Both REQUESTER_FIRST_NAME and REQUESTER_LAST_NAME must be populated to determine a valid employee identifier if REQUESTER_ID isn't used.

No

Settlement Priority

SETTLEMENT_PRIORITY

Priority to settle payment for the transaction. Use the Manage Payables Lookups task, lookup type IBY_SETTLEMENT_PRIORITY to identify valid values.

No

Supplier Tax Invoice Conversion Rate

SUPPLIER_TAX_EXCHANGE_RATE

Supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices.

No

Supplier Tax Invoice Date

SUPPLIER_TAX_INVOICE_DATE

Tax invoice date on the supplier-issued tax invoice. Date format: YYYY/MM/DD.

No

Supplier Tax Invoice Number

SUPPLIER_TAX_INVOICE_NUMBER

The invoice number used to report on a supplier issued tax invoice that's distinct from the regular invoice. Free text field. Not validated.

No

Internal Sequence Number

TAX_INVOICE_INTERNAL_SEQ

Company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. Free text field. Not validated.

No

Internal Recording Date

TAX_INVOICE_RECORDING_DATE

If company-specific tax invoice date and number is captured, the date the company receives or records the supplier-issued tax invoice. Date format: YYYY/MM/DD.

No

Tax Related Invoice

TAX_RELATED_INVOICE_ID

Oracle internal use only.

No

Taxation Country

TAXATION_COUNTRY

Sets the context for tax drivers such as Product Classification Code. If no value is entered, it will display the legal entity country by default.

No

Terms Date

TERMS_DATE

Used with payment terms to calculate scheduled payment of an invoice. Date format: YYYY/MM/DD.

No

Payment Terms ID

TERMS_ID

Payment terms identifier. If the identifier isn't available, use the TERMS_NAME column. Validated against AP_TERMS_TL.TERM_ID.

No

Payment Terms

TERMS_NAME

Name of payment term for an invoice. Use the Manage Payment Terms task to identify valid values.

No

Supplier Tax Registration ID

THIRD_PARTY_REGISTRATION_ID

Third party tax registration identifier.

No

Supplier Tax Registration Number

THIRD_PARTY_REGISTRATION_NUM

Third party tax registration number.

No

Unique Remittance Identifier

UNIQUE_REMITTANCE_IDENTIFIER

Unique remittance identifier provided by the payee. Not validated.

No

Unique Remittance Identifier Check Digit

URI_CHECK_DIGIT

Unique remittance identifier check digit. Free text field. Not validated.

No

Supplier

VENDOR_NAME

Supplier name. Use the Manage Suppliers task to identify valid values.

No

Supplier Number

VENDOR_NUM

Unique number to identify a supplier. Use the Manage Suppliers task to identify valid values.

No

Supplier Site

VENDOR_SITE_CODE

Physical location of the supplier. Use the Manage Suppliers task to identify valid values.

No

Voucher Number

VOUCHER_NUM

Unique internal identifier assigned to a document. Required if document category code has assignment type of manual.

No

AP_INVOICE_LINES_INTERFACE

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Overlay Account Segment

ACCOUNT_SEGMENT

Overrides account segment of the default liability account combination for the invoice line. Must be a valid value for the accounting flexfield.

No

Accounting Date

ACCOUNTING_DATE

Date when the invoice line is to be accounted. Date format: YYYY/MM/DD.

No

Amount

AMOUNT

Amount of the invoice line. Validated against the invoice type. Example: standard invoices must have positive amounts. Amount precision is validated against the currency.

No

Application ID

APPLICATION_ID

Oracle internal use only. Value will be derived.

No

Assessable Value

ASSESSABLE_VALUE

Enter the amount to be used as taxable basis. Free text field. Not validated.

No

Book

ASSET_BOOK_TYPE_CODE

Default asset book for transfers to Oracle Fusion Assets. Use the Manage Assets Books task to identify valid values.

No

Track as Asset

ASSETS_TRACKING_FLAG

A distribution line is tracked in Oracle Fusion Assets. Valid values: Y, N.

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Withholding Tax Group ID

AWT_GROUP_ID

Withholding tax group identifier. If the identifier isn't available, use the AWT_GROUP_NAME column. Validated against AP_AWT_GROUPS.GROUP_ID.

No

Withholding Tax Group

AWT_GROUP_NAME

Used to apply multiple withholding taxes to an invoice line. Use the Manage Withholding Groups task to identify valid values.

No

Overlay Primary Balancing Segment

BALANCING_SEGMENT

Overrides balancing segment of the default liability account for the invoice line. Must be a valid value for the accounting flexfield.

No

Budget Date

BUDGET_DATE

Budgetary Calendar Period Date applicable for funds check

No

Consumption Advice Line Number

CONSUMPTION_ADVICE_LINE_NUMBER

Consumption advice line number. Used for consumption advice matching.

No

Consumption Advice

CONSUMPTION_ADVICE_NUMBER

Consumption advice number. Used for consumption advice matching.

No

Overlay Cost Center Segment

COST_CENTER_SEGMENT

Overrides cost center of the default liability account combination for the invoice line. Must be a valid value for the accounting flexfield.

No

Multiperiod Accounting Accrual Account

DEF_ACCTG_ACCRUAL_CCID

Accrual account that's initially debited for deferred expenses

No

Multiperiod Accounting End Date

DEF_ACCTG_END_DATE

Oracle internal use only.

No

Multiperiod Accounting Start Date

DEF_ACCTG_START_DATE

Oracle internal use only.

No

Distribution Combination ID

DIST_CODE_COMBINATION_ID

Valid account combination for the accounting flexfield identifier distribution line. If the identifier isn't available, use the DIST_CODE_CONCATENATED column. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.

No

Distribution Set ID

DISTRIBUTION_SET_ID

Distribution set identifier. If the identifier isn't available, use the DISTRIBUTION_SET_NAME column. Validated against AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID.

No

Distribution Set

DISTRIBUTION_SET_NAME

Distribution set name. Use the Manage Distribution Sets task to identify valid values.

No

Location of Final Discharge

FINAL_DISCHARGE_LOCATION_CODE

Final discharge location code.

No

Location of Final Discharge ID

FINAL_DISCHARGE_LOCATION_ID

Final discharge location identifier.

No

Final Match

FINAL_MATCH_FLAG

Final match indicator for distribution line matched to purchase order. Valid values: Y, N, NULL. NULL means N.

No

Fiscal Charge Type

FISCAL_CHARGE_TYPE

Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE.

No

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Included in Taxable Line Indicator

INCL_IN_TAXABLE_LINE_FLAG

The amount in the tax line is included in the taxable line. Valid values: Y, N, NULL.

No

Income Tax Region

INCOME_TAX_REGION

Reporting region for distribution line for 1099 supplier. Use the Manage Tax Regions task to identify valid values. Validated against AP_INCOME_TAX_REGIONS.REGION_SHORT_NAME.

No

Item ID

INVENTORY_ITEM_ID

Oracle internal use only. Inventory item identifier.

No

Item Description

ITEM_DESCRIPTION

Item description. Free text field. Not validated.

No

Landed Cost Enabled

LCM_ENABLED_FLAG

Indicates whether invoice line is enabled for landed cost management.

No

Line Group Number

LINE_GROUP_NUMBER

Line group number. Used to prorate charges across a group of lines. Must be a positive integer.

No

Line Number

LINE_NUMBER

Invoice line number. Must be a positive integer. Must be unique per invoice.

No

Line Type

LINE_TYPE_LOOKUP_CODE

Type of invoice line. Use the Manage Payables Lookups task, lookup type INVOICE LINE TYPE to identify valid values.

No

Manufacturer

MANUFACTURER

Name of a manufacturer of an asset or item. Free text field. Not validated.

No

Match Option

MATCH_OPTION

The value of the Invoice Match option on the PO shipment. Valid values: P, R. P used for purchase order. R used for receipt.

No

Model

MODEL_NUMBER

Model number of the invoice line item. Free text field. Not validated.

No

Billable

PJC_BILLABLE_FLAG

Oracle internal use only. Project-related item is available for customer billing.

No

Capitalizable

PJC_CAPITALIZABLE_FLAG

Oracle internal use only. Project-related item is eligible for capitalization.

No

Projects related

PJC_CONTEXT_CATEGORY

Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.

No

Purchase Order Distribution ID

PO_DISTRIBUTION_ID

Purchase order distribution line identifier for matching. If the identifier isn't available, use the PO_DISTRIBUTION_NUM column. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID.

No

Purchase Order Distribution Number

PO_DISTRIBUTION_NUM

Purchase order distribution line number for matching. Use the Manage Purchase Orders task to identify valid values.

No

Purchase Order Header ID

PO_HEADER_ID

Purchase order header identifier used for purchase order matching. If the identifier isn't available, use the PURCHASE_ORDER_NUMBER column. Validated against PO_HEADERS_ALL.PO_HEADER_ID.

No

Purchase Order Line ID

PO_LINE_ID

Purchase order line identifier for matching. If the identifier isn't available, use the PO_LINE_NUMBER column. Validated against PO_LINES_ALL.PO_LINE_ID.

No

Purchase Order Line Location ID

PO_LINE_LOCATION_ID

Purchase order line location identifier for matching. If the identifier isn't available, use the PO_SHIPMENT_NUM column. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID.

No

Purchase Order Line Number

PO_LINE_NUMBER

Purchase order line number for matching. Use the Manage Purchase Orders task to identify valid values.

No

Purchase Order

PO_NUMBER

Purchase order number for matching. Use the Manage Purchase Orders task to identify valid values.

No

Purchase Order Schedule Number

PO_SHIPMENT_NUM

Purchase order shipment number for matching. Use the Manage Purchase Orders task to identify valid values.

No

Price Correction Invoice Line

PRICE_CORRECT_INV_LINE_NUM

Invoice line dependent on price correction. Use the Manage Invoices task to identify valid values.

No

Price Correction Invoice

PRICE_CORRECT_INV_NUM

Number of the invoice that price correction invoice is updating. Use the Manage Invoices task to identify valid values. Validated against AP_INVOICES_ALL.INVOICE_NUM.

No

Price Correction Indicator

PRICE_CORRECTION_FLAG

Indicates if a line creates a price correction. Valid values: Y, N, NULL.

No

Product Category

PRODUCT_CATEGORY

Identifies the taxable nature of a noninventory item. Free text field. Not validated.

No

Product Fiscal Classification

PRODUCT_FISC_CLASSIFICATION

Product fiscal classification for tax. Free text field. Not validated.

No

Product Table

PRODUCT_TABLE

Oracle internal use only.

No

Product Type

PRODUCT_TYPE

Override product type default from the inventory item for tax calculations. Valid values: GOODS, SERVICES.

No

Prorate Across All Item Lines

PRORATE_ACROSS_FLAG

Prorate indicator: prorate all lines with the same LINE_GROUP_NUMBER. Valid values: Y, N, NULL. NULL means Y.

No

Purchasing Category ID

PURCHASING_CATEGORY_ID

Oracle internal use only.

No

Invoiced Quantity

QUANTITY_INVOICED

Quantity invoiced against purchase order shipment.

No

Receipt Line Number

RECEIPT_LINE_NUMBER

The receipt line number with which an invoice will be matched. Use the Receive Expected Shipments task to identify valid values. Validated against RCV_SHIPMENT_LINES.LINE_NUM.

No

Receipt Number

RECEIPT_NUMBER

The receipt number with which an invoice will be matched. Use the Receive Expected Shipments task to identify valid values. Validated against RCV_SHIPMENT_HEADERS.RECEIPT_NUM.

No

Reference Key 1

REFERENCE_KEY1

Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.

No

Reference Key 2

REFERENCE_KEY2

Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.

No

Reference Key 3

REFERENCE_KEY3

Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.

No

Reference Key 4

REFERENCE_KEY4

Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.

No

Reference Key 5

REFERENCE_KEY5

Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated.

No

Requester Employee Number

REQUESTER_EMPLOYEE_NUM

Oracle internal use only.

No

Requester First Name

REQUESTER_FIRST_NAME

Oracle internal use only.

No

Requester ID

REQUESTER_ID

Oracle internal use only.

No

Requester Last Name

REQUESTER_LAST_NAME

Oracle internal use only.

No

Serial Number

SERIAL_NUMBER

Serial number for an item. Free text field. Not validated.

No

Ship-from Location

SHIP_FROM_LOCATION_CODE

Ship-from location code.

No

Ship-from Location ID

SHIP_FROM_LOCATION_ID

Ship-from location identifier.

No

Ship-to Location

SHIP_TO_LOCATION_CODE

Location where goods are received from supplier. Use the Manage Locations task to identify valid values.

No

Ship-to Location ID

SHIP_TO_LOCATION_ID

Ship-to location identifier for tax calculations. Used only if the invoice line isn't PO matched. If the identifier isn't available, use the SHIP_TO_LOCATION column.

No

Tax Name

TAX

Classification of a charge imposed by a government. Use the Manage Taxes task to identify valid values.

No

Tax Classification

TAX_CLASSIFICATION_CODE

Classification code of the invoice line in the interface data. Use the Manage Tax Rates task to identify valid values.

No

Tax Jurisdiction Code

TAX_JURISDICTION_CODE

Internal identifier of a tax jurisdiction. Use the Manage Tax Jurisdictions task to identify valid values.

No

Tax Rate

TAX_RATE

The rate specified for a tax status in effect for a period of time. Use the Manage Tax Rates task to identify valid values.

No

Tax Rate Code

TAX_RATE_CODE

Tax rate name associated with tax rate identifier. The value of the identifier is unique, but the TAX_RATE_CODE may have different tax rates based on date ranges. Use the Manage Tax Rates task to identify valid values.

No

Tax Rate ID

TAX_RATE_ID

Oracle internal use only. Internal identifier for tax rate effective on the invoice date.

No

Tax Regime Code

TAX_REGIME_CODE

Set of tax rules for a tax authority. Use the Manage Tax Regimes task to identify valid values.

No

Tax Status Code

TAX_STATUS_CODE

Tax status code. Examples: taxable standard rate, zero rated, exempt, nontaxable. Use the Manage Tax Statuses task to identify valid values.

No

Taxable Indicator

TAXABLE_FLAG

Indicates whether a line is taxable. Valid values: Y, N, NULL.

No

Transaction Business Category

TRX_BUSINESS_CATEGORY

Transaction category for tax. Free text field. Not validated.

No

Income Tax Type

TYPE_1099

Payments of type 1099 made to a supplier. Use the Income Tax Types task to identify valid values.

No

UOM

UNIT_OF_MEAS_LOOKUP_CODE

Unit of measure for the quantity on an invoice. Validated against purchase order matching option, unit of measure, and quantity. Codependency with QUANTITY_INVOICED and UNIT_PRICE: all three columns must be consistent, either populated or not populated. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE.

No

Unit Price

UNIT_PRICE

Unit price for purchase order matched invoice items. Must be positive for standard invoices; negative for credit and debit memos.

No

User-Defined Fiscal Classification

USER_DEFINED_FISC_CLASS

Fiscal class for tax. Free text field. Not validated.

No

Project Contract ID

PJC_CONTRACT_ID

Oracle internal use only. Contract identifier: used when Oracle Fusion Project Billing or Oracle Fusion Project Billing or Oracle Fusion Grants Accounting is installed.

No

Project Contract Name

PJC_CONTRACT_NAME

Contract name used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.

No

Project Contract Number

PJC_CONTRACT_NUMBER

Contract number used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed.

No

Project Expenditure Item Date

PJC_EXPENDITURE_ITEM_DATE

Oracle internal use only. Date on which project-related transaction occurred. Date format: YYYY/MM/DD.

No

Project Expenditure Type ID

PJC_EXPENDITURE_TYPE_ID

Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.

No

Project Expenditure Type

PJC_EXPENDITURE_TYPE_NAME

A classification of cost that's assigned to each expenditure item.

No

Project Funding Allocation ID

PJC_FUNDING_ALLOCATION_ID

Oracle internal use only. Name of project funding override.

No

Project Funding Source Name

PJC_FUNDING_SOURCE_NAME

Name of the source funding the project.

No

Project Funding Source Number

PJC_FUNDING_SOURCE_NUMBER

Number of the source funding the project.

No

Project Expenditure Organization ID

PJC_ORGANIZATION_ID

Oracle internal use only. Organization identifier to build transaction descriptive flexfield for project-related transaction distributions.

No

Project Expenditure Organization

PJC_ORGANIZATION_NAME

Organization to which the project is assigned.

No

Project ID

PJC_PROJECT_ID

Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.

No

Project Name

PJC_PROJECT_NAME

Name of the project to which the invoice expense is charged.

No

Project Number

PJC_PROJECT_NUMBER

Number of the project to which the invoice expense is charged.

No

Project Reserved Attribute 1

PJC_RESERVED_ATTRIBUTE1

Reserved for future project-related functionality.

No

Project Reserved Attribute 10

PJC_RESERVED_ATTRIBUTE10

Reserved for future project-related functionality.

No

Project Reserved Attribute 2

PJC_RESERVED_ATTRIBUTE2

Reserved for future project-related functionality.

No

Project Reserved Attribute 3

PJC_RESERVED_ATTRIBUTE3

Reserved for future project-related functionality.

No

Project Reserved Attribute 4

PJC_RESERVED_ATTRIBUTE4

Reserved for future project-related functionality.

No

Project Reserved Attribute 5

PJC_RESERVED_ATTRIBUTE5

Reserved for future project-related functionality.

No

Project Reserved Attribute 6

PJC_RESERVED_ATTRIBUTE6

Reserved for future project-related functionality.

No

Project Reserved Attribute 7

PJC_RESERVED_ATTRIBUTE7

Reserved for future project-related functionality.

No

Project Reserved Attribute 8

PJC_RESERVED_ATTRIBUTE8

Reserved for future project-related functionality.

No

Project Reserved Attribute 9

PJC_RESERVED_ATTRIBUTE9

Reserved for future project-related functionality.

No

Project Task ID

PJC_TASK_ID

Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection.

No

Project Task Name

PJC_TASK_NAME

Name of the task used to build the transaction descriptive flexfield for project-related transaction distributions.

No

Project Task Number

PJC_TASK_NUMBER

A subdivision of project work. Task Number uniquely identifies the element within a project or structure.

No

Project User-Defined Attribute 1

PJC_USER_DEF_ATTRIBUTE1

Reserved for user definable project information.

No

Project User-Defined Attribute 10

PJC_USER_DEF_ATTRIBUTE10

Reserved for user definable project information.

No

Project User-Defined Attribute 2

PJC_USER_DEF_ATTRIBUTE2

Reserved for user definable project information.

No

Project User-Defined Attribute 3

PJC_USER_DEF_ATTRIBUTE3

Reserved for user definable project information.

No

Project User-Defined Attribute 4

PJC_USER_DEF_ATTRIBUTE4

Reserved for user definable project information.

No

Project User-Defined Attribute 5

PJC_USER_DEF_ATTRIBUTE5

Reserved for user definable project information.

No

Project User-Defined Attribute 6

PJC_USER_DEF_ATTRIBUTE6

Reserved for user definable project information.

No

Project User-Defined Attribute 7

PJC_USER_DEF_ATTRIBUTE7

Reserved for user definable project information.

No

Project User-Defined Attribute 8

PJC_USER_DEF_ATTRIBUTE8

Reserved for user definable project information.

No

Project User-Defined Attribute 9

PJC_USER_DEF_ATTRIBUTE9

Reserved for user definable project information.

No

Project Work Type

PJC_WORK_TYPE

Classification of project-related work performed.

No

Project Work Type ID

PJC_WORK_TYPE_ID

Oracle internal use only. Identifier for project-related classification of the worked performed.

No

Intended Use

PRIMARY_INTENDED_USE

Tax driver: the purpose for which a product may be used. Free text field. Not validated.

No

Purchasing Category

PURCHASING_CATEGORY

Item category concatenated segments for deriving purchasing category information. Use the Manage Catalogs task to identify valid values.

No

Invoice Id

INVOICE_ID

Invoice identifier. Must be unique.

No

Asset Category

ASSET_CATEGORY_ID

Default asset category for transfers to Oracle Fusion Assets. Use the Manage Asset Categories task to identify valid values.

No

Consumption Advice

CONSUMPTION_ADVICE_HEADER_ID

Consumption advice header identifier. Used for consumption advice matching.

No

Consumption Advice Line Number

CONSUMPTION_ADVICE_LINE_ID

Consumption advice line identifier. Used for consumption advice matching.

No

AP_INVOICES_ALL

Object name on the Configure Business Object Attributes page: Invoice

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

Audit Attribute Table Column Description Audit-Enabled by Default

Liability Distribution

ACCTS_PAY_CODE_COMBINATION_ID

Accounting Flexfield identifier for accounts payable liability account.

No

Discountable Amount

AMOUNT_APPLICABLE_TO_DISCOUNT

Amount of invoice applicable to a discount.

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Bank Charge Bearer

BANK_CHARGE_BEARER

Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER.

No

Invoice Group

BATCH_ID

Unique invoice group identifier.

No

Budget Date

BUDGET_DATE

Budgetary Calendar Period Date applicable for funds check.

No

Control Amount

CONTROL_AMOUNT

Manually entered value to ensure that the calculated tax will be the same as on the physical document.

No

Correction Period

CORRECTION_PERIOD

The tax declaration period of a purchase transaction that's being corrected.

No

Correction Year

CORRECTION_YEAR

The tax declaration year of a purchase transaction that's being corrected.

No

First-Party Taxpayer ID

CUST_REGISTRATION_NUMBER

Customer legal registration number.

No

Delivery Channel

DELIVERY_CHANNEL_CODE

Text on electronic payment that instructs the bank about the execution of payment. For example, print a check and hold it for collection by the payee.

No

Description

DESCRIPTION

Statement that describes the invoice.

No

Document Category

DOC_CATEGORY_CODE

Sequential Numbering (voucher number) document category.

No

Document Fiscal Classification

DOCUMENT_SUB_TYPE

Classification to categorize a document associated with a transaction for tax. This affects the taxability of the transaction.

No

Apply After

EARLIEST_SETTLEMENT_DATE

Date associated with a prepayment after which you can apply the prepayment against invoices. Only used for temporary prepayments. Column is null for permanent prepayments and other invoice types.

No

Conversion Date

EXCHANGE_DATE

Date when a conversion rate is used to convert an amount into another currency for an invoice.

No

Conversion Rate

EXCHANGE_RATE

Ratio at which the principal unit of one currency is converted into another currency for an invoice.

No

Conversion Rate Type

EXCHANGE_RATE_TYPE

Source of currency conversion rate for an invoice. For example, user defined, spot, or corporate.

No

Pay Alone

EXCLUSIVE_PAYMENT_FLAG

Indicator to pay the invoice on a separate payment document.

No

First-Party Tax Registration Number

FIRST_PARTY_REGISTRATION_ID

First party tax registration identifier.

No

Accounting Date

GL_DATE

Accounting date to default to invoice distributions.

No

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Goods Received

GOODS_RECEIVED_DATE

Date when goods on the invoice were received.

No

Intercompany invoice

INTERCOMPANY_FLAG

Intercompany indicator added to incorporate FUN team's intercompany feature.

No

Amount

INVOICE_AMOUNT

Invoice amount in transaction currency.

No

Invoice Currency

INVOICE_CURRENCY_CODE

Currency code used on the invoice.

No

Date

INVOICE_DATE

Date when an event will occur or occurred.

No

Invoice ID

INVOICE_ID

Unique invoice identifier.

No

Number

INVOICE_NUM

Unique number for supplier invoice.

No

Invoice Received

INVOICE_RECEIVED_DATE

Date when the invoice was received. This is used to calculate when the invoice is due.

No

Type

INVOICE_TYPE_LOOKUP_CODE

Invoice category, such as standard, credit memo, or prepayment.

No

Legal Entity

LEGAL_ENTITY_ID

Unique identifier of the legal entity.

No

Pay Group

PAY_GROUP_LOOKUP_CODE

Groups a category of suppliers or invoices for single pay run. For example, employees, merchandise, nonmerchandise, government, domestic, and international.

No

Payment Currency

PAYMENT_CURRENCY_CODE

Currency code of payment (must be same as INVOICE_CURRENCY_CODE or have a fixed rate relationship).

No

Payment Reason

PAYMENT_REASON_CODE

Codes provided by the government or central bank of a country. These codes provide the payment system or bank with additional details about the reason for the payment and are used for regulatory reporting purposes.

No

Payment Reason Comments

PAYMENT_REASON_COMMENTS

Free text field available for entering a reason for the payment.

No

Customs Location Code

PORT_OF_ENTRY_CODE

Code that identifies the location or port through which the invoiced goods entered the country.

No

Requester

REQUESTER_ID

Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers.

No

Routing Attribute 2

ROUTING_ATTRIBUTE2

Captures additional attributes information that may have been used for routing payables invoice images.

No

Routing Attribute 3

ROUTING_ATTRIBUTE3

Captures additional attributes information that may have been used for routing payables invoice images.

No

Routing Attribute 4

ROUTING_ATTRIBUTE4

Captures additional attributes information that may have been used for routing payables invoice images.

No

Settlement Priority

SETTLEMENT_PRIORITY

The priority that the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY.

No

Supplier Tax Invoice Conversion Rate

SUPPLIER_TAX_EXCHANGE_RATE

Conversion rate for taxes on a supplier invoice.

No

Supplier Tax Invoice Date

SUPPLIER_TAX_INVOICE_DATE

Date when the supplier charged tax, as shown on the purchase order.

No

Supplier Tax Invoice Number

SUPPLIER_TAX_INVOICE_NUMBER

Invoice supplier tax invoice number.

No

Internal Sequence Number

TAX_INVOICE_INTERNAL_SEQ

Invoice internal sequence number.

No

Internal Recording Date

TAX_INVOICE_RECORDING_DATE

Date when the invoice was recorded.

No

Related Invoice

TAX_RELATED_INVOICE_ID

Tax related to an invoice.

No

Taxation Country

TAXATION_COUNTRY

Country in which the transaction occurred. Oracle Fusion tax sets the context of other tax drivers, such as Product Fiscal Classification based on this value.

No

Terms Date

TERMS_DATE

Date used with payment terms to calculate scheduled payment of an invoice.

No

Payment Terms

TERMS_ID

Payment terms identifier used on the invoice.

No

Supplier Tax Registration Number

THIRD_PARTY_REGISTRATION_ID

Third party tax registration identifier.

No

Transaction Deadline

TRANSACTION_DEADLINE

Number of days to perform an intra-EU transaction. Used for Modelo reports for Spain.

No

Unique Remittance Identifier

UNIQUE_REMITTANCE_IDENTIFIER

Unique remittance identifier by the payee.

No

Unique Remittance Identifier Check Digit

URI_CHECK_DIGIT

Unique remittance identifier check digit.

No

Supplier

VENDOR_ID

Invoice supplier identifier.

Yes

Supplier Site

VENDOR_SITE_ID

Physical location of the supplier.

Yes

Voucher Number

VOUCHER_NUM

Voucher number; validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled).

No

AP_INVOICE_LINES_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Overlay Account Segment

ACCOUNT_SEGMENT

Account segment value for overlay in generation of accounting flexfield during distribution generation

No

Accounting Date

ACCOUNTING_DATE

Accounting date for invoice line. Used for defaulting to distributions

No

Amount

AMOUNT

Line amount in invoice currency

No

Assessable Value

ASSESSABLE_VALUE

User-enterable amount to be used as taxable basis.

No

Asset Book

ASSET_BOOK_TYPE_CODE

Asset Book. Defaults to the distributions candidate for transfer to Oracle Assets

No

Asset Category

ASSET_CATEGORY_ID

Asset Category. Defaults to the distributions candidate for transfer to Oracle Assets

No

Track as Asset

ASSETS_TRACKING_FLAG

Y indicates that the item should be treated as an asset

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Withholding

AWT_GROUP_ID

Withholding tax group identifier

No

Overlay Primary Balancing Segment

BALANCING_SEGMENT

Balancing segment value for overlay in generation of accounting flexfield during distribution generation

No

Budget Date

BUDGET_DATE

Budgetary Calendar Period Date applicable for funds check.

No

Tax Control Amount

CONTROL_AMOUNT

Optional, user-enterable value to ensure that the calculated tax will be the same as on the physical document.

No

Corrected Invoice Line

CORRECTED_LINE_NUMBER

Invoice line number for invoice line corrected via current line. For price, quantity, or invoice line corrections.

No

Overlay Cost Center Segment

COST_CENTER_SEGMENT

Cost Center segment value for overlay in generation of accounting flexfield during distribution generation

No

Multiperiod Accounting Accrual Account

DEF_ACCTG_ACCRUAL_CCID

Accrual account that's initially debited for deferred expenses.

No

Multiperiod Accounting End Date

DEF_ACCTG_END_DATE

The end date of the deferred expense period

No

Multiperiod Accounting Start Date

DEF_ACCTG_START_DATE

The start date of the deferred expense period

No

Distribution Combination

DEFAULT_DIST_CCID

Account to be used for automatic generation of a single distribution

No

Description

DESCRIPTION

Description of the invoice line.

No

Distribution Set

DISTRIBUTION_SET_ID

Distribution set identifier to be used in the generation of distributions for a line

No

Location of Final Discharge

FINAL_DISCHARGE_LOCATION_ID

Final discharge location identifier.

No

Final Match

FINAL_MATCH_FLAG

Indicates if an invoice is the last one being matched to a PO, so that the PO is no longer available for matching.

No

Fiscal Charge Type

FISCAL_CHARGE_TYPE

Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE.

No

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Income Tax Region

INCOME_TAX_REGION

Reporting region for invoice line for 1099 supplier. Defaults down to distributions

No

Intended Use

INTENDED_USE_CLASSIF_ID

Tax Driver: Intended use identifier.

No

Inventory Item

INVENTORY_ITEM_ID

Inventory item identifier. Validated against EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID

No

Invoice Id

INVOICE_ID

Unique invoice identifier.

No

Landed Cost Enabled

LCM_ENABLED_FLAG

Indicates whether invoice line is enabled for landed cost management.

No

Line Type

LINE_TYPE_LOOKUP_CODE

Type of invoice line. Valid values from INVOICE LINE TYPE lookup codes.

No

Manufacturer

MANUFACTURER

Manufacturer of an asset or item.

No

Model Number

MODEL_NUMBER

Model number of the invoice line item.

No

Overlay Distribution Combination

OVERLAY_DIST_CODE_CONCAT

Concatenated segments for overlay in generation of accounting flexfield during distribution generation

No

Project Billable

PJC_BILLABLE_FLAG

Option that indicates if a project related item is available to be billed to customers.

No

Project Capitalizable

PJC_CAPITALIZABLE_FLAG

Option that indicates if a project related item is eligible for capitalization.

No

Project Contract Number

PJC_CONTRACT_ID

Contract Identified. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.

No

Expenditure Item Date

PJC_EXPENDITURE_ITEM_DATE

Date on which a project related transaction is incurred.

No

Expenditure Item Type

PJC_EXPENDITURE_TYPE_ID

Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions.

No

Expenditure Organization

PJC_ORGANIZATION_ID

Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions.

No

Project Number

PJC_PROJECT_ID

Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions.

No

Task Number

PJC_TASK_ID

Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions.

No

Project User-Defined Attribute 1

PJC_USER_DEF_ATTRIBUTE1

Reserved for user definable project information.

No

Project User-Defined Attribute 10

PJC_USER_DEF_ATTRIBUTE10

Reserved for user definable project information.

No

Project User-Defined Attribute 2

PJC_USER_DEF_ATTRIBUTE2

Reserved for user definable project information.

No

Project User-Defined Attribute 3

PJC_USER_DEF_ATTRIBUTE3

Reserved for user definable project information.

No

Project User-Defined Attribute 4

PJC_USER_DEF_ATTRIBUTE4

Reserved for user definable project information.

No

Project User-Defined Attribute 5

PJC_USER_DEF_ATTRIBUTE5

Reserved for user definable project information.

No

Project User-Defined Attribute 6

PJC_USER_DEF_ATTRIBUTE6

Reserved for user definable project information.

No

Project User-Defined Attribute 7

PJC_USER_DEF_ATTRIBUTE7

Reserved for user definable project information.

No

Project User-Defined Attribute 8

PJC_USER_DEF_ATTRIBUTE8

Reserved for user definable project information.

No

Project User-Defined Attribute 9

PJC_USER_DEF_ATTRIBUTE9

Reserved for user definable project information.

No

Project Work Type

PJC_WORK_TYPE_ID

Identifier for project related classification of the worked performed.

No

Product Fiscal Classification

PROD_FC_CATEG_ID

Tax Driver: Product fiscal classification identifier.

No

Product Category

PRODUCT_CATEGORY

Identifies the taxable nature of a non-inventory based item for tax determination or tax reporting.

No

Product Type

PRODUCT_TYPE

Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user.

No

Prorate Across All Items

PRORATE_ACROSS_ALL_ITEMS

A value of Y indicates that the Freight or Miscellaneous type line should be prorated across all Item type lines

No

Quantity

QUANTITY_INVOICED

Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines

No

Requester

REQUESTER_ID

The name of the person who the requested items are intended for.

No

Serial Number

SERIAL_NUMBER

Number indicating place in a series, used for identification.

No

Ship-from Location

SHIP_FROM_LOCATION_ID

Ship-from location identifier.

No

Ship-to Location

SHIP_TO_CUST_LOCATION_ID

Location where the supplier should ship the goods.

No

Ship-to Location

SHIP_TO_LOCATION_ID

Tax Driver: Ship to location ID. Value entered by user only if line isn't PO matched.

No

Tax Classification

TAX_CLASSIFICATION_CODE

Tax classification code used by Procure To Pay products.

No

Transaction Business Category

TRX_BUSINESS_CATEGORY

Tax Driver: Transactions category assigned by user.

No

Income Tax Type

TYPE_1099

Indicates the category of the withholding tax rates.

No

UOM

UNIT_MEAS_LOOKUP_CODE

Unit of measure for QUANTITY_INVOICED. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE

No

Unit Price

UNIT_PRICE

Price charged per unit of a good or service.

No

User-Defined Fiscal Classification

USER_DEFINED_FISC_CLASS

Tax Driver: Fiscal Classification.

No

AP_INVOICE_DISTRIBUTIONS_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Accounting Date

ACCOUNTING_DATE

Accounting date for invoice line. Used for defaulting to distributions

No

Amount

AMOUNT

Line amount in invoice currency

No

Asset Book

ASSET_BOOK_TYPE_CODE

Asset Book. Defaults to the distributions candidate for transfer to Oracle Assets

No

Track as Asset

ASSETS_TRACKING_FLAG

Y indicates that the item should be treated as an asset

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Budget Date

BUDGET_DATE

Budgetary Calendar Period Date applicable for funds check.

No

Multiperiod Accounting Accrual Account

DEF_ACCTG_ACCRUAL_CCID

Accrual account that's initially debited for deferred expenses.

No

Multiperiod Accounting End Date

DEF_ACCTG_END_DATE

Deferred accounting end date.

No

Multiperiod Accounting Start Date

DEF_ACCTG_START_DATE

Deferred accounting start date.

No

Description

DESCRIPTION

Statement that describes the distribution.

No

Distribution Combination

DIST_CODE_COMBINATION_ID

Accounting Flexfield identifier for account associated with a distribution

No

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Income Tax Region

INCOME_TAX_REGION

Reporting region for distribution for 1099 supplier.

No

Intended Use

INTENDED_USE_CLASSIF_ID

Tax Driver: Intended use identifier.

No

Distribution Line Type

LINE_TYPE_LOOKUP_CODE

Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE

No

Project Billable

PJC_BILLABLE_FLAG

Option that indicates if a project related item is available to be billed to customers.

No

Project Capitalizable

PJC_CAPITALIZABLE_FLAG

Option that indicates if a project related item is eligible for capitalization.

No

Project Context Category

PJC_CONTEXT_CATEGORY

Segment used to identify the descriptive flexfield application context for project related standardized code collection.

No

Contract Number

PJC_CONTRACT_ID

Contract Identified. Used when Oracle Contract Billing or Oracle Grants Accounting is installed.

No

Expenditure Item Date

PJC_EXPENDITURE_ITEM_DATE

Date on which a project related transaction is incurred.

No

Expenditure Item Type

PJC_EXPENDITURE_TYPE_ID

Identifier of the expenditure used to build the transaction descriptive flexfield for project related transaction distributions.

No

Expenditure Organization

PJC_ORGANIZATION_ID

Organization identifier used to build the transaction descriptive flexfield for project related transaction distributions.

No

Project Number

PJC_PROJECT_ID

Identifier of the project used to build the transaction descriptive flexfield for project related transaction distributions.

No

Task Number

PJC_TASK_ID

Identifier of the task used to build the transaction descriptive flexfield for project related transaction distributions.

No

Project User-Defined Attribute 1

PJC_USER_DEF_ATTRIBUTE1

Reserved for user definable project information.

No

Project User-Defined Attribute 10

PJC_USER_DEF_ATTRIBUTE10

Reserved for user definable project information.

No

Project User-Defined Attribute 2

PJC_USER_DEF_ATTRIBUTE2

Reserved for user definable project information.

No

Project User-Defined Attribute 3

PJC_USER_DEF_ATTRIBUTE3

Reserved for user definable project information.

No

Project User-Defined Attribute 4

PJC_USER_DEF_ATTRIBUTE4

Reserved for user definable project information.

No

Project User-Defined Attribute 5

PJC_USER_DEF_ATTRIBUTE5

Reserved for user definable project information.

No

Project User-Defined Attribute 6

PJC_USER_DEF_ATTRIBUTE6

Reserved for user definable project information.

No

Project User-Defined Attribute 7

PJC_USER_DEF_ATTRIBUTE7

Reserved for user definable project information.

No

Project User-Defined Attribute 8

PJC_USER_DEF_ATTRIBUTE8

Reserved for user definable project information.

No

Project User-Defined Attribute 9

PJC_USER_DEF_ATTRIBUTE9

Reserved for user definable project information.

No

Work Type

PJC_WORK_TYPE_ID

Identifier for project related classification of the worked performed.

No

Invoiced Quantity

QUANTITY_INVOICED

Quantity billed for purchase order or receipt matched invoice distributions.

No

Statistical Quantity

STAT_AMOUNT

Amount associated with a distribution for measuring statistical quantities.

No

Income Tax Type

TYPE_1099

Payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type.

No

AP_PAYMENT_SCHEDULES_ALL

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13

ATTRIBUTE13

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 14

ATTRIBUTE14

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 15

ATTRIBUTE15

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

First Discount Amount

DISCOUNT_AMOUNT_AVAILABLE

Discount amount available at first discount date.

No

First Discount Date

DISCOUNT_DATE

Date first discount is available.

No

Due Date

DUE_DATE

Date when the invoice or installment is due for payment.

No

Bank Account

EXTERNAL_BANK_ACCOUNT_ID

External bank account identifier.

No

Global Attribute Category

GLOBAL_ATTRIBUTE_CATEGORY

Global Descriptive Flexfield: structure definition of the global descriptive flexfield.

No

Global Attribute Date 1

GLOBAL_ATTRIBUTE_DATE1

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Date 2

GLOBAL_ATTRIBUTE_DATE2

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Date 3

GLOBAL_ATTRIBUTE_DATE3

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Date 4

GLOBAL_ATTRIBUTE_DATE4

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Date 5

GLOBAL_ATTRIBUTE_DATE5

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Number 1

GLOBAL_ATTRIBUTE_NUMBER1

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Number 2

GLOBAL_ATTRIBUTE_NUMBER2

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Number 3

GLOBAL_ATTRIBUTE_NUMBER3

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Number 4

GLOBAL_ATTRIBUTE_NUMBER4

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute Number 5

GLOBAL_ATTRIBUTE_NUMBER5

Segment of the global descriptive flexfield used to hold user-defined information on invoice installments.

No

Global Attribute 1

GLOBAL_ATTRIBUTE1

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 10

GLOBAL_ATTRIBUTE10

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 11

GLOBAL_ATTRIBUTE11

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 12

GLOBAL_ATTRIBUTE12

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 13

GLOBAL_ATTRIBUTE13

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 14

GLOBAL_ATTRIBUTE14

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 15

GLOBAL_ATTRIBUTE15

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 16

GLOBAL_ATTRIBUTE16

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 17

GLOBAL_ATTRIBUTE17

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 18

GLOBAL_ATTRIBUTE18

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 19

GLOBAL_ATTRIBUTE19

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 2

GLOBAL_ATTRIBUTE2

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 20

GLOBAL_ATTRIBUTE20

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 3

GLOBAL_ATTRIBUTE3

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 4

GLOBAL_ATTRIBUTE4

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 5

GLOBAL_ATTRIBUTE5

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 6

GLOBAL_ATTRIBUTE6

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 7

GLOBAL_ATTRIBUTE7

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 8

GLOBAL_ATTRIBUTE8

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Global Attribute 9

GLOBAL_ATTRIBUTE9

Global Descriptive Flexfield: segment of the global descriptive flexfield.

No

Gross Amount

GROSS_AMOUNT

Gross amount due for a scheduled payment.

No

On Hold

HOLD_FLAG

Indicates if scheduled payment is on hold (Y or N).

No

Hold Reason

IBY_HOLD_REASON

An explanation or justification that explains the reason for performing actions, such as cancellation, apply hold, or close out.

No

Invoice Id

INVOICE_ID

Unique invoice identifier.

No

Payment Method

PAYMENT_METHOD_CODE

Indicates the payment method, such as check, cash, or credit.

No

Payment Priority

PAYMENT_PRIORITY

Number representing payment priority of a scheduled payment (1 to 99).

No

Remit-to Address Name

REMIT_TO_ADDRESS_NAME

Remit-to address where payment should be sent.

No

Remit-to Supplier

REMIT_TO_SUPPLIER_NAME

Third party supplier.

No

Remittance Message 1

REMITTANCE_MESSAGE1

Remittance message for use in payment processing.

No

Remittance Message 2

REMITTANCE_MESSAGE2

Remittance message for use in payment processing.

No

Remittance Message 3

REMITTANCE_MESSAGE3

Remittance message for use in payment processing.

No

Second Discount Amount

SECOND_DISC_AMT_AVAILABLE

Discount amount available at second discount date.

No

Second Discount Date

SECOND_DISCOUNT_DATE

Date second discount is available.

No

Third Discount Amount

THIRD_DISC_AMT_AVAILABLE

Discount amount available at third discount date.

No

Third Discount Date

THIRD_DISCOUNT_DATE

Date third discount is available.

No

AP_PAYMENT_TEMPLATES

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

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

Audit Attribute Table Column Description Audit-Enabled by Default

Template ID

TEMPLATE_ID

System generated primary key for payment template.

No

Name

TEMPLATE_NAME

Payment Process Request Template Name

No

Type

TEMPLATE_TYPE

Payment Process Request Template Type. Values, from the lookup PAYMENT_TEMPLATE_TYPE

No

Description

DESCRIPTION

Payment Process Request Template Description

No

Inactive Date

INACTIVE_DATE

End Date for the Payment Process Request Template

No

Pay from Days

ADDL_PAY_FROM_DAYS

Number of pay from days defined in the payment template. The value can be either zero or a positive number.

No

Pay Through Days

ADDL_PAY_THRU_DAYS

End date in a date range that indicates the date until when the invoices are selected.

No

To Payment Priority

HI_PAYMENT_PRIORITY

Highest payment priority of the documents to select

No

From Payment Priority

LOW_PAYMENT_PRIORITY

Lowest payment priority of the documents to select

No

Date Basis

PAY_ONLY_WHEN_DUE_FLAG

Option that indicates if documents will be selected by their due date only (Y or N)

No

Include Zero Amount Invoices

ZERO_INV_ALLOWED_FLAG

Option indicating whether scheduled payments with zero amount remaining will be selected during a pay run

No

Supplier Type

VENDOR_TYPE_LOOKUP_CODE

Supplier Type. Based on PO Lookup Type VENDOR TYPES

No

Supplier

VENDOR_ID

Unique supplier identifier from the supplier tables.

No

Party

PARTY_ID

Party identifier of the payment template.

No

Payment Method

PAYMENT_METHOD_CODE

Indicates the payment methods, such as check, cash, or credit.

No

Invoice Conversion Rate Type

INV_EXCHANGE_RATE_TYPE

Type of conversion rate between the payment and your ledger currency.

No

Pay Group Selection Criteria

PAY_GROUP_OPTION

Pay Group Options, All and Specify

No

Currency Selection Criteria

CURRENCY_GROUP_OPTION

Currency Options, All and Specify

No

Legal Entity Selection Criteria

LE_GROUP_OPTION

Legal Entity Options, All and Specify

No

Business Unit Selection Criteria

OU_GROUP_OPTION

Business Unit Options, All and Specify

No

Payment Date

PAYMENT_DATE_OPTION

Payment Date Options, Same as the Request Date, Extra Days

No

Additional Payment Days

ADDL_PAYMENT_DAYS

Extra payment days in the payment template.

No

Disbursement Bank Account

BANK_ACCOUNT_ID

The Internal bank account identifier

No

Bank Charge Bearer Override

BANK_CHARGE_BEARER

Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER

No

Settlement Priority Override

SETTLEMENT_PRIORITY

Overrides the invoice value for Oracle Payments' bank charges feature.

No

Starting Voucher Number

FIRST_VOUCHER_NUMBER

First available voucher number in document sequence for payment batch document category

No

Transfer Priority

TRANSFER_PRIORITY

Transfer priority defined in payment template. This can be express, normal, and any.

No

Payment Conversion Rate Type

PAYMENT_EXCHANGE_RATE_TYPE

Exchange rate type for a foreign currency payment

No

Payment Process Profile

PAYMENT_PROFILE_ID

Payment process profile identifier

No

Apply credits up to zero amount payment

ZERO_AMOUNTS_ALLOWED

Option indicating whether zero payments allowed in run. Helps in Maximizing credits

No

Review installments

PAYABLES_REVIEW_SETTINGS

Stop Process for Review After Invoice Selection

No

Calculate Withholding and Interest

CALC_AWT_INT_FLAG

Option to indicate Calculate Payment Withholding and Interest During Scheduled Payment Selection

No

Review proposed payments

PAYMENTS_REVIEW_SETTINGS

If this check box is selected, the Build Payments program runs to group the invoices into payments and the pay run pauses after payments have been built to allow you to review the proposed payments.

No

Create payment files immediately

CREATE_INSTRS_FLAG

Payment Instruction Creation Program. This setting requires the user to select a payment process profile. This setting will also ensure that payments from this payment process request aren't combined with payments from other payment process requests when the application creates the payment instructions

No

Document

DOCUMENT_REJECTION_LEVEL_CODE

Indicates the validation failure handling option for payable documents. Possible values are: Reject All Documents for Payee, Reject All Documents in Request, Stop Process for Review

No

Payment

PAYMENT_REJECTION_LEVEL_CODE

Document used to pay an invoice.

No

Attribute Category

ATTRIBUTE_CATEGORY

Descriptive Flexfield: structure definition of the user descriptive flexfield.

No

Attribute 1

ATTRIBUTE1

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 2

ATTRIBUTE2

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 3

ATTRIBUTE3

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 4

ATTRIBUTE4

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 5

ATTRIBUTE5

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 6

ATTRIBUTE6

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 7

ATTRIBUTE7

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 8

ATTRIBUTE8

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 9

ATTRIBUTE9

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 10

ATTRIBUTE10

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 11

ATTRIBUTE11

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 12

ATTRIBUTE12

Descriptive Flexfield: segment of the user descriptive flexfield.

No

Attribute 13