CUSTDESC – AR Group Customer

System
Accounts Receivable (AR)
Prefix
CUD
Primary key
CUST-GROUP, CUSTOMER
Fields
37
Updated by
301 programs
Referenced by
87 programs

CUSTDESC is the AR Group Customer table in Lawson Accounts Receivable (prefix CUD). It is indexed by CUST-GROUP, CUSTOMER (CUDSET1); alternate indexes: CUDSET2, CUDSET4, CUDSET5, CUDSET6 and CUDSET8. It is related 1:1 to ARCUSTGRP and 1:M to ARCUSTOMER, BILLTO, DTCUSTBANK and FTCUSTGRP. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 293 more and referenced by AC56.1, AC560, AP10.1, AP10.4, AP51.1, AP51.9, AR00.1, AR11.1 and 79 more. The table has 37 fields, 6 indexes and 5 documented relations.

About CUSTDESC

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.

Fields (37)

Column = COBOL field name without the CUD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CUD-CUST-GROUP PK
CUST_GROUP
Alpha 5Customer 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 PK
CUSTOMER
Alpha 9 (Right Justified)Customer number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-SEARCH-NAME
SEARCH_NAME
Alpha 30This 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
NAME
Alpha 30 (Lower Case)The name or description of the customer.AR09.1, AR10.1, AR301, AR501, AR550, TX130, TX140
CUD-ADDR1
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
ADDR2
Alpha 30 (Lower Case)This field contains the first line of address information.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-ADDR3
ADDR3
Alpha 30 (Lower Case)This field contains the first line of address information.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-ADDR4
ADDR4
Alpha 30 (Lower Case)This field contains the first line of address information.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-CITY
CITY
Alpha 18 (Lower Case)This field contains the city of the address.AR09.1, AR10.1, AR301, AR501, AR550, TX130, TX140
CUD-STATE
STATE
Alpha 2This field contains the two character state or province code of the address.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-ZIP
ZIP
Alpha 10Postal code.AR09.1, AR10.1, AR301, AR501, AR550, TX130, TX140
CUD-COUNTRY
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
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
CONTACT
Alpha 20Primary contact name for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-TITLE
TITLE
Alpha 30 (Lower Case)Title of primary contact name.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-INT-PREFIX
INT_PREFIX
Alpha 6International Prefix for customer's telephone number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-PHONE-NMBR
PHONE_NMBR
Alpha 15Customer's telephone number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-PHONE-EXT
PHONE_EXT
Alpha 5Telephone extension number.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-DUNN-CD
DUNN_CD
Alpha 3This field will contain the Dun & Bradstreet rating code for this customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-DUNN-DATE
DUNN_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
DUNN_NUMBER
Numeric 9This is the number that has been assigned by Dun & Bradstreet.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-HOLD-CODE
HOLD_CODE
Alpha 4Customer 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
OPEN_ORDS
Signed 18.2This 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
CURR_BAL
Signed 18.2This 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
DRAFT_BAL
Signed 18.2This 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
ORDER_LIM
Signed 15.0Order 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
CREDIT_LIM
Signed 15.0Maximum 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
OVR_ADDR_FL
Alpha 1Override Address Flag. Used by the Lawson Order Entry system for one time customers.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-TAX-ID
TAX_ID
Alpha 20This is the Tax ID of the Customer.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-VENDOR-GROUP
VENDOR_GROUP
Alpha 4A 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 +52 more (list truncated in source)
CUD-VENDOR
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 +52 more (list truncated in source)
CUD-CURR-DRAFT-BAL
CURR_DRAFT_BAL
DerivedThis 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
COUNTRY_CODE
Alpha 2The 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
REGION
Alpha 2The 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
CUST_AUDIT
Alpha 1This 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
CUD-LEGAL-NAME
LEGAL_NAME
Alpha 80 (Lower Case)The legal name for the customer that contain city and county information on it.AR09.1, AR10.1, AR301, AR501, AR550, TX140
CUD-CHK-DIG-TYPE
CHK_DIG_TYPE
Alpha 10AR09.1, AR10.1, AR301, AR501, AR550, TX140

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CUDSET1CUST-GROUP, CUSTOMERPrimaryAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
CUDSET2DUNN-NUMBER, CUST-GROUPKeyChange, SubsetWhere DUNN-NUMBER != ZeroesAR09.1, AR10.1, AR301, AR501, AR550, TX140
CUDSET4CUST-GROUP, SEARCH-NAME, CUSTOMERKeyChangeAR210, AR301
CUDSET5ZIP, CUST-GROUP, CUSTOMERKeyChangeAR209
CUDSET6PHONE-NMBR, CUST-GROUP, CUSTOMERKeyChange
CUDSET8CUST-GROUP, CITY, STATE, SEARCH-NAME, CUSTOMERKeyChange

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArcustgroupARCUSTGRPRequiredCUD-CUST-GROUPACG-CUST-GROUP (ACGSET1)

One to many (4) — child tables

RelationTableRulesConditionField map
ArcustomerARCUSTOMERCUD-CUSTOMERACM-CUSTOMER, ACM-COMPANY
BilltoBILLTOCUD-CUST-GROUPABS-CUST-GROUP, CUD-CUSTOMERABS-CUSTOMER, ABS-BILL-TO
DtcustbankDTCUSTBANKCUD-CUST-GROUPDTB-CUST-GROUP, ZeroesDTB-COMPANY, CUD-CUSTOMERDTB-CUSTOMER, DTB-BANK-ENTITY, DTB-BANK-ACCT-NBR
FtcustgrpFTCUSTGRPCUD-CUST-GROUPFTG-CUST-GROUP, ZeroesFTG-COMPANY, CUD-CUSTOMERFTG-CR-CUSTOMER, FTG-CUSTOMER

Programs

Updated by (301)

Referenced by (87)