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="..." carrier_pro_nbr="..." check_number="..." commodity_id="..." delivery_date="..." destination_city="..." destination_state="..." driver_id="..." driver_name="..." external_invoiceno="..." gp_exported="..." hubtran_approved_inv_date="..." invoice_recv_date="..." is_void="..." linehaul_charge="..." linehaul_charge_c="..." linehaul_charge_d="..." linehaul_charge_n="..." linehaul_charge_r="..." loaded="..." loadpay_process_date="..." loadpay_pymt_id="..." loadpay_pymt_status="..." loadpay_transaction_date="..." loadpay_transaction_num="..." manifest_id="..." movement_id="..." movement_seq="..." movement_type="..." 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="..." pro_nbr="..." 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="..." triumphpay_carrierpay_date="..." triumphpay_confirm_code="..." triumphpay_invoice_key="..." triumphpay_process_date="..." triumphpay_pymt_details="..." triumphpay_pymt_id="..." triumphpay_pymt_status="..." triumphpay_quickpay="..." triumphpay_transaction_date="..." triumphpay_transaction_num="..." 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":"...","carrier_pro_nbr":"...","check_number":"...","commodity_id":"...","delivery_date":"...","destination_city":"...","destination_state":"...","driver_id":"...","driver_name":"...","external_invoiceno":"...","gp_exported":"...","hubtran_approved_inv_date":"...","invoice_recv_date":"...","is_void":"...","linehaul_charge":"...","linehaul_charge_c":"...","linehaul_charge_d":"...","linehaul_charge_n":"...","linehaul_charge_r":"...","loaded":"...","loadpay_process_date":"...","loadpay_pymt_id":"...","loadpay_pymt_status":"...","loadpay_transaction_date":"...","loadpay_transaction_num":"...","manifest_id":"...","movement_id":"...","movement_seq":"...","movement_type":"...","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":"...","pro_nbr":"...","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":"...","triumphpay_carrierpay_date":"...","triumphpay_confirm_code":"...","triumphpay_invoice_key":"...","triumphpay_process_date":"...","triumphpay_pymt_details":"...","triumphpay_pymt_id":"...","triumphpay_pymt_status":"...","triumphpay_quickpay":"...","triumphpay_transaction_date":"...","triumphpay_transaction_num":"...","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 28 String
billed_distance 10.1 BigDecimal
billed_distance_um 2 String
carrier_pro_nbr 50 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
hubtran_approved_inv_date 10 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 10.6 BigDecimal
loaded 1 String
loadpay_process_date 19 Date
loadpay_pymt_id 40 String
loadpay_pymt_status 20 String
loadpay_transaction_date 19 Date
loadpay_transaction_num 40 String
manifest_id 8 String
movement_id 32 String
movement_seq 10 int
movement_type 4 String
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 10.6 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 10.6 BigDecimal
origin_city 50 String
origin_state 2 String
pay_date 10 Date
pay_distance 10.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 10.6 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 10.6 BigDecimal
pro_nbr 50 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 10.6 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 10.6 BigDecimal
tractor_id 8 String
trailer_id 8 String
trailer_rent_pct 6.2 BigDecimal
transfer_date 10 Date
trip_number 16 String
triumphpay_carrierpay_date 19 Date
triumphpay_confirm_code 40 String
triumphpay_invoice_key 32 String
triumphpay_process_date 19 Date
triumphpay_pymt_details 80 String
triumphpay_pymt_id 40 String
triumphpay_pymt_status 2 String
triumphpay_quickpay 1 String
triumphpay_transaction_date 19 Date
triumphpay_transaction_num 40 String
void_date 10 Date
weight 7.1 BigDecimal
weight_um 2 String