go back Home

RowDrsPayee

Sample XML

The following is only an example of what the XML should look like. The order of fields is not guaranteed and null fields are not included in returned data from the services.

<drs_payee company_id="..." id="..." adp_co_code="..." adp_e_no="..." agreement_dt="..." auth_reinstate_date="..." authority_reg_date="..." authority_reg_status="..." authority_reg_type="..." auto_create_dispatch_tractr="..." bank_acct_type_name="..." bank_address_1="..." bank_address_2="..." bank_city_name="..." bank_state="..." bank_zip_code="..." basic_update="..." begin_vacation_dt="..." bond_filed="..." bond_required="..." box_for_1099_total="..." broker_auth_grant_date="..." broker_auth_status="..." c_tpat_flag="..." c_tpat_svi="..." calc_agent_pay="..." carb_flag="..." cargo_agri_farm="..." cargo_beverages="..." cargo_building_mat="..." cargo_cancel_date="..." cargo_chemicals="..." cargo_coal_coke="..." cargo_commod_dry="..." cargo_construction="..." cargo_drive_tow="..." cargo_email="..." cargo_garbage="..." cargo_gen_freight="..." cargo_grain_feed="..." cargo_household="..." cargo_ins_amount="..." cargo_ins_amount_c="..." cargo_ins_amount_d="..." cargo_ins_amount_n="..." cargo_ins_amount_r="..." cargo_ins_on_file="..." cargo_ins_renew_dt="..." cargo_ins_required="..." cargo_insur_fax="..." cargo_insur_phone="..." cargo_insurer="..." cargo_intermodal="..." cargo_liquids_gas="..." cargo_livestock="..." cargo_logs_lumber="..." cargo_machinery="..." cargo_meat="..." cargo_metal="..." cargo_mobile_homes="..." cargo_oil_equip="..." cargo_other="..." cargo_other_descr="..." cargo_paper_prod="..." cargo_passengers="..." cargo_policy="..." cargo_produce="..." cargo_reefer_breakdown="..." cargo_reefer_food="..." cargo_related_oa="..." cargo_related_ot="..." cargo_related_pct="..." cargo_related_sv="..." cargo_us_mail="..." cargo_utilities="..." cargo_vehicles="..." cargo_water_well="..." carrier="..." carrier_cont_type="..." carrier_contract="..." carrier_flat_count="..." carrier_has_flats="..." carrier_has_refers="..." carrier_has_vans="..." carrier_mgr="..." carrier_ranking="..." carrier_refe_count="..." carrier_status_id="..." carrier_van_count="..." category="..." child_contract="..." com_auth_reinstate_date="..." common_auth_grant_date="..." common_auth_status="..." con_substance_oa="..." con_substance_ot="..." con_substance_sv="..." cont_auth_reinstate_date="..." cont_substance_pct="..." contact="..." contract_auth_grant_date="..." contract_auth_stat="..." contract_authority="..." contract_date="..." cr_union_wh="..." cr_union_wh_c="..." cr_union_wh_d="..." cr_union_wh_n="..." cr_union_wh_r="..." crashes_fatal="..." crashes_injury="..." crashes_total="..." crashes_tow="..." credit_approved="..." credit_check_date="..." cxna_id="..." date_entered="..." def_load_to_radius="..." def_loc_radius="..." default_bank_account="..." department="..." detention_max_pay_amt="..." detention_max_pay_amt_c="..." detention_max_pay_amt_d="..." detention_max_pay_amt_n="..." detention_max_pay_amt_r="..." detention_pay_rate="..." detention_tm_earning_code="..." detention_tm_max_pay_amt="..." detention_tm_max_pay_amt_c="..." detention_tm_max_pay_amt_d="..." detention_tm_max_pay_amt_n="..." detention_tm_max_pay_amt_r="..." detention_tm_pay_rate="..." disable_automatic_tracking="..." disable_electronic_offers="..." distance_method="..." distance_profile="..." distance_source="..." distance_type="..." division_id="..." dob_processed="..." dot_number="..." dray_rate="..." driver_fitness_oa="..." driver_fitness_ot="..." driver_fitness_pct="..." driver_fitness_sv="..." driver_inspection="..." driver_rating="..." drivers="..." drv_oos_inspection="..." dsly_excl_electronics="..." dsly_excl_high_value="..." dsly_excl_none="..." dsly_excl_pharma="..." dsly_excl_vaccine="..." dsly_exclusions_received="..." dsly_salesperson_assigned="..." dsly_unowned="..." earning_code="..." eforms_carrier_onboarding="..." eforms_contract_alert="..." eforms_contract_expire="..." eforms_docrequest_alert="..." eforms_docrequest_expire="..." eforms_expirations="..." eforms_profile_alert="..." eforms_profile_expire="..." eforms_qual_profile="..." efs_account="..." email="..." empty_pay_rate="..." equipment_type_id="..." exclude_from_perf_calc="..." expense_glid="..." experience_date="..." factor_name="..." factoring_company_id="..." fatigue_drive_pct="..." fatigued_drive_oa="..." fatigued_drive_ot="..." fatigued_drive_sv="..." fax="..." fuel_reimburse_id="..." fuel_surcharge_pay="..." futa="..." futa_c="..." futa_d="..." futa_n="..." futa_r="..." gross_non_taxed="..." gross_non_taxed_c="..." gross_non_taxed_d="..." gross_non_taxed_n="..." gross_non_taxed_r="..." haz_oos_inspection="..." hazmat_cert_number="..." hazmat_expire_date="..." hazmat_inspection="..." highway_id_number="..." highway_rule_assessment="..." highway_status="..." holiday_hours_pd="..." hourly_pay_allocation="..." household_goods="..." icc_number="..." ins_auto_update="..." ins_expire_notify="..." ins_last_upd_dt="..." ins_on_file="..." insurance_oa="..." insurance_sv="..." intrastate_code="..." intrastate_only="..." intrastate_state="..." is_air="..." is_any_auto="..." is_broker="..." is_certified="..." is_expedited="..." is_factored="..." is_hired_autos="..." is_intermodal="..." is_ltl="..." is_non_owned_autos="..." is_ocean="..." is_owned_autos="..." is_partial="..." is_rail="..." is_scheduled_autos="..." is_truckload="..." its_cpr_reports="..." its_suspension_reason="..." job_class_code_id="..." last_contacted="..." last_contacted_by="..." last_upd_rate="..." leased_tractors="..." leased_trailers="..." liab_cancel_date="..." liab_expire_date="..." liab_insur_fax="..." liab_insur_phone="..." liability_amount="..." liability_amount_c="..." liability_amount_d="..." liability_amount_n="..." liability_amount_r="..." liability_email="..." liability_insurer="..." liability_percent="..." liability_policy="..." liability_reqd="..." liability_reqd_c="..." liability_reqd_d="..." liability_reqd_n="..." liability_reqd_r="..." loaded_pay_rate="..." loadpay_accepted_status="..." loadpay_acct_id="..." loadpay_contact_email="..." loadpay_contact_name="..." loadpay_date="..." logo="..." logo_name="..." mark_plan_id="..." mc_payroll_pin="..." mcs_150_date="..." mcs_150_mileage="..." mcs_150_mileage_yr="..." method="..." mileage_code="..." min_pay_ded_code="..." minimum_pay="..." minimum_pay_c="..." minimum_pay_d="..." minimum_pay_n="..." minimum_pay_r="..." monitor_ins="..." monitor_ins_basic="..." mpw_carrier_contact_method="..." mpw_carrier_high="..." mpw_carrier_low="..." mpw_exclude="..." mpw_last_contact="..." mpw_num_attempts="..." mpw_num_orders="..." night_phone_number="..." no_dispatch="..." num_days_to_pay="..." onboarded="..." onboarding_status="..." operations_class="..." ops_class_descr="..." order_entry_url="..." out_of_service="..." override_qual_date="..." override_qual_enf="..." override_reason="..." overtime_cutoff="..." overtime_hours_pd="..." overtime_rate="..." owned_tractors="..." owned_trailers="..." p44_cap_provider_code="..." p44_profile_id="..." parent_contract="..." partner_tar_uid="..." partner_tariff_id="..." passenger="..." pay_advances="..." pay_factoring_company="..." pay_method="..." pay_option="..." pay_rate_group="..." payment_frequency="..." payroll_run="..." pend_broker_auth="..." pend_common_auth="..." pend_contract_auth="..." pend_rev_broker="..." pend_rev_common="..." pend_rev_contract="..." perdiem_rate="..." perform_rating="..." perform_rating_dt="..." period_loads="..." period_miles="..." period_revenue="..." period_revenue_c="..." period_revenue_d="..." period_revenue_n="..." period_revenue_r="..." power_units="..." print_1099="..." print_driver_orders_dtl="..." process_status="..." property="..." pu_pay_amount="..." pu_pay_amount_c="..." pu_pay_amount_d="..." pu_pay_amount_n="..." pu_pay_amount_r="..." puc_number="..." quickpay_amount="..." quickpay_basis="..." quickpay_contract="..." quickpay_daystopay="..." quickpay_deduct_id="..." quickpay_enabled="..." quickpay_min_chg="..." quickpay_min_chg_c="..." quickpay_min_chg_d="..." quickpay_min_chg_n="..." quickpay_min_chg_r="..." recur_tractor_last_created="..." regular_hours_pd="..." regular_rate="..." reimburse_fuel="..." req_dispatch_over="..." risk_assessment="..." rmis_carrier_id="..." safety_fitness="..." safety_fitness_dt="..." safety_rate_rev_dt="..." safety_rating="..." safety_rating_dt="..." safety_reg_date="..." safety_reg_status="..." safety_review_type="..." salesperson_id="..." scac="..." sea_accident="..." sea_driver="..." sea_safety_mgmt="..." sea_vehicle="..." search_city_id="..." search_city_name="..." search_state="..." search_zip_code="..." send_to="..." sick_earned="..." sick_hours_due="..." sick_hours_pd="..." smartway_certified="..." smartway_score="..." so_pay_amount="..." so_pay_amount_c="..." so_pay_amount_d="..." so_pay_amount_n="..." so_pay_amount_r="..." start_date="..." taxable_owed="..." taxable_owed_c="..." taxable_owed_d="..." taxable_owed_n="..." taxable_owed_r="..." team_empty_rate="..." team_method="..." team_pay_rate="..." term_code="..." term_is_quick_pay="..." terminal_id="..." tiered_stop_id="..." total_inspection="..." trackid_carrier_onboarding="..." trackid_document_request="..." trackid_expiring_insurance="..." trailer_rent="..." trainee_rate="..." trainer_rate="..." type_of="..." unsafe_driving_oa="..." unsafe_driving_ot="..." unsafe_driving_pct="..." unsafe_driving_sv="..." vacation_earned="..." vacation_hours_due="..." vacation_hours_pd="..." vacation_hrs_base="..." vacation_pay_rate="..." veh_oos_inspection="..." vehicle_inspection="..." vehicle_maint_oa="..." vehicle_maint_ot="..." vehicle_maint_pct="..." vehicle_maint_sv="..." via="..." w9_on_file="..." watchdog_report="..." wats_phone_number="..." workmans_comp="..." workmanscomp_date="..." ytd_401k_catchup="..." ytd_401k_catchup_c="..." ytd_401k_catchup_d="..." ytd_401k_catchup_n="..." ytd_401k_catchup_r="..." ytd_401k_contrib="..." ytd_401k_contrib_c="..." ytd_401k_contrib_d="..." ytd_401k_contrib_n="..." ytd_401k_contrib_r="..." ytd_city_gross="..." ytd_city_gross_c="..." ytd_city_gross_d="..." ytd_city_gross_n="..." ytd_city_gross_r="..." ytd_city_tax_wh="..." ytd_city_tax_wh_c="..." ytd_city_tax_wh_d="..." ytd_city_tax_wh_n="..." ytd_city_tax_wh_r="..." ytd_county_wages="..." ytd_county_wages_c="..." ytd_county_wages_d="..." ytd_county_wages_n="..." ytd_county_wages_r="..." ytd_county_wh="..." ytd_county_wh_c="..." ytd_county_wh_d="..." ytd_county_wh_n="..." ytd_county_wh_r="..." ytd_ett_wages="..." ytd_ett_wages_c="..." ytd_ett_wages_d="..." ytd_ett_wages_n="..." ytd_ett_wages_r="..." ytd_fed_gross="..." ytd_fed_gross_c="..." ytd_fed_gross_d="..." ytd_fed_gross_n="..." ytd_fed_gross_r="..." ytd_fed_withheld="..." ytd_fed_withheld_c="..." ytd_fed_withheld_d="..." ytd_fed_withheld_n="..." ytd_fed_withheld_r="..." ytd_fica_hi_gros="..." ytd_fica_hi_gros_c="..." ytd_fica_hi_gros_d="..." ytd_fica_hi_gros_n="..." ytd_fica_hi_gros_r="..." ytd_fica_hi_wh="..." ytd_fica_hi_wh_c="..." ytd_fica_hi_wh_d="..." ytd_fica_hi_wh_n="..." ytd_fica_hi_wh_r="..." ytd_fica_oadi_gr="..." ytd_fica_oadi_gr_c="..." ytd_fica_oadi_gr_d="..." ytd_fica_oadi_gr_n="..." ytd_fica_oadi_gr_r="..." ytd_fica_oadi_wh="..." ytd_fica_oadi_wh_c="..." ytd_fica_oadi_wh_d="..." ytd_fica_oadi_wh_n="..." ytd_fica_oadi_wh_r="..." ytd_fui_gross="..." ytd_fui_gross_c="..." ytd_fui_gross_d="..." ytd_fui_gross_n="..." ytd_fui_gross_r="..." ytd_holiday_hrs="..." ytd_loads="..." ytd_miles="..." ytd_overtime_hrs="..." ytd_puc_gross="..." ytd_puc_gross_c="..." ytd_puc_gross_d="..." ytd_puc_gross_n="..." ytd_puc_gross_r="..." ytd_puc_withheld="..." ytd_puc_withheld_c="..." ytd_puc_withheld_d="..." ytd_puc_withheld_n="..." ytd_puc_withheld_r="..." ytd_reg_hrs_paid="..." ytd_revenue="..." ytd_revenue_c="..." ytd_revenue_d="..." ytd_revenue_n="..." ytd_revenue_r="..." ytd_sdi_gross="..." ytd_sdi_gross_c="..." ytd_sdi_gross_d="..." ytd_sdi_gross_n="..." ytd_sdi_gross_r="..." ytd_sdi_withheld="..." ytd_sdi_withheld_c="..." ytd_sdi_withheld_d="..." ytd_sdi_withheld_n="..." ytd_sdi_withheld_r="..." ytd_sick_hrs_paid="..." ytd_state_gross="..." ytd_state_gross_c="..." ytd_state_gross_d="..." ytd_state_gross_n="..." ytd_state_gross_r="..." ytd_state_wh="..." ytd_state_wh_c="..." ytd_state_wh_d="..." ytd_state_wh_n="..." ytd_state_wh_r="..." ytd_sui_gross="..." ytd_sui_gross_c="..." ytd_sui_gross_d="..." ytd_sui_gross_n="..." ytd_sui_gross_r="..." ytd_sui_withheld="..." ytd_sui_withheld_c="..." ytd_sui_withheld_d="..." ytd_sui_withheld_n="..." ytd_sui_withheld_r="..." ytd_total_gross="..." ytd_total_gross_c="..." ytd_total_gross_d="..." ytd_total_gross_n="..." ytd_total_gross_r="..." ytd_vacation_hrs="..."/>

