Tables you can query

Every table you can query, grouped by area. Each shows its label, the name you write in a statement, what it holds, its key where it has one, and every field with its kind, named as you write it and as the answer returns it. Tables by area: Sales and orders (13), Customers (2), Products and pricing (8), Inventory and purchasing (9), Suppliers (2), Finance and accounting (7), Loyalty and gift cards (10), Quotes (4), Staff (2), Support (3), Blockchain ledger (schema chain) (7), Reports (mv_, read only) (33), Content store (4).

Field kinds

Each field below shows its kind: what it holds, and how you write and read it.

KindThe column holdsWritten and read as
textWords, codes and JSONA string
numberCounts, quantities and measuresA number
moneyAn amount of moneyA major-unit amount such as 12.50; the engine converts
bpsA percentage or rateA plain number; the engine converts
booleanYes or notrue or false
timestampA date or a momentA date or date and time
idA record's identifierA string

Sales and orders

Orders and everything that happens to them: the lines, the profit, where the order came from, the fees paid, and what is refunded, returned or charged back.

Orders (orders)

All sales orders. Key: orderId.

FieldKindFieldKind
orderIdidorderNumbertext
customerIdidcurrencytext
subtotalmoneydiscountmoney
taxmoneyshippingmoney
totalmoneyfinancialStatustext
channeltextsourceTypetext
statetextzipCodetext
countrytextstaffIdid
createdAttimestamppostedToLedgerboolean
accountingPeriodIdidtotalRefundedmoney
externalIdtextexternalLocationIdtext
isUtmbooleanquoteIdid
numIdnumber

Order line items (order_lines)

Individual products on each order. Key: orderId, lineId.

FieldKindFieldKind
orderIdtextvariantIdtext
skutextproductIdtext
vendortextproductTypetext
categorytexttitletext
quantitynumberunitPricemoney
lineDiscountmoneylineTotalmoney
unitCostmoneylineRevenuemoney
lineCostmoneygrossProfitmoney
marginbpscurrencytext
statustextorderItemVersionnumber
createdAttimestampupdatedAttimestamp
dutyAmountmoneydutyRatebps
dutyTypetextdutySourcetext
harmonizedSystemCodetextinboundFreightmoney
customsClearanceCostmoneyinsuranceCostmoney
landedCostTotalmoneylineTypetext
accountingPeriodIdidtaxRatebps
taxAmountmoneyunitPriceExTaxmoney
externalLocationIdtextlineIdid
lineShippingCostmoneyshippingAllocationMethodtext
isPrivateLabelbooleanisTrafficDriverboolean
isMarginBuilderbooleanisUtmboolean
estimatedUtmCostmoneyinventoryItemIdtext
numIdnumber

Order profit breakdown (order_profit_breakdown)

Per-order profit, fees, refunds, COGS. Key: orderId.

FieldKindFieldKind
orderIdidrevenuemoney
discountmoneycogsmoney
shippingCostmoneygatewayFeesmoney
refundsmoneynetProfitmoney
marginPercentbpscreatedAttimestamp
accountingPeriodIdidexternalLocationIdtext
discountLeakagemoneyshippingLeakagemoney
marketingAllocmoneysaasAllocmoney
fixedCostAllocmoneycontributionmoney
trueProfitmoneychannelTypetext
grossProfitmoneysettingsVersionnumber
shippingCostSourcetextoverheadAllocationMethodtext
fulfilmentCostmoneyfulfilmentRatiobps
accountingRevenuemoneyestimatedUtmCostmoney
numIdnumber

Order attribution (order_attribution)

Marketing source per order. Key: orderId.

FieldKindFieldKind
orderIdidcampaignIdid
attributedAmountmoneyexternalLocationIdtext
numIdnumber

Order cost audits (order_line_cost_audits)

Cost-of-goods checks per order line. Key: orderLineCostAuditId.

FieldKindFieldKind
orderIdtextskutext
fieldNametextoldValuemoney
newValuemoneysourcetext
changedAttimestamporderLineCostAuditIdid

Payment fees (payment_fees)

Processing fees per transaction. Key: orderId.

FieldKindFieldKind
orderIdidprovidertext
feeAmountmoneycurrencytext
createdAttimestampaccountingPeriodIdid
externalLocationIdtextamountmoney
numIdnumber

Price-match discounts (price_match_discounts)

Competitor price-match adjustments. Key: orderId, lineItemExternalId.

FieldKindFieldKind
orderIdtextlineItemExternalIdtext
variantIdtextskutext
titletextdiscountTypetext
sourcetextdetectedBytext
competitorNametextcompetitorPricemoney
originalPricemoneydeltamoney
quantitynumbertotalDeltamoney
currencytextcreatedAttimestamp
accountingPeriodIdidexternalLocationIdtext

Refunds (refunds)

Customer refunds. Key: refundId.

FieldKindFieldKind
refundIdidorderIdid
customerIdidamountmoney
currencytextreasontext
statetextzipCodetext
countrytextcreatedAttimestamp
accountingPeriodIdidexternalLocationIdtext
numIdnumber

Refund line items (refund_line_items)

