View: Document Detail Payments

RotoID: AR0088
Table: AROBLJP
Protocol: Flat
DLL: AROBLJP

Compositions: 0

Keys: 3

Title  Fields

Cust. No./Doc. No./Line No./Seq.  IDCUST, IDINVC, CNTLINE, CNTSEQENCE
Bank, Customer, Check/Receipt No  IDBANK, IDCUSTRMIT, IDRMIT, DATERMIT
Customer, Payment CUID, Document  IDCUST, PYMCUID, IDINVC, CNTLINE

Fields: 31

Field  Index  Type  Title  Attributes  Presentation

IDCUST  String*12  Customer Number  E A K R  Mask: %-12C
IDINVC  String*22  Document Number  E A K R  Mask: %-22C
CNTLINE  BCD*3.0  Line Number  E A K R   
CNTSEQENCE  Long  Sequence Number  E A K R   
TRANSNBR  Long  Transaction Number  E A   
DATEBUS  Date  Posting Date  E A   
TRANSTYPE  Integer  Document Type  E A  List: 13 entries
5=Unapplied Cash
6=Debit Note Applied To
7=Applied Debit Note
8=Credit Note Applied To
9=Applied Credit Note
10=Prepayment
11=Receipt
12=Discount
14=Adjustment
16=Exchange Gain/Loss
17=Rounding
19=Refund
18=Retainage
TRXTYPE  Integer  Transaction Type  E A  List: 29 entries
3=Unapplied Cash - Applied
4=Unapplied Cash - Reversed
41=Debit Note Applied To
42=Applied Debit Note
43=Credit Note Applied To
44=Applied Credit Note
51=Receipt - Posted
52=Receipt - Applied
53=Receipt - Reversed
58=Prepayment - Applied
59=Prepayment - Reversed
61=Discount - Posted
63=Discount - Reversed
65=Exchange Gain/Loss - Posted
67=Exchange Gain/Loss - Reversed
91=Rounding - Posted
93=Rounding - Reversed
69=Unrealized Exchange Gain/Loss
80=Write-Off - Posted
81=Adjustment - Posted
83=Adjustment - Reversed
73=Refund - Posted
75=Refund - Reversed
100=Retainage - Invoiced
101=Retainage - Adjusted
102=Retainage - Revalued
103=Retainage - Exchange Gain/Loss
104=Retainage - Rounding
85=Receipt - Invoice Reversed
TYPEBTCH  String*2  Batch Type  E A  Mask: %-2N
CNTBTCH  10  BCD*5.0  Batch Number  E A   
CNTITEM  11  BCD*4.0  Entry Number  E A   
DATEBTCH  12  Date  Batch Date  E A   
AMTPAYMHC  13  BCD*10.3  Func. Receipt Amount  E A   
AMTPAYMTC  14  BCD*10.3  Cust. Receipt Amount  E A   
TXTOTRTHC  15  BCD*10.3  Func. Retainage Tax Invoiced  E A   
TXTOTRTTC  16  BCD*10.3  Cust. Retainage Tax Invoiced  E A   
CODECURN  17  String*3  Currency Code  E A  Mask: %-3N
IDRATETYPE  18  String*2  Rate Type  E A  Mask: %-2N
RATEEXCHHC  19  BCD*8.7  Exchange Rate  E A   
RATEDATE  20  Date  Rate Date  E A   
RATEOP  21  Integer  Rate Operator  E A   
IDBANK  22  String*8  Bank Code  E A  Mask: %-8N
IDCUSTRMIT  23  String*12  Remitting Customer Number  E A  Mask: %-12C
IDRMIT  24  String*24  Check/Receipt No.  E A  Mask: %-24C
DEPSEQ  25  Long  Deposit Serial Number  E A   
DEPLINE  26  Long  Deposit Line Number  E A   
DATERMIT  27  Date  Receipt Date  E A   
PYMCUID  28  Long  Payment CUID  E A   
IDMEMOXREF  29  String*22  Reference Document Number  E A   
FISCYR  30  String*4  Fiscal Year  E A  Mask: %04D
FISCPER  31  String*2  Fiscal Period  E A  Mask: %02D

This page was generated on 2008-May-01

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