# Table: Create Open Document List

Table: APPOOP
View: AP0048
Record length: 366
Flags: A R

## Keys: 1

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

## Fields: 45

Field | Type | Title | Presentation
--- | --- | --- | ---
PAYMTYPE | String*2 | Payment Type | Mask: %-2N
CNTBTCH | BCD*5.0 | Batch Number |
CNTRMIT | BCD*4.0 | Count Remit |
CNTKEY | BCD*3.0 | Count Key |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
PAYMSCHD | BCD*3.0 | Number of Payments Scheduled |
PROTYPE | Integer | Process Type | List: 1 entries
1 | = | Select
SHOWTYPE | Integer | Show Type | List: 5 entries
1 | = | All
2 | = | Invoice
3 | = | Debit Note
4 | = | Credit Note
5 | = | Prepayment
ORDERBY | Integer | Order By | List: 6 entries
1 | = | Document No.
2 | = | PO Number
3 | = | Due Date
4 | = | Sales Order No.
5 | = | Document Date
6 | = | Current Balance
IDVEND | String*12 | Vendor Number | Mask: %-12C
IDINVC | String*22 | Invoice Number | Mask: %-22C
IDRMIT | String*12 | Check Number | Mask: %-12D
VENDPO | String*22 | Vendor PO Number | Mask: %-22C
ORDRNBR | String*22 | Sales Order Number | Mask: %-22C
TRXTYPE | Integer | Document Type | List: 5 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
10 | = | Prepayment
DATEDUE | Date | Due Date |
DATEDISC | Date | Discount Date |
DATEINVC | Date | Invoice Date |
AMTDUE | BCD*10.3 | Payment Schedule Amount Due |
AMTNET | BCD*10.3 | Payment Schedule Amount Net |
AMTDISC | BCD*10.3 | Payment Schedule Amount Disc |
PAYMAMT | BCD*10.3 | Payment Amount |
DISCAMT | BCD*10.3 | Discount Amount Taken |
APPLY | String*1 | Apply |
MODE | Integer | Mode | List: 2 entries
0 | = | Select
1 | = | Direct
IDTRXTYPE | Integer | Transaction Type | 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 | BCD*10.3 | Adjustment Amount |
STDOCSTR | String*22 | Starting Document Number | Mask: %-22C
STDOCDTE | Date | Starting Date |
STDOCAMT | BCD*10.3 | Starting Amount |
AMTRMIT | BCD*10.3 | Remit Amount |
OBSDISC | BCD*10.3 | Payment Sched. Discount Avail. |
TCPLINE | BCD*3.0 | TCP Line Number |
STRTVEND | String*12 | Starting Vendor Number | Mask: %-12C
ORIGAPLY | String*1 | Original Apply |
PNDPAYTOT | BCD*10.3 | Pending Payment Amount |
PNDDSCTOT | BCD*10.3 | Pending Discount Amount |
PNDADJTOT | BCD*10.3 | Pending Adjustment Amount |
AMTPNDBAL | BCD*10.3 | Pending Balance |
AMTORIGDOC | BCD*10.3 | Original Document Total |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C

This page was generated on 2004-Oct-28

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