Refunded items per refund. Key: refundId, lineItemExternalId.

FieldKindFieldKind
refundIdidlineItemExternalIdtext
skutextquantitynumber
restockedbooleanrestockTypetext
subtotalmoneytaxmoney
unitCostmoneycreatedAttimestamp
variantIdtextnumIdnumber

Returns (returns)

Returned merchandise. Key: returnId.

FieldKindFieldKind
returnIdidorderIdid
statustexttotalQuantitynumber
refundIdidcreatedAttimestamp
updatedAttimestampnumIdnumber

Return line items (return_line_items)

Returned items per return. Key: returnId, lineId.

FieldKindFieldKind
lineIdtextreturnIdid
variantIdtextquantitynumber
reasontextreasonNotetext
restockTypetextsubtotalmoney
taxmoneyunitCostmoney
createdAttimestampcustomerNotetext

Chargebacks (chargebacks)

Disputed payments by customers. Key: chargebackId.

FieldKindFieldKind
chargebackIdidorderIdid
customerIdidamountmoney
currencytextreasontext
statustextstatetext
zipCodetextcountrytext
createdAttimestampaccountingPeriodIdid
externalLocationIdtextnumIdnumber

Advertising channels (advertising_channels)

Marketing channels and ad spend. Key: externalLocationId.

FieldKindFieldKind
channelIdtextadvertisertext
advertiserOthertextcurrencytext
targetScopetexttargetProductstext
startDatetimestampendDatetimestamp
createdAttimestampupdatedAttimestamp
archivedAttimestampcategorytext
externalLocationIdidavgMonthlyCostmoney
numIdnumber

Customers

The people who buy, and the month each one first bought.

Customers (customers)

All customers and their profiles. Key: customerId.

FieldKindFieldKind
customerIdidcountrytext
statetextcitytext
ziptextfirstOrderAttimestamp
lifetimeValuemoneytotalOrdersnumber
totalRefundsmoneyfraudWarnCountnumber
totalChargebacksCountnumbercreatedAttimestamp
initialLtvmoneyinitialTotalOrdersnumber
metafieldstextcontactHashtext
numIdnumber

Customer cohorts (customer_cohorts)

Customers grouped by acquisition period. Key: cohortMonth, customerId.

FieldKindFieldKind
cohortMonthtimestampcustomerIdid
numIdnumber

Products and pricing

What you sell, how it is organised, and what it costs and sells for.

Products (products)

Your full product catalog. Key: productId.

FieldKindFieldKind
productIdidtagstext
launchDatetimestampexpiryDatetimestamp
titletextstatustext
createdAttimestampupdatedAttimestamp
metafieldstexthandletext
numIdnumber

Product variants (product_variants)

SKU variants of each product. Key: variantId.

FieldKindFieldKind
variantIdidproductIdtext
skutextpricemoney
barcodetextcreatedAttimestamp
updatedAttimestamptitletext
metafieldstextweightGramsnumber
lengthMmnumberwidthMmnumber
heightMmnumbercubicMm3number
weightSourcetextcostmoney
currencytextisMarginboolean
marginPriorityScorenumbersupplierIdtext
weightedAvgBuyPriceExTaxnumbermarkupTargetPctbps
maxDiscountPctbpsrrpIncTaxnumber
freightCostIncTaxnumberdirectCostExTaxnumber
cogsExTaxnumberlastPurchasePriceExTaxnumber
leadTimeDaysnumbertrackedboolean
numIdnumber

Product prices (product_prices)

Price history per variant. Key: productPriceId.

FieldKindFieldKind
productIdtextmarketIdtext
pricemoneycurrencytext
recordedAttimestampproductPriceIdid
numIdnumber

Product Types (product_types)

The product types a catalogue is organised by. Key: productTypeId.

FieldKindFieldKind
productTypeIdidtitletext
createdAttimestampupdatedAttimestamp
numIdnumber

Product classifications (product_classifications)

Tax and shipping product classes. Key: sku.

FieldKindFieldKind
variantIdtextskutext
externalProductIdtexttitletext
productTypetextvendortext
marginStatustextavgMarginbps
avgUnitCostmoneyavgUnitPricemoney
currencytextportfolioQuadranttext
demandVelocitynumberisTrafficDriverboolean
isOwnBrandbooleanpriceMatchCountnumber
priceMatchTotalDeltamoneyisInsuranceboolean
orderCountnumberconfidencenumber
lastComputedAttimestampsourcetext
strategyTagtextdaysOnHandnumber
daysToExpirynumberstrategyLastComputedAttimestamp
competitiveFlagtextpriceDeviationbps
attachRatebpsgmroinumber
inventoryRoicnumbercapitalLockedmoney
autoTargetPricemoneyriskScorenumber
basketLiftmoneylossMinimisationModeboolean

Product Edge (product_edge)

Links each product to its vendor, product type and collection. Key: edgeId.

FieldKindFieldKind
productIdtextvendorIdid
productTypeIdidcollectionIdid
createdAttimestampedgeIdtext

Collections (collections)

Product collections and groupings. Key: collectionId.

FieldKindFieldKind
collectionIdidtitletext
createdAttimestampupdatedAttimestamp
numIdnumber

