Invoice Open Interface Table AP_INVOICE_LINES

INVOICE_ID

Enter the INVOICE_ID of the corresponding invoice in the AP_INVOICES_INTERFACE table. This value is used only to assign lines in this table to invoices in the AP_INVOICES_INTERFACE table.

Validation: Must match a value in the AP_INVOICES_INTERFACE.INVOICE_ID table column or the line isn't imported. In addition, the record doesn't appear on the Open Interface Rejections report.
Destination: None.

INVOICE_LINE_ID

Specify a unique number for each invoice line. If you don't specify a value, this column is populated by the AP_INVOICE_LINES_INTERFACE_S sequence.

Validation: Must be a number.
Destination: None.

LINE_NUMBER

Enter a unique number to identify the line.

Validation: Must be a number. If the invoice line has a duplicate line number, the import process rejects the record.
Destination: AP_INVOICE_LINES_ALL.LINE_NUMBER

LINE_TYPE_LOOKUP_CODE

Type of invoice line. Enter the lookup code for the type of invoice line to create from this record.

Validation: Possible values are: ITEM, TAX, MISCELLANEOUS, or FREIGHT. The lookup codes are stored in the AP_LOOKUP_CODES table with the lookup type of INVOICE LINE TYPE.
Destination: AP_INVOICE_LINES_ALL.LINE_TYPE_LOOKUP_CODE

LINE_GROUP_NUMBER

To prorate a charge to a group of lines, enter the same number on each item line to which you want to prorate that charge. For example, to prorate tax across two Item lines, enter the same line group number for the two Item lines and the Tax line.

Validation: Must be a positive whole number.
Destination: AP_INVOICE_LINES_ALL.LINE_GROUP_NUMBER

AMOUNT

The invoice line amount. If you're matching to a purchase order, the AMOUNT is equal to the QUANTITY_INVOICED multiplied by the UNIT PRICE.

Validation: Validated against the invoice type. For example, lines for Standard invoices must have positive amounts. The amount precision is validated against the currency.
Destination: AP_INVOICE_LINES_ALL.AMOUNT

ACCOUNTING_DATE

The accounting date for the invoice lines. During import, the application searches for an accounting date to assign to the invoice line. The application assigns a value from the first source that it finds and searches the following sources in this order:

Invoice line record
Invoice header record
Accounting Date parameter from the import process submission
Accounting Date Basis setting on the Manage Invoice Options page

Note: The following occurs if the application searches at the accounting date basis level: If the Accounting Date Basis option is set to Goods received or invoice date, the application uses the goods received date. The application uses the invoice date if the invoice doesn't have a received date for the goods. If the Accounting Date Basis option is set to Goods received or system date, the application uses the goods received date. The application uses the system date at time of import if the invoice doesn't have a received date for the goods.

If the invoice accounting date is in a future Payables period, you can account for the invoice, but you can't pay it.

Validation: Must be in valid date format. The date must be in an open or future accounting period.
Destination: AP_INVOICE_LINES_ALL.ACCOUNTING_DATE

DESCRIPTION

Enter a description to assign to the invoice line. If blank and you match to a purchase order, import uses the item description on the purchase order line for the AP_INVOICE_LINES_ALL.DESCRIPTION table column.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.DESCRIPTION

PRORATE_ACROSS_FLAG

If set to Y on a non-Item type line, the import process prorates the charge to item lines with the same LINE_GROUP_NUMBER column value. If no LINE_GROUP_NUMBER is specified, the import process prorates the charge to all Item lines. If this column is set to N, import doesn't prorate the cost and creates only one distribution.

The import process prorates tax for Tax type lines, freight for Freight type lines, and miscellaneous charges for Miscellaneous type lines. Import creates a distribution line for each line that you prorate the charge to. The expense account of the Item line is assigned to the new invoice distribution.

Validation: Line type must not be Item.
Destination: None.

TAX_CODE_ID

Identifier for the tax code to be used.

Validation: The TAX_CODE_ID must be a valid and active value in the AP_TAX_CODES_ALL.TAX_ID table column.
Destination: AP_INVOICE_LINES_ALL.TAX_CODE_ID

FINAL_MATCH_FLAG

