Payables Transaction Business Objects
This topic describes the transaction business objects for Payables that you can audit.
Auditing considers 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 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 applications interfacing to 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. Can't 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. Don't 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 more 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. Can't 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 identify 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 identify 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 Assets. Use the Manage Assets Books task to identify valid values. | No |
Track as Asset | ASSETS_TRACKING_FLAG | A distribution line is tracked in 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 might 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 Project Billing or Grants Accounting is installed. | No |
Project Contract Name | PJC_CONTRACT_NAME | Contract name used when Contract Billing or Grants Accounting is installed. | No |
Project Contract Number | PJC_CONTRACT_NUMBER | Contract number used when Contract Billing or 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 might 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 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 extra 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 other attributes that might have been used for routing payables invoice images. | No |
Routing Attribute 3 | ROUTING_ATTRIBUTE3 | Captures other attributes that might have been used for routing payables invoice images. | No |
Routing Attribute 4 | ROUTING_ATTRIBUTE4 | Captures other attributes that might 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 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 not 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 Assets | No |
Asset Category | ASSET_CATEGORY_ID | Asset Category. Defaults to the distributions candidate for transfer to 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 Contract Billing or 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 noninventory-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 application-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 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 Contract Billing or 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 might 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 Payables application uses this information to identify 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 | Application-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 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 with 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 |