Vendors (vendors)

The vendors whose products you sell. Key: vendorId.

FieldKindFieldKind
vendorIdidtitletext
createdAttimestampupdatedAttimestamp
numIdnumber

Inventory and purchasing

Stock on hand and every movement of it, transfers between locations, and the purchase orders that replenish it.

Stock levels (inventories)

Current stock by product and location. Key: sourceId, locationId.

FieldKindFieldKind
sourceIdidlocationIdtext
availablenumberincomingnumber
outgoingnumbersohnumber
adjustmentQtynumberminStocknumber
autoReplenishbooleansafetyStocknumber
stockCoverageDaysnumberdailySalesVelocitynumber
sellThroughRatebpsincomingQuantitynumber
reorderQuantitynumberpoStatustext
versionnumbercreatedAttimestamp
updatedAttimestampvariantIdtext
costmoneylastPurchasedAttimestamp
inventoryValuemoneynumIdnumber

Stock movements (inventory_movements)

All stock changes: sales, transfers, receipts. Key: sourceTopic, originId.

FieldKindFieldKind
movementIdtextsourceIdtext
locationIdtextquantityDeltanumber
previousAvailablenumberavailablenumber
reasontextsourceTopictext
originIdtextcreatedAttimestamp
accountingPeriodIdidpreviousIncomingnumber
incomingnumberpreviousOutgoingnumber
outgoingnumberpreviousSohnumber
sohnumbervariantIdtext
productIdtextcostmoney
inventoryValuemoneydailySalesVelocitynumber
sellThroughRatebpsstockCoverageDaysnumber

Stock transfers (inventory_transfer_orders)

Stock moved between stores. Key: transferId.

FieldKindFieldKind
transferIdidsourceLocationIdtext
destinationLocationIdtextstatustext
createdByStafftextcreatedAttimestamp
updatedAttimestampnumIdnumber

Transfer line items (inventory_transfer_lines)

Items inside each stock transfer. Key: transferId, variantId.

FieldKindFieldKind
transferIdtextvariantIdtext
quantitynumbercostmoney

Transfer recommendations (inventory_transfer_decisions)

Suggested stock transfers between stores. Key: decisionId.

FieldKindFieldKind
decisionIdtextvariantIdtext
sourceLocationIdtextdestinationLocationIdtext
availableStocknumberincomingStocknumber
demandVelocitySourcenumberdemandVelocityDestinationnumber
daysOfCoverSourcenumberdaysOfCoverDestinationnumber
transferCostmoneyprocurementCostmoney
opportunityLossmoneydecisiontext
quantitynumberversionnumber
createdAttimestamp

Goods receipts (goods_receipts)

Stock received from suppliers. Key: receiptId.

FieldKindFieldKind
receiptIdidpoIdid
variantIdidquantityReceivednumber
damagedQtynumberqualityFlagtext
receivedByidreceivedAttimestamp
accountingPeriodIdidnumIdnumber

Purchase orders (purchase_orders)

Orders placed with suppliers. Key: poId.

FieldKindFieldKind
poIdidsupplierIdid
currencytextstatustext
totalAmountmoneycreatedByStaffid
approvedByStaffidlocationIdid
createdAttimestampupdatedAttimestamp
versionnumberaccountingPeriodIdid
numIdnumber

Purchase order lines (purchase_order_lines)

Items on each purchase order. Key: poId, variantId.

FieldKindFieldKind
poIdidvariantIdid
quantitynumberunitCostmoney
receivedQtynumberdamagedQtynumber
currencytextaccountingPeriodIdid

Purchase order shipments (purchase_order_shipments)

Inbound shipments from suppliers. Key: shipmentId.

FieldKindFieldKind
shipmentIdidpoIdid
carrierNametexttrackingNumbertext
incotermtextfreightCostmoney
insuranceCostmoneydutiesCostmoney
customsCostmoneyotherLandingmoney
currencytextfxRateLockednumber
expectedDeparturetimestampexpectedArrivaltimestamp
actualArrivaltimestampshipmentStatustext
accountingPeriodIdidcreatedAttimestamp
numIdnumber

Suppliers

Who supplies what, and how the supplier is rated.

Suppliers (suppliers)

Vendor and supplier directory. Key: supplierId.

FieldKindFieldKind
supplierIdidnametext
statustextdefaultCurrencytext
paymentTermsDaysnumbercreditLimitmoney
riskScorenumbercreatedAttimestamp
updatedAttimestampversionnumber
exposureStatustextcontractStatustext
sfrsCompositenumbercrnumber
cdvnumbercsenumber
ltinumbersffnumber
csinumberconcentrationFreezeboolean
marginShockbooleancurrencyCorridorboolean
capitalExposurebooleanrevenueDependencynumber
substitutionElasticitynumbernumIdnumber

Product suppliers (product_suppliers)

Supplier links per product. Key: productId, supplierId.

FieldKindFieldKind
productIdtextsupplierIdtext
isPrimarybooleanleadTimeDaysnumber
minOrderQuantitynumberlastCostExTaxnumber
currencytextcreatedAttimestamp
updatedAttimestamp

