APVENPAY

UPDATED BY
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 AP150 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
MX123 MX500 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO10.1 PO136 PO190 PO300 PO520
POCP.1 POI3.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
AP10.1 AP11.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VPY-VENDOR-GROUP
Element: Vendor Group		Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies. 		...
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
AP150 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
MX123 MX500
VPY-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code. 		...
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
AP150 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
MX123 MX500
VPY-PAY-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code. 		...
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
AP150 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
MX123 MX500
VPY-PAY-TYPE
Element: Pay Type		Alpha 1

P = Pay to Vendor
F = Factor Vendor		 ...
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
AP150 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
MX123 MX500
VPY-DEFAULT
Element: Default		Alpha 1

Y = Yes
N = No		 ...
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
AP150 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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
MX123 MX500


APVENPAY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VPYSET1 VENDOR-GROUP
VENDOR
PAY-VENDOR
...
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 AP10.1
AP11.1 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
VPYSET2 VENDOR-GROUP
PAY-VENDOR
VENDOR
AP10.1


APVENPAY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:47:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.