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

Table	Column	Type	Size	Nulls	Auto	Default
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
r_request	confidentialtype	bpchar	1			'C'::bpchar	Type of Confidentiality
ad_client	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
w_store	url	varchar	120			'http://localhost'::character varying	Full URL address - e.g. http://www.idempiere.org
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
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
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
ad_client	autoarchive	bpchar	1			'N'::bpchar	Enable and level of automatic Archive of documents
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
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
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
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
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
w_store	isdefault	bpchar	1			'N'::bpchar	Default value
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
r_request	isescalated	bpchar	1			'N'::bpchar	This request has been escalated
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
r_mailtext	ishtml	bpchar	1			'N'::bpchar	Text has HTML tags
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
r_request	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
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
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
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
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
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
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
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
r_request	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
w_advertisement	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_client	issmtpauthorization	bpchar	1			'N'::bpchar	Your mail server requires Authentication
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
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
w_mailmsg_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
w_store_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_client	isuseasp	bpchar	1			'N'::bpchar	IsUseASP
ad_client	isusebetafunctions	bpchar	1			'N'::bpchar	Enable the use of Beta Functionality
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
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
r_request	processed	bpchar	1			'N'::bpchar	The document has been processed
w_click	processed	bpchar	1			'N'::bpchar	The document has been processed
w_counter	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
ad_client	storearchiveonfilesystem	bpchar	1			'N'::bpchar	Store Archive On File System
ad_client	storeattachmentsonfilesystem	bpchar	1			'N'::bpchar	Store Attachments On File System
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
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
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_user	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_usermail	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_paymentterm	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_product	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
r_mailtext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_request	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_advertisement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_basket	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_basketline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_click	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_clickcount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_counter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_countercount	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_mailmsg	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_mailmsg_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_store	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_store_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_clientinfo	isdiscountlineamt	bpchar	1			'Y'::bpchar	Payment Discount calculation does not include Taxes and Charges
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
w_store	ismenuassets	bpchar	1			'Y'::bpchar	Show Menu Assets
w_store	ismenucontact	bpchar	1			'Y'::bpchar	Show Menu Contact
w_store	ismenuinterests	bpchar	1			'Y'::bpchar	Show Menu Interests
w_store	ismenuinvoices	bpchar	1			'Y'::bpchar	Show Menu Invoices
w_store	ismenuorders	bpchar	1			'Y'::bpchar	Show Menu Orders
w_store	ismenupayments	bpchar	1			'Y'::bpchar	Show Menu Payments
w_store	ismenuregistrations	bpchar	1			'Y'::bpchar	Show Menu Registrations
w_store	ismenurequests	bpchar	1			'Y'::bpchar	Show Menu Requests
w_store	ismenurfqs	bpchar	1			'Y'::bpchar	Show Menu RfQs
w_store	ismenushipments	bpchar	1			'Y'::bpchar	Show Menu Shipments
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
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_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
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
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
r_request	qtyinvoiced	numeric	0	√		0	Invoiced Quantity
r_request	qtyspent	numeric	0	√		0	Quantity used for this event
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
w_basketline	price	numeric	0			0	Price
w_basketline	qty	numeric	0			0	Quantity
r_request	requestamt	numeric	0			0	Amount associated with this request
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
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_language	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
ad_usermail	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
r_mailtext	created	timestamp	29,6			now()	Date this record was created
r_request	created	timestamp	29,6			now()	Date this record was created
w_advertisement	created	timestamp	29,6			now()	Date this record was created
w_basket	created	timestamp	29,6			now()	Date this record was created
w_basketline	created	timestamp	29,6			now()	Date this record was created
w_click	created	timestamp	29,6			now()	Date this record was created
w_clickcount	created	timestamp	29,6			now()	Date this record was created
w_counter	created	timestamp	29,6			now()	Date this record was created
w_countercount	created	timestamp	29,6			now()	Date this record was created
w_mailmsg	created	timestamp	29,6			now()	Date this record was created
w_mailmsg_trl	created	timestamp	29,6			now()	Date this record was created
w_store	created	timestamp	29,6			now()	Date this record was created
w_store_trl	created	timestamp	29,6			now()	Date this record was created
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_language	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
ad_usermail	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
r_mailtext	updated	timestamp	29,6			now()	Date this record was updated
r_request	updated	timestamp	29,6			now()	Date this record was updated
w_advertisement	updated	timestamp	29,6			now()	Date this record was updated
w_basket	updated	timestamp	29,6			now()	Date this record was updated
w_basketline	updated	timestamp	29,6			now()	Date this record was updated
w_click	updated	timestamp	29,6			now()	Date this record was updated
w_clickcount	updated	timestamp	29,6			now()	Date this record was updated
w_counter	updated	timestamp	29,6			now()	Date this record was updated
w_countercount	updated	timestamp	29,6			now()	Date this record was updated
w_mailmsg	updated	timestamp	29,6			now()	Date this record was updated
w_mailmsg_trl	updated	timestamp	29,6			now()	Date this record was updated
w_store	updated	timestamp	29,6			now()	Date this record was updated
w_store_trl	updated	timestamp	29,6			now()	Date this record was updated
r_request	a_asset_id	numeric	10	√		null	Asset used internally or by customers
w_click	acceptlanguage	varchar	60	√		null	Language accepted based on browser information
w_counter	acceptlanguage	varchar	60	√		null	Language accepted based on browser information
ad_client	ad_language	varchar	6	√		null	Language for this entity
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
ad_client	ad_replicationstrategy_id	numeric	10	√		null	Data Replication Strategy
r_request	ad_role_id	numeric	10	√		null	Responsibility Role
r_request	ad_table_id	numeric	10	√		null	Database Table information
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
r_request	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
w_advertisement	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
w_click	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
w_counter	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
w_advertisement	adtext	varchar	2000	√		null	Text of the Advertisement
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
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
ad_clientinfo	c_acctschema1_id	numeric	10	√		null	Primary rules for accounting
r_request	c_activity_id	numeric	10	√		null	Business Activity
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
r_request	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
w_basket	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
w_clickcount	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
w_countercount	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
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
r_request	c_campaign_id	numeric	10	√		null	Marketing Campaign
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
r_request	c_invoice_id	numeric	10	√		null	Invoice Identifier
r_request	c_invoicerequest_id	numeric	10	√		null	The generated invoice for this request
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
ad_user	c_job_id	numeric	10	√		null	Job Position
r_request	c_order_id	numeric	10	√		null	Order
r_request	c_payment_id	numeric	10	√		null	Payment identifier
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
w_store	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
r_request	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
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
m_product	classification	varchar	12	√		null	Classification for grouping
r_request	closedate	timestamp	29,6	√		null	Close Date
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
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
r_request	datecompleteplan	timestamp	29,6	√		null	Planned Completion Date
r_request	datelastaction	timestamp	29,6	√		null	Date this request was last acted on
r_request	datelastalert	timestamp	29,6	√		null	Date when last alert were sent
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
r_request	datenextaction	timestamp	29,6	√		null	Date that this request should be acted on
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
ad_language	datepattern	varchar	20	√		null	Java Date Pattern
r_request	datestartplan	timestamp	29,6	√		null	Planned Start Date
ad_usermail	deliveryconfirmation	varchar	120	√		null	EMail Delivery confirmation
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_user	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_paymentterm	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_warehouse	description	varchar	255	√		null	Optional short description of the record
w_advertisement	description	varchar	255	√		null	Optional short description of the record
w_clickcount	description	varchar	255	√		null	Optional short description of the record
w_countercount	description	varchar	255	√		null	Optional short description of the record
w_mailmsg	description	varchar	255	√		null	Optional short description of the record
w_store	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
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
c_paymentterm	documentnote	varchar	2000	√		null	Additional information for a Document
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
w_basket	email	varchar	60	√		null	Electronic Mail Address
w_click	email	varchar	60	√		null	Electronic Mail Address
w_counter	email	varchar	60	√		null	Electronic Mail Address
w_store	emailfooter	varchar	2000	√		null	Footer added to EMails
w_store_trl	emailfooter	varchar	2000	√		null	Footer added to EMails
w_store	emailheader	varchar	2000	√		null	Header added to EMails
w_store_trl	emailheader	varchar	2000	√		null	Header added to EMails
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
r_request	endtime	timestamp	29,6	√		null	End of the time span
ad_user	fax	varchar	40	√		null	Facsimile number
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_paymentterm	fixmonthcutoff	numeric	10	√		null	Last day to include for next due date
c_paymentterm	fixmonthday	numeric	10	√		null	Day of the month of the due date
c_paymentterm	fixmonthoffset	numeric	10	√		null	Number of months (0=same, 1=following)
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
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
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
m_product	help	varchar	2000	√		null	Comment or Hint
w_advertisement	help	varchar	2000	√		null	Comment or Hint
w_store	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
w_advertisement	imageurl	varchar	120	√		null	URL of image
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_usermail	isdelivered	bpchar	1	√		null	Delivered
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_client	isserveremail	bpchar	1	√		null	Send EMail from Server
m_product	istoformule	bpchar	1	√		null
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_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
ad_user	lastresult	varchar	255	√		null	Result of last contact
r_request	lastresult	varchar	2000	√		null	Result of last contact
ad_client	ldapquery	varchar	255	√		null
ad_user	ldapuser	varchar	60	√		null	User Name used for authorization via LDAP (directory) services
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
r_request	m_changerequest_id	numeric	10	√		null	BOM (Engineering) Change Request
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
r_request	m_fixchangenotice_id	numeric	10	√		null	Fixed in Change Notice
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
r_request	m_inout_id	numeric	10	√		null	Material Shipment Document
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
w_basket	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
r_request	m_product_id	numeric	10	√		null	Product, Service, Item
w_basketline	m_product_id	numeric	10	√		null	Product, Service, Item
ad_clientinfo	m_productfreight_id	numeric	10	√		null	Product for Freight
r_request	m_productspent_id	numeric	10	√		null	Product/Resource/Service used in Request
r_request	m_rma_id	numeric	10	√		null	Return Material Authorization
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
r_mailtext	mailheader	varchar	2000	√		null	Mail Header (Subject)
ad_usermail	mailtext	varchar	2000	√		null	Text used for Mail message
r_mailtext	mailtext2	varchar	2000	√		null	Optional second text part used for Mail message
r_mailtext	mailtext3	varchar	2000	√		null	Optional third text part used for Mail message
w_mailmsg	message2	varchar	2000	√		null	Optional second part of the EMail Message
w_mailmsg_trl	message2	varchar	2000	√		null	Optional second part of the EMail Message
w_mailmsg	message3	varchar	2000	√		null	Optional third part of the EMail Message
w_mailmsg_trl	message3	varchar	2000	√		null	Optional third part of the EMail Message
ad_usermail	messageid	varchar	120	√		null	EMail Message ID
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
c_bpartner	name2	varchar	60	√		null	Additional Name
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
r_request	nextaction	bpchar	1	√		null	Next Action to be taken
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
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.
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
r_request	priorityuser	bpchar	1	√		null	Priority of the issue for the User
ad_language	processing	bpchar	1	√		null	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
c_paymentterm	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
w_advertisement	processing	bpchar	1	√		null	Process Now
r_request	qtyplan	numeric	0	√		null	Planned Quantity
r_request	r_category_id	numeric	10	√		null	Request Category
r_request	r_group_id	numeric	10	√		null	Request Group
ad_usermail	r_mailtext_id	numeric	10	√		null	Text templates for mailings
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
r_request	r_mailtext_id	numeric	10	√		null	Text templates for mailings
r_request	r_requestrelated_id	numeric	10	√		null	Related Request (Master Issue, ..)
r_request	r_resolution_id	numeric	10	√		null	Request Resolution
r_request	r_standardresponse_id	numeric	10	√		null	Request Standard Response
r_request	r_status_id	numeric	10	√		null	Request Status
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_usermail	recipientbcc	varchar	2000	√		null	Bcc
ad_usermail	recipientcc	varchar	2000	√		null	Cc
r_request	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
w_click	referrer	varchar	120	√		null	Referring web address
w_counter	referrer	varchar	120	√		null	Referring web address
w_click	remote_addr	varchar	60	√		null	Remote Address
w_counter	remote_addr	varchar	60	√		null	Remote Address
w_click	remote_host	varchar	120	√		null	Remote host Info
w_counter	remote_host	varchar	120	√		null	Remote host Info
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
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
r_request	result	varchar	2000	√		null	Result of the action taken
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
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
ad_client	smtphost	varchar	60	√		null	Hostname of Mail Server for SMTP and IMAP
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
r_request	startdate	timestamp	29,6	√		null	First effective day (inclusive)
r_request	starttime	timestamp	29,6	√		null	Time started
w_store	stylesheet	varchar	60	√		null	CSS (Stylesheet) used
ad_usermail	subject	varchar	255	√		null	Email Message Subject
ad_user	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
w_click	targeturl	varchar	120	√		null	URL for the Target
r_request	taskstatus	bpchar	1	√		null	Status of the Task
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
ad_client	unixarchivepath	varchar	255	√		null	Unix Archive Path
ad_client	unixattachmentpath	varchar	255	√		null	Unix Attachment Path
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
w_click	useragent	varchar	255	√		null	Browser Used
w_counter	useragent	varchar	255	√		null	Browser Used
ad_user	userpin	varchar	20	√		null	User PIN
w_advertisement	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
w_advertisement	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_user	value	varchar	40	√		null	Search key for the record in the format required - must be unique
w_advertisement	version	numeric	10	√		null	Version of the table definition
m_product	versionno	varchar	20	√		null	Version Number
w_advertisement	w_clickcount_id	numeric	10	√		null	Web Click Management
w_click	w_clickcount_id	numeric	10	√		null	Web Click Management
w_advertisement	w_countercount_id	numeric	10	√		null	Web Counter Count Management
w_counter	w_countercount_id	numeric	10	√		null	Web Counter Count Management
ad_usermail	w_mailmsg_id	numeric	10	√		null	Web Store Mail Message Template
w_store	webinfo	varchar	2000	√		null	Web Store Header Information
w_store_trl	webinfo	varchar	2000	√		null	Web Store Header Information
w_store	weborderemail	varchar	60	√		null	EMail address to receive notifications when web orders were processed
w_advertisement	webparam1	varchar	2000	√		null	Web Site Parameter 1 (default: header image)
w_store	webparam1	varchar	2000	√		null	Web Site Parameter 1 (default: header image)
w_store_trl	webparam1	varchar	2000	√		null	Web Site Parameter 1 (default: header image)
w_advertisement	webparam2	varchar	2000	√		null	Web Site Parameter 2 (default index page)
w_store	webparam2	varchar	2000	√		null	Web Site Parameter 2 (default index page)
w_store_trl	webparam2	varchar	2000	√		null	Web Site Parameter 2 (default index page)
w_advertisement	webparam3	varchar	2000	√		null	Web Site Parameter 3 (default left - menu)
w_store	webparam3	varchar	2000	√		null	Web Site Parameter 3 (default left - menu)
w_store_trl	webparam3	varchar	2000	√		null	Web Site Parameter 3 (default left - menu)
w_advertisement	webparam4	varchar	2000	√		null	Web Site Parameter 4 (default footer left)
w_store	webparam4	varchar	2000	√		null	Web Site Parameter 4 (default footer left)
w_store_trl	webparam4	varchar	2000	√		null	Web Site Parameter 4 (default footer left)
w_store	webparam5	varchar	2000	√		null	Web Site Parameter 5 (default footer center)
w_store_trl	webparam5	varchar	2000	√		null	Web Site Parameter 5 (default footer center)
w_store	webparam6	varchar	2000	√		null	Web Site Parameter 6 (default footer right)
w_store_trl	webparam6	varchar	2000	√		null	Web Site Parameter 6 (default footer right)
ad_client	windowsarchivepath	varchar	255	√		null	Windows Archive Path
ad_client	windowsattachmentpath	varchar	255	√		null	Windows Attachment Path
w_store	wstoreemail	varchar	60	√		null	EMail address used as the sender (From)
w_store	wstoreuser	varchar	60	√		null	User ID of the Web Store EMail address
w_store	wstoreuserpw	varchar	20	√		null	Password of the Web Store EMail address
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_language	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_usermail	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Client/Tenant for this installation.
r_mailtext	ad_client_id	numeric	10				Client/Tenant for this installation.
r_request	ad_client_id	numeric	10				Client/Tenant for this installation.
w_advertisement	ad_client_id	numeric	10				Client/Tenant for this installation.
w_basket	ad_client_id	numeric	10				Client/Tenant for this installation.
w_basketline	ad_client_id	numeric	10				Client/Tenant for this installation.
w_click	ad_client_id	numeric	10				Client/Tenant for this installation.
w_clickcount	ad_client_id	numeric	10				Client/Tenant for this installation.
w_counter	ad_client_id	numeric	10				Client/Tenant for this installation.
w_countercount	ad_client_id	numeric	10				Client/Tenant for this installation.
w_mailmsg	ad_client_id	numeric	10				Client/Tenant for this installation.
w_mailmsg_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
w_store	ad_client_id	numeric	10				Client/Tenant for this installation.
w_store_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_language	ad_language	varchar	6				Language for this entity
w_mailmsg_trl	ad_language	varchar	6				Language for this entity
w_store_trl	ad_language	varchar	6				Language for this entity
ad_language	ad_language_id	numeric	10				Language ID
ad_client	ad_org_id	numeric	10				Organizational entity within client
ad_clientinfo	ad_org_id	numeric	10				Organizational entity within client
ad_language	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_org_id	numeric	10				Organizational entity within client
ad_usermail	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm	ad_org_id	numeric	10				Organizational entity within client
m_pricelist	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_warehouse	ad_org_id	numeric	10				Organizational entity within client
r_mailtext	ad_org_id	numeric	10				Organizational entity within client
r_request	ad_org_id	numeric	10				Organizational entity within client
w_advertisement	ad_org_id	numeric	10				Organizational entity within client
w_basket	ad_org_id	numeric	10				Organizational entity within client
w_basketline	ad_org_id	numeric	10				Organizational entity within client
w_click	ad_org_id	numeric	10				Organizational entity within client
w_clickcount	ad_org_id	numeric	10				Organizational entity within client
w_counter	ad_org_id	numeric	10				Organizational entity within client
w_countercount	ad_org_id	numeric	10				Organizational entity within client
w_mailmsg	ad_org_id	numeric	10				Organizational entity within client
w_mailmsg_trl	ad_org_id	numeric	10				Organizational entity within client
w_store	ad_org_id	numeric	10				Organizational entity within client
w_store_trl	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_usermail	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
w_basket	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_usermail	ad_usermail_id	numeric	10				Mail sent to the user
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
w_advertisement	c_bpartner_id	numeric	10				Identifies a Business Partner
m_pricelist	c_currency_id	numeric	10				The Currency for this record
m_warehouse	c_location_id	numeric	10				Location or Address
c_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
m_product	c_taxcategory_id	numeric	10				Tax Category
m_product	c_uom_id	numeric	10				Unit of Measure
r_request	confidentialtypeentry	bpchar	1				Confidentiality of the individual entry
ad_client	createdby	numeric	10				User who created this records
ad_clientinfo	createdby	numeric	10				User who created this records
ad_language	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
ad_usermail	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
r_mailtext	createdby	numeric	10				User who created this records
r_request	createdby	numeric	10				User who created this records
w_advertisement	createdby	numeric	10				User who created this records
w_basket	createdby	numeric	10				User who created this records
w_basketline	createdby	numeric	10				User who created this records
w_click	createdby	numeric	10				User who created this records
w_clickcount	createdby	numeric	10				User who created this records
w_counter	createdby	numeric	10				User who created this records
w_countercount	createdby	numeric	10				User who created this records
w_mailmsg	createdby	numeric	10				User who created this records
w_mailmsg_trl	createdby	numeric	10				User who created this records
w_store	createdby	numeric	10				User who created this records
w_store_trl	createdby	numeric	10				User who created this records
w_basketline	description	varchar	255				Optional short description of the record
c_paymentterm	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_paymentterm	discountdays2	numeric	10				Number of days from invoice date to be eligible for discount
r_request	documentno	varchar	30				Document sequence number of the document
r_request	duetype	bpchar	1				Status of the next action for this Request
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
w_basketline	line	numeric	10				Unique line for this document
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
w_store	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
m_product	m_product_id	numeric	10				Product, Service, Item
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
w_store	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
w_mailmsg	mailmsgtype	bpchar	2				Mail Message Type
r_mailtext	mailtext	text	2147483647				Text used for Mail message
w_mailmsg	message	varchar	2000				EMail Message
w_mailmsg_trl	message	varchar	2000				EMail Message
ad_client	name	varchar	60				Alphanumeric identifier of the entity
ad_language	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_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext	name	varchar	60				Alphanumeric identifier of the entity
w_advertisement	name	varchar	60				Alphanumeric identifier of the entity
w_clickcount	name	varchar	60				Alphanumeric identifier of the entity
w_countercount	name	varchar	60				Alphanumeric identifier of the entity
w_mailmsg	name	varchar	60				Alphanumeric identifier of the entity
w_store	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
w_counter	pageurl	varchar	120				Page URL
w_countercount	pageurl	varchar	120				Page URL
r_request	priority	bpchar	1				Indicates if this request is of a high, medium or low priority.
w_basketline	product	varchar	40				Product
w_advertisement	publishstatus	bpchar	1				Status of Publication
r_mailtext	r_mailtext_id	numeric	10				Text templates for mailings
r_request	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_request	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_request	salesrep_id	numeric	10				Sales Representative or Company Agent
w_store	salesrep_id	numeric	10				Sales Representative or Company Agent
m_warehouse	separator	bpchar	1				Element Separator
w_basket	session_id	varchar	60				Session ID
w_mailmsg	subject	varchar	255				Email Message Subject
w_mailmsg_trl	subject	varchar	255				Email Message Subject
r_request	summary	varchar	2000				Textual summary of this request
w_clickcount	targeturl	varchar	120				URL for the Target
ad_client	updatedby	numeric	10				User who updated this records
ad_clientinfo	updatedby	numeric	10				User who updated this records
ad_language	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
ad_usermail	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
r_mailtext	updatedby	numeric	10				User who updated this records
r_request	updatedby	numeric	10				User who updated this records
w_advertisement	updatedby	numeric	10				User who updated this records
w_basket	updatedby	numeric	10				User who updated this records
w_basketline	updatedby	numeric	10				User who updated this records
w_click	updatedby	numeric	10				User who updated this records
w_clickcount	updatedby	numeric	10				User who updated this records
w_counter	updatedby	numeric	10				User who updated this records
w_countercount	updatedby	numeric	10				User who updated this records
w_mailmsg	updatedby	numeric	10				User who updated this records
w_mailmsg_trl	updatedby	numeric	10				User who updated this records
w_store	updatedby	numeric	10				User who updated this records
w_store_trl	updatedby	numeric	10				User who updated this records
ad_client	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
c_paymentterm	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_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
w_advertisement	w_advertisement_id	numeric	10				Web Advertisement
w_basket	w_basket_id	numeric	10				Web Basket
w_basketline	w_basket_id	numeric	10				Web Basket
w_basketline	w_basketline_id	numeric	10				Web Basket Line
w_click	w_click_id	numeric	10				Individual Web Click
w_clickcount	w_clickcount_id	numeric	10				Web Click Management
w_counter	w_counter_id	numeric	10				Individual Count hit
w_countercount	w_countercount_id	numeric	10				Web Counter Count Management
w_mailmsg	w_mailmsg_id	numeric	10				Web Store Mail Message Template
w_mailmsg_trl	w_mailmsg_id	numeric	10				Web Store Mail Message Template
w_mailmsg	w_store_id	numeric	10				A Web Store of the Client
w_store	w_store_id	numeric	10				A Web Store of the Client
w_store_trl	w_store_id	numeric	10				A Web Store of the Client
w_store	webcontext	varchar	20				Web Server Context - e.g. /wstore
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
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_language	ad_language_uu	varchar	36	√		NULL::character varying	AD_Language_UU
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
ad_usermail	ad_usermail_uu	varchar	36	√		NULL::character varying	AD_UserMail_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_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
ad_usermail	emailfrom	varchar	255	√		NULL::character varying	EMail sent from
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_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
r_mailtext	r_mailtext_uu	varchar	36	√		NULL::character varying	R_MailText_UU
r_request	r_request_uu	varchar	36	√		NULL::character varying	R_Request_UU
ad_usermail	recipientto	varchar	2000	√		NULL::character varying	To
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
w_advertisement	w_advertisement_uu	varchar	36	√		NULL::character varying	W_Advertisement_UU
w_basket	w_basket_uu	varchar	36	√		NULL::character varying	W_Basket_UU
w_basketline	w_basketline_uu	varchar	36	√		NULL::character varying	W_BasketLine_UU
w_click	w_click_uu	varchar	36	√		NULL::character varying	W_Click_UU
w_clickcount	w_clickcount_uu	varchar	36	√		NULL::character varying	W_ClickCount_UU
w_counter	w_counter_uu	varchar	36	√		NULL::character varying	W_Counter_UU
w_countercount	w_countercount_uu	varchar	36	√		NULL::character varying	W_CounterCount_UU
w_mailmsg_trl	w_mailmsg_trl_uu	varchar	36	√		NULL::character varying	W_MailMsg_Trl_UU
w_mailmsg	w_mailmsg_uu	varchar	36	√		NULL::character varying	W_MailMsg_UU
w_store_trl	w_store_trl_uu	varchar	36	√		NULL::character varying	W_Store_Trl_UU
w_store	w_store_uu	varchar	36	√		NULL::character varying	W_Store_UU
ad_language	printname	varchar	60			NULL::character varying	The label text to be printed on a document or correspondence.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
ad_client	ad_passwordrule_id	numeric	10	√		NULL::numeric	Password Policies
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
ad_clientinfo	ad_storageprovider_id	numeric	10	√		NULL::numeric	Storage Provider
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_clientinfo	c_chargefreight_id	numeric	10	√		NULL::numeric	Charge for Freight
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
ad_clientinfo	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
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
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
ad_client	smtpport	numeric	10	√		NULL::numeric	SMTP Port Number
ad_clientinfo	storagearchive_id	numeric	10	√		NULL::numeric	Archive Store
ad_clientinfo	storageimage_id	numeric	10	√		NULL::numeric	Storage provider for Image