Finance and accounting

The journals every sale and refund is posted to, prepaid costs, profit leakage and the apps you pay for.

Journals (journals)

Accounting journal headers. Key: journalId, createdAt.

FieldKindFieldKind
journalIdidaggregateIdid
versionnumbercurrencytext
referencetextcreatedAttimestamp
hashtextaccountingPeriodIdid
externalLocationIdtexttxHashtext
blockHeightnumber

Journal entries (journal_entries)

Accounting entries (debit/credit lines). Key: entryId.

FieldKindFieldKind
entryIdidjournalIdid
accountIdidsidetext
amountmoneycurrencytext
functionalAmountmoneyfunctionalCurrencytext
createdAttimestampaccountingPeriodIdid
externalLocationIdtext

Journal references (journal_references)

Links between journals and source records. Key: referenceType, referenceId.

FieldKindFieldKind
referenceTypetextreferenceIdid
journalIdidcreatedAttimestamp
sourceDomaintextsourceHashtext
referencetextorderIdid
quoteIdidpolicyIdid
ruleIdidcustomerIdid
staffIdidcountrytext
statetextzipCodetext
sourceTypetextsourceIdid
refundIdidreturnIdid
variantIdidlocationIdid
accountIdidcampaignIdid
supplierIdid

Prepaid expenses (prepaid_expenses)

Costs paid up front, amortised over time. Key: expenseId.

FieldKindFieldKind
expenseIdidtotalValuemoney
amortizedmoneystartDatetimestamp
endDatetimestampaccountingPeriodIdid
descriptiontextcategorytext
amortizationMethodtextremainingBalancemoney
updatedAttimestampstatustext
createdAttimestampnumIdnumber

Prepaid expense allocations (prepaid_expense_allocations)

Monthly amortisation of prepaid costs. Key: allocationId.

FieldKindFieldKind
allocationIdtextexpenseIdid
accountingPeriodIdidallocatedAmountmoney
statustextcreatedAttimestamp

Leakage scores (leakage_scores)

Revenue leakage risk by source. Key: aggregateId.

FieldKindFieldKind
aggregateIdidscopetext
leakageScorenumbernormalizedImpactbps
maxSeverityWeightnumbertotalFinancialImpactmoney
transactionRevenuemoneyassessmentCountnumber
exceedsAlertThresholdbooleanweightedAverageScorenumber
policyHashtextcomputedAttimestamp
externalLocationIdtextnumIdnumber

Installed apps (installed_paid_apps)

Paid Shopify apps and subscriptions. Key: appId.

FieldKindFieldKind
appIdtextappNametext
categorytextmonthlyCostmoney
currencytextfxRatenumber
installedDatetimestampstatustext
archivedAttimestampcreatedAttimestamp
updatedAttimestamp

Loyalty and gift cards

Loyalty members, their points and tiers, the guardrails that govern the programme, and gift card balances.

Loyalty members (loyalty_members)

Enrolled loyalty program customers. Key: loyaltyMemberId.

FieldKindFieldKind
loyaltyMemberIdidcustomerIdtext
memberStatustexttiertext
currencytextpointsBalancenumber
totalPointsEarnednumbertotalPointsRedeemednumber
totalPointsExpirednumbertotalPointsReservednumber
currentMultiplierbpsannualSpendmoney
lastPurchaseAttimestampdormantSinceAttimestamp
tierQualifiedAttimestampversionnumber
createdAttimestampupdatedAttimestamp
numIdnumber

Loyalty accounts (loyalty_accounts)

Customer loyalty point balances. Key: customerId.

FieldKindFieldKind
customerIdidpointsBalancenumber
capturedMultipliernumbercreatedAttimestamp
statetextzipCodetext
countrytextupdatedAttimestamp
numIdnumber

Loyalty transactions (loyalty_transactions)

Points earned and redeemed. Key: transactionId.

FieldKindFieldKind
transactionIdidcustomerIdid
pointsDeltanumberreasontext
statetextzipCodetext
countrytextcreatedAttimestamp
accountingPeriodIdidnumIdnumber

Loyalty point batches (loyalty_point_batches)

Issued points with expiry tracking. Key: batchId.

FieldKindFieldKind
batchIdtextcustomerIdtext
orderIdtextstatustext
pointsOriginalnumberpointsRemainingnumber
marginWeightbpscurrencytext
earnedAttimestampavailableAttimestamp
expiresAttimestampreservedAttimestamp
redeemedAttimestampreversedAttimestamp
versionnumbercreatedAttimestamp
policyIdtextsourceOpIdtext
pointValuemoney

Loyalty tiers (loyalty_tier_thresholds)

Spend thresholds for tier upgrades. Key: tier.

FieldKindFieldKind
tiertextannualSpendMinmoney
defaultMultiplierbpssortOrdernumber
annualSpendMaxmoney

Loyalty guardrails (loyalty_guardrail_thresholds)

Limits that prevent loyalty abuse. Key: loyaltyGuardrailThresholdId.

