| 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 | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | RANL | Contract Number | nvarchar | 13 | 0 | CHAR | (N' ') | No | | RANL | Allow NULL? |
| 4 | NTRANS | Transaction data key: Consecutive number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | VVNTRANS | Allow NULL? |
| 5 | SKONDGRP | Condition group in cash flow calculator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SKONDGRP | Allow NULL? |
| 6 | DGUEL_KP | Condition Item Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DGUEL_KP | Allow NULL? |
| 7 | SEXCLGUEL | Exclusive indicator for start date of condition position | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSEXCLKP | Allow NULL? |
| 8 | SULTGUEL | Month-end indicator for start date of condition position | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSULT_KP | Allow NULL? |
| 9 | NSTUFE | Level number of condition item for recurring payments | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | NSTUFE | Allow NULL? |
| 10 | SBERFIMA | Calculation category for cash flow calculator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | AT40 | SBEWFIMA | Allow NULL? |
| 11 | JNULLKON | Condition Form | char | 1 | 0 | CHAR | (N' ') | Yes | | JNULLKON | Allow NULL? |
| 12 | JGESUCHT | Int. indicator for alternative calculations | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJGESUCHT | Allow NULL? |
| 13 | SALTKOND | Unit for supplementary condition items | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TB_SALKOND | Allow NULL? |
| 14 | SZINSANP | Cross-referenced condition grp for interest rate adjustment | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SZINSANP | Allow NULL? |
| 15 | SZSREF | Reference Interest Rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TFM_SZSREF | Allow NULL? |
| 16 | SFORMREF | Formula Reference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | AT30 | TB_XFORMBE | Allow NULL? |
| 17 | SVARNAME | Variable Name | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TB_VARNAME | Allow NULL? |
| 18 | DPKOND | Determination date for percentage rate of condition items | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDPKOND | Allow NULL? |
| 19 | PKONDMIN | Percentage rate for condition items | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKOND | |
| 20 | PKONDMAX | Percentage rate for condition items | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKOND | |
| 21 | PKOND | Percentage rate for condition items | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKOND | |
| 22 | ALFZTAGE | Number of days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | TFMLFZTAGE | Allow NULL? |
| 23 | SWHRKOND | Currency of Condition Item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TFMWHRKOND | Allow NULL? |
| 24 | BKOND | Condition item currency amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | TFM_BKOND | |
| 25 | KBKOND | Currency-independent FiMa condition amount | decimal | 15 | 6 | DEC | ((0)) | Yes | | TFM_KBKOND | |
| 26 | BUGRENZ | Lower Limit for Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFMBUGRENZ | |
| 27 | BOGRENZ | Upper Limit for Amt | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFMBOGRENZ | |
| 28 | SSTAFF | Type of Scaled Calculation | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSSTAFF | Allow NULL? |
| 29 | SBASIS | Calculation Base Reference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TFM_SBASIS | Allow NULL? |
| 30 | BBASIS | Calculation Base Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFM_BBASIS | |
| 31 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 32 | STGMETH | Daily Method | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSTGMETH | Allow NULL? |
| 33 | STGBASIS | Base Days Method | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSTGBASIS | Allow NULL? |
| 34 | AMMRHY | Frequency in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AMMRHY | Allow NULL? |
| 35 | ATTRHY | Frequency in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ATTRHY | Allow NULL? |
| 36 | DVALUT | Calculation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVALUT | Allow NULL? |
| 37 | SINCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCL | Allow NULL? |
| 38 | SVULT | Month-End Indicator for Value Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSVULT | Allow NULL? |
| 39 | SVMETH | Method for determining the next value date | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SVMETH | Allow NULL? |
| 40 | AVGSTAGE | Number of Days for Relative Calculation of Value Date | int | 10 | 0 | INT4 | ((0)) | Yes | | TB_AVGSTAG | Allow NULL? |
| 41 | SVWERK | Working Day Shift for Calculation Day | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SVWERK | Allow NULL? |
| 42 | SVON | Int. FiMa indicator to interprete DVALUT/SINCL | char | 1 | 0 | CHAR | (N' ') | Yes | | TFM_SVON | Allow NULL? |
| 43 | DFAELL | Due date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DFAELL | Allow NULL? |
| 44 | SFINCL | Inclusive Indicator for Due Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSFINCL | Allow NULL? |
| 45 | SFULT | Month-End Indicator for Due Date | char | 1 | 0 | CHAR | (N' ') | Yes | | SFULT | Allow NULL? |
| 46 | SFMETH | Method for determining the next due date | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SFMETH | Allow NULL? |
| 47 | AFGSTAGE | Number of days for rel. determination of due date | int | 10 | 0 | INT4 | ((0)) | Yes | | TB_AFGSTAG | Allow NULL? |
| 48 | SFWERK | Working Day Shift for Due Date | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SFWERK | Allow NULL? |
| 49 | SFRANZ | Shift Due Date | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSFRANZ | Allow NULL? |
| 50 | SDWERK | Working Day Shift for Payment Date | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SDWERK | Allow NULL? |
| 51 | DZFEST | Interest rate fixing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DZFEST | Allow NULL? |
| 52 | SKALID | Factory calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | SKALID | Allow NULL? |
| 53 | SKALID2 | Factory calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | SKALID | Allow NULL? |
| 54 | JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSOFVERR | Allow NULL? |
| 55 | SZEITANT | Indicator for Pro Rata Temporis Calculations | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSZEITANT | Allow NULL? |
| 56 | SFANT | Indicator for due date-related FiMa calculations | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSFANT | Allow NULL? |
| 57 | SERBTERM | FiMa indicator: Date and frequency inheritance for condition | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMERBTERM | Allow NULL? |
| 58 | SRUNDVORF | Rounding of interim results for prepayments | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSRUNDVF | Allow NULL? |
| 59 | SBERECH | Grace Period Interest Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SBERECH | Allow NULL? |
| 60 | SBASFIX | Indicator for fixing calculation base | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSBASFIX | Allow NULL? |
| 61 | RURKONDIND | Reference index for an investment mathematical item | int | 10 | 0 | INT4 | ((0)) | Yes | | VVRKONDIND | Allow NULL? |
