Supported database systems > SAP SQL Anywhere

Col Num		Name	Type	Length	Allow Null	Default
-	Table Name : dsptch30_company_info
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	company_id	char	12	Y
	5	name	char	80	Y	Company name'
	6	addr1	char	40	Y
	7	addr2	char	40	Y
	8	city	char	40	Y
	9	province	char	4	Y
	10	postal_code	char	8	Y
	11	phone1_description	char	20	Y	Phone'
	12	phone1	char	12	Y
	13	phone2_description	char	20	Y	Fax'
	14	phone2	char	12	Y
	15	logo_image	long binary	32767	Y
	16	gst_registration	char	12	Y
	17	print_ticket_heading	smallint	2	Y	1
	18	email	char	128	Y
	19	website	char	128	Y
	20	location_latitude	double	8	Y	0
	21	location_longitude	double	8	Y	0
-	Table Name : dsptch30_contract
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	customer_id	char	41	Y
	5	customer_row_id	integer	4	Y
	6	contract_id	char	41	Y
	7	description	char	254	Y
	8	owner	char	40	Y
	9	internal_contract_id	char	12	Y
	10	purchase_order	char	25	Y
	11	source_id	char	12	Y
	12	company_id	char	12	Y	1'
	13	contract_type	integer	4	Y
	14	effective_date	date	4	Y	current date
	15	expiry_date	date	4	Y
	16	material_taxes_payable	char	20	Y
	17	delivery_taxes_payable	char	20	Y
	18	ticket_table	char	128	Y
	19	ticket_unit	char	4	Y	kg'
	20	invoice_unit	char	4	Y	MT'
	21	print_ticket	integer	4	Y	1
	22	print_barcode	integer	4	Y	0
	23	print_daily_total	integer	4	Y	1
	24	print_contract_total	integer	4	Y	1
	25	phone1_description	char	20	Y
	26	phone1	char	12	Y
	27	phone2_description	char	20	Y
	28	phone2	char	12	Y
	29	contact_name	char	128	Y
	30	contact_email	char	254	Y
	31	contact_other	char	128	Y
	32	location_latitude	double	8	Y	0
	33	location_longitude	double	8	Y	0
-	Table Name : dsptch30_contract_item
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	contract_row_id	integer	4	Y
	5	contract_id	char	41	Y
	6	item	char	31	Y
	7	parent_name	char	31	Y
	8	description	char	40	Y
	9	source	char	12	Y
	10	material_row_id	integer	4	Y
	11	material_code	char	31	Y
	12	ticket_unit	char	4	Y	kg'
	13	ticket_table	char	128	Y
	14	quantity_plan	numeric	12	Y	0
	15	balance	numeric	12	Y	quantity_plan-quantity_to_date-quantity_to_date_adjustment
	16	pct_complete	numeric	12	Y	if quantity_plan <> 0 then(quantity_to_date+quantity_to_date_adjustment)/quantity_plan*100 else 0 endif
	17	date_first_load	date	4	Y
	18	date_last_load	date	4	Y
	19	loads_today	integer	4	Y	0
	20	quantity_today	numeric	12	Y	0
	21	loads_to_date	integer	4	Y	0
	22	quantity_to_date	numeric	12	Y	0
	23	hold	integer	4	Y	0
	24	print_ticket	integer	4	Y	1
	25	print_barcode	integer	4	Y	0
	26	print_daily_total	integer	4	Y	1
	27	print_contract_total	integer	4	Y	1
	28	zone	char	4	Y
	29	unit_price	numeric	10	Y	0
	30	additional_fee	numeric	10	Y	0
	31	invoice_unit	char	4	Y	MT'
	32	item_cost_code	char	41	Y
	33	cost_rate	numeric	10	Y	0
	34	cost_fee	numeric	10	Y	0
	35	cost_unit	char	4	Y	MT'
	36	cost_code	char	41	Y
	37	taxes_payable	char	20	Y
	38	loads_to_date_adjustment	integer	4	Y	0
	39	quantity_to_date_adjustment	numeric	12	Y	0
-	Table Name : dsptch30_customer
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	customer_id	char	41	Y
	5	name	char	80	Y
	6	addr1	char	40	Y
	7	addr2	char	40	Y
	8	city	char	40	Y
	9	province	char	4	Y
	10	postal_code	char	16	Y
	11	credit_limit	numeric	10	Y	0
	12	balance	numeric	10	Y	0
	13	invoice_unit	char	4	Y	MT'
	14	payment_terms	integer	4	Y	1
	15	material_taxes_payable	char	20	Y
	16	delivery_taxes_payable	char	20	Y
	17	phone1_description	char	20	Y
	18	phone1	char	12	Y
	19	phone2_description	char	20	Y
	20	phone2	char	12	Y
	21	contact_name	char	128	Y
	22	contact_email	char	128	Y
	23	contact_other	char	128	Y
	24	ticket_table	char	128	Y
	25	ticket_unit	char	4	Y	kg'
	26	company_id	char	12	Y	1'
	27	print_ticket	integer	4	Y	1
	28	print_barcode	integer	4	Y	0
	29	print_daily_total	integer	4	Y	1
	30	print_contract_total	integer	4	Y	1
	31	location_latitude	double	8	Y	0
	32	location_longitude	double	8	Y	0
	33	shipto_name	char	80	Y
	34	shipto_addr1	char	40	Y
	35	shipto_addr2	char	40	Y
	36	shipto_city	char	40	Y
	37	shipto_province	char	4	Y
	38	shipto_postal_code	char	8	Y
	39	shipto_phone1_description	char	20	Y
	40	shipto_phone1	char	12	Y
	41	shipto_phone2_description	char	20	Y
	42	shipto_phone2	char	12	Y
	43	shipto_contact_name	char	128	Y
	44	shipto_contact_email	char	128	Y
	45	shipto_contact_other	char	128	Y
