# View: Reprint Statement Customers

RotoID: AR0111
Table: ARSTCUS
DLL: ARSTCUS

## Compositions: 0

## 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: 5 entries
0 | = | Mail
1 | = | Fax
2 | = | E-mail
3 | = | Contact's Fax
4 | = | Contact's E-mail
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 For | E A |
HAMTEBALFD | 140 | BCD*10.3 | HDR Amount Ending Balance Forwar | 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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.