bi_dimgiftcarduser
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centerid | varchar ( 36 ) | ||
closed | smallint | ||
closedby | varchar ( 36 ) | ||
closedon | timestamp without time zone | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
expirationdate | timestamp without time zone | ||
firstname | varchar ( 512 ) | ||
giftcardcode | The unique code of the gift or prepaid card used to make the payment. | varchar ( 512 ) | |
giftcardid | varchar ( 36 ) | ||
giftcardpurchaseprice | numeric | ||
giftcarduserid | varchar ( 36 ) | ||
giftcarduserwid | bigint | ||
giftcardvalue | numeric | ||
isgiftcard | boolean | ||
lastname | varchar ( 512 ) | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
purchasedate | timestamp without time zone | ||
salebyid | varchar ( 36 ) | ||
userid | varchar ( 36 ) | ||
void | smallint | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |