1. Tables and Views for SCM
  2. CMR_EXCLUDED_AP_INVOICE_DTLS

CMR_EXCLUDED_AP_INVOICE_DTLS

Table that stores the invoice variance lines (except EXPENSE destination) which are to be excluded from accounting in costing.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CMR_EXCLUDED_AP_INV_DTLS_PK

EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE

Columns

Name Datatype Length Precision Not-null Comments
CMR_AP_INVOICE_DIST_ID NUMBER 18 Yes Internal AP Invoice Distribution Identifier
INVOICE_ID NUMBER 18 Yes Identifies the Payables Invoice Identifier
INVOICE_NUMBER VARCHAR2 50 User specified invoice number during invoice creation.
INVOICING_BUSINESS_UNIT_ID NUMBER 18 Yes Identifier of the business unit that owns the invoice
PROCUREMENT_BUSINESS_UNIT_ID NUMBER 18 Identifies the business unit that has procured the goods/services. Specifically required to non-matched invoices.
INVOICE_LINE_NUMBER VARCHAR2 40 User specified invoice line number
INVOICE_AMT NUMBER Amount on the invoice distribution
INVOICE_BASE_AMOUNT NUMBER Amount on the invoice 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_LINE_TYPE VARCHAR2 30 Type of invoice line. Valid values are ITEM, FREIGHT, MISCELLANEOUS, TAX.
INVOICE_QTY NUMBER Quantity being invoiced in unit of measure code.
UNIT_OF_MEASURE VARCHAR2 25 Identifies the unit of measure for the invoice quantity
INVOICE_QTY_IN_PRIMARY_UOM NUMBER Invoice quantity in the primary unit of measure of the item. Note that in case of global procurement POs, primary unit of measure is the one in the trade inventory organization on the PO. In non-global procurement cases, it is the one in the deliver to inventory organization.
DISTRIBUTION_MATCH_TYPE VARCHAR2 25 Identifies whether the invoice is matched to a Purchase order or a receipt transaction.
TAX_CODE_ID NUMBER 18 Identifies the tax code that was used on this distribution for the invoice date.
CHARGE_APPLICABLE_TO_DIST_ID NUMBER 18 Identifies the invoice distribution to which this one applies.
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}
INVOICE_DISTRIBUTION_TYPE VARCHAR2 25 Yes Identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous etc.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Internal Identifier of the purchase order distribution that is matched to the Invoice distribution. This value will exist for match to PO as well as match to Receipt cases.
PO_DISTRIBUTION_ID NUMBER 18 Source Identifier of the purchase order distribution that is matched to the Invoice distribution. This value will exist for match to PO as well as match to Receipt cases.
CMR_RCV_TRANSACTION_ID NUMBER 18 Single Column FK: Identifies the receiving transaction.
RCV_TRANSACTION_ID NUMBER 18 Source Identifier of the receipt transaction. This value is populated only for the match to receipt cases.
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 Yes Date when the invoice was accounted.
EXPENDITURE_ITEM_DATE TIMESTAMP Expenditure item date that will be passed on Projects.
INVOICE_CREATION_DATE TIMESTAMP Date when the invoice was created
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 Intercompany, Credit Card etc. Mainly used by Cost Management to filter Intercompany invoices.
RELATED_DISTRIBUTION_ID NUMBER 18 Identifier that links related distributions.
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
FISCAL_DOC_HEADER_ID NUMBER 18 Surrogate Identifying the fiscal document header.
FISCAL_DOC_LINE_ID NUMBER 18 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.
PARENT_REVERSAL_ID NUMBER 18 Identifies the invoice distribution that is being reversed.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Identifier of the source system that owns the Accounts Payable Invoice entity
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Identifier of the AP Invoice distribution line in the source system
INVOICING_BU_FUNC_CURR_CODE VARCHAR2 15 Functional currency of the Invoicing business unit
LCM_ASSOCIATION_PROCESSED_FLAG VARCHAR2 1 Indicates whether the invoice distribution has been picked up by the LCM charge invoice association process. Valid values are N - Needs to be processed by the association process Y - Already processed NULL - Not relevant for association
LCM_ASSOCIATION_REQUEST_ID NUMBER 18 Indicates the request ID of the enterprise scheduler service job that processed this record for association.
INVOICE_QTY_IN_PO_UOM NUMBER Invoice quantity converted to the UOM on the purchase order.
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.
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.
ONLINE_ASSOC_PROCESS_ID NUMBER 18 This column would be used to save the online process id if the invoice line was processed by invoking the process from the UI.
LE_TIMEZONE_CODE VARCHAR2 50 Represents the Timezone code of the Legal Entity
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 Tablespace Columns
CMR_EXCLUDED_AP_INV_DTLS_U1 Unique Default EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE
CMR_EXCLUDED_AP_INV_DTLS_U2 Unique Default CMR_AP_INVOICE_DIST_ID