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 |
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 |
Payment Document |
PAYMENT_DOCUMENT_ID |
A set of documents, such as check stock, on which checks and promissory notes can be printed or written. |
No |
Cross-Currency Rate Type |
X_CURR_RATE_TYPE |
The conversion rate type used to convert the invoice currency to payment currency. |
No |
First Approver |
FIRST_APPROVER_ID |
First approver identifier for payment process requests that the payments approval workflow uses to generate the list of approvers. |
No |
Source Selection Criteria |
SOURCE_GROUP_OPTION |
Options on how to select invoices for payment with either all or specific values. |
No |
Select Early Payment Invoices |
ACCELERATED_INVOICES_CODE |
Dynamic discount invoice code. Values are from lookup ACCELERATED_INVOICES. Possible values are INCLUDE, EXCLUDE and EXCLUSIVE. |
No |
AP_OU_GROUP
Object name on the Configure Business Object Attributes page: Business Units
The AP_OU_GROUP contains the user selected values for the operating units for the Payment Process Request Template or the Payment Process Request. AP_OU_GROUP_ is the audit table for AP_OU_GROUP. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Business Unit |
ORG_ID |
Indicates the identifier of the business unit associated to the row. |
No |
Business Unit Group ID |
OU_GROUP_ID |
Business unit group unique identifier. |
No |
AP_CURRENCY_GROUP
Object name on the Configure Business Object Attributes page: Currencies
The AP_CURRENCY_GROUP contains the user selected values for the payment currencies for the Payment Process Request Template or the Payment Process Request. AP_CURRENCY_GROUP_ is the audit table for AP_CURRENCY_GROUP. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Currency |
CURRENCY_CODE |
Currency code of invoices that are selected for a payment template. |
No |
Currency Group ID |
CURRENCY_GROUP_ID |
Unique identifier for every currency selected in the payment template. |
No |
AP_LE_GROUP
Object name on the Configure Business Object Attributes page: Legal Entities
The AP_LE_GROUP contains the user selected values for the legal entities for the Payment Process Request Template or the Payment Process Request. AP_LE_GROUP_ is the audit table for AP_LE_GROUP. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Legal Entity Group ID |
LE_GROUP_ID |
Legal entity group unique identifier. |
No |
Legal Entity |
LEGAL_ENTITY_ID |
Legal entity unique identifier. |
No |
AP_PAY_GROUP
Object name on the Configure Business Object Attributes page: Pay Groups
The AP_PAY_GROUP contains the user selected values for the pay groups for the Payment Process Request Template or the Payment Process Request. AP_PAY_GROUP_ is the audit table for AP_PAY_GROUP. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Pay Group ID |
PAY_GROUP_ID |
Pay group unique identifier. A pay group is a method for categorizing suppliers for payment processing. |
No |
Pay Group |
VENDOR_PAY_GROUP |
Supplier pay group used in the selection criteria for invoices to be paid. |
No |
AP_SOURCE_GROUP
The AP_SOURCE_GROUP table stores the source group selection criteria information for the Payment Process Request template. AP_SOURCE_GROUP_ is the audit table for AP_SOURCE_GROUP. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Source Group ID |
SOURCE_GROUP_ID |
Unique identifier for the source group. |
No |
Sources |
INVOICE_SOURCE_CODE |
Source for creation of invoice used as the selection criteria for the invoices to be paid. Values are from SOURCE lookup type. |
No |
AP_DISCOUNT_OFFERS_B
Object name on the Configure Business Object Attributes page: Early Payment Offers
The AP_DISCOUNT_OFFERS_B table stores discount offers. AP_DISCOUNT_OFFERS_B_ is the audit table for AP_DISCOUNT_OFFERS_B. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Rate |
DISCOUNT_RATE |
Active discount percent rate for the dynamic discount calculation. |
No |
Offer Start Date |
START_DATE_ACTIVE |
Date at the start of the offer period range. |
No |
Expiration Date |
END_DATE_ACTIVE |
Date at the end of the offer period range. |
No |
Initiated |
ENABLED_FLAG |
Indicates the record is active and in use. |
No |
Offer Description |
DESCRIPTION |
Description of the discount offer. |
No |
AP_DISCOUNT_OFFERS_ASSIGN
Object name on the Configure Business Object Attributes page: Early Payment Offer Assignments
The AP_DISCOUNT_OFFERS_ASSIGN table stores information about the supplier assigned to the discount offer. AP_DISCOUNT_OFFERS_ASSIGN_ is the audit table for AP_DISCOUNT_OFFERS_ASSIGN. The following table shows the fields that you can enable for auditing.
Audit Attribute |
Table Column |
Description |
Audit-Enabled by Default |
---|---|---|---|
Rate |
DISCOUNT_RATE |
Active discount percent rate for the dynamic discount calculation. |
Yes |
Supplier |
VENDOR_ID |
Unique identifier of the supplier. |
No |
Supplier Site |
VENDOR_SITE_ID |
Supplier site unique identifier. |
Yes |
Business Unit |
BILL_TO_BU_ID |
Bill-to business unit assigned to the supplier site. |
No |
Offer Start Date |
START_DATE_ACTIVE |
Date at the start of the offer period range. |
No |
Expiration Date |
END_DATE_ACTIVE |
Date at the end of the offer period range. |
Yes |
Comments |
COMMENTS |
Manually entered comments for an assignment. |
Yes |
|
EMAIL_ADDRESS |
Supplier contact email address. |
No |
Initiated |
ENABLED_FLAG |
Indicates the record is active and in use. |
No |