If you're certain that this is a final match against the purchase order, enter Y. If the invoice is matched to a receipt, the import process ignores any value in this column.

Validation: Valid values are Y, N, and null.
Destination: AP_INVOICE_LINES_ALL.FINAL_MATCH_FLAG

PO_HEADER_ID

Internal identifier for the purchase order number. To match to a purchase order, you can enter values for either the PO_HEADER_ID or PO_NUMBER columns. If you enter the record in the invoice spreadsheet, you must provide a value by entering a purchase order number and specifying a supplier.

Validation: Must be a valid value in the PO_HEADERS.PO_HEADER_ID table column. Must be for the same supplier and can't have a final match status.
Destination: None.

PO_NUMBER

Enter a purchase order number if you're matching to a purchase order. If you're matching to a purchase order, you must enter the PO_NUMBER or PO_HEADER_ID. If you enter supplier information in another column that's different from this purchase order, the application uses the supplier on the purchase order. The import process ignores any other supplier information that you entered.

Validation: Must be a valid purchase order number for the same supplier, and the purchase order should be active and not final matched. If you specify a purchase order in the AP_INVOICES_INTERFACE table, it must match this purchase order number. The match option for the purchase order shipment must be set to purchase order.
Destination: None. This value is used to enter the AP_INVOICE_LINES_ALL.PO_HEADER_ID table column.

PO_LINE_ID

Internal identifier for the purchase order line number. If you're matching to a purchase order line, you can specify a value for either the PO_LINE_ID or the PO_LINE_NUMBER column.

Validation: Must be a valid value for the PO_LINES.PO_LINE_ID table column.
Destination: This value is used to enter the AP_INVOICE_LINES_ALL.PO_LINE_ID table column.

PO_LINE_NUMBER

To match to a purchase order line, enter a value for either the PO_LINE_NUMBER or PO_LINE_ID column. Alternatively, you can identify a purchase order line number by entering only an ITEM_ID or an ITEM_DESCRIPTION value. If you do this, the value you enter must exactly match the ITEM_ID or ITEM_DESCRIPTION of exactly one purchase order line for the PO_NUMBER.

Validation: Must be a valid value for the PO_LINES.PO_LINE_NUM table column.
Destination: None.

PO_LINE_LOCATION_ID

Internal identifier for purchase order schedule.

Validation: Must be a valid value in the PO_LINE_LOCATIONS.LINE_LOCATION_ID table column for the purchase order. The purchase order schedule can't be finally closed.
Destination: This value is used to enter the AP_INVOICE_LINES_ALL.PO_LINE_LOCATION_ID table column.

PO_SHIPMENT_NUM

Number of the purchase order schedule. If you're matching to a purchase order schedule, enter a value for either the PO_SHIPMENT_NUM or the PO_LINE_LOCATION_ID column.

Alternatively, you can enter a value for the SHIP_TO_LOCATION_CODE column if exactly one schedule on the purchase order has the SHIP_TO_LOCATION_CODE that you specify. For example, you enter a SHIP_TO_LOCATION_CODE of Taipei for a purchase order with exactly one schedule with the location Taipei.

Validation: Must be a valid value for the PO_LINE_LOCATIONS.SHIPMENT_NUM table column. The purchase order schedule can't be finally closed.
Destination: None.

PO_DISTRIBUTION_ID

Internal identifier for purchase order distribution number. If you're matching to a purchase order distribution, you can enter a value for either the PO_DISTRIBUTION_ID or the PO_DISTRIBUTION_NUM column.

Validation: Must be a valid value in the PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID table column.
Destination: This value is used to enter the AP_INVOICE_LINES_ALL.PO_DISTRIBUTION_ID table column.

PO_DISTRIBUTION_NUM

Purchase order distribution number. If you're matching to a distribution, you must enter a value for either the PO_DISTRIBUTION_NUM or PO_DISTRIBUTION_ID column.

Validation: Must match a distribution number on the purchase order and must be a valid value for PO_DISTRIBUTIONS.PO_DISTRIBUTION_NUM.
Destination: None.

INVENTORY_ITEM_ID

Inventory item identifier on the purchase order. Used during purchase order matching.

