Lawson Insight Technical Documentation |
|
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
|