3PL Central

3PL Central is a cloud-based warehouse management system (WMS) solutions built to meet the needs of the 3PL warehousing community.

See the Schema section for a list of objects available for replication.

A high-level look at this connector, including useful links, and supported features.

Feature/Capability	Support details
Supported Qlik Talend Data Integration projects	Replication projects only. Data pipeline projects are not supported.
Target update methods	Replication tasks: Apply changes Store changes Landing data in a data lake tasks: Change data capture (CDC)
Managing metadata	Manual metadata generation is not required.
Schema evolution	Only the Change column data type operation is supported.
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Not supported.
Scheduled CDC	Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling tasks For lake landing tasks, see Scheduling CDC for lake landing tasks
Notifications	Partially supported Setting notifications for changes in operation
Monitoring	CDC-only, as full load is not relevant for this connector. Monitoring an individual data task
Automatic denesting of JSON column payloads	Not supported. JSON column payloads in source datasets are not denested automatically on the target.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Make sure that the account you use has read access to the tables you want to fetch.

To retrieve your API credentials:

Contact api@extensiv.com and request the following access information:
- Base Url
- Client ID
- Client Secret
- Facility ID
- Customer ID
- TPL Key
- User Login
Once you have your access information, set up the integration app in 3PL Central.
For more information, see 3PL Central's documentation.

Creating the connection

For more information, see Connecting to SaaS applications.

Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.

Connection settings
Setting	Description
Data gateway	Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement.
Start Date	Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target.
Base Url	Base URL.
Client ID	Client ID.
Client Secret	Client secret.
Customer ID	Customer ID.
Facility ID	Facility ID.
TPL Key	Warehouse-specific 3PL Central key.
User Login	User login.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

customers

This table contains information about customers.

Replication Method

Full Table

Primary Key

customer_id

Useful links

3PL Central documentation

3PL Central API method

Join customers with	on
sku_items	customers.customer_id = sku_items.customer_id customers.customer_id = sku_items.customer_identifier.id customers.facilities.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id
stock_details	customers.customer_id = stock_details.customer_id customers.facilities.id = stock_details.location_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id customers.facilities.id = stock_details.pallet_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id
inventory	customers.customer_id = inventory.customer_identifier.id customers.facilities.id = inventory.facility_identifier.id customers.primary_facility_identifier.id = inventory.facility_identifier.id customers.facilities.id = inventory.location_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id customers.facilities.id = inventory.pallet_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id
locations	customers.customer_id = locations.customer_identifier.id customers.facilities.id = locations.facility_id customers.primary_facility_identifier.id = locations.facility_id customers.facilities.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id customers.facilities.id = locations.location_identifier.name_key.facility_identifier.id customers.primary_facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id
orders	customers.customer_id = orders.customer_identifier.id customers.customer_id = orders.batch_identifier.name_key.customer_identifier.id customers.customer_id = orders.ship_to.retailer_info.name_key.customer_identifier.id customers.facilities.id = orders.facility_identifier.id customers.primary_facility_identifier.id = orders.facility_identifier.id
stock_summaries	customers.facilities.id = stock_summaries.facility_id customers.primary_facility_identifier.id = stock_summaries.facility_id

company_info

OBJECT

This is a nested data structure:

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:

id: INTEGER
name: STRING

groups

ARRAY

This is a nested data structure.

options

OBJECT

This is a nested data structure:

alerts: OBJECT, which is also a nested data structure.
- expiration_notification_threshold: INTEGER
- from_email_address: STRING
- notify_ship_to: BOOLEAN
edi: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
- flex_fields: BOOLEAN
- require_attached_documents: BOOLEAN
packaging: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
- defs: ARRAY, which is also a nested data structure.
  - name: STRING
  - required: BOOLEAN
- item_defs: ARRAY, which is also a nested data structure.
  - name: STRING
  - required: BOOLEAN
receiving: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
- orders: OBJECT, which is also a nested data structure.
  - defs: ARRAY, which is also a nested data structure.
    - name: STRING
    - required: BOOLEAN
  - item_defs: ARRAY, which is also a nested data structure.
    - name: STRING
    - required: BOOLEAN
shipping: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
- accounting_customer_name: STRING
- autofill_charges_on_confirm: BOOLEAN
- fuel_surcharge: NUMBER
- set_invoice_date_to_xaction_confirm_date: BOOLEAN
user_interface: OBJECT, which is also a nested data structure.
- 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:

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_contact

