Requisitions measures
| Measure name | Table name | Source business blass and fields |
|---|---|---|
| Req Count | REQHEADER | REQUISITION_COUNT |
| Req LineCount | REQHEADER | REQ_LINE_COUNT |
| Req Line Value | REQLINE | REQLINE.QUANTITY * REQLINE.UNIT_COST |
| Req Quantity | REQLINE | QUANTITY |
| Req Unit Cost | REQLINE | REQLINE.UNIT_COST |
| Req Return Quantity | REQLINE | REQLINE.RETURN_QTY |
| Req Return Value | REQLINE | REQLINE.RETURN_QTY * REQLINE.UNIT_COST |
| Killed Quantity | REQLINE | REQLINE.KILL_QUANTITY |
| Killed Value | REQLINE | CASE WHEN REQLINE.KILL_QUANTITY > 0 THEN REQLINE.KILL_QUANTITY * REQLINE.UNIT_COST ELSE 0 END |
| Killed Line Count | REQLINE | CASE WHEN REQLINE.QUANTITY = REQLINE.KILL_QUANTITY THEN 1 ELSE 0 |
| Lines To Sourcing Value | REQLINE |
CASE WHEN REQLINE.CREATE_PO_FL = 'Y' THEN CASE WHEN REQLINE.SS_EVENT_REQD = 1 THEN REQLINE.QUANTITY * REQLINE.UNIT_COST ELSE 0 END ELSE 0 |
| Days From Req Creation To Approval | REQLINE |
CASE WHEN REQLINE.APPROVED_FL = 'Y' THEN CASE WHEN REQLINE.APR_REJ_DATE > '1753-01-01 00:00:00.000' THEN CASE WHEN REQLINE.CREATION_DATE = REQLINE.APR_REJ_DATE THEN 1 ELSE DATEDIFF(DD,REQLINE.CREATION_DATE, REQLINE.APR_REJ_DATE) END ELSE 0 END ELSE 0 |
| Days From Req Approval To PO Creation | REQLINE |
CASE WHEN REQLINE.APPROVED_FL = 'Y' THEN CASE WHEN REQLINE.APR_REJ_DATE > '1753-01-01 00:00:00.000' THEN CASE WHEN MIN_PO_DATE.PO_DATE IS NOT NULL THEN CASE WHEN REQLINE.APR_REJ_DATE = MIN_PO_DATE.PO_DATE THEN 1 ELSE DATEDIFF(DD,REQLINE.APR_REJ_DATE, MIN_PO_DATE.PO_DATE) END ELSE 0 |