# Table: Customer Statistics

Table: ARCSM
View: AR0022
Record length: 313
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Customer No., Year and Period |  | IDCUST, CNTYR, CNTPERD

## Fields: 43

Field | Type | Title | Presentation
--- | --- | --- | ---
IDCUST | String*12 | Customer Number | Mask: %-12C
CNTYR | String*4 | Year | Mask: %04D
CNTPERD | String*2 | Period | Mask: %02D
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CNTINVC | BCD*3.0 | Number of Invoices |
CNTCR | BCD*3.0 | Number of Credits |
CNTDR | BCD*3.0 | Number of Debits |
CNTPAYM | BCD*3.0 | Number of Receipts |
CNTDISC | BCD*3.0 | Number of Discounts |
CNTADJ | BCD*3.0 | Number of Adjustments |
CNTWROF | BCD*3.0 | Number of Write-Offs |
CNTINTT | BCD*3.0 | Number of Interest Charges |
CNTRIF | BCD*3.0 | Number of Returned Checks |
CNTINVCPD | BCD*3.0 | Number of Invoices Paid |
CNTDTOPAY | BCD*3.0 | Number of Days to Pay |
AMTINVCHC | BCD*10.3 | Total Invoices in Func. Curr. |
AMTCRHC | BCD*10.3 | Total Credits in Func. Curr. |
AMTDRHC | BCD*10.3 | Total Debits in Func. Curr. |
AMTPAYMHC | BCD*10.3 | Total Receipts in Func. Curr. |
AMTDISCHC | BCD*10.3 | Total Discounts in Func. Curr. |
AMTADJHC | BCD*10.3 | Total Adjustments in Func. Curr. |
AMTWROFHC | BCD*10.3 | Total Write-Offs in Func. Curr. |
AMTINTTHC | BCD*10.3 | Total Interest in Func. Curr. |
AMTRIFHC | BCD*10.3 | Total Ret'd Checks in Func. Curr |
AMTINVPDHC | BCD*10.3 | Total Invoices Pd. in Func. Curr |
AMTINVCTC | BCD*10.3 | Total Invoices in Cust. Curr. |
AMTCRTC | BCD*10.3 | Total Credits in Cust. Curr. |
AMTDRTC | BCD*10.3 | Total Debits in Cust. Curr. |
AMTPAYMTC | BCD*10.3 | Total Receipts in Cust. Curr. |
AMTDISCTC | BCD*10.3 | Total Discounts in Cust. Curr. |
AMTADJTC | BCD*10.3 | Total Adjustments in Cust. Curr. |
AMTWROFTC | BCD*10.3 | Total Write-Offs in Cust. Curr. |
AMTINTTTC | BCD*10.3 | Total Interest in Cust. Curr. |
AMTRIFTC | BCD*10.3 | Total Ret'd Checks in Cust. Curr |
AMTINVPDTC | BCD*10.3 | Total Invoices Pd. in Cust. Curr |
AMTBARVALT | BCD*10.3 | Revaluation Bal. in Func. Curr. |
AVGDAYSPAY | BCD*5.1 | Average Days to Pay |
CNTRF | BCD*3.0 | Number of Refunds |
AMTRFHC | BCD*10.3 | Total Refunds in Func. Curr. |
AMTRFTC | BCD*10.3 | Total Refunds in Cust. Curr. |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.