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

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