# Schema Information

## Tables/APIs 

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

* [Inventory](#inventory) 
* [Orders](#orders) 
* [Products](#products) 
* [Return Orders](#return-orders)

#### Inventory 

The Inventory API accesses real-time data and manages product inventory across multiple locations within ShipBob's fulfillment centers.

For more information, see [Shipbob- Inventory](https://developer.shipbob.com/api-docs#tag/Inventory).

**Fields**

| Field Name                                     | Data Type |
| ---------------------------------------------- | --------- |
| id                                             | NUMERIC   |
| name                                           | STRING    |
| is\_digital                                    | BOOLEAN   |
| is\_case\_pick                                 | BOOLEAN   |
| is\_lot                                        | BOOLEAN   |
| dimensions                                     | RECORD    |
| total\_fulfillable\_quantity                   | NUMERIC   |
| total\_onhand\_quantity                        | NUMERIC   |
| total\_committed\_quantity                     | NUMERIC   |
| total\_sellable\_quantity                      | NUMERIC   |
| total\_awaiting\_quantity                      | NUMERIC   |
| total\_exception\_quantity                     | NUMERIC   |
| total\_internal\_transfer\_quantity            | NUMERIC   |
| total\_backordered\_quantity                   | NUMERIC   |
| is\_active                                     | BOOLEAN   |
| fulfillable\_quantity\_by\_fulfillment\_center | RECORD    |
| fulfillable\_quantity\_by\_lot                 | RECORD    |
| packaging\_attribute                           | STRING    |

#### Orders 

The Orders API creates, tracks, and manages orders, enabling efficient order fulfillment processes.

For more information, see [Shipbob- Orders](https://developer.shipbob.com/api-docs#tag/Orders).

**Fields**

| Field Name       | Data Type |
| ---------------- | --------- |
| id               | NUMERIC   |
| created\_date    | TIMESTAMP |
| purchase\_date   | TIMESTAMP |
| reference\_id    | STRING    |
| order\_number    | STRING    |
| status           | STRING    |
| type             | STRING    |
| channel          | RECORD    |
| shipping\_method | STRING    |
| recipient        | RECORD    |
| shipments        | RECORD    |
| financials       | RECORD    |

#### Products 

The Products API provides programmatic control over your product catalog, allowing you to update and retrieve product information.

For more information, see [Shipbob- Products](https://developer.shipbob.com/api-docs#tag/Products).

**Fields**

| Field Name                                     | Data Type |
| ---------------------------------------------- | --------- |
| id                                             | NUMERIC   |
| reference\_id                                  | STRING    |
| created\_date                                  | TIMESTAMP |
| channel                                        | RECORD    |
| sku                                            | STRING    |
| name                                           | STRING    |
| total\_fulfillable\_quantity                   | NUMERIC   |
| total\_onhand\_quantity                        | NUMERIC   |
| total\_committed\_quantity                     | NUMERIC   |
| fulfillable\_inventory\_items                  | RECORD    |
| fulfillable\_quantity\_by\_fulfillment\_center | RECORD    |

#### Return Orders

The Return Orders handles return-related operations, including creating, tracking, and processing return orders for a smoother customer experience.

For more information, see [Shipbob- Return Orders](https://developer.shipbob.com/api-docs#tag/Returns).

**Fields**

| Field Name             | Data Type |
| ---------------------- | --------- |
| id                     | NUMERIC   |
| channel                | RECORD    |
| insert\_date           | TIMESTAMP |
| status                 | STRING    |
| invoice\_amount        | NUMERIC   |
| transactions           | RECORD    |
| fulfillment\_center    | RECORD    |
| reference\_id          | STRING    |
| tracking\_number       | STRING    |
| inventory              | RECORD    |
| original\_shipment\_id | NUMERIC   |
| return\_type           | STRING    |
| completed\_date        | TIMESTAMP |
| store\_order\_id       | STRING    |