idempiere11.adempiere contains 263 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
ad_language	ad_client_id	numeric	10				Tenant for this installation.
c_addresstransaction	ad_client_id	numeric	10				Tenant for this installation.
c_addressvalidation	ad_client_id	numeric	10				Tenant for this installation.
c_addressvalidationcfg	ad_client_id	numeric	10				Tenant for this installation.
c_city	ad_client_id	numeric	10				Tenant for this installation.
c_country	ad_client_id	numeric	10				Tenant for this installation.
c_countrygroup	ad_client_id	numeric	10				Tenant for this installation.
c_countrygroupcountry	ad_client_id	numeric	10				Tenant for this installation.
c_currency	ad_client_id	numeric	10				Tenant for this installation.
c_location	ad_client_id	numeric	10				Tenant for this installation.
c_region	ad_client_id	numeric	10				Tenant for this installation.
m_locator	ad_client_id	numeric	10				Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Tenant for this installation.
ad_language	ad_language	varchar	6				Language for this entity
c_country	ad_language	varchar	6	√		null	Language for this entity
ad_language	ad_language_id	numeric	10				Language ID
ad_language	ad_language_uu	varchar	36	√		NULL::character varying	AD_Language_UU
ad_language	ad_org_id	numeric	10				Organizational entity within tenant
c_addresstransaction	ad_org_id	numeric	10				Organizational entity within tenant
c_addressvalidation	ad_org_id	numeric	10				Organizational entity within tenant
c_addressvalidationcfg	ad_org_id	numeric	10				Organizational entity within tenant
c_city	ad_org_id	numeric	10				Organizational entity within tenant
c_country	ad_org_id	numeric	10				Organizational entity within tenant
c_countrygroup	ad_org_id	numeric	10				Organizational entity within tenant
c_countrygroupcountry	ad_org_id	numeric	10				Organizational entity within tenant
c_currency	ad_org_id	numeric	10				Organizational entity within tenant
c_location	ad_org_id	numeric	10				Organizational entity within tenant
c_region	ad_org_id	numeric	10				Organizational entity within tenant
m_locator	ad_org_id	numeric	10				Organizational entity within tenant
m_warehouse	ad_org_id	numeric	10				Organizational entity within tenant
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
c_addresstransaction	address1	varchar	60	√		NULL::character varying	Address line 1 for this location
c_location	address1	varchar	60	√		null	Address line 1 for this location
c_addresstransaction	address2	varchar	60	√		NULL::character varying	Address line 2 for this location
c_location	address2	varchar	60	√		null	Address line 2 for this location
c_addresstransaction	address3	varchar	60	√		NULL::character varying	Address Line 3 for the location
c_location	address3	varchar	60	√		null	Address Line 3 for the location
c_addresstransaction	address4	varchar	60	√		NULL::character varying	Address Line 4 for the location
c_location	address4	varchar	60	√		null	Address Line 4 for the location
c_addresstransaction	address5	varchar	60	√		NULL::character varying	Address Line 5 for the location
c_location	address5	varchar	60	√		NULL::character varying	Address Line 5 for the location
c_addressvalidationcfg	addressvalidationclass	varchar	100	√		null	Address Validation Class
c_country	allowcitiesoutoflist	bpchar	1	√		'Y'::bpchar	A flag to allow cities, currently not in the list, to be entered
c_city	areacode	varchar	10	√		null	Phone Area Code
c_addresstransaction	c_addresstransaction_id	numeric	10				Address Transaction
c_addresstransaction	c_addresstransaction_uu	varchar	36	√		NULL::character varying	C_AddressTransaction_UU
c_addresstransaction	c_addressvalidation_id	numeric	10				Address Validation
c_addressvalidation	c_addressvalidation_id	numeric	10				Address Validation
c_location	c_addressvalidation_id	numeric	10	√		NULL::numeric	Address Validation
c_addressvalidation	c_addressvalidation_uu	varchar	36	√		NULL::character varying	C_AddressValidation_UU
c_addressvalidation	c_addressvalidationcfg_id	numeric	10				Address Validation Configuration
c_addressvalidationcfg	c_addressvalidationcfg_id	numeric	10				Address Validation Configuration
c_addressvalidationcfg	c_addressvalidationcfg_uu	varchar	36	√		NULL::character varying	C_AddressValidationCfg_UU
c_city	c_city_id	numeric	10				City
c_location	c_city_id	numeric	10	√		null	City
c_city	c_city_uu	varchar	36	√		NULL::character varying	C_City_UU
c_city	c_country_id	numeric	10	√		null	Country
c_country	c_country_id	numeric	10				Country
c_countrygroupcountry	c_country_id	numeric	10	√		NULL::numeric	Country
c_location	c_country_id	numeric	10				Country
c_region	c_country_id	numeric	10				Country
c_country	c_country_uu	varchar	36	√		NULL::character varying	C_Country_UU
c_countrygroup	c_countrygroup_id	numeric	10				Country Group
c_countrygroupcountry	c_countrygroup_id	numeric	10	√		NULL::numeric	Country Group
c_countrygroup	c_countrygroup_uu	varchar	36	√		NULL::character varying	C_CountryGroup_UU
c_countrygroupcountry	c_countrygroupcountry_id	numeric	10				Country on Country Group
c_countrygroupcountry	c_countrygroupcountry_uu	varchar	36	√		NULL::character varying	C_CountryGroupCountry_UU
c_country	c_currency_id	numeric	10	√		null	The Currency for this record
c_currency	c_currency_id	numeric	10				The Currency for this record
c_currency	c_currency_uu	varchar	36	√		NULL::character varying	C_Currency_UU
c_addresstransaction	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_location	c_location_id	numeric	10				Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
c_location	c_location_uu	varchar	36	√		NULL::character varying	C_Location_UU
c_city	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_location	c_region_id	numeric	10	√		null	Identifies a geographical Region
c_region	c_region_id	numeric	10				Identifies a geographical Region
c_region	c_region_uu	varchar	36	√		NULL::character varying	C_Region_UU
c_country	capturesequence	varchar	60	√		null	Capture Sequence
c_addresstransaction	city	varchar	60	√		NULL::character varying	Identifies a City
c_location	city	varchar	60	√		null	Identifies a City
c_addresstransaction	comments	varchar	2000	√		NULL::character varying	Comments or additional information
c_location	comments	varchar	2000	√		NULL::character varying	Comments or additional information
c_addressvalidation	connectionkey	varchar	60	√		NULL::character varying	Connection Key
c_addressvalidation	connectionpassword	varchar	60				Connection Password
c_city	coordinates	varchar	15	√		null	Location coordinate
c_currency	costingprecision	numeric	10				Rounding used costing calculations
c_addresstransaction	country	varchar	60	√		NULL::character varying	Country
ad_language	countrycode	bpchar	2	√		null	Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
c_country	countrycode	bpchar	2				Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_language	created	timestamp	29,6			now()	Date this record was created
c_addresstransaction	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_addressvalidation	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_addressvalidationcfg	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_city	created	timestamp	29,6			now()	Date this record was created
c_country	created	timestamp	29,6			now()	Date this record was created
c_countrygroup	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_countrygroupcountry	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_currency	created	timestamp	29,6			now()	Date this record was created
c_location	created	timestamp	29,6			now()	Date this record was created
c_region	created	timestamp	29,6			now()	Date this record was created
m_locator	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
ad_language	createdby	numeric	10				User who created this records
c_addresstransaction	createdby	numeric	10				User who created this records
c_addressvalidation	createdby	numeric	10				User who created this records
c_addressvalidationcfg	createdby	numeric	10				User who created this records
c_city	createdby	numeric	10				User who created this records
c_country	createdby	numeric	10				User who created this records
c_countrygroup	createdby	numeric	10				User who created this records
c_countrygroupcountry	createdby	numeric	10				User who created this records
c_currency	createdby	numeric	10				User who created this records
c_location	createdby	numeric	10				User who created this records
c_region	createdby	numeric	10				User who created this records
m_locator	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
c_currency	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
c_countrygroup	datefrom	timestamp	29,6	√		null	Starting date for a range
c_countrygroupcountry	datefrom	timestamp	29,6	√		null	Starting date for a range
ad_language	datepattern	varchar	20	√		null	Java Date Pattern
c_countrygroup	dateto	timestamp	29,6	√		null	End date of a date range
c_countrygroupcountry	dateto	timestamp	29,6	√		null	End date of a date range
c_addressvalidationcfg	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_country	description	varchar	255	√		null	Optional short description of the record
c_countrygroup	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_currency	description	varchar	255				Optional short description of the record
c_region	description	varchar	255	√		null	Optional short description of the record
m_warehouse	description	varchar	255	√		null	Optional short description of the record
c_country	displaysequence	varchar	20				Format for printing this Address
c_country	displaysequencelocal	varchar	20	√		null	Format for printing this Address locally
c_currency	emuentrydate	timestamp	29,6	√		null	Date when the currency joined / will join the EMU
c_currency	emurate	numeric	0	√		0	Official rate to the Euro
c_country	expressionbankaccountno	varchar	20	√		null	Format of the Bank Account
c_country	expressionbankroutingno	varchar	20	√		null	Format of the Bank Routing Number
c_country	expressionphone	varchar	20	√		null	Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	expressionpostal	varchar	20	√		null	Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	expressionpostal_add	varchar	20	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
c_country	haspostal_add	bpchar	1			'N'::bpchar	Has Additional Postal Code
c_country	hasregion	bpchar	1			'N'::bpchar	Country contains Regions
c_countrygroup	help	varchar	2000	√		NULL::character varying	Comment or Hint
c_addressvalidationcfg	hostaddress	varchar	60				Host Address URL or DNS
c_addressvalidationcfg	hostport	numeric	10				Host Communication Port
ad_language	isactive	bpchar	1			'N'::bpchar	The record is active in the system
c_addresstransaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_addressvalidation	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_addressvalidationcfg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_city	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_country	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_countrygroup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_countrygroupcountry	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_currency	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_location	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_region	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_country	isaddresslineslocalreverse	bpchar	1			'N'::bpchar	Print Local Address in reverse Order
c_country	isaddresslinesreverse	bpchar	1			'N'::bpchar	Print Address in reverse Order
ad_language	isbaselanguage	bpchar	1			'N'::bpchar	The system information is maintained in this language
ad_language	isdecimalpoint	bpchar	1	√		null	The number notation has a decimal point (no decimal comma)
c_region	isdefault	bpchar	1	√		'N'::bpchar	Default value
m_locator	isdefault	bpchar	1			'N'::bpchar	Default value
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_currency	isemumember	bpchar	1			'N'::bpchar	This currency is member if the European Monetary Union
c_currency	iseuro	bpchar	1			'N'::bpchar	This currency is the Euro
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
ad_language	isloginlocale	bpchar	1	√		'N'::bpchar	Login Locale
c_currency	iso_code	bpchar	3				Three letter ISO 4217 Code of the Currency
c_country	ispostcodelookup	bpchar	1			'N'::bpchar	Does this country have a post code web service
ad_language	issystemlanguage	bpchar	1			'N'::bpchar	The screens, etc. are maintained in this Language
c_addresstransaction	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_location	isvalid	bpchar	1	√		'N'::bpchar	Element is valid
ad_language	languageiso	bpchar	2	√		null	Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
c_city	locode	varchar	10	√		null	Location code - UN/LOCODE
c_country	lookupclassname	varchar	255	√		null	The class name of the postcode lookup plugin
c_country	lookupclientid	varchar	50	√		null	The Client ID or Login submitted to the Lookup URL
c_country	lookuppassword	varchar	50	√		null	The password submitted to the Lookup URL
c_country	lookupurl	varchar	100	√		null	The URL of the web service that the plugin connects to in order to retrieve postcode data
m_locator	m_locator_id	numeric	10				Warehouse Locator
m_locator	m_locator_uu	varchar	36	√		NULL::character varying	M_Locator_UU
m_locator	m_locatortype_id	numeric	10	√		NULL::numeric	Locator Type
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
m_locator	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
c_country	mediasize	varchar	40	√		null	Java Media Size
ad_language	name	varchar	60				Alphanumeric identifier of the entity
c_addressvalidation	name	varchar	60				Alphanumeric identifier of the entity
c_addressvalidationcfg	name	varchar	60				Alphanumeric identifier of the entity
c_city	name	varchar	60				Alphanumeric identifier of the entity
c_country	name	varchar	60				Alphanumeric identifier of the entity
c_countrygroup	name	varchar	60				Alphanumeric identifier of the entity
c_region	name	varchar	60				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
c_country	placeholderaddress1	varchar	255	√		NULL::character varying	Placeholder for Address 1
c_country	placeholderaddress2	varchar	255	√		NULL::character varying	Placeholder for Address 2
c_country	placeholderaddress3	varchar	255	√		NULL::character varying	Placeholder for Address 3
c_country	placeholderaddress4	varchar	255	√		NULL::character varying	Placeholder for Address 4
c_country	placeholderaddress5	varchar	255	√		NULL::character varying	Placeholder for Address 5
c_country	placeholdercity	varchar	255	√		NULL::character varying	Placeholder for city
c_country	placeholdercomments	varchar	255	√		NULL::character varying	Placeholder for comments
c_country	placeholderpostal	varchar	255	√		NULL::character varying	Placeholder for postal
c_country	placeholderpostal_add	varchar	255	√		NULL::character varying	Placeholder for additional zip
c_addresstransaction	postal	varchar	10	√		NULL::character varying	Postal code
c_city	postal	varchar	10	√		null	Postal code
c_location	postal	varchar	10	√		null	Postal code
c_location	postal_add	varchar	10	√		null	Additional ZIP or Postal code
ad_language	printname	varchar	60			NULL::character varying	The label text to be printed on a document or correspondence.
m_locator	priorityno	numeric	10				Where inventory should be picked from first
c_addresstransaction	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_language	processing	bpchar	1	√		null	Process Now
c_addressvalidationcfg	proxyaddress	varchar	60	√		NULL::character varying	Address of your proxy server
c_addressvalidationcfg	proxylogon	varchar	60	√		NULL::character varying	Logon of your proxy server
c_addressvalidationcfg	proxypassword	varchar	60	√		NULL::character varying	Password of your proxy server
c_addressvalidationcfg	proxyport	numeric	10	√		NULL::numeric	Port of your proxy server
c_addresstransaction	region	varchar	60	√		NULL::character varying	Region
c_country	regionname	varchar	60	√		null	Name of the Region
c_location	regionname	varchar	40	√		null	Name of the Region
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
c_addresstransaction	result	varchar	2000	√		NULL::character varying	Result of the action taken
c_location	result	varchar	2000	√		NULL::character varying	Result of the action taken
c_currency	roundofffactor	numeric	0	√		null	Used to Round Off Payment Amount
m_warehouse	separator	bpchar	1				Element Separator
c_addressvalidation	seqno	numeric	10				Method of ordering records; lowest number comes first
c_addressvalidationcfg	servicepath	varchar	60	√		NULL::character varying	Service Path
c_addressvalidation	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
c_addressvalidation	shippermeter	varchar	255	√		NULL::character varying	Shipper Meter
c_currency	stdprecision	numeric	10				Rule for rounding calculated amounts
ad_language	timepattern	varchar	20	√		null	Java Time Pattern
ad_language	updated	timestamp	29,6			now()	Date this record was updated
c_addresstransaction	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_addressvalidation	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_addressvalidationcfg	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_city	updated	timestamp	29,6			now()	Date this record was updated
c_country	updated	timestamp	29,6			now()	Date this record was updated
c_countrygroup	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_countrygroupcountry	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_currency	updated	timestamp	29,6			now()	Date this record was updated
c_location	updated	timestamp	29,6			now()	Date this record was updated
c_region	updated	timestamp	29,6			now()	Date this record was updated
m_locator	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
ad_language	updatedby	numeric	10				User who updated this records
c_addresstransaction	updatedby	numeric	10				User who updated this records
c_addressvalidation	updatedby	numeric	10				User who updated this records
c_addressvalidationcfg	updatedby	numeric	10				User who updated this records
c_city	updatedby	numeric	10				User who updated this records
c_country	updatedby	numeric	10				User who updated this records
c_countrygroup	updatedby	numeric	10				User who updated this records
c_countrygroupcountry	updatedby	numeric	10				User who updated this records
c_currency	updatedby	numeric	10				User who updated this records
c_location	updatedby	numeric	10				User who updated this records
c_region	updatedby	numeric	10				User who updated this records
m_locator	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
c_addressvalidation	userid	varchar	60				User ID or account number
c_location	validateaddress	bpchar	1	√		NULL::bpchar	Validate Address
c_countrygroup	value	varchar	40				Search key for the record in the format required - must be unique
m_locator	value	varchar	40				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
m_locator	x	varchar	60	√		null	X dimension, e.g., Aisle
m_locator	y	varchar	60	√		null	Y dimension, e.g., Bin
m_locator	z	varchar	60	√		null	Z dimension, e.g., Level