If you have limited purchase order information, you can enter an inventory item, and the import process attempts to match to a purchase order line. For example, a supplier has one purchase order for personal computers that includes a single line for monitors. To match to the line with monitors if you don't know the purchase order number, enter the proper INVENTORY_ITEM_ID value for the monitors. The import process matches to the correct purchase order line for the monitors.

Validation: Must match the purchase order EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID table column for exactly one line.
Destination: This value is used to enter the AP_INVOICE_LINES_ALL.INVENTORY_ITEM_ID table column.

ITEM_DESCRIPTION

Exact description of the item on the purchase order. Used during purchase order line matching.

If you have limited purchase order information, you can enter a description, and the import process attempts to match to a purchase order line. Consider a purchase order with one line for books and one line for software, and you don't know which line is for which item. You can enter the exact description for the books item and the import process matches to the correct purchase order line.

Validation: Must match the PO_LINES.ITEM_DESCRIPTION table column.
Destination: This value is used to enter the AP_INVOICE_LINES_ALL.ITEM_DESCRIPTION table column.

QUANTITY_INVOICED

Number of units invoiced. For example if there are five chairs on the invoice, enter 5. If you enter a value for the UNIT_PRICE column and leave this column blank, the import process calculates the invoiced quantity. The process divides the AMOUNT column value by the UNIT_PRICE column value.

If the invoice match option on the purchase order schedule is Receipt, import reviews all receipts that have unbilled quantities for the purchase order schedule. Import then matches the billed quantity on the invoice to these receipts starting with the oldest receipt that has an unbilled quantity. Import then fills each unbilled receipt quantity up to the amount of the invoice billed quantity. If the invoice quantity exceeds all available unbilled receipt quantities for the purchase order schedule, import updates the newest unbilled quantity with the excess.

Validation: Must be a positive number if AMOUNT for this line is positive and a negative number if AMOUNT is negative.
Destination: AP_INVOICE_LINES_ALL.QUANTITY_INVOICED

SHIP_TO_LOCATION_CODE

To match to a purchase order schedule when either the PO_SHIPMENT_NUM or PO_LINE_LOCATION_ID columns are blank, you can enter a value for this column. One schedule on the purchase order must have the SHIP_TO_LOCATION_CODE value that you specify. For example, you enter a SHIP_TO_LOCATION_CODE of Taipei for a purchase order with exactly one schedule with the value Taipei.

You can also provide this value for unmatched invoices.

Validation: Validations are performed in the following order: 1. Must be an existing, active value in the HR_LOCATIONS table with the SHIP_TO_SITE_FLAG column set to Y. 2. Must be an existing, active value for the PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID table column.
Destination: None.

UNIT_PRICE

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

Validation: None.
Destination: AP_INVOICE_LINES_ALL.UNIT_PRICE

DISTRIBUTION_SET_ID

Internal identifier for the distribution set. During import, distributions are created only for matched lines. The DISTRIBUTION_SET_NAME or DISTRIBUTION_SET_ID column is populated for unmatched invoices, and distributions for such invoices aren't automatically created through import.

Don't enter a value here if you're matching this line to a purchase order, prorating, or entering an account.

Validation: Must be an existing, active value for the AP_DISTRIBUTION_SETS.DISTRIBUTION_SET_ID table column.
Destination: None.

DISTRIBUTION_SET_NAME

Name of the distribution set. During import, distributions are created only for matched lines. The DISTRIBUTION_SET_NAME or DISTRIBUTION_SET_ID column is populated for unmatched invoices and distributions for these invoices aren't automatically created through import. If you enter a value here, you don't have to enter the corresponding value for DISTRIBUTION_SET_ID.

Don't enter a value in this column if you're matching to a purchase order, prorating, or entering an account.

Validation: Must be an existing, active value for the AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME table column. If you're matching to a purchase order and enter a value in this column, the import process rejects the invoice.
Destination: None.

DIST_CODE_CONCATENATED

The general ledger account to which the distribution amount is charged.

Validation: The account combination must be valid and in the exact flexfield structure that you defined for your Ledger.
Destination: None. This value might be used to enter a value for the AP_INVOICE_LINES_ALL.DIST_CODE_COMBINATION_ID table column.

