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 |