  RSE,      

   ,     .
     ,  .
    :

 -      (0 -   ).
 -   (grp, const, an, ref, agr) (. ).
  grp -  ,      
  const - ,     ( )
  an - ,      ( )
       (        )
  ref - ,     (. )
  agr - ,   ,  
          sum, count, max, min, avg ( )

 -  ,    .
 -   (,    ACDFGILMNOPQRSTUWZ).
           .
       . 
 
  "grp"     .

:
0,grp,"Period",S

       :

 -    SQL 
 -   ,    (sum, count, max, min, avg)

   ,      .

  "const":

 -  ,  .
        ( )

:
1,const,"Begin Date",SD,DATEBEGIN,,"'01.08.2001'"
0,const,"Product ID",,PRODCODE,,5466
0,const,"",S,OK

  "an":

 -       SQL.
        ( )

:
0,an,"Object ID",,OBJECTID,,CTSC
0,an,"Product ID",,PROD

  "ref":

 -  ,       
 -   (Q, U, S, G, M)
  Q -  SQL 
  U -     UNIVERS
  S -     SYSS
  G -     SYSGRP
  M -     STRGRP
   -  ,    :
 "Q":
 -    ,      
 "U":
 -   UNIVERS,      
 "S":
 -   SYSS,      
 -   TIP  SYSS
 -   COD  SYSS
 "G":
 -   (TMS_SYSGR.ID0) -     ()
    ().       
  NVL(SYS_CONTEXT('ENVUN4','ID0$'||:CLASS),0) ( :CLASS -  )
 -   (0..5),   0 (  )
    (1..5)      ,
    ,     , 
    .
          ,
        ,   .
 "M":
 -   (1..29).    ,  STRGRPCOD
 - : 0    CLC_ID_ITEM, 1 - ID_MASK, 2 - ID_ITEM

     "Q"      ,
    (      ),
        .

     "G"      
       SC, DEP  SC1 - 
        
          .

:
1,ref,"Pret. Fapt",S,PRET_FAPT,,"CANT_FAPT,SUMA_FAPT",Q,"DECODE(CANT_FAPT, 0, 0, SUMA_FAPT / CANT_FAPT)"
1,ref,"Object Code",S,CODVECHI,,CTSC,U,CODVECHI
1,ref,"",S,ATRIBUT,,CTSC,S,DENUMIREA,C,4

2,ref,"SC|",MW{20},SC_NODE,,SC,G,SC
2,ref,"SC|",MW{20},SC_NODE1,,SC,G,SC,1
2,ref,"SC|",MW{20},SC_NODE2,,SC,G,SC,2

2,ref,"SC|",MW{20},SC_MASK,,SC,M
2,ref,"SC|- 1",MW{20},SC_MASK1,,SC,M,1
2,ref,"SC|- 2",MW{20},SC_MASK2,,SC,M,2
2,ref,"SC|- 3",MW{20},SC_MASK3,,SC,M,3

  "agr":

 -    SQL (sum, count, max, min, avg)
        "an"

---------------------------------------------------------------------
 

       ,   
(,  C  G)      

S (Selected) ,        
            

C (Collapsed) ,       
        (c)  :  

G (Grouped)  ,        
        (g)  :  

D (Disabled) ,    Selected   

 SCG     ,  
      (   Selected,
    Disabled   )

    Master/Detail      
  :
- Master- (      )
-   (      )
- Detail- (      )
Master-    Master-, Detail-  
 Detail-,        .

M (Master) ,     Master   ( )
O (Master only) ,      Detail  
A (Aggregate) ,     ( )

      Master/Detail    
.  M   ,     ,
    (, ).    
   A,         Detail
 .  G     MA ,   
  Master ,      .

P (Protected) ,         
   ,   . .,      .
           .
   P  ,       .

R (Aggregate referential)      ref  ,
   SQL-   .     Q.

Z (Z-A sort order) ,       
     .

-   ,      ,
      : XX{x}XXX{xx,xxx,xxx}XX

F (Filter)     -  ,   
   Where clause       (  S)
        ,  RSE

I (Input filter)     -  ,  
    Where clause    .   
      S (   )

Q (Query type)   ,    
    (    ).
      ,     
     USQACILD.   :
  U -        ,
         : Q{U,O,R}  Q{U,P,'2111,2161'}
  S -        ,
         : Q{S,Y,201}
  Q -        . 
          ,    
          -     :
      Q{Q,"SELECT ID1,TEXT,P1,P2 FROM VMS_UNIVTREE1 WHERE ID0=1",TEXT,ID1}
  A -  .   ,   
           .      DT,
        Q{A}    "=5211":   "DT =5211"
  C -       .      DT,
        Q{}    "22 52":  
      "(DT BETWEEN 2200 AND 2299 OR DT BETWEEN 5200 AND 5299)"
  I -      ,  .
           DT,   Q{I}   
      "2111,2161":   "DT IN(2111,2161)"
  L -    ,    .
           DENUMIREA,   Q{L}   
      "SRL":   "DENUMIREA LIKE '%SRL%'"
  D -    ,   
      
      ,      U.
    : "Q{U,O,R}U{1297,1299}", "Q{C}U{22 52}".
    D: "Q{D}U{31.12.2003}"  "Q{D}U{01.01.2003-31.12.2003}" - 
     ,   .

N (Null value)  " " -   NULL
     DATE    N{'1/1/1'}
L (Link list)   ,     
V (Variations)   ,   E, M, R
W (Width)   ( )   
T (Format)     
U (User data)   ,   

 FIQNLVWTU      .
,   ,  CTDATA='24.04.2002'  
  SF{CTDATA='24.04.2002'}.  .   
 Master/Detail   NVL, : NVL(CONT, 0) = NVL(:CONT, 0)
     DATE,    NVL  ,
      DATE (, '1/1/1')
 L      ,  
      ,    .
,      ,     
.     SUMAVALDT  L{VALUTADT}.  
  VALUTADT    SUMAVALDT.    
 ,        .
 V      RSE, 
     (     )
 W  T      .
  U    property AnsiString UserData.

---------------------------------------------------------------------

:
1,agr,"Cantitatea",SD,CANT_PROD
1,agr,"Suma Plan",SD,SUMA_PLAN,SUM

 :

    ,   :
0,grp,"Period"
1,const,"Begin Date",SD,DATEBEGIN,,"'01.08.2001'"
1,const,"Final Date",SD,DATEFINAL,,"'31.08.2001'"

          :
0,an,"Object ID",D,CTSC
1,ref,"Object Code",S,CODVECHI,,CTSC,U,CODVECHI
1,ref,"Object UM",S,UM,,CTSC,U,UM
1,ref,"Object Text",S,CTSCT,,CTSC,U,DENUMIREA__1

    (Plan  Fapt)   :
0,grp,"Plan",S
1,agr,"Cant Plan",S,CANT_PLAN
1,agr,"Pret Plan",S,PRET_PLAN
1,agr,"Suma Plan",SD,SUMA_PLAN,SUM
0,grp,"Fapt",S
1,agr,"Cant Fapt",S,CANT_FAPT
1,ref,"Pret Fapt",S,PRET_FAPT,,,Q,"DECODE(CANT_FAPT, 0, 0, SUMA_FAPT / CANT_FAPT)"
1,agr,"Suma Fapt",SD,SUMA_FAPT,SUM
