Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCVENCERT


                            APCVENCERT FILE

UPDATED BY

AP51.8    AP51.1    AP510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVN-VENDOR-GROUP       Alpha 4                                   AP51.8
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.

CVN-VENDOR             Alpha 9  (Right Justified)                AP51.8
Element: Vendor ID     The vendor's identification code.



CVN-LOCATION-CODE      Alpha 4                                   AP51.8
Element: Location Code A user-defined code that represents an
                       alternate purchasing or remittance
                       location for the vendor.

CVN-CERTIF-CODE        Alpha 10                                  AP51.8
Element: Certif Code   User defined code representing
                       certifications.

CVN-CERTIF-DESC        Alpha 30                                  AP51.8
Element: Certif Desc   Description of the Certification Code.

CVN-CERTIF-EFF-DT      Numeric 8  (yyyymmdd)                     AP51.8
Element: Effective Date

CVN-CERTIF-EXP-DT      Numeric 8  (yyyymmdd)                     AP51.8
Element: Effective Date

                         APCVENCERT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVNSET1   VENDOR-GROUP                                           AP51.1  AP51.8
          VENDOR                                                 AP510
          LOCATION-CODE
          CERTIF-CODE
          CERTIF-EFF-DT*

                         APCVENCERT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcertcode     APCERTCODE   Required

                            CVN-CERTIF-CODE    -> CER-CERTIF-CODE