Freshmark replication server

freshmark-canonical

Metadata-driven navigation

Menu simulator

Browse the live menu model from ZM_MENU, inspect what each item resolves to, and preview report-backed entries against the replicated data schema when live access is enabled.

Menu controls

108 menus
MAINMENU STOCK REPORTS

STOCK_REPORTS

14 items
030 · Consignment stock balances by Item R

report -> STK_SHEET_ITEM

040 · Consignment stock balances by Sect/Item R

report -> STK_SHEET_SECT_ITEM

041 · Stock Balances by Sect/Item Welkom R

report -> STK_SHEET_SECT_ITEM2

050 · Consign stk bal by Sect/Item (Double ln) R

report -> STK_SHT_SCT_ITEM_DBL

060 · Agent stock by Section, Item, Supplier R

unknown -> AGN_STK_SHT_SECT_DUR

070 · Agent stock by Section, Supplier, Item R

report -> AG_STK_SHT_SUPPL_DUR

080 · Agent stock by Section, Item R

report -> AG_STK_SECT_ITEM_DUR

100 · Stock Sheets G

program -> CONSIGN_STOCK_PRT

30 · Agent Stock By Sect,Item (Double ln) R

report -> AGN_STK_SCT_ITEM_DBL

32 · Stock Balance By Item,Cont,Consignment G

report -> STOCK_BALANCES

33 · Agent Stock by Sect,Supl,Item(Double Ln) R

report -> STK_SHT_SUP_DUR_DBL

34 · Agent Stock Sheet Sect and Item DUR ADM R

report -> STK_SCT_ITEM_DUR_ADM

35 · Static cons G

program -> STATIC_CONS

37 · wholesale G

program -> WHOLESALE_STATS_SCRN

Selected item

080 · Agent stock by Section, Item

R report
Menu type
R report launcher · strong signal
Raw launch
AG_STK_SECT_ITEM_DUR
Resolved key
AG_STK_SECT_ITEM_DUR
Suffix
none
Security groups
DEV, COC, CCC, CAC, AGF
Before
(none)
After
(none)

Report target

Open report metadata
Description
AGENT STOCK SHEET BY SECTION AND ITEM
Base table
STK_DETS
Selection
WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE)
Order
SD_SECT SD_ITEM (B):2 SD_DATE

Report preview

Runs a limited SELECT * preview against the configured data schema.

No preview has been executed yet.

        
      

      
    

    
    
  


  

    

      
How it works

      1869 rows mapped
    


    

      The simulator follows the Freshmark metadata chain instead of hard-coded routes. Each click starts with
      ZM_MENU, resolves the launch target, and then cross-references the matching program or report definition.
    


    

      

        
Menus

        108
        distinct ZM_KEY groups
      

      

        
Programs

        1763
        from ZP_PGMS
      

      

        
Reports

        142
        from ZE_ENQ
      

    


    

      

        1
        Load menu rows
        
Read ordered entries from ZM_MENU for the chosen ZM_KEY.

      

      
resolve

      

        2
        Parse launch target
        
Split ZM_PGM into a base key plus any launch suffix.

      

      
cross-reference

      

        3
        Classify the item
        
Match the base key to a submenu, a program in ZP_PGMS, or a report in ZE_ENQ.

      

      
inspect

      

        4
        Open detail or preview
        

          Submenus expand the tree, programs show metadata, and reports can run a limited live preview
          
          against replicated data.
          
        

      

    


    

      

        
submenu

        Another menu key
        
The simulator treats the target as a new ZM_KEY and lets you walk deeper into the tree.

      

      

        
program

        Runtime screen or workflow
        
Program-backed items resolve through ZP_PGMS and field metadata in ZX_PGMS_FIELDS.

      

      

        
report

        Queryable report definition
        
Report-backed items resolve through ZE_ENQ and can expose the base table, filters, and preview SQL.

      

    


    

      
      7 codes observed
    


    

      These are the one-letter codes from ZM_MENU.ZM_TYPE. Where the meaning is still inferred rather than proven,
      the legend says so explicitly.
    


    

      
      

        

          M
          

            submenu launcher
            
Observed rows mostly open another menu key and this is the clearest confirmed submenu marker.

          

        

        

          117 rows
          confirmed
        

        
Observed mix: 114 submenus, 3 unknowns.

      

      
      

        

          P
          

            program launcher
            
Most rows resolve to program screens or workflows in ZP_PGMS.

          

        

        

          763 rows
          strong signal
        

        
Observed mix: 751 programs, 8 reports, 4 unknowns.

      

      
      

        

          G
          

            program-heavy launcher
            
Usually resolves to programs, but a small number of rows also point at reports.

          

        

        

          698 rows
          working inference
        

        
Observed mix: 679 programs, 17 reports, 2 unknowns.

      

      
      

        

          R
          

            report launcher
            
Most observed rows resolve directly to ZE_ENQ report definitions.

          

        

        

          208 rows
          strong signal
        

        
Observed mix: 1 program, 196 reports, 11 unknowns.

      

      
      

        

          A
          

            action-style program launcher
            
Observed rows currently resolve to programs, often with extra launch suffixes or action wrappers.

          

        

        

          73 rows
          working inference
        

        
Observed mix: 73 programs.

      

      
      

        

          E
          

            enquiry or report launcher
            
Rare in the snapshot, but current rows resolve to report-style enquiry definitions.

          

        

        

          5 rows
          strong signal
        

        
Observed mix: 5 reports.

      

      
      

        

          X
          

            external executable
            
Observed rows launch Windows executables instead of Freshmark metadata targets.

          

        

        

          5 rows
          confirmed
        

        
Observed mix: 5 unknowns.

      

      
    


    

      Current path:
      
        STOCK_REPORTS contains 14 rows.
        
        Row 080 currently resolves as report.