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.
<settlement company_id="..." id="..." accrual_date="..." accrual_type="..." addl_revenue_code="..." bill_of_lading_no="..." billed_distance="..." billed_distance_um="..." check_number="..." commodity_id="..." delivery_date="..." destination_city="..." destination_state="..." driver_id="..." driver_name="..." external_invoiceno="..." fuel_pay="..." fuel_pay_c="..." fuel_pay_d="..." fuel_pay_n="..." fuel_pay_r="..." fuel_rate="..." hold_comments="..." invoice_recv_date="..." linehaul_charge="..." linehaul_charge_c="..." linehaul_charge_d="..." linehaul_charge_n="..." linehaul_charge_r="..." loaded="..." manifest_id="..." movement_id="..." movement_seq="..." ok2pay_date="..." order_id="..." order_move_dist="..." order_move_dist_um="..." order_pay="..." order_pay_c="..." order_pay_d="..." order_pay_n="..." order_pay_r="..." order_tot_dist="..." order_tot_dist_um="..." orig_posted_pay="..." orig_posted_pay_c="..." orig_posted_pay_d="..." orig_posted_pay_n="..." orig_posted_pay_r="..." origin_city="..." origin_state="..." pay_distance="..." pay_distance_um="..." pay_method="..." pay_rate="..." payee_id="..." payee_type="..." perdiem_pay="..." perdiem_pay_c="..." perdiem_pay_d="..." perdiem_pay_n="..." perdiem_pay_r="..." post_key="..." post_module="..." preload_charge="..." preload_charge_c="..." preload_charge_d="..." preload_charge_n="..." preload_charge_r="..." process_status="..." prorated_revenue="..." prorated_revenue_c="..." prorated_revenue_d="..." prorated_revenue_n="..." prorated_revenue_r="..." ready_to_pay_flag="..." revenue_id="..." settle_trip_no="..." ship_date="..." total_pay="..." total_pay_c="..." total_pay_d="..." total_pay_n="..." total_pay_r="..." tractor_id="..." trailer_id="..." trailer_rent_pct="..." transfer_date="..." trip_number="..." weight="..." weight_um="..."/>
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":"settlement","company_id":"...","id":"...","accrual_date":"...","accrual_type":"...","addl_revenue_code":"...","bill_of_lading_no":"...","billed_distance":"...","billed_distance_um":"...","check_number":"...","commodity_id":"...","delivery_date":"...","destination_city":"...","destination_state":"...","driver_id":"...","driver_name":"...","external_invoiceno":"...","fuel_pay":"...","fuel_pay_c":"...","fuel_pay_d":"...","fuel_pay_n":"...","fuel_pay_r":"...","fuel_rate":"...","hold_comments":"...","invoice_recv_date":"...","linehaul_charge":"...","linehaul_charge_c":"...","linehaul_charge_d":"...","linehaul_charge_n":"...","linehaul_charge_r":"...","loaded":"...","manifest_id":"...","movement_id":"...","movement_seq":"...","ok2pay_date":"...","order_id":"...","order_move_dist":"...","order_move_dist_um":"...","order_pay":"...","order_pay_c":"...","order_pay_d":"...","order_pay_n":"...","order_pay_r":"...","order_tot_dist":"...","order_tot_dist_um":"...","orig_posted_pay":"...","orig_posted_pay_c":"...","orig_posted_pay_d":"...","orig_posted_pay_n":"...","orig_posted_pay_r":"...","origin_city":"...","origin_state":"...","pay_distance":"...","pay_distance_um":"...","pay_method":"...","pay_rate":"...","payee_id":"...","payee_type":"...","perdiem_pay":"...","perdiem_pay_c":"...","perdiem_pay_d":"...","perdiem_pay_n":"...","perdiem_pay_r":"...","post_key":"...","post_module":"...","preload_charge":"...","preload_charge_c":"...","preload_charge_d":"...","preload_charge_n":"...","preload_charge_r":"...","process_status":"...","prorated_revenue":"...","prorated_revenue_c":"...","prorated_revenue_d":"...","prorated_revenue_n":"...","prorated_revenue_r":"...","ready_to_pay_flag":"...","revenue_id":"...","settle_trip_no":"...","ship_date":"...","total_pay":"...","total_pay_c":"...","total_pay_d":"...","total_pay_n":"...","total_pay_r":"...","tractor_id":"...","trailer_id":"...","trailer_rent_pct":"...","transfer_date":"...","trip_number":"...","weight":"...","weight_um":"..."}
key | name | size | type |
---|---|---|---|
company_id | 4 | String | |
id | 32 | String | |
accrual_date | 10 | Date | |
accrual_type | 1 | String | |
addl_revenue_code | 1 | String | |
bill_of_lading_no | 16 | String | |
billed_distance | 6.1 | BigDecimal | |
billed_distance_um | 2 | String | |
check_number | 8 | String | |
commodity_id | 9 | String | |
delivery_date | 19 | Date | |
destination_city | 50 | String | |
destination_state | 2 | String | |
driver_id | 8 | String | |
driver_name | 28 | String | |
external_invoiceno | 16 | String | |
fuel_pay | 16.2 | BigDecimal | |
fuel_pay_c | 3 | String | |
fuel_pay_d | 19 | Date | |
fuel_pay_n | 16.2 | BigDecimal | |
fuel_pay_r | 8.4 | BigDecimal | |
fuel_rate | 12.4 | BigDecimal | |
hold_comments | 25 | String | |
invoice_recv_date | 10 | Date | |
linehaul_charge | 16.2 | BigDecimal | |
linehaul_charge_c | 3 | String | |
linehaul_charge_d | 19 | Date | |
linehaul_charge_n | 16.2 | BigDecimal | |
linehaul_charge_r | 8.4 | BigDecimal | |
loaded | 1 | String | |
manifest_id | 8 | String | |
movement_id | 32 | String | |
movement_seq | 10 | int | |
ok2pay_date | 10 | Date | |
order_id | 8 | String | |
order_move_dist | 6.1 | BigDecimal | |
order_move_dist_um | 2 | String | |
order_pay | 16.2 | BigDecimal | |
order_pay_c | 3 | String | |
order_pay_d | 19 | Date | |
order_pay_n | 16.2 | BigDecimal | |
order_pay_r | 8.4 | BigDecimal | |
order_tot_dist | 6.1 | BigDecimal | |
order_tot_dist_um | 2 | String | |
orig_posted_pay | 16.2 | BigDecimal | |
orig_posted_pay_c | 3 | String | |
orig_posted_pay_d | 19 | Date | |
orig_posted_pay_n | 16.2 | BigDecimal | |
orig_posted_pay_r | 8.4 | BigDecimal | |
origin_city | 50 | String | |
origin_state | 2 | String | |
pay_distance | 6.1 | BigDecimal | |
pay_distance_um | 2 | String | |
pay_method | 1 | String | |
pay_rate | 12.4 | BigDecimal | |
payee_id | 8 | String | |
payee_type | 1 | String | |
perdiem_pay | 16.2 | BigDecimal | |
perdiem_pay_c | 3 | String | |
perdiem_pay_d | 19 | Date | |
perdiem_pay_n | 16.2 | BigDecimal | |
perdiem_pay_r | 8.4 | BigDecimal | |
post_key | 32 | String | |
post_module | 4 | String | |
preload_charge | 16.2 | BigDecimal | |
preload_charge_c | 3 | String | |
preload_charge_d | 19 | Date | |
preload_charge_n | 16.2 | BigDecimal | |
preload_charge_r | 8.4 | BigDecimal | |
process_status | 1 | String | |
prorated_revenue | 16.2 | BigDecimal | |
prorated_revenue_c | 3 | String | |
prorated_revenue_d | 19 | Date | |
prorated_revenue_n | 16.2 | BigDecimal | |
prorated_revenue_r | 8.4 | BigDecimal | |
ready_to_pay_flag | 1 | String | |
revenue_id | 5 | String | |
settle_trip_no | 15 | String | |
ship_date | 19 | Date | |
total_pay | 16.2 | BigDecimal | |
total_pay_c | 3 | String | |
total_pay_d | 19 | Date | |
total_pay_n | 16.2 | BigDecimal | |
total_pay_r | 8.4 | BigDecimal | |
tractor_id | 8 | String | |
trailer_id | 8 | String | |
trailer_rent_pct | 6.2 | BigDecimal | |
transfer_date | 10 | Date | |
trip_number | 12 | String | |
weight | 7.1 | BigDecimal | |
weight_um | 2 | String |