OBJECT

This is a nested data structure:

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:

id: INTEGER
name: STRING

website

STRING

inventory

This table contains information about inventory resources.

Replication Method

Full Table

Primary Key

receive_item_id

Useful links

3PL Central documentation

3PL Central API method

Join inventory with	on
customers	inventory.customer_identifier.id = customers.customer_id inventory.facility_identifier.id = customers.facilities.id inventory.location_identifier.name_key.facility_identifier.id = customers.facilities.id inventory.pallet_identifier.name_key.facility_identifier.id = customers.facilities.id inventory.facility_identifier.id = customers.primary_facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id
sku_items	inventory.customer_identifier.id = sku_items.customer_id inventory.customer_identifier.id = sku_items.customer_identifier.id inventory.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id inventory.item_identifier.id = sku_items.item_id inventory.item_identifier.id = sku_items.kit.components.item_identifier.id inventory.location_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.id
stock_details	inventory.customer_identifier.id = stock_details.customer_id inventory.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id inventory.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id inventory.item_identifier.id = stock_details.item_identifier.id inventory.location_identifier.id = stock_details.location_identifier.id inventory.pallet_identifier.id = stock_details.pallet_identifier.id inventory.receiver_id = stock_details.receiver_id inventory.receive_item_id = stock_details.receive_item_id inventory.supplier_identifier.id = stock_details.supplier_identifier.id
locations	inventory.customer_identifier.id = locations.customer_identifier.id inventory.facility_identifier.id = locations.facility_id inventory.location_identifier.name_key.facility_identifier.id = locations.facility_id inventory.pallet_identifier.name_key.facility_identifier.id = locations.facility_id inventory.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id inventory.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id inventory.location_identifier.id = locations.location_id inventory.location_identifier.id = locations.location_identifier.id inventory.pallet_identifier.id = locations.item_traits.pallet_identifier.id
orders	inventory.customer_identifier.id = orders.customer_identifier.id inventory.customer_identifier.id = orders.batch_identifier.name_key.customer_identifier.id inventory.customer_identifier.id = orders.ship_to.retailer_info.name_key.customer_identifier.id inventory.facility_identifier.id = orders.facility_identifier.id inventory.location_identifier.name_key.facility_identifier.id = orders.facility_identifier.id inventory.pallet_identifier.name_key.facility_identifier.id = orders.facility_identifier.id
stock_summaries	inventory.facility_identifier.id = stock_summaries.facility_id inventory.location_identifier.name_key.facility_identifier.id = stock_summaries.facility_id inventory.pallet_identifier.name_key.facility_identifier.id = stock_summaries.facility_id

available_qty

NUMBER

cost

NUMBER

customer_identifier

OBJECT

This is a nested data structure:

external_d: STRING
id: INTEGER
name: STRING

expiration_date

DATE-TIME

facility_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name: STRING

inventory_unit_of_measure_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name: STRING

inventory_units_per_secondary_unity

NUMBER

item_description

STRING

item_identifier

OBJECT

This is a nested data structure:

id: INTEGER
sku: STRING

location_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name_key: OBJECT, which is also a nested data structure.
- facility_identifier: OBJECT, which is also a nested data structure.
  - 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:

id: INTEGER
name: STRING

pallet_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name_key: OBJECT, which is also a nested data structure.
- facility_identifier: OBJECT, which is also a nested data structure.
  - 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:

id: INTEGER
name: STRING

serial_number

STRING

supplier_identifier

OBJECT

This is a nested data structure:

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

Full Table

Primary Keys

location_id

facility_id

Useful links

3PL Central documentation

3PL Central API method