DIST_CODE_COMBINATION_ID

Internal identifier for the general ledger account to which the distribution amount is charged. If you enter records in any way other than the invoice spreadsheet, you must provide this value.

Validation: The account combination must be valid and in the exact flexfield structure you have defined for your Ledger. In addition, the value must match the GL_CODE_COMBINATIONS.CODE_COMBINATION_ID table column.
Destination: AP_INVOICE_LINES_ALL.DIST_CODE_COMBINATION_ID

AWT_GROUP_ID

Internal identifier associated with the withholding tax group name. To assign a withholding tax group to the line, you don't have to enter a value if you enter a value for the AWT_GROUP_NAME column.

Validation: Must be a valid, active value in the AP_AWT_GROUPS.GROUP_ID table column.
Destination: AP_INVOICE_LINES_ALL.AWT_GROUP_ID

AWT_GROUP_NAME

Withholding tax group name. When you enter a withholding tax group for a line, all of the withholding taxes in the group are applied to the line. If you don't enter a value for this column, the import process uses the value you entered for the AP_INVOICES_INTERFACE.AWT_GROUP_NAME table column. If you didn't enter a value, the import process uses the supplier site value if there is one.

Validation: Must be a valid, active value in the AP_AWT_GROUPS.NAME table column.
Destination: None.

LAST_UPDATED_BY

Enter the ID of the person who last updated this record, usually the same value as the CREATED_BY column. If you don't enter a value, the import process uses the user ID of the person who submitted the import process.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.LAST_UPDATED_BY

LAST_UPDATE_DATE

Enter the last update date for this record, usually the same date as the CREATION_DATE column. The date is used for reference and audit purposes only.

Validation: Must be in valid date format.
Destination: AP_INVOICE_LINES_ALL.LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

The global user ID of the user who last updated this record.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.LAST_UPDATE_LOGIN

CREATED_BY

Enter the user name of the person or organization who loads this record into the table. If you don't enter a value, the import process uses the user name of the person who submits the import process.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.CREATED_BY

CREATION_DATE

Enter the date on which you load this record into the table. This date is used for reference and audit purposes.

Validation: Must be in valid date format.
Destination: AP_INVOICE_LINES_ALL.CREATION_DATE

ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category for the descriptive flexfield information that you want to import for the line.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.ATTRIBUTE_CATEGORY

ATTRIBUTE1-15

Enter descriptive flexfield information. The structure of the information, such as data types and value sets, must match the structure of the global descriptive flexfield segments that you defined. If the structure doesn't match, you might face validation problems on invoice pages.

If you're using a distribution set that has a descriptive flexfield, any data you enter here overwrites the descriptive flexfield from the distribution set.

The Transfer PO distribution additional information option on the Manage Invoice Options page affects these columns. If the option is enabled, the import process uses the purchase order values for any corresponding open interface attribute columns that are null. However, if you enter data for any open interface attribute, then that value is used on the invoice instead of the purchase order value.

If the Transfer PO distribution additional information option is disabled, the import process ignores the purchase order flexfield values.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.ATTRIBUTE1-15

GLOBAL_ATTRIBUTE_CATEGORY

Enter the global descriptive flexfield category for the descriptive flexfield information to import for the line.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1-20

Enter global descriptive flexfield information. The structure of the information, such as data types and value sets, must match the structure of the global descriptive flexfield segments that you defined. If the structure doesn't match, you might face validation problems on invoice pages.

Validation: If you're using a localization, you must enter appropriate values in this flexfield or import rejects the invoice.
Destination: AP_INVOICE_LINES_ALL.GLOBAL_ATTRIBUTE1-20

PO_RELEASE_ID

Internal identifier for a purchase order release number. To match to a blanket purchase order, you must supply either the RELEASE_NUM or the PO_RELEASE_ID, and provide a shipment number. You can also optionally provide a line number.

Validation: Must match a valid value in the PO_RELEASES_ALL.PO_RELEASE_ID table column.
Destination: AP_INVOICE_LINES_ALL.PO_RELEASE_ID

RELEASE_NUM

