Report definitions
Report metadata from ZE_ENQ
142 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
AGENT_STOCK_LISTING |
AGENT STOCK SHEET BY SALESMAN | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGENT_STOCK_SHEET |
STOCK BALANCES BY SECTION AND DELIVERY | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
AGENT_STOCK_SHEET1 |
AGENT STOCK SHEET BY SALESMAN | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGENT_STOCK_SHEET2 |
CONSIGNMENT STOCK BALANCES BY SALESMAN AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_ENQ_SECT_ITEM |
AGENT STOCK ENQUIRY BY SECTION AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY-SD_PROVQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_PALL_RETURNS |
PALLETS RETURNS BY AGENT | PALL_TRANS | WHERE PT_TRTYPE = 'AR' |
|
AGN_STK_ENQ_SECT |
AGENT STOCK ENQUIRY BY SECTION,ITEM AND SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY-SD_PROVQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_ENQ_SECT_SUP |
AGENT STOCK ENQUIRY BY SECTION, SUPPLIER AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY-SD_PROVQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SCT_ITEM_DBL |
AGENT STOCK SHEET BY SECTION AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SECT_ITEM |
AGENT STOCK SHEET BY SECTION AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SECT_ITEM_MP |
MP AGENT STOCK SHEET BY SECTION AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SECT_SUP2 |
AGENT STOCK SHEET BY SECTION AND SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
agn_stk_sht_sect |
AGENT STOCK SHEET BY SECTION,ITEM AND SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
agn_stk_sht_sect_dur |
AGENT STOCK SHEET BY SECTION,ITEM AND SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SHT_SECT_KIM |
AGENT STOCK SHEET BY SECTION,ITEM AND SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SHT_SECT_PRT |
CONSIGNMENT STOCK BALANCES BY SALES SECT BY ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SHT_SECT_SUP |
AGENT STOCK SHEET BY SECTION, SUPPLIER AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_SHT_SUPL_DBL |
AGENT STOCK SHEET BY SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
agn_stk_sht_suppl |
AGENT STOCK SHEET BY SUPPLIER | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AGN_STK_THERMAL |
AGENT STOCK SHEET BY SECTION - THERMAL | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AG_STK_SECT_ITEM_DUR |
AGENT STOCK SHEET BY SECTION AND ITEM | STK_DETS | 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) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
AG_STK_SHT_SUPPL_DUR |
AGENT STOCK SHEET BY SUPPLIER | STK_DETS | 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) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
buyer_listing |
BUYER LISTING | DEBTOR_MAST | WHERE DA_DEFAULT = 'Y' |
INNER JOIN DEBT_ADDR ON DM_DEBTOR = DA_CODE |
BUYER_PURCHASES_SUM |
BUYER PURCHASES SUMMARY | DEBTOR_MAST | INNER JOIN STK_TRANS ON DM_DEBTOR = ST_DEBTOR AND DM_MARKET = ST_MARKET |
|
BUYER_SALES_ENQUIRY |
BUYER SALES ENQUIRY | DEBTOR_MAST | INNER JOIN STK_TRANS ON DM_MARKET = ST_MARKET AND DM_DEBTOR = ST_DEBTOR |
|
BUYER_SALES_ENQUIRY2 |
BUYER SALES ENQUIRY | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_CSQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY <>0 AND ST_TRTYPE = 'SA' |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO INNER JOIN STK_TRANS ON ST_MARKET = SD_MARKET AND SD_AGENT = ST_AGENT |
BUYER_SALES_ENQUIRY3 |
BUYER SALES ENQUIRY | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON SD_MARKET = PT_MARKET AND SD_AGENT = PT_OWNER AND SD_CONSIGN = PT_CONSIGN AND PT_DELDATE = SD_DATE AND PT_DEBTOR = ST_DEBTOR AND ST_DOCNO = PT_DOCNO AND ST_TRTYPE = PT_TRTYPE |
BUYER_SALES_ENQUIRY4 |
BUYER SALES ENQUIRY | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND = 'N' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
BUYER_TRANSFER |
BUYER TRANSFER ENQUIRY | AUD_DEBTOR_MAST | WHERE ADM_REMARK LIKE '%TFR%' |
LEFT JOIN DEBTOR_MAST ON DM_DEBTOR = ADM_DEBTOR AND DM_MARKET = ADM_MARKET |
cashier_sales_delet |
SALES DELETIONS BY CASHIERS | STK_TRANS | WHERE (ST_TRTYPE = 'DE' OR ST_TRTYPE = 'DT') AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
COLD_STORAGE_BYR |
COLD STORAGE STOCK INCL OTHER DEPOSITS | LOC_TRANS | WHERE LT_TYPE = 'DP' AND (LT_PRQTY_AVAIL > '0' OR LT_PALL_QTY_AVAIL > '0') AND LT_DELIND <> 'Y' AND (NOT ISNULL(LT_DEBTOR) OR LT_DEBTOR <> '') |
LEFT JOIN STK_DETS ON LT_MARKET = SD_MARKET AND LT_AGENT = SD_AGENT AND LT_CONSIGNO = SD_CONSIGN AND LT_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO INNER JOIN LOCATION_MAST ON LM_CODE = LT_LOCA |
COLD_STORAGE_CHARGES |
COLD STORAGE CHARGES | LOC_TRANS | WHERE LT_TYPE = 'IS' |
LEFT JOIN STK_DETS ON LT_MARKET = SD_MARKET AND LT_AGENT = SD_AGENT AND LT_CONSIGNO = SD_CONSIGN AND LT_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
COLD_STORage_enq |
COLD STORAGE STOCK LISTING | LOC_TRANS | WHERE LT_TYPE = 'DP' AND (LT_CHQ_QTY_AVAIL > '0' OR LT_PALL_QTY_AVAIL > '0' OR LT_PRQTY_AVAIL > '0') AND (ISNULL(LT_DEBTOR) OR LT_DEBTOR = '') |
INNER JOIN STK_DETS ON LT_MARKET = SD_MARKET AND LT_AGENT = SD_AGENT AND LT_CONSIGNO = SD_CONSIGN AND LT_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN LOCATION_MAST ON LM_CODE = LT_LOCA |
COLD_STORAGE_ENQ2 |
COLD STORAGE ENQUIRY FOR AGENTS | LOC_TRANS | WHERE LT_TYPE = 'DP' AND (LT_CHQ_QTY_AVAIL > '0' OR LT_PALL_QTY_AVAIL > '0' OR LT_PRQTY_AVAIL > '0') |
INNER JOIN STK_DETS ON LT_MARKET = SD_MARKET AND LT_AGENT = SD_AGENT AND LT_CONSIGNO = SD_CONSIGN AND LT_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO INNER JOIN LOCATION_MAST ON LM_CODE = LT_LOCA |
COLD_STORAGE_STK |
COLD STORAGE STOCK | LOC_TRANS | WHERE LT_TYPE = 'DP' AND (LT_PRQTY_AVAIL > '0' OR LT_PALL_QTY_AVAIL > '0') AND LT_DELIND = 'N' AND (ISNULL(LT_DEBTOR) OR LT_DEBTOR = '') |
INNER JOIN STK_DETS ON LT_MARKET = SD_MARKET AND LT_AGENT = SD_AGENT AND LT_CONSIGNO = SD_CONSIGN AND LT_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN LOCATION_MAST ON LM_CODE = LT_LOCA |
CONSIGNMENT_AUDIT |
CONSIGNMENT AUDIT TRAIL | AUD_STK_DETS | INNER JOIN STK_DETS ON SD_MARKET = ASD_MARKET AND SD_AGENT = ASD_AGENT AND SD_CONSIGN = ASD_CONSIGN AND SD_DATE = ASD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN AUD_STK_MAST ON SD_MARKET = ASM_MARKET AND SD_AGENT = ASM_AGENT AND SD_DELNO = ASM_DELNO AND SD_DATE = ASM_DDATE |
|
CONSIGN_STK_AGN_SECT |
Consignment Stock By Sales Section (By Item) | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
CONSIGN_STK_SSECT |
Consignment Stock By Ssect(By Item) | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' |
LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
CONS_BLOCKED |
BLOCKED CONSIGNMENT LISTING | AUD_STK_DETS | WHERE ASD_AUD_TYPE = 'UPD' AND ASD_BLOCK = 'Y' |
LEFT JOIN STK_DETS ON SD_MARKET = ASD_MARKET AND SD_AGENT = ASD_AGENT AND SD_CONSIGN = ASD_CONSIGN AND SD_DATE = ASD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
CONS_LAZ |
TESTING BY LAZ & CVIG | STK_TRANS | ||
con_list |
CONSIGNMENT LISTING | STK_MAST | WHERE SD_DELIND = 'N' |
INNER JOIN STK_DETS ON SM_MARKET = SD_MARKET AND SM_AGENT = SD_AGENT AND SM_DELNO = SD_DELNO AND SD_DATE = SM_DDATE |
CON_LIST_OLD |
CONSIGNMENT LISTING | STK_MAST | WHERE SD_DELIND = 'N' |
INNER JOIN STK_DETS ON SM_MARKET = SD_MARKET AND SM_AGENT = SD_AGENT AND SM_DELNO = SD_DELNO |
CS_AGENT_DELETIONS |
LIST OF COLD STORAGE AGENT DELETIONS | LOC_TRANS | WHERE LT_DELIND = 'Y' |
LEFT JOIN REASON_MAST ON RSN_REASON = LT_RCODE |
cs_deletions |
COLD STORAGE DELETIONS | LOC_TRANS | WHERE LT_TYPE = 'DE' |
|
CS_LISTING |
CONSIGNMENT LIST BY DELDATE, AGN AND ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
CS_UTILIZATION |
COLD STORAGE UTILIZATION REPORT | CS_QTY_HIST | ||
DAILY_STATS |
DAILY STATS | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y' |
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE |
DAILY_STATS_COMBO |
DAILY STATISTICS FOR COMBINED POTS, TOMS OR ONIONS | STK_DETS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' |
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
DAILY_STATS_GRADE |
DAILY STATISTICS BY GRADE | STK_DETS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND ST_DELIND = 'N' |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
DAILY_STATS_NEW |
DAILY STATISTICS BY ITEM NEW | STK_TRANS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND ST_DELIND = 'N' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE |
DAILY_STATS_REPORT |
DAILY STATISTICS BY ITEM | STK_DETS | WHERE ST_TRTYPE ='SA' AND ST_DELIND <> 'Y' AND ST_PAID = 'Y' |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
DAILY_TONNAGE |
DAILY TONNAGE LISTING | STK_TRANS | LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
|
DAIL_STATS_CONT |
DAILY STATISTICS BY ITEM AND CONTAINER | STK_DETS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' |
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
DAIL_STATS_SECTION |
DAILY STATISTICS BY SECTION | STK_DETS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' |
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
DEBTOR_LISTING |
DEBTOR LISTING | DEBTOR_MAST | ||
DEBTOR_LISTING_ABSA |
ABSA DEBTOR LISTING | DEBTOR_MAST | WHERE DM_ABSA_ACC = "Y" |
|
DELETED_SUPPLIERS |
SUPPLIERS THAT WERE AUTOMATICALLY DELETED | AUD_SUPPLIER_MAST | WHERE ASUM_AUD_TYPE = 'DEL' AND ASUM_AUD_USER = 'AUTOMATIC DELETE' |
|
DELETED_UNPAID_SALES |
LISTING OF DELETED UNPAID SALES | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE |
DELETED_UNPD_SLS |
LISTING OF DELETED SALES | STK_TRANS | WHERE ST_TRTYPE = 'DE' |
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE |
DELETE_CONSIGNMENT |
CONSIGMENTS DELETIONS | AUD_STK_DETS | WHERE ASD_AUD_TYPE = 'DEL' |
INNER JOIN STK_DETS ON SD_MARKET = ASD_MARKET AND SD_AGENT = ASD_AGENT AND SD_CONSIGN = ASD_CONSIGN AND SD_DATE = ASD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
DELIVERY_AMENDMENTS |
DELIVERY AMENDMENTS | AUD_STK_MAST | WHERE ASM_AUD_TYPE = 'INS' OR ASM_AUD_TYPE = 'UPD' |
|
DISCARDED_CONSIGN |
DISCARDED CONSIGNMENT LISTING | STK_TRANS | WHERE ST_TRTYPE IN ('DS','DR') |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
HIST_SALES |
HISTORICAL SALES BY SUPPLIER | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
LATE_SALES_TRANS |
LATE SALES TRANSACTIONS LISTING | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_PAID = 'Y' AND ST_DELIND <> 'Y' AND (ST_TRTIME > ST_UPD_TIME AND ST_TRTIME <= '23:59:59') |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
LEVY_LISTING_BY_AGN |
LEVY LISTING BY AGENT | LEVY_TRANS | INNER JOIN LEVY_MAST ON LVT_LEVYCD = LV_CODE |
|
LEVY_LISTING_SUMMARY |
LEVY LISTING SUMMARY | LEVY_TRANS | INNER JOIN LEVY_MAST ON LVT_LEVYCD = LV_CODE |
|
MARKET_PURCHASES |
MARKET PURCHASES | DEBTOR_MAST | WHERE ST_TRTYPE ='SA' AND ST_DELIND <> 'Y' |
INNER JOIN STK_TRANS ON DM_MARKET = ST_MARKET AND DM_DEBTOR = ST_DEBTOR LEFT JOIN PALL_TRANS ON ST_MARKET = PT_MARKET AND ST_AGENT = PT_OWNER AND ST_CONSIGN = PT_CONSIGN AND ST_DOCNO = PT_DOCNO |
MONTHLY_STATS |
DAILY STATISTICS BY ITEM | STK_DETS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND ST_DELIND = 'N' |
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
NEW_CONSIGN_LISTING |
NEW CONSIGNMENT LISTING | AUD_STK_DETS | WHERE ASD_AUD_TYPE = 'INS' |
INNER JOIN STK_MAST ON ASD_DATE = SM_DDATE AND ASD_DELNO = SM_DELNO INNER JOIN PALL_DETS ON ASD_CONSIGN = PD_CONSIGN AND ASD_DATE = PD_DATE INNER JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL INNER JOIN STK_TRANS ON ASD_CONSIGN = ST_CONSIGN AND ASD_DATE = ST_DELDATE |
NEW_CONS_COMBINED |
NEW CONSIGNMENT SATURDAY AND MONDAY LISTING | AUD_STK_DETS | WHERE ASD_AUD_TYPE = 'INS' |
LEFT JOIN STK_DETS ON SD_MARKET = ASD_MARKET AND SD_AGENT = ASD_AGENT AND SD_CONSIGN = ASD_CONSIGN AND SD_DATE = ASD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
NEW_COSIGN |
NEW CONSIGN | AUD_STK_DETS | WHERE ASD_AUD_TYPE = 'INS' |
LEFT JOIN STK_DETS ON SD_MARKET = ASD_MARKET AND SD_AGENT = ASD_AGENT AND SD_CONSIGN = ASD_CONSIGN AND SD_DATE = ASD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
NEW_COSIGNMENT |
NEW CONSIGNMENT LISTING | AUD_STK_DETS | WHERE ASD_AUD_TYPE = 'INS' |
LEFT JOIN STK_DETS ON SD_MARKET = ASD_MARKET AND SD_AGENT = ASD_AGENT AND SD_CONSIGN = ASD_CONSIGN AND SD_DATE = ASD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
NEW_SUPPLIER_LISTING |
NEW SUPPLIERS LISTING | AUD_SUPPLIER_MAST | WHERE SA_DEFAULT = 'Y' AND ASUM_AUD_TYPE = 'INS' |
INNER JOIN SUPPLIER_MAST ON ASUM_SUPPL = SUM_SUPPL INNER JOIN SUPPL_ADDR ON SUM_SUPPL = SA_CODE |
OUT_PAL_BY_BUYER |
BUYERS OUTSTANDING PALLETS BY AGENT | PALL_TRANS | WHERE PT_TRTYPE = 'SA' AND PT_TRQTY - PT_QTY_RETURNED > 0 |
PALL_TRANS INNER JOIN STK_DETS ON PT_OWNER = SD_AGENT AND PT_CONSIGN = SD_CONSIGN AND PT_MARKET = SD_MARKET AND PT_DELDATE = SD_DATE INNER JOIN DEBTOR_MAST ON DM_DEBTOR = PT_DEBTOR |
PALLET_SALES |
PALLETS SALES LISTING | PALL_TRANS | WHERE PT_TRTYPE <> 'RE' |
INNER JOIN STK_DETS ON PT_MARKET = SD_MARKET AND PT_OWNER = SD_AGENT AND PT_CONSIGN = SD_CONSIGN AND PT_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
REG_CONS_LIST |
REGRADED CONSIGNMENT LISTING | STK_TRANS | WHERE ST_TRTYPE = 'R' |
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
REPRINTED_BUYER_DOCS |
REPRINTS FOR BUYERS DOCKETS | AUD_REPRINTS | WHERE ARP_AUD_TYPE = '03' |
|
REPRINTED_REM_NOTE |
LISTING OF REPRINTED SALES DOCKETS | AUD_REPRINTS | WHERE ARP_AUD_TYPE = '02' |
INNER JOIN STK_TRANS ON ARP_DOCNO = ST_DOCNO INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE |
REPRINT_TAX_INV |
LISTING OF REPRINTED TAX INVOICES | AUD_REPRINTS | WHERE ARP_AUD_TYPE = '01' |
INNER JOIN STK_TRANS ON ARP_DOCNO = ST_TAXINV INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE AND ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT |
RPT_192.9.199.183 |
Consignment Listing | STK_MAST | LEFT JOIN STK_DETS ON SM_MARKET = SD_MARKET AND SM_AGENT = SD_AGENT AND SM_DELNO = SD_DELNO AND SM_DDATE = SD_DATE |
|
RPT_192.9.199.40 |
Consignment Listing | STK_MAST | LEFT JOIN STK_DETS ON SM_MARKET = SD_MARKET AND SM_AGENT = SD_AGENT AND SM_DELNO = SD_DELNO AND SM_DDATE = SD_DATE |
|
SALES_DELETIONS |
SALES DELETIONS | STK_TRANS | WHERE (ST_TRTYPE = 'DE' OR ST_TRTYPE = 'DT') AND ST_PAID = 'Y' AND ISNULL(ST_CHANGED_PRICE) |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
SALES_DELETION_DOCDE |
SALES DELETIONS | STK_TRANS | WHERE ST_TRTYPE = 'DE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
SALES_DELETION_DOCDT |
SALES DELETIONS | STK_TRANS | WHERE ST_TRTYPE = 'DT' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
SALES_DELETION_DOCNO |
SALES DELETIONS | STK_TRANS | WHERE (ST_TRTYPE = 'DE' OR ST_TRTYPE = 'DT') AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
SALES_DEL_KLE |
SALES DELETIONS BY CASHIERS | STK_TRANS | WHERE ST_TRTYPE = 'DE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
SALES_SMAN_COMM |
SALES TRANSACTION LISTING BY SALESMAN COMMISSION | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TFR_DOCNO |
SALES TRANSFERS | STK_TRANS | WHERE ST_TRTYPE = 'DT' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_TRANS ON ST_DOCNO = PT_DOCNO AND ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE |
SALES_TRANSACTION |
SALES TRANSACTION LISTING BY SECTION | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANSACTION_CR |
SALES TRANSACTION LISTING BY SECTION | STK_TRANS | WHERE ST_TRTYPE = 'SA' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
SALES_TRANS_BUYER2 |
SALES TRANSACTION LISTING BY BUYER | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN DEBTOR_MAST ON ST_MARKET = DM_MARKET AND ST_DEBTOR = DM_DEBTOR |
SALES_TRANS_BY_BUYER |
SALES TRANSACTION LISTING BY BUYER | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN DEBTOR_MAST ON ST_MARKET = DM_MARKET AND ST_DEBTOR = DM_DEBTOR |
SALES_TRANS_BY_SMAN |
SALES TRANSACTION LISTING BY SALESMAN | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_BY_SUPPL |
SALES TRANSACTION LISTING BY SUPPLIER | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_CONS |
SALES TRANSACTION LISTING BY CONSIGNMENT | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_TRTYPE <> 'R' AND ST_TRTYPE <> 'DS' AND (ST_DELIND <> 'Y' AND ST_PAID <> 'N') |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_CONS_KIM |
SALES TRANSACTION LISTING BY CONSIGNMENT KIM | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_TRTYPE <> 'R' AND ST_TRTYPE <> 'DS' AND ST_PAID = 'Y' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE INNER JOIN SUPPLIER_MAST ON SUM_SUPPL = SM_SUPP |
SALES_TRANS_CONS_PR |
SALES TRANSACTION LISTING BY ITEM | STK_TRANS | WHERE ST_TRTYPE IN ('SA', 'DE', 'DT') |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_ITEM |
SALES TRANSACTION LISTING BY SECTION | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_SECT |
SALES TRANSACTION LISTING BY SECTION | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_TAXINV |
SALES TRANSACTION LISTING BY TAX INVOICE | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRANS_VARIENCE |
SALES TRANSACTION VARIANCE PRICE LISTING | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' AND ST_VAROR = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRAN_CASHIER |
SALES TRANSACTION BY CASHIER | STK_TRANS | WHERE ST_TRTYPE IN ('SA','DE','DT') AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SALES_TRAN_CASHIER_P |
PALLET SALES TRANSACTION BY CASHIER | PALL_TRANS | WHERE PT_TRTYPE IN ('SA','DE','DT','BR') |
INNER JOIN STK_DETS ON PT_MARKET = SD_MARKET AND PT_OWNER = SD_AGENT AND PT_CONSIGN = SD_CONSIGN AND PT_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SLS_TRANS_BUYER_TIME |
SALES TRANSACTION BY BUYER BY TIME | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN DEBTOR_MAST ON ST_MARKET = DM_MARKET AND ST_DEBTOR = DM_DEBTOR |
SLS_TRANS_SUB_BUYER |
SALES TRANSACTIONS LISTING BY SUB BUYER | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' AND DM_MAIN_DEBTOR <> '' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN DEBTOR_MAST ON ST_MARKET = DM_MARKET AND ST_DEBTOR = DM_DEBTOR |
STATS |
STATS | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND <> 'Y' |
INNER JOIN STK_DETS ON ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE |
STK_BAL_BY_SECT_ITEM |
STOCK BAL BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_BAL_IT_CONT_CONS |
STOCK BALANCE BY ITEM CONT CONSIGN | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL |
stk_bal_sect_kle |
CONSIGNMENT STOCK BALANCES BY SECTION | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_BAL_SECT_KLE2 |
CONSIGNMENT STOCK BALANCES BY SECTION | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_BAL_SUP_IT_CONT |
Stock Balance By Supplier Item Cont | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' AND ISNULL(SD_CDATE) AND ISNULL(SM_FINPDTE) |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL |
STK_DISCARD_SUPPLIER |
DISCARD REPORT BY SUPPLIER | STk_TRANS | WHERE ST_TRTYPE = 'DS' |
inner join `stk_dets` on sd_consign = st_consign inner join stk_mast on sd_delno = sm_delno inner join supplier_mast on sm_supp = sum_suppl |
STK_END_VAR |
STOCK VARIANCE REPORT | STK_DETS | WHERE ST_TYPE = 'L' |
LEFT JOIN STK_TRANS ON SD_DOCNO = ST_DOCNO AND SD_SEQ = ST_SEQ |
STK_SCT_ITEM_DUR_ADM |
AGENT STOCK SHEET BY SECTION AND ITEM | STK_DETS | 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) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHEET_ITEM |
CONSIGNMENT STOCK BALANCES BY ITEM | STK_DETS | WHERE (SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 OR PD_RECQTY-PD_SLDQTY-PD_DISQTY-PD_RETQTY-PD_ADJQTY-PD_RRQTY > 0) AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHEET_SECT_ITEM |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHEET_SECT_ITEM2 |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHT_SCT_ITEM_DBL |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHT_SECT_ITM_KIM |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHT_SECT_ITM_KL2 |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHT_SECT_ITM_KLE |
CONSIGNMENT STOCK BALANCES BY SECTION AND ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHT_SECT_SUP_DUR |
AGENT STOCK SHEET BY SECTION, SUPPLIER AND ITEM | STK_DETS | 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) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_SHT_SUP_DUR_DBL |
AGENT STOCK SHEET BY SUPPLIER | STK_DETS | 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) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_TAKESHEET |
STOCK TAKE SHEET | STK_DETS | WHERE SD_DELETE = 'N' AND SC_DELIND = 'N' |
LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET ANS SD_AGENT = SD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STK_TAKE_SHEET |
STOCK TAKE SHEET | STK_DETS | WHERE ST_TYPE = 'L' AND (ST_QTY <> 0 OR SD_PQTY <> 0 OR SD_PQTY_1 <> 0) |
LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE LEFT JOIN PALL_TRANS |
STOCK_BALANCES |
CONSIGNMENT STOCK BALANCES BY CONSIGNMENT | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY-SD_RRQTY > 0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) |
INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
STOCK_BALANCES2 |
STOCK BALANCES BY SECTION AND DELIVERY | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
STOCK_BALANCES2_NEW |
STOCK BALANCES BY SECTION AND DELIVERY | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE=SM_DDATE |
STOCK_BALANCES3 |
STOCK BALANCES BY DELIVERY NUMBER | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <> 0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
STOCK_BALANCES4 |
STOCK BALANCES BY ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
STOCK_BALANCES4_NEW |
STOCK BALANCES BY ITEM | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
STOCK_BALANCES5 |
STOCK BALANCES BY SUPPLIER NO | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO |
STOCK_BALANCES5_NEW |
STOCK BALANCES BY SUPPLIER NO | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND ISNULL(SD_CDATE) AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SM_DDATE = SD_DATE LEFT JOIN PALL_DETS ON SD_MARKET = PD_MARKET AND SD_AGENT = PD_AGENT AND SD_CONSIGN = PD_CONSIGN AND SD_DATE = PD_DATE |
STOCK_BALANCES6 |
STOCK BALANCES BY SUPPLIER NAME | STK_DETS | WHERE SD_RECQTY-SD_SLDQTY-SD_DISQTY-SD_RETQTY-SD_ADJQTY <>0 AND SD_DELIND <> 'Y' AND SD_BLOCK <> 'Y' |
LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO LEFT JOIN SUPPLIER_MAST ON SM_SUPP = SUM_SUPPL |
STOCK_RSV_CHANGE |
STOCK RESERVATIONS QTY/ PRICE CHANGES | STK_TRANS | WHERE ST_TRTYPE IN ('SA') AND (ST_TRPRICE <> ST_ORIG_TRPRICE OR ST_TRQTY <> ST_ORIG_TRQTY) AND (ST_ORIG_TRPRICE > 0 OR ST_ORIG_TRQTY > 0) |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE INNER JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SUB_SALES_ENQUIRY |
BUYER SALES ENQUIRY | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_DELIND = 'N' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
SUPPLIER_LISTING |
SUPPLIER LISTING | SUPPLIER_MAST | WHERE SA_DEFAULT = 'Y' AND SUM_DELIND = 'N' |
INNER JOIN SUPPL_ADDR ON SUM_SUPPL = SA_CODE |
SUPPLIER_TURNOVER |
SUPPLIER TURNOVER | STK_TRANS | WHERE ST_TRTYPE <> 'RE' AND ST_PAID = 'Y' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |
TOMATOE_STATS |
TOMATO LISTINGS | STK_DETS | WHERE ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' AND ST_TRTYPE ='SA' AND SD_ITEM LIKE 'TO%' |
LEFT JOIN STK_TRANS ON SD_MARKET = ST_MARKET AND SD_AGENT = ST_AGENT AND SD_CONSIGN = ST_CONSIGN AND SD_DATE = ST_DELDATE |
UNCONFIRMED_CS_DEP |
UNCONFIRMED COLD STORAGE DEPOSITS | LOC_TRANS | WHERE LT_CONFIRMED <>'Y' AND LT_TYPE ='DP' AND LT_DELIND <>'Y' AND LT_PRQTY_AVAIL <> 0 AND LEFT(LT_DEPNO,1) <> 'D' |
|
UNPAID_SALES |
LISTING OF UNPAID SALES | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_PAID = 'N' AND ST_DELIND <> 'Y' |
INNER JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE AND ST_AGENT = SD_AGENT LEFT JOIN PALL_TRANS ON ST_CONSIGN = PT_CONSIGN AND ST_DELDATE = PT_DELDATE AND PT_MARKET = ST_MARKET INNER JOIN DEBTOR_MAST ON ST_DEBTOR = DM_DEBTOR |
UNPAID_SALES_CONS |
UNPAID SALES TRANSACTION LISTING BY CONSIGNMENT | STK_TRANS | WHERE ST_TRTYPE = 'SA' AND ST_PAID <> 'Y' AND ST_DELIND <> 'Y' |
LEFT JOIN STK_DETS ON ST_MARKET = SD_MARKET AND ST_AGENT = SD_AGENT AND ST_CONSIGN = SD_CONSIGN AND ST_DELDATE = SD_DATE LEFT JOIN STK_MAST ON SD_MARKET = SM_MARKET AND SD_AGENT = SM_AGENT AND SD_DELNO = SM_DELNO AND SD_DATE = SM_DDATE |