![](/logotransparent.png)
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
- #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 bitsPossible 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