View Design fields: Transaction (TA)

General tab

Transaction data—General
Manager label:Available field:
IdID
Date CreatedDATECREATED
LabelLABEL
Time CreatedTIMECREATED
Transaction Id of CreditTRANSACTIONIDREF
TypeTYPE
SubtypeSUBTYPE
BillingBILLINGTYPE
First NameINVOICEFIRSTNAME
Last NameINVOICELASTNAME
Name
Customer TypeCSTYPE
POS StatusSTATUS
Payment DateTRANSACTIONDATE
Payment StatusSTATUS1
Delivery EmailSTATUS9
Shipping StatusSTATUS2
Gift Email/PrintingSTATUS7
Transferred to AccountingSTATUS3
Checkout PendingSTATUS10
Email/PrintingSTATUS4
CompliantSTATUS6
Checked for ComplianceSTATUS5
Sales Representative NameREPNAME
CheckoutCHECKOUTREPNAME
Pickup SignatureSIGNATUREFIRSTNAME
MerchantORGANIZATIONNAME
Pickup DateSHIPDATE
External RefPONUM
Template NameTEMPLATENAME
POS Station OpenPOSSTATION
POS Station ClosePOSSTATIONCLOSE

Sales Order tab

Transaction data—Sales Order
Manager label:Available field:
Customer
FirstSHIPFIRSTNAME
LastSHIPLASTNAME
NameSHIPPERSONNAME
Pickup LocationPICKUPLOCATION
CompanySHIPCOMPANYNAME
Address 1SHIPADDRESS1
Address 2SHIPADDRESS2
Residential Address
Email Notification
Hold at FedEx Location
CitySHIPCITY
StateSHIPSTATE
ZIPSHIPPOSTALCODE
PhoneSHIPPHONE
BirthSHIPBIRTHDATE
EmailEMAILADDRESS
Distance

Transaction data—Sales Order

Ship DateSHIPDATE
Ship ViaSHIPVIA
Ship TypeSHIPTYPE
PackagesNUMOFPACKAGES
Discount RateDISCOUNTRATE
DiscountDISCOUNTAMOUNT
Sales Tax RateSALESTAXRATE
Actual Shipping ChargeACTUALSHIPPINGCHARGE
Item CountTOTALITEMCOUNT
Product TotalSUBAMOUNT
Selling PriceSELLINGPRICE
Sales TaxSALESTAX
S & HSHIPPINGNHANDLING
TotalAMOUNT

Invoice tab

Transaction data—Invoice
Manager label:Available field:
First NameINVOICEFIRSTNAME
Last NameINVOICELASTNAME
NameCUSTOMERNAME
CompanyINVOICECOMPANYNAME
Address 1INVOICEADDRESS1
Address 2INVOICEADDRESS2
CityINVOICECITY
StateINVOICESTATE
ZIPINVOICEPOSTALCODE
PhoneINVOICEPHONE
EmailINVOICEEMAILADDR
License NumberLICENSENUMBER
License StateLICENSESTATE
Payment MethodPAYMENTMETHOD
TermsTERMS
Due DateDUEDATE
Invoice #DOCUMENTNUM
Cash Drawer IdCASHDRAWERID
State Tax NameSTATETAXNAME
State Tax CodeSTATETAXCODE
QuickBooks StatusQUICKBOOKSSTATUS
QuickBooks Transfer DifferenceQUICKBOOKSDIFFERENCE
Ship MethodBILLSHIPPINGTO
FOB CommentsFOB
LatitudeLATITUDE
LongitudeLONGITUDE
Weather ForecastNOAADAY(1–7)

Payment tab

Transaction data—Credit Card
Manager label:Available field:
PaymentPAYMENTMETHOD
Payment Count
TypeCREDITCARDTYPE
MonthEXPIRATIONMONTH
YearEXPIRATIONYEAR
Card NumberCREDITCARDNUM
TokenizedTOKENIZEDCREDITCARD
Vault IdVAULTID
AVS First NameCUSTOMERFIRSTNAME
Last NameCUSTOMERLASTNAME
AddressAVSADDRESS
CityAVSCITY
StateAVSSTATE
ZIPAVSPOSTALCODE
AVS ResponseAVSRESPONSE
MethodPMMETHOD
StatusPMSTATUS
AmountPMAMOUNT
TipTIP
IdTRANSACTIONID
TypeTRANSACTIONTYPE
DateTRANSACTIONDATE
TimePMTRANSACTIONTIME
DescriptionTRANSACTIONDESC
CodeAUTHORIZATIONCODE
DataAUTHORIZATIONDATA
Payment Id of Credit

