SAP Table VDCBR_RES_DATA - Table of Data Reported to Credit Bureau (Per Loan)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
RANL X RANL CHAR 7 13 0 Contract Number
DATE_CREA X TB_CBR_CREATION_DATE DATS 20 8 0 Created On
TIME_CREA X TIMESTAMP DEC 28 15 0 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
BDW TB_CBR_BLOCK_DESC_WORD NUMC 36 4 0 Block Length Field for Output in File
RDW TB_CBR_REC_DESC_WORD NUMC 40 4 0 Record Length Field
PROCESS_IND TB_CBR_INDICATOR NUMC 44 1 0 Indicator for Forwarding Data in Metro2 Format
TIMESTAMP TB_CBR_TIMESTAMP CHAR 45 15 0 UTC Time Stamp (Metro2 Format)
CORRECTION_IND TB_CBR_INDICATOR NUMC 60 1 0 Indicator for Forwarding Data in Metro2 Format
IDENT_NO TB_CBR_IDENT_NUMBER CHAR 61 20 0 Nuber of Data Provider
CYCLE_IDENT TB_CBR_CYCLE_NUMBER CHAR 81 2 0 Cycle for Reporting to Credit Bureau
CONSUMER_ACC_NO TB_CBR_ACCOUNT_NO_30 CHAR 83 30 0 Loan Number (30 Characters) (Metro2 Format)
PORTFOLIO_TYPE TB_CBR_PORTFOLIO_TYPE CHAR 113 1 0 Loan Type
ACCOUNT_TYPE TB_CBR_ACCOUNT_TYPE CHAR 114 2 0 Loan Type (Metro2 Format)
DATE_OPENED DERF DATS 116 8 0 First Entered on
CREDIT_LIMIT TB_CBR_CREDIT_LIMIT NUMC 124 9 0 Credit Limit in (Metro2 Format)
O_LOAN_AMOUNT TB_CBR_ORG_LOAN_AMOUNT NUMC 133 9 0 Loan Amount (Metro2 Format)
TERMS_DURATION TB_CBR_TERMS_DURATION CHAR 142 3 0 Loan Term (Metro2 Format)
TERMS_FREQUENCY TB_CBR_TERMS_FREQUENCY CHAR 145 1 0 Frequency of Payment Due Date (Metro2 Format)
MON_PAYM_AMOUNT TB_CBR_MON_PAYM_AMOUNT NUMC 146 9 0 Planned Monthly Payment Amount
ACT_PAYM_AMOUNT TB_CBR_ACT_PAYM_AMOUNT NUMC 155 9 0 Amount Paid to Current Date (Metro2 Format)
ACCOUNT_STATUS TB_CBR_ACCOUNT_STATUS CHAR 164 2 0 Loan Status (Metro2-Format)
PAYMENT_RATING TB_CBR_PAYMENT_RATING CHAR 166 1 0 Payment Rating
PAYM_HIST_PROFIL TB_CBR_PAYMENT_HIST_PROF CHAR 167 24 0 Payment History (Metro2 -Format)
SPECIAL_COMMENT TB_CBR_SPECIAL_COMMENT CHAR 191 2 0 Comment Key (Metro2 Format)
COMPL_COND_CODE TB_CBR_SPECIAL_COMMENT CHAR 193 2 0 Comment Key (Metro2 Format)
CURRENT_BALANCE TB_CBR_CURRENT_BALANCE NUMC 195 9 0 Balance on Current Date (Metro2 - Format)
AMOUNT_PAST_DUE TB_CBR_AMOUNT_PAST_DUE NUMC 204 9 0 Payments Past Due (Metro2 Format)
CHARGE_OFF_AM TB_CBR_CHARGE_OFF_AMOUNT NUMC 213 9 0 Charge-Off Amount (Metro2 Format)
BILLING_DATE TB_BILL_DATE DATS 222 8 0 Bill Creation Date
FCRA_DATE TB_CBR_FCRA_DATE DATS 230 8 0 Date of First Delinquency (Metro2 - Format)
DATE_CLOSED TB_CBR_DATE_CLOSED DATS 238 8 0 Contract End Date
LAST_PAYM_DATE TB_CBR_DATE_LAST_PAYMENT DATS 246 8 0 Date of Last Incoming Payment
RESERVE TB_CBR_RESERVE_17 CHAR 254 17 0 Reserve Bytes (Length 17)
CONS_TRANS_TYPE TB_CBR_CONSUMER_TRANS_TYPE CHAR 271 1 0 Changes to Borrower
SURNAME TB_CBR_SURNAME CHAR 272 25 0 Last Name (Metro2 Format)
FIRST_NAME TB_CBR_FIRST_NAME CHAR 297 20 0 First Name (Metro2 Format)
MIDDLE_NAME TB_CBR_MIDDLE_NAME CHAR 317 20 0 Middle Name (Metro2 Format)
GENERATION_CODE TB_CBR_GENERATION_CODE CHAR 337 1 0 Generation Code (Metro2 Format)
SOCIAL_SEC_NO TB_CBR_SOZ_SECURITY_NUM CHAR 338 9 0 Social Security Number (Metro2 Format)
DATE_OF_BIRTH TB_CBR_BIRTH_DATE DATS 347 8 0 Date of Birth (Metro2 Format)
TEL_NUMBER TB_CBR_TEL_NUM NUMC 355 10 0 Telephone Number (Metro2 Format)
ECOA_CODE TB_CBR_ECOA_CODE CHAR 365 1 0 Business Partner Role for Loan (Metro2 Format)
CONS_INFO_IND TB_CBR_CONS_INFO_INDICATOR CHAR 366 2 0 Bankruptcy Phase of Business Partner (Metro2 Format)
COUNTRY_CODE TB_CBR_COUNTRY_CODE CHAR 368 2 0 Country Key (Metro2 Format)
FIRST_ADR_LINE TB_CBR_FIRST_ADR_LINE CHAR 370 32 0 Address Line (Metro2 Format)
SECOND_ADR_LINE TB_CBR_FIRST_ADR_LINE CHAR 402 32 0 Address Line (Metro2 Format)
CITY TB_CBR_CITY CHAR 434 20 0 City (Metro2 Format)
STATE TB_CBR_STATE CHAR 454 2 0 State Identification (Metro 2 Format)
POSTAL_CODE TB_CBR_POSTAL_CODE CHAR 456 9 0 Postal Code (Metro2 Format)
ADR_INDICATOR TB_CBR_ADR_INDICATOR CHAR 465 1 0 Indicator Field for Address (Metro2 Format)
RESID_CODE TB_CBR_RESIDENCE_CODE CHAR 466 1 0 Residence Code for Metro2 Format
SEGMENT_IDENT7 TB_CBR_SEGM_IDENT CHAR 467 2 0 Indicator for Segment
EMPLOYER_NAME TB_CBR_EMPL_NAME CHAR 469 30 0 Name of Employer
EMP_FI_ADR_LINE TB_CBR_FIRST_ADR_LINE CHAR 499 32 0 Address Line (Metro2 Format)
EMP_CITY TB_CBR_CITY CHAR 531 20 0 City (Metro2 Format)
EMP_STATE TB_CBR_STATE CHAR 551 2 0 State Identification (Metro 2 Format)
EMP_POST_CODE TB_CBR_POSTAL_CODE CHAR 553 9 0 Postal Code (Metro2 Format)
OCCUPATION TB_CBR_OCCUPATION CHAR 562 18 0 Name of Occupation (Metro2 Format)
RESERVE7 TB_CBR_RESERVE_1 CHAR 580 1 0 Place Holder for 1 Byte
SEGMENT_IDENT6 TB_CBR_SEGM_IDENT CHAR 581 2 0 Indicator for Segment
SPEC_PAYM_IND TB_CBR_PAYMENT_INDICATOR CHAR 583 2 0 Payment Arrangements (MEtro2 Format)
DEF_PAYM_START TB_CBR_DEFER_PAYM_START_DATE DATS 585 8 0 Start Date of Derffered Repayments (Metro2 Format)
PAYM_DUE_DATE TB_CBR_PAYM_DUE_DATE DATS 593 8 0 Due Date of Final Installment (Metro2 - Format)
PAYM_AMOUNT TB_CBR_PAYM_AMOUNT NUMC 601 9 0 Final Installment Amount (Ballon) (Metro2 Format)
RESERVE6 TB_CBR_RESERVE_1 CHAR 610 1 0 Place Holder for 1 Byte