Table: Reprint Statement NAT Customers

Table: ARSTNAT
View: AR0114
Record Length: 989

Flags: A R 

Keys: 2

Title Flags Fields
Statement Run No./NAT Number STMTSEQ, IDNATACCT
NAT Number/Statement Run Date D M  IDNATACCT, STMTDATE

Fields: 39

Field Type Title Presentation
STMTSEQ Long Statement Run Number
IDNATACCT String*12 National Account Number Mask: %-12C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
STMTDATE Date Statement Run Date
SWPRINTED Integer Statement Printed Flag List:2 entries
0 = No
1 = Yes
NAMEACCT String*60 National Account Name
TEXTSTRE1 String*60 NAT Address Line 1
TEXTSTRE2 String*60 NAT Address Line 2
TEXTSTRE3 String*60 NAT Address Line 3
TEXTSTRE4 String*60 NAT Address Line 4
NAMECITY String*30 NAT City
CODESTATE String*30 NAT State/Prov.
CODEPOST String*20 NAT Zip/Postal Code
CODECTRY String*30 NAT Country
NAMECTAC String*60 NAT Contact Name
TEXTPHON1 String*30 NAT Phone Number Mask: (%-3C) %-3C-%-24C
TEXTPHON2 String*30 NAT Fax Number Mask: (%-3C) %-3C-%-24C
TEXTSTMT String*45 NAT Dunning Message
EMAIL String*50 E-mail
WEBSITE String*100 National Accounts's 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)
SWBALFWD Integer Account Type
AMTBGNBLF BCD*10.3 NAT Amount Beginning Balance Forward
AMTEBALFD BCD*10.3 NAT Amount Ending Balance Forward
AMTSTMTBL BCD*10.3 NAT Amount Statement Balance
AMTDUECUR BCD*10.3 NAT Amount Due Current Period
AMTDUEAG1 BCD*10.3 NAT Amount Due 1st Period
AMTDUEAG2 BCD*10.3 NAT Amount Due 2nd Period
AMTDUEAG3 BCD*10.3 NAT Amount Due 3rd Period
AMTDUEAG4 BCD*10.3 NAT Amount Due 4th Period
AMTDUEFWD BCD*10.3 NAT Amount Due Forward Balance
AMTCRLIMIT BCD*10.3 Credit Limit
CODECURN String*3 Currency Code Mask: %-3N

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).