Square Field Reference


Fields

IDTypeNameDescriptionReport
bank_accounts__account_number_suffixTEXTbank_accounts.account_number_suffixbank_accounts.account_number_suffixbank_accounts
bank_accounts__account_typeTEXTbank_accounts.account_typebank_accounts.account_typebank_accounts
bank_accounts__bank_nameTEXTbank_accounts.bank_namebank_accounts.bank_namebank_accounts
bank_accounts__countryTEXTbank_accounts.countrybank_accounts.countrybank_accounts
bank_accounts__creditableBOOLEANbank_accounts.creditablebank_accounts.creditablebank_accounts
bank_accounts__currencyTEXTbank_accounts.currencybank_accounts.currencybank_accounts
bank_accounts__debitableBOOLEANbank_accounts.debitablebank_accounts.debitablebank_accounts
bank_accounts__holder_nameTEXTbank_accounts.holder_namebank_accounts.holder_namebank_accounts
bank_accounts__idTEXTbank_accounts.idbank_accounts.idbank_accounts
bank_accounts__location_idTEXTbank_accounts.location_idbank_accounts.location_idbank_accounts
bank_accounts__primary_bank_identification_numberTEXTbank_accounts.primary_bank_identification_numberbank_accounts.primary_bank_identification_numberbank_accounts
bank_accounts__statusTEXTbank_accounts.statusbank_accounts.statusbank_accounts
bank_accounts__versionNUMERICbank_accounts.versionbank_accounts.versionbank_accounts
cash_drawers__closed_atTIMESTAMPcash_drawers.closed_atcash_drawers.closed_atcash_drawers
cash_drawers__closed_cash_moneyOBJECTcash_drawers.closed_cash_moneycash_drawers.closed_cash_moneycash_drawers
cash_drawers__descriptionTEXTcash_drawers.descriptioncash_drawers.descriptioncash_drawers
cash_drawers__ended_atTIMESTAMPcash_drawers.ended_atcash_drawers.ended_atcash_drawers
cash_drawers__expected_cash_moneyOBJECTcash_drawers.expected_cash_moneycash_drawers.expected_cash_moneycash_drawers
cash_drawers__idTEXTcash_drawers.idcash_drawers.idcash_drawers
cash_drawers__opened_atTIMESTAMPcash_drawers.opened_atcash_drawers.opened_atcash_drawers
cash_drawers__opened_cash_moneyOBJECTcash_drawers.opened_cash_moneycash_drawers.opened_cash_moneycash_drawers
cash_drawers__stateTEXTcash_drawers.statecash_drawers.statecash_drawers
categories__category_dataOBJECTcategories.category_datacategories.category_datacategories
categories__idTEXTcategories.idcategories.idcategories
categories__is_deletedBOOLEANcategories.is_deletedcategories.is_deletedcategories
categories__present_at_all_locationsBOOLEANcategories.present_at_all_locationscategories.present_at_all_locationscategories
categories__typeTEXTcategories.typecategories.typecategories
categories__updated_atTIMESTAMPcategories.updated_atcategories.updated_atcategories
categories__versionNUMERICcategories.versioncategories.versioncategories
customers__addressOBJECTcustomers.addresscustomers.addresscustomers
customers__birthdayTEXTcustomers.birthdaycustomers.birthdaycustomers
customers__cardsOBJECTcustomers.cardscustomers.cardscustomers
customers__company_nameTEXTcustomers.company_namecustomers.company_namecustomers
customers__created_atTIMESTAMPcustomers.created_atcustomers.created_atcustomers
customers__creation_sourceTEXTcustomers.creation_sourcecustomers.creation_sourcecustomers
customers__email_addressTEXTcustomers.email_addresscustomers.email_addresscustomers
customers__family_nameTEXTcustomers.family_namecustomers.family_namecustomers
customers__given_nameTEXTcustomers.given_namecustomers.given_namecustomers
customers__group_idsOBJECTcustomers.group_idscustomers.group_idscustomers
customers__idTEXTcustomers.idcustomers.idcustomers
customers__phone_numberTEXTcustomers.phone_numbercustomers.phone_numbercustomers
customers__preferencesOBJECTcustomers.preferencescustomers.preferencescustomers
customers__reference_idTEXTcustomers.reference_idcustomers.reference_idcustomers
customers__segment_idsOBJECTcustomers.segment_idscustomers.segment_idscustomers
customers__updated_atTIMESTAMPcustomers.updated_atcustomers.updated_atcustomers
customers__versionNUMERICcustomers.versioncustomers.versioncustomers
datasourceTEXTData SourceThe name of the Windsor connector returning the row
discounts__discount_dataOBJECTdiscounts.discount_datadiscounts.discount_datadiscounts
discounts__idTEXTdiscounts.iddiscounts.iddiscounts
discounts__is_deletedBOOLEANdiscounts.is_deleteddiscounts.is_deleteddiscounts
discounts__present_at_all_locationsBOOLEANdiscounts.present_at_all_locationsdiscounts.present_at_all_locationsdiscounts
discounts__present_at_location_idsOBJECTdiscounts.present_at_location_idsdiscounts.present_at_location_idsdiscounts
discounts__typeTEXTdiscounts.typediscounts.typediscounts
discounts__updated_atTIMESTAMPdiscounts.updated_atdiscounts.updated_atdiscounts
discounts__versionNUMERICdiscounts.versiondiscounts.versiondiscounts
inventory__calculated_atTIMESTAMPinventory.calculated_atinventory.calculated_atinventory
inventory__catalog_object_idTEXTinventory.catalog_object_idinventory.catalog_object_idinventory
inventory__catalog_object_typeTEXTinventory.catalog_object_typeinventory.catalog_object_typeinventory
inventory__location_idTEXTinventory.location_idinventory.location_idinventory
inventory__quantityTEXTinventory.quantityinventory.quantityinventory
inventory__stateTEXTinventory.stateinventory.stateinventory
items__custom_attribute_valuesOBJECTitems.custom_attribute_valuesitems.custom_attribute_valuesitems
items__idTEXTitems.iditems.iditems
items__image_idTEXTitems.image_iditems.image_iditems
items__is_deletedBOOLEANitems.is_deleteditems.is_deleteditems
items__item_dataOBJECTitems.item_dataitems.item_dataitems
items__present_at_all_locationsBOOLEANitems.present_at_all_locationsitems.present_at_all_locationsitems
items__present_at_location_idsOBJECTitems.present_at_location_idsitems.present_at_location_idsitems
items__typeTEXTitems.typeitems.typeitems
items__updated_atTIMESTAMPitems.updated_atitems.updated_atitems
items__versionNUMERICitems.versionitems.versionitems
locations__addressOBJECTlocations.addresslocations.addresslocations
locations__business_emailTEXTlocations.business_emaillocations.business_emaillocations
locations__business_hoursOBJECTlocations.business_hourslocations.business_hourslocations
locations__business_nameTEXTlocations.business_namelocations.business_namelocations
locations__capabilitiesOBJECTlocations.capabilitieslocations.capabilitieslocations
locations__countryTEXTlocations.countrylocations.countrylocations
locations__created_atTIMESTAMPlocations.created_atlocations.created_atlocations
locations__currencyTEXTlocations.currencylocations.currencylocations
locations__descriptionTEXTlocations.descriptionlocations.descriptionlocations
locations__facebook_urlTEXTlocations.facebook_urllocations.facebook_urllocations
locations__idTEXTlocations.idlocations.idlocations
locations__instagram_usernameTEXTlocations.instagram_usernamelocations.instagram_usernamelocations
locations__language_codeTEXTlocations.language_codelocations.language_codelocations
locations__mccTEXTlocations.mcclocations.mcclocations
locations__merchant_idTEXTlocations.merchant_idlocations.merchant_idlocations
locations__nameTEXTlocations.namelocations.namelocations
locations__phone_numberTEXTlocations.phone_numberlocations.phone_numberlocations
locations__statusTEXTlocations.statuslocations.statuslocations
locations__timezoneTEXTlocations.timezonelocations.timezonelocations
locations__twitter_usernameTEXTlocations.twitter_usernamelocations.twitter_usernamelocations
locations__typeTEXTlocations.typelocations.typelocations
locations__website_urlTEXTlocations.website_urllocations.website_urllocations
loyalty__balanceNUMERICloyalty.balanceloyalty.balanceloyalty
loyalty__created_atTIMESTAMPloyalty.created_atloyalty.created_atloyalty
loyalty__customer_idTEXTloyalty.customer_idloyalty.customer_idloyalty
loyalty__idTEXTloyalty.idloyalty.idloyalty
loyalty__lifetime_pointsNUMERICloyalty.lifetime_pointsloyalty.lifetime_pointsloyalty
loyalty__mappingOBJECTloyalty.mappingloyalty.mappingloyalty
loyalty__program_idTEXTloyalty.program_idloyalty.program_idloyalty
loyalty__updated_atTIMESTAMPloyalty.updated_atloyalty.updated_atloyalty
modifier_list__idTEXTmodifier_list.idmodifier_list.idmodifier_list
modifier_list__is_deletedBOOLEANmodifier_list.is_deletedmodifier_list.is_deletedmodifier_list
modifier_list__modifier_list_dataOBJECTmodifier_list.modifier_list_datamodifier_list.modifier_list_datamodifier_list
modifier_list__present_at_all_locationsBOOLEANmodifier_list.present_at_all_locationsmodifier_list.present_at_all_locationsmodifier_list
modifier_list__typeTEXTmodifier_list.typemodifier_list.typemodifier_list
modifier_list__updated_atTIMESTAMPmodifier_list.updated_atmodifier_list.updated_atmodifier_list
modifier_list__versionNUMERICmodifier_list.versionmodifier_list.versionmodifier_list
orders__closed_atTIMESTAMPorders.closed_atorders.closed_atorders
orders__created_atTIMESTAMPorders.created_atorders.created_atorders
orders__customer_idTEXTorders.customer_idorders.customer_idorders
orders__discountsOBJECTorders.discountsorders.discountsorders
orders__fulfillmentsOBJECTorders.fulfillmentsorders.fulfillmentsorders
orders__idTEXTorders.idorders.idorders
orders__line_itemsOBJECTorders.line_itemsorders.line_itemsorders
orders__location_idTEXTorders.location_idorders.location_idorders
orders__net_amountsOBJECTorders.net_amountsorders.net_amountsorders
orders__refundsOBJECTorders.refundsorders.refundsorders
orders__return_amountsOBJECTorders.return_amountsorders.return_amountsorders
orders__returnsOBJECTorders.returnsorders.returnsorders
orders__service_chargesOBJECTorders.service_chargesorders.service_chargesorders
orders__sourceOBJECTorders.sourceorders.sourceorders
orders__stateTEXTorders.stateorders.stateorders
orders__taxesOBJECTorders.taxesorders.taxesorders
orders__tendersOBJECTorders.tendersorders.tendersorders
orders__total_discount_moneyOBJECTorders.total_discount_moneyorders.total_discount_moneyorders
orders__total_moneyOBJECTorders.total_moneyorders.total_moneyorders
orders__total_service_charge_moneyOBJECTorders.total_service_charge_moneyorders.total_service_charge_moneyorders
orders__total_tax_moneyOBJECTorders.total_tax_moneyorders.total_tax_moneyorders
orders__total_tip_moneyOBJECTorders.total_tip_moneyorders.total_tip_moneyorders
orders__updated_atTIMESTAMPorders.updated_atorders.updated_atorders
orders__versionNUMERICorders.versionorders.versionorders
payments__amount_moneyOBJECTpayments.amount_moneypayments.amount_moneypayments
payments__approved_moneyOBJECTpayments.approved_moneypayments.approved_moneypayments
payments__card_detailsOBJECTpayments.card_detailspayments.card_detailspayments
payments__created_atTIMESTAMPpayments.created_atpayments.created_atpayments
payments__customer_idTEXTpayments.customer_idpayments.customer_idpayments
payments__delay_actionTEXTpayments.delay_actionpayments.delay_actionpayments
payments__delay_durationTEXTpayments.delay_durationpayments.delay_durationpayments
payments__delayed_untilTEXTpayments.delayed_untilpayments.delayed_untilpayments
payments__employee_idTEXTpayments.employee_idpayments.employee_idpayments
payments__idTEXTpayments.idpayments.idpayments
payments__location_idTEXTpayments.location_idpayments.location_idpayments
payments__noteTEXTpayments.notepayments.notepayments
payments__order_idTEXTpayments.order_idpayments.order_idpayments
payments__processing_feeOBJECTpayments.processing_feepayments.processing_feepayments
payments__receipt_numberTEXTpayments.receipt_numberpayments.receipt_numberpayments
payments__receipt_urlTEXTpayments.receipt_urlpayments.receipt_urlpayments
payments__refund_idsOBJECTpayments.refund_idspayments.refund_idspayments
payments__refunded_moneyOBJECTpayments.refunded_moneypayments.refunded_moneypayments
payments__risk_evaluationOBJECTpayments.risk_evaluationpayments.risk_evaluationpayments
payments__source_typeTEXTpayments.source_typepayments.source_typepayments
payments__statusTEXTpayments.statuspayments.statuspayments
payments__total_moneyOBJECTpayments.total_moneypayments.total_moneypayments
payments__updated_atTIMESTAMPpayments.updated_atpayments.updated_atpayments
payments__version_tokenTEXTpayments.version_tokenpayments.version_tokenpayments
refunds__amount_moneyOBJECTrefunds.amount_moneyrefunds.amount_moneyrefunds
refunds__created_atTIMESTAMPrefunds.created_atrefunds.created_atrefunds
refunds__idTEXTrefunds.idrefunds.idrefunds
refunds__location_idTEXTrefunds.location_idrefunds.location_idrefunds
refunds__order_idTEXTrefunds.order_idrefunds.order_idrefunds
refunds__payment_idTEXTrefunds.payment_idrefunds.payment_idrefunds
refunds__processing_feeOBJECTrefunds.processing_feerefunds.processing_feerefunds
refunds__reasonTEXTrefunds.reasonrefunds.reasonrefunds
refunds__statusTEXTrefunds.statusrefunds.statusrefunds
refunds__updated_atTIMESTAMPrefunds.updated_atrefunds.updated_atrefunds
shifts__breaksOBJECTshifts.breaksshifts.breaksshifts
shifts__created_atTIMESTAMPshifts.created_atshifts.created_atshifts
shifts__employee_idTEXTshifts.employee_idshifts.employee_idshifts
shifts__end_atTIMESTAMPshifts.end_atshifts.end_atshifts
shifts__idTEXTshifts.idshifts.idshifts
shifts__location_idTEXTshifts.location_idshifts.location_idshifts
shifts__start_atTIMESTAMPshifts.start_atshifts.start_atshifts
shifts__statusTEXTshifts.statusshifts.statusshifts
shifts__team_member_idTEXTshifts.team_member_idshifts.team_member_idshifts
shifts__timezoneTEXTshifts.timezoneshifts.timezoneshifts
shifts__updated_atTIMESTAMPshifts.updated_atshifts.updated_atshifts
shifts__versionNUMERICshifts.versionshifts.versionshifts
shifts__wageOBJECTshifts.wageshifts.wageshifts
sourceTEXTSourceThe name of the Windsor connector returning the row
taxes__absent_at_location_idsOBJECTtaxes.absent_at_location_idstaxes.absent_at_location_idstaxes
taxes__idTEXTtaxes.idtaxes.idtaxes
taxes__is_deletedBOOLEANtaxes.is_deletedtaxes.is_deletedtaxes
taxes__present_at_all_locationsBOOLEANtaxes.present_at_all_locationstaxes.present_at_all_locationstaxes
taxes__tax_dataOBJECTtaxes.tax_datataxes.tax_datataxes
taxes__typeTEXTtaxes.typetaxes.typetaxes
taxes__updated_atTIMESTAMPtaxes.updated_attaxes.updated_attaxes
taxes__versionNUMERICtaxes.versiontaxes.versiontaxes
team_member_wages__hourly_rateOBJECTteam_member_wages.hourly_rateteam_member_wages.hourly_rateteam_member_wages
team_member_wages__idTEXTteam_member_wages.idteam_member_wages.idteam_member_wages
team_member_wages__team_member_idTEXTteam_member_wages.team_member_idteam_member_wages.team_member_idteam_member_wages
team_member_wages__titleTEXTteam_member_wages.titleteam_member_wages.titleteam_member_wages
team_members__assigned_locationsOBJECTteam_members.assigned_locationsteam_members.assigned_locationsteam_members
team_members__created_atTIMESTAMPteam_members.created_atteam_members.created_atteam_members
team_members__email_addressTEXTteam_members.email_addressteam_members.email_addressteam_members
team_members__family_nameTEXTteam_members.family_nameteam_members.family_nameteam_members
team_members__given_nameTEXTteam_members.given_nameteam_members.given_nameteam_members
team_members__idTEXTteam_members.idteam_members.idteam_members
team_members__is_ownerBOOLEANteam_members.is_ownerteam_members.is_ownerteam_members
team_members__phone_numberTEXTteam_members.phone_numberteam_members.phone_numberteam_members
team_members__reference_idTEXTteam_members.reference_idteam_members.reference_idteam_members
team_members__statusTEXTteam_members.statusteam_members.statusteam_members
team_members__updated_atTIMESTAMPteam_members.updated_atteam_members.updated_atteam_members
todayDATETodayToday's date