Join locations with	on
customers	locations.customer_identifier.id = customers.customer_id locations.facility_id = customers.facilities.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = customers.facilities.id locations.location_identifier.name_key.facility_identifier.id = customers.facilities.id locations.facility_id = customers.primary_facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id
sku_items	locations.customer_identifier.id = sku_items.customer_id locations.customer_identifier.id = sku_items.customer_identifier.id locations.facility_id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id locations.item_traits.item_identifier.id = sku_items.item_id locations.location_id = sku_items.options.directed_put_away.preferred_location_identifier.id locations.location_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.id
stock_details	locations.customer_identifier.id = stock_details.customer_id locations.facility_id = stock_details.location_identifier.name_key.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id locations.facility_id = stock_details.pallet_identifier.name_key.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id locations.location_id = stock_details.location_identifier.id locations.location_identifier.id = stock_details.location_identifier.id locations.item_traits.pallet_identifier.id = stock_details.pallet_identifier.id
inventory	locations.customer_identifier.id = inventory.customer_identifier.id locations.facility_id = inventory.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = inventory.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = inventory.facility_identifier.id locations.facility_id = inventory.location_identifier.name_key.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id locations.facility_id = inventory.pallet_identifier.name_key.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id locations.location_id = inventory.location_identifier.id locations.location_identifier.id = inventory.location_identifier.id locations.item_traits.pallet_identifier.id = inventory.pallet_identifier.id
orders	locations.customer_identifier.id = orders.customer_identifier.id locations.customer_identifier.id = orders.batch_identifier.name_key.customer_identifier.id locations.customer_identifier.id = orders.ship_to.retailer_info.name_key.customer_identifier.id locations.facility_id = orders.facility_identifier.id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = orders.facility_identifier.id locations.location_identifier.name_key.facility_identifier.id = orders.facility_identifier.id
stock_summaries	locations.facility_id = stock_summaries.facility_id locations.item_traits.pallet_identifier.name_key.facility_identifier.id = stock_summaries.facility_id locations.location_identifier.name_key.facility_identifier.id = stock_summaries.facility_id locations.item_traits.item_identifier.id = stock_summaries.item_id

customer_identifier

OBJECT

This is a nested data structure:

external_id: STRING
id: INTEGER
name: STRING

description

STRING

facility_id

INTEGER

item_traits

OBJECT

This is a nested data structure:

expiration_date: DATE-TIME
item_identifier: OBJECT, which is also a nested data structure.
- id: INTEGER
- sku: STRING
lot_number: STRING
pallet_identifier: OBJECT, which is also a nested data structure.
- id: INTEGER
- name_key: OBJECT, which is also a nested data structure.
  - facility_identifier: OBJECT, which is also a nested data structure.
    - id: INTEGER
    - name: STRING
  - name: STRING
qualifier: STRING
serial_number: STRING

location_id

INTEGER

location_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name_key: OBJECT, which is also a nested data structure.
- facility_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
- name: STRING

location_type_identifier

OBJECT

id: INTEGER
name: STRING

on_hand

NUMBER

orders

This table contains information about orders.

Replication Method	CDC
Primary Key	order_id
Replication Key	last_modified_date
Useful links	3PL Central documentation 3PL Central API method

Join orders with	on
customers	orders.customer_identifier.id = customers.customer_id orders.batch_identifier.name_key.customer_identifier.id = customers.customer_id orders.ship_to.retailer_info.name_key.customer_identifier.id = customers.customer_id orders.facility_identifier.id = customers.facilities.id orders.facility_identifier.id = customers.primary_facility_identifier.id
sku_items	orders.customer_identifier.id = sku_items.customer_id orders.batch_identifier.name_key.customer_identifier.id = sku_items.customer_id orders.ship_to.retailer_info.name_key.customer_identifier.id = sku_items.customer_id orders.customer_identifier.id = sku_items.customer_identifier.id orders.batch_identifier.name_key.customer_identifier.id = sku_items.customer_identifier.id orders.ship_to.retailer_info.name_key.customer_identifier.id = sku_items.customer_identifier.id orders.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id
stock_details	orders.customer_identifier.id = stock_details.customer_id orders.batch_identifier.name_key.customer_identifier.id = stock_details.customer_id orders.ship_to.retailer_info.name_key.customer_identifier.id = stock_details.customer_id orders.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id orders.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id
inventory	orders.customer_identifier.id = inventory.customer_identifier.id orders.batch_identifier.name_key.customer_identifier.id = inventory.customer_identifier.id orders.ship_to.retailer_info.name_key.customer_identifier.id = inventory.customer_identifier.id orders.facility_identifier.id = inventory.facility_identifier.id orders.facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id orders.facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id
locations	orders.customer_identifier.id = locations.customer_identifier.id orders.batch_identifier.name_key.customer_identifier.id = locations.customer_identifier.id orders.ship_to.retailer_info.name_key.customer_identifier.id = locations.customer_identifier.id orders.facility_identifier.id = locations.facility_id orders.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id orders.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id
stock_summaries	orders.facility_identifier.id = stock_summaries.facility_id

add_freight_to_cod

BOOLEAN

