View Design fields: Customer (CS)

General tab

Customer data—General
Manager label:Available field:Length
IdID15
AbbreviationABBREVIATION6
TypeTYPE15
LabelLABEL15
SubtypeSUBTYPE15
StatusSTATUS15
DateCREATIONDATE10
Last UpdatedLASTUPDATED10
Created ByCREATEDBY15
Time UpdatedTIMEUPDATED8
First NameFIRSTNAME40
MiddleMIDDLEINITIAL40
Last NameLASTNAME40
Full NameNAME50
Birth DateBIRTHDATE10
Birth MonthBIRTHMONTH20
Spouse NameSPOUSENAME40
Spouse Birth DateSPOUSEBIRTHDATE10
Gift Member
Prepaid Member
Wedding DateWEDDINGDATE10
Newsletter
DescriptionDESCRIPTION50
Driverʼs License #DRIVINGLICENCENO40
Lic. State[DRIVINGLICENCESTATE]15
StatusWEBUSERSTATUS15
Last UpdatedWEBUSERUPDATED10
UsernameWEBUSERNAME50
WEBUSERTIMEUPDATED8
PasswordWEBPASSWORD20

Membership tabs

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


Communications tab

Customer data—Communications
Manager label:Available field:Length:
Main PhonePHONE40
Alternate PhonePHONEALTERNATE40
FaxFAX40
Web AddressWEBADDRESS50
Email AddressEMAILADDRESS250
Email Opt InEMAILOPTIN15
Email PreferenceEMAILPREFERENCE15
Opt Out DateEMAILOPTOUTDATE10
Email Address GifteeEMAILADDRESS2250
Mailbox 1 StatusEMAILADDR1MAILBOXVAL15
Domain 1 StatusEMAILADDR1DOMAINVAL15
Mailbox 1 DataEMAILADDR1MAILBOX200
Domain 1 DataEMAILADDR1DOMAIN200
Mailbox 2 StatusEMAILADDR2MAILBOXVAL15
Domain 2 StatusEMAILADDR2DOMAINVAL15
Mailbox 2 DataEMAILADDR2MAILBOX200
Domain 2 DataEMAILADDR2DOMAIN200

Address tab

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


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

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
StatusSTATUS415
AVS ResponseAVSRESPONSE132

Notes tab

Manager label:Available field:Length:
Notes[NOTES]20000
POS NotesPOSNOTES5000


Source tab

Customer data—Source
Manager label:Available field:Length:
SourceSOURCE15
Gift DurationGIFTDURATION15
EmployeeSOURCEPERSONNAME50
Source Code 1SOURCECODE32
Source Code 2SOURCECODE232
DetailSOURCEDETAIL10000
AwardedSOURCEREWARD15
Date AwardedINCENTIVEAWARDDATE10


Accounting tab

Customer data—Accounting
Manager label:Available field:Length:
DiscountDISCOUNT8
TaxableTAXABLE15
Payment MethodPAYMENTMETHOD15
Payment TermsPAYMENTTERMS15
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

Marketing tab

Customer data—Marketing
Manager label:Available field:Length:
Attribute (1–10)ATTRIBUTE(1–10)15


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


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

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