3PL Central

3PL is ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Client Id Client Secret User Name
Replication Type	Full Replication Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	1 hour

Tables/APIs supported

Inventory	Orders

Integrate 3PL Central with Daton

1. Sign in to Daton

2. Select 3PL Central from the list of Integrations

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Post successful authentication, you will be prompted to choose from the list of available tables

5. Then select all required fields for each table

6. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

3PL Central Data

Inventory

Purpose: This API is used to fetch all inventories

Source API Documentation: https://developer.3plcentral.com/#f00b82ce-9c3b-450b-b5f0-3f07eddde822

Replication: Full Replication

Replication Key: NA

Fields

Name	Data Type
receiverId	NUMERIC
receivedDate	DATETIME
receiveItemId	NUMERIC
customerIdentifier	RECORD
facilityIdentifier	RECORD
itemIdentifier	RECORD
itemDescription	STRING
qualifier	STRING
inventoryUnitOfMeasureIdentifier	RECORD
receivedQty	NUMERIC
onHandQty	NUMERIC
availableQty	NUMERIC
onHoldQty	NUMERIC
packagingUnitOfMeasureIdentifier	RECORD
primaryUnitsPerPackagingUnit	NUMERIC
availablePackaging	NUMERIC
onHandPackaging	NUMERIC
inventoryAgeDays	NUMERIC
lotNumber	NUMERIC
serialNumber	STRING
expirationDate	DATETIME
cost	NUMERIC
locationIdentifier	RECORD
palletIdentifier	RECORD
imperial	RECORD
onHold	BOOLEAN
quarantined	BOOLEAN
rowVersion	STRING
stockRowVersion	STRING
referenceNum	STRING
_links	RECORD

Orders

Purpose: This API is used to returns all the orders.

Source API Documentation: https://developer.3plcentral.com/#b630ace1-e5ac-4d87-89fd-7139537d4222

Replication: Incremental

Replication Key: LastModifiedDate

Fields

OrderItems	RECORD
ReferenceNum	STRING
Notes	STRING
NumUnits1	NUMERIC
TotalWeight	NUMERIC
TotalVolume	NUMERIC
BillingCode	STRING
AddFreightToCod	BOOLEAN
UpsIsResidential	BOOLEAN
MasterBillOfLadingId	STRING
InvoiceNumber	STRING
RoutingInfo	RECORD
ShipTo	RECORD
SoldTo	RECORD
BillTo	RECORD
SavedElements	RECORD
ParcelOption	RECORD
FulfillInvInfo	RECORD
OrderId	NUMERIC
Asncandidate	NUMERIC
RouteCandidate	NUMERIC
FullyAllocated	BOOLEAN
DeferNotification	BOOLEAN
IsClosed	BOOLEAN
ProcessDate	DATETIME
PickStarted	BOOLEAN
PackStarted	BOOLEAN
LoadedState	NUMERIC
RouteSent	BOOLEAN
AsnSent	BOOLEAN
ParcelLabelType	NUMERIC
CustomerIdentifier	RECORD
FacilityIdentifier	RECORD
WarehouseTransactionSourceType	STRING
TransactionEntryType	STRING
CreationDate	DATETIME
CreatedByIdentifier	RECORD
LastModifiedDate	DATETIME
LastModifiedByIdentifier	RECORD
Status	NUMERIC