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 AGENTS ADMINI REPS

ADMINI_REPS

168 items
001 · Chep Reports M

submenu -> CHEPPAL

003 · Outstanding Buyer Returns P

program -> BUYERS_OS_PALLETS

005 · Buyer Purchases by Turnover G

program -> BUYER_PURCH_TRNOVR

010 · Cheque Payment Listing G

program -> CHEQUE_TRANS

012 · STOCK SHEETS MANUAL P

program -> CONSIGN_STOCK_PRT

015 · Refund Authorisation Report G

program -> REFUND_AUTH_REPORT

016 · JD CHEP MONTHLY MOVEMENT G

program -> CHEP_MONTHLY_MOVE

017 · JD CHEP BUYERS OS PALLETS G

program -> BUYERS_OS_PALLETS

018 · JD CHEP WRITEOFF ENQUIRY G

program -> WRITE_OFF_ENQ

020 · New Consignment Listing G

program -> NEW_CONS_LIST

022 · New Consignment Listing by Sales Section G

program -> NEW_CONS_SEC_PTA

025 · New Consignment Listing By Supplier G

program -> NEW_CONS_LIST_SUPPL

030 · Detailed Daily Salesman Report G

program -> DAILY_SMAN_DETAILED

032 · Monthly Market Docket Usage P

program -> MKT_DOC_USAGE

033 · Summarized Daily Salesman Report G

program -> DAILY_SMAN_REPORT

034 · Summ. Daily Sman - NO Comm G

program -> DAILY_SMAN_REPORT_NC

035 · Sales Transaction by Salesman R

report -> SALES_TRANS_BY_SMAN

036 · Sales Summary by Salesman G

program -> SALES_SUMM_BY_SMAN

039 · New Pallet Consign Listing G

program -> NEW_PALL_CONS

040 · Amended Pallet Consign List G

program -> AMENDED_PALL_CONS

045 · Deleted Pallet Consign List G

program -> DELETED_PALL_CONS

050 · Pallet Deliveries Received G

program -> PALL_DELS_RECEIVED

051 · Pallet Deliveries Received- by Supplier G

program -> PALL_DELS_REC_RSA

055 · Cashier Pall Refund Cancel List G

program -> CSH_REF_CANCEL_LIST

060 · Cashier Pall Refund List G

program -> CASHIER_REF_LISTING

070 · Daily Stats - Section Totals G

program -> DAILY_SECTION_STATS

075 · Daily Stats By Item G

program -> DAILY_STATS_ITEM1

077 · DAILY STATS BY ITEM CONTAINER P

program -> DAILY_STAT_ITEM_CONT

080 · Daily Stats By Section G

program -> DLY_STATS_SEC_REV

083 · Regrades Report P

program -> REGRADE_AUDITS

085 · Monthly Stats G

report -> MONTHLY_STATS

090 · Daily Stats By Section OLD R

report -> DAIL_STATS_SECTION

095 · Condesned Buyer Sales Enquiry G

program -> BUYER_TRANS_ENQ_SUMM

100 · Consignment Sales Enquiries G

program -> CONS_SALES_ENQ

115 · Sales Transaction Listing R

report -> SALES_TRANSACTION

120 · Buyer Transactions By Payment Type G

program -> BUYER_TRANS_LISTING

123 · Buyer Sales Tonnage Item Enq P

program -> BUYER_SLS_TON_ENQ

125 · Market Stock G

program -> MKT_STOCK

127 · Market Stock by Product G

program -> MKT_STOCK_PROD

130 · Agents Turnover G

program -> AGENTS_TURNOVER

131 · Market Share by Item G

program -> MKT_SHARE_BY_ITEM

132 · Agent Turnover by Sales Section G

program -> AGENTS_TURNOVER_SECT

133 · Buyer Transaction Dump P

program -> BYR_STATEMENTS_DUMP

135 · Buyer Statements G

program -> BUYER_STATEMENTS

