View: Vendor Group Statistics

RotoID: AP0017
Table: APVGS
Protocol: Flat
DLL:APVGS

Keys: 1

Title Fields
Vendor Group Statistics Key IDGRP, CNTYR, CNTPERD

Fields: 41

Field Index Type Title Attributes Presentation
IDGRP 1 String*6 Group code E A K R  Mask: %-6N
CNTYR 2 String*4 Year E A K R  Mask: %04D
CNTPERD 3 String*2 Period E A K R  Mask: %02D
CNTINVC 4 BCD*4.0 Number of Invoices E A 
CNTCR 5 BCD*4.0 Number of Credit Notes E A 
CNTDR 6 BCD*4.0 Number of Debit Notes E A 
CNTPAYM 7 BCD*4.0 Number of Payments E A 
CNTDISC 8 BCD*4.0 Number of Discounts E A 
CNTLOST 9 BCD*4.0 Number of Discounts Lost E A 
CNTADJ 10 BCD*4.0 Number of Adjustments E A 
CNTINVCPD 11 BCD*4.0 Number of Paid Invoices E A 
CNTDTOPAY 12 BCD*4.0 Number of Days to Pay E A 
AMTINVCHC 13 BCD*10.3 Total Invoices Amount E A 
AMTCRHC 14 BCD*10.3 Total Credit Note Amount E A 
AMTDRHC 15 BCD*10.3 Total Debit Note Amount E A 
AMTPAYMHC 16 BCD*10.3 Total Payment Amount E A 
AMTDISCHC 17 BCD*10.3 Total Discount Amount E A 
AMTLOSTHC 18 BCD*10.3 Total Discount Amount Lost E A 
AMTADJHC 19 BCD*10.3 Total Adjustment Amount E A 
AMTINVPDHC 20 BCD*10.3 Total Amount of Paid Invoices E A 
AVGDAYSPAY 21 BCD*5.1 Average Days to Pay E A C 
AVGPAYMENT 22 BCD*10.3 Reserved E 
YTDCNTIN 23 BCD*5.0 YTD Number of Invoices E A 
YTDCNTCR 24 BCD*5.0 YTD Number of Credit Notes E A 
YTDCNTDR 25 BCD*5.0 YTD Number of Debit Notes E A 
YTDCNTPY 26 BCD*5.0 YTD Number of Payments E A 
YTDCNTED 27 BCD*5.0 YTD Number of Discounts E A 
YTDCNTLOST 28 BCD*5.0 YTD Number of Discounts Lost E A 
YTDCNTAD 29 BCD*5.0 YTD Number of Adjustments E A 
YTDCNTINPD 30 BCD*5.0 YTD Number of Paid Invoices E A 
YTDCNTDTP 31 BCD*5.0 YTD Number of Days to Pay E A 
YTDHCIN 32 BCD*10.3 YTD Invoices in Func. Curr. E A 
YTDHCCR 33 BCD*10.3 YTD Credits in Func. Curr. E A 
YTDHCDR 34 BCD*10.3 YTD Debits in Func. Curr. E A 
YTDHCPY 35 BCD*10.3 YTD Payments in Func. Curr. E A 
YTDHCED 36 BCD*10.3 YTD Discounts in Func. Curr. E A 
YTDHCLOST 37 BCD*10.3 YTD Discounts Lost - Func. Curr. E A 
YTDHCAD 38 BCD*10.3 YTD Adjustments in Func. Curr. E A 
YTDHCINPD 39 BCD*10.3 YTD Invoices Pd. in Func. Curr. E A 
YTDCNTADTP 40 BCD*6.1 YTD Average Days to Pay E A 
YTDACTIVE 41 Integer Enable YTD Calculations E A  List:2 entries
0 = No
1 = Yes

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).