| 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 | MGUID | GUID | varbinary | 16 | 0 | RAW | | No | | TB_ESC_GUID16 | |
| 3 | DGUEL_KK | Start of Effective Period for Escrow Analysis | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TB_ESC_EFFFROM | Allow NULL? |
| 4 | SSTATE | Status of the Payment Plan | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TB_ESC_STATUSPP | Allow NULL? |
| 5 | ACASHCUSHION | Required Minimum Balance | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_ESC_CUSHION | |
| 6 | SKOKOART | Type of Condition Header | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SKOKOART | Allow NULL? |
| 7 | SANLF | Product Category | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | SANLF | Allow NULL? |
| 8 | RKEY1 | Key part 1 | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RKEY1 | Allow NULL? |
| 9 | NLFD_ANG | Offer consecutive number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NLFD_ANG | Allow NULL? |
| 10 | SSTATI | Status of data record | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SSTATI | Allow NULL? |
| 11 | STILGRHY | Payment cycle | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STILGRHY | Allow NULL? |
| 12 | STILGART | Repayment Type Indicator | char | 1 | 0 | NUMC | (N'0') | Yes | | STILGART | Allow NULL? |
| 13 | SDISEIN | Type of Discount Withholding | char | 1 | 0 | CHAR | (N' ') | Yes | | SDISEIN | Allow NULL? |
| 14 | KZAHLUNG | Pay-in/disbursement rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | KZAHLUNG | |
| 15 | BZAHLUNG | Pay-in/disbursement amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BZAHLUNG | |
| 16 | SWHRZHLG | Currency of payment amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | SWHRZHLG | Allow NULL? |
| 17 | BZUSAGE | Commitment capital | decimal | 13 | 2 | CURR | ((0)) | Yes | | BZUSAGE | |
| 18 | SWHRZUSA | Currency of commitment amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | SWHRZUSA | Allow NULL? |
| 19 | PEFFZINS | Effective Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | PEFFZINS | |
| 20 | SEFFMETH | Effective Interest Method (Financial Mathematics) | char | 1 | 0 | NUMC | (N'0') | Yes | | SEFFMETH | Allow NULL? |
| 21 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 22 | SDISKO | Discounted | char | 1 | 0 | CHAR | (N' ') | Yes | | SDISKO | Allow NULL? |
| 23 | DKUEND | Date of notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DKUEND | Allow NULL? |
| 24 | SKUEND | Reason for Notice | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | SKUEND | Allow NULL? |
| 25 | DKUENDDG | Earliest Possible Date for Notice Given by the Lender | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DKUENDDG | Allow NULL? |
| 26 | DBLFZ | Start of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBLFZ | Allow NULL? |
| 27 | DBLFZ_ORIGIN | Original Term Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBLFZ_ORIGIN | Allow NULL? |
| 28 | DELFZ | End of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DELFZ | Allow NULL? |
| 29 | DRESAM | Reservation of Conditions On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DRESAM | Allow NULL? |
| 30 | DRESBIS | Reservation of Conditions Until | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DRESBIS | Allow NULL? |
| 31 | DANGAM | Offer creation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANGAM | Allow NULL? |
| 32 | DANGBIS | Offer Effective To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANGBIS | Allow NULL? |
| 33 | SANGVOR | Offer/Acceptance Reservation Indicator | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SANGVOR | Allow NULL? |
| 34 | JANNAHME | Offer Acceptance Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JANNAHME | Allow NULL? |
| 35 | SANNAHME | Type of offer acceptance indicator | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | SANNAHME | Allow NULL? |
| 36 | DANNAHME | Date of acceptance of offer | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DANNAHME | Allow NULL? |
| 37 | JVERTRAG | Indicator: Contract Created? | char | 1 | 0 | CHAR | (N' ') | Yes | | JVERTRAG | Allow NULL? |
| 38 | DVERTRAM | Contract creation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVERTRAM | Allow NULL? |
| 39 | DVERTBIS | Return contract by | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVERTBIS | Allow NULL? |
| 40 | PMANEFFZ | Internal Effective Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | PEFFZINS_INTERN | |
| 41 | SEFFM2 | Effective Interest Method (Financial Mathematics) | char | 1 | 0 | NUMC | (N'0') | Yes | | SEFFMETH | Allow NULL? |
| 42 | SKUEGL | Notice Arrangement Lender | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVSKUEGL | Allow NULL? |
| 43 | RPNR | Activity number/rollover number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | VVRPNR | Allow NULL? |
| 44 | DEFSZ | Date of fixed period end | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDEFSZ | Allow NULL? |
| 45 | DGES | Earliest Notice Date in acc. with the Legal Right of Notice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDGES | Allow NULL? |
| 46 | SGESAUS | Legal Right of Notice Excluded | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSGESAUS | Allow NULL? |
| 47 | SZKZ | Special int. ID for int. on arrears for remaining balance | char | 1 | 0 | CHAR | (N' ') | Yes | * | VVSZKZ | Allow NULL? |
| 48 | NANGEBOT | Offer consecutive number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NLFD_ANG | Allow NULL? |
| 49 | SINCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCL | Allow NULL? |
| 50 | ZVRHYEFF | Int.sttlmnt frequency for effective int.rate calc.in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VVZVRHYEFF | Allow NULL? |
| 51 | PVGLEFFZ | Comparative effective interest | decimal | 10 | 7 | DEC | ((0)) | Yes | | VVPVGLEFFZ | |
| 52 | SULTEFSZ | Month-end indicator for end of fixed period | char | 1 | 0 | CHAR | (N' ') | Yes | | VVSULTEFSZ | Allow NULL? |
| 53 | DABEFFZ | Date when calculation of effective rate starts | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDABEFFZ | Allow NULL? |
| 54 | DKUENDDN | Earliest Possible Date for Notice Given by the Borrower | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDKUENDDN | Allow NULL? |
| 55 | SKUEDN | Notice Arrangement Borrower | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVSKUEDN | Allow NULL? |
| 56 | SKUEART | Notice Type for the Loan | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | VVSKUEART | Allow NULL? |
| 57 | DMARKTZINS | ISB: Market Rate Date: Market Interest Rate for NPV Calc. | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DMARKTZINS | Allow NULL? |
| 58 | SKALIDWT | Interest Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TFMSKALIDWT | Allow NULL? |
| 59 | EDEFFZINS | Relevant for Closely Defined Effective Interest | decimal | 10 | 7 | DEC | ((0)) | Yes | | EDEFFZINS | |
| 60 | EDEFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | EFFMETH | Allow NULL? |
| 61 | JAHREFFZINS | Relevant for Yearly Eff. Interest Acc Guideline 87/102/EU | decimal | 10 | 7 | DEC | ((0)) | Yes | | JAHREFFZINS | |
| 62 | JAHREFFMETH | Effective Interest Method - Acc. to EU Gdline Int.Statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | EFFMETH | Allow NULL? |
| 63 | PEFFZINS_ORIGIN | Original Effective Interest Rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | PEFFZINS_ORIGIN | |
