Table: Vendor Group Statistics

Table: APVGS
View: AP0017
Record Length: 167

Flags: A R 

Keys: 1

Title Flags Fields

Vendor Group Statistics Key IDGRPCNTYRCNTPERD

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