# Table: Create Open Document List

Table: ARPOOP
View: AR0061
Record length: 520
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Open Document List Key |  | PAYMTYPE, CNTBTCH, CNTITEM, CNTKEY

## Fields: 48

Field | Type | Title | Presentation
--- | --- | --- | ---
PAYMTYPE | String*2 | Batch Type | Mask: %-2N
CNTBTCH | BCD*5.0 | Batch Number |
CNTITEM | BCD*4.0 | Entry Number |
CNTKEY | BCD*3.0 | Count key |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
PAYMSCHD | BCD*3.0 | Count payments scheduled |
PROTYPE | Integer | Process Type | List: 2 entries
1 | = | Select
2 | = | Autocash
SHOWTYPE | Integer | Show Type | List: 4 entries
1 | = | All
2 | = | Invoice
3 | = | Debit Note
4 | = | Credit Note
ORDERBY | Integer | Order By | List: 8 entries
1 | = | Document Number
2 | = | PO Number
3 | = | Due Date
4 | = | Order Number
7 | = | Shipment Number
5 | = | Document Date
6 | = | Current Balance
8 | = | Original Doc. No.
IDCUST | String*12 | ID Customer | Mask: %-12C
IDINVC | String*22 | ID Invc | Mask: %-22C
IDRMIT | String*24 | Receipt ID | Mask: %-24C
CUSTPO | String*22 | PO Number | Mask: %-22C
ORDRNBR | String*22 | Order Number | Mask: %-22C
IDSHIPNBR | String*22 | Shipment Number | Mask: %-22C
TRXTYPE | Integer | Text transaction type | List: 7 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
DATEDUE | Date | Due Date |
DATEDISC | Date | Discount date |
DATEINVC | Date | Invoice date |
AMTDUE | BCD*10.3 | Payment Amount Due |
AMTNET | BCD*10.3 | Payment Amount Net |
AMTDISC | BCD*10.3 | Payment Amount Discount |
PAYMAMT | BCD*10.3 | Receipt Amount |
DISCAMT | BCD*10.3 | Discount Taken Amount |
APPLY | String*1 | Apply |
MODE | Integer | Reserved |
IDTRXTYPE | Integer | Text Transaction Type | List: 10 entries
11 | = | Invoice - Item Issued
13 | = | Invoice - Recurring Charge
14 | = | Invoice - Summary Issued
21 | = | Debit Note - Item Issued
24 | = | Debit Note - Summary Issued
31 | = | Credit Note - Item Issued
34 | = | Credit Note - Summary Issued
40 | = | Interest Charge
1 | = | Unapplied Cash - Posted
50 | = | Prepayment - Posted
ADJAMT | BCD*10.3 | Adjustment Amount |
STDOCSTR | String*22 | Starting Doc. Number | Mask: %-22C
STDOCDTE | Date | Starting Date |
STDOCAMT | BCD*10.3 | Starting Amount |
AMTRMIT | BCD*10.3 | Receipt Amount |
OBSDISC | BCD*10.3 | Payment Discount Available |
TCPLINE | BCD*3.0 | TCP line count |
STRTCUST | String*12 | Starting Customer No. | Mask: %-12C
ORIGAPLY | String*1 | Original Apply |
PNDPAYTOT | BCD*10.3 | Pending Receipt Amount |
PNDDSCTOT | BCD*10.3 | Pending Discount Amount |
PNDADJTOT | BCD*10.3 | Pending Adjustment Amount |
PENDNGBAL | BCD*10.3 | Pending Balance |
ORGDOCAMT | BCD*10.3 | Original Document Amount |
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C
TEXTDESC | String*60 | Description |
TEXTREF | String*60 | Reference |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.