Table: Posting Journal Entries

Table: APPJH
View: AP0511
Record length: 586
Flags: A R 

Keys: 1

Title  Flags  Fields

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

Fields: 69

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     
IDVEND  String*12  Vendor No.  Mask: %-12C
IDINVC  String*22  Document No.  Mask: %-22C
CNTPAYM  BCD*3.0  Payment No.   
TRANSTYPE  Integer  Document Type  List: 8 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
10=Prepayment
11=Payment
14=Adjustment
16=Exchange Gain/Loss
TRXTYPE  Integer  Transaction Type  List: 16 entries
12=Invoice - Summary Entered
13=Invoice - Recurring Charge
22=Debit Note - Summary Entered
32=Credit Note - Summary Entered
40=Interest Charge
81=Adjustment - Posted
57=Prepayment - Posted
58=Prepayment - Applied
43=Credit Note Applied To
44=Applied Credit Note
51=Payment - Posted
52=Payment - Applied
53=Payment - Reversed
69=Unrealized Exchange Gain/Loss
65=Exchange Gain/Loss - Posted
94=Payment - 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
IDRMITTO  String*6  Remit-To Location Code  Mask: %-6N
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. Payment Flag   
SWSTATUS  Integer  Payment Edited Flag  List: 2 entries
0=No
1=Yes
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*12  Check/Receipt No.  Mask: %-12D
LONGSERIAL  Long  Serial Number   
MISCRMITTO  String*60  Misc. Payment Remit-To   
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   
ORIGCOMP  String*6  Originator  Mask: %-6N
IDDISTSET  String*6  Distribution Set  Mask: %-6N
AMTTC  BCD*10.3  Check Amount Vend. Curr.   
AMTHC  BCD*10.3  Check Amount Func. Curr.   
AMTBC  BCD*10.3  Payment Amount   
PAYMCODE  String*12  Payment Code  Mask: %-12N
PAYMTYPE  Integer  Payment Type  List: 5 entries
0=
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.