go back Home

RowDrsSettleHist

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.

<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="..."/>

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":"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":"..."}

Fields

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