View Design fields: Customer (CS)

General tab

Customer data—General
Manager label:Available field:Length
IdID15
Date CreatedCREATIONDATE10
TypeTYPE15
SubtypeSUBTYPE15
First NameFIRSTNAME40
Middle NameMIDDLEINITIAL40
Last NameLASTNAME40
Date of BirthBIRTHDATE10
Full NameNAME50
Spouse/Co-OwnerSPOUSENAME40
PhonePHONE40
Alternate PhonePHONEALTERNATE40
Company Name
Web AddressWEBADDRESS50
FaxFAX40
Email AddressEMAILADDRESS250
Notes[NOTES]20000
POS NotesPOSNOTES5000

Membership tabs

Customer data—Membership
Manager label:Available field:Length:
Prepaid
Gift Membership
StatusGROUP(1–3)15
TypeGROUP(1–3)TYPE25
Member SinceGROUP(1–3)STARTDATE10
ExpirationGROUP(1–3)DATE10
On Hold DateGROUP(1–3)SUSPENDDATE10
Restart DateGROUP(1–3)RESTARTDATE10
Cancellation Reason[GROUP(1–3)CANCELREASON]250


Mailing tab

Customer data—Mailing
Manager label:Available field:Length:
Address 1ADDRESS140
Address 2ADDRESS240
CityCITY40
StateSTATE40
ZIPPOSTALCODE40
CountryCOUNTRY50
DistanceDISTANCE16
LatitudeLATITUDE20
LongitudeLONGITUDE20
ValidatedSTATUS215
Validation InfoADDRESSVALMSG200


Billing/Credit Card tab

Customer data—Billing/Credit Card
Manager label:Available field:Length:
Card TypeCREDITCARDTYPE15
Credit Card NumberCREDITCARDNUM50
MonthEXPIRATIONMONTH7
YearEXPIRATIONYEAR7
First NameCUSTOMERFIRSTNAME40
Last NameCUSTOMERLASTNAME40
AddressAVSADDRESS50
CityAVSCITY50
StateAVSSTATE50
ZIPAVSPOSTALCODE50
Tokenized
Vault Id
AVS ResponseAVSRESPONSE132


Shipping tab

