go back Home

RowEdiOrder

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.

<edi_order company_id="..." id="..." agency_id="..." agent_payee_id="..." alt_partner_id="..." app_type="..." 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="..." booking_no="..." booking_number="..." bplant="..." cancelled_order="..." car_address="..." car_city="..." car_code="..." car_code_qualifier="..." car_name="..." car_pay_method="..." car_phone_number="..." car_pro_nbr="..." car_state="..." car_trip_lease="..." car_zip_code="..." carrier_id="..." carrier_tractor="..." carrier_trailer="..." changed_order="..." collection_method="..." commitment_id="..." commodity="..." commodity_id="..." complete_document="..." cons_ediloc="..." consignee_ediloc="..." consignee_refno="..." consignee_stop_id="..." container_planned="..." container_type_id="..." copy_from_company="..." copy_from_order_id="..." create_date="..." ctrl_party_id="..." cube="..." curr_movement_id="..." currency_iso_id="..." currency_type_id="..." cust_order_no="..." customer_ediloc="..." customer_id="..." default_match_id="..." dim_height="..." dim_length="..." dim_surcharge="..." dim_surcharge_c="..." dim_surcharge_d="..." dim_surcharge_n="..." dim_surcharge_r="..." dim_width="..." direction="..." dispatcher_user_id="..." 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="..." edi_commodity_id="..." edi_equip_type_id="..." edi_error="..." edi_order_type_id="..." edi_revenue_code="..." edi_seg_alloc_code="..." eir1_no="..." eir2_no="..." entered_user_id="..." equipment_type_id="..." est_tolls="..." est_tolls_c="..." est_tolls_d="..." est_tolls_n="..." est_tolls_r="..." external_invoiceno="..." extra_deliveries="..." extra_pickups="..." fleet_manager="..." forwd_location_id="..." free_days="..." freight_charge="..." freight_charge_c="..." freight_charge_d="..." freight_charge_n="..." freight_charge_r="..." fuel_distance="..." fuel_distance_um="..." func_ack_batch="..." func_ack_id="..." func_ack_rec="..." func_ack_rec_date="..." func_ack_received="..." func_ack_status="..." gs06_group_cntlno="..." gs_date_time="..." hazmat="..." hazmat_code="..." high_value="..." hold_reason="..." ignore_map_errors="..." image_is_present="..." import_export="..." include_split_point="..." initial_purpose="..." intercompany="..." intercompany_key="..." invoice_recv_date="..." is_autorate_dist="..." is_container="..." is_dedicated="..." is_dray="..." is_local_mile="..." isa13_intr_cntlno="..." jag_carrier_id="..." jag_cost_rate_id="..." ldport_location_id="..." linear_feet_avail="..." load_date="..." lock_miles="..." ltl="..." manifest_id="..." no_display="..." nte_lp_num="..." nte_lp_qual="..." on_hold="..." operational_status="..." operations_user="..." order_compared="..." order_id="..." 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="..." orig_dest_rate_id="..." original_order="..." other_pay_total="..." other_pay_total_c="..." other_pay_total_d="..." other_pay_total_n="..." other_pay_total_r="..." otherchargetotal="..." otherchargetotal_c="..." otherchargetotal_d="..." otherchargetotal_n="..." otherchargetotal_r="..." override_pay_amt="..." override_pay_amt_c="..." override_pay_amt_d="..." override_pay_amt_n="..." override_pay_amt_r="..." override_pay_rate="..." override_pay_units="..." override_type="..." override_units="..." pallets_how_many="..." pallets_required="..." partner_id="..." pay_gross="..." pay_gross_c="..." pay_gross_d="..." pay_gross_n="..." pay_gross_r="..." pick_up_no="..." pieces="..." placard_required="..." planning_comment="..." port_of_discharge="..." preload_trailer_id="..." preloaded="..." purpose="..." purpose_type="..." rate="..." rate_currency_type="..." rate_id="..." rate_min_weight="..." rate_min_weight_um="..." rate_type="..." rate_unit_desc="..." rate_units="..." rbd_timezone_id="..." ready_to_bill="..." ready_to_send="..." record_in_use="..." recurring_order_id="..." reply_action="..." reply_altpartnerid="..." reply_batch_id="..." reply_created="..." reply_date="..." reply_error="..." reply_error_descr="..." reply_gs_date_time="..." reply_partner_id="..." reply_reason="..." reply_received="..." reply_received_ts="..." reply_remarks="..." reply_st02="..." reply_tid="..." reply_trans_count="..." reply_transmitted="..." reply_version="..." require_tracking="..." required_vendor="..." respond_by_date="..." revenue_code_id="..." revenue_share_method="..." round_trip="..." sail_date="..." scac="..." seal_number="..." seg_alloc_code="..." ship_status_to_edi="..." shipment_id="..." shipper_ediloc="..." shipper_stop_id="..." shipstatus2edi_dt="..." ss_location_id="..." st02_trxset_cntlno="..." status="..." teams_required="..." temperature_max="..." temperature_max_um="..." temperature_min="..." temperature_min_um="..." tender_ignored="..." tender_status="..." total_charge="..." total_charge_c="..." total_charge_d="..." total_charge_n="..." total_charge_r="..." total_pay="..." total_pay_c="..." total_pay_d="..." total_pay_n="..." total_pay_r="..." tractor_type="..." trans_count="..." transaction_set="..." transit_warning_id="..." ts_borrowing_company="..." ts_commodity="..." user_id="..." version="..." 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":"edi_order","company_id":"...","id":"...","agency_id":"...","agent_payee_id":"...","alt_partner_id":"...","app_type":"...","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":"...","booking_no":"...","booking_number":"...","bplant":"...","cancelled_order":"...","car_address":"...","car_city":"...","car_code":"...","car_code_qualifier":"...","car_name":"...","car_pay_method":"...","car_phone_number":"...","car_pro_nbr":"...","car_state":"...","car_trip_lease":"...","car_zip_code":"...","carrier_id":"...","carrier_tractor":"...","carrier_trailer":"...","changed_order":"...","collection_method":"...","commitment_id":"...","commodity":"...","commodity_id":"...","complete_document":"...","cons_ediloc":"...","consignee_ediloc":"...","consignee_refno":"...","consignee_stop_id":"...","container_planned":"...","container_type_id":"...","copy_from_company":"...","copy_from_order_id":"...","create_date":"...","ctrl_party_id":"...","cube":"...","curr_movement_id":"...","currency_iso_id":"...","currency_type_id":"...","cust_order_no":"...","customer_ediloc":"...","customer_id":"...","default_match_id":"...","dim_height":"...","dim_length":"...","dim_surcharge":"...","dim_surcharge_c":"...","dim_surcharge_d":"...","dim_surcharge_n":"...","dim_surcharge_r":"...","dim_width":"...","direction":"...","dispatcher_user_id":"...","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":"...","edi_commodity_id":"...","edi_equip_type_id":"...","edi_error":"...","edi_order_type_id":"...","edi_revenue_code":"...","edi_seg_alloc_code":"...","eir1_no":"...","eir2_no":"...","entered_user_id":"...","equipment_type_id":"...","est_tolls":"...","est_tolls_c":"...","est_tolls_d":"...","est_tolls_n":"...","est_tolls_r":"...","external_invoiceno":"...","extra_deliveries":"...","extra_pickups":"...","fleet_manager":"...","forwd_location_id":"...","free_days":"...","freight_charge":"...","freight_charge_c":"...","freight_charge_d":"...","freight_charge_n":"...","freight_charge_r":"...","fuel_distance":"...","fuel_distance_um":"...","func_ack_batch":"...","func_ack_id":"...","func_ack_rec":"...","func_ack_rec_date":"...","func_ack_received":"...","func_ack_status":"...","gs06_group_cntlno":"...","gs_date_time":"...","hazmat":"...","hazmat_code":"...","high_value":"...","hold_reason":"...","ignore_map_errors":"...","image_is_present":"...","import_export":"...","include_split_point":"...","initial_purpose":"...","intercompany":"...","intercompany_key":"...","invoice_recv_date":"...","is_autorate_dist":"...","is_container":"...","is_dedicated":"...","is_dray":"...","is_local_mile":"...","isa13_intr_cntlno":"...","jag_carrier_id":"...","jag_cost_rate_id":"...","ldport_location_id":"...","linear_feet_avail":"...","load_date":"...","lock_miles":"...","ltl":"...","manifest_id":"...","no_display":"...","nte_lp_num":"...","nte_lp_qual":"...","on_hold":"...","operational_status":"...","operations_user":"...","order_compared":"...","order_id":"...","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":"...","orig_dest_rate_id":"...","original_order":"...","other_pay_total":"...","other_pay_total_c":"...","other_pay_total_d":"...","other_pay_total_n":"...","other_pay_total_r":"...","otherchargetotal":"...","otherchargetotal_c":"...","otherchargetotal_d":"...","otherchargetotal_n":"...","otherchargetotal_r":"...","override_pay_amt":"...","override_pay_amt_c":"...","override_pay_amt_d":"...","override_pay_amt_n":"...","override_pay_amt_r":"...","override_pay_rate":"...","override_pay_units":"...","override_type":"...","override_units":"...","pallets_how_many":"...","pallets_required":"...","partner_id":"...","pay_gross":"...","pay_gross_c":"...","pay_gross_d":"...","pay_gross_n":"...","pay_gross_r":"...","pick_up_no":"...","pieces":"...","placard_required":"...","planning_comment":"...","port_of_discharge":"...","preload_trailer_id":"...","preloaded":"...","purpose":"...","purpose_type":"...","rate":"...","rate_currency_type":"...","rate_id":"...","rate_min_weight":"...","rate_min_weight_um":"...","rate_type":"...","rate_unit_desc":"...","rate_units":"...","rbd_timezone_id":"...","ready_to_bill":"...","ready_to_send":"...","record_in_use":"...","recurring_order_id":"...","reply_action":"...","reply_altpartnerid":"...","reply_batch_id":"...","reply_created":"...","reply_date":"...","reply_error":"...","reply_error_descr":"...","reply_gs_date_time":"...","reply_partner_id":"...","reply_reason":"...","reply_received":"...","reply_received_ts":"...","reply_remarks":"...","reply_st02":"...","reply_tid":"...","reply_trans_count":"...","reply_transmitted":"...","reply_version":"...","require_tracking":"...","required_vendor":"...","respond_by_date":"...","revenue_code_id":"...","revenue_share_method":"...","round_trip":"...","sail_date":"...","scac":"...","seal_number":"...","seg_alloc_code":"...","ship_status_to_edi":"...","shipment_id":"...","shipper_ediloc":"...","shipper_stop_id":"...","shipstatus2edi_dt":"...","ss_location_id":"...","st02_trxset_cntlno":"...","status":"...","teams_required":"...","temperature_max":"...","temperature_max_um":"...","temperature_min":"...","temperature_min_um":"...","tender_ignored":"...","tender_status":"...","total_charge":"...","total_charge_c":"...","total_charge_d":"...","total_charge_n":"...","total_charge_r":"...","total_pay":"...","total_pay_c":"...","total_pay_d":"...","total_pay_n":"...","total_pay_r":"...","tractor_type":"...","trans_count":"...","transaction_set":"...","transit_warning_id":"...","ts_borrowing_company":"...","ts_commodity":"...","user_id":"...","version":"...","vessel":"...","vessel_cutoff_date":"...","weight":"...","weight_um":"...","xferred2billing":"...","xferred2billing_dt":"..."}

