Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PDMERCHXRF


                            PDMERCHXRF FILE

REFERENCED BY

PD04.1    PD570     POII.1

UPDATED BY

PD06.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PDY-PCARD-PROGRAM      Alpha 10                                  PD06.1
Element: Pcard Program

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

PDY-VENDOR             Alpha 9  (Right Justified)                PD06.1
Element: Vendor        The vendor's identification code.



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

PDY-MERCHANT           Alpha 32                                  PD06.1
Element: Merchant

                         PDMERCHXRF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PDYSET1   PCARD-PROGRAM                                          PD06.1
          VENDOR-GROUP
          VENDOR
          LOCATION-CODE
          MERCHANT

PDYSET2   PCARD-PROGRAM                                          PD04.1  PD06.1
          MERCHANT                                               PD570   POII.1
          VENDOR
          LOCATION-CODE

PDYSET3   VENDOR-GROUP
          VENDOR
          MERCHANT
          PCARD-PROGRAM

                         PDMERCHXRF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenloc       APVENLOC     Required

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