# View: Create Open Document List

RotoID: AR0061
Tables: ARPOOP
DLL: ARPOOP

## Compositions: 5

RotoID | Title | Tables | DLL
--- | --- | --- | ---
AR0041 | Receipt and Adjustment Batches | ARBTA | ARBTA
AR0042 | Receipts/Adjustments | ARTCR | ARTCR
AR0043 | Miscellaneous Receipts | ARTCN | ARTCN
AR0044 | Applied Receipts/Adjustments | ARTCP | ARTCP
AR0045 | Adjustment G/L Distributions | ARTCU | ARTCU

## Keys: 1

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

## Fields: 41

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
PAYMTYPE | 1 | String*2 | Batch Type | E A K R | Mask: %-2N
CNTBTCH | 2 | BCD*5.0 | Batch Number | E A K R |
CNTITEM | 3 | BCD*4.0 | Entry Number | E A K R |
CNTKEY | 4 | BCD*3.0 | Count key | E A K R |
PAYMSCHD | 5 | BCD*3.0 | Count payments scheduled | E A |
PROTYPE | 6 | Integer | Process Type | E A | List: 2 entries
1 | = | Select
2 | = | Autocash
SHOWTYPE | 7 | Integer | Show Type | E A P | List: 4 entries
1 | = | All
2 | = | Invoice
3 | = | Debit Note
4 | = | Credit Note
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
IDCUST | 9 | String*12 | ID Customer | E A | Mask: %-12C
IDINVC | 10 | String*22 | ID Invc | E A | Mask: %-22C
IDRMIT | 11 | String*24 | Receipt ID | E A | Mask: %-24C
CUSTPO | 12 | String*22 | ID Customer PO | E A | Mask: %-22C
ORDRNBR | 13 | String*22 | ID Order Number | E A | Mask: %-22C
TRXTYPE | 14 | Integer | Text transaction type | E A | List: 7 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
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 Amount Due | E A |
AMTNET | 19 | BCD*10.3 | Payment Amount Net | E A |
AMTDISC | 20 | BCD*10.3 | Payment Amount Discount | E A |
PAYMAMT | 21 | BCD*10.3 | Receipt Amount | E A |
DISCAMT | 22 | BCD*10.3 | Discount Taken Amount | E A |
APPLY | 23 | String*1 | Apply | E A |
MODE | 24 | Integer | Reserved | E |
IDTRXTYPE | 25 | Integer | Text Transaction Type | E A | 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 | 26 | BCD*10.3 | Adjustment Amount | E A |
STDOCSTR | 27 | String*22 | Starting Doc. 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 | Receipt Amount | E A |
OBSDISC | 31 | BCD*10.3 | Payment Discount Available | E A |
TCPLINE | 32 | BCD*3.0 | TCP line count | E A |
STRTCUST | 33 | String*12 | Starting Customer No. | E A | Mask: %-12C
ORIGAPLY | 34 | String*1 | Original Apply | E A |
PNDPAYTOT | 35 | BCD*10.3 | Pending Receipt Amount | E A |
PNDDSCTOT | 36 | BCD*10.3 | Pending Discount Amount | E A |
PNDADJTOT | 37 | BCD*10.3 | Pending Adjustment Amount | E A |
PENDNGBAL | 38 | BCD*10.3 | Pending Balance | E A |
ORGDOCAMT | 39 | BCD*10.3 | Original Document Amount | 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.