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. A customer master record can be used by one or more company records
provided the customer group value is in common.
REFERENCED BY
AC56.1 AC560 AP10.1 AP10.4 AP51.1 AP51.9
AR00.1 AR100 AR105 AR11.1 AR110 AR12.1
AR12.2 AR120 AR132 AR136 AR140 AR141
AR150 AR155 AR161 AR17.1 AR170 AR191
AR199 AR209 AR210 AR211 AR212 AR213
AR217 AR219 AR220 AR222 AR223 AR227
AR228 AR229 AR23.1 AR23.3 AR23.4 AR230
AR232 AR233 AR235 AR237 AR238 AR239
AR242 AR245 AR25.1 AR25.2 AR250 AR251
AR253 AR255 AR256 AR257 AR258 AR260
AR261 AR264 AR265 AR271 AR274 AR275
AR282 AR285 AR286 AR287 AR290 AR291
AR292 AR293 AR294 AR295 AR296 AR300
AR36.2 AR45.1 AR50.1 AR515 AR53.1 AR70.2
AR72.1 AR74.1 AR75.1 AR90.1 AR95.1 BL04.1
BL10.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 BL81.1
BL82.1 BL85.1 BL85.2 BL90.1 BR00.1 BR00.2
BR02.3 BR10.1 BR10.9 BR11.1 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR155
BR156 BR16.1 BR16.2 BR17.1 BR180 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.1 BR21.2 BR210 BR211 BR216 BR217
BR220 BR251 BR252 BR253 BR400 BR420
BR45.1 BR450 BR46.1 BR46.2 BR46.4 BR51.1
BR51.2 BR52.1 BR52.2 BR521 BR53.1 BR55.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 DT161
DT220 DT270 DT280 DT42.1 DT52.1 DT95.1
GL286 GL287 IC02.1 PW110 PW555 IN20.1
TX100 TX130 TX40.1 WH110 WH120 WH130
WH132 WH190 WH21.2 WH224 WH226 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
UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP03.3
AP110 AP115 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP210 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP300 AP305 AP510
AP90.1 AP91.1 API1.1 API2.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
AR32.1 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 AR38.1 AR38.2 AR38.3 AR39.1
AR39.2 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 AR800 AR82.1 ARLL.1 BL02.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL802 BL820 BL92.1
CB06.2 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 MX123
MX500 MA180 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO223
PO23.1 PO233 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO254 PO27.2 PO278 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.1 PO54.2 PO54.3
PO54.4 POI3.1 POID.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 PW550 RQ10.1 RQ10.2 TX140 WH20.2
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 BL802 PW550
the same customer. TX140
CUD-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
Element: Customer Customer number. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
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 BL802 PW550
customer, the characters of the customer TX140
name will default.
CUD-NAME Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Customer Name The name or description of the AR293 AR301
customer. AR35.1 AR37.2
AR501 AR550
BL02.1 BL246
BL802 PW550
TX130 TX140
CUD-ADDR1 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Addr1 This field contains the first line of AR301 AR501
address information. AR550 BL02.1
BL802 PW550
TX130 TX140
CUD-ADDR2 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Addr1 This field contains the first line of AR301 AR501
address information. AR550 BL02.1
BL802 PW550
TX140
CUD-ADDR3 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Addr1 This field contains the first line of AR301 AR501
address information. AR550 BL02.1
BL802 PW550
TX140
CUD-ADDR4 Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Addr1 This field contains the first line of AR301 AR501
address information. AR550 BL02.1
BL802 PW550
TX140
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
BL802 PW550
TX130 TX140
CUD-STATE Alpha 2 AR09.1 AR10.1
Element: State This field contains the two character AR301 AR501
state or province code of the address. AR550 BL02.1
BL802 PW550
TX140
CUD-ZIP Alpha 10 AR09.1 AR10.1
Element: Zip Postal code. AR301 AR501
AR550 BL02.1
BL802 PW550
TX130 TX140
CUD-COUNTRY Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Country This field contains the country of the AR301 AR501
address, or it can be used for AR550 BL02.1
additional information such as an BL802 PW550
attention name. TX140
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 BL802 PW550
attention name. TX140
CUD-CONTACT Alpha 20 AR09.1 AR10.1
Element: Contact Primary contact name for this customer. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
CUD-TITLE Alpha 30 (Lower Case) AR09.1 AR10.1
Element: Title Title of primary contact name. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
CUD-INT-PREFIX Alpha 6 AR09.1 AR10.1
Element: International International Prefix for customer's AR301 AR501
telephone number. AR550 BL02.1
BL802 PW550
TX140
CUD-PHONE-NMBR Alpha 15 AR09.1 AR10.1
Element: Phone Customer's telephone number. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
CUD-PHONE-EXT Alpha 5 AR09.1 AR10.1
Element: Phone Ext Telephone extension number. AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
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. BL802 PW550
TX140
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. BL802 PW550
TX140
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
BL802 PW550
TX140
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 BL802 PW550
external order processing systems. TX140
CUD-OPEN-ORDS Signed 18.2 AR502 AR560
Element: Open Order TotThis is the total open orders in ARLL.1 BL120
customer group currency for all BL122 BL130
companies utilizing this customer. It BL20.1 BL20.3
will be updated by an external order BL21.2 BL21.5
processing system via an application BL29.1 BL29.2
program interface program. BL520 BL820
BL92.1 WH20.7
CUD-CURR-BAL Signed 18.2 AR115 AR12.1
Element: Intl Amt This is the current, non Bill of AR12.2 AR124
Exchange balance for this customer, AR129 AR13.1
cumulative for all companies utilizing AR13.2 AR130
this customer, in customer group AR131 AR135
currency. AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR505 AR560
AR570 AR575
AR580 AR80.1
AR80.2 AR800
AR82.1 ARLL.1
...
CUD-DRAFT-BAL Signed 18.2 AR115 AR12.1
Bill of Exchange This is the current Bill of Exchange AR12.2 AR129
Balance balance for this customer, cumulative AR13.1 AR13.2
for all companies utilizing this AR130 AR131
customer, in customer group currency. AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR505 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
...
CUD-ORDER-LIM Signed 15.0 AR09.1 AR10.1
Element: Order Limit Order Limit in customer group currency AR301 AR501
for a given customer across all AR AR550 BL02.1
companies utilizing this customer. BL802 PW550
TX140
CUD-CREDIT-LIM Signed 15.0 AR09.1 AR10.1
Element: Credit Limit Maximum amount of credit extended to a AR301 AR501
customer, in customer group currency, AR550 BL02.1
for all AR compaies utilizing this BL802 PW550
customer. TX140
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. BL802 PW550
TX140
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
BL802 PW550
TX140
CUD-VENDOR-GROUP Alpha 4 AC160 AM115
Element: Vendor Group A vendor group represents a group of AM117 AM15.1
vendors that can be shared by one or AM15.2 AM15.3
more companies. The vendor group that AM15.4 AM19.1
this customer is related to if the AM19.2 AM20.1
customer is also a vendor. AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
AR09.1 AR48.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
CUD-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor The vendor's identification code. AM117 AM15.1
The vendor number that this customer is AM15.2 AM15.3
related to if the customer is also a AM15.4 AM19.1
vendor. AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP210 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP300
AP305 AP510
AP90.1 AP91.1
API1.1 API2.1
API3.1 API4.1
AR09.1 AR48.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
CUD-CURR-DRAFT-BAL Derived
Element: Current BOE BaThis is the current Bill of Exchange 0
balance for this customer, cumulative
for all companies utilizing this
customer, in customer group currency.
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). BL802 PW550
TX140
CUD-REGION Alpha 2 AR09.1 AR10.1
Element: Region The region code, if applicable for the AR301 AR501
country. Used by Intrastat. Must be AR550 BL02.1
defined in IN02.1 (Region Maintenance) BL802 PW550
TX140
CUD-CUST-AUDIT Alpha 1 AR09.1 AR10.1
Element: Cust Audit This field indicates if customer AR301 AR501
changes will be audited. Valid values AR550 BL02.1
are: BL802 PW550
TX140
N = No changes audited
Y = Changes audited
CUSTDESC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUDSET1 CUST-GROUP AC160 AC56.1
CUSTOMER AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP10.4
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
...
CUDSET2 DUNN-NUMBER KeyChange, Subset AR09.1 AR10.1
CUST-GROUP Where DUNN-NUMBER != Zeroes AR301 AR501
AR550 BL02.1
BL802 PW550
TX140
CUDSET4 CUST-GROUP KeyChange AR210 AR301
SEARCH-NAME
CUSTOMER
CUDSET5 ZIP KeyChange AR209
CUST-GROUP
CUSTOMER
CUDSET6 PHONE-NMBR KeyChange
CUST-GROUP
CUSTOMER
CUDSET8 CUST-GROUP KeyChange
CITY
STATE
SEARCH-NAME
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
|