# View: National Accounts

RotoID: AR0028
Tables: ARNAT
DLL: ARNAT

## Compositions: 1

RotoID | Title | Tables | DLL
--- | --- | --- | ---
AR0411 | National Account Optional Field Values | ARNATO | ARNATO

## Keys: 2

Title | Fields
--- | ---
National Account Number Values | IDNATACCT
Customer Group Code Values | IDGRP

## Fields: 99

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

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.