Data integration
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 |
| External Document No. | PONumber |
| Bill to Code | SoldtoNumber |
| Bill to Name | SoldtoName |
| Sales Order Location Code | WarehouseId |
| TLx Payment Terms | PaymentTerms |
| Ship-to | ShipViaCode |
| Shipment Date | OrderShipDate |
| Due Date | OrderDueDate |
| Requested 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 |
|---|---|
| Sell-to Code | Consignee.ConsigneeNo |
| Sell-to Name | Consignee.Name |
| Sell-to Address | Consignee.Street1 |
| Sell-to City | Consignee.City |
| Sell-to State | Consignee.State |
| Sell-to Post Code | Consignee.Zip |
| Country/Region Code | CountryCode |
| Sell-to Contact Name | Consignee.ContactName |
| Phone No. | PhoneNumber |
| Bill to Code | BillTo.BillToNo |
| Bill to Name | BillTo.Name |
| Bill to Address 1 | BillTo.Street1 |
| Bill to City | BillTo.City |
| Bill to State | BillTo.State |
| Bill to Post Code | BillTo.Zip |
| Country/Region Code | CountryCode |
| Bill to Contact | BillTo.Contact |
| Phone No. | 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 |
| UoM | Items[0].HandlingUnit |
| Length from UoM | Items[0].Length |
| Width from UoM | Items[0].Width |
| Height from UoM | Items[0].Height |
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 |
| 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 |
| 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 |