Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Smartrr v2 connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Smartrr v2 connector:

• Bills

• Customers

• Purchasestate

• Purchasestateline_items

• Orders

Bills

The Bills API allows you to manage financial transactions and invoices within the Smartrr platform. You can create, update, retrieve, and delete bills, ensuring efficient financial record-keeping.

For more information, see Bills.

Field Name	Data Type
createdDate	TIMESTAMP
updatedDate	TIMESTAMP
id	NUMERIC
uniqueId	STRING
uniqueShopifyId	STRING
status	STRING
billingDate	TIMESTAMP
billAmount	STRING
billCurrency	STRING
subscriptionBillingAttemptId	STRING
metadata	RECORD
error	STRING
retryCount	NUMERIC
st	RECORD

Customers

The Customers API provides functionality to manage customer profiles and information. You can use this API to create, update, retrieve, and delete customer records, helping you maintain a database of your clientele.

For more information, see Customers.

Field Name	Data Type
createdDate	TIMESTAMP
updatedDate	TIMESTAMP
id	STRING
shopifyId	STRING
receivedFromShopifyDate	TIMESTAMP
shopifyUpdateDate	TIMESTAMP
email	STRING
firstName	STRING
lastName	STRING
role	STRING
customerCurrency	STRING
hasLoggedIn	BOOLEAN
orderCount	NUMERIC
totalOrderCount	NUMERIC
totalSpent	STRING
otpEntryAttempts	NUMERIC
otpSendAttempts	NUMERIC
otpVerified	BOOLEAN

Purchasestate

The PurchaseState API helps you handle the different states or statuses associated with purchases. It allows you to manage the lifecycle of purchases, from initiation to completion, by creating, updating, retrieving, and deleting purchase states.

For more information, see Purchasestate.

Field Name	Data Type
createdDate	TIMESTAMP
updatedDate	TIMESTAMP
id	STRING
shopifyId	STRING
shopifyUpdateDate	TIMESTAMP
nextBillingDate	TIMESTAMP
purchaseStateStatus	STRING
initialSubmissionDate	TIMESTAMP
createdViaCustomerPortal	BOOLEAN
isRepeatCustomer	BOOLEAN
sellingPlanId	STRING
totalEstimatedTax	STRING
totalFromLineItems	STRING
totalLineItemsDiscount	STRING
totalLineItemsAfterDiscount	STRING
totalShipping	STRING
totalShippingDiscount	STRING
totalDiscount	STRING
totalEstimatedNet	STRING
currency	STRING
shippingAddress	RECORD
externalSubscriptionId	STRING
externalSubscriptionType	STRING
externalSubscriptionStatus	STRING
originalExternalSubscriptionStatus	STRING
containsBundle	BOOLEAN
hasUsedRetentionDiscount	BOOLEAN
custRel	RECORD
schedule	RECORD
stLineItems	RECORD
cancelledAt	TIMESTAMP

Purchasestateline_items

This API is designed for managing the line items associated with purchase states. It enables you to add, modify, retrieve, or remove specific items related to a purchase state.

For more information, see Purchasestateline_items.

Field Name	Data Type
createdDate	TIMESTAMP
updatedDate	TIMESTAMP
id	STRING
shopifyId	STRING
shopifyUpdateDate	TIMESTAMP
idempotencyKey	STRING
basePrice	STRING
priceAfterDiscounts	STRING
priceCurrency	STRING
pricingPolicy	RECORD
quantity	NUMERIC
sellingPlanId	STRING
isAddOn	BOOLEAN
isRedeemed	BOOLEAN
vnt	RECORD
cps	RECORD

Orders

The Orders API is a versatile tool for managing orders within the Smartrr system. You can create new orders, update existing ones, retrieve order details, and even delete orders when necessary.

For more information, see Orders.

Field Name	Data Type
createdDate	TIMESTAMP
updatedDate	TIMESTAMP
id	STRING
shopifyId	STRING
receivedFromShopifyDate	TIMESTAMP
shopifyUpdateDate	TIMESTAMP
shopifyOrderLabel	STRING
orderProcessedDate	TIMESTAMP
shippingLineItems	RECORD
discountApplications	RECORD
totalFromLineItems	STRING
totalLineItemsDiscount	STRING
totalLineItemsAfterDiscount	STRING
totalShipping	STRING
totalTax	STRING
totalDiscount	STRING
totalTip	STRING
totalRefund	STRING
totalBeforeDiscountsAndRefunds	STRING
totalNetBeforeRefunds	STRING
shopIncome	STRING
totalNet	STRING
totalOneTimeShopIncome	STRING
totalSubscriptionShopIncome	STRING
totalAddonShopIncome	STRING
orderCurrency	STRING
orderSource	STRING
orderStatus	STRING
financialStatus	STRING
fulfillmentStatus	STRING
deliveryLatitude	NUMERIC
deliveryLongitude	NUMERIC
deliveryProvinceCode	STRING
deliveryCountryCode	STRING
deliveryAddress	RECORD
isGifted	BOOLEAN
editedBundleOrder	BOOLEAN
containsSmartrrBundle	BOOLEAN
bundleEditStatus	STRING
items	RECORD
custRel	RECORD
pmtMthJson	RECORD
deliveryLongitude_bn	BIGNUMERIC
deliveryLatitude_bn	BIGNUMERIC
trackingInfo	RECORD
taxLineItems	RECORD
sts	RECORD