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.