View: Document Payments

RotoID: AR0038
Table: AROBP
Protocol: Flat
DLL: AROBP

Compositions: 0

Keys: 7

Title  Fields
Payment Audit Key  IDCUST, IDINVC, CNTPAYMNBR, IDRMIT, DATEBUS, TRANSTYPE, CNTSEQNCE
Bank Code  IDBANK, CNTBTCH, CNTITEM, IDCUST, IDINVC, CNTPAYMNBR
Document  IDINVC, CNTPAYMNBR
Customer, Reference Doc. No.  IDCUST, IDMEMOXREF
Bank, Customer, Check/Receipt No  IDBANK, IDCUSTRMIT, IDRMIT, DATERMIT
Customer, Document, Posting Date  IDCUST, IDINVC, CNTPAYMNBR, DATEBUS
Customer, Payment CUID, Document  IDCUST, PYMCUID, IDINVC, CNTPAYMNBR

Fields: 33

Field  Index  Type  Title  Attributes  Presentation
IDCUST  1  String*12  Customer 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*24  Check/Receipt No.  E A K R  Mask: %-24C
DATEBUS  5  Date  Posting Date  E A K R   
TRANSTYPE  6  Integer  Document Type  E A K R  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
CNTSEQNCE  7  BCD*3.0  Sequence No.  E A K R   
DEPSTNBR  8  BCD*5.0  Deposit Number  E A   
CNTBTCH  9  BCD*5.0  Batch Number  E A   
DATEBTCH  10  Date  Batch Date  E A   
AMTPAYMHC  11  BCD*10.3  Func. Receipt Amount  E A   
AMTPAYMTC  12  BCD*10.3  Cust. Receipt 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: 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
IDMEMOXREF  19  String*22  Reference Document No.  E A   
SWINVCDEL  20  Integer  Delete Invoice Switch  E   
DATELSTSTM  21  Date  Last Statement Date  E A   
IDPREPAID  22  String*22  Prepay. Apply-to Doc. No.  E   
IDCUSTRMIT  23  String*12  Remitting Customer No.  E A  Mask: %-12C
DATERMIT  24  Date  Receipt Date  E A   
CNTITEM  25  BCD*4.0  Entry Number  E A   
FISCYR  26  String*4  Fiscal Year  E A  Mask: %04D
FISCPER  27  String*2  Fiscal Period  E A  Mask: %02D
RATEDATE  28  Date  Rate Date  E A   
RATEOP  29  Integer  Rate Operator  E A   
STMTSEQ  31  Long  Statement Run No.  E A   
PYMCUID  32  Long  Payment CUID  E A   
DEPSEQ  33  Long  Deposit Serial Number  E A   
DEPLINE  34  Long  Deposit Line Number  E A   

This page was generated on 2009-Nov-19

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