This text file is used in the Load External Customer File (6.1.10) program.
The file is typically prepared in Excel and saved as a tab delimited text file with a .TXT extension.
| Customer File Load Map | 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 |
| 180 | LF.CUST.AFFILIATION | 92 (9/6/2017) | FX |
| 181 | LF.CUST.UPDATE.SHIPPING.LOC.SH | 93 (10/25/2017) | FY |
| 182 | LF.CUST.SHIP.SHIPPER.SERVICE.APPROVAL | SV - Optional Fields (1/2/2018) | FZ |
| 183 | LF.CUST.SHIP.ALLOW.SHIP.VIA | SV - Optional Fields (1/2/2018) | GA |
| 184 | LF.CUST.MIN.SALE.QTY.OR | 94 (10/8/2018) | GB |
| 185 | LF.CUST.PRIMARY.PICK.BIN.ZONE | 95 (10/8/2018) | GC |
| 186 | LF.CUST.RANKING.CODE | 96 (10/8/2018) | GD |
| 187 | LF.CUST.MIN.PRICE.OR.PART.NO | 55 Option P (3/25/2019) | GE |
| 188 | LF.CUST.WEB.GROUP.ID | Display only (4/4/2019) | GF |
| 189 | LF.SHIP.ADDR3 | 4 - MASTER CUST.THREE.LINE.ADDR must be set (4/4/2019) | GG |
| 190 | LF.MAIL.ADDR3 | 7 - MASTER CUST.THREE.LINE.ADDR must be set (4/4/2019) | GH |
| 191 | LF.CUST.VOC.RESTRICTION.EXEMPT | 97 (6/3/2019) | GI |
| 192 | LF.CUST.STATEMENT.EMAIL.ADDRESSES | 98 (8/16/2019) | GJ |
| 193 | LF.CUST.NUMBER.OF.EMPLOYEES | 99 (8/16/2019) | GK |
| 194 | LF.CUST.SHIP.EXCL.SHIPPER.SERVICE.RULE | SV2 (10/19/2019) | GL |
| 195 | LF.CUST.MAX.SALE.QTY.OR | 100 (3/11/2020) | GM |
| 196 | LF.CUST.PREVENT.DATED.BILLING | 101 (7/20/2020) | GN |
| 197 | LF.CUST.CONSOLIDATED.LOCATION | 102 (7/20/2020) | GO |
| 198 | LF.CUST.CONTINGENCY.LOCATION | 103 (7/20/2020) | GP |
| 199 | LF.CUST.CARTON.LABEL.FLAG | 104 (9/18/2020) | GQ |
| 200 | LF.CUST.EDI.CODE | 105 (10/25/2020) | GR |
| 201 | LF.CUST.MAX.SALE.QTY.OR.PART.NO | 100 Option P (11/16/2020) | GS |
| 202 | LF.CUST.USE.CONTINGENCY.LOCATION | 106 (1/29/2021) | GT |
| 203 | LF.CUST.COL.PR.ASSIGNMENT | 107 (8/19/2021) | GU |
| 204 | LF.CUST.ADD.SV.TO.WEB | 108 (9/8/2021) | GV |
| 205 | LF.CUST.PREVENT.DUPLICATE.PO | 109 (10/15/2021) | GW |
| 206 | LF.CUST.SHIP.AS.ID | 110 (11/3/2021) | GX |
| 207 | LF.CUST.MERGE.MULTIPLE.PO | 111 (5/18/2022) | GY |
| 208 | LF.CUST.ST.DISC.CALC.CRADJ | 34 (9/15/2022) | GZ |
| 209 | LF.CUST.PACK.SLIP.PO/td> | 112 (1/17/2023) | HA |