Receivables Sum Master File | WennSoft Documentation

Import File: SVRM0001.CSV (Comma) or SVRM0001.TXT (Tab)
Warehouse File: SV_RM_Customer_SUM_IMP_WHSE
Destination File: RM_Customer_MSTR_SUM (RM00103)

*Indicates validated fields, and must contain data.

**Indicates validated, but can be left empty.

Tab Position (.txt file)	Excel Column (.csv file)	Field Name	Storage Type	Keyable	Storage
1	A	Total Amount Of NSF Checks Life	Currency	19	10
2	B	Number Of NSF Checks Life	Long Integer	6	4
3	C	*Customer Number	String	15	16
4	D	Customer Balance	Currency	19	10
5 - 11	E-K	Aging Period Amounts	Currency	17	10
12	L	Last Aged	Date	6	4
13	M	First Invoice Date	Date	6	4
14	N	Last NSF Check Date	Date	6	4
15	O	Last Payment Amount	Currency	17	10
16	P	Last Payment Date	Date	6	4
17	Q	Last Transaction Date	Date	6	4
18	R	Last Transaction Amount	Currency	17	10
19	S	Last Finance Charge Amount	Currency	17	10
20	T	Unpaid Finance Charges YTD	Currency	17	10
21	U	Average Days to Pay - LYR	Integer	3	2
22	V	Average Days To Pay - Life	Integer	3	2
23	W	Average Days To Pay - Year	Integer	3	2
24	X	Number ADTP Documents - Life	Long Integer	10	4
25	Y	Number ADTP Documents - Year	Long Integer	10	4
26	Z	Total Discounts Taken YTD	Currency	19	10
27	AA	Total Discounts Taken LYR	Currency	19	10
28	AB	Total Discounts Taken LTD	Currency	19	10
29	AC	Total Discounts Available YTD	Currency	19	10
30	AD	Retainage	Currency	19	10
31	AE	Total Amount Of NSF Checks YTD	Currency	19	10
32	AF	Number Of NSF Checks YTD	Long Integer	6	4
33	AG	Unposted Sales Amount	Currency	19	10
34	AH	Unposted Cash Amount	Currency	19	10
35	AI	Unposted Other Sales Amount	Currency	19	10
36	AJ	Unposted Other Cash Amount	Currency	19	10
37	AK	Non Current Scheduled Payments	Currency	19	10
38	AL	Total Sales YTD	Currency	19	10
39	AM	Total Sales LTD	Currency	19	10
40	AN	Total Sales LYR	Currency	19	10
41	AO	Total Costs YTD	Currency	19	10
42	AP	Total Costs LTD	Currency	19	10
43	AQ	Total Costs LYR	Currency	19	10
44	AR	Total Cash Received YTD	Currency	19	10
45	AS	Total Cash Received LTD	Currency	19	10
46	AT	Total Cash Received LYR	Currency	19	10
47	AU	Total Finance Charges YTD	Currency	19	10
48	AV	Total Finance Charges LTD	Currency	19	10
49	AW	Total Finance Charges LYR	Currency	19	10
50	AX	Finance Charges CYTD	Currency	19	10
51	AY	Finance Charges LYR Calendar	Currency	19	10
52	AZ	Total Bad Debt YTD	Currency	19	10
53	BA	Total Bad Debt LYR	Currency	19	10
54	BB	Total Bad Debt LTD	Currency	19	10
55	BC	Total Waived FC YTD	Currency	19	10
56	BD	Total Waived FC LTD	Currency	19	10
57	BE	Total Waived FC LYR	Currency	19	10
58	BF	Total Writeoffs YTD	Currency	19	10
59	BG	Total Writeoffs LTD	Currency	19	10
60	BH	Total Writeoffs LYR	Currency	19	10
61	BI	Total # Invoices YTD	Long Integer	6	4
62	BJ	Total # Invoices LTD	Long Integer	6	4
63	BK	Total # Invoices LYR	Long Integer	6	4
64	BL	Total # FC YTD	Long Integer	6	4
65	BM	Total # FC LTD	Long Integer	6	4
66	BN	Total # FC LYR	Long Integer	6	4
67	BO	Write Offs LIFE	Currency	19	10
68	BP	Write Offs LYR	Currency	19	10
69	BQ	Write Offs YTD	Currency	19	10
70	BR	High Balance LYR	Currency	19	10
71	BS	High Balance YTD	Currency	19	10
72	BT	High Balance LTD	Currency	19	10
73	BU	Last Statement Date	Date	6	4
74	BV	Last Statement Amount	Currency	17	10
75	BW	Deposits Received	Currency	19	10
76	BX	On Order Amount	Currency	19	10