Invoice Open Interface Table AP_INVOICE_LINES_INTERFACE
This table stores invoice lines information for import into Oracle Fusion Payables base tables using the Import Payables Invoices process.
Records in the AP_INVOICE_LINES_INTERFACE table create one or more invoice distributions. One row might create more than one distribution. For example, if you enter a tax line and prorate it across three item lines, the import process creates three tax invoice distributions.
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
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