A list of purchase order lines.
View Name: vw_KPIPOLines
Filter: PO Status not X (cancelled) or D (draft); Lines Status not X (cancelled)
Features: Company, Warehouse
Transactional: Yes, by OrdDate
| Field | Type | Description |
|---|---|---|
| PONo | int | Purchase Order Number |
| POLine | smallint | Purchase Order Line |
| CompCode | varchar | Company Code |
| PartNo | varchar | Item Number |
| ItemDes | varchar | Item Description |
| OrdDate | datetime | Order Date |
| DueDate | datetime | Due Date |
| Whse | varchar | Warehouse Code |
| AcctGrp | varchar | Account group of line account (Inv=Inventory) |
| QtyDue | decimal | Quantity Due (Due = Ordered - Cancelled - Received - Closed) |
| AmtDue | decimal | Amount Due |
| QtyOrd | decimal | Quantity Ordered |
| AmtOrd | decimal | Amount Ordered |
| ProdFam | varchar | Product Family Code |
| ProdFamName | varchar | Product Family Name |
| BuyerCode | varchar | Buyer Code |
| BuyerName | varchar | Buyer Name |
