View Design fields: Loyalty & Gift Card (LG)

General tab

Loyalty/Gift Card data—General
Manager label:Available field:
IdID
TypeTYPE
StatusSTATUS
Card #CARDNUMBER
Security CodeSECURITYCODE
Open DateOPENEDDATE
Close DateCLOSEDDATE
CustomerCSNAME
Amounts LoadedAMOUNTLOADED
RedeemedAMOUNTREDEEMED
BalanceCURRENTAMOUNT
Points EarnedPOINTSEARNED
RedeemedPOINTSREDEEMED
BalanceCURRENTPOINTS

Available linked tables:

CSCustomer
LALoyalty/Gift Card Activity
PMPayment
TATransaction


Related topic:

View Design field names