| 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 | RMBEWREG | Valuation Rule | nvarchar | 8 | 0 | CHAR | (N' ') | No | JBRBEWREG | JBRBEWREG_ | Allow NULL? |
| 3 | AUSWT | Evaluation type in Risk Management | nvarchar | 4 | 0 | CHAR | (N' ') | No | JBREVAL | TV_AUSWT | Allow NULL? |
| 4 | KURSTG | Exchange rate type bid | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | TB_KURSTG | Allow NULL? |
| 5 | KURSTB | Exchange rate type ask | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | TB_KURSTB | Allow NULL? |
| 6 | BCURVE | Bid valuation curve type for mark-to-market | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVE | Allow NULL? |
| 7 | BCURVEB | Ask Valuation Curve: Mark-to-Market | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVEB | Allow NULL? |
| 8 | WPKURSART | Security price type for evaluations | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TW56 | TB_WKURSA | Allow NULL? |
| 9 | IDXART | Index Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | INDEXA | IDXART | Allow NULL? |
| 10 | DVOLARTG | Volatility Type "Bid Rates" for Foreign Exchange | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_VOLARTG | Allow NULL? |
| 11 | DVOLARTB | Volatility Type "Ask Rates" for Foreign Exchange | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_VOLARTB | Allow NULL? |
| 12 | ZVOLARTG | Volatility Type 'Bid' for Interest Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_ZVOLARG | Allow NULL? |
| 13 | ZVOLARTB | Volatility Type 'Ask' for Interest Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_ZVOLARB | Allow NULL? |
| 14 | WVOLARTG | Volatility Type 'Bid' for Securities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_WVOLARG | Allow NULL? |
| 15 | WVOLARTB | Volatility Type 'Ask' for Securities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_WVOLARB | Allow NULL? |
| 16 | IXVOLARTG | Volatility Type for Security Indexes; Bid Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TV_IXVOLG | Allow NULL? |
| 17 | IXVOLARTB | Volatility Type for Security Indexes; Ask Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TV_IXVOLB | Allow NULL? |
| 18 | HWVOLARTG | Volatility Type for Yield Curve Model, Bid Rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TV_HWVOLAG | Allow NULL? |
| 19 | HWVOLARTB | Volatility Type for Yield Curve Model, Ask Rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TV_HWVOLAB | Allow NULL? |
| 20 | KORRARTG | 'Bid' Correlation Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATKO1 | TV_KORRARTG | Allow NULL? |
| 21 | KORRARTB | 'Ask' Correlation Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATKO1 | TV_KORRARTB | Allow NULL? |
| 22 | VNAME | Volatility Name | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | ATVO0 | TV_VNAME | Allow NULL? |
| 23 | COVOLTYPB | Volitility Type "Bid" for Commodity Transactions | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_COVOTYPB | Allow NULL? |
| 24 | COVOLTYPA | Volitility Type "Ask" for Commodity Transactions | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_COVOTYPA | Allow NULL? |
| 25 | COPRTYPE | Commodity Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TRCOCC_QUOTTYPE | TCR_CTY_QUOTTYPE | Allow NULL? |
| 26 | BCURVE_RF | Bid Valuation Curve : Risk Free | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVE_RF | Allow NULL? |
| 27 | BCURVEB_RF | Ask Valuation Curve : Risk Free | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVEB_RF | Allow NULL? |
| 28 | BSP_CURVE_B | Basis Spread Curve Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCBSCURVE | FTBB_YC_BSCT | Allow NULL? |
| 29 | BSP_CURVE_A | Basis Spread Curve Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCBSCURVE | FTBB_YC_BSCT | Allow NULL? |
| 30 | KURSTM | Exchange rate type middle | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | TB_KURSTM | Allow NULL? |
| 31 | BCURVEM | Middle valuation curve: Mark-to-market | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVEM | Allow NULL? |
| 32 | DVOLARTM | Volatility Type Middle Rates for Foreign Exchange | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_VOLARTM | Allow NULL? |
| 33 | ZVOLARTM | Volatility Type Middle Rates for Interest | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_ZVOLARM | Allow NULL? |
| 34 | WVOLARTM | Volatility Type Middle Rates for Securities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_WVOLARM | Allow NULL? |
| 35 | IXVOLARTM | Volatility Type for Security Indexes; Middle Rates | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TV_IXVOLM | Allow NULL? |
| 36 | HWVOLARTM | Volatility Type for Yield Curve Model, Middle Rate | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TV_HWVOLAM | Allow NULL? |
| 37 | KORRARTM | 'Middle' Correlation Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATKO1 | TV_KORRARTM | Allow NULL? |
| 38 | COVOLTYPM | Volatility Type 'Middle Rate' for Commodities | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_COVOTYPM | Allow NULL? |
| 39 | BCURVEM_RF | Middle Valuation Curve : Risk Free | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JBD14 | TB_BCURVEM_RF | Allow NULL? |
| 40 | BSP_CURVE_M | Basis Spread Curve Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCBSCURVE | FTBB_YC_BSCT | Allow NULL? |
| 41 | XREAL_CASHF | Include Real Cash Flows | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_REAL_CF | Allow NULL? |
| 42 | CALCVERF | Calculation Routines | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ATVC1 | TV_CALCV | Allow NULL? |
| 43 | WPPVART | Calculate Theoretical NPV | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_WPVART | Allow NULL? |
| 44 | WKTAGE | Maximum age of historical price in days | decimal | 3 | 0 | DEC | ((0)) | Yes | | TV_WKTAGE | |
| 45 | SVOLART | Volatility Type for Convexity Adjustment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | ATVO1 | TB_SVOLART | Allow NULL? |
| 46 | XHOR_CASHF | Is cash flow at horizon included in NPV? | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_XHOR_CF | Allow NULL? |
| 47 | XINTOPT | Value Swaptions as Interest Rate Options | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_XINTOPT | Allow NULL? |
| 48 | XIMPLOPT | Break Down Implied Options | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_XIMPLOPT | Allow NULL? |
| 49 | NAMEAUS | Disbursement Procedure (Loan) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JBTAUSVER | JBRNAMEAUS | Allow NULL? |
| 50 | SET_NAME | Redemption Schedule Set | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | RDPT_SET_NAME | Allow NULL? |
| 51 | STUECKZINS | Include the Horizon when Calculating Accrued Interest | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_X_STUECKZINS | Allow NULL? |
| 52 | FLG_ACCR_INT | Calculate Accrued Interest | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_FLG_ACCR_INT | Allow NULL? |
| 53 | DISB_START | Start of Disbursement Procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_DISB_START | Allow NULL? |
| 54 | DISB_CAL | Calendar for Disbursement Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | JBR_DISB_CAL | Allow NULL? |
| 55 | VALUATION_MODEL | Valuation Model for Financial Transactions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JBR_VALUATION_MODEL | Allow NULL? |
| 56 | NUMBER_OF_STEPS | Default Number of Steps for Discretization Method | int | 10 | 0 | INT4 | ((0)) | Yes | | JBR_NUMBER_OF_STEPS | Allow NULL? |
| 57 | MAX_STEPLENGTH | Maximum Permitted Time Step for Discretization Method | decimal | 12 | 6 | DEC | ((0)) | Yes | | JBR_MAXIMUM_STEPLENGTH | |
| 58 | PREPAYMENT | Prepayment | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_PREPAYMENT | Allow NULL? |
| 59 | X_PREPAYMENT | Indicator for Prepayment - Point Effect | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_X_PREPAYMENT | Allow NULL? |
| 60 | FLG_WITH_COMPENS | Select FX Offsetting Transactions | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_FLG_WITH_COMPENS | Allow NULL? |
| 61 | FLG_TERMINATED_D | Select Transaction on Day of Cancellation/Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_FLG_TERMINATED_DEAL | Allow NULL? |
| 62 | COMAXAGEPR | Maximum Age of Historical Commodity Price in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | JBRCOMAXAGEPR | |
| 63 | X_INTVAL | Intrinsic Value Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_INT_VAL | Allow NULL? |
| 64 | COEXPVALTYP | Commodity Exposure - NPV Valuation Type | char | 1 | 0 | NUMC | (N'0') | Yes | | TV_COEXPVALTYP | Allow NULL? |
| 65 | XCREDITSPREAD | Use Credit Spreads at Discounting | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_XCSPREAD | Allow NULL? |
| 66 | CSPREAD_TYPE | Credit Spread Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TCRC_CSPR_TYPE | TCR_CSPREAD_TYPE | Allow NULL? |
| 67 | CTY_CURVE_B | Commodity Curve Type Bid | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JBC_CCURVE_TYPE | TB_CTY_CURVE_B | Allow NULL? |
| 68 | CTY_CURVE_M | Commodity Curve Type Middle | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JBC_CCURVE_TYPE | TB_CTY_CURVE_M | Allow NULL? |
| 69 | CTY_CURVE_A | Commodity Curve Type Ask | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JBC_CCURVE_TYPE | TB_CTY_CURVE_A | Allow NULL? |
| 70 | XDDELIVERY | Delayed Delivery Option Usage Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_DDELIVERY | Allow NULL? |
| 71 | DD_DAYS | Number of Days to consider for Delayed Delivery | decimal | 3 | 0 | DEC | ((0)) | Yes | | TV_DD_DAYS | |
| 72 | XCSP_USE_VAR_RT | Use Credit Spread when Calculating Forward Interest Rates | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_CSPRD_USE_VAR_RT | Allow NULL? |
| 73 | CSP_FWD_RT_TYPE | Credit Spread Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TCRC_CSPR_TYPE | TCR_CSPREAD_TYPE | Allow NULL? |
| 74 | DISPUOM | Display Unit of Measure | char | 1 | 0 | CHAR | (N' ') | Yes | | JBRDISPUOM | Allow NULL? |
| 75 | QTYCALMETH | Quantity Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | JBRQTYCALMETH | Allow NULL? |
| 76 | FUTCALMETH | Calculation Method for Futures | char | 1 | 0 | CHAR | (N' ') | Yes | | JBRFUTCALMETH | Allow NULL? |
| 77 | BSP_DERI_EVAL | Basis Spread Curve Derivation for Evaluation Curves | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCBSC_DREVL | FTBB_YC_BSC_DERIVE_EVAL | Allow NULL? |
| 78 | BSP_DERI_FWD | Basis Spread Curve Derivation ID for Forward Curves | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCBSC_DRFWD | FTBB_YC_BSC_DERIVE_FWD | Allow NULL? |
| 79 | CSP_DERIVE_BP | Reference Entity Derivation for Business Partners | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCCSC_DRBP | FTBB_YC_CSC_DERIVE_BP | Allow NULL? |
| 80 | CSP_DERIVE_OWN | Reference Entity Derivation for Your Own Companies | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FTBB_YCCSC_DROWN | FTBB_YC_CSC_DERIVE_OWN | Allow NULL? |
| 81 | BP_RELTYP | Relationship Category of Business Partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TBZ9 | FTBB_YC_BP_RELTYP | Allow NULL? |
| 82 | OWN_BUKRS | Own Default Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | FTBB_YC_OWN_BUKRS | Allow NULL? |
| 83 | MAX_AGE_CS_REDEF | Use Different Maximum Age for Credit Spreads | char | 1 | 0 | CHAR | (N' ') | Yes | | FTBB_MAX_AGE_CS_REDEF | Allow NULL? |
| 84 | MAX_AGE_CS | Maximum Age for Credit Spreads | int | 10 | 0 | INT4 | ((0)) | Yes | | FTBB_MAX_AGE_CS | Allow NULL? |
| 85 | XEXTBW | Indicator for External Valuation | char | 1 | 0 | CHAR | (N' ') | Yes | | TV_XEXTBW | Allow NULL? |
| 86 | XDEST_T1 | RM RFC: Destination in SAP Banking RM | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | TV_RFCDEST | Allow NULL? |
| 87 | XFUNC_T1 | RM RFC: Function Name in SAP Banking RM | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TV_RFCFNAME | Allow NULL? |
| 88 | XDEST_T2 | RM RFC: Destination in SAP Banking RM | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | TV_RFCDEST | Allow NULL? |
| 89 | XFUNC_T2 | RM RFC: Function Name in SAP Banking RM | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TV_RFCFNAME | Allow NULL? |
| 90 | CONVADJ_VR | Control convexity adjustment valuation rule specific | char | 1 | 0 | CHAR | (N' ') | Yes | | JBR_CONVADJ_VR | Allow NULL? |
| 91 | CSC_VALRULE_REDEF | Redefine Settings | char | 1 | 0 | CHAR | (N' ') | Yes | | FTBB_CSC_VALRULE_REDEF | Allow NULL? |
