View: Journal Headers

RotoID: GL0006
Table: GLJEH
Protocol: Header, Key auto generate
DLL:GLJEH

Compositions: 2

RotoID Tables Title DLL
GL0008 GLBCTL Batches GLBCTL
GL0010 GLJED Journal Details GLJED

Keys: 1

Title Fields
Batch / Entry BATCHID, BTCHENTRY

Fields: 159

Field Index Type Title Attributes Presentation
BATCHID 1 String*6 Batch Number E A K R  Mask: %06D
BTCHENTRY 2 String*5 Entry Number E A K R  Mask: %05D
ORIGCOMP 25 String*6 Originator A X  Mask: %-6N
SRCELEDGER 3 String*2 Source Ledger A R  Mask: %-2A
SRCETYPE 4 String*2 Source Type A R  Mask: %-2N
FSCSYR 5 String*4 Fiscal Year A  Mask: %04D
FSCSPERD 6 String*2 Fiscal Period A 
SWEDIT 7 Integer RESERVED Journal Edit
SWREVERSE 8 Integer Auto Reversal A  List:3 entries
0 = Auto Reversal Off
1 = Next Period
2 = Specific Period
JRNLDESC 9 String*60 Description A 
JRNLDR 10 BCD*10.3 Debits A C 
JRNLCR 11 BCD*10.3 Credits A C 
JRNLQTY 12 BCD*10.3 Quantity A C 
DATEENTRY 14 Date Posting Date A 
DRILSRCTY 15 Integer Drill Down Type A C 
DRILLDWNLK 16 BCD*10.0 Drill Down Link Number A C 
DRILAPP 17 String*2 Drill Down Application Source A C  Mask: %-2A
BALANCE 20 BCD*10.3 Out of Balance By A C 
REVYR 21 String*4 Specific Reversal Year A  Mask: %04D
REVPERD 22 String*2 Specific Reversal Period A 
ERRBATCH 23 Long Error Batch A C 
ERRENTRY 24 Long Error Entry A C 
DETAILCNT 26 BCD*4.0 Number of Details E A C 
PROCESSCMD 27 Integer Process switches A C  List:2 entries
2 = Refresh Source Ledger Field
3 = Create Tax Lines
ENTEREDBY 28 String*8 Entered By A C 
DOCDATE 29 Date Document Date A 
ORIGEXIST 40 Integer Orig Exists A C 
ORIGDESC 41 String*60 Orig Description A C 
ORIGSTAT 42 Integer Orig Status A C 
ORIGMCSW 43 Integer Orig Multicurrency Switch A C 
ORIGCURN 44 String*3 Orig Home Currency A C 
ORIGDEC 45 Integer Orig Home Currency Decimals A C 
ORIGQTYSW 46 Integer Orig Qty Switch A C 
ORIGQTYDEC 47 Integer Orig Qty Decimals A C 
SRCEXIST 55 Integer Source Code Exists A C 
SRCDESC 56 String*60 Source Code Description A C 
CODETAXGRP 57 String*12 Tax Group A  Mask: %-12N
CLASSTYPE 58 Integer Entry Type A  List:3 entries
0 = Standard
1 = Sales Tax
2 = Purchases Tax
SWMANTX 59 Integer Do Not Calc. Tax A  List:2 entries
0 = No
1 = Yes
CUSTVEND 60 String*12 Customer/Vendor Number A  Mask: %-12C
DOCTYPE 61 Integer Document Type A 
DOCNUMBER 62 String*22 Document Number A  Mask: %-22C
TAXAUTH1 63 String*12 Tax Authority 1 A C  Mask: %-12N
TAXAUTH2 64 String*12 Tax Authority 2 A C  Mask: %-12N
TAXAUTH3 65 String*12 Tax Authority 3 A C  Mask: %-12N
TAXAUTH4 66 String*12 Tax Authority 4 A C  Mask: %-12N
TAXAUTH5 67 String*12 Tax Authority 5 A C  Mask: %-12N
TAXVCLSS1 68 Integer Tax Vendor Class 1 A 
TAXVCLSS2 69 Integer Tax Vendor Class 2 A 
TAXVCLSS3 70 Integer Tax Vendor Class 3 A 
TAXVCLSS4 71 Integer Tax Vendor Class 4 A 
TAXVCLSS5 72 Integer Tax Vendor Class 5 A 
TAXICLSS1 73 Integer Tax Item Class 1 A 
TAXICLSS2 74 Integer Tax Item Class 2 A 
TAXICLSS3 75 Integer Tax Item Class 3 A 
TAXICLSS4 76 Integer Tax Item Class 4 A 
TAXICLSS5 77 Integer Tax Item Class 5 A 
BASETAX1 78 BCD*10.3 Tax Base Amount 1 A 
BASETAX2 79 BCD*10.3 Tax Base Amount 2 A 
BASETAX3 80 BCD*10.3 Tax Base Amount 3 A 
BASETAX4 81 BCD*10.3 Tax Base Amount 4 A 
BASETAX5 82 BCD*10.3 Tax Base Amount 5 A 
AMTTAX1 83 BCD*10.3 Tax Amount 1 A C 
AMTTAX2 84 BCD*10.3 Tax Amount 2 A C 
AMTTAX3 85 BCD*10.3 Tax Amount 3 A C 
AMTTAX4 86 BCD*10.3 Tax Amount 4 A C 
AMTTAX5 87 BCD*10.3 Tax Amount 5 A C 
AMTEXPENS1 88 BCD*10.3 Tax Expense Amount 1 A C 
AMTEXPENS2 89 BCD*10.3 Tax Expense Amount 2 A C 
AMTEXPENS3 90 BCD*10.3 Tax Expense Amount 3 A C 
AMTEXPENS4 91 BCD*10.3 Tax Expense Amount 4 A C 
AMTEXPENS5 92 BCD*10.3 Tax Expense Amount 5 A C 
AMTRECVRB1 93 BCD*10.3 Tax Recoverable Amount 1 A C 
AMTRECVRB2 94 BCD*10.3 Tax Recoverable Amount 2 A C 
AMTRECVRB3 95 BCD*10.3 Tax Recoverable Amount 3 A C 
AMTRECVRB4 96 BCD*10.3 Tax Recoverable Amount 4 A C 
AMTRECVRB5 97 BCD*10.3 Tax Recoverable Amount 5 A C 
AMTALLOC1 98 BCD*10.3 Tax Allocated Amount 1 A C 
AMTALLOC2 99 BCD*10.3 Tax Allocated Amount 2 A C 
AMTALLOC3 100 BCD*10.3 Tax Allocated Amount 3 A C 
AMTALLOC4 101 BCD*10.3 Tax Allocated Amount 4 A C 
AMTALLOC5 102 BCD*10.3 Tax Allocated Amount 5 A C 
TXAMT1RC 103 BCD*10.3 Tax Reporting Amount 1 A C 
TXAMT2RC 104 BCD*10.3 Tax Reporting Amount 2 A C 
TXAMT3RC 105 BCD*10.3 Tax Reporting Amount 3 A C 
TXAMT4RC 106 BCD*10.3 Tax Reporting Amount 4 A C 
TXAMT5RC 107 BCD*10.3 Tax Reporting Amount 5 A C 
TXEXPNS1RC 108 BCD*10.3 Tax Reporting Expensed 1 A C 
TXEXPNS2RC 109 BCD*10.3 Tax Reporting Expensed 2 A C 
TXEXPNS3RC 110 BCD*10.3 Tax Reporting Expensed 3 A C 
TXEXPNS4RC 111 BCD*10.3 Tax Reporting Expensed 4 A C 
TXEXPNS5RC 112 BCD*10.3 Tax Reporting Expensed 5 A C 
TXRECVB1RC 113 BCD*10.3 Tax Reporting Recoverable Amount 1 A C 
TXRECVB2RC 114 BCD*10.3 Tax Reporting Recoverable Amount 2 A C 
TXRECVB3RC 115 BCD*10.3 Tax Reporting Recoverable Amount 3 A C 
TXRECVB4RC 116 BCD*10.3 Tax Reporting Recoverable Amount 4 A C 
TXRECVB5RC 117 BCD*10.3 Tax Reporting Recoverable Amount 5 A C 
TXALLOC1RC 118 BCD*10.3 Tax Reporting Allocated Amount 1 A C 
TXALLOC2RC 119 BCD*10.3 Tax Reporting Allocated Amount 2 A C 
TXALLOC3RC 120 BCD*10.3 Tax Reporting Allocated Amount 3 A C 
TXALLOC4RC 121 BCD*10.3 Tax Reporting Allocated Amount 4 A C 
TXALLOC5RC 122 BCD*10.3 Tax Reporting Allocated Amount 5 A C 
CODECURNRC 123 String*3 Tax Reporting Currency Code A C  Mask: %-3N
RATERC 124 BCD*8.7 Tax Reporting Rate A 
RATETYPERC 125 String*2 Tax Reporting Rate Type A  Mask: %-2N
RATEDATERC 126 Date Tax Reporting Rate Date A 
RATEOPRC 127 Integer Tax Reporting Rate Operation A C  List:3 entries
0 = None
1 = Multiply
2 = Divide
EXPNSACNT1 128 String*45 Tax Expense Account 1 A C  Mask: %-45C
EXPNSACNT2 129 String*45 Tax Expense Account 2 A C  Mask: %-45C
EXPNSACNT3 130 String*45 Tax Expense Account 3 A C  Mask: %-45C
EXPNSACNT4 131 String*45 Tax Expense Account 4 A C  Mask: %-45C
EXPNSACNT5 132 String*45 Tax Expense Account 5 A C  Mask: %-45C
RECBLACNT1 133 String*45 Tax Recoverable Account 1 A C  Mask: %-45C
RECBLACNT2 134 String*45 Tax Recoverable Account 2 A C  Mask: %-45C
RECBLACNT3 135 String*45 Tax Recoverable Account 3 A C  Mask: %-45C
RECBLACNT4 136 String*45 Tax Recoverable Account 4 A C  Mask: %-45C
RECBLACNT5 137 String*45 Tax Recoverable Account 5 A C  Mask: %-45C
TAXRATE1 138 BCD*8.7 Tax Rate 1 A C 
TAXRATE2 139 BCD*8.7 Tax Rate 2 A C 
TAXRATE3 140 BCD*8.7 Tax Rate 3 A C 
TAXRATE4 141 BCD*8.7 Tax Rate 4 A C 
TAXRATE5 142 BCD*8.7 Tax Rate 5 A C 
FUNTXAMT1 143 BCD*10.3 Functional Tax Amount 1 A C 
FUNTXAMT2 144 BCD*10.3 Functional Tax Amount 2 A C 
FUNTXAMT3 145 BCD*10.3 Functional Tax Amount 3 A C 
FUNTXAMT4 146 BCD*10.3 Functional Tax Amount 4 A C 
FUNTXAMT5 147 BCD*10.3 Functional Tax Amount 5 A C 
FUNTXBSE1 148 BCD*10.3 Functional Tax Base Amount 1 A C 
FUNTXBSE2 149 BCD*10.3 Functional Tax Base Amount 2 A C 
FUNTXBSE3 150 BCD*10.3 Functional Tax Base Amount 3 A C 
FUNTXBSE4 151 BCD*10.3 Functional Tax Base Amount 4 A C 
FUNTXBSE5 152 BCD*10.3 Functional Tax Base Amount 5 A C 
FUNTXEXP1 153 BCD*10.3 Functional Expensed Amount 1 A C 
FUNTXEXP2 154 BCD*10.3 Functional Expensed Amount 2 A C 
FUNTXEXP3 155 BCD*10.3 Functional Expensed Amount 3 A C 
FUNTXEXP4 156 BCD*10.3 Functional Expensed Amount 4 A C 
FUNTXEXP5 157 BCD*10.3 Functional Expensed Amount 5 A C 
FUNTXRCB1 158 BCD*10.3 Functional Recoverable Amount 1 A C 
FUNTXRCB2 159 BCD*10.3 Functional Recoverable Amount 2 A C 
FUNTXRCB3 160 BCD*10.3 Functional Recoverable Amount 3 A C 
FUNTXRCB4 161 BCD*10.3 Functional Recoverable Amount 4 A C 
FUNTXRCB5 162 BCD*10.3 Functional Recoverable Amount 5 A C 
FUNTXALOC1 163 BCD*10.3 Functional Allocated Amount 1 A C 
FUNTXALOC2 164 BCD*10.3 Functional Allocated Amount 2 A C 
FUNTXALOC3 165 BCD*10.3 Functional Allocated Amount 3 A C 
FUNTXALOC4 166 BCD*10.3 Functional Allocated Amount 4 A C 
FUNTXALOC5 167 BCD*10.3 Functional Allocated Amount 5 A C 
AMTINVCTC 168 BCD*10.3 Invoice total in Tax Group Currency A 
AMTINVCHC 169 BCD*10.3 Invoice total in functional Currency A 
TXGRPDESC 170 String*60 Tax Group Description A C 
AUTH1DESC 171 String*60 Tax Authority Description 1 A C 
AUTH2DESC 172 String*60 Tax Authority Description 2 A C 
AUTH3DESC 173 String*60 Tax Authority Description 3 A C 
AUTH4DESC 174 String*60 Tax Authority Description 4 A C 
AUTH5DESC 175 String*60 Tax Authority Description 5 A C 
CODERCDESC 176 String*60 Tax Reporting Currency Code Description A C 
RTTYPEDESC 177 String*60 Rate Type Description A C 
CUSVENDESC 178 String*60 Customer/Vendor Name A C 
DOCTYPE2 179 Integer Document Type A C  List:3 entries
1 = Invoice
2 = Debit Note
3 = Credit Note

This page was generated on 2022-Aug-18

© 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).