AP_INVOICE_LINES_INTERFACE_
AP_INVOICE_LINES_INTERFACE contains information used to create one or more invoice lines. AP_INVOICE_LINES_INTERFACE_ is the audit table for AP_INVOICE_LINES_INTERFACE.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICE_LINES_INTERFACE_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | 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 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | ||
| PJC_PROJECT_ID | NUMBER | 18 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | ||
| PJC_TASK_ID | NUMBER | 18 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | ||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Oracle internal use only. Identifies descriptive flexfield application context for project-related standardized code collection. | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Oracle internal use only. Date on which project-related transaction occurred. Date format: YYYY/MM/DD. | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | Oracle internal use only. Organization identifier to build transaction descriptive flexfield for project-related transaction distributions. | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Project-related item is available for customer billing. | ||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Project-related item is eligible for capitalization. | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | Oracle internal use only. Identifier for project-related classification of the worked performed. | ||
| 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. | ||
| PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Reserved for future project related functionality. | ||
| 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 | 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 | 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INVOICE_LINES_INTERFACE_N1_ | Non Unique | Default | INVOICE_LINE_ID |
| AP_INVOICE_LINES_INTERFACE_N2_ | Non Unique | Default | INVOICE_ID, LOAD_REQUEST_ID |
| AP_INVOICE_LINES_INTERFACE_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, INVOICE_LINE_ID |