（ERPMRP管
理)compiere_erp_applica
tion_dictionary培训
Author Peter
Date 4/20/20049:22PM
Version
ApplicationDictionary
Howisawindowcreated?
AWindownormallycontainsseveralTabs,andATabcontainsseveralFields.
AndATabisbasedona‘Table’,soAFieldinatabisjusta‘Column’ina‘Table’.
SOtheprocesstogenerateawindowisto:
CreateatableintoOracle(OruseanexistingTable)
CreateatableinApplicationDictionary(OruseanexistingTable)
CreateColumnsinApplicationDictionaryforthisTable
CreateAwindowinApplicationDictionary
CreateTabsforthiswindowusingatableinApplicationDictionary
CreatefieldsfortheTab
CreateanewMenuitemandaddawindowmenuintothemenutree
Loginagain,ISTHATWHATYOUWANT?
WhatisTableinApplicationDictionary?
AtableinApplicationDictionarycanbephysicaltableoraviewinoracle.
DBTableName:thenameofphysicaltableorviewinOracle.
View:clickifthisisaviewinOracle.
DataAccessLevel:SystemOnlymeansitsdatacanonlybeaccessedbySystemClient
Client/OrganizationmeansthedatacanbeaccessedbyClient(*)ororganization(GardenWor
ld,HQ)
Organization:thedatacanonlybeaccessedbyorganization(GardenWorld,HQ)
System/Client:thedatacanbeaccessedbySystemClientandClient(GardenWorld,*)
Window:meanswhichwindowusesthistable.
POWindow:
Recorddeleteable:meanstheusercandeleterecordsinthetable
Highvolume:thistablemaycontainshugerecords,sodisplaythesearchdialogfirst
CreateColumnsfromDB:readthetable’sfieldsfromoracleandgeneraterelativecolumns
DBColumnName:thecolumnnameintherealtableorviewinOracle
SystemElement:thisisusedindisplayinglikereport
Reference:thecolumn’sDataType,alsoitdecidewhatthefieldwilllooklikeinthewindow
Validation:seeValidationRule
ReferenceKey:seeReference
DefaultLogic:setadefaultvalueforthiscolumn,ucanuseconstantvaluelike1,orthevalueinCo
ntextlike@AD_Client_ID@,orjustorsqlquerylike@SQL=select…..
KeyColumn:somethinglikeprimarykey
ParentlinkColumn:usedinMaster/Detailtabs,indicatedwithwhichcolumnthedetailtablinkth
eMasterTab
Mandatory:thecolumncannotbenull,otherwise,thesystemwillgiveanerrormessage
Updateable:thevalueofcolumncannotbeupdated,usavethevalueandthenthefieldbecomereadon
ly
ReadOnlyLogic:Inwhichcase,thecolumnisreadonly,itshouldbeBooleanvaluelike1=2
Callout:calloutisasmallpieceofjavacold,calledwhentheuserinitializethewindoworsomeva
lueisedited,forexample:there’re3fieldsinwindow,aprice,aquantity,andanamount,whenev
ertheuserchangethevalueofprice,orQuantity,
nuaddacalloutlikethat:
SelectionColumn:meansthiscolumnisasearchkey,whenupushthesearch:
thenitappendafterthenameanddescription
Attention:The3columnwillbecomesearchkeyautomatically,Value,Name,Description
OK,thenthetableisFinished!
Butbeforethat,umustcheckthese:
Attention:
1,atablemustcontainsuchcolumns:AD_Client_ID,AD_Org_ID,IsActive,Created,C
reatedBy,Updated,UpdatedBy
2,allthecolumnnameiscaseSensitive
ThengoestoTheWINDOW
TheWindowistherealthingushoulddefinetoshow
WindowType:Maintainmeansinthiswindowucancreaterecord,deleterecord,updaterecord
QueryOnlymeansinthiswindowucanonlyviewthedata,nocreating,nodeleting,
Etc
Transaction:transactionisgenerallyusedinsomebusinesstransactionslikesa
lesorderorshipments,oftenithasacolumncalledProcessed,whenprocessed=’Y
’thenthisrecordcannotbeedited
Andthetransactionwindowonlyshowthedatawhichprocessed=’N’andcreatedto
day,andafterupushthehistorybuttonintoolbar,thentheotherdatacanbedispla
yed
Table:whichtableisthetabused,(atabmustdependonatabledefinedintable)
Sequence:thedisplaysequence,fromuptobottom
Tablevel:meanstherelationshipinmaster/detailtabs
Singlerowlayout:thedatawilldisplayedassingleormultirowsbydefault
HasTree:thetabwillshowedwithatree,likethat:
Attention:Itdoesnotmeanatreewilldisplayedautomaticallyifuclickthis,onlys
ometablehastree(M_Product,AD_Menu,C_BPartner,andmore),whichishardcoded
OrderTab:ThisisanexampleofOrderTab:
Process:ucandefineaprocessforthetab,itisnormallyusedforreport
Column:thetable’scolumn,afieldmustdependonacolumn
FieldGroup:thisisafieldgroup:
DisplayLogic:inwhichcasethefieldisdisplayed,ucanuseconstantvaluelike1,orthevalueinC
ontextlike@AD_Client_ID@,orjustorsqlquerylike@SQL=select…..
HeadingOnly:showthefield’snameonly
FieldOnly:showthefield’svalueonly
EverythingseemsOK,nowaddthewindowintotheMenu:
Loginagain,toseewhathappened!
