Field Listing for Table JOURNALHEADER

Field:JOURNALNUMBER Type: INTEGER
Field:JOURNALDESCRIPTION Type: VARCHAR Length: 500
Field:JOURNALDATE Type: DATE
Field:JOURNALTYPE Type: VARCHAR Length: 50
Field:DEBITVALUE Type: DOUBLE
Field:DEBITTAXVALUE Type: DOUBLE
Field:CREDITVALUE Type: DOUBLE
Field:CREDITTAXVALUE Type: DOUBLE
Field:TRANSACTIONSTATUS Type: VARCHAR Length: 20
Field:TRANSACTIONMESSAGE Type: VARCHAR Length: 300
Field:JOURNALSELECTED Type: BOOLEAN
Field:JOURNALID Type: VARCHAR Length: 50
Field:BATCHFILENO Type: DOUBLE
Field:EXTERNALJOURNALID Type: VARCHAR Length: 100
Field:EXTERNALERROR Type: BLOB
Field:OUTOFBALANCE Type: BOOLEAN
Field:LEDGERCODESMISSING Type: BOOLEAN
Field:RETRYCOUNT Type: INTEGER
Field:REFERENCENUMBER Type: VARCHAR Length: 50
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30