-	Table Name : dsptch30_haul_rate
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	contract_row_id	integer	4	Y
	5	contract_id	char	41	Y
	6	zone	char	31	Y
	7	vehicle_type	char	31	Y
	8	parent_name	char	31	Y
	9	description	char	40	Y
	10	charge_rate	numeric	10	Y	0
	11	charge_fee	numeric	10	Y	0
	12	charge_unit	char	4	Y	MT'
	13	charge_code	char	41	Y
	14	pay_rate	numeric	10	Y	0
	15	pay_fee	numeric	10	Y	0
	16	pay_unit	char	4	Y	MT'
	17	pay_code	char	41	Y
	18	taxes_payable	char	20	Y
-	Table Name : dsptch30_invoice
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	invoice_number	integer	4	Y
	5	invoice_date	date	4	Y	current date
	6	table_name	char	128	Y
-	Table Name : dsptch30_licence
	1	start_date	date	4	Y	current date
	2	date_code	char	254	Y
	3	machine_id	char	254	Y
	4	registration_code	char	254	Y
	5	total_days	integer	4	Y	0
	6	days_left	integer	4	Y	0
	7	is_registered	integer	4	Y	0
	8	unique_id	long varchar	32767	Y
-	Table Name : dsptch30_material
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	material_code	char	31	Y
	5	parent_name	char	31	Y
	6	description	char	40	Y
	7	source	char	12	Y
	8	ticket_unit	char	4	Y	kg'
	9	unit_price	numeric	10	Y	0
	10	additional_fee	numeric	10	Y	0
	11	invoice_unit	char	4	Y	MT'
	12	charge_code	char	41	Y
	13	cost_rate	numeric	10	Y	0
	14	cost_fee	numeric	10	Y	0
	15	cost_unit	char	4	Y	MT'
	16	cost_code	char	41	Y
	17	ticket_table	char	128	Y
	18	print_ticket	integer	4	Y	1
	19	print_barcode	integer	4	Y	0
	20	taxes_payable	char	20	Y
-	Table Name : dsptch30_measurement_unit
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	unit_id	char	4	Y
	5	description	char	20	Y
	6	grad_size	numeric	10	Y	0
	7	unit_label_1	char	8	Y
	8	conversion_factor_1	numeric	10	Y	0
	9	rounding_precision_1	numeric	10	Y	0
	10	unit_label_2	char	8	Y
	11	conversion_factor_2	numeric	10	Y	0
	12	rounding_precision_2	numeric	10	Y	0
-	Table Name : dsptch30_placed_at
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	contract_row_id	integer	4	Y
	5	contract_id	char	41	Y
	6	ticket_date	timestamp	8	N	current timestamp
	7	description	char	254	N
	8	location_latitude	double	8	Y	0
	9	location_longitude	double	8	Y	0
-	Table Name : dsptch30_station
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	contract_row_id	integer	4	Y
	5	contract_id	char	41	Y
	6	item	char	12	Y
	7	ticket_date	timestamp	8	N	current timestamp
	8	description	char	254	N
	9	location_latitude	double	8	Y	0
	10	location_longitude	double	8	Y	0
-	Table Name : dsptch30_systab
	1	row_id	integer	4	N	autoincrement
	2	last_modified	timestamp	8	Y	timestamp
	3	table_name	char	128	N
	4	object_type	integer	4	Y
	5	object_name	char	128	N
	6	version	char	32	Y
	7	remarks	long varchar	32767	Y
-	Table Name : dsptch30_tare_log
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	truck_id	char	12	Y
	5	tare_date	timestamp	8	Y	current timestamp
	6	new_tare	integer	4	Y	0
	7	last_tare	integer	4	Y	0
	8	tared_by	char	128	Y	current user
	9	manual_tare	integer	4	Y	1
	10	contract_id	char	41	Y
-	Table Name : dsptch30_tax_rate
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	tax_id	char	4	Y
	5	description	char	40	Y
	6	rate	numeric	8	Y	0
	7	compound	integer	4	Y	0
	8	type	integer	4	Y	0
-	Table Name : dsptch30_ticket_cash_sale
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	serial_number	integer	4	Y
	5	ticket_table	char	128	Y
	6	payment_total	numeric	10	Y	0
	7	payment_method	char	32	Y
	8	payment_reference	char	32	Y
	9	print_details	integer	4	Y	1
	10	material_unit_price	numeric	10	Y	0
	11	material_additional_fee	numeric	10	Y	0
	12	material_invoice_unit	char	4	Y
	13	material_taxes_payable	char	20	Y
	14	material_payment_details	char	128	Y
	15	material_tax	numeric	10	Y	0
	16	material_tax_details	char	128	Y
	17	delivery_unit_price	numeric	10	Y	0
	18	delivery_additional_fee	numeric	10	Y	0
	19	delivery_invoice_unit	char	4	Y
	20	delivery_taxes_payable	char	20	Y
	21	delivery_payment_details	char	128	Y
	22	delivery_tax	numeric	10	Y	0
	23	delivery_tax_details	char	128	Y
-	Table Name : dsptch30_ticket_number
	1	ml_uuid	binary	16	Y	NEWID(*)
	2	last_modified	timestamp	8	Y	timestamp
	3	table_name	char	128	N
	4	description	char	40	N
	5	label	char	16	Y	Ticket #'
	6	prefix	char	8	Y
	7	prefix_seperator	char	4	Y
	8	next_ticket_number	integer	4	Y	1
	9	report_path	char	254	Y
	10	report_file_name	char	254	Y
	11	printer_name	char	254	Y
	12	copies	integer	4	Y	1
	13	pdf_write	integer	4	Y	0
	14	pdf_open	integer	4	Y	0
	15	pdf_folder	char	254	Y
	16	pdf_file_name_format	char	254	Y	Ticket %ld.pdf'
	17	report_print_mode	integer	4	Y	0
	18	report_print_on_sheet	integer	4	Y	0
	19	invoice_path	char	254	Y
	20	invoice_file_name	char	254	Y
	21	num_of_pages	integer	4	Y	1
