FOURA™ Reference Documentation
In This Topic
    KPI AR Aging
    In This Topic

    A list of unpaid AR Invoices and unallocated cash entries

    View Name: vw_KPIARAge
    Filter: Transaction Amount is not $0; Transaction is not fully allocated; Transaction Type is CASH, ARINV or ARCM
    Features: Company, Business Unit
    Transactional: No

    Field Type Description
    CompCode varchar Company Code
    CustCode varchar Customer Code
    DocDate datetime Document Date (effective date of transaction)
    TrxAmt decimal Transaction Amount
    SINo int Sales Invoice Number
    CAID int Cash Allocation ID
    AllocAmt decimal Allocated Amount
    AgeAmt decimal Aged Amount (Transaction Amount - Allocated Amount)
    TrxType varchar AR Transaction Type (ARINV=AR Invoice, ARCM=AR Credit, CASH=Cash Entry)
    BUnit varchar Business Unit Code
    IsLate bit Is Payment late (not paid in full within term due days)?  (1=Yes, 0=No)
    See Also

    Dashboards