| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RIDXRT | Internal Number of the Generic Transaction | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | NGIDNR | Sequence Number for a Transaction ID in Primary Transaction | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | POBJNR | Pointer to Original Transaction | nvarchar | 22 | 0 | | | | Allow NULL? |
| 5 | PWKN | RM: Pointer to TR ID Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 6 | AGGREGRULE | Aggregation Rule in Hierarchy of Data Type of Fin. Trans. | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | RMBEWREG | Valuation Rule | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | GFORM | Transaction Form | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | GDETAIL | Transaction Form - Detail Information | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | KATEKZ | Indicator for spot and forward transactions | char | 1 | 0 | | | | Allow NULL? |
| 11 | AGGRKZ | Indicator for aggregated transactions | char | 1 | 0 | | | | Allow NULL? |
| 12 | DBLFZ | Start of Term | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DELFZ | End of Term/End of Period of Notice | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | SFGTYP | Buy/Sell | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | SNOTTYPE | Quotation type for option, future, security etc. | char | 1 | 0 | | | | Allow NULL? |
| 16 | SNOMWHR | Currency of Nominal Amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | BNOMINAL | Nominal amount | decimal | 17 | 2 | | | | |
| 18 | ASTUECK | Number of units for unit-quoted securities | decimal | 15 | 5 | | | | |
| 19 | WGSCHFT1 | Currency of Outgoing Side | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | WGSCHFT2 | Currency of Incoming Side | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | BNOMI1 | Nominal amount of outgoing side | decimal | 17 | 2 | | | | |
| 22 | BNOMI2 | Nominal amount of incoming side | decimal | 17 | 2 | | | | |
| 23 | BSALDO | Residual balance of a contract (account) | decimal | 17 | 2 | | | | |
| 24 | DEFSZ | Date of fixed period end | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | RANL | Security | nvarchar | 13 | 0 | | | | Allow NULL? |
| 26 | RHANDPL | Exchange | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | IDX | Securities Index | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | IDXVAL | Index Value | decimal | 15 | 6 | | | | |
| 29 | BPIDX | Value of an index point | decimal | 17 | 2 | | | | |
| 30 | SPIDX | Currency of Value of an Index Point | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | KKURSWP | Current price of futures contract/option on futures contract | decimal | 15 | 6 | | | | |
| 32 | DDEKSE | RM: Date on which the average purchase price was determined | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | SSHLNG | Short/Long Indicator | char | 1 | 0 | | | | Allow NULL? |
| 34 | SEZWHR | Currency of external commitment capital | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | BEZWHR | Amount of external commit. capital in currency | decimal | 17 | 2 | | | | |
| 36 | RIDEXTRTEXT | External Number of the External Generic Transaction | nvarchar | 20 | 0 | | | | Allow NULL? |
| 37 | BETICK | Tick Amount (Commodity) | decimal | 13 | 7 | | | | |
| 38 | BWTICK | Tick Value (Commodity) | decimal | 13 | 7 | | | | |
| 39 | URANL | Security ID Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 40 | CTY_ID | Commodity ID | nvarchar | 18 | 0 | | | | Allow NULL? |
| 41 | QUOTSRC | Quotation Source | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | BETICK_SEC | Tick as amount | decimal | 13 | 2 | | | | |
| 43 | BWTICK_SEC | Tick value | decimal | 13 | 2 | | | | |
| 44 | WWTICK | Tick Value Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 45 | PPTICK | Tick in percentage points | decimal | 10 | 7 | | | | |
| 46 | PITICK | Tick in index points | decimal | 11 | 6 | | | | |
| 47 | CTY_QUANTITY | Quantity | decimal | 13 | 3 | | | | |
| 48 | CTY_UOM | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 49 | CSPREAD | Credit Spread | decimal | 10 | 7 | | | | |
| 50 | CTY_ID2 | Commodity ID | nvarchar | 18 | 0 | | | | Allow NULL? |
| 51 | CSPREAD_FWD | Credit Spread | decimal | 10 | 7 | | | | |
| 52 | EXP_APPR_CAT | Commodity Exposure Approach Category | char | 1 | 0 | | | | Allow NULL? |
| 53 | CONTRACT_VALUE | Contract Value | decimal | 13 | 2 | | | | |
| 54 | CONTRACT_VALUE_CURR | Contract Value Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 55 | FORWARD_DATE | Forward Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | BETICK_CTY_CUNIT | Currency unit | nvarchar | 5 | 0 | | | | Allow NULL? |
| 57 | LEAD_FGET | Selected Transaction | char | 1 | 0 | | | | Allow NULL? |
