A list of unpaid AP Invoices.

View Name: vw_KPIAPAge
Filter: AP Invoice Status A, P or X; CheckDate less than today; Invoice Date less than today
Features: Company
Transactional: No

Field	Type	Description
CompCode	varchar	Company Code
SuppCode	varchar	Supplier Code
VoucherNo	int	AP Invoice Voucher Number
InvcStat	char	AP Invoice Status Code (A=Approved)
InvcDate	datetime	AP Invoice Date
CheckNo	varchar	AP Check Number
CheckDate	datetime	AP Check Date (paid date)
InvcUSD	float	AP Invoice Total Amount (InvcAmt+InvcPre+InvcFreight+InvcTax)
AgeUSD	decimal	AP Aged Amount (not paid)
AgeDays	int	AP Aged Days (number of days after Invoice Date)
TermAgeDays	int	AP Aged Days (number of days after Due Date = Invoice Date + Term Due Days)
PayDate	datetime	Payment Due Date
IsLate	bit	Is AP invoice late (I.E. Not paid in full by payment due date)?  (1=Yes, 0=No)