SchemaSpy Analysis of idempiere9.adempiere - ColumnsTranslation Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:56 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 811 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_language isloginlocale bpchar 1  √  'N'::bpchar Login Locale
ad_reference_trl istranslated bpchar 1  √  'N'::bpchar This column is translated
ad_language isactive bpchar 1 'N'::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 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_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_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_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_country_trl istranslated bpchar 1 'N'::bpchar 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
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
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_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_printformat_trl ad_printformat_id numeric 10 0 Data Print Format
ad_column_trl created timestamp 29,6 now() 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_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_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_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_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
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
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
ad_column_trl updated timestamp 29,6 now() 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_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_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_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_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
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
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
ad_column_trl ad_column_trl_uu varchar 36  √  null AD_Column_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
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
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_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_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_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_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_product_trl description varchar 255  √  null 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
w_store_trl emailfooter varchar 2000  √  null Footer added to EMails
w_store_trl emailheader varchar 2000  √  null Header added to EMails
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
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
pa_dashboardcontent_trl html text 2147483647  √  null HTML
ad_language isdecimalpoint bpchar 1  √  null The number notation has a decimal point (no decimal comma)
ad_language languageiso bpchar 2  √  null Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
r_mailtext_trl mailheader varchar 2000  √  null Mail Header (Subject)
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 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_message_trl msgtip varchar 2000  √  null Additional tip or help for this message
c_dunninglevel_trl note varchar 2000  √  null Optional additional user defined information
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_printformatitem_trl printname varchar 2000  √  null 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
c_country_trl regionname varchar 60  √  null Name of the Region
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
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)
a_asset_group_trl a_asset_group_id numeric 10 Group of Assets
ad_broadcastmessage_trl ad_broadcastmessage_id numeric 10 Broadcast Message
ad_chart_trl ad_chart_id numeric 10 Chart
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_column_trl ad_column_id numeric 10 Column in the table
ad_ctxhelpmsg_trl ad_ctxhelpmsg_id numeric 10 Context Help Message
ad_desktop_trl ad_desktop_id numeric 10 Collection of Workbenches
ad_element_trl ad_element_id numeric 10 System Element enables the central maintenance of column description and help.
ad_field_trl ad_field_id numeric 10 Field on a database table
ad_fieldgroup_trl ad_fieldgroup_id numeric 10 Logical grouping of fields
ad_form_trl ad_form_id numeric 10 Special Form
ad_infocolumn_trl ad_infocolumn_id numeric 10 Info Window Column
ad_infowindow_trl ad_infowindow_id numeric 10 Info and search/select Window
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_menu_trl ad_menu_id numeric 10 Identifies a Menu
ad_message_trl ad_message_id numeric 10 System Message
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_printformatitem_trl ad_printformatitem_id numeric 10 Item/Column in the Print format
ad_process_trl ad_process_id numeric 10 Process or Report
ad_process_para_trl ad_process_para_id numeric 10 Process Parameter
ad_ref_list_trl ad_ref_list_id numeric 10 Reference List based on Table
ad_reference_trl ad_reference_id numeric 10 System Reference and Validation
ad_tab_trl ad_tab_id numeric 10 Tab within a Window
ad_table_trl ad_table_id numeric 10 Database Table information
ad_task_trl ad_task_id numeric 10 Operation System Task
ad_wf_node_trl ad_wf_node_id numeric 10 Workflow Node (activity), step or process
ad_window_trl ad_window_id numeric 10 Data entry or display window
ad_workflow_trl ad_workflow_id numeric 10 Workflow or combination of tasks
ad_broadcastmessage_trl broadcastmessage varchar 2000 Broadcast Message
c_activity_trl c_activity_id numeric 10 Business Activity
c_campaign_trl c_campaign_id numeric 10 Marketing Campaign
c_charge_trl c_charge_id numeric 10 Additional document charges
c_country_trl c_country_id numeric 10 Country
c_countrygroup_trl c_countrygroup_id numeric 10 Country Group
c_currency_trl c_currency_id numeric 10 The Currency for this record
c_doctype_trl c_doctype_id numeric 10 Document type or rules
c_dunninglevel_trl c_dunninglevel_id numeric 10 Dunning Level
c_elementvalue_trl c_elementvalue_id numeric 10 Account Element
c_greeting_trl c_greeting_id numeric 10 Greeting to print on correspondence
c_paymentterm_trl c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_region_trl c_region_id numeric 10 Identifies a geographical Region
c_salesregion_trl c_salesregion_id numeric 10 Sales coverage region
c_salesstage_trl c_salesstage_id numeric 10 Stages of the sales process
c_tax_trl c_tax_id numeric 10 Tax identifier
c_taxcategory_trl c_taxcategory_id numeric 10 Tax Category
c_uom_trl c_uom_id numeric 10 Unit of Measure
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_printcolor_trl created timestamp 29,6 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_region_trl created timestamp 29,6 Date this record was created
c_salesstage_trl created timestamp 29,6 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
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 description varchar 255 Optional short description of the record
gl_category_trl gl_category_id numeric 10 General Ledger Category
ad_ctxhelpmsg_trl istranslated bpchar 1 This column is translated
ad_printformat_trl istranslated bpchar 1 This column is translated
c_charge_trl istranslated bpchar 1 This column is translated
c_countrygroup_trl istranslated bpchar 1 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
m_pricelist_trl m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version_trl m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
m_product_category_trl m_product_category_id numeric 10 Category of a Product
m_product_trl m_product_id numeric 10 Product, Service, Item
r_mailtext_trl mailtext text 2147483647 Text used for Mail message
w_mailmsg_trl message varchar 2000 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
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_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
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
pa_dashboardcontent_trl pa_dashboardcontent_id numeric 10 Dashboard Content
pa_documentstatus_trl pa_documentstatus_id numeric 10 Document Status
pa_reportcolumn_trl pa_reportcolumn_id numeric 10 Column in Report
pa_reportline_trl pa_reportline_id numeric 10 Report Line
ad_element_trl printname varchar 60 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.
r_mailtext_trl r_mailtext_id numeric 10 Text templates for mailings
w_mailmsg_trl subject varchar 255 Email Message Subject
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_printcolor_trl updated timestamp 29,6 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_region_trl updated timestamp 29,6 Date this record was updated
c_salesstage_trl updated timestamp 29,6 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
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_store_trl w_store_id numeric 10 A Web Store of the Client
a_asset_group_trl a_asset_group_trl_uu varchar 36  √  NULL::character varying A_Asset_Group_Trl_UU
ad_broadcastmessage_trl ad_broadcastmessage_trl_uu varchar 36  √  NULL::character varying AD_BroadcastMessage_Trl_UU
ad_chart_trl ad_chart_trl_uu varchar 36  √  NULL::character varying AD_Chart_Trl_UU
ad_color_trl ad_color_trl_uu varchar 36  √  NULL::character varying AD_Color_Trl_UU
ad_ctxhelpmsg_trl ad_ctxhelpmsg_trl_uu varchar 36  √  NULL::character varying AD_CtxHelpMsg_Trl_UU
ad_desktop_trl ad_desktop_trl_uu varchar 36  √  NULL::character varying AD_Desktop_Trl_UU
ad_element_trl ad_element_trl_uu varchar 36  √  NULL::character varying AD_Element_Trl_UU
ad_field_trl ad_field_trl_uu varchar 36  √  NULL::character varying AD_Field_Trl_UU
ad_fieldgroup_trl ad_fieldgroup_trl_uu varchar 36  √  NULL::character varying AD_FieldGroup_Trl_UU
ad_form_trl ad_form_trl_uu varchar 36  √  NULL::character varying AD_Form_Trl_UU
ad_infocolumn_trl ad_infocolumn_trl_uu varchar 36  √  NULL::character varying AD_InfoColumn_Trl_UU
ad_infowindow_trl ad_infowindow_trl_uu varchar 36  √  NULL::character varying AD_InfoWindow_Trl_UU
ad_language ad_language_uu varchar 36  √  NULL::character varying AD_Language_UU
ad_menu_trl ad_menu_trl_uu varchar 36  √  NULL::character varying AD_Menu_Trl_UU
ad_message_trl ad_message_trl_uu varchar 36  √  NULL::character varying AD_Message_Trl_UU
ad_printcolor_trl ad_printcolor_trl_uu varchar 36  √  NULL::character varying AD_PrintColor_Trl_UU
ad_printformat_trl ad_printformat_trl_uu varchar 36  √  NULL::character varying AD_PrintFormat_Trl_UU
ad_printformatitem_trl ad_printformatitem_trl_uu varchar 36  √  NULL::character varying AD_PrintFormatItem_Trl_UU
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_trl_uu varchar 36  √  NULL::character varying AD_Ref_List_Trl_UU
ad_reference_trl ad_reference_trl_uu varchar 36  √  NULL::character varying AD_Reference_Trl_UU
ad_tab_trl ad_tab_trl_uu varchar 36  √  NULL::character varying AD_Tab_Trl_UU
ad_table_trl ad_table_trl_uu varchar 36  √  NULL::character varying AD_Table_Trl_UU
ad_task_trl ad_task_trl_uu varchar 36  √  NULL::character varying AD_Task_Trl_UU
ad_wf_node_trl ad_wf_node_trl_uu varchar 36  √  NULL::character varying AD_WF_Node_Trl_UU
ad_window_trl ad_window_trl_uu varchar 36  √  NULL::character varying AD_Window_Trl_UU
ad_workflow_trl ad_workflow_trl_uu varchar 36  √  NULL::character varying AD_Workflow_Trl_UU
c_activity_trl c_activity_trl_uu varchar 36  √  NULL::character varying C_Activity_Trl_UU
c_campaign_trl c_campaign_trl_uu varchar 36  √  NULL::character varying C_Campaign_Trl_UU
c_charge_trl c_charge_trl_uu varchar 36  √  NULL::character varying C_Charge_Trl_UU
c_country_trl c_country_trl_uu varchar 36  √  NULL::character varying C_Country_Trl_UU
c_countrygroup_trl c_countrygroup_trl_uu varchar 36  √  NULL::character varying C_CountryGroup_Trl_UU
c_currency_trl c_currency_trl_uu varchar 36  √  NULL::character varying C_Currency_Trl_UU
c_doctype_trl c_doctype_trl_uu varchar 36  √  NULL::character varying C_DocType_Trl_UU
c_dunninglevel_trl c_dunninglevel_trl_uu varchar 36  √  NULL::character varying C_DunningLevel_Trl_UU
c_elementvalue_trl c_elementvalue_trl_uu varchar 36  √  NULL::character varying C_ElementValue_Trl_UU
c_greeting_trl c_greeting_trl_uu varchar 36  √  NULL::character varying C_Greeting_Trl_UU
c_paymentterm_trl c_paymentterm_trl_uu varchar 36  √  NULL::character varying C_PaymentTerm_Trl_UU
c_region_trl c_region_trl_uu varchar 36  √  NULL::character varying C_Region_Trl_UU
c_salesregion_trl c_salesregion_trl_uu varchar 36  √  NULL::character varying C_SalesRegion_Trl_UU
c_salesstage_trl c_salesstage_trl_uu varchar 36  √  NULL::character varying C_SalesStage_Trl_UU
c_tax_trl c_tax_trl_uu varchar 36  √  NULL::character varying C_Tax_Trl_UU
c_taxcategory_trl c_taxcategory_trl_uu varchar 36  √  NULL::character varying C_TaxCategory_Trl_UU
c_uom_trl c_uom_trl_uu varchar 36  √  NULL::character varying C_UOM_Trl_UU
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_printformat_trl description varchar 255  √  NULL::character varying 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_countrygroup_trl description varchar 255  √  NULL::character varying 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
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
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
ad_chart_trl domainlabel varchar 60  √  NULL::character varying Label for the domain axis.
gl_category_trl gl_category_trl_uu varchar 36  √  NULL::character varying GL_Category_Trl_UU
a_asset_group_trl help varchar 2000  √  NULL::character varying Comment or Hint
c_activity_trl help varchar 2000  √  NULL::character varying Comment or Hint
m_pricelist_trl m_pricelist_trl_uu varchar 36  √  NULL::character varying M_PriceList_Trl_UU
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_trl_uu varchar 36  √  NULL::character varying M_Product_Category_Trl_UU
m_product_trl m_product_trl_uu varchar 36  √  NULL::character varying M_Product_Trl_UU
gl_category_trl name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
pa_dashboardcontent_trl pa_dashboardcontent_trl_uu varchar 36  √  NULL::character varying PA_DashboardContent_Trl_UU
pa_documentstatus_trl pa_documentstatus_trl_uu varchar 36  √  NULL::character varying PA_DocumentStatus_Trl_UU
pa_reportcolumn_trl pa_reportcolumn_trl_uu varchar 36  √  NULL::character varying PA_ReportColumn_Trl_UU
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
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.
w_mailmsg_trl w_mailmsg_trl_uu varchar 36  √  NULL::character varying W_MailMsg_Trl_UU
w_store_trl w_store_trl_uu varchar 36  √  NULL::character varying W_Store_Trl_UU
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_language ad_printpaper_id numeric 10  √  NULL::numeric Printer paper definition
ad_ctxhelpmsg_trl created timestamp 29,6 statement_timestamp() Date this record was created
ad_printformat_trl created timestamp 29,6 statement_timestamp() Date this record was created
c_countrygroup_trl created timestamp 29,6 statement_timestamp() Date this record was created
c_salesregion_trl created timestamp 29,6 statement_timestamp() 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
ad_ctxhelpmsg_trl updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_printformat_trl updated timestamp 29,6 statement_timestamp() Date this record was updated
c_countrygroup_trl updated timestamp 29,6 statement_timestamp() Date this record was updated
c_salesregion_trl updated timestamp 29,6 statement_timestamp() 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