Release number of a blanket purchase order. Used during purchase order matching. To match to a blanket purchase order, you must supply either the RELEASE_NUM or the PO_RELEASE_ID.

Validation: Must match a valid value in the PO_RELEASES_ALL.PO_RELEASE_ID table column.
Destination: None.

ACCOUNT_SEGMENT

To override the account segment in the account for this line, enter a value. The import process overrides the account segment with this value.

Validation: The value must be a valid value for the account segment of the accounting flexfield.
Destination: AP_INVOICE_LINES_ALL.ACCOUNT_SEGMENT

BALANCING_SEGMENT

To override the balancing segment in the account, enter a value. The import process overrides the balancing segment with this value.

Validation: The value must be a valid value for the balancing account segment of the accounting flexfield.
Destination: AP_INVOICE_LINES_ALL.BALANCING_SEGMENT

COST_CENTER_SEGMENT

To override the cost center in the account, enter a value. The import process overrides the cost center with this value.

Validation: The value must be a valid value for the cost center segment of the accounting flexfield.
Destination: AP_INVOICE_LINES_ALL.COST_CENTER_SEGMENT

Projects Columns

Enter Projects information in the following columns to associate the invoice distribution created from this record with a project in Projects. If you're using Projects, the expense account is built based on this information.

If the invoice is matched to a purchase order with projects-related information, the import process populates the projects-related columns in the AP_INVOICES and AP_INVOICE_LINES_ALL tables.

PROJECT_ID
TASK_ID
EXPENDITURE_TYPE
EXPENDITURE_ITEM_DATE
EXPENDITURE_ORGANIZATION_ID
PA_ADDITION_FLAG

In addition, Projects uses the following columns to transfer invoice data:

PA_QUANTITY
PA_CC_AR_INVOICE_ID
PA_CC_AR_INVOICE_LINE_NUM
REFERENCE_1
REFERENCE_2
PA_CC_PROCESSED_CODE

Validation: The information provided in these columns is validated against Projects.
Destination: AP_INVOICE_LINES_ALL.Projects Columns

STAT_AMOUNT

Amount for measuring statistical quantities that's associated with a distribution line. For example, if the unit of measure is barrels, enter the number of barrels.

Validation: You must also enter a valid value for the PO_UNIT_OF_MEASURE column.
Destination: AP_INVOICE_DISTRIBUTIONS_ALL.STAT_AMOUNT

TYPE_1099

Income tax type for a United States 1099 reportable supplier. Enter a 1099 Miscellaneous Tax Type. You define a supplier as federally reportable by enabling the Federal reportable option on the Manage Suppliers page.

If null and you match to a purchase order, the purchase order provides the default value, even if it's null.

For unmatched invoices, if you don't use a distribution set, the import process uses the income tax type for the supplier as the default value. If you use a distribution set, the import process uses the default income tax type from the distribution set as the default value. You can enter this field regardless of whether the supplier is defined as a US 1099 supplier. This information is used when you submit the US 1099 Payments Report and the US 1099 Form Reports.

Validation: The value must be a valid and active value in the AP_INCOME_TAX_TYPES table (MISC types 1-14, except MISC9, MISC11, and MISC12). In addition, the supplier must be defined as federally reportable.
Destination: AP_INVOICE_LINES_ALL.TYPE_1099

INCOME_TAX_REGION

If the supplier is a US 1099 supplier, enter the reporting region for the supplier. If you don't enter a value, and you enabled the Use supplier tax region option, the import process uses the supplier site income tax region. If you don't enter a value and the Income Tax Region option has a value, the import process uses the option value.

Validation: The value must be a valid and active value in the AP_INCOME_TAX_REGIONS.REGION_SHORT_NAME table column. You must also enter a value for the INCOME_TAX_TYPE column.
Destination: AP_INVOICES_DISTRIBUTIONS.INCOME_TAX_REGION

ASSETS_TRACKING_FLAG

Enter Y if the invoice distribution should be imported into Oracle Fusion Assets using the Create Mass Additions process. If you don't enter a value, and the line has an Asset type account, this column is automatically set to Y during the import process.

