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: (%-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 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: (%-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:4 entries
0 = Mail
2 = Email (national account)
4 = Email (contact)
5 = Email (multiple contacts)
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