FieldKindFieldKind
liabilityRatioCeilingbpsmarginFloorbps
frequencyCeilingbpsmaxEarnMultiplierbps
settlementDelayDaysnumberdefaultExpiryDaysnumber
breakageHealthyFloorbpsbreakageHealthyCeilingbps
updatedAttimestamployaltyGuardrailThresholdIdid
numIdnumber

Loyalty risk scores (loyalty_risk_scores)

Fraud risk per loyalty account.

FieldKindFieldKind
scorenumberbandtext
lirnumberrvrnumber
mesnumberbcrnumber
crlnumberw1number
w2numberw3number
w4numberw5number
computedAttimestamp

Loyalty family pools (loyalty_family_pools)

Shared family loyalty accounts. Key: loyaltyFamilyPoolId.

FieldKindFieldKind
poolIdtexthouseholdIdtext
statustextpoolBalancenumber
currencytextversionnumber
createdAttimestampupdatedAttimestamp
loyaltyFamilyPoolIdidnumIdnumber

Loyalty family members (loyalty_family_members)

Customers in shared loyalty pools. Key: poolId, customerId.

FieldKindFieldKind
poolIdtextcustomerIdtext
personalBalancenumberjoinedAttimestamp

Gift card balances (gift_card_liabilities)

Outstanding gift card values. Key: giftCardId.

FieldKindFieldKind
giftCardIdidinitialValuemoney
balancemoneycurrencytext
createdAttimestampupdatedAttimestamp
expiresOntimestampdeactivatedAttimestamp
cardStatetextnumIdnumber

Quotes

Quotes made for customers, their lines, their expected margin, and the orders they became.

Quotes (quotes)

Customer quotes (draft orders). Key: quoteId.

FieldKindFieldKind
quoteIdidcustomerIdid
currencytextsubtotalmoney
totalDiscountmoneyestimatedCogsmoney
estimatedProfitmoneystatetext
zipCodetextcountrytext
staffIdidstatustext
createdAttimestampvalidUntiltimestamp
approvedBytextriskScorenumber
evImpactmoneygovernanceStatustext
governanceNotestextupdatedAttimestamp
emailtextphonetext
sourceNametexttagstext
metafieldstextacceptAutomaticDiscountsboolean
appliedDiscountValuemoneyappliedDiscountTypetext
appliedDiscountTitletextappliedDiscountstext
notetextaiNarrativetext
locationIdtextlockPricesboolean
numIdnumber

Quote line items (quote_items)

Items on each quote. Key: quoteId, variantId.

FieldKindFieldKind
quoteIdidvariantIdid
quantitynumberunitPricemoney
unitCostmoneyappliedDiscountValuemoney
competitorNametextcompetitorPricemoney
landedCostmoneydutyAmountmoney
shippingAllocationmoneycontributionMarginmoney
titletextvariantTitletext
appliedDiscountTypetextappliedDiscountTitletext
appliedDiscountDescriptiontextappliedDiscountstext
customAttributestexttaxLinestext
taxablebooleanrequiresShippingboolean
isGiftCardbooleanskutext
lineTotalmoneydiscountedTotalmoney
imageUrltext

Quote margin snapshots (quote_margin_snapshot)

Margin snapshot at quote acceptance. Key: quoteId.

FieldKindFieldKind
quoteIdidexpectedRevenuemoney
expectedCogsmoneyexpectedProfitmoney
marginPercentbpscreatedAttimestamp

Quote conversions (quote_conversions)

Quotes that became orders. Key: quoteId.

FieldKindFieldKind
quoteIdidorderIdid
staffIdidconvertedAttimestamp
shopifyOrderIdtext

Staff

The people who work in the business and the commission they earn.

Staff (staff)

Sales staff and team members. Key: staffId.

FieldKindFieldKind
staffIdidtenantRolesid
locationRolestextisActiveboolean
createdAttimestampupdatedAttimestamp
versionnumberisSuperAdminboolean
staffNametextexternalIdtext
emailtext

Staff commissions (staff_commissions)

Commission earned per sale. Key: orderId, staffId.

FieldKindFieldKind
orderIdidstaffIdid
commissionAmountmoneyaccountingPeriodIdid
externalLocationIdtext

Support

Support tickets, their history, and the service log entries they come from.

Support Tickets (support_tickets)

Support tickets raised from errors, with severity, status and resolution. Key: ticketId.

FieldKindFieldKind
ticketIdidticketNumbertext
sourceLogIdidseveritytext
statustextshopDomaintext
errorCodetextservicetext
correlationScopetexttitletext
merchantMessagetextinternalSummarytext
assignedTotextrequiresTenantNotificationboolean
tenantNotifiedAttimestamptenantAcknowledgedAttimestamp
fixRequiredbooleanfixStatustext
gitBranchtextgitPrUrltext
gitCommitShatextoccurrenceCountnumber
lastLogAttimestampresolvedAttimestamp
resolvedBytextresolutionSummarytext
createdAttimestampupdatedAttimestamp
kindtextcategorytext
createdBytextgithubIssueNumbernumber
githubIssueUrltextnumIdnumber

Support Ticket Events (support_ticket_events)

The history of each support ticket: who did what and when. Key: eventId.

FieldKindFieldKind
eventIdidticketIdid
eventTypetextactorTypetext
actorIdtextmessagetext
metadataJsontextcreatedAttimestamp

Reactive Logs (reactive_logs)

Service log entries, with their severity, service and error code. Key: logId.

FieldKindFieldKind
logIdidtimestamptimestamp
leveltextstatustext
servicetextddsourcetext
environmenttextcorrelationIdtext
requestIdtexttraceIdtext
shopDomaintextscopetext
errorCodetexterrorMessagetext
messagetextmerchantImpacttext
actionRequiredtextrequiresTicketboolean
requiresTenantNotificationbooleantracetext
metadataJsontextcreatedAttimestamp
countnumberdedupHashtext

Blockchain ledger (schema chain)

The ledger's chains and the transactions, receipts and consensus, governance, treasury and trust records written to them. These tables live in the schema chain, so name them with it: chain.transactions.

Chains (chain.chains)

The ledger chains, with their height, state hash and status. Key: chainId.

FieldKindFieldKind
chainIdtextchainNametext
chainTypetextgenesisBlockHashtext
currentHeightnumbercurrentStateRootHashtext
statustextcreatedAttimestamp
updatedAttimestampnumIdnumber

Transactions (chain.transactions)

Transactions submitted to a chain, with their signer, hash and status. Key: chainTxId.

FieldKindFieldKind
chainTxIdtextchainIdtext
blockIdtexttxHashtext
txTypetextsignerPrincipalIdtext
payloadHashtextnoncenumber
signaturetexttxStatustext
submittedAttimestampfinalizedAttimestamp
numIdnumber

Transaction Receipts (chain.transaction_receipts)

The execution result of each chain transaction. Key: receiptId.

FieldKindFieldKind
receiptIdtextchainTxIdtext
executionStatustextexecutionHashtext
resultHashtextgasUsednumber
errorCodetextcreatedAttimestamp

Consensus Votes (chain.consensus_votes)

Validator votes cast in a chain's consensus rounds. Key: consensusVoteId.

FieldKindFieldKind
consensusVoteIdtextconsensusRoundIdtext
validatorIdtextvoteTypetext
voteHashtextsignaturetext
createdAttimestampnumIdnumber

Governance Events (chain.governance_events)

Governance events recorded on the chain, with their evidence and vote hashes. Key: chainGovernanceEventId.

FieldKindFieldKind
chainGovernanceEventIdtextchainTxIdtext
governanceEventIdtexteventHashtext
evidenceRootHashtextvoteRootHashtext
resolutionHashtextcreatedAttimestamp

Treasury Events (chain.treasury_events)

Treasury events recorded on the chain, with their approval and ledger hashes. Key: chainTreasuryEventId.

FieldKindFieldKind
chainTreasuryEventIdtextchainTxIdtext
treasuryTransactionIdtexttreasuryEventHashtext
approvalRootHashtextledgerEntryRootHashtext
createdAttimestamp

Trust Events (chain.trust_events)

Trust events recorded on the chain, with the trust hash before and after. Key: chainTrustEventId.

FieldKindFieldKind
chainTrustEventIdtextchainTxIdtext
trustEventIdtexttrustEventHashtext
previousTrustHashtextnewTrustHashtext
createdAttimestamp

Reports (mv_, read only)

Reports are tables the platform keeps up to date for you. Their names start with mv_, you read them like any table, and you cannot write to them.

Cash flow (daily) (mv_cash_flow_daily)

Daily cash inflow and outflow.

FieldKindFieldKind
flowDatetimestampcurrencytext
externalLocationIdtextoperatingInflowsmoney
operatingOutflowsmoneyinvestingOutflowsmoney
refundOutflowsmoneychargebackLossesmoney
gatewayFeesmoneyfinancingFlowsmoney

CFO dashboard (mv_cfo_dashboard_summary)

Top-line metrics for executive review.

FieldKindFieldKind
totalRevenuemoneytotalExpensemoney
grossProfitmoneygiftcardLiabilitymoney
loyaltyLiabilitymoney

Channel P&L (daily) (mv_channel_daily_pnl)

Profit & loss by marketing channel.

FieldKindFieldKind
pnlDatetimestampchanneltext
currencytextexternalLocationIdtext
netSalesmoneycogsmoney
gatewayFeesmoneyrefundTotalmoney
orderCountnumber

Cohort retention (mv_cohort_retention)

Customer retention by acquisition month.

FieldKindFieldKind
cohortMonthtimestampcohortSizenumber
month0numbermonth1number
month2numbermonth3number
month6numbermonth12number

Competitor price pressure (mv_competitor_price_pressure)

SKUs under competitor pricing pressure.

FieldKindFieldKind
productIdtextavgPriceIndexnumber
minPriceIndexnumbercompetitorCountnumber
freshestScrapetimestamp

Customer concentration (mv_customer_concentration)

Revenue concentration risk by customer.

FieldKindFieldKind
currencytextdayOfWeeknumber
hourOfDaynumberorderCountnumber
totalRevenuemoneytotalDiscountmoney

Customer economics (mv_customer_economics)

LTV, AOV and frequency per customer.