Validation: The account must be set up as an existing asset category. In addition, it must be either an asset clearing account or a construction-in-process (CIP) clearing account.
Destination: AP_INVOICE_LINES_ALL.ASSETS_TRACKING_FLAG

PRICE_CORRECTION_FLAG

Indicates if a line creates a price correction. Use a price correction when a supplier sends an invoice for a change in unit price on an invoice already matched to a purchase order. For a price correction, enter the invoice or credit memo, set this indicator to Y, and specify the base matched invoice in the PRICE_CORRECT_INV_NUM column.

The import process records and updates the invoiced unit price of previously matched purchase orders without adjusting billed quantities so you can track price variances. The billed amount on the originally matched purchase order distributions is also updated.

Validation: Valid values are Y, N, and null.
Destination: None.

ORG_ID

Identifier for business unit.

Validation: None.
Destination: None.

RECEIPT_NUMBER

If you're matching to a purchase order receipt, enter the receipt number.

Validation: A purchase order and receipt for the same supplier, supplier site, and currency as the invoice that you're entering must be approved and open. Also, the invoice match option for the purchase order schedule that you're matching to is set to Receipt.
Destination: AP_INVOICE_LINES_ALL.RCV_TRANSACTION_ID

RECEIPT_LINE_NUMBER

If you're matching to a purchase order receipt, you can specify the receipt line that you're matching to.

Validation: A purchase order and receipt for the same supplier, supplier site, and currency as the invoice you're entering must be approved and open. Also, the invoice match option for the purchase order schedule you're matching to is set to Receipt. This must be a valid line number for the receipt.
Destination: None.

MATCH_OPTION

Indicates if an invoice is matched to a purchase order or receipt. When you match to a purchase order or receipt in the invoice spreadsheet, the import process uses the value on the purchase order schedule.

Validation: Must match the value specified in the PO_LINE_LOCATIONS.MATCH_OPTION table column.
Destination: None.

RCV_TRANSACTION_ID

This value specifies a receipt record for matching. This value is used to match Oracle B2B XML invoices to receipts.

Validation: Must be a valid, existing value for the RCV_TRANSACTIONS.RCV_TRANSACTION_ID table column.
Destination: AP_INVOICE_LINES_ALL.RCV_TRANSACTION_ID

PA_CC_AR_INVOICE_ID

Identifier of the corresponding receivable intercompany invoice in Oracle Fusion Receivables.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PA_CC_AR_INVOICE_ID

PA_CC_AR_INVOICE_LINE_NUM

Line number of the corresponding receivable intercompany invoice in Receivables.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PA_CC_AR_INVOICE_LINE_NUM

REFERENCE_1-2

These columns reference records in another application.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.REFERENCE_1, AP_INVOICE_LINES_ALL.REFERENCE_2

PA_CC_PROCESSED_CODE

Indicates the processing status of this invoice line by Oracle Fusion Project Billing in the receiver business unit.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PA_CC_PROCESSED_CODE

TAX_CODE_ID

Internal identifier for the tax code. You can enter a value for either the TAX_CODE column or the TAX_CODE_ID column.

Validation: Must be a valid value for the AP_TAX_CODES_ALL.TAX_ID table column. Further validations are the same as those for the TAX_CODE column.
Destination: AP_INVOICE_LINES_ALL.TAX_CODE_ID

CREDIT_CARD_TRX_ID

This column is populated when credit card transactions for expense reports entered in Oracle Fusion Expenses are imported to Payables.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.CREDIT_ CARD_TRX_ID

VENDOR_ITEM_NUM

Supplier item on the purchase order. Used during purchase order matching. If you have limited purchase order information, you can enter a supplier item, and the import process attempts to match to a purchase order line.

Validation: Must match a valid value in the PO_LINES_ALL.VENDOR_PRODUCT_NUM table column for exactly one line.
Destination: None.

TAXABLE_FLAG

A value of Y indicates that the line is taxable. Import uses this value for B2B XML invoices.

Validation: None.
Destination: None.

PRICE_CORRECT_INV_NUM

Number of the invoice that the price correction invoice is updating. If you set the PRICE_CORRECTION_FLAG column to Y, you must enter the number of the base-matched invoice here.

