CUSTDESC

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
AR11.1 AR12.1 AR12.2 AR17.1 AR211 AR217
AR23.1 AR23.3 AR23.4 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 BR49.1 BR51.1
BR51.2 BR52.1 BR52.2 BR521 BR53.1 BR55.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 IC02.1
TX40.1 WH110 WH120 WH21.2 WH224 WH226
AR209 AR212 AR213 GL286 GL287 IN20.1
TX100 TX130


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 AM22.1 AM500 AM51.1 AM551 AM97.1
AP03.3 AP110 AP115 AP125 AP126 AP131
AP150 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 AP271 AP30.2 AP30.4
AP300 AP305 AP510 AP90.1 AP91.1 API1.1
API2.1 API3.1 API4.1 AR00.1 AR09.1 AR10.1
AR13.1 AR13.2 AR210 AR301 AR501 AR550
ARLL.1 CB06.2 CB191 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC140 IC142 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 IC840 MX123 MX500
MA180 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA42.1 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 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
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO223
PO23.1 PO233 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO253 PO254 PO27.2 PO278 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ500 RQIF.1 TX140 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUD-CUST-GROUP
Element: Customer Group
Alpha 5
Customer group. A customer group defines the customer number definition and allows one or more companies to use the same customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-SEARCH-NAME
Element: Search Name
Alpha 30
This is to search for a customer online and also used for sorting purposes on AR reports. If left blank when adding a customer, the characters of the customer name will default.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-NAME
Element: Customer Name
Alpha 30 (Lower Case)
The name or description of the customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX130
TX140
CUD-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR10.1
AR301 AR501
AR550 TX130
TX140
CUD-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
AR09.1 AR10.1
AR301 AR501
AR550 TX130
TX140
CUD-STATE
Element: State
Alpha 2
This field contains the two character state or province code of the address.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-ZIP
Element: Zip
Alpha 10
Postal code.
AR09.1 AR10.1
AR301 AR501
AR550 TX130
TX140
CUD-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-COUNTY
Element: County
Alpha 25 (Lower Case)
This field contains the county of the address, or it can be used for additional information such as an attention name.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-CONTACT
Element: Contact
Alpha 20
Primary contact name for this customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-TITLE
Element: Title
Alpha 30 (Lower Case)
Title of primary contact name.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-INT-PREFIX
Element: International Prefix
Alpha 6
International Prefix for customer's telephone number.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-PHONE-NMBR
Element: Phone
Alpha 15
Customer's telephone number.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-PHONE-EXT
Element: Phone Ext
Alpha 5
Telephone extension number.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-DUNN-CD
Dun & Bradstreet
Code
Alpha 3
This field will contain the Dun & Bradstreet rating code for this customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-DUNN-DATE
Dun & Bradstreet
Date
Numeric 8 (yyyymmdd)
This field will contain the date that the last Dun & Bradstreet rating code was assigned.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-DUNN-NUMBER
Dun & Bradstreet
Number
Numeric 9
This is the number that has been assigned by Dun & Bradstreet.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-HOLD-CODE
Element: Hold Code
Alpha 4
Customer Hold Code. Provided by the Lawson Accounts Receivable System to be used by the Lawson Order Entry or external order processing systems.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-OPEN-ORDS
Element: Open Order Total
Signed 18.2
This is the total open orders in customer group currency for all companies utilizing this customer. It will be updated by an external order processing system via an application program interface program.
ARLL.1 WH20.7
CUD-CURR-BAL
Element: Intl Amt
Signed 18.2
This is the current, non Bill of Exchange balance for this customer, cumulative for all companies utilizing this customer, in customer group currency.
AR12.1 AR12.2
AR13.1 AR13.2
ARLL.1 CB06.2
CB191
CUD-DRAFT-BAL
Bill of Exchange
Balance
Signed 18.2
This is the current Bill of Exchange balance for this customer, cumulative for all companies utilizing this customer, in customer group currency.
AR12.1 AR12.2
AR13.1 AR13.2
ARLL.1 CB06.2
CUD-ORDER-LIM
Element: Order Limit
Signed 15.0
Order Limit in customer group currency for a given customer across all AR companies utilizing this customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-CREDIT-LIM
Element: Credit Limit
Signed 15.0
Maximum amount of credit extended to a customer, in customer group currency, for all AR compaies utilizing this customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-OVR-ADDR-FL
Element: Override Address
Alpha 1
Override Address Flag. Used by the Lawson Order Entry system for one time customers.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-TAX-ID
Element: Tax Id
Alpha 20
This is the Tax ID of the Customer.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-VENDOR-GROUP
Element: Vendor Group
Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies. The vendor group that this customer is related to if the customer is also a vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 AR09.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CUD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code. The vendor number that this customer is related to if the customer is also a vendor.
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP110
AP115 AP125
AP126 AP131
AP150 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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 AR09.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CUD-CURR-DRAFT-BAL
Element: Current BOE Balance
Derived
This 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
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUD-CUST-AUDIT
Element: Cust Audit
Alpha 1
This field indicates if customer changes will be audited. Valid values are: N = No changes audited Y = Changes audited
AR09.1 AR10.1
AR301 AR501
AR550 TX140


CUSTDESC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUDSET1 CUST-GROUP
CUSTOMER
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP10.4 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
CUDSET2 DUNN-NUMBER
CUST-GROUP
KeyChange, Subset
WhereDUNN-NUMBER !=Zeroes
AR09.1 AR10.1
AR301 AR501
AR550 TX140
CUDSET4 CUST-GROUP
SEARCH-NAME
CUSTOMER
KeyChange
AR210 AR301
CUDSET5 ZIP
CUST-GROUP
CUSTOMER
KeyChange
AR209
CUDSET6 PHONE-NMBR
CUST-GROUP
CUSTOMER
KeyChange
CUDSET8 CUST-GROUP
CITY
STATE
SEARCH-NAME
CUSTOMER
KeyChange


CUSTDESC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcustgroup ARCUSTGRP Required
CUD-CUST-GROUP->ACG-CUST-GROUP (ACGSET1)


CUSTDESC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:09:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.