---
title: "Integration: Skubana"
description: This article will help you learn about how Daasity replicates data from Skubana, limitations to the data we can extract and where the data is stored in the Skubana schema
---

[Back to home](https://support.daasity.com/migrated/knowledge)

- [ Welcome to Daasity
  
  
  
  ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity) 
    - [ Integration Setup | Connect Your Data Sources ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-connect-your-data-sources)
    - [ Integration Setup | Amazon Seller Central ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-amazon-seller-central)
    - [ Navigating the Daasity App ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#navigating-the-daasity-app)
- [ Daasity Platform | Business User Analytics
  
  
  
  ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics) 
    - [ Brand Supplied Data (BSD) ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#brand-supplied-data-bsd)
    - [ Dashboards ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#dashboards)
    - [ Reports ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#reports)
    - [ Explores ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#explores)
    - [ Views ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#views)
    - [ Audiences ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#audiences)
    - [ Customizations ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#customizations)
- [ ELT+ | Technical User Documentation
  
  
  
  ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation) 
    - [ Platform ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#platform)
    - [ Transformation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#transformation)
    - [ Integrations ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#integrations)
- [ User Manual and Support
  
  
  
  ](https://support.daasity.com/migrated/knowledge/user-manual-and-support) 
    - [ Daasity Logic and Best Practices ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#daasity-logic-and-best-practices)
    - [ Marketing Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#marketing-analytics)
    - [ Customer Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#customer-analytics)
    - [ Date Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#date-analytics)
    - [ Inventory and Returns Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#inventory-and-returns-analytics)
    - [ Submit a Support Request ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#submit-a-support-request)
- [ Release Updates
  
  
  
  ](https://support.daasity.com/migrated/knowledge/release-updates) 
    - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates#release-updates)

# Integration: Skubana

## This article will help you learn about how Daasity replicates data from Skubana, limitations to the data we can extract and where the data is stored in the Skubana schema

### Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

- <https://support.daasity.com/migrated/knowledge/integration-skubana#extraction-overview>[API Endpoints](https://support.daasity.com/migrated/knowledge/integration-skubana#api-endpoints)
- [Entity Relationship Diagram](https://support.daasity.com/migrated/knowledge/integration-skubana#erd)
- [Skubana Schema](https://support.daasity.com/migrated/knowledge/integration-skubana#skubana-schema)
- [Related Resources](https://support.daasity.com/migrated/knowledge/integration-skubana#related-resources)

### Integration Availability

This integration is available for:

- Growth (see [Related Resources](https://support.daasity.com/migrated/knowledge/integration-skubana#related-resources) for more information on how Skubana works in Growth)
- Pro

### API Endpoints

The Daasity Skubana extractor is built based on this [Skubana API documentation](https://documentation.skubana.com/spec/).  The following endpoints are used by Daasity to replicate data from Skubana:

- [Company Info](https://documentation.skubana.com/spec/#operation/getCompanyInfoUsingGET)
- [Retrieve FBA inventory](https://documentation.skubana.com/spec/#operation/getFbaInventoryUsingGET)
- [Inventory](https://documentation.skubana.com/spec/#operation/getInventoryUsingGET)
- [Orders](https://documentation.skubana.com/spec/#operation/getOrdersUsingGET_1)
- [Warehouses](https://documentation.skubana.com/spec/#operation/getWarehousesUsingGET)
- [Shipment Providers](https://documentation.skubana.com/spec/#operation/getShippingProvidersUsingGET)
- [Products](https://documentation.skubana.com/spec/#operation/getProductsV11UsingGET)
- [Product Listing](https://documentation.skubana.com/spec/#operation/getListingsUsingGET)
- [Product Stock Totals](https://documentation.skubana.com/spec/#operation/getProductStocksTotalUsingGET)<https://documentation.skubana.com/spec/#operation/getOrdersUsingGET_1>  
  <https://documentation.skubana.com/spec/#operation/getFbaInventoryUsingGET>
- [Purchase Orders](https://documentation.skubana.com/spec/#operation/getPurchaseOrdersUsingGET_1)<https://documentation.skubana.com/spec/#operation/getInventoryUsingGET>
- [Sales Channels](https://documentation.skubana.com/spec/#operation/getSalesChannelsUsingGET)
- [Shipments](https://documentation.skubana.com/spec/#operation/getShipmentsUsingGET)
- [Vendors](https://documentation.skubana.com/spec/#operation/getVendorsUsingGET_1)

The Orders endpoint runs each hour and all other endpoints are updated daily.  

**Limitation**: due to the impact on Skubana, for merchants with a large number of products, the Product Stock Totals endpoint will be used in lieu of the Inventory endpoint to ensure that the API will return data in a timely manner

### Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Skubana integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

### Skubana Schema

The Daasity Skubana extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

- [FBA Inventory Levels](https://support.daasity.com/migrated/knowledge/integration-skubana#fba-inventory-levels)
- [Inventory Levels](https://support.daasity.com/migrated/knowledge/integration-skubana#inventory-levels)
- [Listing SKU](https://support.daasity.com/migrated/knowledge/integration-skubana#listing-sku)
- [Order Items](https://support.daasity.com/migrated/knowledge/integration-skubana#order-items)
- [Orders](https://support.daasity.com/migrated/knowledge/integration-skubana#orders)
- [Purchase Order Items](https://support.daasity.com/migrated/knowledge/integration-skubana#purchase-order-items)
- [Purchase Orders](https://support.daasity.com/migrated/knowledge/integration-skubana#purchase-orders)
- [Related Orders](https://support.daasity.com/migrated/knowledge/integration-skubana#related-orders)
- [Sales Channels](https://support.daasity.com/migrated/knowledge/integration-skubana#sales-channels)
- [Shipment Carrier Services](https://support.daasity.com/migrated/knowledge/integration-skubana#shipment-carrier-services)
- [Shipment Carriers](https://support.daasity.com/migrated/knowledge/integration-skubana#shipment-carriers)
- [Shipment Package Types](https://support.daasity.com/migrated/knowledge/integration-skubana#shipment-package-types)
- [Shipments](https://support.daasity.com/migrated/knowledge/integration-skubana#shipments)
- [SKU Attributes](https://support.daasity.com/migrated/knowledge/integration-skubana#sku-attributes)
- [SKU Components](https://support.daasity.com/migrated/knowledge/integration-skubana#sku-components)
- [SKU Labels](https://support.daasity.com/migrated/knowledge/integration-skubana#sku-labels)
- [SKUs](https://support.daasity.com/migrated/knowledge/integration-skubana#skus)
- [Vendors](https://support.daasity.com/migrated/knowledge/integration-skubana#vendors)
- [Warehouses](https://support.daasity.com/migrated/knowledge/integration-skubana#warehouses)

FBA Inventory Levels

- Endpoint: [Retrieve FBA inventory](https://documentation.skubana.com/spec/#operation/getFbaInventoryUsingGET)
- Update method: UPSERT
- Table Name: skubana.fba_inventory_levels

| **JSON Element** | **Database Column** |
| --- | --- |
| asin + fnsku | key |
| asin | asin |
| fnSku | fnsku |
| inStockSupplyQuantity | in_stock_quantity_supply |
| listingSku | listing_sku |
| product::fnSku | product_fnsku |
| product::masterSku | product_master_sku |
| product::mpn | product_mpn |
| product::name | product_name |
| product::productId | product_product_id |
| product::productType | product_product_type |
| product::upc | product_upc |
| productCondition | product_condition |
| totalSupplyQuantity | total_supply_quantity |
| warehouse::warehouseId | warehouse_id |

#### Inventory Levels

- Endpoint: [Inventory](https://documentation.skubana.com/spec/#operation/getInventoryUsingGET) or [Product Stock Totals](https://documentation.skubana.com/spec/#operation/getProductStocksTotalUsingGET) depending on the volume of SKUs
- Update method: UPSERT
- Table Name: skubana.inventory_levels

**NOTE:** Daasity cycles through each warehouse to retrieve the inventory data

**WARNING: **For merchants with a large volume of SKUs the Inventory endpoint is not performant as Skubana has to do calculations to determine the on hand quantity.  If you have a large number of SKUs we will use the Product Stock Totals endpoint instead but populate the same table

| **JSON Element** | **Database Column** |
| --- | --- |
| masterSKU + productId + upc | key |
| inTransitQuantity | in_transit_quantity |
| lockedQuantity | locked_quantity |
| onHandQuantity | on_hand_quantity |
| product::description | description |
| product::fnSku | fnsku |
| product::hazmat | hazmat |
| product::masterSku | master_sku |
| product::mpn | mpn |
| product::name | name |
| product::productId | product_id |
| product::productType | product_type |
| product::productWeight | product_weight |
| product::upc | upc |
| from API call | warehouse_id |

#### Listing SKU

- Endpoint: [Product Listing](https://documentation.skubana.com/spec/#operation/getListingsUsingGET)
- Update method: UPSERT
- Table Name: skubana.listing_sku

| **JSON Element** | **Database Column** |
| --- | --- |
| listingId | listing_id |
| productId | product_id |
| fnSku | fnsku |
| masterSku | master_sku |
| listingSku | listing_sku |
| pushInventory | push_inventory_flag |
| salesChannelId | sales_channel_id |
| active | active |
| masterSku+listingId+productId+listingSku | key |
| created | created_at |
| lastModified | updated_at |

#### Order Items

- Endpoint: [Orders](https://documentation.skubana.com/spec/#operation/getOrdersUsingGET_1)
- Update method: UPSERT
- Table Name: skubana.order_items

| **JSON Element** | **Database Column** |
| --- | --- |
| orderId + orderItems::orderItemId | key |
| orderItems::listingName | listing_name |
| orderItems::listingSku | listing_sku |
| orderId | order_id |
| orderItems::orderItemId | order_item_id |
| orderItems::product::fnSku | product_fnsku |
| orderItems::product::masterSku | product_master_sku |
| orderItems::product::mpn | product_mpn |
| orderItems::product::name | product_name |
| orderItems::product::productId | product_product_id |
| orderItems::product::productType | product_product_type |
| orderItems::product::upc | product_upc |
| orderItems::quantityOrdered | quantity_ordered |
| orderItems::unitPrice::amount | unit_price_amount |
| orderItems::unitPrice::currency | unit_price_currency |
| orderItems::tax::amount | tax_amount |
| orderItems::tax::currency | tax_currency |

#### Orders

- Endpoint: [Orders](https://documentation.skubana.com/spec/#operation/getOrdersUsingGET_1)
- Update method: UPSERT
- Table Name: skubana.orders

| **JSON Element** | **Database Column** |
| --- | --- |
| orderId | order_id |
| cancelReason::details | cancel_reason_details |
| cancelReasons::type | cancel_reason_type |
| currency | currency |
| customer::companyName | customer_company_name |
| customer::emailAddresses | customer_email_addresses |
| customer::name | customer_name |
| discount::amount | discount_amount |
| fulfillmentSource::name | fulfillment_source_name |
| fulfillmentSource::warehouseId | fulfillment_source_warehouse_id |
| orderDate | order_date |
| orderItemTotal::amount | order_item_total_amount |
| orderItemTotal::currency | order_item_total_currency |
| orderNumber | order_number |
| orderStatus | order_status |
| orderTotal::amount | order_total_amount |
| orderTotal::currency | order_total_currency |
| orderType | order_type |
| paymentDate | payment_date |
| paymentType::name | payment_type_name |
| salesChannel::name | sales_channel_name |
| salesChannel::salesChannelId | sales_channel_id |
| salesChannel::type | sales_channel_type |
| shipCompany | ship_company |
| shipEmail | ship_email |
| shipAddress1 | ship_address1 |
| shipAddress2 | ship_address2 |
| shipCity | ship_city |
| shipState | ship_state |
| shipZipCode | ship_zip_code |
| shipPhone | ship_phone |
| shipCountry | ship_country |
| shipDate | ship_date |
| shipMethod::shippingProviderId | shipping_provider_id |
| shipMethod::shippingServiceId | shipping_service_id |
| shipment::shipmentId | shipment_id |
| shippingCost::amount | shipping_cost_amount |
| createdDate | created_at |
| modifiedDate | updated_at |

#### Purchase Order Items

- Endpoint: [Purchase Orders](https://documentation.skubana.com/spec/#operation/getPurchaseOrdersUsingGET_1)
- Update method: UPSERT
- Table Name: skubana.purchase_order_items

| **JSON Element** | **Database Column** |
| --- | --- |
| purchaseOrderID + purchaseOrderItems::purchaseOrderItemId | key |
| purchaseOrderId | purchase_order_id |
| purchaseOrderItems::billedDate | billed_date |
| purchaseOrderItems::billedUnitCost::amount | billed_unit_cost_amount |
| purchaseOrderItems::billedUnitCost::currency | billed_unit_cost_currency |
| purchaseOrderItems::deliveryDate | delivery_date |
| purchaseOrderItems::discount::amount | discount_amount |
| purchaseOrderItems::discount::discountType | discount_type |
| purchaseOrderItems::estimatedDeliveryDate | estimated_delivery_date |
| purchaseOrderItems::landedUnitCost::amount | landed_unit_cost_amount |
| purchaseOrderItems::landedUnitCost::currency | landed_unit_currency |
| purchaseOrderItems::memo | memo |
| purchaseOrderItems::originalUnitCost::amount | original_unit_cost_amount |
| purchaseOrderItems::originalUnitCost::currency | original_unit_cost_currency |
| purchaseOrderItems::packaging | packaging |
| purchaseOrderItems::percentageTax | percentage_tax |
| purchaseOrderItems::productStockId | product_stock_id |
| purchaseOrderItems::purchaseOrderItemId | purchase_order_item_id |
| purchaseOrderItems::quantity | quantity |
| purchaseOrderItems::referenceNumber | reference_number |
| purchaseOrderItems::status | status |
| purchaseOrderItems::unitOfMeasure | unit_of_measure |
| purchaseOrderItems::uomUnitQuantity | uom_unit_quantity |
| purchaseOrderItems::vendorProductId | vendor_product_id |
| purchaseOrderItems::vendorProductMasterSku | vendor_product_master_sku |
| purchaseOrderItems::vendorProductVendorSku | vendor_product_vendor_sku |
| purchaseOrderItems::receivedDate | received_date |

#### Purchase Orders

- Endpoint: [Purchase Orders](https://documentation.skubana.com/spec/#operation/getPurchaseOrdersUsingGET_1)
- Update method: UPSERT
- Table Name: skubana.purchase_orders

| **JSON Element** | **Database Column** |
| --- | --- |
| vendorId | vendor_id |
| vendorConfirmedOnDate | vendor_confirmed_on_date |
| vendorConfirmByDate | vendor_confirm_by_date |
| type | type |
| status | status |
| shippingCost::amount | shipping_cost_amount |
| shippingCost::currency | shipping_cost_currency |
| purchaseOrderTemplateId | purchase_order_template_id |
| purchaseOrderId | purchase_order_id |
| paymentTerm::active | payment_term_active |
| paymentTerm::description | payment_term_description |
| paymentTerm::vendorPaymentTermId | payment_term_id |
| number | number |
| internalNotes | internal_notes |
| incortermShippingRuleId | incoterm_shipping_rule_id |
| incotermShippingRule | incoterm_shipping_rule |
| format | format |
| dropshipOrderId | dropship_order_id |
| destinationWarehouseId | destination_warehouse_id |
| dateModified | date_modified |
| dateIssued | date_issued |
| dateCreated | date_created |
| dateAuthorized | date_authorized |
| currency | currency |
| createdBy::email | created_by_email |
| createdBy::name | created_by_name |
| createdBy::userId | created_by_user_id |
| autoUpdatesEnabled | auto_updates_enabled |
| authorizer::email | authorizer_email |
| authorizer::name | authorizer_name |
| authorizer::userId | authorizer_user_id |

#### Related Orders

- Endpoint: [Orders](https://documentation.skubana.com/spec/#operation/getOrdersUsingGET_1)
- Update method: UPSERT
- Table Name: skubana.related_orders

| **JSON Element** | **Database Column** |
| --- | --- |
| orderId | order_id |
| relatedOrderIds | related_order_id |

#### Sales Channels

- Endpoint: [Sales Channels](https://documentation.skubana.com/spec/#operation/getSalesChannelsUsingGET)
- Update method: UPSERT
- Table Name: skubana.sales_channels

| **JSON Element** | **Database Column** |
| --- | --- |
| companyName + name + salesChannelId + type | key |
| companyName | company_name |
| name | name |
| salesChannelId | sales_channel_id |
| type | type |

#### Shipment Carrier Services

- Endpoint: [Shipment Providers](https://documentation.skubana.com/spec/#operation/getShippingProvidersUsingGET)
- Update method: UPSERT
- Table Name: skubana.shipment_carrier_services

| **JSON Element** | **Database Column** |
| --- | --- |
| shippingProviderId + shippingServices::shippingServiceId | key |
| shippingProviderId | shipping_carrier_id |
| shippingServices::shippingServiceId | shipping_service_id |
| shippingServices::shippingCarrier | shipping_carrier |
| shippingServices::serviceName | service_name |
| shippingServices::serviceCode | service_code |
| shippingServices::abbreviation | abbreviation |
| shippingServices::international | international |
| shippingServices::weightRequired | weight_required |
| shippingServices::dimensionsRequired | dimensions_required |
| shippingServices::halfPageLabel | half_page_label |
| shippingServices::active | active |

#### Shipment Carriers

- Endpoint: [Shipment Providers](https://documentation.skubana.com/spec/#operation/getShippingProvidersUsingGET)
- Update method: UPSERT
- Table Name: skubana.shipment_carriers

| **JSON Element** | **Database Column** |
| --- | --- |
| active | active |
| name | name |
| shippingProviderId | shipment_carrier_id |
| type | type |

#### Shipment Package Types

- Endpoint: [Shipment Providers](https://documentation.skubana.com/spec/#operation/getShippingProvidersUsingGET)
- Update method: UPSERT
- Table Name: skubana.shipment_package_types

| **JSON Element** | **Database Column** |
| --- | --- |
| shippingProviderId + packageTypes::packageTypeId | key |
| shippingProviderId | shipment_carrier_id |
| packageTypes::packageTypeId | package_type_id |
| packageTypes::shippingCarrier | shipping_carrier |
| packageTypes::packageName | package_name |
| packageTypes::description | description |
| packageTypes::abbreviation | abbreviation |
| packageTypes::packageCode | package_code |
| packageTypes::domestic | domestic |
| packageTypes::international | international |
| packageTypes::weightRequired | weight_required |
| packageTypes::active | active |

#### Shipments

- Endpoint: [Shipments](https://documentation.skubana.com/spec/#operation/getShipmentsUsingGET)
- Update method: UPSERT
- Table Name: skubana.shipments

| **JSON Element** | **Database Column** |
| --- | --- |
| batchNumber | batch_number |
| carrierFee::amount | carrier_fee_amount |
| carrierFee::currency | carrier_fee_currency |
| deliveryStatus | delivery_status |
| estimatedArrival | estimated_arrival |
| orderId | order_id |
| orderNumber | order_number |
| received | received |
| rma | rma |
| shipDate | ship_date |
| shipMethod::packageTypeId | ship_method_package_type_id |
| shipMethod::shippingCarrier | ship_method_shipping_carrier |
| shipMethod::shippingProviderId | ship_method_shipping_provider_id |
| shipMethod::shippingServiceId | ship_method_shipping_service_id |
| shipmentId | shipment_id |
| trackingNumber | tracking_number |
| transactionId | transaction_id |
| type | type |
| warehouseId | warehouse_id |
| created | created_at |

#### SKU Attributes

- Endpoint: [Products](https://documentation.skubana.com/spec/#operation/getProductsV11UsingGET)
- Update method: UPSERT
- Table Name: skubana.sku_attributes

| **JSON Element** | **Database Column** |
| --- | --- |
| productId + attributeGroups::attributeGroupId + attributeGroups::attributes::attributeId | key |
| productId | product_id |
| attributeGroups::attributeGroupId | attribute_group_id |
| attributeGroups::attributes::attributeId | attribute_id |
| attributeGroups::attributes::name | attribute_name |

#### SKU Components

- Endpoint: [Products](https://documentation.skubana.com/spec/#operation/getProductsV11UsingGET)
- Update method: UPSERT
- Table Name: skubana.sku_components

| **JSON Element** | **Database Column** |
| --- | --- |
| productId + bundledItems::bundleItemId | key |
| productId | parent_product_id |
| bundledItems::bundleItemId | bundle_item_id |
| bundledItems::bundledProducts::fnSku | bundled_product_fnsku |
| bundledItems::bundledProducts::masterSku | bundled_product_mastersku |
| bundledItems::bundledProducts::mpn | bundled_product_mpn |
| bundledItems::bundledProducts::name | bundled_product_name |
| bundledItems::bundledProducts::productId | bundled_product_product_id |
| bundledItems::bundledProducts::productType | bundled_product_product_type |
| bundledItems::bundledProducts::upc | bundled_product_upc |
| bundledItems::bundledProductQuantity | bundled_product_quantity |
| bundledItems::product::fnSku | product_fnsku |
| bundledItems::product::masterSku | product_master_sku |
| bundledItems::product::mpn | product_mpn |
| bundledItems::product::name | product_name |
| bundledItems::product::productId | product_product_id |
| bundledItems::product::productType | product_product_type |
| bundledItems::product::upc | product_upc |

#### SKU Labels

- Endpoint: [Products](https://documentation.skubana.com/spec/#operation/getProductsV11UsingGET)
- Update method: UPSERT
- Table Name: skubana.sku_labels

| **JSON Element** | **Database Column** |
| --- | --- |
| productId + labels | key |
| productId | product_id |
| labels | label |

#### SKUs

- Endpoint: [Products](https://documentation.skubana.com/spec/#operation/getProductsV11UsingGET)
- Update method: UPSERT
- Table Name: skubana.skus

| **JSON Element** | **Database Column** |
| --- | --- |
| productId | product_id |
| name | name |
| active | active |
| allowBackorders | allow_backorders |
| brand | brand |
| bundle | bundle |
| height | height |
| length | length |
| masterSku | master_sku |
| mapPrice::amount | map_price_amount |
| mapPrice::currency | map_price_currency |
| ounces | ounces |
| pounds | pounds |
| shippingCost::amount | shipping_cost_amount |
| shippingCost::currency | shipping_cost_currency |
| shipsInOwnBox | ships_in_own_box |
| type | type |
| upc | upc |
| vendorCost::amount | vendor_cost_amount |
| vendorCost::currency | vendor_cost_currency |
| weight | weight |
| width | width |
| createdDate | created_at |
| modifiedDate | updated_at |

#### Vendors

- Endpoint: [Vendors](https://documentation.skubana.com/spec/#operation/getVendorsUsingGET_1)
- Update method: UPSERT
- Table Name: skubana.vendors

| **JSON Element** | **Database Column** |
| --- | --- |
| vendorId | vendor_id |
| active | active |
| address::address1 | address1 |
| address::address2 | address2 |
| address::address3 | address3 |
| address::city | city |
| address::country | country |
| address::province | province |
| address::state | state |
| address::type | address_type |
| address::zipCode | zipcode |
| contactEmail | contact_email |
| contactPhone1 | contact_phone1 |
| contactPhone2 | contact_phone2 |
| defaultIncotermShippingRule | default_incoterm_shipping_rule |
| defaultIncotermShippingRuleId | default_incoterm_shipping_rule_id |
| defaultPurchaseOrderFormat | default_purchase_order_format |
| defaultPurchaseOrderFormatId | default_purchase_order_template_id |
| defaultVendorPaymentTerm::active | default_vendor_payment_term_active |
| defaultVendorPaymentTerm::description | default_vendor_payment_term_desc |
| defaultVendorPaymentTerm::vendorPaymentTermId | default_vendor_payment_term_id |
| dropshipPurchaseOrderTemplateId | dropship_purchase_order_template_id |
| dropshipper | dropshipper |
| fax | fax |
| manufacturer | manufacturer |
| percentageTax | percentage_tax |
| purchaseOrderEmail | purchase_order_email |
| supplier | supplier |
| warehouse::name | warehouse_name |
| warehouse::warehouseId | warehouse_id |
| website | website |
| name | name |

#### Warehouses

- Endpoint: [Warehouses](https://documentation.skubana.com/spec/#operation/getWarehousesUsingGET)
- Update method: UPSERT
- Table Name: skubana.warehouses

| **JSON Element** | **Database Column** |
| --- | --- |
| warehouseId | warehouse_id |
| active | active |
| name | name |

### Related Resources

- [Dashboard: Inventory](https://support.daasity.com/knowledge/inventory-dashboard)
- [Dashboard: Orders & Revenue](https://support.daasity.com/knowledge/orders-revenue-dashboard)
- [Skubana in Growth](https://support.daasity.com/knowledge/skubana-in-growth)