Customer data—Shipping
Manager label:Available field:Length:
Ship MethodBILLSHIPPINGTO15
Special Ship DiscountSHIPDISCOUNT8
Pickup LocationPICKUPLOCATION50
Address NameSANICKNAME50
Default
First NameSHIPFIRSTNAME40
Last NameSHIPLASTNAME40
Full NameSHIPPERSONNAME50
Company NameSHIPCOMPANYNAME50
Address 1SHIPADDRESS140
Address 2SHIPADDRESS240
CitySHIPCITY40
State[SHIPSTATE]40
ZIPSHIPPOSTALCODE40
CountrySHIPCOUNTRY50
Birth DateSHIPBIRTHDATE10
Phone on LabelSHIPPHONE40
Hold at FedEx Location
Email Tracking Info to Customer from Carrier with Shipments
Residential Address[RESIDENTIALADDRESS15
Ship ViaSHIPVIA15
Fixed S&H FeeSHIPNHANDLINGFEE16
Ship TypeSHIPTYPE15
S&H MethodSHIPNHANDLINGTYPE15
ValidatedSTATUS315
Validation InfoSHIPADDRESSVALMSG200


Giftee tab

Customer data—Giftee

Manager label:Available field:Length:
Company NameCOMPANYNAME50
Email Address GifteeEMAILADDRESS2250
Gift MessageGIFTNOTES5000


Source tab

Customer data—Source
Manager label:Available field:Length:
Last UpdatedLASTUPDATED10
Time UpdatedTIMEUPDATED8
SourceSOURCE15
Created ByCREATEDBY15
EmployeeSOURCEPERSONNAME50
Source Code 1SOURCECODE32
Source Code 2SOURCECODE232
DetailSOURCEDETAIL10000
AwardedSOURCEREWARD15
Date AwardedINCENTIVEAWARDDATE10
StatusWEBUSERSTATUS15
Last UpdatedWEBUSERUPDATED10
UsernameWEBUSERNAME50
Time UpdatedWEBUSERTIMEUPDATED8
PasswordWEBPASSWORD20


Marketing tab

Customer data—Marketing
Manager label:Available field:Length:
Newsletter
Email Opt InEMAILOPTIN15
Opt Out DateEMAILOPTOUTDATE10
Domain 1 StatusEMAILADDR1DOMAINVAL15
Domain 1 DataEMAILADDR1DOMAIN200
Domain 2 StatusEMAILADDR2DOMAINVAL15
Domain 2 DataEMAILADDR2DOMAIN200
Customer Birth MonthBIRTHMONTH20
Wedding DateWEDDINGDATE10
Spouse/Co-Owner DOBSPOUSEBIRTHDATE10
AbbreviationABBREVIATION6
LabelLABEL15
StatusSTATUS15
DescriptionDESCRIPTION50
Attribute (1–5)ATTRIBUTE(1–5)15
Attribute (6–10)ATTRIBUTE(6–10)15


Accounting tab

Customer data—Accounting
Manager label:Available field:Length:
DiscountDISCOUNT8
TaxableTAXABLE15
Driving Licence #DRIVINGLICENCENO40
License State[DRIVINGLICENCESTATE]15
WineSTATETAXWINE17
FreightSTATETAXFREIGHT17
SpiritsSTATETAXSPIRITS17
FoodSTATETAXFOOD17
MerchandiseSTATETAXMERCHANDISE17
HotelSTATETAXHOTEL17
State Tax CountySTATETAXNAME50
State Tax CodeSTATETAXCODE12
Customer Reference DateCUSTOMERREFDATE10
External Ref DateEXTERNALREFDATE10
External Ref TimeEXTERNALREFTIME8
External Ref 1EXTERNALREFERENCE20
External Ref 2EXTERNALPARENT50
Enter Customer NameLOYALTYCARDID12
Points EarnedLGPOINTSEARNED12
Available PointsLGCURRENTPOINTS12
Points RedeemedLGPOINTSREDEEMED12
Payment MethodPAYMENTMETHOD15
Payment TermsPAYMENTTERMS15

Statistics tab

Customer data—Statistics
Manager label:Available field:Length:
StatusNOTPICKEDUP15
Number Packages to PickupNUMBERPKGSFOB12
No. of PickupsNUMBERPKGSPICKEDUP12
No. ShippedNUMBERPKGSSHIPPED12
Smallest PurchaseSMALLESTPURCHASE16
Largest PurchaseLARGESTPURCHASE16
Retail SalesTOTALPRODUCT16
DiscountTOTALDISCOUNT16
Selling PriceTOTALSELLINGPRICE16
TaxesTOTALTAXES16
S & HTOTALSHIPNHANDLE16
TotalTOTALPRICE16
Product Buying History #1FIRSTINVNAME100
Product Buying History #2SECONDINVNAME100
Product Buying History #3THIRDINVNAME100
Product Buying History #4FOURTHINVNAME100
Product Buying History #5FIFTHINVNAME100
EarnedLGPOINTSEARNED12
RedeemedLGPOINTSREDEEMED12
BalanceLGCURRENTPOINTS12

Selection tab

Customer data—Selection
Manager label:Available field:
TypeTYPE
StatusSTATUS1
Date CreatedCLDATECREATED
Last UpdatedCLDATEMODIFIED
QuantityCLQUANTITY
Transaction IdCLTRANSACTIONID
View
Default Qty
Use this Selection Type when adding new Selections
Create from Inventory
Quantity
Total Order


Available linked tables:

CCClock In/Clock Out
CLCustomer Selection
ETEmail Event Tracking
IAInventory Stock
ILInventory Location
INInventory
JSJob Schedule
LALoyalty/Gift Card Activity
LGLoyalty/Gift Card
SA
TATransaction
TITransaction Item


Related topic:

View Design field names