ZenotiHelp

Org Payment Option Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing the payment options configured for each organization, including payment type classification and display names. Populated from the organization's payment configuration.

Columns

Column Name Data Type Nullable Description
orgpaymentoptionwid BIGINT IDENTITY No Surrogate warehouse key for the organization payment option dimension
paymenttype VARCHAR(10) Yes Short code for the payment type (e.g., CC, Cash)
orgapaymentoptionid VARCHAR(36) Yes Natural unique identifier of the organization payment option
paymenttypedisplayname VARCHAR(65535) Yes User-facing display name of the payment type
void INTEGER Yes Soft-delete flag; non-zero means the record is logically deleted
paymentoptiontypeintid VARCHAR(100) Yes Internal integer identifier of the payment option type (stored as string)
paymentoptiontype VARCHAR(320) Yes Descriptive name of the payment option type category

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

orgpaymentoptionwid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Enumerator Values

Column Values
paymenttype 1 = Cash
2 = Card
3 = Check
4 = Custom
5 = Membership Credit
6 = Gift Card
7 = PPC (Pre-Paid Card)
8 = Loyalty Points
9 = Package Usage
10 = Membership Usage
11 = CashBack
paymentoptiontype Descriptive payment option category
Was this article helpful?
Your feedback helps us improve our documentation.