View: Document Payments

RotoID: AP0027
Table: APOBP
Protocol: Flat
DLL:APOBP

Keys: 6

Title Fields
Open Item Payment Schedule key IDVEND, IDINVC, CNTPAYMNBR, IDRMIT, DATEBUS, TRANSTYPE, CNTSEQNCE
Bank Code / Batch Number IDBANK, CNTBTCH, CNTITEM, IDVEND, IDINVC, CNTPAYMNBR
Prepay. Number/Document Number IDPREPAID, IDINVC, CNTPAYMNBR
Invoice Comment Key IDBANK, IDVEND, IDRMIT, LONGSERIAL, DATERMIT
Payment Master Primary Key IDBANK, IDVEND, IDRMIT, LONGSERIAL, DATERMIT, CNTSEQNCE
Vendor, Document, Payment Number IDVEND, IDINVC, CNTPAYMNBR, DATEBUS

Fields: 30

Field Index Type Title Attributes Presentation
IDVEND 1 String*12 Vendor Number E A K R  Mask: %-12C
IDINVC 2 String*22 Document Number E A K R  Mask: %-22C
CNTPAYMNBR 3 BCD*3.0 Payment Number E A K R 
IDRMIT 4 String*18 Check Number E A K R  Mask: %-18D
DATEBUS 5 Date Posting Date E A K R 
TRANSTYPE 6 Integer Document Type E A K R  List:12 entries
6 = Debit Note Applied To
7 = Applied Debit Note
8 = Credit Note Applied To
9 = Applied Credit Note
10 = Prepayment
11 = Payment
12 = Discount
14 = Adjustment
16 = Exchange Gain/Loss
17 = Rounding
18 = Retainage
19 = Tax Withheld
CNTSEQNCE 7 BCD*3.0 Sequence No. E A K R 
CNTBTCH 9 BCD*5.0 Batch Number E A 
DATEBTCH 10 Date Batch Date E A 
AMTPAYMHC 11 BCD*10.3 Func. Payment Amount E A 
AMTPAYMTC 12 BCD*10.3 Vend. Payment Amount E A 
CODECURN 13 String*3 Currency Code E A  Mask: %-3N
IDRATETYPE 14 String*2 Rate Type E A  Mask: %-2N
RATEEXCHHC 15 BCD*8.7 Exchange Rate E A 
SWOVRDRATE 16 Integer Rate Overridden E A  List:2 entries
0 = No
1 = Yes
IDBANK 17 String*8 Bank Code E A  Mask: %-8N
TRXTYPE 18 Integer Transaction Type E A  List:26 entries
41 = Debit Note Applied To
42 = Applied Debit Note
43 = Credit Note Applied To
44 = Applied Credit Note
58 = Prepayment - Applied
59 = Prepayment - Reversed
51 = Payment - Posted
52 = Payment - Applied
53 = Payment - Reversed
61 = Discount - Posted
63 = Discount - Reversed
81 = Adjustment - Posted
83 = Adjustment - Reversed
65 = Exchange Gain/Loss - Posted
67 = Exchange Gain/Loss - Reversed
91 = Rounding - Posted
93 = Rounding - Reversed
69 = Unrealized Exchange Gain/Loss
100 = Retainage - Invoiced
101 = Retainage - Adjusted
102 = Retainage - Revalued
103 = Retainage - Exchange Gain/Loss
104 = Retainage - Rounding
94 = Payment - Invoice Reversed
105 = Tax Withheld - Posted
106 = Tax Withheld - Reversed
IDMEMOXREF 19 String*22 Reference Document No. E A  Mask: %-22C
IDPREPAID 22 String*22 Reserved:Matching Document No. E 
IDRMITVEND 23 String*12 Remitting Vendor No. E A 
DATERMIT 24 Date Check Date E A 
CNTITEM 25 BCD*4.0 Entry Number E A 
FISCYR 27 String*4 Year E A  Mask: %04D
FISCPER 28 String*2 Period E A  Mask: %02D
LONGSERIAL 29 ??? Check Serial Number E A 
CODE1099 30 String*6 1099/CPRS Code E A 
AMT1099 31 BCD*10.3 1099/CPRS Amount E A 
RATEDATE 32 Date Rate Date E A 
RATEOP 33 Integer Rate Operator E A 
CODETAX 34 String*12 Tax Authority E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).