FieldKindFieldKind
customerIdidcurrencytext
orderCountnumberrevenueTotalmoney
cogsTotalmoneygrossMarginTotalmoney
refundCountnumberrefundTotalmoney
chargebackCountnumberchargebackTotalmoney

Digital cost per order (mv_digital_cost_per_order)

Marketing spend per acquired order.

FieldKindFieldKind
accountingPeriodIdtexttotalDigitalOperatingCostmoney
digitalCostPerOrdermoneycreatedAttimestamp

Product graph (inbound) (mv_graph_inbound_degree)

Most-bought-with product connections.

FieldKindFieldKind
gidtextentityTypetext
inboundEdgesnumberlabelDiversitynumber
uniqueSourcesnumberactiveEdgesnumber

Product graph metrics (mv_graph_metrics)

Cross-sell and substitution graph stats.

FieldKindFieldKind
gidtextentityTypetext
outboundEdgesnumberlabelDiversitynumber
avgWeightnumberuniqueTargetsnumber
activeEdgesnumber

Stock valuation (mv_inventory_valuation)

Current inventory value by SKU and location.

FieldKindFieldKind
variantIdtextlocationIdtext
quantitynumbercostPerUnitmoney
currencytexttotalValuemoney
updatedAttimestamp

Store performance (mv_location_performance)

Sales and margin by store.

FieldKindFieldKind
locationKeytextlocationNametext
orderCountnumberrevenuemoney
cogsmoneygrossProfitmoney
marginRatenumberpgAnomalynumber

Monthly revenue (mv_monthly_revenue)

Revenue trend by month.

FieldKindFieldKind
revenueMonthtimestampexternalLocationIdtext
totalRevenuemoneytotalOrdersnumber

Daily order lines (mv_order_lines_daily)

Order line totals rolled up daily.

FieldKindFieldKind
metricDaytimestampvariantIdtext
skutexttitletext
vendortextproductTypetext
categorytextcurrencytext
locationKeytexttotalRevenuemoney
totalCostmoneytotalDiscountmoney
totalNetRevenuemoneytotalGrossProfitmoney
orderCountnumberunitsSoldnumber

Price simulations (mv_price_simulation_results)

Modelled impact of price changes.

FieldKindFieldKind
skuIdtextsimulationIdtext
predictedDemandnumberpredictedRevenuemoney
predictedMarginmoneyrevenueChangemoney
marginChangemoneyelasticityUsednumber
createdAttimestamp

Product complements (mv_product_complements)

Products often bought together.

FieldKindFieldKind
productIdtextrelatedProductIdtext
relationshipScorenumbercomplementTypetext
blendedMarginImpactnumber

Product intelligence (mv_product_intelligence)

Sales velocity, margin, ABC class per SKU. Key: productId.

FieldKindFieldKind
productIdtexttitletext
isOwnBrandbooleanisMarginProductboolean
tagstextunitsSold90dnumber
revenue90dmoneyorders90dnumber
avgUnitPricemoneyavgUnitCostmoney
avgLandedCostmoneygrossMarginPctbps
unitsSold30dnumberunitsSoldPrior30dnumber
velocityTrendtexttrendPctChangenumber
inventoryOnHandnumberdaysOfStocknumber
inventoryStatustextpaidChannelPctbps
organicPctbpsadDependentboolean
priceElasticitynumberperformanceClasstext
discountNecessitynumberbundleCandidate1text
bundleCandidate2textbundleCandidate3text
deadStockAlt1textdeadStockAlt2text
deadStockAlt3textupdatedAttimestamp
expiryDatetimestampvendortext
productTypetext

Product substitutions (mv_product_substitutions)

Substitutes bought when out of stock.

FieldKindFieldKind
productIdtextrelatedProductIdtext
relationshipScorenumber

Promotion simulations (mv_promotion_simulation_results)

Modelled impact of promo campaigns.

FieldKindFieldKind
skuIdtextsimulationIdtext
promoRoinumberincrementalSalesmoney
discountCostmoneypredictedRevenuemoney
predictedMarginmoneypromotionIsViableboolean
createdAttimestamp

App spend by category (mv_saas_cost_by_category)

App spend grouped by function.

FieldKindFieldKind
accountingPeriodIdtextcategorytext
sourceTypetextallocatedAmountmoney
sourceCountnumber

App spend by store (mv_saas_cost_by_store)

App spend allocated per store.

FieldKindFieldKind
accountingPeriodIdtextexternalLocationIdtext
sourceTypetextallocatedAmountmoney
allocationCountnumber

App spend summary (mv_saas_cost_summary)

Total app and platform spend.

FieldKindFieldKind
accountingPeriodIdtexttotalPlatformCostmoney
totalAppCostmoneytotalSubscriptionCostmoney
totalPaymentInfraCostmoneytotalLogisticsOverheadmoney
totalFulfilmentCostmoneytotalDigitalOperatingCostmoney
digitalCostPerOrdermoneydigitalCostRatiobps
marginErosionbpscreatedAttimestamp

App spend margin impact (mv_saas_margin_erosion)

How app costs eat into margin.

FieldKindFieldKind
accountingPeriodIdtexttotalDigitalOperatingCostmoney
digitalCostRatiobpsmarginErosionbps
createdAttimestamp

