Comment on page
3PL Central
3PL is ETL connector for data replication
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 |
Inventory | Orders |
- 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
- 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
Purpose: This API is used to fetch all inventories
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 |
Purpose: This API is used to returns all the orders.
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 |
Last modified 5mo ago