CST_INTERFACE_STD_HDRS_GT
Transaction temporary table used to hold the standard cost headers by the standard cost bulk desktop integration process.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_INTERFACE_STD_HDRS_GT_PK |
STD_COST_INT_HDR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STD_COST_INT_HDR_ID | NUMBER | 18 | Yes | Generated identifier for bulk desktop integration interface standard cost header record. | |
| SCENARIO_NUMBER | VARCHAR2 | 30 | Identifies the scenario for which the standard cost is entered. | ||
| COST_ORG_CODE | VARCHAR2 | 30 | Identifies the cost organization for which the standard cost is entered. | ||
| COST_BOOK_CODE | VARCHAR2 | 30 | Identifies the cost book for which the standard cost is entered. | ||
| VAL_UNIT_CODE | VARCHAR2 | 1000 | Indicates the valuation unit of the standard cost record. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Indicates the item identifier of the standard cost record. | ||
| STATUS | VARCHAR2 | 1 | Processing status: N=New, E=Error,S=Successful. | ||
| BUY_COST_FLAG | VARCHAR2 | 1 | Indicates the buy cost type. This can be either Y or N. | ||
| BATCH_ID | NUMBER | 18 | Identifies the Batch identifier in which the standard cost is entered. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_INTFC_STD_HDRS_GT_U1 | Unique | STD_COST_INT_HDR_ID |