# 3PL Central (v2)
Information note **3PL Central is supported by the Singer community**
This integration is powered by [Singer's](https://www.singer.io/) 3PL Central tap. For support, [visit the GitHub repo](https://github.com/singer-io/tap-3plcentral) or [join the Singer Slack](https://singer-slackin.herokuapp.com/).
## 3PL Central feature snapshot
A high-level look at Stitch's 3PL Central (v2) integration, including release status, useful links, and the features supported in Stitch.
| **STITCH** | | | |
| --- | --- | --- | --- |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on May 28, 2026 | **Supported by**
the Info icon
Indicates if the integration is supported by Stitch or the Singer community. | [Singer Community](https://www.singer.io/) |
| **Stitch plan**
the Info icon
The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**
the Info icon
Indicates if the integration is available as a source in Stitch Connect. | the Success icon
This version of the integration is available via the API.
Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon
This feature is supported for this version of the integration.
Supported | **Column selection**
the Info icon
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon
This feature is supported for this version of the integration.
Supported |
| **Select all**
the Info icon
Indicates if the integration supports selecting all available tables and columns. | the Success icon
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon
This feature is supported for this version of the integration.
Supported |
## Connecting 3PL Central
### Step 1: Request API credentials from 3PL Central
1. Log into your 3PL Central account and request the following information from your account manager:
* **Base URL**: The API URL to which endpoints are appended.
* **Client ID**: Your secure OAuth 2.0 identifier.
* **Client Secret**: Your secure OAuth 2.0 secret key.
* **Customer ID**: The integer ID number for your customer organization.
* **Facility ID**: The integer ID number for your warehouse facility.
* **TPL Key**: Your warehouse-specific 3PL Central key.
* **User Login**: The interger ID number for your user account.
2. Keep this information available so you can add the integration in the next step.
### Step 2: Add 3PL Central as a Stitch data source
1. [Sign into your Stitch account](https://app.stitchdata.com/).
2. On the Stitch Dashboard page, click the **Add Integration** button.
3. Click the **3PL Central** icon.
4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch 3PL Central” would create a schema called `stitch_3pl_central` in the destination. **Note**: Schema names cannot be changed after you save the integration.
5. Enter the information you requested from [Step 1](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#request-api) into the corresponding fields in Stitch.
### Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your 3PL Central integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond 3PL Central’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide.
### Step 4: Create a replication schedule
Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information.
In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
3PL Central integrations support the following replication scheduling methods:
* [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency)
* [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)
* [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage.
### Step 5: Set objects to replicate
Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements).
The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#schema)
**Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts.
* Selection options
* Individual tables and columns
* All tables and columns
For 3PL Central integrations, you can select:
1. **Individual tables and columns**
2. **All tables and columns**
Click the tabs to view instructions for each selection method.
1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate.
2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate.
3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate.
4. Repeat this process for all the tables and columns you want to replicate.
5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections.
Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature.
1. Click into the integration from the Stitch Dashboard page.
2. Click the **Tables to Replicate** tab.
3. In the list of tables, click the box next to the **Table Names** column.
4. In the menu that displays, click **Track all Tables and Fields**:
The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab
5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections.
### Initial and historical replication jobs
After you finish setting up 3PL Central, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.**
Information note
**Initial replication jobs with Anchor Scheduling**
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information.
#### Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage.
## 3PL Central table reference
Information note
**Schemas and versioning**
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for **version 2** of this integration.
This is the latest version of the 3PL Central integration.
Information note
**Table and column names in your destination**
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info.
### customers
This table contains information about customers.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | customer\_id |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[customers schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/customers.json "Opens in new tab: customers schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/customers/customers "Opens in new tab: 3PL Central API method") |
customers table foreign keys
| Join customers with | on |
| --- | --- |
| [sku_items](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#sku-items) | ``` customers.customer_id = sku_items.customer_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand company\_info
address1
STRING
address2
STRING
address_status
INTEGER
city
STRING
code
STRING
company_name
STRING
contact_id
INTEGER
country
STRING
dept
STRING
email_address
STRING
fax
STRING
name
STRING
phone_number
STRING
state
STRING
title
STRING
zip
STRING
|
| --- |
| **creation\_date**
DATE-TIME |
| **customer\_id**
INTEGER |
| **deactivated**
BOOLEAN |
| **external\_id**
STRING |
| **facilities**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand facilities
id
INTEGER
name
STRING
|
| **groups**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. |
| **options**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand options
alerts
OBJECT
expiration_notification_threshold
INTEGER
from_email_address
STRING
notify_ship_to
BOOLEAN
edi
OBJECT
customer_interchange_id
STRING
customer_interchange_id_qual
STRING
threepl_interchange_id
STRING
threepl_interchange_id_qual
STRING
trading_partner_id
STRING
other_system_behaviors
OBJECT
flex_fields
BOOLEAN
require_attached_documents
BOOLEAN
packaging
OBJECT
small_parcel_create_packages_on_find
BOOLEAN
small_parcel_customize_duties
BOOLEAN
small_parcel_duties_and_taxes
STRING
small_parcel_duty_billing_type
STRING
small_parcel_high_volume_default_checked
BOOLEAN
small_parcel_high_volume_zpl_batched
BOOLEAN
small_parcel_rate_shopping_carrier_ids
STRING
small_parcel_rate_shopping_logic
STRING
small_parcel_references
STRING
small_parcel_return_default_checked
BOOLEAN
small_parcel_return_fed_ex_service
STRING
small_parcel_return_shipping_cost
BOOLEAN
small_parcel_return_ups_service
STRING
small_parcel_usps_3rd_party
STRING
small_parcel_usps_return_type
STRING
sps_close_on_update
BOOLEAN
ucc128_manufacturers_id
INTEGER
use_vendor_id_on_bol
BOOLEAN
receivers
OBJECT
defs
ARRAY
name
STRING
required
BOOLEAN
item_defs
ARRAY
name
STRING
required
BOOLEAN
receiving
OBJECT
autofill_track_bys
BOOLEAN
create_multiple_mus
BOOLEAN
inherit_original_receipt_date_on_transfer
BOOLEAN
purchase_orders
BOOLEAN
receive_against_asns
INTEGER
require_scac_for_asn
BOOLEAN
suggest_put_away_enabled
BOOLEAN
track_location
INTEGER
track_pallets
INTEGER
track_supplier
INTEGER
saved_elements
OBJECT
orders
OBJECT
defs
ARRAY
name
STRING
required
BOOLEAN
item_defs
ARRAY
name
STRING
required
BOOLEAN
shipping
OBJECT
auto_confirm_order_on_tracking_update
BOOLEAN
bol_num_as_trans_num
BOOLEAN
fed_ex_account_number
STRING
fulfillment_invoicing
INTEGER
next_master_bol_id
INTEGER
next_master_bol_id_override
INTEGER
order_queue
BOOLEAN
packing_list_footer_url
STRING
packing_list_logo_url
STRING
prepopulate_carrier_info
INTEGER
require_tracking_number
BOOLEAN
roundupto_full_mu
BOOLEAN
ups_account_number
STRING
ups_account_zip
STRING
storage
OBJECT
accounting_customer_name
STRING
autofill_charges_on_confirm
BOOLEAN
fuel_surcharge
NUMBER
set_invoice_date_to_xaction_confirm_date
BOOLEAN
user_interface
OBJECT
auto_check_auto_reallocate_on_receive
BOOLEAN
branding_image_id
INTEGER
dashboard
BOOLEAN
exclude_location_with_zero_inventory
BOOLEAN
hide_location_selected_list
BOOLEAN
mobile_receipt_quantity_one_default
BOOLEAN
reallocate_at_pick_time
BOOLEAN
transaction_confirm_invoice_create_default
INTEGER
|
| **other\_contacts**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand other\_contacts
address1
STRING
address2
STRING
address_status
INTEGER
city
STRING
code
STRING
company_name
STRING
contact_id
INTEGER
country
STRING
dept
STRING
email_address
STRING
fax
STRING
name
STRING
phone_number
STRING
state
STRING
title
STRING
type
INTEGER
zip
STRING
|
| **primary\_contact**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand primary\_contact
address1
STRING
address2
STRING
address_status
INTEGER
city
STRING
code
STRING
company_name
STRING
contact_id
INTEGER
country
STRING
dept
STRING
email_address
STRING
fax
STRING
name
STRING
phone_number
STRING
state
STRING
title
STRING
zip
STRING
|
| **primary\_facility\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand primary\_facility\_identifier
id
INTEGER
name
STRING
|
| **website**
STRING |
### inventory
This table contains information about inventory resources.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | receive\_item\_id |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[inventory schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/inventory.json "Opens in new tab: inventory schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/inventory/inventory "Opens in new tab: 3PL Central API method") |
inventory table foreign keys
| Join inventory with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#customers) | ``` inventory.customer_identifier.id = customers.customer_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand customer\_identifier
external_d
STRING
id
INTEGER
name
STRING
|
| **expiration\_date**
DATE-TIME |
| **facility\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand facility\_identifier
id
INTEGER
name
STRING
|
| **inventory\_unit\_of\_measure\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand inventory\_unit\_of\_measure\_identifier
id
INTEGER
name
STRING
|
| **inventory\_units\_per\_secondary\_unity**
NUMBER |
| **item\_description**
STRING |
| **item\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand item\_identifier
id
INTEGER
sku
STRING
|
| **location\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand location\_identifier
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
|
| **lot\_number**
STRING |
| **on\_hand\_qty**
NUMBER |
| **on\_hold**
BOOLEAN |
| **on\_hold\_date**
DATE-TIME |
| **on\_hold\_qty**
NUMBER |
| **on\_hold\_reason**
STRING |
| **on\_hold\_user\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand on\_hold\_user\_identifier
id
INTEGER
name
STRING
|
| **pallet\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand pallet\_identifier
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
|
| **qualifier**
STRING |
| **quarantined**
BOOLEAN |
| **receive\_item\_id**
INTEGER |
| **receive\_qty**
NUMBER |
| **received\_date**
DATE-TIME |
| **receiver\_id**
INTEGER |
| **secondary\_available\_qty**
NUMBER |
| **secondary\_on\_hand\_qty**
NUMBER |
| **secondary\_on\_hold\_qty**
NUMBER |
| **secondary\_received\_qty**
NUMBER |
| **secondary\_unit\_of\_measure\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand secondary\_unit\_of\_measure\_identifier
id
INTEGER
name
STRING
|
| **serial\_number**
STRING |
| **supplier\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand supplier\_identifier
id
INTEGER
name
STRING
|
| **weight\_imperial**
NUMBER |
| **weight\_imperial\_available**
NUMBER |
| **weight\_imperial\_on\_hand**
NUMBER |
| **weight\_metric**
NUMBER |
| **weight\_metric\_available**
NUMBER |
| **weight\_metric\_on\_hand**
NUMBER |
### locations
This table contains information about inventory facility locations.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Keys ** | location\_id
facility\_id |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[locations schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/locations.json "Opens in new tab: locations schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/inventory/locations "Opens in new tab: 3PL Central API method") |
locations table foreign keys
| Join locations with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#customers) | ``` locations.customer_identifier.id = customers.customer_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand customer\_identifier
external_id
STRING
id
INTEGER
name
STRING
|
| --- |
| **description**
STRING |
| **facility\_id**
INTEGER |
| **item\_traits**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand item\_traits
expiration_date
DATE-TIME
item_identifier
OBJECT
id
INTEGER
sku
STRING
lot_number
STRING
pallet_identifier
OBJECT
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
qualifier
STRING
serial_number
STRING
|
| **location\_id**
INTEGER |
| **location\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand location\_identifier
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
|
| **location\_type\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand location\_type\_identifier
id
INTEGER
name
STRING
|
| **on\_hand**
NUMBER |
### orders
This table contains information about orders.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | order\_id |
| **Replication Key ** | last\_modified\_date |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[orders schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/orders.json "Opens in new tab: orders schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/orders/orders "Opens in new tab: 3PL Central API method") |
orders table foreign keys
| Join orders with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#customers) | ``` orders.customer_identifier.id = customers.customer_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand batch\_identifier
id
INTEGER
name_key
OBJECT
customer_identifier
OBJECT
external_id
STRING
id
INTEGER
name
STRING
name
STRING
|
| **bill\_to**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand bill\_to
address1
STRING
address2
STRING
address_status
STRING
city
STRING
code
STRING
company_name
STRING
contact_id
INTEGER
country
STRING
dept
STRING
email_address
STRING
fax
STRING
is_quick_lookup
BOOLEAN
name
STRING
phone_number
STRING
retailer_id
INTEGER
same_as
INTEGER
state
STRING
title
STRING
zip
STRING
|
| **billing**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand billing
billing_charges
ARRAY
charge_type
INTEGER
details
ARRAY
charge_label
STRING
charge_per_unit
NUMBER
gl_acct_num
STRING
num_units
NUMBER
pt_ar_acct
STRING
pt_item
STRING
pt_item_description
STRING
sku
STRING
system_generated
BOOLEAN
unit_description
STRING
warehouse_transaction_price_calc_id
INTEGER
subtotal
NUMBER
|
| **billing\_code**
STRING |
| **created\_by\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand created\_by\_identifier
id
INTEGER
name
STRING
|
| **creation\_date**
DATE-TIME |
| **customer\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand customer\_identifier
external_id
STRING
id
INTEGER
name
STRING
|
| **defer\_notification**
BOOLEAN |
| **description**
STRING |
| **earliest\_ship\_date**
DATE-TIME |
| **export\_channel\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand export\_channel\_identifier
id
INTEGER
name
STRING
|
| **export\_module\_ids**
STRING |
| **external\_id**
STRING |
| **facility\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand facility\_identifier
id
INTEGER
name
STRING
|
| **fulfill\_inv\_info**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand fulfill\_inv\_info
fulfill_inv_amount
NUMBER
fulfill_inv_discount_code
STRING
fulfill_inv_message
STRING
fulfill_inv_shipping_and_handling
NUMBER
fulfill_inv_tax
NUMBER
|
| **fully\_allocated**
BOOLEAN |
| **import\_channel\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand import\_channel\_identifier
id
INTEGER
name
STRING
|
| **invoice\_delivered\_date**
DATE-TIME |
| **invoice\_exported\_date**
DATE-TIME |
| **invoice\_number**
STRING |
| **is\_closed**
BOOLEAN |
| **labels\_exported**
BOOLEAN |
| **last\_modified\_by\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand last\_modified\_by\_identifier
id
INTEGER
name
STRING
|
| **last\_modified\_date**
DATE-TIME |
| **load\_out\_done\_date**
DATE-TIME |
| **loaded\_state**
INTEGER |
| **master\_billing\_of\_lading\_id**
STRING |
| **notes**
STRING |
| **num\_units**
NUMBER |
| **order\_id**
INTEGER |
| **order\_items**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand order\_items
expiration_date
DATE-TIME
external_id
STRING
fulfill_inv_discount_amt
NUMBER
fulfill_inv_discount_pct
NUMBER
fulfill_inv_note
STRING
fulfill_inv_sale_price
NUMBER
item_identifier
OBJECT
id
INTEGER
sku
STRING
lot_number
STRING
notes
STRING
order_item_packages
ARRAY
package_number
INTEGER
quantity
NUMBER
proposed_allocations
ARRAY
qty
NUMBER
receive_item_id
INTEGER
qty
NUMBER
qualifier
STRING
read_only
OBJECT
allocations
ARRAY
detail
OBJECT
expiration_date
DATE-TIME
item_traits
OBJECT
id
INTEGER
sku
STRING
location_identifier
OBJECT
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
lot_number
STRING
pallet_identifier
OBJECT
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
qualifier
STRING
serial_number
STRING
loaded_out
BOOLEAN
properly_picked_primary
NUMBER
properly_picked_secondary
NUMBER
qty
NUMBER
receive_item_id
INTEGER
estimated_qty
NUMBER
estimated_secondary_qty
NUMBER
full_allocated
BOOLEAN
is_order_qty_secondary
BOOLEAN
order_item_id
INTEGER
pick_exceptions
ARRAY
expiration_date
DATE-TIME
location_id
INTEGER
lot_number
STRING
order_id
INTEGER
order_item_id
INTEGER
order_item_pick_exception_id
INTEGER
picked_primary_qty
NUMBER
picked_secondary_qty
NUMBER
reason
STRING
receive_item_id
INTEGER
serial_number
STRING
secondary_unit_identifier
OBJECT
id
INTEGER
name
STRING
unit_identifier
OBJECT
id
INTEGER
name
STRING
saved_elements
ARRAY
name
STRING
value
STRING
secondary_qty
NUMBER
serial_number
STRING
weight_imperial
NUMBER
weight_metric
NUMBER
|
| **outbound\_serial\_numbers**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand outbound\_serial\_numbers
item_identifier
OBJECT
id
INTEGER
sku
STRING
qualifier
STRING
serial_numbers
ARRAY
|
| **pack\_done\_date**
DATE-TIME |
| **packages**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand routing\_info
account
STRING
bill_of_lading
STRING
capacity_identifier
OBJECT
id
INTEGER
name
STRING
carrier
STRING
door_number
STRING
is_cod
BOOLEAN
is_insurance
BOOLEAN
load_number
STRING
mode
STRING
pickup_date
DATE-TIME
required_delivery_conf
BOOLEAN
required_return_receipt
BOOLEAN
scac_code
STRING
seal_number
STRING
ship_point_zip
STRING
tracking_number
STRING
trailer_number
STRING
|
| **saved\_elements**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand saved\_elements
name
STRING
value
STRING
|
| **ship\_cancel\_date**
DATE-TIME |
| **ship\_to**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand ship\_to
address1
STRING
address2
STRING
address_status
STRING
city
STRING
code
STRING
company_name
STRING
contact_id
INTEGER
country
STRING
dept
STRING
email_address
STRING
fax
STRING
is_quick_lookup
BOOLEAN
name
STRING
phone_number
STRING
retailer_id
INTEGER
retailer_info
OBJECT
id
INTEGER
name_key
OBJECT
customer_identifier
OBJECT
external_id
STRING
id
INTEGER
name
STRING
name
STRING
number
STRING
same_as
INTEGER
state
STRING
title
STRING
zip
STRING
|
| **shipping\_notes**
STRING |
| **sold\_to**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand sold\_to
address1
STRING
address2
STRING
address_status
STRING
city
STRING
code
STRING
company_name
STRING
contact_id
INTEGER
country
STRING
dept
STRING
email_address
STRING
fax
STRING
is_quick_lookup
BOOLEAN
name
STRING
phone_number
STRING
retailer_id
INTEGER
same_as
INTEGER
state
STRING
title
STRING
zip
STRING
|
| **status**
INTEGER |
| **total\_volume**
NUMBER |
| **total\_weight**
NUMBER |
| **transaction\_entry\_type**
INTEGER |
| **unit2\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand unit2\_identifier
id
INTEGER
name
STRING
|
| **up\_service\_option\_charge**
NUMBER |
| **up\_transportation\_charge**
NUMBER |
| **ups\_is\_residential**
NUMBER |
| **warehouse\_transaction\_source\_type**
INTEGER |
### sku\_items
This table contains information about SKU items.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental |
| --- | --- |
| **Primary Key ** | item\_id |
| **Replication Key ** | last\_modified\_date |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[sku_items schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/sku_items.json "Opens in new tab: sku_items schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/customers/items "Opens in new tab: 3PL Central API method") |
sku\_items table foreign keys
| Join sku\_items with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#customers) | ``` sku_items.customer_id = customers.customer_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand classification\_identifier
id
INTEGER
name
STRING
|
| **cost**
NUMBER |
| **country\_of\_manufacture**
STRING |
| **creation\_date**
DATE-TIME |
| **customer\_id**
INTEGER |
| **customer\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand customer\_identifier
external_d
STRING
id
INTEGER
name
STRING
|
| **deactivated**
BOOLEAN |
| **description**
STRING |
| **description2**
STRING |
| **harmonized\_code**
STRING |
| **inventory\_category**
STRING |
| **item**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand item
qualifier
STRING
|
| **item\_id**
INTEGER |
| **kit**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand kit
components
ARRAY
item_identifier
OBJECT
id
INTEGER
sku
STRING
non_sku_material
STRING
qty
NUMBER
qualifier
STRING
material_notes
STRING
|
| **last\_modified\_date**
DATE-TIME |
| **last\_price\_change**
DATE-TIME |
| **nmfc**
STRING |
| **options**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand options
auto_hold_on_receive
INTEGER
days_between_counts
INTEGER
directed_put_away
OBJECT
allow_mixed_item_storage
BOOLEAN
allow_mixed_lot_storage
BOOLEAN
force_into_preferred_location
BOOLEAN
location_zones
STRING
mixed_expiration_days_threshold
BOOLEAN
over_alloc_location_zones
STRING
pallet_location_zones
STRING
preferred_location_identifier
OBJECT
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
haz_mat
OBJECT
flag
STRING
flash_point
STRING
hazard_class
STRING
id
INTEGER
is_haz_mat
BOOLEAN
label_code
STRING
packing_group
STRING
shipping_name
STRING
inventory_unit
OBJECT
inventory_method
INTEGER
maximum_stock
NUMBER
minimum_stock
NUMBER
reorder_quantity
NUMBER
unit_identifier
OBJECT
id
INTEGER
name
STRING
package_unit
OBJECT
imperial
OBJECT
height
NUMBER
length
NUMBER
net_weight
NUMBER
weight
NUMBER
width
NUMBER
metric
OBJECT
height
NUMBER
length
NUMBER
net_weight
NUMBER
weight
NUMBER
width
NUMBER
unit_identifier
OBJECT
id
INTEGER
name
STRING
upc
STRING
pallets
OBJECT
high
NUMBER
imperial
OBJECT
height
NUMBER
length
NUMBER
weight
NUMBER
width
NUMBER
metric
OBJECT
height
NUMBER
length
NUMBER
weight
NUMBER
width
NUMBER
qyt
NUMBER
tie
NUMBER
type_identifier
OBJECT
id
INTEGER
name
STRING
upc
STRING
secondary_unit
OBJECT
inventory_also
BOOLEAN
inventory_units_per_unit
NUMBER
unit_identifier
OBJECT
id
INTEGER
name
STRING
track_by
OBJECT
auto_hold_expiration_days_threshold
INTEGER
outbound_mobile_serialization
INTEGER
track_cost
INTEGER
track_expiration_date
INTEGER
track_lot_number
INTEGER
track_serial_number
INTEGER
|
| **price**
NUMBER |
| **qualifier\_renamers**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand qualifier\_renamers
qualifier
STRING
rename
STRING
|
| **sku**
STRING |
| **temperature**
NUMBER |
| **upc**
STRING |
### stock\_details
This table contains information about stock details.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Key ** | receive\_item\_id |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[stock_details schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/stock_details.json "Opens in new tab: stock_details schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/inventory/stockdetails "Opens in new tab: 3PL Central API method") |
stock\_details table foreign keys
| Join stock\_details with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#customers) | ``` stock_details.customer_id = customers.customer_id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand inventory\_unit\_of\_measure\_identifier
id
INTEGER
sku
STRING
|
| **is\_on\_hold**
BOOLEAN |
| **item\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand item\_identifier
id
INTEGER
sku
STRING
|
| **location\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand location\_identifier
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
|
| **lot\_number**
STRING |
| **on\_hand**
NUMBER |
| **pallet\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand pallet\_identifier
id
INTEGER
name_key
OBJECT
facility_identifier
OBJECT
id
INTEGER
name
STRING
name
STRING
|
| **po\_num**
STRING |
| **qualifier**
STRING |
| **quarantined**
BOOLEAN |
| **receive\_item\_id**
INTEGER |
| **received**
NUMBER |
| **received\_date**
DATE-TIME |
| **receiver\_id**
INTEGER |
| **reference\_num**
STRING |
| **saved\_elements**
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand saved\_elements
name
STRING
value
STRING
|
| **serial\_number**
STRING |
| **supplier\_identifier**
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
Click to expand supplier\_identifier
id
INTEGER
name
STRING
|
| **trailer\_number**
STRING |
### stock\_summaries
This table contains information about stock summaries.
| **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table |
| --- | --- |
| **Primary Keys ** | facility\_id
item\_id |
| **Useful links** | [3PL Central documentation](http://api.3plcentral.com/rels/ "Opens in new tab: 3PL Central documentation")
[stock_summaries schema on GitHub](https://github.com/singer-io/tap-3plcentral/blob/master/tap_3plcentral/schemas/stock_summaries.json "Opens in new tab: stock_summaries schema on GitHub")
[3PL Central API method](http://api.3plcentral.com/rels/inventory/stocksummaries "Opens in new tab: 3PL Central API method") |
stock\_summaries table foreign keys
| Join stock\_summaries with | on |
| --- | --- |
| [customers](https://help.qlik.com/en-US/stitch/integrations/saas/3plcentral#customers) | ``` stock_summaries.facility_id = customers.facilities.id ```
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.