View: Age Documents

RotoID: AP0043

Protocol: Superview
DLL:APAGE

Keys: 0

Title Fields

Fields: 101

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
IDVEND 2 String*12 Vendor Number E A  Mask: %-12C
BUSDATE 3 Date Posting Date E A 
INVOICEID 4 String*22 Document Number E A  Mask: %-22C
IDRMIT 5 String*18 Check Number E A  Mask: %-18D
TRXTYPETXT 6 Integer Transaction Type E A 
TRXTYPEID 7 Integer Transaction Description E A 
OBLAMTDUE 8 BCD*10.3 Amount Due E A 
INVCBEGNDT 9 Date Starting Invoice Date E A 
DUEDATE 10 Date Due Date E A 
RUNDATE 11 Date Age as-of Date E A 
CUTOFFDATE 12 Date Cutoff Date E A 
AGEINVDTSW 13 Integer Due Date / Invoice Date E A  List:2 entries
0 = Due Date
1 = Document Date
INCLOBLHLD 14 Integer Include Payments On Hold E A  List:2 entries
0 = No
1 = Yes
ZEROBALSW 15 Integer Include Zero Balances E A  List:2 entries
0 = No
1 = Yes
PASTDUESW 16 Integer ATB / Overdue Rec. Report E A  List:3 entries
0 = Aged Payables
1 = Overdue Payables
2 = Aged Cash Requirements
AGEPERIOD1 17 BCD*3.0 Current E A 
AGEPERIOD2 18 BCD*3.0 First Period E A 
AGEPERIOD3 19 BCD*3.0 Second Period E A 
AGEPERIOD4 20 BCD*3.0 Third Period E A 
AGEPERIOD5 21 BCD*3.0 Fourth Period E A 
AGEPERIOD6 22 BCD*3.0 First Forward Period E A 
AGEPERIOD7 23 BCD*3.0 Second Forward Period E A 
AGEPERIOD8 24 BCD*3.0 Third Forward Period E A 
AGEPERIOD9 25 BCD*3.0 Fourth Forward Period E A 
SWCUSTCRLM 26 Integer Include Over Credit Limit E A  List:2 entries
0 = No
1 = Yes
IDFROM1 27 String*60 Range 1 From E A 
IDTO1 28 String*60 Range 1 To E A 
INDEX1 29 Integer Range 1 Index Value E A 
IDFROM2 30 String*60 Range 2 From E A 
IDTO2 31 String*60 Range 2 To E A 
INDEX2 32 Integer Range 2 Index Value E A 
IDFROM3 33 String*60 Range 3 From E A 
IDTO3 34 String*60 Range 3 To E A 
INDEX3 35 Integer Range 3 Index Value E A 
IDFROM4 36 String*60 Range 4 From E A 
IDTO4 37 String*60 Range 4 To E A 
INDEX4 38 Integer Range 4 Index Value E A 
AMTDUE1TC 39 BCD*10.3 Current Amount Due (Source) E A 
AMTDUE1HC 40 BCD*10.3 Current Amount Due (Functional) E A 
DATEDUE1 41 Date Current Date E A 
AMTDUE2TC 42 BCD*10.3 Period 1 Amount Due (Source) E A 
AMTDUE2HC 43 BCD*10.3 Period 1 Amount Due (Functional) E A 
DATEDUE2 44 Date Period 1 Date E A 
AMTDUE3TC 45 BCD*10.3 Period 2 Amount Due (Source) E A 
AMTDUE3HC 46 BCD*10.3 Period 2 Amount Due (Functional) E A 
DATEDUE3 47 Date Period 2 Date E A 
AMTDUE4TC 48 BCD*10.3 Period 3 Amount Due (Source) E A 
AMTDUE4HC 49 BCD*10.3 Period 3 Amount Due (Functional) E A 
DATEDUE4 50 Date Period 3 Date E A 
AMTDUE5TC 51 BCD*10.3 Period 4 Amount Due (Source) E A 
AMTDUE5HC 52 BCD*10.3 Period 4 Amount Due (Functional) E A 
DATEDUE5 53 Date Period 4 Date E A 
AMTDUE6TC 54 BCD*10.3 Period 5 Amount Due (Source) E A 
AMTDUE6HC 55 BCD*10.3 Period 5 Amount Due (Functional) E A 
DATEDUE6 56 Date Period 5 Date E A 
AMTDUE7TC 57 BCD*10.3 Period 6 Amount Due (Source) E A 
AMTDUE7HC 58 BCD*10.3 Period 6 Amount Due (Functional) E A 
DATEDUE7 59 Date Period 6 Date E A 
AMTDUE8TC 60 BCD*10.3 Period 7 Amount Due (Source) E A 
AMTDUE8HC 61 BCD*10.3 Period 7 Amount Due (Functional) E A 
DATEDUE8 62 Date Period 7 Date E A 
AMTDUE9TC 63 BCD*10.3 Period 8 Amount Due (Source) E A 
AMTDUE9HC 64 BCD*10.3 Period 8 Amount Due (Functional) E A 
DATEDUE9 65 Date Period 8 Date E A 
CNTPERDDUE 66 BCD*3.0 Period Open Item Schedule Due E A 
TOTBKWDTC 67 BCD*10.3 Total Backward Aging (Source) E A 
TOTBKWDHC 68 BCD*10.3 Total Backward Aging (Functional) E A 
TOTFWDTC 69 BCD*10.3 Total Forward Aging (Source) E A 
TOTFWDHC 70 BCD*10.3 Total Forward Aging (Functional) E A 
SWOPTMETER 71 Integer Display Meter E A  List:2 entries
0 = No
1 = Yes
SWMATCHING 72 Integer Include Applied Details E A  List:2 entries
0 = No
1 = Yes
TAKEAVDISC 73 Integer Take all Available Discounts E A  List:2 entries
0 = No
1 = Yes
SWCUTOFFBY 74 Integer Cutoff by E A  List:3 entries
0 = Doc. Date
1 = Posting Date
2 = Year/Period
CUTOFFYEAR 75 String*4 Cutoff Year E A  Mask: %04D
CUTOFFPERD 76 String*2 Cutoff Period E A  Mask: %02D
FIELDNAME1 77 String*19 Field Name 1 E A 
FIELDNAME2 78 String*19 Field Name 2 E A 
FIELDNAME3 79 String*19 Field Name 3 E A 
FIELDNAME4 80 String*19 Field Name 4 E A 
SWPREPAYMT 81 Integer Include Prepayment E A  List:2 entries
0 = No
1 = Yes
AGESEQ 82 Long Aging Sequence Number E A 
SORTINDEX1 83 Integer Sort Field Index 1 E A 
SORTINDEX2 84 Integer Sort Field Index 2 E A 
SORTINDEX3 85 Integer Sort Field Index 3 E A 
SORTINDEX4 86 Integer Sort Field Index 4 E A 
SORTNAME1 87 String*19 Sort Field Name 1 E A 
SORTNAME2 88 String*19 Sort Field Name 2 E A 
SORTNAME3 89 String*19 Sort Field Name 3 E A 
SORTNAME4 90 String*19 Sort Field Name 4 E A 
SWINVOICE 91 Integer Include Invoice E A  List:2 entries
0 = No
1 = Yes
SWDEBIT 92 Integer Include Debit Note E A  List:2 entries
0 = No
1 = Yes
SWCREDIT 93 Integer Include Credit Note E A  List:2 entries
0 = No
1 = Yes
SWINTEREST 94 Integer Include Interest E A  List:2 entries
0 = No
1 = Yes
SWPAYMENT 95 Integer Include Payment E A  List:2 entries
0 = No
1 = Yes
SWINCLPAID 96 Integer Include Fully Paid Transactions E A  List:2 entries
0 = No
1 = Yes
SWADJUST 97 Integer Include Adjustment E A  List:2 entries
0 = No
1 = Yes
FROMDATE 98 Date From Date E A 
FROMYEAR 99 String*4 From Year E A  Mask: %04D
FROMPERD 100 String*2 From Period E A  Mask: %02D
SWAGERTG 101 Integer Show Aged Retainage E A  List:2 entries
0 = No
1 = Yes

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