CST_ITEM_COST_SERVICE_OUT_GT
Global temporary table used in the bulk processing of item cost service requests. This is the output table which contains all the requested costs and is moved to the output view object.
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. Either inventory item identifier or item number is mandatory with inventory item identifier taking the precedence if both are present. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Indicates the item number. Either inventory item identifier or item number is mandatory with inventory item identifier taking the precedence if both are present. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the inventory organization identifier. | ||
| INVENTORY_ORG_CODE | VARCHAR2 | 18 | Indicates the inventory organization code. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the subinventory code. | ||
| LOCATOR_ID | NUMBER | 18 | Indicates the locator identifier. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Indicates the lot number. This is an optional column. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Indicates the serial number. This is an optional column. | ||
| GRADE_CODE | VARCHAR2 | 150 | Indicates the grade code. This is an optional column. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe inventory transactions. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Project number used to stripe inventory transactions. | ||
| TASK_ID | NUMBER | 18 | Identifier of the project task used to stripe inventory transactions. | ||
| TASK_NUMBER | VARCHAR2 | 100 | Task number 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. This is an optional column. Possible values are null/CostBookCode/AverageOfPOs. If no value passed the cost from primary cost book is retrieved. | ||
| KIND_OF_COST_DETAIL | VARCHAR2 | 30 | Indicates the kind of cost detail. For CostBookCode kind of cost, Pass the valid cost book code. | ||
| REFERENCE_DATE | TIMESTAMP | Indicates the reference date time to retrieve the cost of the inventory item. This is an optional column. If no value passed system date time is considered. | |||
| CURRENCY_CODE_IN | VARCHAR2 | 15 | Indicates the target currency code. This is an optional column. | ||
| UOM_CODE_IN | VARCHAR2 | 3 | Indicates the target unit of measure code. This is an optional column. If no value passed the inventory item primary unit of measure. Unit of measure code takes precedence if both unit of measure code and unit of measure values are present. | ||
| UNIT_OF_MEASURE_IN | VARCHAR2 | 25 | Indicates the target unit of measure. This is an optional column. | ||
| ITEM_COST | NUMBER | The retrieved item cost by currency and unit of measure. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | The currency code for the retrieved item cost. | ||
| UOM_CODE | VARCHAR2 | 3 | The unit of measure code for the retrieved item cost. | ||
| ERROR_FLAG | VARCHAR2 | 1 | Indicates the error flag. Possible values are Y/N. | ||
| ERROR_CODE | VARCHAR2 | 30 | Indicates the error code if any error is encountered while retrieving the item cost. | ||
| ERROR_DETAILS | VARCHAR2 | 500 | Indicates the error details as concatenated token names and token values for the error code. | ||
| COST_TYPE | VARCHAR2 | 20 | Indicates the type of item cost. Possible values are ASSET/EXPENSE/CONSIGNED. | ||
| COST_TYPE_DETAIL | VARCHAR2 | 20 | Indicates the cost method of the item or the kind of cost retrieved. Possible values are STANDARD/ACTUAL/PERPETUAL_AVERAGE/PO. | ||
| METHOD_USED | VARCHAR2 | 30 | Indicates the method used to derive the item cost. Possible derivations used are exact match for each cost method or average cost or last layer cost. | ||
| FROM_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the from currency code used during currency conversion. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Indicates the currency conversion type specified on cost organization book. | ||
| CURRENCY_CONVERSION_DATE | DATE | Indicates the currency conversion date. | |||
| FROM_UOM_CODE | VARCHAR2 | 3 | Indicates the from unit of measure code used during unit of measure conversion. | ||
| LOT_CONVERSION_ENABLED_FLAG | VARCHAR2 | 1 | Indicates the item is eligible for lot specific unit of measure conversion. Possible values are Y/N. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ITEM_COST_SERVICE_OUT_U1 | Unique | CST_ITEM_COST_SERVICE_ID |