McLeod Transportation
DLH.io documentation for McLeod Transportation
McLeod Software is a transportation ERP system that enables truckload carriers, private fleets, logistics, brokerage, 3PL, and LT Carrier business units. LoadMaster LTL is a complete business solution for operations and accounting.
Setup Instructions
Follow the setup steps guide for configuring your McLeod Transportation connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
Replicated Entities
The following McLeod Transportation entities are available for replication to Snowflake. With DLH.io you select which ones you'd like replicated and you're always free to add additional ones at a later time. These are the table names you will see in Snowflake:
- ACCIDENTTYPE
- ACCIDENT_CONTROL
- ACCIDENT_COST
- ACCIDENT_NOTIFY
- ACTION_CODE
- AGENCY
- AP1099_DATA
- AP1099_DATA_HIST
- APPOINTMENT_CHANGE
- APPPROCESS
- APPT_SCHED
- AP_BEGIN_BAL
- AP_CHECK
- AP_COD
- AP_COD_DIST
- AP_CONTROL
- AP_CYCLE_CODE
- AP_DIVISION
- AP_OPEN_ITEM
- AP_TERM_CODE
- AP_VOUCHER_DETAIL
- AP_VOUCHER_MASTER
- ARCONTROL
- AR_CALL_RECORD
- AR_CYCLE_CODE
- AR_REASON_CODE
- AUTO_HOME_HISTORY
- AUTO_HOME_LOCATION
- BANK
- BANK_ACCOUNT
- BANK_ACCOUNT_PERM
- BANK_REC
- BANK_REC_HIST
- BANK_REC_TRX
- BANK_STATEMENT_TRX
- BANK_STATEMT_MATCH
- BANK_TRX_CODE
- BATCH_CONTROL
- BILLING
- BILLING_FREIGHT_GROUP
- BILLING_HISTORY
- BI_THEME
- BROKER_DIM
- BR_TRACKING_CTRL
- BUDGET
- BUDGET_CODE
- BUSINESS_CALENDAR
- CALLIN
- CALL_HISTORY
- CALL_LIST_PROFILE
- CALL_RECORD
- CALL_REC_OPEN_ITEM
- CATEGORY
- CHARGE_CODE
- CHARGE_CODE_EDI
- CITY
- CODE
- COMMENT_TYPE
- COMMITMENT_DETAIL
- COMMITMENT_HISTORY
- COMMODITY
- COMMODITY_DIM
- COMPANY
- CONTACT
- CONTINUITY
- COST_FACT
- COST_SUMMARY
- COUNTRY
- CURRENCY
- CUSTOMER
- CUSTOMER_AGENCY
- CUSTOMER_BILLING
- CUSTOMER_CROSS_REF
- CUSTOMER_DIM
- CUSTOMER_FUEL
- CUSTOMER_ORDER
- CUSTOMER_RELATIONSHIP
- CUST_REV_HISTORY
- CYCLE
- DAILY_GOALS
- DEPARTMENT
- DETENTION_DEF
- DETENTION_HIST
- DETENTION_HIST_CHG
- DETENTION_HIST_PAY
- DIVISION
- DRIVER
- DRIVER_APPLICATION
- DRIVER_BKP
- DRIVER_DIM
- DRIVER_EXTRA_PAY
- DRIVER_HOURS
- DRIVER_MILES
- DRS_DEDUCT_HIST
- DRS_PAYEE
- DRS_PAYROLL_HIST
- DRS_SETTLE_HIST
- DRUGTEST
- EDI_BILLING
- EDI_ORDER
- EDI_STANDARD_CODE
- EMPLOYEE
- EQUIPMENT_GROUP
- EQUIPMENT_ISSUED
- EQUIPMENT_ITEM
- EQUIPMENT_MATCH
- EQUIPMENT_POOL_POSITIONING
- EQUIPMENT_POOL_RULE
- EQUIPMENT_TYPE
- EQUIPSTATUS
- EQUIPSTATUSCODE
- FISCAL_YEAR
- FISCAL_YEAR_BUDGET
- FISCAL_YEAR_DTL
- FIVETRAN_AUDIT
- FIXED_TIME_CALL
- FLEET
- FLEETADVISOR
- FUEL_TAX_HISTORY
- GEO_DIM
- GEO_LOCATION
- GL_ACCOUNT
- GL_ACCOUNT_GLMAP
- GL_ACCOUNT_VMMAP
- GL_ASSIGNMENT
- GL_BATCH_TYPE
- GL_BEGIN_BAL
- GL_BUDGET
- GL_CATEGORY
- GL_CONTROL
- GL_CONTROL_MAPPING
- GL_CYCLE
- GL_DESCRIPTION
- GL_JOURNAL_DTL
- GL_JOURNAL_HDR
- GL_JOURNAL_TYPE
- GL_LEDGER
- GL_LEDGER_HIST
- GL_MAPPING
- GL_SEGMENT_CODE
- GL_SOURCE_TYPE
- GL_SUB_AUDIT
- GL_SUMMARY
- GL_TRANSACTION
- GL_TYPE
- GROUP_MEMBERSHIP
- JOB_CLASS
- JOB_CLASS_CODE
- JOURNAL_AP
- JOURNAL_CASH
- JOURNAL_OFFICE
- JOURNAL_SALES
- JOURNAL_SEARCH
- JOURNAL_VM
- KPI_CROSS_REFERENCE
- KPI_DATA_POINT
- KPI_DEFINITION
- KPI_FACTOR
- KPI_GROUP
- KPI_GROUP_DETAIL
- KPI_TEMPLATE
- LABEL
- LATE_ROUTE
- LATE_ROUTE_CONTROL
- LATE_ROUTE_STATUS
- LOAD_UNLOAD
- LOCATION
- MARKET_ACTIVITY
- MARKET_AREA
- MARKET_PLAN
- MC_POSITION
- MC_UNIT
- METRIC_AGGREGATE
- MISC_BILL
- MISC_BILL_DETAIL
- MISC_BILL_HIST
- MOTORACCIDENT
- MOVEMENT
- MOVEMENT_ORDER
- OFF_PAYEE
- OPEN_ITEM
- ORDERS
- ORDER_AUTHORIZATION
- ORDER_TYPE
- ORIG_DEST_RATE
- OSD_DTL
- OSD_HDR
- OTHER_CHARGE
- OTHER_CHARGE_BILL
- OTHER_CHARGE_EDI
- OTHER_CHARGE_HIST
- OTHER_CHARGE_RATE
- OTHER_CHARGE_REC
- PAYEE
- PRODUCT
- PROPERTY_DAMAGE
- PRORATED_MOVE
- PRORATED_MOVEORDER
- PRORATED_ORDERDIST
- QUERY_DTL
- QUERY_HDR
- QUOTE
- QUOTE_HISTORY
- RATE
- RATE_DIMENSION
- RATE_HEADER
- RATE_INDEX_CONTROL
- REC_JOURNAL_DTL
- REC_JOURNAL_HDR
- REPORT_PROPERTY
- REVENUE_CALCULATION
- REVENUE_CODE
- ROUTE
- RUN
- RUN_STOP
- SALESPERSON
- SCORE_HIST
- SCORE_HIST_DETAIL
- SEG_ALLOC_CODE
- SEG_ALLOC_CONTROL
- SEG_ALLOC_DETAIL
- SERVICEFAIL
- SETTLEMENT
- SETTLEMENT_NOTES
- SNAPSHOT_IMAGE
- STATE
- STOP
- STOP_HIST
- STOP_REC_ORDER
- TAX_DATA
- TIMEZONE
- TIME_DIM
- TRACTOR
- TRACTOR_BKP
- TRACTOR_DIM
- TRACTOR_MPG
- TRAILER
- TRAILER_BKP
- TRAILER_DIM
- USERS
- USER_GROUP
- VCARD_MCC
- VCARD_MERCHANT_GRP
- VENDOR
- VENDOR_ADDRESS
- VIOLATION
- VIOLATION_CODE
- VOUCHER
- VOUCHER_DIST
- VOUCHER_HIST
- VOUCHER_INTERFACE
- ZIPZONE
- ZONES
- ZONESUPERREGION
- ZONE_AREA
- ZONE_REGION