Table: Customer Group Statistics

Table: ARGSM
View: AR0026
Record length: 198
Flags: A R 

Keys: 1

Title  Flags  Fields

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

Fields: 31

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 Receipts   
CNTDISC  BCD*4.0  Number of Discounts   
CNTADJ  BCD*4.0  Number of Adjustments   
CNTWROF  BCD*4.0  Number of Write-Offs   
CNTINTT  BCD*4.0  Number of Interest Charges   
CNTRIF  BCD*4.0  Number of Returned Checks   
CNTINVCPD  BCD*4.0  Number of Paid Invoices   
CNTDTOPAY  BCD*4.0  Number of Days to Pay   
AMTINVCHC  BCD*10.3  Total Invoice Amount   
AMTCRHC  BCD*10.3  Total Credit Note Amount   
AMTDRHC  BCD*10.3  Total Debit Note Amount   
AMTPAYMHC  BCD*10.3  Total Receipt Amount   
AMTDISCHC  BCD*10.3  Total Discount Amount   
AMTADJHC  BCD*10.3  Total Adjustment Amount   
AMTWROFHC  BCD*10.3  Total Write-Off Amount   
AMTINTTHC  BCD*10.3  Total Interest Amount   
AMTRIFHC  BCD*10.3  Total Amount of Returned Checks   
AMTINVPDHC  BCD*10.3  Total Amount of Paid Invoices   
AVGDAYSPAY  BCD*5.1  Average Days to Pay   
CNTRF  BCD*3.0  Number of Refunds   
AMTRFHC  BCD*10.3  Total Refund Amount   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.