| 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 | SBEWEGRP | Flow record group in cash flow calculator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SBEWEGRP | Allow NULL? |
| 6 | SBERFIMA | Calculation category for cash flow calculator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | AT40 | SBEWFIMA | Allow NULL? |
| 7 | SAEND | Change Indicator for FiMa Flow Records | char | 1 | 0 | NUMC | (N'0') | Yes | | TFM_SAEND | Allow NULL? |
| 8 | SPLANIST | Plan/actual record/record to be released indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SPLANIST | Allow NULL? |
| 9 | SWOHER | Source of flow record | char | 1 | 0 | CHAR | (N' ') | Yes | | TFM_SWOHER | Allow NULL? |
| 10 | BBWHR | Amount which changes position | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFM_BBWHR | |
| 11 | BNWHR | Nominal amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFM_BNWHR | |
| 12 | BBASISUR | Original calculation basis (e.g. for interval calculation) | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFMBBASISU | |
| 13 | BBASIS | Calculation Base Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFM_BBASIS | |
| 14 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERVON | Allow NULL? |
| 15 | SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSEXCLVON | Allow NULL? |
| 16 | SULTVON | Month-End Indicator for Start of a Calculation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTVON | Allow NULL? |
| 17 | DBERBIS | End of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERBIS | Allow NULL? |
| 18 | SINCLBIS | Inclusive Indicator for the End of a Calculation Period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCLBIS | Allow NULL? |
| 19 | SULTBIS | Month-End Indicator for the End of a Calculation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTBIS | Allow NULL? |
| 20 | DVALUT | Calculation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVALUT | Allow NULL? |
| 21 | SINCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCL | Allow NULL? |
| 22 | SVINCL | Inclusive indicator for value date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSVINCL | Allow NULL? |
| 23 | SVULT | Month-End Indicator for Value Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSVULT | Allow NULL? |
| 24 | DFAELL | Due date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DFAELL | Allow NULL? |
| 25 | SFINCL | Inclusive Indicator for Due Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSFINCL | Allow NULL? |
| 26 | SFULT | Month-End Indicator for Due Date | char | 1 | 0 | CHAR | (N' ') | Yes | | SFULT | Allow NULL? |
| 27 | SRUNDVORF | Rounding of interim results for prepayments | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSRUNDVF | Allow NULL? |
| 28 | DDISPO | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DDISPO | Allow NULL? |
| 29 | DVERRECH | Settlement date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDVERRECH | Allow NULL? |
| 30 | SINCLVERR | Inclusive Indicator for Clearing Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCLVER | Allow NULL? |
| 31 | SULTVERR | Month-End Indicator for Clearing Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTVERR | Allow NULL? |
| 32 | ATAGE | Number of Days | int | 10 | 0 | INT4 | ((0)) | Yes | | TFMATAGE | Allow NULL? |
| 33 | ABASTAGE | Number of base days in a calculation period | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ABASTAGE | Allow NULL? |
| 34 | APERTAGE | No. of days of a (calculation) period in cash flow | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VVAPERTAGE | Allow NULL? |
| 35 | STGMETH | Daily Method | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSTGMETH | Allow NULL? |
| 36 | STGBASIS | Base Days Method | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSTGBASIS | Allow NULL? |
| 37 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 38 | PKOND | Percentage rate for condition items | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKOND | |
| 39 | DPKOND | Determination date for percentage rate of condition items | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDPKOND | Allow NULL? |
| 40 | DZFEST | Interest rate fixing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DZFEST | Allow NULL? |
| 41 | DBPERIOD | Period start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDBPERIOD | Allow NULL? |
| 42 | SPAEXCL | Exclusive Indicator for Start Date of a Period | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSPAEXCL | Allow NULL? |
| 43 | SPAULT | Month-End Indicator for Start Date of a Period | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSPAULT | Allow NULL? |
| 44 | DEPERIOD | Period End | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDEPERIOD | Allow NULL? |
| 45 | SPEINCL | Inclusive Indicator for End Date of a Period | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSPEINCL | Allow NULL? |
| 46 | SPEULT | Month-End Indicator for End of a Period | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSPEULT | Allow NULL? |
| 47 | SWHRKOND | Currency of Condition Item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TFMWHRKOND | Allow NULL? |
| 48 | BKOND | Condition item currency amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | TFM_BKOND | |
| 49 | KBKOND | Currency-independent FiMa condition amount | decimal | 15 | 6 | DEC | ((0)) | Yes | | TFM_KBKOND | |
| 50 | BUGRENZ | Lower Limit for Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFMBUGRENZ | |
| 51 | BOGRENZ | Upper Limit for Amt | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFMBOGRENZ | |
| 52 | SSTAFF | Type of Scaled Calculation | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSSTAFF | Allow NULL? |
| 53 | SBASIS | Calculation Base Reference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TFM_SBASIS | Allow NULL? |
| 54 | JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSOFVERR | Allow NULL? |
| 55 | BTIKALK | Imputed annuity repayment amount (internal FiMa) | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFM_TIKALK | |
| 56 | BKARZINS | Interest amount on diff. betw. clearing/pmnt date (int.FIMA) | decimal | 23 | 2 | CURR | ((0)) | Yes | | TFMKARZINS | |
| 57 | AMMRHY | Frequency in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AMMRHY | Allow NULL? |
| 58 | ATTRHY | Frequency in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ATTRHY | Allow NULL? |
| 59 | JGESUCHT | Int. indicator for alternative calculations | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJGESUCHT | Allow NULL? |
| 60 | SSORTZIT | Sort indicator for financial mathematic calculations | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TFM_SORT | Allow NULL? |
| 61 | SBERECH | Grace Period Interest Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SBERECH | Allow NULL? |
| 62 | SBASFIX | Indicator for fixing calculation base | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSBASFIX | Allow NULL? |
| 63 | SZEITANT | Indicator for Pro Rata Temporis Calculations | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSZEITANT | Allow NULL? |
| 64 | SFANT | Indicator for due date-related FiMa calculations | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSFANT | Allow NULL? |
| 65 | SSALBAS | Indicator for debit position/incoming pmnt (internal FiMa) | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSSALBAS | Allow NULL? |
| 66 | SKONDGRP | Condition group in cash flow calculator | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SKONDGRP | Allow NULL? |
| 67 | RURKONDIND | Reference index for an investment mathematical item | int | 10 | 0 | INT4 | ((0)) | Yes | | VVRKONDIND | Allow NULL? |
| 68 | RURBEWEIND | Reference index for a FiMa flow record | int | 10 | 0 | INT4 | ((0)) | Yes | | VVRBEWEIND | Allow NULL? |
