Search results

Create the page "Tables" on this wiki! See also the search results found.

Page title matches

• Screenshot:Tables and Columns
  == '''Tables and Columns''' == Edit tables and columns so that Openbravo can access the database, as well as control t
  11 KB (1,684 words) - 16:49, 26 October 2018
• GL Posting by DB Tables
  290 bytes (39 words) - 22:22, 17 November 2021
• Screenshot:GL Posting by DB Tables
  == GL Posting by DB Tables == ...n and add transactions for the General Ledger, grouped by defined database tables.
  256 bytes (32 words) - 22:15, 18 November 2021

Page text matches

• User Interface Introduction
  ...s based on [http://wiki.openbravo.com/wiki/How_to_Define_a_Table_as_a_Tree tables that have been defined as a tree]. The tree grid view shows the tab data hi ...r not filterable. This can be configured by system administrators in the ''Tables and Columns'' window and there it can be chosen the column of which one wan
  46 KB (7,777 words) - 18:26, 20 November 2021
• How To Create and Package a Module
  * '''Data Package:''' allows you to groups tables together. Data packages are used to determine the Java package generated Ja ...ckage | Data Package]]. Other howto's in the developers guide will add new tables so there is a need to specify a data package as illustrated in the image be
  16 KB (2,503 words) - 20:14, 14 October 2018
• How to add Columns to a Table
  ...en exported into a file in a 'modifiedTables' folder instead of the usual 'tables' to indicate that this module does not create the ''ht_salary'' table but i # In the ''''Tables and Columns'''' window search for the entry of the ''ht_salary'' table.
  10 KB (1,705 words) - 20:22, 14 October 2018
• How to Create a Window
  ...hin that window. To indicate that go to the '''''Application Dictionary || Tables and Columns''''' window, find our HT_Salary table and set the '''Window'''
  9 KB (1,448 words) - 20:28, 14 October 2018
