Report definitions
Report metadata from ZE_ENQ
3 matching rows out of 142 report definitions.
| Key | Description | Table | Selection | Join |
|---|---|---|---|---|
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 |
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 |