APCONTACT FILE
REFERENCED BY
AP13.1 AP210 AP212 AP290 POCP.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
AM500 AM51.1 AM551 AM97.1 AP03.3 AP110
AP115 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 AP90.1 AP91.1 API1.1 API2.1
API3.1 API4.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MX123 MX500 MA180 MA279
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 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
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO27.2 PO278 PO29.1 PO30.1 PO30.2 PO30.3
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 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
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VCT-VENDOR-GROUP Alpha 4 AP14.1 AP510
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
VCT-VENDOR Alpha 9 (Right Justified) AP14.1 AP510
Element: Vendor The vendor's identification code.
VCT-LOCATION-CODE Alpha 4 AP14.1 AP510
Element: Location Code A user-defined code that represents an
alternate purchasing or remittance
location for the vendor.
VCT-RESP-CODE Alpha 5 AP14.1 AP510
Element: Resp Code User defined field for label assignment
to contacts.
VCT-CONTACT-LVL Numeric 3 AP14.1 AP510
Element: Contact Lvl System generated assignment that can be
over-ridden at input. To distinguish
and prioritize contacts.
VCT-NAME Alpha 30 (Lower Case) AP10.1 AP10.2
Element: Name Displays the company description. AP14.1
VCT-INT-PREFIX Alpha 6 AP10.1 AP10.2
Element: Phone Prefix The telephone number country code. AP14.1 AP510
VCT-PHONE-NMBR Alpha 15 AP10.1 AP10.2
Element: Phone Phone number. AP14.1 AP510
VCT-PHONE-EXT Alpha 5 AP10.1 AP10.2
Element: Phone Ext This field contains the telephone AP14.1 AP510
extension number.
VCT-MBL-INT-PREFIX Alpha 6 AP10.1 AP10.2
Element: Mbl Int PrefixThis field contains the country code of AP14.1 AP510
the mobile phone number.
VCT-MOBILE-NUM Alpha 15 AP10.1 AP10.2
Element: Mobile Num This field contains the mobile phone AP14.1 AP510
number.
VCT-MOBILE-EXT Alpha 5 AP10.1 AP10.2
Element: Mobile Ext This field contains the mobile phone AP14.1 AP510
extension number.
VCT-FAX-PREFIX Alpha 6 AP10.1 AP10.2
Element: Phone Prefix The telephone number country code. AP14.1 AP510
VCT-FAX-NMBR Alpha 15 AP10.1 AP10.2
Element: Phone Phone number. AP14.1 AP510
VCT-FAX-EXT Alpha 5 AP10.1 AP10.2
Element: Phone Ext This field contains the telephone AP14.1 AP510
extension number.
VCT-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP10.1 AP10.2
Element: Email Address e-mail address. AP14.1 AP510
APCONTACT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VCTSET1 VENDOR-GROUP AC160 AM115
VENDOR AM117 AM15.1
LOCATION-CODE AM15.2 AM15.3
RESP-CODE AM15.4 AM19.1
CONTACT-LVL 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
AP13.1 AP131
AP14.1 AP14.2
AP20.1 AP20.2
...
VCTSET2 VENDOR-GROUP KeyChange AP300 APCP.1
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL
NAME
VCTSET3 VENDOR-GROUP Subset
VENDOR Where (LOCATION-CODE = Spaces )
RESP-CODE
CONTACT-LVL
LOCATION-CODE
VCTSET4 VENDOR-GROUP AP14.1
VENDOR
LOCATION-CODE
RESP-CODE
CONTACT-LVL*
APCONTACT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