• How to create a Table
  ...[[Tables | Tables]] page. That page explains common columns needed for all tables in Openbravo, naming rules and more important info. ...] or [http://www.toadsoft.com/ Toad] for Oracle) one needs to first CREATE TABLEs that will be used to hold data of the new window/tabs.
  12 KB (1,948 words) - 20:46, 14 October 2018
• How to create a Computed Column
  Defining a computed column is quite easy. Goto the 'Tables and Columns' window to the table in which you want to add the computed colu * If it is a select sql expression then the tables in the from clause all need to use an alias.
  6 KB (1,013 words) - 20:47, 14 October 2018
• How to create a Stored Procedure
  == ''AD_PInstance'' and ''AD_PInstance_Para'' tables ==
  7 KB (1,162 words) - 20:48, 14 October 2018
• How to exclude Database Physical Objects From Model
  Openbravo keeps track of the database physical objects (such as tables, views, functions or triggers) through an utility called [DBSourceManager].
  2 KB (255 words) - 20:50, 14 October 2018
• How to create client side callout onchange function
  ...'''''System Administrator''''' navigate to '''''Application Dictionary || Tables and Columns''''' and find the ''M_Product'' DB Table. This is the underlyin
  12 KB (1,751 words) - 20:51, 14 October 2018
• How to create a Callout
  ...'''''System Administrator''''' navigate to '''''Application Dictionary || Tables and Columns''''' and find the ''M_Product'' DB Table. This is the underlyin
  12 KB (1,751 words) - 20:53, 14 October 2018
• How to implement a new main view
  // Datasources refer to tables using the entity name
  26 KB (3,892 words) - 21:00, 14 October 2018
• Create Invoice Lines From refactor
  # The grids for P&E are based on a HQL tables with HQL insertion points. === New HQL tables used in P&Es ===
  23 KB (3,327 words) - 21:27, 20 November 2021
• Retail:Configuration Guide
  This two tables are designed to simplify the configuration process for the user: if the use
  120 KB (19,264 words) - 01:10, 15 October 2018
• Processes
  ...define a column that references a button. In '''Application Dictionary || Tables and Columns''', go to the column you want to use to execute the process and
  13 KB (1,906 words) - 19:59, 15 October 2018
• How to work with the Data Access Layer
  * Automatically maps new entries in the Application Dictionary to database tables and columns. Direct read access is based on the window access tables, i.e. a user can read all the information of a certain entity if the user h
  57 KB (8,883 words) - 20:17, 15 October 2018
• Main Development Concepts
  ...sql client (eg. pgAdmin, sqlDeveloper) to manage database schema objects (tables, procedures, etc.). Finally developers can develop their own code through a
  9 KB (1,337 words) - 20:19, 15 October 2018
• Openbravo 3 Architecture
  # the module reads the component definition from tables or other sources and instantiates the Component instance.
  28 KB (4,124 words) - 20:37, 15 October 2018
• Data Access Layer
  * Automatically maps new entries in the Application Dictionary to database tables and columns. Direct read access is based on the window access tables, i.e. a user can read all the information of a certain entity if the user h
  57 KB (8,883 words) - 13:59, 1 August 2022
• How to develop a DAL background process
  ...yer which provides mid-tier POJOs through which we can manipulate database tables. If this method is used, your background Java class must ''extend'' the '''
  12 KB (1,715 words) - 20:39, 15 October 2018
• How to create a Pick and Execute Process
  ...''' as your data-source. Note: If you need to mix information from several tables, you have different options: * Go to: Tables and Columns
  11 KB (1,673 words) - 20:41, 15 October 2018
• How to create a Manual UI Process
  * Go to: Tables and Columns
  14 KB (1,927 words) - 20:42, 15 October 2018
• Financial Management
  *[[GL Posting by DB Tables | GL Posting by DB Tables]]
  3 KB (377 words) - 08:26, 18 November 2021
• Financial Management // Receivables & Payables
  *[[GL Posting by DB Tables | GL Posting by DB Tables]]
  4 KB (442 words) - 17:37, 19 October 2018
• How to create a HQL Based Table
  HQL Based Tables must define a HQL select query, that will be used to obtain the proper reco ...a Class Name'' fields. There are two new fields that must be set for these tables:
  9 KB (1,341 words) - 16:26, 22 October 2018
• Goods Receipt
  ...lMgmtShipmentInOut"''' table is set to Active for accounting in the Active Tables tab of the organization's general ledger configuration.
  9 KB (1,500 words) - 12:50, 24 October 2018
• Screenshot:Matched Invoices
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  6 KB (877 words) - 14:06, 24 October 2018
• Screens Reference
  *[[Screenshot:GL Posting by DB Tables|GL Posting by DB Tables]] *[[Screenshot:Tables and Columns|Tables and Columns]]
  16 KB (1,821 words) - 14:04, 24 October 2018
• Screenshot:Sales Invoice
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  34 KB (4,629 words) - 14:06, 24 October 2018
• Screenshot:Goods Shipment
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  16 KB (2,142 words) - 14:07, 24 October 2018
• Screenshot:General Ledger Configuration
  === Active Tables === Active Tables tab allows to define which tables and therefore transactions are going to be post to the ledger and which one
  17 KB (2,163 words) - 14:10, 24 October 2018
• Screenshot:Financial Account
  * '''[[Screenshot:Tables and Columns#Table | Forced_Table_ID]]''' : Hidden column to set the source * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  39 KB (5,162 words) - 02:13, 27 October 2018
• Screenshot:Document Type
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  6 KB (775 words) - 00:46, 26 October 2018
• Screenshot:Amortization
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  10 KB (1,362 words) - 15:45, 26 October 2018
• Audit Trail
  ...ays read-only infromation about all the recorded data changes done in the tables for which the audit trail feature has been enabled. * Enable the audit trail for one or more tables in the system
  10 KB (1,736 words) - 16:34, 26 October 2018
• Screenshot:Audit Trail
  ...ays read-only information about all the recorded data changes done in the tables for which the audit trail feature has been enabled. * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  2 KB (240 words) - 16:41, 26 October 2018
• Screenshot:Tables and Columns
  == '''Tables and Columns''' == Edit tables and columns so that Openbravo can access the database, as well as control t
  11 KB (1,684 words) - 16:49, 26 October 2018
• Screenshot:Module
  The Data Package is a grouping mechanism for tables within a module. Openbravo has a java business object for each Table. The j The corresponding tables have then the following setting:
  9 KB (1,184 words) - 16:45, 26 October 2018
• Screenshot:Windows, Tabs, and Fields
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that * '''[[Screenshot:Tables and Columns#Table Tree Category | Table Tree Category]]''' : Table tree str
  19 KB (2,603 words) - 16:47, 26 October 2018
• Screenshot:Payment In
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  17 KB (2,251 words) - 02:08, 27 October 2018
• ERP/2.50/User Manual/General Setup
  Define access to DB tables and columns for selected roles. Edit a role for which you want to give or withhold tables and columns tables.
  60 KB (9,358 words) - 18:29, 20 November 2021
• Navigation Model Documentation
  ...Field Level rules but are defined on the ''Navigation Rules'' tab of the ''Tables and Columns'' window. They are applied after checking all the field level r
  4 KB (655 words) - 11:41, 29 October 2018
• How to create a navigation rule
  ...level for the Extended Navigation Model are defined in a new tab of the ''Tables and Columns'' window called ''Navigation Rules''
  3 KB (462 words) - 11:37, 29 October 2018
• General Ledger Configuration
  == Active Tables == Active Tables tab allows to define which tables and therefore transactions are going to be post to the ledger and which one
  1 KB (206 words) - 00:07, 19 November 2018
• Screenshot:Physical Inventory
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  9 KB (1,244 words) - 00:10, 19 November 2018
• How to Create a Table Based on a User Defined Datasource
  {{(!)|Tables Based on User Defind Datasources are available in MP24 and later MPs.}} ...e set for tables defined in the application dictionary: 'Tables' (database tables and views) and 'Datasource'. There are two main reasons why to use a dataso
  15 KB (2,037 words) - 07:43, 11 July 2021
• How to implement a new Discount and Promotion Type
  ...ation Dictionary for <code>M_Offer</code> table should be created: go to ''Tables and Columns'' window, look for <code>M_Offer</code> table and click on ''Cr
  10 KB (1,711 words) - 07:48, 11 July 2021
• How to Define a Table as a Tree
  ...[[Tables | Tables]] page. That page explains common columns needed for all tables in Openbravo, naming rules and more important info. ...] or [http://www.toadsoft.com/ Toad] for Oracle) one needs to first CREATE TABLEs that will be used to hold data of the new window/tabs.
  12 KB (1,948 words) - 08:40, 11 July 2021
• How to Create a Tree Selector
  ...penbravo.com/wiki/Selectors Openbravo Selector]. It can only be applied on tables with [http://wiki.openbravo.com/wiki/How_to_Define_a_Table_as_a_Tree trees
  4 KB (665 words) - 08:48, 11 July 2021
• How to Create a Custom Tree
  All the datasources from custom tables must be a subclass of [https://code.openbravo.com/erp/devel/pi/file/tip/mod ...or instance, if the custom tree is going to use the ADTree and ADTree node tables, at this point the ADTree node should be created for the new record.
  8 KB (1,346 words) - 09:43, 11 July 2021
• How To Create a Configuration Script
  ...w objects (such as new windows, tabs, tables, or even columns for existing tables and fields for existing tabs), but they cannot be used to modify existing o
  12 KB (1,918 words) - 09:45, 11 July 2021
• Quick Guide/Business setup
  ...tion please review the [[General_Ledger_Configuration#Active_Tables|Active Tables]] article of the User Guide. ...(tables) for the accounting server process, meaning that those documents (tables) will be skipped during the process.
  93 KB (14,045 words) - 21:03, 16 November 2021
• Development Build Tasks
  * Tables should have a primary key. * Names of tables, columns and constraints are checked for their length (Oracle has a 30 char
  18 KB (2,902 words) - 08:32, 17 November 2021
• Screenshot:Goods Receipt
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  17 KB (2,352 words) - 08:42, 17 November 2021
• Screenshot:Purchase Invoice
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  34 KB (4,628 words) - 08:43, 17 November 2021
• Screenshot:Goods Movements
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  9 KB (1,278 words) - 08:45, 17 November 2021
• Screenshot:Bill of Materials Production
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  10 KB (1,366 words) - 08:45, 17 November 2021
• Screenshot:Internal Consumption
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  9 KB (1,183 words) - 08:46, 17 November 2021
• Screenshot:Return Material Receipt
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  13 KB (1,783 words) - 08:47, 17 November 2021
• Screenshot:Payment Out
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  16 KB (2,227 words) - 08:47, 17 November 2021
• Screenshot:G/L Journal
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  14 KB (1,957 words) - 08:48, 17 November 2021
• Screenshot:Doubtful Debt
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  8 KB (1,050 words) - 08:50, 17 November 2021
• Screenshot:Landed Cost
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  17 KB (2,277 words) - 08:50, 17 November 2021
• Screenshot:Cost Adjustment
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  8 KB (1,050 words) - 08:51, 17 November 2021
• Screenshot:Simple G/L Journal
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  13 KB (1,862 words) - 08:51, 17 November 2021
• Coworking:Screenshot:Purchase Invoice
  * '''[[Coworking:Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  35 KB (4,753 words) - 19:35, 17 November 2021
• Coworking:Screens Reference
  *[[Coworking:Screenshot:GL Posting by DB Tables|GL Posting by DB Tables]] *[[Coworking:Screenshot:Tables and Columns|Tables and Columns]]
  13 KB (1,374 words) - 19:36, 17 November 2021
• ManualDoc:SectionFinancial Management(Openbravo Admin)
  ...nvoices", by using the process [[GL_Posting_by_DB_Tables |GL posting by DB Tables]] ...posted once again by using the [[GL_Posting_by_DB_Tables|GL Posting by DB Tables]] feature.<br> This feature performs a massive posting of all the accountin
  37 KB (5,786 words) - 21:38, 17 November 2021
• Screenshot:Accounting Transaction Details
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  4 KB (581 words) - 22:18, 17 November 2021
• Reset Accounting
  ...d again by using the "Accounting Server Process" or the "G/L Posting by DB Tables" process. The manual changes done for the accounting entries description wi
  544 bytes (80 words) - 22:19, 17 November 2021
• Release Notes/3.0PR17Q2
  ...threads.</li><li><b>Table recreation prevention</b>: in most of the cases, tables are altered to new model without the need of recreating them.</li></ul>
  11 KB (1,523 words) - 07:24, 18 November 2021
• ERP/3.0/Release Changelog
  * {{IssueReference|issuenum=47047}}: Reading tables part of PostgreSQL modelloader could be simplified and speed up ...ssueReference|issuenum=45129}}: Fix name and print name for all columns in tables obsched*
  213 KB (25,772 words) - 07:29, 18 November 2021
• ERP/3.0/API changes
  | Change type to CLOB from Varchar on C_POC_EMAIL* tables body columns | body column in C_POC_EMAIL and C_POC_EMAILDEFINITION tables has its type changed from VARCHAR to CLOB to allow more than 4000 character
  128 KB (17,243 words) - 07:31, 18 November 2021
• Installation/Appliance/Howto
  * You have a big database or there is tables with high numbers of rows.
  23 KB (3,943 words) - 07:41, 18 November 2021
• Screenshot:Accounting templates
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  1 KB (153 words) - 08:46, 18 November 2021
• Window screenshots
  *[[Screenshot:GL Posting by DB Tables]] *[[Screenshot:Tables and Columns]]
  10 KB (979 words) - 22:19, 18 November 2021
• Screenshot:Element
  View tables and columns that a particular application element applies to. * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  6 KB (863 words) - 18:15, 18 November 2021
• Screenshot:Reference
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that * '''[[Screenshot:Tables and Columns#Column | Key Column]]''' : Unique identifier of a record
  20 KB (2,659 words) - 18:16, 18 November 2021
• Screenshot:Validation Setup
  Create and edit the validation setup to be used for columns of tables. Edit the validation setup used for columns of tables.
  1 KB (142 words) - 18:17, 18 November 2021
• Screenshot:Role Access
  Define access to DB tables and columns for selected roles. Edit a role for which you want to give or withhold tables and columns tables.
  2 KB (307 words) - 18:38, 18 November 2021
• Screenshot:Datasource
  * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  3 KB (452 words) - 19:18, 18 November 2021
• Screenshot:GL Posting by DB Tables
  == GL Posting by DB Tables == ...n and add transactions for the General Ledger, grouped by defined database tables.
  256 bytes (32 words) - 22:15, 18 November 2021
• Screenshot:Accounting Schema
  === Account Schema Tables === [[File:WS800041.png|thumb|Account Schema Tables]]
  16 KB (2,001 words) - 22:18, 18 November 2021
• Screenshot:Dataset
  Tables of a dataset. * '''[[Screenshot:Tables and Columns#Table | Table]]''' : A dictionary table used for this tab that
  3 KB (381 words) - 22:21, 18 November 2021
• Configuration changes that affect the Core Module
  ...changes to the Application Dictionary (and therefore, only changes done to tables which belong to the dataset AD) can be exported as a configuration script''
  5 KB (644 words) - 19:06, 20 November 2021
• ERP/2.50/Configuration Manual/Configuration changes that affect the Core module
  ...changes to the Application Dictionary (and therefore, only changes done to tables which belong to the dataset AD) can be exported as a configuration script''
  5 KB (641 words) - 19:06, 20 November 2021
• ERP/2.50/Developers Guide/Concepts/Modularity
  * ''Name'', that will be used in the xml entities of tables assigned to it Registering tables in the AD is the first exception to the general rule. Tables are not assigned directly to a module but to a package in a module. It is n
  63 KB (10,430 words) - 19:07, 20 November 2021
• Modularity Concepts
  * ''Name'', that will be used in the xml entities of tables assigned to it Registering tables in the AD is the first exception to the general rule. Tables are not assigned directly to a module but to a data package in a module. It
  65 KB (10,756 words) - 21:50, 20 November 2021
• How to create a Dataset
  ...he dataset concept, which allows to export the sets of data from different tables in one step. This is especially useful to manage and distribute the module ...set Tables and Dataset Columns. This detailed configuration leads to which tables to be exported, and which columns of each table are executed and exported.
  20 KB (3,347 words) - 14:58, 25 November 2021
• Projects/Modularity/Reference Data
  ...red and conditions for rows (SQL filters) because not all records on these tables are members of the application dictionary metadata. New requirements are ne * to define what columns on these tables are members. Sometimes it is easier to define which columns remove, for exa
  20 KB (3,411 words) - 15:02, 25 November 2021
• Projects/Modularity/Specifications
  ...messages to perform a task that reads and processes information from those tables and shows a message depending on the result. ...se objects'': they are XML files that persist the database physical model: tables, column, constraints, indexes, triggers, views, functions and procedures.
  81 KB (13,101 words) - 15:02, 25 November 2021
• Projects/Translation Management/Language Handling Refactoring
  ...t that entry in other language it's needed to translate it through the TRL tables. #*# Translation process will continue to populate translation tables with complete text data for all artifacts.
  6 KB (995 words) - 15:13, 25 November 2021
• Projects/UUIDs Usage/Functional Specifications
  Currently in Openbravo, database records are identified by one (for some tables it is two) numeric column which is known as ''primary key'' (PK). The value ...work different developers in different projects inserting data in the same tables at once. The way numbers are generated for these identifiers is having a di
  5 KB (825 words) - 15:14, 25 November 2021
• Projects/UUIDs Usage/Technical Documentation
  ...ata primary keys. This will cause the coexistence of the two models in the tables, there will be some records with the UUID primary and other ones with the o ...t all the tables referring to existent values in this one (specially *_TRL tables).
  21 KB (3,304 words) - 15:14, 25 November 2021
• Datasets
  ...reference data for a module, for example tax rates or default data in new tables added by a module. The reference data is packaged, distributed and installe ...defines which tables are exported, the second one which columns from those tables are exported.
  8 KB (1,401 words) - 15:18, 25 November 2021
• Release Notes/3.0PR17Q1
  ...database process dropped foreign key constraints to Application Dictionary tables and looked for deleted referenced records to remove them. This process whic
  11 KB (1,701 words) - 15:25, 25 November 2021
• IDL User Manual
  ...checks data types, mandatory fields and that references to fields in other tables are valid (such as 'Country', 'Region', 'Tax Category', etc).
  32 KB (4,852 words) - 14:54, 29 November 2021
• ERP/2.50/API changes
  | Removed foreign keys in table I_ORDER to C_BPARTNER and M_PRODUCT tables. | Column CALCOST in tables MA_SEQUENCE_EMPLOYEE,MA_SEQUENCE_IC and MA_SEQUENCE_MACHINE has changed fro
  43 KB (6,294 words) - 08:11, 16 December 2021
• Projects/AdvPaymentMngt/Technical Documentation
  {{(!)|All new tables needed on this module will be created in core with the new FIN prefix.}} ...fields, tabs and window will require of the creation of the corresponding tables and columns in the application dictionary. The relation of these new databa
  75 KB (10,832 words) - 08:18, 16 December 2021
• Projects/AdvPaymentMngt/Development Status
  | Table Creation - Column addition to core tables * 11 new tables
  4 KB (521 words) - 08:20, 16 December 2021
• How To Change The Size of a Column
  ...umn size in the '''Application Dictionary'''. For this, we go to the '''''"Tables and Columns"''''' window, find the column definition and specify the new si
  3 KB (454 words) - 09:58, 16 December 2021

View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)