View: Age Documents

RotoID: AR0055

Protocol: Superview
DLL:ARAGE

Keys: 0

Title Fields

Fields: 105

Field Index Type Title Attributes Presentation
CMNDCODE 1 Integer Command Code E A  List:5 entries
1 = Setup
51 = Generate Sorted Work File
52 = Generate Unsorted Work File
61 = Single Age Calculation
71 = Bucket Total Calculation
CUSTID 2 String*12 Customer Number E A  Mask: %-12C
BUSDATE 3 Date Posting Date E A 
INVOICEID 4 String*22 Document Number E A  Mask: %-22C
RMITID 5 String*24 Check/Receipt No. E A  Mask: %-24C
TRXTYPETXT 6 Integer Document Type E A 
TRXTYPEID 7 Integer Transaction Type E A 
OBLAMTDUET 8 BCD*10.3 Amount Due (Source) E A 
OBLAMTDUEH 9 BCD*10.3 Amount Due (Functional) E A 
INVCBEGNDT 10 Date Starting Invoice Date E A 
DUEDATE 11 Date Due Date E A 
RUNDATE 12 Date Age as-of Date E A 
CUTOFFDATE 13 Date Cutoff Date E A 
AGEINVDTSW 14 Integer Age by E A  List:2 entries
0 = Due Date
1 = Document Date
INCLPAIDSW 15 Integer Age Fully Paid Documents E A  List:2 entries
0 = Excluded
1 = Included
ZEROBALSW 16 Integer Include Zero Balances E A  List:2 entries
0 = Excluded
1 = Included
PASTDUESW 17 Integer Report Type E A  List:2 entries
0 = Aged Trial Balance
1 = Overdue Receivable
AGEPERIOD1 18 BCD*3.0 Current E A 
AGEPERIOD2 19 BCD*3.0 First Period E A 
AGEPERIOD3 20 BCD*3.0 Second Period E A 
AGEPERIOD4 21 BCD*3.0 Third Period E A 
AGEPERIOD5 22 BCD*3.0 Fourth Period E A 
AGEPERIOD6 23 BCD*3.0 First Forward Period E A 
AGEPERIOD7 24 BCD*3.0 Second Forward Period E A 
AGEPERIOD8 25 BCD*3.0 Third Forward Period E A 
AGEPERIOD9 26 BCD*3.0 Fourth Forward Period E A 
SWCUSTCRLM 27 Integer Include Over Credit Limit E A  List:2 entries
0 = All Customers
1 = Only
IDFROM1 28 String*60 Range 1 From E A 
IDTO1 29 String*60 Range 1 To E A 
INDEX1 30 Integer Range 1 Type E A 
IDFROM2 31 String*60 Range 2 From E A 
IDTO2 32 String*60 Range 2 To E A 
INDEX2 33 Integer Range 2 Type E A 
IDFROM3 34 String*60 Range 3 From E A 
IDTO3 35 String*60 Range 3 To E A 
INDEX3 36 Integer Range 3 Type E A 
IDFROM4 37 String*60 Range 4 From E A 
IDTO4 38 String*60 Range 4 To E A 
INDEX4 39 Integer Range 4 Type E A 
DAYSOUTFRM 40 BCD*3.0 Number of Days Outstanding From E A 
DAYSOUTTO 41 BCD*3.0 Number of Days Outstanding To E A 
AMTDUE1TC 42 BCD*10.3 Current Amount Due (Source) E A 
AMTDUE1HC 43 BCD*10.3 Current Amount Due (Functional) E A 
DATEDUE1 44 Date Current Date E A 
AMTDUE2TC 45 BCD*10.3 Period 1 Amount Due (Source) E A 
AMTDUE2HC 46 BCD*10.3 Period 1 Amount Due (Functional) E A 
DATEDUE2 47 Date Period 1 Date E A 
AMTDUE3TC 48 BCD*10.3 Period 2 Amount Due (Source) E A 
AMTDUE3HC 49 BCD*10.3 Period 2 Amount Due (Functional) E A 
DATEDUE3 50 Date Period 2 Date E A 
AMTDUE4TC 51 BCD*10.3 Period 3 Amount Due (Source) E A 
AMTDUE4HC 52 BCD*10.3 Period 3 Amount Due (Functional) E A 
DATEDUE4 53 Date Period 3 Date E A 
AMTDUE5TC 54 BCD*10.3 Period 4 Amount Due (Source) E A 
AMTDUE5HC 55 BCD*10.3 Period 4 Amount Due (Functional) E A 
DATEDUE5 56 Date Period 4 Date E A 
AMTDUE6TC 57 BCD*10.3 Period 5 Amount Due (Source) E A 
AMTDUE6HC 58 BCD*10.3 Period 5 Amount Due (Functional) E A 
DATEDUE6 59 Date Period 5 Date E A 
AMTDUE7TC 60 BCD*10.3 Period 6 Amount Due (Source) E A 
AMTDUE7HC 61 BCD*10.3 Period 6 Amount Due (Functional) E A 
DATEDUE7 62 Date Period 6 Date E A 
AMTDUE8TC 63 BCD*10.3 Period 7 Amount Due (Source) E A 
AMTDUE8HC 64 BCD*10.3 Period 7 Amount Due (Functional) E A 
DATEDUE8 65 Date Period 7 Date E A 
AMTDUE9TC 66 BCD*10.3 Period 8 Amount Due (Source) E A 
AMTDUE9HC 67 BCD*10.3 Period 8 Amount Due (Functional) E A 
DATEDUE9 68 Date Period 8 Date E A 
CNTPERDDUE 69 BCD*3.0 Period Open Item Schedule Due E A 
TOTBKWDTC 70 BCD*10.3 Total Backward Aging (Source) E A 
TOTBKWDHC 71 BCD*10.3 Total Backward Aging (Functional) E A 
TOTFWDTC 72 BCD*10.3 Total Forward Aging (Source) E A 
TOTFWDHC 73 BCD*10.3 Total Forward Aging (Functional) E A 
SWOPTMETER 74 Integer Display Meter E A  List:2 entries
0 = No
1 = Yes
SWMATCHING 75 Integer Include Applied Details E A  List:2 entries
0 = No
1 = Yes
SWACCTTYPE 76 Integer Customer Account Type E A 
SWCUTOFFBY 77 Integer Cutoff By E A  List:3 entries
0 = Doc. Date
1 = Posting Date
2 = Year/Period
CUTOFFYEAR 78 String*4 Cutoff Year E A  Mask: %04D
CUTOFFPERD 79 String*2 Cutoff Period E A  Mask: %02D
FIELDNAME1 80 String*19 Field Name 1 E A 
FIELDNAME2 81 String*19 Field Name 2 E A 
FIELDNAME3 82 String*19 Field Name 3 E A 
FIELDNAME4 83 String*19 Field Name 4 E A 
SWPREPAYMT 84 Integer Include Prepayment E A  List:2 entries
0 = No
1 = Yes
AGESEQ 85 Long Aging Sequence Number E A 
SORTINDEX1 86 Integer Sort Field Index 1 E A 
SORTINDEX2 87 Integer Sort Field Index 2 E A 
SORTINDEX3 88 Integer Sort Field Index 3 E A 
SORTINDEX4 89 Integer Sort Field Index 4 E A 
SORTNAME1 90 String*19 Sort Field Name 1 E A 
SORTNAME2 91 String*19 Sort Field Name 2 E A 
SORTNAME3 92 String*19 Sort Field Name 3 E A 
SORTNAME4 93 String*19 Sort Field Name 4 E A 
SWINVOICE 94 Integer Include Invoice E A  List:2 entries
0 = No
1 = Yes
SWDEBIT 95 Integer Include Debit Note E A  List:2 entries
0 = No
1 = Yes
SWCREDIT 96 Integer Include Credit Note E A  List:2 entries
0 = No
1 = Yes
SWINTEREST 97 Integer Include Interest E A  List:2 entries
0 = No
1 = Yes
SWUNAPCASH 98 Integer Include Unapplied Cash E A  List:2 entries
0 = No
1 = Yes
SWRECEIPT 99 Integer Include Receipt E A  List:2 entries
0 = No
1 = Yes
SWREFUND 100 Integer Include Refund E A  List:2 entries
0 = No
1 = Yes
SWADJUST 101 Integer Include Adjustment E A  List:2 entries
0 = No
1 = Yes
FROMDATE 102 Date From Date E A 
FROMYEAR 103 String*4 From Year E A  Mask: %04D
FROMPERD 104 String*2 From Period E A  Mask: %02D
SWAGERTG 105 Integer Show Aged Retainage E A  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

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