Data Model
This guide helps you understand the data model and the objects in FTM, along with their relationships. It also gives you a clearer idea of which objects are needed in the system and allows you to extend them as needed.
Accident
API Name: FreightTM__Accident__c
Relevant to: Carriers
Purpose: Tracks and manages information about accidents related to equipment for better monitoring and reporting.
| Field Label | API Name | Type | Description |
| Accident ID | Name | Auto Number | A unique identifier automatically generated for each accident record. |
| Equipment | FreightTM__Equipment__c | Master-Detail (Equipment) | Links the accident record to the related equipment for tracking purposes. |
🔗 Relationships
| Field | Related Object | Notes |
| Equipment | Equipment | Master-Detail to the associated Equipment record. |
Bid
API Name: FreightTM__Bid__c
Relevant to: Brokers, Shippers
Purpose: Represents a bid submitted by brokers or carriers for transporting a load, including financial details and related information.
| Field Label | API Name | Type | Description |
| Bid Name | Name | Auto Number | A unique identifier automatically generated for each bid record. |
| Carrier | FreightTM__Carrier__c | Lookup (Carrier) | Links the bid to the carrier submitting the offer. |
| Load | FreightTM__Load__c | Master-Detail (Load) | Associates the bid with the corresponding load being bid on. |
| Rate | FreightTM__Rate__c | Currency (16, 2) | Represents the monetary amount of the bid. |
🔗 Relationships
| Field | Related Object | Notes |
| Carrier | Carrier | Lookup to the carrier submitting the bid. |
| Load | Load | Master-Detail relationship to the load that the bid is associated with. |
Cargo
API Name: FreightTM__Cargo__c
Relevant to: Shippers, Brokers
Purpose: Represents cargo details, including ownership and tracking information for effective shipment management.
| Field Label | API Name | Type | Description |
| Cargo Name | Name | Text (80) | The name or identifier of the cargo, up to 80 characters. |
| Owner | OwnerId | Lookup (User, Group) | Indicates the user or group responsible for the cargo record. |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User / Group | Lookup to either a user or a group responsible for the cargo. |
Cargo Item
API Name: FreightTM__Cargo_Item__c
Relevant to: Shippers, Brokers
Purpose: Represents individual cargo items within a shipment, including physical attributes, associated accounts, and vendor information.
| Field Label | API Name | Type | Description |
| Account | FreightTM__Account__c | Lookup (Account) | Links the cargo item to the related customer account. |
| Cargo Item ID | Name | Auto Number | A unique identifier automatically generated for each cargo item record. |
| Commodity | FreightTM__Commodity__c | Text (100) | Describes the type of goods being transported, up to 100 characters. |
| Description | FreightTM__Description__c | Text Area (255) | A detailed description of the cargo item, up to 255 characters. |
| EDi Ref # | FreightTM__EDi_Ref__c | Text (100) | EDI reference number for tracking, up to 100 characters. |
| Height | FreightTM__Height__c | Number (6, 2) | Height of the cargo item (numeric, 2 decimal places). |
| Length | FreightTM__Length__c | Number (6, 2) | Length of the cargo item (numeric, 2 decimal places). |
| Load | FreightTM__Load__c | Master-Detail (Load) | Associates the cargo item with the corresponding load. |
| Vendor | FreightTM__Vendor__c | Lookup (Carrier) | Links the cargo item to the responsible carrier. |
| Volume | FreightTM__Volume__c | Formula (Number) | A calculated field representing the volume of the cargo item. |
| Volume Copy | FreightTM__Volume_Copy__c | Number (16, 2) | A stored copy of the calculated volume (up to 16 digits, 2 decimals). |
| Width | FreightTM__Width__c | Number (6, 2) | Width of the cargo item (numeric, 2 decimal places). |
🔗 Relationships
| Field | Related Object | Notes |
| Account | Account | Lookup to the customer account associated with this item. |
| Load | Load | Master-detail relationship to the parent load. |
| Vendor | Carrier | Lookup to the carrier responsible for transporting the item. |
Carrier
API Name: FreightTM__Carrier__c
Relevant to: Shippers, Brokers
Purpose: The Carrier Object is typically used to manage information about transportation companies (carriers). It stores details such as the company name, contact information, and shipping status, supporting logistics and supply chain processes.
| Field Label | API Name | Type | Description |
| After Hours Phone | FreightTM__After_Hours_Phone__c | Phone | Contact number available for after-business hours communication. |
| Billing City | FreightTM__Billing_City__c | Text (20) | The city associated with the carrier’s billing address. |
| Billing Country | FreightTM__Billing_Country__c | Picklist | The country associated with the carrier’s billing address. |
| Billing State/Province | FreightTM__Billing_State_Province__c | Picklist | The state or province of the carrier’s billing address. |
| Billing Street | FreightTM__Billing_Address__c | Text (60) | The street address used for billing. |
| Billing Zip Code | FreightTM__Billing_Zip_Code__c | Text (10) | The postal code for the carrier’s billing address. |
| Cargo Insurance Amount | FreightTM__Cargo_Insurance_Amount__c | Currency (8, 0) | The amount of cargo insurance coverage. |
| Cargo Insurance Expiration | FreightTM__Cargo_Insurance_Expiration__c | Date | The expiration date of the cargo insurance policy. |
| Carrier Name | Name | Text (80) | The official name of the carrier. |
| City | FreightTM__City__c | Text (20) | The city where the carrier is located. |
| Country | FreightTM__Country__c | Picklist | The country where the carrier is located. |
| FreightTM__Email__c | The primary email address of the carrier. | ||
| Fax | FreightTM__Fax__c | Phone | The fax number for the carrier. |
| Federal ID # | FreightTM__Federal_ID__c | Text (10) | The carrier’s federal identification number. |
| Hazmat Permit | FreightTM__Hazmat_Permit__c | Checkbox | Indicates whether the carrier has hazardous materials certification. |
| Liability Insurance Amount | FreightTM__Liability_Insurance_Amount__c | Currency (8, 0) | The amount of liability insurance coverage. |
| Liability Insurance Expiration | FreightTM__Liability_Insurance_Expiration__c | Date | The expiration date of the liability insurance policy. |
| LTL | FreightTM__LTL__c | Checkbox | Indicates whether the carrier supports Less-Than-Truckload (LTL) shipments. |
| MC/MX/FF Number | FreightTM__MC_MX_FF_Number__c | Text (10) | The carrier’s Motor Carrier, Mexico Carrier, or Freight Forwarder number. |
| Mode | FreightTM__Mode__c | Picklist (Multi-Select) | Specifies the transportation modes the carrier supports (e.g., Air, Ground). |
| Number of Drivers | FreightTM__Number_of_Drivers__c | Number (6, 0) | The total number of drivers employed by the carrier. |
| Number of Tractors | FreightTM__Number_of_Tractors__c | Number (6, 0) | The total number of tractor units available. |
| Number of Trailers | FreightTM__Number_of_Trailers__c | Number (6, 0) | The total number of trailers available. |
| On-boarding Status | FreightTM__On_boarding_Status__c | Picklist | Indicates the current stage of the carrier’s onboarding process. |
| Online GPS Tracking | FreightTM__Online_GPS_Tracking__c | Checkbox | Indicates whether the carrier supports online GPS tracking. |
| Owner | OwnerId | Lookup (User, Group) | Identifies the user or group that owns the carrier record. |
| Phone | FreightTM__Phone__c | Phone | The primary phone number of the carrier. |
| Preferred Lanes | FreightTM__Preferred_Lanes__c | Text Area (255) | Describes the preferred transportation routes or lanes. |
| Primary Contact | FreightTM__Primary_Contact__c | Text (30) | The name of the primary contact person at the carrier. |
| Remarks | FreightTM__Remarks__c | Text Area (255) | Additional notes or comments regarding the carrier. |
| SCAC Code | FreightTM__SCAC_Code__c | Text (5) | The Standard Carrier Alpha Code (SCAC) used for carrier identification. |
| State/Province | FreightTM__State_Province__c | Picklist | The state or province where the carrier is located. |
| Street | FreightTM__Address__c | Text (60) | The physical street address of the carrier. |
| Title | FreightTM__Title__c | Text (20) | The title or position of the primary contact person. |
| USDOT Number | FreightTM__USDOT_Number__c | Text (10) | The U.S. Department of Transportation (USDOT) number for the carrier. |
| Website | FreightTM__Website__c | URL (255) | The carrier’s official website URL. |
| Zip Code | FreightTM__Zip_Code__c | Text (10) | The postal code of the carrier’s location. |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User or Group | Identifies the user or group responsible for the carrier record. |
Carrier Contact
API Name: FreightTM__Carrier__c
Relevant to: Brokers, Shippers
Purpose: Stores contact details of individuals associated with a carrier, including their communication information and roles.
| Field Label | API Name | Type | Description |
| Carrier | FreightTM__Carrier__c | Master-Detail (Carrier) | Links the contact to a specific carrier. |
| Carrier Contact Name | Name | Text (80) | The full name of the carrier contact. |
| Cellphone | FreightTM__Cellphone__c | Phone | The contact’s mobile phone number. |
| FreightTM__Email__c | The contact’s email address. | ||
| Phone | FreightTM__Phone__c | Phone | The contact’s primary phone number. |
| Roles | FreightTM__Roles__c | Picklist (Multi-Select) | Specifies the roles or responsibilities of the contact. |
| Title | FreightTM__Title__c | Text (100) | The job title or position of the contact within the carrier organization. |
🔗 Relationships
| Field | Related Object | Notes |
| Carrier | Carrier | Master-Detail relationship to Carrier Object. |
Claim
API Name: FreightTM__Claim__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Manages claims related to damaged or lost cargo, including financial details and submission tracking.
| Field Label | API Name | Type | Description |
| Claim ID | Name | Auto Number | Unique identifier for each claim. |
| Damage Cost | FreightTM__Damage_Cost__c | Currency (10, 2) | Estimated or actual cost of the damage. |
| Deadline | FreightTM__Deadline__c | Date | Final date for resolving or processing the claim. |
| Description | FreightTM__Description__c | Rich Text Area (131072) | Detailed description of the claim and its circumstances. |
| Load | FreightTM__Load__c | Lookup (Load) | Reference to the cargo load associated with the claim. |
| Owner | OwnerId | Lookup (User, Group) | User or group responsible for managing the claim. |
| Submission Date | FreightTM__Submission_Date__c | Date | Date the claim was submitted for review or action. |
🔗 Relationships
| Field | Related Object | Notes |
| Load | Load | Lookup to the Load object associated with the claim. |
| Owner | User, Group | Lookup to the User or Group managing the claim. |
Container
API Name: FreightTM__Container__c
Relevant to: Carriers, Shippers
Purpose: Represents physical containers used for transporting cargo, including dimensions and type.
| Field Label | API Name | Type | Description |
| Container ID | Name | Auto Number | Unique identifier for each container. |
| Description | FreightTM__Description__c | Text Area (255) | Additional details or notes about the container. |
| Height | FreightTM__Height__c | Number (6, 2) | Height of the container (in specified units). |
| Length | FreightTM__Length__c | Number (6, 2) | Length of the container (in specified units). |
| Owner | OwnerId | Lookup (User, Group) | User or group responsible for managing the container. |
| Type | FreightTM__Type__c | Picklist | Type of container (e.g., Dry Van, Reefer, Flatbed). |
| Width | FreightTM__Width__c | Number (6, 2) | Width of the container (in specified units). |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User, Group | Lookup to the User or Group managing the container. |
Defect
API Name: FreightTM__Defect__c
Relevant to: Carriers, Brokers, Brokers
Purpose: Tracks defects related to equipment, providing details on the issue and the responsible equipment.
| Field Label | API Name | Type | Description |
| Defect ID | Name | Auto Number | Unique identifier for each defect record. |
| Description | FreightTM__Description__c | Text Area (255) | Detailed description of the defect or issue. |
| Equipment | FreightTM__Equipment__c | Master-Detail (Equipment) | Reference to the specific equipment related to the defect. |
🔗 Relationships
| Field | Related Object | Notes |
| Equipment | Equipment | Master-Detail relationship to Equipment. |
Driving Distance
API Name: FreightTM__Mileage__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Represents the driving distance record, tracking information related to the driver, truck, and mileage over a specific time period.
| Field Label | API Name | Type | Description |
| Distance ID | Name | Auto Number | A unique identifier for the driving distance record. |
| Driver | FreightTM__Driver__c | Lookup (Worker) | Links the driving distance record to the driver who completed the trip. |
| End Date | FreightTM__End_Date__c | Date | The date when the driving period ended. |
| Miles | FreightTM__Miles__c | Number (8, 2) | The total distance in miles covered during the driving period. |
| Owner | OwnerId | Lookup (User, Group) | Identifies the user or group that owns the driving distance record. |
| Start Date | FreightTM__Start_Date__c | Date | The date when the driving period began. |
| State | FreightTM__State__c | Picklist | Indicates the state where the driving activity occurred (e.g., “In Progress”, “Completed”). |
| Truck | FreightTM__Truck__c | Lookup (Equipment) | Links the driving distance record to the truck used for the trip. |
🔗 Relationships
| Field | Related Object | Notes |
| Driver | Worker | Lookup to the worker (driver) associated with the driving record. |
| Truck | Equipment | Lookup to the equipment (truck) used for the driving activity. |
Equipment
API Name: FreightTM__Truck__c
Relevant to: Carriers, Shippers
Purpose: Represents a physical vehicle or piece of equipment used in transportation, storing details such as dimensions, drivers, registration info, and operational status.
| Field Label | API Name | Type | Description |
| Active | FreightTM__Active__c | Checkbox | Indicates if the equipment is currently active. |
| Color | FreightTM__Color__c | Text (20) | The color of the equipment. |
| Coupled with | FreightTM__Coupled_with__c | Lookup (Equipment) | References another equipment this one is coupled with. |
| Driver | FreightTM__Driver__c | Lookup (Worker) | Primary driver assigned to this equipment. |
| Equipment Owner | FreightTM__Equipment_Owner__c | Text (80) | Name of the company or person owning the equipment. |
| Features | FreightTM__Features__c | Picklist (Multi-Select) | Equipment features or capabilities. |
| Height | FreightTM__Height__c | Number (3, 2) | Height of the equipment in meters. |
| Initial Odometer Stand | FreightTM__Initial_Odometer_Stand__c | Number (7, 0) | Odometer reading at the start of equipment use. |
| Last Odometer Stand | FreightTM__Last_Odometer_Mileage__c | Number (8, 0) | Most recent odometer reading. |
| Last Time Odometer Read | FreightTM__Last_Time_Mileage_Read__c | Date | Date when odometer was last read. |
| Length | FreightTM__Length__c | Number (3, 2) | Length of the equipment in meters. |
| License Plate | FreightTM__License_Plate__c | Text (20) | License plate number of the equipment. |
| License Plate Country | FreightTM__License_Plate_Country__c | Picklist | Country of the license plate. |
| License Plate State/Province | FreightTM__License_Plate_State__c | Picklist (dependent on Country) | State or province of the license plate. |
| Maintenance History | FreightTM__Maintenance_History__c | Long Text Area (32768) | Detailed maintenance records. |
| Make | FreightTM__Make__c | Picklist | Manufacturer of the equipment. |
| Model | FreightTM__Model__c | Picklist (dependent on Make) | Specific model of the equipment. |
| Owner | OwnerId | Lookup (User, Group) | Record owner (user or group). |
| Physical Damage Insurance Value | FreightTM__Physical_Damage_Insurance_Value__c | Currency (7, 2) | Value covered by physical damage insurance. |
| Purchase Date | FreightTM__Purchase_Date__c | Date | Date the equipment was purchased. |
| Purchase Price | FreightTM__Purchase_Price__c | Currency (7, 2) | Price paid for the equipment. |
| Registration Expiration | FreightTM__Registration_Expiration__c | Date | Date when the registration expires. |
| Second Driver | FreightTM__Second_Driver__c | Lookup (Worker) | A secondary driver assigned to the equipment. |
| Space | FreightTM__Space__c | Formula (Number) | Available space, calculated via formula. |
| Status | FreightTM__Status__c | Picklist | Current operational status (e.g., Active, In Repair, Retired). |
| Total Number of Inspections | FreightTM__Total_Number_of_Inspections__c | Roll-Up Summary (COUNT Inspection) | Total count of inspections related to this equipment. |
| Total Service Amount | FreightTM__Total_Service_Amount__c | Roll-Up Summary (SUM Service) | Total cost of all services associated with the equipment. |
| Type | FreightTM__Type__c | Picklist | Type or classification of the equipment. |
| Unit Number | Name | Text (80) | Internal tracking number or ID for the equipment. |
| Unladen Weight | FreightTM__Unladen_Weight__c | Number (7, 0) | Weight of the equipment without cargo (in kg or lbs). |
| Use Type | FreightTM__Use_Type__c | Picklist | Usage classification (e.g., Private, Commercial). |
| VIN Number | FreightTM__VIN_Number__c | Text (17) | Vehicle Identification Number. |
| Width | FreightTM__Width__c | Number (3, 2) | Width of the equipment in meters. |
| Year | FreightTM__Year__c | Picklist | Manufacturing year. |
🔗 Relationships
| Field | Related Object | Notes |
| Coupled with | Equipment | Self-referencing lookup to another Equipment record. |
| Driver | Worker | Primary driver assigned to this equipment. |
| Second Driver | Worker | Secondary driver if assigned. |
| Owner | User, Group | Owner of the Equipment record. |
Expense
API Name: FreightTM__Expense__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Tracks the expenses related to freight, including details such as amounts, discounts, payment methods, and associated records like workers, loads, trips, and vendors.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Currency (10, 2) | The total amount of the expense. |
| Credit to Worker | FreightTM__Paid_by_Worker__c | Checkbox | Indicates if the expense is credited to the worker. |
| Date | FreightTM__Date__c | Date | The date of the expense. |
| Description | FreightTM__Description__c | Text Area (255) | A detailed description of the expense. |
| Discount (%) | FreightTM__Discount_Percent__c | Percent (3, 0) | The percentage discount applied to the expense. |
| Employee | FreightTM__Employee__c | Lookup (Worker) | References the worker associated with the expense. |
| Include in Settlement | FreightTM__Include_in_Settlement__c | Checkbox | Indicates if the expense should be included in the settlement. |
| Load | FreightTM__Load__c | Lookup (Load) | References the load associated with the expense. |
| Owner | OwnerId | Lookup (User, Group) | References the user or group that owns the expense record. |
| Payee | FreightTM__Payee__c | Text (40) | The name of the payee for the expense. |
| Payer | FreightTM__Payer__c | Text (20) | The name of the payer for the expense. |
| Payment Method | FreightTM__Payment_Method__c | Picklist | The method used for payment of the expense. |
| Purchase ID | Name | Auto Number | A unique identifier for each purchase (expense) record. |
| Shipping | FreightTM__Shipping__c | Currency (8, 2) | The shipping cost associated with the expense. |
| Status | FreightTM__Status__c | Picklist | The current status of the expense (e.g., pending, paid). |
| Subtotal | FreightTM__Subtotal__c | Roll-Up Summary (SUM Purchase Item) | The subtotal of the associated purchase items. |
| Tax (%) | FreightTM__Tax_Percent__c | Percent (3, 4) | The percentage of tax applied to the expense. |
| Trip | FreightTM__Trip__c | Lookup (Trip) | References the trip associated with the expense. |
| Truck | FreightTM__Truck__c | Lookup (Equipment) | References the truck (equipment) associated with the expense. |
| Type | FreightTM__Type__c | Picklist | The type of expense (e.g., fuel, toll, maintenance). |
| Vendor | FreightTM__Vendor__c | Lookup (Account) | References the vendor associated with the expense. |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User / Group | Owner of the expense record. |
| Employee | Worker | Links the expense to a specific worker. |
| Load | Load | Links to the load related to this expense. |
| Trip | Trip | References the related trip. |
| Truck | Equipment | References the truck used for the expense. |
| Vendor | Account | Links to the vendor providing the goods/services. |
Expense Transaction
API Name: FreightTM__Expense_Transaction__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Tracks the individual transactions related to an expense, including amounts, related expense records, and user information.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Currency (10, 2) | The total amount for the expense transaction. |
| Expense | FreightTM__Expense__c | Master-Detail (Expense) | Links the expense transaction to a specific expense record. |
| Expense Transaction ID | Name | Auto Number | A unique identifier for each expense transaction record. |
🔗 Relationships
| Field | Related Object | Notes |
| Expense | Expense | Master-detail relationship linking to the related expense record. |
Facility
API Name: FreightTM__Facility__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Tracks detailed information about a facility, including contact details, location, working hours, and associated company.
| Field Label | API Name | Type | Description |
| City | FreightTM__City__c | Text(40) | The city where the facility is located. |
| Company | FreightTM__Company__c | Lookup (Account) | Links the facility to a specific company account. |
| Country | FreightTM__Country__c | Picklist | The country where the facility is located. |
| FreightTM__Email__c | The facility’s contact email address. | ||
| Facility Name | Name | Text(80) | The name of the facility. |
| Owner | OwnerId | Lookup (User, Group) | References the user or group that owns the facility record. |
| Phone | FreightTM__Phone__c | Phone | The facility’s primary phone number. |
| Primary Contact | FreightTM__Primary_Contact__c | Text(30) | The name of the primary contact person at the facility. |
| Remarks | FreightTM__Remarks__c | Text Area(255) | Additional remarks or notes about the facility. |
| State/Province | FreightTM__State__c | Picklist | The state or province where the facility is located. |
| Street | FreightTM__Street__c | Text(100) | The street address of the facility. |
| Type | FreightTM__Type__c | Picklist | The type of facility (e.g., warehouse, office). |
| Working End Time | FreightTM__Working_End_Time__c | Time | The time when the facility closes. |
| Working Start Time | FreightTM__Working_Start_Time__c | Time | The time when the facility opens. |
| Zip Code | FreightTM__Zip_Code__c | Text(10) | The postal code of the facility’s location. |
🔗 Relationships
| Field | Related Object | Notes |
| Company | Account | Lookup to the associated company account. |
| Owner | User or Group | Lookup to the user or group that owns the record. |
Facility Holiday
API Name: FreightTM__Facility_Holiday__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Tracks holidays associated with a specific facility, providing details on the holiday and the responsible facility.
| Field Label | API Name | Type | Description |
| Facility | FreightTM__Facility__c | Master-Detail (Facility) | Links the holiday to a specific facility. |
| Facility Holiday ID | Name | Auto Number | Unique identifier for each facility holiday record. |
🔗 Relationships
| Field | Related Object | Notes |
| Facility | Facility | Master-Detail to the associated facility record. |
Fuel
API Name: FreightTM__Fuel__c
Relevant to: Carriers
Purpose: Tracks fuel-related transactions, including details about the fuel purchased, the driver, the truck used, and the associated fees.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Currency (5, 2) | The total cost of the fuel transaction. |
| Card Number | FreightTM__Card_Number__c | Text (16) | The card number used for the fuel purchase. |
| City | FreightTM__City__c | Text (20) | The city where the fuel was purchased. |
| Country | FreightTM__Country__c | Picklist | The country where the fuel transaction took place. |
| Driver | FreightTM__Driver__c | Lookup (Worker) | The worker (driver) associated with the fuel transaction. |
| Fees | FreightTM__Fees__c | Currency (3, 2) | Additional fees related to the fuel transaction. |
| Fuel ID | Name | Auto Number | Unique identifier for each fuel record. |
| Include in Settlement | FreightTM__Include_in_Settlement__c | Checkbox | Indicates whether the fuel transaction should be included in settlement. |
| Location Name | FreightTM__Location_Name__c | Text (40) | The name of the location where the fuel was purchased. |
| Odometer | FreightTM__Odometer__c | Number (12, 2) | The odometer reading of the truck at the time of the fuel transaction. |
| Owner | OwnerId | Lookup (User, Group) | References the user or group that owns the fuel record. |
| Quantity | FreightTM__Quantity__c | Number (4, 2) | The quantity of fuel purchased. |
| State/Province | FreightTM__State__c | Picklist | The state or province where the fuel transaction occurred. |
| Transaction Date | FreightTM__Transaction_Date__c | Date | The date the fuel transaction occurred. |
| Trip | FreightTM__Trip__c | Lookup (Trip) | Links the fuel transaction to a specific trip. |
| Truck | FreightTM__Truck__c | Lookup (Equipment) | Links the fuel transaction to the truck (equipment) used. |
| Type | FreightTM__Type__c | Picklist | The type of fuel transaction (e.g., diesel, gasoline). |
| Unit Price | FreightTM__Unit_Price__c | Currency (2, 2) | The price per unit of fuel. |
🔗 Relationships
| Field | Related Object | Notes |
| Driver | Worker | Lookup to the worker (driver) associated with the transaction. |
| Trip | Trip | Lookup to the associated trip for the fuel transaction. |
| Truck | Equipment | Lookup to the truck (equipment) used in the fuel transaction. |
| Owner | User, Group | Lookup to the user or group that owns the record. |
Inspection
API Name: FreightTM__Inspection__c
Relevant to: Carriers
Purpose: Tracks inspection details for equipment, including the inspection results, equipment involved, and the associated costs.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Currency (6, 2) | The cost associated with the inspection. |
| Date | FreightTM__Date__c | Date | The date the inspection took place. |
| Description | FreightTM__Description__c | Text Area (255) | A detailed description of the inspection. |
| Equipment | FreightTM__Equipment__c | Master-Detail (Equipment) | Links the inspection to a specific piece of equipment. |
| Inspection | Name | Auto Number | Unique identifier for each inspection record. |
| Level | FreightTM__Level__c | Picklist | The level of inspection (e.g., basic, advanced). |
| Location | FreightTM__Location__c | Text (120) | The location where the inspection took place. |
| Results | FreightTM__Results__c | Picklist | The results of the inspection (e.g., passed, failed, requires attention). |
| Type | FreightTM__Type__c | Picklist | The type of inspection (e.g., routine, emergency, safety). |
🔗 Relationships
| Field | Related Object | Notes |
| Equipment | Equipment | Master-Detail relationship to link the inspection with specific equipment. |
Item
API Name: FreightTM__Item_Movement__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Tracks inventory and item details within a facility, including quantities, dimensions, location, and related product information.
| Field Label | API Name | Type | Description |
| Absolute Quantity | FreightTM__Absolut_Quantity__c | Formula (Number) | The absolute quantity of the item, calculated based on certain parameters. |
| Aisle | FreightTM__Aisle__c | Picklist | The aisle where the item is stored within the facility. |
| Expiration | FreightTM__Expiration__c | Date | The expiration date of the item, if applicable. |
| Facility | FreightTM__Facility__c | Master-Detail (Facility) | Links the item to a specific facility. |
| Height | FreightTM__Height__c | Number (3, 2) | The height of the item in the unit of measurement specified. |
| Item ID | Name | Auto Number | Unique identifier for each item record. |
| Length | FreightTM__Length__c | Number (3, 2) | The length of the item in the unit of measurement specified. |
| Movement Type | FreightTM__Movement_Type__c | Picklist | Describes the type of movement for the item (e.g., received, dispatched, in transit). |
| Operator | FreightTM__Operator__c | Lookup (User) | The operator responsible for managing the item record. |
| Product | FreightTM__Product__c | Lookup (Product) | References the related product associated with the item. |
| Quantity | FreightTM__Quantity__c | Number (16, 0) | The quantity of the item in stock. |
| Section | FreightTM__Section__c | Picklist | The section within the facility where the item is stored. |
| Shelf | FreightTM__Shelf__c | Picklist | The specific shelf where the item is placed. |
| Width | FreightTM__Width__c | Number (3, 2) | The width of the item in the unit of measurement specified. |
🔗 Relationships
| Field | Related Object | Notes |
| Facility | Facility | Master-Detail relationship to link the item with a specific facility. |
| Operator | User | Lookup to the operator responsible for managing the item record. |
| Product | Product | Lookup to the product associated with the item. |
Lane Quote
API Name: FreightTM__Lane_Quote__c
Relevant to: Carriers, Shippers, Brokers
Purpose: The Lane Quote Object helps organizations create, manage, and track the pricing details for specific transportation lanes. It is primarily used by logistics, transportation, or freight companies to provide accurate pricing estimates based on the specific routes and transportation lanes they are using. This Object helps streamline the quoting process for transportation services by providing detailed pricing information for each lane.
| Field Label | API Name | Type | Description |
| Carrier | FreightTM__Carrier__c | Lookup (Carrier) | References the carrier associated with the lane quote. |
| Contract | FreightTM__Contract__c | Lookup (Contract) | Links the lane quote to a specific contract. |
| Customer | FreightTM__Customer__c | Lookup (Account) | References the customer (account) for whom the lane quote is provided. |
| Customer Rate | FreightTM__Customer_Rate__c | Currency(7, 2) | The rate quoted to the customer for the lane. |
| Delivery 3 Zip | FreightTM__Delivery_3_Zip__c | Formula (Text) | Formula field for the delivery ZIP code. |
| Delivery City | FreightTM__Delivery_City__c | Text (40) | The city for the delivery location. |
| Delivery Country | FreightTM__Delivery_Country__c | Picklist | The country for the delivery location. |
| Delivery Facility | FreightTM__Delivery_Facility__c | Lookup (Facility) | The facility where the delivery is made. |
| Delivery State/Province | FreightTM__Delivery_State__c | Picklist | The state or province of the delivery location, based on the delivery country. |
| Delivery Street | FreightTM__Delivery_Street__c | Text (100) | The street address of the delivery location. |
| Delivery Zip Code | FreightTM__Delivery_Zip_Code__c | Text (10) | The ZIP code of the delivery location. |
| Description | FreightTM__Description__c | Text Area (255) | A detailed description of the lane quote. |
| Estimated Delivery Time | FreightTM__Estimated_Delivery_Time__c | Date/Time | The estimated time of delivery for the quote. |
| Estimated Pickup Time | FreightTM__Estimated_Pickup_Time__c | Date/Time | The estimated time of pickup for the quote. |
| Lane 3 Zips | FreightTM__Lane_3_Zips__c | Formula (Text) | Formula field for lane ZIP codes. |
| Lane Quote ID | Name | Auto Number | A unique identifier for the lane quote record. |
| Mode | FreightTM__Mode__c | Picklist | The mode of transportation for the lane quote. |
| Order | FreightTM__Order__c | Lookup (Order) | The related order for the lane quote. |
| Owner | OwnerId | Lookup (User, Group) | The owner of the lane quote record. |
| Pickup 3 Zip | FreightTM__Pickup_3_Zip__c | Formula (Text) | Formula field for the pickup ZIP code. |
| Pickup City | FreightTM__Pickup_City__c | Text (40) | The city for the pickup location. |
| Pickup Country | FreightTM__Pickup_Country__c | Picklist | The country for the pickup location. |
| Pickup Facility | FreightTM__Pickup_Facility__c | Lookup (Facility) | The facility where the pickup is made. |
| Pickup State/Province | FreightTM__Pickup_State__c | Picklist | The state or province of the pickup location, based on the pickup country. |
| Pickup Street | FreightTM__Pickup_Street__c | Text (100) | The street address of the pickup location. |
| Pickup Zip Code | FreightTM__Pickup_Zip_Code__c | Text (10) | The ZIP code of the pickup location. |
| Priority | FreightTM__Priority__c | Picklist | The priority level of the lane quote (e.g., low, medium, high). |
| Rate to Carrier | FreightTM__Rate_to_Carrier__c | Currency(7, 2) | The rate paid to the carrier for the lane. |
| Status | FreightTM__Status__c | Picklist | The status of the lane quote (e.g., active, inactive, pending). |
| Weight | FreightTM__Weight__c | Number(6, 0) | The total weight for the lane quote. |
🔗 Relationships
| Field | Related Object | Notes |
| Carrier | Carrier | Lookup to the carrier associated with the lane quote. |
| Contract | Contract | Lookup to the specific contract linked with the lane quote. |
| Customer | Account | Lookup to the customer (account) who receives the lane quote. |
| Delivery Facility | Facility | Lookup to the facility where the delivery is made. |
| Order | Order | Lookup to the related order for the lane quote. |
| Owner | User or Group | Lookup to the user or group that owns the lane quote record. |
| Pickup Facility | Facility | Lookup to the facility where the pickup is made. |
Leg
API Name: FreightTM__Leg__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Represents individual legs of a transportation route, including delivery and pickup details, driver, status, and payments.
| Field Label | API Name | Type | Description |
| Carrier | FreightTM__Carrier__c | Lookup (Carrier) | References the carrier for the transportation leg. |
| Carrier Pay | FreightTM__Carrier_Pay__c | Currency(10, 2) | The amount paid to the carrier for the leg of transportation. |
| Container Number | FreightTM__Container_Number__c | Text (40) | The identification number for the container being used during the leg. |
| Delivery City | FreightTM__Delivery_City__c | Text (40) | The city for the delivery location. |
| Delivery Country | FreightTM__Delivery_Country__c | Picklist | The country of the delivery location. |
| Delivery Facility | FreightTM__Delivery_Facility__c | Lookup (Facility) | The facility where the delivery is made. |
| Delivery State | FreightTM__Delivery_State__c | Picklist | The state for the delivery location, based on the delivery country. |
| Delivery Street | FreightTM__Delivery_Street__c | Text (100) | The street address of the delivery location. |
| Delivery ZIP Code | FreightTM__Delivery_ZIP_Code__c | Text (10) | The ZIP code of the delivery location. |
| Driver | FreightTM__Driver__c | Lookup (Worker) | The driver assigned to this transportation leg. |
| Leg ID | Name | Auto Number | A unique identifier for the transportation leg. |
| Load | FreightTM__Load__c | Master-Detail (Load) | Links to the load record that the leg is part of. |
| Pickup City | FreightTM__Pickup_City__c | Text (40) | The city for the pickup location. |
| Pickup Country | FreightTM__Pickup_Country__c | Picklist | The country for the pickup location. |
| Pickup Facility | FreightTM__Pickup_Facility__c | Lookup (Facility) | The facility where the pickup is made. |
| Pickup State | FreightTM__Pickup_State__c | Picklist | The state for the pickup location, based on the pickup country. |
| Pickup Street | FreightTM__Pickup_Street__c | Text (100) | The street address of the pickup location. |
| Pickup ZIP Code | FreightTM__Pickup_ZIP_Code__c | Text (10) | The ZIP code of the pickup location. |
| Status | FreightTM__Status__c | Picklist | The current status of the transportation leg (e.g., pending, completed, in progress). |
| Total Cargo Length | FreightTM__Total_Cargo_Length__c | Roll-Up Summary (SUM Leg Cargo Item) | The total length of cargo in the leg, calculated by summing the related Leg Cargo Item records. |
| Total Cargo Weight | FreightTM__Total_Cargo_Weight__c | Roll-Up Summary (SUM Leg Cargo Item) | The total weight of the cargo in the leg, calculated by summing the related Leg Cargo Item records. |
| Total Leg Payments | FreightTM__Total_Leg_Payments__c | Roll-Up Summary (SUM Leg Payment) | The total payments for the leg, calculated by summing the related Leg Payment records. |
| Transportation Mode | FreightTM__Transportation_Mode__c | Picklist | The mode of transportation used for this leg (e.g., truck, rail, air). |
🔗 Relationships
| Field | Related Object | Notes |
| Carrier | Carrier | Lookup to the carrier for the transportation leg. |
| Delivery Facility | Facility | Lookup to the facility where the delivery is made. |
| Driver | Worker | Lookup to the driver assigned to this transportation leg. |
| Load | Load | Master-Detail relationship to the load record that the leg is part of. |
| Pickup Facility | Facility | Lookup to the facility where the pickup is made. |
Leg Cargo Item
API Name: FreightTM__Leg_Cargo_Item__c
Relevant to: Carriers, Shippers, Brokers
Purpose: Represents individual cargo items within a leg of transportation, including the commodity, description, weight, length, and other related details.
| Field Label | API Name | Type | Description |
| Commodity | FreightTM__Commodity__c | Text (100) | The type or name of the commodity being transported in this cargo item. |
| Description | FreightTM__Description__c | Text Area (255) | A detailed description of the cargo item. |
| Leg | FreightTM__Leg__c | Master-Detail (Leg) | Links the cargo item to the transportation leg it is part of. |
| Leg Cargo Item ID | Name | Auto Number | A unique identifier for the cargo item within the transportation leg. |
| Length | FreightTM__Length__c | Number (6, 2) | The length of the cargo item in units (e.g., meters or feet). |
| Weight | FreightTM__Weight__c | Number (6, 2) | The weight of the cargo item in units (e.g., kilograms or pounds). |
🔗 Relationships
| Field | Related Object | Notes |
| Leg | Leg | Master-Detail relationship to the transportation leg the cargo item is part of. |
Leg Payment
API Name: FreightTM__Leg_Payment__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents the payment details for a transportation leg, including the amount, quantity, and unit price associated with the leg.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Formula (Currency) | The total payment amount for the leg, calculated based on other factors such as quantity and unit price. |
| Leg | FreightTM__Leg__c | Master-Detail (Leg) | Links the payment to the specific transportation leg. |
| Leg Payment ID | Name | Auto Number | A unique identifier for the leg payment. |
| Quantity | FreightTM__Quantity__c | Number (8, 2) | The quantity of units involved in the payment. |
| Type | FreightTM__Type__c | Picklist | The type of payment (e.g., fixed, variable, etc.). |
| Unit Price | FreightTM__Unit_Price__c | Currency (6, 2) | The unit price of the goods or services for the leg, used to calculate the total payment amount. |
🔗 Relationships
| Field | Related Object | Notes |
| Leg | Leg | Master-Detail relationship to the transportation leg the payment is linked to. |
Leg Stop
API Name: FreightTM__Leg_Stop__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents a stop along a transportation leg, detailing the specific facility or location where the stop occurs.
| Field Label | API Name | Type | Description |
| Facility | FreightTM__Facility__c | Lookup (Facility) | Links to the facility where the leg stop occurs. |
| Leg | FreightTM__Leg__c | Master-Detail (Leg) | Links the stop to the specific transportation leg. |
| Leg Stop ID | Name | Auto Number | A unique identifier for the leg stop. |
🔗 Relationships
| Field | Related Object | Notes |
| Facility | Facility | Lookup to the facility where the stop occurs. |
| Leg | Leg | Master-Detail relationship to the transportation leg the stop is linked to. |
Line Item
API Name: FreightTM__Line_Item__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents a detailed line item within a load, including the description, price, and quantity of units for a specific item in the load.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Formula (Currency) | The total amount for the line item, calculated based on the unit price and the number of units. |
| Description | FreightTM__Description__c | Text Area (255) | A description of the item in the line item. |
| Line Item ID | Name | Auto Number | A unique identifier for the line item. |
| Load | FreightTM__Load__c | Master-Detail (Load) | Links the line item to the load it is associated with. |
| Number of Units | FreightTM__Number_of_Units__c | Number (8, 2) | The quantity of units for the line item. |
| Type | FreightTM__Type__c | Picklist | The type of line item (e.g., goods, services). |
| Unit Price | FreightTM__Unit_Price__c | Currency (6, 2) | The price per unit for the line item. |
🔗 Relationships
| Field | Related Object | Notes |
| Load | Load | Master-Detail relationship to the load the line item is linked to. |
Load
API Name: FreightTM__Load__c
Relevant to: Carriers, Brokers, Shippers
Purpose: The Load Object is an essential tool for both sales teams and transportation companies. It allows you to track shipments in real-time, optimize routes, and manage costs effectively. For sales teams, it ensures timely deliveries and better customer satisfaction, while for transportation companies, it streamlines operations, reduces errors, and enhances profitability. By centralizing all shipment details, you improve communication and decision-making, making the entire process more efficient for everyone involved.
| Field Label | API Name | Data Type | Description |
| 2nd Alt. Tariff | FreightTM__X2nd_Alt_Tariff__c | Lookup (Tariff) | A reference to the second alternative tariff. |
| 2nd Alt. Tariff Info | FreightTM__X2nd_Alt_Tariff_Info__c | Formula (Text) | Information about the second alternative tariff. |
| Alt. Tariff | FreightTM__Alt_Tariff__c | Lookup (Tariff) | A reference to the alternative tariff. |
| Alt. Tariff Info | FreightTM__Alt_Tariff_Info__c | Formula (Text) | Information about the alternative tariff. |
| Bill Status | FreightTM__Bill_Status__c | Picklist | The status of the bill. |
| Billed On | FreightTM__Billed_On__c | Date | The date when the bill was issued. |
| Branch | FreightTM__Branch__c | Picklist | The branch associated with the freight. |
| Carrier | FreightTM__Carrier_Obj__c | Lookup (Carrier) | A reference to the carrier of the freight. |
| Carrier (Account) | FreightTM__Carrier__c | Lookup (Account) | A reference to the carrier’s account. |
| Carrier Email | FreightTM__Carrier_Email__c | Formula (Text) | The email address of the carrier. |
| Commodity | FreightTM__Commodity__c | Text (100) | The type of commodity being transported. |
| Confirmation Number | FreightTM__Confirmation_Number__c | Text (100) | A unique confirmation number for the shipment. |
| Contact Person | FreightTM__Contact_Person__c | Lookup (Contact) | A reference to the contact person for the freight. |
| Container Number | FreightTM__Container_Number__c | Text (100) | The number associated with the container. |
| Container Size | FreightTM__Container_Size__c | Picklist | The size of the container. |
| Credit Memo | FreightTM__Credit_Memo__c | Text (100) | The credit memo for the freight. |
| Credit to Driver | FreightTM__Credit_to_Driver__c | Currency (5, 2) | The credit amount given to the driver. |
| Customer | FreightTM__Customer__c | Lookup (Account) | A reference to the customer associated with the freight. |
| Days After Delivery | FreightTM__Days_After_Delivery__c | Formula (Number) | The number of days after delivery. |
| Days After Invoicing | FreightTM__Days_After_Invoicing__c | Formula (Number) | The number of days after invoicing. |
| Deadhead | FreightTM__Deadhead__c | Number (5, 2) | The distance driven without carrying a load (deadhead distance). |
| Delivery Arrival | FreightTM__Delivery_Arrival__c | Date/Time | The arrival date and time of the delivery. |
| Delivery By Appointment | FreightTM__Delivery_By_Appointment__c | Picklist | The status of delivery, whether it is by appointment. |
| Delivery City | FreightTM__Delivery_City__c | Text (100) | The city where the delivery will take place. |
| Delivery Contact | FreightTM__Delivery_Contact__c | Text (100) | The contact person for the delivery. |
| Delivery Country | FreightTM__Delivery_Country__c | Picklist | The country where the delivery will take place. |
| Delivery Date | FreightTM__Delivery_Date__c | Date | The scheduled delivery date. |
| Delivery Departure | FreightTM__Delivery_Departure__c | Date/Time | The departure date and time for the delivery. |
| Delivery Email | FreightTM__Delivery_Email__c | The email address for delivery communication. | |
| Delivery Facility | FreightTM__DeliveryFacility__c | Lookup (Facility) | A reference from the facility to the delivery facility. |
| Delivery Facility | FreightTM__Delivery_Facility__c | Lookup(Account) | A reference from the account to the delivery facility. |
| Delivery Phone | FreightTM__Delivery_Phone__c | Phone | The phone number for delivery communication. |
| Delivery Ref. # | FreightTM__Delivery_Ref__c | Text (100) | The reference number for the delivery. |
| Delivery Remarks | FreightTM__Delivery_Remarks__c | Text Area (255) | Remarks regarding the delivery. |
| Delivery State/Province | FreightTM__Delivery_State__c | Picklist | The state or province where the delivery will take place. |
| Delivery Street | FreightTM__Delivery_Address__c | Text (100) | The street address for the delivery. |
| Delivery Working Hours | FreightTM__Delivery_In_and_Out_Times__c | Text Area (255) | The working hours for the delivery facility. |
| Delivery Zip Code | FreightTM__Delivery_Zip_Code__c | Text (11) | The zip code for the delivery location. |
| Dispatcher | FreightTM__Dispatch__c | Lookup (User) | A reference to the dispatcher handling the freight. |
| Dispatcher-Worker | FreightTM__Dispatcher__c | Lookup (Worker) | A reference to the dispatcher worker. |
| Distance | FreightTM__Distance__c | Number (5, 2) | The distance of the freight delivery. |
| Driver | FreightTM__Driver__c | Lookup (Worker) | A reference to the driver handling the freight. |
| Driver Email | FreightTM__Driver_Email__c | Formula (Text) | The email address of the driver. |
| Driver Remarks | FreightTM__Driver_Remarks__c | Text Area (255) | Remarks from the driver. |
| Factoring | FreightTM__Factoring__c | Checkbox | Indicates if factoring is applied to the freight. |
| Factoring Rate (%) | FreightTM__Factoring_Rate__c | Number (2, 2) | The factoring rate percentage. |
| Gross Margin | FreightTM__Gross_Margin__c | Formula (Currency) | The gross margin for the freight. |
| Gross Margin (%) | FreightTM__Gross_Margin_Percent__c | Formula (Percent) | The gross margin percentage. |
| Hazmat | FreightTM__Hazmat__c | Checkbox | Indicates if the freight contains hazardous materials. |
| Height | FreightTM__Height__c | Number (3, 2) | The height of the freight. |
| Invoice Date | FreightTM__Invoiced_On__c | Date | The date when the invoice was issued. |
| Invoice Status | FreightTM__Invoice_Status__c | Picklist | The status of the invoice. |
| Lane Quote | FreightTM__Lane_Quote__c | Lookup (Lane Quote) | A reference to the lane quote for the freight. |
| Length | FreightTM__Length__c | Number (3, 2) | The length of the freight. |
| Load Canceled | FreightTM__Load_Canceled__c | Checkbox | Indicates if the load has been canceled. |
| Load ID | Name | Auto Number | A unique identifier for the load. |
| Number of Pallets | FreightTM__Number_of_Pallets__c | Number (14, 0) | The number of pallets in the load. |
| Origin –> Destination | FreightTM__Calendar_Load__c | Formula (Text) | The origin and destination of the freight. |
| Owner | OwnerId | Lookup (User, Group) | A reference to the owner of the freight record. |
| Pay Date | FreightTM__Pay_Date__c | Date | The date when payment for the freight is due. |
| Pay Status | FreightTM__Pay_Status__c | Picklist | The status of payment for the freight. |
| Pickup Arrival | FreightTM__Pickup_Arrival__c | Date/Time | The date and time when the pickup arrives. |
| Pickup By Appointment | FreightTM__Pickup_By_Appointment__c | Picklist | The status of the pickup, whether it is by appointment. |
| Pickup City | FreightTM__Pickup_City__c | Text (100) | The city where the pickup will occur. |
| Pickup Contact | FreightTM__Pickup_Contact__c | Text (100) | The contact person for the pickup. |
| Pickup Country | FreightTM__Pickup_Country__c | Picklist | The country where the pickup will occur. |
| Pickup Date | FreightTM__Pickup_Date__c | Date | The scheduled pickup date. |
| Pickup Departure | FreightTM__Pickup_Departure__c | Date/Time | The departure date and time for the pickup. |
| Pickup Email | FreightTM__Pickup_Email__c | The email address for pickup communication. | |
| Pickup Facility | FreightTM__PickupFacility__c | Lookup (Facility) | A reference from the facility to the pickup facility. |
| Pickup Facility | FreightTM__Pickup_Facility__c | Lookup(Account) | A reference from the account to the pickup facility. |
| Pickup Phone | FreightTM__Pickup_Phone__c | Phone | The phone number for pickup communication. |
| Pickup Ref. # | FreightTM__Pickup_Ref__c | Text (100) | The reference number for the pickup. |
| Pickup Remarks | FreightTM__Pickup_Remarks__c | Text Area (255) | Remarks regarding the pickup. |
| Pickup State/Province | FreightTM__Pickup_State__c | Picklist | The state or province where the pickup will occur. |
| Pickup Street | FreightTM__Pickup_Address__c | Text (100) | The street address for the pickup. |
| Pickup Working Hours | FreightTM__Pickup_In_and_Out_Times__c | Text Area (255) | The working hours for the pickup facility. |
| Pickup Zip Code | FreightTM__Pickup_Zip_Code__c | Text (11) | The zip code for the pickup location. |
| Price per Weight Unit | FreightTM__Price_per_Weight_Unit__c | Formula (Number) | The price per weight unit for the freight. |
| Priority | FreightTM__Priority__c | Picklist | The priority level of the freight. |
| PRO # | FreightTM__PRO__c | Text (100) | The PRO number for the freight. |
| Quote | FreightTM__Quote__c | Checkbox | Indicates if a quote has been generated for the freight. |
| Rate | FreightTM__Rate__c | Currency (6, 2) | The rate for the freight. |
| Rate per Mile | FreightTM__Rate_per_Mile__c | Formula (Currency) | The rate per mile for the freight. |
| Rate to Carrier | FreightTM__Rate_to_Carrier__c | Currency (6, 2) | The rate paid to the carrier. |
| Record Type | RecordTypeId | RecordTypeId | A reference to the record type for the freight. |
| Remaining Space | FreightTM__Remaining_Space__c | Formula (Number) | The remaining space in the freight. |
| Remarks | FreightTM__Remarks__c | Long Text Area (32768) | Remarks for the freight. |
| Required Trailer | FreightTM__Required_Trailer__c | Picklist (Multi-Select) | The type of trailer required for the freight. |
| Requirements | FreightTM__Requirements__c | Picklist (Multi-Select) | The specific requirements for the freight. |
| Second Driver | FreightTM__Second_Driver__c | Lookup (Worker) | A reference to the second driver assigned to the freight. |
| Size | FreightTM__Size__c | Picklist | The size of the freight. |
| Status | FreightTM__Status__c | Picklist | The status of the freight. |
| Tariff | FreightTM__Tariff__c | Lookup (Tariff) | A reference to the tariff associated with the freight. |
| Tariff Info | FreightTM__Tariff_Info__c | Formula (Text) | Information about the tariff. |
| Temperature | FreightTM__Temperature__c | Number (3, 2) | The temperature of the freight. |
| Total | FreightTM__Total__c | Formula (Currency) | The total cost for the freight. |
| Total After Factoring | FreightTM__Total_After_Factoring__c | Formula (Currency) | The total cost after factoring. |
| Total Cargo Volume | FreightTM__Total_Cargo_Volume__c | Roll-Up Summary (SUM Cargo Item) | The total cargo volume, calculated from related cargo items. |
| Total Distance | FreightTM__Total_Miles__c | Formula (Number) | The total distance for the freight. |
| Total Line Items | FreightTM__Total_Line_Items__c | Roll-Up Summary (SUM Line Item) | The total number of line items for the freight. |
| Total Pay Items | FreightTM__Total_Pay_Items__c | Roll-Up Summary (SUM Pay Item) | The total number of pay items for the freight. |
| Total Rate to Carrier | FreightTM__Total_Rate_to_Carrier__c | Formula (Currency) | The total rate paid to the carrier. |
| Trailer | FreightTM__Trailer1__c | Lookup (Equipment) | A reference to the trailer used for the freight. |
| Trailer Type | FreightTM__Trailer__c | Picklist | The type of trailer used for the freight. |
| Trip | FreightTM__Trip__c | Lookup (Trip) | A reference to the trip associated with the freight. |
| Truck | FreightTM__Truck__c | Lookup (Equipment) | A reference to the truck used for the freight. |
| Weight | FreightTM__Weight__c | Number (6, 0) | The weight of the freight. |
| Width | FreightTM__Width__c | Number (3, 2) | The width of the freight. |
🔗 Relationships
| Field Label | Related Object | Description |
| 2nd Alt. Tariff | Tariff | Lookup relationship to the second alternative tariff |
| Alt. Tariff | Tariff | Lookup relationship to the alternative tariff |
| Carrier | Carrier | Lookup relationship to the Carrier object |
| Carrier (Account) | Account | Lookup relationship to the Carrier’s Account |
| Contact Person | Contact | Lookup relationship to the Contact person for the freight |
| Customer | Account | Lookup relationship to the Customer’s Account |
| Delivery Facility | Facility | Lookup relationship to the Delivery Facility object |
| Delivery Facility | Account | Lookup relationship to the Delivery Facility as an Account |
| Dispatcher | User | Lookup relationship to the User acting as Dispatcher |
| Dispatcher-Worker | Worker | Lookup relationship to the Worker acting as Dispatcher |
| Driver | Worker | Lookup relationship to the Worker acting as Driver |
| Lane Quote | Lane Quote | Lookup relationship to the Lane Quote object |
| Pickup Facility | Facility | Lookup relationship to the Pickup Facility object |
| Pickup Facility | Account | Lookup relationship to the Pickup Facility as an Account |
| Second Driver | Worker | Lookup relationship to the Worker acting as Second Driver |
| Tariff | Tariff | Lookup relationship to the Tariff object |
| Trailer | Equipment | Lookup relationship to the Trailer equipment |
| Trip | Trip | Lookup relationship to the Trip object |
| Truck | Equipment | Lookup relationship to the Truck equipment |
| Owner | User / Group | Standard lookup to the Owner of the record |
Location
API Name: FreightTM__Site_Location__c
Relevant to: Carriers, Brokers
Purpose: The Location object stores geographical and logistical details of various places involved in the freight process, such as pickup and delivery points. It helps associate loads and companies with physical addresses, enabling accurate routing and planning.
| Field Label | API Name | Data Type | Description |
| Location ID | Name | Auto Number | Unique identifier for the location |
| Location Name | FreightTM__Location_Name__c | Text (80) | Descriptive name for the location |
| City | FreightTM__City__c | Text (40) | City where the location is situated |
| Street | FreightTM__Address__c | Text (100) | Street address of the location |
| State/Province | FreightTM__State_Province__c | Picklist | State or province (dependent on Country) |
| Zip Code | FreightTM__Zip_Code__c | Text (10) | Postal or ZIP code |
| Country | FreightTM__Country__c | Picklist | Country where the location is located |
| Coordinates | FreightTM__Coordinates__c | Geolocation | Geographical coordinates (latitude & longitude) |
| Remarks | FreightTM__Remarks__c | Text Area (255) | Additional notes or remarks about the location |
| Company | FreightTM__Company__c | Lookup (Account) | A reference from the account to the company |
| Load | FreightTM__Load__c | Lookup (Load) | A reference from the load |
| Owner | OwnerId | Lookup (User, Group) | Owner of the record |
🔗 Relationships
| Field Label | Related Object | Description |
| Company | Account | Lookup relationship to the company associated with the location |
| Load | Load | Lookup relationship to the load linked to the location |
| Owner | User / Group | Ownership of the record |
Modal
API Name: FreightTM__Modal__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents different transportation modes associated with specific loads and carriers.
| Field Label | API Name | Type | Description |
| Carrier | FreightTM__Carrier__c | Lookup (Carrier) | Links the modal record to the carrier responsible for the transportation. |
| Load | FreightTM__Load__c | Master-Detail (Load) | Associates the modal record with a specific load being transported. |
| Modal Name | Name | Auto Number | A unique identifier for the modal record. |
| Transportation Mode | FreightTM__Transportation_Mode__c | Picklist | Specifies the mode of transportation (e.g., “Truck”, “Rail”, “Air”). |
🔗 Relationships
| Field | Related Object | Notes |
| Carrier | Carrier | Lookup to the carrier responsible for the transportation. |
| Load | Load | Master-Detail to the load associated with the modal record. |
Operating Lane
API Name: FreightTM__Operating_Lane__c
Relevant to: Carriers, Brokers
Purpose: Represents the operational routes or corridors used for transportation.
| Field Label | API Name | Type | Description |
| Description | FreightTM__Description__c | Text Area (255) | Provides a brief description of the operating lane. |
| Operating Lane ID | Name | Auto Number | A unique identifier for each operating lane record. |
| Owner | OwnerId | Lookup (User, Group) | Identifies the user or group responsible for managing the operating lane. |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User or Group | Lookup to the user or group responsible for managing the operating lane. |
Package
API Name: FreightTM__Package__c
Relevant to: Carriers, Shippers
Purpose: Represents the details of a package, including its dimensions, weight, and related entities.
| Field Label | API Name | Type | Description |
| Description | FreightTM__Description__c | Text Area (255) | Provides a brief description of the package. |
| Height | FreightTM__Height__c | Number (3, 2) | Specifies the height of the package in the given unit of measurement. |
| Length | FreightTM__Length__c | Number (3, 2) | Indicates the length of the package in the given unit of measurement. |
| Owner | OwnerId | Lookup (User, Group) | Identifies the user or group responsible for the package record. |
| Package Name | Name | Auto Number | A unique identifier for each package record. |
| Parcel | FreightTM__Parcel__c | Lookup (Parcel) | Links the package to a related parcel. |
| Product | FreightTM__Product__c | Lookup (Product) | Links the package to a related product. |
| Weight | FreightTM__Weight__c | Number (4, 2) | Specifies the weight of the package in the given unit of measurement. |
| Width | FreightTM__Width__c | Number (3, 2) | Indicates the width of the package in the given unit of measurement. |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User or Group | Lookup to the user or group responsible for the package record. |
| Parcel | Parcel | Lookup to a related parcel. |
| Product | Product | Lookup to a related product. |
Parcel
API Name: FreightTM__Parcel__c
Relevant to: Carriers, Shippers
Purpose: Represents individual parcels with their dimensions, associated products, and other related details.
| Field Label | API Name | Type | Description |
| Description | FreightTM__Description__c | Text Area (255) | Provides a brief description of the parcel. |
| Height | FreightTM__Height__c | Number (3, 2) | Specifies the height of the parcel in the given unit of measurement. |
| Length | FreightTM__Length__c | Number (3, 2) | Indicates the length of the parcel in the given unit of measurement. |
| Load | FreightTM__Load__c | Lookup (Load) | Links the parcel to a specific load. |
| Owner | OwnerId | Lookup (User, Group) | Identifies the user or group responsible for the parcel record. |
| Parcel Name | Name | Auto Number | A unique identifier for each parcel record. |
| Product | FreightTM__Product__c | Lookup (Product) | Links the parcel to an associated product. |
| Weight | FreightTM__Weight__c | Number (6, 2) | Specifies the weight of the parcel in the given unit of measurement. |
| Width | FreightTM__Width__c | Number (3, 2) | Indicates the width of the parcel in the given unit of measurement. |
🔗 Relationships
| Field | Related Object | Notes |
| Created By | User | Lookup to the user who created the parcel record. |
| Last Modified By | User | Lookup to the user who last modified the parcel record. |
| Load | Load | Lookup to a specific load associated with the parcel. |
| Owner | User or Group | Lookup to the user or group responsible for the parcel record. |
| Product | Product | Lookup to a related product. |
Part
API Name: FreightTM__Part__c
Relevant to: Carriers, Shippers
Purpose: Represents individual parts with their unique identifiers and descriptions.
| Field Label | API Name | Type | Description |
| Created By | FreightTM__Description__c | Lookup (User) | References the user who created the part record. |
| Description | FreightTM__Description__c | Text Area(255) | Provides a brief description of the part. |
| Owner | OwnerId | Lookup (User, Group) | Identifies the user or group responsible for the part record. |
| Part ID | Name | Auto Number | A unique identifier automatically generated for each part record. |
🔗 Relationships
| Field | Related Object | Notes |
| Created By | User | Lookup to the user who created the part record. |
| Owner | User or Group | Lookup to the user or group responsible for the part record. |
Pay Item
API Name: FreightTM__Pay_Item__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents payment-related items with specific financial details and statuses.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Formula (Currency) | Automatically calculates the total amount based on the number of units and unit price. |
| Description | FreightTM__Description__c | Text Area (255) | Provides a brief description of the pay item. |
| Load | FreightTM__Load__c | Master-Detail(Load) | Associates the Pay Item record with a specific load being transported. |
| Number of Units | FreightTM__Number_of_Units__c | Number (8, 2) | Indicates the quantity of units for the pay item. |
| Pay Item ID | Name | Auto Number | A unique identifier automatically generated for each pay item record. |
| Status | FreightTM__Status__c | Picklist | Represents the current status of the pay item (e.g., “Pending,” “Approved,” “Rejected”). |
| Type | FreightTM__Type__c | Picklist | Specifies the category or type of pay item (e.g., “Freight Charge,” “Accessory Fee”). |
| Unit Price | FreightTM__Unit_Price__c | Currency (6, 2) | Displays the price per unit for the pay item. |
🔗 Relationships
| Field | Related Object | Notes |
| Load | Load | Master-Detail relationship linking the pay item to a specific load. |
Pay Transaction
API Name: FreightTM__Pay_Transaction__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents a financial transaction related to a specific load.
| Field Label | API Name | Type | Description |
| Load | FreightTM__Load__c | Master-Detail(Load) | Associates the Pay Transaction record with a specific load being transported. |
| Pay Transaction ID | Name | Auto Number | A unique identifier automatically generated for each pay transaction record. |
🔗 Relationships
| Field | Related Object | Notes |
| Load | Load | Master-Detail relationship linking the pay transaction to a specific load. |
Performance
API Name: FreightTM__Performance__c
Relevant to: Carriers
Purpose: Represents a performance record associated with a specific worker.
| Field Label | API Name | Type | Description |
| Performance Name | Name | Auto Number | A unique identifier automatically generated for each performance record. |
| Worker | FreightTM__Worker__c | Master-Detail (Worker) | Links the performance record to a specific worker. |
🔗 Relationships
| Field | Related Object | Notes |
| Worker | Worker | Master-Detail relationship linking the performance record to a specific worker. |
Project
API Name: FreightTM__Project__c
Relevant to: Carriers, Brokers
Purpose: Represents a project with a defined start and end date.
| Field Label | API Name | Type | Description |
| End | FreightTM__End__c | Date | The end date of the project. |
| Owner | OwnerId | Lookup (User, Group) | Represents the owner of the project, which could be a user or a group. |
| Project ID | Name | Auto Number | A unique identifier automatically generated for each project. |
| Start | FreightTM__Start__c | Date | The start date of the project. |
🔗 Relationships
| Field | Related Object | Notes |
| Owner | User or Group | Lookup to the user or group who owns the project. |
Purchase Item
API Name: FreightTM__Purchase_Item__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents an item within a purchase with associated amount, quantity, and unit price.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Formula (Currency) | The total amount calculated for the purchase item. |
| Description | FreightTM__Description__c | Text Area (255) | A description of the purchase item. |
| Purchase | FreightTM__Purchase__c | Master-Detail (Expense) | References the associated purchase record. |
| Purchase Item Name | Name | Auto Number | A unique identifier automatically generated for each purchase item. |
| Quantity | FreightTM__Quantity__c | Number (8, 2) | The quantity of the purchase item. |
| Unit Price | FreightTM__Unit_Price__c | Currency (8, 2) | The price per unit of the purchase item. |
🔗 Relationships
| Field | Related Object | Notes |
| Purchase | Expense | Master-Detail relationship to the associated purchase record. |
Quote Cargo
API Name: FreightTM__Quote_Cargo__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents a cargo associated with a quote, containing details about the lane quote and associated metadata.
| Field Label | API Name | Type | Description |
| Lane Quote | FreightTM__Lane_Quote__c | Master-Detail (Lane Quote) | References the associated lane quote for the cargo. |
| Quote Cargo ID | Name | Auto Number | A unique identifier automatically generated for each quote cargo. |
🔗 Relationships
| Field | Related Object | Notes |
| Lane Quote | Lane Quote | Master-Detail relationship to the associated lane quote. |
Quote Leg
API Name: FreightTM__Quote_Leg__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents the details of a specific leg of a quote, including pickup and delivery information, transportation mode, and payments associated with that leg.
| Field Label | API Name | Type | Description |
| Carrier | FreightTM__Carrier__c | Lookup (Carrier) | References the carrier for the quote leg. |
| Delivery City | FreightTM__Delivery_City__c | Text (40) | The city where the cargo will be delivered. |
| Delivery Country | FreightTM__Delivery_Country__c | Picklist | The country where the cargo will be delivered. |
| Delivery Facility | FreightTM__Delivery_Facility__c | Lookup (Facility) | References the delivery facility. |
| Delivery State | FreightTM__Delivery_State__c | Picklist | The state where the cargo will be delivered. |
| Delivery Street | FreightTM__Delivery_Street__c | Text (100) | The street address for the delivery. |
| Delivery ZIP Code | FreightTM__Delivery_ZIP_Code__c | Text (10) | The ZIP code for the delivery address. |
| Lane Quote | FreightTM__Lane_Quote__c | Master-Detail (Lane Quote) | References the associated lane quote for the leg. |
| Mode of Transportation | FreightTM__Mode_of_Transportation__c | Picklist | The mode of transportation used for this leg of the quote. |
| Pickup City | FreightTM__Pickup_City__c | Text (40) | The city where the cargo will be picked up. |
| Pickup Country | FreightTM__Pickup_Country__c | Picklist | The country where the cargo will be picked up. |
| Pickup Facility | FreightTM__Pickup_Facility__c | Lookup (Facility) | References the pickup facility. |
| Pickup State | FreightTM__Pickup_State__c | Picklist | The state where the cargo will be picked up. |
| Pickup Street | FreightTM__Pickup_Street__c | Text (100) | The street address for the pickup. |
| Pickup ZIP Code | FreightTM__Pickup_ZIP_Code__c | Text (10) | The ZIP code for the pickup address. |
| Quote Leg ID | Name | Auto Number | A unique identifier automatically generated for each quote leg. |
| Total Leg Payments | FreightTM__Total_Leg_Payments__c | Roll-Up Summary | The total payments associated with the quote leg, summarized from related Quote Leg Payments. |
🔗 Relationships
| Field | Related Object | Notes |
| Carrier | Carrier | Lookup to the carrier associated with the quote leg. |
| Delivery Facility | Facility | Lookup to the facility where the cargo will be delivered. |
| Lane Quote | Lane Quote | Master-Detail relationship to the associated lane quote for the leg. |
| Pickup Facility | Facility | Lookup to the facility where the cargo will be picked up. |
Quote Leg Cargo
API Name: FreightTM__Quote_Leg_Cargo__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents the commodity associated with a specific quote leg cargo, including its description and other related details.
| Field Label | API Name | Type | Description |
| Commodity | FreightTM__Commodity__c | Text (100) | The type of commodity being transported in the quote leg cargo. |
| Description | FreightTM__Description__c | Text Area (255) | A description of the commodity in the quote leg cargo. |
| Quote Leg | FreightTM__Quote_Leg__c | Master-Detail (Quote Leg) | References the associated quote leg for this cargo commodity. |
| Quote Leg Cargo ID | Name | Auto Number | A unique identifier automatically generated for each quote leg cargo commodity. |
🔗 Relationships
| Field | Related Object | Notes |
| Quote Leg | Quote Leg | Master-Detail relationship to the associated quote leg for the commodity. |
Quote Leg Payment
API Name: FreightTM__Quote_Leg_Payment__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents the payment details associated with a specific quote leg, including the amount, quantity, and unit price for the cargo or transportation.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Formula (Currency) | The total amount for the quote leg payment, calculated based on related values. |
| Quantity | FreightTM__Quantity__c | Number (8, 2) | The quantity of items involved in the quote leg payment. |
| Quote Leg | FreightTM__Quote_Leg__c | Master-Detail (Quote Leg) | References the associated quote leg for this payment. |
| Quote Leg Payment ID | Name | Auto Number | A unique identifier automatically generated for each quote leg payment. |
| Type | FreightTM__Type__c | Picklist | The type of payment (e.g., full payment, partial payment, etc.). |
| Unit Price | FreightTM__Unit_Price__c | Currency (6, 2) | The unit price of the items involved in the payment. |
🔗 Relationships
| Field | Related Object | Notes |
| Quote Leg | Quote Leg | Master-Detail relationship to the associated quote leg for the payment. |
Quote Leg Stop
API Name: FreightTM__Quote_Leg_Stop__c
Relevant to: Carriers, Brokers
Purpose: Tracks and manages the details of a specific quote leg stop, including the related facility, the associated quote leg, and user-related information for easier monitoring and reporting.
| Field Label | API Name | Type | Description |
| Facility | FreightTM__Facility__c | Lookup(Facility) | Links to the related facility for the record. |
| Quote Leg | FreightTM__Quote_Leg__c | Master-Detail (Quote Leg) | References the associated quote leg for this record. |
| Quote Leg Stop ID | Name | Auto Number | A unique identifier automatically generated for each quote leg stop. |
🔗 Relationships
| Field | Related Object | Notes |
| Facility | Facility | Lookup relationship to the associated facility. |
| Quote Leg | Quote Leg | Master-Detail relationship to the associated quote leg. |
Quote Line
API Name: FreightTM__Quote_Line__c
Relevant to: Carriers, Brokers
Purpose: Tracks and manages the details of each line item in a quote, including the related lane quote and user information for easier monitoring and reporting.
| Field Label | API Name | Type | Description |
| Lane Quote | FreightTM__Lane_Quote__c | Master-Detail(Lane Quote) | Links the quote line to the related lane quote for better tracking. |
| Quote Line ID | Name | Auto Number | A unique identifier automatically generated for each quote line. |
🔗 Relationships
| Field | Related Object | Notes |
| Lane Quote | Lane Quote | Master-Detail relationship to the associated lane quote. |
Quote Pay
API Name: FreightTM__Quote_Pay__c
Relevant to: Carriers, Brokers
Purpose: Tracks and manages the payment details for a specific quote, including the amount, number of units, description, and associated lane quote, allowing for more accurate financial tracking.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Formula (Currency) | The total amount for the quote pay, calculated based on related values. |
| Description | FreightTM__Description__c | Text Area(255) | A brief description of the payment. |
| Lane Quote | FreightTM__Lane_Quote__c | Master-Detail(Lane Quote) | Links the quote pay to the related lane quote. |
| Number of Units | FreightTM__Number_of_Units__c | Number(8, 2) | The number of units involved in the payment. |
| Quote Pay ID | Name | Auto Number | A unique identifier automatically generated for each quote pay. |
| Type | FreightTM__Type__c | Picklist | The type of payment (e.g., full payment, partial payment, etc.). |
| Unit Price | FreightTM__Unit_Price__c | Currency(6, 2) | The unit price of the items involved in the payment. |
🔗 Relationships
| Field Label | Related Object | Notes |
| Lane Quote | Lane Quote | Master-Detail relationship to the associated lane quote. |
Quote Stop
API Name: FreightTM__Quote_Stop__c
Relevant to: Carriers, Brokers
Purpose: Tracks and manages the details of a specific stop in a quote, including location information (city, country, state/province), and links to the related lane quote and facility for easier monitoring and management.
| Field Label | API Name | Type | Description |
| City | FreightTM__City__c | Text(40) | The city where the quote stop is located. |
| Country | FreightTM__Country__c | Picklist | The country associated with the quote stop location. |
| Facility | FreightTM__Facility__c | Lookup(Facility) | Links the quote stop to the related facility. |
| Lane Quote | FreightTM__Lane_Quote__c | Master-Detail(Lane Quote) | Links the quote stop to the associated lane quote. |
| Quote Stop Name | Name | Auto Number | A unique identifier automatically generated for each quote stop. |
| State/Province | FreightTM__State__c | Picklist | The state or province associated with the quote stop location. |
| Street | FreightTM__Street__c | Text(100) | The street address where the quote stop is located. |
| Zip Code | FreightTM__Zip_Code__c | Text(10) | The postal code for the quote stop location. |
🔗 Relationships
| Field | Related Object | Notes |
| Facility | Facility | Lookup relationship to the associated facility. |
| Lane Quote | Lane Quote | Master-Detail relationship to the associated lane quote. |
Service
API Name: FreightTM__Service__c
Relevant to: Carriers
Purpose: This object captures details about repair or maintenance services performed on equipment, including costs, timing, and related parties.
| Field Label | API Name | Type | Description |
| Amount | FreightTM__Amount__c | Currency(7, 2) | Total cost of the service |
| Category | FreightTM__Category__c | Picklist | Category of the service |
| Coupled with | FreightTM__Coupled_with__c | Formula (Text) | Related service or record, auto-generated |
| Description | FreightTM__Description__c | Text Area(255) | Description of the service performed |
| Driver | FreightTM__Driver__c | Formula (Text) | Name of the driver involved |
| Driver’s Phone | FreightTM__Driver_s_Phone__c | Formula (Text) | Phone number of the driver |
| End | FreightTM__End__c | Date/Time | End datetime of the service |
| End Date | FreightTM__End_Date__c | Date | End date of the service |
| Equipment | FreightTM__Equipment__c | Master-Detail(Equipment) | Equipment the service is performed on |
| Estimate | FreightTM__Estimate__c | Currency(6, 2) | Estimated cost before the service |
| Location | FreightTM__Location__c | Text(120) | Physical location of the service |
| Repair Shop | FreightTM__Repair_Shop__c | Lookup(Account) | Account of the shop where the service is done |
| Scheduled | FreightTM__Scheduled__c | Checkbox | Whether the service is scheduled |
| Service | Name | Auto Number | Unique identifier for the service |
| Source | FreightTM__Source__c | Picklist | Origin or source of the service request |
| Start | FreightTM__Start__c | Date/Time | Start datetime of the service |
| Start Date | FreightTM__Start_Date__c | Date | Start date of the service |
| Status | FreightTM__Status__c | Picklist | Current status of the service |
| Type | FreightTM__Type__c | Picklist | Type of service performed |
🔗 Relationships
| Field | Related Object | Notes |
| Equipment | Equipment | Master-detail relationship to the equipment receiving service |
| Repair Shop | Account | Lookup relationship to the repair shop handling the service |
Service Line
API Name: FreightTM__Service_Line__c
Relevant to: Carriers
Purpose: Represents individual service components, such as parts and labor, that are part of a larger maintenance or repair service.
| Field Label | API Name | Type | Description |
| Description | FreightTM__Description__c | Text Area(255) | Description of the service line item |
| Part | FreightTM__Part__c | Lookup(Part) | Reference to the part used in the service |
| Quantity | FreightTM__Quantity__c | Number(8, 2) | Quantity of the part or item used |
| Rate | FreightTM__Rate__c | Currency(8, 2) | Rate or price per unit of the service line |
| Service | FreightTM__Service__c | Master-Detail(Service) | The parent service record this line belongs to |
| Service Line ID | Name | Auto Number | Unique identifier for the service line |
🔗 Relationships
| Field Name | Related Object | Notes |
| Part | Part | Lookup to the part or component used in the service line |
| Service | Service | Master-detail relationship to the parent Service object |
Stop
API Name: FreightTM__Stop__c
Relevant to: Carriers
Purpose: Represents a pickup or delivery point associated with a Load, including time windows, location details, and contact information.
| Field Label | API Name | Type | Description |
| Arrival | FreightTM__Arrival__c | Date/Time | Scheduled or actual arrival time at the stop |
| By Appointment | FreightTM__By_Appointment__c | Picklist | Indicates if appointment is required |
| City | FreightTM__City__c | Text(40) | City of the stop location |
| Contact | FreightTM__Contact__c | Text(30) | Contact person at the stop |
| Country | FreightTM__Country__c | Picklist | Country of the stop location |
| Departure | FreightTM__Departure__c | Date/Time | Scheduled or actual departure time |
| FreightTM__Email__c | Email address of the stop contact | ||
| Facility | FreightTM__SFacility__c | Lookup(Facility) | Reference to internal facility (if applicable) |
| Facility | FreightTM__Facility__c | Lookup(Account) | Reference to external facility (as an Account) |
| Load | FreightTM__Load__c | Master-Detail(Load) | The load this stop is associated with |
| Phone | FreightTM__Phone__c | Phone | Phone number of the stop contact |
| Reference # | FreightTM__Reference__c | Text(40) | External reference number related to this stop |
| Remarks | FreightTM__Remarks__c | Text Area(255) | Additional notes or comments about the stop |
| State/Province | FreightTM__State__c | Picklist | State or province of the stop |
| Status | FreightTM__Status__c | Picklist | Current status of the stop |
| Stop ID | Name | Auto Number | Unique identifier for the stop |
| Street | FreightTM__Address__c | Text(100) | Street address of the stop |
| Type | FreightTM__Type__c | Picklist | Type of stop (e.g., Pickup, Delivery) |
| Zip Code | FreightTM__Zip_Code__c | Text(10) | ZIP or postal code |
🔗 Relationships
| Field Name | Related Object | Notes |
| Load | Load | Master-detail relationship linking this stop to a load |
| Facility | Facility | Lookup to internal facility |
| Facility (Account) | Account | Lookup to external facility as Account |
Storage
API Name: FreightTM__Storage__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents storage information related to a Load, used for tracking storage events or status when freight is held temporarily.
| Field Label | API Name | Type | Description |
| Load | FreightTM__Load__c | Master-Detail(Load) | The load associated with this storage event |
| Storage ID | Name | Auto Number | Unique identifier for the storage record |
🔗 Relationships
| Field Name | Related Object | Notes |
| Load | Load | Master-detail relationship linking this storage to a load |
Storage Billing
API Name: FreightTM__Storage_Billing__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents billing details associated with a specific storage event, used for invoicing or cost tracking of storage services.
| Field Label | API Name | Type | Description |
| Storage | FreightTM__Storage__c | Master-Detail(Storage) | The related storage record being billed |
| Storage Billing ID | Name | Auto Number | Unique identifier for the storage billing entry |
🔗 Relationships
| Field Name | Related Object | Notes |
| Storage | Storage | Master-detail relationship linking this billing to a storage |
Tariff
API Name: FreightTM__Tariff__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Defines pricing and rate rules associated with a carrier for a specific origin-destination pair, used in freight billing or quotation processes.
| Field Label | API Name | Type | Description |
| Carrier | FreightTM__Carrier__c | Lookup(Carrier) | Associated carrier offering the tariff |
| Description | FreightTM__Description__c | Text Area(255) | Additional details or notes about the tariff |
| Destination | FreightTM__Destination__c | Text(40) | Destination city or location |
| Origin | FreightTM__Origin__c | Text(40) | Origin city or location |
| Owner | OwnerId | Lookup(User,Group) | Owner of the tariff record |
| Rate | FreightTM__Rate__c | Currency(12, 2) | Price or cost defined for the route |
| Tariff ID | Name | Auto Number | Unique identifier for the tariff record |
| Type | FreightTM__Type__c | Picklist | Classification or type of tariff (e.g., Standard, Express) |
🔗 Relationships
| Field Name | Related Object | Notes |
| Carrier | Carrier | Lookup to the carrier offering this tariff |
| Owner | User / Group | Owner responsible for the tariff entry |
Trip
API Name: FreightTM__Trip__c
Relevant to: Carriers, Brokers, Shippers
Purpose: Represents a planned transportation journey or sequence of movements often assigned to a driver or vehicle, potentially grouping multiple loads or legs.
| Field Label | API Name | Type | Description |
| Description | FreightTM__Description__c | Text Area(255) | Notes or extra information describing the trip |
| Owner | OwnerId | Lookup(User,Group) | Owner of the trip record |
| Trip Name | Name | Auto Number | Auto-generated identifier for the trip |
🔗 Relationships
| Field Name | Related Object | Notes |
| Owner | User / Group | The record’s assigned owner |
Trip Item
API Name: FreightTM__Trip_Item__c
Relevant to: Carriers
Purpose: Represents an individual component or leg within a trip, often linking specific actions or entities (like loads or locations) to the overall journey defined in the Trip object.
| Field Label | API Name | Type | Description |
| Trip | FreightTM__Trip__c | Master-Detail(Trip) | Reference to the parent Trip object |
| Trip Item ID | Name | Auto Number | Auto-generated identifier for the trip item |
🔗 Relationships
| Field Name | Related Object | Notes |
| Trip | Trip | The parent trip this item belongs to |
Violation
API Name: FreightTM__Violation__c
Relevant to: Carriers
Purpose: Records and tracks any violations associated with a driver or vehicle, including time, description, and financial penalties applied.
| Field Label | API Name | Type | Description |
| Date and Time | FreightTM__Date_and_Time__c | Date/Time | Date and time the violation occurred |
| Description | FreightTM__Description__c | Text Area(255) | Description of the violation |
| Driver | FreightTM__Driver__c | Lookup(Worker) | The driver responsible for or involved in the violation |
| Owner | OwnerId | Lookup(User,Group) | Record owner (can be a user or group) |
| Penalty Amount | FreightTM__Penalty_Amount__c | Currency(6, 2) | Amount charged as penalty for the violation |
| Vehicle | FreightTM__Vehicle__c | Lookup(Equipment) | Vehicle involved in the violation |
| Violation ID | Name | Auto Number | Auto-generated identifier for the violation record |
🔗 Relationships
| Field Name | Related Object | Notes |
| Owner | User / Group | Owner of the record |
| Driver | Worker | The driver involved in the violation |
| Vehicle | Equipment | The vehicle involved in the violation |
Warranty
API Name: FreightTM__Warranty__c
Relevant to: Carriers, Shippers
Purpose: Tracks warranty information related to each piece of equipment, enabling service validation and coverage tracking.
| Field Label | API Name | Type | Description |
| Equipment | FreightTM__Equipment__c | Master-Detail(Equipment) | The equipment item to which the warranty belongs |
| Warranty ID | Name | Auto Number | Auto-generated identifier for the warranty record |
🔗 Relationships
| Field Name | Related Object | Description |
| Equipment | Equipment | Equipment associated with this warranty |
Warranty Claim
API Name: FreightTM__Warranty_Claim__c
Relevant to: Carriers, Shippers
Purpose: Records individual claims made against a warranty, enabling tracking and resolution of warranty-covered issues.
| Field Label | API Name | Type | Description |
| Warranty | FreightTM__Warranty__c | Master-Detail(Warranty) | The warranty under which the claim is being filed |
| Warranty Claim ID | Name | Auto Number | Auto-generated identifier for the warranty claim record |
🔗 Relationships
| Field Name | Related Object | Description |
| Warranty | Warranty | The warranty related to this claim |
Worker (Driver)
API Name: FreightTM__Employee__c
Relevant to: Carriers
Purpose: Stores driver-specific information used for identification, compliance, pay, and contact purposes in transportation operations.
| Field Label | API Name | Type | Description |
| Active | FreightTM__Active__c | Checkbox | Indicates if the driver is currently active |
| Card Numbers | FreightTM__Card_Numbers__c | Text Area(255) | List of card numbers assigned to the driver |
| CDL Country | FreightTM__CDL_Country__c | Picklist | Country of Commercial Driver’s License |
| CDL Endorsements | FreightTM__CDL_Endorsements__c | Picklist (Multi-Select) | Endorsements associated with the driver’s CDL |
| CDL Expiration | FreightTM__CDL_Expiration__c | Date | CDL expiration date |
| CDL State | FreightTM__CDL_State__c | Picklist | State of CDL issuance |
| City | FreightTM__City__c | Text(40) | City of residence |
| Communication Channel | FreightTM__Communication_Channel__c | Picklist | Preferred communication channel |
| Country | FreightTM__Country__c | Picklist | Country of residence |
| Date of Birth | FreightTM__Date_of_Birth__c | Date | Driver’s date of birth |
| FreightTM__Email__c | Email address | ||
| Emergency Contact | FreightTM__Emergency_Contact__c | Text(30) | Emergency contact name |
| Emergency Contact Phone | FreightTM__Emergency_Contact_Phone__c | Phone | Phone number for emergency contact |
| Fax | FreightTM__Fax__c | Phone | Fax number |
| First Name | FreightTM__First_Name__c | Text(20) | Driver’s first name |
| Gross Pay (Hourly) | FreightTM__Gross_Pay_Hourly__c | Formula (Currency) | Calculated gross pay per hour |
| HoS Training | FreightTM__HoS_Training__c | Checkbox | Whether driver has completed Hours of Service training |
| Hourly Rate | FreightTM__Hourly_Rate__c | Currency(3, 2) | Hourly compensation rate |
| Last Name | Name | Text(80) | Driver’s last name (Primary field) |
| License Class | FreightTM__License_Class__c | Picklist | Class of driver’s license |
| License Number | FreightTM__License_Number__c | Text(20) | Driver’s license number |
| Medical Card Expiration | FreightTM__Medical_Card_Expiration__c | Date | Expiration of driver’s medical card |
| Number of Hours | FreightTM__Number_of_Hours__c | Number(4, 2) | Number of work hours recorded |
| Orientation Date | FreightTM__Orientation_Date__c | Date | Date the driver completed orientation |
| Owner | OwnerId | Lookup(User,Group) | Record owner (user or group) |
| Per Mile | FreightTM__Per_Mile__c | Currency(2, 2) | Compensation per mile |
| Percentage Pay | FreightTM__Percentage_Pay__c | Percent(3, 2) | Pay percentage (e.g., revenue share) |
| Phone | FreightTM__Phone__c | Phone | Driver’s personal phone number |
| PIN | FreightTM__PIN__c | Text(20) | Personal Identification Number for driver |
| Recruiting Stage | FreightTM__Recruiting__c | Picklist | Current recruiting pipeline stage |
| Start Date | FreightTM__Start_Date__c | Date | Start date of employment |
| State/Province | FreightTM__State__c | Picklist | State of residence |
| Street | FreightTM__Address__c | Text(100) | Street address |
| Termination Date | FreightTM__Termination_Date__c | Date | Termination date if applicable |
| Type | FreightTM__Type__c | Picklist | Type of worker (e.g., full-time, part-time, contractor) |
| Work Phone | FreightTM__Work_Phone__c | Phone | Work phone number |
| Zip Code | FreightTM__Zip_Code__c | Text(10) | Zip code of residence |
🔗 Relationships
| Field Name | Related Object | Description |
| Owner | User, Group | Record owner (individual or group) |
Working Time
API Name: FreightTM__Working_Time__c
Relevant to: Carriers
Purpose: Stores time-tracking records for workers (drivers), capturing their shift start and end times.
| Field Label | API Name | Type | Description |
| End | FreightTM__End__c | Date/Time | End time of the work shift |
| Start | FreightTM__Start__c | Date/Time | Start time of the work shift |
| Worker | FreightTM__Worker__c | Master-Detail(Worker) | The worker (driver) this time record is linked to |
| Working Time ID | Name | Auto Number | Unique identifier for the working time record |
🔗 Relationships
| Field Name | Related Object | Description |
| Worker | Worker | Associated driver for the time entry |
Zone
API Name: FreightTM__Zone__c
Relevant to: Carriers
Purpose: Represents defined zones or regions used for operational, routing, or billing categorization in freight management.
| Field Label | API Name | Type | Description |
| Description | FreightTM__Description__c | Text Area(255) | Descriptive text about the zone |
| Owner | OwnerId | Lookup(User,Group) | Owner of the record (User or Group) |
| Zone ID | Name | Auto Number | Unique identifier for the zone |
🔗 Relationships
| Field Name | Related Object | Description |
| Owner | User / Group | Record owner |
