DB | Areas | X-idx | Tables | Sequences <- glr-genjrn glr-mainacct -> HtmlDict 11

qbfdecn.glr-jrnline

Journal Lines

Table details

Area FinData
Dumpname jrnline
Label Journal Lines
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
50 acct-cde X Account Code character x(4)
180 alloc-ind X Alloc Ind logical Yes/No NO
30 area-cde X Area Code character x(3)
40 cost-cde X Cost Code character x(4)
190 descr X Description character x(30)
90 doc-ln X Document Line integer >>9 0
80 doc-no X Document No character x(12)
110 emp-no X Employee No character x(8)
130 fin-mth X Fin Month integer 99 0
120 fin-year X Fin Year character 9999/9999
20 jrn-ln X Journal Line integer >>>>>9 0
10 jrn-no X Journal No character x(8)
60 jrn-type X Journal Type character x(2)
200 match-no X Match No character x(12)
170 post-ind X Post Ind logical Yes/No NO
100 ref-no X Ref No character x(12)
160 trn-amt X Trans Amount decimal-2 >>,>>>,>>9.99- 0
140 trn-date X Transaction date date 99/99/9999 ?
70 trn-type X Trans Type character x(3)
150 trn-units X Trans Units decimal-1 >>,>>9.9 0

Indexes

Index name Flags Fields Datatype
jrn-no P U jrn-no (+) character
    jrn-ln (+) integer
acct-cde acct-cde (+) character
area-cde area-cde (+) character
    cost-cde (+) character
doc-no doc-no (+) character
    doc-ln (+) integer
post-ind post-ind (+) logical
ref-no ref-no (+) character
trn-type trn-type (+) character
vendor-match ref-no (+) character
    match-no (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
acr-paytrnsfer   cbk-match   glr-costcent   glr-genjrn   glr-mainacct   sal-empben   sys-finmonth   sys-trntype  
Child tables
asr-trn   glr-std-jrnln  
generated 18-9-2026 10:02