A list of Sales Order lines.
View Name: vw_KPIOrderLine
Filter: Sales Order Status R (released) or V (revising)
Features: Company, Business Unit
Transactional: Yes, by OrdDate
| Field | Type | Description |
|---|---|---|
| OrdNo | int | Sales Order Number |
| OrdLine | int | Sales Order Line Number |
| CompCode | varchar | Company Code |
| OrdDate | datetime | Sales Order Date |
| CustCode | varchar | Customer Code |
| CustName | varchar | Customer Name |
| BUnit | varchar | Business Unit Code |
| BUnitName | varchar | Business Unit Name |
| LineNetPrice | decimal | Line Price not including tax (LinePrice-DiscAmt-DiscAmt2) |
| PartNo | varchar | Item Number |
| ItemDes | varchar | Item Description |
| ProdFam | varchar | Product Family |
| ProdFamName | varchar | Product Family Name |
