Master Files

Billto (Customer) File

You can run a list of customers, based on entries in the Billto File.

The Customer Master List has an option to create a file for downloading to other systems. The file created is labeled BILLDWNL and is placed in library FVUSER. This file is in a simple flat file format, with no packed fields and may be easily imported into many other databases and programs. This file can be used for the following purposes:

to feed a third-party mailing system
to feed a third-party database program for PC based analysis
to feed a third-party parcel shipping system for automatic labeling of sample orders and other parcel shipments.

Customer Master List Layout

The customer master BILLDWNL File has the following layout. The starting and ending position of each field is shown as well as the length. All fields are in character format.

File: BILLDWNL
Library: FVUSER
Record Format Name: RBILLDWN
Record Length: 637

Field Name	Type	Start	End	Length	Description and Values
XID	CHAR	1	1	1	Record ID = B
XCO#	CHAR	2	2	1	Company # (0-9)
XACCT#	CHAR	3	7	5	Customer Account #
XSLMN#	CHAR	8	10	3	Salesman # or Code
XNAME	CHAR	11	40	30	Customer's Name
XADDR1	CHAR	41	70	30	Address 1
XADDR2	CHAR	71	100	30	Address 2
XCITY	CHAR	101	130	30	City
XSTATE	CHAR	131	132	2	State
XZIP1	CHAR	133	137	5	five-digit zip code
XZIP2	CHAR	138	141	4	additional four-digit zip code
XCTRY	CHAR	142	143	2	Country
XCONTA	CHAR	144	153	10	Contact Name
XPHONB	CHAR	154	164	11	Primary Phone
XPHONH	CHAR	165	175	11	Fax Phone
XOPEND	CHAR	176	182	7	Date Account Opened
XLCHDT	CHAR	183	189	7	Date Last Changed Account
XDBA	CHAR	190	209	20	Doing Business As - Name
XGUAR	CHAR	210	218	9	Guarantee Dollars
XTERPC	CHAR	219	223	5	Terms - Percent
XTERDA	CHAR	224	226	3	Terms - Days
XTERCD	CHAR	227	227	1	Terms Code
XBO	CHAR	228	228	1	B/O Code
XCRMGR	CHAR	229	229	1	Credit Manager Code
XHOLDQ	CHAR	230	230	1	Sub Hold Code
XHOLD	CHAR	231	231	1	Hold Code
XHCHG	CHAR	232	236	5	Handling Charge / Discount Percent
XOV120	CHAR	237	245	9	Over 120 Days (A/R)
XCOUNT	CHAR	246	248	3	County Code
XWHERE	CHAR	249	249	1	Where to Show Handling Charge
XLANGU	CHAR	250	250	1	Language Code
XSPCLP	CHAR	251	251	1	Use Special Price File (Y/N)
XFLAGS	CHAR	252	252	1	Misc. Flag (Bits Used)
XPOWRK	CHAR	253	261	9	Pending Orders Unprocessed
XBRAN#	CHAR	262	264	3	Branch Number or Code
XINVWK	CHAR	265	273	9	Pending Invoices Unprocessed
XORDER	CHAR	274	280	7	Total Orders, Life of Account
XTRRT1	CHAR	281	282	2	Truck Route Code 1
XTRRT2	CHAR	283	284	2	Truck Route Code 2
XTRRT3	CHAR	285	286	2	Truck Route Code 3
XPRVBA	CHAR	287	295	2	Previous A/R EOM Balance
XSLAST	CHAR	296	306	11	Last Year Sales
XS2YAG	CHAR	307	317	11	Sales 2 Yrs Ago
XBNK#1	CHAR	318	330	13	Cust Bank Acct #
XBANK1	CHAR	331	360	30	Customer Primary Bank Name
XFOB	CHAR	361	361	1	FOB Code
XMSGCD	CHAR	362	362	1	Error Flag (Y/N)
XAR#	CHAR	363	367	5	A/R Acct # to X-Ref To
XML	CHAR	368	377	10	Mailing List Codes (1 Char Each)
XINT$	CHAR	378	386	9	Accumulated Interest
XBNK#2	CHAR	387	399	13	Customer's Bank Account #2
XBANK2	CHAR	400	429	30	Bank Name 2
XFILL1	CHAR	430	434	5	Filler - Unused
XSHIP#	CHAR	435	441	7	Default SHIPTO #
XWARE#	CHAR	442	444	3	Warehouse #
XCHAIN	CHAR	445	447	3	Chain Classification Code
XINTPC	CHAR	448	452	5	XINTPC
XSHPVI	CHAR	453	454	2	Default Ship Via
XSS#	CHAR	455	463	9	Tax ID / Soc Sec #
XSTHIS	CHAR	464	474	11	Sales $ This Year
XOPENA	CHAR	475	483	9	Total Open A/R Amount
XOV15	CHAR	484	492	9	Past Due 15 Days
XOV30	CHAR	493	501	9	Past Due 30 Days
XOV45	CHAR	502	510	9	Past Due 45 Days
XOV60	CHAR	511	519	9	Past Due 60 Days
XOV90	CHAR	520	528	9	Past Due 90 Days
XMINYN	CHAR	529	529	1	Access Min Charges (Y/N)
XDELYN	CHAR	530	530	1	Access Delivery Charges (Y/N)
XOPENP	CHAR	531	539	9	Open Order Amount
XCLIMI	CHAR	540	548	9	Credit Limit Amount
XBALFW	CHAR	549	549	1	Balance Forward
XBCOCD	CHAR	550	551	2	Customer Type Code
XCLAS2	CHAR	552	553	2	Price List Code
XCOPIE	CHAR	554	554	1	Not Used - BLANK FILL
XCOMM1	CHAR	555	584	30	Comments
XCOMM2	CHAR	585	614	30	Comments 2
XLPAYD	CHAR	615	621	7	Last Payment Date
XLSALD	CHAR	622	628	7	Last Invoice Date
XCLAS3	CHAR	629	630	2	Region Code
XTAXST	CHAR	631	632	2	State Tax Code
XTAXOT	CHAR	633	634	2	Other Tax Code
XFILL3	CHAR	635	635	1	Filler - BLANK FILL
XPREF	CHAR	636	636	1	Customer ABC Rating Code
XDEL	CHAR	637	637	1	Delete Record Code