Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENDIV


                             APVENDIV FILE

The APVENDIV file stores the diversity codes and their certification dates for
the related vendor in APVENMAST

REFERENCED BY

AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP23.1    AP520     API1.1    MA41.1    MA41.2
MA41.4    MA41.7    MA43.2    MA540

UPDATED BY

AP14.4    AP300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


VDC-VENDOR             Alpha 9  (Right Justified)                AP14.4
Element: Vendor        The vendor's identification code.



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


VDC-DIVERSE-CODE       Alpha 5                                   AP14.4
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors

VDC-CERT-DATE          Numeric 8  (yyyymmdd)                     AP14.4
Element: Date          This is the date the vendor was
                       certified for the diversity code

VDC-DCERT-DATE         Numeric 8  (yyyymmdd)                     AP14.4
Element: Date          This is the date the expiration date for
                       the diversity code of the vendor

VDC-REVIEW-DATE        Numeric 8  (yyyymmdd)                     AP14.4
Element: Date          This is the date the diversity code
                       should be reviewed for certification

                         APVENDIV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VDCSET1   VENDOR-GROUP                                           AP14.4  AP20.1
          VENDOR                                                 AP20.2  AP20.3
          LOCATION-CODE                                          AP20.4  AP20.5
          DIVERSE-CODE                                           AP20.7  AP21.1
          DCERT-DATE                                             AP23.1  AP300
                                                                 AP520   API1.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA540

VDCSET2   DIVERSE-CODE
          VENDOR-GROUP
          VENDOR
          LOCATION-CODE
          DCERT-DATE

                         APVENDIV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenloc       APVENLOC     Required

                            VDC-VENDOR-GROUP     -> VLO-VENDOR-GROUP  (VLOSET1)
                            VDC-VENDOR           -> VLO-VENDOR
                            VDC-LOCATION-CODE    -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            VDC-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            VDC-VENDOR           -> VEN-VENDOR

Procuregrp     PROCUREGRP   Required

                            VDC-VENDOR-GROUP     -> PCG-VENDOR-GROUP

                         APVENDIV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apinvoice      APINVOICE

                            VDC-VENDOR-GROUP     -> API-VENDOR-GROUP
                            VDC-VENDOR           -> API-VENDOR
                                                    API-INVOICE
                                                    API-SUFFIX
                                                    API-CANCEL-SEQ
                                                    API-COMPANY

Apvenbal       APVENBAL

                            VDC-VENDOR-GROUP     -> VBA-VENDOR-GROUP
                            VDC-VENDOR           -> VBA-VENDOR
                            VDC-LOCATION-CODE    -> VBA-LOCATION-CODE
                                                    VBA-COMPANY

Povagrmthd     POVAGRMTHD

                            PCG-PROCURE-GROUP    -> PVH-PROCURE-GROUP
                            VDC-VENDOR           -> PVH-VENDOR
                            VDC-LOCATION-CODE    -> PVH-PURCH-FR-LOC
                                                    PVH-VEN-AGRMT-REF