1. Tables and Views for SCM
  2. CST_AP_INVOICE_DTLS_GT

CST_AP_INVOICE_DTLS_GT

Global temporary table used in the cost preprocessor. It holds the AP invoice distribution information that came in from the AP Invoice interface and needs to be processed by the cost preprocessor.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
CMR_AP_INVOICE_DISTRIBUTION_ID NUMBER 18 Yes Identifies Account Payables Invoice Distribution interfaced to Costings.
INVOICE_ID NUMBER 18 Yes Identifies Accounts Payables Invoice Interfaced to Costing.
INVOICE_LINE_NUMBER VARCHAR2 40 This is User Specified Invoice Line Number in Accounts Payables Invoice interfaced to Costing.
INVOICE_AMT NUMBER This is Invoice amount in the Accounts Payables Invoice interfaced to Costings.
INVOICE_BASE_AMOUNT NUMBER This is Invoice amount in functional curency.
INVOICE_TYPE VARCHAR2 25 This is Invoice Type in the Accounts Payables Invoice interfaced to Costings such as Standard Invoice, Credit memo, Debit memo etc.
INVOICE_QTY NUMBER This is Invoice quantity in the Accounts Payables Invoice interfaced to Costing.
UNIT_OF_MEASURE VARCHAR2 25 This is the unit of measure of the invoice quantity in the accounts Payables Invoice interfaced to Costing.
INVOICE_QTY_IN_PO_UOM NUMBER Invoice quantity in Purchase Order unit of measure.
DISTRIBUTION_MATCH_TYPE VARCHAR2 25 This is the Distribution Match Type in the Accounts Payables Invoice interfaced to Costing. It identifies whether the Invoice is matched to Purchase order or a receipt transaction. The valid values are NOT_MATCHED, ITEM_TO_PO, ITEM_TO_RECEIPT.
INVOICE_DISTRIBUTION_TYPE VARCHAR2 25 This is the Invoice distribution type in the Accounts Payables Invoice interfaced to Costing. It 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 Single column FK: identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
CMR_RCV_TRANSACTION_ID NUMBER 18 Internal 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 Date when the invoice was accounted.
CORRECTED_INVOICE_DIST_ID NUMBER 18 For correction invoices, this identifies the invoice distribution that is being corrected.
RELATED_DISTRIBUTION_ID NUMBER 18 Identifier that links related distributions.
CURRENCY_CODE VARCHAR2 15 Identifies the currency of the invoice amount.
INVOICING_BU_FUNC_CURR_CODE VARCHAR2 15 Functional currency of the Invoicing business unit.
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.
PARENT_REVERSAL_ID NUMBER 18 Identifies the invoice distribution that is being reversed.
ADJUSTMENT_DATE TIMESTAMP Indicates the adjustment date derived in preprocessing to be used in cost processing acquisition cost adjustments.

Indexes

Index Uniqueness Columns
CST_AP_INVOICE_DTLS_GT_N1 Non Unique CMR_PO_DISTRIBUTION_ID