testdb.public contains 339 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
wms_inv_product	c_account	varchar	255	√		null
wms_inv_product_log	c_account	varchar	255	√		null
wms_inv_transport_unit	c_acknowledged	bool	1	√		null
wms_inv_packaging_unit	c_actual_location	int8	19	√		null
wms_inv_packaging_unit_log	c_actual_location	int8	19	√		null
wms_inv_transport_unit	c_actual_location	int8	19
wms_inv_transport_unit	c_actual_location_date	timestamp	29,6	√		null
wms_inv_location	c_aisle	varchar	4
wms_inv_location_log	c_aisle	varchar	4	√		null
wms_inv_packaging_unit	c_alive	bool	1	√		null
wms_inv_packaging_unit_log	c_alive	bool	1	√		null
wms_inv_product_stacking_rule	c_allowed_product	int8	19
wms_inv_location	c_area	varchar	4
wms_inv_location_log	c_area	varchar	4	√		null
wms_inv_packaging_unit	c_av_state	varchar	255
wms_inv_packaging_unit_log	c_av_state	varchar	255	√		null
wms_inv_product	c_av_state	varchar	255	√		null
wms_inv_product_log	c_av_state	varchar	255	√		null
wms_inv_product_stacking_rule	c_base_product	int8	19
wms_inv_product	c_base_unit_qty	varchar	16
wms_inv_product_log	c_base_unit_qty	varchar	16	√		null
wms_inv_product	c_base_unit_type	varchar	255
wms_inv_product_log	c_base_unit_type	varchar	255	√		null
wms_inv_location	c_classification	varchar	255	√		null
wms_inv_location_log	c_classification	varchar	255	√		null
wms_inv_product	c_classification	varchar	255	√		null
wms_inv_product_log	c_classification	varchar	255	√		null
wms_inv_product_unit	c_code	varchar	255	√		null
wms_inv_product_unit_log	c_code	varchar	255	√		null
wms_inv_load_unit	c_created	timestamp	29,6	√		null
wms_inv_load_unit_log	c_created	timestamp	29,6	√		null
wms_inv_load_unit_type	c_created	timestamp	29,6	√		null
wms_inv_location	c_created	timestamp	29,6	√		null
wms_inv_location_log	c_created	timestamp	29,6	√		null
wms_inv_packaging_unit	c_created	timestamp	29,6	√		null
wms_inv_packaging_unit_log	c_created	timestamp	29,6	√		null
wms_inv_product	c_created	timestamp	29,6	√		null
wms_inv_product_log	c_created	timestamp	29,6	√		null
wms_inv_product_stacking_rule	c_created	timestamp	29,6	√		null
wms_inv_product_unit	c_created	timestamp	29,6	√		null
wms_inv_product_unit_log	c_created	timestamp	29,6	√		null
wms_inv_reservation	c_created	timestamp	29,6	√		null
wms_inv_reservation_log	c_created	timestamp	29,6	√		null
wms_inv_transport_unit	c_created	timestamp	29,6	√		null
wms_inv_load_unit	c_created_by	varchar	255	√		null
wms_inv_load_unit_log	c_created_by	varchar	255	√		null
wms_inv_load_unit_type	c_created_by	varchar	255	√		null
wms_inv_location	c_created_by	varchar	255	√		null
wms_inv_location_log	c_created_by	varchar	255	√		null
wms_inv_packaging_unit	c_created_by	varchar	255	√		null
wms_inv_packaging_unit_log	c_created_by	varchar	255	√		null
wms_inv_product	c_created_by	varchar	255	√		null
wms_inv_product_log	c_created_by	varchar	255	√		null
wms_inv_product_stacking_rule	c_created_by	varchar	255	√		null
wms_inv_product_unit	c_created_by	varchar	255	√		null
wms_inv_product_unit_log	c_created_by	varchar	255	√		null
wms_inv_reservation	c_created_by	varchar	255	√		null
wms_inv_reservation_log	c_created_by	varchar	255	√		null
wms_inv_transport_unit	c_created_by	varchar	255	√		null
wms_inv_transport_unit	c_customer_order_id	varchar	255	√		null
wms_inv_load_unit_type	c_description	varchar	255	√		null
wms_inv_location	c_description	varchar	255	√		null
wms_inv_location_log	c_description	varchar	255	√		null
wms_inv_product	c_description	varchar	255	√		null
wms_inv_product_log	c_description	varchar	255	√		null
wms_inv_product_unit	c_description	varchar	255	√		null
wms_inv_product_unit_log	c_description	varchar	255	√		null
wms_inv_product	c_description_text	oid	10	√		null
wms_inv_product_log	c_description_text	oid	10	√		null
wms_inv_location	c_direct_booking_allowed	bool	1	√		null
wms_inv_location_log	c_direct_booking_allowed	bool	1	√		null
wms_inv_location	c_erp_code	varchar	255	√		null
wms_inv_location_log	c_erp_code	varchar	255	√		null
wms_inv_packaging_unit	c_expires_at	timestamp	22	√		null
wms_inv_packaging_unit_log	c_expires_at	timestamp	22	√		null
wms_inv_packaging_unit	c_fifo_date	timestamp	29,6	√		null
wms_inv_packaging_unit_log	c_fifo_date	timestamp	29,6	√		null
wms_inv_location	c_foreign_pid	varchar	255	√		null
wms_inv_location_log	c_foreign_pid	varchar	255	√		null
wms_inv_transport_unit	c_foreign_pid	varchar	255	√		null
wms_inv_product	c_group	varchar	255	√		null
wms_inv_product_log	c_group	varchar	255	√		null
wms_inv_load_unit	c_height	int4	10	√		null
wms_inv_load_unit_log	c_height	int4	10	√		null
wms_inv_packaging_unit	c_height	int4	10	√		null
wms_inv_packaging_unit_log	c_height	int4	10	√		null
wms_inv_product	c_height	int4	10	√		null
wms_inv_product_log	c_height	int4	10	√		null
wms_inv_product_unit	c_height	int4	10	√		null
wms_inv_product_unit_log	c_height	int4	10	√		null
wms_inv_transport_unit	c_height	int4	10	√		null
wms_inv_location	c_incoming_active	bool	1	√		null
wms_inv_location_log	c_incoming_active	bool	1	√		null
wms_inv_load_unit_type	c_inner_height	int4	10	√		null
wms_inv_load_unit_type	c_inner_length	int4	10	√		null
wms_inv_load_unit_type	c_inner_width	int4	10	√		null
wms_inv_packaging_unit_detail	c_key	varchar	255
wms_inv_packaging_unit_detail_log	c_key	varchar	255
wms_inv_product_detail	c_key	varchar	255
wms_inv_product_unit_detail	c_key	varchar	255
wms_inv_product_unit_detail_log	c_key	varchar	255
wms_inv_load_unit	c_label	varchar	255	√		null
wms_inv_load_unit_log	c_label	varchar	255	√		null
wms_inv_product	c_label	varchar	255	√		null
wms_inv_product_log	c_label	varchar	255	√		null
wms_inv_product_unit	c_label	varchar	255	√		null
wms_inv_product_unit_log	c_label	varchar	255	√		null
wms_inv_packaging_unit	c_labels	varchar	1024	√		null
wms_inv_packaging_unit_log	c_labels	varchar	1024	√		null
wms_inv_location	c_last_inventory_date	timestamp	22	√		null
wms_inv_location_log	c_last_inventory_date	timestamp	22	√		null
wms_inv_location	c_last_pick_date	timestamp	22	√		null
wms_inv_location_log	c_last_pick_date	timestamp	22	√		null
wms_inv_load_unit	c_length	int4	10	√		null
wms_inv_load_unit_log	c_length	int4	10	√		null
wms_inv_packaging_unit	c_length	int4	10	√		null
wms_inv_packaging_unit_log	c_length	int4	10	√		null
wms_inv_product	c_length	int4	10	√		null
wms_inv_product_log	c_length	int4	10	√		null
wms_inv_product_unit	c_length	int4	10	√		null
wms_inv_product_unit_log	c_length	int4	10	√		null
wms_inv_transport_unit	c_length	int4	10	√		null
wms_inv_packaging_unit	c_load_unit	int8	19	√		null
wms_inv_packaging_unit_log	c_load_unit	int8	19	√		null
wms_inv_load_unit	c_load_unit_type	varchar	255
wms_inv_location	c_location_group	varchar	255	√		null
wms_inv_location_log	c_location_group	varchar	255	√		null
wms_inv_load_unit	c_locked	bool	1	√		null
wms_inv_load_unit_log	c_locked	bool	1	√		null
wms_inv_packaging_unit	c_lot_id	varchar	255	√		null
wms_inv_packaging_unit_log	c_lot_id	varchar	255	√		null
wms_inv_packaging_unit	c_message_no	int4	10	√		null
wms_inv_packaging_unit_log	c_message_no	int4	10	√		null
wms_inv_packaging_unit	c_message_text	varchar	255	√		null
wms_inv_packaging_unit_log	c_message_text	varchar	255	√		null
wms_inv_load_unit	c_mixed_products	bool	1	√		null
wms_inv_load_unit_log	c_mixed_products	bool	1	√		null
wms_inv_location	c_mixed_products	bool	1	√		null
wms_inv_location_log	c_mixed_products	bool	1	√		null
wms_inv_location	c_no_max_transport_units	int4	10	√		null
wms_inv_location_log	c_no_max_transport_units	int4	10	√		null
wms_inv_product_stacking_rule	c_no_products	int4	10
wms_inv_load_unit	c_ol	int8	19	√		null
wms_inv_load_unit_type	c_ol	int8	19	√		null
wms_inv_location	c_ol	int8	19	√		null
wms_inv_packaging_unit	c_ol	int8	19	√		null
wms_inv_product	c_ol	int8	19	√		null
wms_inv_product_stacking_rule	c_ol	int8	19	√		null
wms_inv_product_unit	c_ol	int8	19	√		null
wms_inv_reservation	c_ol	int8	19	√		null
wms_inv_transport_unit	c_ol	int8	19	√		null
wms_inv_load_unit_type	c_outer_height	int4	10	√		null
wms_inv_load_unit_type	c_outer_length	int4	10	√		null
wms_inv_load_unit_type	c_outer_width	int4	10	√		null
wms_inv_location	c_outgoing_active	bool	1	√		null
wms_inv_location_log	c_outgoing_active	bool	1	√		null
wms_inv_product	c_overbooking_allowed	bool	1
wms_inv_product_log	c_overbooking_allowed	bool	1	√		null
wms_inv_reservation	c_packaging_unit_pk	int8	19
wms_inv_reservation_log	c_packaging_unit_pk	int8	19	√		null
wms_inv_packaging_unit	c_parent	int8	19	√		null
wms_inv_packaging_unit_log	c_parent	int8	19	√		null
wms_inv_load_unit	c_physical_pos	varchar	255
wms_inv_load_unit_log	c_physical_pos	varchar	255	√		null
wms_inv_packaging_unit	c_physical_pos	varchar	255	√		null
wms_inv_packaging_unit_log	c_physical_pos	varchar	255	√		null
wms_inv_load_unit	c_pid	varchar	255
wms_inv_load_unit_log	c_pid	varchar	255	√		null
wms_inv_load_unit_type	c_pid	varchar	255
wms_inv_location	c_pid	varchar	255
wms_inv_location_log	c_pid	varchar	255	√		null
wms_inv_packaging_unit	c_pid	varchar	255
wms_inv_packaging_unit_log	c_pid	varchar	255	√		null
wms_inv_product	c_pid	varchar	255
wms_inv_product_log	c_pid	varchar	255	√		null
wms_inv_product_stacking_rule	c_pid	varchar	255
wms_inv_product_unit	c_pid	varchar	255
wms_inv_product_unit_log	c_pid	varchar	255	√		null
wms_inv_reservation	c_pid	varchar	255
wms_inv_reservation_log	c_pid	varchar	255	√		null
wms_inv_transport_unit	c_pid	varchar	255
wms_inv_load_unit	c_pk	int8	19
wms_inv_load_unit_log	c_pk	int8	19
wms_inv_load_unit_type	c_pk	int8	19
wms_inv_location	c_pk	int8	19
wms_inv_location_log	c_pk	int8	19
wms_inv_packaging_unit	c_pk	int8	19
wms_inv_packaging_unit_log	c_pk	int8	19
wms_inv_product	c_pk	int8	19
wms_inv_product_log	c_pk	int8	19
wms_inv_product_stacking_rule	c_pk	int8	19
wms_inv_product_unit	c_pk	int8	19
wms_inv_product_unit_log	c_pk	int8	19
wms_inv_reservation	c_pk	int8	19
wms_inv_reservation_log	c_pk	int8	19
wms_inv_revision	c_pk	int8	19
wms_inv_transport_unit	c_pk	int8	19
wms_inv_location	c_plc_state	int4	10	√		null
wms_inv_location_log	c_plc_state	int4	10	√		null
wms_inv_product	c_preferable_storage_location	int8	19	√		null
wms_inv_product_log	c_preferable_storage_location	int8	19	√		null
wms_inv_packaging_unit	c_produced_at	timestamp	22	√		null
wms_inv_packaging_unit_log	c_produced_at	timestamp	22	√		null
wms_inv_load_unit	c_product_pk	int8	19	√		null
wms_inv_load_unit_log	c_product_pk	int8	19	√		null
wms_inv_packaging_unit	c_product_pk	int8	19	√		null
wms_inv_packaging_unit_log	c_product_pk	int8	19	√		null
wms_inv_product_detail	c_product_pk	int8	19
wms_inv_product_unit	c_product_pk	int8	19
wms_inv_product_unit_log	c_product_pk	int8	19	√		null
wms_inv_product_unit_detail	c_product_unit_pk	int8	19
wms_inv_product_unit_detail_log	c_product_unit_pk	int8	19
wms_inv_packaging_unit_detail	c_pu_pk	int8	19
wms_inv_packaging_unit_detail_log	c_pu_pk	int8	19
wms_inv_packaging_unit	c_qty	varchar	16
wms_inv_packaging_unit_log	c_qty	varchar	16	√		null
wms_inv_product_unit	c_qty	varchar	16
wms_inv_product_unit_log	c_qty	varchar	16	√		null
wms_inv_reservation	c_qty_reserved	varchar	16	√		null
wms_inv_reservation_log	c_qty_reserved	varchar	16	√		null
wms_inv_packaging_unit	c_qty_type	varchar	255
wms_inv_packaging_unit_log	c_qty_type	varchar	255	√		null
wms_inv_product_unit	c_qty_type	varchar	255
wms_inv_product_unit_log	c_qty_type	varchar	255	√		null
wms_inv_reservation	c_qty_type_reserved	varchar	255	√		null
wms_inv_reservation_log	c_qty_type_reserved	varchar	255	√		null
wms_inv_transport_unit	c_reconciled_at	timestamp	22	√		null
wms_inv_transport_unit	c_reconciled_by	varchar	255	√		null
wms_inv_reservation	c_reserved_at	timestamp	22	√		null
wms_inv_reservation_log	c_reserved_at	timestamp	22	√		null
wms_inv_reservation	c_reserved_by	varchar	255	√		null
wms_inv_reservation_log	c_reserved_by	varchar	255	√		null
wms_inv_load_unit_log	c_rev	int8	19
wms_inv_location_log	c_rev	int8	19
wms_inv_packaging_unit_detail_log	c_rev	int8	19
wms_inv_packaging_unit_log	c_rev	int8	19
wms_inv_product_log	c_rev	int8	19
wms_inv_product_unit_detail_log	c_rev	int8	19
wms_inv_product_unit_log	c_rev	int8	19
wms_inv_reservation_log	c_rev	int8	19
wms_inv_load_unit_log	c_rev_type	int2	5	√		null
wms_inv_location_log	c_rev_type	int2	5	√		null
wms_inv_packaging_unit_detail_log	c_rev_type	int2	5	√		null
wms_inv_packaging_unit_log	c_rev_type	int2	5	√		null
wms_inv_product_log	c_rev_type	int2	5	√		null
wms_inv_product_unit_detail_log	c_rev_type	int2	5	√		null
wms_inv_product_unit_log	c_rev_type	int2	5	√		null
wms_inv_reservation_log	c_rev_type	int2	5	√		null
wms_inv_packaging_unit	c_serial_number	varchar	255	√		null
wms_inv_packaging_unit_log	c_serial_number	varchar	255	√		null
wms_inv_product	c_sku	varchar	255
wms_inv_product_log	c_sku	varchar	255	√		null
wms_inv_location	c_sort	int4	10	√		null
wms_inv_location_log	c_sort	int4	10	√		null
wms_inv_transport_unit	c_state	varchar	255	√		null
wms_inv_location	c_stock_zone	varchar	255	√		null
wms_inv_location_log	c_stock_zone	varchar	255	√		null
wms_inv_product	c_stock_zone	varchar	255	√		null
wms_inv_product_log	c_stock_zone	varchar	255	√		null
wms_inv_transport_unit	c_target	varchar	255	√		null
wms_inv_revision	c_timestamp	int8	19	√		null
wms_inv_revision	c_trace_id	varchar	255	√		null
wms_inv_transport_unit	c_transport_unit_bk	varchar	255
wms_inv_load_unit	c_transport_unit_pk	int8	19
wms_inv_transport_unit	c_transport_unit_type	varchar	255
wms_inv_load_unit_type	c_type	varchar	255
wms_inv_load_unit	c_uom	varchar	255	√		null
wms_inv_load_unit_log	c_uom	varchar	255	√		null
wms_inv_packaging_unit	c_uom	varchar	255	√		null
wms_inv_packaging_unit_log	c_uom	varchar	255	√		null
wms_inv_product	c_uom	varchar	255	√		null
wms_inv_product_log	c_uom	varchar	255	√		null
wms_inv_product_unit	c_uom	varchar	255	√		null
wms_inv_product_unit_log	c_uom	varchar	255	√		null
wms_inv_packaging_unit	c_uom_relation	int8	19	√		null
wms_inv_packaging_unit_log	c_uom_relation	int8	19	√		null
wms_inv_load_unit	c_updated	timestamp	29,6	√		null
wms_inv_load_unit_log	c_updated	timestamp	29,6	√		null
wms_inv_load_unit_type	c_updated	timestamp	29,6	√		null
wms_inv_location	c_updated	timestamp	29,6	√		null
wms_inv_location_log	c_updated	timestamp	29,6	√		null
wms_inv_packaging_unit	c_updated	timestamp	29,6	√		null
wms_inv_packaging_unit_log	c_updated	timestamp	29,6	√		null
wms_inv_product	c_updated	timestamp	29,6	√		null
wms_inv_product_log	c_updated	timestamp	29,6	√		null
wms_inv_product_stacking_rule	c_updated	timestamp	29,6	√		null
wms_inv_product_unit	c_updated	timestamp	29,6	√		null
wms_inv_product_unit_log	c_updated	timestamp	29,6	√		null
wms_inv_reservation	c_updated	timestamp	29,6	√		null
wms_inv_reservation_log	c_updated	timestamp	29,6	√		null
wms_inv_transport_unit	c_updated	timestamp	29,6	√		null
wms_inv_load_unit	c_updated_by	varchar	255	√		null
wms_inv_load_unit_log	c_updated_by	varchar	255	√		null
wms_inv_load_unit_type	c_updated_by	varchar	255	√		null
wms_inv_location	c_updated_by	varchar	255	√		null
wms_inv_location_log	c_updated_by	varchar	255	√		null
wms_inv_packaging_unit	c_updated_by	varchar	255	√		null
wms_inv_packaging_unit_log	c_updated_by	varchar	255	√		null
wms_inv_product	c_updated_by	varchar	255	√		null
wms_inv_product_log	c_updated_by	varchar	255	√		null
wms_inv_product_stacking_rule	c_updated_by	varchar	255	√		null
wms_inv_product_unit	c_updated_by	varchar	255	√		null
wms_inv_product_unit_log	c_updated_by	varchar	255	√		null
wms_inv_reservation	c_updated_by	varchar	255	√		null
wms_inv_reservation_log	c_updated_by	varchar	255	√		null
wms_inv_transport_unit	c_updated_by	varchar	255	√		null
wms_inv_revision	c_user	varchar	255	√		null
wms_inv_packaging_unit_detail	c_value	varchar	255	√		null
wms_inv_packaging_unit_detail_log	c_value	varchar	255
wms_inv_product_detail	c_value	varchar	255	√		null
wms_inv_product_unit_detail	c_value	varchar	255	√		null
wms_inv_product_unit_detail_log	c_value	varchar	255
wms_inv_packaging_unit	c_weight	varchar	255	√		null
wms_inv_packaging_unit_log	c_weight	varchar	255	√		null
wms_inv_product	c_weight	varchar	16	√		null
wms_inv_product_log	c_weight	varchar	16	√		null
wms_inv_load_unit_type	c_weight_max	varchar	255	√		null
wms_inv_load_unit_type	c_weight_max_type	varchar	255	√		null
wms_inv_load_unit_type	c_weight_tare	varchar	255	√		null
wms_inv_load_unit_type	c_weight_tare_type	varchar	255	√		null
wms_inv_packaging_unit	c_weight_type	varchar	255	√		null
wms_inv_packaging_unit_log	c_weight_type	varchar	255	√		null
wms_inv_product	c_weight_type	varchar	255	√		null
wms_inv_product_log	c_weight_type	varchar	255	√		null
wms_inv_load_unit	c_width	int4	10	√		null
wms_inv_load_unit_log	c_width	int4	10	√		null
wms_inv_packaging_unit	c_width	int4	10	√		null
wms_inv_packaging_unit_log	c_width	int4	10	√		null
wms_inv_product	c_width	int4	10	√		null
wms_inv_product_log	c_width	int4	10	√		null
wms_inv_product_unit	c_width	int4	10	√		null
wms_inv_product_unit_log	c_width	int4	10	√		null
wms_inv_transport_unit	c_width	int4	10	√		null
wms_inv_location	c_x	varchar	4
wms_inv_location_log	c_x	varchar	4	√		null
wms_inv_location	c_y	varchar	4
wms_inv_location_log	c_y	varchar	4	√		null
wms_inv_location	c_z	varchar	4
wms_inv_location_log	c_z	varchar	4	√		null