CST_AP_INVOICE_DTLS_S_GT
This table is used to temporarily store a subset of data from CST_AP_INVOICE_DTLS_GT table to support internal processing within the Cost Processor.
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 Costing. | |
| 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. | |||
| PROCESSED_BY_CA_FLAG | VARCHAR2 | 1 | Indicates whether the distribution was picked up by the cost accounting processor. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| ROW_UPDATED_FLAG | VARCHAR2 | 1 | Indicates if this row has been updated during the process. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifier of the source system that owns the Accounts Payable Invoice entity. | ||
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Identifier of the consumption advice line that is matched to the invoice. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_AP_INVOICE_DTLS_S_GT_N1 | Non Unique | CMR_PO_DISTRIBUTION_ID |