CST_DELIVERY_ACQ_COST_GT
Temporary table used in the acquisition cost processor to hold the row identifiers of CST_DELIVERY_ACQ_COST
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Precision | Comments |
|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Single column FK: identifies the entity in costing Inventory Transactions. Here It is a delivery transaction whose acquisition cost is being persisted. |
| EFFECTIVE_DATE | TIMESTAMP | This indicates the effective date of the acquisition cost. | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Single column FK: identiifes entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases. |
| CMR_ROOT_RCV_TXN_ID | NUMBER | 18 | Single column FK: internal Root/First Receiving Transaction Identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_DELIVERY_ACQ_COST_GT_N1 | Non Unique | CST_INV_TRANSACTION_ID |