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