Purchasing measures
| Measure name | Table name | Source field |
|---|---|---|
| Average Lines per PO | PURCHORDER | POLineCount / POCount |
| Average Quantity per PO Line | PURCHORDER, POLINE | POLINE.QUANTITY/PURCHORDER.POLINECOUNT |
| Average Receipt Lines per Receipt Header | PURCHORDER | ISNULL(RECEIPTSBYPO.REC_LINE_COUNT, 0) /PURCHORDER.ReceiptHeaderCount |
| Average Receipts per PO | PURCHORDER, POLINE | POLINE, POLINE.CXL_QTY =POLINE.QUANTITY ANDPLI.ITEM_TYPE <> 'S' THEN 1ELSE 0 /PURCHORDER.POCOUNT |
| Average Unit Cost per Purchase | POLINE, PURCHORDER | POLINE.ENT_UNIT_CST/PURCHORDER.POLineCount |
| Average Value per PO Line POLINE | POMESSAGE | POLINE.EXTENDED_AMT /PURCHORDER.POLineCount |
| Buyer Messages Count | PURCHORDER | when related record in PurchaseOrderBuyerMessage exists |
| Cancel Quantity | POLINE | CASEWHENPOLINE.CXL_QTY= POLINE.QUANTITY THENPLI.QUANTITY ELSE POLINE.CXL_QTY |
| Canceled Line Count | POLINE | CASEWHENPOLINE.CXL_QTY= POLINE.QUANTITY THEN 1ELSE 0 |
| Entered Unit Cost | POLINE | POLINE.ENT_UNIT_CST |
| Entered Unit Cost Per StockUOM | POLINE | POLINE.ENT_UNIT_CST / CASEWHEN POLINE.EBUY_UOM_MULT = 0THEN 1 ELSE POLINE.EBUY_UOM_MULT |
| Extended Receipt Value | POLINE | POLINE.REC_QTY *ENT_UNIT_CST |
| Extended Rejected Value | POLINE | POLINE.REJECT_QTY *PLI.ENT_UNIT_CST |
| Invoiced PO Line Count | POLINE | when InvoiceDetailExists |
| Landed Unit Cost | POLINE | POLINE.LAND_UNIT_CST |
| Lines Not Shipped Complete | POLINE | CASE WHEN PLI.REC_QTY <POLINE.QUANTITY THEN 1ELSE 0 |
| Lines Shipped Complete | POLINE | CASE WHEN PLI.REC_QTY =POLINE.QUANTITY THEN 1ELSE 0 |
| Matched Amount | POLINE | POLINE.MATCHED_AMOUNT |
| Matched PO Line Count | POLINE | CASE WHEN (POLINE.MATCHED_QTY >= (POLINE.QUANTITY - POLINE.CXL_QTY)) |
| Matched Quantity | POLINE | POLINE.MATCHED_QTY |
| Matched Quantity In Stock UOM | POLINE | POLINE.EBUY_UOM_MULT *POLINE.MATCHED_QTY |
| Matched Unit Cost | POLINE |
CASE WHEN PLI.MATCHED_QTY <> 0 THENPOLINE.MATCHED_AMOUNT /POLINE.MATCHED_QTY ELSE0 |
| Off Agreement Line Count | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 [Off Agreement Line Count] = 0 IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [Off Agreement Line Count] = 1 |
| Off Agreement Quantity | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [Off Agreement Quantity]= 0 IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [Off Agreement Quantity] = [PurchaseOrderLine.QUANTITY] |
| Off Contract Value | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [On Contract Value] =[PurchaseOrderLine.EXTENDEDAMOUNT] IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [Off Contract Value] = [PurchaseOrderLine.EXTENDEDAMOUNT] |
| On Contract Quantity | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [On Contract Quantity]= [PurchaseOrderLine.QUANTITY] IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [On Contract Quantity] = 0 |
| On Contract Value | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [Off Contract Value] =0 IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [On Contract Value] = 0 |
| On Order Quantity | POLINE | POLINE.QUANTITY - POLINE.CXL_QTY - POLINE.REC_QTY |
| On Order Value | POLINE |
CASE WHEN PLI.CLOSED_FL<> 'Y' THEN POLINE.OPEN_PO_AMT ELSE 0 END AS OPENPURCHASEAMOUNT, (POLINE.QUANTITY - POLINE.CXL_QTY - POLINE.REC_QTY) * POLINE.ENT_UNIT_CST |
| Open PO Count | PURCHORDER |
IF [PurchaseOrder.CLOSED] ='Yes' THEN [Open PO Count] = 1 ELSE [Open PO Count] = 0 |
| Open PO Line Count | POLINE | when Closed.No |
| Open Purchase Amount | POLINE |
CASE WHEN PLI.CLOSED_FL<> 'Y' THEN POLINE.OPEN_PO_AMT ELSE 0 |
| Percent Delivered to Correct Location | PURCHORDER, PORECEIVE |
CASE WHEN POLINE.LOCATION = RECEIPTSBYPO.LOCATION THEN 1 ELSE 0/PURCHORDER.POLineCount |
| Percent Electronically Transmitted POs | POREVISION |
CASE POREVISION.ISSUE_METH WHEN 'F' THEN 1 WHEN 'E' THEN 1 WHEN 'I' THEN 1 WHEN ' ' THEN 1 ELSE 0 END AS PO_TRANSMITTED_ELECTRONICALLY /PURCHORDER.POLineCount |
| Percent Inventory Lines | POLINE | POLineCount where ItemType='I'/ POLineCount |
| Percent Non Stock Lines | POLINE | POLineCount where ItemType='N' / POLineCount |
| Percent Not Shipped Complete | POLINE, PURCHORDER | POLINE.LinesNotShippedComplete / PURCHORDER .POLineCount |
| Percent Order Quantity Off Agreement | POLINE | Off Agreement Quantity] / POLINE.QUANTITY |
| Percent Order Quantity On Agreement | POLINE | OnAgreementQuantity / POLINE.QUANTITY |
| Percent Order Value Off Agreement | POLINE | OffAgreementValue / [POLINE.EXTENDEDAMOUNT] |
| Percent Order Value On Agreement | POLINE | OnAgreementValue / [POLINE.EXTENDEDAMOUNT] |
| Percent PO Lines Over Received | PORECLINE |
CASE WHEN PLI.REC_QTY >PLI.QUANTITY THEN 1 ELSE 0/ PURCHORDER.POLineCount |
| Percent PO Lines w Buyer Messages | POMESSAGE | BuyerMessagesCount / POLineCount |
| Percent POs Not Via EDI | POREVISION |
PO Count - IF [POREVISION.ISSUE_METHOD] = 'E' THEN [POs Issued EDI] = 1 ELSE [POs Issued EDI] = 0 END IF / POLineCount |
| Percent POs Transmitted EDI | POREVISION |
IF [POREVISION.ISSUE_METHOD] = 'E' THEN [POs Issued EDI] = 1 ELSE [POs Issued EDI] = 0 END IF / PO Count |
| Percent Received On Time | PORECEIVE, POREVISION.POLINE |
WHEN POLine.LATE_DL_DATE >'1753-01-01 00:00:00.000' AND POLine.REC_ACT_DATE > '1753-01-01 00:00:00.000' THEN CASE WHEN POLine.REC_ACT_DATE <=POLINE.LATE_DL_DATE THEN 1ELSE 0 END ELSE CASE WHEN POLine.REC_ACT_DATE <=POLINE.EARLY_DL_DATE AND POLine.REC_ACT_DATE > '1753-01-01 00:00:00.000' THEN 1ELSE 0 END / PURCHORDER.POLineCount |
| Percent Service Lines | POLINE | POLineCount where ItemType='S' / PURCHORDER.POLineCount |
| Percent Shipped Complete | POLINE, PURCHORDER | POLINE.LinesShippedComplete/ PURCHORDER .POLineCount |
| Percent Special Lines | POLINE | POLineCount where ItemType='X' / PURCHORDER .POLineCount |
| Percent Undamaged | POLINE | (POLINE.REC_QTY - POLINE.REJECT_QTY) / POLINE.REC_QTY |
| PO Count | PURCHORDER | PO Count |
| PO Line Count | PURCHORDER | PO Line Count |
| PO Line Extended Amount | POLINE | [POLINE.EXTENDEDAMOUNT] |
| PO Lines Delivered To CorrectLocation | POLINE, PORECLINE |
CASE WHEN POLINE.LOCATION = RECEIPTSBYPO.LOCATION THEN 1 ELSE 0 END |
| PO Lines Over Received | POLINE, PORECLINE |
CASE WHEN POLINE.REC_QTY > POLINE.QUANTITY THEN 1 ELSE 0 END |
| PO Lines Received | POLINE |
CASE WHEN POLINE.REC_QTY = 0 THEN 1 ELSE 0 |
| PO Lines Unreceived | POLINE |
CASE WHEN POLINE.REC_QTY = 0 THEN 1 ELSE 0 END |
| POs Issued EDI | POREVISION |
IF [POREVISION.ISSUE_METHOD] = 'E' THEN [POs Issued EDI] = 1 ELSE [POs Issued EDI] = 0 END IF |
| POs Transmitted Electronically | POREVISION |
CASE POREVISION.ISSUE_METH WHEN 'F' THEN 1 WHEN 'E' THEN 1 WHEN 'I' THEN 1 WHEN ' ' THEN 1 ELSE 0 END AS PO_TRANSMITTED_ELECTRONICALLY |
| Quantity | POLINE | QUANTITY |
| Quantity In Stock UOM | POLINE |
POLINE.QUANTITY / CASE WHEN POLINE.EBUY_UOM_MULT = 0 THEN 1 ELSE POLINE.EBUY_UOM_MULT END |
| Quantity Received On Time | POLINE |
WHEN POLINE.LATE_DL_DATE> '1753-01-01 00:00:00.000' ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN CASE WHEN POLINE.REC_ACT_DATE <= POLINE.LATE_DL_DATE THENPOLINE.QUANTITY ELSE 0 END ELSE CASE WHEN POLINE.REC_ACT_DATE <= POLINE.EARLY_DL_DATE AND POLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN POLINE.QUANTITY ELSE 0 END |
| Quantity Shipped Complete | POLINE |
CASE WHEN POLINE.REC_QTY = POLINE.QUANTITY THEN POLINE.QUANTITY ELSE 0 END |
| Receipt Header Count | PURCHORDER | Receipt Header Count |
| Receipt Line Count | PORECLINE | ISNULL(RECEIPTSBYPO.REC_LINE_COUNT, 0) |
| Receipt Quantity | Receipt Quantity | RECEIPTSBYPO.REC_LINE_COUNT |
| Received Late | POLINE, PORECLINE |
CASE WHEN POLINE.LATE_DL_DATE> '1753-01-01 00:00:00.000' ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN CASE WHEN PLI.REC_ACT_DATE > POLINE.LATE_DL_DATE THEN 1 ELSE 0 END ELSE CASE WHEN POLINE.REC_ACT_DATE > POLINE.EARLY_DL_DATE ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN1 ELSE 0 END |
| Received On Time | POLINE, PORECLINE |
CASE WHEN POLINE.LATE_DL_DATE> '1753-01-01 00:00:00.000' ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN CASE WHEN POLINE.REC_ACT_DATE <= POLINE.LATE_DL_DATE THEN 1 ELSE 0 END ELSE CASE WHEN POLINE.REC_ACT_DATE <= POLINE.EARLY_DL_DATE ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN1 ELSE 0 END |
| Received Quantity | PORECLINE | POLINE.REC_QTY |
| Service Cancel Amount | POLINE.REJECT_QTY | |
| Service Cancel Amount | PORECLINE |
CASE WHEN PLI.ITEM_TYPE = 'S'AND POLINE.SERVICE_CODE= 'A' THEN POLINE.SERV_CXL_AMT ELSE 0 |
| Total Order Amount | PURCHORDER | PURCHORDER.TOT_ORDER_AM |
| Total Product Amount | PURCHORDER | PURCHORDER.TOT_PRD_AMT |
| Total Tax Amount | PURCHORDER | PURCHORDER.PO_TAX_TOTAL |
| Total Taxable Amount | PURCHORDER | PURCHORDER.PO_TAXBL_TOTAL |
| UnMatched PO Line Count | PURCHORDER |
CASE WHENPLI.MATCHED_QTY < (POLINE.QUANTITY - POLINE.CXL_QTY) THEN 1 ELSE0 |
| Average Lines per PO | PURCHORDER | POLineCount / POCount |
| Average Quantity per PO Line | PURCHORDER, POLINE | POLINE.QUANTITY/PURCHORDER.POLINECOUNT |
| Average Receipt Lines per Receipt Header | PURCHORDER | ISNULL(RECEIPTSBYPO.REC_LINE_COUNT, 0) /PURCHORDER.ReceiptHeaderCount |
| Average Receipts per PO | PURCHORDER, POLINE | POLINE, POLINE.CXL_QTY =POLINE.QUANTITY ANDPLI.ITEM_TYPE <> 'S' THEN 1ELSE 0 /PURCHORDER.POCOUNT |
| Average Unit Cost per Purchase | POLINE, PURCHORDER | POLINE.ENT_UNIT_CST/PURCHORDER.POLineCount |
| Average Value per PO Line POLINE | POMESSAGE | POLINE.EXTENDED_AMT /PURCHORDER.POLineCount |
| Buyer Messages Count | PURCHORDER | when related record in PurchaseOrderBuyerMessage exists |
| Canceled Line Count | POLINE | CASEWHENPOLINE.CXL_QTY= POLINE.QUANTITY THEN 1ELSE 0 |
| Cancel Quantity | POLINE | CASEWHENPOLINE.CXL_QTY= POLINE.QUANTITY THENPLI.QUANTITY ELSE POLINE.CXL_QTY |
| Entered Unit Cost | POLINE | POLINE.ENT_UNIT_CST |
| Entered Unit Cost Per StockUOM | POLINE | POLINE.ENT_UNIT_CST / CASEWHEN POLINE.EBUY_UOM_MULT = 0THEN 1 ELSE POLINE.EBUY_UOM_MULT |
| PO Line Extended Amount | POLINE | [POLINE.EXTENDEDAMOUNT] |
| Extended Receipt Value | POLINE | POLINE.REC_QTY *ENT_UNIT_CST |
| Extended Rejected Value | POLINE | POLINE.REJECT_QTY *PLI.ENT_UNIT_CST |
| Invoiced PO Line Count | POLINE | when InvoiceDetailExists |
| Landed Unit Cost | POLINE | POLINE.LAND_UNIT_CST |
| Lines Not Shipped Complete | POLINE | CASE WHEN PLI.REC_QTY <POLINE.QUANTITY THEN 1ELSE 0 |
| Lines Shipped Complete | POLINE | CASE WHEN PLI.REC_QTY =POLINE.QUANTITY THEN 1ELSE 0 |
| Matched Amount | POLINE | POLINE.MATCHED_AMOUNT |
| Matched PO Line Count | POLINE | CASE WHEN (POLINE.MATCHED_QTY >= (POLINE.QUANTITY - POLINE.CXL_QTY)) |
| Matched Quantity | POLINE | |
| Matched Quantity In Stock UOM | POLINE | POLINE.EBUY_UOM_MULT *POLINE.MATCHED_QTY |
| Matched Unit Cost | POLINE | CASE WHEN PLI.MATCHED_QTY <> 0 THENPOLINE.MATCHED_AMOUNT /POLINE.MATCHED_QTY ELSE0 |
| Off Agreement Line Count | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 [Off Agreement Line Count] = 0 IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [Off Agreement Line Count] = 1 |
| Off Agreement Quantity | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [Off Agreement Quantity]= 0 IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [Off Agreement Quantity] = [PurchaseOrderLine.QUANTITY] |
| Off Agreement Value | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [On Agreement Value] =[PurchaseOrderLine.EXTENDEDAMOUNT] IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [Off Agreement Value] = [PurchaseOrderLine.EXTENDEDAMOUNT] |
| On Agreement Quantity | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [On Agreement Quantity]= [PurchaseOrderLine.QUANTITY] IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [On Agreement Quantity] = 0 |
| On Agreement Value | POLINE |
IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]= 1 THEN [Off Agreement Value] =0 IF [PurchaseOrderLine.SPEND_CATEGORY_KEY]NOT EQUALS 1 THEN [On Agreement Value] = 0 |
| On Order Quantity | POLINE | POLINE.QUANTITY - POLINE.CXL_QTY - POLINE.REC_QTY |
| On Order Value | POLINE |
CASE WHEN PLI.CLOSED_FL<> 'Y' THEN POLINE.OPEN_PO_AMT ELSE 0 END AS OPENPURCHASEAMOUNT, (POLINE.QUANTITY - POLINE.CXL_QTY - PO-LINE.REC_QTY) * POLINE.ENT_UNIT_CST |
| Open PO Count | PURCHORDER | IF [PurchaseOrder.CLOSED] ='Yes' THEN [Open PO Count] = 1 ELSE [Open PO Count] = 0 |
| Open PO Line Count | POLINE | when Closed.No |
| Open Purchase Amount | POLINE | CASE WHEN PLI.CLOSED_FL<> 'Y' THEN POLINE.OPEN_PO_AMT ELSE 0 |
| Percent Delivered to Correct Location | PURCHORDER, PORECEIVE |
CASE WHEN POLINE.LOCATION = RECEIPTSBYPO.LOCATION THEN 1 ELSE 0/PURCHORDER.POLineCount |
| Percent Electronically Transmitted POs | POREVISION |
CASE POREVISION.ISSUE_METH WHEN 'F' THEN 1 WHEN 'E' THEN 1 WHEN 'I' THEN 1 WHEN ' ' THEN 1 ELSE 0 END AS PO_TRANSMITTED_ELECTRONICALLY /PURCHORDER.POLineCount |
| Percent Inventory Lines | POLINE | POLineCount where ItemType='I'/ POLineCount |
| Percent Non Stock Lines | POLINE | POLineCount where ItemType='N' / POLineCount |
| Percent Order Quantity Off Contract | POLINE | Off Contract Quantity] / POLINE.QUANTITY |
| Percent Order Quantity On Contract | POLINE | OnContractQuantity / POLINE.QUANTITY |
| Percent Order Value Off Contract | POLINE | OffContractValue / [POLINE.EXTENDEDAMOUNT] |
| Percent Order Value On Contract | POLINE | OnContractValue / [POLINE.EXTENDEDAMOUNT] |
| Percent PO Lines Over Received | PORECLINE | CASE WHEN PLI.REC_QTY >PLI.QUANTITY THEN 1 ELSE 0/ PURCHORDER.POLineCount |
| Percent PO Lines w Buyer Messages | POMESSAGE | BuyerMessagesCount / POLineCount |
| Percent POs Not Via EDI | POREVISION |
PO Count - IF [POREVISION.ISSUE_METHOD] = 'E' THEN [POs Issued EDI] = 1 ELSE [POs Issued EDI] = 0 END IF / POLineCount |
| Percent POs Transmitted EDI | POREVISION |
IF [POREVISION.ISSUE_METHOD] = 'E' THEN [POs Issued EDI] = 1 ELSE [POs Issued EDI] = 0 END IF / PO Count |
| Percent Received On Time | PORECEIVE, POREVISION.POLINE |
WHEN POLine.LATE_DL_DATE >'1753-01-01 00:00:00.000' AND POLine.REC_ACT_DATE > '1753-01-01 00:00:00.000' THEN CASE WHEN POLine.REC_ACT_DATE <=POLINE.LATE_DL_DATE THEN 1ELSE 0 END ELSE CASE WHEN POLine.REC_ACT_DATE <=POLINE.EARLY_DL_DATE AND POLine.REC_ACT_DATE > '1753-01-01 00:00:00.000' THEN 1ELSE 0 END / PURCHORDER.POLineCount |
| Percent Service Lines | POLINE | POLineCount where ItemType='S' / PURCHORDER.POLineCount |
| Percent Shipped Complete | POLINE, PURCHORDER | POLINE.LinesShippedComplete/ PURCHORDER .POLineCount |
| Percent Not Shipped Complete | POLINE, PURCHORDER | POLINE.LinesNotShippedComplete / PURCHORDER .POLineCount |
| Percent Special Lines | POLINE | POLineCount where ItemType='X' / PURCHORDER .POLineCount |
| Percent Undamaged | POLINE |
(POLINE.REC_QTY - POLINE.REJECT_QTY) / POLINE.REC_QTY |
| PO Count | PURCHORDER | PO Count |
| PO Line Count | PURCHORDER | PO Line Count |
| PO Lines Delivered To CorrectLocation | POLINE, PORECLINE | CASE WHEN POLINE.LOCATION = RECEIPTSBYPO.LOCATION THEN 1 ELSE 0 END |
| PO Lines Over Received | POLINE, PORECLINE | CASE WHEN POLINE.REC_QTY > POLINE.QUANTITY THEN 1 ELSE 0 END |
| PO Lines Received | POLINE | CASE WHEN POLINE.REC_QTY = 0 THEN 1 ELSE 0 |
| PO Lines Unreceived | POLINE | CASE WHEN POLINE.REC_QTY = 0 THEN 1 ELSE 0 END |
| POs Issued EDI | POREVISION |
IF [POREVISION.ISSUE_METHOD] = 'E' THEN [POs Issued EDI] = 1 ELSE [POs Issued EDI] = 0 END IF |
| POs Transmitted Electronically | POREVISION |
CASE POREVISION.ISSUE_METH WHEN 'F' THEN 1 WHEN 'E' THEN 1 WHEN 'I' THEN 1 WHEN ' ' THEN 1 ELSE 0 END AS PO_TRANSMITTED_ELECTRONICALLY |
| Quantity | POLINE | QUANTITY |
| Quantity In Stock UOM | POLINE | POLINE.QUANTITY / CASE WHEN POLINE.EBUY_UOM_MULT = 0 THEN 1 ELSE POLINE.EBUY_UOM_MULT END |
| Quantity Received On Time | POLINE |
WHEN POLINE.LATE_DL_DATE> '1753-01-01 00:00:00.000' ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN CASE WHEN POLINE.REC_ACT_DATE <= POLINE.LATE_DL_DATE THENPOLINE.QUANTITY ELSE 0 END ELSE CASE WHEN POLINE.REC_ACT_DATE <= POLINE.EARLY_DL_DATE AND POLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN POLINE.QUANTITY ELSE 0 END |
| Quantity Shipped Complete | POLINE | CASE WHEN POLINE.REC_QTY = POLINE.QUANTITY THEN POLINE.QUANTITY ELSE 0 END |
| Receipt Header Count | PURCHORDER | Receipt Header Count |
| Receipt Line Count | PORECLINE | ISNULL(RECEIPTSBYPO.REC_LINE_COUNT, 0) |
| Receipt Quantity | Receipt Quantity | RECEIPTSBYPO.REC_LINE_COUNT |
| Received Late | POLINE, PORECLINE |
CASE WHEN POLINE.LATE_DL_DATE> '1753-01-01 00:00:00.000' ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN CASE WHEN PLI.REC_ACT_DATE > POLINE.LATE_DL_DATE THEN 1 ELSE 0 END ELSE CASE WHEN POLINE.REC_ACT_DATE > POLINE.EARLY_DL_DATE ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN1 ELSE 0 END |
| Received On Time | POLINE, PORECLINE |
CASE WHEN POLINE.LATE_DL_DATE> '1753-01-01 00:00:00.000' ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN CASE WHEN POLINE.REC_ACT_DATE <= POLINE.LATE_DL_DATE THEN 1 ELSE 0 END ELSE CASE WHEN POLINE.REC_ACT_DATE <= POLINE.EARLY_DL_DATE ANDPOLINE.REC_ACT_DATE >'1753-01-01 00:00:00.000' THEN1 ELSE 0 END |
| Received Quantity | PORECLINE | POLINE.REC_QTY |
| Service Cancel Amount | PORECLINE | POLINE.REJECT_QTY |
| Service Cancel Amount | PORECLINE |
CASE WHEN PLI.ITEM_TYPE = 'S'AND POLINE.SERVICE_CODE= 'A' THEN POLINE.SERV_CXL_AMT ELSE 0 |
| Total Order Amount | PURCHORDER | PURCHORDER.TOT_ORDER_AM |
| Total Product Amount | PURCHORDER | PURCHORDER.TOT_PRD_AMT |
| Total Taxable Amount | PURCHORDER | PURCHORDER.PO_TAXBL_TOTAL |
| Total Tax Amount | PURCHORDER | PURCHORDER.PO_TAX_TOTAL |
| UnMatched PO Line Count | PURCHORDER | CASE WHENPLI.MATCHED_QTY < (POLINE.QUANTITY - POLINE.CXL_QTY)
THEN 1 ELSE0 |
| Spend | ||
| AP Base Amount | APDISTRIB | ORIG_BASE_AMT |
| AP Trans Amount | APDISTRIB | ORIG_BASE_AMT |
| Vendor Returns | ||
| Entered UOM Mult | PORETURNHD | ENT_UOM_MULT |
| Return Count | PORETURNHD | 1 as Return Count |
| Return Credit Received | PORETURNHD | CREDIT_RECVD |
| Return Line Extended Amount | PORETURNLN | RETURN_QTY * UNIT_COST |
| Return Line Count | PORETURNLN | 1 as Return Line Count |
| Return Loss Cost | PORETURNLN | UNIT_COST-(RETURN_VALUE- CREDIT_RECVD) |
| Return Lost Cost | PORETURNHD | RETURN_VALUE- CREDIT_RECVD |
| Return Qty Instock UOM | PORETURNLN | RETURN_QTY * ENT_UOM_MULT |
| Return Quantity | PORETURNLN | RETURN_QTY |
| Return Unit Cost | PORETURNLN | UNIT_COST |
| Return Unit Cost Stock Per UOM | PORETURNLN | UNIT_COST / ENT_UOM_MULT |
| Vendor Agreement | ||
| Agreement Max Amount | POVAGRMTHD | AGRMT_MAX_AMT |
| Amount Ordered | POVAGRMTHD | AMT_ORDERED |
| Amount Remaining | POVAGRMTHD | AMT_REMAINING |