 |
Lawson Insight Technical Documentation |
|
CUSTDESC FILE
AR Group Customer
The AR Group Customer file contains customer master records. These records
contain company independent information. Customer number, name, address and
total open balance are some examples of company independent information stored
here.
REFERENCED BY
AC551 AP10.1 AP10.4 AP90.9 AR00.1 AR100
AR105 AR11.1 AR110 AR132 AR136 AR140
AR141 AR150 AR155 AR161 AR17.1 AR191
AR199 AR209 AR210 AR211 AR212 AR213
AR217 AR219 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
AR293 AR294 AR295 AR300 AR36.2 AR45.1
AR50.1 AR53.1 AR70.2 AR72.1 AR74.1 AR75.1
AR80.1 AR80.2 AR90.1 AR95.1 BL04.1 BL121
BL123 BL125 BL202 BL204 BL217 BL220
BL231 BL246 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 BL546 BL80.1
BL80.3 BL802 BL81.1 BL82.1 BL85.1 BL85.2
BL90.1 BR10.1 BR11.1 BR120 BR121 BR21.1
BR210 BR211 BR220 BR420 BR450 BRIP.1
CB06.2 DT161 DT220 DT270 DT280 DT42.1
DT52.1 DT95.1 GL286 GL287 IC02.1 PR197
IN20.1 TX100 TX130 TX140 TX40.1 WH110
WH120 WH130 WH21.2 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4
UPDATED BY
API3.1 API4.1 AR115 AR124 AR129 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 AR48.3 AR48.4 AR501 AR502 AR505
AR550 AR560 AR570 AR575 AR580 AR82.1
BL02.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUD-CUST-GROUP Alpha 5 AR501 AR550
Customer Group Customer group. A customer group BL02.1
defines the customer number definition
and allows one or more companies to use
the same customer.
CUD-CUSTOMER Alpha 9 (Right Justified) AR501 AR550
Customer Number Customer number. BL02.1
CUD-SEARCH-NAME Alpha 30 AR501 AR550
Search Name This is to search for a customer online BL02.1
and also used for sorting purposes on AR
reports. If left blank when adding a
customer, the characters of the customer
name will default.
CUD-NAME Alpha 30 (Lower Case) AR293 AR35.1
Customer Name The name/description of the customer. AR37.2 AR501
AR550 BL02.1
BL246 TX130
CUD-ADDR1 Alpha 30 (Lower Case) AR501 AR550
Address 1 This field contains the first line of BL02.1 TX130
address information.
CUD-ADDR2 Alpha 30 (Lower Case) AR501 AR550
Address 2 This field contains the second line of BL02.1
address information.
CUD-ADDR3 Alpha 30 (Lower Case) AR501 AR550
Address 3 This field contains the third line of BL02.1
address information.
CUD-ADDR4 Alpha 30 (Lower Case) AR501 AR550
Address 4 This field contains the fourth line of BL02.1
address information.
CUD-CITY Alpha 18 (Lower Case) AR501 AR550
City This field contains the city of the BL02.1 TX130
address.
CUD-STATE Alpha 2 AR501 AR550
State or Province This field contains the two character BL02.1
state or province code of the address.
CUD-ZIP Alpha 10 AR501 AR550
Postal Code Postal code. BL02.1 TX130
CUD-COUNTRY Alpha 30 (Lower Case) AR501 AR550
Country or Other This field contains the country of the BL02.1
address, or it can be used for
additional information such as an
attention name.
CUD-COUNTY Alpha 25 (Lower Case) AR501 AR550
County This field contains the county of the BL02.1
address, or it can be used for
additional information such as an
attention name.
CUD-CONTACT Alpha 20 AR501 AR550
Primary Contact Primary contact name for this customer. BL02.1
CUD-TITLE Alpha 30 (Lower Case) AR501 AR550
Title Title of primary contact name. BL02.1
CUD-INT-PREFIX Alpha 6 AR501 AR550
International Prefix International Prefix for customer's BL02.1
telephone number.
CUD-PHONE-NMBR Alpha 15 AR501 AR550
Telephone Number Customer's telephone number. BL02.1
CUD-PHONE-EXT Alpha 5 AR501 AR550
Telephone Extension Telephone extension number. BL02.1
CUD-DUNN-CD Alpha 3 AR501 AR550
Dun & Bradstreet This field will contain the Dun & BL02.1
Code Bradstreet rating code for this
customer.
CUD-DUNN-DATE Numeric 8 (yyyymmdd) AR501 AR550
Dun & Bradstreet This field will contain the date that BL02.1
Date the last Dun & Bradstreet rating code
was assigned.
CUD-DUNN-NUMBER Numeric 9 AR501 AR550
Dun & Bradstreet This is the number that has been BL02.1
Number assigned by Dun & Bradstreet.
CUD-HOLD-CODE Alpha 4 AR501 AR550
Hold Code Customer Hold Code. Provided by the BL02.1
Lawson Accounts Receivable System to be
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
companies with this customer. It will be
updated by an external order processing
system via an application program
interface program.
CUD-CURR-BAL Signed 15.2 AR115 AR124
Current Balance This is the current non bill of AR129 AR13.1
exchange balance for this customer; AR13.2 AR130
cumulative for all companies. 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
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
AR48.3 AR502
AR505 AR560
AR570 AR575
AR580 AR82.1
CB191 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
...
CUD-DRAFT-BAL Signed 15.2 AR115 AR129
Bill of Exchange This is the current bill of exchange AR13.1 AR13.2
Balance balance for this customer; cumulative AR130 AR131
for all companies. AR135 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
AR48.3 AR502
AR505 AR560
AR82.1 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 AR501 AR550
Order Limit Order Limit for a given customer across BL02.1
all AR companies.
CUD-CREDIT-LIM Signed 15.0 AR501 AR550
Credit Limit Maximum amount of credit extended to a BL02.1
customer.
CUD-OVR-ADDR-FL Alpha 1 AR501 AR550
Override Address Override Address Flag. Used by the BL02.1
Lawson Order Entry system for one time
customers.
CUD-TAX-ID Alpha 20 AR501 AR550
Tax ID This is the Tax ID of the Customer. BL02.1
CUD-VENDOR-GROUP Alpha 4 API3.1 API4.1
Vendor Group A vendor group represents a group of AR48.4
vendors that can be shared by one or
more companies.
CUD-VENDOR Alpha 9 (Right Justified) API3.1 API4.1
Vendor ID The vendor's identification code. AR48.4
CUD-CURR-DRAFT-BAL Derived
Current BOE Balance This is the balance for this customer;
cumulative of all companies.
CUD-COUNTRY-CODE Alpha 2 AR501 AR550
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CUD-REGION Alpha 2 AR501 AR550
Region Code The region code, if applicable for the
country. Used 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 AC551 AP10.1
CUSTOMER customer description records. AP10.4 AP90.9
API3.1 API4.1
AR00.1 AR100
AR105 AR11.1
AR110 AR115
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR132 AR135
AR136 AR137
AR140 AR141
AR150 AR155
AR161 AR17.1
AR180 AR190
...
CUDSET2 DUNN-NUMBER This path is used to access customer AR501 AR550
CUST-GROUP description records in Dun number order. 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
Zeroes -> DTB-COMPANY
CUD-CUSTOMER -> DTB-CUSTOMER
DTB-BANK-ENTITY
DTB-BANK-ACCT-NBR
Ftcustgrp FTCUSTGRP
CUD-CUST-GROUP -> FTG-CUST-GROUP
Zeroes -> FTG-COMPANY
CUD-CUSTOMER -> FTG-CR-CUSTOMER
FTG-CUSTOMER
|