Table: Create Open Document List

Table: ARPOOP
View: AR0061
Record Length: 700

Flags: A R 

Keys: 1

Title Flags Fields

Open Document List Key PAYMTYPECNTBTCHCNTITEMCNTKEY

Fields: 65

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
AMTWHD1TC BCD*10.3 Tax Withheld Amount 1
AMTWHD2TC BCD*10.3 Tax Withheld Amount 2
AMTWHD3TC BCD*10.3 Tax Withheld Amount 3
AMTWHD4TC BCD*10.3 Tax Withheld Amount 4
AMTWHD5TC BCD*10.3 Tax Withheld Amount 5
AMTWHDTOT BCD*10.3 Tax Withheld Amount Total
PNDWHD1TOT BCD*10.3 Pending Tax Withheld Amount 1
PNDWHD2TOT BCD*10.3 Pending Tax Withheld Amount 2
PNDWHD3TOT BCD*10.3 Pending Tax Withheld Amount 3
PNDWHD4TOT BCD*10.3 Pending Tax Withheld Amount 4
PNDWHD5TOT BCD*10.3 Pending Tax Withheld Amount 5
PNDWHDTOT BCD*10.3 Pending Tax Withheld Total
CODETAX1 String*12 Document Tax Authority 1
CODETAX2 String*12 Document Tax Authority 2
CODETAX3 String*12 Document Tax Authority 3
CODETAX4 String*12 Document Tax Authority 4
CODETAX5 String*12 Document Tax Authority 5