-	Table Name : dsptch30_truck
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	truck_id	char	12	Y
	5	owner	char	40	Y
	6	driver	char	40	Y
	7	description	char	40	Y
	8	vehicle_licence	char	10	Y
	9	vehicle_registration	char	20	Y
	10	vehicle_licence_expiry	date	4	Y
	11	vehicle_type	char	31	Y
	12	tare	integer	4	Y	0
	13	agw	integer	4	Y	0
	14	rgw	integer	4	Y	0
	15	allowed	integer	4	Y	if agw = 0 or rgw = 0 then(if agw > rgw then agw else rgw endif) else(if agw <= rgw then agw else rgw endif) endif
	16	tare_date	timestamp	8	Y	current timestamp
	17	days_since_last_tared	integer	4	Y	DATEDIFF(day,"DATE"(tare_date),current date)
	18	allow_overloads	integer	4	Y	0
	19	manual_tare	integer	4	Y	0
	20	payroll_code	char	12	Y
	21	trailer_1	char	12	Y
	22	trailer_1_tare	integer	4	Y	0
	23	trailer_2	char	12	Y
	24	trailer_2_tare	integer	4	Y	0
	25	use_stored_tare	integer	4	Y	1
	26	customer_id	char	41	Y
	27	contract_id	char	41	Y
	28	contract_item	char	31	Y
	29	contract_material_code	char	31	Y
	30	zone	char	31	Y
	31	use_last_customer_id	integer	4	Y	1
	32	use_last_contract	integer	4	Y	1
	33	use_last_contract_item	integer	4	Y	1
	34	use_last_contract_material_code	integer	4	Y	1
	35	use_last_zone	integer	4	Y	1
	36	phone1_description	char	20	Y
	37	phone1	char	12	Y
	38	phone2_description	char	20	Y
	39	phone2	char	12	Y
	40	contact_name	char	128	Y
	41	contact_email	char	254	Y
	42	contact_other	char	128	Y
	43	image_driver_signature	long binary	32767	Y
	44	use_image_driver_signature	integer	4	Y	0
	45	image_driver	long binary	32767	Y
	46	image_driver_licence	long binary	32767	Y
	47	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	48	location	integer	4	Y	0
-	Table Name : dsptch30_vehicle_type
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	type	char	31	Y
	5	charge_rate	numeric	10	Y	0
	6	charge_fee	numeric	10	Y	0
	7	charge_unit	char	4	N	MT'
	8	charge_code	char	41	Y
	9	pay_rate	numeric	10	Y	0
	10	pay_fee	numeric	10	Y	0
	11	pay_unit	char	4	N	MT'
	12	pay_code	char	41	Y
	13	description	char	40	Y
-	Table Name : dsptch30_weighed_in
	1	row_id	integer	4	N	autoincrement
	2	time_in	timestamp	8	Y	current timestamp
	3	weight_in	integer	4	Y	0
	4	time_out	timestamp	8	Y
	5	weight_out	integer	4	Y	0
	6	truck_id	char	12	Y
	7	trailer_1	char	12	Y
	8	trailer_2	char	12	Y
	9	customer_id	char	41	Y
	10	contract_id	char	41	Y
	11	purchase_order	char	25	Y
	12	item_id	char	31	Y
	13	material_code	char	31	Y
	14	source	char	12	Y
	15	placed_at	char	254	Y
	16	station	char	40	Y
	17	note	char	254	Y
	18	qty_in	numeric	10	Y	0
	19	is_manual	integer	4	Y	0
	20	weighed_by	char	128	Y	current user
	21	serial_number	integer	4	Y
	22	ticket_table	char	128	Y
	23	company_id	char	12	Y	1'
	24	tare	integer	4	Y	0
	25	trailer_1_tare	integer	4	Y	0
	26	trailer_2_tare	integer	4	Y	0
	27	ml_uuid	binary	16	Y	NEWID(*)
	28	last_modified	timestamp	8	Y	timestamp
-	Table Name : dsptch30_zone
	1	row_id	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	zone	char	31	Y
	5	vehicle_type	char	31	Y
	6	parent_name	char	31	Y
	7	description	char	40	Y
	8	charge_rate	numeric	10	N	0
	9	charge_fee	numeric	10	N	0
	10	charge_unit	char	4	Y	MT'
	11	charge_code	char	41	Y
	12	pay_rate	numeric	10	N	0
	13	pay_fee	numeric	10	N	0
	14	pay_unit	char	4	Y	MT'
	15	pay_code	char	41	Y
	16	taxes_payable	char	20	Y
-	Table Name : invoice_number
	1	next_invoice_number	integer	4	Y
