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

CN_Main 

Purpose       

Contact header details are maintained in this table together with a linking to the debtor and creditor record where appropriate

Path    

Contacts or Debtors or Creditors Maintenance New Record

Name

Type

Linked To/Supplied

ProspectID

Text (20)

 

LastSavedDateTime

Date/Time

 

ProspectNumber

Text (50)

 

CompanyName

Text (50)

 

Address1

Text (50)

 

Address2

Text (50)

 

Address3

Text (50)

 

State

Text (20)

 

PostCode

Text (50)

 

Phone

Text (50)

 

Fax

Text (50)

 

EmailAddress

Text (200)

 

CRAccountNo

Text (50)

 

DBAccountNo

Text (50)

 

CreditorID

Text (20)

CR_Main1.CreditorID

DebtorID

Text (20)

DB_Main1.DebtorID

ExternalAppRecID

Text (20)

 

AustPostDPID

Text (20)

 

AustPostBCSP

Text (20)

 

Copyright © 2012 Jiwa Financials. All rights reserved.