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 |