-	Table Name : receipt_ticket
	1	ticket_date	timestamp	8	Y	current timestamp
	2	ticket_number	integer	4	Y
	3	truck_id	char	12	N
	4	item	char	31	Y
	5	source	char	12	Y
	6	tare	integer	4	Y	0
	7	net	integer	4	Y	0
	8	manual_gross	integer	4	Y	0
	9	manual_tare	integer	4	Y	0
	10	weighed_by	char	128	Y	current user
	11	edited_by	char	128	Y	current user
	12	edit_count	integer	4	Y	0
	13	edit_date	timestamp	8	Y	current timestamp
	14	contract_id	char	41	Y
	15	serial_number	integer	4	N	autoincrement
	16	material_code	char	31	Y
	17	overload	integer	4	Y
	18	placed_at	char	254	Y
	19	company_id	char	12	Y	1'
	20	purchase_order	char	25	Y
	21	zone	char	31	Y
	22	item_cost_code	char	12	Y
	23	ticket_unit	char	4	Y
	24	vehicle_type	char	31	Y
	27	station	char	40	Y
	28	customer_id	char	41	Y
	29	invoice_number	integer	4	Y
	30	trailer_1	char	12	Y
	31	trailer_2	char	12	Y
	32	conversion_factor_1	numeric	10	Y	1
	33	conversion_factor_2	numeric	10	Y	1
	34	ml_uuid	binary	16	N	NEWID(*)
	35	time_in	timestamp	8	Y
	36	last_modified	timestamp	8	Y	timestamp
	37	note	char	254	Y
	38	trailer_1_tare	integer	4	Y	0
	39	trailer_2_tare	integer	4	Y	0
	40	ticket_number_prefix	char	8	Y
	41	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	42	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	43	driver_on_scale	integer	4	Y	1
	44	net_3	decimal	12	Y	ROUND(net*conversion_factor_2,2)
	45	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	46	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	47	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	48	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	49	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	50	shipto_name	char	80	Y
	51	shipto_addr1	char	40	Y
	52	shipto_addr2	char	40	Y
	53	shipto_city	char	40	Y
	54	shipto_province	char	4	Y
	55	shipto_postal_code	char	16	Y
	56	shipto_phone1_description	char	20	Y
	57	shipto_phone1	char	12	Y
	58	shipto_phone2_description	char	20	Y
	59	shipto_phone2	char	12	Y
	60	shipto_contact_name	char	128	Y
	61	shipto_contact_email	char	128	Y
	62	shipto_contact_other	char	128	Y
	63	shipto_note	char	254	Y
	64	parent_serial_number	integer	4	Y
	65	item_uom	char	31	Y
	66	item_description	char	254	Y
	67	item_qty	numeric	10	Y
	68	item_tare	numeric	10	Y
	69	item_rate	numeric	10	Y
	70	item_discount_pct	numeric	10	Y
	71	item_sub_total	numeric	10	Y
	72	item_taxes_payable	char	20	Y
	73	item_tax_total	numeric	10	Y
	74	item_total	numeric	10	Y
	75	payment_method	char	32	Y
	76	payment_reference	char	32	Y
-	Table Name : receipt_ticket_attachment
	1	serial_number	integer	4	N
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	attachment_type	integer	4	Y	0
	5	mime_type	char	254	Y
	6	attachment_data	long binary	32767	Y
-	Table Name : receipt_ticket_cash_sale
	1	serial_number	integer	4	N
	2	unit_price	numeric	10	Y
	3	invoice_unit	char	4	Y
	4	additional_haul_fee	numeric	10	Y
	5	haul_rate	numeric	10	Y
	6	additional_item_fee	numeric	10	Y
	7	haul_unit	char	4	Y
	8	payment_method	integer	4	Y	0
	9	item_taxes_payable	char	20	Y
	10	haul_taxes_payable	char	20	Y
-	Table Name : receipt_ticket_deleted
	1	ticket_date	timestamp	8	Y	current timestamp
	2	ticket_number	integer	4	Y
	3	truck_id	char	12	N
	4	item	char	31	Y
	5	source	char	12	Y
	6	tare	integer	4	Y	0
	7	net	integer	4	Y	0
	8	manual_gross	integer	4	Y	0
	9	manual_tare	integer	4	Y	0
	10	weighed_by	char	128	Y	current user
	11	edited_by	char	128	Y	current user
	12	edit_count	integer	4	Y	0
	13	edit_date	timestamp	8	Y	current timestamp
	14	contract_id	char	41	Y
	15	serial_number	integer	4	N	autoincrement
	16	material_code	char	31	Y
	17	overload	integer	4	Y
	18	placed_at	char	254	Y
	19	company_id	char	120	Y	1'
	20	purchase_order	char	25	Y
	21	zone	char	31	Y
	22	item_cost_code	char	12	Y
	23	ticket_unit	char	4	Y
	24	vehicle_type	char	31	Y
	25	trailer_1	char	12	Y
	26	trailer_2	char	12	Y
	27	ml_uuid	binary	16	N	NEWID(*)
	28	time_in	timestamp	8	Y
	29	last_modified	timestamp	8	Y	timestamp
	30	customer_id	char	41	Y
	31	invoice_number	integer	4	Y
	32	note	char	254	Y
	33	trailer_1_tare	integer	4	Y	0
	34	trailer_2_tare	integer	4	Y	0
	35	ticket_number_prefix	char	8	Y
	36	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	37	conversion_factor_1	numeric	10	Y	1
	38	conversion_factor_2	numeric	10	Y	1
	39	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	40	driver_on_scale	integer	4	Y	1
	41	net_3	decimal	12	Y	ROUND(net*conversion_factor_2,2)
	42	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	43	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	44	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	45	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	46	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	47	shipto_name	char	80	Y
	48	shipto_addr1	char	40	Y
	49	shipto_addr2	char	40	Y
	50	shipto_city	char	40	Y
	51	shipto_province	char	4	Y
	52	shipto_postal_code	char	16	Y
	53	shipto_phone1_description	char	20	Y
	54	shipto_phone1	char	12	Y
	55	shipto_phone2_description	char	20	Y
	56	shipto_phone2	char	12	Y
	57	shipto_contact_name	char	128	Y
	58	shipto_contact_email	char	128	Y
	59	shipto_contact_other	char	128	Y
	60	shipto_note	char	254	Y
	61	parent_serial_number	integer	4	Y
	62	item_uom	char	31	Y
	63	item_description	char	254	Y
	64	item_qty	numeric	10	Y
	65	item_tare	numeric	10	Y
	66	item_rate	numeric	10	Y
	67	item_discount_pct	numeric	10	Y
	68	item_sub_total	numeric	10	Y
	69	item_taxes_payable	char	20	Y
	70	item_tax_total	numeric	10	Y
	71	item_total	numeric	10	Y
	72	payment_method	char	32	Y
	73	payment_reference	char	32	Y
