|
AVAILABLE FIELDS |
TYPE |
|
|
ABN |
Text (20) |
|
|
Area |
Numeric |
|
|
AreaText |
Text (50) |
|
|
ASIC |
Text (20) |
|
|
BillToBusiness |
Numeric |
|
|
BillToBusinessText |
Text (50) |
|
|
BillToPerson |
Numeric |
|
|
BillToPersonText |
Text (50) |
|
|
BusinessStructure |
Numeric |
1=Company,2=Partnership,3=Sole Trader,4=Trust,5=Individual,6=n/a,7=Government Body,8=Not For Profit |
|
CardExpiry |
Text (10) |
|
|
CardName |
Text (50) |
|
|
CardNumber |
Text (50) |
|
|
ContactSince |
Date |
|
|
ContactSource |
Numeric |
You can define your own, but there are some standard choices, eg 1=Word of Mouth,2=Trade Show,3=Advertising |
|
ContactSourceText |
Text (50) |
As above |
|
Credit |
Numeric |
Credit Limit |
|
CreditorBalanceDate |
Date |
This field is maintained by FINANCIAL_DEBTORSCREDITORS_PROCESSING_MANAGE. It reflects that most recent time that you did not owe them money (ie via Expenses and Payments). It is used to aid with the performance of FINANCIAL_CREDITOR_SEARCH |
|
CustomerStatus |
Numeric |
Alias for Status |
|
CustomerStatusText |
Text (50) |
|
|
DebtorBalanceDate |
Date |
This field is maintained by FINANCIAL_DEBTORSCREDITORS_PROCESSING_MANAGE. It reflects that most recent time that they did not owe you money (ie via Invoices and Receipts). It is used to aid with the performance of FINANCIAL_DEBTOR_SEARCH |
|
DirectDebitAccountName |
Text (50) |
|
|
DirectDebitAccountNumber |
Text (50) |
|
|
DirectDebitBank |
Text (20) |
|
|
DirectDebitBranchNumber |
Text (50) |
|
|
DisplayOrder |
Numeric |
|
|
Email |
Text (50) |
|
|
ExpenseFinancialAccount |
Numeric |
Define your own |
|
ExpenseFinancialAccountText |
Text (50) |
|
|
FaxNumber |
Text (50) |
|
|
Id |
Numeric |
|
|
ImageAttachment |
Numeric |
|
|
ImageAttachmentText |
Text (300) |
|
|
Industry |
Numeric |
Standard industry values, eg 1=A-Agriculture, Forestry and Fishing,2=B-Mining,3=C-Manufacturing |
|
IndustryText |
Text (50) |
|
|
Legalname |
Text (100) |
|
|
MailingAddressCombined |
Text (200) |
Mailing Address 1 and Mailing Address 2 in the one field |
|
MailingAddress1 |
Text (100) |
|
|
MailingAddress2 |
Text (100) |
|
|
MailingCountry |
Text (50) |
|
|
MailingGPSLatitude |
Numeric |
|
|
MailingGPSLatitudeString |
String (50) |
|
|
MailingGPSLongitude |
Numeric |
|
|
MailingGPSLongitudeString |
String (50) |
|
|
MailingPostCode |
Text (10) |
|
|
MailingState |
Text (30) |
|
|
MailingSuburb |
Text (50) |
|
|
Notes |
Text (6000) |
|
|
OtherInfo |
Text (100) |
|
|
PaymentAdvice |
Numeric |
1=Send Invoice Only,2=Send Invoice & Statement |
|
PaymentAdviceText |
Text (50) |
As above |
|
PaymentAdviceDays |
Numeric |
|
|
PaymentMethod |
Numeric |
Define your own, plus there aree some defaults eg 1=Cheque,2=Visa or Mastercard,3=Direct Debit |
|
PaymentMethodText |
Text (50) |
As above |
|
PaymentTerms |
Numeric |
eg 1=Manually Set,2=7 Days from Invoice Date,3=14 Days from Invoice Date |
|
PaymentTermsText |
Text (50) |
As above |
|
PaymentTermsNotes |
Text (200) |
|
|
Phone |
Text (30) |
|
|
PhoneNumber |
Text (30) |
Alias of Phone |
|
PriceGroup |
Numeric |
Define your own |
|
PriceGroupText |
Text (50) |
|
|
PrimaryContactPerson |
Numeric |
|
|
PrimaryContactPersonText |
Text (50) |
|
|
PrimaryGroup |
Numeric |
As configured via SETUP_CONTACT_BUSINESS_GROUP_MANAGE. If you are wanting to store multiple groups per contact use CONTACT_BUSINESS_GROUP_MANAGE |
|
PrimaryGroupText |
Text (50) |
|
|
Private |
Text (1) |
Y / N |
|
Rating |
Numeric |
You can define your own, and also specify if you want the defaults. eg default values 1=A,2=B,3=C |
|
RatingText |
Text (50) |
As above |
|
Reference |
Text (50) |
|
|
RelationshipManager |
Numeric |
Id of the contact's relationship manager |
|
RelationshipManagerText |
Text (50) |
Name of the contact's relationship manager |
|
RevenueFinancialAccount |
Numeric |
Define your own |
|
RevenueFinancialAccountText |
Text (50) |
|
|
SendNews |
Text (1) |
Y / N [default] |
|
SendOverDue |
Text (1) |
Y / N |
|
Status |
Numeric |
1=Active,2=Prospect,3=Non-Active,4=Soon to be Non-Active,5=Internal,6=Alternate Supplier,7=Reference Only,8=Pending Approval |
|
StatusText |
Text (50) |
eg Pending Approval |
|
StatusNotes |
Text (254) |
|
|
StreetAddressCombined |
Text (200) |
Streeet Address 1 and Street Address 2 in the one field |
|
StreetAddress1 |
Text (100) |
|
|
StreetAddress2 |
Text (100) |
|
|
StreetCountry |
Text (50) |
|
|
StreetGPSLatitude |
Numeric |
|
|
StreetGPSLatitudeString |
Text (50) |
|
|
StreetGPSLongitude |
Numeric |
|
|
StreetGPSLongitudeString |
Text (50) |
|
|
StreetPostCode |
Text (10) |
|
|
StreetRegion |
Text (50) |
|
|
StreetState |
Text (30) |
|
|
StreetSuburb |
Text (50) |
|
|
SupplierStatus |
Numeric |
Same values as Customer Status |
|
SupplierStatusText |
Text (50) |
|
|
Tradename |
Text (100) |
|
|
WebAddress |
Text (100) |
|
|
|
|
|
|
Structure Fields |
|
Click here for more information |
|
Audit Fields |
|
Click here for more information |