Validation: This value must be a valid purchase order matched invoice with a type of Standard. You must provide sufficient purchase order information for the application to identify the purchase order amount that you want to update.
Destination: Used to derive the AP_INVOICE_DISTRIBUTIONS.PRICE_CORRECT_INV_ID table column.

PRICE_CORRECT_INV_LINE_NUM

The invoice line that's subject to the price correction.

Validation: None.
Destination: None.

EXTERNAL_DOC_LINE_REF

An internal document reference number from Receivables.

Validation: None.
Destination: None.

SERIAL_NUMBER

The serial number for an item.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SERIAL_NUMBER

MANUFACTURER

The name of the manufacturer.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.MANUFACTURER

MODEL_NUMBER

The model information.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.MODEL_NUMBER

WARRANTY_NUMBER

The warranty number.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.WARRANTY_NUMBER

UNIT_OF_MEAS_LOOKUP_CODE

The unit of measure for the invoiced quantity.

Validation: INV_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE
Destination: AP_INVOICE_LINES_ALL.UNIT_MEAS_LOOKUP_CODE

ASSET_BOOK_TYPE_CODE

Default asset book for transfers to Assets.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE

ASSET_CATEGORY_ID

Default asset category for transfers to Assets.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.ASSET_CATEGORY_ID

REQUESTER_ID

The identifier of the requester. Valid values are from active HR employees.

Validation: PER_WORKFORCE_CURRENT_X.PERSON_ID
Destination: AP_INVOICE_LINES_ALL.REQUESTER_ID

REQUESTER_FIRST_NAME

The first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use the invoice approval workflow, you can define rules using the requester ID to generate a hierarchical list of approvers for the line.

Validation: None.
Destination: None.

REQUESTER_LAST_NAME

The last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use the invoice approval workflow, you can define rules using the requester ID to generate a hierarchical list of approvers for the line.

Validation: None.
Destination: None.

REQUESTER_EMPLOYEE_NUM

The employee number of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use the invoice approval workflow, you can define rules using the requester ID to generate a hierarchical list of approvers for the line.

Validation: None.
Destination: None.

APPLICATION_ID

The application identifier.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.APPLICATION_ID

PRODUCT_TABLE

The product source table name.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PRODUCT_TABLE

REFERENCE_KEY1-5

Primary keys that uniquely identify a record in other product views.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.REFERENCE_KEY1-5

PURCHASING_CATEGORY

Item category concatenated segments for deriving purchasing category information.

Validation: None.
Destination: None.

PURCHASING_CATEGORY_ID

The item category unique identifier.

Validation: None.
Destination: INVOICE_LINES_ALL.PURCHASING_CATEGORY_ID

COST_FACTOR_ID

The identifier of the cost component class. Cost component classes identify the individual buckets or component costs that make up the total cost of an item. Examples include direct material costs, freight, labor, and production or conversion costs.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.COST_FACTOR_ID

COST_FACTOR_NAME

The cost component class name. Cost component classes identify the individual buckets or component costs that make up the total cost of an item. Examples include direct material costs, freight, labor, and production or conversion costs.

Validation: None.
Destination: None.

CONTROL_AMOUNT

An optional value entered by a user to ensure that the calculated tax is the same as the tax on the physical document.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.CONTROL_AMOUNT

ASSESSABLE_VALUE

The taxable basis entered by a user.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.ASSESSABLE_VALUE

DEFAULT_DIST_CCID

An account combination identifier of the general ledger account associated with the transaction line.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.DEFAULT_DIST_CCID

PRIMARY_INTENDED_USE

A tax driver. The purpose a product might serve. The actual use is stored at the distribution level.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PRIMARY_INTENDED_USE

SHIP_TO_LOCATION_ID

Ship-to location identifier for tax calculations. Used only if the invoice line isn't matched to a purchase order.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SHIP_TO_LOCATION_ID

SHIP_FROM_LOCATION_ID

Ship-from location unique identifier for tax calculations.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SHIP_FROM_LOCATION_ID

SHIP_FROM_LOCATION_CODE

A tax driver. The supplier location or site from where the goods are shipped.