-	Table Name : receipt_ticket_haul_taxes
	1	serial_number	integer	4	N
	2	tax_id	char	4	N
	3	rate	numeric	4	N	0
	4	amount_paid	numeric	10	N
-	Table Name : receipt_ticket_image_driver_signature
	1	serial_number	integer	4	N
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	image_driver_signature	long binary	32767	Y
-	Table Name : receipt_ticket_item
	1	serial_number	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	ticket_number_prefix	char	8	Y
	5	ticket_number	integer	4	Y
	6	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	7	ticket_date	timestamp	8	Y	current timestamp
	8	time_in	timestamp	8	Y
	9	truck_id	char	12	Y
	10	vehicle_type	char	12	Y
	11	customer_id	char	41	Y
	12	contract_id	char	41	Y
	13	purchase_order	char	25	Y
	14	company_id	char	12	Y	1'
	15	item	char	31	Y
	16	material_code	char	31	Y
	17	source	char	12	Y
	18	item_cost_code	char	41	Y
	19	zone	char	31	Y
	20	placed_at	char	254	Y
	21	station	char	40	Y
	22	tare	integer	4	Y	0
	23	net	integer	4	Y	0
	24	net_3	decimal	8	Y	ROUND(net*(select conversion_factor_2 from dba.dsptch30_measurement_unit where unit_id = ticket_unit),2)
	25	ticket_unit	char	4	Y
	26	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	27	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	28	conversion_factor_1	numeric	10	Y
	29	conversion_factor_2	numeric	10	Y
	30	overload	integer	4	Y	0
	31	manual_gross	integer	4	Y	1
	32	manual_tare	integer	4	Y	1
	33	weighed_by	char	128	Y	current user
	34	edited_by	char	128	Y
	35	edit_count	integer	4	Y	0
	36	edit_date	timestamp	8	Y
	37	invoice_number	integer	4	Y
	38	note	char	254	Y
	39	trailer_1	char	12	Y
	40	trailer_1_tare	integer	4	Y	0
	41	trailer_2	char	12	Y
	42	trailer_2_tare	integer	4	Y	0
	43	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	44	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	45	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	46	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	47	driver_on_scale	integer	4	Y	1
	48	shipto_name	char	80	Y
	49	shipto_addr1	char	40	Y
	50	shipto_addr2	char	40	Y
	51	shipto_city	char	40	Y
	52	shipto_province	char	4	Y
	53	shipto_postal_code	char	16	Y
	54	shipto_phone1_description	char	20	Y
	55	shipto_phone1	char	12	Y
	56	shipto_phone2_description	char	20	Y
	57	shipto_phone2	char	12	Y
	58	shipto_contact_name	char	128	Y
	59	shipto_contact_email	char	128	Y
	60	shipto_contact_other	char	128	Y
	61	shipto_note	char	254	Y
	62	parent_serial_number	integer	4	Y
	63	item_uom	char	31	Y
	64	item_description	char	254	Y
	65	item_qty	numeric	10	Y
	66	item_tare	numeric	10	Y
	67	item_rate	numeric	10	Y
	68	item_discount_pct	numeric	10	Y
	69	item_sub_total	numeric	10	Y
	70	item_taxes_payable	char	20	Y
	71	item_tax_total	numeric	10	Y
	72	item_total	numeric	10	Y
	73	payment_method	char	32	Y
	74	payment_reference	char	32	Y
-	Table Name : receipt_ticket_item_taxes
	1	serial_number	integer	4	N
	2	tax_id	char	4	N
	3	rate	numeric	4	N	0
	4	amount_paid	numeric	10	N
-	Table Name : receipt_ticket_payment
	1	ml_uuid	binary	16	N	NEWID(*)
	2	last_modified	timestamp	8	Y	timestamp
	3	serial_number	integer	4	Y
	4	ticket_table	char	128	Y
	5	payment_total	numeric	10	Y	0
	6	payment_method	char	32	Y
	7	payment_reference	char	32	Y
	8	print_details	integer	4	Y	1
	9	material_unit_price	numeric	10	Y	0
	10	material_additional_fee	numeric	10	Y	0
	11	material_invoice_unit	char	4	Y
	12	material_taxes_payable	char	20	Y
	13	material_payment_details	char	128	Y
	14	material_tax	numeric	10	Y	0
	15	material_tax_details	char	128	Y
	16	delivery_unit_price	numeric	10	Y	0
	17	delivery_additional_fee	numeric	10	Y	0
	18	delivery_invoice_unit	char	4	Y
	19	delivery_taxes_payable	char	20	Y
	20	delivery_payment_details	char	128	Y
	21	delivery_tax	numeric	10	Y	0
	22	delivery_tax_details	char	128	Y
