# GLTransactionLines: Exact Online General Ledger Transaction Lines
## Documentation:
Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- downloadidchr(13) || chr(10) || chr(13) || chr(10)- yearchr(13) || chr(10) || chr(13) || chr(10)- yearrange_fromchr(13) || chr(10) || chr(13) || chr(10)- yearrange_tochr(13) || chr(10) || chr(13) || chr(10)- period_fromchr(13) || chr(10) || chr(13) || chr(10)- period_tochr(13) || chr(10) || chr(13) || chr(10)- number_fromchr(13) || chr(10) || chr(13) || chr(10)- number_tochr(13) || chr(10) || chr(13) || chr(10)- journalchr(13) || chr(10) || chr(13) || chr(10)- entrydate_fromchr(13) || chr(10) || chr(13) || chr(10)- entrydate_tochr(13) || chr(10) || chr(13) || chr(10)- statuschr(13) || chr(10) || chr(13) || chr(10)- details (1 )chr(13) || chr(10) || chr(13) || chr(10)- documents (0 )
- Catalog: `ExactOnlineXML`
- Schema: `XML`
- Label: General Ledger Transaction Lines
The data in this table is partitioned per value of the `Division` column.
- Retrieve: True
- Insert: True
- Update: True
- Delete: False
- Filters on API Server: division
- downloadid
- year
- yearrange_from
- yearrange_to
- period_from
- period_to
- number_from
- number_to
- journal
- entrydate_from
- entrydate_to
- status
- details (1 )
- documents (0 )
## Table Columns
This table has too many columns to be included. Please enter the table name in Invantive Query Tool and press F4 (Describe) to get the column list.