go back Home

RowEdiBilling

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.

<edi_billing company_id="..." id="..." agent="..." alt_partner_id="..." autorate_status="..." batch="..." bill_date="..." bill_tid="..." bill_type="..." billing_empty_distance="..." billing_empty_distance_um="..." billing_id="..." billing_loaded_distance="..." billing_loaded_distance_um="..." billing_user_id="..." blnum="..." booking_number="..." broker="..." carrier_id="..." carrier_tractor="..." carrier_trailer="..." cc_pro_nbr="..." commodity="..." commodity_descr="..." consignee_ref_no="..." consignee_stop_id="..." container="..." correction_ind="..." create_date="..." currency="..." currency_iso_id="..." currency_type_id="..." customer_ediloc="..." customer_id="..." delivery_date="..." direction="..." dist_include_split="..." distance="..." distance_um="..." driver_id="..." edi_commodity_id="..." edi_equip_type_id="..." edi_error="..." edi_transfered="..." entered_user_id="..." equipment_type_id="..." error_text="..." excisetax_total="..." excisetax_total_c="..." excisetax_total_d="..." excisetax_total_n="..." excisetax_total_r="..." external_invoiceno="..." factoring_exp_date="..." factoring_id="..." fixed_charge_label="..." fixed_charge_seg_alloc_code="..." freight_class="..." frt_grp_pro_nbr="..." func_ack_batch="..." func_ack_id="..." func_ack_rec="..." func_ack_rec_date="..." func_ack_status="..." gs06_group_cntlno="..." gs_date_time="..." handling_code1="..." handling_code2="..." intercompany="..." invoice_no="..." invoice_no_string="..." invoice_recv_date="..." invoiced_flag="..." is_balance_due="..." is_dedicated_bill="..." is_fixed="..." is_rebill="..." is_split_bill="..." linehaul_chg="..." linehaul_chg_c="..." linehaul_chg_d="..." linehaul_chg_n="..." linehaul_chg_r="..." lock_miles="..." master_order_id="..." minimum_weight="..." minimum_weight_um="..." modified_date="..." modified_user_id="..." movement_id="..." order_id="..." order_type_id="..." other_charge="..." other_charge_c="..." other_charge_d="..." other_charge_n="..." other_charge_r="..." partner_id="..." pay_gross="..." pay_gross_c="..." pay_gross_d="..." pay_gross_n="..." pay_gross_r="..." payment_method="..." pieces="..." pieces_qual="..." port="..." post_key="..." post_module="..." printed="..." pro_nbr="..." purchase_order_no="..." rate="..." rate_id="..." rate_type="..." rate_unit_desc="..." rating_method="..." rating_type="..." rating_units="..." ready_to_process="..." ready_to_send="..." rebilled="..." reference_id="..." revenue_id="..." round_trip_flag="..." route_code="..." route_qual="..." scac="..." service_code="..." ship_date="..." ship_match_descr="..." ship_match_type="..." shipment_id="..." shipper_stop_id="..." splc="..." st02_trxset_cntlno="..." status="..." total_charges="..." total_charges_c="..." total_charges_d="..." total_charges_n="..." total_charges_r="..." totalcharge_and_excisetax="..." totalcharge_and_excisetax_c="..." totalcharge_and_excisetax_d="..." totalcharge_and_excisetax_n="..." totalcharge_and_excisetax_r="..." tractor_id="..." trailer2_id="..." trailer_id="..." trans_count="..." transfer_date="..." transport_method="..." version="..." vessel="..." void_credit_immediately="..." weight="..." weight_qual="..." 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":"edi_billing","company_id":"...","id":"...","agent":"...","alt_partner_id":"...","autorate_status":"...","batch":"...","bill_date":"...","bill_tid":"...","bill_type":"...","billing_empty_distance":"...","billing_empty_distance_um":"...","billing_id":"...","billing_loaded_distance":"...","billing_loaded_distance_um":"...","billing_user_id":"...","blnum":"...","booking_number":"...","broker":"...","carrier_id":"...","carrier_tractor":"...","carrier_trailer":"...","cc_pro_nbr":"...","commodity":"...","commodity_descr":"...","consignee_ref_no":"...","consignee_stop_id":"...","container":"...","correction_ind":"...","create_date":"...","currency":"...","currency_iso_id":"...","currency_type_id":"...","customer_ediloc":"...","customer_id":"...","delivery_date":"...","direction":"...","dist_include_split":"...","distance":"...","distance_um":"...","driver_id":"...","edi_commodity_id":"...","edi_equip_type_id":"...","edi_error":"...","edi_transfered":"...","entered_user_id":"...","equipment_type_id":"...","error_text":"...","excisetax_total":"...","excisetax_total_c":"...","excisetax_total_d":"...","excisetax_total_n":"...","excisetax_total_r":"...","external_invoiceno":"...","factoring_exp_date":"...","factoring_id":"...","fixed_charge_label":"...","fixed_charge_seg_alloc_code":"...","freight_class":"...","frt_grp_pro_nbr":"...","func_ack_batch":"...","func_ack_id":"...","func_ack_rec":"...","func_ack_rec_date":"...","func_ack_status":"...","gs06_group_cntlno":"...","gs_date_time":"...","handling_code1":"...","handling_code2":"...","intercompany":"...","invoice_no":"...","invoice_no_string":"...","invoice_recv_date":"...","invoiced_flag":"...","is_balance_due":"...","is_dedicated_bill":"...","is_fixed":"...","is_rebill":"...","is_split_bill":"...","linehaul_chg":"...","linehaul_chg_c":"...","linehaul_chg_d":"...","linehaul_chg_n":"...","linehaul_chg_r":"...","lock_miles":"...","master_order_id":"...","minimum_weight":"...","minimum_weight_um":"...","modified_date":"...","modified_user_id":"...","movement_id":"...","order_id":"...","order_type_id":"...","other_charge":"...","other_charge_c":"...","other_charge_d":"...","other_charge_n":"...","other_charge_r":"...","partner_id":"...","pay_gross":"...","pay_gross_c":"...","pay_gross_d":"...","pay_gross_n":"...","pay_gross_r":"...","payment_method":"...","pieces":"...","pieces_qual":"...","port":"...","post_key":"...","post_module":"...","printed":"...","pro_nbr":"...","purchase_order_no":"...","rate":"...","rate_id":"...","rate_type":"...","rate_unit_desc":"...","rating_method":"...","rating_type":"...","rating_units":"...","ready_to_process":"...","ready_to_send":"...","rebilled":"...","reference_id":"...","revenue_id":"...","round_trip_flag":"...","route_code":"...","route_qual":"...","scac":"...","service_code":"...","ship_date":"...","ship_match_descr":"...","ship_match_type":"...","shipment_id":"...","shipper_stop_id":"...","splc":"...","st02_trxset_cntlno":"...","status":"...","total_charges":"...","total_charges_c":"...","total_charges_d":"...","total_charges_n":"...","total_charges_r":"...","totalcharge_and_excisetax":"...","totalcharge_and_excisetax_c":"...","totalcharge_and_excisetax_d":"...","totalcharge_and_excisetax_n":"...","totalcharge_and_excisetax_r":"...","tractor_id":"...","trailer2_id":"...","trailer_id":"...","trans_count":"...","transfer_date":"...","transport_method":"...","version":"...","vessel":"...","void_credit_immediately":"...","weight":"...","weight_qual":"...","weight_um":"..."}