-	Table Name : shipment_ticket
	1	ticket_number	integer	4	Y
	2	ticket_date	timestamp	8	Y	current timestamp
	3	truck_id	char	12	Y
	4	item	char	31	Y
	5	source	char	12	Y
	6	tare	integer	4	Y	0
	7	net	integer	4	Y	0
	8	manual_gross	integer	4	Y	0
	9	manual_tare	integer	4	Y	0
	10	station	char	40	Y
	11	weighed_by	char	128	Y	current user
	12	edited_by	char	128	Y	current user
	13	edit_count	integer	4	Y	0
	14	edit_date	timestamp	8	Y	current timestamp
	15	contract_id	char	41	Y
	16	serial_number	integer	4	N	autoincrement
	17	material_code	char	31	Y
	18	overload	integer	4	Y
	19	placed_at	char	254	Y
	20	company_id	char	12	Y	1'
	21	purchase_order	char	25	Y
	22	zone	char	31	Y
	23	item_cost_code	char	12	Y
	24	ticket_unit	char	4	Y
	25	vehicle_type	char	31	Y
	28	customer_id	char	41	Y
	29	invoice_number	integer	4	Y
	30	trailer_1	char	12	Y
	31	trailer_2	char	12	Y
	32	conversion_factor_1	numeric	10	Y	1
	33	conversion_factor_2	numeric	10	Y	1
	34	ml_uuid	binary	16	N	NEWID(*)
	35	time_in	timestamp	8	Y
	36	last_modified	timestamp	8	Y	timestamp
	37	note	char	254	Y
	38	trailer_1_tare	integer	4	Y	0
	39	trailer_2_tare	integer	4	Y	0
	40	ticket_number_prefix	char	8	Y
	41	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	42	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	43	driver_on_scale	integer	4	Y	1
	44	net_3	decimal	12	Y	ROUND(net*conversion_factor_2,2)
	45	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	46	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	47	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	48	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	49	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	50	shipto_name	char	80	Y
	51	shipto_addr1	char	40	Y
	52	shipto_addr2	char	40	Y
	53	shipto_city	char	40	Y
	54	shipto_province	char	4	Y
	55	shipto_postal_code	char	16	Y
	56	shipto_phone1_description	char	20	Y
	57	shipto_phone1	char	12	Y
	58	shipto_phone2_description	char	20	Y
	59	shipto_phone2	char	12	Y
	60	shipto_contact_name	char	128	Y
	61	shipto_contact_email	char	128	Y
	62	shipto_contact_other	char	128	Y
	63	shipto_note	char	254	Y
	64	parent_serial_number	integer	4	Y
	65	item_uom	char	31	Y
	66	item_description	char	254	Y
	67	item_qty	numeric	10	Y
	68	item_tare	numeric	10	Y
	69	item_rate	numeric	10	Y
	70	item_discount_pct	numeric	10	Y
	71	item_sub_total	numeric	10	Y
	72	item_taxes_payable	char	20	Y
	73	item_tax_total	numeric	10	Y
	74	item_total	numeric	10	Y
	75	payment_method	char	32	Y
	76	payment_reference	char	32	Y
-	Table Name : shipment_ticket_attachment
	1	serial_number	integer	4	N
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	attachment_type	integer	4	Y	0
	5	mime_type	char	254	Y
	6	attachment_data	long binary	32767	Y
-	Table Name : shipment_ticket_cash_sale
	1	serial_number	integer	4	N
	2	unit_price	numeric	10	Y
	3	invoice_unit	char	4	Y
	4	additional_haul_fee	numeric	10	Y
	5	haul_rate	numeric	10	Y
	6	additional_item_fee	numeric	10	Y
	7	haul_unit	char	4	Y
	8	payment_method	integer	4	Y	0
	9	item_taxes_payable	char	20	Y
	10	haul_taxes_payable	char	20	Y
-	Table Name : shipment_ticket_deleted
	1	ticket_number	integer	4	Y
	2	ticket_date	timestamp	8	Y	current timestamp
	3	truck_id	char	12	Y
	4	item	char	31	Y
	5	source	char	12	Y
	6	tare	integer	4	Y	0
	7	net	integer	4	Y	0
	8	manual_gross	integer	4	Y	0
	9	manual_tare	integer	4	Y	0
	10	station	char	40	Y
	11	weighed_by	char	128	Y	current user
	12	edited_by	char	128	Y	current user
	13	edit_count	integer	4	Y	0
	14	edit_date	timestamp	8	Y	current timestamp
	15	contract_id	char	41	Y
	16	serial_number	integer	4	Y	autoincrement
	17	material_code	char	31	Y
	18	overload	integer	4	Y
	19	placed_at	char	254	Y
	20	company_id	char	12	Y	1'
	21	purchase_order	char	25	Y
	22	zone	char	31	Y
	23	item_cost_code	char	12	Y
	24	ticket_unit	char	4	Y
	25	vehicle_type	char	31	Y
	26	trailer_1	char	12	Y
	27	trailer_2	char	12	Y
	28	ml_uuid	binary	16	N	NEWID(*)
	29	time_in	timestamp	8	Y
	30	last_modified	timestamp	8	Y	timestamp
	31	customer_id	char	41	Y
	32	invoice_number	integer	4	Y
	33	note	char	254	Y
	34	trailer_1_tare	integer	4	Y	0
	35	trailer_2_tare	integer	4	Y	0
	36	ticket_number_prefix	char	8	Y
	37	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	38	conversion_factor_1	numeric	10	Y	1
	39	conversion_factor_2	numeric	10	Y	1
	40	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	41	driver_on_scale	integer	4	Y	1
	42	net_3	decimal	12	Y	ROUND(net*conversion_factor_2,2)
	43	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	44	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	45	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	46	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	47	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	48	shipto_name	char	80	Y
	49	shipto_addr1	char	40	Y
	50	shipto_addr2	char	40	Y
	51	shipto_city	char	40	Y
	52	shipto_province	char	4	Y
	53	shipto_postal_code	char	16	Y
	54	shipto_phone1_description	char	20	Y
	55	shipto_phone1	char	12	Y
	56	shipto_phone2_description	char	20	Y
	57	shipto_phone2	char	12	Y
	58	shipto_contact_name	char	128	Y
	59	shipto_contact_email	char	128	Y
	60	shipto_contact_other	char	128	Y
	61	shipto_note	char	254	Y
	62	parent_serial_number	integer	4	Y
	63	item_uom	char	31	Y
	64	item_description	char	254	Y
	65	item_qty	numeric	10	Y
	66	item_tare	numeric	10	Y
	67	item_rate	numeric	10	Y
	68	item_discount_pct	numeric	10	Y
	69	item_sub_total	numeric	10	Y
	70	item_taxes_payable	char	20	Y
	71	item_tax_total	numeric	10	Y
	72	item_total	numeric	10	Y
	73	payment_method	char	32	Y
	74	payment_reference	char	32	Y
-	Table Name : shipment_ticket_haul_taxes
	1	serial_number	integer	4	N
	2	tax_id	char	4	N
	3	rate	numeric	4	N	0
	4	amount_paid	numeric	10	N
