View: Payment and Aging Options

RotoID: AP0003
Table: APP03
Protocol: Flat
DLL:APP03

Compositions: 1

RotoID Tables Title DLL
AP0001 APP01 Company Options APP01

Keys: 1

Title Fields
Payment and Aging Options Key RECID03

Fields: 68

Field Index Type Title Attributes Presentation
RECID03 1 String*6 Options Record Key E A K R  Mask: %-6N
DATELASTMN 2 Date Date Last Maintained E A C 
DRCTBTCH 3 BCD*5.0 Next Payment Batch Number E A 
MANLBTCH 4 BCD*5.0 Reserved E 
ADJBTCH 5 BCD*5.0 Next Adjustment Batch Number E A 
ADJTRX 6 BCD*5.0 Reserved E 
PAYMRUN 7 BCD*5.0 Reserved E 
SWCHKPRNT 8 Integer Reserved E 
SWDOCORDR 9 Integer Default Order of Open Documents E A  List:7 entries
1 = Document Number
2 = PO Number
3 = Due Date
4 = Order Number
5 = Document Date
6 = Current Balance
7 = Original Doc. No.
SWPAYMBANK 10 Integer Reserved E 
AGINPRD1 11 BCD*3.0 Aging Period 1 E A 
AGINPRD2 12 BCD*3.0 Aging Period 2 E A 
AGINPRD3 13 BCD*3.0 Aging Period 3 E A 
SWAGECR 14 Integer Age Credit Notes & Debit Notes E A  List:2 entries
1 = As Current
2 = By Date
DTPREREG 15 Date Date Last Preregistered E A 
TMPREREG 16 Time Time Last Preregistered E A 
DTDRCTCHK 17 Date Date Last Direct Check E A 
TMDRCTCHK 18 Time Time Last Direct Check E A 
DTSYSCHK 19 Date Date Last Sys. Check E A 
TMSYSCHK 20 Time Time Last Sys. Check E A 
SWSYSBTCH 21 Integer Allow Edit of System Batches E A  List:2 entries
0 = No
1 = Yes
SWFORCREG 22 Integer Reserved E 
IDDFLTBANK 23 String*8 Default Bank Code E A  Mask: %-8N
DFLTRATE 24 String*2 Reserved E 
PAYMCODE 25 String*12 Payment Code E A  Mask: %-12N
CNTPPDBTCH 26 BCD*5.0 Next Prepayment Number E A 
CNTSYSBTCH 27 BCD*5.0 Reserved E 
CNTNXTPAYM 28 BCD*5.0 Next Payment Posting Sequence E A 
CNTNXTADJM 29 BCD*5.0 Next Adjustment Posting Sequence E A 
SWPAYMBTCH 30 Integer Allow Adjustments in Payment Batch E A  List:2 entries
0 = No
1 = Yes
PPDPREFIX 31 String*6 Prepayment Prefix E A  Mask: %-6C
PPDPFXLEN 32 BCD*2.0 Prepayment Number Length E A 
SWAGEUAPL 33 Integer Age Unapplied Cash & Prepayments E A  List:2 entries
1 = As Current
2 = By Date
CNTNXTUAPL 34 BCD*5.0 Reserved E 
ADPFX 35 String*6 Adjustment Prefix E A  Mask: %-6C
ADPFXLEN 36 BCD*2.0 Adjustment Number Length E A 
ADNEXTSEQ 37 BCD*5.0 Next Adjustment Number E A 
RPPFX 38 String*6 Recurring Payable Prefix E A  Mask: %-6C
RPPFXLEN 39 BCD*2.0 Recurring Payable Number Length E A 
RPNEXTSEQ 40 BCD*5.0 Next Recurring Payable Number E A 
RMITTYPE 41 Integer Default Transaction Type E A  List:4 entries
1 = Payment
2 = Prepayment
3 = Apply Document
4 = Misc. Payment
PYPFX 42 String*6 Payment Prefix E A  Mask: %-6C
PYPFXLEN 43 BCD*2.0 Payment Number Length E A 
PYNEXTSEQ 44 BCD*5.0 Next Payment Number E A 
RIPFX 45 String*6 Retainage Invoice Prefix E A  Mask: %-6C
RIPFXLEN 46 BCD*2.0 Retainage Invoice Number Length E A 
RINEXTSEQ 47 BCD*5.0 Next Retainage Invoice Number E A 
RCPFX 48 String*6 Retainage Credit Note Prefix E A  Mask: %-6C
RCPFXLEN 49 BCD*2.0 Retainage Credit Note No. Length E A 
RCNEXTSEQ 50 BCD*5.0 Next Retainage Credit Note No. E A 
RDPFX 51 String*6 Retainage Debit Note Prefix E A  Mask: %-6C
RDPFXLEN 52 BCD*2.0 Retainage Debit Note No. Length E A 
RDNEXTSEQ 53 BCD*5.0 Next Retainage Debit Note No. E A 
SWRTG 54 Integer Use Retainage E A  List:2 entries
0 = No
1 = Yes
SWRTGBASE 55 Integer Retainage Base E A  List:2 entries
0 = Document Total After Taxes
1 = Document Total Before Taxes
RTGSCHDKEY 56 String*12 Retainage Schedule E A  Mask: %-12N
RTGSCHDLNK 57 BCD*10.0 Retainage Schedule Link E A C 
RTGLASTRUN 58 Date Date Retainage Sched. Last Run E A C 
RTGDAYS 59 Integer Days Retained E A 
RTGPERCENT 60 BCD*5.5 Percent Retained E A 
RTGADVDAYS 61 Integer Days Before Retainage Due E A 
SWRTGRATE 62 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
SWTXRTGRPT 63 Integer Report Retainage Tax E A  List:2 entries
0 = At Time of Original Document
1 = As Per Tax Authority
SWCHNGRMIT 64 Integer Allow Edit of Remit-To Info. E A  List:2 entries
0 = No
1 = Yes
SWCHKDUP 65 Integer Check for Duplicate Checks E A  List:3 entries
0 = None
1 = Warning
2 = Error
SWSHPYPND 66 Integer Include Pending Transactions E A  List:4 entries
0 = None
1 = Payments
2 = Payments and Adjustments
3 = All Transactions
SWDATEBUS 67 Integer Default Posting Date E A  List:3 entries
0 = Document Date
1 = Batch Date
2 = Session Date
SORTCHKBY 68 Integer Sort Checks By E A  List:5 entries
0 = Transaction Entry Number
1 = Vendor Number
2 = Payee Name
3 = Payee Country
4 = Payee Zip/Postal Code

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