APVENPAY

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 AM22.1 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 AP20.7 AP21.1 AP210 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP271
AP30.2 AP30.4 AP300 AP305 AP510 AP90.1
AP91.1 API1.1 API2.1 API3.1 API4.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC140 IC142
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 IC840
MX123 MX500 MA180 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 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 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5
POCP.1 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 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ500 RQIF.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130

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. 		...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VPY-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code. 		...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VPY-PAY-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code. 		...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VPY-PAY-TYPE
Element: Pay Type		Alpha 1

P = Pay to Vendor
F = Factor Vendor		 ...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
VPY-DEFAULT
Element: Default		Alpha 1

Y = Yes
N = No		 ...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
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 AP271
AP30.2 AP30.4
AP300 AP305
AP510 AP90.1
AP91.1 API1.1
API2.1 API3.1
API4.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506


APVENPAY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VPYSET1 VENDOR-GROUP
VENDOR
PAY-VENDOR
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP11.1 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
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: Thu Jun 09 11:07:57 2016

Home
Contact Us



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