Internal
Freshmark Metadata
Relevant Programs
Freshmark menu and program clues for top-buyer reports.
| Program | Description | Type | Source | Menu Locations |
|---|---|---|---|---|
BUYER_PURCH_TRNOVR |
BUYER PURCH TURNOVER | DSP | STK_TRANS |
ADMINI_REPS #005: Buyer Purchases by Turnover
|
BUYER_TURNOVER |
BUYERS TURNOVER | DSP | STK_MAST |
No menu entry found
|
TOP_BUYERS_TOVER |
TOP BUYERS BY TURNOVER LISTING | DSP | STK_MAST |
No menu entry found
|
TOP_BUYER_TURNOVER |
TO BUYERS LISTING BY TURNOVER | DSP | STK_MAST |
ADMINI_REPS #915: Top Buyers Report
DBUYER #375: Top Buyers Listing By Turnover
STATSE #740: Top Buyers Listing
|
TOP_BYR_TURN_SECT |
TO BUYERS BY TURNOVER BY SECTION | DSP | STK_MAST |
No menu entry found
|
Portal Metric Sources
How this portal traces visible values back to Freshmark.
| Metric | Source | Note |
|---|---|---|
| Turnover | fms.stk_trans.ST_TRPRICE * ST_TRQTY + ST_TRVAT |
Summed line value for valid sale rows. |
| Quantity | fms.stk_trans.ST_TRQTY |
Summed for valid sale rows. |
| Buyer | fms.debtor_mast.DM_MAIN_DEBTOR / DM_NAME |
Ranks by main debtor account, then names that main account. |
| Buyer group | fms.buyer_group |
Labels ST_BUY_GRP and DM_GROUP values. |
| Product section | fms.sect_mast |
Labels ST_PROD_SECT values. |
| Address/contact | fms.debt_addr |
Default physical address rows first. |
| Card breakdown | fms.stk_trans.ST_DEBTOR / ST_CARDNO |
Shows card accounts rolled into the selected main account. |