# Table: Vendor Group Statistics

Table: APVGS
View: AP0017
Record length: 167
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Vendor Group Statistics Key |  | IDGRP, CNTYR, CNTPERD

## Fields: 26

Field | Type | Title | Presentation
--- | --- | --- | ---
IDGRP | String*6 | Group code | Mask: %-6N
CNTYR | String*4 | Year | Mask: %04D
CNTPERD | String*2 | Period | Mask: %02D
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CNTINVC | BCD*4.0 | Number of Invoices |
CNTCR | BCD*4.0 | Number of Credit Notes |
CNTDR | BCD*4.0 | Number of Debit Notes |
CNTPAYM | BCD*4.0 | Number of Payments |
CNTDISC | BCD*4.0 | Number of Discounts |
CNTLOST | BCD*4.0 | Number of Discounts Lost |
CNTADJ | BCD*4.0 | Number of Adjustments |
CNTINVCPD | BCD*4.0 | Number of Paid Invoices |
CNTDTOPAY | BCD*4.0 | Number of Days to Pay |
AMTINVCHC | BCD*10.3 | Total Invoices Amount |
AMTCRHC | BCD*10.3 | Total Credit Note Amount |
AMTDRHC | BCD*10.3 | Total Debit Note Amount |
AMTPAYMHC | BCD*10.3 | Total Payment Amount |
AMTDISCHC | BCD*10.3 | Total Discount Amount |
AMTLOSTHC | BCD*10.3 | Total Discount Amount Lost |
AMTADJHC | BCD*10.3 | Total Adjustment Amount |
AMTINVPDHC | BCD*10.3 | Total Amount of Paid Invoices |
AVGDAYSPAY | BCD*5.1 | Average Days to Pay |
AVGPAYMENT | BCD*10.3 | Reserved |

This page was generated on 2008-May-01

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