AP_VendorContactListingWrk AP Vendor Contact Listing Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_VendorContactListing_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorContactListingWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 3 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 4 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . . 5 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . . 6 PrimaryContactCode. . . . . . 1 SNN Primary Contact Code. . . . . . 7 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . . 8 AddressLine1. . . . . . . . . 30 SNN Contact Address Line 1. . . . . 9 AddressLine2. . . . . . . . . 30 SNN Contact Address Line 2. . . . . 10 AddressLine3. . . . . . . . . 30 SNN Contact Address Line 3. . . . . 11 City. . . . . . . . . . . . . 30 SNN Contact City. . . . . . . . . . 12 State . . . . . . . . . . . . 2 SNN Contact State . . . . . . . . . 13 ZipCode . . . . . . . . . . . 10 SNN Contact Zip Code. . . . . . . . 14 CountryCode . . . . . . . . . 3 SNN Contact Country Code. . . . . . 15 CountryName . . . . . . . . . 30 SNN Contact Country Name. . . . . . 16 Salutation. . . . . . . . . . 10 SNN Contact Salutation. . . . . . . 17 ContactTitle. . . . . . . . . 15 SNN Contact Title . . . . . . . . . 18 TelephoneNo1. . . . . . . . . 17 SNN Contact Telephone Number 1. . . 19 TelephoneExt1 . . . . . . . . 5 SNN Contact Telephone Extension . . 20 TelephoneNo2. . . . . . . . . 17 SNN Contact Telephone Number 2. . . 21 TelephoneExt2 . . . . . . . . 17 SNN Contact Telephone Extension . . 22 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . . 23 EmailAddress. . . . . . . . . 50 SNN Contact E-mail Address. . . . . 24 ContactNotes. . . . . . . . . 256 SNN Contact Notes . . . . . . . . .