View: Create Open Document List

RotoID: AR0061
Table: ARPOOP
Protocol: Flat, Sequenced revisions, Key auto generate
DLL:ARPOOP

Compositions: 5

RotoID Tables Title DLL

AR0041 ARBTA Receipt and Adjustment Batches ARBTA
AR0042 ARTCR Receipts/Adjustments ARTCR
AR0043 ARTCN Miscellaneous Receipts ARTCN
AR0044 ARTCP Applied Receipts/Adjustments ARTCP
AR0045 ARTCU Adjustment G/L Distributions ARTCU

Keys: 1

Title Fields

Open Document List Key PAYMTYPECNTBTCHCNTITEMCNTKEY

Fields: 66

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: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 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 PO Number E A  Mask: %-22C
ORDRNBR 13 String*22 Order Number E A  Mask: %-22C
IDSHIPNBR 14 String*22 Shipment Number E A  Mask: %-22C
TRXTYPE 15 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 16 Date Due Date E A 
DATEDISC 17 Date Discount date E A 
DATEINVC 18 Date Invoice date E A 
AMTDUE 19 BCD*10.3 Payment Amount Due E A 
AMTNET 20 BCD*10.3 Payment Amount Net E A 
AMTDISC 21 BCD*10.3 Payment Amount Discount E A 
PAYMAMT 22 BCD*10.3 Receipt Amount E A 
DISCAMT 23 BCD*10.3 Discount Taken Amount E A 
APPLY 24 String*1 Apply E A 
MODE 25 Integer Reserved E 
IDTRXTYPE 26 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 27 BCD*10.3 Adjustment Amount E A 
STDOCSTR 28 String*22 Starting Doc. Number E A  Mask: %-22C
STDOCDTE 29 Date Starting Date E A 
STDOCAMT 30 BCD*10.3 Starting Amount E A 
AMTRMIT 31 BCD*10.3 Receipt Amount E A 
OBSDISC 32 BCD*10.3 Payment Discount Available E A 
TCPLINE 33 BCD*3.0 TCP line count E A 
STRTCUST 34 String*12 Starting Customer No. E A  Mask: %-12C
ORIGAPLY 35 String*1 Original Apply E A 
PNDPAYTOT 36 BCD*10.3 Pending Receipt Amount E A 
PNDDSCTOT 37 BCD*10.3 Pending Discount Amount E A 
PNDADJTOT 38 BCD*10.3 Pending Adjustment Amount E A 
PENDNGBAL 39 BCD*10.3 Pending Balance E A 
ORGDOCAMT 40 BCD*10.3 Original Document Amount E A 
SWJOB 41 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
RTGAPPLYTO 42 String*22 Original Doc. No. E A  Mask: %-22C
TEXTDESC 43 String*60 Description E A 
TEXTREF 44 String*60 Reference E A 
AMTWHD1TC 45 BCD*10.3 Tax Withheld Amount 1 E A 
AMTWHD2TC 46 BCD*10.3 Tax Withheld Amount 2 E A 
AMTWHD3TC 47 BCD*10.3 Tax Withheld Amount 3 E A 
AMTWHD4TC 48 BCD*10.3 Tax Withheld Amount 4 E A 
AMTWHD5TC 49 BCD*10.3 Tax Withheld Amount 5 E A 
AMTWHDTOT 50 BCD*10.3 Tax Withheld Amount Total E A 
PNDWHD1TOT 51 BCD*10.3 Pending Tax Withheld Amount 1 E A 
PNDWHD2TOT 52 BCD*10.3 Pending Tax Withheld Amount 2 E A 
PNDWHD3TOT 53 BCD*10.3 Pending Tax Withheld Amount 3 E A 
PNDWHD4TOT 54 BCD*10.3 Pending Tax Withheld Amount 4 E A 
PNDWHD5TOT 55 BCD*10.3 Pending Tax Withheld Amount 5 E A 
PNDWHDTOT 56 BCD*10.3 Pending Tax Withheld Total E A 
CODETAX1 57 String*12 Document Tax Authority 1 E A 
CODETAX2 58 String*12 Document Tax Authority 2 E A 
CODETAX3 59 String*12 Document Tax Authority 3 E A 
CODETAX4 60 String*12 Document Tax Authority 4 E A 
CODETAX5 61 String*12 Document Tax Authority 5 E A 
TXAU1DESC 150 String*60 Tax Auth 1 Description E A C 
TXAU2DESC 151 String*60 Tax Auth 2 Description E A C 
TXAU3DESC 152 String*60 Tax Auth 3 Description E A C 
TXAU4DESC 153 String*60 Tax Auth 4 Description E A C 
TXAU5DESC 154 String*60 Tax Auth 5 Description E A C