| MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
T000 |
| BUKRS |
✔ |
Company Code |
BUKRS |
CHAR |
4 |
T001 |
| SARCHIV |
✔ |
Archiving Category Indicator |
SARCHIV |
CHAR |
1 |
|
| RANL |
✔ |
Contract Number |
RANL |
CHAR |
13 |
|
| RERF |
|
Entered by |
RERF |
CHAR |
12 |
|
| DERF |
|
First Entered on |
DERF |
DATS |
8 |
|
| TERF |
|
Time of Initial Entry |
TERF |
TIMS |
6 |
|
| REHER |
|
Source of initial entry |
REHER |
CHAR |
10 |
|
| RBEAR |
|
Employee ID |
RBEAR |
CHAR |
12 |
|
| DBEAR |
|
Last Edited on |
DBEAR |
DATS |
8 |
|
| TBEAR |
|
Last Edited at |
TBEAR |
TIMS |
6 |
|
| RBHER |
|
Editing Source |
RBHER |
CHAR |
10 |
|
| SOBJEKT |
|
Internal key for object |
VVKEYOBJ |
CHAR |
10 |
|
| SSTATI |
|
Status of data record |
SSTATI |
NUMC |
2 |
TZC37 |
| SANLF |
|
Product Category |
SANLF |
NUMC |
3 |
TZAF |
| GSART |
|
Product Type |
VVSART |
CHAR |
3 |
TZPAB |
| RREFKONT |
|
Account Assignment Reference in Financial Assets Management |
RREFKONT |
CHAR |
8 |
T037S |
| HBKID |
|
Short Key for a House Bank |
HBKID |
CHAR |
5 |
T012 |
| HKTID |
|
ID for account details |
HKTID |
CHAR |
5 |
T012K |
| STITEL |
|
Loan Type Indicator |
STITEL |
NUMC |
3 |
TD03 |
| SGLZB |
|
SCB asset group indicator |
SGLZB |
CHAR |
4 |
TW07 |
| SFIBG |
|
Asset Grouping Indicator |
SFIBG |
NUMC |
4 |
TW08 |
| SBILK |
|
Balance Sheet Indicator |
SBILK |
CHAR |
2 |
TW11 |
| XALKZ |
|
Short name |
XALKZ |
CHAR |
15 |
|
| XALLB |
|
Long name |
XALLB |
CHAR |
60 |
|
| XAKT |
|
File Number |
XAKT |
CHAR |
32 |
|
| RANLALT1 |
|
Alternative Identification |
RANLALT1 |
CHAR |
13 |
|
| RANLALT2 |
|
Alternative identification 2 |
RANLALT2 |
CHAR |
13 |
|
| SGR1 |
|
Group Key 1 (Freely Available) |
SGRP1 |
CHAR |
6 |
TDDG1 |
| SGR2 |
|
Group Key 2 (Freely Available) |
SGRP2 |
CHAR |
6 |
TDDG2 |
| RKLAMMER |
|
Classification Number for Finance Projects |
RKLAMMER |
CHAR |
13 |
|
| RANLKET |
|
Principle loan investment number |
RANLHPT |
CHAR |
13 |
|
| RANTRAG |
|
Application number |
RANTRAG |
CHAR |
13 |
|
| SSOLIST |
|
Plan/Actual principle |
VVSSOLIST |
CHAR |
1 |
|
| SFRIST |
|
Loan Term |
SFRIST |
NUMC |
2 |
TD09 |
| BANTRAG |
|
Capital applied for |
BANTRAG |
CURR |
13 |
|
| SANTWHR |
|
Currency |
SWHR |
CUKY |
5 |
TCURC |
| DANTRAG |
|
Entry Date of Loan Application |
DANTRAG |
DATS |
8 |
|
| BZUSAGE |
|
Commitment capital |
BZUSAGE |
CURR |
13 |
|
| DZUSAGE |
|
Loan - Date of Commitment by Lender |
DZUSAGE |
DATS |
8 |
|
| DZUSAGE_ORIGIN |
|
Date of the Original Approval from the Lender |
DZUSAGE_ORIGIN |
DATS |
8 |
|
| DBLFZ |
|
Start of Term |
DBLFZ |
DATS |
8 |
|
| DELFZ |
|
End of Loan Term |
DENDLFZ |
DATS |
8 |
|
| DBDIS |
|
Start of distribution of discount |
DBDIS |
DATS |
8 |
|
| SDISMETH |
|
Discount distribution method |
SDISMETH |
NUMC |
1 |
|
| SSICHER |
|
Primary collateral |
SSICHER |
CHAR |
4 |
TD01 |
| SVZWECK |
|
Purpose of Loan |
SVZWECK |
CHAR |
2 |
TD07 |
| SSONDER |
|
Special treatment of loan |
SSONDER |
NUMC |
2 |
TD10 |
| SFIWO |
|
Indicator: Type of Residential Object Financing |
SFIWO |
CHAR |
2 |
TD15 |
| SDTI |
|
DTI indicator |
SDTI |
NUMC |
5 |
|
| SHOME |
|
Home statement |
SHOME |
NUMC |
3 |
TD11 |
| SLAENDER |
|
Country ID |
SLAENDER |
CHAR |
3 |
T005 |
| AABTRET |
|
Number of Assignments Still Possible |
AABTRET |
NUMC |
2 |
|
| BABTRET |
|
Minimum amount for assignments |
BABTRET |
CURR |
13 |
|
| SNICHTAB |
|
Reason for Non-Acceptance |
SNICHTAB |
NUMC |
2 |
TDA5 |
| DARCHIV |
|
Date of Rejection/Withdrawal |
DARCHIV |
DATS |
8 |
|
| BGESDAR |
|
Total amount of syndicated loan |
BGESDAR |
CURR |
13 |
|
| DKONS |
|
Syndicate loan date |
DKONS |
DATS |
8 |
|
| SKWGKRED |
|
Credit category indicator Para. 75 report (Austria) |
SKWGKRED |
NUMC |
1 |
TZ35 |
| SKWGDAR |
|
Credit type indicator for Austrian reporting |
SKWGDAR |
NUMC |
1 |
TZ34 |
| JORIG |
|
Posting system indicator for borrower's note loans |
BUCHSYS |
NUMC |
1 |
|
| VVSLOEKZ |
|
Deletion indicator |
VVSLOEKZ |
NUMC |
1 |
|
| SDTYP |
|
Loans Class |
VVSDTYP |
NUMC |
3 |
TD02 |
| DBEWI |
|
Approval date |
VVDBEWI |
DATS |
8 |
|
| SABTRANS |
|
Indicator for Possible Foreign Assignment |
VVSABTRANS |
CHAR |
1 |
|
| AKONS |
|
Number of syndicate members |
VVAKONS |
NUMC |
3 |
|
| SFGKZ |
|
Release Indicator |
VVSFGKZ |
CHAR |
1 |
|
| SABT |
|
Assignee |
VVSABT |
CHAR |
4 |
TDS1 |
| MABER |
|
Dunning Area |
MABER |
CHAR |
2 |
T047M |
| MAHNS |
|
Dunning level |
MAHNS_D |
NUMC |
1 |
|
| MADAT |
|
Last dunned on |
MADAT |
DATS |
8 |
|
| RPNR |
|
Activity number/rollover number |
VVRPNR |
NUMC |
8 |
|
| RSBEAR |
|
Dummy field 12 characters CHAR |
DUMMY_12 |
CHAR |
12 |
|
| SONDST |
|
Special posting treatment |
VVSONDST |
CHAR |
2 |
TD14 |
| SGRP3 |
|
Group Key 3 (Freely Available) |
SGRP3 |
CHAR |
6 |
TDDG3 |
| SGRP4 |
|
Group Key 4 (Freely Available) |
SGRP4 |
CHAR |
6 |
TDDG4 |
| SZKEY |
|
Indicator for Control of Incoming Payment Distribution |
VVSZKEY |
NUMC |
2 |
TVZ01 |
| BEGRU |
|
Authorization Group |
BEGRU |
CHAR |
4 |
|
| SVERFU |
|
Type of Restraint on Drawing |
VVSVERFU |
NUMC |
2 |
TZV05 |
| STITART |
|
Borrower's Note Loan Security Type |
VVSTITART |
NUMC |
2 |
TD16 |
| NABTRV |
|
Contract of assignment number |
VVNABTRV |
CHAR |
15 |
|
| NAVAL |
|
Guarantee number |
VVNAVAL |
CHAR |
15 |
|
| DABTR |
|
Date of assignment |
VVDABTR |
DATS |
8 |
|
| DVERFU |
|
Date of restraint on disposal upto |
VVDVERFU |
DATS |
8 |
|
| SFGBEW |
|
Transaction data to be released available |
VVSFGBEW |
NUMC |
2 |
|
| DELSOZ |
|
Date of last special interest payment period |
VVDLESOZ |
DATS |
8 |
|
| RPORTB |
|
Portfolio |
RPORTB |
CHAR |
10 |
TWPOB |
| SREGION |
|
Sales Region |
VVSREGION |
CHAR |
4 |
TD18 |
| SGESST |
|
Branch Office |
VVSGESST |
CHAR |
4 |
TD17 |
| SBEA |
|
Loan Processing Indicator |
VVSBEA |
NUMC |
2 |
|
| SOBEZ |
|
Organizational District |
VVSOBEZ |
CHAR |
2 |
|
| SBEZIRK |
|
Agent District |
VVSBEZIRK |
CHAR |
4 |
|
| SPLIT |
|
Debit position splitting |
VVSPLIT |
CHAR |
1 |
|
| BNBUERG |
|
Initial capital not guaranteed |
VVBNBUERG |
CURR |
13 |
|
| SREFZINS |
|
Loan With Reference Interest Rate |
VVSREFZINS |
CHAR |
1 |
|
| SMAHNM |
|
Loan Manual Dunning Level |
VVSMAHNM |
CHAR |
1 |
TDMAHNS_MAN |
| SIHERK |
|
Version Number Component |
CHAR2 |
CHAR |
2 |
|
| RGENUM |
|
Character Field Length = 10 |
CHAR10 |
CHAR |
10 |
|
| DRUECK |
|
Date when loan will probably be redeemed |
VVDRUECK |
DATS |
8 |
|
| SABGRENZ |
|
Loan Discount Accrual/Deferral Method |
VVSABGRD |
CHAR |
1 |
|
| SFEST |
|
Indicator for Control of Fixed Contract |
VVFESTKZ |
CHAR |
1 |
|
| SRATING |
|
Rating |
BP_RATING |
CHAR |
3 |
TP06 |
| SRATAGEN |
|
Rating agency |
SRATAGEN_NEW |
CHAR |
10 |
* |
| RDARNEHM |
|
Business Partner Number |
BP_PARTNR_NEW |
CHAR |
10 |
BUT000 |
| OBJNR |
|
Object Number for Financial Transactions |
TB_FINOBJNR |
CHAR |
22 |
* |
| HDN_KUNNR |
|
Main Borrower Customer Number |
HDN_KUNNR |
CHAR |
10 |
KNA1 |
| SKWG14_NEU |
|
Position grouping acc. Para 14 GBA (Sec. and loans) |
VVSKWG14 |
CHAR |
2 |
|
| RANLSTAMNR |
|
Master number part of loan number for finding contracts |
RANLSTAMNR |
CHAR |
13 |
|
| MIGDATE |
|
Migration date |
MIGDATE |
DATS |
8 |
|
| SDUNNCMP |
|
Summarization Level for Dunning Letter |
SDUNNCMP |
CHAR |
2 |
|
| XNODUNN |
|
Exclude Loan from Dunning Run |
XNODUNN |
CHAR |
1 |
|
| ZUOND |
|
Assignment |
TB_ZUOND |
CHAR |
18 |
|
| REFER |
|
Internal Reference |
TB_REFER |
CHAR |
16 |
|
| MERKM |
|
Characteristics |
TB_MERKM |
CHAR |
25 |
|
| SDUNCHARG |
|
Post Dunning Charges and Interest to this Contract |
SDUNCHARG |
CHAR |
1 |
|
| SWHRORG |
|
Loan currency before conversion to EURO |
SWHRORG |
CUKY |
5 |
TCURC |
| DCONVERT |
|
Date loan was converted to EURO |
DCONVERT |
DATS |
8 |
|
| DCORRECT |
|
Date for adjustment flows resulting from EURO conversion |
DCORRECT |
DATS |
8 |
|
| SAKTPAS |
|
Indicator: Asset/Liability Transaction |
VVSAKTPAS |
CHAR |
1 |
|
| RPZAHL |
|
Payer/payee |
TB_RPZAHL_NEW |
CHAR |
10 |
BUT000 |
| GSBER |
|
Business Area |
GSBER |
CHAR |
4 |
TGSB |
| JNOREPAY |
|
Payoff Lock |
TB_JNOREPAY |
CHAR |
1 |
|
| JNODOIP |
|
Blocked by Payoff: No Open Item Clearing for Loan |
TB_JNODOIP |
CHAR |
1 |
|
| COM_VAL_CLASS |
|
General Valuation Class |
TPM_COM_VAL_CLASS |
NUMC |
4 |
TRGC_COM_VALCL |
| SARC_EXCL |
|
Documents For The Loan May Not Be Archived |
TB_SARC_EXCL |
CHAR |
1 |
|
| SARC_DOCS |
|
Indicator: Archived Loan Documents Exist |
TB_SARC_DOCS |
CHAR |
1 |
|
| NO_PLAN_DONE |
|
Do Not Transfer Loan to Status "Completed" |
TB_NO_PLAN_DONE |
CHAR |
1 |
|
| DPLAN_SET |
|
Date of Transfer of Contract into Status Planned Completed |
TB_DPLAN_SET |
DATS |
8 |
|
| DOPEN |
|
Opening Date of a Loan Contract |
TB_DOPEN |
DATS |
8 |
|
| DCLOSE |
|
Closing Date of a Loan Contract |
TB_DCLOSE |
DATS |
8 |
|
| DUNN_BLOCK_TILL |
|
Expiration Date of Dunning Lock |
TB_VIEW_DATE_DUNNING_BLOCK_TIL |
DATS |
8 |
|
| XNOIOA |
|
Lock for Interest on Arrears |
TB_XNOIOA |
CHAR |
1 |
|
| NOIOA_TILL |
|
Expiry Date of Lock on Interest on Arrears |
TB_NOIOA_TILL |
DATS |
8 |
|
| ORIGIN |
|
Loan Origin |
TB_ORIGIN |
CHAR |
2 |
TDORIGIN |
| DCALLEND |
|
Provision Expiry Date |
TB_DCALLEND |
DATS |
8 |
|
| SVER_EXCL |
|
Documents for the loan may not be summarized |
TB_SVER_EXCL |
CHAR |
1 |
|
| LC_DISBURSEMENT |
|
Processing Characteristic: Disbursement Status |
TB_LC_CHARAC_DISBURSEMENT |
CHAR |
1 |
* |
| LC_CAPITALS |
|
Processing Characteristic: Status of Capital Amounts |
TB_LC_CHARAC_CAPITALS |
CHAR |
1 |
* |
| LC_PLANNED_FLOW |
|
Processing Characteristic: Status of Planned Records |
TB_LC_CHARAC_PLANNED_FLOW |
CHAR |
1 |
* |
| LC_DEBIT |
|
Processing Characteristic: Status of Customer Receivables |
TB_LC_CHARAC_DEBIT |
CHAR |
1 |
* |
| LC_CREDIT |
|
Processing Characteristic: Status of Customer Payables |
TB_LC_CHARAC_CREDIT |
CHAR |
1 |
* |
| LC_STATUS |
|
Status of Processing Characteristics for Loan |
TB_LC_STATUS |
CHAR |
1 |
|
| PAYM_STATUS |
|
Payment Status |
TB_PAYM_STATUS |
CHAR |
1 |
|
| STOP_INDICATOR |
|
Stop Indicator |
TB_STOP_INDICATOR |
CHAR |
1 |
|
| PRODUCT_ID |
|
Internal Product ID |
TB_PR_PRODINT |
CHAR |
18 |
* |
| PRODUCT_VERSION |
|
Product Version |
TB_PR_VERSION |
NUMC |
4 |
* |
| SCHUFA_MESSAGE |
|
Business Partner Has Signed a Schufa Declaration |
TB_VIEW_SCHUFA |
CHAR |
1 |
|
| DAT_FULL_PAY |
|
Date of Full Disbursement |
TB_VIEW_DATE_OF_FULL_PAYMENT |
DATS |
8 |
|
| DAT_OF_CANCEL |
|
Rescission Date |
TB_VIEW_DATE_OF_CANCELATION |
DATS |
8 |
|
| FLG_CNCL |
|
Rescission Indicator |
TB_CNCL |
CHAR |
1 |
|
| DINSTR |
|
Date Customer Was Instructed About Rescission Rights |
TB_DINSTR |
DATS |
8 |
|
| ORGUNIT |
|
Organizational Unit |
TB_MD_ORGUNIT_CNMGT |
CHAR |
12 |
TD19 |
| DISTRIB_CHANNEL |
|
Sales Channel |
TB_MD_DISTRIBUTION_CHANNEL |
CHAR |
10 |
TD30 |
| FLG_CNCL_CLI |
|
Indicator: Rescind Credit Life Insurance |
TB_CNCL_CLI |
CHAR |
1 |
|
| FLG_NO_CHANGE |
|
Only Limited Changes Possible for Contract Indicator |
TB_MD_NO_CHANGE |
CHAR |
1 |
|
| SCHEME_ID |
|
Calculation Profile for Interest on Arrears Calculation |
TB_SCHEME_ID |
CHAR |
3 |
TDIOA_SCHEME_DEF |
| SSTATE_OF_EXEC |
|
Region Where Contract Concluded |
TB_SREGION |
CHAR |
3 |
T005S |
| WAIVE_REASON |
|
Reason for Automatic Waiver of Charges |
TB_WAIVE_REASON |
CHAR |
3 |
TDWAIVE_REASON |
| WAIVE_METHOD |
|
Waiver Method |
TB_WAIVE_METHOD |
NUMC |
1 |
|
| BACKOFFICE_ID |
|
Back Office |
TB_BACKOFFICE_ID |
NUMC |
8 |
* |
| FLG_NON_ACCRUAL |
|
Non-Accrual Status Permitted |
TB_FLG_NON_ACCRUAL |
CHAR |
1 |
|
| SFIMA_METHOD |
|
Control Settings for FiMa Connection |
TB_FIMA_METHOD |
CHAR |
1 |
|
| GRACE_DAYS |
|
Grace Days |
TB_GRACEDAYS |
NUMC |
3 |
|
| NOIOA_TILL_BLOCK |
|
End Date of Non-IOA Period |
TB_NOIOA_TILL_BLOCK |
DATS |
8 |
|
| FLG_SYNDICATE |
|
Syndicated Loan |
TB_FLG_SYNDICATE |
CHAR |
1 |
|
| FLG_FACILITY |
|
Loan: Part of Facility |
TB_FLG_FACILITY |
CHAR |
1 |
|
| SHADOW_ACCNT |
|
Value of Shadow Account |
TB_SHD_ACCNT |
CHAR |
1 |
|
| OPTIMAL_LIST |
|
For interest adjust optimization solution list |
TB_OP_LIST_CMLCHN |
CHAR |
1 |
|
| RP_RELEVANT |
|
Flag „relevant for German Banking Act " |
VVRP_RELEVANT |
CHAR |
1 |
|
| CONTRACT_BIC |
|
SWIFT/BIC for International Payments |
SWIFT |
CHAR |
11 |
|
| CONTRACT_IBAN |
|
IBAN (International Bank Account Number) |
BU_IBAN |
CHAR |
34 |
|
| IBAN_DET |
|
Type of Determination of IBAN for a contract |
TB_SEPA_IBAN_DET |
CHAR |
1 |
|
| FAC_GROUP_NUMBER |
|
Facility Grouping Identifier |
TB_FACILITY_GROUP_NUMBER |
CHAR |
13 |
|
| FLG_DD_REVOLVING |
|
Revolving Drawdown |
TB_FLG_DRAWDOWN_REVOLVING |
CHAR |
1 |
|
| FLG_FAC_INACTIVE |
|
Facility Inactive |
TB_FLG_FACILITY_INACTIVE |
CHAR |
1 |
|
| OBJ_ID |
|
Data object Identifier |
DATOBJ_ID |
CHAR |
50 |
|
| OBJ_KEY |
|
Key for Archive File |
ARKEY |
CHAR |
20 |
|
| OBJ_OFFSET |
|
Archive file data object offset |
ADMI_OFFST |
INT4 |
10 |
|
| FLP |
|
Loan Belongs to Forward Loan Purchase |
TB_FLP_FLAG |
CHAR |
1 |
|
| FLP_NUMBER |
|
Forward Loan Purchase Deal Number |
TB_FLP_DEAL_NUMBER |
CHAR |
13 |
|
| VDBEPP_DBEAR |
|
Planned Records Last Edited On |
VDBEPP_DBEAR |
DATS |
8 |
|
| VDBEPP_TBEAR |
|
Planned Records Last Edited At |
VDBEPP_TBEAR |
TIMS |
6 |
|
| VDBEPP_RBHER |
|
Planned Records Editing Source |
VDBEPP_RBHER |
CHAR |
10 |
|
| RESERVED_AMOUNT |
|
Reserved amount |
TB_FACILITY_RES_AMT_CMLCHN |
CURR |
13 |
|