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 项目	仅 Replication 项目。不支持数据管道项目。
目标更新方法	复制任务：应用更改存储更改在数据湖任务中登陆数据：更改数据捕获 (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 Starter 订阅，因为它不支持数据移动网关。如果您有另一个订阅层并且不想使用数据移动网关，请选择无。有关数据移动网关的优势和需要它的用例的信息，请参阅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

本页面有帮助吗？

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们！

在此处留下您的反馈