Excel Sample Sheet 33234

Partial file snippet.

Sheet 1: File Definition

	
	
	
	
	
	
	
	
	
		Data File Definitions
		

		

		

		

		

		

		

	
	
		NAME
		DESC
		FILE NAME
		ENABLED
		

		

		

		

	
	
		MASTER_ACCOUNT_STATEMENT
		MASTER ACCOUNT CUSTOMER STATEMENT
		master_account_customer_stmt
		Y
		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Record Definitions
		

		

		

		

		

		

		

	
	
		RECORD TYPE
		RECORD DESCRIPTION
		DELIMITED CD
		DELIMITER
		RECORD TERMINATOR
		

		

		

	
	
		1
		HEADER RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		2
		MASTER ACCOUNT RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		3
		LINKED ACCOUNT RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		4
		ASSET DETAILS RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		5
		TRANSACTION RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		6
		MESSAGE RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		7
		FOOTER RECORD
		VARIABLE
		|
		CRLF
		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Column Definitions
		

		

		

		

		

		

		

	
	
		RECORD TYPE
		COLUMN NAME
		COLUMN SEQ
		OUTPUT COLUMN SEQ
		DATA TYPE
		FORMAT MASK
		COLUMN LENGTH
		SORT
	
	
		1
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		1
		STATEMENT DATE
		2
		2
		DATE
		MM/DD/YYYY
		10
		2
	
	
		1
		BRANCH
		3
		3
		VARCHAR2
		UNDEFINED
		30
		3
	
	
		1
		COMPANY
		4
		4
		VARCHAR2
		UNDEFINED
		30
		4
	
	
		2
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		2
		MASTER ACCOUNT #
		2
		2
		VARCHAR2
		UNDEFINED
		30
		2
	
	
		2
		FIRST NAME
		3
		3
		VARCHAR2
		UNDEFINED
		80
		3
	
	
		2
		MIDDLE NAME
		4
		4
		VARCHAR2
		UNDEFINED
		1
		4
	
	
		2
		LAST NAME
		5
		5
		VARCHAR2
		UNDEFINED
		80
		5
	
	
		2
		GENERATION CODE
		6
		6
		VARCHAR2
		UNDEFINED
		30
		6
	
	
		2
		HOUSE #
		7
		7
		VARCHAR2
		UNDEFINED
		30
		7
	
	
		2
		ADDRESS LINE
		8
		8
		VARCHAR2
		UNDEFINED
		80
		8
	
	
		2
		CITY
		9
		9
		VARCHAR2
		UNDEFINED
		30
		9
	
	
		2
		STATE
		10
		10
		VARCHAR2
		UNDEFINED
		2
		10
	
	
		2
		ZIP CODE
		11
		11
		VARCHAR2
		UNDEFINED
		30
		11
	
	
		2
		ZIP EXTN
		12
		12
		VARCHAR2
		UNDEFINED
		30
		12
	
	
		2
		LANGUAGE CODE
		13
		13
		VARCHAR2
		UNDEFINED
		30
		13
	
	
		2
		SSN
		14
		14
		NUMBER
		0
		9
		14
	
	
		2
		PRODUCER NAME
		15
		15
		VARCHAR2
		UNDEFINED
		80
		15
	
	
		2
		PRODUCER #
		16
		16
		VARCHAR2
		UNDEFINED
		30
		16
	
	
		2
		PRODUCER ADDRESS LINE
		17
		17
		VARCHAR2
		UNDEFINED
		80
		17
	
	
		2
		PRODUCER CITY
		18
		18
		VARCHAR2
		UNDEFINED
		30
		18
	
	
		2
		PRODUCER STATE
		19
		19
		VARCHAR2
		UNDEFINED
		2
		19
	
	
		2
		PRODUCER ZIP CODE
		20
		20
		VARCHAR2
		UNDEFINED
		30
		20
	
	
		2
		PRODUCER PHONE
		21
		21
		NUMBER
		9999999999
		10
		21
	
	
		2
		COMPANY NAME
		22
		22
		VARCHAR2
		UNDEFINED
		80
		22
	
	
		2
		COMPANY ADDRESS LINE
		23
		23
		VARCHAR2
		UNDEFINED
		80
		23
	
	
		2
		COMPANY CITY
		24
		24
		VARCHAR2
		UNDEFINED
		30
		24
	
	
		2
		COMPANY STATE
		25
		25
		VARCHAR2
		UNDEFINED
		2
		25
	
	
		2
		COMPANY ZIP
		26
		26
		VARCHAR2
		UNDEFINED
		30
		26
	
	
		2
		REMITTANCE ADDRESS LINE
		27
		27
		VARCHAR2
		UNDEFINED
		80
		27
	
	
		2
		REMITTANCE CITY
		28
		28
		VARCHAR2
		UNDEFINED
		30
		28
	
	
		2
		REMITTANCE STATE
		29
		29
		VARCHAR2
		UNDEFINED
		2
		29
	
	
		2
		REMITTANCE ZIP CODE
		30
		30
		VARCHAR2
		UNDEFINED
		30
		30
	
	
		2
		REMITTANCE ZIP EXTN
		31
		31
		VARCHAR2
		UNDEFINED
		30
		31
	
	
		2
		REMITTANCE COUNTRY CODE
		32
		32
		VARCHAR2
		UNDEFINED
		30
		32
	
	
		2
		REMITTANCE PHONE
		33
		33
		NUMBER
		9999999999
		10
		33
	
	
		2
		TOTAL PREVIOUS BALANCE
		34
		34
		NUMBER
		999999999.9
		12
		34
	
	
		2
		TOTAL ADVANCE AMOUNT
		35
		35
		NUMBER
		999999999.9
		12
		35
	
	
		2
		TOTAL PAST DUE AMOUNT
		36
		36
		NUMBER
		999999999.9
		12
		36
	
	
		2
		DUE DATE
		37
		37
		DATE
		MM/DD/YYYY
		10
		37
	
	
		2
		OLDEST DUE DATE
		38
		38
		DATE
		MM/DD/YYYY
		10
		38
	
	
		2
		TOTAL CURRENT DUE AMOUNT
		39
		39
		NUMBER
		999999999.9
		12
		39
	
	
		2
		TOTAL MINIMUM DUE AMOUNT
		40
		40
		NUMBER
		999999999.9
		12
		40
	
	
		2
		TOTAL CREDIT LIMIT
		41
		41
		NUMBER
		999999999.9
		12
		41
	
	
		2
		TOTAL CREDIT AVAILABLE
		42
		42
		NUMBER
		999999999.9
		12
		42
	
	
		2
		TOTAL CREDIT AMOUNT
		43
		43
		NUMBER
		999999999.9
		12
		43
	
	
		2
		TOTAL PAYMENTS AMOUNT
		44
		44
		NUMBER
		999999999.9
		12
		44
	
	
		2
		TOTAL OTHER CHARGES
		45
		45
		NUMBER
		999999999.9
		12
		45
	
	
		2
		TOTAL OTHER FEE CHARGES
		46
		46
		NUMBER
		999999999.9
		12
		46
	
	
		2
		TOTAL OTHER EXPENSES CHARGES
		47
		47
		NUMBER
		999999999.9
		12
		47
	
	
		2
		TOTAL LATE CHARGE AMOUNT
		48
		48
		NUMBER
		999999999.9
		12
		48
	
	
		2
		PAYOFF DATE
		49
		49
		DATE
		MM/DD/YYYY
		10
		49
	
	
		2
		TOTAL PAYOFF AMOUNT
		50
		50
		NUMBER
		999999999.9
		12
		50
	
	
		2
		TOTAL OUTSTANDING FEE
		51
		51
		NUMBER
		999999999.9
		12
		51
	
	
		2
		TOTAL OUTSTANDING EXPENSE
		52
		52
		NUMBER
		999999999.9
		12
		52
	
	
		2
		TOTAL NEW BALANCE AMOUNT
		53
		53
		NUMBER
		999999999.9
		12
		53
	
	
		2
		TOTAL PRINCIPAL BALANCE
		54
		54
		NUMBER
		999999999.9
		12
		54
	
	
		2
		STATEMENT CLOSING DATE
		55
		55
		DATE
		MM/DD/YYYY
		10
		55
	
	
		2
		STATEMENT DATE
		56
		56
		DATE
		MM/DD/YYYY
		10
		56
	
	
		3
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		3
		ACCOUNT #
		2
		2
		VARCHAR2
		UNDEFINED
		30
		2
	
	
		3
		MASTER ACCOUNT #
		3
		3
		VARCHAR2
		UNDEFINED
		30
		3
	
	
		3
		FIRST NAME
		4
		4
		VARCHAR2
		UNDEFINED
		80
		4
	
	
		3
		MIDDLE NAME
		5
		5
		VARCHAR2
		UNDEFINED
		1
		5
	
	
		3
		LAST NAME
		6
		6
		VARCHAR2
		UNDEFINED
		80
		6
	
	
		3
		GENERATION CODE
		7
		7
		VARCHAR2
		UNDEFINED
		30
		7
	
	
		3
		HOUSE #
		8
		8
		VARCHAR2
		UNDEFINED
		30
		8
	
	
		3
		ADDRESS LINE
		9
		9
		VARCHAR2
		UNDEFINED
		80
		9
	
	
		3
		CITY
		10
		10
		VARCHAR2
		UNDEFINED
		30
		10
	
	
		3
		STATE
		11
		11
		VARCHAR2
		UNDEFINED
		2
		11
	
	
		3
		ZIP CODE
		12
		12
		VARCHAR2
		UNDEFINED
		30
		12
	
	
		3
		ZIP EXTN
		13
		13
		VARCHAR2
		UNDEFINED
		30
		13
	
	
		3
		LANGUAGE CODE
		14
		14
		VARCHAR2
		UNDEFINED
		30
		14
	
	
		3
		SSN
		15
		15
		NUMBER
		0
		9
		15
	
	
		3
		PRODUCER NAME
		16
		16
		VARCHAR2
		UNDEFINED
		80
		16
	
	
		3
		PRODUCER #
		17
		17
		VARCHAR2
		UNDEFINED
		30
		17
	
	
		3
		PRODUCER ADDRESS LINE
		18
		18
		VARCHAR2
		UNDEFINED
		80
		18
	
	
		3
		PRODUCER CITY
		19
		19
		VARCHAR2
		UNDEFINED
		30
		19
	
	
		3
		PRODUCER STATE
		20
		20
		VARCHAR2
		UNDEFINED
		2
		20
	
	
		3
		PRODUCER ZIP CODE
		21
		21
		VARCHAR2
		UNDEFINED
		30
		21
	
	
		3
		PRODUCER PHONE
		22
		22
		NUMBER
		9999999999
		10
		22
	
	
		3
		COMPANY NAME
		23
		23
		VARCHAR2
		UNDEFINED
		80
		23
	
	
		3
		COMPANY ADDRESS LINE
		24
		24
		VARCHAR2
		UNDEFINED
		80
		24
	
	
		3
		COMPANY CITY
		25
		25
		VARCHAR2
		UNDEFINED
		30
		25
	
	
		3
		COMPANY STATE
		26
		26
		VARCHAR2
		UNDEFINED
		2
		26
	
	
		3
		COMPANY ZIP
		27
		27
		VARCHAR2
		UNDEFINED
		30
		27
	
	
		3
		REMITTANCE ADDRESS LINE
		28
		28
		VARCHAR2
		UNDEFINED
		80
		28
	
	
		3
		REMITTANCE CITY
		29
		29
		VARCHAR2
		UNDEFINED
		30
		29
	
	
		3
		REMITTANCE STATE
		30
		30
		VARCHAR2
		UNDEFINED
		2
		30
	
	
		3
		REMITTANCE ZIP CODE
		31
		31
		VARCHAR2
		UNDEFINED
		30
		31
	
	
		3
		REMITTANCE ZIP EXTN
		32
		32
		VARCHAR2
		UNDEFINED
		30
		32
	
	
		3
		REMITTANCE COUNTRY CODE
		33
		33
		VARCHAR2
		UNDEFINED
		30
		33
	
	
		3
		REMITTANCE PHONE
		34
		34
		NUMBER
		9999999999
		10
		34
	
	
		3
		CURRENT DUE AMOUNT
		35
		35
		NUMBER
		999999999.9
		12
		35
	
	
		3
		MINIMUM DUE AMOUNT
		36
		36
		NUMBER
		999999999.9
		12
		36
	
	
		3
		DAILY PERIODIC RATE
		37
		37
		NUMBER
		9999.99999
		11
		37
	
	
		3
		AVERAGE DAILY BALANCE
		38
		38
		NUMBER
		999999999.9
		12
		38
	
	
		3
		DAYS IN CYCLE
		39
		39
		NUMBER
		0
		3
		39
	
	
		3
		CREDIT LIMIT
		40
		40
		NUMBER
		999999999.9
		12
		40
	
	
		3
		CREDIT AVAILABLE
		41
		41
		NUMBER
		999999999.9
		12
		41
	
	
		3
		CREDIT AMOUNT
		42
		42
		NUMBER
		999999999.9
		12
		42
	
	
		3
		ADVANCE AMOUNT
		43
		43
		NUMBER
		999999999.9
		12
		43
	
	
		3
		PAST DUE AMOUNT
		44
		44
		NUMBER
		999999999.9
		12
		44
	
	
		3
		PREVIOUS BALANCE
		45
		45
		NUMBER
		999999999.9
		12
		45
	
	
		3
		PAYMENTS AMOUNT
		46
		46
		NUMBER
		999999999.9
		12
		46
	
	
		3
		OTHER CHARGES
		47
		47
		NUMBER
		999999999.9
		12
		47
	
	
		3
		OTHER FEE CHARGES
		48
		48
		NUMBER
		999999999.9
		12
		48
	
	
		3
		OTHER EXPENSES CHARGES
		49
		49
		NUMBER
		999999999.9
		12
		49
	
	
		3
		LATE CHARGE AMOUNT
		50
		50
		NUMBER
		999999999.9
		12
		50
	
	
		3
		NEW BALANCE AMOUNT
		51
		51
		NUMBER
		999999999.9
		12
		51
	
	
		3
		PAYOFF DATE
		52
		52
		DATE
		MM/DD/YYYY
		10
		52
	
	
		3
		PAYOFF AMOUNT
		53
		53
		NUMBER
		999999999.9
		12
		53
	
	
		3
		OUTSTANDING TOTAL FEE
		54
		54
		NUMBER
		999999999.9
		12
		54
	
	
		3
		OUTSTANDING TOTAL EXPENSE
		55
		55
		NUMBER
		999999999.9
		12
		55
	
	
		3
		OLDEST DUE DATE
		56
		56
		DATE
		MM/DD/YYYY
		10
		56
	
	
		3
		STATEMENT CLOSING DATE
		57
		57
		DATE
		MM/DD/YYYY
		10
		57
	
	
		3
		STATEMENT DATE
		58
		58
		DATE
		MM/DD/YYYY
		10
		58
	
	
		3
		POOL
		59
		59
		VARCHAR2
		UNDEFINED
		30
		59
	
	
		3
		PRINCIPLE BALANCE
		60
		60
		NUMBER
		999999999.9
		12
		60
	
	
		3
		DUE DATE
		61
		61
		DATE
		MM/DD/YYYY
		10
		61
	
	
		4
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		4
		ACCOUNT #
		2
		2
		VARCHAR2
		UNDEFINED
		30
		2
	
	
		4
		ASSET TYPE
		3
		3
		VARCHAR2
		UNDEFINED
		30
		3
	
	
		4
		ASSET SUB TYPE
		4
		4
		VARCHAR2
		UNDEFINED
		30
		4
	
	
		4
		ASSET NUMBER
		5
		5
		VARCHAR2
		UNDEFINED
		30
		5
	
	
		4
		ASSET IDENTIFICATION NUMBER
		6
		6
		VARCHAR2
		UNDEFINED
		30
		6
	
	
		4
		ASSET YEAR
		7
		7
		VARCHAR2
		UNDEFINED
		80
		7
	
	
		4
		ASSET MAKE
		8
		8
		VARCHAR2
		UNDEFINED
		80
		8
	
	
		4
		ASSET MODEL
		9
		9
		VARCHAR2
		UNDEFINED
		80
		9
	
	
		5
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		5
		ACCOUNT #
		2
		2
		VARCHAR2
		UNDEFINED
		30
		2
	
	
		5
		TRANSACTION DESCRIPTION
		3
		3
		VARCHAR2
		UNDEFINED
		80
		3
	
	
		5
		TRANSACTION DATE
		4
		4
		DATE
		MM/DD/YYYY
		10
		4
	
	
		5
		TRANSACTION AMOUNT
		5
		5
		NUMBER
		999999999.9
		12
		5
	
	
		5
		TRUE TRANSACTION INDICATOR
		6
		6
		VARCHAR2
		UNDEFINED
		30
		6
	
	
		5
		INTERNAL TRANSACTION INDICATOR
		7
		7
		VARCHAR2
		UNDEFINED
		30
		7
	
	
		5
		STATEMENT PREFERENCE MODE
		8
		8
		VARCHAR2
		UNDEFINED
		30
		8
	
	
		6
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		6
		ACCOUNT #
		2
		2
		VARCHAR2
		UNDEFINED
		30
		2
	
	
		6
		MESSAGE CODE
		3
		3
		VARCHAR2
		UNDEFINED
		30
		3
	
	
		6
		MESSAGE SORT
		4
		4
		NUMBER
		0
		2
		4
	
	
		6
		MESSAGE TEXT
		5
		5
		VARCHAR2
		UNDEFINED
		512
		5
	
	
		7
		RECORD TYPE
		1
		1
		VARCHAR2
		UNDEFINED
		30
		1
	
	
		7
		GENERATION DATE
		2
		2
		DATE
		MM/DD/YYYY
		10
		2
	
	
		7
		TOTAL STATEMENTS
		3
		3
		NUMBER
		0000000000
		10
		3

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet file definition data definitions name desc enabled master account statement customer stmt y record type description delimited cd delimiter terminator header variable crlf linked asset details transaction message footer column seq output format mask length sort varchar undefined date mmddyyyy branch company first middle last generation code house address line city state zip extn language ssn number producer phone remittance country total previous balance advance amount past due oldest current minimum credit limit available payments other charges fee expenses late charge payoff outstanding expense new principal closing daily periodic rate average days in cycle t...

