Lawson Insight Technical Documentation |
|
CUSTDESC
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
AP10.1 AP10.4 AP125 AP126 AP131 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP51.1 AP51.9
AP510 AP90.9 AR00.1 AR100 AR105 AR11.1
AR110 AR12.1 AR12.2 AR132 AR136 AR140
AR141 AR150 AR155 AR161 AR17.1 AR170
AR191 AR199 AR209 AR210 AR211 AR212
AR213 AR217 AR219 AR220 AR222 AR227
AR228 AR23.1 AR23.3 AR23.4 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 AR515
AR53.1 AR70.2 AR72.1 AR74.1 AR75.1 AR90.1
AR95.1 BL04.1 BL121 BL123 BL125 BL202
BL204 BL217 BL220 BL231 BL232 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 BL530 BL546 BL80.1 BL80.3
BL802 BL81.1 BL82.1 BL85.1 BL85.2 BL90.1
BR00.1 BR00.2 BR02.3 BR10.1 BR11.1 BR120
BR121 BR122 BR140 BR16.1 BR17.1 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.1 BR21.2 BR210 BR211 BR216 BR217
BR220 BR400 BR420 BR45.1 BR450 BR46.1
BR46.2 BR46.4 BR521 BRIP.1 CB06.2 DT161
DT220 DT270 DT280 DT42.1 DT52.1 DT95.1
GL286 GL287 IC02.1 IC28.1 IC531 MA180
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 OE112 OE116 OE130 OE16.1
OE230 OE254 OE260 OE270 OE271 OE272
OE280 OE284 OE285 OE286 OE290 OE291
OE292 OE293 OE294 OE330 OE53.1 OE54.1
OE60.1 OE80.1 OE80.2 OE81.1 OE81.2 OE85.1
OE85.3 OE86.1 OE90.1 OE90.2 PBIP.1 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 PR197 RQ10.1 RQ10.2 SA03.1
SA100 SA252 SA254 SA256 SA261 SA271
SA281 SA291 SA300 SA80.2 SA90.2 IN20.1
TX100 TX130 TX140 TX40.1 WH110 WH120
WH130 WH132 WH190 WH21.2 WH224 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 WO30.1
UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 API3.1 API4.1 AR09.1 AR10.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.8 AR301 AR31.6 AR33.1
AR33.3 AR33.6 AR34.1 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 AR80.1 AR80.2
AR82.1 ARLL.1 BL02.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 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 IC840 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 OE111 OE113 OE114
OE129 OE13.2 OE13.3 OE13.5 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE810 OE830 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 UK47.1
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUD-CUST-GROUP Alpha 5 AR09.1 AR10.1
Element: Customer GroupCustomer group. A customer group AR301 AR501
defines the customer number definition AR550 BL02.1
and allows one or more companies to use
the same customer.
CUD-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer NumbeCustomer number. AR301 AR501
AR550 BL02.1
CUD-SEARCH-NAME Alpha 30 AR09.1 AR10.1
Element: Search Name This is to search for a customer online AR301 AR501
and also used for sorting purposes on AR AR550 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 AR10.1
Element: Customer Name The name/description of the customer. AR293 AR301
AR35.1 AR37.2
AR501 AR550
BL02.1 BL246
OE254 TX130
CUD-ADDR1 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Address 1 This field contains the first line of AR301 AR501
address information. AR550 BL02.1
TX130
CUD-ADDR2 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Address 1 This field contains the second line of AR301 AR501
address information. AR550 BL02.1
CUD-ADDR3 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Address 1 This field contains the third line of AR301 AR501
address information. AR550 BL02.1
CUD-ADDR4 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Address 1 This field contains the fourth line of AR301 AR501
address information. AR550 BL02.1
CUD-CITY Alpha 18 (Lower Case) AR09.1 AR10.1
Element: City This field contains the city of the AR301 AR501
address. AR550 BL02.1
TX130
CUD-STATE Alpha 2 AR09.1 AR10.1
Element: State or ProviThis field contains the two character AR301 AR501
state or province code of the address. AR550 BL02.1
CUD-ZIP Alpha 10 AR09.1 AR10.1
Element: Postal Code Postal code. AR301 AR501
AR550 BL02.1
TX130
CUD-COUNTRY Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Country or OthThis field contains the country of the AR301 AR501
address, or it can be used for AR550 BL02.1
additional information such as an
attention name.
CUD-COUNTY Alpha 25 (Lower Case) AR09.1 AR10.1
Element: County This field contains the county of the AR301 AR501
address, or it can be used for AR550 BL02.1
additional information such as an
attention name.
CUD-CONTACT Alpha 20 AR09.1 AR10.1
Element: Primary ContacPrimary contact name for this customer. AR301 AR501
AR550 BL02.1
CUD-TITLE Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Title Title of primary contact name. AR301 AR501
AR550 BL02.1
CUD-INT-PREFIX Alpha 6 AR09.1 AR10.1
Element: International International Prefix for customer's AR301 AR501
telephone number. AR550 BL02.1
CUD-PHONE-NMBR Alpha 15 AR09.1 AR10.1
Element: Telephone NumbCustomer's telephone number. AR301 AR501
AR550 BL02.1
CUD-PHONE-EXT Alpha 5 AR09.1 AR10.1
Element: Telephone ExteTelephone extension number. AR301 AR501
AR550 BL02.1
CUD-DUNN-CD Alpha 3 AR09.1 AR10.1
Dun & Bradstreet This field will contain the Dun & AR301 AR501
Code Bradstreet rating code for this AR550 BL02.1
customer.
CUD-DUNN-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Dun & Bradstreet This field will contain the date that AR301 AR501
Date the last Dun & Bradstreet rating code AR550 BL02.1
was assigned.
CUD-DUNN-NUMBER Numeric 9 AR09.1 AR10.1
Dun & Bradstreet This is the number that has been AR301 AR501
Number assigned by Dun & Bradstreet. AR550 BL02.1
CUD-HOLD-CODE Alpha 4 AR09.1 AR10.1
Element: Hold Code Customer Hold Code. Provided by the AR301 AR501
Lawson Accounts Receivable System to be AR550 BL02.1
used by the Lawson Order Entry or
external order processing systems.
CUD-OPEN-ORDS Signed 18.2 AR502 AR560
Element: Open Order TotThis is the total open orders for all BL120 BL122
companies with this customer. It will be BL130 BL20.1
updated by an external order processing BL20.3 BL21.2
system via an application program BL21.5 BL29.1
interface program. BL29.2 BL520
BL820 BL92.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 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CUD-CURR-BAL Signed 18.2 AR115 AR124
Element: Intl Amt 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.8 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
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
AR80.1 AR80.2
AR82.1 ARLL.1
CB191 DT150
DT155 DT160
DT165 DT166
DT180 DT181
...
CUD-DRAFT-BAL Signed 18.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.8 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
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 AR80.1
AR80.2 AR82.1
ARLL.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
...
CUD-ORDER-LIM Signed 15.0 AR09.1 AR10.1
Element: Order Limit Order Limit for a given customer across AR301 AR501
all AR companies. AR550 BL02.1
CUD-CREDIT-LIM Signed 15.0 AR09.1 AR10.1
Element: Credit Limit Maximum amount of credit extended to a AR301 AR501
customer. AR550 BL02.1
CUD-OVR-ADDR-FL Alpha 1 AR09.1 AR10.1
Element: Override AddreOverride Address Flag. Used by the AR301 AR501
Lawson Order Entry system for one time AR550 BL02.1
customers.
CUD-TAX-ID Alpha 20 AR09.1 AR10.1
Element: Tax ID This is the Tax ID of the Customer. AR301 AR501
AR550 BL02.1
CUD-VENDOR-GROUP Alpha 4 AM115 AM117
Element: Vendor Group A vendor group represents a group of AM15.1 AM15.2
vendors that can be shared by one or AM15.3 AM15.4
more companies. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
API3.1 API4.1
AR09.1 AR48.4
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
CUD-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Vendor ID The vendor's identification code. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
API3.1 API4.1
AR09.1 AR48.4
IC840 PR05.1
PR05.3 PR226
PR247 PR26.1
PR47.1 UK47.1
CUD-CURR-DRAFT-BAL Derived
Element: Current BOE BaThis is the balance for this customer;
cumulative of all companies.
CUD-COUNTRY-CODE Alpha 2 AR09.1 AR10.1
Element: Country Code The country code. Required for VAT and AR301 AR501
intrastat reporting. Must be defined in AR550 BL02.1
IN01.1 (Country Maintenance).
CUD-REGION Alpha 2 AR09.1 AR10.1
Element: Region Code The region code, if applicable for the AR301 AR501
country. Used by Intrastat. Must be AR550 BL02.1
defined in IN02.1 (Region Maintenance)
CUD-CUST-AUDIT Alpha 1 AR09.1 AR10.1
Element: Cust Audit AR301 AR501
AR550 BL02.1
CUSTDESC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUDSET1 CUST-GROUP This is the primary path used to access AM115 AM117
CUSTOMER customer description records. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.4
AP125 AP126
AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP51.1 AP51.9
AP510 AP90.9
API3.1 API4.1
...
CUDSET2 DUNN-NUMBER This path is used to access customer AR09.1 AR10.1
CUST-GROUP description records in Dun number order. AR301 AR501
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
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
|