Data integration
Aptean Total Logistix
•
Article
•
7/22/2026
•
To view the data transfer during the release of the sales orders
The table below shows how data from fields in Business Central maps to variables in TOTALogistix for sales orders.
| In Business Central | In TOTALogistix |
|---|---|
| Sales Order No. | OrderNumber |
| (Hardcoded: Outbound) | DirectionType |
| External Document No. | PONumber |
| Bill-to Customer No. | SoldtoNumber |
| Bill to Name | SoldtoName |
| Sales Order Location Code | WarehouseId |
| TLx Payment Terms | PaymentTerms |
| Shipping Agent Code | ShipViaCode |
| Shipment Date | OrderShipDate |
| Due Date | OrderDueDate |
| Promised Delivery Date | OrderDeliveryDate |
The table below shows how data from fields in Business Central maps to variables in TOTALogistix for customer information associated with the sales order.
| In Business Central | In TOTALogistix |
|---|---|
| Ship-to Name | Consignee.Name |
| Ship-to Address | Consignee.Street1 |
| Ship-to Address 2 | Consignee.Street2 |
| Ship-to City | Consignee.City |
| Ship-to County | Consignee.State |
| Ship-to Post Code | Consignee.Zip |
| Ship-to Country/Region Code | Consignee.CountryCode |
| Ship-to Contact Name (if blank, Sell-to Contact) | Consignee.ContactName |
| Sell-to Phone No. (only when Ship-to Contact is blank; empty otherwise) | Consignee.PhoneNumber |
| Bill to Name | BillTo.Name |
| Bill to Address 1 | BillTo.Street1 |
| Bill-to Address 2 | BillTo.Street2 |
| Bill to City | BillTo.City |
| Bill to County | BillTo.State |
| Bill to Post Code | BillTo.Zip |
| Bill to Country/Region Code | BillTo.CountryCode |
| Bill to Contact No. | BillTo.ContactName |
| Contact Phone No. | BillTo.PhoneNumber |
| Shipping Services | AdditionalServices[0] |
| Shipping Services | AdditionalServices[1] |
| Shipping Services | AdditionalServices[0] |
| Item no | Items[0].ItemNumber |
| Description | Items[0].Description |
| Quantity | Items[0].Quantity |
| Quantity | Items[0].QuantityOrdered |
| Quantity Shipped | Items[0].QuantityShipped |
| Gross Weight | Items[0].Weight |
| Weight | Items[0].WeightUnitOfMeasure |
| Length | Items[0].DimensionUnitOfMeasure |
| Sales Line Location Code (fallback: Sales Header Location Code) | Items[0].ItemWarehouseCode |
| UoM | Items[0].HandlingUnit |
| Length from UoM | Items[0].Length |
| Width from UoM | Items[0].Width |
| Height from UoM | Items[0].Height |
| Reservation Entry Lot No. | Items[0].Tracking[0].LotNumber |
| Reservation Entry Serial No. | Items[0].Tracking[0].SerialNumber |
| Reservation Entry Expiration Date | Items[0].Tracking[0].ExpirationDate |
| Reservation Entry Quantity | Items[0].Tracking[0].Quantity |
To view the data transfer during the release of the purchase orders
The table below shows how data from fields in Business Central maps to variables in TOTALogistix for purchase orders.
| In Business Central | In TOTALogistix |
|---|---|
| Purchase Order No | PONumber |
| (Hardcoded: Inbound) | DirectionType |
| Purchase Header Document Date | OrderDate |
| Purchase Header Buy-from Vendor No. | VendorCode |
| Purchase Header Buy-from Vendor Name | VendorName |
| Purchase Header Buy-from Vendor Name | Shipper.Name |
| Purchase Header Buy-from Address | Shipper.Street1 |
| Purchase Header Buy-from Address 2 | Shipper.Street2 |
| Purchase Header Buy-from City | Shipper.City |
| Purchase Header Buy-from County | Shipper.State |
| Buy-from Country/Region Code → ISO Code | Shipper.CountryCode |
| Purchase Header Buy-from Post Code | Shipper.Zip |
| Purchase Header Buy-from Contact | Shipper.ContactName |
| Vendor Phone No. | Shipper.PhoneNumber |
| TLx Payment Type | PaymentTerms |
| Location Code | Consignee.WarehouseId |
| Location Description | Consignee.Name |
| Location Street 1 | Consignee.Street1 |
| Location Street 2 | Consignee.Street2 |
| Location City | Consignee.City |
| Location City County | Consignee.State |
| Location Zip | Consignee.Zip |
| Location Contact Name | Consignee.ContactName |
| Location Contact Phone | Consignee.ContactPhone |
| Requested Receipt Date - Lead Time Calculation | ShipDate |
| Requested Receipt Date | DeliveryDate |
| Item Code | Items[0].ItemNumber |
| Item Description | Items[0].Description |
| Item Quantity | Items[0].Quantity |
| Item Weight | Items[0].Weight |
| Unit of Measure (per line) | Items[0].HandlingUnit |
| Item Length | Items[0].Length |
| Item Width | Items[0].Width |
| Item Height | Items[0].Height |
| Weight UoM - TLx Setup | Items[0].WeightUnitOfMeasure |
| Dimension UoM - TLx Setup | Items[0].DimensionUnitOfMeasure |
| Purchase Line Location Code (fallback: Purchase Header Location Code) | Items[0].ItemWarehouseCode |
| Reservation Entry Lot No. | Items[0].Tracking[0].LotNumber |
| Reservation Entry Serial No. | Items[0].Tracking[0].SerialNumber |
| Reservation Entry Expiration Date | Items[0].Tracking[0].ExpirationDate |
| Reservation Entry Quantity | Items[0].Tracking[0].Quantity |
To view the data transfer during the release of the transfer orders
The table below shows how data from fields in Business Central maps to variables in TOTALogistix for transfer orders.
| In Business Central | In TOTALogistix |
|---|---|
| Transfer Header No. | OrderNumber |
| (Hardcoded: Transfer) | DirectionType |
| External Document No. | PONumber |
| Transfer-from Code | WarehouseId |
| TLx Payment Type | PaymentTerms |
| Shipping Agent Code | ShipViaCode |
| Shipment Date | OrderShipDate |
| Receipt Date | OrderDueDate |
| Receipt Date | OrderDeliveryDate |
| Transfer-from Code | Shipper.WarehouseId |
| Transfer-from Name | Shipper.Name |
| Transfer-from Address | Shipper.Street1 |
| Transfer-from Address 2 | Shipper.Street2 |
| Transfer-from City | Shipper.City |
| Transfer-from County | Shipper.State |
| Trsf.-from Country/Region Code | Shipper.CountryCode |
| Transfer-from Post Code | Shipper.Zip |
| Transfer-from Contact | Shipper.ContactName |
| Transfer-from Location Name | Shipper.LocationName |
| Transfer-to Code | Consignee.WarehouseId |
| Transfer-to Name | Consignee.Name |
| Transfer-to Address | Consignee.Street1 |
| Transfer-to Address 2 | Consignee.Street2 |
| Transfer-to City | Consignee.City |
| Transfer-to County | Consignee.State |
| Trsf.-to Country/Region Code | Consignee.CountryCode |
| Transfer-to Post Code | Consignee.Zip |
| Transfer-to Contact | Consignee.ContactName |
| Transfer-to Location Name | Consignee.LocationName |
| Transfer Line Item No. | Items[0].ItemNumber |
| Transfer Line Description | Items[0].Description |
| Transfer Line Quantity | Items[0].Quantity |
| Transfer Line Quantity | Items[0].QuantityOrdered |
| Transfer Line Quantity Shipped | Items[0].QuantityShipped |
| Item Gross Weight × Transfer Line Quantity | Items[0].Weight |
| TLx Unit of Measure - Item card | Items[0].HandlingUnit |
| Weight UoM - TLx Setup | Items[0].WeightUnitOfMeasure |
| Length UoM - TLx Setup | Items[0].DimensionUnitOfMeasure |
| Item Unit of Measure Length | Items[0].Length |
| Item Unit of Measure Width | Items[0].Width |
| Item Unit of Measure Height | Items[0].Height |
| Reservation Entry Lot No. | Items[0].Tracking[0].LotNumber |
| Reservation Entry Serial No. | Items[0].Tracking[0].SerialNumber |
| Reservation Entry Expiration Date | Items[0].Tracking[0].ExpirationDate |
| Reservation Entry Quantity | Items[0].Tracking[0].Quantity |