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="..." changed_order="..." collection_method="..." commodity="..." commodity_id="..." complete_document="..." cons_ediloc="..." consignee_ediloc="..." consignee_refno="..." consignee_stop_id="..." container_planned="..." container_type_id="..." create_date="..." ctrl_party_id="..." cube="..." curr_movement_id="..." currency_iso_id="..." currency_type_id="..." cust_order_no="..." customer_ediloc="..." customer_id="..." dim_height="..." dim_length="..." dim_surcharge="..." dim_surcharge_c="..." dim_surcharge_d="..." dim_surcharge_n="..." dim_surcharge_r="..." dim_width="..." direction="..." 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_invoice_no="..." external_invoiceno="..." extra_deliveries="..." extra_pickups="..." forwd_location_id="..." free_days="..." freight_charge="..." freight_charge_c="..." freight_charge_d="..." freight_charge_n="..." freight_charge_r="..." 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="..." invoice_recv_date="..." is_autorate_dist="..." is_container="..." is_dedicated="..." isa13_intr_cntlno="..." jag_carrier_id="..." jag_cost_rate_id="..." ldport_location_id="..." linear_feet_avail="..." load_date="..." 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="..." original_order="..." 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="..." 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_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="..." 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="..." tanker="..." 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="..." tractor_type="..." trans_count="..." transaction_set="..." transit_warning_id="..." user_id="..." version="..." vessel="..." vessel_cutoff_date="..." was_auto_created="..." weight="..." weight_um="..." xferred2billing="..." xferred2billing_dt="..."/>
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":"...","changed_order":"...","collection_method":"...","commodity":"...","commodity_id":"...","complete_document":"...","cons_ediloc":"...","consignee_ediloc":"...","consignee_refno":"...","consignee_stop_id":"...","container_planned":"...","container_type_id":"...","create_date":"...","ctrl_party_id":"...","cube":"...","curr_movement_id":"...","currency_iso_id":"...","currency_type_id":"...","cust_order_no":"...","customer_ediloc":"...","customer_id":"...","dim_height":"...","dim_length":"...","dim_surcharge":"...","dim_surcharge_c":"...","dim_surcharge_d":"...","dim_surcharge_n":"...","dim_surcharge_r":"...","dim_width":"...","direction":"...","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_invoice_no":"...","external_invoiceno":"...","extra_deliveries":"...","extra_pickups":"...","forwd_location_id":"...","free_days":"...","freight_charge":"...","freight_charge_c":"...","freight_charge_d":"...","freight_charge_n":"...","freight_charge_r":"...","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":"...","invoice_recv_date":"...","is_autorate_dist":"...","is_container":"...","is_dedicated":"...","isa13_intr_cntlno":"...","jag_carrier_id":"...","jag_cost_rate_id":"...","ldport_location_id":"...","linear_feet_avail":"...","load_date":"...","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":"...","original_order":"...","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":"...","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_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":"...","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":"...","tanker":"...","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":"...","tractor_type":"...","trans_count":"...","transaction_set":"...","transit_warning_id":"...","user_id":"...","version":"...","vessel":"...","vessel_cutoff_date":"...","was_auto_created":"...","weight":"...","weight_um":"...","xferred2billing":"...","xferred2billing_dt":"..."}
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 | 6.1 | BigDecimal | |
bill_distance_um | 2 | String | |
billing_empty_distance | 6.1 | BigDecimal | |
billing_empty_distance_um | 2 | String | |
billing_loaded_distance | 6.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 | 12 | String | |
car_zip_code | 10 | String | |
carrier_id | 8 | String | |
changed_order | 1 | String | |
collection_method | 1 | 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 | |
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 | |
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 | 8.4 | BigDecimal | |
dim_width | 32 | String | |
direction | 1 | 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 | 8.4 | 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 | 8.4 | BigDecimal | |
dray_pu_payee | 8 | String | |
dray_pu_xfer_dt | 19 | Date | |
edi_commodity_id | 30 | String | |
edi_equip_type_id | 15 | String | |
edi_error | 10 | int | |
edi_order_type_id | 15 | String | |
edi_revenue_code | 15 | String | |
edi_seg_alloc_code | 15 | String | |
eir1_no | 14 | String | |
eir2_no | 14 | String | |
entered_user_id | 10 | String | |
equipment_type_id | 15 | 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 | 8.4 | BigDecimal | |
external_invoice_no | 12 | String | |
external_invoiceno | 12 | String | |
extra_deliveries | 10 | int | |
extra_pickups | 10 | int | |
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 | 8.4 | BigDecimal | |
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 | |
invoice_recv_date | 19 | Date | |
is_autorate_dist | 1 | String | |
is_container | 1 | String | |
is_dedicated | 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 | |
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 | 8.4 | BigDecimal | |
ordered_by | 40 | String | |
ordered_date | 19 | Date | |
ordered_method | 1 | String | |
original_order | 1 | String | |
otherchargetotal | 16.2 | BigDecimal | |
otherchargetotal_c | 3 | String | |
otherchargetotal_d | 19 | Date | |
otherchargetotal_n | 16.2 | BigDecimal | |
otherchargetotal_r | 8.4 | 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 | 8.4 | BigDecimal | |
override_pay_rate | 12.4 | BigDecimal | |
override_pay_units | 12.4 | BigDecimal | |
override_type | 1 | String | |
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 | 8.4 | 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_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 | 3 | 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 | |
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 | 28 | 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 | |
tanker | 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 | 8.4 | BigDecimal | |
tractor_type | 4 | String | |
trans_count | 10 | int | |
transaction_set | 3 | String | |
transit_warning_id | 1 | String | |
user_id | 10 | String | |
version | 12 | String | |
vessel | 20 | String | |
vessel_cutoff_date | 19 | Date | |
was_auto_created | 1 | String | |
weight | 7.1 | BigDecimal | |
weight_um | 2 | String | |
xferred2billing | 1 | String | |
xferred2billing_dt | 19 | Date |