| |
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 |