Customers Database Table

Distrbuted Access: Lanes( read insert edit CanSync Edits-require-TUBT )

Fields

cid

#100, Datatype: Integer
Unique number assigned to this customer record. Negative numbers may be subject to automatic renumbering. Zero is never used.

physkey

#254, Datatype: String 44 bytes
Unique primary key assigned to this record.

name

#101, Datatype: String 120 bytes
The customers full name. This field is typically used on reports. If left blank the system will populate it based on other fields

lastname

#102 The last name of the customer.

firstname

#103 The customers first (christian) name.

address1

#104 Line 1 of the customer primary address

Address2

#105 Line 2 of the customer primary address

Address3

#106 Line 3 of the customer primary address

Address4

#107 Line 4 of the customer primary address

Address5

#108 Line 5 of the customer primary address

Address6

#109 Line 6 of the customer primary address

city

#110 Primary city or town this customer resides in. This value is expected to also be present in the AddressN fields and is extracted to aid reporting

postcode

#111 Post code for this customer. This value is expected to also be present in the AddressN fields if relevant and is extracted to aid reporting

phone

#112 Customer primary phone number

mobile

#113 Customers mobile phone number

fax

#114 Customers fax number

email

#115 Customers primary email address

contactcomment

#116 A comment relating to communication with this customer. Designed to say things like 'Do not call after 6pm'

birthday

#117 Customers birthday. This can be either a precise date or a DD/MM pair. Used to trigger Point Of Sale messages on this aniversary

credit_limit

#122 Total credit limit for this customer. Typically customers belong to an account and the account provides the credit limit

floor_limit

#123 Maximum single transaction for this customer.

rid

#127 Internal use only.

customercard

#131 A unique barcode sequence assigned to this customer alone. This field should contain the complete barcode

accid

#132 Account number this customer belongs too. Zero if customer does not have a charge account.

priceband

#136 Price band assigned to this customer if they have a specific pricing structure

receiptformat

#137 If this customer is to use a specific receipt format, this field contains the name of the format to override system defaults

custflags

#138

ridutc

#140 Internal use only.

handness

#143 Is customer left or right handed

flybuy

#145 Customers Flybuys number.

applicationnumber

#147 Serial number from an application form. Used when customers complete an application or similar. Provides a reference back to the original document.

createdt

#152, Datatype: DateTime
Date this customer was created in the system.

phone2

#153 Secondary phone number of customer

companyname

#154, Datatype: String 60 bytes
Company name for this customer

keywords

#155 A comma or pipe seperated list of keywords assigned to this customer. Keywords and meanings are free for sites to assign.

store

#156 Store that originally created this customer

createtid

#157 Teller that created this customer record.

ReferredBy

#161 Referred By

CustomerRep

#162

comments

#163, Datatype: String 132 bytes

assigneddivision

#164

State

#166, Datatype: String 40 bytes
State/Province for address

iflags

#167, Datatype: Integer
Internal flags and status bits

Possible Values

Value	Description
1	ContactDetail records exist

MarketingOptIn

#210

EUCitizen

#211

RecordType

#212

MarketingFlags

#213

StaffMember

#214, Datatype: Integer

Job Title

#215, Datatype: String 32 bytes

Occupation

#216, Datatype: String 40 bytes

assignedstore

#217, Datatype: Integer

JobStatus

#218, Datatype: Integer

editdtu

#219, Datatype: DateTime
Date/time UTC this record was last changed

geolatitude

#220, Datatype: Double
Customers primary Geographic latitude

geolongitude

#221, Datatype: Double
Customers primary Geographic longitude

geoaltitude

#222, Datatype: Double
Customers primary Geographic altitude

rve

#223, Datatype: Double

rvel

#224, Datatype: Double

contactinterval

#225, Datatype: Integer
Defines the number of days that can elapse before contact is made to this customer

crmflags

#226, Datatype: Integer

Possible Values

Value	Description
1	Sale counts as contact

lastcontactdt

#227, Datatype: DateTime
Date/time (local) this customer was last contacted.

OccupationFreeForm

#300, Datatype: String 60 bytes

OccupationANZSCO

#301, Datatype: Integer

SellingMessage

#302, Datatype: String 250 bytes
Simple text message displayed on screen when customer selected at Point Of Sale

emailtransactions

#303, Datatype: String 100 bytes
Customers email address for transaction information

emailmarketing

#304, Datatype: String 100 bytes
Customers email address for marketing

emailgeneral

#305, Datatype: String 100 bytes
Customers email address for general communication

abn

#306, Datatype: String 15 bytes
Australian ABN number

gst

#307, Datatype: String 24 bytes
GST number

nzbn

#308, Datatype: String 15 bytes
New Zealand NZBN Number

Replacementphyskey

#309, Datatype: String 44 bytes
Replacement Physkey of new customer when a customer is reassigned or merged

istate

#311, Datatype: Integer
Internal use only state flags

idate

#312, Datatype: DateTime
Internal use only

deletedt

#313, Datatype: DateTime
Date this customer was deleteed in the system.

externalid

#314, Datatype: String 64 bytes
A site specific external Id, used when a link to another systems id is required

myob_contactid

#315, Datatype: String 50 bytes

addressraw

#501, Datatype: String 250 bytes
Complete multi line address

CreateAccount

#888 Request a new account be created for this customer

ocid

#899 Original cid allocated when created in distributed environment

stopcreditflag

#4000 Set to true if this customer is on stop credit.

u_invoicefrequency

#5000

u_paymentcard

#5001

u_allcredit

#5002

urucreg

#5003

prepay

#5004

accountstatus

#5005