View: Salesperson Statistics

RotoID: AR0030
Table: ARSPS
Protocol: Flat
DLL:ARSPS

Keys: 1

Title Fields

Salesperson, Year, Period CODESLSPCNTYRCNTPERD

Fields: 28

Field Index Type Title Attributes Presentation

CODESLSP 1 String*8 Salesperson E A K R  Mask: %-8N
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 
CNTWROF 9 BCD*4.0 Number of Write-Offs E A 
AMTINVC 10 BCD*10.3 Total Invoice Amount E A 
AMTCR 11 BCD*10.3 Total Credit Note Amount E A 
AMTDR 12 BCD*10.3 Total Debit Note Amount E A 
AMTPAYM 13 BCD*10.3 Total Receipt Amount E A 
AMTDISC 14 BCD*10.3 Total Discount Amount E A 
AMTWROF 15 BCD*10.3 Total Write-Off Amount E A 
YTDCNTIN 16 BCD*5.0 YTD Number of Invoices E A 
YTDCNTCR 17 BCD*5.0 YTD Number of Credit Notes E A 
YTDCNTDR 18 BCD*5.0 YTD Number of Debit Notes E A 
YTDCNTPY 19 BCD*5.0 YTD Number of Receipts E A 
YTDCNTED 20 BCD*5.0 YTD Number of Discounts E A 
YTDCNTWO 21 BCD*5.0 YTD Number of Write-Offs E A 
YTDHCIN 22 BCD*10.3 YTD Total Invoice Amount E A 
YTDHCCR 23 BCD*10.3 YTD Total Credit Note Amount E A 
YTDHCDR 24 BCD*10.3 YTD Total Debit Note Amount E A 
YTDHCPY 25 BCD*10.3 YTD Total Receipt Amount E A 
YTDHCED 26 BCD*10.3 YTD Total Discount Amount E A 
YTDHCWO 27 BCD*10.3 YTD Total Write-Off Amount E A 
YTDACTIVE 28 Integer Enable YTD Calculations E A  List:2 entries
0 = No
1 = Yes