AP_VendorContact AP Vendor Contact Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_VendorContact_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_VendorContact.M4T"
KPRIMARY: APDivisionNo+VendorNo+ContactCode
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP_17$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {AP_17$(3,7)} 3 ContactCode . . . . . . . . . 10 SYY Contact Code. . . . . . . . . .APCONTACT Notes: {AP_17$(10,10)} 4 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . .NAME Notes: {AP_17$(20,30)} 5 AddressLine1. . . . . . . . . 30 SNN Contact Address Line 1. . . . .ADDRESSLINE Notes: {AP_17$(50,30)} 6 AddressLine2. . . . . . . . . 30 SNN Contact Address Line 2. . . . .ADDRESSLINE Notes: {AP_17$(80,30)} 7 AddressLine3. . . . . . . . . 30 SNN Contact Address Line 3. . . . .ADDRESSLINE Notes: {AP_17$(110,30)} 8 City. . . . . . . . . . . . . 20 SNN Contact City. . . . . . . . . .CITY Notes: {AP_17$(140,20)} 9 State . . . . . . . . . . . . 2 SYN Contact State . . . . . . . . .STATE Notes: {AP_17$(160,2)} 10 ZipCode . . . . . . . . . . . 10 SYN Contact Zip Code. . . . . . . .ZIPCODE Notes: {AP_17$(162,10)} 11 CountryCode . . . . . . . . . 3 SYN Contact Country Code. . . . . .COUNTRY Notes: {AP_17$(172,3)} 12 Salutation. . . . . . . . . . 10 SNN Contact Salutation. . . . . . . Notes: {AP_17$(192,10)} 13 ContactTitle. . . . . . . . . 15 SNN Contact Title . . . . . . . . . Notes: {AP_17$(202,15)} 14 TelephoneNo1. . . . . . . . . 17 SNN Contact Telephone Number 1. . .TELEPHONENO Notes: {AP_17$(217,17)} 15 TelephoneExt1 . . . . . . . . 5 SNN Contact Telephone Extension 1 .TELEPHONEEXT Notes: {AP_17$(234,5)} 16 TelephoneNo2. . . . . . . . . 17 SNN Contact Telephone Number 2. . .TELEPHONENO Notes: {AP_17$(239,17)} 17 TelephoneExt2 . . . . . . . . 5 SNN Contact Telephone Extension 2 .TELEPHONEEXT Notes: {AP_17$(256,5)} 18 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO Notes: {AP_17$(261,17)} 19 EmailAddress. . . . . . . . . 50 SNN Contact Email Address . . . . .EMAILADDRESS Notes: {AP_17$(278,50)} 20 ContactNotes. . . . . . . . . 256 SNN Contact Notes . . . . . . . . . Notes: {AP_17$(328,256)} 21 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 22 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 23 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 24 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 25 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 26 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000