Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCONTACT


                             APCONTACT FILE

REFERENCED BY

AP13.1    AP210     AP290     PO20.1    POCP.1    APCP.1

UPDATED BY

AP10.1    AP10.2    AP14.1    AP300     AP510     AM115
AM117     AM15.1    AM15.2    AM15.3    AM15.4    AM20.1
AM20.3    AM21.1    AM21.3    AM500     AM51.1    AM551
AM97.1    API3.1    API4.1    IC840     PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    UK47.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VCT-VENDOR-GROUP       Alpha 4                                   AP14.1  AP510
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.

VCT-VENDOR             Alpha 9  (Right Justified)                AP14.1  AP510
Element: Vendor ID     The vendor's identification code.



VCT-LOCATION-CODE      Alpha 4                                   AP14.1  AP510
Element: Location Code A user-defined code that represents an
                       alternate purchasing or remittance
                       location for the vendor.

VCT-RESP-CODE          Alpha 5                                   AP14.1  AP510
Element: Resp Code     User defined field for label assignment
                       to contacts.

VCT-CONTACT-LVL        Numeric 3                                 AP14.1  AP510
Element: Contact Lvl   System generated assignment that can be
                       over-ridden at input.  To distinguish
                       and prioritize contacts.

VCT-NAME               Alpha 30  (Lower Case)                    AP10.1  AP10.2
Element: Name          Displays the company description.         AP14.1

VCT-INT-PREFIX         Alpha 6                                   AP10.1  AP10.2
Telephone Country                                                AP14.1  AP510
Code

VCT-PHONE-NMBR         Alpha 15                                  AP10.1  AP10.2
Element: Telephone Number                                        AP14.1  AP510

VCT-PHONE-EXT          Alpha 5                                   AP10.1  AP10.2
Element: Telephone ExteThis field contains the telephone         AP14.1  AP510
                       extension number.

VCT-MBL-INT-PREFIX     Alpha 6                                   AP10.1  AP10.2
Element: Mbl Int PrefixThis field contains the country code of   AP14.1  AP510
                       the mobile phone number.

VCT-MOBILE-NUM         Alpha 15                                  AP10.1  AP10.2
Element: Mobile Num    This field contains the mobile phone      AP14.1  AP510
                       number.

VCT-MOBILE-EXT         Alpha 5                                   AP10.1  AP10.2
Element: Mobile Ext    This field contains the mobile phone      AP14.1  AP510
                       extension number.

VCT-FAX-PREFIX         Alpha 6                                   AP10.1  AP10.2
Telephone Country      The fax number prefix.                    AP14.1  AP510
Code

VCT-FAX-NMBR           Alpha 15                                  AP10.1  AP10.2
Element: Telephone Number                                        AP14.1  AP510

VCT-FAX-EXT            Alpha 5                                   AP10.1  AP10.2
Element: Telephone ExteThis field contains the fax number        AP14.1  AP510
                       extension.


VCT-E-MAIL-ADDRESS     Alpha 60  (Lower Case)                    AP10.1  AP10.2
Element: Email Address                                           AP14.1  AP510

                         APCONTACT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VCTSET1   VENDOR-GROUP                                           AM115   AM117
          VENDOR                                                 AM15.1  AM15.2
          LOCATION-CODE                                          AM15.3  AM15.4
          RESP-CODE                                              AM20.1  AM20.3
          CONTACT-LVL                                            AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP10.1  AP10.2
                                                                 AP13.1  AP14.1
                                                                 AP14.2  AP210
                                                                 AP290   AP300
                                                                 AP510   API3.1
                                                                 API4.1  IC840
                                                                 PO20.1  POCP.1
                                                                 PR05.1  PR05.3
                                                                 ...

VCTSET2   VENDOR-GROUP  KeyChange                                AP300   APCP.1
          VENDOR
          LOCATION-CODE
          RESP-CODE
          CONTACT-LVL
          NAME

VCTSET3   VENDOR-GROUP  Subset
          VENDOR        Where (LOCATION-CODE = Spaces )
          RESP-CODE
          CONTACT-LVL
          LOCATION-CODE

VCTSET4   VENDOR-GROUP                                           AP14.1
          VENDOR
          LOCATION-CODE
          RESP-CODE
          CONTACT-LVL*

                         APCONTACT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Address1       APVENADDR    Required

                            VCT-VENDOR-GROUP     -> VDR-VENDOR-GROUP
                            VCT-VENDOR           -> VDR-VENDOR
                            VCT-LOCATION-CODE    -> VDR-LOCATION-CODE
                            VCT-RESP-CODE        -> VDR-RESP-CODE
                            VCT-CONTACT-LVL      -> VDR-CONTACT-LVL
                            "Y"                  -> VDR-CUR-ADDR

Aprespcode     APRESPCODE   Required

                            VCT-RESP-CODE        -> VRC-RESP-CODE

Apvenloc       APVENLOC     Required

                            VCT-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            VCT-VENDOR           -> VLO-VENDOR
                            VCT-LOCATION-CODE    -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            VCT-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            VCT-VENDOR           -> VEN-VENDOR

                         APCONTACT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenaddr      APVENADDR    Delete Cascades

                            VCT-VENDOR-GROUP     -> VDR-VENDOR-GROUP
                            VCT-VENDOR           -> VDR-VENDOR
                            VCT-LOCATION-CODE    -> VDR-LOCATION-CODE
                            VCT-RESP-CODE        -> VDR-RESP-CODE
                            VCT-CONTACT-LVL      -> VDR-CONTACT-LVL
                                                    VDR-EFFECTIVE-DATE