You are here: Reference Guide > Table Structures > Contacts > CN_Contact

CN_Contact

Purpose       

This table stores the individual contact details for each debtor, creditor and contact record, including position ID.

Path    

Debtors, Creditors and Contacts Main form tab Contacts

Name

Type

Linked To/Supplied

ContactID

Text (20)

 

AccNo

Text (50)

 

Title

Text (30)

 

Fname

Text (50)

 

Sname

Text (50)

 

PrimaryID

Text (20)

CN_ContactPosition.ContactPositionID

SecondaryID

Text (20)

CN_ContactPosition.ContactPositionID

TertiaryID

Text (20)

CN_ContactPosition.ContactPositionID

Phone

Text (20)

 

Mobile

Text (20)

 

Fax

Text (20)

 

EmailAddress

Text (200)

 

ProspectID

Text (20)

CN_Main.ProspectID

LogonCode

Text (20)

 

LogonPassword

Text (10)

 

ExternalAppRecID

Text (20)

 

DefaultContact

Yes/No

 

DebtorContact

Yes/No

 

CreditorContact

Yes/No

 

LastSavedDateTime

Date/Time

 

Copyright © 2012 Jiwa Financials. All rights reserved.