Statement Batch File Layout

The statement batch file sent to your billing service is a comma-delimited (csv) file. Each data field is enclosed in double-quotes (“). The data in the fields varies by line type, and the first field in each line is a tag that identifies the line type.

Tag	Line Type	Description
VER	Version	Information about the version of this document.
HDR	Header	Information about a statement, such as the remit-to address, statement date, bill-to address, and other information. Each statement has one HDR line.
ITM	Item	Information about one invoice on this statement. You can have multiple ITM lines per statement.
FTR	Footer	Information about the balances for the statement. Each statement has one FTR line. It signals the end of the data for one statement.
SUM	Summary	Summary information for the entire batch transmission, such as the number of statements in the batch file.

Version Line Data Fields

Field Number	Description	Format
1	Segment Code VER	Alpha
2	Eclipse Point Release	Alphanumeric
3	Third-Party Statement Layout Document ID	Alpha

Header Line Data Fields

Field Number	Description	Format
1	Segment Code HDR	Alpha
2	Ship-To Customer ID	Numeric
3	Bill-to Customer ID	Numeric
4	Remit-To Address1	Alphanumeric
5	Remit-To Address2	Alphanumeric
6	Remit-To Address3	Alphanumeric
7	Remit-To Address4	Alphanumeric
8	Remit-To City	Alpha
9	Remit-To State	Alpha
10	Remit-To Zip	Alphanumeric
11	Remit-To Phone Number	Alphanumeric
12	Remit-To Fax Number	Alphanumeric
13	Home Branch Address1	Alphanumeric
14	Home Branch Address2	Alphanumeric
15	Home Branch Address3	Alphanumeric
16	Home Branch Address4	Alphanumeric
17	Home Branch City	Alpha
18	Home Branch State	Alpha
19	Home Branch Zip	Alphanumeric
20	Home Branch Phone Number	Alphanumeric
21	Home Branch Fax Number	Alphanumeric
22	Bill-To Address 1	Alphanumeric
23	Bill-To Address 2	Alphanumeric
24	Bill-To Address 3	Alphanumeric
25	Bill-To Address 4	Alphanumeric
26	Bill-To City	Alpha
27	Bill-To State	Alpha
28	Bill-To Zip	Alphanumeric
29	Statement Date	mm/dd/yy
30	Home Branch Number	Alphanumeric
31	Send via	Alpha
32	Email – TO	Alphanumeric
33	Email – CC	Alphanumeric
34	Email – BCC	Alphanumeric
35	Email – Subject	Alphanumeric
36	Email – Body	Alphanumeric
37	Email – From	Alphanumeric
38	Email – Format	Alpha
39	Fax – To Contact	Alpha
40	Fax – To Number	Numeric
41	Fax – To Message	Alphanumeric
42	Fax – From Contact	Alpha
43	Fax – Send Time	Alphanumeric
44	Fax – Send Date	mm/dd/yy
45	Ship-To Address 1	Alphanumeric
46	Ship-To Address 2	Alphanumeric
47	Ship-To Address 3	Alphanumeric
48	Ship-To Address 4	Alphanumeric
49	Ship-To City	Alpha
50	Ship-To State	Alpha
51	Ship-To Zip	Alphanumeric
52	User Defined Data
53	User Defined Data
54	User Defined Data
55	User Defined Data
56	User Defined Data
57	User Defined Data
58	User Defined Data
59	User Defined Data
60	User Defined Data
61	User Defined Data

Item Line Data Fields

Field Number	Description	Format
1	Segment Code ITM	Alpha
2	Date	mm/dd/yyyy
3	Invoice Number	Alphanumeric
4	Purchase Order Number	Alphanumeric
5	Invoice Amount	Decimal (2)
6	Payments/Credits	Decimal (2)
7	Net Due Amount	Decimal (2)
8	Invoice Status Message	Alphanumeric
9	Discount Amount at time of stmt run	Decimal (2)
10	Discount Date	mm/dd/yyyy
11	Past Due	Decimal (2)
12	Future Due	Decimal (2)
13	Current Due	Decimal (2)
14	Invoice Due Date	mm/dd/yyyy
15	User Defined Data
16	User Defined Data
17	User Defined Data
18	User Defined Data
19	User Defined Data
20	User Defined Data
21	User Defined Data
22	User Defined Data
23	User Defined Data
24	User Defined Data

Footer Line Date Fields

Field Number	Description	Format
1	Segment Code FTR	Alpha
2	Statement Message	Alphanumeric
3	Discount Date \| Amount (you can have multiple dates and amounts)	multi
4	Full amount due date	mm/dd/yyyy
5	Previous balance	Decimal (2)
6	Total payments	Decimal (2)
7	Total credits	Decimal (2)
8	Total Purchases	Decimal (2)
9	Total Service Charges	Decimal (2)
10	New Balance	Decimal (2)
11	Future Amount Due	Decimal (2)
12	Current Amount Due	Decimal (2)
13	31-60 Days Amount Due	Decimal (2)
14	61-90 Days Amount Due	Decimal (2)
15	91-120 Days Amount Due	Decimal (2)
16	120+ Days Amount Due	Decimal (2)
17	Service Message	Alphanumeric
18	Past Due Total	Decimal (2)
19	Future Due Total	Decimal (2)
20	Current Due Total	Decimal (2)
21	Deposits	Decimal (2)
22	User Defined Data
23	User Defined Data
24	User Defined Data
25	User Defined Data
26	User Defined Data
27	User Defined Data
28	User Defined Data
29	User Defined Data
30	User Defined Data
31	User Defined Data

Summary Line Data Fields

Field Number	Description	Format
1	Segment Code SUM	Alpha
2	Statement Count	Numeric
3	Item Count	Numeric
4	Total Batch Amount	Decimal (2)