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.
<drs_settle_hist company_id="..." id="..." accrual_date="..." accrual_key="..." accrual_module="..." accrual_type="..." addl_revenue_code="..." allocated="..." 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="..." gp_exported="..." invoice_recv_date="..." is_void="..." 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_pay="..." order_pay_c="..." order_pay_d="..." order_pay_n="..." order_pay_r="..." orig_posted_pay="..." orig_posted_pay_c="..." orig_posted_pay_d="..." orig_posted_pay_n="..." orig_posted_pay_r="..." origin_city="..." origin_state="..." pay_date="..." 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="..." prorated_revenue="..." prorated_revenue_c="..." prorated_revenue_d="..." prorated_revenue_n="..." prorated_revenue_r="..." ready_to_pay_flag="..." remark="..." revenue_id="..." 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="..." void_date="..." 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":"drs_settle_hist","company_id":"...","id":"...","accrual_date":"...","accrual_key":"...","accrual_module":"...","accrual_type":"...","addl_revenue_code":"...","allocated":"...","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":"...","gp_exported":"...","invoice_recv_date":"...","is_void":"...","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_pay":"...","order_pay_c":"...","order_pay_d":"...","order_pay_n":"...","order_pay_r":"...","orig_posted_pay":"...","orig_posted_pay_c":"...","orig_posted_pay_d":"...","orig_posted_pay_n":"...","orig_posted_pay_r":"...","origin_city":"...","origin_state":"...","pay_date":"...","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":"...","prorated_revenue":"...","prorated_revenue_c":"...","prorated_revenue_d":"...","prorated_revenue_n":"...","prorated_revenue_r":"...","ready_to_pay_flag":"...","remark":"...","revenue_id":"...","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":"...","void_date":"...","weight":"...","weight_um":"..."}
key | name | size | type |
---|---|---|---|
company_id | 4 | String | |
id | 32 | String | |
accrual_date | 10 | Date | |
accrual_key | 32 | String | |
accrual_module | 4 | String | |
accrual_type | 1 | String | |
addl_revenue_code | 1 | String | |
allocated | 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 | |
gp_exported | 19 | Date | |
invoice_recv_date | 10 | Date | |
is_void | 1 | String | |
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_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 | |
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_date | 10 | Date | |
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 | |
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 | |
remark | 60 | String | |
revenue_id | 5 | 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 | |
void_date | 10 | Date | |
weight | 7.1 | BigDecimal | |
weight_um | 2 | String |