This table stores the individual contact details for each debtor, creditor and contact record, including position ID.
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.