| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRRMANASSMNT | Assessment Table | 12 | UNIT_OF_MEASURE | 32 Char GUID | nvarchar | 32 | 0 | | |
2 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 9 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
3 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 10 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
4 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 10 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
5 | J_1UF_TP_PRICES | Intervals of Market Prices of Controlled Transactions | 9 | UNIT_OF_MEASURE | Base Unit of Measure | nvarchar | 3 | 0 | | |
6 | J_3RF_TP_PRICES | Intervals of Market Prices of Controlled Transactions | 9 | UNIT_OF_MEASURE | Base Unit of Measure | nvarchar | 3 | 0 | | |
7 | TEXT_CTY_EXPOS | Commodity Price Exposure | 30 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
8 | THAEXT_EXPOS_COP | Obsolet: Commodity exposure pricing data | 9 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
9 | THAEXT_TRANS_COP | Commodity exposure pricing data | 17 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
10 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 18 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
TOPBudgeting and Availability Control |
11 | GMBDGTLINE | Budget Document Line | 27 | UNIT_OF_MEASURE | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
12 | GMHBDGTLINE | Budget Line: Held Documents | 28 | UNIT_OF_MEASURE | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPCentral Part of Product Master |
13 | COMM_PR_GTIN | GTIN - Global Trade Item Number | 4 | UNIT_OF_MEASURE | Units of Measure of Product | nvarchar | 3 | 0 | | |
14 | COMM_PR_GTINH | GTIN - Global Trade Item Number History | 5 | UNIT_OF_MEASURE | Units of Measure of Product | nvarchar | 3 | 0 | | |
TOPChargeback |
15 | WCOCOI | Condition Contract: Eligible Partner | 15 | UNIT_OF_MEASURE | Unit of Measure | nvarchar | 3 | 0 | | |
TOPExcise Duty |
16 | /BEV2/CS_C_PCODE | Product Codes | 8 | UNIT_OF_MEASURE | EMCS: Unit of Measurement for Report in e-AAD | nvarchar | 3 | 0 | | |
TOPGRC Risk Management |
17 | GRRMANALASSMNT | Assessment Table | 11 | UNIT_OF_MEASURE | 32 Char GUID | nvarchar | 32 | 0 | | |
TOPMaster Data |
18 | CMS_AST | Asset Details | 50 | UNIT_OF_MEASURE | Unit of Measure of Quantity | nvarchar | 3 | 0 | | |
19 | CMS_AST_HIST | Asset Value History | 10 | UNIT_OF_MEASURE | Unit of Measure of Quantity | nvarchar | 3 | 0 | | |
TOPTransaction Management |
20 | TCHT_HD_BEWEG_CY | SFGDT Commodity Flows Table | 9 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
21 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 142 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
22 | OTC_CONV_FINKO | Backup Table for Financial Transaction Conditions | 88 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
23 | OTC_CONV_IFINKO | Backup Table for Financial Transaction Underlying Conditions | 87 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
24 | TCORT_CODCO | Deal: Conditions | 74 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
25 | TCORT_CODULFL | Deal: Underlying Flows | 35 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
26 | TEXT_POS_FLOW | Exposure Position Flows | 49 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
27 | TEXT_REXP_ITEM | Raw Exposure Item | 11 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
28 | TEXT_REXP_SUBIT | Sub Raw Exposures (Split Items) | 8 | UNIT_OF_MEASURE | Unit of measure | nvarchar | 3 | 0 | | |
29 | TEXT_TRANSACTION | Unmatched Exposure Business Transactions | 46 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
30 | THAEXT_EXPOS_CO | Commodity exposure | 7 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
31 | THAEXT_TRANS_CO | Transaction for commodity price exposure | 9 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
32 | THMHRT_HR | Hedge Relationship | 43 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
33 | THMT_HEDGE_ITEM | Hedged Item | 20 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
34 | VTBFHAPO | Transaction Flow | 142 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
35 | VTBFHAPO_MIGR | Migrated Financial Flows | 142 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
36 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 142 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
37 | VTBFINKO | Transaction Condition | 88 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
38 | VTIFHAPO | Underlying transaction flows | 78 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
39 | VTIFINKO | Underlying transaction conditions | 87 | UNIT_OF_MEASURE | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | |
TOPVehicle Management System |
40 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 12 | UNIT_OF_MEASURE | Base Unit of Measure | nvarchar | 3 | 0 | | |