SAP ABAP Table RVD_CBR_BASE_SEGM (Basis Segment of Output File for Credit Bur. (Metro2 Format))

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_CREDIT_BUREAU (Package) Data for Credit Bureau Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	RVD_CBR_BASE_SEGM	Table Relationship Diagram
Short Description	Basis Segment of Output File for Credit Bur. (Metro2 Format)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	BDW	☐	TB_CBR_BLOCK_DESC_WORD	NUMC4	NUMC	4	0	Block Length Field for Output in File
2	RDW	☐	TB_CBR_REC_DESC_WORD	NUMC4	NUMC	4	0	Record Length Field
3	PROCESS_IND	☐	TB_CBR_INDICATOR	NUMC1	NUMC	1	0	Indicator for Forwarding Data in Metro2 Format
4	TIMESTAMP	☐	TB_CBR_TIMESTAMP	CHAR15	CHAR	15	0	UTC Time Stamp (Metro2 Format)
5	CORRECTION_IND	☐	TB_CBR_INDICATOR	NUMC1	NUMC	1	0	Indicator for Forwarding Data in Metro2 Format
6	IDENT_NO	☐	TB_CBR_IDENT_NUMBER	CHAR20	CHAR	20	0	Nuber of Data Provider
7	CYCLE_IDENT	☐	TB_CBR_CYCLE_NUMBER	CHAR02	CHAR	2	0	Cycle for Reporting to Credit Bureau
8	CONSUMER_ACC_NO	☐	TB_CBR_ACCOUNT_NO_30	CHAR30	CHAR	30	0	Loan Number (30 Characters) (Metro2 Format)
9	PORTFOLIO_TYPE	☐	TB_CBR_PORTFOLIO_TYPE	T_CBR_PORTFOLIO_TYPE	CHAR	1	0	Loan Type
10	ACCOUNT_TYPE	☐	TB_CBR_ACCOUNT_TYPE	T_CBR_ACCOUNT_TYPE	CHAR	2	0	Loan Type (Metro2 Format)
11	DATE_OPENED	☐	DERF	DATUM	DATS	8	0	First Entered on
12	CREDIT_LIMIT	☐	TB_CBR_CREDIT_LIMIT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Credit Limit in (Metro2 Format)
13	O_LOAN_AMOUNT	☐	TB_CBR_ORG_LOAN_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Loan Amount (Metro2 Format)
14	TERMS_DURATION	☐	TB_CBR_TERMS_DURATION	CHAR03	CHAR	3	0	Loan Term (Metro2 Format)
15	TERMS_FREQUENCY	☐	TB_CBR_TERMS_FREQUENCY	CHAR01	CHAR	1	0	Frequency of Payment Due Date (Metro2 Format)
16	MON_PAYM_AMOUNT	☐	TB_CBR_MON_PAYM_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Planned Monthly Payment Amount
17	ACT_PAYM_AMOUNT	☐	TB_CBR_ACT_PAYM_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Amount Paid to Current Date (Metro2 Format)
18	ACCOUNT_STATUS	☐	TB_CBR_ACCOUNT_STATUS	CHAR02	CHAR	2	0	Loan Status (Metro2-Format)
19	PAYMENT_RATING	☐	TB_CBR_PAYMENT_RATING	CHAR01	CHAR	1	0	Payment Rating
20	PAYM_HIST_PROFIL	☐	TB_CBR_PAYMENT_HIST_PROF	CHAR24	CHAR	24	0	Payment History (Metro2 -Format)
21	SPECIAL_COMMENT	☐	TB_CBR_SPECIAL_COMMENT	CHAR02	CHAR	2	0	Comment Key (Metro2 Format)
22	COMPL_COND_CODE	☐	TB_CBR_SPECIAL_COMMENT	CHAR02	CHAR	2	0	Comment Key (Metro2 Format)
23	CURRENT_BALANCE	☐	TB_CBR_CURRENT_BALANCE	T_CBR_AMOUNT_METRO2	NUMC	9	0	Balance on Current Date (Metro2 - Format)
24	AMOUNT_PAST_DUE	☐	TB_CBR_AMOUNT_PAST_DUE	T_CBR_AMOUNT_METRO2	NUMC	9	0	Payments Past Due (Metro2 Format)
25	CHARGE_OFF_AM	☐	TB_CBR_CHARGE_OFF_AMOUNT	T_CBR_AMOUNT_METRO2	NUMC	9	0	Charge-Off Amount (Metro2 Format)
26	BILLING_DATE	☐	TB_BILL_DATE	DATS	DATS	8	0	Bill Creation Date
27	FCRA_DATE	☐	TB_CBR_FCRA_DATE	DATS	DATS	8	0	Date of First Delinquency (Metro2 - Format)
28	DATE_CLOSED	☐	TB_CBR_DATE_CLOSED	DATS	DATS	8	0	Contract End Date
29	LAST_PAYM_DATE	☐	TB_CBR_DATE_LAST_PAYMENT	DATS	DATS	8	0	Date of Last Incoming Payment
30	RESERVE	☐	TB_CBR_RESERVE_17	CHAR17	CHAR	17	0	Reserve Bytes (Length 17)
31	CONS_TRANS_TYPE	☐	TB_CBR_CONSUMER_TRANS_TYPE	CHAR01	CHAR	1	0	Changes to Borrower
32	SURNAME	☐	TB_CBR_SURNAME	CHAR25	CHAR	25	0	Last Name (Metro2 Format)
33	FIRST_NAME	☐	TB_CBR_FIRST_NAME	CHAR20	CHAR	20	0	First Name (Metro2 Format)
34	MIDDLE_NAME	☐	TB_CBR_MIDDLE_NAME	CHAR20	CHAR	20	0	Middle Name (Metro2 Format)
35	GENERATION_CODE	☐	TB_CBR_GENERATION_CODE	CHAR01	CHAR	1	0	Generation Code (Metro2 Format)
36	SOCIAL_SEC_NO	☐	TB_CBR_SOZ_SECURITY_NUM	CHAR9	CHAR	9	0	Social Security Number (Metro2 Format)
37	DATE_OF_BIRTH	☐	TB_CBR_BIRTH_DATE	DATS	DATS	8	0	Date of Birth (Metro2 Format)
38	TEL_NUMBER	☐	TB_CBR_TEL_NUM	NUMC10	NUMC	10	0	Telephone Number (Metro2 Format)
39	ECOA_CODE	☐	TB_CBR_ECOA_CODE	CHAR01	CHAR	1	0	Business Partner Role for Loan (Metro2 Format)
40	CONS_INFO_IND	☐	TB_CBR_CONS_INFO_INDICATOR	CHAR02	CHAR	2	0	Bankruptcy Phase of Business Partner (Metro2 Format)
41	COUNTRY_CODE	☐	TB_CBR_COUNTRY_CODE	CHAR02	CHAR	2	0	Country Key (Metro2 Format)
42	FIRST_ADR_LINE	☐	TB_CBR_FIRST_ADR_LINE	CHAR32	CHAR	32	0	Address Line (Metro2 Format)
43	SECOND_ADR_LINE	☐	TB_CBR_FIRST_ADR_LINE	CHAR32	CHAR	32	0	Address Line (Metro2 Format)
44	CITY	☐	TB_CBR_CITY	CHAR20	CHAR	20	0	City (Metro2 Format)
45	STATE	☐	TB_CBR_STATE	CHAR02	CHAR	2	0	State Identification (Metro 2 Format)
46	POSTAL_CODE	☐	TB_CBR_POSTAL_CODE	CHAR9	CHAR	9	0	Postal Code (Metro2 Format)
47	ADR_INDICATOR	☐	TB_CBR_ADR_INDICATOR	CHAR01	CHAR	1	0	Indicator Field for Address (Metro2 Format)
48	RESID_CODE	☐	TB_CBR_RESIDENCE_CODE	CHAR01	CHAR	1	0	Residence Code for Metro2 Format

History

Last changed by/on	SAP	20130529
SAP Release Created in	600