idempiere9.adempiere contains 96 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
ws_webservicetype	insertparameters	bpchar	1	√		NULL::bpchar	Create Default Parameters
ws_webservice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservice_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservicefieldinput	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservicefieldoutput	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservicemethod	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservicetype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservicetypeaccess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ws_webservicefieldinput	isidentifier	bpchar	1	√		'N'::bpchar	This column is part of the record identifier
ws_webservicefieldinput	isnullidentifier	bpchar	1	√		'N'::bpchar	Should allow null value for identifiere field
ws_webservicetypeaccess	isreadwrite	bpchar	1			'Y'::bpchar	Field is read / write
ws_webservice_para	parametertype	bpchar	1				Parameter Type
ws_webservice	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservice_para	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservicefieldinput	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservicefieldoutput	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservicemethod	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservicetype	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservicetypeaccess	ad_client_id	numeric	10				Client/Tenant for this installation.
ws_webservicefieldinput	ad_column_id	numeric	10	√		null	Column in the table
ws_webservicefieldoutput	ad_column_id	numeric	10	√		null	Column in the table
ws_webservice	ad_org_id	numeric	10				Organizational entity within client
ws_webservice_para	ad_org_id	numeric	10				Organizational entity within client
ws_webservicefieldinput	ad_org_id	numeric	10				Organizational entity within client
ws_webservicefieldoutput	ad_org_id	numeric	10				Organizational entity within client
ws_webservicemethod	ad_org_id	numeric	10				Organizational entity within client
ws_webservicetype	ad_org_id	numeric	10				Organizational entity within client
ws_webservicetypeaccess	ad_org_id	numeric	10				Organizational entity within client
ws_webservicefieldinput	ad_reference_id	numeric	10	√		NULL::numeric	System Reference and Validation
ws_webservicefieldinput	ad_reference_value_id	numeric	10	√		NULL::numeric	Required to specify, if data type is Table or List
ws_webservicetypeaccess	ad_role_id	numeric	10				Responsibility Role
ws_webservicetype	ad_table_id	numeric	10	√		null	Database Table information
ws_webservice	createdby	numeric	10				User who created this records
ws_webservice_para	createdby	numeric	10	√		null	User who created this records
ws_webservicefieldinput	createdby	numeric	10	√		null	User who created this records
ws_webservicefieldoutput	createdby	numeric	10	√		null	User who created this records
ws_webservicemethod	createdby	numeric	10				User who created this records
ws_webservicetype	createdby	numeric	10				User who created this records
ws_webservicetypeaccess	createdby	numeric	10				User who created this records
ws_webservice	updatedby	numeric	10				User who updated this records
ws_webservice_para	updatedby	numeric	10	√		null	User who updated this records
ws_webservicefieldinput	updatedby	numeric	10	√		null	User who updated this records
ws_webservicefieldoutput	updatedby	numeric	10	√		null	User who updated this records
ws_webservicemethod	updatedby	numeric	10				User who updated this records
ws_webservicetype	updatedby	numeric	10				User who updated this records
ws_webservicetypeaccess	updatedby	numeric	10				User who updated this records
ws_webservice	ws_webservice_id	numeric	10				Web Service
ws_webservicemethod	ws_webservice_id	numeric	10	√		null	Web Service
ws_webservicetype	ws_webservice_id	numeric	10				Web Service
ws_webservice_para	ws_webservice_para_id	numeric	10				Web Service Parameters
ws_webservicefieldinput	ws_webservicefieldinput_id	numeric	10				Web Service Field Input
ws_webservicefieldoutput	ws_webservicefieldoutput_id	numeric	10				Web Service Field Output
ws_webservicemethod	ws_webservicemethod_id	numeric	10				Web Service Method
ws_webservicetype	ws_webservicemethod_id	numeric	10				Web Service Method
ws_webservice_para	ws_webservicetype_id	numeric	10				Web Service Type
ws_webservicefieldinput	ws_webservicetype_id	numeric	10				Web Service Type
ws_webservicefieldoutput	ws_webservicetype_id	numeric	10				Web Service Type
ws_webservicetype	ws_webservicetype_id	numeric	10				Web Service Type
ws_webservicetypeaccess	ws_webservicetype_id	numeric	10				Web Service Type
ws_webservice	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservice_para	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservicefieldinput	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservicefieldoutput	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservicemethod	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservicetype	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservicetypeaccess	created	timestamp	29,6			statement_timestamp()	Date this record was created
ws_webservice	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservice_para	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservicefieldinput	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservicefieldoutput	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservicemethod	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservicetype	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservicetypeaccess	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ws_webservicefieldinput	columnname	varchar	30	√		NULL::character varying	Name of the column in the database
ws_webservice_para	ws_webservice_para_uu	varchar	36	√		NULL::character varying	WS_WebService_Para_UU
ws_webservice	ws_webservice_uu	varchar	36	√		NULL::character varying	WS_WebService_UU
ws_webservicefieldinput	ws_webservicefieldinput_uu	varchar	36	√		NULL::character varying	WS_WebServiceFieldInput_UU
ws_webservicefieldoutput	ws_webservicefieldoutput_uu	varchar	36	√		NULL::character varying	WS_WebServiceFieldOutput_UU
ws_webservicemethod	ws_webservicemethod_uu	varchar	36	√		NULL::character varying	WS_WebServiceMethod_UU
ws_webservicetype	ws_webservicetype_uu	varchar	36	√		NULL::character varying	WS_WebServiceType_UU
ws_webservicetypeaccess	ws_webservicetypeaccess_uu	varchar	36	√		NULL::character varying	WS_WebServiceTypeAccess_UU
ws_webservice	value	varchar	40				Search key for the record in the format required - must be unique
ws_webservicemethod	value	varchar	40				Search key for the record in the format required - must be unique
ws_webservicetype	value	varchar	40				Search key for the record in the format required - must be unique
ws_webservice	name	varchar	60				Alphanumeric identifier of the entity
ws_webservicemethod	name	varchar	60				Alphanumeric identifier of the entity
ws_webservicetype	name	varchar	60				Alphanumeric identifier of the entity
ws_webservice_para	parametername	varchar	60	√		null	Parameter Name
ws_webservice	description	varchar	255	√		null	Optional short description of the record
ws_webservicemethod	description	varchar	255	√		null	Optional short description of the record
ws_webservicetype	description	varchar	255	√		null	Optional short description of the record
ws_webservice_para	constantvalue	varchar	2000	√		null	Constant value
ws_webservice	help	varchar	2000	√		null	Comment or Hint
ws_webservicemethod	help	varchar	2000	√		null	Comment or Hint
ws_webservicetype	help	varchar	2000	√		null	Comment or Hint
ws_webservicefieldinput	identifierlogic	varchar	2000	√		null	Identifier Logic