# Table: National Accounts

Table: ARNAT
View: AR0028
Record length: 1418
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
National Account Number |  | IDNATACCT
Customer Group Code | D M | IDGRP

## Fields: 101

Field | Type | Title | Presentation
--- | --- | --- | ---
IDNATACCT | String*12 | National Account Number | Mask: %-12C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDGRP | String*6 | Group Code | Mask: %-6N
SWACTV | Integer | Status | List: 2 entries
0 | = | Inactive
1 | = | Active
DATEINAC | Date | Inactive Date |
DATELSTMTN | Date | Date Last Maintained |
SWHOLD | Integer | On Hold | List: 2 entries
0 | = | No
1 | = | Yes
CODEDAB | String*9 | Credit Bureau Number |
DABRTG | String*5 | Credit Bureau Rating |
DATEDAB | Date | Credit Bureau Date |
NAMEACCT | String*60 | National Account Name |
TEXTSTRE1 | String*60 | Address Line 1 |
TEXTSTRE2 | String*60 | Address Line 2 |
TEXTSTRE3 | String*60 | Address Line 3 |
TEXTSTRE4 | String*60 | Address Line 4 |
NAMECITY | String*30 | City |
CODESTATE | String*30 | State/Prov. |
CODEPOST | String*20 | Zip/Postal Code |
CODECTRY | String*30 | Country |
NAMECTAC | String*60 | Contact Name |
TEXTPHON1 | String*30 | Phone Number | Mask: (%-3C) %-3C-%-24C
TEXTPHON2 | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
IDACCTSET | String*6 | Account Set | Mask: %-6N
IDAUTOCASH | String*6 | Autocash Profile |
IDBILLCYCL | String*6 | Billing Cycle | Mask: %-6N
IDSVCCHRG | String*6 | Interest Profile | Mask: %-6N
IDDLNQ | String*6 | Reserved |
CODECURN | String*3 | Currency Code |
SWPRTSTMT | Integer | Print Statements | List: 2 entries
0 | = | No
1 | = | Yes
SWPRTDLNQ | Integer | Reserved |
SWBALFWD | Integer | Account Type | List: 2 entries
0 | = | Open Item
1 | = | Balance Forward
IDRATETYPE | String*2 | Rate Type | Mask: %-2N
AMTCRLIMIT | BCD*10.3 | Credit Limit |
AMTBALDUTC | BCD*10.3 | Balance Due in Cust. Currency |
AMTBALDUHC | BCD*10.3 | Balance Due in Func. Currency |
DATELSTSTM | Date | Date of Last Statement |
AMTLSTSTTC | BCD*10.3 | Last Statement Total Cust. Curr. |
AMTLSTSTHC | BCD*10.3 | Last Statement Total Func. Curr. |
DATEBALFWD | Date | Date Balance Forward Begins |
AMTBLFWDTC | BCD*10.3 | Balance Forward Cust. Curr. |
AMTBLFWDHC | BCD*10.3 | Balance Forward Func. Curr. |
DATERVAL | Date | Reserved |
AMTLSTRVAL | BCD*10.3 | Reserved |
CNTOPENINV | BCD*4.0 | Number of Open Documents |
CNTINVPAID | BCD*4.0 | Number of Paid Invoices |
CNTDAYSPAY | BCD*4.0 | Number of Days to Pay |
DATEINVCHI | Date | Date of Largest Invoice |
DATEBALHI | Date | Date of Highest Balance |
DATEINVHIL | Date | Date of Largest Invoice Last Yr. |
DATEBALHIL | Date | Date of Highest Bal. Last Yr. |
DATELASTAC | Date | Date of Last Activity |
DATELASTIN | Date | Date of Last Invoice |
DATELASTCR | Date | Date of Last Credit Note |
DATELASTDR | Date | Date of Last Debit Note |
DATELASTPA | Date | Date of Last Receipt |
DATELASTDI | Date | Date of Last Discount |
DATELASTAD | Date | Date of Last Adjustment |
DATELASTWR | Date | Date of Last Write-Off |
DATELASTRI | Date | Date of Last Returned Check |
DATELSTINT | Date | Date of Last Interest Charge |
DATELASTDL | Date | Reserved |
IDINVCHIGH | String*22 | Largest Invoice Number |
IDINVCHILY | String*22 | Largest Invoice Number Last Yr. |
AMTINVHITC | BCD*10.3 | Largest Invoice - Cust. Curr. |
AMTBALHITC | BCD*10.3 | Highest Balance - Cust. Curr. |
AMTINVHLIT | BCD*10.3 | Lgst. Inv. Last Yr. Cust. Curr. |
AMTBALHILT | BCD*10.3 | High Bal. Last Yr. - Cust. Curr. |
AMTINVTC | BCD*10.3 | Last Invoice Amt. - Cust. Curr. |
AMTCRTC | BCD*10.3 | Last Cr. Note Amt. - Cust. Curr. |
AMTDRTC | BCD*10.3 | Last Dr. Note Amt. - Cust. Curr. |
AMTPAYMTC | BCD*10.3 | Last Receipt - Cust. Curr. |
AMTDISCTC | BCD*10.3 | Last Discount Amt. - Cust. Curr. |
AMTADJTC | BCD*10.3 | Last Adj. Amt. - Cust. Curr. |
AMTWROFTC | BCD*10.3 | Last Write-Off Amt. Cust. Curr. |
AMTRIFTC | BCD*10.3 | Last Ret'd. Chk. Amt. Cust. Curr |
AMTINTTTC | BCD*10.3 | Last Int. Charge - Cust. Curr. |
AMTINVHIHC | BCD*10.3 | Largest Invoice - Func. Curr. |
AMTBALHIHC | BCD*10.3 | Highest Balance - Func. Curr. |
AMTINVHILH | BCD*10.3 | Lgst. Inv. Last Yr. Func. Curr. |
AMTBALHILH | BCD*10.3 | High Bal. Last Yr. - Func. Curr. |
AMTINVHC | BCD*10.3 | Last Invoice Amt. - Func. Curr. |
AMTCRHC | BCD*10.3 | Last Cr. Note Amt. - Func. Curr. |
AMTDRHC | BCD*10.3 | Last Dr. Note Amt. - Func. Curr. |
AMTPAYMHC | BCD*10.3 | Last Receipt - Func. Curr. |
AMTDISCHC | BCD*10.3 | Last Discount Amt. - Func. Curr. |
AMTADJHC | BCD*10.3 | Last Adj. Amt. - Func. Curr. |
AMTWROFHC | BCD*10.3 | Last Write-Off Amt. Func. Curr. |
AMTRIFHC | BCD*10.3 | Last Ret'd. Chk. Amt. Func. Curr |
AMTINTTHC | BCD*10.3 | Last Int. Charge - Func. Curr. |
EMAIL | String*50 | E-mail |
WEBSITE | String*100 | Web Site |
CTACPHONE | String*30 | Contact's Phone | Mask: (%-3C) %-3C-%-24C
CTACFAX | String*30 | Contact's Fax | Mask: (%-3C) %-3C-%-24C
CTACEMAIL | String*50 | Contact's E-mail |
DELMETHOD | Integer | Delivery Method | List: 5 entries
0 | = | Mail
1 | = | Fax
2 | = | E-mail
3 | = | Contact's Fax
4 | = | Contact's E-mail
RTGAMTTC | BCD*10.3 | Amount Retained - Cust. Curr. |
RTGAMTHC | BCD*10.3 | Amount Retained - Func. Curr. |
VALUES | Long | Optional Fields |

This page was generated on 2004-Oct-28

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