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) |