Table: Create Open Document List

Table: APPOOP
View: AP0048
Record Length: 674

Flags: A R 

Keys: 1

Title Flags Fields

Populate payment records key PAYMTYPECNTBTCHCNTRMITCNTKEY

Fields: 65

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*18 Check Number Mask: %-18D
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
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