GL10001 - Transaction Work Line Detail
Stores line-level detail for unposted GL journal entries. Each line represents a debit or credit distribution.
SQL Query Builder
38 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| BACHNUMB | char(15) '' | ||||
| JRNENTRY | int 0 | ||||
| SQNCLINE | numeric(19,5) 0.00 | ||||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | |||
| XCHGRATE | numeric(19,7) 0.00 | ||||
| DSCRIPTN | char(31) '' | ||||
| GLLINMSG | binary(4) 0 | ||||
| GLLINMS2 | binary(4) 0 | ||||
| CURRNIDX | smallint 0 | ||||
| GLLINVAL | binary(4) 0 | ||||
| ACCTTYPE | smallint 0 | ||||
Account Type values (4) 1 = Posting Account2 = Unit Account3 = Posting Allocation Account4 = Unit Allocation Account | |||||
| FXDORVAR | smallint 0 | ||||
Fixed or Variable Allocation values (2) 1 = Fixed Allocation2 = Variable Allocation | |||||
| BALFRCLC | smallint 0 | ||||
| PSTNGTYP | smallint 0 | ||||
Posting Type values (2) 0 = Balance Sheet1 = Profit and Loss | |||||
| DECPLACS | smallint 0 | ||||
| ORCTRNUM | char(21) '' | ||||
| ORDOCNUM | char(21) '' | ||||
| ORMSTRID | char(31) '' | ||||
| ORMSTRNM | char(65) '' | ||||
| ORTRXTYP | smallint 0 | ||||
| OrigSeqNum | int 0 | ||||
| ORTRXDESC | char(31) '' | ||||
| DTA_GL_Status | smallint 0 | ||||
| INTERID | char(5) '' | ||||
| RATETPID | char(15) '' | ||||
| EXGTBLID | char(15) '' | ||||
| EXCHDATE | datetime '1/1/1900' | ||||
| TIME1 | datetime '1/1/1900' | ||||
| RTCLCMTD | smallint 0 | ||||
| CRDTAMNT | numeric(19,5) 0.00 | ||||
| DEBITAMT | numeric(19,5) 0.00 | ||||
| ORCRDAMT | numeric(19,5) 0.00 | ||||
| ORDBTAMT | numeric(19,5) 0.00 | ||||
| DENXRATE | numeric(19,7) 0.00 | ||||
| MCTRXSTT | smallint 0 | ||||
| LNESTAT | smallint 0 | ||||
| CorrespondingUnit | char(5) '' | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Reporting Tips
- - Join to GL10000 on JRNENTRY for the batch/header info
- - DEBITAMT and CRDTAMNT contain the amounts
Related Tables
Tables that share columns with GL10001. Click "Join" to add to your query.