Customer File Load Map Updated: 8/23/2017 Load External Customer File (6.1.10)
Attr Field Name Customer Entry Spreadsheet Column
1 LF.CUST.NO Cust ID A
2 LF.CUST.NAME 2 B
3 LF.LEGAL.NAME 3 C
4 LF.SHIP.ADDR 4 D
5 LF.SHIP.ADDR2 4 E
6 LF.SHIP.CITY 6 F
7 LF.SHIP.STATE n/a G
8 LF.SHIP.ZIP 5 H
9 LF.MAIL.ADDR 7 I
10 LF.MAIL.ADDR2 7 J
11 LF.MAIL.CITY 9 K
12 LF.MAIL.STATE n/a L
13 LF.MAIL.ZIP 8 M
14 LF.OWNER.NAME 10 N
15 LF.AP.CONTACT 12 O
16 LF.ALT.PHONE.NO 13 P
17 LF.ALT.PHONE.DESC 13 Q
18 LF.LOCATION 15 R
19 LF.SALESPERSON 14 S
20 LF.DATE.ENT 1 T
21 LF.REFERRED.BY 11 U
22 LF.LAST.BUY.DATE n/a V
23 LF.LAST.PAY.DATE n/a W
24 LF.LAST.PAY.AMT n/a X
25 LF.CUST.MFR C-schedule Y
26 LF.CUST.INV.COMMENT IC Z
27 LF.CUST.ITAX.EXEMPT 23 AA
28 LF.AUTH.BUYERS 31 AB
29 LF.CREDIT.LIM 18 AC
30 LF.POS.NOTE 24 AD
31 LF.PRICE.CODE 17 AE
32 LF.TAX.CODE 19 AF
33 LF.RESALE.TAX.NO 20 AG
34 LF.PO.FLAG 22 AH
35 LF.SHIP.VIA 21 AI
36 LF.STATEMENT.FLAG 26 AJ
37 LF.BILL.PERIOD 27 AK
38 LF.BILLTO 16 AL
39 LF.STATEMENT.NOTE 28 AM
40 LF.PAY.TERMS (CHG,COD,CSH) 25 AN
41 LF.SERV.CHARGE 29 AO
42 LF.CUST.SORT.CODE 30 AP
43 LF.CUST.HOLD 32 AQ
44 LF.CUST.ST.DISC 34 AR
45 LF.CUST.BO 33 AS
46 LF.CUST.EXCLUDE.TAX.FR 35 AT
47 LF.CUST.ACCT.TYPE 36 AU
48 LF.CUST.PREVENT.SA 37 AV
49 LF.CUST.POINT.TABLE 38 AW
50 LF.CUST.SPCL.PR.MODEL 39 AX
51 LF.CUST.DL.NO 40 AY
52 LF.CONS.ACCT 41 AZ
53 LF.CUST.BEST.PR.ISP.MFR 42 BA
54 LF.CUST.DISABLE.CROR 43 BB
55 LF.CUST.SUPPRESS.PICK.PR 44 BC
56 LF.CUST.MAN.ALT.SHIPTO 45 BD
57 LF.CUST.SC.PERCENT 46 BE
58 LF.CUST.PAST.DUE.DAYS.HOLD 47 BF
59 LF.CUST.LIST.PRICE.PRINT 48 BG
60 LF.CUST.EMAIL.ADDRESSES 49 BH
61 LF.CUST.POS.AUTO.DISC 50 BI
62 LF.CUST.DISABLE.HAZ.MAT.PR 51 BJ
63 LF.CUST.AUTO.SORT.INVOICE 52 BK
64 LF.CUST.PAY.TERM (2% 10TH, etc) 25 BL
65 LF.CUST.BLANKET.PO 53 BM
66 LF.CUST.SHIP.INST 21 BN
67 LF.CUST.COMPETITIVE.MODEL 54 BO
68 LF.CUST.TRANSFER.FORMAT OC1 BP
69 LF.CUST.TRANSFER.SITE OC2 BQ
70 LF.CUST.TRANSFER.LOGIN OC3 BR
71 LF.CUST.TRANSFER.PASSWORD OC4 BS
72 LF.CUST.TRANSFER.PATH OC5 BT
73 LF.CUST.TRANSFER.CONF.FLAG OC6 BU
74 LF.CUST.SHIP.CODE SV1 BV
75 LF.CUST.SHIP.MIN.PRICE SV1 BW
76 LF.CUST.SHIP.IGNORE.EXCL SV1 BX
77 LF.CUST.SHIP.APPROVED.BY SV1 BY
78 LF.CUST.SHIP.DAYS 21 BZ
79 LF.CUST.MIN.PRICE.OR 55 CA
80 LF.CUST.CASH.APPLY.DISPLAY 56 CB
81 LF.CUST.HOLD.POS.NUMBER 57 CC
82 LF.CUST.STORE.NUMBER 58 CD
83 LF.CUST.PO.FORMAT 59 CE
84 LF.CUST.PO.STORE.NUMBER 59 CF
85 LF.CUST.BOL.COMMENT.ID 60 CG
86 LF.CUST.BOL.PREPAID.ID 61 CH
87 LF.CUST.PACK.SLIP.COMMENT PSC CI
88 LF.CUST.COLLECTOR 62 CJ
89 LF.CUST.PREF.DOC.DELIVERY 63 CK
90 LF.CUST.OWNER.OFFICER 64 CL
91 LF.CUST.RESALE.CERT.EXP.DATE 65 CM
92 LF.CUST.LAST.CRED.REVIEW.DATE 66 CN
93 LF.CUST.CREDIT.APP 67 CO
94 LF.CUST.LAST.APP.UPDATE.DATE 67 CP
95 LF.CUST.CREDIT.RATING 68 CQ
96 LF.CUST.PERSONAL.GUARANTEE 69 CR
97 LF.CUST.SECURITY.AGREEMENT 70 CS
98 LF.CUST.CUST.UCC.FILED 71 CT
99 LF.CUST.UCC.EXP.DATE 71 CU
100 LF.CUST.COLLECTION.AGENCY 72 CV
101 LF.CUST.COLLECTION.AGENCY.DATE 72 CW
102 LF.CUST.COLLECTION.PLAN.DATE 72 CX
103 LF.CUST.AR.ASSOCIATE 73 CY
104 LF.CUST.ALLOW.QTY.ORD.MOD.WEB.ORD 74 CZ
105 LF.CUST.TRANSFER.EMAIL.ADDRESSES OC7 DA
106 LF.CUST.INELIG.CODE 75 DB
107 LF.CUST.ST.DISC.MFR 34M DC
108 LF.CUST.ST.DISC.GR.CODE 34M DD
109 LF.CUST.ST.DISC.GR.CODE2 34M DE
110 LF.CUST.ST.DISC.GR.CODE3 34M DF
111 LF.CUST.ST.DISC.GR.CODE4 34M DG
112 LF.CUST.ST.DISC.GR.CODE5 34M DH
113 LF.CUST.ST.DISC.UNIT 34M DI
114 LF.CUST.ST.DISC.PCT 34M DJ
115 LF.CUST.INVOICE.FLAG 76 DK
116 LF.CUST.STATUS.CODE 77 DL
117 LF.CUST.STATUS.CHANGE.DATE 77 DM
118 LF.CUST.STATUS.CHANGE.REASON 77 DN
119 LF.CUST.STATUS.NEW.CUST.NO 77 DO
120 LF.CUST.USER.DEF.LABEL1 UD1 DP
121 LF.CUST.USER.DEF1 UD1 DQ
122 LF.CUST.USER.DEF.LABEL2 UD2 DR
123 LF.CUST.USER.DEF2 UD2 DS
124 LF.CUST.USER.DEF.LABEL3 UD3 DT
125 LF.CUST.USER.DEF3 UD3 DU
126 LF.CUST.USER.DEF.LABEL4 UD4 DV
127 LF.CUST.USER.DEF4 UD4 DW
128 LF.CUST.USER.DEF.LABEL5 UD5 DX
129 LF.CUST.USER.DEF5 UD5 DY
130 LF.CUST.USER.DEF.LABEL6 UD6 DZ
131 LF.CUST.USER.DEF6 UD6 EA
132 LF.CUST.USER.DEF.LABEL7 UD7 EB
133 LF.CUST.USER.DEF7 UD7 EC
134 LF.CUST.USER.DEF.LABEL8 UD8 ED
135 LF.CUST.USER.DEF8 UD8 EE
136 LF.CUST.USER.DEF.LABEL9 UD9 EF
137 LF.CUST.USER.DEF9 UD9 EG
138 LF.CUST.USER.DEF.LABEL10 UD10 EH
139 LF.CUST.USER.DEF10 UD10 EI
140 LF.CUST.USER.DEF.LABEL11 UD11 EJ
141 LF.CUST.USER.DEF11 UD11 EK
142 LF.CUST.USER.DEF.LABEL12 UD12 EL
143 LF.CUST.USER.DEF12 UD12 EM
144 LF.CUST.USER.DEF.LABEL13 UD13 EN
145 LF.CUST.USER.DEF13 UD13 EO
146 LF.CUST.USER.DEF.LABEL14 UD14 EP
147 LF.CUST.USER.DEF14 UD14 EQ
148 LF.CUST.USER.DEF.LABEL15 UD15 ER
149 LF.CUST.USER.DEF15 UD15 ES
150 LF.CUST.CODE 6.1.5.1 ET
151 LF.CUST.SLS.OWNER.NAME 78 EU
152 LF.CUST.POINT.ST.PR 79 EV
153 LF.CUST.SHIP.LATITUDE 80 EW
154 LF.CUST.SHIP.LONGITUDE 81 EX
155 LF.CUST.REFINISH.HOURS DASH EY
156 LF.CUST.REPAIR.ORDERS DASH EZ
157 LF.CUST.DAILY.BOOTH.OP.HOURS DASH FA
158 LF.CUST.WORK.DAYS.IN.WEEK DASH FB
159 LF.CUST.NUM.SPRAY.BOOTHS DASH FC
160 LF.CUST.KPI.PART.NO DASH FD
161 LF.CUST.LAST.APP.VERIFY.DATE 77 FE
162 LF.CUST.SHIP.PREFERRED.SHIPPER SV1 FF
163 LF.CUST.SHIP.FREIGHT.ACCT SV1 FG
164 LF.CUST.SHIP.PREFERRED.SERVICE SV1 FH
165 LF.CUST.SHIP.SV.SHIP.INST SV1 FI
166 LF.CUST.SHIP.SERVICE.LOCK SV1 FJ
167 LF.CUST.CALC.FREIGHT.OPTION 82 FK
168 LF.CUST.CALC.FREIGHT.FACTOR 83 FL
169 LF.CUST.SHIP.SERVICE LOC.LOCK SV - Optional Fields (8/23/2017) FM
170 LF.EDI.STORE.ID 84 (8/23/2017) FN
171 LF.CUST.ACQUIRED.COMPANY.NAME 85 (8/23/2017) FO
172 LF.CUST.ACQUIRED.DATE 86 (8/23/2017) FP
173 LF.CUST.ACQUIRED.OWNER.NAME 87a (8/23/2017) FQ
174 LF.CUST.ACQUIRED.CUST.NO 87b (8/23/2017) FR
175 LF.CUST.THIRD.PARTY.SHIPPING 88 (8/23/2017) FS
176 LF.CUST.PAYMENT.PLAN.AMOUNT 25 after terms (8/23/2017) FT
177 LF.CUST.BOUNTY.ELIGIBLE 89 (8/23/2017) FU
178 LF.CUST.CREDIT.REPORT.BIN 90 (8/23/2017) FV
179 LF.CUST.APPROVED.CREDIT.LIMIT 91 (8/23/2017) FW