Schema Information of Skubana Connector

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

Saras Daton

Need help with something?

Talk to data expert

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

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

Orders

Purpose: Retrieve a list of all orders

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

NAME	DATATYPE
orderId	NUMERIC
orderNumber	STRING
billDutiesToPayor	BOOLEAN
confirmationCost	RECORD
containsAlcohol	BOOLEAN
containsDryIce	BOOLEAN
createdDate	TIMESTAMP
currency	STRING
customer	RECORD
customField1	STRING
customsDeclarationType	STRING
deliveryConfirmation	STRING
discount	RECORD
doNotPrepayPostage	BOOLEAN
dryIceWeight	NUMERIC
external	BOOLEAN
fulfillmentSource	RECORD
gift	BOOLEAN
height	NUMERIC
holdUntilDate	TIMESTAMP
includeReturnLabel	BOOLEAN
insuranceCost	RECORD
insuranceProvider	STRING
insuredValue	RECORD
labels	RECORD
length	NUMERIC
modifiedDate	TIMESTAMP
nonMachinable	BOOLEAN
orderDate	TIMESTAMP
orderItems	RECORD
orderStatus	STRING
orderTotal	RECORD
releaseWithoutSignature	BOOLEAN
requestedShippingService	STRING
salesChannel	RECORD
saturdayDelivery	BOOLEAN
shipEmail	STRING
shipMethod	RECORD
shipName	STRING
shippingCost	RECORD
shipAddress1	STRING
shipCity	STRING
shipState	STRING
shipZipCode	STRING
shipCountry	STRING
shipPhone	STRING
showPostage	BOOLEAN
unresolvedStatus	STRING
weight	NUMERIC
width	NUMERIC
orderType	STRING
orderItemTotal	RECORD
suppressChannelUpdate	BOOLEAN
fraudAnalysis	STRING
addressType	STRING
internationalNonDeliveryAction	STRING
subscription	BOOLEAN
pos	BOOLEAN
customShipBillingOption	STRING
amountPaid	RECORD
notesFromBuyer	STRING
paymentDate	TIMESTAMP
shipAddress2	STRING
shipment	RECORD
shipDate	TIMESTAMP
shipCompany	STRING
giftMessage	STRING
relatedOrderIds	STRING
cancelReason	RECORD
shipments	RECORD
internalNotes	STRING
customField2	STRING
customField3	STRING
notesToBuyer	STRING
shipAddress3	STRING

Returns

Purpose: Retrieve a list of all RMAs

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

connector schema

Table of Contents

Tables/APIs Skubana Data