# View: Create Open Document List

RotoID: AP0048
Tables: APPOOP
DLL: APPOOP

## Compositions: 5

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

## Keys: 1

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

## Fields: 41

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 | Count Remit | E A K R |
CNTKEY | 4 | BCD*3.0 | Count Key | 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: 6 entries
1 | = | Document No.
2 | = | PO Number
3 | = | Due Date
4 | = | Sales Order No.
5 | = | Document Date
6 | = | Current Balance
IDVEND | 9 | String*12 | Vendor Number | E A | Mask: %-12C
IDINVC | 10 | String*22 | Invoice Number | E A | Mask: %-22C
IDRMIT | 11 | String*12 | Check Number | E A | Mask: %-12D
VENDPO | 12 | String*22 | Vendor PO Number | E A | Mask: %-22C
ORDRNBR | 13 | String*22 | Sales 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

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.