Table: Recurring Charges

Table: ARSIA
View: AR0046
Record Length: 954

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: 98

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
AMTWHT1TC BCD*10.3 Tax Withheld 1
AMTWHT2TC BCD*10.3 Tax Withheld 2
AMTWHT3TC BCD*10.3 Tax Withheld 3
AMTWHT4TC BCD*10.3 Tax Withheld 4
AMTWHT5TC BCD*10.3 Tax Withheld 5

This page was generated on 2022-Aug-18

© 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).