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