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

Table	Column	Type	Size	Nulls	Auto	Default
a_asset	a_asset_action	varchar	2			'MD'::character varying	Asset Action
a_asset	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
a_asset	a_asset_createdate	timestamp	29,6	√		null	Create Date
a_asset_delivery	a_asset_delivery_id	numeric	10				Delivery of Asset
a_asset_delivery	a_asset_delivery_uu	varchar	36	√		NULL::character varying	A_Asset_Delivery_UU
a_asset	a_asset_group_id	numeric	10				Group of Assets
a_asset	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_delivery	a_asset_id	numeric	10				Asset used internally or by customers
r_request	a_asset_id	numeric	10	√		null	Asset used internally or by customers
r_requestaction	a_asset_id	numeric	10	√		null	Asset used internally or by customers
a_asset	a_asset_revaldate	timestamp	29,6	√		null	Revaluation Date
a_asset	a_asset_status	varchar	2			'NW'::character varying	Asset Status
a_asset	a_asset_type_id	numeric	10	√		null	Asset Type
a_asset	a_asset_uu	varchar	36	√		NULL::character varying	A_Asset_UU
a_asset	a_assettype	varchar	3			'MFX'::character varying	Asset Type
a_asset	a_parent_asset_id	numeric	10	√		null	Parent Asset
a_asset	a_qty_current	numeric	0	√		null	Current Qty
a_asset	a_qty_original	numeric	0	√		null	A_QTY_Original
ad_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
a_asset	ad_client_id	numeric	10				Client/Tenant for this installation.
a_asset_delivery	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_role	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_smtp	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.
ad_usermail	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bp_group	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
m_changenotice	ad_client_id	numeric	10				Client/Tenant for this installation.
m_changerequest	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inout	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_rma	ad_client_id	numeric	10				Client/Tenant for this installation.
r_category	ad_client_id	numeric	10				Client/Tenant for this installation.
r_categoryupdates	ad_client_id	numeric	10				Client/Tenant for this installation.
r_contactinterest	ad_client_id	numeric	10				Client/Tenant for this installation.
r_group	ad_client_id	numeric	10				Client/Tenant for this installation.
r_groupupdates	ad_client_id	numeric	10				Client/Tenant for this installation.
r_interestarea	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.
r_requestaction	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestprocessor	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestprocessor_route	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requesttype	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requesttypeupdates	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestupdate	ad_client_id	numeric	10				Client/Tenant for this installation.
r_requestupdates	ad_client_id	numeric	10				Client/Tenant for this installation.
r_resolution	ad_client_id	numeric	10				Client/Tenant for this installation.
r_standardresponse	ad_client_id	numeric	10				Client/Tenant for this installation.
r_status	ad_client_id	numeric	10				Client/Tenant for this installation.
r_statuscategory	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
a_asset	ad_org_id	numeric	10				Organizational entity within client
a_asset_delivery	ad_org_id	numeric	10				Organizational entity within client
ad_role	ad_org_id	numeric	10				Organizational entity within client
ad_smtp	ad_org_id	numeric	10			0	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
ad_usermail	ad_org_id	numeric	10				Organizational entity within client
c_activity	ad_org_id	numeric	10				Organizational entity within client
c_bp_group	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
m_changenotice	ad_org_id	numeric	10				Organizational entity within client
m_changerequest	ad_org_id	numeric	10				Organizational entity within client
m_inout	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_rma	ad_org_id	numeric	10				Organizational entity within client
r_category	ad_org_id	numeric	10				Organizational entity within client
r_categoryupdates	ad_org_id	numeric	10				Organizational entity within client
r_contactinterest	ad_org_id	numeric	10				Organizational entity within client
r_group	ad_org_id	numeric	10				Organizational entity within client
r_groupupdates	ad_org_id	numeric	10				Organizational entity within client
r_interestarea	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
r_requestaction	ad_org_id	numeric	10				Organizational entity within client
r_requestprocessor	ad_org_id	numeric	10				Organizational entity within client
r_requestprocessor_route	ad_org_id	numeric	10				Organizational entity within client
r_requesttype	ad_org_id	numeric	10				Organizational entity within client
r_requesttypeupdates	ad_org_id	numeric	10				Organizational entity within client
r_requestupdate	ad_org_id	numeric	10				Organizational entity within client
r_requestupdates	ad_org_id	numeric	10				Organizational entity within client
r_resolution	ad_org_id	numeric	10				Organizational entity within client
r_standardresponse	ad_org_id	numeric	10				Organizational entity within client
r_status	ad_org_id	numeric	10				Organizational entity within client
r_statuscategory	ad_org_id	numeric	10				Organizational entity within client
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
m_inout	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_bp_group	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_role	ad_role_id	numeric	10				Responsibility Role
r_request	ad_role_id	numeric	10	√		null	Responsibility Role
r_requestaction	ad_role_id	numeric	10	√		null	Responsibility Role
ad_role	ad_role_uu	varchar	36	√		NULL::character varying	AD_Role_UU
r_requestprocessor	ad_schedule_id	numeric	10			NULL::numeric	Schedule
ad_smtp	ad_smtp_id	numeric	10				SMTP Server
ad_smtp	ad_smtp_uu	varchar	36	√		NULL::character varying	AD_SMTP_UU
ad_table	ad_table_id	numeric	10				Database Table information
r_request	ad_table_id	numeric	10	√		null	Database Table information
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_role	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_role	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
a_asset	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
a_asset_delivery	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_usermail	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
m_inout	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
r_categoryupdates	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
r_contactinterest	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
r_groupupdates	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
r_request	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
r_requestaction	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
r_requestprocessor_route	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
r_requesttypeupdates	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
r_requestupdates	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_usermail	ad_usermail_id	numeric	10				Mail sent to the user
ad_usermail	ad_usermail_uu	varchar	36	√		NULL::character varying	AD_UserMail_UU
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
ad_role	allow_info_account	bpchar	1			'Y'::bpchar	Allow Info Account
ad_role	allow_info_asset	bpchar	1			'Y'::bpchar	Allow Info Asset
ad_role	allow_info_bpartner	bpchar	1			'Y'::bpchar	Allow Info BPartner
ad_role	allow_info_cashjournal	bpchar	1			'N'::bpchar	Allow Info CashJournal
ad_role	allow_info_crp	bpchar	1			'N'::bpchar	Allow Info CRP
ad_role	allow_info_inout	bpchar	1			'Y'::bpchar	Allow Info InOut
ad_role	allow_info_invoice	bpchar	1			'Y'::bpchar	Allow Info Invoice
ad_role	allow_info_mrp	bpchar	1			'N'::bpchar	Allow Info MRP
ad_role	allow_info_order	bpchar	1			'Y'::bpchar	Allow Info Order
ad_role	allow_info_payment	bpchar	1			'Y'::bpchar	Allow Info Payment
ad_role	allow_info_product	bpchar	1			'Y'::bpchar	Allow Info Product
ad_role	allow_info_resource	bpchar	1			'Y'::bpchar	Allow Info Resource
ad_role	allow_info_schedule	bpchar	1			'Y'::bpchar	Allow Info Schedule
m_rma	amt	numeric	0	√		null	Amount
ad_role	amtapproval	numeric	0	√		0	The approval amount limit for this role
ad_role	amtapprovalaccum	numeric	0	√		null	The approval amount limit for this role accumulated on a period
ad_user	answer	varchar	1024	√		NULL::character varying	Answer
a_asset	assetactivationdate	timestamp	29,6	√		null	Activation Date
a_asset	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
a_asset	assetdisposaldate	timestamp	29,6	√		null	Date when the asset is/was disposed
a_asset	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
r_requesttype	autoduedatedays	numeric	10	√		null	Automatic Due Date Days
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
a_asset	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_activity	c_activity_id	numeric	10				Business Activity
m_inout	c_activity_id	numeric	10	√		null	Business Activity
r_request	c_activity_id	numeric	10	√		null	Business Activity
r_requestaction	c_activity_id	numeric	10	√		null	Business Activity
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_bp_group	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bp_group	c_bp_group_uu	varchar	36	√		NULL::character varying	C_BP_Group_UU
a_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
m_inout	c_bpartner_id	numeric	10				Identifies a Business Partner
m_rma	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
r_request	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
r_requestaction	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
a_asset	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
ad_user	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
m_inout	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
a_asset	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
r_request	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inout	c_charge_id	numeric	10	√		null	Additional document charges
ad_role	c_currency_id	numeric	10	√		null	The Currency for this record
m_rma	c_currency_id	numeric	10	√		null	The Currency for this record
m_inout	c_doctype_id	numeric	10				Document type or rules
m_rma	c_doctype_id	numeric	10				Document type or rules
c_bp_group	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
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
m_inout	c_invoice_id	numeric	10	√		null	Invoice Identifier
r_request	c_invoice_id	numeric	10	√		null	Invoice Identifier
r_requestaction	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
a_asset	c_location_id	numeric	10	√		null	Location or Address
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
m_inout	c_order_id	numeric	10	√		null	Order
m_rma	c_order_id	numeric	10	√		null	Order
r_request	c_order_id	numeric	10	√		null	Order
r_requestaction	c_order_id	numeric	10	√		null	Order
r_request	c_payment_id	numeric	10	√		null	Payment identifier
r_requestaction	c_payment_id	numeric	10	√		null	Payment identifier
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
a_asset	c_project_id	numeric	10	√		null	Financial Project
m_inout	c_project_id	numeric	10	√		null	Financial Project
r_request	c_project_id	numeric	10	√		null	Financial Project
r_requestaction	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
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
m_product	c_uom_id	numeric	10				Unit of Measure
m_inout	chargeamt	numeric	0	√		0	Charge Amount
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
r_request	confidentialtype	bpchar	1			'C'::bpchar	Type of Confidentiality
r_requestaction	confidentialtype	bpchar	1	√		null	Type of Confidentiality
r_requesttype	confidentialtype	bpchar	1			'C'::bpchar	Type of Confidentiality
r_request	confidentialtypeentry	bpchar	1				Confidentiality of the individual entry
r_requestupdate	confidentialtypeentry	bpchar	1				Confidentiality of the individual entry
ad_role	confirmqueryrecords	numeric	10			0	Require Confirmation if more records will be returned by the query (If not defined 500)
ad_role	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
r_requesttype	contentcolor	varchar	7	√		NULL::character varying	Content color of calendar dashlet
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
a_asset	created	timestamp	29,6			now()	Date this record was created
a_asset_delivery	created	timestamp	29,6			now()	Date this record was created
ad_role	created	timestamp	29,6			now()	Date this record was created
ad_smtp	created	timestamp	29,6			statement_timestamp()	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
ad_usermail	created	timestamp	29,6			now()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_bp_group	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
m_changenotice	created	timestamp	29,6			now()	Date this record was created
m_changerequest	created	timestamp	29,6			now()	Date this record was created
m_inout	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_rma	created	timestamp	29,6			now()	Date this record was created
r_category	created	timestamp	29,6			now()	Date this record was created
r_categoryupdates	created	timestamp	29,6			now()	Date this record was created
r_contactinterest	created	timestamp	29,6			now()	Date this record was created
r_group	created	timestamp	29,6			now()	Date this record was created
r_groupupdates	created	timestamp	29,6			now()	Date this record was created
r_interestarea	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
r_requestaction	created	timestamp	29,6			now()	Date this record was created
r_requestprocessor	created	timestamp	29,6			now()	Date this record was created
r_requestprocessor_route	created	timestamp	29,6			now()	Date this record was created
r_requesttype	created	timestamp	29,6			now()	Date this record was created
r_requesttypeupdates	created	timestamp	29,6			now()	Date this record was created
r_requestupdate	created	timestamp	29,6			now()	Date this record was created
r_requestupdates	created	timestamp	29,6			now()	Date this record was created
r_resolution	created	timestamp	29,6			now()	Date this record was created
r_standardresponse	created	timestamp	29,6			now()	Date this record was created
r_status	created	timestamp	29,6			now()	Date this record was created
r_statuscategory	created	timestamp	29,6			now()	Date this record was created
a_asset	createdby	numeric	10				User who created this records
a_asset_delivery	createdby	numeric	10				User who created this records
ad_role	createdby	numeric	10				User who created this records
ad_smtp	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
ad_usermail	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_bp_group	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
m_changenotice	createdby	numeric	10				User who created this records
m_changerequest	createdby	numeric	10				User who created this records
m_inout	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_rma	createdby	numeric	10				User who created this records
r_category	createdby	numeric	10				User who created this records
r_categoryupdates	createdby	numeric	10				User who created this records
r_contactinterest	createdby	numeric	10				User who created this records
r_group	createdby	numeric	10				User who created this records
r_groupupdates	createdby	numeric	10				User who created this records
r_interestarea	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
r_requestaction	createdby	numeric	10				User who created this records
r_requestprocessor	createdby	numeric	10				User who created this records
r_requestprocessor_route	createdby	numeric	10				User who created this records
r_requesttype	createdby	numeric	10				User who created this records
r_requesttypeupdates	createdby	numeric	10				User who created this records
r_requestupdate	createdby	numeric	10				User who created this records
r_requestupdates	createdby	numeric	10				User who created this records
r_resolution	createdby	numeric	10				User who created this records
r_standardresponse	createdby	numeric	10				User who created this records
r_status	createdby	numeric	10				User who created this records
r_statuscategory	createdby	numeric	10				User who created this records
m_inout	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_rma	createfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
m_inout	createpackage	bpchar	1	√		null	Create Package
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
c_bp_group	creditwatchpercent	numeric	0	√		null	Credit Watch - Percent of Credit Limit when OK switches to Watch
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
m_inout	dateacct	timestamp	29,6				Accounting Date
r_request	datecompleteplan	timestamp	29,6	√		null	Planned Completion Date
r_requestaction	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_requestprocessor	datelastrun	timestamp	29,6	√		null	Date the process was last run.
r_request	datenextaction	timestamp	29,6	√		null	Date that this request should be acted on
r_requestaction	datenextaction	timestamp	29,6	√		null	Date that this request should be acted on
r_requestprocessor	datenextrun	timestamp	29,6	√		null	Date the process will run next
m_inout	dateordered	timestamp	29,6	√		null	Date of Order
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
m_inout	dateprinted	timestamp	29,6	√		null	Date the document was printed.
m_inout	datereceived	timestamp	29,6	√		null	Date a product was received
r_request	datestartplan	timestamp	29,6	√		null	Planned Start Date
r_requestaction	datestartplan	timestamp	29,6	√		null	Planned Start Date
ad_role	daysapprovalaccum	numeric	10	√		null	The days approval indicates the days to take into account to verify the accumulated approval amount.
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
a_asset_delivery	deliveryconfirmation	varchar	120	√		null	EMail Delivery confirmation
ad_usermail	deliveryconfirmation	varchar	120	√		null	EMail Delivery confirmation
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
a_asset	description	varchar	255	√		null	Optional short description of the record
a_asset_delivery	description	varchar	255	√		null	Optional short description of the record
ad_role	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_activity	description	varchar	255	√		null	Optional short description of the record
c_bp_group	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
m_changenotice	description	varchar	255	√		null	Optional short description of the record
m_changerequest	description	varchar	255	√		null	Optional short description of the record
m_inout	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_rma	description	varchar	255	√		null	Optional short description of the record
r_category	description	varchar	255	√		null	Optional short description of the record
r_group	description	varchar	255	√		null	Optional short description of the record
r_interestarea	description	varchar	255	√		null	Optional short description of the record
r_requestprocessor	description	varchar	255	√		null	Optional short description of the record
r_requesttype	description	varchar	255	√		null	Optional short description of the record
r_resolution	description	varchar	255	√		null	Optional short description of the record
r_status	description	varchar	255	√		null	Optional short description of the record
r_statuscategory	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_changenotice	detailinfo	text	2147483647	√		null	Additional Detail Information
m_changerequest	detailinfo	text	2147483647	√		null	Additional Detail Information
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
m_inout	docaction	bpchar	2				The targeted status of the document
m_rma	docaction	bpchar	2				The targeted status of the document
m_inout	docstatus	bpchar	2				The current status of the document
m_rma	docstatus	bpchar	2				The current status of the document
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
m_changerequest	documentno	varchar	30				Document sequence number of the document
m_inout	documentno	varchar	30				Document sequence number of the document
m_rma	documentno	varchar	30				Document sequence number of the document
r_request	documentno	varchar	30				Document sequence number of the document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
m_inout	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
m_inout	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
m_inout	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
r_requesttype	duedatetolerance	numeric	10			7	Tolerance in days between the Date Next Action and the date the request is regarded as overdue
r_request	duetype	bpchar	1				Status of the next action for this Request
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
a_asset_delivery	email	varchar	60	√		null	Electronic Mail Address
ad_user	email	varchar	60	√		null	Electronic Mail Address
ad_usermail	emailfrom	varchar	255	√		NULL::character varying	EMail sent from
ad_smtp	emailtest	bpchar	1	√		NULL::bpchar	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_requestaction	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
r_request	endtime	timestamp	29,6	√		null	End of the time span
r_requestupdate	endtime	timestamp	29,6	√		null	End of the time span
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
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
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
m_inout	freightamt	numeric	0	√		0	Freight Amount
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_inout	freightcostrule	bpchar	1				Method for charging Freight
r_requestprocessor	frequency	numeric	10	√		(1)::numeric	Frequency of events
r_requestprocessor	frequencytype	bpchar	1	√		null	Frequency of event
m_inout	generateto	bpchar	1	√		null	Generate To
m_rma	generateto	bpchar	1	√		null	Generate To
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
a_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
r_requesttype	headercolor	varchar	7	√		NULL::character varying	Header color of calendar dashlet
a_asset	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
c_activity	help	varchar	2000	√		null	Comment or Hint
m_changenotice	help	varchar	2000	√		null	Comment or Hint
m_changerequest	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_rma	help	varchar	2000	√		null	Comment or Hint
r_category	help	varchar	2000	√		null	Comment or Hint
r_group	help	varchar	2000	√		null	Comment or Hint
r_resolution	help	varchar	2000	√		null	Comment or Hint
r_status	help	varchar	2000	√		null	Comment or Hint
r_statuscategory	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
r_requestprocessor	inactivityalertdays	numeric	10			0	Send Alert when there is no activity after days (0= no alert)
m_rma	inout_id	numeric	10				MaterialShipment Document
m_inout	insurance	bpchar	1	√		NULL::bpchar	Insurance
a_asset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
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_role	isaccessadvanced	bpchar	1	√		'N'::bpchar	Access Advanced
ad_role	isaccessallorgs	bpchar	1			'N'::bpchar	Access all Organizations (no org access control) of the client
a_asset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_delivery	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_smtp	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
ad_usermail	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bp_group	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_changenotice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_changerequest	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	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_rma	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_categoryupdates	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_contactinterest	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_group	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_groupupdates	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_interestarea	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
r_requestaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestprocessor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestprocessor_route	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requesttype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requesttypeupdates	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestupdate	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_requestupdates	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_resolution	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_standardresponse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_status	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_statuscategory	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
m_inout	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
m_changenotice	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_changerequest	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inout	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_rma	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
r_requesttype	isautochangerequest	bpchar	1			'N'::bpchar	Automatically create BOM (Engineering) Change Request
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
ad_role	iscanapproveowndoc	bpchar	1			'Y'::bpchar	Users with this role can approve their own documents
ad_role	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_role	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_role	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
r_status	isclosed	bpchar	1			'N'::bpchar	The status is closed
c_bp_group	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
r_requesttype	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_bp_group	isdefault	bpchar	1			'N'::bpchar	Default value
r_requesttype	isdefault	bpchar	1			'N'::bpchar	Default value
r_status	isdefault	bpchar	1			'N'::bpchar	Default value
r_statuscategory	isdefault	bpchar	1			'N'::bpchar	Default value
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
ad_usermail	isdelivered	bpchar	1	√		null	Delivered
a_asset	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
ad_role	isdiscountallowedontotal	bpchar	1			'N'::bpchar	IsDiscountAllowedOnTotal
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
ad_role	isdiscountuptolimitprice	bpchar	1			'N'::bpchar	IsDiscountUptoLimitPrice
a_asset	isdisposed	bpchar	1			'N'::bpchar	The asset is disposed
m_inout	isdropship	bpchar	1	√		'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
r_requesttype	isemailwhendue	bpchar	1			'N'::bpchar	Send EMail when Request becomes due
r_requesttype	isemailwhenoverdue	bpchar	1			'N'::bpchar	Send EMail when Request becomes overdue
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
r_requestaction	isescalated	bpchar	1	√		null	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_status	isfinalclose	bpchar	1			'N'::bpchar	Entries with Final Close cannot be re-opened
ad_user	isfullbpaccess	bpchar	1			'Y'::bpchar	The user/contact has full access to Business Partner information and resources
a_asset	isfullydepreciated	bpchar	1			'N'::bpchar	The asset is fully depreciated
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
r_mailtext	ishtml	bpchar	1			'N'::bpchar	Text has HTML tags
r_requesttype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
m_inout	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
ad_user	isinpayroll	bpchar	1			'N'::bpchar	Defined if any User Contact will be used for Calculate Payroll
a_asset	isinposession	bpchar	1			'Y'::bpchar	The asset is in the possession of the organization
m_inout	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
r_request	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
r_requestaction	isinvoiced	bpchar	1	√		null	Is this invoiced?
r_requesttype	isinvoiced	bpchar	1	√		null	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
ad_role	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
ad_role	ismasterrole	bpchar	1			'N'::bpchar	A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role	ismenuautoexpand	bpchar	1			'N'::bpchar	If ticked, the menu is automatically expanded
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
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
r_status	isopen	bpchar	1			'N'::bpchar	The status is closed
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
a_asset	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
ad_role	ispersonalaccess	bpchar	1			'N'::bpchar	Allow access to all personal records
ad_role	ispersonallock	bpchar	1			'N'::bpchar	Allow users with role to lock access to personal records
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
m_inout	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
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_smtp	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
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_categoryupdates	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_groupupdates	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_interestarea	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_request	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_requestaction	isselfservice	bpchar	1	√		null	This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttype	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttypeupdates	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
r_requestupdates	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_role	isshowacct	bpchar	1			'Y'::bpchar	Users with this role can see accounting information
ad_smtp	issmtpauthorization	bpchar	1			'N'::bpchar	Your mail server requires Authentication
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_inout	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_rma	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
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
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_product	istoformule	bpchar	1	√		null
ad_role	isuseuserorgaccess	bpchar	1			'N'::bpchar	Use Org Access defined by user instead of Role Org Access
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
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
r_status	iswebcanupdate	bpchar	1			'Y'::bpchar	Entry can be updated from the Web
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
r_requestprocessor	keeplogdays	numeric	10				Number of days to keep the log entries
r_requestprocessor_route	keyword	varchar	60	√		null	Case insensitive keyword
ad_user	lastcontact	timestamp	29,6	√		null	Date this individual was last contacted
a_asset	lastmaintenancedate	timestamp	29,6	√		null	Last Maintenance Date
a_asset	lastmaintenancenote	varchar	60	√		null	Last Maintenance Note
a_asset	lastmaintenanceunit	numeric	10	√		null	Last Maintenance Unit
a_asset	lastmaintenanceuseunit	numeric	10	√		null
a_asset	lastmaintenencedate	timestamp	29,6	√		null
ad_user	lastresult	varchar	255	√		null	Result of last contact
r_request	lastresult	varchar	2000	√		null	Result of last contact
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
a_asset	lease_bpartner_id	numeric	10	√		null	The Business Partner who rents or leases
a_asset	leaseterminationdate	timestamp	29,6	√		null	Lease Termination Date
a_asset	lifeuseunits	numeric	0	√		null	Units of use until the asset is not usable anymore
ad_table	loadseq	numeric	10	√		null	Sequence
a_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
a_asset	lot	varchar	255	√		null	Lot number (alphanumeric)
a_asset_delivery	lot	varchar	40	√		null	Lot number (alphanumeric)
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
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
a_asset	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
r_group	m_bom_id	numeric	10	√		null
m_changenotice	m_changenotice_id	numeric	10				Bill of Materials (Engineering) Change Notice (Version)
m_changerequest	m_changenotice_id	numeric	10	√		null	Bill of Materials (Engineering) Change Notice (Version)
r_group	m_changenotice_id	numeric	10	√		null	Bill of Materials (Engineering) Change Notice (Version)
m_changenotice	m_changenotice_uu	varchar	36	√		NULL::character varying	M_ChangeNotice_UU
m_changerequest	m_changerequest_id	numeric	10				BOM (Engineering) Change Request
r_request	m_changerequest_id	numeric	10	√		null	BOM (Engineering) Change Request
m_changerequest	m_changerequest_uu	varchar	36	√		NULL::character varying	M_ChangeRequest_UU
c_bp_group	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_changerequest	m_fixchangenotice_id	numeric	10	√		null	Fixed in Change Notice
r_request	m_fixchangenotice_id	numeric	10	√		null	Fixed in Change Notice
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_inout	m_inout_id	numeric	10				Material Shipment Document
r_request	m_inout_id	numeric	10	√		null	Material Shipment Document
r_requestaction	m_inout_id	numeric	10	√		null	Material Shipment Document
m_inout	m_inout_uu	varchar	36	√		NULL::character varying	M_InOut_UU
a_asset	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
a_asset_delivery	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
a_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_bp_group	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
a_asset	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
r_category	m_product_id	numeric	10	√		null	Product, Service, Item
r_request	m_product_id	numeric	10	√		null	Product, Service, Item
r_requestaction	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
a_asset_delivery	m_productdownload_id	numeric	10	√		null	Product downloads
r_request	m_productspent_id	numeric	10	√		null	Product/Resource/Service used in Request
r_requestaction	m_productspent_id	numeric	10	√		null	Product/Resource/Service used in Request
r_requestupdate	m_productspent_id	numeric	10	√		null	Product/Resource/Service used in Request
m_inout	m_rma_id	numeric	10	√		null	Return Material Authorization
m_rma	m_rma_id	numeric	10				Return Material Authorization
r_request	m_rma_id	numeric	10	√		null	Return Material Authorization
r_requestaction	m_rma_id	numeric	10	√		null	Return Material Authorization
m_rma	m_rma_uu	varchar	36	√		NULL::character varying	M_RMA_UU
m_rma	m_rmatype_id	numeric	10	√		null	Return Material Authorization Type
m_inout	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
r_mailtext	mailheader	varchar	2000	√		null	Mail Header (Subject)
ad_usermail	mailtext	varchar	2000	√		null	Text used for Mail message
r_mailtext	mailtext	text	2147483647				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
a_asset	manufacturedyear	numeric	10	√		NULL::numeric	Manufactured Year
a_asset	manufacturer	varchar	30	√		NULL::character varying	Manufacturer of the Product
ad_role	maxqueryrecords	numeric	10			0	If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
a_asset_delivery	messageid	varchar	120	√		null	EMail Message ID
ad_usermail	messageid	varchar	120	√		null	EMail Message ID
a_asset_delivery	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	movementtype	bpchar	2				Method of moving the inventory
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
a_asset	name	varchar	60				Alphanumeric identifier of the entity
ad_role	name	varchar	60				Alphanumeric identifier of the entity
ad_smtp	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_activity	name	varchar	60				Alphanumeric identifier of the entity
c_bp_group	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
m_changenotice	name	varchar	60				Alphanumeric identifier of the entity
m_changerequest	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_rma	name	varchar	60				Alphanumeric identifier of the entity
r_category	name	varchar	60				Alphanumeric identifier of the entity
r_group	name	varchar	60				Alphanumeric identifier of the entity
r_interestarea	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext	name	varchar	60				Alphanumeric identifier of the entity
r_requestprocessor	name	varchar	60				Alphanumeric identifier of the entity
r_requesttype	name	varchar	60				Alphanumeric identifier of the entity
r_resolution	name	varchar	60				Alphanumeric identifier of the entity
r_standardresponse	name	varchar	60				Alphanumeric identifier of the entity
r_status	name	varchar	60				Alphanumeric identifier of the entity
r_statuscategory	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
r_status	next_status_id	numeric	10	√		null	Move to next status automatically after timeout
r_request	nextaction	bpchar	1	√		null	Next Action to be taken
a_asset	nextmaintenanceuseunit	numeric	10	√		null
a_asset	nextmaintenencedate	timestamp	29,6	√		null	Next Maintenence Date
a_asset	nextmaintenenceunit	numeric	10	√		null	Next Maintenence Unit
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
r_requestaction	nullcolumns	varchar	255	√		null	Columns with NULL value
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
r_contactinterest	optoutdate	timestamp	29,6	√		null	Date the contact opted out
r_requestprocessor	overduealertdays	numeric	10				Send email alert after number of days due (0=no alerts)
r_requestprocessor	overdueassigndays	numeric	10				Escalation to superior after number of due days (0 = no)
ad_role	overwritepricelimit	bpchar	1			'N'::bpchar	Overwrite Price Limit if the Price List enforces the Price Limit
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.
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
c_bp_group	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
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_bp_group	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
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
m_inout	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout	posted	bpchar	1			'N'::bpchar	Posting status
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
m_changerequest	pp_product_bom_id	numeric	10	√		null	BOM & Formula
r_group	pp_product_bom_id	numeric	10	√		null	BOM & Formula
ad_role	preferencetype	bpchar	1			'C'::bpchar	Determines what preferences the user can set
c_bp_group	pricematchtolerance	numeric	0	√		null	PO-Invoice Match Price Tolerance in percent of the purchase price
r_request	priority	bpchar	1				Indicates if this request is of a high, medium or low priority.
r_requestaction	priority	bpchar	1	√		null	Indicates if this request is of a high, medium or low priority.
c_bp_group	prioritybase	bpchar	1	√		null	Base of Priority
m_inout	priorityrule	bpchar	1				Priority of a document
r_request	priorityuser	bpchar	1	√		null	Priority of the issue for the User
r_requestaction	priorityuser	bpchar	1	√		null	Priority of the issue for the User
a_asset	processed	bpchar	1			'N'::bpchar	The document has been processed
m_changenotice	processed	bpchar	1			'N'::bpchar	The document has been processed
m_changerequest	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inout	processed	bpchar	1			'N'::bpchar	The document has been processed
m_rma	processed	bpchar	1			'N'::bpchar	The document has been processed
r_request	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inout	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
a_asset	processing	bpchar	1	√		'N'::bpchar	Process Now
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
m_changenotice	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_rma	processing	bpchar	1	√		null	Process Now
r_requestprocessor	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
a_asset	qty	numeric	0	√		null	Quantity
r_request	qtyinvoiced	numeric	0	√		0	Invoiced Quantity
r_requestaction	qtyinvoiced	numeric	0	√		null	Invoiced Quantity
r_requestupdate	qtyinvoiced	numeric	0	√		0	Invoiced Quantity
r_request	qtyplan	numeric	0	√		null	Planned Quantity
r_requestaction	qtyplan	numeric	0	√		null	Planned Quantity
r_request	qtyspent	numeric	0	√		0	Quantity used for this event
r_requestaction	qtyspent	numeric	0	√		null	Quantity used for this event
r_requestupdate	qtyspent	numeric	0	√		0	Quantity used for this event
r_category	r_category_id	numeric	10				Request Category
r_categoryupdates	r_category_id	numeric	10				Request Category
r_request	r_category_id	numeric	10	√		null	Request Category
r_requestaction	r_category_id	numeric	10	√		null	Request Category
r_category	r_category_uu	varchar	36	√		NULL::character varying	R_Category_UU
r_categoryupdates	r_categoryupdates_uu	varchar	36	√		NULL::character varying	R_CategoryUpdates_UU
r_contactinterest	r_contactinterest_uu	varchar	36	√		NULL::character varying	R_ContactInterest_UU
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
r_group	r_group_id	numeric	10				Request Group
r_groupupdates	r_group_id	numeric	10				Request Group
r_request	r_group_id	numeric	10	√		null	Request Group
r_requestaction	r_group_id	numeric	10	√		null	Request Group
r_group	r_group_uu	varchar	36	√		NULL::character varying	R_Group_UU
r_groupupdates	r_groupupdates_uu	varchar	36	√		NULL::character varying	R_GroupUpdates_UU
r_contactinterest	r_interestarea_id	numeric	10				Interest Area or Topic
r_interestarea	r_interestarea_id	numeric	10				Interest Area or Topic
r_interestarea	r_interestarea_uu	varchar	36	√		NULL::character varying	R_InterestArea_UU
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_mailtext	r_mailtext_id	numeric	10				Text templates for mailings
r_request	r_mailtext_id	numeric	10	√		null	Text templates for mailings
r_mailtext	r_mailtext_uu	varchar	36	√		NULL::character varying	R_MailText_UU
r_request	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_requestaction	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_requestupdate	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_requestupdates	r_request_id	numeric	10				Request from a Business Partner or Prospect
r_request	r_request_uu	varchar	36	√		NULL::character varying	R_Request_UU
r_requestaction	r_requestaction_id	numeric	10				Request has been changed
r_requestaction	r_requestaction_uu	varchar	36	√		NULL::character varying	R_RequestAction_UU
r_requestprocessor	r_requestprocessor_id	numeric	10				Processor for Requests
r_requestprocessor_route	r_requestprocessor_id	numeric	10				Processor for Requests
r_requestprocessor_route	r_requestprocessor_route_id	numeric	10				Automatic routing of requests
r_requestprocessor_route	r_requestprocessor_route_uu	varchar	36	√		NULL::character varying	R_RequestProcessor_Route_UU
r_requestprocessor	r_requestprocessor_uu	varchar	36	√		NULL::character varying	R_RequestProcessor_UU
r_request	r_requestrelated_id	numeric	10	√		null	Related Request (Master Issue, ..)
r_request	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_requestaction	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor_route	r_requesttype_id	numeric	10	√		null	Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_requesttypeupdates	r_requesttype_id	numeric	10				Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype	r_requesttype_uu	varchar	36	√		NULL::character varying	R_RequestType_UU
r_requesttypeupdates	r_requesttypeupdates_uu	varchar	36	√		NULL::character varying	R_RequestTypeUpdates_UU
r_requestupdate	r_requestupdate_id	numeric	10				Request Updates
r_requestupdate	r_requestupdate_uu	varchar	36	√		NULL::character varying	R_RequestUpdate_UU
r_requestupdates	r_requestupdates_uu	varchar	36	√		NULL::character varying	R_RequestUpdates_UU
r_request	r_resolution_id	numeric	10	√		null	Request Resolution
r_requestaction	r_resolution_id	numeric	10	√		null	Request Resolution
r_resolution	r_resolution_id	numeric	10				Request Resolution
r_resolution	r_resolution_uu	varchar	36	√		NULL::character varying	R_Resolution_UU
r_request	r_standardresponse_id	numeric	10	√		null	Request Standard Response
r_standardresponse	r_standardresponse_id	numeric	10				Request Standard Response
r_standardresponse	r_standardresponse_uu	varchar	36	√		NULL::character varying	R_StandardResponse_UU
r_request	r_status_id	numeric	10	√		null	Request Status
r_requestaction	r_status_id	numeric	10	√		null	Request Status
r_status	r_status_id	numeric	10				Request Status
r_status	r_status_uu	varchar	36	√		NULL::character varying	R_Status_UU
r_requesttype	r_statuscategory_id	numeric	10				Request Status Category
r_status	r_statuscategory_id	numeric	10				Request Status Category
r_statuscategory	r_statuscategory_id	numeric	10				Request Status Category
r_statuscategory	r_statuscategory_uu	varchar	36	√		NULL::character varying	R_StatusCategory_UU
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_usermail	recipientbcc	varchar	2000	√		null	Bcc
ad_usermail	recipientcc	varchar	2000	√		null	Cc
ad_usermail	recipientto	varchar	2000	√		NULL::character varying	To
r_request	record_id	numeric	10	√		null	Direct internal record ID
m_inout	ref_inout_id	numeric	10	√		null	Referenced Shipment
m_rma	ref_rma_id	numeric	10	√		NULL::numeric	Referenced RMA
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
a_asset_delivery	referrer	varchar	255	√		null	Referring web address
r_requestprocessor	reminddays	numeric	10			7	Days between sending Reminder Emails for a due or inactive Document
a_asset_delivery	remote_addr	varchar	60	√		null	Remote Address
a_asset_delivery	remote_host	varchar	60	√		null	Remote host Info
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
r_request	requestamt	numeric	0			0	Amount associated with this request
ad_smtp	requestuser	varchar	60	√		NULL::character varying	User Name (ID) of the email owner
ad_smtp	requestuserpw	varchar	255	√		NULL::character varying	Password of the user name (ID) for mail processing
r_standardresponse	responsetext	varchar	2000				Request Response Text
r_request	result	varchar	2000	√		null	Result of the action taken
r_requestupdate	result	varchar	2000	√		null	Result of the action taken
m_inout	returnbpartner_id	numeric	10	√		NULL::numeric	Return Partner
m_inout	returnlocation_id	numeric	10	√		NULL::numeric	Return Location
m_inout	returnuser_id	numeric	10	√		NULL::numeric	Return User/Contact
m_inout	reversal_id	numeric	10	√		null	ID of document reversal
ad_role	roletype	varchar	2	√		NULL::character varying	Role Type
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
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
m_inout	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_rma	salesrep_id	numeric	10				Sales Representative or Company Agent
r_request	salesrep_id	numeric	10				Sales Representative or Company Agent
r_requestaction	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	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_inout	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
r_requestprocessor_route	seqno	numeric	10				Method of ordering records; lowest number comes first
r_status	seqno	numeric	10			0	Method of ordering records; lowest number comes first
a_asset	serno	varchar	255	√		null	Product Serial Number
a_asset_delivery	serno	varchar	40	√		null	Product Serial Number
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
m_product	sku	varchar	30	√		null	Stock Keeping Unit
ad_smtp	smtphost	varchar	60	√		NULL::character varying	Hostname of Mail Server for SMTP and IMAP
ad_smtp	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
r_request	startdate	timestamp	29,6	√		null	First effective day (inclusive)
r_requestaction	startdate	timestamp	29,6	√		null	First effective day (inclusive)
r_request	starttime	timestamp	29,6	√		null	Time started
r_requestupdate	starttime	timestamp	29,6	√		null	Time started
ad_usermail	subject	varchar	255	√		null	Email Message Subject
r_contactinterest	subscribedate	timestamp	29,6	√		null	Date the contact actively subscribed
r_request	summary	varchar	2000				Textual summary of this request
r_requestaction	summary	varchar	2000	√		null	Textual summary of this request
ad_role	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
r_requestprocessor	supervisor_id	numeric	10				Supervisor for this user/organization - used for escalation and approval
ad_table	tablename	varchar	40				Name of the table in the database
r_request	taskstatus	bpchar	1	√		null	Status of the Task
r_requestaction	taskstatus	bpchar	1	√		null	Status of the Task
c_bpartner	taxid	varchar	20	√		null	Tax Identification
r_status	timeoutdays	numeric	10	√		null	Timeout in Days to change Status automatically
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_inout	trackingno	varchar	60	√		null	Number to track the shipment
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
r_status	update_status_id	numeric	10	√		null	Automatically change the status after entry from web
a_asset	updated	timestamp	29,6			now()	Date this record was updated
a_asset_delivery	updated	timestamp	29,6			now()	Date this record was updated
ad_role	updated	timestamp	29,6			now()	Date this record was updated
ad_smtp	updated	timestamp	29,6			statement_timestamp()	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
ad_usermail	updated	timestamp	29,6			now()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_bp_group	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
m_changenotice	updated	timestamp	29,6			now()	Date this record was updated
m_changerequest	updated	timestamp	29,6			now()	Date this record was updated
m_inout	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_rma	updated	timestamp	29,6			now()	Date this record was updated
r_category	updated	timestamp	29,6			now()	Date this record was updated
r_categoryupdates	updated	timestamp	29,6			now()	Date this record was updated
r_contactinterest	updated	timestamp	29,6			now()	Date this record was updated
r_group	updated	timestamp	29,6			now()	Date this record was updated
r_groupupdates	updated	timestamp	29,6			now()	Date this record was updated
r_interestarea	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
r_requestaction	updated	timestamp	29,6			now()	Date this record was updated
r_requestprocessor	updated	timestamp	29,6			now()	Date this record was updated
r_requestprocessor_route	updated	timestamp	29,6			now()	Date this record was updated
r_requesttype	updated	timestamp	29,6			now()	Date this record was updated
r_requesttypeupdates	updated	timestamp	29,6			now()	Date this record was updated
r_requestupdate	updated	timestamp	29,6			now()	Date this record was updated
r_requestupdates	updated	timestamp	29,6			now()	Date this record was updated
r_resolution	updated	timestamp	29,6			now()	Date this record was updated
r_standardresponse	updated	timestamp	29,6			now()	Date this record was updated
r_status	updated	timestamp	29,6			now()	Date this record was updated
r_statuscategory	updated	timestamp	29,6			now()	Date this record was updated
a_asset	updatedby	numeric	10				User who updated this records
a_asset_delivery	updatedby	numeric	10				User who updated this records
ad_role	updatedby	numeric	10				User who updated this records
ad_smtp	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
ad_usermail	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_bp_group	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
m_changenotice	updatedby	numeric	10				User who updated this records
m_changerequest	updatedby	numeric	10				User who updated this records
m_inout	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_rma	updatedby	numeric	10				User who updated this records
r_category	updatedby	numeric	10				User who updated this records
r_categoryupdates	updatedby	numeric	10				User who updated this records
r_contactinterest	updatedby	numeric	10				User who updated this records
r_group	updatedby	numeric	10				User who updated this records
r_groupupdates	updatedby	numeric	10				User who updated this records
r_interestarea	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
r_requestaction	updatedby	numeric	10				User who updated this records
r_requestprocessor	updatedby	numeric	10				User who updated this records
r_requestprocessor_route	updatedby	numeric	10				User who updated this records
r_requesttype	updatedby	numeric	10				User who updated this records
r_requesttypeupdates	updatedby	numeric	10				User who updated this records
r_requestupdate	updatedby	numeric	10				User who updated this records
r_requestupdates	updatedby	numeric	10				User who updated this records
r_resolution	updatedby	numeric	10				User who updated this records
r_standardresponse	updatedby	numeric	10				User who updated this records
r_status	updatedby	numeric	10				User who updated this records
r_statuscategory	updatedby	numeric	10				User who updated this records
a_asset_delivery	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_smtp	usedbyemailordomain	varchar	255	√		NULL::character varying	Used by email or domain
a_asset	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
a_asset	uselifeyears	numeric	10	√		null	Years of the usable life of the asset
m_inout	user1_id	numeric	10	√		null	User defined list element #1
m_inout	user2_id	numeric	10	√		null	User defined list element #2
ad_role	userdiscount	numeric	22,2	√		null	UserDiscount
ad_role	userlevel	bpchar	3			' O'::bpchar	System Client Organization
ad_user	userpin	varchar	20	√		null	User PIN
a_asset	useunits	numeric	0	√		null	Currently used units of the assets
a_asset	value	varchar	40				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_activity	value	varchar	40				Search key for the record in the format required - must be unique
c_bp_group	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
r_interestarea	value	varchar	40				Search key for the record in the format required - must be unique
r_status	value	varchar	40				Search key for the record in the format required - must be unique
a_asset	versionno	varchar	20	√		null	Version Number
a_asset_delivery	versionno	varchar	20	√		null	Version Number
m_product	versionno	varchar	20	√		null	Version Number
m_inout	volume	numeric	0	√		null	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
ad_usermail	w_mailmsg_id	numeric	10	√		null	Web Store Mail Message Template
m_inout	weight	numeric	0	√		null	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product