A list of Sales Orders.
View Name: vw_KPIOrders
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 |
| CompCode | varchar | Company Code |
| OrdDate | datetime | Sales Order Date |
| CustCode | varchar | Customer Code |
| CustName | varchar | Customer Name |
| OrdType | varchar | Sales Order Type (see Order Types for list) |
| OrdTypeName | varchar | Sales Order Type Name |
| BUnit | varchar | Business Unit Code |
| BUnitName | varchar | Business Unit Name |
| BUnitCC | varchar | Business Unit Cost Center |
| SalesRep | varchar | Account Manager Code |
| SalesAmt | decimal | Sale Amount not including tax (TotalLinePrice-TotalDiscAmt+TotalFreightAmt) |