RowOrders

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.

<orders company_id="..." id="..." actual_reefer_profile="..." agency_id="..." agent_payee_id="..." allow_relay="..." appt_delay_reason_del="..." appt_delay_reason_pu="..." autorate_status="..." bill_date="..." bill_distance="..." bill_distance_um="..." billing_empty_distance="..." billing_empty_distance_um="..." billing_loaded_distance="..." billing_loaded_distance_um="..." billing_user_id="..." blnum="..." bol_received="..." bol_recv_date="..." booking_no="..." booking_number="..." brk_qual_profile="..." broker_location_id="..." brokerage_workflow_id="..." cbp_crossing_date="..." cbp_crossing_location_id="..." cbp_crossing_reason="..." cbsa_crossing_date="..." cbsa_crossing_location_id="..." cbsa_crossing_reason="..." cc_fuel_revenue="..." cc_fuel_revenue_c="..." cc_fuel_revenue_d="..." cc_fuel_revenue_n="..." cc_fuel_revenue_r="..." cc_net_revenue="..." cc_net_revenue_c="..." cc_net_revenue_d="..." cc_net_revenue_n="..." cc_net_revenue_r="..." cc_pro_nbr="..." channel="..." cobroker_location_id="..." collection_method="..." com_setpnt_temp="..." com_setpnt_temp_um="..." commodity="..." commodity_id="..." consignee_refno="..." consignee_stop_id="..." container="..." container_planned="..." container_type_id="..." controlling_carrier_code="..." copy_from_company="..." copy_from_order_id="..." copy_to_company="..." copy_to_order_id="..." ctrl_party_id="..." cube="..." curr_movement_id="..." cust_order_no="..." customer_id="..." declared_val="..." default_match_id="..." dim_height="..." dim_length="..." dim_surcharge="..." dim_surcharge_c="..." dim_surcharge_d="..." dim_surcharge_n="..." dim_surcharge_r="..." dim_width="..." dispatch_opt="..." dl_team_reqd="..." dray_del_date="..." dray_del_pay="..." dray_del_pay_c="..." dray_del_pay_d="..." dray_del_pay_n="..." dray_del_pay_r="..." dray_del_payee="..." dray_del_xfer_dt="..." dray_pu_date="..." dray_pu_pay="..." dray_pu_pay_c="..." dray_pu_pay_d="..." dray_pu_pay_n="..." dray_pu_pay_r="..." dray_pu_payee="..." dray_pu_xfer_dt="..." eir1_no="..." eir2_no="..." entered_user_id="..." equipment_type_id="..." est_tolls="..." est_tolls_c="..." est_tolls_d="..." est_tolls_n="..." est_tolls_r="..." excise_disable_update="..." excise_taxable="..." excisetax_total="..." excisetax_total_c="..." excisetax_total_d="..." excisetax_total_n="..." excisetax_total_r="..." external_invoiceno="..." extra_deliveries="..." extra_pickups="..." force_assign="..." forwd_location_id="..." free_days="..." freight_charge="..." freight_charge_c="..." freight_charge_d="..." freight_charge_n="..." freight_charge_r="..." hazmat="..." hazmat_code="..." high_value="..." hold_reason="..." image_is_present="..." import_export="..." include_split_point="..." intelliset="..." invoice_recv_date="..." is_autorate_dist="..." is_container="..." is_dedicated="..." is_local_mile="..." is_requested="..." jag_carrier_id="..." jag_cost_rate_id="..." ldport_location_id="..." linear_feet_avail="..." load_date="..." loadboard="..." loadboard_user_id="..." ltl="..." mabd="..." markup_flat="..." markup_flat_c="..." markup_flat_d="..." markup_flat_n="..." markup_flat_r="..." markup_percent="..." master_order_id="..." master_sequence="..." next_rebill="..." nte_lp_num="..." nte_lp_qual="..." of_accrual_ap_amt="..." of_accrual_ar_amt="..." of_accrual_date="..." on_hold="..." operational_status="..." operations_user="..." optiset="..." order_mode="..." order_type_id="..." order_value="..." order_value_c="..." order_value_d="..." order_value_n="..." order_value_r="..." ordered_by="..." ordered_date="..." ordered_method="..." original_invoice_number="..." otherchargetotal="..." otherchargetotal_c="..." otherchargetotal_d="..." otherchargetotal_n="..." otherchargetotal_r="..." pallets_how_many="..." pallets_required="..." pay_gross="..." pay_gross_c="..." pay_gross_d="..." pay_gross_n="..." pay_gross_r="..." pick_up_no="..." pieces="..." placard_required="..." planning_comment="..." pnn_callback="..." pnn_comment="..." pnn_comment2="..." pnn_post_type="..." pnn_rate="..." pnn_rate_type="..." pnn_trailer_length="..." pnn_trailer_width="..." ponum="..." port="..." port_of_discharge="..." preload_trailer_id="..." preloaded="..." rate="..." rate_currency_type="..." rate_id="..." rate_min_weight="..." rate_min_weight_um="..." rate_type="..." rate_unit_desc="..." rate_units="..." ready_to_bill="..." recurring_order_id="..." reply_transmitted="..." requesting_company="..." return_temp="..." return_temp_um="..." return_temp_var="..." return_temp_var_um="..." revenue_code_id="..." revenue_share_method="..." round_trip="..." sail_date="..." seal_number="..." seg_alloc_code="..." setpoint_temp="..." setpoint_temp_um="..." setpoint_var="..." setpoint_var_um="..." settlement_date="..." ship_status_to_edi="..." shipment_id="..." shipper_stop_id="..." shipstatus2edi_dt="..." ss_location_id="..." status="..." subject_order_number="..." subject_order_status="..." subject_order_void_date="..." swap="..." tanker="..." teams_required="..." temperature_max="..." temperature_max_um="..." temperature_min="..." temperature_min_um="..." tms_ap_amt="..." total_charge="..." total_charge_c="..." total_charge_d="..." total_charge_n="..." total_charge_r="..." totalcharge_and_excisetax="..." totalcharge_and_excisetax_c="..." totalcharge_and_excisetax_d="..." totalcharge_and_excisetax_n="..." totalcharge_and_excisetax_r="..." tractor_type="..." vessel="..." vessel_cutoff_date="..." weight="..." weight_um="..." xferred2billing="..." xferred2billing_dt="..."/>

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":"orders","company_id":"...","id":"...","actual_reefer_profile":"...","agency_id":"...","agent_payee_id":"...","allow_relay":"...","appt_delay_reason_del":"...","appt_delay_reason_pu":"...","autorate_status":"...","bill_date":"...","bill_distance":"...","bill_distance_um":"...","billing_empty_distance":"...","billing_empty_distance_um":"...","billing_loaded_distance":"...","billing_loaded_distance_um":"...","billing_user_id":"...","blnum":"...","bol_received":"...","bol_recv_date":"...","booking_no":"...","booking_number":"...","brk_qual_profile":"...","broker_location_id":"...","brokerage_workflow_id":"...","cbp_crossing_date":"...","cbp_crossing_location_id":"...","cbp_crossing_reason":"...","cbsa_crossing_date":"...","cbsa_crossing_location_id":"...","cbsa_crossing_reason":"...","cc_fuel_revenue":"...","cc_fuel_revenue_c":"...","cc_fuel_revenue_d":"...","cc_fuel_revenue_n":"...","cc_fuel_revenue_r":"...","cc_net_revenue":"...","cc_net_revenue_c":"...","cc_net_revenue_d":"...","cc_net_revenue_n":"...","cc_net_revenue_r":"...","cc_pro_nbr":"...","channel":"...","cobroker_location_id":"...","collection_method":"...","com_setpnt_temp":"...","com_setpnt_temp_um":"...","commodity":"...","commodity_id":"...","consignee_refno":"...","consignee_stop_id":"...","container":"...","container_planned":"...","container_type_id":"...","controlling_carrier_code":"...","copy_from_company":"...","copy_from_order_id":"...","copy_to_company":"...","copy_to_order_id":"...","ctrl_party_id":"...","cube":"...","curr_movement_id":"...","cust_order_no":"...","customer_id":"...","declared_val":"...","default_match_id":"...","dim_height":"...","dim_length":"...","dim_surcharge":"...","dim_surcharge_c":"...","dim_surcharge_d":"...","dim_surcharge_n":"...","dim_surcharge_r":"...","dim_width":"...","dispatch_opt":"...","dl_team_reqd":"...","dray_del_date":"...","dray_del_pay":"...","dray_del_pay_c":"...","dray_del_pay_d":"...","dray_del_pay_n":"...","dray_del_pay_r":"...","dray_del_payee":"...","dray_del_xfer_dt":"...","dray_pu_date":"...","dray_pu_pay":"...","dray_pu_pay_c":"...","dray_pu_pay_d":"...","dray_pu_pay_n":"...","dray_pu_pay_r":"...","dray_pu_payee":"...","dray_pu_xfer_dt":"...","eir1_no":"...","eir2_no":"...","entered_user_id":"...","equipment_type_id":"...","est_tolls":"...","est_tolls_c":"...","est_tolls_d":"...","est_tolls_n":"...","est_tolls_r":"...","excise_disable_update":"...","excise_taxable":"...","excisetax_total":"...","excisetax_total_c":"...","excisetax_total_d":"...","excisetax_total_n":"...","excisetax_total_r":"...","external_invoiceno":"...","extra_deliveries":"...","extra_pickups":"...","force_assign":"...","forwd_location_id":"...","free_days":"...","freight_charge":"...","freight_charge_c":"...","freight_charge_d":"...","freight_charge_n":"...","freight_charge_r":"...","hazmat":"...","hazmat_code":"...","high_value":"...","hold_reason":"...","image_is_present":"...","import_export":"...","include_split_point":"...","intelliset":"...","invoice_recv_date":"...","is_autorate_dist":"...","is_container":"...","is_dedicated":"...","is_local_mile":"...","is_requested":"...","jag_carrier_id":"...","jag_cost_rate_id":"...","ldport_location_id":"...","linear_feet_avail":"...","load_date":"...","loadboard":"...","loadboard_user_id":"...","ltl":"...","mabd":"...","markup_flat":"...","markup_flat_c":"...","markup_flat_d":"...","markup_flat_n":"...","markup_flat_r":"...","markup_percent":"...","master_order_id":"...","master_sequence":"...","next_rebill":"...","nte_lp_num":"...","nte_lp_qual":"...","of_accrual_ap_amt":"...","of_accrual_ar_amt":"...","of_accrual_date":"...","on_hold":"...","operational_status":"...","operations_user":"...","optiset":"...","order_mode":"...","order_type_id":"...","order_value":"...","order_value_c":"...","order_value_d":"...","order_value_n":"...","order_value_r":"...","ordered_by":"...","ordered_date":"...","ordered_method":"...","original_invoice_number":"...","otherchargetotal":"...","otherchargetotal_c":"...","otherchargetotal_d":"...","otherchargetotal_n":"...","otherchargetotal_r":"...","pallets_how_many":"...","pallets_required":"...","pay_gross":"...","pay_gross_c":"...","pay_gross_d":"...","pay_gross_n":"...","pay_gross_r":"...","pick_up_no":"...","pieces":"...","placard_required":"...","planning_comment":"...","pnn_callback":"...","pnn_comment":"...","pnn_comment2":"...","pnn_post_type":"...","pnn_rate":"...","pnn_rate_type":"...","pnn_trailer_length":"...","pnn_trailer_width":"...","ponum":"...","port":"...","port_of_discharge":"...","preload_trailer_id":"...","preloaded":"...","rate":"...","rate_currency_type":"...","rate_id":"...","rate_min_weight":"...","rate_min_weight_um":"...","rate_type":"...","rate_unit_desc":"...","rate_units":"...","ready_to_bill":"...","recurring_order_id":"...","reply_transmitted":"...","requesting_company":"...","return_temp":"...","return_temp_um":"...","return_temp_var":"...","return_temp_var_um":"...","revenue_code_id":"...","revenue_share_method":"...","round_trip":"...","sail_date":"...","seal_number":"...","seg_alloc_code":"...","setpoint_temp":"...","setpoint_temp_um":"...","setpoint_var":"...","setpoint_var_um":"...","settlement_date":"...","ship_status_to_edi":"...","shipment_id":"...","shipper_stop_id":"...","shipstatus2edi_dt":"...","ss_location_id":"...","status":"...","subject_order_number":"...","subject_order_status":"...","subject_order_void_date":"...","swap":"...","tanker":"...","teams_required":"...","temperature_max":"...","temperature_max_um":"...","temperature_min":"...","temperature_min_um":"...","tms_ap_amt":"...","total_charge":"...","total_charge_c":"...","total_charge_d":"...","total_charge_n":"...","total_charge_r":"...","totalcharge_and_excisetax":"...","totalcharge_and_excisetax_c":"...","totalcharge_and_excisetax_d":"...","totalcharge_and_excisetax_n":"...","totalcharge_and_excisetax_r":"...","tractor_type":"...","vessel":"...","vessel_cutoff_date":"...","weight":"...","weight_um":"...","xferred2billing":"...","xferred2billing_dt":"..."}

Fields