| 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 | KURSTG | Exchange rate type bid | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | KURSTB | Exchange rate type ask | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | BCURVE | Bid valuation curve type for mark-to-market | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | BCURVEB | Ask Valuation Curve: Mark-to-Market | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | WPKURSART | Security price type for evaluations | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | IDXART | Index Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | DVOLARTG | Volatility Type "Bid Rates" for Foreign Exchange | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | DVOLARTB | Volatility Type "Ask Rates" for Foreign Exchange | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | ZVOLARTG | Volatility Type 'Bid' for Interest Rates | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | ZVOLARTB | Volatility Type 'Ask' for Interest Rates | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | WVOLARTG | Volatility Type 'Bid' for Securities | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | WVOLARTB | Volatility Type 'Ask' for Securities | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | IXVOLARTG | Volatility Type for Security Indexes; Bid Rates | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | IXVOLARTB | Volatility Type for Security Indexes; Ask Rates | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | HWVOLARTG | Volatility Type for Yield Curve Model, Bid Rate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | HWVOLARTB | Volatility Type for Yield Curve Model, Ask Rate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | KORRARTG | 'Bid' Correlation Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | KORRARTB | 'Ask' Correlation Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | VNAME | Volatility Name | nvarchar | 15 | 0 | | | | Allow NULL? |
| 24 | COVOLTYPB | Volitility Type "Bid" for Commodity Transactions | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | COVOLTYPA | Volitility Type "Ask" for Commodity Transactions | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | COPRTYPE | Commodity Quotation Type | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | BCURVE_RF | Bid Valuation Curve : Risk Free | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | BCURVEB_RF | Ask Valuation Curve : Risk Free | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | BSP_CURVE_B | Basis Spread Curve Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | BSP_CURVE_A | Basis Spread Curve Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | XREAL_CASHF | Include Real Cash Flows | char | 1 | 0 | | | | Allow NULL? |
| 32 | CALCVERF | Calculation Routines | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | WPPVART | Calculate Theoretical NPV | char | 1 | 0 | | | | Allow NULL? |
| 34 | WKTAGE | Maximum age of historical price in days | decimal | 3 | 0 | | | | |
| 35 | SVOLART | Volatility Type for Convexity Adjustment | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | XHOR_CASHF | Is cash flow at horizon included in NPV? | char | 1 | 0 | | | | Allow NULL? |
| 37 | XINTOPT | Value Swaptions as Interest Rate Options | char | 1 | 0 | | | | Allow NULL? |
| 38 | XIMPLOPT | Break Down Implied Options | char | 1 | 0 | | | | Allow NULL? |
| 39 | NAMEAUS | Disbursement Procedure (Loan) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | SET_NAME | Redemption Schedule Set | nvarchar | 15 | 0 | | | | Allow NULL? |
| 41 | STUECKZINS | Include the Horizon when Calculating Accrued Interest | char | 1 | 0 | | | | Allow NULL? |
| 42 | FLG_ACCR_INT | Calculate Accrued Interest | char | 1 | 0 | | | | Allow NULL? |
| 43 | DISB_START | Start of Disbursement Procedure | char | 1 | 0 | | | | Allow NULL? |
| 44 | DISB_CAL | Calendar for Disbursement Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | VALUATION_MODEL | Valuation Model for Financial Transactions | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | NUMBER_OF_STEPS | Default Number of Steps for Discretization Method | int | 10 | 0 | | | | Allow NULL? |
| 47 | MAX_STEPLENGTH | Maximum Permitted Time Step for Discretization Method | decimal | 12 | 6 | | | | |
| 48 | PREPAYMENT | Prepayment | char | 1 | 0 | | | | Allow NULL? |
| 49 | X_PREPAYMENT | Indicator for Prepayment - Point Effect | char | 1 | 0 | | | | Allow NULL? |
| 50 | FLG_WITH_COMPENS | Select FX Offsetting Transactions | char | 1 | 0 | | | | Allow NULL? |
| 51 | FLG_TERMINATED_D | Select Transaction on Day of Cancellation/Settlement | char | 1 | 0 | | | | Allow NULL? |
| 52 | COMAXAGEPR | Maximum Age of Historical Commodity Price in Days | decimal | 3 | 0 | | | | |
| 53 | X_INTVAL | Intrinsic Value Indicator | char | 1 | 0 | | | | Allow NULL? |
| 54 | COEXPVALTYP | Commodity Exposure - NPV Valuation Type | char | 1 | 0 | | | | Allow NULL? |
| 55 | XCREDITSPREAD | Use Credit Spreads at Discounting | char | 1 | 0 | | | | Allow NULL? |
| 56 | CSPREAD_TYPE | Credit Spread Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | CTY_CURVE_B | Commodity Curve Type Bid | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | CTY_CURVE_M | Commodity Curve Type Middle | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | CTY_CURVE_A | Commodity Curve Type Ask | nvarchar | 3 | 0 | | | | Allow NULL? |
| 60 | XDDELIVERY | Delayed Delivery Option Usage Flag | char | 1 | 0 | | | | Allow NULL? |
| 61 | DD_DAYS | Number of Days to consider for Delayed Delivery | decimal | 3 | 0 | | | | |
| 62 | XCSP_USE_VAR_RT | Use Credit Spread when Calculating Forward Interest Rates | char | 1 | 0 | | | | Allow NULL? |
| 63 | CSP_FWD_RT_TYPE | Credit Spread Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 64 | DISPUOM | Display Unit of Measure | char | 1 | 0 | | | | Allow NULL? |
| 65 | QTYCALMETH | Quantity Calculation Method | char | 1 | 0 | | | | Allow NULL? |
| 66 | FUTCALMETH | Calculation Method for Futures | char | 1 | 0 | | | | Allow NULL? |
| 67 | BSP_DERI_EVAL | Basis Spread Curve Derivation for Evaluation Curves | nvarchar | 4 | 0 | | | | Allow NULL? |
| 68 | BSP_DERI_FWD | Basis Spread Curve Derivation ID for Forward Curves | nvarchar | 4 | 0 | | | | Allow NULL? |
| 69 | CSP_DERIVE_BP | Reference Entity Derivation for Business Partners | nvarchar | 4 | 0 | | | | Allow NULL? |
| 70 | CSP_DERIVE_OWN | Reference Entity Derivation for Your Own Companies | nvarchar | 4 | 0 | | | | Allow NULL? |
| 71 | BP_RELTYP | Relationship Category of Business Partner | nvarchar | 6 | 0 | | | | Allow NULL? |
| 72 | OWN_BUKRS | Own Default Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 73 | MAX_AGE_CS_REDEF | Use Different Maximum Age for Credit Spreads | char | 1 | 0 | | | | Allow NULL? |
| 74 | MAX_AGE_CS | Maximum Age for Credit Spreads | int | 10 | 0 | | | | Allow NULL? |
| 75 | XEXTBW | Indicator for External Valuation | char | 1 | 0 | | | | Allow NULL? |
| 76 | XDEST_T1 | RM RFC: Destination in SAP Banking RM | nvarchar | 32 | 0 | | | | Allow NULL? |
| 77 | XFUNC_T1 | RM RFC: Function Name in SAP Banking RM | nvarchar | 30 | 0 | | | | Allow NULL? |
| 78 | XDEST_T2 | RM RFC: Destination in SAP Banking RM | nvarchar | 32 | 0 | | | | Allow NULL? |
| 79 | XFUNC_T2 | RM RFC: Function Name in SAP Banking RM | nvarchar | 30 | 0 | | | | Allow NULL? |
| 80 | IDX | Securities Index | nvarchar | 10 | 0 | | | | Allow NULL? |
| 81 | BFART | Beta Factor Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 82 | XSTDINDEX | Is index standard index? | char | 1 | 0 | | | | Allow NULL? |
| 83 | STDBETAF | Standard Beta Factor | decimal | 10 | 6 | | | | |
| 84 | XCONVADJ | Calculate convexity adjustment? | char | 1 | 0 | | | | Allow NULL? |
| 85 | XKOMPRESS | Activate Presummarization | char | 1 | 0 | | | | Allow NULL? |
| 86 | DIFFBAR | Differentiation Rule for NPV Function | nvarchar | 2 | 0 | | | | Allow NULL? |
| 87 | DELTA_KNZ | Treatment of Options (Gap Evaluation) | char | 1 | 0 | | | | Allow NULL? |
| 88 | STAT_KNZ | Display Static Interest Rate or Product Interest Rate | char | 1 | 0 | | | | Allow NULL? |
| 89 | OZ_FROM | Determination of Opportunity Interest Rate for ALM | char | 1 | 0 | | | | Allow NULL? |
| 90 | SOPPZINS | Gap: Indicator for Opportunity Interest Rate | char | 1 | 0 | | | | Allow NULL? |
| 91 | SEFFZINS | GAP effective interest rate indicator | char | 1 | 0 | | | | Allow NULL? |
| 92 | SDATUM | GAP date indicator | char | 1 | 0 | | | | Allow NULL? |
| 93 | SEXTGAP | External Gap Analysis | char | 1 | 0 | | | | Allow NULL? |
| 94 | EXDEST | RM Gap: Destination for External Transaction Analysis | nvarchar | 32 | 0 | | | | Allow NULL? |
| 95 | EXFUNC | RM Gap: RFC - Function Name for External Trans. Analysis | nvarchar | 30 | 0 | | | | Allow NULL? |
| 96 | BILVOLKNZ | Inclusion of Off-Balance-Sheet Transactions in BS Volume | char | 1 | 0 | | | | Allow NULL? |
| 97 | LFZENDE | Position Outflow at End of Term or Fixed Interest Period | char | 1 | 0 | | | | Allow NULL? |
| 98 | DEVTERM | Depiction of Forward Exchange Transactions in ALM Simulation | char | 1 | 0 | | | | Allow NULL? |
