Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACSRVCLOC


                             ACSRVCLOC FILE

                       Activity Service Location

REFERENCED BY

BR123     BR151     BR152     BR155     BR156     BR251
BR252     BR51.1    BR52.2    BRPI.1

UPDATED BY

BR16.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ASV-COMPANY            Numeric 4                                 BR16.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

ASV-CUSTOMER           Alpha 9  (Right Justified)                BR16.1
Element: Customer NumbeThis field contains the number that
                       represents a customer.

ASV-SERVICE-LOC        Numeric 4                                 BR16.1
Element: Service Loc

ASV-NAME               Alpha 30  (Lower Case)                    BR16.1
Element: Name          Displays the company description.

ASV-ADDR1              Alpha 30  (Lower Case)                    BR16.1
Element: Address 1     This field contains the first line of
                       address information.

ASV-ADDR2              Alpha 30  (Lower Case)                    BR16.1
Element: Address 1

ASV-ADDR3              Alpha 30  (Lower Case)                    BR16.1
Element: Address 1

ASV-ADDR4              Alpha 30  (Lower Case)                    BR16.1
Element: Address 1

ASV-CITY               Alpha 18  (Lower Case)                    BR16.1
Element: City          This field contains the city of the
                       address.

ASV-STATE              Alpha 2                                   BR16.1
Element: State or ProviThis field contains the two-character
                       state code of the address.

ASV-ZIP                Alpha 10                                  BR16.1
Element: Postal Code   This field contains the postal code of
                       the address.






ASV-COUNTY             Alpha 25  (Lower Case)                    BR16.1
Element: County        The county for the company address.

ASV-COUNTRY-CODE       Alpha 2                                   BR16.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

ASV-REGION             Alpha 2                                   BR16.1
Element: Region Code   The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

ASV-ACTIVE-FLAG        Alpha 1                                   BR16.1
Element: Status        The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

ASV-TAX-EXEMPT-CD      Alpha 1                                   BR16.1
Element: Tax Exempt CodE = Exempt
                       T = Taxable

ASV-TAX-CODE           Alpha 10                                  BR16.1
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


                         ACSRVCLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASVSET1   COMPANY                                                BR123   BR151
          CUSTOMER                                               BR152   BR155
          SERVICE-LOC                                            BR156   BR16.1
                                                                 BR251   BR252
                                                                 BR51.1  BR52.2
                                                                 BRPI.1

                         ACSRVCLOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ASV-COMPANY         -> ACO-COMPANY

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP      -> CUD-CUST-GROUP
                            ASV-CUSTOMER        -> CUD-CUSTOMER

Instctrycd     INSTCTRYCD   Not Required

                            ASV-COUNTRY-CODE    -> INT-COUNTRY-CODE

Instregn       INSTREGN     Not Required

                            ASV-COUNTRY-CODE    -> INR-COUNTRY-CODE
                            ASV-REGION          -> INR-REGION