CST_TRANSFER_SRC_COSTS_GT
Global temp table that contains the transfer transaction cost details generated internally by the costing engine. The cost is in terms of the shipping cost organization and contains a reference to the destination cost transaction identifier. The costs are converted by mapping cost elements and converting currencies from the source to the destination.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEST_TRANSACTION_ID | NUMBER | 18 | Identifies the destination cost transaction. | ||
| SOURCE_TRANSACTION_ID | NUMBER | 18 | Identifies Source Transaction layer | ||
| SOURCE_REC_TRXN_ID | NUMBER | 18 | Identifies Source Transaction layer | ||
| SOURCE_DEP_TRXN_ID | NUMBER | 18 | Identifies Source Transaction layer | ||
| SOURCE_COST_ELEMENT_ID | NUMBER | 18 | Yes | Identifies the source cost element. Holds the transfer cost in terms of the shipping cost organization's cost elements. | |
| SOURCE_EXPENSE_POOL_ID | NUMBER | 18 | Identifies the source expense pool. | ||
| SOURCE_ABSORPTION_TYPE | VARCHAR2 | 30 | Identifies the absorption type for which this cost is created. | ||
| SOURCE_TXFR_COST_DATE | TIMESTAMP | Identifies the maximum transfer transaction cost date. | |||
| ORIG_SOURCE_TXFR_COST_DATE | TIMESTAMP | Identifies the original transfer transaction cost date if the cost date had to be bumped up because of adjustments. | |||
| SOURCE_UNIT_COST | NUMBER | Identifies the source unit cost of the transfer transaction cost element. | |||
| SOURCE_QUANTITY | NUMBER | Quantity of the source transaction. | |||
| TOTAL_SOURCE_QUANTITY | NUMBER | Total Quantity of the source transactions. | |||
| DEST_QUANTITY | NUMBER | Identifies the destination quantity this source transaction affects. Typically equal to the total source transaction. | |||
| UOM_CONVERSION_FACTOR | NUMBER | UOM_CONVERSION_FACTOR | |||
| SOURCE_DEST_CONV_FACTOR | NUMBER | The conversion factor between the primary unit of measure (uom) of source (issue) transfer transaction and the primary uom of the destination receipt transaction. | |||
| ADJUSTMENT_FLAG | VARCHAR2 | 1 | Yes | Identifies if the row represents an adjustment cost being propagated. 'N' - No 'Y' - Yes | |
| SOURCE_COST_ORG_ID | NUMBER | 18 | Identifies the source cost organization. | ||
| SOURCE_COST_BOOK_ID | NUMBER | 18 | Identifies the source cost book. | ||
| SOURCE_SET_ID | NUMBER | 18 | Identifies the set identifier of the source cost organization. | ||
| SOURCE_CURRENCY_CODE | VARCHAR2 | 30 | Identifies the source currency code. | ||
| SOURCE_INV_ORG_ID | NUMBER | 18 | Identifies the source inventory organization. It is used to retrieve the profit in inventory cost element. | ||
| COST_ELEMENT_TYPE | VARCHAR2 | 30 | Identifies the cost element type. When the source cost element ID is set to 0, this column specifies what type or category the cost is. For example, if this row is profit in inventory, this column value becomes PROFIT_IN_INVENTORY, specifying it as such. Note that this column has no correlation with the column of the same name (COST_ELEMENT_TYPE) on table CST_COST_ELEMENTS_B. There is no LOOKUP_TYPE for these codes. | ||
| MAPPING_REQUIRED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether cost element to cost element mapping is required on transfers that have multiple legs consisting of physical and logical transfer issues and receipts. The flag helps to avoid unnecessary mapping of cost elements. N - No, Y - Yes. There is no LOOKUP_TYPE for these codes. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_TRANSFER_SRC_COSTS_GT_N1 | Non Unique | DEST_TRANSACTION_ID, SOURCE_TRANSACTION_ID, SOURCE_REC_TRXN_ID, SOURCE_DEP_TRXN_ID, SOURCE_COST_ELEMENT_ID, SOURCE_EXPENSE_POOL_ID, SOURCE_TXFR_COST_DATE |