Fields

key name size type
company_id 4 String
id 8 String
agency_id 8 String
agent_payee_id 8 String
alt_partner_id 15 String
app_type 2 String
autorate_status 1 String
bill_date 19 Date
bill_distance 10.1 BigDecimal
bill_distance_um 2 String
billing_empty_distance 10.1 BigDecimal
billing_empty_distance_um 2 String
billing_loaded_distance 10.1 BigDecimal
billing_loaded_distance_um 2 String
billing_user_id 10 String
blnum 28 String
bol_received 1 String
booking_no 14 String
booking_number 12 String
bplant 17 String
cancelled_order 1 String
car_address 40 String
car_city 50 String
car_code 8 String
car_code_qualifier 2 String
car_name 28 String
car_pay_method 1 String
car_phone_number 20 String
car_pro_nbr 50 String
car_state 2 String
car_trip_lease 16 String
car_zip_code 10 String
carrier_id 8 String
carrier_tractor 12 String
carrier_trailer 12 String
changed_order 1 String
collection_method 1 String
commitment_id 8 String
commodity 80 String
commodity_id 9 String
complete_document 1 String
cons_ediloc 80 String
consignee_ediloc 17 String
consignee_refno 28 String
consignee_stop_id 32 String
container_planned 16 String
container_type_id 4 String
copy_from_company 4 String
copy_from_order_id 8 String
create_date 19 Date
ctrl_party_id 8 String
cube 10 int
curr_movement_id 32 String
currency_iso_id 3 String
currency_type_id 3 String
cust_order_no 14 String
customer_ediloc 80 String
customer_id 8 String
default_match_id 30 String
dim_height 32 String
dim_length 32 String
dim_surcharge 16.2 BigDecimal
dim_surcharge_c 3 String
dim_surcharge_d 19 Date
dim_surcharge_n 16.2 BigDecimal
dim_surcharge_r 10.6 BigDecimal
dim_width 32 String
direction 1 String
dispatcher_user_id 10 String
dray_del_date 19 Date
dray_del_pay 16.2 BigDecimal
dray_del_pay_c 3 String
dray_del_pay_d 19 Date
dray_del_pay_n 16.2 BigDecimal
dray_del_pay_r 10.6 BigDecimal
dray_del_payee 8 String
dray_del_xfer_dt 19 Date
dray_pu_date 19 Date
dray_pu_pay 16.2 BigDecimal
dray_pu_pay_c 3 String
dray_pu_pay_d 19 Date
dray_pu_pay_n 16.2 BigDecimal
dray_pu_pay_r 10.6 BigDecimal
dray_pu_payee 8 String
dray_pu_xfer_dt 19 Date
edi_commodity_id 30 String
edi_equip_type_id 20 String
edi_error 10 int
edi_order_type_id 20 String
edi_revenue_code 20 String
edi_seg_alloc_code 20 String
eir1_no 14 String
eir2_no 14 String
entered_user_id 10 String
equipment_type_id 4 String
est_tolls 16.2 BigDecimal
est_tolls_c 3 String
est_tolls_d 19 Date
est_tolls_n 16.2 BigDecimal
est_tolls_r 10.6 BigDecimal
external_invoiceno 16 String
extra_deliveries 10 int
extra_pickups 10 int
fleet_manager 10 String
forwd_location_id 8 String
free_days 10 int
freight_charge 16.2 BigDecimal
freight_charge_c 3 String
freight_charge_d 19 Date
freight_charge_n 16.2 BigDecimal
freight_charge_r 10.6 BigDecimal
fuel_distance 12.1 BigDecimal
fuel_distance_um 2 String
func_ack_batch 10 int
func_ack_id 32 String
func_ack_rec 1 String
func_ack_rec_date 19 Date
func_ack_received 1 String
func_ack_status 1 String
gs06_group_cntlno 9 String
gs_date_time 19 Date
hazmat 1 String
hazmat_code 6 String
high_value 1 String
hold_reason 20 String
ignore_map_errors 1 String
image_is_present 1 String
import_export 1 String
include_split_point 1 String
initial_purpose 1 String
intercompany 1 String
intercompany_key 256 String
invoice_recv_date 19 Date
is_autorate_dist 1 String
is_container 1 String
is_dedicated 1 String
is_dray 1 String
is_local_mile 1 String
isa13_intr_cntlno 9 String
jag_carrier_id 8 String
jag_cost_rate_id 10 int
ldport_location_id 8 String
linear_feet_avail 10 int
load_date 19 Date
lock_miles 1 String
ltl 1 String
manifest_id 8 String
no_display 1 String
nte_lp_num 30 String
nte_lp_qual 2 String
on_hold 1 String
operational_status 4 String
operations_user 10 String
order_compared 1 String
order_id 8 String
order_mode 1 String
order_type_id 8 String
order_value 16.2 BigDecimal
order_value_c 3 String
order_value_d 19 Date
order_value_n 16.2 BigDecimal
order_value_r 10.6 BigDecimal
ordered_by 40 String
ordered_date 19 Date
ordered_method 1 String
orig_dest_rate_id 32 String
original_order 1 String
other_pay_total 16.2 BigDecimal
other_pay_total_c 3 String
other_pay_total_d 19 Date
other_pay_total_n 16.2 BigDecimal
other_pay_total_r 10.6 BigDecimal
otherchargetotal 16.2 BigDecimal
otherchargetotal_c 3 String
otherchargetotal_d 19 Date
otherchargetotal_n 16.2 BigDecimal
otherchargetotal_r 10.6 BigDecimal
override_pay_amt 16.2 BigDecimal
override_pay_amt_c 3 String
override_pay_amt_d 19 Date
override_pay_amt_n 16.2 BigDecimal
override_pay_amt_r 10.6 BigDecimal
override_pay_rate 12.4 BigDecimal
override_pay_units 12.4 BigDecimal
override_type 1 String
override_units 12.4 BigDecimal
pallets_how_many 10 int
pallets_required 1 String
partner_id 15 String
pay_gross 16.2 BigDecimal
pay_gross_c 3 String
pay_gross_d 19 Date
pay_gross_n 16.2 BigDecimal
pay_gross_r 10.6 BigDecimal
pick_up_no 14 String
pieces 10 int
placard_required 40 String
planning_comment 80 String
port_of_discharge 20 String
preload_trailer_id 8 String
preloaded 1 String
purpose 2 String
purpose_type 1 String
rate 16.4 BigDecimal
rate_currency_type 3 String
rate_id 10 int
rate_min_weight 7.1 BigDecimal
rate_min_weight_um 2 String
rate_type 1 String
rate_unit_desc 10 String
rate_units 12.4 BigDecimal
rbd_timezone_id 2 String
ready_to_bill 1 String
ready_to_send 1 String
record_in_use 1 String
recurring_order_id 8 String
reply_action 1 String
reply_altpartnerid 15 String
reply_batch_id 10 int
reply_created 1 String
reply_date 19 Date
reply_error 10 int
reply_error_descr 255 String
reply_gs_date_time 19 Date
reply_partner_id 15 String
reply_reason 40 String
reply_received 1 String
reply_received_ts 25 String
reply_remarks 80 String
reply_st02 9 String
reply_tid 10 int
reply_trans_count 10 int
reply_transmitted 1 String
reply_version 12 String
require_tracking 1 String
required_vendor 1 String
respond_by_date 19 Date
revenue_code_id 5 String
revenue_share_method 1 String
round_trip 1 String
sail_date 19 Date
scac 4 String
seal_number 20 String
seg_alloc_code 8 String
ship_status_to_edi 1 String
shipment_id 32 String
shipper_ediloc 80 String
shipper_stop_id 32 String
shipstatus2edi_dt 19 Date
ss_location_id 8 String
st02_trxset_cntlno 9 String
status 1 String
teams_required 1 String
temperature_max 5.1 BigDecimal
temperature_max_um 2 String
temperature_min 5.1 BigDecimal
temperature_min_um 2 String
tender_ignored 1 String
tender_status 1 String
total_charge 16.2 BigDecimal
total_charge_c 3 String
total_charge_d 19 Date
total_charge_n 16.2 BigDecimal
total_charge_r 10.6 BigDecimal
total_pay 16.2 BigDecimal
total_pay_c 3 String
total_pay_d 19 Date
total_pay_n 16.2 BigDecimal
total_pay_r 10.6 BigDecimal
tractor_type 4 String
trans_count 10 int
transaction_set 3 String
transit_warning_id 1 String
ts_borrowing_company 4 String
ts_commodity 9 String
user_id 10 String
version 12 String
vessel 20 String
vessel_cutoff_date 19 Date
weight 7.1 BigDecimal
weight_um 2 String
xferred2billing 1 String
xferred2billing_dt 19 Date