View: Create Open Document List

RotoID: AP0048
Table: APPOOP
Protocol: Flat, Sequenced revisions, Key auto generate
DLL:APPOOP

Compositions: 5

RotoID Tables Title DLL
AP0030 APBTA Payment and Adjustment Batches APBTA
AP0031 APTCR Payments/Adjustments APTCR
AP0032 APTCN Miscellaneous Payments APTCN
AP0033 APTCP Applied Payments APTCP
AP0034 APTCU Adjustment G/L Distributions APTCU

Keys: 1

Title Fields
Populate payment records key PAYMTYPE, CNTBTCH, CNTRMIT, CNTKEY

Fields: 67

Field Index Type Title Attributes Presentation
PAYMTYPE 1 String*2 Payment Type E A K R  Mask: %-2N
CNTBTCH 2 BCD*5.0 Batch Number E A K R 
CNTRMIT 3 BCD*4.0 Entry Number E A K R 
CNTKEY 4 BCD*3.0 Line Number E A K R 
PAYMSCHD 5 BCD*3.0 Number of Payments Scheduled E A 
PROTYPE 6 Integer Process Type E A  List:1 entries
1 = Select
SHOWTYPE 7 Integer Show Type E A P  List:5 entries
1 = All
2 = Invoice
3 = Debit Note
4 = Credit Note
5 = Prepayment
ORDERBY 8 Integer Order By 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.
IDVEND 9 String*12 Vendor Number E A  Mask: %-12C
IDINVC 10 String*22 Invoice Number E A  Mask: %-22C
IDRMIT 11 String*18 Check Number E A  Mask: %-18D
VENDPO 12 String*22 PO Number E A  Mask: %-22C
ORDRNBR 13 String*22 Order Number E A  Mask: %-22C
TRXTYPE 14 Integer Document Type E A  List:5 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
10 = Prepayment
DATEDUE 15 Date Due Date E A 
DATEDISC 16 Date Discount Date E A 
DATEINVC 17 Date Invoice Date E A 
AMTDUE 18 BCD*10.3 Payment Schedule Amount Due E A 
AMTNET 19 BCD*10.3 Payment Schedule Amount Net E A 
AMTDISC 20 BCD*10.3 Payment Schedule Amount Disc E A 
PAYMAMT 21 BCD*10.3 Payment Amount E A 
DISCAMT 22 BCD*10.3 Discount Amount Taken E A 
APPLY 23 String*1 Apply E A 
MODE 24 Integer Mode E A  List:2 entries
0 = Select
1 = Direct
IDTRXTYPE 25 Integer Transaction Type E A  List:6 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
32 = Credit Note - Summary Entered
40 = Interest Charge
50 = Prepayment - Posted
ADJAMT 26 BCD*10.3 Adjustment Amount E A 
STDOCSTR 27 String*22 Starting Document Number E A  Mask: %-22C
STDOCDTE 28 Date Starting Date E A 
STDOCAMT 29 BCD*10.3 Starting Amount E A 
AMTRMIT 30 BCD*10.3 Remit Amount E A 
OBSDISC 31 BCD*10.3 Payment Sched. Discount Avail. E A 
TCPLINE 32 BCD*3.0 TCP Line Number E A 
STRTVEND 33 String*12 Starting Vendor Number E A  Mask: %-12C
ORIGAPLY 34 String*1 Original Apply E A 
PNDPAYTOT 35 BCD*10.3 Pending Payment Amount E A 
PNDDSCTOT 36 BCD*10.3 Pending Discount Amount E A 
PNDADJTOT 37 BCD*10.3 Pending Adjustment Amount E A 
AMTPNDBAL 38 BCD*10.3 Pending Balance E A 
AMTORIGDOC 39 BCD*10.3 Original Document Total E A 
SWJOB 40 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
RTGAPPLYTO 41 String*22 Original Doc. No. E A  Mask: %-22C
SWHOLD 42 Integer On Hold E A  List:2 entries
0 = No
1 = Yes
TEXTDESC 43 String*60 Description E A 
TEXTREF 44 String*60 Reference E A 
AMTWHD1TC 45 BCD*10.3 Tax Withheld Amount 1 E A 
AMTWHD2TC 46 BCD*10.3 Tax Withheld Amount 2 E A 
AMTWHD3TC 47 BCD*10.3 Tax Withheld Amount 3 E A 
AMTWHD4TC 48 BCD*10.3 Tax Withheld Amount 4 E A 
AMTWHD5TC 49 BCD*10.3 Tax Withheld Amount 5 E A 
AMTWHDTOT 50 BCD*10.3 Tax Withheld Amount Total E A 
PNDWHD1TOT 51 BCD*10.3 Pending Tax Withheld Amount 1 E A 
PNDWHD2TOT 52 BCD*10.3 Pending Tax Withheld Amount 2 E A 
PNDWHD3TOT 53 BCD*10.3 Pending Tax Withheld Amount 3 E A 
PNDWHD4TOT 54 BCD*10.3 Pending Tax Withheld Amount 4 E A 
PNDWHD5TOT 55 BCD*10.3 Pending Tax Withheld Amount 5 E A 
PNDWHDTOT 56 BCD*10.3 Pending Tax Withheld Total E A 
CODETAX1 57 String*12 Document Tax Authority 1 E A 
CODETAX2 58 String*12 Document Tax Authority 2 E A 
CODETAX3 59 String*12 Document Tax Authority 3 E A 
CODETAX4 60 String*12 Document Tax Authority 4 E A 
CODETAX5 61 String*12 Document Tax Authority 5 E A 
TXAU1DESC 65 String*60 Tax Auth 1 Description E A C 
TXAU2DESC 66 String*60 Tax Auth 2 Description E A C 
TXAU3DESC 67 String*60 Tax Auth 3 Description E A C 
TXAU4DESC 68 String*60 Tax Auth 4 Description E A C 
TXAU5DESC 69 String*60 Tax Auth 5 Description E A C 
APPLYMETH 70 Integer Job Apply Method 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).