APCONTACT

REFERENCED BY
AP100 AP109 AP111 AP151 AP16.1 AP16.2
AP160 AP161 AP170 AP180 AP181 AP190
AP193 AP212 AP28.1 AP28.2 AP290 AP520
AP590 APBD.2 CB00.1 CB10.1 CB150 EE135
EE20.1 EE20.2 EE35.1 EE35.2 EE520 MA64.6
MA64.9 MAED.1 APCP.1


UPDATED BY
AP10.1 AP10.2 AP14.1 AP300 AP510 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 AP13.1 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
AP305 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

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
VCT-SOCIAL-ID1
Element: Social Id1		Alpha 80 (Lower Case)
AP10.1 AP10.2
AP14.1
VCT-SOCIAL-ID2
Element: Social Id2		Alpha 80 (Lower Case)
AP10.1 AP10.2
AP14.1
VCT-SOCIAL-ID3
Element: Social Id3		Alpha 80 (Lower Case)
AP10.1 AP10.2
AP14.1
VCT-SOCIAL-ID4
Element: Social Id4		Alpha 80 (Lower Case)
AP10.1 AP10.2
AP14.1
VCT-SOCIAL-ID5
Element: Social Id5		Alpha 80 (Lower Case)
AP10.1 AP10.2
AP14.1


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 AP100
AP109 AP110
AP111 AP115
AP125 AP126
AP13.1 AP131
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
Apcntnbod APCNTNBOD Not Required, Delete Cascades
VCT-VENDOR-GROUP->YAX-VENDOR-GROUP
VCT-VENDOR->YAX-VENDOR
VCT-LOCATION-CODE->YAX-LOCATION-CODE
VCT-RESP-CODE->YAX-RESP-CODE
VCT-CONTACT-LVL->YAX-CONTACT-LVL
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 02:06:57 2016

Home
Contact Us



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