APCONTACT

REFERENCED BY
AP212 AP13.1 APCP.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 AP10.1 AP10.2 AP110 AP115 AP125
AP126 AP131 AP14.1 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 AP290 AP30.2 AP30.4 AP300 AP305
AP510 AP590 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
VCT-VENDOR-GROUP
Element: Vendor Group		Alpha 4
A vendor group represents a group of vendors that can be shared by one or more companies.
AP10.1 AP10.2
AP14.1 AP510
VCT-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP10.1 AP10.2
AP14.1 AP510
VCT-LOCATION-CODE
Element: Location Code		Alpha 4
A user-defined code that represents an alternate purchasing or remittance location for the vendor.
AP10.1 AP10.2
AP14.1 AP510
VCT-RESP-CODE
Element: Resp Code		Alpha 5
User defined field for label assignment to contacts.
AP10.1 AP10.2
AP14.1 AP510
VCT-CONTACT-LVL
Element: Contact Lvl		Numeric 3
System generated assignment that can be over-ridden at input. To distinguish and prioritize contacts.
AP10.1 AP10.2
AP14.1 AP510
VCT-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
AP10.1 AP10.2
AP14.1 AP510
VCT-INT-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
AP10.1 AP10.2
AP14.1 AP510
VCT-PHONE-NMBR
Element: Phone		Alpha 15
Phone number.
AP10.1 AP10.2
AP14.1 AP510
VCT-PHONE-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
AP10.1 AP10.2
AP14.1 AP510
VCT-MBL-INT-PREFIX
Element: Mbl Int Prefix		Alpha 6
This field contains the country code of the mobile phone number.
AP10.1 AP10.2
AP14.1 AP510
VCT-MOBILE-NUM
Element: Mobile Num		Alpha 15
This field contains the mobile phone number.
AP10.1 AP10.2
AP14.1 AP510
VCT-MOBILE-EXT
Element: Mobile Ext		Alpha 5
This field contains the mobile phone extension number.
AP10.1 AP10.2
AP14.1 AP510
VCT-FAX-PREFIX
Element: Phone Prefix		Alpha 6
The telephone number country code.
AP10.1 AP10.2
AP14.1 AP510
VCT-FAX-NMBR
Element: Phone		Alpha 15
Phone number.
AP10.1 AP10.2
AP14.1 AP510
VCT-FAX-EXT
Element: Phone Ext		Alpha 5
This field contains the telephone extension number.
AP10.1 AP10.2
AP14.1 AP510
VCT-E-MAIL-ADDRESS
Element: Email Address		Alpha 60 (Lower Case)
e-mail address.
AP10.1 AP10.2
AP14.1 AP510


APCONTACT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VCTSET1 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
...
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
AP10.2 AP110
AP115 AP125
AP126 AP13.1
AP131 AP14.1
AP14.2 AP150
VCTSET2 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
NAME
KeyChange
AP300 APCP.1
VCTSET3 VENDOR-GROUP
VENDOR
RESP-CODE
CONTACT-LVL
LOCATION-CODE
Subset
Where(LOCATION-CODE =Spaces)
VCTSET4 VENDOR-GROUP
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL*
AP14.1


APCONTACT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Address1 APVENADDR Required
VCT-VENDOR-GROUP->VDR-VENDOR-GROUP
VCT-VENDOR->VDR-VENDOR
VCT-LOCATION-CODE->VDR-LOCATION-CODE
VCT-RESP-CODE->VDR-RESP-CODE
VCT-CONTACT-LVL->VDR-CONTACT-LVL
"Y"->VDR-CUR-ADDR
Aprespcode APRESPCODE Required
VCT-RESP-CODE->VRC-RESP-CODE
Apvenloc APVENLOC Required
VCT-VENDOR-GROUP->VLO-VENDOR-GROUP
VCT-VENDOR->VLO-VENDOR
VCT-LOCATION-CODE->VLO-LOCATION-CODE
Apvenmast APVENMAST Required
VCT-VENDOR-GROUP->VEN-VENDOR-GROUP
VCT-VENDOR->VEN-VENDOR


APCONTACT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apvenaddr APVENADDR Delete Cascades
VCT-VENDOR-GROUP->VDR-VENDOR-GROUP
VCT-VENDOR->VDR-VENDOR
VCT-LOCATION-CODE->VDR-LOCATION-CODE
VCT-RESP-CODE->VDR-RESP-CODE
VCT-CONTACT-LVL->VDR-CONTACT-LVL
  VDR-EFFECTIVE-DATE

File created: Thu Jun 09 11:07:18 2016

Home
Contact Us



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