-	Table Name : shipment_ticket_image_driver_signature
	1	serial_number	integer	4	N
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	image_driver_signature	long binary	32767	Y
-	Table Name : shipment_ticket_item
	1	serial_number	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	ticket_number_prefix	char	8	Y
	5	ticket_number	integer	4	Y
	6	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	7	ticket_date	timestamp	8	Y	current timestamp
	8	time_in	timestamp	8	Y
	9	truck_id	char	12	Y
	10	vehicle_type	char	12	Y
	11	customer_id	char	41	Y
	12	contract_id	char	41	Y
	13	purchase_order	char	25	Y
	14	company_id	char	12	Y	1'
	15	item	char	31	Y
	16	material_code	char	31	Y
	17	source	char	12	Y
	18	item_cost_code	char	41	Y
	19	zone	char	31	Y
	20	placed_at	char	254	Y
	21	station	char	40	Y
	22	tare	integer	4	Y	0
	23	net	integer	4	Y	0
	24	net_3	decimal	8	Y	ROUND(net*(select conversion_factor_2 from dba.dsptch30_measurement_unit where unit_id = ticket_unit),2)
	25	ticket_unit	char	4	Y
	26	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	27	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	28	conversion_factor_1	numeric	10	Y
	29	conversion_factor_2	numeric	10	Y
	30	overload	integer	4	Y	0
	31	manual_gross	integer	4	Y	1
	32	manual_tare	integer	4	Y	1
	33	weighed_by	char	128	Y	current user
	34	edited_by	char	128	Y
	35	edit_count	integer	4	Y	0
	36	edit_date	timestamp	8	Y
	37	invoice_number	integer	4	Y
	38	note	char	254	Y
	39	trailer_1	char	12	Y
	40	trailer_1_tare	integer	4	Y	0
	41	trailer_2	char	12	Y
	42	trailer_2_tare	integer	4	Y	0
	43	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	44	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	45	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	46	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	47	driver_on_scale	integer	4	Y	1
	48	shipto_name	char	80	Y
	49	shipto_addr1	char	40	Y
	50	shipto_addr2	char	40	Y
	51	shipto_city	char	40	Y
	52	shipto_province	char	4	Y
	53	shipto_postal_code	char	16	Y
	54	shipto_phone1_description	char	20	Y
	55	shipto_phone1	char	12	Y
	56	shipto_phone2_description	char	20	Y
	57	shipto_phone2	char	12	Y
	58	shipto_contact_name	char	128	Y
	59	shipto_contact_email	char	128	Y
	60	shipto_contact_other	char	128	Y
	61	shipto_note	char	254	Y
	62	parent_serial_number	integer	4	Y
	63	item_uom	char	31	Y
	64	item_description	char	254	Y
	65	item_qty	numeric	10	Y
	66	item_tare	numeric	10	Y
	67	item_rate	numeric	10	Y
	68	item_discount_pct	numeric	10	Y
	69	item_sub_total	numeric	10	Y
	70	item_taxes_payable	char	20	Y
	71	item_tax_total	numeric	10	Y
	72	item_total	numeric	10	Y
	73	payment_method	char	32	Y
	74	payment_reference	char	32	Y
-	Table Name : shipment_ticket_item_taxes
	1	serial_number	integer	4	N
	2	tax_id	char	4	N
	3	rate	numeric	4	N	0
	4	amount_paid	numeric	10	N
-	Table Name : shipment_ticket_payment
	1	ml_uuid	binary	16	N	NEWID(*)
	2	last_modified	timestamp	8	Y	timestamp
	3	serial_number	integer	4	Y
	4	ticket_table	char	128	Y
	5	payment_total	numeric	10	Y	0
	6	payment_method	char	32	Y
	7	payment_reference	char	32	Y
	8	print_details	integer	4	Y	1
	9	material_unit_price	numeric	10	Y	0
	10	material_additional_fee	numeric	10	Y	0
	11	material_invoice_unit	char	4	Y
	12	material_taxes_payable	char	20	Y
	13	material_payment_details	char	128	Y
	14	material_tax	numeric	10	Y	0
	15	material_tax_details	char	128	Y
	16	delivery_unit_price	numeric	10	Y	0
	17	delivery_additional_fee	numeric	10	Y	0
	18	delivery_invoice_unit	char	4	Y
	19	delivery_taxes_payable	char	20	Y
	20	delivery_payment_details	char	128	Y
	21	delivery_tax	numeric	10	Y	0
	22	delivery_tax_details	char	128	Y
