View: Posting Journal Entries

RotoID: AR0408
Table: ARPJH
Protocol: Flat
DLL:ARPJH

Keys: 1

Title Fields

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

Fields: 67

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 
IDCUST 5 String*12 Customer 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: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 9 Integer Transaction Type E A  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 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
IDBILLCYC 14 String*6 Billing Cycle E A  Mask: %-6N
IDCUSTSHP 15 String*6 Ship-To Location Code E A  Mask: %-6C
DATEINVC 16 Date Document Date E A 
DATEDISC 17 Date Discount Date E A 
DATEDUE 18 Date Due Date E A 
DATEBTCH 19 Date Batch Date E A 
PCTDISC 20 BCD*5.5 Discount Percentage E A 
SWNONRCVBL 21 Integer Misc. Receipt Flag E A 
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*24 Check/Receipt No. E A  Mask: %-24C
DATEDEPST 31 Date Deposit Date E A 
DEPSTNBR 32 BCD*8.0 Deposit Number 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 
NAMERMIT 55 String*60 Name on Check E A 
AMTTC 56 BCD*10.3 Customer Amount E A 
AMTHC 57 BCD*10.3 Functional Amount E A 
AMTBC 58 BCD*10.3 Bank Amount E A 
DEPSEQ 59 ??? Deposit Serial Number E A 
DEPLINE 60 Long Deposit Line Number E A 
PAYMCODE 61 String*12 Payment Code E A  Mask: %-12N
PAYMTYPE 62 Integer Payment Type E A P  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
5 = SPS Credit Card
4 = Other
TEXTREF 64 String*60 Reference E A 
DATEBUS 65 Date Posting Date E A 
REVINVC 66 Integer Reverse Invoice E A 
ENTEREDBY 67 String*8 Entered By E A 
EDN 68 String*30 Export Declaration Number E A