140 · Buyer Statements By Buyer Type G

program -> STATEMENTS_BY_TYPE

145 · Pre Printed Buyer Statements G

program -> BUYER_STATEMENTS_PP

150 · Buyer Statements By Type G

program -> BUYER_STATEMENTS2

155 · Detailed Market Purchases G

program -> MARKET_PURCHASES_DET

160 · Summary Of Market Purchases G

report -> MARKET_PURCHASES

165 · Pallet Sales Listing R

report -> PALLET_SALES

170 · Pallet Summary/Detail G

program -> PALLETS_SOLD

175 · Market Sales Summary G

program -> MARKET_SALES_SUMM

180 · Summary of Sales G

program -> DAILY_SALES_TRANS

182 · Section Sales Summary G

program -> SALES_SECT_SUMMARY

184 · Market section sales summary G

program -> MKT_SECT_SLS_SUMM

185 · Sales Deletion Report G

program -> DEL_SALES_AGENT

190 · Sales Deletion listing by Section G

program -> DEL_SALES_AGN_SSECT

192 · Deleted Sales by Agent G

program -> DEL_SALES_AGENT

195 · Sales Transactions By Cashier R

report -> SALES_TRAN_CASHIER · B~AGENT

196 · Sales Transactions By Cashier - NEW P

program -> SALES_TRANS_LISTING

200 · Print Agent Pallet Returns G

program -> AGN_PALLET_RET

205 · Print Buyers Outstanding Writeoffs G

program -> BUYERS_OS_WRITEOFFS

210 · Saturday Cashier Summary Report G

program -> CASHIER_SUMM_REPORT · B~AGENT

215 · Stock Balance by Consignment R

report -> STOCK_BALANCES

220 · New Stock List By Section,Item R

report -> STK_BAL_BY_SECT_ITEM

225 · Stock Balances by Section and Del no R

report -> STOCK_BALANCES2

230 · Stock Balances By Section Delno (ADMIN) R

report -> STOCK_BALANCES2_NEW

235 · Stock Balances by Delivery Number R

report -> STOCK_BALANCES3

240 · Stock Balances by Item R

report -> STOCK_BALANCES4

245 · Stock Balance By Item (ADMIN) R

report -> STOCK_BALANCES4_NEW

250 · Stock Balances by Supplier Number R

report -> STOCK_BALANCES5

255 · Stock Balances By Supplier No (ADMIN) R

report -> STOCK_BALANCES5_NEW

260 · Stock Balances by Supplier Name R

report -> STOCK_BALANCES6

265 · Stock Balances to Fax G

program -> STK_BAL_TO_FAX

270 · Stock Balance by Supplier Item Container R

report -> STK_BAL_SUP_IT_CONT

275 · Stock Bal By Item Cont Consign R

report -> STK_BAL_IT_CONT_CONS

285 · Debtor Balance Listing R

report -> DEBTOR_LISTING

290 · Fax Supplier Sales G

program -> SUPPL_SALES_TO_FAX · N

295 · Fax Supplier Sales (Bulk Fax) G

program -> SUPPL_SALES_TO_FAX · Y

300 · Fax Supplier Sales SUMMARY G

program -> SUPPLIER_FAX_SUMM

305 · Supplier Sales to Fax Summary by Delno G

program -> SUPPL_FAX_DEL

310 · Suppl Faxe By Delno DATE RANGE G

program -> SUPPL_FAX_DEL_DTE

315 · Suppl Fax Delno Summary OLD G

program -> SUPPL_FAX_DEL_DTE2

320 · Supplier Stock Fax G

program -> SUPPL_STOCK_FAX

500 · Sales By Supplier G

program -> HIST_SALES_BY_SUPP

510 · Sales by Supplier and Product G

program -> HIST_SALES2

520 · Sales Transactions By Buyer R

report -> SALES_TRANS_BY_BUYER

530 · Supplier Listing R

report -> SUPPLIER_LISTING

