AP_INVOICE_LINES_INTERFACE
AP_INVOICE_LINES_INTERFACE stores information used to create one or more invoice distributions. Note that one row in this table may create, during the import process, more than one invoice distribution. For example, if you enter a Tax line in this table and prorate it across multiple Item lines, during Open Interface Import the system may create multiple Tax invoice distributions based on the single Tax line in this table. Please refer to the appendix of the Oracle Payables User Guide or online help for more detailed information on Open Interface table columns, including import validation and destination columns. This is the lines interface table for the AP Invoice Open Interface. Use it in conjunction with AP_INVOICE_INTERFACE table. @rep:ihelp AP/@t_invliint#t_invliint Invoice Lines Open Interface Table Description Scope: public Lifecycle: active Display Name: AP Invoice Lines Interface Product: AP Category: BUSINESS_ENTITY AP_INVOICE
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICE_LINES_INTERFACE_PK |
INVOICE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | Yes | Invoice identifier. Must be unique. | ||
| INVOICE_LINE_ID | NUMBER | 18 | Yes | Unique number for each invoice line of an invoice. If NULL, populated by AP_INVOICE_LINES_INTERFACE_S sequence. | ||
| LINE_NUMBER | NUMBER | 18 | Invoice line number. Must be a positive integer. Must be unique per invoice. | |||
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Type of invoice line. Use the Manage Payables Lookups task, lookup type INVOICE LINE TYPE to identify valid values. | |||
| LINE_GROUP_NUMBER | NUMBER | Line group number. Used to prorate charges across a group of lines. Must be a positive integer. | ||||
| AMOUNT | NUMBER | Amount of the invoice line. Validated against the invoice type. Example: standard invoices must have positive amounts. Amount precision is validated against the currency. | ||||
| ACCOUNTING_DATE | DATE | Date when the invoice line is to be accounted. Date format: YYYY/MM/DD. | ||||
| DESCRIPTION | VARCHAR2 | 240 | Description of the invoice line. Free text field. Not validated. | |||
| PRORATE_ACROSS_FLAG | VARCHAR2 | 1 | Prorate indicator: prorate all lines with the same LINE_GROUP_NUMBER. Valid values: Y, N, NULL. NULL means Y. | |||
| TAX_CODE | VARCHAR2 | 15 | Oracle internal use only. | |||
| FINAL_MATCH_FLAG | VARCHAR2 | 1 | Final match indicator for distribution line matched to purchase order. Valid values: Y, N, NULL. NULL means N. | |||
| PO_HEADER_ID | NUMBER | Purchase order header identifier used for purchase order matching. If the identifier is not available, use the PURCHASE_ORDER_NUMBER column. Validated against PO_HEADERS_ALL.PO_HEADER_ID. | ||||
| PO_NUMBER | VARCHAR2 | 30 | Purchase order number for matching. Use the Manage Purchase Orders task to identify valid values. | |||
| PO_LINE_ID | NUMBER | Purchase order line identifier for matching. If the identifier is not available, use the PO_LINE_NUMBER column. Validated against PO_LINES_ALL.PO_LINE_ID. | ||||
| PO_LINE_NUMBER | NUMBER | Purchase order line number for matching. Use the Manage Purchase Orders task to identify valid values. | ||||
| PO_LINE_LOCATION_ID | NUMBER | Purchase order line location identifier for matching. If the identifier is not available, use the PO_SHIPMENT_NUM column. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID. | ||||
| PO_SHIPMENT_NUM | NUMBER | Purchase order shipment number for matching. Use the Manage Purchase Orders task to identify valid values. | ||||
| PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution line identifier for matching. If the identifier is not available, use the PO_DISTRIBUTION_NUM column. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. | ||||
| PO_DISTRIBUTION_NUM | NUMBER | Purchase order distribution line number for matching. Use the Manage Purchase Orders task to identify valid values. | ||||
| INVENTORY_ITEM_ID | NUMBER | Oracle internal use only. Inventory item identifier. | ||||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. Free text field. Not validated. | |||
| QUANTITY_INVOICED | NUMBER | Quantity invoiced against purchase order shipment. | ||||
| SHIP_TO_LOCATION_CODE | VARCHAR2 | 60 | Location where goods are received from supplier. Use the Manage Locations task to identify valid values. | |||
| UNIT_PRICE | NUMBER | Unit price for purchase order matched invoice items. Must be positive for standard invoices; negative for credit and debit memos. | ||||
| DISTRIBUTION_SET_ID | NUMBER | 18 | Distribution set identifier. If the identifier is not available, use the DISTRIBUTION_SET_NAME column. Validated against AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID. | |||
| DISTRIBUTION_SET_NAME | VARCHAR2 | 50 | Distribution set name. Use the Manage Distribution Sets task to identify valid values. | |||
| DIST_CODE_CONCATENATED | VARCHAR2 | 250 | Accounting flexfield value for a distribution line. Use the valid segment separator from the accounting key flexfield definition. Example: 100-4000-000. | |||
| DIST_CODE_COMBINATION_ID | NUMBER | 18 | Valid account combination for the accounting flexfield identifier distribution line. If the identifier is not available, use the DIST_CODE_CONCATENATED column. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. | |||
| AWT_GROUP_ID | NUMBER | 18 | Withholding tax group identifier. If the identifier is not available, use the AWT_GROUP_NAME column. Validated against AP_AWT_GROUPS.GROUP_ID. | |||
| AWT_GROUP_NAME | VARCHAR2 | 50 | Used to apply multiple withholding taxes to an invoice line. Use the Manage Withholding Groups task to identify valid values. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Gateway Lines (AP_INVOICE_LINES_INTERFACE) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| PO_RELEASE_ID | NUMBER | Blanket purchase order release identifier for PO matching. If the identifier is not available, use the RELEASE_NUM column. Validated against PO_RELEASES_ALL.PO_RELEASE_ID. | ||||
| RELEASE_NUM | NUMBER | Blanket purchase order release number for matching. Use the Manage Purchase Orders task to find valid values. Validated against PO_RELEASES_ALL.RELEASE_NUM. | ||||
| ACCOUNT_SEGMENT | VARCHAR2 | 25 | Overrides account segment of the default liability account combination for the invoice line. Must be a valid value for the accounting flexfield. | |||
| BALANCING_SEGMENT | VARCHAR2 | 25 | Overrides balancing segment of the default liability account for the invoice line. Must be a valid value for the accounting flexfield. | |||
| COST_CENTER_SEGMENT | VARCHAR2 | 25 | Overrides cost center of the default liability account combination for the invoice line. Must be a valid value for the accounting flexfield. | |||
| PROJECT_ID | NUMBER | 18 | Oracle internal use only. | |||
| TASK_ID | NUMBER | 18 | Oracle internal use only. | |||
| EXPENDITURE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |||
| EXPENDITURE_ITEM_DATE | DATE | Oracle internal use only. | ||||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Oracle internal use only. | |||
| PA_ADDITION_FLAG | VARCHAR2 | 1 | Oracle internal use only. Indicates whether project related invoice distributions have been transferred to Oracle Fusion Projects. Valid values: Y, N. | |||
| PA_QUANTITY | NUMBER | Oracle internal use only. Project item quantity used to build accounting flexfield for project-related distribution line. | ||||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | |||
| STAT_AMOUNT | NUMBER | Amount associated with a distribution line for measuring statistical quantities. | ||||
| TYPE_1099 | VARCHAR2 | 10 | Payments of type 1099 made to a supplier. Use the Income Tax Types task to identify valid values. | |||
| INCOME_TAX_REGION | VARCHAR2 | 10 | 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. | |||
| ASSETS_TRACKING_FLAG | VARCHAR2 | 1 | A distribution line is tracked in Oracle Fusion Assets. Valid values: Y, N. | |||
| TAX_CODE_ID | NUMBER | 18 | Tax code identifier for the tax code to be used. If the identifier is not available, use the TAX_CODE column. Validated against AP_TAX_CODES_ALL.TAX_ID. | |||
| PRICE_CORRECTION_FLAG | VARCHAR2 | 1 | Indicates if a line creates a price correction. Valid values: Y, N, NULL. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |||
| RECEIPT_NUMBER | VARCHAR2 | 30 | 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. | |||
| RECEIPT_LINE_NUMBER | VARCHAR2 | 25 | 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. | |||
| MATCH_OPTION | VARCHAR2 | 25 | The value of the Invoice Match option on the PO shipment. Valid values: P, R. P used for purchase order. R used for receipt. | |||
| PACKING_SLIP | VARCHAR2 | 25 | Packing slip associated with the invoice line. Free text field. Not validated. | |||
| RCV_TRANSACTION_ID | NUMBER | Receipt identifier used for Receipt matching. If the identifier is not available, use the RECEIPT_NUMBER and RECEIPT_LINE_NUMBER column. Validated against RCV_TRANSACTIONS.TRANSACTION_ID. | ||||
| PA_CC_AR_INVOICE_ID | NUMBER | 18 | Oracle internal use only. Populated for Projects intercompany invoices. | |||
| PA_CC_AR_INVOICE_LINE_NUM | NUMBER | 18 | Oracle internal use only. Populated for Projects intercompany invoices. | |||
| REFERENCE_1 | VARCHAR2 | 30 | Reference information from a non-Oracle application. Free text field. Not validated. | |||
| REFERENCE_2 | VARCHAR2 | 30 | Reference information from a non-Oracle application. Free text field. Not validated. | |||
| PA_CC_PROCESSED_CODE | VARCHAR2 | 1 | Oracle internal use only. The processing status of this invoice line by Oracle Fusion Projects in the receiver business unit. | |||
| CARD_TRX_ID | NUMBER | 18 | Oracle internal use only. | |||
| CREDIT_CARD_TRX_ID | NUMBER | 18 | Oracle internal use only. | |||
| AWARD_ID | NUMBER | 18 | Oracle internal use only. | |||
| VENDOR_ITEM_NUM | VARCHAR2 | 300 | Oracle internal use only. | |||
| TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether a line is taxable. Valid values: Y, N, NULL. | |||
| PRICE_CORRECT_INV_NUM | VARCHAR2 | 50 | 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. | |||
| EXTERNAL_DOC_LINE_REF | VARCHAR2 | 240 | Oracle internal use only. Internal document reference number from Accounts Receivables system. Used for XML invoices. | |||
| SERIAL_NUMBER | VARCHAR2 | 35 | Serial number for an item. Free text field. Not validated. | |||
| MANUFACTURER | VARCHAR2 | 30 | Name of a manufacturer of an asset or item. Free text field. Not validated. | |||
| MODEL_NUMBER | VARCHAR2 | 40 | Model number of the invoice line item. Free text field. Not validated. | |||
| WARRANTY_NUMBER | VARCHAR2 | 15 | Warranty number of the item. Free text field. Not validated. | |||
| DEFERRED_ACCTG_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
| DEF_ACCTG_START_DATE | DATE | Oracle internal use only. | ||||
| DEF_ACCTG_END_DATE | DATE | Oracle internal use only. | ||||
| DEF_ACCTG_NUMBER_OF_PERIODS | NUMBER | Oracle internal use only. | ||||
| DEF_ACCTG_PERIOD_TYPE | VARCHAR2 | 15 | Oracle internal use only. | |||
| UNIT_OF_MEAS_LOOKUP_CODE | VARCHAR2 | 25 | Unit of measure for quantity invoiced. Validated against purchase order matching option, unit of measure, and quantity. Codependency with QUANTITY_INVOICED and UNIT_PRICE: all three columns must be consistently either populated or not populated. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE. | |||
| PRICE_CORRECT_INV_LINE_NUM | NUMBER | Invoice line dependent on price correction. Use the Manage Invoices task to identify valid values. | ||||
| ASSET_BOOK_TYPE_CODE | VARCHAR2 | 30 | Default asset book for transfers to Oracle Fusion Assets. Use the Manage Assets Books task to identify valid values. | |||
| ASSET_CATEGORY_ID | NUMBER | 18 | Default asset category for transfers to Oracle Fusion Assets. Use the Manage Asset Categories task to identify valid values. | |||
| REQUESTER_ID | NUMBER | 18 | Oracle internal use only. | |||
| REQUESTER_FIRST_NAME | VARCHAR2 | 150 | Oracle internal use only. | |||
| REQUESTER_LAST_NAME | VARCHAR2 | 150 | Oracle internal use only. | |||
| REQUESTER_EMPLOYEE_NUM | VARCHAR2 | 30 | Oracle internal use only. | |||
| APPLICATION_ID | NUMBER | 18 | Oracle internal use only. Value will be derived. | |||
| PRODUCT_TABLE | VARCHAR2 | 30 | Oracle internal use only. | |||
| REFERENCE_KEY1 | VARCHAR2 | 150 | Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated. | |||
| REFERENCE_KEY2 | VARCHAR2 | 150 | Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated. | |||
| REFERENCE_KEY3 | VARCHAR2 | 150 | Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated. | |||
| REFERENCE_KEY4 | VARCHAR2 | 150 | Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated. | |||
| REFERENCE_KEY5 | VARCHAR2 | 150 | Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated. | |||
| PURCHASING_CATEGORY | VARCHAR2 | 2000 | Item category concatenated segments for deriving purchasing category information. Use the Manage Catalogs task to identify valid values. | |||
| PURCHASING_CATEGORY_ID | NUMBER | 18 | Oracle internal use only. | |||
| COST_FACTOR_ID | NUMBER | 18 | Identifies components that make up the total cost of an item. Example: direct material costs and freight costs. If the identifier is not available, use the COST_FACTOR_NAME column. | |||
| COST_FACTOR_NAME | VARCHAR2 | 80 | Identifies components that make up the total cost of an item. Example: direct material costs and freight costs. | |||
| CONTROL_AMOUNT | NUMBER | Control total to validate calculated tax. Must be less than invoice amount. | ||||
| ASSESSABLE_VALUE | NUMBER | Enter the amount to be used as taxable basis. Free text field. Not validated. | ||||
| DEFAULT_DIST_CCID | NUMBER | 18 | Oracle internal use only. Code combination identifier of the GL account associated with the transaction line. Required to support the Account Method VAT feature. | |||
| PRIMARY_INTENDED_USE | VARCHAR2 | 30 | Tax driver: the purpose for which a product may be used. Free text field. Not validated. | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location identifier for tax calculations. Used only if the invoice line is not PO matched. If the identifier is not available, use the SHIP_TO_LOCATION column. | |||
| PRODUCT_TYPE | VARCHAR2 | 240 | Override product type default from the inventory item for tax calculations. Valid values: GOODS, SERVICES. | |||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Identifies the taxable nature of a noninventory item. Free text field. Not validated. | |||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Product fiscal classification for tax. Free text field. Not validated. | |||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 240 | Fiscal class for tax. Free text field. Not validated. | |||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction category for tax. Free text field. Not validated. | |||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Set of tax rules for a tax authority. Use the Manage Tax Regimes task to identify valid values. | |||
| TAX | VARCHAR2 | 30 | Classification of a charge imposed by a government. Use the Manage Taxes task to identify valid values. | |||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Internal identifier of a tax jurisdiction. Use the Manage Tax Jurisdictions task to identify valid values. | |||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code. Examples: taxable standard rate, zero rated, exempt, nontaxable. Use the Manage Tax Statuses task to identify valid values. | |||
| TAX_RATE_ID | NUMBER | 18 | Oracle internal use only. Internal identifier for tax rate effective on the invoice date. | |||
| TAX_RATE_CODE | VARCHAR2 | 150 | Tax rate name associated with tax rate identifier. The value of the identifier is unique, but the TAX_RATE_CODE may have different tax rates based on date ranges. Use the Manage Tax Rates task to identify valid values. | |||
| TAX_RATE | NUMBER | The rate specified for a tax status in effect for a period of time. Use the Manage Tax Rates task to identify valid values. | ||||
| INCL_IN_TAXABLE_LINE_FLAG | VARCHAR2 | 1 | The amount in the tax line is included in the taxable line. Valid values: Y, N, NULL. | |||
| SOURCE_APPLICATION_ID | NUMBER | Oracle internal use only. Source document application identifier. | ||||
| SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only. Entity code of the source document. | |||
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. Source document event class code. | |||
| SOURCE_TRX_ID | NUMBER | Oracle internal use only. Source document transaction identifier. | ||||
| SOURCE_LINE_ID | NUMBER | Oracle internal use only. Identifier of the lowest level for tax calculation. | ||||
| SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Oracle internal use only. Source document transaction level type. | |||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification code of the invoice line in the interface data. Use the Manage Tax Rates task to identify valid values. | |||
| CC_REVERSAL_FLAG | VARCHAR2 | 1 | Oracle internal use only. Confirms whether prepayment has been reversed. | |||
| COMPANY_PREPAID_INVOICE_ID | NUMBER | 18 | Oracle internal use only. | |||
| EXPENSE_GROUP | VARCHAR2 | 80 | Oracle internal use only. Expense group associated with the invoice line. Populated by Oracle Fusion Expenses. | |||
| JUSTIFICATION | VARCHAR2 | 240 | Oracle internal use only. Justification for expenses. Populated by Oracle Fusion Expenses. | |||
| MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | 80 | Oracle internal use only. Number of the receipt or invoice that includes the VAT charge for an expense report item. Populated by Oracle Fusion Expenses. | |||
| MERCHANT_NAME | VARCHAR2 | 80 | Oracle internal use only. Merchant name where the expense was incurred. Populated by Oracle Fusion Expenses. | |||
| MERCHANT_REFERENCE | VARCHAR2 | 240 | Oracle internal use only. Additional merchant information for the VAT inclusive receipt. Example: document information like the purchase order number. Populated by Oracle Fusion Expenses. | |||
| MERCHANT_TAX_REG_NUMBER | VARCHAR2 | 80 | Oracle internal use only. Merchant tax registration number for payment requests. Populated by Oracle Fusion Expenses. | |||
| MERCHANT_TAXPAYER_ID | VARCHAR2 | 80 | Oracle internal use only. Merchant taxpayer unique identifier. Populated by Oracle Fusion Expenses. | |||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | |||
| RECEIPT_CONVERSION_RATE | NUMBER | Oracle internal use only. | ||||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | Oracle internal use only. | ||||
| COUNTRY_OF_SUPPLY | VARCHAR2 | 5 | Country from where line item is supplied. Format: two character ISO country code. Example: US for United States. | |||
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | 1 | Confirms whether tax is included in the amount. Valid values: Y, N, NULL. | |||
| PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_PROJECT_ID | NUMBER | 18 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_TASK_ID | NUMBER | 18 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Oracle internal use only. Date on which project-related transaction occurred. Date format: YYYY/MM/DD. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | Oracle internal use only. Organization identifier to build transaction descriptive flexfield for project-related transaction distributions. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Project-related item is available for customer billing. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Project-related item is eligible for capitalization. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | Oracle internal use only. Identifier for project-related classification of the worked performed. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_CONTRACT_ID | NUMBER | 18 | Oracle internal use only. Contract identifier: used when Oracle Fusion Project Billing or Oracle Fusion Project Billing or Oracle Fusion Grants Accounting is installed. | |||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | Oracle internal use only. Tracks contract line information. Used by Oracle Fusion Project Billing or Oracle Fusion Grants Accounting. | |||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Oracle internal use only. Name of project funding override. | |||
| PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| BUDGET_DATE | DATE | Budgetary Calendar Period Date applicable for funds check | ||||
| LCM_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether invoice line is enabled for landed cost management. | |||
| CONSUMPTION_ADVICE_HEADER_ID | NUMBER | 18 | Consumption advice header identifier. Used for consumption advice matching. | |||
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Consumption advice line identifier. Used for consumption advice matching. | |||
| CONSUMPTION_ADVICE_NUMBER | VARCHAR2 | 20 | Consumption advice number. Used for consumption advice matching. | |||
| CONSUMPTION_ADVICE_LINE_NUMBER | NUMBER | Consumption advice line number. Used for consumption advice matching. | ||||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Ship-from location identifier. | |||
| SHIP_FROM_LOCATION_CODE | VARCHAR2 | 60 | Ship-from location code. | |||
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Final discharge location identifier. | |||
| FINAL_DISCHARGE_LOCATION_CODE | VARCHAR2 | 60 | Final discharge location code. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Oracle Enterprise Scheduler: request identifier of the interface load job that created the row. | ||
| AUTOMATIC_MATCHING_FLAG | VARCHAR2 | 1 | Indicates if automatic matching is enabled for the invoice line. | |||
| MATCHING_RULE_SET_ID | NUMBER | 18 | Matching rule set identifier of the associated matching rule that was used to update matching information for the invoice line. | |||
| MATCHING_RULE_ID | NUMBER | 18 | Matching rule identifier that was used to update matching information for the invoice line. | |||
| FISCAL_CHARGE_TYPE | VARCHAR2 | 30 | Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE. | |||
| PJC_PROJECT_NAME | VARCHAR2 | 240 | Name of the project to which the invoice expense is charged. | |||
| PJC_TASK_NUMBER | VARCHAR2 | 100 | A subdivision of project work. Task Number uniquely identifies the element within a project or structure. | |||
| PJC_EXPENDITURE_TYPE_NAME | VARCHAR2 | 240 | A classification of cost that is assigned to each expenditure item. | |||
| PJC_ORGANIZATION_NAME | VARCHAR2 | 240 | Organization to which the project is assigned. | |||
| PJC_PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project to which the invoice expense is charged. | |||
| PJC_TASK_NAME | VARCHAR2 | 255 | Name of the task used to build the transaction descriptive flexfield for project-related transaction distributions. | |||
| PJC_WORK_TYPE | VARCHAR2 | 240 | Classification of project-related work performed. | |||
| PJC_CONTRACT_NAME | VARCHAR2 | 300 | Contract name used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed. | |||
| PJC_CONTRACT_NUMBER | VARCHAR2 | 120 | Contract number used when Oracle Fusion Contract Billing or Oracle Fusion Grants Accounting is installed. | |||
| PJC_FUNDING_SOURCE_NAME | VARCHAR2 | 360 | Name of the source funding the project. | |||
| PJC_FUNDING_SOURCE_NUMBER | VARCHAR2 | 50 | Number of the source funding the project. | |||
| DEF_ACCTG_ACCRUAL_CCID | NUMBER | 18 | Accrual account that is initially debited for deferred expenses | |||
| DEF_ACCRUAL_CODE_CONCATENATED | VARCHAR2 | 800 | Accrual account combination that is initially debited for deferred expenses. Use the valid segment separator from the account combination definition. Example: 100-4000-000. | |||
| REQUESTER_EMAIL_ADDRESS | VARCHAR2 | 240 | The email address of the employee for the requested items. | |||
| TRANSACTION_LINE_GEOGRAPHY_ID | NUMBER | 18 | Tax driver: Expenses location identifier used for tax calculation for payment requests. | |||
| ACC_REFERENCE_VALUE1 | VARCHAR2 | 4000 | This column is reserved for future internal use. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_INVOICE_LINES_INTERFACE | exm_credit_card_trxns | CREDIT_CARD_TRX_ID |
| AP_INVOICE_LINES_INTERFACE | ap_invoices_interface | INVOICE_ID, LOAD_REQUEST_ID |
| AP_INVOICE_LINES_INTERFACE | po_headers_all | PO_HEADER_ID |
| AP_INVOICE_LINES_INTERFACE | po_lines_all | PO_LINE_ID |
| AP_INVOICE_LINES_INTERFACE | po_distributions_all | PO_DISTRIBUTION_ID |
| AP_INVOICE_LINES_INTERFACE | egp_system_items_b | INVENTORY_ITEM_ID, ORG_ID |
| AP_INVOICE_LINES_INTERFACE | ap_distribution_sets_all | DISTRIBUTION_SET_ID |
| AP_INVOICE_LINES_INTERFACE | gl_code_combinations | DIST_CODE_COMBINATION_ID |
| AP_INVOICE_LINES_INTERFACE | ap_awt_groups | AWT_GROUP_ID |
| AP_INVOICE_LINES_INTERFACE | pjf_projects_all_b | PJC_PROJECT_ID |
| AP_INVOICE_LINES_INTERFACE | ap_income_tax_regions | INCOME_TAX_REGION |
| AP_INVOICE_LINES_INTERFACE | rcv_transactions | RCV_TRANSACTION_ID |
| AP_INVOICE_LINES_INTERFACE | ap_tax_codes_all | TAX_CODE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INVOICE_LINES_INTERFACE_N1 | Non Unique | Default | INVOICE_ID, LOAD_REQUEST_ID |
| AP_INVOICE_LINES_INT_U1 | Unique | Default | INVOICE_LINE_ID |