APCONTACT

REFERENCED BY
AP212 APCP.1


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

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
...
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
AP10.2 AP110
AP115 AP125
AP126 AP131
AP14.1 AP14.2
AP150 AP20.1
AP20.2 AP20.3
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: Wed Jun 08 20:47:28 2016

Home
Contact Us



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