View: Reprint Statement Customers

RotoID: AR0111
Table: ARSTCUS
Protocol: Flat
DLL:ARSTCUS

Keys: 3

Title Fields
Statement Run No./Customer Numbe STMTSEQ, IDCUST
NAT Statement Switch/Customer No SWNATSTMT, IDCUST, STMTDATE
Statement Run No./National Accou STMTSEQ, IDNATACCT

Fields: 151

Field Index Type Title Attributes Presentation
STMTSEQ 1 Long Statement Run Number E A K R 
IDCUST 2 String*12 Customer Number E A K R  Mask: %-12C
SWPRINTED 3 Integer Statement Printed Flag E A  List:2 entries
0 = No
1 = Yes
SWNATSTMT 4 Integer NAT Statement Switch E A  List:3 entries
0 = Customer Statements
1 = National Acct. Statements
2 = Letters or Labels
IDNATACCT 5 String*12 National Account Number E A  Mask: %-12C
STMTDATE 6 Date Statement Run Date E A 
TEXTSNAM 7 String*10 Short Name E A 
IDGRP 8 String*6 Group Code E A  Mask: %-6N
SWACTV 9 Integer Status E A 
DATEINAC 10 Date Inactive Date E A 
DATELASTMN 11 Date Date Last Maintained E A 
SWHOLD 12 Integer On Hold E A 
DATESTART 13 Date Start Date E A 
IDPPNT 14 String*12 Reserved E A 
CODEDAB 15 String*9 Credit Bureau Number E A 
CODEDABRTG 16 String*5 Credit Bureau Rating E A 
DATEDAB 17 Date Credit Bureau Date E A 
NAMECUST 18 String*60 Customer Name E A 
TEXTSTRE1 19 String*60 Address Line 1 E A 
TEXTSTRE2 20 String*60 Address Line 2 E A 
TEXTSTRE3 21 String*60 Address Line 3 E A 
TEXTSTRE4 22 String*60 Address Line 4 E A 
NAMECITY 23 String*30 City E A 
CODESTTE 24 String*30 State/Prov. E A 
CODEPSTL 25 String*20 Zip/Postal Code E A 
CODECTRY 26 String*30 Country E A 
NAMECTAC 27 String*60 Contact Name E A 
TEXTPHON1 28 String*30 Phone Number E A P  Mask: (%-3C) %-3C-%-24C
TEXTPHON2 29 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
CODETERR 30 String*6 Territory Code E A  Mask: %-6N
IDACCTSET 31 String*6 Account Set E A  Mask: %-6N
IDAUTOCASH 32 String*6 Autocash Profile E A 
IDBILLCYCL 33 String*6 Billing Cycle E A  Mask: %-6N
IDSVCCHRG 34 String*6 Interest Profile E A  Mask: %-6N
IDDLNQ 35 String*6 Reserved E A 
CODECURN 36 String*3 Currency Code E A  Mask: %-3N
SWPRTSTMT 37 Integer Print Statements E A  List:2 entries
0 = No
1 = Yes
SWPRTDLNQ 38 Integer Reserved E A 
SWBALFWD 39 Integer Account Type E A  List:2 entries
0 = Open Item
1 = Balance Forward
CODETERM 40 String*6 Terms E A  Mask: %-6N
IDRATETYPE 41 String*2 Rate Type E A  Mask: %-2N
CODETAXGRP 42 String*12 Tax Group E A  Mask: %-12N
IDTAXREGI1 43 String*20 Tax Registration No. 1 E A 
IDTAXREGI2 44 String*20 Tax Registration No. 2 E A 
IDTAXREGI3 45 String*20 Tax Registration No. 3 E A 
IDTAXREGI4 46 String*20 Tax Registration No. 4 E A 
IDTAXREGI5 47 String*20 Tax Registration No. 5 E A 
TAXSTTS1 48 Integer Tax Class Code 1 E A 
TAXSTTS2 49 Integer Tax Class Code 2 E A 
TAXSTTS3 50 Integer Tax Class Code 3 E A 
TAXSTTS4 51 Integer Tax Class Code 4 E A 
TAXSTTS5 52 Integer Tax Class Code 5 E A 
AMTCRLIMT 53 BCD*10.3 Credit Limit (Cust. Curr.) E A 
AMTBALDUET 54 BCD*10.3 Balance Due in Cust. Curr. E A 
AMTBALDUEH 55 BCD*10.3 Balance Due in Func. Curr. E A 
DATELASTST 56 Date Date of Last Statement E A 
AMTLASTSTT 57 BCD*10.3 Last Statement Total Cust. Curr. E A 
AMTLASTSTH 58 BCD*10.3 Reserved E A 
DTBEGBALFW 59 Date Date of Last Bal. Fwd. Statement E A 
AMTBALFWDT 60 BCD*10.3 Beginning Bal. on Last Statement E A 
AMTBALFWDH 61 BCD*10.3 Reserved E A 
DTLASTRVAL 62 Date Date of Last Revaluation E A 
AMTBALLARV 63 BCD*10.3 Last Revaluation Balance E A 
CNTOPENINV 64 BCD*4.0 Number of Open Documents E A 
CNTINVPAID 65 BCD*4.0 Number of Paid Invoices E A 
DAYSTOPAY 66 BCD*4.0 Number of Days to Pay E A 
DATEINVCHI 67 Date Date of Largest Invoice E A 
DATEBALHI 68 Date Date of Highest Balance E A 
DATEINVHIL 69 Date Date of Largest Invoice Last Yr. E A 
DATEBALHIL 70 Date Date of Highest Balance Last Yr. E A 
DATELASTAC 71 Date Date of Last Activity E A 
DATELASTIV 72 Date Date of Last Invoice E A 
DATELASTCR 73 Date Date of Last Credit Note E A 
DATELASTDR 74 Date Date of Last Debit Note E A 
DATELASTPA 75 Date Date of Last Receipt E A 
DATELASTDI 76 Date Date of Last Discount E A 
DATELASTAD 77 Date Date of Last Adjustment E A 
DATELASTWR 78 Date Date of Last Write-Off E A 
DATELASTRI 79 Date Date of Last Returned Check E A 
DATELASTIN 80 Date Date of Last Interest Charge E A 
DATELASTDQ 81 Date Reserved E A 
IDINVCHI 82 String*22 Largest Invoice Number E A 
IDINVCHILY 83 String*22 Largest Invoice Number Last Yr. E A 
AMTINVHIT 84 BCD*10.3 Largest Invoice - Cust. Curr. E A 
AMTBALHIT 85 BCD*10.3 Highest Balance - Cust. Curr. E A 
AMTINVHILT 86 BCD*10.3 Lgst. Inv. Last Yr. Cust. Curr. E A 
AMTBALHILT 87 BCD*10.3 High Bal. Last Yr. - Cust. Curr. E A 
AMTLASTIVT 88 BCD*10.3 Last Invoice Amt. - Cust. Curr. E A 
AMTLASTCRT 89 BCD*10.3 Last Cr. Note Amt. - Cust. Curr. E A 
AMTLASTDRT 90 BCD*10.3 Last Dr. Note Amt. - Cust. Curr. E A 
AMTLASTPYT 91 BCD*10.3 Last Receipt - Cust. Curr. E A 
AMTLASTDIT 92 BCD*10.3 Last Discount Amt. - Cust. Curr. E A 
AMTLASTADT 93 BCD*10.3 Last Adj. Amt. - Cust. Curr. E A 
AMTLASTWRT 94 BCD*10.3 Last Write-Off Amt. Cust. Curr. E A 
AMTLASTRIT 95 BCD*10.3 Last Ret'd. Chk. Amt. Cust. Curr E A 
AMTLASTINT 96 BCD*10.3 Last Int. Charge - Cust. Curr. E A 
AMTINVHIH 97 BCD*10.3 Largest Invoice - Func. Curr. E A 
AMTBALHIH 98 BCD*10.3 Highest Balance - Func. Curr. E A 
AMTINVHILH 99 BCD*10.3 Lgst. Inv. Last Yr. Func. Curr. E A 
AMTBALHILH 100 BCD*10.3 High Bal. Last Yr. - Func. Curr. E A 
AMTLASTIVH 101 BCD*10.3 Last Invoice Amt. - Func. Curr. E A 
AMTLASTCRH 102 BCD*10.3 Last Cr. Note Amt. - Func. Curr. E A 
AMTLASTDRH 103 BCD*10.3 Last Dr. Note Amt. - Func. Curr. E A 
AMTLASTPYH 104 BCD*10.3 Last Receipt - Func. Curr. E A 
AMTLASTDIH 105 BCD*10.3 Last Discount Amt. - Func. Curr. E A 
AMTLASTADH 106 BCD*10.3 Last Adj. Amt. - Func. Curr. E A 
AMTLASTWRH 107 BCD*10.3 Last Write-Off Amt. Func. Curr. E A 
AMTLASTRIH 108 BCD*10.3 Last Ret'd. Chk. Amt. Func. Curr E A 
AMTLASTINH 109 BCD*10.3 Last Int. Charge - Func. Curr. E A 
CODESLSP1 110 String*8 Salesperson 1 E A  Mask: %-8N
CODESLSP2 111 String*8 Salesperson 2 E A  Mask: %-8N
CODESLSP3 112 String*8 Salesperson 3 E A  Mask: %-8N
CODESLSP4 113 String*8 Salesperson 4 E A  Mask: %-8N
CODESLSP5 114 String*8 Salesperson 5 E A  Mask: %-8N
PCTSASPLT1 115 BCD*5.5 Sales-Split Percentage 1 E A 
PCTSASPLT2 116 BCD*5.5 Sales-Split Percentage 2 E A 
PCTSASPLT3 117 BCD*5.5 Sales-Split Percentage 3 E A 
PCTSASPLT4 118 BCD*5.5 Sales-Split Percentage 4 E A 
PCTSASPLT5 119 BCD*5.5 Sales-Split Percentage 5 E A 
PRICLIST 128 String*6 Customer Price List E A  Mask: %-6C
CUSTTYPE 129 Integer Customer Discount Type E A  List:6 entries
0 = Base
1 = A
2 = B
3 = C
4 = D
5 = E
AMTPDUE 130 BCD*10.3 Amount Past Due E A 
TEXTSTMT 131 String*45 Dunning Message E A 
EMAIL1 132 String*50 Contact's E-mail E A 
EMAIL2 133 String*50 Customer's E-mail E A 
WEBSITE 134 String*100 Web Site E A 
DELMETHOD 135 Integer Delivery Method E A  List:4 entries
0 = Mail
2 = Email (customer)
4 = Email (contact)
5 = Email (multiple contacts)
CTACPHONE 136 String*30 Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 137 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
SWPARTSHIP 138 Integer Allow Partial Shipments E A  List:2 entries
0 = No
1 = Yes
HAMTBGNBLF 139 BCD*10.3 HDR Amount Beginning Balance Forward E A 
HAMTEBALFD 140 BCD*10.3 HDR Amount Ending Balance Forward E A 
HAMTSTMTBL 141 BCD*10.3 HDR Amount Statement Balance E A 
HAMTDUECUR 142 BCD*10.3 HDR Amount Due Current Period E A 
HAMTDUEAG1 143 BCD*10.3 HDR Amount Due 1st Period E A 
HAMTDUEAG2 144 BCD*10.3 HDR Amount Due 2nd Period E A 
HAMTDUEAG3 145 BCD*10.3 HDR Amount Due 3rd Period E A 
HAMTDUEAG4 146 BCD*10.3 HDR Amount Due 4th Period E A 
HAMTDUEFWD 147 BCD*10.3 HDR Amount Due Forward Balance E A 
RBCNAME 148 String*60 Remit-To Name E A 
RBCSTREET1 149 String*60 Remit-To Address 1 E A 
RBCSTREET2 150 String*60 Remit-To Address 2 E A 
RBCSTREET3 151 String*60 Remit-To Address 3 E A 
RBCSTREET4 152 String*60 Remit-To Address 4 E A 
RBCCITY 153 String*30 Remit-To City E A 
RBCSTATE 154 String*30 Remit-To State/Prov. E A 
RBCPSTCDE 155 String*20 Remit-To Zip/Postal Code E A 
RBCCNTYCDE 156 String*30 Remit-To Country E A 
CUSDECIMAL 157 Integer Customer Currency Decimal E A 
CURSYMBOL 158 String*4 Customer Currency Symbol E A 
VALUES 159 Long Optional Fields E A C 

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