CST_PROCESSING_ORG_BOOK_GT
Global temporary table used in the cost preprocessor. It holds the Cost oraganization, Cost book combinations for a given start and end dates.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
CST_PROCESSING_ORG_BOOK_G_PK |
COST_ORG_ID, COST_BOOK_ID |
Columns
| Name |
|---|
|
COST_ORG_IDNUMBER18YesCost Organization assigned to the Inventory Organization(s). COST_BOOK_IDNUMBER18YesCost Book assigned to the Cost Organization. ORG_BOOK_FROM_DATEDATEThe start date of organization - Book for processing. ORG_BOOK_TO_DATEDATEThe end date of organization - Book for processing. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PROCESSING_ORG_BOOK_GT_U1 | Unique | COST_ORG_ID, COST_BOOK_ID |