asn_candidate

INTEGER

asn_number

STRING

asn_sent

BOOLEAN

asn_sent_date

DATE-TIME

batch_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name_key: OBJECT, which is also a nested data structure.
- facility_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
- name: STRING

bill_to

OBJECT

This is a nested data structure:

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

billing

OBJECT

This is a nested data structure:

billing_charges: ARRAY, which is also a nested data structure.
- charge_type: INTEGER
- details: ARRAY, which is also a nested data structure.
  - 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:

id: INTEGER
name: STRING

creation_date

DATE-TIME

customer_identifier

OBJECT

This is a nested data structure:

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:

id: INTEGER
name: STRING

export_module_ids

STRING

external_id

STRING

facility_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name: STRING

fulfill_inv_info

OBJECT

This is a nested data structure:

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:

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:

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:

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, which is also a nested data structure.
- id: INTEGER
- sku: STRING
lot_number: STRING
notes: STRING
order_item_packages: ARRAY, which is also a nested data structure.
- package_number: INTEGER
- quantity: NUMBER
proposed_allocations: ARRAY, which is also a nested data structure.
- qty: NUMBER
- receive_item_id: INTEGER
qty: NUMBER
qualifier: STRING
read_only: OBJECT, which is also a nested data structure.
- allocations: ARRAY, which is also a nested data structure.
  - detail: OBJECT, which is also a nested data structure.
    - expiration_date: DATE-TIME
    - item_traits: OBJECT, which is also a nested data structure.
      - id: INTEGER
      - sku: STRING
    - location_identifier: OBJECT, which is also a nested data structure.
      - id: INTEGER
      - name_key: OBJECT, which is also a nested data structure.
        facility_identifier: OBJECT, which is also a nested data structure.
        id: INTEGER
        name: STRING
        name: STRING
    - lot_number: STRING
    - pallet_identifier: OBJECT, which is also a nested data structure.
      - id: INTEGER
      - name_key: OBJECT, which is also a nested data structure.
        facility_identifier: OBJECT, which is also a nested data structure.
        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, which is also a nested data structure.
  - 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, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
- unit_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
saved_elements: ARRAY, which is also a nested data structure.
- 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:

item_identifier: OBJECT, which is also a nested data structure.
- id: INTEGER
- sku: STRING
qualifier: STRING
serial_numbers: ARRAY, which is also a nested data structure.

pack_done_date

DATE-TIME

packages

ARRAY

This is a nested data structure:

cod: BOOLEAN
cod_amount: NUMBER
create_date: DATE-TIME
description: STRING
height: NUMBER
insured_amount: NUMBER
label: STRING
length: NUMBER
oversize: BOOLEAN
package_contents: ARRAY, which is also a nested data structure.
- create_date: DATE-TIME
- expiration_date: DATE-TIME
- lot_number: STRING
- order_item_id: INTEGER
- order_item_pick_exception_id: INTEGER
- package_content_id: INTEGER
- package_id: INTEGER
- qty: NUMBER
- receive_item_id: INTEGER
- serial_number: STRING
- serial_numbers: ARRAY, which is also a nested data structure.
package_id: INTEGER
package_type_id: INTEGER
tracking_number: STRING
ucc128: INTEGER
weight: NUMBER
width: NUMBER

parcel_label_type

INTEGER

pick_done_date

DATE-TIME

pick_ticket_print_date

DATE-TIME

pkgs_exported

BOOLEAN

po_num

STRING

process_date

DATE-TIME

reallocated_after_pick_ticket_date

DATE-TIME

reference_num

STRING

route_candidate

INTEGER

route_pickup_date

DATE-TIME

route_sent

BOOLEAN

routing_info

OBJECT

This is a nested data structure:

account: STRING
bill_of_lading: STRING
capacity_identifier: OBJECT, which is also a nested data structure.
- 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:

name: STRING
value: STRING

ship_cancel_date

DATE-TIME

ship_to

OBJECT

This is a nested data structure:

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, which is also a nested data structure.
- id: INTEGER
- name_key: OBJECT, which is also a nested data structure.
  - customer_identifier: OBJECT, which is also a nested data structure.
    - 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:

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:

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	CDC
Primary Key	item_id
Replication Key	last_modified_date
Useful links	3PL Central documentation 3PL Central API method

