| field name | data type | db field | description |
|---|
| tiJournal_ID | integer | Journal.Journal_ID | Record ID |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcJournalControl | character | Journal.JournalControl | A type of daybook control: Financial/Operational/External-used to clearly separate postings based on their source. |
| tcJournalDescription | character | Journal.JournalDescription | A brief description of the daybook. |
| api annotation: | | Value for this field defaults to null. |
| tlJournalIsActive | logical | Journal.JournalIsActive | Indicate if this is an active daybook. |
| api annotation: | | Value for this field defaults to false. |
| tlJournalIsProjectProvision | logical | Journal.JournalIsProjectProvision | Project Provision |
| tcJournalSecondDescription | character | Journal.JournalSecondDescription | Second Description |
| tcJournalTypeCode | character | Journal.JournalTypeCode | A daybook type code. |
| api annotation: | | Value for this field defaults to "Journal Entries". |
| tiLayer_ID | integer | Layer.Layer_ID | Record ID |
| tcLayerCode | character | Layer.LayerCode | Layer Code |
| tcLayerDescription | character | Layer.LayerDescription | Description |
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiSharedSet_ID | integer | Journal.SharedSet_ID | Link to SharedSet |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Journal),rowid(Layer) |
each Journal where