| 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 | SCLASS | Datafeed: Instrument Class | nvarchar | 2 | 0 | CHAR | (N' ') | No | VTBDFC | TB_CLASS | Allow NULL? |
| 3 | RKEY1 | Datafeed: Key 1 | nvarchar | 15 | 0 | CHAR | (N' ') | No | | TB_KEY1 | Allow NULL? |
| 4 | RKEY2 | Datafeed: Key 2 | nvarchar | 15 | 0 | CHAR | (N' ') | No | | TB_KEY2 | Allow NULL? |
| 5 | SINSTRUMNT | Datafeed: Rate type | nvarchar | 5 | 0 | CHAR | (N' ') | No | | TB_INSTR | Allow NULL? |
| 6 | RFEEDNAME | Market Data: Data Provider | nvarchar | 10 | 0 | CHAR | (N' ') | No | VTBDFF | TB_DFNAME | Allow NULL? |
| 7 | RZUSATZ | Datafeed: Additional key | nvarchar | 10 | 0 | CHAR | (N' ') | No | | TB_ZUSATZ | Allow NULL? |
| 8 | SMETACLASS | Datafeed: Meta instrument class | nvarchar | 2 | 0 | CHAR | (N' ') | No | | TB_MCLASS | Allow NULL? |
| 9 | SCLASS2 | Datafeed: Instrument Class | nvarchar | 2 | 0 | CHAR | (N' ') | No | VTBDFC | TB_CLASS | Allow NULL? |
| 10 | RKEY12 | Datafeed: Key 1 | nvarchar | 15 | 0 | CHAR | (N' ') | No | | TB_KEY1 | Allow NULL? |
| 11 | RKEY22 | Datafeed: Key 2 | nvarchar | 15 | 0 | CHAR | (N' ') | No | | TB_KEY2 | Allow NULL? |
| 12 | SSTATS | Datafeed: Status of market date | nvarchar | 2 | 0 | CHAR | (N' ') | No | | TB_STATS | Allow NULL? |
| 13 | SPOOLID | Datafeed: Spool- / Workflow identifier | decimal | 15 | 0 | DEC | ((0)) | Yes | | TB_SPOOLID | |
| 14 | ERROR | Datafeed: Error message | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TB_ERROR | Allow NULL? |
| 15 | RUPDHIST | Datafeed: Flag for refreshing R/3 tables | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_UPDHIST | Allow NULL? |
| 16 | RDONE | Datafeed: Flag for update indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_DONE | Allow NULL? |
| 17 | RSUPID | Datafeed: Supplier ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_SUPID | Allow NULL? |
| 18 | RCONID | Datafeed: Contributor ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TB_CONID | Allow NULL? |
| 19 | RCONCN | Datafeed: contributor country | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TB_CONCN | Allow NULL? |
| 20 | DDATE | Datafeed: Value date in SAP format | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_SDATE | Allow NULL? |
| 21 | TTIME | Datafeed: Time of value (SAP format) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_STIME | Allow NULL? |
| 22 | VALUE | Datafeed: Value of requested property | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TB_VALUE | Allow NULL? |
| 23 | CURRENCY | Datafeed: Currency key | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TB_CURR | Allow NULL? |
| 24 | FFACT | Datafeed: Factor for units of from-currency | decimal | 9 | 0 | DEC | ((0)) | Yes | | TB_FFACT | |
| 25 | TFACT | Datafeed: Factor for units of to-currency | decimal | 9 | 0 | DEC | ((0)) | Yes | | TB_TFACT | |
| 26 | MKIND | Datafeed: Price notation for security prices | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TB_MKIND | Allow NULL? |
| 27 | RINID1 | Datafeed: Instrument name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TB_INID1 | Allow NULL? |
| 28 | RINID2 | Datafeed: Data source | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | TB_INID2 | Allow NULL? |
| 29 | SPRPTY | Market data: Instrument property | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | TB_PRPTY | Allow NULL? |
| 30 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 31 | UKURSART1 | Datafeed: Rate type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TB_INSTR | Allow NULL? |
| 32 | UKURSART2 | Datafeed: Rate type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TB_INSTR | Allow NULL? |
| 33 | ZEITRAUM | Datafeed: period | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_ZEITR | Allow NULL? |
| 34 | KONFIDENZ | Datafeed: confidence level | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | TB_KONFID | Allow NULL? |
| 35 | DECAY | Datafeed: decay factor | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | TB_DECAY | Allow NULL? |
| 36 | REALTIME | Datafeed: Indicator for real-time data supply | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_REALTME | Allow NULL? |
| 37 | LIMIT | Datafeed: Rate monitoring | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | TB_LIMIT | |
| 38 | SPOOLID2 | Datafeed: Spool- / Workflow identifier | decimal | 15 | 0 | DEC | ((0)) | Yes | | TB_SPOOLID | |
| 39 | TIMEDEP | Datafeed: Indicator for intraday rates/prices | char | 1 | 0 | CHAR | (N' ') | No | | TB_TIMEDEP | Allow NULL? |
| 40 | MQUOTE | Datafeed: Indirect (x) or Direct Quotation ( ) | char | 1 | 0 | CHAR | (N' ') | No | | TB_QUOTE | Allow NULL? |
| 41 | CCY_UNIT | Datafeed: Currency | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TB_CCYUNIT | Allow NULL? |
| 42 | UOM | Datafeed: Unit of Measurement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | TB_UOM | Allow NULL? |
| 43 | PUT_CALL_IND | Datafeed: Put/Call Indicator for Listed Options | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PUTCALL | Allow NULL? |
| 44 | STRIKE_AMOUNT | Datafeed: Strike Price for Listed Options | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TB_STRIKE_AMOUNT | Allow NULL? |
