View: Customer Statistics

RotoID: AR0022
Table: ARCSM
Protocol: Flat
DLL: ARCSM

Compositions: 0

Keys: 1

Title	Fields

Customer No., Year and Period	IDCUST, CNTYR, CNTPERD

Fields: 75

Field	Index	Type	Title	Attributes	Presentation

IDCUST	1	String*12	Customer 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 Credits	E A
CNTDR	6	BCD*3.0	Number of Debits	E A
CNTPAYM	7	BCD*3.0	Number of Receipts	E A
CNTDISC	8	BCD*3.0	Number of Discounts	E A
CNTADJ	9	BCD*3.0	Number of Adjustments	E A
CNTWROF	10	BCD*3.0	Number of Write-Offs	E A
CNTINTT	11	BCD*3.0	Number of Interest Charges	E A
CNTRIF	12	BCD*3.0	Number of Returned Checks	E A
CNTINVCPD	13	BCD*3.0	Number of Invoices Paid	E A
CNTDTOPAY	14	BCD*3.0	Number of Days to Pay	E A
AMTINVCHC	15	BCD*10.3	Total Invoices in Func. Curr.	E A
AMTCRHC	16	BCD*10.3	Total Credits in Func. Curr.	E A
AMTDRHC	17	BCD*10.3	Total Debits in Func. Curr.	E A
AMTPAYMHC	18	BCD*10.3	Total Receipts in Func. Curr.	E A
AMTDISCHC	19	BCD*10.3	Total Discounts in Func. Curr.	E A
AMTADJHC	20	BCD*10.3	Total Adjustments in Func. Curr.	E A
AMTWROFHC	21	BCD*10.3	Total Write-Offs in Func. Curr.	E A
AMTINTTHC	22	BCD*10.3	Total Interest in Func. Curr.	E A
AMTRIFHC	23	BCD*10.3	Total Ret'd Checks in Func. Curr.	E A
AMTINVPDHC	24	BCD*10.3	Total Invoices Pd. in Func. Curr.	E A
AMTINVCTC	25	BCD*10.3	Total Invoices in Cust. Curr.	E A
AMTCRTC	26	BCD*10.3	Total Credits in Cust. Curr.	E A
AMTDRTC	27	BCD*10.3	Total Debits in Cust. Curr.	E A
AMTPAYMTC	28	BCD*10.3	Total Receipts in Cust. Curr.	E A
AMTDISCTC	29	BCD*10.3	Total Discounts in Cust. Curr.	E A
AMTADJTC	30	BCD*10.3	Total Adjustments in Cust. Curr.	E A
AMTWROFTC	31	BCD*10.3	Total Write-Offs in Cust. Curr.	E A
AMTINTTTC	32	BCD*10.3	Total Interest in Cust. Curr.	E A
AMTRIFTC	33	BCD*10.3	Total Ret'd Checks in Cust. Curr.	E A
AMTINVPDTC	34	BCD*10.3	Total Invoices Pd. in Cust. Curr.	E A
AMTBARVALT	35	BCD*10.3	Revaluation Bal. in Func. Curr.	E A
AVGDAYSPAY	36	BCD*5.1	Average Days to Pay	A C
CNTRF	37	BCD*3.0	Number of Refunds	E A
AMTRFHC	38	BCD*10.3	Total Refunds in Func. Curr.	E A
AMTRFTC	39	BCD*10.3	Total Refunds in Cust. Curr.	E A
YTDCNTIN	50	BCD*5.0	YTD Number of Invoices	E
YTDCNTCR	51	BCD*5.0	YTD Number of Credits	E
YTDCNTDR	52	BCD*5.0	YTD Number of Debits	E
YTDCNTPY	53	BCD*5.0	YTD Number of Receipts	E
YTDCNTED	54	BCD*5.0	YTD Number of Discounts	E
YTDCNTAD	55	BCD*5.0	YTD Number of Adjustments	E
YTDCNTWO	56	BCD*5.0	YTD Number of Write-Offs	E
YTDCNTIT	57	BCD*5.0	YTD Number of Interest Charges	E
YTDCNTRIF	58	BCD*5.0	YTD Number of Returned Checks	E
YTDCNTINPD	59	BCD*5.0	YTD Number of Invoices Paid	E
YTDCNTRF	60	BCD*5.0	YTD Number of Refunds	E
YTDCNTDTP	61	BCD*5.0	YTD Number of Days to Pay	E
YTDHCIN	62	BCD*10.3	YTD Invoices in Func. Curr.	E
YTDHCCR	63	BCD*10.3	YTD Credits in Func. Curr.	E
YTDHCDR	64	BCD*10.3	YTD Debits in Func. Curr.	E
YTDHCPY	65	BCD*10.3	YTD Receipts in Func. Curr.	E
YTDHCED	66	BCD*10.3	YTD Discounts in Func. Curr.	E
YTDHCAD	67	BCD*10.3	YTD Adjustments in Func. Curr.	E
YTDHCWO	68	BCD*10.3	YTD Write-Offs in Func. Curr.	E
YTDHCIT	69	BCD*10.3	YTD Interest in Func. Curr.	E
YTDHCRIF	70	BCD*10.3	YTD Ret'd Checks in Func. Curr.	E
YTDHCINPD	71	BCD*10.3	YTD Invoices Pd. in Func. Curr.	E
YTDHCRF	72	BCD*10.3	YTD Refunds in Func. Curr.	E
YTDTCIN	73	BCD*10.3	YTD Invoices in Cust. Curr.	E
YTDTCCR	74	BCD*10.3	YTD Credits in Cust. Curr.	E
YTDTCDR	75	BCD*10.3	YTD Debits in Cust. Curr.	E
YTDTCPY	76	BCD*10.3	YTD Receipts in Cust. Curr.	E
YTDTCED	77	BCD*10.3	YTD Discounts in Cust. Curr.	E
YTDTCAD	78	BCD*10.3	YTD Adjustments in Cust. Curr.	E
YTDTCWO	79	BCD*10.3	YTD Write-Offs in Cust. Curr.	E
YTDTCIT	80	BCD*10.3	YTD Interest in Cust. Curr.	E
YTDTCRIF	81	BCD*10.3	YTD Ret'd Checks in Cust. Curr.	E
YTDTCINPD	82	BCD*10.3	YTD Invoices Pd. in Cust. Curr.	E
YTDTCRF	83	BCD*10.3	YTD Refunds in Cust. Curr.	E
YTDCNTADTP	84	BCD*6.1	YTD Average Days to Pay	E
YTDACTIVE	85	Integer	Enable YTD Calculations	E

This page was generated on 2009-Nov-19