APVENPAY

REFERENCED BY
AP10.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 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
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 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 MA126
MA180 MA278 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 MA53.1
MA530 MA531 MA540 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO192 PO195
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO222 PO223 PO224
PO225 PO229 PO23.1 PO230 PO233 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO253 PO254 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO278
PO28.2 PO280 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
PO529 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.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 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. 		...
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 02:07:43 2016

Home
Contact Us



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