APCONTACT FILE
REFERENCED BY
AP13.1 AP210 AP290 PO20.1 POCP.1 APCP.1
UPDATED BY
AP10.1 AP10.2 AP14.1 AP300 AP510 AM115
AM117 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 API3.1 API4.1 IC840 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 UK47.1
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 ID 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
Telephone Country AP14.1 AP510
Code
VCT-PHONE-NMBR Alpha 15 AP10.1 AP10.2
Element: Telephone Number AP14.1 AP510
VCT-PHONE-EXT Alpha 5 AP10.1 AP10.2
Element: Telephone ExteThis 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
Telephone Country The fax number prefix. AP14.1 AP510
Code
VCT-FAX-NMBR Alpha 15 AP10.1 AP10.2
Element: Telephone Number AP14.1 AP510
VCT-FAX-EXT Alpha 5 AP10.1 AP10.2
Element: Telephone ExteThis field contains the fax number AP14.1 AP510
extension.
VCT-E-MAIL-ADDRESS Alpha 60 (Lower Case) AP10.1 AP10.2
Element: Email Address AP14.1 AP510
APCONTACT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VCTSET1 VENDOR-GROUP AM115 AM117
VENDOR AM15.1 AM15.2
LOCATION-CODE AM15.3 AM15.4
RESP-CODE AM20.1 AM20.3
CONTACT-LVL AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP10.1 AP10.2
AP13.1 AP14.1
AP14.2 AP210
AP290 AP300
AP510 API3.1
API4.1 IC840
PO20.1 POCP.1
PR05.1 PR05.3
...
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
|
