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

Table	Column	Type	Size	Nulls	Auto	Default
ad_replicationstrategy	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_replicationtable	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_system	systemstatus	bpchar	1			'E'::bpchar	Status of the system - Support priority depends on system status
ad_replicationtable	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_system	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
ad_sequence	isaudited	bpchar	1	√		'N'::bpchar	Activate Audit Trail of what numbers are generated
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
ad_system	isjustmigrated	bpchar	1	√		'N'::bpchar	Value set by Migration for post-Migration tasks.
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
ad_sequence	istableid	bpchar	1	√		'N'::bpchar	The document number will be used as the record key
ad_sequence	startnewyear	bpchar	1	√		'N'::bpchar	Restart the sequence with Start on every 1/1
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
ad_system	isfailonbuilddiffer	bpchar	1			'N'::bpchar	Fail if Build Differ
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
ad_sequence	isorglevelsequence	bpchar	1			'N'::bpchar	This sequence can be defined for each organization
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
ad_replication_log	isreplicated	bpchar	1			'N'::bpchar	The data is successfully replicated
ad_replication_run	isreplicated	bpchar	1			'N'::bpchar	The data is successfully replicated
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_sequence	startnewmonth	bpchar	1			'N'::bpchar	Restart sequence every month
ad_sequence	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_replication	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_replication_log	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_replication_run	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_replicationdocument	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_replicationstrategy	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_replicationtable	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_system	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_system	isallowstatistics	bpchar	1			'Y'::bpchar	Maintain general statistics
ad_system	isautoerrorreport	bpchar	1			'Y'::bpchar	Automatically report Errors
ad_sequence	isautosequence	bpchar	1			'Y'::bpchar	Automatically assign the next number
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
ad_system	isfailonmissingmodelvalidator	bpchar	1			'Y'::bpchar	Fail on Missing Model Validator
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
ad_replication	isrmioverhttp	bpchar	1			'Y'::bpchar	Connect to Server via HTTP Tunnel
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_replication	created	timestamp	29,6			now()	Date this record was created
ad_replication_log	created	timestamp	29,6			now()	Date this record was created
ad_replication_run	created	timestamp	29,6			now()	Date this record was created
ad_replicationstrategy	created	timestamp	29,6			now()	Date this record was created
ad_replicationtable	created	timestamp	29,6			now()	Date this record was created
ad_sequence	created	timestamp	29,6			now()	Date this record was created
ad_system	created	timestamp	29,6			now()	Date this record was created
ad_table	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
ad_replication	updated	timestamp	29,6			now()	Date this record was updated
ad_replication_log	updated	timestamp	29,6			now()	Date this record was updated
ad_replication_run	updated	timestamp	29,6			now()	Date this record was updated
ad_replicationstrategy	updated	timestamp	29,6			now()	Date this record was updated
ad_replicationtable	updated	timestamp	29,6			now()	Date this record was updated
ad_sequence	updated	timestamp	29,6			now()	Date this record was updated
ad_system	updated	timestamp	29,6			now()	Date this record was updated
ad_table	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_replication_log	ad_replicationtable_id	numeric	10	√		null	Data Replication Strategy Table Info
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_system	customprefix	varchar	60	√		null	Prefix for Custom entities
ad_sequence	datecolumn	varchar	60	√		null	Fully qualified date column
ad_replication	datelastrun	timestamp	29,6	√		null	Date the process was last run.
ad_system	dbaddress	varchar	255	√		null	JDBC URL of the database server
ad_system	dbinstance	varchar	60	√		null	Database Name
ad_sequence	decimalpattern	varchar	40	√		null	Java Decimal Pattern
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
ad_replication	description	varchar	255	√		null	Optional short description of the record
ad_replication_run	description	varchar	255	√		null	Optional short description of the record
ad_replicationdocument	description	varchar	255	√		null	Optional short description of the record
ad_replicationstrategy	description	varchar	255	√		null	Optional short description of the record
ad_replicationtable	description	varchar	255	√		null	Optional short description of the record
ad_sequence	description	varchar	255	√		null	Optional short description of the record
ad_system	description	varchar	255	√		null	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
ad_system	encryptionkey	varchar	255	√		null	Encryption Class used for securing data content
ad_replicationstrategy	exp_processor_id	numeric	10	√		null	Export Processor
ad_replication	help	varchar	2000	√		null	Comment or Hint
ad_replicationstrategy	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
ad_replication	idrangeend	numeric	0	√		null	End if the ID Range used
ad_system	idrangeend	numeric	0	√		null	End if the ID Range used
ad_replication	idrangestart	numeric	0	√		null	Start of the ID Range used
ad_system	idrangestart	numeric	0	√		null	Start of the ID Range used
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
ad_system	info	varchar	255	√		null	Information
ad_system	lastbuildinfo	varchar	255	√		null	Last Build Info
ad_system	ldapdomain	varchar	255	√		null	Directory service domain name - e.g. idempiere.org
ad_system	ldaphost	varchar	60	√		null	Connection String to LDAP server starting with ldap://
ad_table	loadseq	numeric	10	√		null	Sequence
ad_system	noprocessors	numeric	10	√		null	Number of Database Processors
ad_system	oldname	varchar	60	√		null	Old Name
ad_replication_log	p_msg	varchar	2000	√		null	Process Message
ad_system	password	varchar	20	√		null	Password of any length (case sensitive)
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
ad_replication	prefix	varchar	10	√		null	Prefix before the sequence number
ad_sequence	prefix	varchar	255	√		null	Prefix before the sequence number
ad_replication	processing	bpchar	1	√		null	Process Now
ad_system	processing	bpchar	1	√		null	Process Now
ad_system	profileinfo	varchar	255	√		null	Information to help profiling the system for solving support issues
ad_system	record_id	numeric	10	√		null	Direct internal record ID
ad_system	releaseno	varchar	10	√		null	Internal Release Number
ad_replication	remote_client_id	numeric	10	√		null	Remote Client to be used to replicate / synchronize data with.
ad_replication	remote_org_id	numeric	10	√		null	Remote Organization to be used to replicate / synchronize data with.
ad_system	statisticsinfo	varchar	60	√		null	Information to help profiling the system for solving support issues
ad_replication	suffix	varchar	10	√		null	Suffix after the number
ad_sequence	suffix	varchar	255	√		null	Suffix after the number
ad_system	summary	varchar	255	√		null	Textual summary of this request
ad_system	supportemail	varchar	60	√		null	EMail address to send support information and updates to
ad_system	supportexpdate	timestamp	29,6	√		null	Date when the iDempiere support expires
ad_system	supportunits	numeric	10	√		null	Number of Internal Users for iDempiere Support
ad_replicationstrategy	value	varchar	40	√		null	Search key for the record in the format required - must be unique
ad_system	version	varchar	20	√		null	Version of the table definition
ad_sequence	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_table	accesslevel	bpchar	1				Access Level required
ad_replication	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_replication_log	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_replication_run	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_replicationdocument	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_replicationstrategy	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_replicationtable	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sequence	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_system	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_replication	ad_org_id	numeric	10				Organizational entity within client
ad_replication_log	ad_org_id	numeric	10				Organizational entity within client
ad_replication_run	ad_org_id	numeric	10				Organizational entity within client
ad_replicationdocument	ad_org_id	numeric	10				Organizational entity within client
ad_replicationstrategy	ad_org_id	numeric	10				Organizational entity within client
ad_replicationtable	ad_org_id	numeric	10				Organizational entity within client
ad_sequence	ad_org_id	numeric	10				Organizational entity within client
ad_system	ad_org_id	numeric	10				Organizational entity within client
ad_table	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_org_id	numeric	10				Organizational entity within client
ad_replication	ad_replication_id	numeric	10				Data Replication Target
ad_replication_run	ad_replication_id	numeric	10				Data Replication Target
ad_replication_log	ad_replication_log_id	numeric	10				Data Replication Log Details
ad_replication_log	ad_replication_run_id	numeric	10				Data Replication Run
ad_replication_run	ad_replication_run_id	numeric	10				Data Replication Run
ad_replicationdocument	ad_replicationdocument_id	numeric	10				Replication Document
ad_replication	ad_replicationstrategy_id	numeric	10				Data Replication Strategy
ad_replicationdocument	ad_replicationstrategy_id	numeric	10				Data Replication Strategy
ad_replicationstrategy	ad_replicationstrategy_id	numeric	10				Data Replication Strategy
ad_replicationtable	ad_replicationstrategy_id	numeric	10				Data Replication Strategy
ad_replicationtable	ad_replicationtable_id	numeric	10				Data Replication Strategy Table Info
ad_sequence	ad_sequence_id	numeric	10				Document Sequence
ad_system	ad_system_id	numeric	10				System Definition
ad_replicationdocument	ad_table_id	numeric	10				Database Table information
ad_replicationtable	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
ad_replicationdocument	c_doctype_id	numeric	10				Document type or rules
c_doctype	c_doctype_id	numeric	10				Document type or rules
ad_replication	createdby	numeric	10				User who created this records
ad_replication_log	createdby	numeric	10				User who created this records
ad_replication_run	createdby	numeric	10				User who created this records
ad_replicationdocument	createdby	numeric	10				User who created this records
ad_replicationstrategy	createdby	numeric	10				User who created this records
ad_replicationtable	createdby	numeric	10				User who created this records
ad_sequence	createdby	numeric	10				User who created this records
ad_system	createdby	numeric	10				User who created this records
ad_table	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
ad_sequence	currentnext	numeric	10				The next number to be used
ad_sequence	currentnextsys	numeric	10				Next sequence for system use
c_doctype	docbasetype	bpchar	3				Logical type of document
c_doctype	documentcopies	numeric	10				Number of copies to be printed
c_doctype	gl_category_id	numeric	10				General Ledger Category
ad_replication	hostaddress	varchar	60				Host Address URL or DNS
ad_replication	hostport	numeric	10				Host Communication Port
ad_sequence	incrementno	numeric	10				The number to increment the last document number by
ad_replication	name	varchar	60				Alphanumeric identifier of the entity
ad_replication_run	name	varchar	60				Alphanumeric identifier of the entity
ad_replicationstrategy	name	varchar	60				Alphanumeric identifier of the entity
ad_sequence	name	varchar	60				Alphanumeric identifier of the entity
ad_system	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
ad_replicationdocument	replicationtype	bpchar	1				Type of Data Replication
ad_sequence	startno	numeric	10				Starting number/position
ad_table	tablename	varchar	40				Name of the table in the database
ad_replication	updatedby	numeric	10				User who updated this records
ad_replication_log	updatedby	numeric	10				User who updated this records
ad_replication_run	updatedby	numeric	10				User who updated this records
ad_replicationdocument	updatedby	numeric	10				User who updated this records
ad_replicationstrategy	updatedby	numeric	10				User who updated this records
ad_replicationtable	updatedby	numeric	10				User who updated this records
ad_sequence	updatedby	numeric	10				User who updated this records
ad_system	updatedby	numeric	10				User who updated this records
ad_table	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
ad_system	username	varchar	60				User Name
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_replication_log	ad_replication_log_uu	varchar	36	√		NULL::character varying	AD_Replication_Log_UU
ad_replication_run	ad_replication_run_uu	varchar	36	√		NULL::character varying	AD_Replication_Run_UU
ad_replication	ad_replication_uu	varchar	36	√		NULL::character varying	AD_Replication_UU
ad_replicationdocument	ad_replicationdocument_uu	varchar	36	√		NULL::character varying	AD_ReplicationDocument_UU
ad_replicationstrategy	ad_replicationstrategy_uu	varchar	36	√		NULL::character varying	AD_ReplicationStrategy_UU
ad_replicationtable	ad_replicationtable_uu	varchar	36	√		NULL::character varying	AD_ReplicationTable_UU
ad_sequence	ad_sequence_uu	varchar	36	√		NULL::character varying	AD_Sequence_UU
ad_system	ad_system_uu	varchar	36	√		NULL::character varying	AD_System_UU
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
ad_system	lastmigrationscriptapplied	varchar	255	√		NULL::character varying	Register of the filename for the last migration script applied on this database
ad_sequence	orgcolumn	varchar	60	√		NULL::character varying	Fully qualified Organization column (AD_Org_ID)
ad_replicationdocument	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_replicationdocument	updated	timestamp	29,6			statement_timestamp()	Date this record was updated