# View: National Accounts

RotoID: AR0028
Table: ARNAT
DLL: ARNAT

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
AR0411 | ARNATO | National Account Optional Field | ARNATO

## 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: 5 entries
0 | = | Mail
1 | = | Fax
2 | = | E-mail
3 | = | Contact's Fax
4 | = | Contact's E-mail
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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.