# View: Vendor Statistics

RotoID: AP0019
Table: APVSM
Protocol: Flat
DLL: APVSM

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Vendor Statistics Key | VENDORID, CNTYR, CNTPERD

## Fields: 60

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
VENDORID | 1 | String*12 | Vendor Number | E A K R | Mask: %-12C
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*3.0 | Number of Invoices | E A |
CNTCR | 5 | BCD*3.0 | Number of Credit Notes | E A |
CNTDR | 6 | BCD*3.0 | Number of Debit Notes | E A |
CNTPAYM | 7 | BCD*3.0 | Number of Payments | E A |
CNTDISC | 8 | BCD*3.0 | Number of Discounts | E A |
CNTLOST | 9 | BCD*3.0 | Number of Discounts Lost | E A |
CNTADJ | 10 | BCD*3.0 | Number of Adjustments | E A |
CNTINVCPD | 11 | BCD*3.0 | Number of Paid Invoices | E A |
CNTDTOPAY | 12 | BCD*3.0 | Number of Days to Pay | E A |
AMTINVCHC | 13 | BCD*10.3 | Total Invoices in Func. Currency | E A |
AMTCRHC | 14 | BCD*10.3 | Total Credits in Func. Currency | E A |
AMTDRHC | 15 | BCD*10.3 | Total Debits in Func. Currency | E A |
AMTPAYMHC | 16 | BCD*10.3 | Total Payments in Func. Currency | E A |
AMTDISCHC | 17 | BCD*10.3 | Total Discounts in Func. Curr. | E A |
AMTLOSTHC | 18 | BCD*10.3 | Total Discounts Lost - Func. Curr. | E A |
AMTADJHC | 19 | BCD*10.3 | Total Adjustments in Func. Curr. | E A |
AMTPURHC | 20 | BCD*10.3 | Reserved | E |
AMTINVPDHC | 21 | BCD*10.3 | Total Invoices Pd. in Func. Curr. | E A |
AMTINVCTC | 22 | BCD*10.3 | Total Invoices in Vend. Curr. | E A |
AMTCRTC | 23 | BCD*10.3 | Total Credits in Vend. Curr. | E A |
AMTDRTC | 24 | BCD*10.3 | Total Debits in Vend. Curr. | E A |
AMTPAYMTC | 25 | BCD*10.3 | Total Payments in Vend. Curr. | E A |
AMTDISCTC | 26 | BCD*10.3 | Total Discounts in Vend. Curr. | E A |
AMTLOSTTC | 27 | BCD*10.3 | Total Discounts Lost in Vend. Curr. | E A |
AMTADJTC | 28 | BCD*10.3 | Total Adjustments in Vend. Curr. | E A |
AMTPURTC | 29 | BCD*10.3 | Reserved | E |
AMTINPDTC | 30 | BCD*10.3 | Total Invoices Pd. in Vend. Curr. | E A |
AMTBLRVLTC | 31 | BCD*10.3 | Revaluation Bal. in Vend. Curr. | E A |
CNTPUR | 32 | BCD*3.0 | Reserved | E |
AVGDAYSPAY | 33 | BCD*5.1 | Average Days to Pay | E A C |
YTDCNTIN | 34 | BCD*5.0 | YTD Number of Invoices | E |
YTDCNTCR | 35 | BCD*5.0 | YTD Number of Credit Notes | E |
YTDCNTDR | 36 | BCD*5.0 | YTD Number of Debit Notes | E |
YTDCNTPY | 37 | BCD*5.0 | YTD Number of Payments | E |
YTDCNTED | 38 | BCD*5.0 | YTD Number of Discounts | E |
YTDCNTLOST | 39 | BCD*5.0 | YTD Number of Discounts Lost | E |
YTDCNTAD | 40 | BCD*5.0 | YTD Number of Adjustments | E |
YTDCNTINPD | 41 | BCD*5.0 | YTD Number of Paid Invoices | E |
YTDCNTDTP | 42 | BCD*5.0 | YTD Number of Days to Pay | E |
YTDHCIN | 43 | BCD*10.3 | YTD Invoices in Func. Curr. | E |
YTDHCCR | 44 | BCD*10.3 | YTD Credits in Func. Curr. | E |
YTDHCDR | 45 | BCD*10.3 | YTD Debits in Func. Curr. | E |
YTDHCPY | 46 | BCD*10.3 | YTD Payments in Func. Curr. | E |
YTDHCED | 47 | BCD*10.3 | YTD Discounts in Func. Curr. | E |
YTDHCLOST | 48 | BCD*10.3 | YTD Discounts Lost - Func. Curr. | E |
YTDHCAD | 49 | BCD*10.3 | YTD Adjustments in Func. Curr. | E |
YTDHCINPD | 50 | BCD*10.3 | YTD Invoices Pd. in Func. Curr. | E |
YTDTCIN | 51 | BCD*10.3 | YTD Invoices in Vend. Curr. | E |
YTDTCCR | 52 | BCD*10.3 | YTD Credits in Vend. Curr. | E |
YTDTCDR | 53 | BCD*10.3 | YTD Debits in Vend. Curr. | E |
YTDTCPY | 54 | BCD*10.3 | YTD Payments in Vend. Curr. | E |
YTDTCED | 55 | BCD*10.3 | YTD Discounts in Vend. Curr. | E |
YTDTCLOST | 56 | BCD*10.3 | YTD Discounts Lost in Vend. Curr. | E |
YTDTCAD | 57 | BCD*10.3 | YTD Adjustments in Vend. Curr. | E |
YTDTCINPD | 58 | BCD*10.3 | YTD Invoices Pd. in Vend. Curr. | E |
YTDCNTADTP | 59 | BCD*6.1 | YTD Average Days to Pay | E |
YTDACTIVE | 60 | Integer | Enable YTD Calculations | E |

This page was generated on 2008-May-01

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