Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENPAY


                             APVENPAY FILE

REFERENCED BY

AP10.1    AP11.1

UPDATED BY

AC160     AM115     AM117     AM15.1    AM15.2    AM15.3
AM15.4    AM19.1    AM19.2    AM20.1    AM20.3    AM21.1
AM21.3    AM500     AM51.1    AM551     AM97.1    AP03.3
AP110     AP115     AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP210     AP220     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP300     AP305     AP510
AP90.1    AP91.1    API1.1    API2.1    API3.1    API4.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MX123     MX500     MA180     MA279     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.4
MA43.6    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA63.1    MA65.1    MA66.2    MA66.3
MA67.2    MA67.3    MA68.2    MA68.3    MA68.5    MA70.1
MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PD235     PO10.1    PO100
PO101     PO120     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO220
PO223     PO23.1    PO233     PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO253     PO254     PO27.2    PO278
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     PO54.1    PO54.2
PO54.3    PO54.4    POI3.1    POID.1    POII.1    POIJ.1
PR05.1    PR05.3    PR226     PR247     PR26.1    PR47.1
PR514     UK47.1    RQ10.1    RQ10.2    WH20.2    WH20.7


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VPY-VENDOR-GROUP       Alpha 4                                   AC160   AM115
Element: Vendor Group  A vendor group represents a group of      AM117   AM15.1
                       vendors that can be shared by one or      AM15.2  AM15.3
                       more companies.                           AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP210   AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   AP90.1
                                                                 AP91.1  API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

VPY-VENDOR             Alpha 9  (Right Justified)                AC160   AM115
Element: Vendor        The vendor's identification code.         AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP210   AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   AP90.1
                                                                 AP91.1  API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

VPY-PAY-VENDOR         Alpha 9  (Right Justified)                AC160   AM115
Element: Vendor        The vendor's identification code.         AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP210   AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   AP90.1
                                                                 AP91.1  API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

VPY-PAY-TYPE           Alpha 1                                   AC160   AM115
Element: Pay Type      P = Pay to Vendor                         AM117   AM15.1
                       F = Factor Vendor                         AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP210   AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   AP90.1
                                                                 AP91.1  API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

VPY-DEFAULT            Alpha 1                                   AC160   AM115
Element: Default       Y = Yes                                   AM117   AM15.1
                       N = No                                    AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP210   AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 AP510   AP90.1
                                                                 AP91.1  API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

                         APVENPAY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VPYSET1   VENDOR-GROUP                                           AC160   AM115
          VENDOR                                                 AM117   AM15.1
          PAY-VENDOR                                             AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP10.1  AP11.1
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 ...

VPYSET2   VENDOR-GROUP                                           AP10.1
          PAY-VENDOR
          VENDOR

                         APVENPAY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Address1       APVENADDR    Required

                            VPY-VENDOR-GROUP    -> VDR-VENDOR-GROUP
                            VPY-PAY-VENDOR      -> VDR-VENDOR
                            Spaces              -> VDR-LOCATION-CODE
                            Spaces              -> VDR-RESP-CODE
                            Zeroes              -> VDR-CONTACT-LVL
                            "Y"                 -> VDR-CUR-ADDR

Address2       APVENADDR    Required

                            VPY-VENDOR-GROUP    -> VDR-VENDOR-GROUP
                            VPY-VENDOR          -> VDR-VENDOR
                            Spaces              -> VDR-LOCATION-CODE
                            Spaces              -> VDR-RESP-CODE
                            Zeroes              -> VDR-CONTACT-LVL
                            "Y"                 -> VDR-CUR-ADDR

Apvenmast      APVENMAST    Required

                            VPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            VPY-PAY-VENDOR      -> VEN-VENDOR

Apvenmast2     APVENMAST    Required

                            VPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            VPY-VENDOR          -> VEN-VENDOR

                         APVENPAY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aphldinv1      APHLDINV     Delete Cascades

                            "V"                 -> HLI-REC-TYPE
                            VPY-VENDOR-GROUP    -> HLI-VENDOR-GROUP
                            Zeroes              -> HLI-COMPANY
                            VPY-PAY-VENDOR      -> HLI-VENDOR
                                                   HLI-INVOICE
                                                   HLI-SUFFIX
                                                   HLI-CANCEL-SEQ
                                                   HLI-SEQ-NBR
                                                   HLI-VOID-SEQ
                                                   HLI-HLD-CODE

Aphldinv2      APHLDINV     Delete Cascades

                            "V"                 -> HLI-REC-TYPE
                            VPY-VENDOR-GROUP    -> HLI-VENDOR-GROUP
                            Zeroes              -> HLI-COMPANY
                            VPY-VENDOR          -> HLI-VENDOR
                                                   HLI-INVOICE
                                                   HLI-SUFFIX
                                                   HLI-CANCEL-SEQ
                                                   HLI-SEQ-NBR
                                                   HLI-VOID-SEQ
                                                   HLI-HLD-CODE

Apvcomments1   APCOMMENTS

                            "V"                 -> APC-REC-TYPE
                            VPY-VENDOR-GROUP    -> APC-VENDOR-GROUP
                            VPY-PAY-VENDOR      -> APC-VENDOR
                            Spaces              -> APC-LOCATION-CODE
                                                   APC-COMPANY
                                                   APC-SEQ-NBR

Apvcomments2   APCOMMENTS

                            "V"                 -> APC-REC-TYPE
                            VPY-VENDOR-GROUP    -> APC-VENDOR-GROUP
                            VPY-VENDOR          -> APC-VENDOR
                            Spaces              -> APC-LOCATION-CODE
                                                   APC-COMPANY
                                                   APC-SEQ-NBR

Apvenloc1      APVENLOC     Delete Cascades

                            VPY-VENDOR-GROUP    -> VLO-VENDOR-GROUP
                            VPY-PAY-VENDOR      -> VLO-VENDOR
                                                   VLO-LOCATION-CODE

Apvenloc2      APVENLOC     Delete Cascades

                            VPY-VENDOR-GROUP    -> VLO-VENDOR-GROUP
                            VPY-VENDOR          -> VLO-VENDOR
                                                   VLO-LOCATION-CODE