-	Table Name : ticket_scratch_pad
	1	serial_number	integer	4	N	autoincrement
	2	ml_uuid	binary	16	N	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	ticket_number_prefix	char	8	Y
	5	ticket_number	integer	4	Y
	6	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	7	ticket_date	timestamp	8	Y	current timestamp
	8	time_in	timestamp	8	Y
	9	truck_id	char	12	Y
	10	vehicle_type	char	31	Y
	11	customer_id	char	41	Y
	12	contract_id	char	41	Y
	13	purchase_order	char	25	Y
	14	company_id	char	12	Y	1'
	15	item	char	31	Y
	16	material_code	char	31	Y
	17	source	char	12	Y
	18	item_cost_code	char	41	Y
	19	zone	char	31	Y
	20	placed_at	char	254	Y
	21	station	char	40	Y
	22	tare	integer	4	Y	0
	23	net	integer	4	Y	0
	25	ticket_unit	char	4	Y
	26	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	28	conversion_factor_1	numeric	10	Y	1
	29	conversion_factor_2	numeric	10	Y	1
	30	overload	integer	4	Y	0
	31	manual_gross	integer	4	Y	0
	32	manual_tare	integer	4	Y	0
	33	weighed_by	char	128	Y	current user
	34	edited_by	char	128	Y
	35	edit_count	integer	4	Y	0
	36	edit_date	timestamp	8	Y
	37	invoice_number	integer	4	Y
	38	note	char	254	Y
	39	trailer_1	char	12	Y
	40	trailer_1_tare	integer	4	Y	0
	41	trailer_2	char	12	Y
	42	trailer_2_tare	integer	4	Y	0
	43	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	47	driver_on_scale	integer	4	Y	1
	48	shipto_name	char	80	Y
	49	shipto_addr1	char	40	Y
	50	shipto_addr2	char	40	Y
	51	shipto_city	char	40	Y
	52	shipto_province	char	4	Y
	53	shipto_postal_code	char	16	Y
	54	shipto_phone1_description	char	20	Y
	55	shipto_phone1	char	12	Y
	56	shipto_phone2_description	char	20	Y
	57	shipto_phone2	char	12	Y
	58	shipto_contact_name	char	128	Y
	59	shipto_contact_email	char	128	Y
	60	shipto_contact_other	char	128	Y
	61	shipto_note	char	254	Y
	62	parent_serial_number	integer	4	Y	0
	63	item_uom	char	31	Y
	64	item_description	char	254	Y
	65	item_qty	numeric	10	Y
	66	item_tare	numeric	10	Y
	67	item_rate	numeric	10	Y
	68	item_discount_pct	numeric	10	Y
	69	item_sub_total	numeric	10	Y
	70	item_taxes_payable	char	20	Y
	71	item_tax_total	numeric	10	Y
	72	item_total	numeric	10	Y
	73	payment_method	char	32	Y
	74	payment_reference	char	32	Y
	75	net_3	decimal	12	Y	ROUND(net*conversion_factor_2,2)
	76	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	77	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	78	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	79	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
-	Table Name : ticket_scratch_pad_image_driver_signature
	1	serial_number	integer	4	N
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	image_driver_signature	long binary	32767	Y
-	Table Name : ticket_scratch_pad_item
	1	serial_number	integer	4	N	autoincrement
	2	ml_uuid	binary	16	Y	NEWID(*)
	3	last_modified	timestamp	8	Y	timestamp
	4	ticket_number_prefix	char	8	Y
	5	ticket_number	integer	4	Y
	6	ticket_date_date	date	4	Y	"DATE"(ticket_date)
	7	ticket_date	timestamp	8	Y	current timestamp
	8	time_in	timestamp	8	Y
	9	truck_id	char	12	Y
	10	vehicle_type	char	12	Y
	11	customer_id	char	41	Y
	12	contract_id	char	41	Y
	13	purchase_order	char	25	Y
	14	company_id	char	12	Y	1'
	15	item	char	31	Y
	16	material_code	char	31	Y
	17	source	char	12	Y
	18	item_cost_code	char	41	Y
	19	zone	char	31	Y
	20	placed_at	char	254	Y
	21	station	char	40	Y
	22	tare	integer	4	Y	0
	23	net	integer	4	Y	0
	24	net_3	decimal	8	Y	ROUND(net*(select conversion_factor_2 from dba.dsptch30_measurement_unit where unit_id = ticket_unit),2)
	25	ticket_unit	char	4	Y
	26	ticket_tare	integer	4	Y	(convert(integer,(tareconversion_factor_1))+5)/1010
	27	ticket_net	integer	4	Y	(convert(integer,(netconversion_factor_1))+5)/1010
	28	conversion_factor_1	numeric	10	Y
	29	conversion_factor_2	numeric	10	Y
	30	overload	integer	4	Y	0
	31	manual_gross	integer	4	Y	1
	32	manual_tare	integer	4	Y	1
	33	weighed_by	char	128	Y	current user
	34	edited_by	char	128	Y
	35	edit_count	integer	4	Y	0
	36	edit_date	timestamp	8	Y
	37	invoice_number	integer	4	Y
	38	note	char	254	Y
	39	trailer_1	char	12	Y
	40	trailer_1_tare	integer	4	Y	0
	41	trailer_2	char	12	Y
	42	trailer_2_tare	integer	4	Y	0
	43	total_tare	integer	4	Y	IFNULL(tare+trailer_1_tare+trailer_2_tare,0,tare+trailer_1_tare+trailer_2_tare)
	44	ticket_trailer_1_tare	integer	4	Y	(convert(integer,(trailer_1_tareconversion_factor_1))+5)/1010
	45	ticket_trailer_2_tare	integer	4	Y	(convert(integer,(trailer_2_tareconversion_factor_1))+5)/1010
	46	ticket_total_tare	integer	4	Y	IFNULL(ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare,0,ticket_tare+ticket_trailer_1_tare+ticket_trailer_2_tare)
	47	driver_on_scale	integer	4	Y	1
	48	shipto_name	char	80	Y
	49	shipto_addr1	char	40	Y
	50	shipto_addr2	char	40	Y
	51	shipto_city	char	40	Y
	52	shipto_province	char	4	Y
	53	shipto_postal_code	char	16	Y
	54	shipto_phone1_description	char	20	Y
	55	shipto_phone1	char	12	Y
	56	shipto_phone2_description	char	20	Y
	57	shipto_phone2	char	12	Y
	58	shipto_contact_name	char	128	Y
	59	shipto_contact_email	char	128	Y
	60	shipto_contact_other	char	128	Y
	61	shipto_note	char	254	Y
	62	parent_serial_number	integer	4	Y
	63	item_uom	char	31	Y
	64	item_description	char	254	Y
	65	item_qty	numeric	10	Y
	66	item_tare	numeric	10	Y
	67	item_rate	numeric	10	Y
	68	item_discount_pct	numeric	10	Y
	69	item_sub_total	numeric	10	Y
	70	item_taxes_payable	char	20	Y
	71	item_tax_total	numeric	10	Y
	72	item_total	numeric	10	Y
	73	payment_method	char	32	Y
	74	payment_reference	char	32	Y

Database Schema (SQL Anywhere)

Database Schema (SQL Anywhere)