FOURA™ Reference Documentation
In This Topic
    KPI Cash Allocation
    In This Topic

    A list of cash entry transactions that can be allocated (to AR account)

    View Name: vw_KPICashAlloc
    Filter: Transaction type CASH
    Features: Company, Business Unit
    Transactional: Yes, by DocDate, however; most often reported as the current total only

    Field Type Description
    ARID int Cash Allocation placeholder transaction ID (in AR_TRX)
    CompCode varchar Company Code
    CustCode varchar Customer Code
    DocDate datetime Document Date (effective date of allocation)
    TrxAmt decimal Transaction Amount (total cash available to allocate)
    AllocAmt decimal Allocated Amount
    NetAmt decimal Aged/Unallocated Amount (Transaction Amount - Allocated Amount)
    BUnit varchar Business Unit Code
    See Also

    Dashboards