Table: Recurring Charges

Table: ARSIA
View: AR0046
Record length: 904
Flags: A R 

Keys: 4

Title  Flags  Fields

Recurring Charge Code  IDSTDINVC, IDCUST
Customer Number  D M  IDCUST
Billing Cycle  D M  IDBILL
Schedule  D M  SCHEDKEY, SCHEDLINK

Fields: 93

Field  Type  Title  Presentation 

IDSTDINVC  String*16  Recurring Charge Code  Mask: %-16C
IDCUST  String*12  Customer Number  Mask: %-12C
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDBILL  String*6  Reserved   
TEXTDESC  String*60  Description   
SWACTV  Integer  Status  List: 2 entries
0=Inactive
1=Active
DATEINAC  Date  Inactive Date   
DATELSTMTN  Date  Date Last Maintained   
DATELSTPRC  Date  Last Invoice Date Generated   
DATEEFF  Date  Effective Date   
DATEEXPR  Date  Expiration Date   
AMTTOTCHRG  BCD*10.3  Maximum Total Invoice Amount   
AMTINVC  BCD*10.3  YTD Total Invoice Amount   
DATEINVDAY  BCD*2.0  Reserved   
SWLASTDAY  Integer  Reserved   
IDCUSTSHPT  String*6  Ship-To Location  Mask: %-6C
TEXTSHIP  String*15  Reserved   
TEXTINST  String*60  Special Instructions   
IDORDENBR  String*22  Order Number  Mask: %-22C
IDCUSTPO  String*22  PO Number  Mask: %-22C
IDJOBNBR  String*22  Reserved   
INVCDESC  String*60  Invoice Description   
SWPRTINVC  Integer  Reserved   
CODECURN  String*3  Currency Code  Mask: %-3N
IDRATETYPE  String*2  Rate Type  Mask: %-2N
CODETERM  String*6  Terms  Mask: %-6N
CNTLSTLINE  BCD*3.0  Last Line Number   
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   
SWTXBL  Integer  Taxable  List: 2 entries
0=No
1=Yes
SWMANLTX  Integer  Tax Override  List: 2 entries
0=No
1=Yes
CODETAXGRP  String*12  Tax Group  Mask: %-12N
CODETAX1  String*12  Tax Authority 1  Mask: %-12N
CODETAX2  String*12  Tax Authority 2  Mask: %-12N
CODETAX3  String*12  Tax Authority 3  Mask: %-12N
CODETAX4  String*12  Tax Authority 4  Mask: %-12N
CODETAX5  String*12  Tax Authority 5  Mask: %-12N
TAXSTTS1  Integer  Tax Class 1   
TAXSTTS2  Integer  Tax Class 2   
TAXSTTS3  Integer  Tax Class 3   
TAXSTTS4  Integer  Tax Class 4   
TAXSTTS5  Integer  Tax Class 5   
BASETAX1  BCD*10.3  Tax Base 1   
BASETAX2  BCD*10.3  Tax Base 2   
BASETAX3  BCD*10.3  Tax Base 3   
BASETAX4  BCD*10.3  Tax Base 4   
BASETAX5  BCD*10.3  Tax Base 5   
AMTTAX1  BCD*10.3  Tax Amount 1   
AMTTAX2  BCD*10.3  Tax Amount 2   
AMTTAX3  BCD*10.3  Tax Amount 3   
AMTTAX4  BCD*10.3  Tax Amount 4   
AMTTAX5  BCD*10.3  Tax Amount 5   
AMTTXBL  BCD*10.3  Taxable Amount   
AMTNOTTXBL  BCD*10.3  Non-Taxable Amount   
AMTTAXTOTL  BCD*10.3  Total Tax Amount   
AMTINVTOTL  BCD*10.3  Last Invoice Amount Posted   
CNTPAYMTOT  BCD*3.0  Reserved   
AMTPAYMSCD  BCD*10.3  Invoice Subtotal   
MAXCOUNT  Integer  Maximum Number of Invoices   
YTDCOUNT  Integer  YTD Number of Invoices   
SCHEDKEY  String*12  Schedule  Mask: %-12N
SCHEDLINK  BCD*10.0  Schedule Link   
EXPIRETYPE  Integer  Expiration Type  List: 4 entries
0=No Expiration
1=Specific Date
2=Maximum Amount
3=Number of Invoices
SHPVIACODE  String*6  Ship Via Code  Mask: %-6N
SHPVIADESC  String*60  Ship Via Description   
AMTINVCTOT  BCD*10.3  Invoice Total Before Tax   
AMTNETTOT  BCD*10.3  Invoice Total Including Tax   
VALUES  Long  Number of Optional Fields   
AMTTAXTOT  BCD*10.3  Total Tax Amount   
INVCTYPE  Integer  Invoice Type  List: 2 entries
1=Item
2=Summary
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
DATENEXT  Date  Next Scheduled Date   
OPENCOUNT  Integer  Unposted Number of Invoices   
OPENAMOUNT  BCD*10.3  Unposted Total Invoice Amount   
POSTCOUNT  Integer  Posted Number of Invoices   
POSTAMOUNT  BCD*10.3  Posted Total Invoice Amount   
LSTDATEINV  Date  Last Invoice Date Posted   
LSTIDINVC  String*22  Last Invoice Number Posted   
LSTCNTBTCH  BCD*5.0  Last Batch Number Posted   
LSTCNTITEM  BCD*4.0  Last Entry Number Posted   
LSTPOSTSEQ  BCD*5.0  Last Posting Sequence Number   
IDACCTSET  String*6  Account Set  Mask: %-6N

This page was generated on 2008-May-01

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