Fields

key name size type
company_id 4 String
id 32 String
agent 8 String
alt_partner_id 15 String
autorate_status 1 String
batch 10 int
bill_date 10 Date
bill_tid 10 int
bill_type 1 String
billing_empty_distance 10.1 BigDecimal
billing_empty_distance_um 2 String
billing_id 32 String
billing_loaded_distance 10.1 BigDecimal
billing_loaded_distance_um 2 String
billing_user_id 10 String
blnum 28 String
booking_number 12 String
broker 1 String
carrier_id 8 String
carrier_tractor 12 String
carrier_trailer 12 String
cc_pro_nbr 50 String
commodity 9 String
commodity_descr 80 String
consignee_ref_no 28 String
consignee_stop_id 32 String
container 13 String
correction_ind 2 String
create_date 19 Date
currency 3 String
currency_iso_id 3 String
currency_type_id 3 String
customer_ediloc 80 String
customer_id 8 String
delivery_date 10 Date
direction 1 String
dist_include_split 1 String
distance 10.1 BigDecimal
distance_um 2 String
driver_id 8 String
edi_commodity_id 30 String
edi_equip_type_id 20 String
edi_error 10 int
edi_transfered 1 String
entered_user_id 10 String
equipment_type_id 4 String
error_text 255 String
excisetax_total 16.2 BigDecimal
excisetax_total_c 3 String
excisetax_total_d 19 Date
excisetax_total_n 16.2 BigDecimal
excisetax_total_r 10.6 BigDecimal
external_invoiceno 16 String
factoring_exp_date 19 Date
factoring_id 8 String
fixed_charge_label 35 String
fixed_charge_seg_alloc_code 8 String
freight_class 5 String
frt_grp_pro_nbr 50 String
func_ack_batch 10 int
func_ack_id 32 String
func_ack_rec 1 String
func_ack_rec_date 19 Date
func_ack_status 2 String
gs06_group_cntlno 9 String
gs_date_time 19 Date
handling_code1 3 String
handling_code2 3 String
intercompany 1 String
invoice_no 10 int
invoice_no_string 10 String
invoice_recv_date 19 Date
invoiced_flag 1 String
is_balance_due 1 String
is_dedicated_bill 1 String
is_fixed 1 String
is_rebill 1 String
is_split_bill 1 String
linehaul_chg 16.2 BigDecimal
linehaul_chg_c 3 String
linehaul_chg_d 19 Date
linehaul_chg_n 16.2 BigDecimal
linehaul_chg_r 10.6 BigDecimal
lock_miles 1 String
master_order_id 8 String
minimum_weight 7.1 BigDecimal
minimum_weight_um 2 String
modified_date 19 Date
modified_user_id 10 String
movement_id 32 String
order_id 8 String
order_type_id 8 String
other_charge 16.2 BigDecimal
other_charge_c 3 String
other_charge_d 19 Date
other_charge_n 16.2 BigDecimal
other_charge_r 10.6 BigDecimal
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 10.6 BigDecimal
payment_method 1 String
pieces 10 int
pieces_qual 3 String
port 20 String
post_key 32 String
post_module 4 String
printed 1 String
pro_nbr 50 String
purchase_order_no 16 String
rate 12.4 BigDecimal
rate_id 10 int
rate_type 1 String
rate_unit_desc 10 String
rating_method 1 String
rating_type 1 String
rating_units 12.4 BigDecimal
ready_to_process 1 String
ready_to_send 1 String
rebilled 1 String
reference_id 2 String
revenue_id 5 String
round_trip_flag 1 String
route_code 4 String
route_qual 2 String
scac 4 String
service_code 2 String
ship_date 10 Date
ship_match_descr 200 String
ship_match_type 1 String
shipment_id 32 String
shipper_stop_id 32 String
splc 9 String
st02_trxset_cntlno 9 String
status 1 String
total_charges 16.2 BigDecimal
total_charges_c 3 String
total_charges_d 19 Date
total_charges_n 16.2 BigDecimal
total_charges_r 10.6 BigDecimal
totalcharge_and_excisetax 16.2 BigDecimal
totalcharge_and_excisetax_c 3 String
totalcharge_and_excisetax_d 19 Date
totalcharge_and_excisetax_n 16.2 BigDecimal
totalcharge_and_excisetax_r 10.6 BigDecimal
tractor_id 8 String
trailer2_id 8 String
trailer_id 8 String
trans_count 10 int
transfer_date 19 Date
transport_method 2 String
version 12 String
vessel 20 String
void_credit_immediately 1 String
weight 7.1 BigDecimal
weight_qual 2 String
weight_um 2 String