# View: Vendor Group Statistics

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

## Compositions: 0

## 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 |
YTDCNTCR | 24 | BCD*5.0 | YTD Number of Credit Notes | E |
YTDCNTDR | 25 | BCD*5.0 | YTD Number of Debit Notes | E |
YTDCNTPY | 26 | BCD*5.0 | YTD Number of Payments | E |
YTDCNTED | 27 | BCD*5.0 | YTD Number of Discounts | E |
YTDCNTLOST | 28 | BCD*5.0 | YTD Number of Discounts Lost | E |
YTDCNTAD | 29 | BCD*5.0 | YTD Number of Adjustments | E |
YTDCNTINPD | 30 | BCD*5.0 | YTD Number of Paid Invoices | E |
YTDCNTDTP | 31 | BCD*5.0 | YTD Number of Days to Pay | E |
YTDHCIN | 32 | BCD*10.3 | YTD Invoices in Func. Curr. | E |
YTDHCCR | 33 | BCD*10.3 | YTD Credits in Func. Curr. | E |
YTDHCDR | 34 | BCD*10.3 | YTD Debits in Func. Curr. | E |
YTDHCPY | 35 | BCD*10.3 | YTD Payments in Func. Curr. | E |
YTDHCED | 36 | BCD*10.3 | YTD Discounts in Func. Curr. | E |
YTDHCLOST | 37 | BCD*10.3 | YTD Discounts Lost - Func. Curr. | E |
YTDHCAD | 38 | BCD*10.3 | YTD Adjustments in Func. Curr. | E |
YTDHCINPD | 39 | BCD*10.3 | YTD Invoices Pd. in Func. Curr. | E |
YTDCNTADTP | 40 | BCD*6.1 | YTD Average Days to Pay | E |
YTDACTIVE | 41 | Integer | Enable YTD Calculations | E |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.