Table: National Accounts

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

Keys: 2

Title  Flags  Fields

National Account Number  IDNATACCT
Customer Group Code  D M  IDGRP

Fields: 108

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: %-30c
TEXTPHON2  String*30  Fax Number  Mask: %-30c
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  Mask: %-3N
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: %-30c
CTACFAX  String*30  Contact's Fax  Mask: %-30c
CTACEMAIL  String*50  Contact's E-mail   
DELMETHOD  Integer  Delivery Method  List: 3 entries
0=Mail
2=E-mail
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   
DATELASTRF  Date  Date of Last Refund.   
AMTLASTRFT  BCD*10.3  Last Refund Amt. - Cust. Curr.   
AMTLASTRFH  BCD*10.3  Last Refund Amt. - Func. Curr.   
SWCHKLIMIT  Integer  Check Credit Limit  List: 2 entries
0=No
1=Yes
SWCHKOVER  Integer  Check Overdue Amounts  List: 2 entries
0=No
1=Yes
OVERDAYS  Integer  Days Overdue   
OVERAMT  BCD*10.3  Amount Overdue   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.