# Table: Reprint Statement Customers

Table: ARSTCUS
View: AR0111
Record length: 2220
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Statement Run No./Customer Numbe |  | STMTSEQ, IDCUST
NAT Statement Switch/Customer No | D M | SWNATSTMT, IDCUST, STMTDATE
Statement Run No./National Accou | D M | STMTSEQ, IDNATACCT

## Fields: 155

Field | Type | Title | Presentation
--- | --- | --- | ---
STMTSEQ | Long | Statement Run Number |
IDCUST | String*12 | Customer Number | Mask: %-12C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SWPRINTED | Integer | Statement Printed Flag | List: 2 entries
0 | = | No
1 | = | Yes
SWNATSTMT | Integer | NAT Statement Switch | List: 3 entries
0 | = | Customer Statements
1 | = | National Acct. Statements
2 | = | Letters or Labels
IDNATACCT | String*12 | National Account Number | Mask: %-12C
STMTDATE | Date | Statement Run Date |
TEXTSNAM | String*10 | Short Name |
IDGRP | String*6 | Group Code | Mask: %-6N
SWACTV | Integer | Status |
DATEINAC | Date | Inactive Date |
DATELASTMN | Date | Date Last Maintained |
SWHOLD | Integer | On Hold |
DATESTART | Date | Start Date |
IDPPNT | String*12 | Reserved |
CODEDAB | String*9 | Credit Bureau Number |
CODEDABRTG | String*5 | Credit Bureau Rating |
DATEDAB | Date | Credit Bureau Date |
NAMECUST | String*60 | Customer 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 |
CODESTTE | String*30 | State/Prov. |
CODEPSTL | 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
CODETERR | String*6 | Territory Code | Mask: %-6N
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
CODETERM | String*6 | Terms | Mask: %-6N
IDRATETYPE | String*2 | Rate Type | Mask: %-2N
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
IDTAXREGI1 | String*20 | Tax Registration No. 1 |
IDTAXREGI2 | String*20 | Tax Registration No. 2 |
IDTAXREGI3 | String*20 | Tax Registration No. 3 |
IDTAXREGI4 | String*20 | Tax Registration No. 4 |
IDTAXREGI5 | String*20 | Tax Registration No. 5 |
TAXSTTS1 | Integer | Tax Class Code 1 |
TAXSTTS2 | Integer | Tax Class Code 2 |
TAXSTTS3 | Integer | Tax Class Code 3 |
TAXSTTS4 | Integer | Tax Class Code 4 |
TAXSTTS5 | Integer | Tax Class Code 5 |
AMTCRLIMT | BCD*10.3 | Credit Limit (Cust. Curr.) |
AMTBALDUET | BCD*10.3 | Balance Due in Cust. Curr. |
AMTBALDUEH | BCD*10.3 | Balance Due in Func. Curr. |
DATELASTST | Date | Date of Last Statement |
AMTLASTSTT | BCD*10.3 | Last Statement Total Cust. Curr. |
AMTLASTSTH | BCD*10.3 | Reserved |
DTBEGBALFW | Date | Date of Last Bal. Fwd. Statement |
AMTBALFWDT | BCD*10.3 | Beginning Bal. on Last Statement |
AMTBALFWDH | BCD*10.3 | Reserved |
DTLASTRVAL | Date | Date of Last Revaluation |
AMTBALLARV | BCD*10.3 | Last Revaluation Balance |
CNTOPENINV | BCD*4.0 | Number of Open Documents |
CNTINVPAID | BCD*4.0 | Number of Paid Invoices |
DAYSTOPAY | 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 Balance Last Yr. |
DATELASTAC | Date | Date of Last Activity |
DATELASTIV | 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 |
DATELASTIN | Date | Date of Last Interest Charge |
DATELASTDQ | Date | Reserved |
IDINVCHI | String*22 | Largest Invoice Number |
IDINVCHILY | String*22 | Largest Invoice Number Last Yr. |
AMTINVHIT | BCD*10.3 | Largest Invoice - Cust. Curr. |
AMTBALHIT | BCD*10.3 | Highest Balance - Cust. Curr. |
AMTINVHILT | BCD*10.3 | Lgst. Inv. Last Yr. Cust. Curr. |
AMTBALHILT | BCD*10.3 | High Bal. Last Yr. - Cust. Curr. |
AMTLASTIVT | BCD*10.3 | Last Invoice Amt. - Cust. Curr. |
AMTLASTCRT | BCD*10.3 | Last Cr. Note Amt. - Cust. Curr. |
AMTLASTDRT | BCD*10.3 | Last Dr. Note Amt. - Cust. Curr. |
AMTLASTPYT | BCD*10.3 | Last Receipt - Cust. Curr. |
AMTLASTDIT | BCD*10.3 | Last Discount Amt. - Cust. Curr. |
AMTLASTADT | BCD*10.3 | Last Adj. Amt. - Cust. Curr. |
AMTLASTWRT | BCD*10.3 | Last Write-Off Amt. Cust. Curr. |
AMTLASTRIT | BCD*10.3 | Last Ret'd. Chk. Amt. Cust. Curr |
AMTLASTINT | BCD*10.3 | Last Int. Charge - Cust. Curr. |
AMTINVHIH | BCD*10.3 | Largest Invoice - Func. Curr. |
AMTBALHIH | 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. |
AMTLASTIVH | BCD*10.3 | Last Invoice Amt. - Func. Curr. |
AMTLASTCRH | BCD*10.3 | Last Cr. Note Amt. - Func. Curr. |
AMTLASTDRH | BCD*10.3 | Last Dr. Note Amt. - Func. Curr. |
AMTLASTPYH | BCD*10.3 | Last Receipt - Func. Curr. |
AMTLASTDIH | BCD*10.3 | Last Discount Amt. - Func. Curr. |
AMTLASTADH | BCD*10.3 | Last Adj. Amt. - Func. Curr. |
AMTLASTWRH | BCD*10.3 | Last Write-Off Amt. Func. Curr. |
AMTLASTRIH | BCD*10.3 | Last Ret'd. Chk. Amt. Func. Curr |
AMTLASTINH | BCD*10.3 | Last Int. Charge - Func. Curr. |
CODESLSP1 | String*8 | Salesperson 1 | Mask: %-8N
CODESLSP2 | String*8 | Salesperson 2 | Mask: %-8N
CODESLSP3 | String*8 | Salesperson 3 | Mask: %-8N
CODESLSP4 | String*8 | Salesperson 4 | Mask: %-8N
CODESLSP5 | String*8 | Salesperson 5 | Mask: %-8N
PCTSASPLT1 | BCD*5.5 | Sales-Split Percentage 1 |
PCTSASPLT2 | BCD*5.5 | Sales-Split Percentage 2 |
PCTSASPLT3 | BCD*5.5 | Sales-Split Percentage 3 |
PCTSASPLT4 | BCD*5.5 | Sales-Split Percentage 4 |
PCTSASPLT5 | BCD*5.5 | Sales-Split Percentage 5 |
PRICLIST | String*6 | Customer Price List | Mask: %-6C
CUSTTYPE | Integer | Customer Discount Type | List: 6 entries
0 | = | Base
1 | = | A
2 | = | B
3 | = | C
4 | = | D
5 | = | E
AMTPDUE | BCD*10.3 | Amount Past Due |
TEXTSTMT | String*45 | Dunning Message |
EMAIL1 | String*50 | Contact's E-mail |
EMAIL2 | String*50 | Customer's E-mail |
WEBSITE | String*100 | Web Site |
DELMETHOD | Integer | Delivery Method | List: 3 entries
0 | = | Mail
2 | = | E-mail
4 | = | Contact's E-mail
CTACPHONE | String*30 | Contact's Phone | Mask: (%-3C) %-3C-%-24C
CTACFAX | String*30 | Contact's Fax | Mask: (%-3C) %-3C-%-24C
SWPARTSHIP | Integer | Allow Partial Shipments | List: 2 entries
0 | = | No
1 | = | Yes
HAMTBGNBLF | BCD*10.3 | HDR Amount Beginning Balance Forward |
HAMTEBALFD | BCD*10.3 | HDR Amount Ending Balance Forward |
HAMTSTMTBL | BCD*10.3 | HDR Amount Statement Balance |
HAMTDUECUR | BCD*10.3 | HDR Amount Due Current Period |
HAMTDUEAG1 | BCD*10.3 | HDR Amount Due 1st Period |
HAMTDUEAG2 | BCD*10.3 | HDR Amount Due 2nd Period |
HAMTDUEAG3 | BCD*10.3 | HDR Amount Due 3rd Period |
HAMTDUEAG4 | BCD*10.3 | HDR Amount Due 4th Period |
HAMTDUEFWD | BCD*10.3 | HDR Amount Due Forward Balance |
RBCNAME | String*60 | Remit-To Name |
RBCSTREET1 | String*60 | Remit-To Address 1 |
RBCSTREET2 | String*60 | Remit-To Address 2 |
RBCSTREET3 | String*60 | Remit-To Address 3 |
RBCSTREET4 | String*60 | Remit-To Address 4 |
RBCCITY | String*30 | Remit-To City |
RBCSTATE | String*30 | Remit-To State/Prov. |
RBCPSTCDE | String*20 | Remit-To Zip/Postal Code |
RBCCNTYCDE | String*30 | Remit-To Country |
CUSDECIMAL | Integer | Customer Currency Decimal |
CURSYMBOL | String*4 | Customer Currency Symbol |
VALUES | Long | Optional Fields |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.