Lawson Insight Technical Documentation |
|
APVENPAY
APVENPAY FILE
REFERENCED BY
AP10.1 AP11.1
UPDATED BY
AM115 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
PR514 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VPY-VENDOR-GROUP Alpha 4 AM115 AM15.1
Element: Vendor Group A vendor group represents a group of AM15.2 AM15.3
vendors that can be shared by one or AM15.4 AM20.1
more companies. 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 PR514
UK47.1
VPY-VENDOR Alpha 9 (Right Justified) AM115 AM15.1
Element: Vendor ID The vendor's identification code. 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 PR514
UK47.1
VPY-PAY-VENDOR Alpha 9 (Right Justified) AM115 AM15.1
Element: Vendor ID 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 PR514
UK47.1
VPY-PAY-TYPE Alpha 1 AM115 AM15.1
Element: Pay Type P = Pay to Vendor AM15.2 AM15.3
F = Factor Vendor 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 PR514
UK47.1
VPY-DEFAULT Alpha 1 AM115 AM15.1
Element: Default Y = Yes AM15.2 AM15.3
N = No 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 PR514
UK47.1
APVENPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VPYSET1 VENDOR-GROUP AM115 AM15.1
VENDOR AM15.2 AM15.3
PAY-VENDOR 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 PR514
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
"Y" -> VDR-CUR-ADDR
Address2 APVENADDR Required
VPY-VENDOR-GROUP -> VDR-VENDOR-GROUP
VPY-VENDOR -> VDR-VENDOR
Spaces -> VDR-LOCATION-CODE
"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
|