Signal: customer discounts (mv_signal_customer_discount_profile)

Discount usage patterns per customer.

FieldKindFieldKind
customerIdidstatMonthtimestamp
accountingPeriodIdtextexternalLocationIdtext
totalOrderCountnumberdiscountedOrderCountnumber
totalRevenuemoneytotalCostmoney
totalDiscountmoneygrossProfitmoney
totalRefundAmountmoneycontributionMarginmoney
discountRatiobpsfirstOrderAttimestamp
lastOrderAttimestamp

Signal: customer geography (mv_signal_customer_geo_profile)

Customer location and shipping patterns.

FieldKindFieldKind
customerIdidhomeCountrytext
historicOrderCountnumberregisteredCountrytext
registeredZiptextrecentOrderCountrytext
recentOrderZiptext

Signal: customer refunds (mv_signal_customer_refund_stats)

Refund frequency per customer.

FieldKindFieldKind
customerIdidstatMonthtimestamp
accountingPeriodIdtextexternalLocationIdtext
refundCountnumberorderCountnumber
totalRefundAmountmoneyrefundRatebps
fraudWarnCountnumberfirstRefundAttimestamp
lastRefundAttimestamp

Signal: daily velocity (mv_signal_daily_velocity)

Daily sales velocity per SKU.

FieldKindFieldKind
statDatetimestampaccountingPeriodIdtext
externalLocationIdtextdailyOrderCountnumber
dailyOrderValuemoneydailyRefundCountnumber
dailyRefundValuemoney

Signal: geographic clusters (mv_signal_geo_cluster_stats)

Sales clustered by region.

FieldKindFieldKind
countrytextstatetext
zipCodetextstatMonthtimestamp
accountingPeriodIdtextexternalLocationIdtext
clusterCustomerCountnumberrefundingCustomerCountnumber
totalRefundAmountmoneyrefundRatebps
latestRefundAttimestamp

Signal: monthly periods (mv_signal_period_monthly_stats)

Monthly comparative period stats.

FieldKindFieldKind
yearMonthtimestampaccountingPeriodIdtext
externalLocationIdtextmonthlyRevenuemoney
monthlyDiscountmoneymonthlyGrossMarginmoney
monthlyContributionMarginmoneymonthlyRefundsmoney
monthlyOrderCountnumber

Signal: refund details (mv_signal_refund_enriched)

Refunds with enriched context.

FieldKindFieldKind
refundIdidcustomerIdid
orderIdidrefundAmountmoney
orderTotalmoneyaccountingPeriodIdid
externalLocationIdtextorderCountrytext
orderZiptextrefundCountrytext
refundZiptextcountryDiffersboolean
zipDiffersbooleanorderCreatedAttimestamp
refundCreatedAttimestampdaysToRefundnumber
fraudWarnCountnumbercustomerTotalOrdersnumber
customerLifetimeValuemoneygcRedemptionCountnumber
gcLineTotalmoney

Signal: staff refunds (mv_signal_staff_refund_stats)

Refund stats per staff member.

FieldKindFieldKind
staffIdidstatMonthtimestamp
accountingPeriodIdtextorderCountnumber
refundCountnumbertotalRefundedmoney
staffRatebpstenantAvgRatebps
lastRefundAttimestamp

SKU P&L (daily) (mv_sku_daily_pnl)

Daily profit & loss per SKU.

FieldKindFieldKind
pnlDatetimestampvariantIdtext
currencytextexternalLocationIdtext
revenuemoneycogsmoney
gatewayFeesmoneyrefundsmoney
chargebacksmoneyorderCountnumber

Tenant P&L (daily) (mv_tenant_daily_pnl)

Daily profit & loss across the whole tenant.

FieldKindFieldKind
pnlDatetimestampcurrencytext
externalLocationIdtextrevenuemoney
cogsmoneyoperatingExpensesmoney
orderCountnumber

Content store

These four tables are the content store: the entries, types, files and version history that hold a site's pages and records. They live in the schema content. Money does not appear in them; an entry's fields is JSON, read with e.fields.name.

Entries (entries)

The content store's entries: each is a record of a content type, its fields held as JSON. Key: id.

FieldKindFieldKind
idtextcontentTypetext
slugtextfieldstext
publishedbooleanversionnumber
createdAttimestampupdatedAttimestamp
publishedAttimestampcreatedBytext
updatedBytextarchivedboolean

Content types (content_types)

The content store's types: the name and field definitions each entry follows. Key: id.

FieldKindFieldKind
idtextnametext
displayFieldtextfieldstext
createdAttimestampupdatedAttimestamp

Assets (content.assets)

The content store's files and images, each with its title and file details. Key: id.

FieldKindFieldKind
idtexttitletext
descriptiontextfiletext
publishedbooleancreatedAttimestamp
updatedAttimestamp

Entry versions (entry_versions)

Earlier versions of each entry, snapshotted when it changes. Key: id, versionNo.

FieldKindFieldKind
idtextversionNonumber
contentTypetextslugtext
fieldstextpublishedboolean
snapshottedAttimestamp