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 VO.
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_ID or ITEM_NUMBER is required. INVENTORY_ITEM_ID takes precedence if both columns are populated. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Indicates the item number. Either INVENTORY_ITEM_ID or ITEM_NUMBER is required. INVENTORY_ITEM_ID takes precedence if both columns are populated. | ||
| 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 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. This column is optional and can be null. | ||
| GRADE_CODE | VARCHAR2 | 150 | Indicates the grade code. This column is optional and can be null. | ||
| 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'. This column is optional and can be null. If null then the cost from the primary cost book is retrieved. | ||
| 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. | ||
| ITEM_COST | NUMBER | The retrieved item cost by currency and UOM. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | The currency code for the retrieved item cost. | ||
| UOM_CODE | VARCHAR2 | 3 | The UOM code for the retrieved item cost. | ||
| ERROR_FLAG | VARCHAR2 | 1 | Indicates the error flag: 'Y' = error, 'N' = no error. | ||
| ERROR_CODE | VARCHAR2 | 30 | Indicates the error code if any error is encountered while retrieving the item cost. For example: CST_PREP_CURR_CONV_ERROR. | ||
| ERROR_DETAILS | VARCHAR2 | 500 | Indicates the error details as concatenated token names and token values for the error code. For example: FROM_CURRENCY:USD:TO_CURRENCY:SGD:CONVERSION_DATE:25-04-2016:CONVERSION_TYPE:Corporate. | ||
| 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, or PO. | ||
| METHOD_USED | VARCHAR2 | 30 | Indicates the SQL used to derive the item cost. | ||
| FROM_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the from currency code used during currency conversion. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Indicates the currency converion type specificed on cost organization book. | ||
| CURRENCY_CONVERSION_DATE | DATE | Indicates the currency conversion date. | |||
| FROM_UOM_CODE | VARCHAR2 | 3 | Indicates the from UOM code used during unit of measure conversion. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ITEM_COST_SERVICE_OUT_U1 | Unique | CST_ITEM_COST_SERVICE_ID |