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.
<customer company_id="..." id="..." activity_count="..." activity_start_date="..." add_empty_distance_occ="..." add_finance_charge="..." address1="..." address2="..." allow_inc_in_frt="..." auto_rate="..." available_template="..." average_bill="..." average_bill_c="..." average_bill_d="..." average_bill_n="..." average_bill_r="..." average_pay_days="..." balance="..." balance_c="..." balance_d="..." balance_n="..." balance_r="..." benchmark_ctg_uid="..." benchmark_tar_uid="..." bill_due_days="..." bill_format_flag="..." bill_template="..." bill_transfer_when="..." billed_loads="..." bl_logo="..." bl_logo_name="..." bridge_id="..." brokerage_filter="..." business_hours="..." business_number="..." buy_tariff_id="..." category="..." cert_of_ins_date="..." chassis_chargeby="..." chassis_freedays="..." chassis_rate="..." chassis_rate_c="..." chassis_rate_d="..." chassis_rate_n="..." chassis_rate_r="..." city="..." city_id="..." coll_thresh_pd1="..." coll_thresh_pd1_c="..." coll_thresh_pd1_d="..." coll_thresh_pd1_n="..." coll_thresh_pd1_r="..." coll_thresh_pd2="..." coll_thresh_pd2_c="..." coll_thresh_pd2_d="..." coll_thresh_pd2_n="..." coll_thresh_pd2_r="..." coll_thresh_pd3="..." coll_thresh_pd3_c="..." coll_thresh_pd3_d="..." coll_thresh_pd3_n="..." coll_thresh_pd3_r="..." coll_thresh_pd4="..." coll_thresh_pd4_c="..." coll_thresh_pd4_d="..." coll_thresh_pd4_n="..." coll_thresh_pd4_r="..." collections_id="..." collections_ok="..." confidence_level="..." container_chargeby="..." container_freedays="..." container_rate="..." container_rate_c="..." container_rate_d="..." container_rate_n="..." container_rate_r="..." contract_cbc="..." contract_ccc="..." contract_gbc="..." contract_gcc="..." contract_sbc="..." contract_scc="..." controlling_carrier_code="..." conversion_date="..." cost_ctg_uid="..." cost_tar_uid="..." covered_template="..." cp_logo="..." cp_logo_name="..." credit_application="..." credit_check_date="..." credit_limit="..." credit_limit_c="..." credit_limit_d="..." credit_limit_n="..." credit_limit_r="..." credit_status="..." credit_warning_pct="..." ctg_uid="..." currency_type="..." cust_stmt_template="..." d_and_b_code="..." d_and_b_date="..." d_and_b_number="..." days_between_calls="..." deadhead_target="..." ded_last_fixed_cost_billdt="..." dedicated_cycle="..." dedicated_revenue_code_id="..." dedicated_seg_alloc_code="..." dedicated_start_day="..." dedicated_template="..." delivered_template="..." departure_date_at="..." distance_method="..." distance_profile="..." distance_source="..." distance_type="..." dot_number="..." driver_load="..." empty_distance_charge_id="..." empty_distance_rate="..." enforce_dep_dates="..." entered_date="..." excise_taxable="..." expected_close="..." factor_percent="..." factor_receivables="..." factoring_id="..." fak_profile_id="..." fourkites_customer_id="..." fuel_amount="..." fuel_base_price="..." fuel_credit="..." fuel_method="..." fuel_percent="..." fuel_price_region="..." fuel_surcharge_id="..." fuel_surchg_enddt="..." fuel_surchg_strtdt="..." fuel_variance="..." google_place_id="..." gp_exclude="..." gp_exported="..." grace_period="..." high_balance="..." high_balance_c="..." high_balance_d="..." high_balance_n="..." high_balance_r="..." include_by_date="..." include_empty_distance="..." include_fuel_surcharge="..." include_split_point="..." is_active="..." is_consignee="..." is_distribution_center="..." is_drop_yard="..." is_geocoded="..." is_pallets_required="..." is_shipper="..." is_trailer_pool_required="..." jaguar_id="..." last_bill_date="..." last_fin_charge_dt="..." last_pay_date="..." last_ship_date="..." latitude="..." location_id="..." longitude="..." macropoint_requestor_id="..." main_phone="..." manual_exchange="..." mark_plan_id="..." max_pay_percent="..." misc_bill_template="..." monthly_order_goal="..." motor_carrier_id="..." name="..." next_call_date="..." next_rec_call="..." nxt_action_code_id="..." nxt_action_date="..." of_billing_code="..." operations_user="..." order_count="..." order_detail_at="..." order_start_date="..." paid_loads="..." pay_days_date="..." pay_days_orders="..." payee_id="..." pd0_alert="..." pd1_np_auto="..." pd1_sp_auto="..." pd1_sp_thresh="..." pd1_sp_thresh_c="..." pd1_sp_thresh_d="..." pd1_sp_thresh_n="..." pd1_sp_thresh_r="..." pd2_np_auto="..." pd2_sp_auto="..." pd2_sp_thresh="..." pd2_sp_thresh_c="..." pd2_sp_thresh_d="..." pd2_sp_thresh_n="..." pd2_sp_thresh_r="..." pd3_np_auto="..." pd3_sp_auto="..." pd3_sp_thresh="..." pd3_sp_thresh_c="..." pd3_sp_thresh_d="..." pd3_sp_thresh_n="..." pd3_sp_thresh_r="..." pd4_np_auto="..." pd4_sp_auto="..." pd4_sp_thresh="..." pd4_sp_thresh_c="..." pd4_sp_thresh_d="..." pd4_sp_thresh_n="..." pd4_sp_thresh_r="..." plc_uid="..." post_summary_dtl="..." potential="..." potential_c="..." potential_d="..." potential_n="..." potential_r="..." prev_code="..." primary_agency="..." primary_commodity_id="..." primary_contact="..." primary_sort="..." primary_trailer_type="..." print_containers="..." progress_template="..." prospect_type_id="..." quebec_number="..." rate_override_nmfc_code="..." reassign_profile_id="..." rec_call_days="..." remarks="..." revenue="..." revenue_c="..." revenue_d="..." revenue_n="..." revenue_r="..." revenue_start_date="..." sales_manager_id="..." sales_status_id="..." salesperson_id="..." search_city="..." search_state_id="..." search_zip_code="..." secondary_sort="..." seg_alloc_code="..." sell_tariff_id="..." service_fail_cons="..." service_fail_drop="..." service_fail_pick="..." service_fail_ship="..." service_failures="..." sic_code="..." start_date="..." state_id="..." summary_billing="..." summary_template="..." tar_uid="..." target_profit="..." tenfour_customer_id="..." type_of="..." use_local_mile="..." vm_part_update="..." website_url="..." zip_code="..." zone_id="..."/>
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":"customer","company_id":"...","id":"...","activity_count":"...","activity_start_date":"...","add_empty_distance_occ":"...","add_finance_charge":"...","address1":"...","address2":"...","allow_inc_in_frt":"...","auto_rate":"...","available_template":"...","average_bill":"...","average_bill_c":"...","average_bill_d":"...","average_bill_n":"...","average_bill_r":"...","average_pay_days":"...","balance":"...","balance_c":"...","balance_d":"...","balance_n":"...","balance_r":"...","benchmark_ctg_uid":"...","benchmark_tar_uid":"...","bill_due_days":"...","bill_format_flag":"...","bill_template":"...","bill_transfer_when":"...","billed_loads":"...","bl_logo":"...","bl_logo_name":"...","bridge_id":"...","brokerage_filter":"...","business_hours":"...","business_number":"...","buy_tariff_id":"...","category":"...","cert_of_ins_date":"...","chassis_chargeby":"...","chassis_freedays":"...","chassis_rate":"...","chassis_rate_c":"...","chassis_rate_d":"...","chassis_rate_n":"...","chassis_rate_r":"...","city":"...","city_id":"...","coll_thresh_pd1":"...","coll_thresh_pd1_c":"...","coll_thresh_pd1_d":"...","coll_thresh_pd1_n":"...","coll_thresh_pd1_r":"...","coll_thresh_pd2":"...","coll_thresh_pd2_c":"...","coll_thresh_pd2_d":"...","coll_thresh_pd2_n":"...","coll_thresh_pd2_r":"...","coll_thresh_pd3":"...","coll_thresh_pd3_c":"...","coll_thresh_pd3_d":"...","coll_thresh_pd3_n":"...","coll_thresh_pd3_r":"...","coll_thresh_pd4":"...","coll_thresh_pd4_c":"...","coll_thresh_pd4_d":"...","coll_thresh_pd4_n":"...","coll_thresh_pd4_r":"...","collections_id":"...","collections_ok":"...","confidence_level":"...","container_chargeby":"...","container_freedays":"...","container_rate":"...","container_rate_c":"...","container_rate_d":"...","container_rate_n":"...","container_rate_r":"...","contract_cbc":"...","contract_ccc":"...","contract_gbc":"...","contract_gcc":"...","contract_sbc":"...","contract_scc":"...","controlling_carrier_code":"...","conversion_date":"...","cost_ctg_uid":"...","cost_tar_uid":"...","covered_template":"...","cp_logo":"...","cp_logo_name":"...","credit_application":"...","credit_check_date":"...","credit_limit":"...","credit_limit_c":"...","credit_limit_d":"...","credit_limit_n":"...","credit_limit_r":"...","credit_status":"...","credit_warning_pct":"...","ctg_uid":"...","currency_type":"...","cust_stmt_template":"...","d_and_b_code":"...","d_and_b_date":"...","d_and_b_number":"...","days_between_calls":"...","deadhead_target":"...","ded_last_fixed_cost_billdt":"...","dedicated_cycle":"...","dedicated_revenue_code_id":"...","dedicated_seg_alloc_code":"...","dedicated_start_day":"...","dedicated_template":"...","delivered_template":"...","departure_date_at":"...","distance_method":"...","distance_profile":"...","distance_source":"...","distance_type":"...","dot_number":"...","driver_load":"...","empty_distance_charge_id":"...","empty_distance_rate":"...","enforce_dep_dates":"...","entered_date":"...","excise_taxable":"...","expected_close":"...","factor_percent":"...","factor_receivables":"...","factoring_id":"...","fak_profile_id":"...","fourkites_customer_id":"...","fuel_amount":"...","fuel_base_price":"...","fuel_credit":"...","fuel_method":"...","fuel_percent":"...","fuel_price_region":"...","fuel_surcharge_id":"...","fuel_surchg_enddt":"...","fuel_surchg_strtdt":"...","fuel_variance":"...","google_place_id":"...","gp_exclude":"...","gp_exported":"...","grace_period":"...","high_balance":"...","high_balance_c":"...","high_balance_d":"...","high_balance_n":"...","high_balance_r":"...","include_by_date":"...","include_empty_distance":"...","include_fuel_surcharge":"...","include_split_point":"...","is_active":"...","is_consignee":"...","is_distribution_center":"...","is_drop_yard":"...","is_geocoded":"...","is_pallets_required":"...","is_shipper":"...","is_trailer_pool_required":"...","jaguar_id":"...","last_bill_date":"...","last_fin_charge_dt":"...","last_pay_date":"...","last_ship_date":"...","latitude":"...","location_id":"...","longitude":"...","macropoint_requestor_id":"...","main_phone":"...","manual_exchange":"...","mark_plan_id":"...","max_pay_percent":"...","misc_bill_template":"...","monthly_order_goal":"...","motor_carrier_id":"...","name":"...","next_call_date":"...","next_rec_call":"...","nxt_action_code_id":"...","nxt_action_date":"...","of_billing_code":"...","operations_user":"...","order_count":"...","order_detail_at":"...","order_start_date":"...","paid_loads":"...","pay_days_date":"...","pay_days_orders":"...","payee_id":"...","pd0_alert":"...","pd1_np_auto":"...","pd1_sp_auto":"...","pd1_sp_thresh":"...","pd1_sp_thresh_c":"...","pd1_sp_thresh_d":"...","pd1_sp_thresh_n":"...","pd1_sp_thresh_r":"...","pd2_np_auto":"...","pd2_sp_auto":"...","pd2_sp_thresh":"...","pd2_sp_thresh_c":"...","pd2_sp_thresh_d":"...","pd2_sp_thresh_n":"...","pd2_sp_thresh_r":"...","pd3_np_auto":"...","pd3_sp_auto":"...","pd3_sp_thresh":"...","pd3_sp_thresh_c":"...","pd3_sp_thresh_d":"...","pd3_sp_thresh_n":"...","pd3_sp_thresh_r":"...","pd4_np_auto":"...","pd4_sp_auto":"...","pd4_sp_thresh":"...","pd4_sp_thresh_c":"...","pd4_sp_thresh_d":"...","pd4_sp_thresh_n":"...","pd4_sp_thresh_r":"...","plc_uid":"...","post_summary_dtl":"...","potential":"...","potential_c":"...","potential_d":"...","potential_n":"...","potential_r":"...","prev_code":"...","primary_agency":"...","primary_commodity_id":"...","primary_contact":"...","primary_sort":"...","primary_trailer_type":"...","print_containers":"...","progress_template":"...","prospect_type_id":"...","quebec_number":"...","rate_override_nmfc_code":"...","reassign_profile_id":"...","rec_call_days":"...","remarks":"...","revenue":"...","revenue_c":"...","revenue_d":"...","revenue_n":"...","revenue_r":"...","revenue_start_date":"...","sales_manager_id":"...","sales_status_id":"...","salesperson_id":"...","search_city":"...","search_state_id":"...","search_zip_code":"...","secondary_sort":"...","seg_alloc_code":"...","sell_tariff_id":"...","service_fail_cons":"...","service_fail_drop":"...","service_fail_pick":"...","service_fail_ship":"...","service_failures":"...","sic_code":"...","start_date":"...","state_id":"...","summary_billing":"...","summary_template":"...","tar_uid":"...","target_profit":"...","tenfour_customer_id":"...","type_of":"...","use_local_mile":"...","vm_part_update":"...","website_url":"...","zip_code":"...","zone_id":"..."}
| key | name | size | type |
|---|---|---|---|
| company_id | 4 | String | |
| id | 8 | String | |
| activity_count | 10 | int | |
| activity_start_date | 10 | Date | |
| add_empty_distance_occ | 1 | String | |
| add_finance_charge | 1 | String | |
| address1 | 40 | String | |
| address2 | 40 | String | |
| allow_inc_in_frt | 1 | String | |
| auto_rate | 1 | String | |
| available_template | 10 | int | |
| average_bill | 16.2 | BigDecimal | |
| average_bill_c | 3 | String | |
| average_bill_d | 19 | Date | |
| average_bill_n | 16.2 | BigDecimal | |
| average_bill_r | 8.4 | BigDecimal | |
| average_pay_days | 8.2 | BigDecimal | |
| balance | 16.2 | BigDecimal | |
| balance_c | 3 | String | |
| balance_d | 19 | Date | |
| balance_n | 16.2 | BigDecimal | |
| balance_r | 8.4 | BigDecimal | |
| benchmark_ctg_uid | 10 | int | |
| benchmark_tar_uid | 10 | int | |
| bill_due_days | 10 | int | |
| bill_format_flag | 1 | String | |
| bill_template | 10 | int | |
| bill_transfer_when | 1 | String | |
| billed_loads | 10 | int | |
| bl_logo | -1 | byte[] | |
| bl_logo_name | 100 | String | |
| bridge_id | 8 | String | |
| brokerage_filter | 1 | String | |
| business_hours | 12 | String | |
| business_number | 18 | String | |
| buy_tariff_id | 10 | String | |
| category | 3 | String | |
| cert_of_ins_date | 10 | Date | |
| chassis_chargeby | 1 | String | |
| chassis_freedays | 10 | int | |
| chassis_rate | 16.2 | BigDecimal | |
| chassis_rate_c | 3 | String | |
| chassis_rate_d | 19 | Date | |
| chassis_rate_n | 16.2 | BigDecimal | |
| chassis_rate_r | 8.4 | BigDecimal | |
| city | 50 | String | |
| city_id | 10 | int | |
| coll_thresh_pd1 | 16.2 | BigDecimal | |
| coll_thresh_pd1_c | 3 | String | |
| coll_thresh_pd1_d | 19 | Date | |
| coll_thresh_pd1_n | 16.2 | BigDecimal | |
| coll_thresh_pd1_r | 8.4 | BigDecimal | |
| coll_thresh_pd2 | 16.2 | BigDecimal | |
| coll_thresh_pd2_c | 3 | String | |
| coll_thresh_pd2_d | 19 | Date | |
| coll_thresh_pd2_n | 16.2 | BigDecimal | |
| coll_thresh_pd2_r | 8.4 | BigDecimal | |
| coll_thresh_pd3 | 16.2 | BigDecimal | |
| coll_thresh_pd3_c | 3 | String | |
| coll_thresh_pd3_d | 19 | Date | |
| coll_thresh_pd3_n | 16.2 | BigDecimal | |
| coll_thresh_pd3_r | 8.4 | BigDecimal | |
| coll_thresh_pd4 | 16.2 | BigDecimal | |
| coll_thresh_pd4_c | 3 | String | |
| coll_thresh_pd4_d | 19 | Date | |
| coll_thresh_pd4_n | 16.2 | BigDecimal | |
| coll_thresh_pd4_r | 8.4 | BigDecimal | |
| collections_id | 10 | String | |
| collections_ok | 1 | String | |
| confidence_level | 6.2 | BigDecimal | |
| container_chargeby | 1 | String | |
| container_freedays | 10 | int | |
| container_rate | 16.2 | BigDecimal | |
| container_rate_c | 3 | String | |
| container_rate_d | 19 | Date | |
| container_rate_n | 16.2 | BigDecimal | |
| container_rate_r | 8.4 | BigDecimal | |
| contract_cbc | 1 | String | |
| contract_ccc | 1 | String | |
| contract_gbc | 1 | String | |
| contract_gcc | 1 | String | |
| contract_sbc | 1 | String | |
| contract_scc | 1 | String | |
| controlling_carrier_code | 8 | String | |
| conversion_date | 10 | Date | |
| cost_ctg_uid | 10 | int | |
| cost_tar_uid | 10 | int | |
| covered_template | 10 | int | |
| cp_logo | -1 | byte[] | |
| cp_logo_name | 100 | String | |
| credit_application | 1 | String | |
| credit_check_date | 10 | Date | |
| credit_limit | 16.2 | BigDecimal | |
| credit_limit_c | 3 | String | |
| credit_limit_d | 19 | Date | |
| credit_limit_n | 16.2 | BigDecimal | |
| credit_limit_r | 8.4 | BigDecimal | |
| credit_status | 1 | String | |
| credit_warning_pct | 5.2 | BigDecimal | |
| ctg_uid | 10 | int | |
| currency_type | 3 | String | |
| cust_stmt_template | 10 | int | |
| d_and_b_code | 10 | String | |
| d_and_b_date | 10 | Date | |
| d_and_b_number | 20 | String | |
| days_between_calls | 10 | int | |
| deadhead_target | 5.2 | BigDecimal | |
| ded_last_fixed_cost_billdt | 10 | Date | |
| dedicated_cycle | 2 | String | |
| dedicated_revenue_code_id | 5 | String | |
| dedicated_seg_alloc_code | 8 | String | |
| dedicated_start_day | 1 | String | |
| dedicated_template | 10 | int | |
| delivered_template | 10 | int | |
| departure_date_at | 1 | String | |
| distance_method | 1 | String | |
| distance_profile | 8 | String | |
| distance_source | 1 | String | |
| distance_type | 1 | String | |
| dot_number | 10 | String | |
| driver_load | 8 | String | |
| empty_distance_charge_id | 4 | String | |
| empty_distance_rate | 12.4 | BigDecimal | |
| enforce_dep_dates | 1 | String | |
| entered_date | 10 | Date | |
| excise_taxable | 1 | String | |
| expected_close | 10 | Date | |
| factor_percent | 6.2 | BigDecimal | |
| factor_receivables | 1 | String | |
| factoring_id | 8 | String | |
| fak_profile_id | 8 | String | |
| fourkites_customer_id | 20 | String | |
| fuel_amount | 16.3 | BigDecimal | |
| fuel_base_price | 16.3 | BigDecimal | |
| fuel_credit | 1 | String | |
| fuel_method | 1 | String | |
| fuel_percent | 6.2 | BigDecimal | |
| fuel_price_region | 1 | String | |
| fuel_surcharge_id | 4 | String | |
| fuel_surchg_enddt | 10 | Date | |
| fuel_surchg_strtdt | 10 | Date | |
| fuel_variance | 16.3 | BigDecimal | |
| google_place_id | 60 | String | |
| gp_exclude | 1 | String | |
| gp_exported | 19 | Date | |
| grace_period | 10 | int | |
| high_balance | 16.2 | BigDecimal | |
| high_balance_c | 3 | String | |
| high_balance_d | 19 | Date | |
| high_balance_n | 16.2 | BigDecimal | |
| high_balance_r | 8.4 | BigDecimal | |
| include_by_date | 1 | String | |
| include_empty_distance | 1 | String | |
| include_fuel_surcharge | 1 | String | |
| include_split_point | 1 | String | |
| is_active | 1 | String | |
| is_consignee | 1 | String | |
| is_distribution_center | 1 | String | |
| is_drop_yard | 1 | String | |
| is_geocoded | 1 | String | |
| is_pallets_required | 1 | String | |
| is_shipper | 1 | String | |
| is_trailer_pool_required | 1 | String | |
| jaguar_id | 10 | int | |
| last_bill_date | 10 | Date | |
| last_fin_charge_dt | 10 | Date | |
| last_pay_date | 10 | Date | |
| last_ship_date | 10 | Date | |
| latitude | 10.6 | BigDecimal | |
| location_id | 8 | String | |
| longitude | 10.6 | BigDecimal | |
| macropoint_requestor_id | 20 | String | |
| main_phone | 20 | String | |
| manual_exchange | 1 | String | |
| mark_plan_id | 8 | String | |
| max_pay_percent | 6.2 | BigDecimal | |
| misc_bill_template | 10 | int | |
| monthly_order_goal | 10 | int | |
| motor_carrier_id | 8 | String | |
| name | 40 | String | |
| next_call_date | 10 | Date | |
| next_rec_call | 10 | Date | |
| nxt_action_code_id | 3 | String | |
| nxt_action_date | 10 | Date | |
| of_billing_code | 20 | String | |
| operations_user | 10 | String | |
| order_count | 10 | int | |
| order_detail_at | 1 | String | |
| order_start_date | 10 | Date | |
| paid_loads | 10 | int | |
| pay_days_date | 10 | Date | |
| pay_days_orders | 10 | int | |
| payee_id | 8 | String | |
| pd0_alert | 10 | int | |
| pd1_np_auto | 1 | String | |
| pd1_sp_auto | 1 | String | |
| pd1_sp_thresh | 16.2 | BigDecimal | |
| pd1_sp_thresh_c | 3 | String | |
| pd1_sp_thresh_d | 19 | Date | |
| pd1_sp_thresh_n | 16.2 | BigDecimal | |
| pd1_sp_thresh_r | 8.4 | BigDecimal | |
| pd2_np_auto | 1 | String | |
| pd2_sp_auto | 1 | String | |
| pd2_sp_thresh | 16.2 | BigDecimal | |
| pd2_sp_thresh_c | 3 | String | |
| pd2_sp_thresh_d | 19 | Date | |
| pd2_sp_thresh_n | 16.2 | BigDecimal | |
| pd2_sp_thresh_r | 8.4 | BigDecimal | |
| pd3_np_auto | 1 | String | |
| pd3_sp_auto | 1 | String | |
| pd3_sp_thresh | 16.2 | BigDecimal | |
| pd3_sp_thresh_c | 3 | String | |
| pd3_sp_thresh_d | 19 | Date | |
| pd3_sp_thresh_n | 16.2 | BigDecimal | |
| pd3_sp_thresh_r | 8.4 | BigDecimal | |
| pd4_np_auto | 1 | String | |
| pd4_sp_auto | 1 | String | |
| pd4_sp_thresh | 16.2 | BigDecimal | |
| pd4_sp_thresh_c | 3 | String | |
| pd4_sp_thresh_d | 19 | Date | |
| pd4_sp_thresh_n | 16.2 | BigDecimal | |
| pd4_sp_thresh_r | 8.4 | BigDecimal | |
| plc_uid | 10 | int | |
| post_summary_dtl | 1 | String | |
| potential | 16.2 | BigDecimal | |
| potential_c | 3 | String | |
| potential_d | 19 | Date | |
| potential_n | 16.2 | BigDecimal | |
| potential_r | 8.4 | BigDecimal | |
| prev_code | 16 | String | |
| primary_agency | 8 | String | |
| primary_commodity_id | 9 | String | |
| primary_contact | 28 | String | |
| primary_sort | 1 | String | |
| primary_trailer_type | 4 | String | |
| print_containers | 1 | String | |
| progress_template | 10 | int | |
| prospect_type_id | 8 | String | |
| quebec_number | 18 | String | |
| rate_override_nmfc_code | 4 | String | |
| reassign_profile_id | 8 | String | |
| rec_call_days | 10 | int | |
| remarks | -1 | String | |
| revenue | 10.2 | BigDecimal | |
| revenue_c | 3 | String | |
| revenue_d | 19 | Date | |
| revenue_n | 16.2 | BigDecimal | |
| revenue_r | 8.4 | BigDecimal | |
| revenue_start_date | 10 | Date | |
| sales_manager_id | 10 | String | |
| sales_status_id | 8 | String | |
| salesperson_id | 8 | String | |
| search_city | 50 | String | |
| search_state_id | 2 | String | |
| search_zip_code | 10 | String | |
| secondary_sort | 1 | String | |
| seg_alloc_code | 8 | String | |
| sell_tariff_id | 10 | String | |
| service_fail_cons | 1 | String | |
| service_fail_drop | 1 | String | |
| service_fail_pick | 1 | String | |
| service_fail_ship | 1 | String | |
| service_failures | 1 | String | |
| sic_code | 4 | String | |
| start_date | 10 | Date | |
| state_id | 2 | String | |
| summary_billing | 1 | String | |
| summary_template | 10 | int | |
| tar_uid | 10 | int | |
| target_profit | 6.2 | BigDecimal | |
| tenfour_customer_id | 20 | String | |
| type_of | 1 | String | |
| use_local_mile | 1 | String | |
| vm_part_update | 1 | String | |
| website_url | 60 | String | |
| zip_code | 10 | String | |
| zone_id | 3 | String |