Table: Journal Headers

Table: GLJEH
View: GL0006
Record Length: 1557

Flags: A R 

Keys: 1

Title Flags Fields
Batch / Entry BATCHID, BTCHENTRY

Fields: 141

Field Type Title Presentation
BATCHID String*6 Batch Number Mask: %06D
BTCHENTRY String*5 Entry Number Mask: %05D
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
SRCELEDGER String*2 Source Ledger Mask: %-2A
SRCETYPE String*2 Source Type Mask: %-2N
FSCSYR String*4 Fiscal Year Mask: %04D
FSCSPERD String*2 Fiscal Period
SWEDIT Integer RESERVED Journal Edit
SWREVERSE Integer Auto Reversal List:3 entries
0 = Auto Reversal Off
1 = Next Period
2 = Specific Period
JRNLDESC String*60 Description
JRNLDR BCD*10.3 Debits
JRNLCR BCD*10.3 Credits
JRNLQTY BCD*10.3 Quantity
DATEENTRY Date Posting Date
DRILSRCTY Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
DRILAPP String*2 Drill Down Application Source Mask: %-2A
REVYR String*4 Specific Reversal Year Mask: %04D
REVPERD String*2 Specific Reversal Period
ERRBATCH Long Error Batch
ERRENTRY Long Error Entry
ORIGCOMP String*6 Originator Mask: %-6N
DETAILCNT BCD*4.0 Number of Details
ENTEREDBY String*8 Entered By
DOCDATE Date Document Date
CODETAXGRP String*12 Tax Group Mask: %-12N
CLASSTYPE Integer Entry Type List:3 entries
0 = Standard
1 = Sales Tax
2 = Purchases Tax
SWMANTX Integer Do Not Calc. Tax List:2 entries
0 = No
1 = Yes
CUSTVEND String*12 Customer/Vendor Number Mask: %-12C
DOCTYPE Integer Document Type
DOCNUMBER String*22 Document Number Mask: %-22C
TAXAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAXAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAXAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAXAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAXAUTH5 String*12 Tax Authority 5 Mask: %-12N
TAXVCLSS1 Integer Tax Vendor Class 1
TAXVCLSS2 Integer Tax Vendor Class 2
TAXVCLSS3 Integer Tax Vendor Class 3
TAXVCLSS4 Integer Tax Vendor Class 4
TAXVCLSS5 Integer Tax Vendor Class 5
TAXICLSS1 Integer Tax Item Class 1
TAXICLSS2 Integer Tax Item Class 2
TAXICLSS3 Integer Tax Item Class 3
TAXICLSS4 Integer Tax Item Class 4
TAXICLSS5 Integer Tax Item Class 5
BASETAX1 BCD*10.3 Tax Base Amount 1
BASETAX2 BCD*10.3 Tax Base Amount 2
BASETAX3 BCD*10.3 Tax Base Amount 3
BASETAX4 BCD*10.3 Tax Base Amount 4
BASETAX5 BCD*10.3 Tax Base Amount 5
AMTTAX1 BCD*10.3 Tax Amount 1
AMTTAX2 BCD*10.3 Tax Amount 2
AMTTAX3 BCD*10.3 Tax Amount 3
AMTTAX4 BCD*10.3 Tax Amount 4
AMTTAX5 BCD*10.3 Tax Amount 5
AMTEXPENS1 BCD*10.3 Tax Expense Amount 1
AMTEXPENS2 BCD*10.3 Tax Expense Amount 2
AMTEXPENS3 BCD*10.3 Tax Expense Amount 3
AMTEXPENS4 BCD*10.3 Tax Expense Amount 4
AMTEXPENS5 BCD*10.3 Tax Expense Amount 5
AMTRECVRB1 BCD*10.3 Tax Recoverable Amount 1
AMTRECVRB2 BCD*10.3 Tax Recoverable Amount 2
AMTRECVRB3 BCD*10.3 Tax Recoverable Amount 3
AMTRECVRB4 BCD*10.3 Tax Recoverable Amount 4
AMTRECVRB5 BCD*10.3 Tax Recoverable Amount 5
AMTALLOC1 BCD*10.3 Tax Allocated Amount 1
AMTALLOC2 BCD*10.3 Tax Allocated Amount 2
AMTALLOC3 BCD*10.3 Tax Allocated Amount 3
AMTALLOC4 BCD*10.3 Tax Allocated Amount 4
AMTALLOC5 BCD*10.3 Tax Allocated Amount 5
TXAMT1RC BCD*10.3 Tax Reporting Amount 1
TXAMT2RC BCD*10.3 Tax Reporting Amount 2
TXAMT3RC BCD*10.3 Tax Reporting Amount 3
TXAMT4RC BCD*10.3 Tax Reporting Amount 4
TXAMT5RC BCD*10.3 Tax Reporting Amount 5
TXEXPNS1RC BCD*10.3 Tax Reporting Expensed 1
TXEXPNS2RC BCD*10.3 Tax Reporting Expensed 2
TXEXPNS3RC BCD*10.3 Tax Reporting Expensed 3
TXEXPNS4RC BCD*10.3 Tax Reporting Expensed 4
TXEXPNS5RC BCD*10.3 Tax Reporting Expensed 5
TXRECVB1RC BCD*10.3 Tax Reporting Recoverable Amount 1
TXRECVB2RC BCD*10.3 Tax Reporting Recoverable Amount 2
TXRECVB3RC BCD*10.3 Tax Reporting Recoverable Amount 3
TXRECVB4RC BCD*10.3 Tax Reporting Recoverable Amount 4
TXRECVB5RC BCD*10.3 Tax Reporting Recoverable Amount 5
TXALLOC1RC BCD*10.3 Tax Reporting Allocated Amount 1
TXALLOC2RC BCD*10.3 Tax Reporting Allocated Amount 2
TXALLOC3RC BCD*10.3 Tax Reporting Allocated Amount 3
TXALLOC4RC BCD*10.3 Tax Reporting Allocated Amount 4
TXALLOC5RC BCD*10.3 Tax Reporting Allocated Amount 5
CODECURNRC String*3 Tax Reporting Currency Code Mask: %-3N
RATERC BCD*8.7 Tax Reporting Rate
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEDATERC Date Tax Reporting Rate Date
RATEOPRC Integer Tax Reporting Rate Operation List:3 entries
0 = None
1 = Multiply
2 = Divide
EXPNSACNT1 String*45 Tax Expense Account 1 Mask: %-45C
EXPNSACNT2 String*45 Tax Expense Account 2 Mask: %-45C
EXPNSACNT3 String*45 Tax Expense Account 3 Mask: %-45C
EXPNSACNT4 String*45 Tax Expense Account 4 Mask: %-45C
EXPNSACNT5 String*45 Tax Expense Account 5 Mask: %-45C
RECBLACNT1 String*45 Tax Recoverable Account 1 Mask: %-45C
RECBLACNT2 String*45 Tax Recoverable Account 2 Mask: %-45C
RECBLACNT3 String*45 Tax Recoverable Account 3 Mask: %-45C
RECBLACNT4 String*45 Tax Recoverable Account 4 Mask: %-45C
RECBLACNT5 String*45 Tax Recoverable Account 5 Mask: %-45C
TAXRATE1 BCD*8.7 Tax Rate 1
TAXRATE2 BCD*8.7 Tax Rate 2
TAXRATE3 BCD*8.7 Tax Rate 3
TAXRATE4 BCD*8.7 Tax Rate 4
TAXRATE5 BCD*8.7 Tax Rate 5
FUNTXAMT1 BCD*10.3 Functional Tax Amount 1
FUNTXAMT2 BCD*10.3 Functional Tax Amount 2
FUNTXAMT3 BCD*10.3 Functional Tax Amount 3
FUNTXAMT4 BCD*10.3 Functional Tax Amount 4
FUNTXAMT5 BCD*10.3 Functional Tax Amount 5
FUNTXBSE1 BCD*10.3 Functional Tax Base Amount 1
FUNTXBSE2 BCD*10.3 Functional Tax Base Amount 2
FUNTXBSE3 BCD*10.3 Functional Tax Base Amount 3
FUNTXBSE4 BCD*10.3 Functional Tax Base Amount 4
FUNTXBSE5 BCD*10.3 Functional Tax Base Amount 5
FUNTXEXP1 BCD*10.3 Functional Expensed Amount 1
FUNTXEXP2 BCD*10.3 Functional Expensed Amount 2
FUNTXEXP3 BCD*10.3 Functional Expensed Amount 3
FUNTXEXP4 BCD*10.3 Functional Expensed Amount 4
FUNTXEXP5 BCD*10.3 Functional Expensed Amount 5
FUNTXRCB1 BCD*10.3 Functional Recoverable Amount 1
FUNTXRCB2 BCD*10.3 Functional Recoverable Amount 2
FUNTXRCB3 BCD*10.3 Functional Recoverable Amount 3
FUNTXRCB4 BCD*10.3 Functional Recoverable Amount 4
FUNTXRCB5 BCD*10.3 Functional Recoverable Amount 5
FUNTXALOC1 BCD*10.3 Functional Allocated Amount 1
FUNTXALOC2 BCD*10.3 Functional Allocated Amount 2
FUNTXALOC3 BCD*10.3 Functional Allocated Amount 3
FUNTXALOC4 BCD*10.3 Functional Allocated Amount 4
FUNTXALOC5 BCD*10.3 Functional Allocated Amount 5
AMTINVCTC BCD*10.3 Invoice total in Tax Group Currency
AMTINVCHC BCD*10.3 Invoice total in functional Currency

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).