Table: Document Payments

Table: APOBP
View: AP0027
Record Length: 258

Flags: A R 

Keys: 6

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

Fields: 34

Field Type Title Presentation
IDVEND String*12 Vendor Number Mask: %-12C
IDINVC String*22 Document Number Mask: %-22C
CNTPAYMNBR BCD*3.0 Payment Number
IDRMIT String*18 Check Number Mask: %-18D
DATEBUS Date Posting Date
TRANSTYPE Integer Document Type 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 BCD*3.0 Sequence No.
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CNTBTCH BCD*5.0 Batch Number
DATEBTCH Date Batch Date
AMTPAYMHC BCD*10.3 Func. Payment Amount
AMTPAYMTC BCD*10.3 Vend. Payment Amount
CODECURN String*3 Currency Code Mask: %-3N
IDRATETYPE String*2 Rate Type Mask: %-2N
RATEEXCHHC BCD*8.7 Exchange Rate
SWOVRDRATE Integer Rate Overridden List:2 entries
0 = No
1 = Yes
IDBANK String*8 Bank Code Mask: %-8N
TRXTYPE Integer Transaction Type 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 String*22 Reference Document No. Mask: %-22C
IDPREPAID String*22 Reserved:Matching Document No.
IDRMITVEND String*12 Remitting Vendor No.
DATERMIT Date Check Date
CNTITEM BCD*4.0 Entry Number
FISCYR String*4 Year Mask: %04D
FISCPER String*2 Period Mask: %02D
LONGSERIAL ??? Check Serial Number
CODE1099 String*6 1099/CPRS Code
AMT1099 BCD*10.3 1099/CPRS Amount
RATEDATE Date Rate Date
RATEOP Integer Rate Operator
CODETAX String*12 Tax Authority

This page was generated on 2022-Aug-18

© 2021 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).