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) |