Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.nekt.com/llms.txt

Use this file to discover all available pages before exploring further.

PCS Software is a transportation management system (TMS) designed for trucking companies, brokers, and logistics providers. It offers tools for load management, dispatching, billing, and fleet operations.

​
Configuring PCS Software as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the PCS Software option from the list of connectors. Click Next and you’ll be prompted to add your access.

​
1. Add account access

You’ll need the following credentials from your PCS Software account:
  • Customer ID: Your PCS Software client ID, used for API authentication. Contact your PCS Software account representative to obtain this value.
  • Username: A valid TMS username that will be recorded as the user performing the API operations.
  • Start Date: (Optional) The earliest date from which records will be synced. If not set, all available records are fetched.
Once you’re done, click Next.

​
2. Select streams

Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. Select the streams and click Next.

​
3. Configure data streams

Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table, and the type of sync.
  • Layer: choose between the existing layers on your catalog.
  • Folder: a folder can be created inside the selected layer to group all tables being created from this new data source.
  • Table name: a default name is suggested, but feel free to customize it.
  • Sync Type: Full Table is recommended for all streams. Every extraction fetches the current state of the data.
Once you are done configuring, click Next.

​
4. Configure data source

Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. Once you are ready, click Next to finalize the setup.

​
5. Check your new source

You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.
For you to be able to see it on your Catalog, you need at least one successful source run.

​
Streams and Fields

Below you’ll find all available data streams from PCS Software and their corresponding fields:
Load records from the PCS Software TMS, including TruckLoad, LTL, and Intermodal load types with stops and rating information.Core Fields:
  • LoadId - Unique identifier for the load
  • Status - Load status (active, arrived, assigned, booked, brokered, cancelled, dispatched, dropped, enroute, moving, pending, possible, ready)
  • LoadClass - Load classification (TL, LTL, Intermodal)
  • LoadType - Load type description
  • BillToId - Bill-to customer ID
  • BillToName - Bill-to customer name
  • LoadReference - Load reference number
  • BillingType - Billing type (P = Prepaid, C = Collect, B = Both)
  • MilesBilled - Billed miles
  • TotalWeight - Total load weight
  • Pallets - Number of pallets
  • Notes - Load notes
  • Reference1 - Additional reference number
Intermodal-Specific Fields:
  • Boundary - Boundary type (I = Inbound, O = Outbound, C = Crosstown)
  • BookingNumber - Booking number
  • Container - Container number
  • Chassis - Chassis number
Office:
  • Office.Code - Office code
Rating:
  • Rating.LineHaulRate - Line haul rate details (RateType, Rate, MatrixId, Source)
  • Rating.AccessorialRates - Array of accessorial rate charges
  • Rating.CommodityRating - Commodity rating details
Stops (array):
  • Stops[].Id - Stop ID
  • Stops[].Order - Stop order
  • Stops[].Type - Stop type (Shipper or Consignee)
  • Stops[].Zone - Zone
  • Stops[].AvailableFrom / Stops[].AvailableTo - Availability window
  • Stops[].Miles - Miles to stop
  • Stops[].ReferenceNumber - Reference number
  • Stops[].Contact - Contact name
  • Stops[].CompanyName - Company name
  • Stops[].Phone - Phone number
  • Stops[].Address - Address (CountrySubDivisionCode, City, Line1, PostalCode)
Company dispatch records from the PCS Software Dispatch API, containing driver assignments, vehicle details, pickup/delivery information, and pay data.Identifiers:
  • id - Unique dispatch record ID
  • loadId - Associated load ID
  • tripId - Associated trip ID
  • mainDispatchId - Main dispatch ID
  • batchId - Batch ID
Status & Dates:
  • status - Dispatch status
  • dispatchDate / dispatchTime - Dispatch date and time
  • dispatchCode - Dispatch code
  • inputDate / inputTime - Input date and time
  • inputUser - User who entered the record
Driver Information:
  • driverId / driverName - Primary driver
  • coDriverId / coDriverName - Co-driver
  • driverPay / coDriverPay - Driver pay amounts
Vehicle Details:
  • truckId / truckNumber - Truck information
  • trailerId1 / trailerNumber1 - First trailer
  • trailerId2 / trailerNumber2 - Second trailer
  • unitId / unitNumber - Unit information
Carrier:
  • carrierId / carrierName - Carrier details
  • carrierRef / carrierContact - Carrier reference and contact
Pickup Location:
  • pickupDate / pickupTimeIn / pickupTimeOut - Pickup schedule
  • pickupName / pickupAddress / pickupCity / pickupState / pickupZip / pickupZone - Pickup location
  • pickupCustomer - Pickup customer ID
Drop Location:
  • dropDate / dropTimeIn / dropTimeOut - Drop schedule
  • dropName / dropAddress / dropCity / dropState / dropZip / dropZone - Drop location
  • dropCus - Drop customer ID
  • dropRetDate / dropRetTime - Drop return date/time
Delivery Location:
  • deliveryDate / deliveryTimeIn / deliveryTimeOut - Delivery schedule
  • deliveryName / deliveryAddress / deliveryCity / deliveryState / deliveryZip / deliveryZone - Delivery location
  • deliveryCus - Delivery customer ID
Actual Times:
  • actualDateOrigin / actualTimeInOrigin / actualTimeOutOrigin - Actual origin times
  • actualDateDestination / actualTimeInDestination / actualTimeOutDestination - Actual destination times
Pay & Rates:
  • payType / payCode / payRate / paySource - Pay configuration
  • payMatrixId / payUnits - Pay matrix details
  • totalPay - Total pay amount
  • miles / emptyMiles / emptyRate - Mileage and rates
  • dispatchHours - Dispatch hours
  • trailerCharge - Trailer charge
  • driverPayForeignCurrency / currencyCode - Foreign currency pay
Other:
  • entityCode - Entity code
  • ownerId - Owner ID
  • macroPointOrderId - MacroPoint order ID
  • notes - Dispatch notes
Broker dispatch records from the PCS Software Dispatch API. Contains all the same fields as Company Dispatches, plus:
  • driverCellPhone - Driver’s cell phone number
Refer to the Company Dispatches stream above for the full field list.