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.