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 |