CST_ACQ_COST_PO_SCHEDULE_GT
Global temporary table used in the trade event acquisition cost preprocessor. It holds the acquisition costs for PO Schedules.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: TEMP3
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Yes | Po line location identifier in receipt accounting. |
| ACQUISITION_COST | NUMBER | Unit acquisition cost in the functional currency. | ||
| COST_COMPONENT_ID | NUMBER | 18 | Indicates the Cost component identifier. | |
| ACQUISITION_AMOUNT | NUMBER | Indicates the acquisition amount in functional currency. | ||
| INVOICE_AMOUNT | NUMBER | Net invoice amount in functional currency for each po schedule. | ||
| UNINVOICED_AMOUNT | NUMBER | Net delivered and invoice amount difference in functional currency for each po schedule. | ||
| PRIMARY_NET_DEL_QTY | NUMBER | Indicates the net delivered quantity in primary uom. | ||
| SECONDARY_NET_DEL_QTY | NUMBER | Indicates the net delivered quantity in secondary uom. |