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

Table	Column	Type	Size	Nulls	Auto	Default
ad_column	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_element	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_field	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_process	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_process_para	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_reportview	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_column	fkconstrainttype	bpchar	1	√		'N'::bpchar	Constraint Type
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
ad_printtableformat	imageisattached	bpchar	1	√		'N'::bpchar	The image to be printed is attached to the record
ad_field	isadvancedfield	bpchar	1	√		'N'::bpchar	Advanced Field
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
ad_process	isdirectprint	bpchar	1	√		'N'::bpchar	Print without dialog
ad_column	ishtml	bpchar	1	√		'N'::bpchar	Text has HTML tags
ad_language	isloginlocale	bpchar	1	√		'N'::bpchar	Login Locale
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
ad_column	issyncdatabase	bpchar	1	√		'N'::bpchar	Change database table definition when changing dictionary definition
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
ad_printformatitem	imageisattached	bpchar	1			'N'::bpchar	The image to be printed is attached to the record
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
ad_language	isactive	bpchar	1			'N'::bpchar	The record is active in the system
ad_column	isalwaysupdateable	bpchar	1			'N'::bpchar	The column is always updateable, even if the record is not active or processed
ad_column	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for textfields
ad_process_para	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for textfields
ad_printformatitem	isaveraged	bpchar	1			'N'::bpchar	Calculate Average of numeric content or length
ad_language	isbaselanguage	bpchar	1			'N'::bpchar	The system information is maintained in this language
ad_process	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_printformatitem	iscounted	bpchar	1			'N'::bpchar	Count number of not empty elements
ad_printcolor	isdefault	bpchar	1			'N'::bpchar	Default value
ad_printfont	isdefault	bpchar	1			'N'::bpchar	Default value
ad_printformat	isdefault	bpchar	1			'N'::bpchar	Default value
ad_printpaper	isdefault	bpchar	1			'N'::bpchar	Default value
ad_printtableformat	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
ad_field	isdefaultfocus	bpchar	1			'N'::bpchar	Default Focus
ad_printformatitem	isdesc	bpchar	1			'N'::bpchar	Sort your data using a SQL Desc Order By statement
ad_printformatitem	isdeviationcalc	bpchar	1			'N'::bpchar	Calculate Standard Deviation
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
ad_column	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_field	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_process_para	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_field	isfieldonly	bpchar	1			'N'::bpchar	Label is not displayed
ad_printformatitem	isfilledrectangle	bpchar	1			'N'::bpchar	Fill the shape with the color selected
ad_printformatitem	isfixedwidth	bpchar	1			'N'::bpchar	Column has a fixed width
ad_printformat	isform	bpchar	1			'N'::bpchar	If Selected, a Form is printed, if not selected a columnar List report
ad_printformatitem	isgroupby	bpchar	1			'N'::bpchar	After a group change, totals, etc. are printed
ad_reportview_col	isgroupfunction	bpchar	1			'N'::bpchar	This function will generate a Group By Clause
ad_field	isheading	bpchar	1			'N'::bpchar	Field without Column - Only label is displayed
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
r_mailtext	ishtml	bpchar	1			'N'::bpchar	Text has HTML tags
ad_column	isidentifier	bpchar	1			'N'::bpchar	This column is part of the record identifier
ad_printformatitem	isimagefield	bpchar	1			'N'::bpchar	The image is retrieved from the data column
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
ad_column	iskey	bpchar	1			'N'::bpchar	This column is the key in this table
ad_column	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_process_para	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_printformatitem	ismaxcalc	bpchar	1			'N'::bpchar	Calculate the maximum amount
ad_printformatitem	ismincalc	bpchar	1			'N'::bpchar	Calculate the minimum amount
ad_printtableformat	ismultilineheader	bpchar	1			'N'::bpchar	Print column headers on mutliple lines if necessary.
ad_printformatitem	isnextpage	bpchar	1			'N'::bpchar	The column is printed on the next page
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
ad_printformatitem	isorderby	bpchar	1			'N'::bpchar	Include in sort order
ad_printformatitem	ispagebreak	bpchar	1			'N'::bpchar	Start with new page
ad_printtableformat	ispaintboundarylines	bpchar	1			'N'::bpchar	Paint table boundary lines
ad_printtableformat	ispainthlines	bpchar	1			'N'::bpchar	Paint horizontal lines
ad_printtableformat	ispaintvlines	bpchar	1			'N'::bpchar	Paint vertical lines
ad_column	isparent	bpchar	1			'N'::bpchar	This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
ad_printformatitem	isprintinstanceattributes	bpchar	1			'N'::bpchar	Print each attributes as report column instead of printing the description of attribute set instance
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
ad_field	isquickentry	bpchar	1			'N'::bpchar	Quick Entry
ad_field	isquickform	bpchar	1			'N'::bpchar	Display in Quick Form
ad_process_para	isrange	bpchar	1			'N'::bpchar	The parameter is a range of values
ad_field	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_printformatitem	isrunningtotal	bpchar	1			'N'::bpchar	Create a running total (sum)
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
ad_field	issameline	bpchar	1			'N'::bpchar	Displayed on same line as previous field
ad_column	issecure	bpchar	1			'N'::bpchar	Defines whether content must be treated as secure
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
ad_column	isselectioncolumn	bpchar	1			'N'::bpchar	Is this column used for finding rows in windows
c_dunninglevel	issetcreditstop	bpchar	1			'N'::bpchar	Set the business partner to credit stop
ad_printformatitem	issetnlposition	bpchar	1			'N'::bpchar	Set New Line Position
c_dunninglevel	issetpaymentterm	bpchar	1			'N'::bpchar	Set the payment term of the Business Partner
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_dunninglevel	isshowalldue	bpchar	1			'N'::bpchar	Show/print all due invoices
c_dunninglevel	isshownotdue	bpchar	1			'N'::bpchar	Show/print all invoices which are not due (yet).
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
c_dunninglevel	isstatement	bpchar	1			'N'::bpchar	Dunning Level is a definition of a statement
ad_printformatitem	issummarized	bpchar	1			'N'::bpchar	Calculate the Sum of numeric content or length
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_printformatitem	issuppressnull	bpchar	1			'N'::bpchar	Suppress columns or elements with NULL value
ad_printformatitem	issuppressrepeats	bpchar	1			'N'::bpchar	Suppress repeated elements in column.
ad_language	issystemlanguage	bpchar	1			'N'::bpchar	The screens, etc. are maintained in this Language
ad_column	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_printformatitem_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_printlabelline_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_printformatitem	isvariancecalc	bpchar	1			'N'::bpchar	Calculate Variance
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_labelprinterfunction	isxyposition	bpchar	1			'N'::bpchar	The Function is XY position
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
ad_process	allowmultipleexecution	bpchar	1	√		'P'::bpchar	Allow or disallow executing a process/report multiple times.
c_dunninglevel	name	varchar	60			'x'::character varying	Alphanumeric identifier of the entity
ad_column	isallowlogging	bpchar	1	√		'Y'::bpchar	Determine if a column must be recorded into the change log
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
ad_field	isdisplayedgrid	bpchar	1	√		'Y'::bpchar	Show in Grid
ad_process	showhelp	bpchar	1	√		'Y'::bpchar	Show Help
c_dunninglevel	chargefee	bpchar	1			'Y'::bpchar	Indicates if fees will be charged for overdue invoices
c_dunninglevel	chargeinterest	bpchar	1			'Y'::bpchar	Indicates if interest will be charged on overdue invoices
ad_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_element	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_field	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_labelprinter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_labelprinterfunction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printcolor	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printfont	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printform	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printformatitem	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printformatitem_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printgraph	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printheaderfooter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printlabel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printlabelline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printlabelline_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printpaper	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printtableformat	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_reportview	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_reportview_col	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_reportview_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bankaccountdoc	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_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunninglevel	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
ad_column	isallowcopy	bpchar	1			'Y'::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_printformat	isbreakpageperrecord	bpchar	1			'Y'::bpchar	Page Break after each record
ad_field	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_printformatitem	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_process_para	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
ad_field	isdisplayed	bpchar	1			'Y'::bpchar	Determines, if this field is displayed
ad_printformatitem	isheightoneline	bpchar	1			'Y'::bpchar	If selected, only one line is printed
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
ad_printlabel	islandscape	bpchar	1			'Y'::bpchar	Landscape orientation
ad_printpaper	islandscape	bpchar	1			'Y'::bpchar	Landscape orientation
ad_printformatitem	isnextline	bpchar	1			'Y'::bpchar	Print item on next line
ad_printtableformat	ispaintheaderlines	bpchar	1			'Y'::bpchar	Paint Lines over/under the Header Line
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
ad_printformatitem	isprintbarcodetext	bpchar	1			'Y'::bpchar	Print barcode text at the bottom of barcode
ad_printformatitem	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
ad_printtableformat	isprintfunctionsymbols	bpchar	1			'Y'::bpchar	Print Symbols for Functions (Sum, Average, Count)
ad_printformatitem	isrelativeposition	bpchar	1			'Y'::bpchar	The item is relative positioned (not absolute)
ad_process	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_printformat	isstandardheaderfooter	bpchar	1			'Y'::bpchar	The standard Header and Footer is used
ad_printformat	istablebased	bpchar	1			'Y'::bpchar	Table based List Reporting
ad_column	istoolbarbutton	bpchar	1			'Y'::bpchar	Show the button on the toolbar, the window, or both
ad_column	isupdateable	bpchar	1			'Y'::bpchar	Determines, if the field can be updated
ad_field	columnspan	numeric	10	√		(1)::numeric	Number of column for a box of field
ad_field	numlines	numeric	10	√		(1)::numeric	Number of lines for a field
ad_field	xposition	numeric	10	√		(1)::numeric	Absolute X (horizontal) position in 1/72 of an inch
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
c_dunninglevel	feeamt	numeric	0	√		0	Fee amount in invoice currency
c_dunninglevel	interestpercent	numeric	0	√		0	Percentage interest to charge on overdue invoices
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
ad_printpaper	marginbottom	numeric	10			36	Bottom Space in 1/72 inch
ad_printpaper	marginleft	numeric	10			36	Left Space in 1/72 inch
ad_printpaper	marginright	numeric	10			36	Right Space in 1/72 inch
ad_printpaper	margintop	numeric	10			36	Top Space in 1/72 inch
ad_column	created	timestamp	29,6			now()	Date this record was created
ad_field	created	timestamp	29,6			now()	Date this record was created
ad_labelprinter	created	timestamp	29,6			now()	Date this record was created
ad_labelprinterfunction	created	timestamp	29,6			now()	Date this record was created
ad_language	created	timestamp	29,6			now()	Date this record was created
ad_printcolor	created	timestamp	29,6			now()	Date this record was created
ad_printfont	created	timestamp	29,6			now()	Date this record was created
ad_printform	created	timestamp	29,6			now()	Date this record was created
ad_printformat	created	timestamp	29,6			now()	Date this record was created
ad_printformatitem	created	timestamp	29,6			now()	Date this record was created
ad_printformatitem_trl	created	timestamp	29,6			now()	Date this record was created
ad_printgraph	created	timestamp	29,6			now()	Date this record was created
ad_printlabel	created	timestamp	29,6			now()	Date this record was created
ad_printlabelline	created	timestamp	29,6			now()	Date this record was created
ad_printlabelline_trl	created	timestamp	29,6			now()	Date this record was created
ad_printpaper	created	timestamp	29,6			now()	Date this record was created
ad_printtableformat	created	timestamp	29,6			now()	Date this record was created
ad_process	created	timestamp	29,6			now()	Date this record was created
ad_process_para	created	timestamp	29,6			now()	Date this record was created
ad_reportview	created	timestamp	29,6			now()	Date this record was created
ad_reportview_col	created	timestamp	29,6			now()	Date this record was created
ad_table	created	timestamp	29,6			now()	Date this record was created
c_bankaccountdoc	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_dunninglevel	created	timestamp	29,6			now()	Date this record was created
r_mailtext	created	timestamp	29,6			now()	Date this record was created
ad_column	updated	timestamp	29,6			now()	Date this record was updated
ad_element	updated	timestamp	29,6			now()	Date this record was updated
ad_field	updated	timestamp	29,6			now()	Date this record was updated
ad_labelprinter	updated	timestamp	29,6			now()	Date this record was updated
ad_labelprinterfunction	updated	timestamp	29,6			now()	Date this record was updated
ad_language	updated	timestamp	29,6			now()	Date this record was updated
ad_printcolor	updated	timestamp	29,6			now()	Date this record was updated
ad_printfont	updated	timestamp	29,6			now()	Date this record was updated
ad_printform	updated	timestamp	29,6			now()	Date this record was updated
ad_printformat	updated	timestamp	29,6			now()	Date this record was updated
ad_printformatitem	updated	timestamp	29,6			now()	Date this record was updated
ad_printformatitem_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_printgraph	updated	timestamp	29,6			now()	Date this record was updated
ad_printlabel	updated	timestamp	29,6			now()	Date this record was updated
ad_printlabelline	updated	timestamp	29,6			now()	Date this record was updated
ad_printlabelline_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_printpaper	updated	timestamp	29,6			now()	Date this record was updated
ad_printtableformat	updated	timestamp	29,6			now()	Date this record was updated
ad_process	updated	timestamp	29,6			now()	Date this record was updated
ad_process_para	updated	timestamp	29,6			now()	Date this record was updated
ad_reportview	updated	timestamp	29,6			now()	Date this record was updated
ad_reportview_col	updated	timestamp	29,6			now()	Date this record was updated
ad_table	updated	timestamp	29,6			now()	Date this record was updated
c_bankaccountdoc	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_dunninglevel	updated	timestamp	29,6			now()	Date this record was updated
r_mailtext	updated	timestamp	29,6			now()	Date this record was updated
ad_printform	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
ad_field	ad_column_id	numeric	10	√		null	Column in the table
ad_printformatitem	ad_column_id	numeric	10	√		null	Column in the table
ad_printlabelline	ad_column_id	numeric	10	√		null	Column in the table
ad_reportview_col	ad_column_id	numeric	10	√		null	Column in the table
ad_column	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_process_para	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_field	ad_fieldgroup_id	numeric	10	√		null	Logical grouping of fields
ad_process	ad_form_id	numeric	10	√		null	Special Form
ad_printtableformat	ad_image_id	numeric	10	√		null	Image or Icon
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_printformatitem	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
ad_printformatitem	ad_printfont_id	numeric	10	√		null	Maintain Print Font
ad_process	ad_printformat_id	numeric	10	√		null	Data Print Format
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_printformatitem	ad_printformatchild_id	numeric	10	√		null	Print format that is included here.
ad_printformatitem	ad_printgraph_id	numeric	10	√		null	Graph included in Reports
ad_printformat	ad_printtableformat_id	numeric	10	√		null	Table Format in Reports
ad_column	ad_process_id	numeric	10	√		null	Process or Report
ad_field	ad_reference_id	numeric	10	√		null	System Reference and Validation
ad_column	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_field	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_process_para	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_printformat	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_process	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_column	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_field	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_process_para	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
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_process	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_printformatitem	arcdiameter	numeric	10	√		null	Arc Diameter for rounded Rectangles
ad_printformat	args	varchar	510	√		null	Args
ad_printformatitem	barcodetype	bpchar	3	√		null	Type of barcode
ad_printformatitem	belowcolumn	numeric	10	√		null	Print this column below the column index entered
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_dunninglevel	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
ad_column	callout	varchar	255	√		null	Fully qualified class names and method - separated by semicolons
c_bankaccountdoc	check_printformat_id	numeric	10	√		null	Print Format for printing Checks
ad_printformat	classname	varchar	240	√		null	Java Classname
ad_process	classname	varchar	255	√		null	Java Classname
ad_column	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_field	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
ad_language	countrycode	bpchar	2	√		null	Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_printformat	createcopy	bpchar	1	√		null	Create Copy
ad_printgraph	data1_printformatitem_id	numeric	10	√		null	Data Column for Line Charts
ad_printgraph	data2_printformatitem_id	numeric	10	√		null	Data Column for Line Charts
ad_printgraph	data3_printformatitem_id	numeric	10	√		null	Data Column for Line Charts
ad_printgraph	data4_printformatitem_id	numeric	10	√		null	Data Column for Line Charts
ad_language	datepattern	varchar	20	√		null	Java Date Pattern
ad_column	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_field	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_process_para	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_process_para	defaultvalue2	varchar	2000	√		null	Default value hierarchy, separated by ;
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
ad_column	description	varchar	255	√		null	Optional short description of the record
ad_element	description	varchar	255	√		null	Optional short description of the record
ad_field	description	varchar	255	√		null	Optional short description of the record
ad_labelprinter	description	varchar	255	√		null	Optional short description of the record
ad_labelprinterfunction	description	varchar	255	√		null	Optional short description of the record
ad_printform	description	varchar	255	√		null	Optional short description of the record
ad_printformat	description	varchar	255	√		null	Optional short description of the record
ad_printgraph	description	varchar	255	√		null	Optional short description of the record
ad_printlabel	description	varchar	255	√		null	Optional short description of the record
ad_printpaper	description	varchar	255	√		null	Optional short description of the record
ad_printtableformat	description	varchar	255	√		null	Optional short description of the record
ad_process	description	varchar	255	√		null	Optional short description of the record
ad_process_para	description	varchar	255	√		null	Optional short description of the record
ad_reportview	description	varchar	255	√		null	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
c_bankaccountdoc	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_dunninglevel	description	varchar	255	√		null	Optional short description of the record
ad_printpaper	dimensionunits	bpchar	1	√		null	Units of Dimension
ad_field	displaylength	numeric	10	√		null	Length of the display in characters
ad_field	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_process_para	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_printform	distrib_order_mailtext_id	numeric	10	√		null	Email text used for sending Distribution Order
ad_printform	distrib_order_printformat_id	numeric	10	√		null	Print Format for printing Distribution Order
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
c_dunninglevel	dunning_printformat_id	numeric	10	√		null	Print Format for printing Dunning Letters
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
ad_column	fieldlength	numeric	10	√		null	Length of the column in the database
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
ad_printtableformat	footercenter	varchar	255	√		null	Content of the center portion of the footer.
ad_printtableformat	footerleft	varchar	255	√		null	Content of the left portion of the footer.
ad_printtableformat	footerright	varchar	255	√		null	Content of the right portion of the footer.
ad_column	formatpattern	varchar	22	√		null	The pattern used to format a number or date.
ad_printformatitem	formatpattern	varchar	60	√		null	The pattern used to format a number or date.
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
ad_printtableformat	funct_printfont_id	numeric	10	√		null	Function row Font
ad_printtableformat	functbg_printcolor_id	numeric	10	√		null	Function Background Color
ad_printtableformat	functfg_printcolor_id	numeric	10	√		null	Function Foreground Color
ad_labelprinterfunction	functionprefix	varchar	40	√		null	Data sent before the function
ad_labelprinterfunction	functionsuffix	varchar	40	√		null	Data sent after the function
ad_printtableformat	hdr_printfont_id	numeric	10	√		null	Header row Font
ad_printtableformat	hdrline_printcolor_id	numeric	10	√		null	Table header row line color
ad_printtableformat	hdrstroke	numeric	0	√		null	Width of the Header Line Stroke
ad_printtableformat	hdrstroketype	bpchar	1	√		null	Type of the Header Line Stroke
ad_printtableformat	hdrtextbg_printcolor_id	numeric	10	√		null	Background color of header row
ad_printtableformat	hdrtextfg_printcolor_id	numeric	10	√		null	Foreground color if the table header row
ad_printtableformat	headercenter	varchar	255	√		null	Content of the center portion of the header.
ad_printtableformat	headerleft	varchar	255	√		null	Content of the left portion of the header.
ad_printtableformat	headerright	varchar	255	√		null	Content of the right portion of the header.
ad_column	help	varchar	2000	√		null	Comment or Hint
ad_element	help	varchar	2000	√		null	Comment or Hint
ad_field	help	varchar	2000	√		null	Comment or Hint
ad_process	help	varchar	2000	√		null	Comment or Hint
ad_process_para	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
ad_printformatitem	imageurl	varchar	120	√		null	URL of image
ad_printtableformat	imageurl	varchar	120	√		null	URL of image
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
ad_field	included_tab_id	numeric	10	√		null	Included Tab in this Tab (Master Detail)
ad_column	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
ad_field	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
ad_printform	invoice_mailtext_id	numeric	10	√		null	Email text used for sending invoices
ad_printform	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
ad_language	isdecimalpoint	bpchar	1	√		null	The number notation has a decimal point (no decimal comma)
ad_field	ismandatory	bpchar	1	√		null	Data entry is required in this column
ad_process	isserverprocess	bpchar	1	√		null	Run this Process on Server only
ad_field	istoolbarbutton	bpchar	1	√		null	Show the button on the toolbar, the window, or both
ad_printformat	jasperprocess_id	numeric	10	√		null	The Jasper Process used by the printengine if any process defined
ad_process	jasperreport	varchar	255	√		null	Jasper Report
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_printtableformat	line_printcolor_id	numeric	10	√		null	Table line color
ad_printtableformat	linestroke	numeric	0	√		null	Width of the Line Stroke
ad_printtableformat	linestroketype	bpchar	1	√		null	Type of the Line Stroke
ad_printformatitem	linewidth	numeric	10	√		null	Width of the lines
ad_table	loadseq	numeric	10	√		null	Sequence
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
r_mailtext	mailheader	varchar	2000	√		null	Mail Header (Subject)
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
ad_column	mandatorylogic	varchar	2000	√		null	Mandatory Logic
ad_printform	manuf_order_mailtext_id	numeric	10	√		null	Email text used for sending Manufacturing Order
ad_printform	manuf_order_printformat_id	numeric	10	√		null	Print Format for printing Manufacturing Order
c_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_dunninglevel	note	varchar	2000	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
ad_field	obscuretype	bpchar	3	√		null	Type of obscuring the data (limiting the display)
ad_printform	order_mailtext_id	numeric	10	√		null	Email text used for sending order acknowledgements or quotations
ad_printform	order_printformat_id	numeric	10	√		null	Print Format for Orders, Quotes, Offers
ad_reportview	orderbyclause	varchar	2000	√		null	Fully qualified ORDER BY clause
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
ad_element	po_description	varchar	255	√		null	Description in PO Screens
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
ad_element	po_help	varchar	2000	√		null	Help for PO Screens
ad_element	po_name	varchar	60	√		null	Name on PO Screens
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
ad_element	po_printname	varchar	60	√		null	Print name on PO Screens/Reports
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
ad_printformat	printername	varchar	40	√		null	Name of the Printer
ad_printlabel	printername	varchar	40	√		null	Name of the Printer
ad_printformatitem	printname	varchar	2000	√		null	The label text to be printed on a document or correspondence.
ad_printformatitem_trl	printname	varchar	2000	√		null	The label text to be printed on a document or correspondence.
ad_printlabelline	printname	varchar	60	√		null	The label text to be printed on a document or correspondence.
ad_printlabelline_trl	printname	varchar	60	√		null	The label text to be printed on a document or correspondence.
ad_printformatitem	printnamesuffix	varchar	60	√		null	The label text to be printed on a document or correspondence after the field
ad_printformatitem_trl	printnamesuffix	varchar	60	√		null	The label text to be printed on a document or correspondence after the field
ad_process	procedurename	varchar	60	√		null	Name of the Database Procedure
ad_language	processing	bpchar	1	√		null	Process Now
ad_printpaper	processing	bpchar	1	√		null	Process Now
ad_printform	project_mailtext_id	numeric	10	√		null	Standard text for Project EMails
ad_printform	project_printformat_id	numeric	10	√		null	Standard Project Print Format
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
ad_column	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
ad_process_para	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
ad_printform	remittance_mailtext_id	numeric	10	√		null	Email text used for sending payment remittances
ad_printform	remittance_printformat_id	numeric	10	√		null	Print Format for separate Remittances
ad_printformatitem	runningtotallines	numeric	10	√		null	Create Running Total Lines (page break) every x lines
c_bpartner	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_column	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_field	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_printformatitem	shapetype	bpchar	1	√		null	Type of the shape to be painted
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
ad_printform	shipment_mailtext_id	numeric	10	√		null	Email text used for sending delivery notes
ad_printform	shipment_printformat_id	numeric	10	√		null	Print Format for Shipments, Receipts, Pick Lists
ad_printpaper	sizex	numeric	0	√		null	X (horizontal) dimension size
ad_printpaper	sizey	numeric	0	√		null	Y (vertical) dimension size
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
ad_field	sortno	numeric	10	√		null	Determines in what order the records are displayed
ad_process	statistic_count	numeric	10	√		null	Internal statistics how often the entity was used
ad_process	statistic_seconds	numeric	0	√		null	Internal statistics how many seconds a process took
c_bpartner	taxid	varchar	20	√		null	Tax Identification
ad_language	timepattern	varchar	20	√		null	Java Time Pattern
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
ad_column	valuemax	varchar	20	√		null	Maximum Value for a field
ad_process_para	valuemax	varchar	20	√		null	Maximum Value for a field
ad_column	valuemin	varchar	20	√		null	Minimum Value for a field
ad_process_para	valuemin	varchar	20	√		null	Minimum Value for a field
ad_column	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_process_para	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_reportview	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
ad_process	workflowvalue	varchar	40	√		null	Key of the Workflow to start
ad_labelprinterfunction	xyseparator	varchar	20	√		null	The separator between the X and Y function.
ad_process	accesslevel	bpchar	1				Access Level required
ad_table	accesslevel	bpchar	1				Access Level required
ad_column	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_element	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_field	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_labelprinter	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_labelprinterfunction	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_language	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printcolor	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printfont	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printformat	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printformatitem	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printformatitem_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printgraph	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printheaderfooter	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printlabel	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printlabelline	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printlabelline_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printpaper	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printtableformat	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process_para	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_reportview	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_reportview_col	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bankaccountdoc	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunninglevel	ad_client_id	numeric	10				Client/Tenant for this installation.
r_mailtext	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_column	ad_column_id	numeric	10				Column in the table
ad_reportview_column	ad_column_id	numeric	10				Column in the table
ad_element	ad_element_id	numeric	10				System Element enables the central maintenance of column description and help.
ad_field	ad_field_id	numeric	10				Field on a database table
ad_labelprinter	ad_labelprinter_id	numeric	10				Label Printer Definition
ad_labelprinterfunction	ad_labelprinter_id	numeric	10				Label Printer Definition
ad_printlabel	ad_labelprinter_id	numeric	10				Label Printer Definition
ad_labelprinterfunction	ad_labelprinterfunction_id	numeric	10				Function of Label Printer
ad_printlabelline	ad_labelprinterfunction_id	numeric	10				Function of Label Printer
ad_language	ad_language	varchar	6				Language for this entity
ad_printformatitem_trl	ad_language	varchar	6				Language for this entity
ad_printlabelline_trl	ad_language	varchar	6				Language for this entity
ad_language	ad_language_id	numeric	10				Language ID
ad_column	ad_org_id	numeric	10				Organizational entity within client
ad_element	ad_org_id	numeric	10				Organizational entity within client
ad_field	ad_org_id	numeric	10				Organizational entity within client
ad_labelprinter	ad_org_id	numeric	10				Organizational entity within client
ad_labelprinterfunction	ad_org_id	numeric	10				Organizational entity within client
ad_language	ad_org_id	numeric	10				Organizational entity within client
ad_printcolor	ad_org_id	numeric	10				Organizational entity within client
ad_printfont	ad_org_id	numeric	10				Organizational entity within client
ad_printform	ad_org_id	numeric	10				Organizational entity within client
ad_printformat	ad_org_id	numeric	10				Organizational entity within client
ad_printformatitem	ad_org_id	numeric	10				Organizational entity within client
ad_printformatitem_trl	ad_org_id	numeric	10				Organizational entity within client
ad_printgraph	ad_org_id	numeric	10				Organizational entity within client
ad_printheaderfooter	ad_org_id	numeric	10				Organizational entity within client
ad_printlabel	ad_org_id	numeric	10				Organizational entity within client
ad_printlabelline	ad_org_id	numeric	10				Organizational entity within client
ad_printlabelline_trl	ad_org_id	numeric	10				Organizational entity within client
ad_printpaper	ad_org_id	numeric	10				Organizational entity within client
ad_printtableformat	ad_org_id	numeric	10				Organizational entity within client
ad_process	ad_org_id	numeric	10				Organizational entity within client
ad_process_para	ad_org_id	numeric	10				Organizational entity within client
ad_reportview	ad_org_id	numeric	10				Organizational entity within client
ad_reportview_col	ad_org_id	numeric	10				Organizational entity within client
ad_reportview_column	ad_org_id	numeric	10				Organizational entity within client
ad_table	ad_org_id	numeric	10				Organizational entity within client
c_bankaccountdoc	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_dunninglevel	ad_org_id	numeric	10				Organizational entity within client
r_mailtext	ad_org_id	numeric	10				Organizational entity within client
ad_printcolor	ad_printcolor_id	numeric	10				Color used for printing and display
ad_printformat	ad_printcolor_id	numeric	10				Color used for printing and display
ad_printfont	ad_printfont_id	numeric	10				Maintain Print Font
ad_printformat	ad_printfont_id	numeric	10				Maintain Print Font
ad_printform	ad_printform_id	numeric	10				Form
ad_printformat	ad_printformat_id	numeric	10				Data Print Format
ad_printformatitem	ad_printformat_id	numeric	10				Data Print Format
ad_printgraph	ad_printformat_id	numeric	10				Data Print Format
ad_printformatitem	ad_printformatitem_id	numeric	10				Item/Column in the Print format
ad_printformatitem_trl	ad_printformatitem_id	numeric	10				Item/Column in the Print format
ad_printgraph	ad_printgraph_id	numeric	10				Graph included in Reports
ad_printheaderfooter	ad_printheaderfooter_id	numeric	10				Print Header/Footer
ad_printlabel	ad_printlabel_id	numeric	10				Label Format to print
ad_printlabelline	ad_printlabel_id	numeric	10				Label Format to print
ad_printlabelline	ad_printlabelline_id	numeric	10				Print Label Line Format
ad_printlabelline_trl	ad_printlabelline_id	numeric	10				Print Label Line Format
ad_printformat	ad_printpaper_id	numeric	10				Printer paper definition
ad_printpaper	ad_printpaper_id	numeric	10				Printer paper definition
ad_printtableformat	ad_printtableformat_id	numeric	10				Table Format in Reports
ad_process	ad_process_id	numeric	10				Process or Report
ad_process_para	ad_process_id	numeric	10				Process or Report
ad_process_para	ad_process_para_id	numeric	10				Process Parameter
ad_column	ad_reference_id	numeric	10				System Reference and Validation
ad_process_para	ad_reference_id	numeric	10				System Reference and Validation
ad_reportview_col	ad_reportview_col_id	numeric	10				Report view Column
ad_reportview	ad_reportview_id	numeric	10				View used to generate this report
ad_reportview_col	ad_reportview_id	numeric	10				View used to generate this report
ad_reportview_column	ad_reportview_id	numeric	10				View used to generate this report
ad_field	ad_tab_id	numeric	10				Tab within a Window
ad_column	ad_table_id	numeric	10				Database Table information
ad_printformat	ad_table_id	numeric	10				Database Table information
ad_printlabel	ad_table_id	numeric	10				Database Table information
ad_reportview	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
c_bankaccountdoc	c_bankaccount_id	numeric	10				Account at the Bank
c_bankaccountdoc	c_bankaccountdoc_id	numeric	10				Checks, Transfers, etc.
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_doctype	c_doctype_id	numeric	10				Document type or rules
c_dunninglevel	c_dunning_id	numeric	10				Dunning Rules for overdue invoices
c_dunninglevel	c_dunninglevel_id	numeric	10				Dunning Level
ad_printcolor	code	varchar	2000				Validation Code
ad_printfont	code	varchar	2000				Validation Code
ad_printpaper	code	varchar	2000				Validation Code
ad_column	columnname	varchar	30				Name of the column in the database
ad_element	columnname	varchar	30				Name of the column in the database
ad_process_para	columnname	varchar	30				Name of the column in the database
ad_reportview_column	created	timestamp	29,6				Date this record was created
ad_column	createdby	numeric	10				User who created this records
ad_element	createdby	numeric	10				User who created this records
ad_field	createdby	numeric	10				User who created this records
ad_labelprinter	createdby	numeric	10				User who created this records
ad_labelprinterfunction	createdby	numeric	10				User who created this records
ad_language	createdby	numeric	10				User who created this records
ad_printcolor	createdby	numeric	10				User who created this records
ad_printfont	createdby	numeric	10				User who created this records
ad_printform	createdby	numeric	10				User who created this records
ad_printformat	createdby	numeric	10				User who created this records
ad_printformatitem	createdby	numeric	10				User who created this records
ad_printformatitem_trl	createdby	numeric	10				User who created this records
ad_printgraph	createdby	numeric	10				User who created this records
ad_printheaderfooter	createdby	numeric	10				User who created this records
ad_printlabel	createdby	numeric	10				User who created this records
ad_printlabelline	createdby	numeric	10				User who created this records
ad_printlabelline_trl	createdby	numeric	10				User who created this records
ad_printpaper	createdby	numeric	10				User who created this records
ad_printtableformat	createdby	numeric	10				User who created this records
ad_process	createdby	numeric	10				User who created this records
ad_process_para	createdby	numeric	10				User who created this records
ad_reportview	createdby	numeric	10				User who created this records
ad_reportview_col	createdby	numeric	10				User who created this records
ad_reportview_column	createdby	numeric	10				User who created this records
ad_table	createdby	numeric	10				User who created this records
c_bankaccountdoc	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_dunninglevel	createdby	numeric	10				User who created this records
r_mailtext	createdby	numeric	10				User who created this records
c_bankaccountdoc	currentnext	numeric	10				The next number to be used
ad_printgraph	data_printformatitem_id	numeric	10				Data Column for Pie and Line Charts
c_dunninglevel	daysafterdue	numeric	10				Days after due date to dun (if negative days until due)
c_dunninglevel	daysbetweendunning	numeric	10				Days between sending dunning notices
ad_printgraph	description_printformatitem_id	numeric	10				Description Column for Pie/Line/Bar Charts
c_doctype	docbasetype	bpchar	3				Logical type of document
c_doctype	documentcopies	numeric	10				Number of copies to be printed
ad_printformatitem	fieldalignmenttype	bpchar	1				Field Text Alignment
ad_process_para	fieldlength	numeric	10				Length of the column in the database
ad_printformat	footermargin	numeric	10				Margin of the Footer in 1/72 of an inch
ad_reportview_col	functioncolumn	varchar	60				Overwrite Column with Function
c_doctype	gl_category_id	numeric	10				General Ledger Category
ad_printgraph	graphtype	bpchar	1				Type of graph to be painted
ad_printformat	headermargin	numeric	10				Margin of the Header in 1/72 of an inch
ad_printlabelline	labelformattype	bpchar	1				Label Format Type
ad_printlabel	labelheight	numeric	10				Height of the label
ad_printlabel	labelwidth	numeric	10				Width of the Label
ad_printformatitem	linealignmenttype	bpchar	1				Line Alignment
r_mailtext	mailtext	text	2147483647				Text used for Mail message
ad_printformatitem	maxheight	numeric	10				Maximum Height in 1/72 if an inch - 0 = no restriction
ad_printformatitem	maxwidth	numeric	10				Maximum Width in 1/72 if an inch - 0 = no restriction
ad_column	name	varchar	60				Alphanumeric identifier of the entity
ad_element	name	varchar	60				Alphanumeric identifier of the entity
ad_field	name	varchar	60				Alphanumeric identifier of the entity
ad_labelprinter	name	varchar	60				Alphanumeric identifier of the entity
ad_labelprinterfunction	name	varchar	60				Alphanumeric identifier of the entity
ad_language	name	varchar	60				Alphanumeric identifier of the entity
ad_printcolor	name	varchar	60				Alphanumeric identifier of the entity
ad_printfont	name	varchar	60				Alphanumeric identifier of the entity
ad_printform	name	varchar	60				Alphanumeric identifier of the entity
ad_printformat	name	varchar	60				Alphanumeric identifier of the entity
ad_printformatitem	name	varchar	60				Alphanumeric identifier of the entity
ad_printgraph	name	varchar	60				Alphanumeric identifier of the entity
ad_printheaderfooter	name	varchar	60				Alphanumeric identifier of the entity
ad_printlabel	name	varchar	60				Alphanumeric identifier of the entity
ad_printlabelline	name	varchar	60				Alphanumeric identifier of the entity
ad_printpaper	name	varchar	60				Alphanumeric identifier of the entity
ad_printtableformat	name	varchar	60				Alphanumeric identifier of the entity
ad_process	name	varchar	60				Alphanumeric identifier of the entity
ad_process_para	name	varchar	60				Alphanumeric identifier of the entity
ad_reportview	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
c_bankaccountdoc	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
r_mailtext	name	varchar	60				Alphanumeric identifier of the entity
c_bankaccountdoc	paymentrule	bpchar	1				How you pay the invoice
ad_printformatitem	printareatype	bpchar	1				Print Area
ad_printformatitem	printformattype	bpchar	1				Print Format Type
ad_element	printname	varchar	60				The label text to be printed on a document or correspondence.
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
c_dunninglevel	printname	varchar	60				The label text to be printed on a document or correspondence.
r_mailtext	r_mailtext_id	numeric	10				Text templates for mailings
ad_printformatitem	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_printlabelline	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_process_para	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_printformatitem	sortno	numeric	10				Determines in what order the records are displayed
ad_table	tablename	varchar	40				Name of the table in the database
ad_reportview_column	updated	timestamp	29,6				Date this record was updated
ad_column	updatedby	numeric	10				User who updated this records
ad_element	updatedby	numeric	10				User who updated this records
ad_field	updatedby	numeric	10				User who updated this records
ad_labelprinter	updatedby	numeric	10				User who updated this records
ad_labelprinterfunction	updatedby	numeric	10				User who updated this records
ad_language	updatedby	numeric	10				User who updated this records
ad_printcolor	updatedby	numeric	10				User who updated this records
ad_printfont	updatedby	numeric	10				User who updated this records
ad_printform	updatedby	numeric	10				User who updated this records
ad_printformat	updatedby	numeric	10				User who updated this records
ad_printformatitem	updatedby	numeric	10				User who updated this records
ad_printformatitem_trl	updatedby	numeric	10				User who updated this records
ad_printgraph	updatedby	numeric	10				User who updated this records
ad_printheaderfooter	updatedby	numeric	10				User who updated this records
ad_printlabel	updatedby	numeric	10				User who updated this records
ad_printlabelline	updatedby	numeric	10				User who updated this records
ad_printlabelline_trl	updatedby	numeric	10				User who updated this records
ad_printpaper	updatedby	numeric	10				User who updated this records
ad_printtableformat	updatedby	numeric	10				User who updated this records
ad_process	updatedby	numeric	10				User who updated this records
ad_process_para	updatedby	numeric	10				User who updated this records
ad_reportview	updatedby	numeric	10				User who updated this records
ad_reportview_col	updatedby	numeric	10				User who updated this records
ad_reportview_column	updatedby	numeric	10				User who updated this records
ad_table	updatedby	numeric	10				User who updated this records
c_bankaccountdoc	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_dunninglevel	updatedby	numeric	10				User who updated this records
r_mailtext	updatedby	numeric	10				User who updated this records
ad_process	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
ad_column	version	numeric	0				Version of the table definition
ad_printformatitem	xposition	numeric	10				Absolute X (horizontal) position in 1/72 of an inch
ad_printlabelline	xposition	numeric	10				Absolute X (horizontal) position in 1/72 of an inch
ad_printformatitem	xspace	numeric	10				Relative X (horizontal) space in 1/72 of an inch
ad_printformatitem	yposition	numeric	10				Absolute Y (vertical) position in 1/72 of an inch
ad_printlabelline	yposition	numeric	10				Absolute Y (vertical) position in 1/72 of an inch
ad_printformatitem	yspace	numeric	10				Relative Y (vertical) space in 1/72 of an inch
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
ad_process	copyfromprocess	bpchar	1	√		NULL::bpchar	Copy settings from one report and process to another.
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_process	executiontype	bpchar	1	√		NULL::bpchar	Execution Type defines whether the report/process will always run in background or foreground.
c_dunninglevel	invoicecollectiontype	bpchar	1	√		NULL::bpchar	Invoice Collection Status
ad_field	isallowcopy	bpchar	1	√		NULL::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_field	isalwaysupdateable	bpchar	1	√		NULL::bpchar	The column is always updateable, even if the record is not active or processed
ad_field	isselectioncolumn	bpchar	1	√		NULL::bpchar	Is this column used for finding rows in windows
ad_field	isupdateable	bpchar	1	√		NULL::bpchar	Determines, if the field can be updated
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_column	ad_column_uu	varchar	36	√		NULL::character varying	AD_Column_UU
ad_element	ad_element_uu	varchar	36	√		NULL::character varying	AD_Element_UU
ad_field	ad_field_uu	varchar	36	√		NULL::character varying	AD_Field_UU
ad_labelprinter	ad_labelprinter_uu	varchar	36	√		NULL::character varying	AD_LabelPrinter_UU
ad_labelprinterfunction	ad_labelprinterfunction_uu	varchar	36	√		NULL::character varying	AD_LabelPrinterFunction_UU
ad_language	ad_language_uu	varchar	36	√		NULL::character varying	AD_Language_UU
ad_printcolor	ad_printcolor_uu	varchar	36	√		NULL::character varying	AD_PrintColor_UU
ad_printfont	ad_printfont_uu	varchar	36	√		NULL::character varying	AD_PrintFont_UU
ad_printform	ad_printform_uu	varchar	36	√		NULL::character varying	AD_PrintForm_UU
ad_printformat	ad_printformat_uu	varchar	36	√		NULL::character varying	AD_PrintFormat_UU
ad_printformatitem_trl	ad_printformatitem_trl_uu	varchar	36	√		NULL::character varying	AD_PrintFormatItem_Trl_UU
ad_printformatitem	ad_printformatitem_uu	varchar	36	√		NULL::character varying	AD_PrintFormatItem_UU
ad_printgraph	ad_printgraph_uu	varchar	36	√		NULL::character varying	AD_PrintGraph_UU
ad_printheaderfooter	ad_printheaderfooter_uu	varchar	36	√		NULL::character varying	AD_PrintHeaderFooter_UU
ad_printlabel	ad_printlabel_uu	varchar	36	√		NULL::character varying	AD_PrintLabel_UU
ad_printlabelline_trl	ad_printlabelline_trl_uu	varchar	36	√		NULL::character varying	AD_PrintLabelLine_Trl_UU
ad_printlabelline	ad_printlabelline_uu	varchar	36	√		NULL::character varying	AD_PrintLabelLine_UU
ad_printpaper	ad_printpaper_uu	varchar	36	√		NULL::character varying	AD_PrintPaper_UU
ad_printtableformat	ad_printtableformat_uu	varchar	36	√		NULL::character varying	AD_PrintTableFormat_UU
ad_process_para	ad_process_para_uu	varchar	36	√		NULL::character varying	AD_Process_Para_UU
ad_process	ad_process_uu	varchar	36	√		NULL::character varying	AD_Process_UU
ad_reportview_col	ad_reportview_col_uu	varchar	36	√		NULL::character varying	AD_ReportView_Col_UU
ad_reportview_column	ad_reportview_column_uu	varchar	36	√		NULL::character varying	AD_ReportView_Column_UU
ad_reportview	ad_reportview_uu	varchar	36	√		NULL::character varying	AD_ReportView_UU
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
c_bankaccountdoc	c_bankaccountdoc_uu	varchar	36	√		NULL::character varying	C_BankAccountDoc_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_dunninglevel	c_dunninglevel_uu	varchar	36	√		NULL::character varying	C_DunningLevel_UU
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
ad_printformatitem	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
ad_column	fkconstraintname	varchar	30	√		NULL::character varying	Constraint Name
ad_field	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_process_para	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_column	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_element	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_field	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para	placeholder2	varchar	255	√		NULL::character varying	Placeholder2
ad_process_para	query	varchar	2000	√		NULL::character varying	SQL
r_mailtext	r_mailtext_uu	varchar	36	√		NULL::character varying	R_MailText_UU
ad_field	readonlylogic	varchar	2000	√		NULL::character varying	Logic to determine if field is read only (applies only when field is read-write)
ad_printformatitem	script	varchar	2000	√		NULL::character varying	Dynamic Java Language Script to calculate result
ad_field	vformat	varchar	255	√		NULL::character varying	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_printformatitem_trl	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
ad_language	printname	varchar	60			NULL::character varying	The label text to be printed on a document or correspondence.
ad_printheaderfooter	sourceclassname	varchar	255			NULL::character varying	Source Class Name
ad_column	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_reportview_column	ad_client_id	numeric	10	√		NULL::numeric	Client/Tenant for this installation.
ad_process	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_process_para	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_field	ad_fieldstyle_id	numeric	10	√		NULL::numeric	Field CSS Style
ad_field	ad_labelstyle_id	numeric	10	√		NULL::numeric	Label CSS Style
ad_printformat	ad_printheaderfooter_id	numeric	10	√		NULL::numeric	Print Header/Footer
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
ad_column	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_field	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_printformat	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
ad_column	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
ad_field	seqnogrid	numeric	10	√		NULL::numeric	Grid Sequence No
ad_column	seqnoselection	numeric	10	√		NULL::numeric	Selection Column Sequence
ad_element	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_printheaderfooter	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_printheaderfooter	updated	timestamp	29,6			statement_timestamp()	Date this record was updated