CST_CONSIGNED_AP_INVOICES_GT
Temporary table to snapshot the consigned related AP invoice distributions to be processed by the acquisition 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 | Internal identifier of the Account Payables Invoice Distribution interfaced to Costing. | |
| INVOICE_BASE_AMOUNT | NUMBER | Invoice amount in functional currency. | |||
| INVOICE_QTY_IN_PRIMARY_UOM | NUMBER | Invoice quantity in the primary unit of measure of the item. Note that primary unit of measure here is the one in the supplier facing inventory organization. | |||
| 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. | ||
| INVOICING_BU_FUNC_CURR_CODE | VARCHAR2 | 15 | Functional currency of the Invoicing business unit. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifies the external source system. Necessary in joins to consumption advice line. | |
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Yes | Identifies the consumption advice line that is matched to this invoice. | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Internal Identifier of the Consigned PO Distribution. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_CONS_AP_INVOICES_GT_N1 | Non Unique | EXTERNAL_SYSTEM_REFERENCE, CONSUMPTION_ADVICE_LINE_ID |