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 |