Home > Technical > Table Definitions > CUSTOMER

CUSTOMER

Customers are used for membership and account details.

Column Type Description

LINTCUSTOMERNUM

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.

TRADUNIT.strTradeCode

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.

CUSTPOINTS.lintCustomerNum

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.

STATSPER.strYearWeek

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.

ACHDR.lintAccountCode

STLEDGERCODE

VARCHAR(10)

If a debit/credit card is used by this customer, this will contain the account code recording the transactions.

ACHDR.lintAccountCode

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.

CUSTOMERCATEGORY.strCode

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.

SALESFREIGHT.strFreightCode

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

CUSTOMER.lintCustomerNum

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)