View: Vendor Statistics

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

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 A 
YTDCNTCR 35 BCD*5.0 YTD Number of Credit Notes E A 
YTDCNTDR 36 BCD*5.0 YTD Number of Debit Notes E A 
YTDCNTPY 37 BCD*5.0 YTD Number of Payments E A 
YTDCNTED 38 BCD*5.0 YTD Number of Discounts E A 
YTDCNTLOST 39 BCD*5.0 YTD Number of Discounts Lost E A 
YTDCNTAD 40 BCD*5.0 YTD Number of Adjustments E A 
YTDCNTINPD 41 BCD*5.0 YTD Number of Paid Invoices E A 
YTDCNTDTP 42 BCD*5.0 YTD Number of Days to Pay E A 
YTDHCIN 43 BCD*10.3 YTD Invoices in Func. Curr. E A 
YTDHCCR 44 BCD*10.3 YTD Credits in Func. Curr. E A 
YTDHCDR 45 BCD*10.3 YTD Debits in Func. Curr. E A 
YTDHCPY 46 BCD*10.3 YTD Payments in Func. Curr. E A 
YTDHCED 47 BCD*10.3 YTD Discounts in Func. Curr. E A 
YTDHCLOST 48 BCD*10.3 YTD Discounts Lost - Func. Curr. E A 
YTDHCAD 49 BCD*10.3 YTD Adjustments in Func. Curr. E A 
YTDHCINPD 50 BCD*10.3 YTD Invoices Pd. in Func. Curr. E A 
YTDTCIN 51 BCD*10.3 YTD Invoices in Vend. Curr. E A 
YTDTCCR 52 BCD*10.3 YTD Credits in Vend. Curr. E A 
YTDTCDR 53 BCD*10.3 YTD Debits in Vend. Curr. E A 
YTDTCPY 54 BCD*10.3 YTD Payments in Vend. Curr. E A 
YTDTCED 55 BCD*10.3 YTD Discounts in Vend. Curr. E A 
YTDTCLOST 56 BCD*10.3 YTD Discounts Lost in Vend. Curr. E A 
YTDTCAD 57 BCD*10.3 YTD Adjustments in Vend. Curr. E A 
YTDTCINPD 58 BCD*10.3 YTD Invoices Pd. in Vend. Curr. E A 
YTDCNTADTP 59 BCD*6.1 YTD Average Days to Pay E A 
YTDACTIVE 60 Integer Enable YTD Calculations E A  List:2 entries
0 = No
1 = Yes

This page was generated on 2022-Aug-18

© 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).