Table: Journal Details

Table: GLJED
View: GL0010
Record Length: 315

Flags: A R 

Keys: 1

Title Flags Fields

Batch / Entry / Transaction BATCHNBRJOURNALIDTRANSNBR

Fields: 31

Field Type Title Presentation

BATCHNBR String*6 Batch Number Mask: %06D
JOURNALID String*5 Entry Number Mask: %05D
TRANSNBR String*10 Transaction Number Mask: %C%09D
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
ACCTID String*45 Account Number Mask: %-45C
COMPANYID String*8 Company ID
TRANSAMT BCD*10.3 Amount
TRANSQTY BCD*10.3 Quantity
SCURNDEC String*1 Source Currency Decimals
SCURNAMT BCD*10.3 Source Currency Amount
HCURNCODE String*3 Home Currency Mask: %-3N
RATETYPE String*2 Currency Rate Table Mask: %-2N
SCURNCODE String*3 Source Currency Mask: %-3N
RATEDATE Date Currency Rate Date
CONVRATE BCD*8.7 Currency Rate
RATESPREAD BCD*8.7 Currency Rate Spread
DATEMTCHCD String*1 Currency Rate Date Matching
RATEOPER String*1 Currency Rate Operator
TRANSDESC String*60 Description
TRANSREF String*60 Reference
TRANSDATE Date Journal Date
SRCELDGR String*2 Source Ledger Mask: %-2A
SRCETYPE String*2 Source Type Mask: %-2N
VALUES Long Optional Fields
DESCOMP String*6 Destination Mask: %-6N
ROUTE Integer Route No.
TAXAUTH String*12 Tax Authority
TXACCTTYPE Integer Tax Account Type