Table: Posting Journal Entries

Table: APPJH
View: AP0511
Record Length: 622

Flags: A R 

Keys: 1

Title Flags Fields

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

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
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*18 Check/Receipt No. Mask: %-18D
LONGSERIAL ??? 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
TEXTREF String*60 Reference
DATEBUS Date Posting Date
REVINVC Integer Reverse Invoice
IDN String*30 Import Declaration Number
ENTEREDBY String*8 Entered By