540 · Buyer Listing R

unknown -> BUYER_LISTING

545 · Condensed Buyer Sales Enquiry G

program -> BUYER_TRANS_ENQ_SUMM

550 · Sales Transactions By Supplier R

report -> SALES_TRANS_BY_SUPPL

560 · Levy Listing G

program -> LEVY_REPORT

570 · Fruit Levy Collection G

program -> FRUIT_LEVIES

580 · Potato Levy Collection G

program -> POTATO_LEVIES

590 · Sales Transactions by Consignment R

report -> SALES_TRANS_CONS

595 · Sales Transactions by Consignment G

program -> SALES_TRANS_CONS2

600 · Cold Storage Stock Listing R

report -> COLD_STORAGE_STK

605 · Cold Storage Transaction Enq by Room G

program -> CS_LISTING_BY_ROOM

610 · Cold Store Transaction Enq by Depositor G

program -> CS_LISTING_BY_DEP

615 · Consignment Enquiry G

program -> CONS_ENQUIRY

620 · Cold Storage Transaction Enquiry G

program -> CS_TRANS_ENQUIRY

625 · Daily Market Prices G

program -> DAILY_MKT_PRICES_RV2

630 · Consign Price Enquiry G

program -> CONS_PRICE_ENQ

635 · Consignment Salesman Enquiry G

program -> CONS_SALESMAN_ENQ

640 · Summarised Price Enquiry By Section G

program -> SUMMARISED_PRICE_ENQ

645 · Amended Consignments G

program -> CONS_AMEND

650 · Pallet Sales G

program -> PALL_SALES

655 · Cashpoint Receipt Analysis G

program -> CASHPNT_REC_ANALYSIS

660 · Head Cashier Balancing G

program -> HEAD_CASHIER_BAL

665 · Agents Balances G

program -> AGENT_BALANCES

670 · Cold Storage Audits G

program -> CS_AUDITS

680 · Stats Combined G

program -> STATS_COMBINED

690 · Tonnage Report By Section/Agent G

program -> TONNAGE_REPORT

700 · Levy Report Summary/Detail G

program -> LEVY_REPORTS2

710 · Discard Audit Report G

program -> DISCARD_AUDITS

720 · Buyer Transactions By Cashier G

program -> BUYER_TRANS_CASHIER

740 · Agent Stock Sheet By Salesman R

report -> AGENT_STOCK_SHEET1

750 · Daily Market Prices G

program -> DAILY_MKT_PRICES_RV2

760 · Agent Stock by Section,Item,Supplier R

unknown -> AGN_STK_SHT_SECT

765 · Agent Stock by Section,Supplier and Item R

unknown -> AGN_STK_SHT_SUPPL

770 · Agent Stock Sheet By Salesman and Item R

report -> AGENT_STOCK_SHEET2

780 · Agent Stock Sheet by Sect and Suppl R

report -> AGN_STK_SHT_SECT_SUP

785 · Agent Sheet by Section Supplier Per Agn R

report -> AGN_STK_SECT_SUP2

790 · Agent Stock By Section and Item R

report -> AGN_STK_SECT_ITEM

795 · Sales Transactions by Sub Buyer R

report -> SLS_TRANS_SUB_BUYER

805 · Supplier Turnover G

report -> SUPPLIER_TURNOVER

810 · Supplier Turnover (Deliv) By Salesman G

program -> SUPPL_TURNOVR_SLSMAN

811 · Supplier Weekly Analysis G

program -> SUPP_WEEKLY_ANALYSIS

815 · Unpaid Sales Report R

report -> UNPAID_SALES_CONS

820 · Regrades Report G

program -> REGRADE_AUDITS

825 · Price Variance Listing G

program -> PRICE_VARIANCE_PERC

830 · Consignment Balances By Item R

report -> STK_SHEET_ITEM

835 · Consignment Balances By Sect/Item R

report -> STK_SHEET_SECT_ITEM