Validation: None.
Destination: None. This value might be useful for deriving a value for the AP_INVOICE_LINES_ALL.SHIP_FROM_LOCATION_ID table column.

FINAL_DISCHARGE_LOCATION_ID

Location of final discharge unique identifier for tax calculations.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.FINAL_DISCHARGE_LOCATION_ID

FINAL_DISCHARGE_LOCATION_CODE

A tax driver. The final destination location for purchases made by the customer.

Validation: None.
Destination: None. This value might be used to derive a value for the AP_INVOICE_LINES_ALL.FINAL_DISCHARGE_LOCATION_ID table column.

PRODUCT_TYPE

A tax driver. A type of product. Possible values are Goods and Service. Inventory item attributes provide the default value. Otherwise, the user enters the value.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PRODUCT_TYPE

PRODUCT_CATEGORY

Override product type default value from the inventory item for tax calculations.

Validation: Valid values are Goods or Services.
Destination: AP_INVOICE_LINES_ALL.PRODUCT_CATEGORY

PRODUCT_FISC_CLASSIFICATION

A tax driver. A product fiscal classification.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.PRODUCT_FISC_CLASSIFICATION

USER_DEFINED_FISC_CLASS

A tax driver. A fiscal classification.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.USER_DEFINED_FISC_CLASS

TRX_BUSINESS_CATEGORY

A tax driver. A transactions category assigned by a user.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TRX_BUSINESS_CATEGORY

TAX_REGIME_CODE

A tax regime code. The set of tax rules that determines the treatment of one or more taxes administered by a tax authority.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_REGIME_CODE

TAX

A classification of a charge imposed by a government through a fiscal or tax authority.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX

TAX_JURISDICTION_CODE

The internal identifier of the tax jurisdiction.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_JURISDICTION_CODE

TAX_STATUS_CODE

The tax status code. Examples include taxable standard rate, zero rate, exempt, or nontaxable.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_STATUS_CODE

TAX_RATE_ID

The internal identifier for the tax rate that's in effect on the invoice date.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_RATE_ID

TAX_RATE_CODE

The tax rate name associated with the tax rate identifier. The TAX_RATE_ID value is unique while a TAX_RATE_CODE value might have different tax rates based on date ranges.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_RATE_CODE

TAX_RATE

The rate specified for a tax status in effect for a period of time.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_RATE

INCL_IN_TAXABLE_LINE_FLAG

The indicator for whether the amount in the tax line is included in the taxable line.

Validation: Valid values are Y, N, and null.
Destination: None.

SOURCE_APPLICATION_ID

The source document application identifier.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SOURCE_APPLICATION_ID

SOURCE_ENTITY_CODE

The source document entity code.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SOURCE_ENTITY_CODE

SOURCE_EVENT_CLASS_CODE

The source document event class code.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SOURCE_EVENT_CLASS_CODE

SOURCE_TRX_ID

The source document transaction identifier.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SOURCE_TRX_ID

SOURCE_LINE_ID

The identifier of the lowest level for which tax is calculated.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SOURCE_LINE_ID

SOURCE_TRX_LEVEL_TYPE

The source document transaction level type.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.SOURCE_TRX_LEVEL_TYPE

TAX_CLASSIFICATION_CODE

The tax classification code.

Validation: None.
Destination: AP_INVOICE_LINES_ALL.TAX_CLASSIFICATION_CODE

Consumption Advice Number

Number of the consumption advice.

Validation: INV_CONS_ADVICE_HEADERS
Destination

Consumption Advice Line Number

Number of the consumption advice line.

Validation: INV_CONS_ADVICE_LINES
Destination

Consumption Advice Header ID

Identifier for the consumption advice.

Validation: INV_CONS_ADVICE_HEADERS
Destination

Consumption Advice Line ID

Identifier for the line of the consumption advice.

Validation: INV_CONS_ADVICE_LINES
Destination

BUDGET_DATE

Budget date for invoices requiring budgetary control. If populated, this column takes precedence over the BUDGET_DATE column in the AP_INVOICES_INTERFACE table. If neither table has a budget date, the import process uses the Budget Date Basis option to determine the budget date for the invoice.

Validation
Destination: AP_INVOICE_LINES_ALL.BUDGET_DATE