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
| AP10.1 | AP10.4 | AP51.1 | AP51.9 | AR11.1 | AR12.1 |
| AR12.2 | AR17.1 | AR209 | AR211 | AR212 | AR213 |
| AR217 | AR23.1 | AR23.3 | AR23.4 | GL286 | GL287 |
| IN20.1 | TX100 | TX130 | TX40.1 |
| 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. |
|
||||||||
| CUD-CUSTOMER Element: Customer | Alpha 9 (Right Justified) Customer number. |
|
||||||||
| 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. |
|
||||||||
| CUD-NAME Element: Customer Name | Alpha 30 (Lower Case) The name or description of the customer. |
|
||||||||
| CUD-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||
| CUD-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||
| CUD-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||
| CUD-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||
| CUD-CITY Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||||||||
| CUD-STATE Element: State | Alpha 2 This field contains the two character state or province code of the address. |
|
||||||||
| CUD-ZIP Element: Zip | Alpha 10 Postal code. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| CUD-CONTACT Element: Contact | Alpha 20 Primary contact name for this customer. |
|
||||||||
| CUD-TITLE Element: Title | Alpha 30 (Lower Case) Title of primary contact name. |
|
||||||||
| CUD-INT-PREFIX Element: International Prefix | Alpha 6 International Prefix for customer's telephone number. |
|
||||||||
| CUD-PHONE-NMBR Element: Phone | Alpha 15 Customer's telephone number. |
|
||||||||
| CUD-PHONE-EXT Element: Phone Ext | Alpha 5 Telephone extension number. |
|
||||||||
| CUD-DUNN-CD Dun & Bradstreet Code | Alpha 3 This field will contain the Dun & Bradstreet rating code for this customer. |
|
||||||||
| CUD-DUNN-DATE Dun & Bradstreet Date | Numeric 8 (yyyymmdd) This field will contain the date that the last Dun & Bradstreet rating code was assigned. |
|
||||||||
| CUD-DUNN-NUMBER Dun & Bradstreet Number | Numeric 9 This is the number that has been assigned by Dun & Bradstreet. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| CUD-OVR-ADDR-FL Element: Override Address | Alpha 1 Override Address Flag. Used by the Lawson Order Entry system for one time customers. |
|
||||||||
| CUD-TAX-ID Element: Tax Id | Alpha 20 This is the Tax ID of the Customer. |
|
||||||||
| 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. |
|||||||||
| 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. |
|||||||||
| 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). |
|
||||||||
| 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) |
|
||||||||
| 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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUDSET1 |
CUST-GROUP CUSTOMER |
|
|||||||||||||||||||
| CUDSET2 |
DUNN-NUMBER CUST-GROUP |
|
| ||||||||||||||||||
| CUDSET4 |
CUST-GROUP SEARCH-NAME CUSTOMER |
|
| ||||||||||||||||||
| CUDSET5 |
ZIP CUST-GROUP CUSTOMER |
|
| ||||||||||||||||||
| CUDSET6 |
PHONE-NMBR CUST-GROUP CUSTOMER |
|
|||||||||||||||||||
| CUDSET8 |
CUST-GROUP CITY STATE SEARCH-NAME CUSTOMER |
|
|||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
|---|---|---|---|---|---|
| Arcustgroup | ARCUSTGRP |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcustomer | ARCUSTOMER |
| |||||||||||||||
| Billto | BILLTO |
| |||||||||||||||
| Dtcustbank | DTCUSTBANK |
| |||||||||||||||
| Ftcustgrp | FTCUSTGRP |
|
All trademarks and registered trademarks are the property of their
respective owners.