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	EMAIL_ADDRESS	Supplier contact email address.	No
Initiated	ENABLED_FLAG	Indicates the record is active and in use.	No