View: National Accounts

RotoID: AR0028
Table: ARNAT
Protocol: Header
DLL:ARNAT

Compositions: 2

RotoID Tables Title DLL
AR0411 ARNATO National Account Optional Field Values ARNATO
AR0227 National Acct Contact Selections ARNATMT

Keys: 2

Title Fields
National Account Number IDNATACCT
Customer Group Code IDGRP

Fields: 106

Field Index Type Title Attributes Presentation
IDNATACCT 1 String*12 National Account Number E A K R  Mask: %-12C
IDGRP 2 String*6 Group Code E A  Mask: %-6N
SWACTV 3 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
DATEINAC 4 Date Inactive Date E A C 
DATELSTMTN 5 Date Date Last Maintained E A C 
SWHOLD 6 Integer On Hold E A  List:2 entries
0 = No
1 = Yes
CODEDAB 7 String*9 Credit Bureau Number E A 
DABRTG 8 String*5 Credit Bureau Rating E A 
DATEDAB 9 Date Credit Bureau Date E A 
NAMEACCT 10 String*60 National Account Name E A 
TEXTSTRE1 11 String*60 Address Line 1 E A 
TEXTSTRE2 12 String*60 Address Line 2 E A 
TEXTSTRE3 13 String*60 Address Line 3 E A 
TEXTSTRE4 14 String*60 Address Line 4 E A 
NAMECITY 15 String*30 City E A 
CODESTATE 16 String*30 State/Prov. E A 
CODEPOST 17 String*20 Zip/Postal Code E A 
CODECTRY 18 String*30 Country E A 
NAMECTAC 19 String*60 Contact Name E A 
TEXTPHON1 20 String*30 Phone Number E A P  Mask: (%-3C) %-3C-%-24C
TEXTPHON2 21 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
IDACCTSET 22 String*6 Account Set E A  Mask: %-6N
IDAUTOCASH 23 String*6 Autocash Profile E A 
IDBILLCYCL 24 String*6 Billing Cycle E A  Mask: %-6N
IDSVCCHRG 25 String*6 Interest Profile E A  Mask: %-6N
IDDLNQ 26 String*6 Reserved E 
CODECURN 27 String*3 Currency Code A  Mask: %-3N
SWPRTSTMT 28 Integer Print Statements E A  List:2 entries
0 = No
1 = Yes
SWPRTDLNQ 29 Integer Reserved E 
SWBALFWD 30 Integer Account Type E A  List:2 entries
0 = Open Item
1 = Balance Forward
IDRATETYPE 31 String*2 Rate Type E A  Mask: %-2N
AMTCRLIMIT 32 BCD*10.3 Credit Limit E A 
AMTBALDUTC 33 BCD*10.3 Balance Due in Cust. Currency E A C 
AMTBALDUHC 34 BCD*10.3 Balance Due in Func. Currency E A C 
DATELSTSTM 35 Date Date of Last Statement E A C 
AMTLSTSTTC 36 BCD*10.3 Last Statement Total Cust. Curr. E A C 
AMTLSTSTHC 37 BCD*10.3 Last Statement Total Func. Curr. E A 
DATEBALFWD 38 Date Date Balance Forward Begins E A C 
AMTBLFWDTC 39 BCD*10.3 Balance Forward Cust. Curr. E A C 
AMTBLFWDHC 40 BCD*10.3 Balance Forward Func. Curr. E A 
DATERVAL 41 Date Reserved E 
AMTLSTRVAL 42 BCD*10.3 Reserved E 
CNTOPENINV 43 BCD*4.0 Number of Open Documents E A C 
CNTINVPAID 44 BCD*4.0 Number of Paid Invoices E A 
CNTDAYSPAY 45 BCD*4.0 Number of Days to Pay E A 
AVGDAYSPAY 46 BCD*5.1 Average Days to Pay A C 
DATEINVCHI 47 Date Date of Largest Invoice E A 
DATEBALHI 48 Date Date of Highest Balance E A 
DATEINVHIL 49 Date Date of Largest Invoice Last Yr. E A 
DATEBALHIL 50 Date Date of Highest Bal. Last Yr. E A 
DATELASTAC 51 Date Date of Last Activity E A C 
DATELASTIN 52 Date Date of Last Invoice E A 
DATELASTCR 53 Date Date of Last Credit Note E A 
DATELASTDR 54 Date Date of Last Debit Note E A 
DATELASTPA 55 Date Date of Last Receipt E A 
DATELASTDI 56 Date Date of Last Discount E A 
DATELASTAD 57 Date Date of Last Adjustment E A 
DATELASTWR 58 Date Date of Last Write-Off E A 
DATELASTRI 59 Date Date of Last Returned Check E A 
DATELSTINT 60 Date Date of Last Interest Charge E A 
DATELASTDL 61 Date Reserved E 
IDINVCHIGH 62 String*22 Largest Invoice Number E A C 
IDINVCHILY 63 String*22 Largest Invoice Number Last Yr. E A C 
AMTINVHITC 64 BCD*10.3 Largest Invoice - Cust. Curr. E A 
AMTBALHITC 65 BCD*10.3 Highest Balance - Cust. Curr. E A 
AMTINVHLIT 66 BCD*10.3 Lgst. Inv. Last Yr. Cust. Curr. E A 
AMTBALHILT 67 BCD*10.3 High Bal. Last Yr. - Cust. Curr. E A 
AMTINVTC 68 BCD*10.3 Last Invoice Amt. - Cust. Curr. E A 
AMTCRTC 69 BCD*10.3 Last Cr. Note Amt. - Cust. Curr. E A 
AMTDRTC 70 BCD*10.3 Last Dr. Note Amt. - Cust. Curr. E A 
AMTPAYMTC 71 BCD*10.3 Last Receipt - Cust. Curr. E A 
AMTDISCTC 72 BCD*10.3 Last Discount Amt. - Cust. Curr. E A 
AMTADJTC 73 BCD*10.3 Last Adj. Amt. - Cust. Curr. E A 
AMTWROFTC 74 BCD*10.3 Last Write-Off Amt. Cust. Curr. E A 
AMTRIFTC 75 BCD*10.3 Last Ret'd. Chk. Amt. Cust. Curr. E A 
AMTINTTTC 76 BCD*10.3 Last Int. Charge - Cust. Curr. E A 
AMTINVHIHC 77 BCD*10.3 Largest Invoice - Func. Curr. E A 
AMTBALHIHC 78 BCD*10.3 Highest Balance - Func. Curr. E A 
AMTINVHILH 79 BCD*10.3 Lgst. Inv. Last Yr. Func. Curr. E A 
AMTBALHILH 80 BCD*10.3 High Bal. Last Yr. - Func. Curr. E A 
AMTINVHC 81 BCD*10.3 Last Invoice Amt. - Func. Curr. E A 
AMTCRHC 82 BCD*10.3 Last Cr. Note Amt. - Func. Curr. E A 
AMTDRHC 83 BCD*10.3 Last Dr. Note Amt. - Func. Curr. E A 
AMTPAYMHC 84 BCD*10.3 Last Receipt - Func. Curr. E A 
AMTDISCHC 85 BCD*10.3 Last Discount Amt. - Func. Curr. E A 
AMTADJHC 86 BCD*10.3 Last Adj. Amt. - Func. Curr. E A 
AMTWROFHC 87 BCD*10.3 Last Write-Off Amt. Func. Curr. E A 
AMTRIFHC 88 BCD*10.3 Last Ret'd. Chk. Amt. Func. Curr E A 
AMTINTTHC 89 BCD*10.3 Last Int. Charge - Func. Curr. E A 
EMAIL 98 String*50 E-mail E A 
WEBSITE 99 String*100 Web Site E A 
CTACPHONE 100 String*30 Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 101 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 102 String*50 Contact's E-mail E A 
DELMETHOD 103 Integer Delivery Method E A  List:4 entries
0 = Mail
2 = Email (national account)
4 = Email (contact)
5 = Email (multiple contacts)
RTGAMTTC 104 BCD*10.3 Amount Retained - Cust. Curr. E A C 
RTGAMTHC 105 BCD*10.3 Amount Retained - Func. Curr. E A C 
VALUES 106 Long Optional Fields E A C 
PROCESSCMD 107 Integer Process Command Code E A C  List:1 entries
0 = Insert Optional Fields
DATELASTRF 108 Date Date of Last Refund. E A 
AMTLASTRFT 109 BCD*10.3 Last Refund Amt. - Cust. Curr. E A 
AMTLASTRFH 110 BCD*10.3 Last Refund Amt. - Func. Curr. E A 
SWCHKLIMIT 111 Integer Check Credit Limit E A  List:2 entries
0 = No
1 = Yes
SWCHKOVER 112 Integer Check Overdue Amounts E A  List:2 entries
0 = No
1 = Yes
OVERDAYS 113 Integer Days Overdue E A 
OVERAMT 114 BCD*10.3 Amount Overdue E A 

This page was generated on 2021-Nov-24

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