| 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 | SGSART | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | TZPA | VVSART | Allow NULL? |
| 3 | AUSWT | Evaluation type in Risk Management | nvarchar | 4 | 0 | CHAR | (N' ') | No | JBREVAL | TV_AUSWT | Allow NULL? |
| 4 | CALCVERF | Calculation Routines | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ATVC1 | TV_CALCV | Allow NULL? |
| 5 | BCURVE | Bid valuation curve type for mark-to-market | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVE | Allow NULL? |
| 6 | BCURVEB | Ask Valuation Curve: Mark-to-Market | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVEB | Allow NULL? |
| 7 | BCURVEM | Middle valuation curve: Mark-to-market | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVEM | Allow NULL? |
| 8 | DVOLARTB | Volatility Type "Ask Rates" for Foreign Exchange | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_VOLARTB | Allow NULL? |
| 9 | DVOLARTG | Volatility Type "Bid Rates" for Foreign Exchange | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_VOLARTG | Allow NULL? |
| 10 | DVOLARTM | Volatility Type Middle Rates for Foreign Exchange | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_VOLARTM | Allow NULL? |
| 11 | ZVOLARTB | Volatility Type 'Ask' for Interest Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_ZVOLARB | Allow NULL? |
| 12 | ZVOLARTG | Volatility Type 'Bid' for Interest Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_ZVOLARG | Allow NULL? |
| 13 | ZVOLARTM | Volatility Type Middle Rates for Interest | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_ZVOLARM | Allow NULL? |
| 14 | WVOLARTB | Volatility Type 'Ask' for Securities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_WVOLARB | Allow NULL? |
| 15 | WVOLARTG | Volatility Type 'Bid' for Securities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_WVOLARG | Allow NULL? |
| 16 | WVOLARTM | Volatility Type Middle Rates for Securities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_WVOLARM | Allow NULL? |
| 17 | SVOLART | Volatility Type for Convexity Adjustment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_SVOLART | Allow NULL? |
| 18 | WPPVART | Calculate Theoretical NPV | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_WPVART | Allow NULL? |
| 19 | WKTAGE | Maximum age of historical price in days | decimal | 3 | 0 | DEC | ((0)) | Yes | | TV_WKTAGE | |
