arcasys contains 652 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
posper_product_category	categories_id	varchar	255
locations	id	varchar	3
positions	Position	varchar	20
posper_product_category	Product_id	varchar	255
sales_all	ACCLEVEL	int	10	√		0	Bit mask
sales_all	ACCOUNTING_FLAGS	int	10	√		0	various propertiy flags
posper_product	accountingLevel	int	10			0	Bit mask
posper_product	actMod	int	10	√		0	Active modifier mask
posper_customer	alternativeInvoiceAddress	bit	0	√		0	-
goldberg_site_controllers	builtin	int	10	√		0
posper_cashregister	cashCarryForward	double	22	√		0	The amount remaining in the drawer as change for the next period. The amount is added for the next cash count.
posper_cashregister	cashDifference	double	22	√		0	Counted amount minus expected amount.
posper_product	com	bit	0			0	Helper product
posper_customer	credit	float	12	√		0	Allowed negative balance for customer account.
posper_customer	detailedInvoice	bit	0	√		0	-
posper_product	flags	int	10	√		0	various propertiy flags
posper_place	height	int	10	√		0	pixel
goldberg_system_settings	menu_depth	int	10			0
posper_customergroup	modifiers	int	10	√		0	Activated modifiers, e.g. group discount.
posper_product	modifiers	int	10	√		0	Excluded modifiers mask.
posper_ticketline	modifiers	int unsigned	10	√		0	Active modifiers
posper_user	modifiers	int	10	√		0	Forbidden modifiers mask
posper_ticketline	orderPrinted	float	12	√		0	Print flag
posper_customer	pin	int	10	√		0	Security PIN for customer card
posper_product	reference	varchar	255			0	Article number, not necessarily unique
posper_product	scale	bit	0			0	Is weighable
goldberg_system_settings	session_timeout	int	10			0
posper_ticket	status	int	10	√		0	Currently not used
timeaccounts	vacation_year_cor	int	10	√		0
posper_category	version	int	10			0	Used for optimistic locking
posper_customerdiscounts	version	int	10			0	Used for optimistic locking
posper_product	version	int	10			0	Used for optimistic locking
posper_productean	version	int	10			0	Used for optimistic locking
posper_productlocation	version	int	10			0	Used for optimistic locking
posper_specialprice	version	int	10			0	Used for optimistic locking
posper_web_info	version	int	10			0	Used for optimistic locking
posper_place	width	int	10	√		0	pixel
timeaccounts	corr	decimal	4,1	√		0.0
sales_all	LINETOTAL	double	19,2			0.00
holidays	Datum	date	10			0000-00-00
posper_product	inStock	bit	0			1	-
posper_product	supplier_id	int	10	√		1	-
posper_product	tax_id	varchar	255			1	-
posper_product	units	double	22	√		1	-
posper_productlocation	location_id	varchar	255			100	-
posper_customer	modifiers	int	10	√		64	Activated modifiers, e.g. individual discount.
employees	Abschluss	varchar	20	√		null
posper_customer	active	bit	0	√		null	-
posper_logintime	activity	int	10	√		null	login=1, logout=0
posper_location	address	varchar	255	√		null	-
posper_role	alias	varchar	255	√		null	Alias
memberaccounts	amount	double	22	√		null
posper_payment	amount	double	22				Payment amount.-
posper_ticketline	amount	double	22				Number of items sold
posper_valuecard	amount	double	22	√		null	Value in main currency
sales_all	AMOUNT	double	22				Number of items sold
speps_suporderlines	amountDelivered	float	12	√		null
speps_suporderlines	amountOrdered	float	12	√		null
employees	Anschrift	varchar	50	√		null
locations	Anschrift	varchar	50	√		null
employees	Anschrift2	varchar	50	√		null
employees	Ausbildung	varchar	20	√		null
posper_payment	auth_code	varchar	255	√		null	Used for CC payments.
DATABASECHANGELOG	AUTHOR	varchar	63
employees	AV	float	12	√		null
memberaccounts	balance	double	22	√		null
employees	Bank	varchar	30	√		null
posper_paymentserialgenerator	base	varchar	20	√		null	Can be used by a DB trigger to qualify the scope of serial numbers, e.g. by month
employees	Beendigung	date	10	√		null
locations	Beschreibung	varchar	50	√		null
positions	Beschreibung	blob	65535	√		null
employees	BLZ	varchar	8	√		null
rosters	break_0	int	10	√		null
rosters	break_1	int	10	√		null
rosters	break_2	int	10	√		null
rosters	break_3	int	10	√		null
rosters	break_4	int	10	√		null
rosters	break_5	int	10	√		null
rosters	break_6	int	10	√		null
goldberg_roles	cache_de	text	65535	√		null
goldberg_roles	cache_en	text	65535	√		null
posper_payment	card_number	varchar	255	√		null	Normally not used.
memberaccounts	card_string	varchar	45	√		null
memberaccounts	card_type	varchar	20	√		null
sales_all	CARDCUSTNAME	varchar	255	√		null
sales_all	CARDDEPARTMNT	varchar	255	√		null	-
posper_customer	cardNumber	varchar	45	√		null	Unique ID of an identification medium like RFID card etc.
posper_user	cardString	varchar	45	√		null	Identification e.g. Dallas Lock token
posper_cashregister	cashInSafe	varchar	50	√		null
posper_payment	cashregister_id	varchar	255	√		null	Reference to cashregister
sales_all	CATEGORY	varchar	255	√		null	-
posper_product	category_id	varchar	255				-
posper_category	category_name	varchar	255				-
posper_reservation	chairs	int	10				Number of persons
sales_all	CHOST	varchar	30	√		null	Defines the register the ticket belongs to.
posper_customer	city	varchar	255	√		null	-
speps_suppliers	city	varchar	255	√		null
posper_customer	city1	varchar	255	√		null	-
posper_customer	code	varchar	255				-
posper_product	code	varchar	255	√		null	EAN or UPC
speps_suppliers	code	varchar	255	√		null
bo_translations	column_id	int	10	√		null
bo_trcolumns	column_id	int	10	√		null
bo_trcolumns	column_name	varchar	255	√		null
posper_customer	comment	varchar	255	√		null	-
posper_payment	comment	varchar	45	√		null	Payment or customer specific use, e.g. card circuit
posper_ticket	comment	varchar	255	√		null	-
posper_ticketline	comment	varchar	255	√		null	-
DATABASECHANGELOG	COMMENTS	varchar	255	√		null
posper_ticketline	comProduct	bit	1	√		null
goldberg_users	confirmation_key	varchar	255	√		null
posper_valuecard	consumed	bit	0	√		null	true invalidates the card
posper_customer	contactName	varchar	255	√		null	-
speps_suppliers	contactName	varchar	255	√		null
posper_customer	contactName1	varchar	255	√		null	-
goldberg_content_pages	content_cache_de	text	65535	√		null
goldberg_content_pages	content_cache_en	text	65535	√		null
goldberg_content_pages	content_de	text	65535	√		null
goldberg_content_pages	content_en	text	65535	√		null
goldberg_menu_items	content_page_id	int	10	√		null
DATABASECHANGELOG	CONTEXTS	varchar	255	√		null
goldberg_menu_items	controller_action_id	int	10	√		null
posper_currency	conversion_rate	double	22	√		null	-
posper_payment	conversion_rate	double	22	√		null	For foreign currency only: current rate
posper_cashregister	countCloseCash	smallint	5	√		null
posper_cashregister	countCurrentCash	smallint	5	√		null
posper_cashregister	countOpenDrawer	smallint	5	√		null
posper_cashregister	countPayments	smallint	5	√		null
posper_cashregister	countReprints	smallint	5	√		null
speps_suppliers	country	varchar	255	√		null
posper_ticketline	coupon	bit	1	√		null
posper_product	course	tinyint	3	√		null	-
posper_ticketline	course	tinyint	3	√		null	-
posper_course	course_id	tinyint	3	√		null	-
posper_course	course_name	varchar	255	√		null	-
account_conversion_rules	created_at	datetime	19	√		null
bo_invoices	created_at	datetime	19	√		null
bo_price_labels	created_at	datetime	19	√		null
goldberg_content_pages	created_at	datetime	19	√		null
goldberg_roles	created_at	datetime	19	√		null
log4j_audit_logs	created_at	datetime	19	√		null
memberaccounts	created_at	datetime	19	√		null
posper_logintime	created_at	datetime	19	√		null	-
posper_product	created_at	datetime	19	√		null	-
posper_reservation	created_at	datetime	19	√		null
posper_ticket	created_at	datetime	19	√		null
posper_ticketline	created_at	datetime	19	√		null	-
sessions	created_at	datetime	19	√		null
posper_currency	currency_code	varchar	3	√		null	-
posper_payment	currency_code	varchar	3	√		null	For foreign currency only.
memberaccounts	customer	smallint	5	√		null
posper_reservation	customer	varchar	255	√		null	-
memberaccounts	customer_id	varchar	255	√		null
posper_customerdiscounts	customer_id	varchar	255	√		null	Set if customer specific discount
posper_ticket	customer_id	varchar	255	√		null	-
posper_customerdiscounts	customergroup_id	varchar	255	√		null	Set if customer group specific discount
sessions	data	text	65535	√		null
posper_reservation	date	datetime	19	√		null
posper_stockdiary	date	datetime	19				-
posper_customer	date1	date	10	√		null	-
posper_customer	date2	date	10	√		null	-
posper_specialprice	date_from	datetime	19	√		null	-
posper_specialprice	date_to	datetime	19	√		null	-
posper_cashregister	dateClose	datetime	19	√		null	End of register period.
posper_ticket	dateClose	datetime	19	√		null	-
sales_all	DATECLOSE	varchar	10	√		null
posper_ticket	dateDelivered	datetime	19	√		null	Set if delivery ticket
posper_ticket	dateDueDelivery	datetime	19	√		null	-
DATABASECHANGELOG	DATEEXECUTED	datetime	19
posper_cashregister	dateOpen	datetime	19				Start of register period. Must always be equal to the end of the previous period.
posper_ticket	dateOpen	datetime	19	√		null	Creation date
goldberg_roles	default_page_id	int	10	√		null
speps_suporders	deliveryDate	date	10	√		null
posper_customer	department	varchar	255	√		null	-
DATABASECHANGELOG	DEPLOYMENT_ID	varchar	10	√		null
bo_price_labels	description	varchar	255	√		null
DATABASECHANGELOG	DESCRIPTION	varchar	255	√		null
posper_image	description	varchar	255	√		null	-
posper_product	description	varchar	255				-
posper_reservation	description	varchar	255	√		null	-
posper_ticketline	description	varchar	255				Product description
posper_valuecard	description	varchar	255	√		null	documentary
sales_all	DESCRIPTION	varchar	255				Product description
goldberg_roles	description_de	varchar	255	√		null
goldberg_roles	description_en	varchar	255	√		null
posper_product	description_ext	text	65535	√		null	Extended description, doc and Enjoy client
posper_customerdiscounts	discount	double	22	√		null	Percentage rate
posper_ticketline	discountReason_id	varchar	255	√		null	-
posper_category	displayOrder	int	10	√		null	-
posper_product	displayOrder	int	10	√		null	-
positions	Doc	int	10	√		null
posper_reservation	done	bit	0				-
speps_suporders	dueDate	date	10	√		null
posper_productean	ean	varchar	255	√		null	-
employees	Einstellung	date	10	√		null
goldberg_users	email	varchar	255	√		null
posper_customer	email	varchar	255	√		null	-
posper_customer	email1	varchar	255	√		null	-
goldberg_users	employee_id	int	10	√		null
rosters	employee_id	int	10	√		null
timeaccounts	employee_id	int	10	√		null
rosters	end_0	time	8	√		null
rosters	end_1	time	8	√		null
rosters	end_2	time	8	√		null
rosters	end_3	time	8	√		null
rosters	end_4	time	8	√		null
rosters	end_5	time	8	√		null
rosters	end_6	time	8	√		null
posper_category	erp_updated_at	datetime	19	√		null	Last sync update from ERP system
posper_customer	erp_updated_at	datetime	19	√		null
posper_customergroup	erp_updated_at	datetime	19	√		null
posper_product	erp_updated_at	datetime	19	√		null	Used by Backoffice for ERP updates
posper_ticket	erp_updated_at	datetime	19	√		null
DATABASECHANGELOG	EXECTYPE	varchar	10
account_conversion_rules	expression	varchar	255	√		null
posper_customer	fax	varchar	255	√		null	-
speps_suppliers	fax	varchar	255	√		null
posper_customer	fax1	varchar	255	√		null	-
holidays	Feiertag_de	varchar	25	√		null
holidays	Feiertag_en	varchar	25	√		null
DATABASECHANGELOG	FILENAME	varchar	200
employees	Finanzamt	varchar	20	√		null
posper_place	floor_id	varchar	255				-
goldberg_system_settings	footer_message_de	varchar	255	√		null
goldberg_system_settings	footer_message_en	varchar	255	√		null
goldberg_users	fullname	varchar	255	√		null
employees	GebDatum	date	10	√		null
employees	Gemeinde	varchar	10	√		null
posper_customer	group_id	varchar	255	√		null	-
employees	Grund	varchar	50	√		null
employees	Grundlohn	float	12	√		null
posper_ticket	guests	smallint	5	√		null	Informational
posper_payment	holder_name	varchar	255	√		null	Normally not used.
posper_cashregister	host	varchar	255				Host name. Each host has it't own sequence.
posper_ticket	host	varchar	30	√		null	Defines the register the ticket belongs to.
posper_logintime	hostname	varchar	45	√		null	-
rosters	hours_0	decimal	3,2	√		null
rosters	hours_1	decimal	3,2	√		null
rosters	hours_2	decimal	3,2	√		null
rosters	hours_3	decimal	3,2	√		null
rosters	hours_4	decimal	3,2	√		null
rosters	hours_5	decimal	3,2	√		null
rosters	hours_6	decimal	3,2	√		null
account_conversion_rules	id	int	10		√
bo_invoices	id	int	10		√
bo_new_prices	id	int	10		√
bo_price_labels	id	int	10		√
bo_translations	id	int	10		√
bo_trcolumns	id	int	10		√
bo_trtables	id	int	10		√
bo_uitranslations	id	int	10		√
DATABASECHANGELOG	ID	varchar	63
DATABASECHANGELOGLOCK	ID	int	10
employees	id	int	10		√
goldberg_content_pages	id	int	10		√
goldberg_controller_actions	id	int	10		√
goldberg_menu_items	id	int	10		√
goldberg_permissions	id	int	10		√
goldberg_roles	id	int	10		√
goldberg_roles_permissions	id	int	10		√
goldberg_site_controllers	id	int	10		√
goldberg_system_settings	id	int	10		√
goldberg_users	id	int	10		√
log4j_audit_logs	id	int	10		√
memberaccounts	id	int	10		√
positions	id	int	10		√
posper_cashregister	id	varchar	255
posper_category	id	varchar	255
posper_course	id	varchar	255
posper_currency	id	varchar	255
posper_customer	id	varchar	255
posper_customerdiscounts	id	varchar	255
posper_customergroup	id	varchar	255
posper_discountreason	id	varchar	255
posper_floor	id	varchar	255
posper_image	id	varchar	255
posper_location	id	varchar	255
posper_logintime	id	varchar	255
posper_payment	id	varchar	255
posper_paymentserialgenerator	id	int	10		√
posper_place	id	varchar	255
posper_product	id	varchar	255
posper_productean	id	varchar	255
posper_productlocation	id	varchar	255
posper_reservation	id	varchar	255
posper_specialprice	id	varchar	255
posper_stockdiary	id	varchar	255
posper_tare	id	varchar	255
posper_tax	id	varchar	255
posper_ticket	id	varchar	255
posper_ticketcreationgenerator	id	int	10		√
posper_ticketidgenerator	id	int	10		√
posper_ticketline	id	varchar	255
posper_user	id	varchar	255
posper_valuecard	id	varchar	255
posper_web_info	id	varchar	255
rosters	id	int	10		√
sessions	id	int	10		√
speps_suporderlines	id	int	10		√
speps_suporders	id	int	10		√
speps_suppliers	id	int	10		√
timeaccounts	id	int	10		√
bo_languages	image_id	varchar	255	√		null
posper_category	image_id	varchar	255	√		null	-
posper_floor	image_id	varchar	255	√		null	-
posper_imageresource	image_id	varchar	255	√		null	Reference to image blob
posper_product	image_id	varchar	255	√		null	-
posper_user	image_id	varchar	255	√		null	-
posper_image	imageBlob	mediumblob	16777215				Image data
posper_ticketline	inactiveVoucher	bit	1	√		null
posper_valuecard	issue_date	date	10	√		null	-
timeaccounts	Jahr	int	10	√		null
employees	KKasse	varchar	25	√		null
employees	KKNr	varchar	20	√		null
employees	KontoNr	varchar	15	√		null
goldberg_menu_items	label_de	varchar	255	√		null
goldberg_menu_items	label_en	varchar	255	√		null
DATABASECHANGELOG	LABELS	varchar	255	√		null
bo_languages	language	varchar	255	√		null
bo_languages	language_id	varchar	5
bo_translations	language_id	varchar	5	√		null
bo_uitranslations	language_id	varchar	5	√		null
posper_customer	language_id	varchar	5	√		null
log4j_audit_logs	level	varchar	10	√		null
posper_ticketline	line_index	int	10	√		null	Line order number used by Hibernate
sales_all	LINENR	int	10	√		null	Line order number used by Hibernate
DATABASECHANGELOG	LIQUIBASE	varchar	20	√		null
memberaccounts	location	smallint	5	√		null
employees	location_id	varchar	3	√		null
posper_stockdiary	location_id	varchar	255				-
DATABASECHANGELOGLOCK	LOCKED	bit	0
posper_specialprice	locked	bit	0	√		null	-
DATABASECHANGELOGLOCK	LOCKEDBY	varchar	255	√		null
DATABASECHANGELOGLOCK	LOCKGRANTED	datetime	19	√		null
log4j_audit_logs	logger	varchar	255	√		null
employees	Lohnart	varchar	1	√		null
locations	Lokation	varchar	50	√		null
goldberg_content_pages	markup_style	varchar	255	√		null
goldberg_content_pages	markup_style_id	int	10	√		null
DATABASECHANGELOG	MD5SUM	varchar	35	√		null
log4j_audit_logs	message	varchar	255	√		null
posper_payment	method	varchar	255				Payment method.
posper_stockdiary	modifiers	int	10	√		null	Active modifiers
timeaccounts	Monat	int	10	√		null
rosters	monday	date	10
timeaccounts	month	date	10	√		null
timeaccounts	month_hours_act	decimal	4,1	√		null
timeaccounts	month_hours_nom	decimal	4,1	√		null
employees	MStd	float	12	√		null
employees	Name	varchar	40	√		null
goldberg_content_pages	name	varchar	255	√		null
goldberg_controller_actions	name	varchar	255	√		null
goldberg_menu_items	name	varchar	255	√		null
goldberg_permissions	name	varchar	45	√		null
goldberg_roles	name	varchar	45	√		null
goldberg_site_controllers	name	varchar	255	√		null
goldberg_users	name	varchar	255	√		null
posper_customer	name	varchar	255
posper_customergroup	name	varchar	255				-
posper_floor	name	varchar	255				-
posper_location	name	varchar	255				-
posper_payment	name	varchar	50	√		null	Payment or customer specific use.
posper_permission	name	varchar	255
posper_place	name	varchar	255				pixel
posper_role	name	varchar	255
posper_tare	name	varchar	255
posper_user	name	varchar	255				Displayed name
speps_suppliers	name	varchar	255	√		null
goldberg_permissions	name_de	varchar	255	√		null
goldberg_roles	name_de	varchar	255	√		null
goldberg_permissions	name_en	varchar	255	√		null
goldberg_roles	name_en	varchar	255	√		null
posper_ticket	newsURL	varchar	255	√		null
employees	Nickname	varchar	15	√		null
goldberg_system_settings	not_found_page_id	int	10	√		null
posper_ticket	number	int	10	√		null	Serial number for closed sales tickets
posper_valuecard	opt1	varchar	255	√		null	customer specific use
posper_valuecard	opt2	varchar	255	√		null	customer specific use
posper_valuecard	opt3	varchar	255	√		null	customer specific use opt1..3 ares aved in posper_payment.name
posper_ticket	orderCode	varchar	255	√		null	Order code from a foreign ERP system for back reference (if erpmode=true
speps_suporders	orderDate	date	10	√		null
DATABASECHANGELOG	ORDEREXECUTED	int	10
employees	Ort	varchar	50	√		null
locations	Ort	varchar	50	√		null
employees	Ort2	varchar	50	√		null
goldberg_menu_items	parent_id	int	10	√		null
goldberg_roles	parent_id	int	10	√		null
posper_category	parent_id	varchar	255	√		null	-
posper_ticket	parent_id	varchar	255	√		null	Related Cashregister, can alo be a CANELED-Register or a delivery invoice
posper_ticketline	parent_id	varchar	255	√		null	-
posper_permission	parent_name	varchar	255	√		null	-
goldberg_users	password	varchar	255	√		null
goldberg_users	password_changed_at	datetime	19	√		null
goldberg_users	password_expired	bit	0	√		null
goldberg_users	password_salt	varchar	255	√		null
goldberg_system_settings	permission_denied_page_id	int	10	√		null
goldberg_content_pages	permission_id	int	10	√		null
goldberg_controller_actions	permission_id	int	10	√		null
goldberg_roles_permissions	permission_id	int	10	√		null
goldberg_site_controllers	permission_id	int	10	√		null
posper_role_permission	permissions_name	varchar	255
posper_customer	phone	varchar	255	√		null	-
speps_suppliers	phone	varchar	255	√		null
posper_customer	phone1	varchar	255	√		null	-
posper_ticket	place_id	varchar	255	√		null	-
plugin_schema_info	plugin_name	varchar	255	√		null
employees	PLZ	varchar	10	√		null
locations	PLZ	varchar	10	√		null
employees	PLZ2	varchar	10	√		null
employees	position_id	int	10	√		null
posper_customer	postal	varchar	255	√		null	-
posper_customer	postal1	varchar	255	√		null	-
speps_suppliers	postcode	varchar	255	√		null
posper_category	prep_time	smallint	5	√		null	Preparation time. For restaurant use with Enjoy
posper_product	prep_time	smallint	5	√		null	Preparation time
posper_stockdiary	price	double	22				Buy price net
bo_new_prices	price_buy_new	double	22	√		null
bo_new_prices	price_new	double	22	√		null
posper_product	priceBase	double	22	√		null	For weighable products
posper_product	priceBuy	double	22				-
posper_specialprice	priceBuy	double	22	√		null	buy price net
speps_suporderlines	priceBuy	float	12	√		null
posper_ticketline	priceOrig	double	22	√		null
posper_product	priceSell	double	22				-
posper_specialprice	priceSell	double	22	√		null	Sell price net
posper_stockdiary	priceSell	double	22	√		null	Sell price net
posper_ticketline	priceSell	double	22				Sell price net at time of sales
posper_product	priceSell_1	double	22	√		null	-
posper_product	priceSell_2	double	22	√		null	-
bo_price_labels	print_flags	int	10	√		null
employees	Probezeit	bit	0	√		null
bo_new_prices	product_id	varchar	255	√		null
bo_price_labels	product_id	varchar	255	√		null
posper_customerdiscounts	product_id	varchar	255				-
posper_product_tax	Product_id	varchar	255
posper_productean	product_id	varchar	255				-
posper_productlocation	product_id	varchar	255				-
posper_specialprice	product_id	varchar	255				-
posper_stockdiary	product_id	varchar	255				-
posper_ticketline	product_id	varchar	255	√		null	-
posper_web_info	product_id	varchar	255	√		null	-
sales_all	PRODUCT_ID	varchar	255	√		null	-
speps_suporderlines	product_id	varchar	255	√		null
posper_property	property_key	varchar	255
posper_ticketline	protect	bit	1	√		null
posper_course	protected	bit	0	√		null	Cannot be reassigned by client
posper_customer	provState	varchar	255	√		null	-
posper_customer	provState1	varchar	255	√		null	-
goldberg_system_settings	public_role_id	int	10	√		null
posper_product	quantity_unit	varchar	10	√		null	Used by Backoffice for price labels
posper_tax	rate	double	22				Tax rate decimal 0..1
posper_discountreason	reason	varchar	255				-
posper_stockdiary	reason	int	10				Reason codes: 1=in_purchase 2=in_refund 4=in_movement -1=out_sale -2=out_refund -3=out_break -4=out_movement
sales_all	RECEIPT	int	10	√		null	Serial number for closed sales tickets
bo_translations	record_id	varchar	255	√		null
posper_ticket	reference	int	10	√		null
memberaccounts	register	smallint	5	√		null
posper_product	repl_avail_date	date	10	√		null	Availability of replacement product
posper_product	repl_code	varchar	255	√		null	Code of replacement product
posper_product	repl_date	date	10	√		null	Replacement date
account_conversion_rules	replacement	varchar	255	√		null
posper_specialprice	replacement_id	varchar	255	√		null	obsolete, replaced by posper_product.repl_code
posper_reservation	reservationDate	datetime	19	√		null	Start of reservation
posper_ticketline	reserved	bit	1	√		null
posper_reservation	resource_id	varchar	255	√		null	e.g. line_id
posper_imageresource	resource_key	varchar	255
posper_resource	resource_key	varchar	255
posper_reservation	resourceType	varchar	255	√		null	customized
employees	Resturlaub	int	10	√		null
goldberg_roles_permissions	role_id	int	10	√		null
goldberg_users	role_id	int	10	√		null
posper_role_permission	Role_name	varchar	255
posper_user	role_name	varchar	255				-
employees	Schule	varchar	20	√		null
posper_ticketline	seat	int	10	√		null	Documentary
goldberg_system_settings	self_reg_confirmation_error_page_id	int	10	√		null
goldberg_system_settings	self_reg_confirmation_required	bit	0	√		null
goldberg_users	self_reg_confirmation_required	bit	0	√		null
goldberg_system_settings	self_reg_enabled	bit	0	√		null
goldberg_system_settings	self_reg_role_id	int	10	√		null
goldberg_system_settings	self_reg_send_confirmation_email	bit	0	√		null
goldberg_menu_items	seq	int	10	√		null
posper_payment	serial	int	10	√		null	Serial nuber for not sales related in and out payments.
posper_paymentserialgenerator	serial	int	10	√		null	-
posper_cashregister	serialnr	int unsigned	10	√		null	Gapless number for register periods by host.
posper_valuecard	series	int	10	√		null	Creation series.
goldberg_system_settings	session_expired_page_id	int	10	√		null
sessions	session_id	varchar	255
posper_ticket	signature	text	65535	√		null
goldberg_controller_actions	site_controller_id	int	10	√		null
goldberg_system_settings	site_default_page_id	int	10	√		null
goldberg_system_settings	site_name_de	varchar	255	√		null
goldberg_system_settings	site_name_en	varchar	255	√		null
goldberg_system_settings	site_subtitle_de	varchar	255	√		null
goldberg_system_settings	site_subtitle_en	varchar	255	√		null
goldberg_system_settings	site_url_prefix	varchar	255	√		null
posper_reservation	slotLength	int	10	√		null	Lenght of reservation slot in min
posper_reservation	slots	int	10	√		null	Number of slots
employees	SonderVb	varchar	255	√		null
account_conversion_rules	source_field	varchar	255	√		null
employees	SozNr	varchar	15	√		null
rosters	start_0	time	8	√		null
rosters	start_1	time	8	√		null
rosters	start_2	time	8	√		null
rosters	start_3	time	8	√		null
rosters	start_4	time	8	√		null
rosters	start_5	time	8	√		null
rosters	start_6	time	8	√		null
goldberg_roles	start_path	varchar	255	√		null
goldberg_system_settings	start_path	varchar	255	√		null
goldberg_users	start_path	varchar	255	√		null
bo_invoices	status	int	10	√		null
posper_ticketline	status	tinyint	3	√		null	Used with Enjoy only
employees	Steuerklasse	int	10	√		null
employees	Steuernummer	varchar	20	√		null
posper_product	stockCost	double	22	√		null	doc only
posper_productlocation	stockMaximum	double	22	√		null	Used by Backoffice to calculate an order proposal
posper_productlocation	stockSecurity	double	22	√		null	Used by Backoffice for stock warning
posper_customer	street	varchar	255	√		null	-
speps_suppliers	street	varchar	255	√		null
posper_customer	street1	varchar	255	√		null	-
bo_uitranslations	string_id	varchar	255	√		null
speps_suporderlines	suporder_id	int	10	√		null
speps_suporders	supplier_id	int	10	√		null
posper_currency	symbol	varchar	3	√		null	-
posper_stockdiary	synced	bit	0	√		null
posper_ticket	synched	bit	0	√		null	Used with ERP systems
bo_translations	table_id	int	10	√		null
bo_trcolumns	table_id	int	10	√		null
bo_trtables	table_name	varchar	255	√		null
DATABASECHANGELOG	TAG	varchar	255	√		null
posper_tare	tare	int	10				Tare in grams
posper_product	tare_id	varchar	255	√		null	Link to tare for weighable
account_conversion_rules	target_field	varchar	255	√		null
employees	Tarif	varchar	5	√		null
rosters	task_0	varchar	10	√		null
rosters	task_1	varchar	10	√		null
rosters	task_2	varchar	10	√		null
rosters	task_3	varchar	10	√		null
rosters	task_4	varchar	10	√		null
rosters	task_5	varchar	10	√		null
rosters	task_6	varchar	10	√		null
posper_customer	tax_id	varchar	255	√		null	not used
posper_ticketline	tax_id	varchar	255				-
posper_tax	tax_name	varchar	255				-
posper_product_tax	taxes_id	varchar	255
posper_ticketline_tax	taxes_id	varchar	255
speps_suppliers	taxId	varchar	255	√		null
posper_customer	taxIdentifier	varchar	255	√		null	-
posper_ticketline	taxRate	double	22				Decimal tax rate 0..1 at time of sales
sales_all	TAXRATE	double	22				Decimal tax rate 0..1 at time of sales
posper_customer	termOfPayment	int	10	√		null	-
posper_resource	text	longtext	2147483647	√		null	The resource content
posper_payment	ticket_id	varchar	255	√		null	Referrence to ticket.
posper_ticketline	ticket_ticketline	varchar	255	√		null	Reference to posper_ticket
sales_all	TICKETCUSTNAME	varchar	255	√		null
sales_all	TICKETDEPARTMNT	varchar	255	√		null	-
posper_ticketline_tax	TicketLine_id	varchar	255
sales_all	TIMECLOSE	datetime	19	√		null	-
posper_category	timed_availability	varchar	255	√		null
posper_product	timed_availability	varchar	255	√		null
posper_product	timed_availability_to	datetime	19	√		null	-
posper_specialprice	timer	varchar	255	√		null	timer string similar to cron expressions
goldberg_content_pages	title_de	varchar	255	√		null
goldberg_content_pages	title_en	varchar	255	√		null
memberaccounts	trans_type	varchar	10	√		null
memberaccounts	transaction_id	varchar	255	√		null
bo_translations	translation	text	65535	√		null
bo_uitranslations	translation	varchar	255	√		null
employees	TStd	float	12	√		null
posper_ticket	turnover	decimal	19,2	√		null
posper_ticketidgenerator	turnover	bigint	19	√		null
sales_all	TYPE	varchar	10	√		null
posper_stockdiary	units	double	22				Number of units
account_conversion_rules	updated_at	datetime	19	√		null
bo_invoices	updated_at	datetime	19	√		null
bo_price_labels	updated_at	datetime	19	√		null
goldberg_content_pages	updated_at	datetime	19	√		null
goldberg_roles	updated_at	datetime	19	√		null
memberaccounts	updated_at	datetime	19	√		null
posper_category	updated_at	datetime	19	√		null	-
posper_product	updated_at	datetime	19	√		null	-
posper_reservation	updated_at	datetime	19	√		null	-
posper_ticket	updated_at	datetime	19	√		null	-
posper_ticketline	updated_at	datetime	19	√		null	-
sessions	updated_at	datetime	19	√		null
goldberg_controller_actions	url_to_use	varchar	255	√		null
employees	Urlaub	int	10	√		null
posper_customer	user_field_1	varchar	255	√		null	-
posper_customergroup	user_field_1	varchar	255	√		null	-
speps_suppliers	user_field_1	varchar	255	√		null
posper_customer	user_field_2	varchar	255	√		null	-
posper_customergroup	user_field_2	varchar	255	√		null	-
speps_suppliers	user_field_2	varchar	255	√		null
speps_suppliers	user_field_3	varchar	255	√		null
speps_suppliers	user_field_4	varchar	255	√		null
employees	user_id	varchar	255	√		null
posper_customer	user_id	int	10	√		null	Reference to a Backoffice user.
posper_logintime	user_id	varchar	255	√		null	-
posper_place	user_id	varchar	255	√		null	-
posper_ticketline	user_id	varchar	255	√		null	-
posper_user	user_password	varchar	255	√		null	User PIN, encrypted
posper_ticket	userid	varchar	255	√		null	-
timeaccounts	vacation_month_act	int	10	√		null
timeaccounts	vacation_year_nom	int	10	√		null
bo_new_prices	valid_as_of	datetime	19	√		null
posper_valuecard	valid_from	datetime	19	√		null	-
posper_valuecard	valid_to	datetime	19	√		null	-
posper_property	value	varchar	255	√		null	The value assigned. No escapes like in property files are necessary
posper_web_info	value	text	65535	√		null	URL
plugin_schema_info	version	int	10	√		null
posper_cashregister	version	int	10				Used for optimistic locking
posper_course	version	int	10	√		null	Used for optimistic locking
posper_currency	version	int	10				Used for optimistic locking
posper_customer	version	int	10				Used for optimistic locking
posper_customergroup	version	int	10				Used for optimistic locking
posper_discountreason	version	int	10				Used for optimistic locking
posper_floor	version	int	10				Used for optimistic locking
posper_image	version	int	10				Used for optimistic locking
posper_location	version	int	10				Used for optimistic locking
posper_logintime	version	int	10				Used for optimistic locking
posper_payment	version	int	10				Used for optimistic locking
posper_place	version	int	10				Used for optimistic locking
posper_reservation	version	int	10				Used for optimistic locking
posper_resource	version	int	10				Used for optimistic locking
posper_stockdiary	version	int	10				Used for optimistic locking
posper_tare	version	int	10				Used for optimistic locking
posper_tax	version	int	10				Used for optimistic locking
posper_ticket	version	int	10				Used for optimistic locking
posper_ticketline	version	int	10				Used for optimistic locking
posper_user	version	int	10				Used for optimistic locking
posper_valuecard	version	int	10				Used for optimistic locking
schema_migrations	version	varchar	255
posper_user	visible	bit	0				-
posper_category	visibleId	int	10	√		null	-
posper_floor	visibleId	int	10	√		null	-
posper_location	visibleId	int	10	√		null	-
posper_tare	visibleId	int	10	√		null	-
posper_tax	visibleId	int	10	√		null	-
posper_ticket	visibleId	int	10	√		null	-
posper_valuecard	visibleId	int	10				-
posper_product	volume	double	22	√		null	doc only
employees	Vorname	varchar	40	√		null
employees	VWL	float	12	√		null
posper_product	web_info_available	bit	0	√		null
employees	WStd	float	12	√		null
posper_place	x	int	10				pixel from left
posper_place	y	int	10				pixel from top
sales_all	ZCLOSE	datetime	19	√		null	End of register period.
employees	Zeitkonto	float	12	√		null
sales_all	ZNR	int unsigned	10	√		null	Gapless number for register periods by host.
posper_product	unitType	varchar	255	√		Stk	-