Table: Document Detail Payments

Table: APOBLJP
View: AP0171
Record length: 237
Flags: A R 

Keys: 2

Title  Flags  Fields

Vend. No./Doc. No./Line No./Seq.  IDVEND, IDINVC, CNTLINE, CNTSEQENCE
Vendor, Document, Payment Number  D M  IDBANK, IDVEND, IDRMIT, LONGSERIAL, DATERMIT

Fields: 35

Field  Type  Title  Presentation 

IDVEND  String*12  Vendor Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTLINE  BCD*3.0  Line Number   
CNTSEQENCE  Long  Sequence Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSNBR  Long  Transaction Number   
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
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
69=Unrealized Exchange Gain/Loss
91=Rounding - Posted
93=Rounding - Reversed
100=Retainage - Invoiced
101=Retainage - Adjusted
102=Retainage - Revalued
103=Retainage - Exchange Gain/Loss
104=Retainage - Rounding
94=Payment - Invoice Reversed
TYPEBTCH  String*2  Batch Type  Mask: %-2N
CNTBTCH  BCD*5.0  Batch Number   
CNTITEM  BCD*4.0  Entry Number   
DATEBTCH  Date  Batch Date   
QTYINVC  BCD*10.5  Quantity   
AMTPAYMHC  BCD*10.3  Func. Payment Amount   
AMTPAYMTC  BCD*10.3  Vend. Payment Amount   
TXTOTRTHC  BCD*10.3  Func. Retainage Tax Invoiced   
TXTOTRTTC  BCD*10.3  Vend. Retainage Tax Invoiced   
CODECURN  String*3  Currency Code  Mask: %-3N
IDRATETYPE  String*2  Rate Type  Mask: %-2N
RATEEXCHHC  BCD*8.7  Exchange Rate   
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator   
IDMEMOXREF  String*22  Reference Document Number  Mask: %-22C
IDBANK  String*8  Bank Code  Mask: %-8N
IDRMIT  String*12  Check/Receipt Number  Mask: %-12D
DATERMIT  Date  Payment Date   
LONGSERIAL  Long  Serial Number   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
CODE1099  String*6  1099/CPRS Code   
AMT1099  BCD*10.3  1099/CPRS Amount   

This page was generated on 2008-May-01

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