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.

Immagine di alto livello di questo connettore, inclusi collegamenti utili e funzionalità supportate.

Funzionalità/Capacità	Dettagli del supporto
Progetti Qlik Talend Data Integration supportati	Solo i progetti di replica. I progetti delle pipeline di dati non sono supportati.
Metodi di aggiornamento della destinazione	Attività di replica: Applica modifiche Archivia modifiche Trasferimento dei dati nelle attività di un data lake: Change Data Capture (CDC)
Gestione dei metadati	La generazione manuale dei metadati non è richiesta.
Evoluzione dello schema	È supportata solo l'operazione Cambia tipo di dati colonne.
Replica delle colonne LOB (NCLOB, CLOB e BLOB)	Operazione non supportata.
CDC pianificato	Operazione richiesta. In questo modo la destinazione viene aggiornata con le modifiche apportate alla sorgente. Per le attività di replica, vedere Attività di pianificazione Per le attività di trasferimento su data lake, vedere Pianificazione delle attività CDC per i processi di trasferimento su data lake
Notifiche	Operazione parzialmente supportata Impostare notifiche quando vengono apportate modifiche al funzionamento
Monitoraggio	Solo attività CDC, in quanto il caricamento completo non è rilevante per questo connettore. Monitoraggio di un'attività dati individuale
Annullamento automatico della nidificazione dei payload nelle colonne JSON	Operazione non supportata. La nidificazione per i payload della colonna JSON nei set di dati di origine non viene annullata automaticamente nella destinazione.

Preparing for authentication

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

Assicurarsi che l'account utilizzata disponga di accesso di lettura per le tabelle che si desidera recuperare.

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

Per ulteriori informazioni, vedere Connessione alle applicazioni SaaS.

Inserire le proprietà di connessione richieste.
Fornire un nome per la connessione in Nome connessione.
Selezionare Apri metadati di connessione per definire i metadati della connessione al momento della creazione.
Fare clic su Crea.

Connection settings
Setting	Description
Data gateway	Selezionare un Gateway Data Movement se richiesto dal proprio caso di utilizzo. Nota informatica Questo campo non è disponibile con la sottoscrizione a Avvio Qlik Talend Cloud, poiché non supporta il Gateway Data Movement. Se si dispone di un altro livello di sottoscrizione e non si desidera utilizzare il Gateway Data Movement, selezionare Nessuno. Per informazioni sui vantaggi del Gateway Data Movement e quando è richiesto, vedere Qlik Data Gateway - Movimento dati.
Start Date	Inserire la data, nel formato `MM/DD/YYYY`, a partire dalla quale i dati devono essere replicati dalla sorgente alla destinazione.
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

Hai trovato utile questa pagina?

Se riscontri problemi con questa pagina o con il suo contenuto – un errore di battitura, un passaggio mancante o un errore tecnico – ti pregiamo di farcelo sapere!

Lascia qui il tuo feedback