CST_ITEM_COST_SERVICE_GT
Global temporary table used in the bulk processing of item cost service requests. This holds the transformed data for set based processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_ITEM_COST_SERVICE_ID | NUMBER | 18 | Yes | Indicates the unique identifier for the item cost request. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the inventory item identifier. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Identifies the inventory item name. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the inventory organization identifier. | ||
| INVENTORY_ORG_CODE | VARCHAR2 | 25 | Indicates the inventory organization code. This value is user entered and can be null. The column was added to support Oracle Integration Cloud Service. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the sub-inventory code. | ||
| LOCATOR_ID | NUMBER | 18 | Indicates the locator identifier. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Indicates the lot number. This column is optional and can be null. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Indicates the serial number of the item. | ||
| GRADE_CODE | VARCHAR2 | 150 | Indicates the grade of the lot for a grade controlled Item. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe inventory transactions. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Project used to stripe inventory transactions. | ||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe inventory transactions. | ||
| TASK_NUMBER | VARCHAR2 | 100 | Task used to stripe inventory transactions. | ||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe inventory transactions. | ||
| KIND_OF_COST | VARCHAR2 | 30 | Indicates the kind of cost. Possible values are null, 'CostBookCode', or 'AverageOfPOs'. | ||
| KIND_OF_COST_DETAIL | VARCHAR2 | 30 | Indicates the kind of cost detail. | ||
| REFERENCE_DATE | TIMESTAMP | Indicates the reference date. It specifies the effective date time for which to retrieve the cost. If null then the system date time is used. | |||
| CURRENCY_CODE_IN | VARCHAR2 | 15 | Indicates the target currency code. | ||
| UOM_CODE_IN | VARCHAR2 | 3 | Indicates the target UOM code. This column is optional and can be null. If null then the item cost is returned in the item's primary unit of measure. If both UOM_CODE_IN and UNIT_OF_MEASURE_IN are populated, UOM_CODE_IN will take precedence. | ||
| UNIT_OF_MEASURE_IN | VARCHAR2 | 25 | Indicates the target unit of measure. | ||
| COST_BOOK_CODE | VARCHAR2 | 30 | Indicates the cost book code associated with the cost organization. | ||
| AVERAGE_OF_POS | NUMBER | 18 | Indicates the number of POs for which to average the item cost | ||
| COST_ORG_ID | NUMBER | 18 | Indicates the cost organization identifier. | ||
| COST_BOOK_ID | NUMBER | 18 | Indicates the cost book identifier. | ||
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Indicates the item cost profile identifier. | ||
| COST_PROFILE_ID | NUMBER | 18 | Indicates the cost profile identifier. | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | Indicates the cost method code. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Indicates the currency conversion type. | ||
| CURRENCY_CONVERSION_DATE | DATE | Indicates the currency conversion date. | |||
| INV_ORG_CODE | VARCHAR2 | 18 | Indicates the inventory organization code. This value is derived and used internally. The column was added to improve performance for processing item cost requests. | ||
| COST_ORG_CODE | VARCHAR2 | 150 | Indicates the cost organization code. | ||
| VAL_STRUCTURE_ID | NUMBER | 18 | Indicates the valuation structure identifier. | ||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Indicates the structure instance number. | ||
| VAL_STRUCTURE_TYPE_CODE | VARCHAR2 | 30 | Indicates the valuation structure type code. | ||
| VAL_UNIT_ID | NUMBER | 18 | Indicates the valuation unit identifier for transaction. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ITEM_COST_SERVICE_GT_U1 | Unique | CST_ITEM_COST_SERVICE_ID |