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

이 페이지가 도움이 되었습니까?

이 페이지 또는 해당 콘텐츠에서 오타, 누락된 단계 또는 기술적 오류와 같은 문제를 발견하면 알려 주십시오!

여기에 피드백을 남겨주십시오.