View: Posting Journal Entries

RotoID: AP0511
Table: APPJH
Protocol: Flat
DLL:APPJH

Keys: 1

Title Fields

Batch Type/Post. Seq./Batch/Entr TYPEBTCHPOSTSEQNCECNTBTCHCNTITEM

Fields: 66

Field Index Type Title Attributes Presentation

TYPEBTCH 1 String*2 Batch Type E A K R  Mask: %-2N
POSTSEQNCE 2 BCD*5.0 Posting Sequence No. E A K R 
CNTBTCH 3 BCD*5.0 Batch No. E A K R 
CNTITEM 4 BCD*4.0 Entry No. E A K R 
IDVEND 5 String*12 Vendor No. E A  Mask: %-12C
IDINVC 6 String*22 Document No. E A  Mask: %-22C
CNTPAYM 7 BCD*3.0 Payment No. E A 
TRANSTYPE 8 Integer Document Type E A  List:8 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
10 = Prepayment
11 = Payment
14 = Adjustment
16 = Exchange Gain/Loss
TRXTYPE 9 Integer Transaction Type E A  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 10 String*6 Group Code E A  Mask: %-6N
IDACCTSET 11 String*6 Account Set E A  Mask: %-6N
CODETAXGRP 12 String*12 Tax Group E A  Mask: %-12N
CODETERM 13 String*6 Terms Code E A  Mask: %-6N
IDRMITTO 14 String*6 Remit-To Location Code E A  Mask: %-6N
DATEINVC 15 Date Document Date E A 
DATEDISC 16 Date Discount Date E A 
DATEDUE 17 Date Due Date E A 
DATEBTCH 18 Date Batch Date E A 
PCTDISC 19 BCD*5.5 Discount Percentage E A 
SWNONRCVBL 20 Integer Misc. Payment Flag E A 
SWSTATUS 21 Integer Payment Edited Flag E A  List:2 entries
0 = No
1 = Yes
GLBATCH 22 String*6 G/L Batch No. E A 
GLENTRY 23 String*5 G/L Entry No. E A 
CNTADJNBR 24 BCD*5.0 Adjustment Number E A 
FISCYR 25 String*4 Fiscal Year E A  Mask: %04D
FISCPER 26 String*2 Fiscal Period E A  Mask: %02D
IDINVCAPPL 27 String*22 Apply-To Doc. No. E A  Mask: %-22C
DESC 28 String*60 Description E A 
IDBANK 29 String*8 Bank Code E A  Mask: %-8N
IDRMIT 30 String*18 Check/Receipt No. E A  Mask: %-18D
LONGSERIAL 31 ??? Serial Number E A 
MISCRMITTO 32 String*60 Misc. Payment Remit-To E A 
CODECURNTC 33 String*3 Currency Code (Source) E A  Mask: %-3N
RATETYPETC 34 String*2 Rate Type (Source->Functional) E A  Mask: %-2N
RATEDATETC 35 Date Rate Date (Source->Functional) E A 
RATEEXCHTC 36 BCD*8.7 Exchange Rate (Source->Functional) E A 
RATEOPTC 37 Integer Rate Operator (Source->Functional) E A 
SWRATETC 38 Integer Rate Override (Source) E A 
CODECURNBC 39 String*3 Currency Code (Bank) E A  Mask: %-3N
RATETYPEBC 40 String*2 Rate Type (Bank->Functional) E A  Mask: %-2N
RATEDATEBC 41 Date Rate Date (Bank->Functional) E A 
RATEEXCHBC 42 BCD*8.7 Exchange Rate (Bank->Functional) E A 
RATEOPBC 43 Integer Rate Operator (Bank->Functional) E A 
SWRATEBC 44 Integer Rate Override (Bank) E A 
AMTINVCTC 45 BCD*10.3 Document Total Less Retainage (Source) E A 
SWJOB 46 Integer Job Related E A 
SWRTG 47 Integer Retainage Invoice Flag E A  List:2 entries
0 = No
1 = Yes
RTGTERMS 48 String*6 Retainage Terms Code E A  Mask: %-6N
RTGDATEDUE 49 Date Date Retainage Due E A 
SWRTGRATE 50 Integer Retainage Exchange Rate E A 
RTGAPPLYTO 51 String*22 Original Doc. No. E A  Mask: %-22C
RTGAMTTC 52 BCD*10.3 Retainage Amount (Source) E A 
RTGAMTHC 53 BCD*10.3 Retainage Amount (Functional) E A 
VALUES 54 Long Optional Fields E A 
ORIGCOMP 55 String*6 Originator E A  Mask: %-6N
IDDISTSET 56 String*6 Distribution Set E A  Mask: %-6N
AMTTC 57 BCD*10.3 Check Amount Vend. Curr. E A 
AMTHC 58 BCD*10.3 Check Amount Func. Curr. E A 
AMTBC 59 BCD*10.3 Payment Amount E A 
PAYMCODE 60 String*12 Payment Code E A  Mask: %-12N
PAYMTYPE 61 Integer Payment Type E A C  List:5 entries
0 =
1 = Cash
2 = Check
3 = Credit Card
4 = Other
TEXTREF 63 String*60 Reference E A 
DATEBUS 64 Date Posting Date E A 
REVINVC 65 Integer Reverse Invoice E A 
IDN 66 String*30 Import Declaration Number E A 
ENTEREDBY 67 String*8 Entered By E A