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.
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.
Tables/APIs
The following is the list of tables or APIs associated with the Skubana connector:
- Orders
- Returns
Skubana Data
Orders
Purpose: Retrieve a list of all orders
Source API Documentation: https://developer.extensiv.com/pages/order-manager.html#tag/Order/operation/getOrdersUsingGET_1
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
NAME |
DATATYPE |
|---|---|
rmaid |
NUMERIC |
shipmentid |
NUMERIC |
rmanumber |
STRING |
weight |
NUMERIC |
height |
NUMERIC |
width |
NUMERIC |
length |
NUMERIC |
insuranceprovider |
STRING |
insuredvalue |
RECORD |
insurancecost |
RECORD |
deliveryconfirmation |
STRING |
confirmationcost |
RECORD |
forwardtoemail |
STRING |
notes |
STRING |
items |
RECORD |
returnslocation |
RECORD |
issuedate |
NUMERIC |
instorereturn |
BOOLEAN |
items.losstoseller |
RECORD |
items.rmaorderitem |
RECORD |
items.rmaorderitem.product |
RECORD |
returnslocation.address |
RECORD |
