CMF_AP_INVOICE_LINES_GT
Staging table for fiscal document information used to generate invoice lines.
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMF_AP_INVOICE_LINES_GT_PK |
INVOICE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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. Populated by AP_INVOICE_LINES_INTERFACE_S sequence. | |
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Yes | Fiscal document header unique identifier. | |
| FISCAL_DOC_LINE_ID | NUMBER | 18 | Yes | Fiscal document line unique identifier. | |
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Yes | Fiscal document schedule unique identifier. | |
| REF_FISCAL_DOC_HEADER_ID | NUMBER | 18 | Referenced fiscal document header unique identifier. | ||
| REF_FISCAL_DOC_LINE_ID | NUMBER | 18 | Referenced fiscal document line unique identifier. | ||
| REF_FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | Referenced fiscal document schedule unique identifier. | ||
| FISCAL_DOC_CHARGE_ASSOC_ID | NUMBER | 18 | Fiscal document charge association unique identifier. | ||
| 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_NUMBER | NUMBER | 18 | Invoice line number. Must be a positive integer. Must be unique per invoice. | ||
| LINE_GROUP_NUMBER | NUMBER | Line group number. Used to prorate charges across a group of lines. Must be a positive integer. | |||
| FISCAL_CHARGE_TYPE | VARCHAR2 | 30 | Tax driver. Subclassification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE. | ||
| 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. | |||
| DESCRIPTION | VARCHAR2 | 240 | Description of the invoice line. Free text field. Not validated. | ||
| PO_HEADER_ID | NUMBER | Purchase order header identifier used for purchase order matching. Validated against PO_HEADERS_ALL.PO_HEADER_ID. | |||
| PO_LINE_ID | NUMBER | Purchase order line identifier for matching. Validated against PO_LINES_ALL.PO_LINE_ID. | |||
| PO_LINE_LOCATION_ID | NUMBER | Purchase order line location identifier for matching. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID. | |||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase order distribution identifier for matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. | ||
| FISCAL_DOC_DISTRIBUTION_ID | NUMBER | 18 | Identifier of Fiscal Document Distribution. | ||
| INVENTORY_ITEM_ID | NUMBER | This identifies the inventory item. | |||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Item description. Free text field. Not validated. | ||
| QUANTITY_INVOICED | NUMBER | Quantity invoiced against purchase order shipment. | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location identifier for tax calculations. Used only if the invoice line is not PO matched. | ||
| UNIT_PRICE | NUMBER | Unit price for purchase order matched invoice items. Must be positive for standard invoices; negative for credit and debit memos. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| RCV_TRANSACTION_ID | NUMBER | Receipt identifier used for Receipt matching. Validated against RCV_TRANSACTIONS.TRANSACTION_ID. | |||
| 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. | ||
| 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. | ||
| PRICE_CORRECT_INV_LINE_NUM | NUMBER | Invoice line dependent on price correction. Use the Manage Invoices task to identify valid values. | |||
| PRICE_CORRECTION_FLAG | VARCHAR2 | 1 | Indicates if a line creates a price correction. Valid values: Y, N, NULL. | ||
| UNIT_OF_MEAS_LOOKUP_CODE | VARCHAR2 | 25 | Unit of measure for quantity invoiced. Validated against purchase order matching option, unit of measure, and quantity. Co-dependency 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. | ||
| ASSESSABLE_VALUE | NUMBER | Amount to be used as taxable basis. Free text field. Not validated. | |||
| FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Unique Identifier for the final destination location of the purchase made by a customer. | ||
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Input Tax Classification code for Procure to Pay products is represented by this column. | ||
| PRIMARY_INTENDED_USE | VARCHAR2 | 30 | Tax driver: the purpose for which a product may be used. Free text field. Not validated. | ||
| 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. | ||
| APPLICATION_ID | NUMBER | 18 | For Oracle Fusion applications interfacing to Oracle Fusion Payables. | ||
| SOURCE_APPLICATION_ID | NUMBER | Source document application identifier. | |||
| SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Entity code of the source document. | ||
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Source document event class code. | ||
| SOURCE_TRX_ID | NUMBER | Source document transaction identifier. | |||
| SOURCE_LINE_ID | NUMBER | Identifier of the lowest level for tax calculation. | |||
| SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Source document transaction level type. | ||
| LCM_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether invoice line is enabled for landed cost management. | ||
| DIST_CODE_COMBINATION_ID | NUMBER | 18 | This column stores the identification of GL account related to the line. | ||
| LINE_TYPE | VARCHAR2 | 30 | This column stores the type of the fiscal document line. | ||
| 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. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CONSUMPTION_ADVICE_HEADER_ID | NUMBER | 18 | Identifier of consumption header in case of consigned sales flow. | ||
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Identifier of consumption line in case of consigned sales flow. | ||
| REFERENCE_KEY5 | VARCHAR2 | 150 | Captures reference information for invoices imported from non-Oracle applications. Free text field. Not validated. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CMF_AP_INVOICE_LINES_GT_N1 | Non Unique | FISCAL_DOC_HEADER_ID |
| CMF_AP_INVOICE_LINES_GT_N2 | Non Unique | INVOICE_ID |
| CMF_AP_INVOICE_LINES_GT_U1 | Unique | INVOICE_LINE_ID |