Join sku_items with	on
customers	sku_items.customer_id = customers.customer_id sku_items.customer_identifier.id = customers.customer_id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = customers.facilities.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id
stock_details	sku_items.customer_id = stock_details.customer_id sku_items.customer_identifier.id = stock_details.customer_id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = stock_details.location_identifier.name_key.facility_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = stock_details.pallet_identifier.name_key.facility_identifier.id sku_items.item_id = stock_details.item_identifier.id sku_items.kit.components.item_identifier.id = stock_details.item_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.id = stock_details.location_identifier.id
inventory	sku_items.customer_id = inventory.customer_identifier.id sku_items.customer_identifier.id = inventory.customer_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = inventory.facility_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id sku_items.item_id = inventory.item_identifier.id sku_items.kit.components.item_identifier.id = inventory.item_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.id = inventory.location_identifier.id
locations	sku_items.customer_id = locations.customer_identifier.id sku_items.customer_identifier.id = locations.customer_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = locations.facility_id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id sku_items.item_id = locations.item_traits.item_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.id = locations.location_id sku_items.options.directed_put_away.preferred_location_identifier.id = locations.location_identifier.id
orders	sku_items.customer_id = orders.customer_identifier.id sku_items.customer_identifier.id = orders.customer_identifier.id sku_items.customer_id = orders.batch_identifier.name_key.customer_identifier.id sku_items.customer_identifier.id = orders.batch_identifier.name_key.customer_identifier.id sku_items.customer_id = orders.ship_to.retailer_info.name_key.customer_identifier.id sku_items.customer_identifier.id = orders.ship_to.retailer_info.name_key.customer_identifier.id sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = orders.facility_identifier.id
stock_summaries	sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id = stock_summaries.facility_id sku_items.item_id = stock_summaries.item_id

account_ref

STRING

classification_identifier

OBJECT

This is a nested data structure:

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:

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:

qualifier: STRING

item_id

INTEGER

kit

OBJECT

This is a nested data structure:

components: ARRAY, which is also a nested data structure.
- item_identifier: OBJECT, which is also a nested data structure.
  - 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:

auto_hold_on_receive: INTEGER
days_between_counts: INTEGER
directed_put_away: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
  - id: INTEGER
  - name_key: OBJECT, which is also a nested data structure.
    - facility_identifier: OBJECT, which is also a nested data structure.
      - id: INTEGER
      - name: STRING
    - name: STRING
haz_mat: OBJECT, which is also a nested data structure.
- 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, which is also a nested data structure.
- inventory_method: INTEGER
- maximum_stock: NUMBER
- minimum_stock: NUMBER
- reorder_quantity: NUMBER
- unit_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
package_unit: OBJECT, which is also a nested data structure.
- imperial: OBJECT, which is also a nested data structure.
  - height: NUMBER
  - length: NUMBER
  - net_weight: NUMBER
  - weight: NUMBER
  - width: NUMBER
- metric: OBJECT, which is also a nested data structure.
  - height: NUMBER
  - length: NUMBER
  - net_weight: NUMBER
  - weight: NUMBER
  - width: NUMBER
- unit_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
- upc: STRING
pallets: OBJECT, which is also a nested data structure.
- high: NUMBER
- imperial: OBJECT, which is also a nested data structure.
  - height: NUMBER
  - length: NUMBER
  - weight: NUMBER
  - width: NUMBER
- metric: OBJECT, which is also a nested data structure.
  - height: NUMBER
  - length: NUMBER
  - weight: NUMBER
  - width: NUMBER
- qyt: NUMBER
- tie: NUMBER
- type_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
- upc: STRING
secondary_unit: OBJECT, which is also a nested data structure.
- inventory_also: BOOLEAN
- inventory_units_per_unit: NUMBER
- unit_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
track_by: OBJECT, which is also a nested data structure.
- 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:

qualifier: STRING
rename: STRING

sku

STRING

temperature

NUMBER

upc

STRING

stock_details

This table contains information about stock details.

Replication Method

Full Table

Primary Key

receive_item_id

Useful links

3PL Central documentation

3PL Central API method

Join stock_details with	on
customers	stock_details.customer_id = customers.customer_id stock_details.location_identifier.name_key.facility_identifier.id = customers.facilities.id stock_details.pallet_identifier.name_key.facility_identifier.id = customers.facilities.id stock_details.location_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = customers.primary_facility_identifier.id
sku_items	stock_details.customer_id = sku_items.customer_id stock_details.customer_id = sku_items.customer_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id stock_details.item_identifier.id = sku_items.item_id stock_details.item_identifier.id = sku_items.kit.components.item_identifier.id stock_details.location_identifier.id = sku_items.options.directed_put_away.preferred_location_identifier.id
inventory	stock_details.customer_id = inventory.customer_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = inventory.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = inventory.facility_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = inventory.location_identifier.name_key.facility_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = inventory.pallet_identifier.name_key.facility_identifier.id stock_details.item_identifier.id = inventory.item_identifier.id stock_details.location_identifier.id = inventory.location_identifier.id stock_details.pallet_identifier.id = inventory.pallet_identifier.id stock_details.receiver_id = inventory.receiver_id stock_details.receive_item_id = inventory.receive_item_id stock_details.supplier_identifier.id = inventory.supplier_identifier.id
locations	stock_details.customer_id = locations.customer_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = locations.facility_id stock_details.pallet_identifier.name_key.facility_identifier.id = locations.facility_id stock_details.location_identifier.name_key.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = locations.location_identifier.name_key.facility_identifier.id stock_details.location_identifier.id = locations.location_id stock_details.location_identifier.id = locations.location_identifier.id stock_details.pallet_identifier.id = locations.item_traits.pallet_identifier.id
orders	stock_details.customer_id = orders.customer_identifier.id stock_details.customer_id = orders.batch_identifier.name_key.customer_identifier.id stock_details.customer_id = orders.ship_to.retailer_info.name_key.customer_identifier.id stock_details.location_identifier.name_key.facility_identifier.id = orders.facility_identifier.id stock_details.pallet_identifier.name_key.facility_identifier.id = orders.facility_identifier.id
stock_summaries	stock_details.location_identifier.name_key.facility_identifier.id = stock_summaries.facility_id stock_details.pallet_identifier.name_key.facility_identifier.id = stock_summaries.facility_id

available

NUMBER

cost

NUMBER

customer_id

INTEGER

description

STRING

expiration_date

DATE-TIME

inventory_unit_of_measure_identifier

OBJECT

This is a nested data structure:

id: INTEGER
sku: STRING

is_on_hold

BOOLEAN

item_identifier

OBJECT

This is a nested data structure:

id: INTEGER
sku: STRING

location_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name_key: OBJECT, which is also a nested data structure.
- facility_identifier: OBJECT, which is also a nested data structure.
  - id: INTEGER
  - name: STRING
- name: STRING

lot_number

STRING

on_hand

NUMBER

pallet_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name_key: OBJECT, which is also a nested data structure.
- facility_identifier: OBJECT, which is also a nested data structure.
  - 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:

name: STRING
value: STRING

serial_number

STRING

supplier_identifier

OBJECT

This is a nested data structure:

id: INTEGER
name: STRING

trailer_number

STRING

stock_summaries

This table contains information about stock summaries.

Replication Method

Full Table

Primary Keys

facility_id

item_id

Useful links

3PL Central documentation

3PL Central API method

Join stock_summaries with	on
customers	stock_summaries.facility_id = customers.facilities.id stock_summaries.facility_id = customers.primary_facility_identifier.id
inventory	stock_summaries.facility_id = inventory.facility_identifier.id stock_summaries.facility_id = inventory.location_identifier.name_key.facility_identifier.id stock_summaries.facility_id = inventory.pallet_identifier.name_key.facility_identifier.id
locations	stock_summaries.facility_id = locations.facility_id stock_summaries.facility_id = locations.item_traits.pallet_identifier.name_key.facility_identifier.id stock_summaries.facility_id = locations.location_identifier.name_key.facility_identifier.id stock_summaries.item_id = locations.item_traits.item_identifier.id
orders	stock_summaries.facility_id = orders.facility_identifier.id
sku_items	stock_summaries.facility_id = sku_items.options.directed_put_away.preferred_location_identifier.name_key.facility_identifier.id stock_summaries.item_id = sku_items.item_id
stock_details	stock_summaries.facility_id = stock_details.location_identifier.name_key.facility_identifier.id stock_summaries.facility_id = stock_details.pallet_identifier.name_key.facility_identifier.id

allocated

NUMBER

available

NUMBER

facility_id

INTEGER

item_id

INTEGER

item_identifier

OBJECT

This is a nested data structure:

id: INTEGER
sku: STRING

on_hand

NUMBER

on_hold

NUMBER

qualifier

STRING

total_received

NUMBER

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here