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="..." authority_days="..." authority_grant_date="..." authority_reg_date="..." authority_reg_status="..." authority_reg_type="..." auto_create_dispatch_tractr="..." basic_update="..." begin_vacation_dt="..." bond_filed="..." bond_required="..." box_for_1099_total="..." broker_auth_status="..." c_tpat_flag="..." c_tpat_svi="..." calc_agent_pay="..." 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_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="..." common_auth_status="..." con_substance_oa="..." con_substance_ot="..." con_substance_sv="..." cont_substance_pct="..." contact="..." 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="..." date_entered="..." def_load_to_radius="..." def_loc_radius="..." department="..." 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="..." 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="..." employer_liability_amount="..." employer_liability_amount_c="..." employer_liability_amount_d="..." employer_liability_amount_n="..." employer_liability_amount_r="..." employer_liability_date="..." empty_pay_rate="..." equipment_type_id="..." exclude_from_perf_calc="..." expense_glid="..." experience_date="..." 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="..." general_liab_expire_date="..." general_liability_amount="..." general_liability_amount_c="..." general_liability_amount_d="..." general_liability_amount_n="..." general_liability_amount_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="..." 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_broker="..." is_certified="..." is_rail="..." 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="..." logo="..." logo_name="..." mark_plan_id="..." mc_payroll_pin="..." mcs_150_date="..." mcs_150_mileage="..." mcs_150_mileage_yr="..." mileage_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="..." 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="..." parent_contract="..." partner_tar_uid="..." partner_tariff_id="..." passenger="..." pay_advances="..." pay_factoring_company="..." pay_method="..." 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="..." 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_pay_rate="..." 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="..." 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="..."/>
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":"...","authority_days":"...","authority_grant_date":"...","authority_reg_date":"...","authority_reg_status":"...","authority_reg_type":"...","auto_create_dispatch_tractr":"...","basic_update":"...","begin_vacation_dt":"...","bond_filed":"...","bond_required":"...","box_for_1099_total":"...","broker_auth_status":"...","c_tpat_flag":"...","c_tpat_svi":"...","calc_agent_pay":"...","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_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":"...","common_auth_status":"...","con_substance_oa":"...","con_substance_ot":"...","con_substance_sv":"...","cont_substance_pct":"...","contact":"...","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":"...","date_entered":"...","def_load_to_radius":"...","def_loc_radius":"...","department":"...","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":"...","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":"...","employer_liability_amount":"...","employer_liability_amount_c":"...","employer_liability_amount_d":"...","employer_liability_amount_n":"...","employer_liability_amount_r":"...","employer_liability_date":"...","empty_pay_rate":"...","equipment_type_id":"...","exclude_from_perf_calc":"...","expense_glid":"...","experience_date":"...","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":"...","general_liab_expire_date":"...","general_liability_amount":"...","general_liability_amount_c":"...","general_liability_amount_d":"...","general_liability_amount_n":"...","general_liability_amount_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":"...","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_broker":"...","is_certified":"...","is_rail":"...","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":"...","logo":"...","logo_name":"...","mark_plan_id":"...","mc_payroll_pin":"...","mcs_150_date":"...","mcs_150_mileage":"...","mcs_150_mileage_yr":"...","mileage_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":"...","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":"...","parent_contract":"...","partner_tar_uid":"...","partner_tariff_id":"...","passenger":"...","pay_advances":"...","pay_factoring_company":"...","pay_method":"...","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":"...","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_pay_rate":"...","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":"...","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":"..."}
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 | |
authority_days | 10 | int | |
authority_grant_date | 10 | Date | |
authority_reg_date | 10 | Date | |
authority_reg_status | 1 | String | |
authority_reg_type | 1 | String | |
auto_create_dispatch_tractr | 1 | 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_status | 1 | String | |
c_tpat_flag | 1 | String | |
c_tpat_svi | 40 | String | |
calc_agent_pay | 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 | 8.4 | 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_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 | |
common_auth_status | 1 | String | |
con_substance_oa | 1 | String | |
con_substance_ot | 1 | String | |
con_substance_sv | 1 | String | |
cont_substance_pct | 5.2 | BigDecimal | |
contact | 20 | String | |
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 | 8.4 | 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 | |
date_entered | 10 | Date | |
def_load_to_radius | 10 | int | |
def_loc_radius | 10 | int | |
department | 3 | 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 | |
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 | |
60 | String | ||
employer_liability_amount | 16.2 | BigDecimal | |
employer_liability_amount_c | 3 | String | |
employer_liability_amount_d | 19 | Date | |
employer_liability_amount_n | 16.2 | BigDecimal | |
employer_liability_amount_r | 8.4 | BigDecimal | |
employer_liability_date | 10 | Date | |
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 | |
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 | 8.4 | BigDecimal | |
general_liab_expire_date | 10 | Date | |
general_liability_amount | 16.2 | BigDecimal | |
general_liability_amount_c | 3 | String | |
general_liability_amount_d | 19 | Date | |
general_liability_amount_n | 16.2 | BigDecimal | |
general_liability_amount_r | 8.4 | 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 | 8.4 | BigDecimal | |
haz_oos_inspection | 10 | int | |
hazmat_cert_number | 20 | String | |
hazmat_expire_date | 10 | Date | |
hazmat_inspection | 10 | int | |
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_broker | 1 | String | |
is_certified | 1 | String | |
is_rail | 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 | 8.4 | 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 | 8.4 | BigDecimal | |
loaded_pay_rate | 12.4 | BigDecimal | |
logo | -1 | byte[] | |
logo_name | 100 | String | |
mark_plan_id | 8 | String | |
mc_payroll_pin | 8 | String | |
mcs_150_date | 19 | Date | |
mcs_150_mileage | 10 | int | |
mcs_150_mileage_yr | 10 | int | |
mileage_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 | 8.4 | 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 | |
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 | |
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_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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | |
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 | 8 | 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 | 8.4 | 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 | 8.4 | BigDecimal | |
team_empty_rate | 12.4 | BigDecimal | |
team_pay_rate | 12.4 | BigDecimal | |
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 | |
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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | 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 | 8.4 | BigDecimal | |
ytd_vacation_hrs | 7.2 | BigDecimal |