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.