Table: Create Open Document List

Table: APPOOP
View: AP0048
Record length: 488
Flags: A R 

Keys: 1

Title  Flags  Fields

Populate payment records key  PAYMTYPE, CNTBTCH, CNTRMIT, CNTKEY

Fields: 48

Field  Type  Title  Presentation 

PAYMTYPE  String*2  Payment Type  Mask: %-2N
CNTBTCH  BCD*5.0  Batch Number   
CNTRMIT  BCD*4.0  Entry Number   
CNTKEY  BCD*3.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
PAYMSCHD  BCD*3.0  Number of Payments Scheduled   
PROTYPE  Integer  Process Type  List: 1 entries
1=Select
SHOWTYPE  Integer  Show Type  List: 5 entries
1=All
2=Invoice
3=Debit Note
4=Credit Note
5=Prepayment
ORDERBY  Integer  Order By  List: 7 entries
1=Document Number
2=PO Number
3=Due Date
4=Order Number
5=Document Date
6=Current Balance
7=Original Doc. No.
IDVEND  String*12  Vendor Number  Mask: %-12C
IDINVC  String*22  Invoice Number  Mask: %-22C
IDRMIT  String*12  Check Number  Mask: %-12D
VENDPO  String*22  PO Number  Mask: %-22C
ORDRNBR  String*22  Order Number  Mask: %-22C
TRXTYPE  Integer  Document Type  List: 5 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
10=Prepayment
DATEDUE  Date  Due Date   
DATEDISC  Date  Discount Date   
DATEINVC  Date  Invoice Date   
AMTDUE  BCD*10.3  Payment Schedule Amount Due   
AMTNET  BCD*10.3  Payment Schedule Amount Net   
AMTDISC  BCD*10.3  Payment Schedule Amount Disc   
PAYMAMT  BCD*10.3  Payment Amount   
DISCAMT  BCD*10.3  Discount Amount Taken   
APPLY  String*1  Apply   
MODE  Integer  Mode  List: 2 entries
0=Select
1=Direct
IDTRXTYPE  Integer  Transaction Type  List: 6 entries
12=Invoice - Summary Entered
13=Invoice - Recurring Charge
22=Debit Note - Summary Entered
32=Credit Note - Summary Entered
40=Interest Charge
50=Prepayment - Posted
ADJAMT  BCD*10.3  Adjustment Amount   
STDOCSTR  String*22  Starting Document Number  Mask: %-22C
STDOCDTE  Date  Starting Date   
STDOCAMT  BCD*10.3  Starting Amount   
AMTRMIT  BCD*10.3  Remit Amount   
OBSDISC  BCD*10.3  Payment Sched. Discount Avail.   
TCPLINE  BCD*3.0  TCP Line Number   
STRTVEND  String*12  Starting Vendor Number  Mask: %-12C
ORIGAPLY  String*1  Original Apply   
PNDPAYTOT  BCD*10.3  Pending Payment Amount   
PNDDSCTOT  BCD*10.3  Pending Discount Amount   
PNDADJTOT  BCD*10.3  Pending Adjustment Amount   
AMTPNDBAL  BCD*10.3  Pending Balance   
AMTORIGDOC  BCD*10.3  Original Document Total   
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
RTGAPPLYTO  String*22  Original Doc. No.  Mask: %-22C
SWHOLD  Integer  On Hold  List: 2 entries
0=No
1=Yes
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.