Home > Technical > Table Definitions > CUSTOMER
Customers are used for membership and account details.
Column | Type | Description |
INTEGER |
A unique number to identify the customer. This is assigned by the system. |
|
STRTITLE |
VARCHAR(10) |
Customer’s title, for example MR,MRS. |
STRFIRSTNAME |
VARCHAR(50) |
First name. |
STRINITIALS |
VARCHAR(5) |
Initials. |
STRLASTNAME |
VARCHAR(50) |
Last name. |
STRPREFERNAME |
VARCHAR(50) |
Customer’s preferred name. |
DTMBIRTHDAY |
DATE |
Customer’s birthday. |
DTMLASTVISIT |
DATE |
Date the customer last visited. |
DTMWHEN |
DATE |
When the customer was added to the computer. |
STRWHO |
VARCHAR(10) |
Who entered the customer into the computer. |
STRTRADECODE |
VARCHAR(5) |
The location which added the customer. |
LINTACCOUNTNUM |
INTEGER |
The customer to which the points will be assigned. This is normally the same value as lintCustomerNum. However, it the customer wanted to assign points to a charity, this would contain the charity’s customer number. |
STRADDR1 |
VARCHAR(50) |
Address details. |
STRADDR2 |
VARCHAR(50) |
Address details. |
STRCITY |
VARCHAR(50) |
Address details. |
STRSTATE |
VARCHAR(5) |
Address details. |
STRPOSTCODE |
VARCHAR(5) |
Address details. |
STRADDR1POST |
VARCHAR(50) |
Postal address details. |
STADDR2POST |
VARCHAR(50) |
Postal address details. |
STRCITYPOST |
VARCHAR(50) |
Postal address details. |
STRSTATEPOST |
VARCHAR(5) |
Postal address details. |
STRPOSTCODEPOST |
VARCHAR(5) |
Postal address details. |
STRPHONE |
VARCHAR(20) |
Phone number. |
STRFAX |
VARCHAR(20) |
Fax number. |
STRMOBILE |
VARCHAR(20) |
Mobile phone number. |
STREMAIL |
VARCHAR(60) |
Customer’s email address. |
YSNDELETED |
VARCHAR(1) |
‘T’ if the customer is no longer active. |
YSNNEW |
VARCHAR(1) |
‘T’ if a new customer. |
YSNCHANGED |
VARCHAR(1) |
‘T’ if customer details have changed. |
STRGENDER |
VARCHAR(1) |
Customer’s gender, for example M/F |
STRCUSTTYPE |
VARCHAR(5) |
The type of member. |
STRACTIVEFLAG |
VARCHAR(1) |
'A' if member is active, 'I' if the member is inactive (hasn't visited in the last 90 days). |
STRPERIODJOINED |
VARCHAR(7) |
The period the member joined. |
STRPOSCOMMENT |
VARCHAR(50) |
A comment which will appear on the POS when the card is scanned. |
MEMCOMMENTS |
BLOB SUBTYPE 1 |
A free-format comment about the member. |
STRACCOUNTCODE |
VARCHAR(20) |
If a debit/credit card is used by this customer, this will contain the account code recording the transactions. |
STLEDGERCODE |
VARCHAR(10) |
If a debit/credit card is used by this customer, this will contain the account code recording the transactions. |
STRWORKPHONE |
VARCHAR(20) |
The work phone number. |
STRPASSWORD |
VARCHAR(10) |
A password for the customer. This can be used when a customer attempts to get details, for example over the web. |
STREMPLOYMENT |
VARCHAR(50) |
The type of employment for the customer. |
STRCATEGORY1 |
VARCHAR(5) |
There are five categories a customer can be assigned to. These categories are definable by the user. |
STRCATEGORY2 |
VARCHAR(5) |
|
STRCATEGORY3 |
VARCHAR(5) |
|
STRCATEGORY4 |
VARCHAR(5) |
|
STRCATEGORY5 |
VARCHAR(5) |
|
YSNBADDEBT |
VARCHAR(1) |
T' if the customer is a bad debt, 'F' otherwise. |
INTCOUNT |
INT |
Used by one client to keep track off the number of periods the customer has been active. |
STRRECOMMENDEDBY |
VARCHAR(50) |
The name of the person who recommended this customer to us. |
STRGLACCOUNTCODE |
VARCHAR(20) |
This is used when exporting customer account transactions to a third party accounts system (see Accounts Interfacing). Usually when the account is exported, the customer number or name is used as the account code. However, if an accounts system is already set up with account numbers defined, those account numbers can be recorded in this field. When the data is exported, it will use this as the account code. |
STRTAXEXEMPT |
VARCHAR(20) |
If the customer is entitled to tax exempt sales then there tax exemption number should be recorded here. |
STRSALESFREIGHTCODE |
VARCHAR(5) |
The sales freight applicable to this customer. Used as part of the Wholesale Sales module. |
YSNASKFORPONUMBER |
VARCHAR(1) |
If 'T' then when a DynaPOS transaction for this customer is completed, the user will be asked for a reference number from the customer. If 'F' no reference number will be required. |
STRDRIVERSLICENCE |
VARCHAR(20) |
The customer's driver's licence number. |
DTMJOINED |
DATE |
The date the customer actually joined. |
STRTAXNUMBER1 |
VARCHAR(20) |
The tax number (ABN) for this customer. |
STRTAXNUMBER2 |
VARCHAR(20) |
The tax number (BRN) for this customer. |
YSNRECIPIENTINVOICE |
VARCHAR(1) |
'T' if this customer uses Recipient Created Tax Invoice. Usually 'F'. |
YSNMAILOUT |
VARCHAR(1) |
'T' if the customer will accept mail from us, 'F' otherwise. |
STRXREFCODE |
VARCHAR(20) |
If customer info comes from a third-party system, then this field can contain the code of the customer within that system. |
LINTRECOMMENDEDBY |
INTEGER |
The customer number of the customer that recommended this customer to us |
STRIDENTIFICATIONNUMBER |
VARCHAR(20) |
|
YSNNOTIFYUPGRADE |
VARCHAR(1) |
|
INTLOADTYPE |
INT |
|
STRAGREEMENTCODE |
VARCHAR(10) |
|
DTMAGREEMENTEXPIRY |
DATETIME |
|
YSNALLOWEDTOUSE |
VARCHAR(1) |
|
STRWEBSITE |
VARCHAR(100) |
|
MEMAGREEMENT |
TEXT |
|
STRREPLTRADECODE |
VARCHAR(10) |
|
DTMLASTUPGRADED |
DATETIME |
|
STRLASTUPGRADEKEY |
VARCHAR(38) |
|
STRCOUNTRY |
VARCHAR(50) |
|
STRCOUNTRYPOST |
VARCHAR(50) |
|
STRLICENCETYPEPAID |
VARCHAR(50) |
|
STRLICENCETRIALCODES |
VARCHAR(50) |
|
INTLICENCETILLS |
INT |
|
INTLICENCESTORES |
INT |
|
STRLICENCECOUNTRIES |
VARCHAR(100) |
|
YSNLICENCEPAID |
VARCHAR(1) |
|
STRRESPONSIBLEUSERCODE |
VARCHAR(20) |
|
MEMLICENCECOUNTRYNOTES |
TEXT |
|
YSNELECTRONICSTATEMENTS |
VARCHAR(1) |
Indicates if electronic account statements (paperless statements) are emailed to a customer. |
Primary Key: LINTCUSTOMERNUM
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |