Lawson Insight Technical Documentation |
|
APVENPAY
APVENPAY FILE
REFERENCED BY
AP10.1 AP11.1
UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP300 AP510 API3.1 API4.1
IC840 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VPY-VENDOR-GROUP Alpha 4 AM115 AM117
Element: Vendor Group A vendor group represents a group of AM15.1 AM15.2
vendors that can be shared by one or AM15.3 AM15.4
more companies. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VPY-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Vendor ID The vendor's identification code. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VPY-PAY-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Vendor ID AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VPY-PAY-TYPE Alpha 1 AM115 AM117
Element: Pay Type P = Pay to Vendor AM15.1 AM15.2
F = Factor Vendor AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
VPY-DEFAULT Alpha 1 AM115 AM117
Element: Default Y = Yes AM15.1 AM15.2
N = No AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP510 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
APVENPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VPYSET1 VENDOR-GROUP AM115 AM117
VENDOR AM15.1 AM15.2
PAY-VENDOR AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP11.1
AP300 API3.1
API4.1 IC840
PR05.1 PR05.3
PR226 PR247
PR26.1 PR47.1
UK47.1
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
|