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:4 entries
0 = Mail
2 = Email (customer)
4 = Email (contact)
5 = Email (multiple contacts)
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 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).