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

Table	Column	Type	Size	Nulls	Auto	Default
a_asset_group_trl	a_asset_group_id	numeric	10				Group of Assets
a_asset_group_trl	a_asset_group_trl_uu	varchar	36	√		NULL::character varying	A_Asset_Group_Trl_UU
ad_broadcastmessage_trl	ad_broadcastmessage_id	numeric	10				Broadcast Message
ad_broadcastmessage_trl	ad_broadcastmessage_trl_uu	varchar	36	√		NULL::character varying	AD_BroadcastMessage_Trl_UU
ad_chart_trl	ad_chart_id	numeric	10				Chart
ad_chart_trl	ad_chart_trl_uu	varchar	36	√		NULL::character varying	AD_Chart_Trl_UU
a_asset_group_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_broadcastmessage_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_chart_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_color_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_column_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ctxhelpmsg_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_desktop_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_element_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_field_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_fieldgroup_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_form_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_infocolumn_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_infowindow_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_language	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_menu_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_message_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printcolor_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printformat_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_printformatitem_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process_para_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ref_list_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_reference_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tab_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_task_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_wf_node_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_window_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_workflow_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_campaign_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_charge_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_country_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_countrygroup_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_currency_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_dunninglevel_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_elementvalue_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_greeting_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_region_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_salesregion_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_salesstage_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_tax_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_taxcategory_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
c_uom_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_category_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist_version_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_dashboardcontent_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_documentstatus_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportcolumn_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
pa_reportline_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
r_mailtext_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
w_mailmsg_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
w_store_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_color_trl	ad_color_id	numeric	10				Color for backgrounds or indicators
ad_color_trl	ad_color_trl_uu	varchar	36	√		NULL::character varying	AD_Color_Trl_UU
ad_column_trl	ad_column_id	numeric	10				Column in the table
ad_column_trl	ad_column_trl_uu	varchar	36	√		null	AD_Column_Trl_UU
ad_ctxhelpmsg_trl	ad_ctxhelpmsg_id	numeric	10				Context Help Message
ad_ctxhelpmsg_trl	ad_ctxhelpmsg_trl_uu	varchar	36	√		NULL::character varying	AD_CtxHelpMsg_Trl_UU
ad_desktop_trl	ad_desktop_id	numeric	10				Collection of Workbenches
ad_desktop_trl	ad_desktop_trl_uu	varchar	36	√		NULL::character varying	AD_Desktop_Trl_UU
ad_element_trl	ad_element_id	numeric	10				System Element enables the central maintenance of column description and help.
ad_element_trl	ad_element_trl_uu	varchar	36	√		NULL::character varying	AD_Element_Trl_UU
ad_field_trl	ad_field_id	numeric	10				Field on a database table
ad_field_trl	ad_field_trl_uu	varchar	36	√		NULL::character varying	AD_Field_Trl_UU
ad_fieldgroup_trl	ad_fieldgroup_id	numeric	10				Logical grouping of fields
ad_fieldgroup_trl	ad_fieldgroup_trl_uu	varchar	36	√		NULL::character varying	AD_FieldGroup_Trl_UU
ad_form_trl	ad_form_id	numeric	10				Special Form
ad_form_trl	ad_form_trl_uu	varchar	36	√		NULL::character varying	AD_Form_Trl_UU
ad_infocolumn_trl	ad_infocolumn_id	numeric	10				Info Window Column
ad_infocolumn_trl	ad_infocolumn_trl_uu	varchar	36	√		NULL::character varying	AD_InfoColumn_Trl_UU
ad_infowindow_trl	ad_infowindow_id	numeric	10				Info and search/select Window
ad_infowindow_trl	ad_infowindow_trl_uu	varchar	36	√		NULL::character varying	AD_InfoWindow_Trl_UU
a_asset_group_trl	ad_language	varchar	6				Language for this entity
ad_broadcastmessage_trl	ad_language	varchar	6				Language for this entity
ad_chart_trl	ad_language	varchar	6				Language for this entity
ad_color_trl	ad_language	varchar	6				Language for this entity
ad_column_trl	ad_language	varchar	6				Language for this entity
ad_ctxhelpmsg_trl	ad_language	varchar	6				Language for this entity
ad_desktop_trl	ad_language	varchar	6				Language for this entity
ad_element_trl	ad_language	varchar	6				Language for this entity
ad_field_trl	ad_language	varchar	6				Language for this entity
ad_fieldgroup_trl	ad_language	varchar	6				Language for this entity
ad_form_trl	ad_language	varchar	6				Language for this entity
ad_infocolumn_trl	ad_language	varchar	6				Language for this entity
ad_infowindow_trl	ad_language	varchar	6				Language for this entity
ad_language	ad_language	varchar	6				Language for this entity
ad_menu_trl	ad_language	varchar	6				Language for this entity
ad_message_trl	ad_language	varchar	6				Language for this entity
ad_printcolor_trl	ad_language	varchar	6				Language for this entity
ad_printformat_trl	ad_language	varchar	6				Language for this entity
ad_printformatitem_trl	ad_language	varchar	6				Language for this entity
ad_process_para_trl	ad_language	varchar	6				Language for this entity
ad_process_trl	ad_language	varchar	6				Language for this entity
ad_ref_list_trl	ad_language	varchar	6				Language for this entity
ad_reference_trl	ad_language	varchar	6				Language for this entity
ad_tab_trl	ad_language	varchar	6				Language for this entity
ad_table_trl	ad_language	varchar	6				Language for this entity
ad_task_trl	ad_language	varchar	6				Language for this entity
ad_wf_node_trl	ad_language	varchar	6				Language for this entity
ad_window_trl	ad_language	varchar	6				Language for this entity
ad_workflow_trl	ad_language	varchar	6				Language for this entity
c_activity_trl	ad_language	varchar	6				Language for this entity
c_campaign_trl	ad_language	varchar	6				Language for this entity
c_charge_trl	ad_language	varchar	6				Language for this entity
c_country_trl	ad_language	varchar	6				Language for this entity
c_countrygroup_trl	ad_language	varchar	6				Language for this entity
c_currency_trl	ad_language	varchar	6				Language for this entity
c_doctype_trl	ad_language	varchar	6				Language for this entity
c_dunninglevel_trl	ad_language	varchar	6				Language for this entity
c_elementvalue_trl	ad_language	varchar	6				Language for this entity
c_greeting_trl	ad_language	varchar	6				Language for this entity
c_paymentterm_trl	ad_language	varchar	6				Language for this entity
c_region_trl	ad_language	varchar	6				Language for this entity
c_salesregion_trl	ad_language	varchar	6				Language for this entity
c_salesstage_trl	ad_language	varchar	6				Language for this entity
c_tax_trl	ad_language	varchar	6				Language for this entity
c_taxcategory_trl	ad_language	varchar	6				Language for this entity
c_uom_trl	ad_language	varchar	6				Language for this entity
gl_category_trl	ad_language	varchar	6				Language for this entity
m_pricelist_trl	ad_language	varchar	6				Language for this entity
m_pricelist_version_trl	ad_language	varchar	6				Language for this entity
m_product_category_trl	ad_language	varchar	6				Language for this entity
m_product_trl	ad_language	varchar	6				Language for this entity
pa_dashboardcontent_trl	ad_language	varchar	6				Language for this entity
pa_documentstatus_trl	ad_language	varchar	6				Language for this entity
pa_reportcolumn_trl	ad_language	varchar	6				Language for this entity
pa_reportline_trl	ad_language	varchar	6				Language for this entity
r_mailtext_trl	ad_language	varchar	6				Language for this entity
w_mailmsg_trl	ad_language	varchar	6				Language for this entity
w_store_trl	ad_language	varchar	6				Language for this entity
ad_language	ad_language_id	numeric	10				Language ID
ad_language	ad_language_uu	varchar	36	√		NULL::character varying	AD_Language_UU
ad_menu_trl	ad_menu_id	numeric	10				Identifies a Menu
ad_menu_trl	ad_menu_trl_uu	varchar	36	√		NULL::character varying	AD_Menu_Trl_UU
ad_message_trl	ad_message_id	numeric	10				System Message
ad_message_trl	ad_message_trl_uu	varchar	36	√		NULL::character varying	AD_Message_Trl_UU
a_asset_group_trl	ad_org_id	numeric	10				Organizational entity within client
ad_broadcastmessage_trl	ad_org_id	numeric	10				Organizational entity within client
ad_chart_trl	ad_org_id	numeric	10				Organizational entity within client
ad_color_trl	ad_org_id	numeric	10				Organizational entity within client
ad_column_trl	ad_org_id	numeric	10				Organizational entity within client
ad_ctxhelpmsg_trl	ad_org_id	numeric	10				Organizational entity within client
ad_desktop_trl	ad_org_id	numeric	10				Organizational entity within client
ad_element_trl	ad_org_id	numeric	10				Organizational entity within client
ad_field_trl	ad_org_id	numeric	10				Organizational entity within client
ad_fieldgroup_trl	ad_org_id	numeric	10				Organizational entity within client
ad_form_trl	ad_org_id	numeric	10				Organizational entity within client
ad_infocolumn_trl	ad_org_id	numeric	10				Organizational entity within client
ad_infowindow_trl	ad_org_id	numeric	10				Organizational entity within client
ad_language	ad_org_id	numeric	10				Organizational entity within client
ad_menu_trl	ad_org_id	numeric	10				Organizational entity within client
ad_message_trl	ad_org_id	numeric	10				Organizational entity within client
ad_printcolor_trl	ad_org_id	numeric	10				Organizational entity within client
ad_printformat_trl	ad_org_id	numeric	10				Organizational entity within client
ad_printformatitem_trl	ad_org_id	numeric	10				Organizational entity within client
ad_process_para_trl	ad_org_id	numeric	10				Organizational entity within client
ad_process_trl	ad_org_id	numeric	10				Organizational entity within client
ad_ref_list_trl	ad_org_id	numeric	10				Organizational entity within client
ad_reference_trl	ad_org_id	numeric	10				Organizational entity within client
ad_tab_trl	ad_org_id	numeric	10				Organizational entity within client
ad_table_trl	ad_org_id	numeric	10				Organizational entity within client
ad_task_trl	ad_org_id	numeric	10				Organizational entity within client
ad_wf_node_trl	ad_org_id	numeric	10				Organizational entity within client
ad_window_trl	ad_org_id	numeric	10				Organizational entity within client
ad_workflow_trl	ad_org_id	numeric	10				Organizational entity within client
c_activity_trl	ad_org_id	numeric	10				Organizational entity within client
c_campaign_trl	ad_org_id	numeric	10				Organizational entity within client
c_charge_trl	ad_org_id	numeric	10				Organizational entity within client
c_country_trl	ad_org_id	numeric	10				Organizational entity within client
c_countrygroup_trl	ad_org_id	numeric	10				Organizational entity within client
c_currency_trl	ad_org_id	numeric	10				Organizational entity within client
c_doctype_trl	ad_org_id	numeric	10				Organizational entity within client
c_dunninglevel_trl	ad_org_id	numeric	10				Organizational entity within client
c_elementvalue_trl	ad_org_id	numeric	10				Organizational entity within client
c_greeting_trl	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm_trl	ad_org_id	numeric	10				Organizational entity within client
c_region_trl	ad_org_id	numeric	10				Organizational entity within client
c_salesregion_trl	ad_org_id	numeric	10				Organizational entity within client
c_salesstage_trl	ad_org_id	numeric	10				Organizational entity within client
c_tax_trl	ad_org_id	numeric	10				Organizational entity within client
c_taxcategory_trl	ad_org_id	numeric	10				Organizational entity within client
c_uom_trl	ad_org_id	numeric	10				Organizational entity within client
gl_category_trl	ad_org_id	numeric	10				Organizational entity within client
m_pricelist_trl	ad_org_id	numeric	10				Organizational entity within client
m_pricelist_version_trl	ad_org_id	numeric	10				Organizational entity within client
m_product_category_trl	ad_org_id	numeric	10				Organizational entity within client
m_product_trl	ad_org_id	numeric	10				Organizational entity within client
pa_dashboardcontent_trl	ad_org_id	numeric	10				Organizational entity within client
pa_documentstatus_trl	ad_org_id	numeric	10				Organizational entity within client
pa_reportcolumn_trl	ad_org_id	numeric	10				Organizational entity within client
pa_reportline_trl	ad_org_id	numeric	10				Organizational entity within client
r_mailtext_trl	ad_org_id	numeric	10				Organizational entity within client
w_mailmsg_trl	ad_org_id	numeric	10				Organizational entity within client
w_store_trl	ad_org_id	numeric	10				Organizational entity within client
ad_printcolor_trl	ad_printcolor_id	numeric	10				Color used for printing and display
ad_printcolor_trl	ad_printcolor_trl_uu	varchar	36	√		NULL::character varying	AD_PrintColor_Trl_UU
ad_printformat_trl	ad_printformat_id	numeric	10			0	Data Print Format
ad_printformat_trl	ad_printformat_trl_uu	varchar	36	√		NULL::character varying	AD_PrintFormat_Trl_UU
ad_printformatitem_trl	ad_printformatitem_id	numeric	10				Item/Column in the Print format
ad_printformatitem_trl	ad_printformatitem_trl_uu	varchar	36	√		NULL::character varying	AD_PrintFormatItem_Trl_UU
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
ad_process_trl	ad_process_id	numeric	10				Process or Report
ad_process_para_trl	ad_process_para_id	numeric	10				Process Parameter
ad_process_para_trl	ad_process_para_trl_uu	varchar	36	√		NULL::character varying	AD_Process_Para_Trl_UU
ad_process_trl	ad_process_trl_uu	varchar	36	√		NULL::character varying	AD_Process_Trl_UU
ad_ref_list_trl	ad_ref_list_id	numeric	10				Reference List based on Table
ad_ref_list_trl	ad_ref_list_trl_uu	varchar	36	√		NULL::character varying	AD_Ref_List_Trl_UU
ad_reference_trl	ad_reference_id	numeric	10				System Reference and Validation
ad_reference_trl	ad_reference_trl_uu	varchar	36	√		NULL::character varying	AD_Reference_Trl_UU
ad_tab_trl	ad_tab_id	numeric	10				Tab within a Window
ad_tab_trl	ad_tab_trl_uu	varchar	36	√		NULL::character varying	AD_Tab_Trl_UU
ad_table_trl	ad_table_id	numeric	10				Database Table information
ad_table_trl	ad_table_trl_uu	varchar	36	√		NULL::character varying	AD_Table_Trl_UU
ad_task_trl	ad_task_id	numeric	10				Operation System Task
ad_task_trl	ad_task_trl_uu	varchar	36	√		NULL::character varying	AD_Task_Trl_UU
ad_wf_node_trl	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_node_trl	ad_wf_node_trl_uu	varchar	36	√		NULL::character varying	AD_WF_Node_Trl_UU
ad_window_trl	ad_window_id	numeric	10				Data entry or display window
ad_window_trl	ad_window_trl_uu	varchar	36	√		NULL::character varying	AD_Window_Trl_UU
ad_workflow_trl	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow_trl	ad_workflow_trl_uu	varchar	36	√		NULL::character varying	AD_Workflow_Trl_UU
ad_broadcastmessage_trl	broadcastmessage	varchar	2000				Broadcast Message
c_activity_trl	c_activity_id	numeric	10				Business Activity
c_activity_trl	c_activity_trl_uu	varchar	36	√		NULL::character varying	C_Activity_Trl_UU
c_campaign_trl	c_campaign_id	numeric	10				Marketing Campaign
c_campaign_trl	c_campaign_trl_uu	varchar	36	√		NULL::character varying	C_Campaign_Trl_UU
c_charge_trl	c_charge_id	numeric	10				Additional document charges
c_charge_trl	c_charge_trl_uu	varchar	36	√		NULL::character varying	C_Charge_Trl_UU
c_country_trl	c_country_id	numeric	10				Country
c_country_trl	c_country_trl_uu	varchar	36	√		NULL::character varying	C_Country_Trl_UU
c_countrygroup_trl	c_countrygroup_id	numeric	10				Country Group
c_countrygroup_trl	c_countrygroup_trl_uu	varchar	36	√		NULL::character varying	C_CountryGroup_Trl_UU
c_currency_trl	c_currency_id	numeric	10				The Currency for this record
c_currency_trl	c_currency_trl_uu	varchar	36	√		NULL::character varying	C_Currency_Trl_UU
c_doctype_trl	c_doctype_id	numeric	10				Document type or rules
c_doctype_trl	c_doctype_trl_uu	varchar	36	√		NULL::character varying	C_DocType_Trl_UU
c_dunninglevel_trl	c_dunninglevel_id	numeric	10				Dunning Level
c_dunninglevel_trl	c_dunninglevel_trl_uu	varchar	36	√		NULL::character varying	C_DunningLevel_Trl_UU
c_elementvalue_trl	c_elementvalue_id	numeric	10				Account Element
c_elementvalue_trl	c_elementvalue_trl_uu	varchar	36	√		NULL::character varying	C_ElementValue_Trl_UU
c_greeting_trl	c_greeting_id	numeric	10				Greeting to print on correspondence
c_greeting_trl	c_greeting_trl_uu	varchar	36	√		NULL::character varying	C_Greeting_Trl_UU
c_paymentterm_trl	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_paymentterm_trl	c_paymentterm_trl_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_Trl_UU
c_region_trl	c_region_id	numeric	10				Identifies a geographical Region
c_region_trl	c_region_trl_uu	varchar	36	√		NULL::character varying	C_Region_Trl_UU
c_salesregion_trl	c_salesregion_id	numeric	10				Sales coverage region
c_salesregion_trl	c_salesregion_trl_uu	varchar	36	√		NULL::character varying	C_SalesRegion_Trl_UU
c_salesstage_trl	c_salesstage_id	numeric	10				Stages of the sales process
c_salesstage_trl	c_salesstage_trl_uu	varchar	36	√		NULL::character varying	C_SalesStage_Trl_UU
c_tax_trl	c_tax_id	numeric	10				Tax identifier
c_tax_trl	c_tax_trl_uu	varchar	36	√		NULL::character varying	C_Tax_Trl_UU
c_taxcategory_trl	c_taxcategory_id	numeric	10				Tax Category
c_taxcategory_trl	c_taxcategory_trl_uu	varchar	36	√		NULL::character varying	C_TaxCategory_Trl_UU
c_uom_trl	c_uom_id	numeric	10				Unit of Measure
c_uom_trl	c_uom_trl_uu	varchar	36	√		NULL::character varying	C_UOM_Trl_UU
ad_tab_trl	commitwarning	varchar	2000	√		null	Warning displayed when saving
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
a_asset_group_trl	created	timestamp	29,6				Date this record was created
ad_broadcastmessage_trl	created	timestamp	29,6				Date this record was created
ad_chart_trl	created	timestamp	29,6				Date this record was created
ad_color_trl	created	timestamp	29,6				Date this record was created
ad_column_trl	created	timestamp	29,6			now()	Date this record was created
ad_ctxhelpmsg_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_desktop_trl	created	timestamp	29,6			now()	Date this record was created
ad_element_trl	created	timestamp	29,6			now()	Date this record was created
ad_field_trl	created	timestamp	29,6			now()	Date this record was created
ad_fieldgroup_trl	created	timestamp	29,6			now()	Date this record was created
ad_form_trl	created	timestamp	29,6			now()	Date this record was created
ad_infocolumn_trl	created	timestamp	29,6			now()	Date this record was created
ad_infowindow_trl	created	timestamp	29,6			now()	Date this record was created
ad_language	created	timestamp	29,6			now()	Date this record was created
ad_menu_trl	created	timestamp	29,6			now()	Date this record was created
ad_message_trl	created	timestamp	29,6			now()	Date this record was created
ad_printcolor_trl	created	timestamp	29,6				Date this record was created
ad_printformat_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_printformatitem_trl	created	timestamp	29,6			now()	Date this record was created
ad_process_para_trl	created	timestamp	29,6			now()	Date this record was created
ad_process_trl	created	timestamp	29,6			now()	Date this record was created
ad_ref_list_trl	created	timestamp	29,6			now()	Date this record was created
ad_reference_trl	created	timestamp	29,6			now()	Date this record was created
ad_tab_trl	created	timestamp	29,6			now()	Date this record was created
ad_table_trl	created	timestamp	29,6			now()	Date this record was created
ad_task_trl	created	timestamp	29,6			now()	Date this record was created
ad_wf_node_trl	created	timestamp	29,6			now()	Date this record was created
ad_window_trl	created	timestamp	29,6			now()	Date this record was created
ad_workflow_trl	created	timestamp	29,6			now()	Date this record was created
c_activity_trl	created	timestamp	29,6				Date this record was created
c_campaign_trl	created	timestamp	29,6				Date this record was created
c_charge_trl	created	timestamp	29,6			now()	Date this record was created
c_country_trl	created	timestamp	29,6			now()	Date this record was created
c_countrygroup_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_currency_trl	created	timestamp	29,6			now()	Date this record was created
c_doctype_trl	created	timestamp	29,6			now()	Date this record was created
c_dunninglevel_trl	created	timestamp	29,6			now()	Date this record was created
c_elementvalue_trl	created	timestamp	29,6			now()	Date this record was created
c_greeting_trl	created	timestamp	29,6			now()	Date this record was created
c_paymentterm_trl	created	timestamp	29,6			now()	Date this record was created
c_region_trl	created	timestamp	29,6				Date this record was created
c_salesregion_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_salesstage_trl	created	timestamp	29,6				Date this record was created
c_tax_trl	created	timestamp	29,6			now()	Date this record was created
c_taxcategory_trl	created	timestamp	29,6			now()	Date this record was created
c_uom_trl	created	timestamp	29,6			now()	Date this record was created
gl_category_trl	created	timestamp	29,6				Date this record was created
m_pricelist_trl	created	timestamp	29,6				Date this record was created
m_pricelist_version_trl	created	timestamp	29,6				Date this record was created
m_product_category_trl	created	timestamp	29,6				Date this record was created
m_product_trl	created	timestamp	29,6			now()	Date this record was created
pa_dashboardcontent_trl	created	timestamp	29,6			now()	Date this record was created
pa_documentstatus_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_reportcolumn_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
pa_reportline_trl	created	timestamp	29,6			statement_timestamp()	Date this record was created
r_mailtext_trl	created	timestamp	29,6			now()	Date this record was created
w_mailmsg_trl	created	timestamp	29,6			now()	Date this record was created
w_store_trl	created	timestamp	29,6			now()	Date this record was created
a_asset_group_trl	createdby	numeric	10				User who created this records
ad_broadcastmessage_trl	createdby	numeric	10				User who created this records
ad_chart_trl	createdby	numeric	10				User who created this records
ad_color_trl	createdby	numeric	10				User who created this records
ad_column_trl	createdby	numeric	10				User who created this records
ad_ctxhelpmsg_trl	createdby	numeric	10				User who created this records
ad_desktop_trl	createdby	numeric	10				User who created this records
ad_element_trl	createdby	numeric	10				User who created this records
ad_field_trl	createdby	numeric	10				User who created this records
ad_fieldgroup_trl	createdby	numeric	10				User who created this records
ad_form_trl	createdby	numeric	10				User who created this records
ad_infocolumn_trl	createdby	numeric	10				User who created this records
ad_infowindow_trl	createdby	numeric	10				User who created this records
ad_language	createdby	numeric	10				User who created this records
ad_menu_trl	createdby	numeric	10				User who created this records
ad_message_trl	createdby	numeric	10				User who created this records
ad_printcolor_trl	createdby	numeric	10				User who created this records
ad_printformat_trl	createdby	numeric	10				User who created this records
ad_printformatitem_trl	createdby	numeric	10				User who created this records
ad_process_para_trl	createdby	numeric	10				User who created this records
ad_process_trl	createdby	numeric	10				User who created this records
ad_ref_list_trl	createdby	numeric	10				User who created this records
ad_reference_trl	createdby	numeric	10				User who created this records
ad_tab_trl	createdby	numeric	10				User who created this records
ad_table_trl	createdby	numeric	10				User who created this records
ad_task_trl	createdby	numeric	10				User who created this records
ad_wf_node_trl	createdby	numeric	10				User who created this records
ad_window_trl	createdby	numeric	10				User who created this records
ad_workflow_trl	createdby	numeric	10				User who created this records
c_activity_trl	createdby	numeric	10				User who created this records
c_campaign_trl	createdby	numeric	10				User who created this records
c_charge_trl	createdby	numeric	10				User who created this records
c_country_trl	createdby	numeric	10				User who created this records
c_countrygroup_trl	createdby	numeric	10				User who created this records
c_currency_trl	createdby	numeric	10				User who created this records
c_doctype_trl	createdby	numeric	10				User who created this records
c_dunninglevel_trl	createdby	numeric	10				User who created this records
c_elementvalue_trl	createdby	numeric	10				User who created this records
c_greeting_trl	createdby	numeric	10				User who created this records
c_paymentterm_trl	createdby	numeric	10				User who created this records
c_region_trl	createdby	numeric	10				User who created this records
c_salesregion_trl	createdby	numeric	10				User who created this records
c_salesstage_trl	createdby	numeric	10				User who created this records
c_tax_trl	createdby	numeric	10				User who created this records
c_taxcategory_trl	createdby	numeric	10				User who created this records
c_uom_trl	createdby	numeric	10				User who created this records
gl_category_trl	createdby	numeric	10				User who created this records
m_pricelist_trl	createdby	numeric	10				User who created this records
m_pricelist_version_trl	createdby	numeric	10				User who created this records
m_product_category_trl	createdby	numeric	10				User who created this records
m_product_trl	createdby	numeric	10				User who created this records
pa_dashboardcontent_trl	createdby	numeric	10				User who created this records
pa_documentstatus_trl	createdby	numeric	10				User who created this records
pa_reportcolumn_trl	createdby	numeric	10				User who created this records
pa_reportline_trl	createdby	numeric	10				User who created this records
r_mailtext_trl	createdby	numeric	10				User who created this records
w_mailmsg_trl	createdby	numeric	10				User who created this records
w_store_trl	createdby	numeric	10				User who created this records
c_currency_trl	cursymbol	varchar	10	√		null	Symbol of the currency (opt used for printing only)
ad_language	datepattern	varchar	20	√		null	Java Date Pattern
a_asset_group_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_chart_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_desktop_trl	description	varchar	255	√		null	Optional short description of the record
ad_element_trl	description	varchar	255	√		null	Optional short description of the record
ad_field_trl	description	varchar	255	√		null	Optional short description of the record
ad_form_trl	description	varchar	255	√		null	Optional short description of the record
ad_infocolumn_trl	description	varchar	255	√		null	Optional short description of the record
ad_infowindow_trl	description	varchar	255	√		null	Optional short description of the record
ad_menu_trl	description	varchar	255	√		null	Optional short description of the record
ad_printformat_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_process_para_trl	description	varchar	255	√		null	Optional short description of the record
ad_process_trl	description	varchar	255	√		null	Optional short description of the record
ad_ref_list_trl	description	varchar	255	√		null	Optional short description of the record
ad_reference_trl	description	varchar	255	√		null	Optional short description of the record
ad_tab_trl	description	varchar	255	√		null	Optional short description of the record
ad_task_trl	description	varchar	255	√		null	Optional short description of the record
ad_wf_node_trl	description	varchar	255	√		null	Optional short description of the record
ad_window_trl	description	varchar	255	√		null	Optional short description of the record
ad_workflow_trl	description	varchar	255	√		null	Optional short description of the record
c_activity_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_campaign_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_charge_trl	description	varchar	255	√		null	Optional short description of the record
c_country_trl	description	varchar	255	√		null	Optional short description of the record
c_countrygroup_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_currency_trl	description	varchar	255				Optional short description of the record
c_elementvalue_trl	description	varchar	255	√		null	Optional short description of the record
c_paymentterm_trl	description	varchar	255	√		null	Optional short description of the record
c_salesregion_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_salesstage_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_tax_trl	description	varchar	255	√		null	Optional short description of the record
c_taxcategory_trl	description	varchar	255	√		null	Optional short description of the record
c_uom_trl	description	varchar	255	√		null	Optional short description of the record
m_pricelist_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_product_category_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_product_trl	description	varchar	255	√		null	Optional short description of the record
pa_dashboardcontent_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
pa_reportcolumn_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
pa_reportline_trl	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_doctype_trl	documentnote	varchar	2000	√		null	Additional information for a Document
c_paymentterm_trl	documentnote	varchar	2000	√		null	Additional information for a Document
m_product_trl	documentnote	varchar	2000	√		null	Additional information for a Document
ad_chart_trl	domainlabel	varchar	60	√		NULL::character varying	Label for the domain axis.
w_store_trl	emailfooter	varchar	2000	√		null	Footer added to EMails
w_store_trl	emailheader	varchar	2000	√		null	Header added to EMails
gl_category_trl	gl_category_id	numeric	10				General Ledger Category
gl_category_trl	gl_category_trl_uu	varchar	36	√		NULL::character varying	GL_Category_Trl_UU
c_greeting_trl	greeting	varchar	60	√		null	For letters, e.g. "Dear {0}" or "Dear Mr. {0}" - At runtime, "{0}" is replaced by the name
a_asset_group_trl	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_desktop_trl	help	varchar	2000	√		null	Comment or Hint
ad_element_trl	help	varchar	2000	√		null	Comment or Hint
ad_field_trl	help	varchar	2000	√		null	Comment or Hint
ad_form_trl	help	varchar	2000	√		null	Comment or Hint
ad_infocolumn_trl	help	varchar	2000	√		null	Comment or Hint
ad_infowindow_trl	help	varchar	2000	√		null	Comment or Hint
ad_process_para_trl	help	varchar	2000	√		null	Comment or Hint
ad_process_trl	help	varchar	2000	√		null	Comment or Hint
ad_reference_trl	help	varchar	2000	√		null	Comment or Hint
ad_tab_trl	help	varchar	2000	√		null	Comment or Hint
ad_task_trl	help	varchar	2000	√		null	Comment or Hint
ad_wf_node_trl	help	text	2147483647	√		null	Comment or Hint
ad_window_trl	help	varchar	2000	√		null	Comment or Hint
ad_workflow_trl	help	text	2147483647	√		null	Comment or Hint
c_activity_trl	help	varchar	2000	√		NULL::character varying	Comment or Hint
pa_dashboardcontent_trl	html	text	2147483647	√		null	HTML
a_asset_group_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_broadcastmessage_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_chart_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_color_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_column_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ctxhelpmsg_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_desktop_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_element_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_field_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_fieldgroup_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_form_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_infocolumn_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_infowindow_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_language	isactive	bpchar	1			'N'::bpchar	The record is active in the system
ad_menu_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_message_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printcolor_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_printformat_trl	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_process_para_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_process_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_ref_list_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_reference_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tab_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_task_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_node_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_window_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflow_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_campaign_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_charge_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_country_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_countrygroup_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_currency_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_dunninglevel_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_elementvalue_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_greeting_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_paymentterm_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_region_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_salesregion_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_salesstage_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_tax_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_taxcategory_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_category_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist_version_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_dashboardcontent_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_documentstatus_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportcolumn_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
pa_reportline_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
r_mailtext_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_mailmsg_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
w_store_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_language	isbaselanguage	bpchar	1			'N'::bpchar	The system information is maintained in this language
ad_language	isdecimalpoint	bpchar	1	√		null	The number notation has a decimal point (no decimal comma)
ad_language	isloginlocale	bpchar	1	√		'N'::bpchar	Login Locale
ad_language	issystemlanguage	bpchar	1			'N'::bpchar	The screens, etc. are maintained in this Language
a_asset_group_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_broadcastmessage_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_chart_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_color_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_column_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_ctxhelpmsg_trl	istranslated	bpchar	1				This column is translated
ad_desktop_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_element_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_field_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_fieldgroup_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_form_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_infocolumn_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_infowindow_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_menu_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_message_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_printcolor_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_printformat_trl	istranslated	bpchar	1				This column is translated
ad_printformatitem_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_process_para_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_process_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_ref_list_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_reference_trl	istranslated	bpchar	1	√		'N'::bpchar	This column is translated
ad_tab_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_table_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_task_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_wf_node_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_window_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_workflow_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_activity_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_campaign_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_charge_trl	istranslated	bpchar	1				This column is translated
c_country_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_countrygroup_trl	istranslated	bpchar	1				This column is translated
c_currency_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_doctype_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_dunninglevel_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_elementvalue_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_greeting_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_paymentterm_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_region_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_salesregion_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_salesstage_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_tax_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_taxcategory_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
c_uom_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
gl_category_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
m_pricelist_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
m_pricelist_version_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
m_product_category_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
m_product_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
pa_dashboardcontent_trl	istranslated	bpchar	1				This column is translated
pa_documentstatus_trl	istranslated	bpchar	1				This column is translated
pa_reportcolumn_trl	istranslated	bpchar	1				This column is translated
pa_reportline_trl	istranslated	bpchar	1				This column is translated
r_mailtext_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
w_mailmsg_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
w_store_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_language	languageiso	bpchar	2	√		null	Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
m_pricelist_trl	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist_trl	m_pricelist_trl_uu	varchar	36	√		NULL::character varying	M_PriceList_Trl_UU
m_pricelist_version_trl	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_pricelist_version_trl	m_pricelist_version_trl_uu	varchar	36	√		NULL::character varying	M_PriceList_Version_Trl_UU
m_product_category_trl	m_product_category_id	numeric	10				Category of a Product
m_product_category_trl	m_product_category_trl_uu	varchar	36	√		NULL::character varying	M_Product_Category_Trl_UU
m_product_trl	m_product_id	numeric	10				Product, Service, Item
m_product_trl	m_product_trl_uu	varchar	36	√		NULL::character varying	M_Product_Trl_UU
r_mailtext_trl	mailheader	varchar	2000	√		null	Mail Header (Subject)
r_mailtext_trl	mailtext	text	2147483647				Text used for Mail message
r_mailtext_trl	mailtext2	varchar	2000	√		null	Optional second text part used for Mail message
r_mailtext_trl	mailtext3	varchar	2000	√		null	Optional third text part used for Mail message
w_mailmsg_trl	message	varchar	2000				EMail Message
w_mailmsg_trl	message2	varchar	2000	√		null	Optional second part of the EMail Message
w_mailmsg_trl	message3	varchar	2000	√		null	Optional third part of the EMail Message
ad_ctxhelpmsg_trl	msgtext	varchar	2000				Textual Informational, Menu or Error Message
ad_message_trl	msgtext	varchar	2000				Textual Informational, Menu or Error Message
ad_message_trl	msgtip	varchar	2000	√		null	Additional tip or help for this message
a_asset_group_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_chart_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_color_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_column_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_desktop_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_element_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_field_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_fieldgroup_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_form_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_infocolumn_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_infowindow_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_language	name	varchar	60				Alphanumeric identifier of the entity
ad_menu_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_printcolor_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_printformat_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_printformatitem_trl	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
ad_process_para_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_process_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_ref_list_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_reference_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_tab_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_table_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_task_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_node_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_window_trl	name	varchar	60				Alphanumeric identifier of the entity
ad_workflow_trl	name	varchar	60				Alphanumeric identifier of the entity
c_activity_trl	name	varchar	60				Alphanumeric identifier of the entity
c_campaign_trl	name	varchar	60				Alphanumeric identifier of the entity
c_charge_trl	name	varchar	60				Alphanumeric identifier of the entity
c_country_trl	name	varchar	60				Alphanumeric identifier of the entity
c_countrygroup_trl	name	varchar	60				Alphanumeric identifier of the entity
c_doctype_trl	name	varchar	60				Alphanumeric identifier of the entity
c_elementvalue_trl	name	varchar	120				Alphanumeric identifier of the entity
c_greeting_trl	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm_trl	name	varchar	60				Alphanumeric identifier of the entity
c_region_trl	name	varchar	60				Alphanumeric identifier of the entity
c_salesregion_trl	name	varchar	60				Alphanumeric identifier of the entity
c_salesstage_trl	name	varchar	60				Alphanumeric identifier of the entity
c_tax_trl	name	varchar	60				Alphanumeric identifier of the entity
c_taxcategory_trl	name	varchar	60				Alphanumeric identifier of the entity
c_uom_trl	name	varchar	60				Alphanumeric identifier of the entity
gl_category_trl	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
m_pricelist_trl	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist_version_trl	name	varchar	60				Alphanumeric identifier of the entity
m_product_category_trl	name	varchar	60				Alphanumeric identifier of the entity
m_product_trl	name	varchar	255				Alphanumeric identifier of the entity
pa_dashboardcontent_trl	name	varchar	120				Alphanumeric identifier of the entity
pa_documentstatus_trl	name	varchar	60				Alphanumeric identifier of the entity
pa_reportcolumn_trl	name	varchar	255				Alphanumeric identifier of the entity
pa_reportline_trl	name	varchar	255				Alphanumeric identifier of the entity
r_mailtext_trl	name	varchar	60				Alphanumeric identifier of the entity
c_dunninglevel_trl	note	varchar	2000	√		null	Optional additional user defined information
pa_dashboardcontent_trl	pa_dashboardcontent_id	numeric	10				Dashboard Content
pa_dashboardcontent_trl	pa_dashboardcontent_trl_uu	varchar	36	√		NULL::character varying	PA_DashboardContent_Trl_UU
pa_documentstatus_trl	pa_documentstatus_id	numeric	10				Document Status
pa_documentstatus_trl	pa_documentstatus_trl_uu	varchar	36	√		NULL::character varying	PA_DocumentStatus_Trl_UU
pa_reportcolumn_trl	pa_reportcolumn_id	numeric	10				Column in Report
pa_reportcolumn_trl	pa_reportcolumn_trl_uu	varchar	36	√		NULL::character varying	PA_ReportColumn_Trl_UU
pa_reportline_trl	pa_reportline_id	numeric	10				Report Line
pa_reportline_trl	pa_reportline_trl_uu	varchar	36	√		NULL::character varying	PA_ReportLine_Trl_UU
ad_column_trl	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_element_trl	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_field_trl	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_infocolumn_trl	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para_trl	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para_trl	placeholder2	varchar	255	√		NULL::character varying	Placeholder2
c_country_trl	placeholderaddress1	varchar	255	√		NULL::character varying	Placeholder for Address 1
c_country_trl	placeholderaddress2	varchar	255	√		NULL::character varying	Placeholder for Address 2
c_country_trl	placeholderaddress3	varchar	255	√		NULL::character varying	Placeholder for Address 3
c_country_trl	placeholderaddress4	varchar	255	√		NULL::character varying	Placeholder for Address 4
c_country_trl	placeholderaddress5	varchar	255	√		NULL::character varying	Placeholder for Address 5
c_country_trl	placeholdercity	varchar	255	√		NULL::character varying	Placeholder for city
c_country_trl	placeholdercomments	varchar	255	√		NULL::character varying	Placeholder for comments
c_country_trl	placeholderpostal	varchar	255	√		NULL::character varying	Placeholder for postal
c_country_trl	placeholderpostal_add	varchar	255	√		NULL::character varying	Placeholder for additional zip
ad_element_trl	po_description	varchar	255	√		null	Description in PO Screens
ad_element_trl	po_help	varchar	2000	√		null	Help for PO Screens
ad_element_trl	po_name	varchar	60	√		null	Name on PO Screens
ad_element_trl	po_printname	varchar	60	√		null	Print name on PO Screens/Reports
ad_element_trl	printname	varchar	60				The label text to be printed on a document or correspondence.
ad_language	printname	varchar	60			NULL::character varying	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.
c_doctype_trl	printname	varchar	60				The label text to be printed on a document or correspondence.
c_dunninglevel_trl	printname	varchar	60				The label text to be printed on a document or correspondence.
ad_printformatitem_trl	printnamesuffix	varchar	60	√		null	The label text to be printed on a document or correspondence after the field
ad_language	processing	bpchar	1	√		null	Process Now
r_mailtext_trl	r_mailtext_id	numeric	10				Text templates for mailings
r_mailtext_trl	r_mailtext_trl_uu	varchar	36	√		NULL::character varying	R_MailText_Trl_UU
ad_chart_trl	rangelabel	varchar	60	√		NULL::character varying	Label for the range axis.
c_country_trl	regionname	varchar	60	√		null	Name of the Region
w_mailmsg_trl	subject	varchar	255				Email Message Subject
c_tax_trl	taxindicator	varchar	10	√		null	Short form for Tax to be printed on documents
ad_language	timepattern	varchar	20	√		null	Java Time Pattern
c_uom_trl	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
a_asset_group_trl	updated	timestamp	29,6				Date this record was updated
ad_broadcastmessage_trl	updated	timestamp	29,6				Date this record was updated
ad_chart_trl	updated	timestamp	29,6				Date this record was updated
ad_color_trl	updated	timestamp	29,6				Date this record was updated
ad_column_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_ctxhelpmsg_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_desktop_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_element_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_field_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_fieldgroup_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_form_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_infocolumn_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_infowindow_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_language	updated	timestamp	29,6			now()	Date this record was updated
ad_menu_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_message_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_printcolor_trl	updated	timestamp	29,6				Date this record was updated
ad_printformat_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_printformatitem_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_process_para_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_process_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_ref_list_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_reference_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_tab_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_table_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_task_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_node_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_window_trl	updated	timestamp	29,6			now()	Date this record was updated
ad_workflow_trl	updated	timestamp	29,6			now()	Date this record was updated
c_activity_trl	updated	timestamp	29,6				Date this record was updated
c_campaign_trl	updated	timestamp	29,6				Date this record was updated
c_charge_trl	updated	timestamp	29,6			now()	Date this record was updated
c_country_trl	updated	timestamp	29,6			now()	Date this record was updated
c_countrygroup_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_currency_trl	updated	timestamp	29,6			now()	Date this record was updated
c_doctype_trl	updated	timestamp	29,6			now()	Date this record was updated
c_dunninglevel_trl	updated	timestamp	29,6			now()	Date this record was updated
c_elementvalue_trl	updated	timestamp	29,6			now()	Date this record was updated
c_greeting_trl	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm_trl	updated	timestamp	29,6			now()	Date this record was updated
c_region_trl	updated	timestamp	29,6				Date this record was updated
c_salesregion_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_salesstage_trl	updated	timestamp	29,6				Date this record was updated
c_tax_trl	updated	timestamp	29,6			now()	Date this record was updated
c_taxcategory_trl	updated	timestamp	29,6			now()	Date this record was updated
c_uom_trl	updated	timestamp	29,6			now()	Date this record was updated
gl_category_trl	updated	timestamp	29,6				Date this record was updated
m_pricelist_trl	updated	timestamp	29,6				Date this record was updated
m_pricelist_version_trl	updated	timestamp	29,6				Date this record was updated
m_product_category_trl	updated	timestamp	29,6				Date this record was updated
m_product_trl	updated	timestamp	29,6			now()	Date this record was updated
pa_dashboardcontent_trl	updated	timestamp	29,6			now()	Date this record was updated
pa_documentstatus_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_reportcolumn_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
pa_reportline_trl	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
r_mailtext_trl	updated	timestamp	29,6			now()	Date this record was updated
w_mailmsg_trl	updated	timestamp	29,6			now()	Date this record was updated
w_store_trl	updated	timestamp	29,6			now()	Date this record was updated
a_asset_group_trl	updatedby	numeric	10				User who updated this records
ad_broadcastmessage_trl	updatedby	numeric	10				User who updated this records
ad_chart_trl	updatedby	numeric	10				User who updated this records
ad_color_trl	updatedby	numeric	10				User who updated this records
ad_column_trl	updatedby	numeric	10				User who updated this records
ad_ctxhelpmsg_trl	updatedby	numeric	10				User who updated this records
ad_desktop_trl	updatedby	numeric	10				User who updated this records
ad_element_trl	updatedby	numeric	10				User who updated this records
ad_field_trl	updatedby	numeric	10				User who updated this records
ad_fieldgroup_trl	updatedby	numeric	10				User who updated this records
ad_form_trl	updatedby	numeric	10				User who updated this records
ad_infocolumn_trl	updatedby	numeric	10				User who updated this records
ad_infowindow_trl	updatedby	numeric	10				User who updated this records
ad_language	updatedby	numeric	10				User who updated this records
ad_menu_trl	updatedby	numeric	10				User who updated this records
ad_message_trl	updatedby	numeric	10				User who updated this records
ad_printcolor_trl	updatedby	numeric	10				User who updated this records
ad_printformat_trl	updatedby	numeric	10				User who updated this records
ad_printformatitem_trl	updatedby	numeric	10				User who updated this records
ad_process_para_trl	updatedby	numeric	10				User who updated this records
ad_process_trl	updatedby	numeric	10				User who updated this records
ad_ref_list_trl	updatedby	numeric	10				User who updated this records
ad_reference_trl	updatedby	numeric	10				User who updated this records
ad_tab_trl	updatedby	numeric	10				User who updated this records
ad_table_trl	updatedby	numeric	10				User who updated this records
ad_task_trl	updatedby	numeric	10				User who updated this records
ad_wf_node_trl	updatedby	numeric	10				User who updated this records
ad_window_trl	updatedby	numeric	10				User who updated this records
ad_workflow_trl	updatedby	numeric	10				User who updated this records
c_activity_trl	updatedby	numeric	10				User who updated this records
c_campaign_trl	updatedby	numeric	10				User who updated this records
c_charge_trl	updatedby	numeric	10				User who updated this records
c_country_trl	updatedby	numeric	10				User who updated this records
c_countrygroup_trl	updatedby	numeric	10				User who updated this records
c_currency_trl	updatedby	numeric	10				User who updated this records
c_doctype_trl	updatedby	numeric	10				User who updated this records
c_dunninglevel_trl	updatedby	numeric	10				User who updated this records
c_elementvalue_trl	updatedby	numeric	10				User who updated this records
c_greeting_trl	updatedby	numeric	10				User who updated this records
c_paymentterm_trl	updatedby	numeric	10				User who updated this records
c_region_trl	updatedby	numeric	10				User who updated this records
c_salesregion_trl	updatedby	numeric	10				User who updated this records
c_salesstage_trl	updatedby	numeric	10				User who updated this records
c_tax_trl	updatedby	numeric	10				User who updated this records
c_taxcategory_trl	updatedby	numeric	10				User who updated this records
c_uom_trl	updatedby	numeric	10				User who updated this records
gl_category_trl	updatedby	numeric	10				User who updated this records
m_pricelist_trl	updatedby	numeric	10				User who updated this records
m_pricelist_version_trl	updatedby	numeric	10				User who updated this records
m_product_category_trl	updatedby	numeric	10				User who updated this records
m_product_trl	updatedby	numeric	10				User who updated this records
pa_dashboardcontent_trl	updatedby	numeric	10				User who updated this records
pa_documentstatus_trl	updatedby	numeric	10				User who updated this records
pa_reportcolumn_trl	updatedby	numeric	10				User who updated this records
pa_reportline_trl	updatedby	numeric	10				User who updated this records
r_mailtext_trl	updatedby	numeric	10				User who updated this records
w_mailmsg_trl	updatedby	numeric	10				User who updated this records
w_store_trl	updatedby	numeric	10				User who updated this records
w_mailmsg_trl	w_mailmsg_id	numeric	10				Web Store Mail Message Template
w_mailmsg_trl	w_mailmsg_trl_uu	varchar	36	√		NULL::character varying	W_MailMsg_Trl_UU
w_store_trl	w_store_id	numeric	10				A Web Store of the Client
w_store_trl	w_store_trl_uu	varchar	36	√		NULL::character varying	W_Store_Trl_UU
w_store_trl	webinfo	varchar	2000	√		null	Web Store Header Information
w_store_trl	webparam1	varchar	2000	√		null	Web Site Parameter 1 (default: header image)
w_store_trl	webparam2	varchar	2000	√		null	Web Site Parameter 2 (default index page)
w_store_trl	webparam3	varchar	2000	√		null	Web Site Parameter 3 (default left - menu)
w_store_trl	webparam4	varchar	2000	√		null	Web Site Parameter 4 (default footer left)
w_store_trl	webparam5	varchar	2000	√		null	Web Site Parameter 5 (default footer center)
w_store_trl	webparam6	varchar	2000	√		null	Web Site Parameter 6 (default footer right)