| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | RIDXRT | Internal Number of the Generic Transaction | nvarchar | 20 | 0 | CHAR | (N' ') | No | JBRDBKO | JBRIDXRT | Allow NULL? |
| 3 | NGIDNR | Sequence Number for a Transaction ID in Primary Transaction | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | JBNGIDNR | Allow NULL? |
| 4 | POBJNR | Pointer to Original Transaction | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | JBPOBJNR | Allow NULL? |
| 5 | PWKN | RM: Pointer to TR ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | JBRRANLW | Allow NULL? |
| 6 | AGGREGRULE | Aggregation Rule in Hierarchy of Data Type of Fin. Trans. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JBRAGGREG | Allow NULL? |
| 7 | RMBEWREG | Valuation Rule | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JBRBEWREG | JBRBEWREG_ | Allow NULL? |
| 8 | GFORM | Transaction Form | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | VTVFGKOGF | TV_GFORM | Allow NULL? |
| 9 | GDETAIL | Transaction Form - Detail Information | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | VTVFGKOGF | TV_GDETAIL | Allow NULL? |
| 10 | KATEKZ | Indicator for spot and forward transactions | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_KATEKZ | Allow NULL? |
| 11 | AGGRKZ | Indicator for aggregated transactions | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_AGGRKZ | Allow NULL? |
| 12 | DBLFZ | Start of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBLFZ | Allow NULL? |
| 13 | DELFZ | End of Term/End of Period of Notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JBRDELFZ | Allow NULL? |
| 14 | SFGTYP | Buy/Sell | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | TV_SFGTYP | Allow NULL? |
| 15 | SNOTTYPE | Quotation type for option, future, security etc. | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_NOTTYPE | Allow NULL? |
| 16 | SNOMWHR | Currency of Nominal Amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TV_NOMWAE | Allow NULL? |
| 17 | BNOMINAL | Nominal amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | TV_NOMINAL | |
| 18 | ASTUECK | Number of units for unit-quoted securities | decimal | 15 | 5 | DEC | ((0)) | Yes | | ASTUECK | |
| 19 | WGSCHFT1 | Currency of Outgoing Side | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WGSCHF1 | Allow NULL? |
| 20 | WGSCHFT2 | Currency of Incoming Side | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WGSCHF2 | Allow NULL? |
| 21 | BNOMI1 | Nominal amount of outgoing side | decimal | 17 | 2 | CURR | ((0)) | Yes | | TV_NOMI1 | |
| 22 | BNOMI2 | Nominal amount of incoming side | decimal | 17 | 2 | CURR | ((0)) | Yes | | TV_NOMI2 | |
| 23 | BSALDO | Residual balance of a contract (account) | decimal | 17 | 2 | CURR | ((0)) | Yes | | TV_BSALDO | |
| 24 | DEFSZ | Date of fixed period end | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDEFSZ | Allow NULL? |
| 25 | RANL | Security | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | JBRRANL | Allow NULL? |
| 26 | RHANDPL | Exchange | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TWH01 | VVRHANDPL | Allow NULL? |
| 27 | IDX | Securities Index | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | INDEXD | IDX | Allow NULL? |
| 28 | IDXVAL | Index Value | decimal | 15 | 6 | DEC | ((0)) | Yes | | TV_IDXVAL | |
| 29 | BPIDX | Value of an index point | decimal | 17 | 2 | CURR | ((0)) | Yes | | TV_BPIDX | |
| 30 | SPIDX | Currency of Value of an Index Point | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TV_SPIDX | Allow NULL? |
| 31 | KKURSWP | Current price of futures contract/option on futures contract | decimal | 15 | 6 | DEC | ((0)) | Yes | | TV_KURSFUT | |
| 32 | DDEKSE | RM: Date on which the average purchase price was determined | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DDEKSE | Allow NULL? |
| 33 | SSHLNG | Short/Long Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JBSSHLNG | Allow NULL? |
| 34 | SEZWHR | Currency of external commitment capital | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | KL_EXTZKWHR | Allow NULL? |
| 35 | BEZWHR | Amount of external commit. capital in currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | KL_EXTZK | |
| 36 | RIDEXTRTEXT | External Number of the External Generic Transaction | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | JBRIDEXTRTEXT | Allow NULL? |
| 37 | BETICK | Tick Amount (Commodity) | decimal | 13 | 7 | DEC | ((0)) | Yes | | TI_BETICK_COMMODITY | |
| 38 | BWTICK | Tick Value (Commodity) | decimal | 13 | 7 | DEC | ((0)) | Yes | | TI_BWTICK_COMMODITY | |
| 39 | URANL | Security ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | VVRANLW | Allow NULL? |
| 40 | CTY_ID | Commodity ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | TRCO_COMM_ID | Allow NULL? |
| 41 | QUOTSRC | Quotation Source | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TCR_CTY_QUOTSRC | Allow NULL? |
| 42 | BETICK_SEC | Tick as amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | TI_BETICK | |
| 43 | BWTICK_SEC | Tick value | decimal | 13 | 2 | CURR | ((0)) | Yes | | TI_BWTICK | |
| 44 | WWTICK | Tick Value Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TI_WWTICK | Allow NULL? |
| 45 | PPTICK | Tick in percentage points | decimal | 10 | 7 | DEC | ((0)) | Yes | | TI_PPTICK | |
| 46 | PITICK | Tick in index points | decimal | 11 | 6 | DEC | ((0)) | Yes | | TI_PITICK | |
| 47 | CTY_QUANTITY | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FTR_QUAN | |
| 48 | CTY_UOM | Unit of Measure for the Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | TPM_CTY_UOM | Allow NULL? |
| 49 | CSPREAD | Credit Spread | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTR_CSPREAD | |
| 50 | CTY_ID2 | Commodity ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | TRCO_COMM_ID | Allow NULL? |
| 51 | CSPREAD_FWD | Credit Spread | decimal | 10 | 7 | DEC | ((0)) | Yes | | FTR_CSPREAD | |
| 52 | EXP_APPR_CAT | Commodity Exposure Approach Category | char | 1 | 0 | NUMC | (N'0') | Yes | | FTR_EXP_APPR_CAT | Allow NULL? |
| 53 | CONTRACT_VALUE | Contract Value | decimal | 13 | 2 | CURR | ((0)) | Yes | | JBR_CONTRACT_VALUE | |
| 54 | CONTRACT_VALUE_CURR | Contract Value Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | JBR_CONTRACT_VALUE_CURR | Allow NULL? |
| 55 | FORWARD_DATE | Forward Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FTR_FWDDATE | Allow NULL? |
| 56 | BETICK_CTY_CUNIT | Currency unit | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | VVSRUNIT | Allow NULL? |
| 57 | LEAD_FGET | Selected Transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | LEAD_FGET | Allow NULL? |
