FOURA™ Reference Documentation
In This Topic
KPI Sales Orders
In This Topic

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

Dashboards