Sample JSON

The following is only an example of what the JSON should look like. The order of fields is not guaranteed and null fields are not included in returned data from the services.

{"__type":"drs_payee","company_id":"...","id":"...","adp_co_code":"...","adp_e_no":"...","agreement_dt":"...","auth_reinstate_date":"...","authority_reg_date":"...","authority_reg_status":"...","authority_reg_type":"...","auto_create_dispatch_tractr":"...","bank_acct_type_name":"...","bank_address_1":"...","bank_address_2":"...","bank_city_name":"...","bank_state":"...","bank_zip_code":"...","basic_update":"...","begin_vacation_dt":"...","bond_filed":"...","bond_required":"...","box_for_1099_total":"...","broker_auth_grant_date":"...","broker_auth_status":"...","c_tpat_flag":"...","c_tpat_svi":"...","calc_agent_pay":"...","carb_flag":"...","cargo_agri_farm":"...","cargo_beverages":"...","cargo_building_mat":"...","cargo_cancel_date":"...","cargo_chemicals":"...","cargo_coal_coke":"...","cargo_commod_dry":"...","cargo_construction":"...","cargo_drive_tow":"...","cargo_email":"...","cargo_garbage":"...","cargo_gen_freight":"...","cargo_grain_feed":"...","cargo_household":"...","cargo_ins_amount":"...","cargo_ins_amount_c":"...","cargo_ins_amount_d":"...","cargo_ins_amount_n":"...","cargo_ins_amount_r":"...","cargo_ins_on_file":"...","cargo_ins_renew_dt":"...","cargo_ins_required":"...","cargo_insur_fax":"...","cargo_insur_phone":"...","cargo_insurer":"...","cargo_intermodal":"...","cargo_liquids_gas":"...","cargo_livestock":"...","cargo_logs_lumber":"...","cargo_machinery":"...","cargo_meat":"...","cargo_metal":"...","cargo_mobile_homes":"...","cargo_oil_equip":"...","cargo_other":"...","cargo_other_descr":"...","cargo_paper_prod":"...","cargo_passengers":"...","cargo_policy":"...","cargo_produce":"...","cargo_reefer_breakdown":"...","cargo_reefer_food":"...","cargo_related_oa":"...","cargo_related_ot":"...","cargo_related_pct":"...","cargo_related_sv":"...","cargo_us_mail":"...","cargo_utilities":"...","cargo_vehicles":"...","cargo_water_well":"...","carrier":"...","carrier_cont_type":"...","carrier_contract":"...","carrier_flat_count":"...","carrier_has_flats":"...","carrier_has_refers":"...","carrier_has_vans":"...","carrier_mgr":"...","carrier_ranking":"...","carrier_refe_count":"...","carrier_status_id":"...","carrier_van_count":"...","category":"...","child_contract":"...","com_auth_reinstate_date":"...","common_auth_grant_date":"...","common_auth_status":"...","con_substance_oa":"...","con_substance_ot":"...","con_substance_sv":"...","cont_auth_reinstate_date":"...","cont_substance_pct":"...","contact":"...","contract_auth_grant_date":"...","contract_auth_stat":"...","contract_authority":"...","contract_date":"...","cr_union_wh":"...","cr_union_wh_c":"...","cr_union_wh_d":"...","cr_union_wh_n":"...","cr_union_wh_r":"...","crashes_fatal":"...","crashes_injury":"...","crashes_total":"...","crashes_tow":"...","credit_approved":"...","credit_check_date":"...","cxna_id":"...","date_entered":"...","def_load_to_radius":"...","def_loc_radius":"...","default_bank_account":"...","department":"...","detention_max_pay_amt":"...","detention_max_pay_amt_c":"...","detention_max_pay_amt_d":"...","detention_max_pay_amt_n":"...","detention_max_pay_amt_r":"...","detention_pay_rate":"...","detention_tm_earning_code":"...","detention_tm_max_pay_amt":"...","detention_tm_max_pay_amt_c":"...","detention_tm_max_pay_amt_d":"...","detention_tm_max_pay_amt_n":"...","detention_tm_max_pay_amt_r":"...","detention_tm_pay_rate":"...","disable_automatic_tracking":"...","disable_electronic_offers":"...","distance_method":"...","distance_profile":"...","distance_source":"...","distance_type":"...","division_id":"...","dob_processed":"...","dot_number":"...","dray_rate":"...","driver_fitness_oa":"...","driver_fitness_ot":"...","driver_fitness_pct":"...","driver_fitness_sv":"...","driver_inspection":"...","driver_rating":"...","drivers":"...","drv_oos_inspection":"...","dsly_excl_electronics":"...","dsly_excl_high_value":"...","dsly_excl_none":"...","dsly_excl_pharma":"...","dsly_excl_vaccine":"...","dsly_exclusions_received":"...","dsly_salesperson_assigned":"...","dsly_unowned":"...","earning_code":"...","eforms_carrier_onboarding":"...","eforms_contract_alert":"...","eforms_contract_expire":"...","eforms_docrequest_alert":"...","eforms_docrequest_expire":"...","eforms_expirations":"...","eforms_profile_alert":"...","eforms_profile_expire":"...","eforms_qual_profile":"...","efs_account":"...","email":"...","empty_pay_rate":"...","equipment_type_id":"...","exclude_from_perf_calc":"...","expense_glid":"...","experience_date":"...","factor_name":"...","factoring_company_id":"...","fatigue_drive_pct":"...","fatigued_drive_oa":"...","fatigued_drive_ot":"...","fatigued_drive_sv":"...","fax":"...","fuel_reimburse_id":"...","fuel_surcharge_pay":"...","futa":"...","futa_c":"...","futa_d":"...","futa_n":"...","futa_r":"...","gross_non_taxed":"...","gross_non_taxed_c":"...","gross_non_taxed_d":"...","gross_non_taxed_n":"...","gross_non_taxed_r":"...","haz_oos_inspection":"...","hazmat_cert_number":"...","hazmat_expire_date":"...","hazmat_inspection":"...","highway_id_number":"...","highway_rule_assessment":"...","highway_status":"...","holiday_hours_pd":"...","hourly_pay_allocation":"...","household_goods":"...","icc_number":"...","ins_auto_update":"...","ins_expire_notify":"...","ins_last_upd_dt":"...","ins_on_file":"...","insurance_oa":"...","insurance_sv":"...","intrastate_code":"...","intrastate_only":"...","intrastate_state":"...","is_air":"...","is_any_auto":"...","is_broker":"...","is_certified":"...","is_expedited":"...","is_factored":"...","is_hired_autos":"...","is_intermodal":"...","is_ltl":"...","is_non_owned_autos":"...","is_ocean":"...","is_owned_autos":"...","is_partial":"...","is_rail":"...","is_scheduled_autos":"...","is_truckload":"...","its_cpr_reports":"...","its_suspension_reason":"...","job_class_code_id":"...","last_contacted":"...","last_contacted_by":"...","last_upd_rate":"...","leased_tractors":"...","leased_trailers":"...","liab_cancel_date":"...","liab_expire_date":"...","liab_insur_fax":"...","liab_insur_phone":"...","liability_amount":"...","liability_amount_c":"...","liability_amount_d":"...","liability_amount_n":"...","liability_amount_r":"...","liability_email":"...","liability_insurer":"...","liability_percent":"...","liability_policy":"...","liability_reqd":"...","liability_reqd_c":"...","liability_reqd_d":"...","liability_reqd_n":"...","liability_reqd_r":"...","loaded_pay_rate":"...","loadpay_accepted_status":"...","loadpay_acct_id":"...","loadpay_contact_email":"...","loadpay_contact_name":"...","loadpay_date":"...","logo":"...","logo_name":"...","mark_plan_id":"...","mc_payroll_pin":"...","mcs_150_date":"...","mcs_150_mileage":"...","mcs_150_mileage_yr":"...","method":"...","mileage_code":"...","min_pay_ded_code":"...","minimum_pay":"...","minimum_pay_c":"...","minimum_pay_d":"...","minimum_pay_n":"...","minimum_pay_r":"...","monitor_ins":"...","monitor_ins_basic":"...","mpw_carrier_contact_method":"...","mpw_carrier_high":"...","mpw_carrier_low":"...","mpw_exclude":"...","mpw_last_contact":"...","mpw_num_attempts":"...","mpw_num_orders":"...","night_phone_number":"...","no_dispatch":"...","num_days_to_pay":"...","onboarded":"...","onboarding_status":"...","operations_class":"...","ops_class_descr":"...","order_entry_url":"...","out_of_service":"...","override_qual_date":"...","override_qual_enf":"...","override_reason":"...","overtime_cutoff":"...","overtime_hours_pd":"...","overtime_rate":"...","owned_tractors":"...","owned_trailers":"...","p44_cap_provider_code":"...","p44_profile_id":"...","parent_contract":"...","partner_tar_uid":"...","partner_tariff_id":"...","passenger":"...","pay_advances":"...","pay_factoring_company":"...","pay_method":"...","pay_option":"...","pay_rate_group":"...","payment_frequency":"...","payroll_run":"...","pend_broker_auth":"...","pend_common_auth":"...","pend_contract_auth":"...","pend_rev_broker":"...","pend_rev_common":"...","pend_rev_contract":"...","perdiem_rate":"...","perform_rating":"...","perform_rating_dt":"...","period_loads":"...","period_miles":"...","period_revenue":"...","period_revenue_c":"...","period_revenue_d":"...","period_revenue_n":"...","period_revenue_r":"...","power_units":"...","print_1099":"...","print_driver_orders_dtl":"...","process_status":"...","property":"...","pu_pay_amount":"...","pu_pay_amount_c":"...","pu_pay_amount_d":"...","pu_pay_amount_n":"...","pu_pay_amount_r":"...","puc_number":"...","quickpay_amount":"...","quickpay_basis":"...","quickpay_contract":"...","quickpay_daystopay":"...","quickpay_deduct_id":"...","quickpay_enabled":"...","quickpay_min_chg":"...","quickpay_min_chg_c":"...","quickpay_min_chg_d":"...","quickpay_min_chg_n":"...","quickpay_min_chg_r":"...","recur_tractor_last_created":"...","regular_hours_pd":"...","regular_rate":"...","reimburse_fuel":"...","req_dispatch_over":"...","risk_assessment":"...","rmis_carrier_id":"...","safety_fitness":"...","safety_fitness_dt":"...","safety_rate_rev_dt":"...","safety_rating":"...","safety_rating_dt":"...","safety_reg_date":"...","safety_reg_status":"...","safety_review_type":"...","salesperson_id":"...","scac":"...","sea_accident":"...","sea_driver":"...","sea_safety_mgmt":"...","sea_vehicle":"...","search_city_id":"...","search_city_name":"...","search_state":"...","search_zip_code":"...","send_to":"...","sick_earned":"...","sick_hours_due":"...","sick_hours_pd":"...","smartway_certified":"...","smartway_score":"...","so_pay_amount":"...","so_pay_amount_c":"...","so_pay_amount_d":"...","so_pay_amount_n":"...","so_pay_amount_r":"...","start_date":"...","taxable_owed":"...","taxable_owed_c":"...","taxable_owed_d":"...","taxable_owed_n":"...","taxable_owed_r":"...","team_empty_rate":"...","team_method":"...","team_pay_rate":"...","term_code":"...","term_is_quick_pay":"...","terminal_id":"...","tiered_stop_id":"...","total_inspection":"...","trackid_carrier_onboarding":"...","trackid_document_request":"...","trackid_expiring_insurance":"...","trailer_rent":"...","trainee_rate":"...","trainer_rate":"...","type_of":"...","unsafe_driving_oa":"...","unsafe_driving_ot":"...","unsafe_driving_pct":"...","unsafe_driving_sv":"...","vacation_earned":"...","vacation_hours_due":"...","vacation_hours_pd":"...","vacation_hrs_base":"...","vacation_pay_rate":"...","veh_oos_inspection":"...","vehicle_inspection":"...","vehicle_maint_oa":"...","vehicle_maint_ot":"...","vehicle_maint_pct":"...","vehicle_maint_sv":"...","via":"...","w9_on_file":"...","watchdog_report":"...","wats_phone_number":"...","workmans_comp":"...","workmanscomp_date":"...","ytd_401k_catchup":"...","ytd_401k_catchup_c":"...","ytd_401k_catchup_d":"...","ytd_401k_catchup_n":"...","ytd_401k_catchup_r":"...","ytd_401k_contrib":"...","ytd_401k_contrib_c":"...","ytd_401k_contrib_d":"...","ytd_401k_contrib_n":"...","ytd_401k_contrib_r":"...","ytd_city_gross":"...","ytd_city_gross_c":"...","ytd_city_gross_d":"...","ytd_city_gross_n":"...","ytd_city_gross_r":"...","ytd_city_tax_wh":"...","ytd_city_tax_wh_c":"...","ytd_city_tax_wh_d":"...","ytd_city_tax_wh_n":"...","ytd_city_tax_wh_r":"...","ytd_county_wages":"...","ytd_county_wages_c":"...","ytd_county_wages_d":"...","ytd_county_wages_n":"...","ytd_county_wages_r":"...","ytd_county_wh":"...","ytd_county_wh_c":"...","ytd_county_wh_d":"...","ytd_county_wh_n":"...","ytd_county_wh_r":"...","ytd_ett_wages":"...","ytd_ett_wages_c":"...","ytd_ett_wages_d":"...","ytd_ett_wages_n":"...","ytd_ett_wages_r":"...","ytd_fed_gross":"...","ytd_fed_gross_c":"...","ytd_fed_gross_d":"...","ytd_fed_gross_n":"...","ytd_fed_gross_r":"...","ytd_fed_withheld":"...","ytd_fed_withheld_c":"...","ytd_fed_withheld_d":"...","ytd_fed_withheld_n":"...","ytd_fed_withheld_r":"...","ytd_fica_hi_gros":"...","ytd_fica_hi_gros_c":"...","ytd_fica_hi_gros_d":"...","ytd_fica_hi_gros_n":"...","ytd_fica_hi_gros_r":"...","ytd_fica_hi_wh":"...","ytd_fica_hi_wh_c":"...","ytd_fica_hi_wh_d":"...","ytd_fica_hi_wh_n":"...","ytd_fica_hi_wh_r":"...","ytd_fica_oadi_gr":"...","ytd_fica_oadi_gr_c":"...","ytd_fica_oadi_gr_d":"...","ytd_fica_oadi_gr_n":"...","ytd_fica_oadi_gr_r":"...","ytd_fica_oadi_wh":"...","ytd_fica_oadi_wh_c":"...","ytd_fica_oadi_wh_d":"...","ytd_fica_oadi_wh_n":"...","ytd_fica_oadi_wh_r":"...","ytd_fui_gross":"...","ytd_fui_gross_c":"...","ytd_fui_gross_d":"...","ytd_fui_gross_n":"...","ytd_fui_gross_r":"...","ytd_holiday_hrs":"...","ytd_loads":"...","ytd_miles":"...","ytd_overtime_hrs":"...","ytd_puc_gross":"...","ytd_puc_gross_c":"...","ytd_puc_gross_d":"...","ytd_puc_gross_n":"...","ytd_puc_gross_r":"...","ytd_puc_withheld":"...","ytd_puc_withheld_c":"...","ytd_puc_withheld_d":"...","ytd_puc_withheld_n":"...","ytd_puc_withheld_r":"...","ytd_reg_hrs_paid":"...","ytd_revenue":"...","ytd_revenue_c":"...","ytd_revenue_d":"...","ytd_revenue_n":"...","ytd_revenue_r":"...","ytd_sdi_gross":"...","ytd_sdi_gross_c":"...","ytd_sdi_gross_d":"...","ytd_sdi_gross_n":"...","ytd_sdi_gross_r":"...","ytd_sdi_withheld":"...","ytd_sdi_withheld_c":"...","ytd_sdi_withheld_d":"...","ytd_sdi_withheld_n":"...","ytd_sdi_withheld_r":"...","ytd_sick_hrs_paid":"...","ytd_state_gross":"...","ytd_state_gross_c":"...","ytd_state_gross_d":"...","ytd_state_gross_n":"...","ytd_state_gross_r":"...","ytd_state_wh":"...","ytd_state_wh_c":"...","ytd_state_wh_d":"...","ytd_state_wh_n":"...","ytd_state_wh_r":"...","ytd_sui_gross":"...","ytd_sui_gross_c":"...","ytd_sui_gross_d":"...","ytd_sui_gross_n":"...","ytd_sui_gross_r":"...","ytd_sui_withheld":"...","ytd_sui_withheld_c":"...","ytd_sui_withheld_d":"...","ytd_sui_withheld_n":"...","ytd_sui_withheld_r":"...","ytd_total_gross":"...","ytd_total_gross_c":"...","ytd_total_gross_d":"...","ytd_total_gross_n":"...","ytd_total_gross_r":"...","ytd_vacation_hrs":"..."}