Notes tab

Manager label:Available field:
Notes
Is Gift
Special Instructions

Promos/Discounts tab

Transaction data—Credit Card
Manager label:Available field:
Promo Code 1SOURCECODE
Promo Code 2SOURCECODE2
POS PromoPOSPROMOCODE
Discounts ReasonPOSDISCOUNTREASON
AmountPOSDISCOUNTAMOUNT
OverridePOSOVERRIDEDISCOUNT
Shipping & Handling PromoPOSSHIPPROMOCODE
OverridePOSSANDHOVERRIDE


Customer tab

Transaction data—Customer
Manager label:Available field:
IdCSID
LabelCSLABEL
TypeCSTYPE
SubtypeCSSUBTYPE
StatusCSSTATUS
AbbreviationCSABBREVIATION
Date CreatedCSCREATIONDATE
Last UpatedCSLASTUPDATED
NameCSNAME
Web UsernameCSWEBUSERNAME
Is GiftCSISGIFT
Web PasswordCSWEBPASSWORD
Address 1CSADDRESS1
Address 2CSADDRESS2
CityCSCITY
StateCSSTATE
ZIPCSPOSTALCODE
Home PhoneCSPHONE
Work PhoneCSPHONEALTERNATE
Cell PhoneCSCELL
Email AddressCSEMAILADDRESS
Ship MethodCSBILLSHIPPINGTO
Special Ship DiscountCSSHIPDISCOUNT
Special DiscountCSDISCOUNT
Ship TypeCSSHIPTYPE
Ship ViaCSSHIPVIA
Loyalty Card
Points Earned
Available Points
Points Redeemed

Membership tab

Manager label:Available field:
Csgroup(1–10)CSGROUP(1–10)
TypeCSGROUP(1–10)TYPE
Member SinceCSGROUP(1–10)STARTDATE
ExpirationCSGROUP(1–10)DATE

Compliance tab

Transaction data—Compliance
Manager label:Available field:
DescriptionSRDESCRIPTION
CompliantSRISCOMPLIANT
DateSRREPORTDATE
TimeSRREPORTTIME
Rule TypeSRRULETYPE
License RelationshipSRLICENSERELATIONSHIP
Rule DescriptionSRRULEDESCRIPTION
TypeSRCOMPLIANCEDETAILTYPE
ValueSRCOMPLIANCEDETAILVALUE
Volume Limit TypeSRVOLUMELIMITTYPE
Time Frame CountSRAGGVOLLIMITTIMEFRAMECOUN
Time Frame TypeSRAGGVOLLIMITTIMEFRAMETYPE
Volume CountSRAGGVOLLIMITVOLUMECOUNT
Time Frame UnitSRAGGVOLLIMITTIMEFRAMEUNIT
Unit of MeasureSRAGGVOLLIMITUNITOFMEASURE
Per Shipment Volume CountSRPERSHIPVOLLIMITVOLCOUNT
Per Shipment Volume LimitSRPERSHIPVOLLIMITVOLUNIT
Per Bottle Volume CountSRPERBOTTLEVOLLIMITVOLCOUNT
Per Bottle Volume LimitSRPERBOTTLEVOLLIMITVOLUNIT

Available linked tables:

CACash Drawer
CCClock In/Clock Out
CLCustomer Selection
CSCustomer
ETEmail Event Tracking
IAInventory Stock
ILInventory Location
INInventory
JSJob Schedule
LALoyalty/Gift Card Activity
LGLoyalty/Gift Card
PE
PKPackage
PMPayment
SRShipCompliant
TC
TITransaction Item
TPTrack Package
TY
WL


Related topic:

View Design field names