Table: Contacts

Table: MTCONC
View: MT0100
Record Length: 1655

Flags: A R 

Keys: 1

Title Flags Fields
Contact Code IDCONTACT

Fields: 32

Field Type Title Presentation
IDCONTACT String*24 Contact Code Mask: %-24C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DATEINAC Date Inactive Date
SWACTV Integer Status List:2 entries
0 = Inactive
1 = Active
DATELASTMN Date Date Last Maintained
SALUTATION String*10 Salutation
FIRSTNAME String*60 First Name
MIDDLENAME String*60 Middle Name
LASTNAME String*60 Last Name
TITLE String*60 Title
TEXTSTRE1 String*60 Address Line 1
TEXTSTRE2 String*60 Address Line 2
TEXTSTRE3 String*60 Address Line 3
TEXTSTRE4 String*60 Address Line 4
NAMECITY String*30 City
CODESTTE String*30 State/Prov.
CODEPSTL String*30 Zip/Postal Code
CODECTRY String*30 Country
SWOKEMAIL Integer Consents to Receive Email List:2 entries
0 = No
1 = Yes
TEXTPHON1 String*30 Phone Number 1 Mask: (%-3C) %-3C-%-24C
TEXTPHON2 String*30 Phone Number 2 Mask: (%-3C) %-3C-%-24C
TEXTPHON3 String*30 Phone Number 3 Mask: (%-3C) %-3C-%-24C
TEXTFAX String*30 Fax Number Mask: (%-3C) %-3C-%-24C
EMAIL String*255 Email
COMMENT1 String*250 Comment 1
COMMENT2 String*250 Comment 2
WEBSITE String*100 Web Site
CRMPRSNID Long CRM Person ID
VALUES Long Optional Fields

This page was generated on 2023-Aug-31

© 2023 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).