CUSTDESC FILE
AR Group Customer
AR Group Customer
REFERENCED BY
AC115 AC15.2 AC450 AP90.9 AR00.1 AR10.1
AR100 AR105 AR11.1 AR110 AR12.1 AR12.2
AR132 AR136 AR140 AR141 AR150 AR155
AR161 AR17.1 AR17.2 AR191 AR199 AR209
AR210 AR211 AR212 AR213 AR217 AR220
AR222 AR227 AR228 AR230 AR232 AR233
AR235 AR242 AR245 AR25.1 AR25.2 AR250
AR251 AR253 AR255 AR256 AR260 AR261
AR271 AR274 AR275 AR282 AR286 AR287
AR290 AR291 AR292 AR294 AR295 AR300
AR36.2 AR45.1 AR50.1 AR53.1 AR70.2 AR72.1
AR73.1 AR74.1 AR75.1 AR80.1 AR80.2 AR90.1
AR95.1 BL04.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL204 BL21.2
BL21.5 BL220 BL231 BL246 BL29.1 BL29.2
BL290 BL291 BL31.1 BL31.2 BL31.3 BL31.5
BL31.7 BL32.3 BL32.4 BL33.1 BL331 BL34.1
BL46.1 BL46.2 BL520 BL546 BL80.1 BL80.3
BL802 BL81.1 BL820 BL85.1 BL85.2 BL90.1
BL902 BL940 CB06.2 DT161 DT220 DT270
DT280 DT42.1 DT52.1 DT95.1 GL286 GL287
IN20.1 OE112 OE130 OE230 OE254 OE260
OE270 OE271 OE272 OE284 OE285 OE286
OE290 OE291 OE292 OE293 OE294 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE330 OE53.1 OE54.1 OE60.1 OE80.1
OE80.2 OE81.1 OE81.2 OE830 OE85.1 OE90.1
OE90.2 OE950 PBIP.1 SA03.1 SA100 SA252
SA254 SA256 SA261 SA271 SA281 SA291
SA300 SA80.2 SA90.2 SAA2.1 TX130 TX140
TX225 TX40.1 WH110 WH120 WH21.2
UPDATED BY
AP10.1 AR09.1 AR115 AR124 AR13.1 AR13.2
AR130 AR131 AR135 AR137 AR180 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR28.1
AR29.1 AR29.3 AR30.1 AR30.2 AR30.3 AR30.4
AR30.8 AR301 AR31.6 AR35.1 AR35.2 AR37.1
AR37.2 AR37.3 AR37.4 AR37.5 AR37.6 AR37.7
AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3
AR501 AR502 AR505 AR550 AR560 AR570
AR575 AR580 AR82.1 AR977 BL02.1 BL92.1
CB191 DT150 DT155 DT160 DT165 DT166
DT180 DT181 DT30.1 DT30.2 DT40.1 DT45.1
DT520 DT60.1 DT60.2 DT70.1 DT70.3 DT80.1
DT85.1 DT85.2 DT90.1 DT92.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113
OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE510 OE810 OE920
WH130 WH132 WH190 WH20.7 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUD-CUST-GROUP Alpha 5 AR09.1 AR501
Customer Group Customer group. A customer group AR550 AR977
defines the customer number definition BL02.1
and allows one or more companies to use
the same customer.
CUD-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR501
Customer Number Customer number. AR550 AR977
BL02.1
CUD-SEARCH-NAME Alpha 30 AR09.1 AR501
Search Name This is to search for a customer online AR550 AR977
and also used for sorting purposes on AR BL02.1
reports. If left blank when adding a
customer, the characters of the customer
name will default.
CUD-NAME Alpha 30 (Lower Case) AR09.1 AR35.1
Customer Name The name/description of the customer. AR37.2 AR501
AR550 AR977
BL02.1 BL246
OE254 TX130
CUD-ADDR1 Alpha 30 (Lower Case) AR09.1 AR501
Customer Address This field contains the first line of AR550 AR977
Line 1 address information. BL02.1 TX130
CUD-ADDR2 Alpha 30 (Lower Case) AR09.1 AR501
Customer Address This field contains the second line of AR550 AR977
Line 2 address information. BL02.1
CUD-ADDR3 Alpha 30 (Lower Case) AR09.1 AR501
Customer Address This field contains the third line of AR550 AR977
Line 3 address information. BL02.1
CUD-ADDR4 Alpha 30 (Lower Case) AR09.1 AR501
Customer Address This field contains the fourth line of AR550 AR977
Line 4 address information. BL02.1
CUD-CITY Alpha 18 (Lower Case) AR09.1 AR501
Customer City This field contains the city of the AR550 AR977
address. BL02.1 TX130
CUD-STATE Alpha 2 AR09.1 AR501
Customer State This field contains the two character AR550 AR977
state or province code of the address. BL02.1
CUD-ZIP Alpha 10 AR09.1 AR501
Customer Postal Code Postal code. AR550 AR977
BL02.1 TX130
CUD-COUNTRY Alpha 30 (Lower Case) AR09.1 AR501
Customer Country This field contains the country of the AR550 AR977
address, or it can be used for BL02.1
additional information such as an
attention name.
CUD-COUNTY Alpha 25 AR501 AR550
Customer County For use in a future release.
CUD-CONTACT Alpha 20 AR09.1 AR501
Customer Contact Primary contact name for this customer. AR550 AR977
BL02.1
CUD-TITLE Alpha 30 (Lower Case) AR09.1 AR501
Contact Title Title of primary contact name. AR550 AR977
BL02.1
CUD-INT-PREFIX Alpha 6 AR09.1 AR501
International Prefix International Prefix for customer's AR550 AR977
telephone number. BL02.1
CUD-PHONE-NMBR Alpha 15 AR09.1 AR501
Telephone Number Customer's telephone number. AR550 AR977
BL02.1
CUD-PHONE-EXT Alpha 5 AR09.1 AR501
Telephone Extension Telephone extension number. AR550 AR977
BL02.1
CUD-DUNN-CD Alpha 3 AR09.1 AR501
Dun & Bradstreet This field will contain the Dun & AR550 AR977
Code Bradstreet rating code for this BL02.1
customer.
CUD-DUNN-DATE Numeric 8 (yyyymmdd) AR09.1 AR501
Dun & Bradstreet This field will contain the date that AR550 AR977
Date the last Dun & Bradstreet rating code BL02.1
was assigned.
CUD-DUNN-NUMBER Numeric 9 AR09.1 AR501
Dun & Bradstreet This is the number that has been AR550 AR977
Number assigned by Dun & Bradstreet. BL02.1
CUD-HOLD-CODE Alpha 4 AR09.1 AR501
Hold Code Customer Hold Code. Provided by the AR550 AR977
Lawson Accounts Receivable System to be BL02.1
used by the Lawson Order Entry or
external order processing systems.
CUD-OPEN-ORDS Signed 15.2 AR501 AR502
Open Order Total This is the total open orders for all AR560 AR977
companies with this customer. It will be BL92.1 OE10.1
updated by an external order processing OE10.2 OE10.3
system via an application program OE10.4 OE10.5
interface program. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
CUD-CURR-BAL Signed 15.2 AR115 AR124
Total Current This is the current non bill of AR13.1 AR13.2
Balance exchange balance for this customer; AR130 AR131
cumulative for all companies. AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR28.1
AR29.1 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR505 AR560
AR570 AR575
AR580 AR82.1
AR977 CB191
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
...
CUD-DRAFT-BAL Signed 15.2 AR115 AR13.1
Bill of Exchange This is the current bill of exchange AR13.2 AR130
Balance balance for this customer; cumulative AR131 AR135
for all companies. AR137 AR180
AR190 AR28.1
AR29.1 AR29.3
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR502
AR505 AR560
AR82.1 AR977
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
DT70.1 DT70.3
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
CUD-ORDER-LIM Signed 15.0 AR09.1 AR501
Order Limit Order Limit for a given customer across AR550 AR977
all AR companies. BL02.1
CUD-CREDIT-LIM Signed 15.0 AR09.1 AR501
Credit Limit Maximum amount of credit extended to a AR550 AR977
customer. BL02.1
CUD-OVR-ADDR-FL Alpha 1 AR09.1 AR501
Override Address Override Address Flag. Used by the AR550 AR977
Lawson Order Entry system for one time BL02.1
customers.
CUD-TAX-ID Alpha 20 AR09.1 AR501
Tax ID This is the Tax ID of the Customer. AR550 AR977
BL02.1
CUD-VENDOR-GROUP Alpha 4 AP10.1 AR09.1
Vendor Group A vendor group represents a group of AR977
vendors that can be shared by one or
more companies.
CUD-VENDOR Alpha 9 AP10.1 AR09.1
Vendor ID The vendor's identification code. AR977
CUD-CURR-DRAFT-BAL Derived
Current BOE Balance This is the balance for this customer;
cumulative of all companies.
CUD-COUNTRY-CODE Alpha 2 AR09.1 AR501
Customer Country The country code. Required for VAT and AR550
Code intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CUD-REGION Alpha 2 AR09.1 AR501
Customer Region The region code, if applicable for the AR550
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
CUSTDESC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUDSET1 CUST-GROUP This is the primary path used to access AC115 AC15.2
CUSTOMER customer description records. AC450 AP10.1
AP10.4 AP90.9
AR00.1 AR09.1
AR09.4 AR09.5
AR09.7 AR09.8
AR10.1 AR100
AR105 AR11.1
AR110 AR115
AR12.1 AR12.2
AR124 AR13.1
AR13.2 AR130
AR131 AR132
AR135 AR136
AR137 AR140
...
CUDSET2 DUNN-NUMBER This path is used to access customer AR09.1 AR501
CUST-GROUP description records in Dun number order. AR550 BL02.1
KeyChange, Subset
Where DUNN-NUMBER != Zeroes
CUDSET4 CUST-GROUP This path is used to access customer AR210 AR301
SEARCH-NAME description records in search name
CUSTOMER order.
KeyChange
CUDSET5 ZIP This path is used to access customer AR209
CUST-GROUP description records in postal code
CUSTOMER order.
KeyChange
CUDSET6 PHONE-NMBR This path is used to access customer
CUST-GROUP description records in telephone number
CUSTOMER order.
KeyChange
CUDSET8 CUST-GROUP This path is used to access customer
CITY description records in city, state and
STATE search name order.
SEARCH-NAME KeyChange
CUSTOMER
CUSTDESC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustgroup ARCUSTGRP Required
CUD-CUST-GROUP -> ACG-CUST-GROUP (ACGSET1)
CUSTDESC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustomer ARCUSTOMER
CUD-CUSTOMER -> ACM-CUSTOMER
ACM-COMPANY
Billto BILLTO
CUD-CUST-GROUP -> ABS-CUST-GROUP
CUD-CUSTOMER -> ABS-CUSTOMER
ABS-BILL-TO
Dtcustbank DTCUSTBANK
CUD-CUST-GROUP -> DTB-CUST-GROUP
CUD-CUSTOMER -> DTB-CUSTOMER
DTB-BANK-ENTITY
DTB-BANK-ACCT-NBR
Ftcustgrp FTCUSTGRP
CUD-CUST-GROUP -> FTG-CUST-GROUP
CUD-CUSTOMER -> FTG-CR-CUSTOMER
FTG-CUSTOMER
|