| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GBT/O_BAT_HDR | Batch master - Header table | 17 | PROD_DATE | Date of Manufacture | nvarchar | 8 | 0 | | |
2 | GHO_ALERT | Store Network Alerts | 6 | PROD_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
3 | GHO_ALLOC_PREP | Allocation Results Header | 7 | PROD_DATE | Production Start Date | nvarchar | 8 | 0 | | |
4 | GHO_ALLOC_RUN_JB | Allocation Results Header | 7 | PROD_DATE | Production Start Date | nvarchar | 8 | 0 | | |
5 | GHO_DM_ALLOC_RES | Allocation Results | 3 | PROD_DATE | Production Start Date | nvarchar | 8 | 0 | | |
6 | GHO_DM_RESULTS | Deferment Results | 3 | PROD_DATE | Production Start Date | nvarchar | 8 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
7 | T8PSA_ADJUST_VOL | Adjustment Volumes | 8 | PROD_DATE | PSA Production date | nvarchar | 8 | 0 | | |
8 | T8PSA_LIFT_TERM | Lifting Volumes by terminal | 5 | PROD_DATE | Lifting Date | nvarchar | 8 | 0 | | |
9 | T8PSA_LIFT_VOL | Lifting Volumes | 9 | PROD_DATE | Lifting Date | nvarchar | 8 | 0 | | |
10 | T8PSA_PRICE_VOL | Prices for Volumes | 8 | PROD_DATE | PSA Production date | nvarchar | 8 | 0 | | |
11 | T8PSA_PROD_VOL | Production Volumes | 8 | PROD_DATE | PSA Production date | nvarchar | 8 | 0 | | |
12 | T8PSA_TERM_PRICE | PSA Price per terminal | 5 | PROD_DATE | PSA Production date | nvarchar | 8 | 0 | | |
13 | T8PSC_ADJUST | PSC Adjustment Data | 8 | PROD_DATE | PSC Production date | nvarchar | 8 | 0 | | |
14 | T8PSC_LIFT | PSC Lifting Data | 8 | PROD_DATE | PSC Production date | nvarchar | 8 | 0 | | |
15 | T8PSC_PRICE | PSC Production Prices | 8 | PROD_DATE | PSC Production date | nvarchar | 8 | 0 | | |
16 | T8PSC_PROD | PSC Production Data | 8 | PROD_DATE | PSC Production date | nvarchar | 8 | 0 | | |
TOPNetwork Operations |
17 | GHO_PP_PTABLE_LN | Schedule Lines Table for Results of GHO Planning Table | 3 | PROD_DATE | Date of Production | nvarchar | 8 | 0 | | |
TOPProduction Allocation |
18 | GHO_ALLOCRES_H | Allocation Results Header | 7 | PROD_DATE | Production Start Date | nvarchar | 8 | 0 | | |
19 | GHO_ALLOC_RES_H | OBSOLETE - Table for storing allocation results (Header) | 7 | PROD_DATE | Production Start Date | nvarchar | 8 | 0 | | |
TOPSAP Retail Store |
20 | WSGM_ITEM_DB_TMP | SRS GM: Temporary Persistence for Item Data | 15 | PROD_DATE | Date of Manufacture | nvarchar | 8 | 0 | | |
21 | WSGR_ITEM_DB_TMP | SRS GR: Temporary Persistence for Item Data | 11 | PROD_DATE | Date of Manufacture | nvarchar | 8 | 0 | | |