Enums represent possible sets of values for a field.
Also called Enums, enumeration types are a special kind of scalar that is restricted to a particular set of allowed values. This allows you to:
- validate that any arguments of this type are one of the allowed values, and
- communicate through the type system that a field will always be one of a finite set of values. Learn more.
AdjustmentTypeEnum
Values
COMP
VOID
REFUND
OPEN_REFUND
ORDER_RULE_REFUND
CategoriesOrderBy
Methods to use when ordering Category.
Values
NATURAL
CATEGORY_ID_ASC
CATEGORY_ID_DESC
NAME_ASC
NAME_DESC
X_CATEGORY_ID_ASC
X_CATEGORY_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
DISCLAIMER_ASC
DISCLAIMER_DESC
ARCHIVED_ASC
ARCHIVED_DESC
TAX_RATE_ID_ASC
TAX_RATE_ID_DESC
IMAGES_ASC
IMAGES_DESC
IMAGE_ENABLED_TIMESTAMP_ASC
IMAGE_ENABLED_TIMESTAMP_DESC
POS_COLOR_ASC
POS_COLOR_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
EmployeesOrderBy
Methods to use when ordering Employee.
Values
NATURAL
USER_ID_ASC
USER_ID_DESC
NAME_ASC
NAME_DESC
DISPLAY_NAME_ASC
DISPLAY_NAME_DESC
VERIFIED_ASC
VERIFIED_DESC
LOCATION_UUID_ASC
LOCATION_UUID_DESC
ARCHIVED_ASC
ARCHIVED_DESC
GuestsOrderBy
Methods to use when ordering Guest.
Values
NATURAL
NAME_ASC
NAME_DESC
LOCATION_UUID_ASC
LOCATION_UUID_DESC
TAB_UUID_ASC
TAB_UUID_DESC
FEEDBACK_ASC
FEEDBACK_DESC
HANDLE_ASC
HANDLE_DESC
ImpactsAvailabilityType
Values
EIGHTYSIX
DISABLE
IncludeArchivedOption
Indicates whether archived items should be included in the results or not.
| Values | Description |
|---|---|
| NO | Exclude archived items. |
| YES | Include archived items. |
| EXCLUSIVELY | Only include archived items (i.e. exclude non-archived items). |
| INHERIT | If there is a parent GraphQL record and it is archived then this is equivalent to YES, in all other cases this is equivalent to NO. |
InventoriesOrderBy
Methods to use when ordering Inventory.
Values
NATURAL
INVENTORY_ID_ASC
INVENTORY_ID_DESC
NAME_ASC
NAME_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
CREATED_ASC
CREATED_DESC
ARCHIVED_ASC
ARCHIVED_DESC
KEY_ASC
KEY_DESC
TYPE_ASC
TYPE_DESC
UNITS_ASC
UNITS_DESC
IMPACTS_AVAILABILITY_ASC
IMPACTS_AVAILABILITY_DESC
DETACHED_ASC
DETACHED_DESC
TRACKED_ASC
TRACKED_DESC
INVENTORY_LEVEL_ASC
INVENTORY_LEVEL_DESC
STOCK_LEVEL_ASC
STOCK_LEVEL_DESC
PAR_LEVEL_ASC
PAR_LEVEL_DESC
RESERVED_QUANTITY_ASC
RESERVED_QUANTITY_DESC
IDEAL_RESERVED_QUANTITY_ASC
IDEAL_RESERVED_QUANTITY_DESC
LOW_LEVEL_COMPONENTS_ASC
LOW_LEVEL_COMPONENTS_DESC
NEXT_LEVEL_COMPONENTS_ASC
NEXT_LEVEL_COMPONENTS_DESC
INSTRUCTION_COMPONENTS_ASC
INSTRUCTION_COMPONENTS_DESC
PATH_COMPONENTS_ASC
PATH_COMPONENTS_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
InventoryType
Values
PRODUCT
OPTION
COMPONENT
InventoryUnits
Values
COUNT
OZ
LB
KG
G
FLOZ_
LITRE
ML
GAL
QT
PINT
CASE
DRYPT
ItemAdjustmentsOrderBy
Methods to use when ordering ItemAdjustment.
Values
NATURAL
ITEM_ADJUSTMENT_ID_ASC
ITEM_ADJUSTMENT_ID_DESC
TAB_ID_ASC
TAB_ID_DESC
PAYMENT_ID_ASC
PAYMENT_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
PARENT_ITEM_ID_ASC
PARENT_ITEM_ID_DESC
QUANTITY_ASC
QUANTITY_DESC
CREATED_ASC
CREATED_DESC
FISCAL_DAY_ASC
FISCAL_DAY_DESC
PRODUCT_ID_ASC
PRODUCT_ID_DESC
UNIT_PRICE_ASC
UNIT_PRICE_DESC
ADJUSTMENT_TYPE_ASC
ADJUSTMENT_TYPE_DESC
ADJUSTMENT_REASON_ASC
ADJUSTMENT_REASON_DESC
X_ITEM_ID_ASC
X_ITEM_ID_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
ItemStatus
Values
OPEN
PARTIALED
PREPARED
DISPATCHED
VOIDED
COMPED
ItemsOrderBy
Methods to use when ordering Item.
Values
NATURAL
ITEM_ID_ASC
ITEM_ID_DESC
TAB_ID_ASC
TAB_ID_DESC
NAME_ASC
NAME_DESC
QUANTITY_ASC
QUANTITY_DESC
CREATED_ASC
CREATED_DESC
UPDATED_ASC
UPDATED_DESC
PRODUCT_ID_ASC
PRODUCT_ID_DESC
UNIT_PRICE_ASC
UNIT_PRICE_DESC
TAX_RATE_ASC
TAX_RATE_DESC
EXTERNAL_ITEM_ID_ASC
EXTERNAL_ITEM_ID_DESC
TAX_RATE_DETAIL_ASC
TAX_RATE_DETAIL_DESC
STATUS_ASC
STATUS_DESC
PARENT_ITEM_ID_ASC
PARENT_ITEM_ID_DESC
ORDER_RULE_ID_ASC
ORDER_RULE_ID_DESC
SKU_ASC
SKU_DESC
REMOVED_ASC
REMOVED_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
LocationType
Values
RESTAURANT
BREWERY
RESTAURANT_AND_BREWERY
WINERY
BAR
MUSIC_VENUE
FOOD_TRUCK
CAFE
HOTEL
MARKET
GROCERY
DISTILLERY
RACE_TRACK
MULTI
LocationsOrderBy
Methods to use when ordering Location.
Values
NATURAL
LOCATION_ID_ASC
LOCATION_ID_DESC
NAME_ASC
NAME_DESC
LOCATION_UUID_ASC
LOCATION_UUID_DESC
TIMEZONE_ASC
TIMEZONE_DESC
ORDER_ENABLED_ASC
ORDER_ENABLED_DESC
URL_NAME_ASC
URL_NAME_DESC
AUTOGRAT_PERCENT_ASC
AUTOGRAT_PERCENT_DESC
TYPE_ASC
TYPE_DESC
ADDRESS_ASC
ADDRESS_DESC
DEFAULT_ROUTERS_ASC
DEFAULT_ROUTERS_DESC
KDS_CHAT_AVAILABLE_ASC
KDS_CHAT_AVAILABLE_DESC
THUMBNAIL_IMAGES_ASC
THUMBNAIL_IMAGES_DESC
REQUIRES_EXPLICIT_ACL_ASC
REQUIRES_EXPLICIT_ACL_DESC
CUSTOMER_RECEIPT_HEADER_ASC
CUSTOMER_RECEIPT_HEADER_DESC
CUSTOMER_RECEIPT_FOOTER_ASC
CUSTOMER_RECEIPT_FOOTER_DESC
PIN_LENGTH_ASC
PIN_LENGTH_DESC
AUTO_DISPATCH_PRINT_ON_ORDER_ASC
AUTO_DISPATCH_PRINT_ON_ORDER_DESC
AUTO_CLOCKOUT_POLICY_ASC
AUTO_CLOCKOUT_POLICY_DESC
ESTIMATED_FULFILLMENT_ENABLED_ASC
ESTIMATED_FULFILLMENT_ENABLED_DESC
NOTIFY_ON_CLOCKOUT_ASC
NOTIFY_ON_CLOCKOUT_DESC
TABS_REFUND_MODE_ENABLED_ASC
TABS_REFUND_MODE_ENABLED_DESC
OPEN_TAB_PREAUTH_INITIAL_ORDER_ASC
OPEN_TAB_PREAUTH_INITIAL_ORDER_DESC
OPEN_TAB_PREAUTH_PAYMENT_TERMINAL_ASC
OPEN_TAB_PREAUTH_PAYMENT_TERMINAL_DESC
READ_ONLY_ASC
READ_ONLY_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
MenusOrderBy
Methods to use when ordering Menu.
Values
NATURAL
MENU_ID_ASC
MENU_ID_DESC
URL_NAME_ASC
URL_NAME_DESC
NAME_ASC
NAME_DESC
DISPLAY_ORDER_ASC
DISPLAY_ORDER_DESC
LOCATION_UUID_ASC
LOCATION_UUID_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
MenuCategoriesOrderBy
Methods to use when ordering MenuCategory.
Values
NATURAL
MENU_CATEGORY_ID_ASC
MENU_CATEGORY_ID_DESC
LABEL_ASC
LABEL_DESC
DESCRIPTION_ASC
DESCRIPTION_DESC
MENU_ID_ASC
MENU_ID_DESC
CATEGORY_ID_ASC
CATEGORY_ID_DESC
DISPLAY_ORDER_ASC
DISPLAY_ORDER_DESC
LOCATION_UUID_ASC
LOCATION_UUID_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
OrderStatus
Values
PENDING
SCHEDULED
SENT
IN_TRANSIT
DELIVERED
OFFLINE_DELIVERED
RECALLED
VOIDED
RESET
OrdersOrderBy
Methods to use when ordering Order.
Values
NATURAL
ORDER_ID_ASC
ORDER_ID_DESC
TAB_ID_ASC
TAB_ID_DESC
CREATED_ASC
CREATED_DESC
STATUS_CHANGED_ASC
STATUS_CHANGED_DESC
STATUS_ASC
STATUS_DESC
NAME_ASC
NAME_DESC
DISPATCHED_ASC
DISPATCHED_DESC
SENT_ASC
SENT_DESC
PREPARED_ASC
PREPARED_DESC
RECALLED_ASC
RECALLED_DESC
SCHEDULED_ASC
SCHEDULED_DESC
PLACED_ASC
PLACED_DESC
FISCAL_DAY_ASC
FISCAL_DAY_DESC
ORDER_PREP_TIME_MS_ASC
ORDER_PREP_TIME_MS_DESC
ORDER_UUID_ASC
ORDER_UUID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
IS_ASAP_ASC
IS_ASAP_DESC
AUTOGRAT_TAX_RATE_DETAIL_ASC
AUTOGRAT_TAX_RATE_DETAIL_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
PaymentsOrderBy
Methods to use when ordering Payment.
Values
NATURAL
PAYMENT_ID_ASC
PAYMENT_ID_DESC
TAB_ID_ASC
TAB_ID_DESC
AMOUNT_ASC
AMOUNT_DESC
TIP_AMOUNT_ASC
TIP_AMOUNT_DESC
NAME_ASC
NAME_DESC
CREATED_ASC
CREATED_DESC
PAYMENT_TYPE_ASC
PAYMENT_TYPE_DESC
X_PAYMENT_ID_ASC
X_PAYMENT_ID_DESC
PAYMENT_SOURCE_ASC
PAYMENT_SOURCE_DESC
LAST4_ASC
LAST4_DESC
STATUS_ASC
STATUS_DESC
AUTH_AMOUNT_ASC
AUTH_AMOUNT_DESC
AUTH_TIP_AMOUNT_ASC
AUTH_TIP_AMOUNT_DESC
AUTOGRAT_ASC
AUTOGRAT_DESC
CUSTOMER_FEE_ASC
CUSTOMER_FEE_DESC
PARENT_PAYMENT_ID_ASC
PARENT_PAYMENT_ID_DESC
AUTH_AUTOGRAT_ASC
AUTH_AUTOGRAT_DESC
TAX_ASC
TAX_DESC
AUTH_TAX_ASC
AUTH_TAX_DESC
COMP_ASC
COMP_DESC
AUTH_COMP_ASC
AUTH_COMP_DESC
SUBTOTAL_ASC
SUBTOTAL_DESC
AUTH_SUBTOTAL_ASC
AUTH_SUBTOTAL_DESC
ZIP_ASC
ZIP_DESC
PREAUTH_AMOUNT_ASC
PREAUTH_AMOUNT_DESC
FISCAL_DAY_ASC
FISCAL_DAY_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
TOKENIZED_PAYMENT_METHOD_ASC
TOKENIZED_PAYMENT_METHOD_DESC
PAYMENT_MODE_ASC
PAYMENT_MODE_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
ProductModifierType
Values
CHECKBOX
RADIO
SELECT
TEXTAREA
TOGGLE
MULTI
SINGLE
CUSTOM
ProductType
Values
DEFAULT
ORDER_RULE
REFUND
DELIVERY_FEE
CUSTOM
OPEN
ProductsOrderBy
Methods to use when ordering Product.
Values
NATURAL
PRODUCT_ID_ASC
PRODUCT_ID_DESC
CATEGORY_ID_ASC
CATEGORY_ID_DESC
X_PRODUCT_ID_ASC
X_PRODUCT_ID_DESC
NAME_ASC
NAME_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
CREATED_ASC
CREATED_DESC
BASE_PRICE_ASC
BASE_PRICE_DESC
DESCRIPTION_ASC
DESCRIPTION_DESC
ROUTER_IDS_ASC
ROUTER_IDS_DESC
ORDER_ENABLED_ASC
ORDER_ENABLED_DESC
ARCHIVED_ASC
ARCHIVED_DESC
OPTIONS_ASC
OPTIONS_DESC
TAX_RATE_ID_ASC
TAX_RATE_ID_DESC
DISPLAY_PRICE_ASC
DISPLAY_PRICE_DESC
PREP_TIME_ASC
PREP_TIME_DESC
SHORT_NAME_ASC
SHORT_NAME_DESC
ENABLE_TIMESTAMP_ASC
ENABLE_TIMESTAMP_DESC
PRODUCT_UUID_ASC
PRODUCT_UUID_DESC
PRODUCT_TYPE_ASC
PRODUCT_TYPE_DESC
IMAGES_ASC
IMAGES_DESC
ORDER_LIMIT_ASC
ORDER_LIMIT_DESC
VIDEO_URL_ASC
VIDEO_URL_DESC
VIDEO_ENABLED_ASC
VIDEO_ENABLED_DESC
ACCOUNT_PROCESSOR_ID_ASC
ACCOUNT_PROCESSOR_ID_DESC
SHOW_PREP_TIME_ASC
SHOW_PREP_TIME_DESC
POS_COLOR_ASC
POS_COLOR_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
SpotsOrderBy
Methods to use when ordering Spot.
Values
NATURAL
SPOT_ID_ASC
SPOT_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
NAME_ASC
NAME_DESC
ARCHIVED_ASC
ARCHIVED_DESC
ZONE_ID_ASC
ZONE_ID_DESC
URL_NAME_ASC
URL_NAME_DESC
SPOT_UUID_ASC
SPOT_UUID_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
TabMode
Values
DEFAULT
REFUND
TabsOrderBy
Methods to use when ordering Tab.
Values
NATURAL
TAB_ID_ASC
TAB_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
TAB_UUID_ASC
TAB_UUID_DESC
NAME_ASC
NAME_DESC
TOTAL_ASC
TOTAL_DESC
SUBTOTAL_ASC
SUBTOTAL_DESC
TAX_ASC
TAX_DESC
CREATED_ASC
CREATED_DESC
STATUS_ASC
STATUS_DESC
OPENED_ASC
OPENED_DESC
FISCAL_DAY_ASC
FISCAL_DAY_DESC
EXTERNAL_TAB_ID_ASC
EXTERNAL_TAB_ID_DESC
AUTOGRAT_ASC
AUTOGRAT_DESC
BALANCE_DUE_ASC
BALANCE_DUE_DESC
AUTOGRAT_DUE_ASC
AUTOGRAT_DUE_DESC
GOTAB_ORDER_ASC
GOTAB_ORDER_DESC
CUSTOMER_ID_ASC
CUSTOMER_ID_DESC
SEGMENT_IDS_ASC
SEGMENT_IDS_DESC
TAX_EXEMPTION_ID_ASC
TAX_EXEMPTION_ID_DESC
TAB_MODE_ASC
TAB_MODE_DESC
DISABLE_PRODUCT_TAGS_ASC
DISABLE_PRODUCT_TAGS_DESC
DISCOVERABLE_TO_ASC
DISCOVERABLE_TO_DESC
TIPPED_SUBTOTAL_ASC
TIPPED_SUBTOTAL_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
TaxRatesOrderBy
Methods to use when ordering TaxRate.
Values
NATURAL
TAX_RATE_ID_ASC
TAX_RATE_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
RATE_ASC
RATE_DESC
DETAIL_ASC
DETAIL_DESC
TAX_RATE_UUID_ASC
TAX_RATE_UUID_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
TaxesOrderBy
Values
NATURAL
TAX_ID_ASC
TAX_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
NAME_ASC
NAME_DESC
RATE_ASC
RATE_DESC
CREATED_ASC
CREATED_DESC
TAX_UUID_ASC
TAX_UUID_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
TimeEntriesOrderBy
Methods to use when ordering TimeEntry.
Values
NATURAL
TIME_ENTRY_ID_ASC
TIME_ENTRY_ID_DESC
TIME_SHIFT_ID_ASC
TIME_SHIFT_ID_DESC
TIME_PUNCH_ENTRY_UUID_ASC
TIME_PUNCH_ENTRY_UUID_DESC
PAID_DURATION_ASC
PAID_DURATION_DESC
UNPAID_DURATION_ASC
UNPAID_DURATION_DESC
TOTAL_DURATION_ASC
TOTAL_DURATION_DESC
PUNCH_IN_ASC
PUNCH_IN_DESC
PUNCH_OUT_ASC
PUNCH_OUT_DESC
TIME_PUNCH_TYPE_ID_ASC
TIME_PUNCH_TYPE_ID_DESC
CREATED_ASC
CREATED_DESC
ARCHIVED_ASC
ARCHIVED_DESC
USER_ID_ASC
USER_ID_DESC
USER_ROLE_ID_ASC
USER_ROLE_ID_DESC
FISCAL_DAY_ASC
FISCAL_DAY_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
RATE_ASC
RATE_DESC
AUTO_CLOSED_ASC
AUTO_CLOSED_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
TimePunchTypesOrderBy
Methods to use when ordering TimePunchType.
Values
NATURAL
TIME_PUNCH_TYPE_ID_ASC
TIME_PUNCH_TYPE_ID_DESC
TIME_PUNCH_TYPE_UUID_ASC
TIME_PUNCH_TYPE_UUID_DESC
TIME_PUNCH_TYPE_NAME_ASC
TIME_PUNCH_TYPE_NAME_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
IS_PAID_ASC
IS_PAID_DESC
IS_SHIFT_ASC
IS_SHIFT_DESC
CREATED_ASC
CREATED_DESC
ARCHIVED_ASC
ARCHIVED_DESC
MIN_DURATION_ASC
MIN_DURATION_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
TransferMode
Values
DEBIT
CREDIT
REVERSAL
TRANSFER
UserRolesOrderBy
Methods to use when ordering UserRole.
Values
NATURAL
USER_ROLE_ID_ASC
USER_ROLE_ID_DESC
USER_ROLE_UUID_ASC
USER_ROLE_UUID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
ROLE_NAME_ASC
ROLE_NAME_DESC
ACL_ASC
ACL_DESC
CREATED_ASC
CREATED_DESC
ARCHIVED_ASC
ARCHIVED_DESC
RATE_ASC
RATE_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC
VariantInventoriesOrderBy
Methods to use when ordering VariantInventory.
Values
NATURAL
INVENTORY_ID_ASC
INVENTORY_ID_DESC
NAME_ASC
NAME_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
CREATED_ASC
CREATED_DESC
ARCHIVED_ASC
ARCHIVED_DESC
SKU_ASC
SKU_DESC
TYPE_ASC
TYPE_DESC
INSTRUCTION_ID_ASC
INSTRUCTION_ID_DESC
UNITS_ASC
UNITS_DESC
IMPACTS_AVAILABILITY_ASC
IMPACTS_AVAILABILITY_DESC
DETACHED_ASC
DETACHED_DESC
TRACKED_ASC
TRACKED_DESC
INVENTORY_LEVEL_ASC
INVENTORY_LEVEL_DESC
STOCK_LEVEL_ASC
STOCK_LEVEL_DESC
PAR_LEVEL_ASC
PAR_LEVEL_DESC
RESERVED_QUANTITY_ASC
RESERVED_QUANTITY_DESC
IDEAL_RESERVED_QUANTITY_ASC
IDEAL_RESERVED_QUANTITY_DESC
LOW_LEVEL_COMPONENTS_ASC
LOW_LEVEL_COMPONENTS_DESC
NEXT_LEVEL_COMPONENTS_ASC
NEXT_LEVEL_COMPONENTS_DESC
INSTRUCTION_COMPONENTS_ASC
INSTRUCTION_COMPONENTS_DESC
PATH_COMPONENTS_ASC
PATH_COMPONENTS_DESC
PARENT_PRODUCT_ID_ASC
PARENT_PRODUCT_ID_DESC
PRICE_ASC
PRICE_DESC
ZoneType
Values
DINING
PICKUP
SCHEDULED
ZonesOrderBy
Methods to use when ordering Zone.
Values
NATURAL
ZONE_ID_ASC
ZONE_ID_DESC
LOCATION_ID_ASC
LOCATION_ID_DESC
NAME_ASC
NAME_DESC
CREATED_ASC
CREATED_DESC
REQUIRES_ADDRESS_ASC
REQUIRES_ADDRESS_DESC
TYPE_ASC
TYPE_DESC
ASAP_ORDERING_ENABLED_ASC
ASAP_ORDERING_ENABLED_DESC
REQUIRE_NAME_ON_SCAN_ASC
REQUIRE_NAME_ON_SCAN_DESC
SERVER_TABS_DISCOVERABLE_ASC
SERVER_TABS_DISCOVERABLE_DESC
ZONE_UUID_ASC
ZONE_UUID_DESC
AUTOGRAT_ID_ASC
AUTOGRAT_ID_DESC
OPEN_TAB_ONLY_ASC
OPEN_TAB_ONLY_DESC
DISPLAY_ORDER_ASC
DISPLAY_ORDER_DESC
PRIMARY_KEY_ASC
PRIMARY_KEY_DESC