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

Table	Column	Type	Size	Nulls	Auto	Default
ad_entitytype	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_modification	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_process_para	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_reference	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
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
ad_system	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
a_asset	a_asset_action	varchar	2			'MD'::character varying	Asset Action
a_asset	a_assettype	varchar	3			'MFX'::character varying	Asset Type
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
ad_system	isjustmigrated	bpchar	1	√		'N'::bpchar	Value set by Migration for post-Migration tasks.
ad_language	isloginlocale	bpchar	1	√		'N'::bpchar	Login Locale
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_reference	isorderbyvalue	bpchar	1	√		'N'::bpchar	Order list using the value column instead of the name column
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
a_asset	processing	bpchar	1	√		'N'::bpchar	Process Now
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_language	isactive	bpchar	1			'N'::bpchar	The record is active in the system
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
ad_process_para	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for textfields
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
ad_language	isbaselanguage	bpchar	1			'N'::bpchar	The system information is maintained in this language
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
a_asset	isdisposed	bpchar	1			'N'::bpchar	The asset is disposed
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
ad_process_para	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_system	isfailonbuilddiffer	bpchar	1			'N'::bpchar	Fail if Build Differ
a_asset	isfullydepreciated	bpchar	1			'N'::bpchar	The asset is fully depreciated
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
a_registration	isinproduction	bpchar	1			'N'::bpchar	The system is in production
ad_registration	isinproduction	bpchar	1			'N'::bpchar	The system is in production
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
ad_process_para	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
ad_process_para	isrange	bpchar	1			'N'::bpchar	The parameter is a range of values
a_registration	isregistered	bpchar	1			'N'::bpchar	The application is registered.
ad_registration	isregistered	bpchar	1			'N'::bpchar	The application is registered.
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_language	issystemlanguage	bpchar	1			'N'::bpchar	The screens, etc. are maintained in this Language
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
a_asset	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
a_asset	a_asset_status	varchar	2			'NW'::character varying	Asset Status
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
a_asset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_registration	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_registrationattribute	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_registrationproduct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_registrationvalue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_entitytype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_modification	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_reference	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_registration	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_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_registration	isallowpublish	bpchar	1			'Y'::bpchar	You allow to publish the information, not just statistical summary info
ad_registration	isallowpublish	bpchar	1			'Y'::bpchar	You allow to publish the information, not just statistical summary info
ad_registration	isallowstatistics	bpchar	1			'Y'::bpchar	Maintain general statistics
ad_system	isallowstatistics	bpchar	1			'Y'::bpchar	Maintain general statistics
ad_system	isautoerrorreport	bpchar	1			'Y'::bpchar	Automatically report Errors
ad_process_para	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
a_asset	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
ad_system	isfailonmissingmodelvalidator	bpchar	1			'Y'::bpchar	Fail on Missing Model Validator
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
a_asset	isinposession	bpchar	1			'Y'::bpchar	The asset is in the possession of the organization
a_asset	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
a_registrationattribute	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
a_asset	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
ad_registration	numberemployees	numeric	10	√		0	Number of employees
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
ad_registration	salesvolume	numeric	10	√		0	Total Volume of Sales in Thousands of Currency
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
a_registrationattribute	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_modification	seqno	numeric	10			0	Method of ordering records; lowest number comes first
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
a_asset	created	timestamp	29,6			now()	Date this record was created
a_registration	created	timestamp	29,6			now()	Date this record was created
a_registrationattribute	created	timestamp	29,6			now()	Date this record was created
a_registrationproduct	created	timestamp	29,6			now()	Date this record was created
a_registrationvalue	created	timestamp	29,6			now()	Date this record was created
ad_entitytype	created	timestamp	29,6			now()	Date this record was created
ad_language	created	timestamp	29,6			now()	Date this record was created
ad_modification	created	timestamp	29,6			now()	Date this record was created
ad_process_para	created	timestamp	29,6			now()	Date this record was created
ad_reference	created	timestamp	29,6			now()	Date this record was created
ad_registration	created	timestamp	29,6			now()	Date this record was created
ad_system	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
a_asset	updated	timestamp	29,6			now()	Date this record was updated
a_registration	updated	timestamp	29,6			now()	Date this record was updated
a_registrationattribute	updated	timestamp	29,6			now()	Date this record was updated
a_registrationproduct	updated	timestamp	29,6			now()	Date this record was updated
a_registrationvalue	updated	timestamp	29,6			now()	Date this record was updated
ad_entitytype	updated	timestamp	29,6			now()	Date this record was updated
ad_language	updated	timestamp	29,6			now()	Date this record was updated
ad_modification	updated	timestamp	29,6			now()	Date this record was updated
ad_process_para	updated	timestamp	29,6			now()	Date this record was updated
ad_reference	updated	timestamp	29,6			now()	Date this record was updated
ad_registration	updated	timestamp	29,6			now()	Date this record was updated
ad_system	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
a_asset	a_asset_createdate	timestamp	29,6	√		null	Create Date
a_registration	a_asset_id	numeric	10	√		null	Asset used internally or by customers
a_asset	a_asset_revaldate	timestamp	29,6	√		null	Revaluation Date
a_asset	a_asset_type_id	numeric	10	√		null	Asset Type
a_asset	a_parent_asset_id	numeric	10	√		null	Parent Asset
a_asset	a_qty_current	numeric	0	√		null	Current Qty
a_asset	a_qty_original	numeric	0	√		null	A_QTY_Original
ad_process_para	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
a_registrationattribute	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_process_para	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
a_asset	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
a_registration	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_process_para	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
a_asset	assetactivationdate	timestamp	29,6	√		null	Activation Date
a_asset	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
a_asset	assetdisposaldate	timestamp	29,6	√		null	Date when the asset is/was disposed
a_asset	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
a_registration	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
a_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
a_registration	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
a_asset	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
a_asset	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
ad_registration	c_currency_id	numeric	10	√		null	The Currency for this record
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
a_asset	c_location_id	numeric	10	√		null	Location or Address
ad_registration	c_location_id	numeric	10	√		null	Location or Address
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
a_asset	c_project_id	numeric	10	√		null	Financial Project
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
m_product	classification	varchar	12	√		null	Classification for grouping
ad_entitytype	classpath	varchar	255	√		null	Extension Classpath
a_registrationattribute	columnname	varchar	30	√		null	Name of the column in the database
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
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
ad_system	customprefix	varchar	60	√		null	Prefix for Custom entities
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
ad_language	datepattern	varchar	20	√		null	Java Date Pattern
ad_system	dbaddress	varchar	255	√		null	JDBC URL of the database server
ad_system	dbinstance	varchar	60	√		null	Database Name
ad_process_para	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_process_para	defaultvalue2	varchar	2000	√		null	Default value hierarchy, separated by ;
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
a_asset	description	varchar	255	√		null	Optional short description of the record
a_registration	description	varchar	255	√		null	Optional short description of the record
a_registrationattribute	description	varchar	255	√		null	Optional short description of the record
a_registrationproduct	description	varchar	255	√		null	Optional short description of the record
a_registrationvalue	description	varchar	255	√		null	Optional short description of the record
ad_entitytype	description	varchar	255	√		null	Optional short description of the record
ad_modification	description	varchar	255	√		null	Optional short description of the record
ad_process_para	description	varchar	255	√		null	Optional short description of the record
ad_reference	description	varchar	255	√		null	Optional short description of the record
ad_registration	description	varchar	255	√		null	Optional short description of the record
ad_system	description	varchar	255	√		null	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
ad_process_para	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_user	emailuser	varchar	60	√		null	User Name (ID) in the Mail System
ad_user	emailuserpw	varchar	255	√		null	Password of your email user id
ad_user	emailverify	varchar	40	√		null	Verification information of EMail Address
ad_user	emailverifydate	timestamp	29,6	√		null	Date Email was verified
ad_system	encryptionkey	varchar	255	√		null	Encryption Class used for securing data content
ad_user	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
a_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
a_asset	help	varchar	2000	√		null	Comment or Hint
a_registration	help	varchar	2000	√		null	Comment or Hint
ad_entitytype	help	varchar	2000	√		null	Comment or Hint
ad_modification	help	varchar	2000	√		null	Comment or Hint
ad_process_para	help	varchar	2000	√		null	Comment or Hint
ad_reference	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
ad_system	idrangeend	numeric	0	√		null	End if the ID Range used
ad_system	idrangestart	numeric	0	√		null	Start of the ID Range used
m_product	imageurl	varchar	120	√		null	URL of image
ad_registration	industryinfo	varchar	255	√		null	Information of the industry (e.g. professional service, distribution of furnitures, ..)
ad_system	info	varchar	255	√		null	Information
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
ad_language	isdecimalpoint	bpchar	1	√		null	The number notation has a decimal point (no decimal comma)
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
m_product	istoformule	bpchar	1	√		null
ad_language	languageiso	bpchar	2	√		null	Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
ad_system	lastbuildinfo	varchar	255	√		null	Last Build Info
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
a_asset	lastmaintenancedate	timestamp	29,6	√		null	Last Maintenance Date
a_asset	lastmaintenancenote	varchar	60	√		null	Last Maintenance Note
a_asset	lastmaintenanceunit	numeric	10	√		null	Last Maintenance Unit
a_asset	lastmaintenanceuseunit	numeric	10	√		null
a_asset	lastmaintenencedate	timestamp	29,6	√		null
ad_user	lastresult	varchar	255	√		null	Result of last contact
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_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
a_asset	lease_bpartner_id	numeric	10	√		null	The Business Partner who rents or leases
a_asset	leaseterminationdate	timestamp	29,6	√		null	Lease Termination Date
a_asset	lifeuseunits	numeric	0	√		null	Units of use until the asset is not usable anymore
a_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
a_asset	lot	varchar	255	√		null	Lot number (alphanumeric)
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
a_asset	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
a_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
a_registration	m_product_id	numeric	10	√		null	Product, Service, Item
ad_entitytype	modelpackage	varchar	255	√		null	Java Package of the model classes
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name2	varchar	60	√		null	Additional Name
a_asset	nextmaintenanceuseunit	numeric	10	√		null
a_asset	nextmaintenencedate	timestamp	29,6	√		null	Next Maintenence Date
a_asset	nextmaintenenceunit	numeric	10	√		null	Next Maintenence Unit
ad_system	noprocessors	numeric	10	√		null	Number of Database Processors
a_registration	note	varchar	2000	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_system	oldname	varchar	60	√		null	Old Name
ad_system	password	varchar	20	√		null	Password of any length (case sensitive)
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
ad_registration	platforminfo	varchar	255	√		null	Information about Server and Client Platform
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
a_registration	processing	bpchar	1	√		null	Process Now
ad_entitytype	processing	bpchar	1	√		null	Process Now
ad_language	processing	bpchar	1	√		null	Process Now
ad_registration	processing	bpchar	1	√		null	Process Now
ad_system	processing	bpchar	1	√		null	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
ad_system	profileinfo	varchar	255	√		null	Information to help profiling the system for solving support issues
a_asset	qty	numeric	0	√		null	Quantity
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_process_para	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
ad_registration	record_id	numeric	10	√		null	Direct internal record ID
ad_system	record_id	numeric	10	√		null	Direct internal record ID
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
ad_system	releaseno	varchar	10	√		null	Internal Release Number
a_registration	remote_addr	varchar	60	√		null	Remote Address
ad_registration	remote_addr	varchar	60	√		null	Remote Address
a_registration	remote_host	varchar	120	√		null	Remote host Info
ad_registration	remote_host	varchar	120	√		null	Remote host Info
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
ad_user	securityquestion	varchar	1024	√		null	Security Question
a_asset	serno	varchar	255	√		null	Product Serial Number
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
ad_registration	startproductiondate	timestamp	29,6	√		null	The day you started the implementation (if implementing) - or production (went life) with iDempiere
ad_system	statisticsinfo	varchar	60	√		null	Information to help profiling the system for solving support issues
ad_system	summary	varchar	255	√		null	Textual summary of this request
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
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
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_language	timepattern	varchar	20	√		null	Java Time Pattern
ad_user	title	varchar	40	√		null	Name this entity is referred to as
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
a_asset	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
a_asset	uselifeyears	numeric	10	√		null	Years of the usable life of the asset
ad_user	userpin	varchar	20	√		null	User PIN
a_asset	useunits	numeric	0	√		null	Currently used units of the assets
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
ad_process_para	valuemax	varchar	20	√		null	Maximum Value for a field
ad_process_para	valuemin	varchar	20	√		null	Minimum Value for a field
ad_entitytype	version	varchar	20	√		null	Version of the table definition
ad_modification	version	varchar	20	√		null	Version of the table definition
ad_system	version	varchar	20	√		null	Version of the table definition
a_asset	versionno	varchar	20	√		null	Version Number
m_product	versionno	varchar	20	√		null	Version Number
ad_process_para	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_reference	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
a_asset	a_asset_group_id	numeric	10				Group of Assets
a_asset	a_asset_id	numeric	10				Asset used internally or by customers
a_registration	a_registration_id	numeric	10				User Asset Registration
a_registrationvalue	a_registration_id	numeric	10				User Asset Registration
a_registrationattribute	a_registrationattribute_id	numeric	10				Asset Registration Attribute
a_registrationproduct	a_registrationattribute_id	numeric	10				Asset Registration Attribute
a_registrationvalue	a_registrationattribute_id	numeric	10				Asset Registration Attribute
a_asset	ad_client_id	numeric	10				Client/Tenant for this installation.
a_registration	ad_client_id	numeric	10				Client/Tenant for this installation.
a_registrationattribute	ad_client_id	numeric	10				Client/Tenant for this installation.
a_registrationproduct	ad_client_id	numeric	10				Client/Tenant for this installation.
a_registrationvalue	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_entitytype	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_language	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_modification	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process_para	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_reference	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_registration	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_system	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_entitytype	ad_entitytype_id	numeric	10				System Entity Type
ad_language	ad_language	varchar	6				Language for this entity
ad_language	ad_language_id	numeric	10				Language ID
ad_modification	ad_modification_id	numeric	10				System Modification or Extension
a_asset	ad_org_id	numeric	10				Organizational entity within client
a_registration	ad_org_id	numeric	10				Organizational entity within client
a_registrationattribute	ad_org_id	numeric	10				Organizational entity within client
a_registrationproduct	ad_org_id	numeric	10				Organizational entity within client
a_registrationvalue	ad_org_id	numeric	10				Organizational entity within client
ad_entitytype	ad_org_id	numeric	10				Organizational entity within client
ad_language	ad_org_id	numeric	10				Organizational entity within client
ad_modification	ad_org_id	numeric	10				Organizational entity within client
ad_process_para	ad_org_id	numeric	10				Organizational entity within client
ad_reference	ad_org_id	numeric	10				Organizational entity within client
ad_registration	ad_org_id	numeric	10				Organizational entity within client
ad_system	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
ad_process_para	ad_process_id	numeric	10				Process or Report
ad_process_para	ad_process_para_id	numeric	10				Process Parameter
a_registrationattribute	ad_reference_id	numeric	10				System Reference and Validation
ad_process_para	ad_reference_id	numeric	10				System Reference and Validation
ad_reference	ad_reference_id	numeric	10				System Reference and Validation
ad_registration	ad_registration_id	numeric	10				System Registration
ad_registration	ad_system_id	numeric	10				System Definition
ad_system	ad_system_id	numeric	10				System Definition
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
m_product	c_taxcategory_id	numeric	10				Tax Category
m_product	c_uom_id	numeric	10				Unit of Measure
ad_process_para	columnname	varchar	30				Name of the column in the database
a_asset	createdby	numeric	10				User who created this records
a_registration	createdby	numeric	10				User who created this records
a_registrationattribute	createdby	numeric	10				User who created this records
a_registrationproduct	createdby	numeric	10				User who created this records
a_registrationvalue	createdby	numeric	10				User who created this records
ad_entitytype	createdby	numeric	10				User who created this records
ad_language	createdby	numeric	10				User who created this records
ad_modification	createdby	numeric	10				User who created this records
ad_process_para	createdby	numeric	10				User who created this records
ad_reference	createdby	numeric	10				User who created this records
ad_registration	createdby	numeric	10				User who created this records
ad_system	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
ad_process_para	fieldlength	numeric	10				Length of the column in the database
m_product	m_product_category_id	numeric	10				Category of a Product
a_asset	m_product_id	numeric	10				Product, Service, Item
a_registrationproduct	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
a_asset	name	varchar	60				Alphanumeric identifier of the entity
a_registration	name	varchar	60				Alphanumeric identifier of the entity
a_registrationattribute	name	varchar	60				Alphanumeric identifier of the entity
a_registrationvalue	name	varchar	60				Alphanumeric identifier of the entity
ad_entitytype	name	varchar	60				Alphanumeric identifier of the entity
ad_language	name	varchar	60				Alphanumeric identifier of the entity
ad_modification	name	varchar	60				Alphanumeric identifier of the entity
ad_process_para	name	varchar	60				Alphanumeric identifier of the entity
ad_reference	name	varchar	60				Alphanumeric identifier of the entity
ad_system	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
ad_process_para	seqno	numeric	10				Method of ordering records; lowest number comes first
a_asset	updatedby	numeric	10				User who updated this records
a_registration	updatedby	numeric	10				User who updated this records
a_registrationattribute	updatedby	numeric	10				User who updated this records
a_registrationproduct	updatedby	numeric	10				User who updated this records
a_registrationvalue	updatedby	numeric	10				User who updated this records
ad_entitytype	updatedby	numeric	10				User who updated this records
ad_language	updatedby	numeric	10				User who updated this records
ad_modification	updatedby	numeric	10				User who updated this records
ad_process_para	updatedby	numeric	10				User who updated this records
ad_reference	updatedby	numeric	10				User who updated this records
ad_registration	updatedby	numeric	10				User who updated this records
ad_system	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
ad_system	username	varchar	60				User Name
ad_reference	validationtype	bpchar	1				Different method of validating data
a_asset	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
a_asset	a_asset_uu	varchar	36	√		NULL::character varying	A_Asset_UU
a_registration	a_registration_uu	varchar	36	√		NULL::character varying	A_Registration_UU
a_registrationattribute	a_registrationattribute_uu	varchar	36	√		NULL::character varying	A_RegistrationAttribute_UU
a_registrationproduct	a_registrationproduct_uu	varchar	36	√		NULL::character varying	A_RegistrationProduct_UU
a_registrationvalue	a_registrationvalue_uu	varchar	36	√		NULL::character varying	A_RegistrationValue_UU
ad_entitytype	ad_entitytype_uu	varchar	36	√		NULL::character varying	AD_EntityType_UU
ad_language	ad_language_uu	varchar	36	√		NULL::character varying	AD_Language_UU
ad_modification	ad_modification_uu	varchar	36	√		NULL::character varying	AD_Modification_UU
ad_process_para	ad_process_para_uu	varchar	36	√		NULL::character varying	AD_Process_Para_UU
ad_reference	ad_reference_uu	varchar	36	√		NULL::character varying	AD_Reference_UU
ad_registration	ad_registration_uu	varchar	36	√		NULL::character varying	AD_Registration_UU
ad_system	ad_system_uu	varchar	36	√		NULL::character varying	AD_System_UU
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
a_asset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
ad_system	lastmigrationscriptapplied	varchar	255	√		NULL::character varying	Register of the filename for the last migration script applied on this database
ad_user	leadsource	varchar	10	√		NULL::character varying	The source of this lead/opportunity
ad_user	leadsourcedescription	varchar	255	√		NULL::character varying	Additional information on the source of this lead/opportunity
ad_user	leadstatus	varchar	10	√		NULL::character varying	The status of this lead/opportunity in the sales cycle
ad_user	leadstatusdescription	varchar	255	√		NULL::character varying	Additional information on the status of this lead/opportunity
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
ad_process_para	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
a_asset	manufacturer	varchar	30	√		NULL::character varying	Manufacturer of the Product
ad_process_para	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para	placeholder2	varchar	255	√		NULL::character varying	Placeholder2
ad_process_para	query	varchar	2000	√		NULL::character varying	SQL
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_language	printname	varchar	60			NULL::character varying	The label text to be printed on a document or correspondence.
a_asset	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
ad_reference	ad_element_id	numeric	10	√		NULL::numeric	System Element enables the central maintenance of column description and help.
ad_process_para	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
a_asset	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
a_asset	manufacturedyear	numeric	10	√		NULL::numeric	Manufactured Year
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent