go back Home

RowCustomer

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.

<customer company_id="..." id="..." accept_reject="..." activity_count="..." activity_start_date="..." add_empty_distance_occ="..." add_finance_charge="..." address1="..." address2="..." allow_inc_in_frt="..." alt_salesperson_id="..." am_group="..." annual_revenue="..." annual_revenue1="..." annual_revenue1_c="..." annual_revenue1_d="..." annual_revenue1_n="..." annual_revenue1_r="..." annual_revenue_c="..." annual_revenue_d="..." annual_revenue_n="..." annual_revenue_r="..." api_fail="..." auto_rate="..." available_template="..." average_bill="..." average_bill_c="..." average_bill_d="..." average_bill_n="..." average_bill_r="..." average_pay_days="..." back_solicit_start_date="..." back_solicitation_percent="..." 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="..." billing_location="..." bl_logo="..." bl_logo_name="..." bounty_paid_date="..." bridge_id="..." brokerage_filter="..." business_hours="..." business_number="..." buy_tariff_id="..." cannot_edit_cover="..." category="..." cert_of_ins_date="..." charge_detention="..." 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="..." conference="..." 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="..." cover_id_checked="..." covered_template="..." cp_logo="..." cp_logo_name="..." cr_pending="..." credit_application="..." credit_bot_notified="..." credit_cargo="..." credit_check_date="..." credit_denied_reason="..." credit_limit="..." credit_limit_c="..." credit_limit_d="..." credit_limit_n="..." credit_limit_r="..." credit_request="..." credit_request_date="..." credit_request_status="..." 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="..." debtor_id="..." 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="..." distribution_email="..." dot_number="..." driver_load="..." edi_210_required="..." edi_214_required="..." edi_start="..." employeecount="..." empty_distance_charge_id="..." empty_distance_rate="..." enable_notifications="..." enforce_dep_dates="..." entered_date="..." euler_cover_id="..." euler_credit_limit="..." euler_credit_limit_c="..." euler_credit_limit_d="..." euler_credit_limit_date="..." euler_credit_limit_n="..." euler_credit_limit_r="..." euler_id="..." euler_id_accurate="..." euler_id_date="..." euler_job_url="..." euler_reduction_job_url="..." euler_scrub_notified="..." excise_taxable="..." exempt_from_write_offs="..." expected_close="..." ext_eligibility_request_dt="..." extend_rates="..." extended_eligibility="..." factor_percent="..." factor_receivables="..." factoring_id="..." fak_profile_id="..." fourkites_customer_id="..." freight_forwarder="..." 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="..." global_detention="..." google_place_id="..." gp_exclude="..." gp_exported="..." grace_period="..." headquarters="..." high_balance="..." high_balance_c="..." high_balance_d="..." high_balance_n="..." high_balance_r="..." hot_prospect="..." import_batch="..." include_by_date="..." include_empty_distance="..." include_fuel_surcharge="..." include_split_point="..." industry="..." ineligible_cross_age="..." insurance_required="..." insurance_type_required="..." is_active="..." is_consignee="..." is_distribution_center="..." is_drop_yard="..." is_geocoded="..." is_pallets_required="..." is_shipper="..." is_trailer_pool_required="..." jaguar_id="..." last_ap_reminder_date="..." last_bill_date="..." last_customer_statement="..." last_euler_request="..." last_fin_charge_dt="..." last_notified_salesperson="..." last_pay_date="..." last_ship_date="..." latitude="..." lead_import_date="..." load_count="..." load_posting_disabled="..." location_id="..." longitude="..." ltl_code="..." lumper_bot_opt_out="..." macropoint_requestor_id="..." main_phone="..." manual_exchange="..." mark_plan_id="..." max_pay_percent="..." misc_bill_template="..." monthly_customer_statements="..." monthly_order_goal="..." motor_carrier_id="..." name="..." needs_modified="..." new_customer="..." next_call_date="..." next_rec_call="..." next_rfp_date="..." no_ap_contact="..." no_customer_statement="..." notification="..." notify_salesperson="..." nxt_action_code_id="..." nxt_action_date="..." operations_user="..." ops_account="..." ops_account_override="..." opt_out_customer_statement="..." order_count="..." order_detail_at="..." order_start_date="..." original_credit_check_date="..." outsidesales_assign_by="..." outsidesales_id="..." p44_profile_id="..." p44_tracking_required="..." 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="..." pending_euler_job_reduction="..." 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_import_line_1="..." prospect_import_line_2="..." prospect_import_line_3="..." prospect_import_line_4="..." prospect_import_line_5="..." prospect_import_line_6="..." prospect_import_line_7="..." prospect_import_line_8="..." prospect_type_id="..." quebec_number="..." quickpay_deadline="..." quickpay_discount_perecent="..." quote_days_to_expire="..." rate_override_nmfc_code="..." reassign_profile_id="..." rec_call_days="..." referral="..." referral_carrier_rep="..." referral_date="..." referral_partner="..." reject_timer_minutes="..." remarks="..." remove_customer="..." revenue="..." revenue_c="..." revenue_d="..." revenue_n="..." revenue_r="..." revenue_range="..." revenue_start_date="..." review_date="..." sales_manager_id="..." sales_status_id="..." salesforce_link="..." salesforceid="..." salesperson_assign_date="..." salesperson_id="..." salesperson_salesforce_id="..." search_city="..." search_state_id="..." search_zip_code="..." seccondary_sales_rep="..." secondary_sort="..." segment="..." sell_tariff_id="..." service_fail_cons="..." service_fail_drop="..." service_fail_pick="..." service_fail_ship="..." service_failures="..." service_failures_review="..." sheer_branch_manager="..." sheer_create_date="..." sheer_credit_date="..." sheer_credit_limit="..." sheer_credit_limit_c="..." sheer_credit_limit_d="..." sheer_credit_limit_n="..." sheer_credit_limit_r="..." sheer_customer="..." sheer_oid="..." sheer_rate_total="..." sheer_sales_director="..." sheer_sales_executive="..." sic_code="..." spreadsheet_statement="..." sql_test="..." start_date="..." state_id="..." sub_industry="..." summary_billing="..." summary_template="..." tar_uid="..." target_profit="..." tenfour_customer_id="..." tentative_checking="..." tentative_credit_check_date="..." terms_verified="..." test="..." type_of="..." use_local_mile="..." vm_part_update="..." website_url="..." wf_bwop="..." wf_queue="..." wintrust_credit_limit="..." wintrust_credit_limit_c="..." wintrust_credit_limit_d="..." wintrust_credit_limit_date="..." wintrust_credit_limit_n="..." wintrust_credit_limit_r="..." zip_code="..." zone_id="..." zoom_attempt_date="..." zoom_fixed_date="..." zoom_id_by_bot="..." zoominfo_id="..." zoominfo_id_checked="..." zoominfo_import_date="..." zoominfo_modified_date="..."/>

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":"customer","company_id":"...","id":"...","accept_reject":"...","activity_count":"...","activity_start_date":"...","add_empty_distance_occ":"...","add_finance_charge":"...","address1":"...","address2":"...","allow_inc_in_frt":"...","alt_salesperson_id":"...","am_group":"...","annual_revenue":"...","annual_revenue1":"...","annual_revenue1_c":"...","annual_revenue1_d":"...","annual_revenue1_n":"...","annual_revenue1_r":"...","annual_revenue_c":"...","annual_revenue_d":"...","annual_revenue_n":"...","annual_revenue_r":"...","api_fail":"...","auto_rate":"...","available_template":"...","average_bill":"...","average_bill_c":"...","average_bill_d":"...","average_bill_n":"...","average_bill_r":"...","average_pay_days":"...","back_solicit_start_date":"...","back_solicitation_percent":"...","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":"...","billing_location":"...","bl_logo":"...","bl_logo_name":"...","bounty_paid_date":"...","bridge_id":"...","brokerage_filter":"...","business_hours":"...","business_number":"...","buy_tariff_id":"...","cannot_edit_cover":"...","category":"...","cert_of_ins_date":"...","charge_detention":"...","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":"...","conference":"...","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":"...","cover_id_checked":"...","covered_template":"...","cp_logo":"...","cp_logo_name":"...","cr_pending":"...","credit_application":"...","credit_bot_notified":"...","credit_cargo":"...","credit_check_date":"...","credit_denied_reason":"...","credit_limit":"...","credit_limit_c":"...","credit_limit_d":"...","credit_limit_n":"...","credit_limit_r":"...","credit_request":"...","credit_request_date":"...","credit_request_status":"...","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":"...","debtor_id":"...","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":"...","distribution_email":"...","dot_number":"...","driver_load":"...","edi_210_required":"...","edi_214_required":"...","edi_start":"...","employeecount":"...","empty_distance_charge_id":"...","empty_distance_rate":"...","enable_notifications":"...","enforce_dep_dates":"...","entered_date":"...","euler_cover_id":"...","euler_credit_limit":"...","euler_credit_limit_c":"...","euler_credit_limit_d":"...","euler_credit_limit_date":"...","euler_credit_limit_n":"...","euler_credit_limit_r":"...","euler_id":"...","euler_id_accurate":"...","euler_id_date":"...","euler_job_url":"...","euler_reduction_job_url":"...","euler_scrub_notified":"...","excise_taxable":"...","exempt_from_write_offs":"...","expected_close":"...","ext_eligibility_request_dt":"...","extend_rates":"...","extended_eligibility":"...","factor_percent":"...","factor_receivables":"...","factoring_id":"...","fak_profile_id":"...","fourkites_customer_id":"...","freight_forwarder":"...","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":"...","global_detention":"...","google_place_id":"...","gp_exclude":"...","gp_exported":"...","grace_period":"...","headquarters":"...","high_balance":"...","high_balance_c":"...","high_balance_d":"...","high_balance_n":"...","high_balance_r":"...","hot_prospect":"...","import_batch":"...","include_by_date":"...","include_empty_distance":"...","include_fuel_surcharge":"...","include_split_point":"...","industry":"...","ineligible_cross_age":"...","insurance_required":"...","insurance_type_required":"...","is_active":"...","is_consignee":"...","is_distribution_center":"...","is_drop_yard":"...","is_geocoded":"...","is_pallets_required":"...","is_shipper":"...","is_trailer_pool_required":"...","jaguar_id":"...","last_ap_reminder_date":"...","last_bill_date":"...","last_customer_statement":"...","last_euler_request":"...","last_fin_charge_dt":"...","last_notified_salesperson":"...","last_pay_date":"...","last_ship_date":"...","latitude":"...","lead_import_date":"...","load_count":"...","load_posting_disabled":"...","location_id":"...","longitude":"...","ltl_code":"...","lumper_bot_opt_out":"...","macropoint_requestor_id":"...","main_phone":"...","manual_exchange":"...","mark_plan_id":"...","max_pay_percent":"...","misc_bill_template":"...","monthly_customer_statements":"...","monthly_order_goal":"...","motor_carrier_id":"...","name":"...","needs_modified":"...","new_customer":"...","next_call_date":"...","next_rec_call":"...","next_rfp_date":"...","no_ap_contact":"...","no_customer_statement":"...","notification":"...","notify_salesperson":"...","nxt_action_code_id":"...","nxt_action_date":"...","operations_user":"...","ops_account":"...","ops_account_override":"...","opt_out_customer_statement":"...","order_count":"...","order_detail_at":"...","order_start_date":"...","original_credit_check_date":"...","outsidesales_assign_by":"...","outsidesales_id":"...","p44_profile_id":"...","p44_tracking_required":"...","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":"...","pending_euler_job_reduction":"...","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_import_line_1":"...","prospect_import_line_2":"...","prospect_import_line_3":"...","prospect_import_line_4":"...","prospect_import_line_5":"...","prospect_import_line_6":"...","prospect_import_line_7":"...","prospect_import_line_8":"...","prospect_type_id":"...","quebec_number":"...","quickpay_deadline":"...","quickpay_discount_perecent":"...","quote_days_to_expire":"...","rate_override_nmfc_code":"...","reassign_profile_id":"...","rec_call_days":"...","referral":"...","referral_carrier_rep":"...","referral_date":"...","referral_partner":"...","reject_timer_minutes":"...","remarks":"...","remove_customer":"...","revenue":"...","revenue_c":"...","revenue_d":"...","revenue_n":"...","revenue_r":"...","revenue_range":"...","revenue_start_date":"...","review_date":"...","sales_manager_id":"...","sales_status_id":"...","salesforce_link":"...","salesforceid":"...","salesperson_assign_date":"...","salesperson_id":"...","salesperson_salesforce_id":"...","search_city":"...","search_state_id":"...","search_zip_code":"...","seccondary_sales_rep":"...","secondary_sort":"...","segment":"...","sell_tariff_id":"...","service_fail_cons":"...","service_fail_drop":"...","service_fail_pick":"...","service_fail_ship":"...","service_failures":"...","service_failures_review":"...","sheer_branch_manager":"...","sheer_create_date":"...","sheer_credit_date":"...","sheer_credit_limit":"...","sheer_credit_limit_c":"...","sheer_credit_limit_d":"...","sheer_credit_limit_n":"...","sheer_credit_limit_r":"...","sheer_customer":"...","sheer_oid":"...","sheer_rate_total":"...","sheer_sales_director":"...","sheer_sales_executive":"...","sic_code":"...","spreadsheet_statement":"...","sql_test":"...","start_date":"...","state_id":"...","sub_industry":"...","summary_billing":"...","summary_template":"...","tar_uid":"...","target_profit":"...","tenfour_customer_id":"...","tentative_checking":"...","tentative_credit_check_date":"...","terms_verified":"...","test":"...","type_of":"...","use_local_mile":"...","vm_part_update":"...","website_url":"...","wf_bwop":"...","wf_queue":"...","wintrust_credit_limit":"...","wintrust_credit_limit_c":"...","wintrust_credit_limit_d":"...","wintrust_credit_limit_date":"...","wintrust_credit_limit_n":"...","wintrust_credit_limit_r":"...","zip_code":"...","zone_id":"...","zoom_attempt_date":"...","zoom_fixed_date":"...","zoom_id_by_bot":"...","zoominfo_id":"...","zoominfo_id_checked":"...","zoominfo_import_date":"...","zoominfo_modified_date":"..."}

