View: Recurring Charges

RotoID: AR0046
Table: ARSIA
Protocol: Header
DLL:ARSIA

Compositions: 2

RotoID Tables Title DLL
AR0047 ARSID Recurring Charge Details ARSID
AR0405 ARSIAO Recurring Charge Optional Fields ARSIAO

Keys: 4

Title Fields
Recurring Charge Code IDSTDINVC, IDCUST
Customer Number IDCUST
Billing Cycle IDBILL
Schedule SCHEDKEY, SCHEDLINK

Fields: 96

Field Index Type Title Attributes Presentation
IDSTDINVC 1 String*16 Recurring Charge Code E A K R  Mask: %-16C
IDCUST 2 String*12 Customer Number E A K R  Mask: %-12C
IDBILL 3 String*6 Reserved E 
TEXTDESC 4 String*60 Description E A 
SWACTV 5 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
DATEINAC 6 Date Inactive Date E A C 
DATELSTMTN 7 Date Date Last Maintained E A C 
DATELSTPRC 8 Date Last Invoice Date Generated E A C 
DATEEFF 9 Date Effective Date E A 
DATEEXPR 10 Date Expiration Date E A 
AMTTOTCHRG 11 BCD*10.3 Maximum Total Invoice Amount E A 
AMTINVC 12 BCD*10.3 YTD Total Invoice Amount E A C 
DATEINVDAY 13 BCD*2.0 Reserved E 
SWLASTDAY 14 Integer Reserved E 
IDCUSTSHPT 15 String*6 Ship-To Location E A  Mask: %-6C
TEXTSHIP 16 String*15 Reserved E 
TEXTINST 17 String*60 Special Instructions E A 
IDORDENBR 18 String*22 Order Number E A  Mask: %-22C
IDCUSTPO 19 String*22 PO Number E A  Mask: %-22C
IDJOBNBR 20 String*22 Reserved E 
INVCDESC 21 String*60 Invoice Description E A 
SWPRTINVC 22 Integer Reserved E 
CODECURN 23 String*3 Currency Code E A C  Mask: %-3N
IDRATETYPE 24 String*2 Rate Type E A  Mask: %-2N
CODETERM 25 String*6 Terms E A  Mask: %-6N
CNTLSTLINE 26 BCD*3.0 Last Line Number E A C 
CODESLSP1 27 String*8 Salesperson 1 E A  Mask: %-8N
CODESLSP2 28 String*8 Salesperson 2 E A  Mask: %-8N
CODESLSP3 29 String*8 Salesperson 3 E A  Mask: %-8N
CODESLSP4 30 String*8 Salesperson 4 E A  Mask: %-8N
CODESLSP5 31 String*8 Salesperson 5 E A  Mask: %-8N
PCTSASPLT1 32 BCD*5.5 Sales-Split Percentage 1 E A 
PCTSASPLT2 33 BCD*5.5 Sales-Split Percentage 2 E A 
PCTSASPLT3 34 BCD*5.5 Sales-Split Percentage 3 E A 
PCTSASPLT4 35 BCD*5.5 Sales-Split Percentage 4 E A 
PCTSASPLT5 36 BCD*5.5 Sales-Split Percentage 5 E A 
SWTXBL 37 Integer Taxable E A C  List:2 entries
0 = No
1 = Yes
SWMANLTX 38 Integer Tax Override E A  List:2 entries
0 = No
1 = Yes
CODETAXGRP 39 String*12 Tax Group E A  Mask: %-12N
CODETAX1 40 String*12 Tax Authority 1 E A C  Mask: %-12N
CODETAX2 41 String*12 Tax Authority 2 E A C  Mask: %-12N
CODETAX3 42 String*12 Tax Authority 3 E A C  Mask: %-12N
CODETAX4 43 String*12 Tax Authority 4 E A C  Mask: %-12N
CODETAX5 44 String*12 Tax Authority 5 E A C  Mask: %-12N
TAXSTTS1 45 Integer Tax Class 1 E A 
TAXSTTS2 46 Integer Tax Class 2 E A 
TAXSTTS3 47 Integer Tax Class 3 E A 
TAXSTTS4 48 Integer Tax Class 4 E A 
TAXSTTS5 49 Integer Tax Class 5 E A 
BASETAX1 50 BCD*10.3 Tax Base 1 E A 
BASETAX2 51 BCD*10.3 Tax Base 2 E A 
BASETAX3 52 BCD*10.3 Tax Base 3 E A 
BASETAX4 53 BCD*10.3 Tax Base 4 E A 
BASETAX5 54 BCD*10.3 Tax Base 5 E A 
AMTTAX1 60 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 61 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 62 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 63 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 64 BCD*10.3 Tax Amount 5 E A 
AMTTXBL 73 BCD*10.3 Taxable Amount E 
AMTNOTTXBL 74 BCD*10.3 Non-Taxable Amount E 
AMTTAXTOTL 75 BCD*10.3 Total Tax Amount E 
AMTINVTOTL 76 BCD*10.3 Last Invoice Amount Posted E A C 
CNTPAYMTOT 77 BCD*3.0 Reserved E 
AMTPAYMSCD 78 BCD*10.3 Invoice Subtotal E A C 
MAXCOUNT 79 Integer Maximum Number of Invoices E A 
YTDCOUNT 80 Integer YTD Number of Invoices E A C 
SCHEDKEY 81 String*12 Schedule E A  Mask: %-12N
SCHEDLINK 82 BCD*10.0 Schedule Link E A C 
EXPIRETYPE 83 Integer Expiration Type E A  List:4 entries
0 = No Expiration
1 = Specific Date
2 = Maximum Amount
3 = Number of Invoices
SHPVIACODE 84 String*6 Ship Via Code E A  Mask: %-6N
SHPVIADESC 85 String*60 Ship Via Description E A 
AMTINVCTOT 86 BCD*10.3 Invoice Total Before Tax E A C 
AMTNETTOT 87 BCD*10.3 Invoice Total Including Tax A C 
AMTTAXTOT 88 BCD*10.3 Total Tax Amount E A C 
INVCTYPE 89 Integer Invoice Type E A  List:2 entries
1 = Item
2 = Summary
VALUES 90 Long Number of Optional Fields E A C 
PROCESSCMD 91 Integer Process Command Code E A C  List:3 entries
0 = Insert Optional Fields
1 = Calculate Taxes
2 = Distribute Taxes
SWJOB 92 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
DATENEXT 93 Date Next Scheduled Date E A C 
OPENCOUNT 94 Integer Unposted Number of Invoices E A 
OPENAMOUNT 95 BCD*10.3 Unposted Total Invoice Amount E A 
POSTCOUNT 96 Integer Posted Number of Invoices E A 
POSTAMOUNT 97 BCD*10.3 Posted Total Invoice Amount E A 
LSTDATEINV 98 Date Last Invoice Date Posted E A C 
LSTIDINVC 99 String*22 Last Invoice Number Posted E A C 
LSTCNTBTCH 100 BCD*5.0 Last Batch Number Posted E A C 
LSTCNTITEM 101 BCD*4.0 Last Entry Number Posted E A C 
LSTPOSTSEQ 102 BCD*5.0 Last Posting Sequence Number E A C 
IDACCTSET 103 String*6 Account Set E A  Mask: %-6N
AMTWHT1TC 104 BCD*10.3 Tax Withheld 1 E A C 
AMTWHT2TC 105 BCD*10.3 Tax Withheld 2 E A C 
AMTWHT3TC 106 BCD*10.3 Tax Withheld 3 E A C 
AMTWHT4TC 107 BCD*10.3 Tax Withheld 4 E A C 
AMTWHT5TC 108 BCD*10.3 Tax Withheld 5 E A C 
AMTWHTTOT 109 BCD*10.3 Estimated Tax Withheld Total E A C 

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