1. Tables and Views for SCM
  2. CMR_AP_INVOICE_DTLS

CMR_AP_INVOICE_DTLS

This table contains the persisted AP Invoice information that came through the AP Invoice interface CMR_I_AP_INVOICE_DTLS, after validating it.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMR_AP_INVOICE_DTLS_PK

EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID

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.
CMR_AP_INVOICE_LINE_ID NUMBER 18 Internal AP Invoice Line Identifier.
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 PO, 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.
PROCESSED_BY_CA_FLAG VARCHAR2 5 Indicates whether the distribution was processed by the cost accounting processor. Possible values are N,Y and F. Value N indicates not yet processed by cost accounting, Y indicates processed by cost accounting, F indicates future dated invoice and is not ready for cost accounting.
PROCESSED_BY_RA_FLAG VARCHAR2 5 Indicates whether the distribution was picked up by the receipt accounting processor.
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.
PROCESSED_BY_CMF_FLAG VARCHAR2 4 Indicates if the invoice is processed for fiscal document allocation.

Foreign Keys

Table Foreign Table Foreign Key Column
cst_acq_cost_adj_sources cmr_ap_invoice_dtls CMR_AP_INVOICE_DIST_ID
cst_incoming_txn_cost_sources cmr_ap_invoice_dtls CMR_AP_INVOICE_DIST_ID

Indexes

Index Uniqueness Tablespace Columns
CMR_AP_INVOICE_DTLS_N1 Non Unique FUSION_TS_TX_DATA CMR_PO_DISTRIBUTION_ID, CMR_RCV_TRANSACTION_ID
CMR_AP_INVOICE_DTLS_N10 Non Unique Default INVOICE_NUMBER
CMR_AP_INVOICE_DTLS_N2 Non Unique FUSION_TS_TX_DATA LCM_ENABLED_FLAG, PROCUREMENT_BUSINESS_UNIT_ID, VENDOR_ID, VENDOR_SITE_ID
CMR_AP_INVOICE_DTLS_N3 Non Unique FUSION_TS_TX_DATA LCM_ENABLED_FLAG, INVOICE_LINE_TYPE, CHARGE_APPLICABLE_TO_DIST_ID, EXTERNAL_SYSTEM_REFERENCE
CMR_AP_INVOICE_DTLS_N4 Non Unique FUSION_TS_TX_DATA EXTERNAL_SYSTEM_REFERENCE, CONSUMPTION_ADVICE_LINE_ID
CMR_AP_INVOICE_DTLS_N5 Non Unique FUSION_TS_TX_DATA INVOICE_ID, INVOICE_NUMBER, INVOICE_LINE_NUMBER
CMR_AP_INVOICE_DTLS_N6 Non Unique Default PROCESSED_BY_CMF_FLAG
CMR_AP_INVOICE_DTLS_N7 Non Unique Default PROCESSED_BY_RA_FLAG
CMR_AP_INVOICE_DTLS_N8 Non Unique Default PROCESSED_BY_CA_FLAG, CONSUMPTION_ADVICE_LINE_ID
CMR_AP_INVOICE_DTLS_N9 Non Unique Default PROCUREMENT_BUSINESS_UNIT_ID, LCM_ASSOCIATION_PROCESSED_FLAG
CMR_AP_INVOICE_DTLS_PK Unique FUSION_TS_TX_DATA EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID
CMR_AP_INVOICE_DTLS_UK1 Unique FUSION_TS_TX_DATA CMR_AP_INVOICE_DIST_ID