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

Table	Column	Type	Size	Nulls	Auto	Default
ad_table	accesslevel	bpchar	1				Access Level required
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
ad_client	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_clientinfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_clientshare	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_language	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org_v	ad_client_id	numeric	10	√		null
ad_orginfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_orgtype	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_preference	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printform	ad_client_id	numeric	10	√		null	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_table	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.
c_country	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_client	ad_client_uu	varchar	36	√		NULL::character varying	AD_Client_UU
ad_clientinfo	ad_clientinfo_uu	varchar	36	√		NULL::character varying	AD_ClientInfo_UU
ad_clientshare	ad_clientshare_id	numeric	10				Force (not) sharing of client/org entities
ad_clientshare	ad_clientshare_uu	varchar	36	√		NULL::character varying	AD_ClientShare_UU
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_preference	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_client	ad_language	varchar	6	√		null	Language for this entity
ad_language	ad_language	varchar	6				Language for this entity
c_bpartner	ad_language	varchar	6	√		null	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_client	ad_org_id	numeric	10				Organizational entity within client
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within client
ad_clientshare	ad_org_id	numeric	10				Organizational entity within client
ad_language	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_id	numeric	10				Organizational entity within client
ad_org_v	ad_org_id	numeric	10	√		null
ad_orginfo	ad_org_id	numeric	10				Organizational entity within client
ad_orgtype	ad_org_id	numeric	10				Organizational entity within client
ad_preference	ad_org_id	numeric	10				Organizational entity within client
ad_printform	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_table	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
c_country	ad_org_id	numeric	10				Organizational entity within client
m_pricelist	ad_org_id	numeric	10				Organizational entity within client
m_warehouse	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
ad_orginfo	ad_orginfo_uu	varchar	36	√		NULL::character varying	AD_OrgInfo_UU
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_org_v	ad_orgtype_id	numeric	10	√		null
ad_orginfo	ad_orgtype_id	numeric	10	√		null	Organization Type
ad_orgtype	ad_orgtype_id	numeric	10				Organization Type
ad_orgtype	ad_orgtype_uu	varchar	36	√		NULL::character varying	AD_OrgType_UU
ad_client	ad_passwordrule_id	numeric	10	√		NULL::numeric	Password Policies
ad_preference	ad_preference_id	numeric	10				Personal Value Preference
ad_preference	ad_preference_uu	varchar	36	√		NULL::character varying	AD_Preference_UU
ad_orgtype	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_printform	ad_printform_id	numeric	10				Form
ad_printform	ad_printform_uu	varchar	36	√		NULL::character varying	AD_PrintForm_UU
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
ad_preference	ad_process_id	numeric	10	√		NULL::numeric	Process or Report
ad_registration	ad_registration_id	numeric	10				System Registration
ad_registration	ad_registration_uu	varchar	36	√		NULL::character varying	AD_Registration_UU
ad_client	ad_replicationstrategy_id	numeric	10	√		null	Data Replication Strategy
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
ad_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_registration	ad_system_id	numeric	10				System Definition
ad_system	ad_system_id	numeric	10				System Definition
ad_system	ad_system_uu	varchar	36	√		NULL::character varying	AD_System_UU
ad_clientshare	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_clientinfo	ad_tree_activity_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_bpartner_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_campaign_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_clientinfo	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_clientinfo	ad_tree_product_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_project_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_clientinfo	ad_tree_salesregion_id	numeric	10	√		null	Trees are used for (financial) reporting
ad_preference	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_preference	ad_window_id	numeric	10	√		null	Data entry or display window
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
c_country	allowcitiesoutoflist	bpchar	1	√		'Y'::bpchar	A flag to allow cities, currently not in the list, to be entered
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
ad_preference	attribute	varchar	60				Attribute
ad_client	autoarchive	bpchar	1			'N'::bpchar	Enable and level of automatic Archive of documents
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
ad_org_v	c_bpartner_id	numeric	10	√		null
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
ad_clientinfo	c_bpartnercashtrx_id	numeric	10	√		null	Business Partner used for creating new Business Partners on the fly
ad_clientinfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_orginfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
c_country	c_country_id	numeric	10				Country
c_country	c_country_uu	varchar	36	√		NULL::character varying	C_Country_UU
ad_registration	c_currency_id	numeric	10	√		null	The Currency for this record
c_country	c_currency_id	numeric	10	√		null	The Currency for this record
m_pricelist	c_currency_id	numeric	10				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
ad_org_v	c_location_id	numeric	10	√		null
ad_orginfo	c_location_id	numeric	10	√		null	Location or Address
ad_registration	c_location_id	numeric	10	√		null	Location or Address
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
ad_clientinfo	c_uom_length_id	numeric	10	√		null	Standard Unit of Measure for Length
ad_clientinfo	c_uom_time_id	numeric	10	√		null	Standard Unit of Measure for Time
ad_clientinfo	c_uom_volume_id	numeric	10	√		null	Standard Unit of Measure for Volume
ad_clientinfo	c_uom_weight_id	numeric	10	√		null	Standard Unit of Measure for Weight
c_country	capturesequence	varchar	60	√		null	Capture Sequence
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_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
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_client	created	timestamp	29,6			now()	Date this record was created
ad_clientinfo	created	timestamp	29,6			now()	Date this record was created
ad_clientshare	created	timestamp	29,6			now()	Date this record was created
ad_language	created	timestamp	29,6			now()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_org_v	created	timestamp	29,6	√		null
ad_orginfo	created	timestamp	29,6			now()	Date this record was created
ad_orgtype	created	timestamp	29,6			now()	Date this record was created
ad_preference	created	timestamp	29,6			now()	Date this record was created
ad_printform	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_table	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
c_country	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
ad_client	createdby	numeric	10				User who created this records
ad_clientinfo	createdby	numeric	10				User who created this records
ad_clientshare	createdby	numeric	10				User who created this records
ad_language	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_org_v	createdby	numeric	10	√		null
ad_orginfo	createdby	numeric	10				User who created this records
ad_orgtype	createdby	numeric	10				User who created this records
ad_preference	createdby	numeric	10				User who created this records
ad_printform	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_table	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
c_country	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
ad_system	customprefix	varchar	60	√		null	Prefix for Custom entities
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
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
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
ad_client	description	varchar	255	√		null	Optional short description of the record
ad_clientshare	description	varchar	255	√		null	Optional short description of the record
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_org_v	description	varchar	255	√		null
ad_orgtype	description	varchar	255	√		null	Optional short description of the record
ad_printform	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_table	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
c_country	description	varchar	255	√		null	Optional short description of the record
m_pricelist	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
ad_printform	distrib_order_mailtext_id	numeric	10	√		null	Email text used for sending Distribution Order
ad_printform	distrib_order_printformat_id	numeric	10	√		null	Print Format for printing Distribution Order
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
ad_client	documentdir	varchar	60	√		null	Directory for documents from the application server
ad_orginfo	dropship_warehouse_id	numeric	10	√		null	The (logical) warehouse to use for recording drop ship receipts and shipments.
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
ad_org_v	duns	varchar	11	√		null
ad_orginfo	duns	varchar	11				Dun & Bradstreet Number
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_orginfo	email	varchar	60	√		NULL::character varying	Electronic Mail Address
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_client	emailtest	bpchar	1	√		null	Test EMail
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
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
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"
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_orginfo	fax	varchar	40	√		NULL::character varying	Facsimile number
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
ad_clientinfo	fy_startdate	timestamp	29,6	√		null	Financial Year Start Date
c_country	haspostal_add	bpchar	1			'N'::bpchar	Has Additional Postal Code
c_country	hasregion	bpchar	1			'N'::bpchar	Country contains Regions
ad_table	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
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
ad_registration	industryinfo	varchar	255	√		null	Information of the industry (e.g. professional service, distribution of furnitures, ..)
ad_system	info	varchar	255	√		null	Information
ad_printform	invoice_mailtext_id	numeric	10	√		null	Email text used for sending invoices
ad_printform	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_client	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_clientinfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_clientshare	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_language	isactive	bpchar	1			'N'::bpchar	The record is active in the system
ad_org	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_org_v	isactive	bpchar	1	√		null
ad_orginfo	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_orgtype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_preference	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printform	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_table	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
c_country	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	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
ad_user	isaddmailtextautomatically	bpchar	1			'N'::bpchar	The selected mail template will be automatically inserted when creating an email
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_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_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
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_clientinfo	isconfirmondocclose	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Close
ad_clientinfo	isconfirmondocvoid	bpchar	1			'N'::bpchar	Show Confirmation On Document Action Void
ad_client	iscostimmediate	bpchar	1			'N'::bpchar	Update Costs immediately for testing
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_language	isdecimalpoint	bpchar	1	√		null	The number notation has a decimal point (no decimal comma)
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
ad_system	isfailonbuilddiffer	bpchar	1			'N'::bpchar	Fail if Build Differ
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
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
ad_registration	isinproduction	bpchar	1			'N'::bpchar	The system is in production
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
ad_system	isjustmigrated	bpchar	1	√		'N'::bpchar	Value set by Migration for post-Migration tasks.
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
ad_language	isloginlocale	bpchar	1	√		'N'::bpchar	Login Locale
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_client	ismultilingualdocument	bpchar	1			'N'::bpchar	Documents are Multi Lingual
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
c_country	ispostcodelookup	bpchar	1			'N'::bpchar	Does this country have a post code web service
ad_client	ispostimmediate	bpchar	1			'N'::bpchar	Post the accounting immediately for testing (Deprecated)
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
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_client	issecuresmtp	bpchar	1			'N'::bpchar	Use SSL/TLS for SMTP
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
ad_client	isserveremail	bpchar	1	√		null	Send EMail from Server
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_client	issmtpauthorization	bpchar	1			'N'::bpchar	Your mail server requires Authentication
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_org_v	issummary	bpchar	1	√		null
c_bpartner	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	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
ad_client	isuseasp	bpchar	1			'N'::bpchar	IsUseASP
ad_client	isusebetafunctions	bpchar	1			'N'::bpchar	Enable the use of Beta Functionality
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
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_clientinfo	keeplogdays	numeric	10	√		null	Number of days to keep the log entries
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
ad_system	lastmigrationscriptapplied	varchar	255	√		NULL::character varying	Register of the filename for the last migration script applied on this database
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_client	ldapquery	varchar	255	√		null
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
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
ad_table	loadseq	numeric	10	√		null	Sequence
ad_clientinfo	logo_id	numeric	10	√		NULL::numeric	Logo
ad_orginfo	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
ad_clientinfo	logoreport_id	numeric	10	√		NULL::numeric	Logo Report
ad_clientinfo	logoweb_id	numeric	10	√		NULL::numeric	Logo Web
c_country	lookupclassname	varchar	255	√		null	The class name of the postcode lookup plugin
c_country	lookupclientid	varchar	50	√		null	The ClientID 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
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
ad_org_v	m_warehouse_id	numeric	10	√		null
ad_orginfo	m_warehouse_id	numeric	10	√		null	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
ad_printform	manuf_order_mailtext_id	numeric	10	√		null	Email text used for sending Manufacturing Order
ad_printform	manuf_order_printformat_id	numeric	10	√		null	Print Format for printing Manufacturing Order
c_country	mediasize	varchar	40	√		null	Java Media Size
ad_client	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
ad_client	modelvalidationclasses	varchar	255	√		null	List of data model validation classes separated by ;
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_client	name	varchar	60				Alphanumeric identifier of the entity
ad_clientshare	name	varchar	60				Alphanumeric identifier of the entity
ad_language	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_org_v	name	varchar	60	√		null
ad_orgtype	name	varchar	60				Alphanumeric identifier of the entity
ad_printform	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
ad_user	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_country	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
ad_system	noprocessors	numeric	10	√		null	Number of Database Processors
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
ad_registration	numberemployees	numeric	10	√		0	Number of employees
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_system	oldname	varchar	60	√		null	Old Name
ad_printform	order_mailtext_id	numeric	10	√		null	Email text used for sending order acknowledgements or quotations
ad_printform	order_printformat_id	numeric	10	√		null	Print Format for Orders, Quotes, Offers
ad_orginfo	pa_goal_id	numeric	10	√		null
ad_org_v	parent_org_id	numeric	10	√		null
ad_orginfo	parent_org_id	numeric	10	√		null	Parent (superior) Organization
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_orginfo	phone	varchar	40	√		NULL::character varying	Identifies a telephone number
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_orginfo	phone2	varchar	40	√		NULL::character varying	Identifies an alternate telephone number.
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
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
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
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
ad_preference	preferencefor	bpchar	1			'W'::bpchar	Type of preference, it can window, info window or parameter process
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
ad_language	printname	varchar	60			NULL::character varying	The label text to be printed on a document or correspondence.
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_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
ad_system	profileinfo	varchar	255	√		null	Information to help profiling the system for solving support issues
ad_printform	project_mailtext_id	numeric	10	√		null	Standard text for Project EMails
ad_printform	project_printformat_id	numeric	10	√		null	Standard Project Print Format
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_orginfo	receiptfootermsg	varchar	1023	√		null	This message will be displayed at the bottom of a receipt when doing a sales or purchase
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
c_country	regionname	varchar	60	√		null	Name of the Region
ad_system	releaseno	varchar	10	√		null	Internal Release Number
ad_printform	remittance_mailtext_id	numeric	10	√		null	Email text used for sending payment remittances
ad_printform	remittance_printformat_id	numeric	10	√		null	Print Format for separate Remittances
ad_registration	remote_addr	varchar	60	√		null	Remote Address
ad_registration	remote_host	varchar	120	√		null	Remote host Info
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
ad_system	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_client	requestemail	varchar	60	√		null	EMail address to send automated mails from or receive mails for automated processing (fully qualified)
ad_client	requestfolder	varchar	20	√		null	EMail folder to process incoming emails; if empty INBOX is used
ad_client	requestuser	varchar	60	√		null	User Name (ID) of the email owner
ad_client	requestuserpw	varchar	255	√		null	Password of the user name (ID) for mail processing
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
ad_registration	salesvolume	numeric	10	√		0	Total Volume of Sales in Thousands of Currency
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	securityquestion	varchar	1024	√		null	Security Question
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_warehouse	separator	bpchar	1				Element Separator
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
ad_clientshare	sharetype	bpchar	1				Type of sharing
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
ad_printform	shipment_mailtext_id	numeric	10	√		null	Email text used for sending delivery notes
ad_printform	shipment_printformat_id	numeric	10	√		null	Print Format for Shipments, Receipts, Pick Lists
ad_client	smtphost	varchar	60	√		null	Hostname of Mail Server for SMTP and IMAP
ad_client	smtpport	numeric	10	√		NULL::numeric	SMTP Port Number
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
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_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image
ad_client	storearchiveonfilesystem	bpchar	1			'N'::bpchar	Store Archive On File System
ad_client	storeattachmentsonfilesystem	bpchar	1			'N'::bpchar	Store Attachments On File System
ad_system	summary	varchar	255	√		null	Textual summary of this request
ad_org_v	supervisor_id	numeric	10	√		null
ad_orginfo	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
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
ad_system	systemstatus	bpchar	1			'E'::bpchar	Status of the system - Support priority depends on system status
ad_table	tablename	varchar	40				Name of the table in the database
ad_org_v	taxid	varchar	20	√		null
ad_orginfo	taxid	varchar	20				Tax Identification
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
ad_orginfo	transferbank_id	numeric	0	√		null	Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo	transfercashbook_id	numeric	0	√		null	CashBook for transfers
ad_client	unixarchivepath	varchar	255	√		null	Unix Archive Path
ad_client	unixattachmentpath	varchar	255	√		null	Unix Attachment Path
ad_client	updated	timestamp	29,6			now()	Date this record was updated
ad_clientinfo	updated	timestamp	29,6			now()	Date this record was updated
ad_clientshare	updated	timestamp	29,6			now()	Date this record was updated
ad_language	updated	timestamp	29,6			now()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_org_v	updated	timestamp	29,6	√		null
ad_orginfo	updated	timestamp	29,6			now()	Date this record was updated
ad_orgtype	updated	timestamp	29,6			now()	Date this record was updated
ad_preference	updated	timestamp	29,6			now()	Date this record was updated
ad_printform	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_table	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
c_country	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
ad_client	updatedby	numeric	10				User who updated this records
ad_clientinfo	updatedby	numeric	10				User who updated this records
ad_clientshare	updatedby	numeric	10				User who updated this records
ad_language	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_org_v	updatedby	numeric	10	√		null
ad_orginfo	updatedby	numeric	10				User who updated this records
ad_orgtype	updatedby	numeric	10				User who updated this records
ad_preference	updatedby	numeric	10				User who updated this records
ad_printform	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_table	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
c_country	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_system	username	varchar	60				User Name
ad_user	userpin	varchar	20	√		null	User PIN
ad_client	value	varchar	40				Search key for the record in the format required - must be unique
ad_org	value	varchar	40				Search key for the record in the format required - must be unique
ad_org_v	value	varchar	40	√		null
ad_preference	value	varchar	60				Search key for the record in the format required - must be unique
ad_user	value	varchar	40	√		null	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_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
ad_system	version	varchar	20	√		null	Version of the table definition
ad_client	windowsarchivepath	varchar	255	√		null	Windows Archive Path
ad_client	windowsattachmentpath	varchar	255	√		null	Windows Attachment Path