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.

進一步查看此連接器，包括實用的連結和支援的功能。

功能	支援詳細資訊
支援的 Qlik Talend Data Integration 專案	僅複寫專案。不支援資料管道專案。
目標更新方法	複寫任務：套用變更儲存變更在資料湖中登陸資料任務：變更資料擷取 (CDC)
管理中繼資料	不需要手動產生中繼資料。
結構描述演進	僅支援變更欄資料類型操作。
LOB 欄 (NCLOB、CLOB 和 BLOB) 複寫	不支援。
已排程 CDC	必填。此為目標與來源的變更保持同步的方式。對於複寫任務，請參閱排程任務對於湖登陸任務，請參閱排程湖登陸任務的 CDC
通知	部分支援設定變更進行時的通知
監控	僅限 CDC，因為此連接器與完整載入無關。監控個別資料任務
自動解除 JSON 欄裝載的巢狀結構	不支援。來源資料集中的 JSON 欄裝載不會在目標上自動解除巢狀結構。

Preparing for authentication

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

確認您使用的帳戶可讀取您要擷取的表格。

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

如需詳細資訊，請參閱連線到 SaaS 應用程式。

填寫所需的連線屬性。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。
按一下建立。

Connection settings
Setting	Description
Data gateway	如您的使用情況有需要，選取資料移動閘道。資訊備註此欄位無法用於 Qlik Talend Cloud 啟動器訂閱，因為不支援資料移動閘道。若您有另一個訂閱層級且不想使用資料移動閘道，選取無。如需關於資料移動閘道福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。
Start Date	以 `MM/DD/YYYY` 格式輸入資料必須從來源複寫到目標的日期。
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

此頁面是否對您有幫助？

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們！

在此留下意見回饋