compiere_erp_application_dictionary培训.docVIP

Author Peter Date 4/20/2004 9:22 PM Version 0.1 Application Dictionary How is a window created? A Window normally contains several Tabs, and A Tab contains several Fields. And A Tab is based on a ‘Table’, so A Field in a tab is just a ‘Column’ in a ‘Table’. SO the process to generate a window is to: Create a table into Oracle (Or use an existing Table) Create a table in Application Dictionary (Or use an existing Table) Create Columns in Application Dictionary for this Table Create A window in Application Dictionary Create Tabs for this window using a table in Application Dictionary Create fields for the Tab Create a new Menu item and add a window menu into the menu tree Login again, IS THAT WHAT YOU WANT? What is Table in Application Dictionary? A table in Application Dictionary can be physical table or a view in oracle. DB Table Name: the name of physical table or view in Oracle. View: click if this is a view in Oracle. Data Access Level: System Only means its data can only be accessed by System Client Client/Organization means the data can be accessed by Client(*) or organization (GardenWorld, HQ) Organization: the data can only be accessed by organization (GardenWorld, HQ) System/Client: the data can be accessed by System Client and Client (GardenWorld, *) Window: means which window uses this table. PO Window: Record deleteable: means the user can delete records in the table High volume: this table may contains huge records, so display the search dialog first Create Columns from DB: read the table’s fields from oracle and generate relative columns DB Column Name: the column name in the real table or view in Oracle System Element: this is used in displaying like report Reference: the column’s Data Type, also it decide what the field will look like in the window Validation: see Validation Rule Reference Key: see Reference Default Logic: set a def