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 |