CST_OLD_DELIVERIES_GT
This table will hold the set of old deliveries where landed cost charges have changed, however all other charges remained same. This table will be then used to apply the newer landed cost charges to these deliveries and create acquisition cost adjustment.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Precision | Comments |
|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Surrogate ID FK identifying the delivery transaction |
| EFFECTIVE_DATE | TIMESTAMP | Effective date of the acquisition cost. | |
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Root receive transaction associate to the deliver transaction. |
| PO_RCPT_QTY | NUMBER | Purchase Order net received quantity to calculate acquisition cost adjustment. | |
| PRIMARY_RCPT_QTY | NUMBER | The net received quantity in primary unit of measure to calculate acquisition cost adjustment. | |
| SECONDARY_RCPT_QTY | NUMBER | The net received quantity in secondary unit of measure to calculate acquisition cost adjustment. |