View: Contacts

RotoID: MT0100
Table: MTCONC
Protocol: Header
DLL:MTCONC

Compositions: 1

RotoID Tables Title DLL
MT0110 MTCONCO Contact Optional Field Values MTCONCO

Keys: 1

Title Fields
Contact Code IDCONTACT

Fields: 30

Field Index Type Title Attributes Presentation
IDCONTACT 1 String*24 Contact Code E A K R  Mask: %-24C
DATEINAC 2 Date Inactive Date E A 
SWACTV 3 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
DATELASTMN 4 Date Date Last Maintained E A 
SALUTATION 5 String*10 Salutation E A 
FIRSTNAME 6 String*60 First Name E A 
MIDDLENAME 7 String*60 Middle Name E A 
LASTNAME 8 String*60 Last Name E A 
TITLE 9 String*60 Title E A 
TEXTSTRE1 10 String*60 Address Line 1 E A 
TEXTSTRE2 11 String*60 Address Line 2 E A 
TEXTSTRE3 12 String*60 Address Line 3 E A 
TEXTSTRE4 13 String*60 Address Line 4 E A 
NAMECITY 14 String*30 City E A 
CODESTTE 15 String*30 State/Prov. E A 
CODEPSTL 16 String*30 Zip/Postal Code E A 
CODECTRY 17 String*30 Country E A 
SWOKEMAIL 18 Integer Consents to Receive Email E A  List:2 entries
0 = No
1 = Yes
TEXTPHON1 19 String*30 Phone Number 1 E A  Mask: (%-3C) %-3C-%-24C
TEXTPHON2 20 String*30 Phone Number 2 E A  Mask: (%-3C) %-3C-%-24C
TEXTPHON3 21 String*30 Phone Number 3 E A  Mask: (%-3C) %-3C-%-24C
TEXTFAX 22 String*30 Fax Number E A  Mask: (%-3C) %-3C-%-24C
EMAIL 23 String*255 Email E A 
COMMENT1 24 String*250 Comment 1 E A 
COMMENT2 25 String*250 Comment 2 E A 
WEBSITE 26 String*100 Web Site E A 
CRMPRSNID 27 Long CRM Person ID E A 
VALUES 28 Long Optional Fields E A C 
DISPLAYNAM 150 String*255 Display Name E A C 
EWSUPPRESS 151 Boolean Suppress Integration E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).