NameDescriptionTypeAdditional information
CustomerID

Primary key. Auto-incremented. database reference = customers.contactid

 integer

None.
Email

database reference = customers.email

 string

Required

String length: inclusive between 0 and 100
Password

database reference = customers.pass

 string

Required

String length: inclusive between 0 and 50
BillingCompany

database reference = customers.billing_company

 string

String length: inclusive between 0 and 255
BillingFirstName

database reference = customers.billing_firstname

 string

String length: inclusive between 0 and 50
BillingLastName

database reference = customers.billing_lastname

 string

String length: inclusive between 0 and 50
BillingAddress1

database reference = customers.billing_address

 string

String length: inclusive between 0 and 255
BillingAddress2

database reference = customers.billing_address2

 string

String length: inclusive between 0 and 50
BillingCity

database reference = customers.billing_city

 string

String length: inclusive between 0 and 100
BillingState

database reference = customers.billing_state

 string

String length: inclusive between 0 and 100
BillingZipCode

database reference = customers.billing_zip

 string

String length: inclusive between 0 and 20
BillingCountry

database reference = customers.billing_country

 string

String length: inclusive between 0 and 100
BillingPhoneNumber

database reference = customers.billing_phone

 string

String length: inclusive between 0 and 50
BillingTaxID

database reference = customers.accountno

 string

String length: inclusive between 0 and 50
ShippingCompany

database reference = customers.shipping_company

 string

String length: inclusive between 0 and 255
ShippingFirstName

database reference = customers.shipping_firstname

 string

String length: inclusive between 0 and 50
ShippingLastName

database reference = customers.shipping_lastname

 string

String length: inclusive between 0 and 50
ShippingAddress1

database reference = customers.shipping_address

 string

String length: inclusive between 0 and 255
ShippingAddress2

database reference = customers.shipping_address2

 string

String length: inclusive between 0 and 50
ShippingCity

database reference = customers.shipping_city

 string

String length: inclusive between 0 and 100
ShippingState

database reference = customers.shipping_state

 string

String length: inclusive between 0 and 100
ShippingZipCode

database reference = customers.shipping_zip

 string

String length: inclusive between 0 and 20
ShippingCountry

database reference = customers.shipping_country

 string

String length: inclusive between 0 and 100
ShippingPhoneNumber

database reference = customers.shipping_phone

 string

String length: inclusive between 0 and 50
ShippingAddressType

database reference = customers.oshipaddresstype

 integer

None.
CustomerGroupID

database reference = customers.discount

 integer

None.
Enabled

database reference = customers.custenabled

 boolean

None.
MailList

database reference = customers.maillist

 boolean

None.
NonTaxable

database reference = customers.type

 boolean

None.
DisableBillingSameAsShipping

boolean

None.
Comments

database reference = customers.comments

 string

String length: inclusive between 0 and 255
AdditionalField1

database reference = customers.additional_field1

 string

String length: inclusive between 0 and 250
AdditionalField2

database reference = customers.additional_field2

 string

String length: inclusive between 0 and 250
AdditionalField3

database reference = customers.additional_field3

 string

String length: inclusive between 0 and 150
TotalStoreCredit

computed column ==> sum(customer_credit.credit) of all records

 decimal number

None.
ResetPassword

database reference = customers.reset_pass

 boolean

None.