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