Related files

Share

Help

Data File Definitions
NAME	DESC	FILE NAME	ENABLED
MASTER_ACCOUNT_STATEMENT	MASTER ACCOUNT CUSTOMER STATEMENT	master_account_customer_stmt	Y

Record Definitions
RECORD TYPE	RECORD DESCRIPTION	DELIMITED CD	DELIMITER	RECORD TERMINATOR
1	HEADER RECORD	VARIABLE	\|	CRLF
2	MASTER ACCOUNT RECORD	VARIABLE	\|	CRLF
3	LINKED ACCOUNT RECORD	VARIABLE	\|	CRLF
4	ASSET DETAILS RECORD	VARIABLE	\|	CRLF
5	TRANSACTION RECORD	VARIABLE	\|	CRLF
6	MESSAGE RECORD	VARIABLE	\|	CRLF
7	FOOTER RECORD	VARIABLE	\|	CRLF

Column Definitions
RECORD TYPE	COLUMN NAME	COLUMN SEQ	OUTPUT COLUMN SEQ	DATA TYPE	FORMAT MASK	COLUMN LENGTH	SORT
1	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
1	STATEMENT DATE	2	2	DATE	MM/DD/YYYY	10	2
1	BRANCH	3	3	VARCHAR2	UNDEFINED	30	3
1	COMPANY	4	4	VARCHAR2	UNDEFINED	30	4
2	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
2	MASTER ACCOUNT #	2	2	VARCHAR2	UNDEFINED	30	2
2	FIRST NAME	3	3	VARCHAR2	UNDEFINED	80	3
2	MIDDLE NAME	4	4	VARCHAR2	UNDEFINED	1	4
2	LAST NAME	5	5	VARCHAR2	UNDEFINED	80	5
2	GENERATION CODE	6	6	VARCHAR2	UNDEFINED	30	6
2	HOUSE #	7	7	VARCHAR2	UNDEFINED	30	7
2	ADDRESS LINE	8	8	VARCHAR2	UNDEFINED	80	8
2	CITY	9	9	VARCHAR2	UNDEFINED	30	9
2	STATE	10	10	VARCHAR2	UNDEFINED	2	10
2	ZIP CODE	11	11	VARCHAR2	UNDEFINED	30	11
2	ZIP EXTN	12	12	VARCHAR2	UNDEFINED	30	12
2	LANGUAGE CODE	13	13	VARCHAR2	UNDEFINED	30	13
2	SSN	14	14	NUMBER	0	9	14
2	PRODUCER NAME	15	15	VARCHAR2	UNDEFINED	80	15
2	PRODUCER #	16	16	VARCHAR2	UNDEFINED	30	16
2	PRODUCER ADDRESS LINE	17	17	VARCHAR2	UNDEFINED	80	17
2	PRODUCER CITY	18	18	VARCHAR2	UNDEFINED	30	18
2	PRODUCER STATE	19	19	VARCHAR2	UNDEFINED	2	19
2	PRODUCER ZIP CODE	20	20	VARCHAR2	UNDEFINED	30	20
2	PRODUCER PHONE	21	21	NUMBER	9999999999	10	21
2	COMPANY NAME	22	22	VARCHAR2	UNDEFINED	80	22
2	COMPANY ADDRESS LINE	23	23	VARCHAR2	UNDEFINED	80	23
2	COMPANY CITY	24	24	VARCHAR2	UNDEFINED	30	24
2	COMPANY STATE	25	25	VARCHAR2	UNDEFINED	2	25
2	COMPANY ZIP	26	26	VARCHAR2	UNDEFINED	30	26
2	REMITTANCE ADDRESS LINE	27	27	VARCHAR2	UNDEFINED	80	27
2	REMITTANCE CITY	28	28	VARCHAR2	UNDEFINED	30	28
2	REMITTANCE STATE	29	29	VARCHAR2	UNDEFINED	2	29
2	REMITTANCE ZIP CODE	30	30	VARCHAR2	UNDEFINED	30	30
2	REMITTANCE ZIP EXTN	31	31	VARCHAR2	UNDEFINED	30	31
2	REMITTANCE COUNTRY CODE	32	32	VARCHAR2	UNDEFINED	30	32
2	REMITTANCE PHONE	33	33	NUMBER	9999999999	10	33
2	TOTAL PREVIOUS BALANCE	34	34	NUMBER	999999999.9	12	34
2	TOTAL ADVANCE AMOUNT	35	35	NUMBER	999999999.9	12	35
2	TOTAL PAST DUE AMOUNT	36	36	NUMBER	999999999.9	12	36
2	DUE DATE	37	37	DATE	MM/DD/YYYY	10	37
2	OLDEST DUE DATE	38	38	DATE	MM/DD/YYYY	10	38
2	TOTAL CURRENT DUE AMOUNT	39	39	NUMBER	999999999.9	12	39
2	TOTAL MINIMUM DUE AMOUNT	40	40	NUMBER	999999999.9	12	40
2	TOTAL CREDIT LIMIT	41	41	NUMBER	999999999.9	12	41
2	TOTAL CREDIT AVAILABLE	42	42	NUMBER	999999999.9	12	42
2	TOTAL CREDIT AMOUNT	43	43	NUMBER	999999999.9	12	43
2	TOTAL PAYMENTS AMOUNT	44	44	NUMBER	999999999.9	12	44
2	TOTAL OTHER CHARGES	45	45	NUMBER	999999999.9	12	45
2	TOTAL OTHER FEE CHARGES	46	46	NUMBER	999999999.9	12	46
2	TOTAL OTHER EXPENSES CHARGES	47	47	NUMBER	999999999.9	12	47
2	TOTAL LATE CHARGE AMOUNT	48	48	NUMBER	999999999.9	12	48
2	PAYOFF DATE	49	49	DATE	MM/DD/YYYY	10	49
2	TOTAL PAYOFF AMOUNT	50	50	NUMBER	999999999.9	12	50
2	TOTAL OUTSTANDING FEE	51	51	NUMBER	999999999.9	12	51
2	TOTAL OUTSTANDING EXPENSE	52	52	NUMBER	999999999.9	12	52
2	TOTAL NEW BALANCE AMOUNT	53	53	NUMBER	999999999.9	12	53
2	TOTAL PRINCIPAL BALANCE	54	54	NUMBER	999999999.9	12	54
2	STATEMENT CLOSING DATE	55	55	DATE	MM/DD/YYYY	10	55
2	STATEMENT DATE	56	56	DATE	MM/DD/YYYY	10	56
3	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
3	ACCOUNT #	2	2	VARCHAR2	UNDEFINED	30	2
3	MASTER ACCOUNT #	3	3	VARCHAR2	UNDEFINED	30	3
3	FIRST NAME	4	4	VARCHAR2	UNDEFINED	80	4
3	MIDDLE NAME	5	5	VARCHAR2	UNDEFINED	1	5
3	LAST NAME	6	6	VARCHAR2	UNDEFINED	80	6
3	GENERATION CODE	7	7	VARCHAR2	UNDEFINED	30	7
3	HOUSE #	8	8	VARCHAR2	UNDEFINED	30	8
3	ADDRESS LINE	9	9	VARCHAR2	UNDEFINED	80	9
3	CITY	10	10	VARCHAR2	UNDEFINED	30	10
3	STATE	11	11	VARCHAR2	UNDEFINED	2	11
3	ZIP CODE	12	12	VARCHAR2	UNDEFINED	30	12
3	ZIP EXTN	13	13	VARCHAR2	UNDEFINED	30	13
3	LANGUAGE CODE	14	14	VARCHAR2	UNDEFINED	30	14
3	SSN	15	15	NUMBER	0	9	15
3	PRODUCER NAME	16	16	VARCHAR2	UNDEFINED	80	16
3	PRODUCER #	17	17	VARCHAR2	UNDEFINED	30	17
3	PRODUCER ADDRESS LINE	18	18	VARCHAR2	UNDEFINED	80	18
3	PRODUCER CITY	19	19	VARCHAR2	UNDEFINED	30	19
3	PRODUCER STATE	20	20	VARCHAR2	UNDEFINED	2	20
3	PRODUCER ZIP CODE	21	21	VARCHAR2	UNDEFINED	30	21
3	PRODUCER PHONE	22	22	NUMBER	9999999999	10	22
3	COMPANY NAME	23	23	VARCHAR2	UNDEFINED	80	23
3	COMPANY ADDRESS LINE	24	24	VARCHAR2	UNDEFINED	80	24
3	COMPANY CITY	25	25	VARCHAR2	UNDEFINED	30	25
3	COMPANY STATE	26	26	VARCHAR2	UNDEFINED	2	26
3	COMPANY ZIP	27	27	VARCHAR2	UNDEFINED	30	27
3	REMITTANCE ADDRESS LINE	28	28	VARCHAR2	UNDEFINED	80	28
3	REMITTANCE CITY	29	29	VARCHAR2	UNDEFINED	30	29
3	REMITTANCE STATE	30	30	VARCHAR2	UNDEFINED	2	30
3	REMITTANCE ZIP CODE	31	31	VARCHAR2	UNDEFINED	30	31
3	REMITTANCE ZIP EXTN	32	32	VARCHAR2	UNDEFINED	30	32
3	REMITTANCE COUNTRY CODE	33	33	VARCHAR2	UNDEFINED	30	33
3	REMITTANCE PHONE	34	34	NUMBER	9999999999	10	34
3	CURRENT DUE AMOUNT	35	35	NUMBER	999999999.9	12	35
3	MINIMUM DUE AMOUNT	36	36	NUMBER	999999999.9	12	36
3	DAILY PERIODIC RATE	37	37	NUMBER	9999.99999	11	37
3	AVERAGE DAILY BALANCE	38	38	NUMBER	999999999.9	12	38
3	DAYS IN CYCLE	39	39	NUMBER	0	3	39
3	CREDIT LIMIT	40	40	NUMBER	999999999.9	12	40
3	CREDIT AVAILABLE	41	41	NUMBER	999999999.9	12	41
3	CREDIT AMOUNT	42	42	NUMBER	999999999.9	12	42
3	ADVANCE AMOUNT	43	43	NUMBER	999999999.9	12	43
3	PAST DUE AMOUNT	44	44	NUMBER	999999999.9	12	44
3	PREVIOUS BALANCE	45	45	NUMBER	999999999.9	12	45
3	PAYMENTS AMOUNT	46	46	NUMBER	999999999.9	12	46
3	OTHER CHARGES	47	47	NUMBER	999999999.9	12	47
3	OTHER FEE CHARGES	48	48	NUMBER	999999999.9	12	48
3	OTHER EXPENSES CHARGES	49	49	NUMBER	999999999.9	12	49
3	LATE CHARGE AMOUNT	50	50	NUMBER	999999999.9	12	50
3	NEW BALANCE AMOUNT	51	51	NUMBER	999999999.9	12	51
3	PAYOFF DATE	52	52	DATE	MM/DD/YYYY	10	52
3	PAYOFF AMOUNT	53	53	NUMBER	999999999.9	12	53
3	OUTSTANDING TOTAL FEE	54	54	NUMBER	999999999.9	12	54
3	OUTSTANDING TOTAL EXPENSE	55	55	NUMBER	999999999.9	12	55
3	OLDEST DUE DATE	56	56	DATE	MM/DD/YYYY	10	56
3	STATEMENT CLOSING DATE	57	57	DATE	MM/DD/YYYY	10	57
3	STATEMENT DATE	58	58	DATE	MM/DD/YYYY	10	58
3	POOL	59	59	VARCHAR2	UNDEFINED	30	59
3	PRINCIPLE BALANCE	60	60	NUMBER	999999999.9	12	60
3	DUE DATE	61	61	DATE	MM/DD/YYYY	10	61
4	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
4	ACCOUNT #	2	2	VARCHAR2	UNDEFINED	30	2
4	ASSET TYPE	3	3	VARCHAR2	UNDEFINED	30	3
4	ASSET SUB TYPE	4	4	VARCHAR2	UNDEFINED	30	4
4	ASSET NUMBER	5	5	VARCHAR2	UNDEFINED	30	5
4	ASSET IDENTIFICATION NUMBER	6	6	VARCHAR2	UNDEFINED	30	6
4	ASSET YEAR	7	7	VARCHAR2	UNDEFINED	80	7
4	ASSET MAKE	8	8	VARCHAR2	UNDEFINED	80	8
4	ASSET MODEL	9	9	VARCHAR2	UNDEFINED	80	9
5	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
5	ACCOUNT #	2	2	VARCHAR2	UNDEFINED	30	2
5	TRANSACTION DESCRIPTION	3	3	VARCHAR2	UNDEFINED	80	3
5	TRANSACTION DATE	4	4	DATE	MM/DD/YYYY	10	4
5	TRANSACTION AMOUNT	5	5	NUMBER	999999999.9	12	5
5	TRUE TRANSACTION INDICATOR	6	6	VARCHAR2	UNDEFINED	30	6
5	INTERNAL TRANSACTION INDICATOR	7	7	VARCHAR2	UNDEFINED	30	7
5	STATEMENT PREFERENCE MODE	8	8	VARCHAR2	UNDEFINED	30	8
6	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
6	ACCOUNT #	2	2	VARCHAR2	UNDEFINED	30	2
6	MESSAGE CODE	3	3	VARCHAR2	UNDEFINED	30	3
6	MESSAGE SORT	4	4	NUMBER	0	2	4
6	MESSAGE TEXT	5	5	VARCHAR2	UNDEFINED	512	5
7	RECORD TYPE	1	1	VARCHAR2	UNDEFINED	30	1
7	GENERATION DATE	2	2	DATE	MM/DD/YYYY	10	2
7	TOTAL STATEMENTS	3	3	NUMBER	0000000000	10	3

Related files

Share

Share to social media

Help

Login Area