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 |