840 · Consign Balance Sect/Item Double Space R

report -> STK_SHT_SCT_ITEM_DBL

850 · Sales Transactions By Item (NEW) G

report -> SALES_TRANS_ITEM

860 · Sales Transaction Listing By Section R

report -> SALES_TRANS_SECT

870 · Tax Invoice Enquiry G

program -> TAXINV_ENQUIRY

880 · Late Sales Transactions Listing R

report -> LATE_SALES_TRANS

890 · Top Suppliers Listing By Turnover G

program -> TOP_SUPPL_TURNOVER

891 · Top Suppliers Listing By Turnover/Area G

program -> TOP_SUPPL_BY_AREA

895 · Top Supplier Turnover by Section G

program -> TOP_SUPPL_TOVER_SECT

897 · Top Supplier by Salesman G

program -> TOP_SUPPL_SMAN

900 · Supplier Detailed Listing G

program -> SUPPL_DETAIL_LISTING

910 · SALES DEL LISTING NEW G

program -> SALES_DEL_LISTING

915 · Top Buyers Report G

program -> TOP_BUYER_TURNOVER

920 · Deviation Code Listing G

program -> DEVIATION_CODE_LIST

925 · Docket Exit Scan Report G

program -> DKT_EXIT_SCAN_CPT

930 · PTA Fax Suppl Sales G

program -> PTA_SUPPL_SALES_FAX

940 · PTA Suppl Sls Fax Summ G

program -> PSUPPLIER_FAX_SUMM

942 · ABSA Buyers CR to SC P

program -> ABSA_BUYERS_CRSC

944 · ABSA Buyers SC to CR P

program -> ABSA_BUYERS_SCCR

950 · PTA Suppl Fax Delno ALL GRNs G

program -> PTA_SUPPL_FAX_DEL

960 · PTA Fax Suppl Delno DATE RANGE G

program -> PSUPPL_FAX_DEL_DTE

961 · RERUN DOCARCH JD G

program -> DOCARCH_RERUN_JD

970 · PTA BUYER STATEMENT BY BUYER NUM G

program -> PTA_STATEMENTS_NUM

972 · Automatic Payment Runs P

program -> PMTS_CHECK_AUTO

980 · PTA STATEMENTS BUY BUYER TYPE G

program -> PTA_STATEMENTS_TYP

985 · Buyer Turnover by Section P

program -> BUYER_TURNOVR_SECT

986 · Stock Balances by Supplier R

report -> STOCK_BALANCES5_NEW

987 · Supplier Item Comparison P

program -> VALUE_OF_STOCK_RSA

988 · Supplier Item Comparison - NEW P

program -> VALUE_OF_STOCK_NEW

990 · JD STATEMENT PTA RERUN G

program -> BUYER_STATEMENTS2

991 · Salesman Audits P

program -> AUD_SLSMAN_ALLOC

994 · CT THERMAL STK SHEET G

program -> CT_STK_SHEET_THERM

995 · STKSHEET THERMAL G

program -> STK_SHEET_THERM

996 · Commodity Listing G

program -> COMM_LIST

998 · Condensed Sales By Sales Section G

program -> BUYER_TRANS_SUMM2

999 · Sales Trans by Sales Section (Summary) P

program -> SALES_TRANS_SLS_SECT

Selected item

840 · Consign Balance Sect/Item Double Space

R report
Menu type
R report launcher · strong signal
Raw launch
STK_SHT_SCT_ITEM_DBL
Resolved key
STK_SHT_SCT_ITEM_DBL
Suffix
none
Security groups
DEV
Before
(none)
After
(none)

Report target

Open report metadata
Description
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM
Base table
STK_DETS
Selection
WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE)
Order
SD_AGENT (B):1 SD_SECT (B):7 SD_ITEM (B):8 SM_SUPP SD_CONSIGN

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:
      
        ADMINI_REPS contains 168 rows.
        
        Row 840 currently resolves as report.