Table: Posting Journal Entries

Table: ARPJH
View: AR0408
Record length: 604
Flags: A R 

Keys: 1

Title  Flags  Fields

Batch Type/Post. Seq./Batch/Entr  TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM

Fields: 70

Field  Type  Title  Presentation 

TYPEBTCH  String*2  Batch Type  Mask: %-2N
POSTSEQNCE  BCD*5.0  Posting Sequence No.   
CNTBTCH  BCD*5.0  Batch No.   
CNTITEM  BCD*4.0  Entry No.   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDCUST  String*12  Customer No.  Mask: %-12C
IDINVC  String*22  Document No.  Mask: %-22C
CNTPAYM  BCD*3.0  Payment No.   
TRANSTYPE  Integer  Document Type  List: 10 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
5=Unapplied Cash
10=Prepayment
11=Receipt
14=Adjustment
16=Exchange Gain/Loss
19=Refund
TRXTYPE  Integer  Transaction Type  List: 30 entries
11=Invoice - Item Issued
12=Invoice - Summary Entered
13=Invoice - Recurring Charge
14=Invoice - Summary Issued
15=Invoice - Item Entered
21=Debit Note - Item Issued
22=Debit Note - Summary Entered
24=Debit Note - Summary Issued
25=Debit Note - Item Entered
31=Credit Note - Item Issued
32=Credit Note - Summary Entered
34=Credit Note - Summary Issued
35=Credit Note - Item Entered
40=Interest Charge
81=Adjustment - Posted
80=Write-Off - Posted
2=Unapplied Cash - Posted
57=Prepayment - Posted
3=Unapplied Cash - Applied
58=Prepayment - Applied
43=Credit Note Applied To
44=Applied Credit Note
51=Receipt - Posted
52=Receipt - Applied
53=Receipt - Reversed
69=Unrealized Exchange Gain/Loss
73=Refund - Posted
75=Refund - Reversed
65=Exchange Gain/Loss - Posted
85=Receipt - Invoice Reversed
IDGRP  String*6  Group Code  Mask: %-6N
IDACCTSET  String*6  Account Set  Mask: %-6N
CODETAXGRP  String*12  Tax Group  Mask: %-12N
CODETERM  String*6  Terms Code  Mask: %-6N
IDBILLCYC  String*6  Billing Cycle  Mask: %-6N
IDCUSTSHP  String*6  Ship-To Location Code  Mask: %-6C
DATEINVC  Date  Document Date   
DATEDISC  Date  Discount Date   
DATEDUE  Date  Due Date   
DATEBTCH  Date  Batch Date   
PCTDISC  BCD*5.5  Discount Percentage   
SWNONRCVBL  Integer  Misc. Receipt Flag   
GLBATCH  String*6  G/L Batch No.   
GLENTRY  String*5  G/L Entry No.   
CNTADJNBR  BCD*5.0  Adjustment Number   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
IDINVCAPPL  String*22  Apply-To Doc. No.  Mask: %-22C
DESC  String*60  Description   
IDBANK  String*8  Bank Code  Mask: %-8N
IDRMIT  String*24  Check/Receipt No.  Mask: %-24C
DATEDEPST  Date  Deposit Date   
DEPSTNBR  BCD*5.0  Deposit Number   
CODECURNTC  String*3  Currency Code (Source)  Mask: %-3N
RATETYPETC  String*2  Rate Type (Source->Functional)  Mask: %-2N
RATEDATETC  Date  Rate Date (Source->Functional)   
RATEEXCHTC  BCD*8.7  Exchange Rate (Source->Functional)   
RATEOPTC  Integer  Rate Operator (Source->Functional)   
SWRATETC  Integer  Rate Override (Source)   
CODECURNBC  String*3  Currency Code (Bank)  Mask: %-3N
RATETYPEBC  String*2  Rate Type (Bank->Functional)  Mask: %-2N
RATEDATEBC  Date  Rate Date (Bank->Functional)   
RATEEXCHBC  BCD*8.7  Exchange Rate (Bank->Functional)   
RATEOPBC  Integer  Rate Operator (Bank->Functional)   
SWRATEBC  Integer  Rate Override (Bank)   
AMTINVCTC  BCD*10.3  Document Total Less Retainage (Source)   
SWJOB  Integer  Job Related   
SWRTG  Integer  Retainage Invoice Flag  List: 2 entries
0=No
1=Yes
RTGTERMS  String*6  Retainage Terms Code  Mask: %-6N
RTGDATEDUE  Date  Date Retainage Due   
SWRTGRATE  Integer  Retainage Exchange Rate   
RTGAPPLYTO  String*22  Original Doc. No.  Mask: %-22C
RTGAMTTC  BCD*10.3  Retainage Amount (Source)   
RTGAMTHC  BCD*10.3  Retainage Amount (Functional)   
VALUES  Long  Optional Fields   
NAMERMIT  String*60  Name on Check   
AMTTC  BCD*10.3  Customer Amount   
AMTHC  BCD*10.3  Functional Amount   
AMTBC  BCD*10.3  Bank Amount   
DEPSEQ  Long  Deposit Serial Number   
DEPLINE  Long  Deposit Line Number   
PAYMCODE  String*12  Payment Code  Mask: %-12N
PAYMTYPE  Integer  Payment Type  List: 5 entries
0=(None)
1=Cash
2=Check
3=Credit Card
4=Other
CCTYPE  String*12  C.C. Type  Mask: %-12N
TEXTREF  String*60  Reference   
DATEBUS  Date  Posting Date   
REVINVC  Integer  Reverse Invoice   

This page was generated on 2008-May-01

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