Fields

key name size type
company_id 4 String
id 8 String
accept_reject 1 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
alt_salesperson_id 8 String
am_group 200 String
annual_revenue 30 String
annual_revenue1 16.2 BigDecimal
annual_revenue1_c 3 String
annual_revenue1_d 19 Date
annual_revenue1_n 16.2 BigDecimal
annual_revenue1_r 8.4 BigDecimal
annual_revenue_c 3 String
annual_revenue_d 19 Date
annual_revenue_n 16.2 BigDecimal
annual_revenue_r 8.4 BigDecimal
api_fail 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
back_solicit_start_date 10 Date
back_solicitation_percent 4.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
billing_location 1 String
bl_logo -1 byte[]
bl_logo_name 100 String
bounty_paid_date 10 Date
bridge_id 8 String
brokerage_filter 1 String
business_hours 12 String
business_number 18 String
buy_tariff_id 10 String
cannot_edit_cover 1 String
category 3 String
cert_of_ins_date 10 Date
charge_detention 1 String
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
conference 75 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
cover_id_checked 1 String
covered_template 10 int
cp_logo -1 byte[]
cp_logo_name 100 String
cr_pending 1 String
credit_application 1 String
credit_bot_notified 1 String
credit_cargo 1 String
credit_check_date 19 Date
credit_denied_reason 90 String
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_request 1 String
credit_request_date 19 Date
credit_request_status 40 String
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
debtor_id 120 String
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
distribution_email 50 String
dot_number 10 String
driver_load 8 String
edi_210_required 1 String
edi_214_required 1 String
edi_start 19 Date
employeecount 30 String
empty_distance_charge_id 4 String
empty_distance_rate 12.4 BigDecimal
enable_notifications 1 String
enforce_dep_dates 1 String
entered_date 10 Date
euler_cover_id 100 String
euler_credit_limit 16.2 BigDecimal
euler_credit_limit_c 3 String
euler_credit_limit_d 19 Date
euler_credit_limit_date 10 Date
euler_credit_limit_n 16.2 BigDecimal
euler_credit_limit_r 8.4 BigDecimal
euler_id 20 String
euler_id_accurate 1 String
euler_id_date 10 Date
euler_job_url 60 String
euler_reduction_job_url 100 String
euler_scrub_notified 1 String
excise_taxable 1 String
exempt_from_write_offs 1 String
expected_close 10 Date
ext_eligibility_request_dt 10 Date
extend_rates 1 String
extended_eligibility 10 int
factor_percent 6.2 BigDecimal
factor_receivables 1 String
factoring_id 8 String
fak_profile_id 8 String
fourkites_customer_id 20 String
freight_forwarder 1 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
global_detention 1 String
google_place_id 60 String
gp_exclude 1 String
gp_exported 19 Date
grace_period 10 int
headquarters 1 String
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
hot_prospect 1 String
import_batch 100 String
include_by_date 1 String
include_empty_distance 1 String
include_fuel_surcharge 1 String
include_split_point 1 String
industry 60 String
ineligible_cross_age 1 String
insurance_required 10 int
insurance_type_required 20 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_ap_reminder_date 10 Date
last_bill_date 10 Date
last_customer_statement 10 Date
last_euler_request 50 String
last_fin_charge_dt 10 Date
last_notified_salesperson 30 String
last_pay_date 10 Date
last_ship_date 10 Date
latitude 10.6 BigDecimal
lead_import_date 10 Date
load_count 10 int
load_posting_disabled 1 String
location_id 8 String
longitude 10.6 BigDecimal
ltl_code 80 String
lumper_bot_opt_out 1 String
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_customer_statements 1 String
monthly_order_goal 10 int
motor_carrier_id 8 String
name 40 String
needs_modified 1 String
new_customer 1 String
next_call_date 10 Date
next_rec_call 10 Date
next_rfp_date 10 Date
no_ap_contact 1 String
no_customer_statement 1 String
notification 10 Date
notify_salesperson 1 String
nxt_action_code_id 3 String
nxt_action_date 10 Date
operations_user 10 String
ops_account 1 String
ops_account_override 1 String
opt_out_customer_statement 1 String
order_count 10 int
order_detail_at 1 String
order_start_date 10 Date
original_credit_check_date 19 Date
outsidesales_assign_by 10 String
outsidesales_id 8 String
p44_profile_id 8 String
p44_tracking_required 1 String
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
pending_euler_job_reduction 1 String
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_import_line_1 300 String
prospect_import_line_2 300 String
prospect_import_line_3 300 String
prospect_import_line_4 300 String
prospect_import_line_5 300 String
prospect_import_line_6 300 String
prospect_import_line_7 300 String
prospect_import_line_8 300 String
prospect_type_id 8 String
quebec_number 18 String
quickpay_deadline 10 int
quickpay_discount_perecent 10 int
quote_days_to_expire 10 int
rate_override_nmfc_code 4 String
reassign_profile_id 8 String
rec_call_days 10 int
referral 10 String
referral_carrier_rep 8 String
referral_date 10 Date
referral_partner 50 String
reject_timer_minutes 10 int
remarks -1 String
remove_customer 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_range 40 String
revenue_start_date 10 Date
review_date 10 Date
sales_manager_id 10 String
sales_status_id 8 String
salesforce_link 500 String
salesforceid 30 String
salesperson_assign_date 10 Date
salesperson_id 8 String
salesperson_salesforce_id 30 String
search_city 50 String
search_state_id 2 String
search_zip_code 10 String
seccondary_sales_rep 200 String
secondary_sort 1 String
segment 200 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
service_failures_review 1 String
sheer_branch_manager 30 String
sheer_create_date 10 Date
sheer_credit_date 10 Date
sheer_credit_limit 16.2 BigDecimal
sheer_credit_limit_c 3 String
sheer_credit_limit_d 19 Date
sheer_credit_limit_n 16.2 BigDecimal
sheer_credit_limit_r 8.4 BigDecimal
sheer_customer 1 String
sheer_oid 30 String
sheer_rate_total 16.2 BigDecimal
sheer_sales_director 30 String
sheer_sales_executive 30 String
sic_code 4 String
spreadsheet_statement 1 String
sql_test 1 String
start_date 10 Date
state_id 2 String
sub_industry 200 String
summary_billing 1 String
summary_template 10 int
tar_uid 10 int
target_profit 6.2 BigDecimal
tenfour_customer_id 20 String
tentative_checking 1 String
tentative_credit_check_date 19 Date
terms_verified 1 String
test 15 String
type_of 1 String
use_local_mile 1 String
vm_part_update 1 String
website_url 60 String
wf_bwop 1 String
wf_queue 10 int
wintrust_credit_limit 16.2 BigDecimal
wintrust_credit_limit_c 3 String
wintrust_credit_limit_d 19 Date
wintrust_credit_limit_date 10 Date
wintrust_credit_limit_n 16.2 BigDecimal
wintrust_credit_limit_r 8.4 BigDecimal
zip_code 10 String
zone_id 3 String
zoom_attempt_date 19 Date
zoom_fixed_date 19 Date
zoom_id_by_bot 1 String
zoominfo_id 15 String
zoominfo_id_checked 1 String
zoominfo_import_date 10 Date
zoominfo_modified_date 10 Date