CST_ITEM_COST_SERVICE_IN_GT
Global temporary table used in the bulk processing of item cost service requests. This table is the input table which captures the incoming VO data.
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. Either INVENTORY_ORG_ID or INVENTORY_ORG_CODE is required. INVENTORY_ORG_ID takes precedence if both columns are populated. | ||
| INVENTORY_ORG_CODE | VARCHAR2 | 18 | Indicates the inventory organization code. Either INVENTORY_ORG_ID or INVENTORY_ORG_CODE is required. INVENTORY_ORG_ID takes precedence if both columns are populated. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the sub-inventory code. This column is optional and can be null. | ||
| LOCATOR_ID | NUMBER | 18 | Indicates the locator identifier. This column is optional and can be null. | ||
| 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. If kind of cost indicator is CostBookCode, this column holds the cost book code value; if AverageOfPOs, this column holds the number of POs to average. | ||
| 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. This column is optional and can be null. If null then the cost is returned in the currency of the cost organization's cost book relationship. | ||
| 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. This column is optional and can be null. If null then the item cost is returned in the item's primary unit of measure. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ITEM_COST_SERVICE_IN_GT_U1 | Unique | CST_ITEM_COST_SERVICE_ID |