CMR_I_AP_INVOICE_DTLS_I_GT
This table is used to temporarily store a subset of data from CMR_I_AP_INVOICE_DTLS table to support internal processing within the Cost Processor
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CMR_I_AP_INV_DTLS_I_GT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifier of the source system that owns the Accounts Payable Invoice entity | |
| CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Internal AP Invoice Distribution Identifier | ||
| TO_DELETE | VARCHAR2 | 20 | To identify if the corresponding row in interface table is to be deleted | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Identifier of the AP Invoice distribution line in the source system | |
| INVOICE_ID | NUMBER | 18 | Yes | Identifies the Payables Invoice Identifier and references to {AP_INVOICE_LINES_ALL} | |
| INVOICE_NUMBER | VARCHAR2 | 50 | User specified invoice number while creating the payable invoice. | ||
| INVOICING_BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Identifier of the business unit that owns the invoice | |
| INVOICE_LINE_NUMBER | VARCHAR2 | 40 | User specified invoice line number | ||
| INVOICE_AMT | NUMBER | Amount on the invoice distribution | |||
| INVOICE_BASE_AMOUNT | NUMBER | invoice amount on the distribution in functional currency | |||
| DIST_CODE_COMBINATION_ID | NUMBER | 18 | Account identifier associated with invoice distribution | ||
| INVOICE_TYPE | VARCHAR2 | 25 | Identifies the type of invoice such as Standard Invoice, Credit memo, Debit memo etc. | ||
| INVOICE_QTY | NUMBER | Quantity being invoiced in unit of measure | |||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Identifies the unit of measure for the invoice quantity | ||
| DISTRIBUTION_MATCH_TYPE | VARCHAR2 | 25 | Identifies whether the invoice is matched to a Purchase order or a receipt transaction | ||
| INVOICE_DISTRIBUTION_TYPE | VARCHAR2 | 25 | Identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous etc. | ||
| INVOICE_LINE_TYPE | VARCHAR2 | 30 | Type of invoice line. Valid values are ITEM, FREIGHT, MISCELLANEOUS, TAX. | ||
| TAX_CODE_ID | NUMBER | 18 | Identifies the tax code that was used on this distribution for the invoice date. | ||
| LCM_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if this invoice line is for a landed cost charge. | ||
| LINE_CANCELLED_FLAG | VARCHAR2 | 1 | Indicates whether the invoice line has been cancelled. Y - Yes, NULL or N - No. | ||
| VENDOR_ID | NUMBER | 18 | Identifies the Supplier and {References PO_VENDORS.vendor_id}. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Identifies the Supplier Site and references {PO_VENDOR_SITES_ALL.vendor_site_id}. | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Identifier of the purchase order distribution that is matched to the Invoice distribution. This value is expected for match to PO as well as match to Receipt cases. | ||
| RCV_TRANSACTION_ID | NUMBER | 18 | Identifier of the receipt transaction. This value is expected only for the match to receipt cases. | ||
| CONSUMPTION_ADVICE_HEADER_ID | NUMBER | 18 | Header identifier of the consumption advice line that is matched to the invoice. | ||
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Identifier of the consumption advice line that is matched to the invoice. | ||
| FINAL_MATCH_FLAG | VARCHAR2 | 1 | Indicates whether this is a final match invoice. No further invoices are expected for the PO or the Receipt after the final match. | ||
| ACCOUNTING_DATE | TIMESTAMP | Date when the invoice was accounted. | |||
| INVOICE_CREATION_DATE | TIMESTAMP | Date when the invoice was created | |||
| EXPENDITURE_ITEM_DATE | TIMESTAMP | Expenditure item date that will be passed on to Projects. | |||
| CORRECTED_INVOICE_DIST_ID | NUMBER | 18 | For correction invoices, this identifies the invoice distribution that is being corrected. | ||
| INVOICE_SOURCE | VARCHAR2 | 25 | Identifies the source of the invoice such as inter company, Credit Card etc. Mainly used by Cost Management to filter inter company invoices. | ||
| RELATED_DISTRIBUTION_ID | NUMBER | 18 | Identifier that links related distributions. | ||
| CHARGE_APPLICABLE_TO_DIST_ID | NUMBER | 18 | Identifies the invoice distribution to which this one applies. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the invoice amount | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |||
| REVERSAL_FLAG | VARCHAR2 | 1 | Indicates if this invoice distribution is reversing another invoice distribution. This could happen due to invoice line cancellation, discarding an invoice line etc. | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Self Assessed Flag to indicate the NONREC TAX invoice distribution line is self assessed or not. | ||
| PARENT_REVERSAL_ID | NUMBER | 18 | Identifies the invoice distribution that is being reversed. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | Surrogate Identifying the fiscal document header. | |||
| FISCAL_DOC_LINE_ID | NUMBER | Surrogate Identifying a fiscal document line. | |||
| FISCAL_CHARGE_TYPE | VARCHAR2 | 30 | Tax driver. Sub classification for invoice line type of Freight or Miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE. | ||
| 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. | ||
| PROCESSING_STATUS | VARCHAR2 | 20 | This attribute explains about the processing status information | ||
| INCLUSIVE_FLAG | VARCHAR2 | 1 | Inclusive flag to find out invoice amounts on each invoice distribution is a tax exclusive and tax inclusive amount or not. | ||
| TAX_POINT_BASIS | VARCHAR2 | 30 | Tax point basis applicable to the tax line on each invoice distribution. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CMR_I_AP_INV_DTLS_I_GT_U1 | Unique | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |