Table: Create Open Document List

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

Keys: 1


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

Fields: 43


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: 6 entries
1=Document Number
2=PO Number
3=Due Date
4=Sales Order Number
5=Document Date
6=Current Balance
IDCUST  String*12  ID Customer  Mask: %-12C
IDINVC  String*15  ID Invc  Mask: %-15C
IDRMIT  String*24  Receipt ID  Mask: %-24C
CUSTPO  String*22  ID Customer PO  Mask: %-22C
ORDRNBR  String*22  ID Order Number  Mask: %-22C
TRXTYPE  Integer  Text transaction type  List: 4 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
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: 8 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
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   

This page was generated on 2002-Oct-04

Copyright © 2002 ACCPAC International, Inc. All rights reserved.