A list of purchase orders.
View Name: vw_KPIPOs
Filter: PO Status not X (cancelled) or D (draft)
Features: Company, Warehouse
Transactional: Yes, by OrdDate
| Field | Type | Description |
|---|---|---|
| PONo | int | Purchase Order Number |
| CompCode | varchar | Company Code |
| SuppCode | varchar | Supplier Code |
| SuppName | varchar | Supplier Name |
| OrdDate | datetime | Purchase Order Date |
| BuyerCode | varchar | Buyer Code |
| ShipCode | varchar | Ship To Address Code |
| Whse | varchar | Warehouse Code |
| WhseName | varchar | Warehouse Name |
| TotalAmt | decimal | PO Total Amount |
| SuppEmp | bit | Is Supplier an Employee (1=Yes, 0=No) |
