View: Customer Group Statistics

RotoID: AR0026
Table: ARGSM
Protocol: Flat
DLL:ARGSM

Keys: 1

Title Fields
Group No., Year and Period IDGRP, CNTPERD, CNTYR

Fields: 52

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 Receipts E A 
CNTDISC 8 BCD*4.0 Number of Discounts E A 
CNTADJ 9 BCD*4.0 Number of Adjustments E A 
CNTWROF 10 BCD*4.0 Number of Write-Offs E A 
CNTINTT 11 BCD*4.0 Number of Interest Charges E A 
CNTRIF 12 BCD*4.0 Number of Returned Checks E A 
CNTINVCPD 13 BCD*4.0 Number of Paid Invoices E A 
CNTDTOPAY 14 BCD*4.0 Number of Days to Pay E A 
AMTINVCHC 15 BCD*10.3 Total Invoice Amount E A 
AMTCRHC 16 BCD*10.3 Total Credit Note Amount E A 
AMTDRHC 17 BCD*10.3 Total Debit Note Amount E A 
AMTPAYMHC 18 BCD*10.3 Total Receipt Amount E A 
AMTDISCHC 19 BCD*10.3 Total Discount Amount E A 
AMTADJHC 20 BCD*10.3 Total Adjustment Amount E A 
AMTWROFHC 21 BCD*10.3 Total Write-Off Amount E A 
AMTINTTHC 22 BCD*10.3 Total Interest Amount E A 
AMTRIFHC 23 BCD*10.3 Total Amount of Returned Checks E A 
AMTINVPDHC 24 BCD*10.3 Total Amount of Paid Invoices E A 
AVGDAYSPAY 25 BCD*5.1 Average Days to Pay A C 
CNTRF 26 BCD*3.0 Number of Refunds E A 
AMTRFHC 27 BCD*10.3 Total Refund Amount E A 
YTDCNTIN 28 BCD*5.0 YTD Number of Invoices E A 
YTDCNTCR 29 BCD*5.0 YTD Number of Credits E A 
YTDCNTDR 30 BCD*5.0 YTD Number of Debits E A 
YTDCNTPY 31 BCD*5.0 YTD Number of Receipts E A 
YTDCNTED 32 BCD*5.0 YTD Number of Discounts E A 
YTDCNTAD 33 BCD*5.0 YTD Number of Adjustments E A 
YTDCNTWO 34 BCD*5.0 YTD Number of Write-Offs E A 
YTDCNTIT 35 BCD*5.0 YTD Number of Interest Charges E A 
YTDCNTRIF 36 BCD*5.0 YTD Number of Returned Checks E A 
YTDCNTINPD 37 BCD*5.0 YTD Number of Invoices Paid E A 
YTDCNTRF 38 BCD*5.0 YTD Number of Refunds E A 
YTDCNTDTP 39 BCD*5.0 YTD Number of Days to Pay E A 
YTDHCIN 40 BCD*10.3 YTD Invoices in Func. Curr. E A 
YTDHCCR 41 BCD*10.3 YTD Credits in Func. Curr. E A 
YTDHCDR 42 BCD*10.3 YTD Debits in Func. Curr. E A 
YTDHCPY 43 BCD*10.3 YTD Receipts in Func. Curr. E A 
YTDHCED 44 BCD*10.3 YTD Discounts in Func. Curr. E A 
YTDHCAD 45 BCD*10.3 YTD Adjustments in Func. Curr. E A 
YTDHCWO 46 BCD*10.3 YTD Write-Offs in Func. Curr. E A 
YTDHCIT 47 BCD*10.3 YTD Interest in Func. Curr. E A 
YTDHCRIF 48 BCD*10.3 YTD Ret'd Checks in Func. Curr. E A 
YTDHCINPD 49 BCD*10.3 YTD Invoices Pd. in Func. Curr. E A 
YTDHCRF 50 BCD*10.3 YTD Refunds in Func. Curr. E A 
YTDCNTADTP 51 BCD*6.1 YTD Average Days to Pay E A 
YTDACTIVE 52 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).