Skip to main content
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:
  • Application ID: Your PCS Software Application ID for API authentication. Contact your PCS Software account representative to obtain this value if you do not have it.
  • Application Secret: Your PCS Software Application Secret for API authentication.
  • 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.
FieldTypeDescription
LoadIdStringUnique identifier for the load
StatusStringLoad status (active, arrived, assigned, booked, brokered, cancelled, dispatched, dropped, enroute, moving, pending, possible, ready)
LoadClassStringLoad classification (TL, LTL, Intermodal)
LoadTypeStringLoad type description
BillToIdStringBill-to customer ID
BillToNameStringBill-to customer name
LoadReferenceStringLoad reference number
BillingTypeStringBilling type (P = Prepaid, C = Collect, B = Both)
MilesBilledNumberBilled miles
TotalWeightNumberTotal load weight
PalletsNumberNumber of pallets
NotesStringLoad notes
Reference1StringAdditional reference number
BoundaryStringIntermodal: Boundary type (I = Inbound, O = Outbound, C = Crosstown)
BookingNumberStringIntermodal: Booking number
ContainerStringIntermodal: Container number
ChassisStringIntermodal: Chassis number
Office.CodeStringOffice code
Rating.LineHaulRateObjectLine haul rate details (RateType, Rate, MatrixId, Source)
Rating.AccessorialRatesArrayArray of accessorial rate charges
Rating.CommodityRatingObjectCommodity rating details
StopsArrayArray of stops
Stops[].IdStringStop ID
Stops[].OrderNumberStop order
Stops[].TypeStringStop type (Shipper or Consignee)
Stops[].ZoneStringZone
Stops[].AvailableFromStringAvailability window start
Stops[].AvailableToStringAvailability window end
Stops[].MilesNumberMiles to stop
Stops[].ReferenceNumberStringReference number
Stops[].ContactStringContact name
Stops[].CompanyNameStringCompany name
Stops[].PhoneStringPhone number
Stops[].AddressObjectAddress (CountrySubDivisionCode, City, Line1, PostalCode)
Company dispatch records from the PCS Software Dispatch API, containing driver assignments, vehicle details, pickup/delivery information, and pay data.
FieldTypeDescription
idStringUnique dispatch record ID
loadIdStringAssociated load ID
tripIdStringAssociated trip ID
mainDispatchIdStringMain dispatch ID
batchIdStringBatch ID
statusStringDispatch status
dispatchDateStringDispatch date
dispatchTimeStringDispatch time
dispatchCodeStringDispatch code
inputDateStringInput date
inputTimeStringInput time
inputUserStringUser who entered the record
driverIdStringPrimary driver ID
driverNameStringPrimary driver name
coDriverIdStringCo-driver ID
coDriverNameStringCo-driver name
driverPayNumberDriver pay amount
coDriverPayNumberCo-driver pay amount
truckIdStringTruck ID
truckNumberStringTruck number
trailerId1StringFirst trailer ID
trailerNumber1StringFirst trailer number
trailerId2StringSecond trailer ID
trailerNumber2StringSecond trailer number
unitIdStringUnit ID
unitNumberStringUnit number
carrierIdStringCarrier ID
carrierNameStringCarrier name
carrierRefStringCarrier reference
carrierContactStringCarrier contact
pickupDateStringPickup date
pickupTimeInStringPickup time in
pickupTimeOutStringPickup time out
pickupNameStringPickup location name
pickupAddressStringPickup location address
pickupCityStringPickup location city
pickupStateStringPickup location state
pickupZipStringPickup location zip
pickupZoneStringPickup location zone
pickupCustomerStringPickup customer ID
dropDateStringDrop date
dropTimeInStringDrop time in
dropTimeOutStringDrop time out
dropNameStringDrop location name
dropAddressStringDrop location address
dropCityStringDrop location city
dropStateStringDrop location state
dropZipStringDrop location zip
dropZoneStringDrop location zone
dropCusStringDrop customer ID
dropRetDateStringDrop return date
dropRetTimeStringDrop return time
deliveryDateStringDelivery date
deliveryTimeInStringDelivery time in
deliveryTimeOutStringDelivery time out
deliveryNameStringDelivery location name
deliveryAddressStringDelivery location address
deliveryCityStringDelivery location city
deliveryStateStringDelivery location state
deliveryZipStringDelivery location zip
deliveryZoneStringDelivery location zone
deliveryCusStringDelivery customer ID
actualDateOriginStringActual origin date
actualTimeInOriginStringActual origin time in
actualTimeOutOriginStringActual origin time out
actualDateDestinationStringActual destination date
actualTimeInDestinationStringActual destination time in
actualTimeOutDestinationStringActual destination time out
payTypeStringPay configuration type
payCodeStringPay configuration code
payRateNumberPay configuration rate
paySourceStringPay configuration source
payMatrixIdStringPay matrix ID
payUnitsNumberPay matrix units
totalPayNumberTotal pay amount
milesNumberMileage
emptyMilesNumberEmpty mileage
emptyRateNumberEmpty rate
dispatchHoursNumberDispatch hours
trailerChargeNumberTrailer charge
driverPayForeignCurrencyNumberForeign currency pay
currencyCodeStringForeign currency code
entityCodeStringEntity code
ownerIdStringOwner ID
macroPointOrderIdStringMacroPoint order ID
notesStringDispatch notes
Broker dispatch records from the PCS Software Dispatch API. Contains all the same fields as Company Dispatches, plus the following specific fields:
FieldTypeDescription
driverCellPhoneStringDriver’s cell phone number
Refer to the Company Dispatches stream above for the full field list.

​
Skills for agents

Download PCS Software skills file

PCS Software connector documentation as plain markdown, for use in AI agent contexts.