| 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 | VZFZE_BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | VZFZE_SVORGANG | Release procedure activity number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VVSVORGANG | Allow NULL? |
| 4 | VZFZE_LFDNR | Table entry sequential number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | VVLFDNR | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 6 | RANL | Contract Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RANL | Allow NULL? |
| 7 | DTRANS | Flow data key: System date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDTRANS | Allow NULL? |
| 8 | TTRANS | Transaction data key: system time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | VVTTRANS | Allow NULL? |
| 9 | NTRANS | Transaction data key: Consecutive number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | VVNTRANS | Allow NULL? |
| 10 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 11 | DERF | First Entered on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERF | Allow NULL? |
| 12 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TERF | Allow NULL? |
| 13 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 14 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 15 | DBEAR | Last Edited on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEAR | Allow NULL? |
| 16 | TBEAR | Last Edited at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TBEAR | Allow NULL? |
| 17 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
| 18 | DVORGANG | Activity date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVORGANG | Allow NULL? |
| 19 | SVORGANG | Business Operation (Activity) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SVORFALL | Allow NULL? |
| 20 | NVORGANG | Activity number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | NVORGANG | Allow NULL? |
| 21 | SBEWART | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SBEWART | Allow NULL? |
| 22 | SREFBEW | Reference flow type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SREFBEW | Allow NULL? |
| 23 | SBEWZITI | Flow category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SBEWZITI | Allow NULL? |
| 24 | SPLANIST | Plan/actual record/record to be released indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SPLANIST | Allow NULL? |
| 25 | SSOLHAB | Debit/credit indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSSOLHAB | Allow NULL? |
| 26 | SSTORNO | Reversal indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTORNO | Allow NULL? |
| 27 | SSTOGRD | Reason for Reversal | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SSTOGRD | Allow NULL? |
| 28 | ZUONR | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 29 | RSTBLG | Reverse Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | STBLG | Allow NULL? |
| 30 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 31 | SANLF | Product Category | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | SANLF | Allow NULL? |
| 32 | DGUEL_KK | Date Condition Effective from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DGUEL | Allow NULL? |
| 33 | NLFD_ANG | Offer consecutive number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NLFD_ANG | Allow NULL? |
| 34 | SSTATI | Status of data record | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SSTATI | Allow NULL? |
| 35 | GSART | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VVSART | Allow NULL? |
| 36 | RREFKONT | Account Assignment Reference in Financial Assets Management | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | RREFKONT | Allow NULL? |
| 37 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 38 | DORDER | Order day | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DORDER | Allow NULL? |
| 39 | NORDER | Order Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | NORDER | Allow NULL? |
| 40 | BNWHR | Nominal amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BNWHR | |
| 41 | SNWHR | Currency of nominal amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | SNWHR | Allow NULL? |
| 42 | BBWHR | Amount in position currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBWHR | |
| 43 | SBWHR | Position Currency (Currency of Position Amount) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | SBWHR | Allow NULL? |
| 44 | BCWHR | Settlement Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BCWHR | |
| 45 | SCWHR | Settlement Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | SCWHR | Allow NULL? |
| 46 | BHWHR | Amount in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BHWHR | |
| 47 | KURS1 | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | VVKURSF | |
| 48 | KURS2 | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | VVKURSF | |
| 49 | DVALUT | Calculation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVALUT | Allow NULL? |
| 50 | DFAELL | Due date/calculation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DFAELLIG | Allow NULL? |
| 51 | DDISPO | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DDISPO | Allow NULL? |
| 52 | DBESTAND | Position value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBESTAND | Allow NULL? |
| 53 | DBERVON | Start of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERVON | Allow NULL? |
| 54 | DBERBIS | End of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERBIS | Allow NULL? |
| 55 | ATAGE | Number of days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VVATAGE | Allow NULL? |
| 56 | ABASTAGE | Number of base days in a calculation period | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ABASTAGE | Allow NULL? |
| 57 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 58 | UMSKZ | Special G/L Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | UMSKZ | Allow NULL? |
| 59 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 60 | SSPESEN | Expenses key | char | 1 | 0 | CHAR | (N' ') | Yes | | SSPESEN | Allow NULL? |
| 61 | RSOLL | Account for debit posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RSOLL | Allow NULL? |
| 62 | RHABEN | Account for credit posting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RHABEN | Allow NULL? |
| 63 | RZKSOLL | Debit interim account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RZKSOLL | Allow NULL? |
| 64 | RZKHABE | Credit interim account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RZKHABE | Allow NULL? |
| 65 | SBSLSOLL | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 66 | SBSLZKSO | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 67 | SBSLZKHA | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 68 | SHSLHABEN | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 69 | RBANKK | Bank account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RBANKK | Allow NULL? |
| 70 | SFDLEV | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FDLEV | Allow NULL? |
| 71 | JFDUPD | Record transferred to cash management and forecast | char | 1 | 0 | CHAR | (N' ') | Yes | | JFDUPD | Allow NULL? |
| 72 | JONLAEN | Indicator for fixing a flow record | char | 1 | 0 | CHAR | (N' ') | Yes | | JONLAEN | Allow NULL? |
| 73 | JZINSBAS | Flow in interest base | char | 1 | 0 | CHAR | (N' ') | Yes | | JZINSBAS | Allow NULL? |
| 74 | JZINSZPT | Interest date | char | 1 | 0 | CHAR | (N' ') | Yes | | JZINSZPT | Allow NULL? |
| 75 | PKOND | Percentage rate for condition items | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKOND | |
| 76 | BBASIS | Calculation base amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBASIS | |
| 77 | SSORTZIT | Sort indicator for interest/repayment schedule calculations | char | 1 | 0 | CHAR | (N' ') | Yes | | SSORTZIT | Allow NULL? |
| 78 | SWOHER | Source of flow record | char | 1 | 0 | CHAR | (N' ') | Yes | | SWOHER | Allow NULL? |
| 79 | SSTCKKZ | Accrued interest method | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTCKKZ | Allow NULL? |
| 80 | SSTCKTG | Accrued interest: Daily method | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTCKTG | Allow NULL? |
| 81 | PEFFZINS | Effective Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | PEFFZINS | |
| 82 | SEFFMETH | Effective Interest Method (Financial Mathematics) | char | 1 | 0 | NUMC | (N'0') | Yes | | SEFFMETH | Allow NULL? |
| 83 | JVERF | Indicator whether drawings exist for the disbursement | char | 1 | 0 | CHAR | (N' ') | Yes | | JVERF | Allow NULL? |
| 84 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 85 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BVTYP | Allow NULL? |
| 86 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSCH | Allow NULL? |
| 87 | MABER | Dunning Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MABER | Allow NULL? |
| 88 | ZAHLS | Block Key for Payment | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZAHLS | Allow NULL? |
| 89 | RPARTNR | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_PARTNR_NEW | Allow NULL? |
| 90 | SROLEXT | Dummy function | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DUMMY_3 | Allow NULL? |
| 91 | RKLAMMER | Classification Number for Finance Projects | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RKLAMMER | Allow NULL? |
| 92 | JEINBEHALT | Indicator for withholding of amount during disbursement | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJEINBE | Allow NULL? |
| 93 | SZEGEN | Generate incoming payment immediately | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SZEGEN | Allow NULL? |
| 94 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 95 | DTRANSREF | Flow data key: System date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDTRANS | Allow NULL? |
| 96 | TTRANSREF | Transaction data key: system time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | VVTTRANS | Allow NULL? |
| 97 | NTRANSREF | Transaction data key: Consecutive number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | VVNTRANS | Allow NULL? |
| 98 | RPNNR | Daybook no. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VVRPNNR | Allow NULL? |
| 99 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HBKID | Allow NULL? |
| 100 | SBUST | Posting control key | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | VVSBUST | Allow NULL? |
| 101 | PWKURS | Security price for percentage quotation | decimal | 10 | 7 | DEC | ((0)) | Yes | | PWKURS | |
| 102 | DSTOCK | Premium reserve fund date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDSTOCK | Allow NULL? |
| 103 | JVORAUS | ID for planned record reference to an advance payment | char | 1 | 0 | CHAR | (N' ') | Yes | | VVJVORAUS | Allow NULL? |
| 104 | AMMRHY | Frequency in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AMMRHY | Allow NULL? |
| 105 | SKOART | Condition Type (Smallest Subdivision of Condition Records) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | SKOART | Allow NULL? |
| 106 | SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSEXCLVON | Allow NULL? |
| 107 | SULTVON | Month-End Indicator for Start of a Calculation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTVON | Allow NULL? |
| 108 | SINCLBIS | Inclusive Indicator for the End of a Calculation Period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCLBIS | Allow NULL? |
| 109 | SULTBIS | Month-End Indicator for the End of a Calculation Period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTBIS | Allow NULL? |
| 110 | SINCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCL | Allow NULL? |
| 111 | DVERRECH | Settlement date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDVERRECH | Allow NULL? |
| 112 | DPKOND | Determination date for percentage rate of condition items | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDPKOND | Allow NULL? |
| 113 | RUMBLG | Reference transfer document number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | UMBLG | Allow NULL? |
| 114 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DZINKZ | Allow NULL? |
| 115 | SVULT | Month-End Indicator for Value Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSVULT | Allow NULL? |
| 116 | JSOFVERR | Immediate settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | JSOFVERR | Allow NULL? |
| 117 | SINCLVERR | Inclusive Indicator for Clearing Date | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCLVER | Allow NULL? |
| 118 | SULTVERR | Month-End Indicator for Clearing Date | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTVERR | Allow NULL? |
| 119 | SREFZITI | Refer.flow category in accrual/deferral flow records | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VVSREFZITI | Allow NULL? |
| 120 | STGBASIS | Base Days Method | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSTGBASIS | Allow NULL? |
| 121 | STGMETH | Daily Method | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSTGMETH | Allow NULL? |
| 122 | SBASIS | Calculation base reference | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VVSBASIS | Allow NULL? |
| 123 | SBERFIMA | Calculation category for cash flow calculator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SBEWFIMA | Allow NULL? |
| 124 | SVORGKZ | Activity indicator for debit/credit control | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | VVSVORGKZ | Allow NULL? |
| 125 | MANSP | Dunning block | char | 1 | 0 | CHAR | (N' ') | Yes | * | MANSP | Allow NULL? |
| 126 | DGUEL_KP | Condition Item Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DGUEL_KP | Allow NULL? |
| 127 | NSTUFE | Level number of condition item for recurring payments | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | NSTUFE | Allow NULL? |
| 128 | DBPERIOD | Period start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDBPERIOD | Allow NULL? |
| 129 | SPAEXCL | Exclusive Indicator for Start Date of a Period | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSPAEXCL | Allow NULL? |
| 130 | SPAULT | Month-End Indicator for Start Date of a Period | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSPAULT | Allow NULL? |
| 131 | DEPERIOD | Period End | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDEPERIOD | Allow NULL? |
| 132 | SPEINCL | Inclusive Indicator for End Date of a Period | char | 1 | 0 | NUMC | (N'0') | Yes | | TFMSPEINCL | Allow NULL? |
| 133 | SPEULT | Month-End Indicator for End of a Period | char | 1 | 0 | CHAR | (N' ') | Yes | | TFMSPEULT | Allow NULL? |
| 134 | RKONT | Quota number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RKONT | Allow NULL? |
| 135 | DAUSZ | Lead date for withholding amounts for disbursement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDAUSZ | Allow NULL? |
| 136 | SSOLIST | Calculation using actual principle (or debit) | char | 1 | 0 | CHAR | (N' ') | Yes | | SSOLIST | Allow NULL? |
| 137 | RDARNEHM | Borrower/Applicant Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RDARNEHM_NEW | Allow NULL? |
| 138 | BKOND | Condition item currency amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BKOND | |
| 139 | RZEBEL | Document number of waiver/write-off document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VEBLGNR | Allow NULL? |
| 140 | ZFBDT | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DDISPO | Allow NULL? |
| 141 | DZFEST | Interest rate fixing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DZFEST | Allow NULL? |
| 142 | SBERECH | Grace Period Interest Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SBERECH | Allow NULL? |
| 143 | BKARZINS | Int.for days betw. redemption clear.and pmnt (FiMa-internal) | decimal | 13 | 2 | CURR | ((0)) | Yes | | TFMBKAZINS | |
| 144 | BTITALK | Imputed annuity repayment amount (FiMa internal) | decimal | 13 | 2 | CURR | ((0)) | Yes | | TFMBTIKALK | |
| 145 | HDN_KUNNR | Main Borrower Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HDN_KUNNR | Allow NULL? |
| 146 | SZART | Payment transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SZART | Allow NULL? |
| 147 | RUZBEL | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 148 | REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | REBZJ | Allow NULL? |
| 149 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REBZG | Allow NULL? |
| 150 | REBZZ | Line Item in the Relevant Invoice | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | REBZZ | Allow NULL? |
| 151 | S_SSDREF | Reference flow category in borrower's note loan flow records | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VVS_SSDREF | Allow NULL? |
| 152 | SAEND | Change Indicator for FiMa Flow Records | char | 1 | 0 | NUMC | (N'0') | Yes | | TFM_SAEND | Allow NULL? |
| 153 | XPORE | Indicator: Individual Payment? | char | 1 | 0 | CHAR | (N' ') | Yes | | PRQ_XPORE | Allow NULL? |
| 154 | SPAYRQ | Generate payment request | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SPAYRQK | Allow NULL? |
| 155 | PRKEY | Key Number for Payment Request | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRQ_KEYNO | Allow NULL? |
| 156 | HKTID | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HKTID | Allow NULL? |
| 157 | VORGTYP | Activity Category (Posting Area) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORGTYP_LO | Allow NULL? |
| 158 | ACENV | Source in TR-LO posting area | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ACENV_LO | Allow NULL? |
| 159 | SSIGN | Direction of flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SSIGN | Allow NULL? |
| 160 | SPRSNG | Individual payment | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SPRSNGK | Allow NULL? |
| 161 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
| 162 | SPRGRD | Determine grouping definition | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SPRGRD | Allow NULL? |
| 163 | SCSPAY | Same direction necessary for joint payment? | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SCSPAY | Allow NULL? |
| 164 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | DZWELS | Allow NULL? |
| 165 | PAYGR | Grouping Field for Automatic Payments | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PAYGR | Allow NULL? |
| 166 | JEXPOZINS | Exponential Interest Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_JZINSRE | Allow NULL? |
| 167 | SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSREVALEXCL | Allow NULL? |
| 168 | RBO | Business Operation Number (Loans) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | RBO | Allow NULL? |
| 169 | SROUND | Rounding Category | char | 1 | 0 | CHAR | (N' ') | Yes | | TFM_SROUND | Allow NULL? |
| 170 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TFMSKALIDWT | Allow NULL? |
| 171 | PPAYMENT | Payment Rate | decimal | 11 | 7 | DEC | ((0)) | Yes | | TFM_PPAYMENT | |
| 172 | AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TFM_AMMRHYZV | Allow NULL? |
| 173 | LC_CAPITALS | Effect of the Flow on Capital Amounts Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_LC_CAPITALS | Allow NULL? |
| 174 | LC_DISBURSE | Effect of the Flow on the Disbursement Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_LC_DISBURSE | Allow NULL? |
| 175 | OP_APPLICATION | Open Item Tool: Application Key | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | TB_OPAPPL | Allow NULL? |
| 176 | OP_RBO | OI Tool: Locking Business Operation | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | TB_OP_RBO | Allow NULL? |
| 177 | DFAELL_OLD_EXT | Old Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_EXTENS_DFAELL_OLD | Allow NULL? |
| 178 | DDISPO_OLD_EXT | Old Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_EXTENS_DDISPO_OLD | Allow NULL? |
| 179 | RBO_EXT | Business Operation Number (Loans) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | RBO | Allow NULL? |
| 180 | SBEWEGRP2 | Flow Record Group in Cash Flow Calculator (Incoming Payment) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | TB_FLOW_REC_GRP | Allow NULL? |
| 181 | SUSP_REASON_TYPE | Key for Overpayment Reason | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | TDSUSPREASON | TB_SUSPREASON | Allow NULL? |
| 182 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SEPA_MNDID | Allow NULL? |
| 183 | REMIT_INFO | Payment Notes Info | nvarchar | 140 | 0 | CHAR | (N' ') | Yes | | TB_REMIT_INFO | Allow NULL? |
| 184 | BROUNDUNIT | Rounding Unit for Amounts | decimal | 13 | 7 | DEC | ((0)) | Yes | | TB_BROUNDUNIT_A | |
| 185 | SEPA_PD | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |