Table: Document Payments

Table: AROBP
View: AR0038
Record length: 256
Flags: A R 

Keys: 7

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

Fields: 37

Field  Type  Title  Presentation 
IDCUST  String*12  Customer Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYMNBR  BCD*3.0  Payment Number   
IDRMIT  String*24  Check/Receipt No.  Mask: %-24C
DATEBUS  Date  Posting Date   
TRANSTYPE  Integer  Document Type  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  BCD*3.0  Sequence No.   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DEPSTNBR  BCD*5.0  Deposit Number   
CNTBTCH  BCD*5.0  Batch Number   
DATEBTCH  Date  Batch Date   
AMTPAYMHC  BCD*10.3  Func. Receipt Amount   
AMTPAYMTC  BCD*10.3  Cust. Receipt 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: 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  String*22  Reference Document No.   
SWINVCDEL  Integer  Delete Invoice Switch   
DATELSTSTM  Date  Last Statement Date   
IDPREPAID  String*22  Prepay. Apply-to Doc. No.   
IDCUSTRMIT  String*12  Remitting Customer No.  Mask: %-12C
DATERMIT  Date  Receipt Date   
CNTITEM  BCD*4.0  Entry Number   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
RATEDATE  Date  Rate Date   
RATEOP  Integer  Rate Operator   
STMTSEQ  Long  Statement Run No.   
PYMCUID  Long  Payment CUID   
DEPSEQ  Long  Deposit Serial Number   
DEPLINE  Long  Deposit Line Number   

This page was generated on 2008-May-01

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