View: Reprint Statement NAT Customers

RotoID: AR0114
Table: ARSTNAT
Protocol: Flat
DLL:ARSTNAT

Keys: 2

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

Fields: 35

Field Index Type Title Attributes Presentation
STMTSEQ 1 Long Statement Run Number E A K R 
IDNATACCT 2 String*12 National Account Number E A K R  Mask: %-12C
STMTDATE 3 Date Statement Run Date E A 
SWPRINTED 4 Integer Statement Printed Flag E A  List:2 entries
0 = No
1 = Yes
NAMEACCT 5 String*60 National Account Name E A 
TEXTSTRE1 6 String*60 NAT Address Line 1 E A 
TEXTSTRE2 7 String*60 NAT Address Line 2 E A 
TEXTSTRE3 8 String*60 NAT Address Line 3 E A 
TEXTSTRE4 9 String*60 NAT Address Line 4 E A 
NAMECITY 10 String*30 NAT City E A 
CODESTATE 11 String*30 NAT State/Prov. E A 
CODEPOST 12 String*20 NAT Zip/Postal Code E A 
CODECTRY 13 String*30 NAT Country E A 
NAMECTAC 14 String*60 NAT Contact Name E A 
TEXTPHON1 15 String*30 NAT Phone Number E A P  Mask: (%-3C) %-3C-%-24C
TEXTPHON2 16 String*30 NAT Fax Number E A P  Mask: (%-3C) %-3C-%-24C
TEXTSTMT 17 String*45 NAT Dunning Message E A 
EMAIL 18 String*50 E-mail E A 
WEBSITE 19 String*100 National Accounts's Web Site E A 
CTACPHONE 20 String*30 Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 21 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 22 String*50 Contact's E-mail E A 
DELMETHOD 23 Integer Delivery Method E A  List:4 entries
0 = Mail
2 = Email (national account)
4 = Email (contact)
5 = Email (multiple contacts)
SWBALFWD 24 Integer Account Type E A 
AMTBGNBLF 25 BCD*10.3 NAT Amount Beginning Balance Forward E A 
AMTEBALFD 26 BCD*10.3 NAT Amount Ending Balance Forward E A 
AMTSTMTBL 27 BCD*10.3 NAT Amount Statement Balance E A 
AMTDUECUR 28 BCD*10.3 NAT Amount Due Current Period E A 
AMTDUEAG1 29 BCD*10.3 NAT Amount Due 1st Period E A 
AMTDUEAG2 30 BCD*10.3 NAT Amount Due 2nd Period E A 
AMTDUEAG3 31 BCD*10.3 NAT Amount Due 3rd Period E A 
AMTDUEAG4 32 BCD*10.3 NAT Amount Due 4th Period E A 
AMTDUEFWD 33 BCD*10.3 NAT Amount Due Forward Balance E A 
AMTCRLIMIT 34 BCD*10.3 Credit Limit E A 
CODECURN 35 String*3 Currency Code E A  Mask: %-3N

This page was generated on 2022-Aug-18

© 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).