Fields

key name size type
company_id 4 String
id 8 String
adp_co_code 3 String
adp_e_no 6 String
agreement_dt 10 Date
auth_reinstate_date 10 Date
authority_reg_date 10 Date
authority_reg_status 1 String
authority_reg_type 1 String
auto_create_dispatch_tractr 1 String
bank_acct_type_name 255 String
bank_address_1 40 String
bank_address_2 40 String
bank_city_name 50 String
bank_state 2 String
bank_zip_code 10 String
basic_update 10 Date
begin_vacation_dt 10 Date
bond_filed 1 String
bond_required 1 String
box_for_1099_total 2 String
broker_auth_grant_date 10 Date
broker_auth_status 1 String
c_tpat_flag 1 String
c_tpat_svi 40 String
calc_agent_pay 1 String
carb_flag 1 String
cargo_agri_farm 1 String
cargo_beverages 1 String
cargo_building_mat 1 String
cargo_cancel_date 19 Date
cargo_chemicals 1 String
cargo_coal_coke 1 String
cargo_commod_dry 1 String
cargo_construction 1 String
cargo_drive_tow 1 String
cargo_email 120 String
cargo_garbage 1 String
cargo_gen_freight 1 String
cargo_grain_feed 1 String
cargo_household 1 String
cargo_ins_amount 16.2 BigDecimal
cargo_ins_amount_c 3 String
cargo_ins_amount_d 19 Date
cargo_ins_amount_n 16.2 BigDecimal
cargo_ins_amount_r 10.6 BigDecimal
cargo_ins_on_file 1 String
cargo_ins_renew_dt 10 Date
cargo_ins_required 1 String
cargo_insur_fax 20 String
cargo_insur_phone 20 String
cargo_insurer 28 String
cargo_intermodal 1 String
cargo_liquids_gas 1 String
cargo_livestock 1 String
cargo_logs_lumber 1 String
cargo_machinery 1 String
cargo_meat 1 String
cargo_metal 1 String
cargo_mobile_homes 1 String
cargo_oil_equip 1 String
cargo_other 1 String
cargo_other_descr 50 String
cargo_paper_prod 1 String
cargo_passengers 1 String
cargo_policy 28 String
cargo_produce 1 String
cargo_reefer_breakdown 1 String
cargo_reefer_food 1 String
cargo_related_oa 1 String
cargo_related_ot 1 String
cargo_related_pct 5.2 BigDecimal
cargo_related_sv 1 String
cargo_us_mail 1 String
cargo_utilities 1 String
cargo_vehicles 1 String
cargo_water_well 1 String
carrier 1 String
carrier_cont_type 1 String
carrier_contract 1 String
carrier_flat_count 10 int
carrier_has_flats 1 String
carrier_has_refers 1 String
carrier_has_vans 1 String
carrier_mgr 10 String
carrier_ranking 4.1 BigDecimal
carrier_refe_count 10 int
carrier_status_id 8 String
carrier_van_count 10 int
category 3 String
child_contract 10 int
com_auth_reinstate_date 10 Date
common_auth_grant_date 10 Date
common_auth_status 1 String
con_substance_oa 1 String
con_substance_ot 1 String
con_substance_sv 1 String
cont_auth_reinstate_date 10 Date
cont_substance_pct 5.2 BigDecimal
contact 20 String
contract_auth_grant_date 10 Date
contract_auth_stat 1 String
contract_authority 1 String
contract_date 10 Date
cr_union_wh 16.2 BigDecimal
cr_union_wh_c 3 String
cr_union_wh_d 19 Date
cr_union_wh_n 16.2 BigDecimal
cr_union_wh_r 10.6 BigDecimal
crashes_fatal 10 int
crashes_injury 10 int
crashes_total 10 int
crashes_tow 10 int
credit_approved 1 String
credit_check_date 10 Date
cxna_id 10 int
date_entered 10 Date
def_load_to_radius 10 int
def_loc_radius 10 int
default_bank_account 255 String
department 3 String
detention_max_pay_amt 16.2 BigDecimal
detention_max_pay_amt_c 3 String
detention_max_pay_amt_d 19 Date
detention_max_pay_amt_n 16.2 BigDecimal
detention_max_pay_amt_r 10.6 BigDecimal
detention_pay_rate 5.2 BigDecimal
detention_tm_earning_code 3 String
detention_tm_max_pay_amt 16.2 BigDecimal
detention_tm_max_pay_amt_c 3 String
detention_tm_max_pay_amt_d 19 Date
detention_tm_max_pay_amt_n 16.2 BigDecimal
detention_tm_max_pay_amt_r 10.6 BigDecimal
detention_tm_pay_rate 5.2 BigDecimal
disable_automatic_tracking 1 String
disable_electronic_offers 1 String
distance_method 1 String
distance_profile 8 String
distance_source 1 String
distance_type 1 String
division_id 2 String
dob_processed 1 String
dot_number 10 String
dray_rate 10 int
driver_fitness_oa 1 String
driver_fitness_ot 1 String
driver_fitness_pct 5.2 BigDecimal
driver_fitness_sv 1 String
driver_inspection 10 int
driver_rating 12 String
drivers 10 int
drv_oos_inspection 10 int
dsly_excl_electronics 1 String
dsly_excl_high_value 1 String
dsly_excl_none 1 String
dsly_excl_pharma 1 String
dsly_excl_vaccine 1 String
dsly_exclusions_received 1 String
dsly_salesperson_assigned 10 Date
dsly_unowned 1 String
earning_code 3 String
eforms_carrier_onboarding 2 String
eforms_contract_alert 10.2 BigDecimal
eforms_contract_expire 10.2 BigDecimal
eforms_docrequest_alert 10.2 BigDecimal
eforms_docrequest_expire 10.2 BigDecimal
eforms_expirations 1 String
eforms_profile_alert 10.2 BigDecimal
eforms_profile_expire 10.2 BigDecimal
eforms_qual_profile 8 String
efs_account 7 String
email 60 String
empty_pay_rate 12.4 BigDecimal
equipment_type_id 4 String
exclude_from_perf_calc 1 String
expense_glid 20 String
experience_date 10 Date
factor_name 255 String
factoring_company_id 8 String
fatigue_drive_pct 5.2 BigDecimal
fatigued_drive_oa 1 String
fatigued_drive_ot 1 String
fatigued_drive_sv 1 String
fax 20 String
fuel_reimburse_id 8 String
fuel_surcharge_pay 8 String
futa 16.2 BigDecimal
futa_c 3 String
futa_d 19 Date
futa_n 16.2 BigDecimal
futa_r 10.6 BigDecimal
gross_non_taxed 16.2 BigDecimal
gross_non_taxed_c 3 String
gross_non_taxed_d 19 Date
gross_non_taxed_n 16.2 BigDecimal
gross_non_taxed_r 10.6 BigDecimal
haz_oos_inspection 10 int
hazmat_cert_number 20 String
hazmat_expire_date 10 Date
hazmat_inspection 10 int
highway_id_number 12 String
highway_rule_assessment 1 String
highway_status 1 String
holiday_hours_pd 6.2 BigDecimal
hourly_pay_allocation 1 String
household_goods 1 String
icc_number 12 String
ins_auto_update 1 String
ins_expire_notify 120 String
ins_last_upd_dt 19 Date
ins_on_file 1 String
insurance_oa 1 String
insurance_sv 1 String
intrastate_code 15 String
intrastate_only 1 String
intrastate_state 2 String
is_air 1 String
is_any_auto 1 String
is_broker 1 String
is_certified 1 String
is_expedited 1 String
is_factored 1 String
is_hired_autos 1 String
is_intermodal 1 String
is_ltl 1 String
is_non_owned_autos 1 String
is_ocean 1 String
is_owned_autos 1 String
is_partial 1 String
is_rail 1 String
is_scheduled_autos 1 String
is_truckload 1 String
its_cpr_reports 70 String
its_suspension_reason 70 String
job_class_code_id 2 String
last_contacted 19 Date
last_contacted_by 10 String
last_upd_rate 10 Date
leased_tractors 10 int
leased_trailers 10 int
liab_cancel_date 19 Date
liab_expire_date 10 Date
liab_insur_fax 20 String
liab_insur_phone 20 String
liability_amount 16.2 BigDecimal
liability_amount_c 3 String
liability_amount_d 19 Date
liability_amount_n 16.2 BigDecimal
liability_amount_r 10.6 BigDecimal
liability_email 120 String
liability_insurer 28 String
liability_percent 5.2 BigDecimal
liability_policy 28 String
liability_reqd 16.2 BigDecimal
liability_reqd_c 3 String
liability_reqd_d 19 Date
liability_reqd_n 16.2 BigDecimal
liability_reqd_r 10.6 BigDecimal
loaded_pay_rate 12.4 BigDecimal
loadpay_accepted_status 1 String
loadpay_acct_id 255 String
loadpay_contact_email 128 String
loadpay_contact_name 80 String
loadpay_date 19 Date
logo 20 byte[]
logo_name 100 String
mark_plan_id 8 String
mc_payroll_pin 8 String
mcs_150_date 19 Date
mcs_150_mileage 20 String
mcs_150_mileage_yr 10 int
method 1 String
mileage_code 3 String
min_pay_ded_code 3 String
minimum_pay 16.2 BigDecimal
minimum_pay_c 3 String
minimum_pay_d 19 Date
minimum_pay_n 16.2 BigDecimal
minimum_pay_r 10.6 BigDecimal
monitor_ins 1 String
monitor_ins_basic 1 String
mpw_carrier_contact_method 1 String
mpw_carrier_high 10 int
mpw_carrier_low 10 int
mpw_exclude 1 String
mpw_last_contact 10 Date
mpw_num_attempts 10 int
mpw_num_orders 10 int
night_phone_number 20 String
no_dispatch 1 String
num_days_to_pay 10 int
onboarded 1 String
onboarding_status 1 String
operations_class 50 String
ops_class_descr 50 String
order_entry_url 512 String
out_of_service 1 String
override_qual_date 10 Date
override_qual_enf 1 String
override_reason 40 String
overtime_cutoff 6.2 BigDecimal
overtime_hours_pd 6.2 BigDecimal
overtime_rate 12.4 BigDecimal
owned_tractors 10 int
owned_trailers 10 int
p44_cap_provider_code 64 String
p44_profile_id 8 String
parent_contract 10 int
partner_tar_uid 10 int
partner_tariff_id 10 String
passenger 1 String
pay_advances 1 String
pay_factoring_company 1 String
pay_method 1 String
pay_option 1 String
pay_rate_group 8 String
payment_frequency 1 String
payroll_run 1 String
pend_broker_auth 1 String
pend_common_auth 1 String
pend_contract_auth 1 String
pend_rev_broker 1 String
pend_rev_common 1 String
pend_rev_contract 1 String
perdiem_rate 12.4 BigDecimal
perform_rating 12 String
perform_rating_dt 10 Date
period_loads 10 int
period_miles 16.1 BigDecimal
period_revenue 16.2 BigDecimal
period_revenue_c 3 String
period_revenue_d 19 Date
period_revenue_n 16.2 BigDecimal
period_revenue_r 10.6 BigDecimal
power_units 10 int
print_1099 1 String
print_driver_orders_dtl 1 String
process_status 1 String
property 1 String
pu_pay_amount 16.2 BigDecimal
pu_pay_amount_c 3 String
pu_pay_amount_d 19 Date
pu_pay_amount_n 16.2 BigDecimal
pu_pay_amount_r 10.6 BigDecimal
puc_number 10 String
quickpay_amount 16.2 BigDecimal
quickpay_basis 1 String
quickpay_contract 10 Date
quickpay_daystopay 10 int
quickpay_deduct_id 3 String
quickpay_enabled 1 String
quickpay_min_chg 16.2 BigDecimal
quickpay_min_chg_c 3 String
quickpay_min_chg_d 19 Date
quickpay_min_chg_n 16.2 BigDecimal
quickpay_min_chg_r 10.6 BigDecimal
recur_tractor_last_created 19 Date
regular_hours_pd 6.2 BigDecimal
regular_rate 12.4 BigDecimal
reimburse_fuel 1 String
req_dispatch_over 1 String
risk_assessment 1 String
rmis_carrier_id 12 String
safety_fitness 1 String
safety_fitness_dt 10 Date
safety_rate_rev_dt 19 Date
safety_rating 1 String
safety_rating_dt 10 Date
safety_reg_date 10 Date
safety_reg_status 1 String
safety_review_type 1 String
salesperson_id 8 String
scac 4 String
sea_accident 5.2 BigDecimal
sea_driver 5.2 BigDecimal
sea_safety_mgmt 5.2 BigDecimal
sea_vehicle 5.2 BigDecimal
search_city_id 10 int
search_city_name 50 String
search_state 2 String
search_zip_code 10 String
send_to 40 String
sick_earned 16.5 BigDecimal
sick_hours_due 8.2 BigDecimal
sick_hours_pd 6.2 BigDecimal
smartway_certified 1 String
smartway_score 3.2 BigDecimal
so_pay_amount 16.2 BigDecimal
so_pay_amount_c 3 String
so_pay_amount_d 19 Date
so_pay_amount_n 16.2 BigDecimal
so_pay_amount_r 10.6 BigDecimal
start_date 10 Date
taxable_owed 16.2 BigDecimal
taxable_owed_c 3 String
taxable_owed_d 19 Date
taxable_owed_n 16.2 BigDecimal
taxable_owed_r 10.6 BigDecimal
team_empty_rate 12.4 BigDecimal
team_method 1 String
team_pay_rate 12.4 BigDecimal
term_code 10 String
term_is_quick_pay 1 String
terminal_id 2 String
tiered_stop_id 8 String
total_inspection 10 int
trackid_carrier_onboarding 10 int
trackid_document_request 10 int
trackid_expiring_insurance 10 int
trailer_rent 5.2 BigDecimal
trainee_rate 12.4 BigDecimal
trainer_rate 12.4 BigDecimal
type_of 1 String
unsafe_driving_oa 1 String
unsafe_driving_ot 1 String
unsafe_driving_pct 5.2 BigDecimal
unsafe_driving_sv 1 String
vacation_earned 16.5 BigDecimal
vacation_hours_due 8.2 BigDecimal
vacation_hours_pd 8.2 BigDecimal
vacation_hrs_base 8.2 BigDecimal
vacation_pay_rate 12.4 BigDecimal
veh_oos_inspection 10 int
vehicle_inspection 10 int
vehicle_maint_oa 1 String
vehicle_maint_ot 1 String
vehicle_maint_pct 5.2 BigDecimal
vehicle_maint_sv 1 String
via 1 String
w9_on_file 1 String
watchdog_report 10 String
wats_phone_number 20 String
workmans_comp 5.2 BigDecimal
workmanscomp_date 10 Date
ytd_401k_catchup 16.2 BigDecimal
ytd_401k_catchup_c 3 String
ytd_401k_catchup_d 19 Date
ytd_401k_catchup_n 16.2 BigDecimal
ytd_401k_catchup_r 10.6 BigDecimal
ytd_401k_contrib 16.2 BigDecimal
ytd_401k_contrib_c 3 String
ytd_401k_contrib_d 19 Date
ytd_401k_contrib_n 16.2 BigDecimal
ytd_401k_contrib_r 10.6 BigDecimal
ytd_city_gross 16.2 BigDecimal
ytd_city_gross_c 3 String
ytd_city_gross_d 19 Date
ytd_city_gross_n 16.2 BigDecimal
ytd_city_gross_r 10.6 BigDecimal
ytd_city_tax_wh 16.2 BigDecimal
ytd_city_tax_wh_c 3 String
ytd_city_tax_wh_d 19 Date
ytd_city_tax_wh_n 16.2 BigDecimal
ytd_city_tax_wh_r 10.6 BigDecimal
ytd_county_wages 16.2 BigDecimal
ytd_county_wages_c 3 String
ytd_county_wages_d 19 Date
ytd_county_wages_n 16.2 BigDecimal
ytd_county_wages_r 10.6 BigDecimal
ytd_county_wh 16.2 BigDecimal
ytd_county_wh_c 3 String
ytd_county_wh_d 19 Date
ytd_county_wh_n 16.2 BigDecimal
ytd_county_wh_r 10.6 BigDecimal
ytd_ett_wages 16.2 BigDecimal
ytd_ett_wages_c 3 String
ytd_ett_wages_d 19 Date
ytd_ett_wages_n 16.2 BigDecimal
ytd_ett_wages_r 10.6 BigDecimal
ytd_fed_gross 16.2 BigDecimal
ytd_fed_gross_c 3 String
ytd_fed_gross_d 19 Date
ytd_fed_gross_n 16.2 BigDecimal
ytd_fed_gross_r 10.6 BigDecimal
ytd_fed_withheld 16.2 BigDecimal
ytd_fed_withheld_c 3 String
ytd_fed_withheld_d 19 Date
ytd_fed_withheld_n 16.2 BigDecimal
ytd_fed_withheld_r 10.6 BigDecimal
ytd_fica_hi_gros 16.2 BigDecimal
ytd_fica_hi_gros_c 3 String
ytd_fica_hi_gros_d 19 Date
ytd_fica_hi_gros_n 16.2 BigDecimal
ytd_fica_hi_gros_r 10.6 BigDecimal
ytd_fica_hi_wh 16.2 BigDecimal
ytd_fica_hi_wh_c 3 String
ytd_fica_hi_wh_d 19 Date
ytd_fica_hi_wh_n 16.2 BigDecimal
ytd_fica_hi_wh_r 10.6 BigDecimal
ytd_fica_oadi_gr 16.2 BigDecimal
ytd_fica_oadi_gr_c 3 String
ytd_fica_oadi_gr_d 19 Date
ytd_fica_oadi_gr_n 16.2 BigDecimal
ytd_fica_oadi_gr_r 10.6 BigDecimal
ytd_fica_oadi_wh 16.2 BigDecimal
ytd_fica_oadi_wh_c 3 String
ytd_fica_oadi_wh_d 19 Date
ytd_fica_oadi_wh_n 16.2 BigDecimal
ytd_fica_oadi_wh_r 10.6 BigDecimal
ytd_fui_gross 16.2 BigDecimal
ytd_fui_gross_c 3 String
ytd_fui_gross_d 19 Date
ytd_fui_gross_n 16.2 BigDecimal
ytd_fui_gross_r 10.6 BigDecimal
ytd_holiday_hrs 7.2 BigDecimal
ytd_loads 10 int
ytd_miles 16.1 BigDecimal
ytd_overtime_hrs 7.2 BigDecimal
ytd_puc_gross 16.2 BigDecimal
ytd_puc_gross_c 3 String
ytd_puc_gross_d 19 Date
ytd_puc_gross_n 16.2 BigDecimal
ytd_puc_gross_r 10.6 BigDecimal
ytd_puc_withheld 16.2 BigDecimal
ytd_puc_withheld_c 3 String
ytd_puc_withheld_d 19 Date
ytd_puc_withheld_n 16.2 BigDecimal
ytd_puc_withheld_r 10.6 BigDecimal
ytd_reg_hrs_paid 7.2 BigDecimal
ytd_revenue 16.2 BigDecimal
ytd_revenue_c 3 String
ytd_revenue_d 19 Date
ytd_revenue_n 16.2 BigDecimal
ytd_revenue_r 10.6 BigDecimal
ytd_sdi_gross 16.2 BigDecimal
ytd_sdi_gross_c 3 String
ytd_sdi_gross_d 19 Date
ytd_sdi_gross_n 16.2 BigDecimal
ytd_sdi_gross_r 10.6 BigDecimal
ytd_sdi_withheld 16.2 BigDecimal
ytd_sdi_withheld_c 3 String
ytd_sdi_withheld_d 19 Date
ytd_sdi_withheld_n 16.2 BigDecimal
ytd_sdi_withheld_r 10.6 BigDecimal
ytd_sick_hrs_paid 7.2 BigDecimal
ytd_state_gross 16.2 BigDecimal
ytd_state_gross_c 3 String
ytd_state_gross_d 19 Date
ytd_state_gross_n 16.2 BigDecimal
ytd_state_gross_r 10.6 BigDecimal
ytd_state_wh 16.2 BigDecimal
ytd_state_wh_c 3 String
ytd_state_wh_d 19 Date
ytd_state_wh_n 16.2 BigDecimal
ytd_state_wh_r 10.6 BigDecimal
ytd_sui_gross 16.2 BigDecimal
ytd_sui_gross_c 3 String
ytd_sui_gross_d 19 Date
ytd_sui_gross_n 16.2 BigDecimal
ytd_sui_gross_r 10.6 BigDecimal
ytd_sui_withheld 16.2 BigDecimal
ytd_sui_withheld_c 3 String
ytd_sui_withheld_d 19 Date
ytd_sui_withheld_n 16.2 BigDecimal
ytd_sui_withheld_r 10.6 BigDecimal
ytd_total_gross 16.2 BigDecimal
ytd_total_gross_c 3 String
ytd_total_gross_d 19 Date
ytd_total_gross_n 16.2 BigDecimal
ytd_total_gross_r 10.6 BigDecimal
ytd_vacation_hrs 7.2 BigDecimal