Table: Document Payments

Table: APOBP
View: AP0027
Record length: 236
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: 33

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*12  Check Number  Mask: %-12D
DATEBUS  Date  Posting Date   
TRANSTYPE  Integer  Document Type  List: 11 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
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: 24 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
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  Long  Check Serial Number   
CODE1099  String*6  1099/CPRS Code   
AMT1099  BCD*10.3  1099/CPRS Amount   
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.