View: National Account Statistics

RotoID: AR0029
Table: ARNSM
Protocol: Flat
DLL:ARNSM

Keys: 1

Title Fields
Natl. Acct., Year and Period IDNATLACCT, CNTYR, CNTPERD

Fields: 74

Field Index Type Title Attributes Presentation
IDNATLACCT 1 String*12 National Account 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 Credit Notes E A 
CNTDR 6 BCD*3.0 Number of Debit Notes 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 
CNTDYTOPY 14 BCD*3.0 Number of Days to Pay E A 
AVGDYTOPY 15 BCD*4.1 Average Days to Pay A C 
AMTINVHCUR 16 BCD*10.3 Total Invoices in Func. Currency E A 
AMTCRHCUR 17 BCD*10.3 Total Credits in Func. Currency E A 
AMTDRHCUR 18 BCD*10.3 Total Debits in Func. Currency E A 
AMTPYMHCUR 19 BCD*10.3 Total Receipts in Func. Currency E A 
AMTDSCHCUR 20 BCD*10.3 Total Discounts in Func. Curr. E A 
AMTADJHCUR 21 BCD*10.3 Total Adjustments in Func. Curr. E A 
AMTWRFHCUR 22 BCD*10.3 Total Write-Offs in Func. Curren E A 
AMTINTHCUR 23 BCD*10.3 Total Interest in Func. Curr. E A 
AMTRIFHCUR 24 BCD*10.3 Total Ret'd. Checks Func. Curr. E A 
AMTINVPD 25 BCD*10.3 Total Invoices Paid Func. Curr. E A 
AMTINVTCUR 26 BCD*10.3 Total Invoices in Cust. Curr. E A 
AMTCRTCUR 27 BCD*10.3 Total Credits in Cust. Curr. E A 
AMTDRTCUR 28 BCD*10.3 Total Debits in Cust. Curr. E A 
AMTPYMTCUR 29 BCD*10.3 Total Receipts in Cust. Curr. E A 
AMTDSCTCUR 30 BCD*10.3 Total Discounts in Cust. Curr. E A 
AMTADJTCUR 31 BCD*10.3 Total Adjustments in Cust. Curr. E A 
AMTWRFTCUR 32 BCD*10.3 Total Write-Offs in Cust. Curr. E A 
AMTINTTCUR 33 BCD*10.3 Total Interest in Cust. Curr. E A 
AMTRIFTCUR 34 BCD*10.3 Total Ret'd. Checks Cust. Curr. E A 
AMTINVPTHC 35 BCD*10.3 Total Invoices Paid Cust. Curr. E A 
CNTRF 36 BCD*3.0 Number of Refunds E A 
AMTRFHC 37 BCD*10.3 Total Refunds in Func. Currency E A 
AMTRFTC 38 BCD*10.3 Total Refunds in Cust. Currency E A 
YTDCNTIN 39 BCD*5.0 YTD Number of Invoices E A 
YTDCNTCR 40 BCD*5.0 YTD Number of Credits E A 
YTDCNTDR 41 BCD*5.0 YTD Number of Debits E A 
YTDCNTPY 42 BCD*5.0 YTD Number of Receipts E A 
YTDCNTED 43 BCD*5.0 YTD Number of Discounts E A 
YTDCNTAD 44 BCD*5.0 YTD Number of Adjustments E A 
YTDCNTWO 45 BCD*5.0 YTD Number of Write-Offs E A 
YTDCNTIT 46 BCD*5.0 YTD Number of Interest Charges E A 
YTDCNTRIF 47 BCD*5.0 YTD Number of Returned Checks E A 
YTDCNTINPD 48 BCD*5.0 YTD Number of Invoices Paid E A 
YTDCNTRF 49 BCD*5.0 YTD Number of Refunds E A 
YTDCNTDTP 50 BCD*5.0 YTD Number of Days to Pay E A 
YTDHCIN 51 BCD*10.3 YTD Invoices in Func. Curr. E A 
YTDHCCR 52 BCD*10.3 YTD Credits in Func. Curr. E A 
YTDHCDR 53 BCD*10.3 YTD Debits in Func. Curr. E A 
YTDHCPY 54 BCD*10.3 YTD Receipts in Func. Curr. E A 
YTDHCED 55 BCD*10.3 YTD Discounts in Func. Curr. E A 
YTDHCAD 56 BCD*10.3 YTD Adjustments in Func. Curr. E A 
YTDHCWO 57 BCD*10.3 YTD Write-Offs in Func. Curr. E A 
YTDHCIT 58 BCD*10.3 YTD Interest in Func. Curr. E A 
YTDHCRIF 59 BCD*10.3 YTD Ret'd Checks in Func. Curr. E A 
YTDHCINPD 60 BCD*10.3 YTD Invoices Pd. in Func. Curr. E A 
YTDHCRF 61 BCD*10.3 YTD Refunds in Func. Curr. E A 
YTDTCIN 62 BCD*10.3 YTD Invoices in Cust. Curr. E A 
YTDTCCR 63 BCD*10.3 YTD Credits in Cust. Curr. E A 
YTDTCDR 64 BCD*10.3 YTD Debits in Cust. Curr. E A 
YTDTCPY 65 BCD*10.3 YTD Receipts in Cust. Curr. E A 
YTDTCED 66 BCD*10.3 YTD Discounts in Cust. Curr. E A 
YTDTCAD 67 BCD*10.3 YTD Adjustments in Cust. Curr. E A 
YTDTCWO 68 BCD*10.3 YTD Write-Offs in Cust. Curr. E A 
YTDTCIT 69 BCD*10.3 YTD Interest in Cust. Curr. E A 
YTDTCRIF 70 BCD*10.3 YTD Ret'd Checks in Cust. Curr. E A 
YTDTCINPD 71 BCD*10.3 YTD Invoices Pd. in Cust. Curr. E A 
YTDTCRF 72 BCD*10.3 YTD Refunds in Cust. Curr. E A 
YTDCNTADTP 73 BCD*6.1 YTD Average Days to Pay E A 
YTDACTIVE 74 Integer Enable YTD Calculations E A  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

© 2023 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).