Field Listing for Table JOURNALINVHEADER

Field:JOURNALNUMBER Type: INTEGER
Field:INVOICEDATE Type: DATE
Field:INVOICETYPE Type: VARCHAR Length: 20
Field:INVOICENUMBER Type: VARCHAR Length: 25
Field:COMPANYINVNUMBER Type: VARCHAR Length: 20
Field:INVOICEREFERENCE Type: VARCHAR Length: 100
Field:INVOICEDUEDATE Type: DATE
Field:COMPANYNAME Type: VARCHAR Length: 50
Field:TRANSACTIONSTATUS Type: VARCHAR Length: 20
Field:TRANSACTIONMESSAGE Type: VARCHAR Length: 300
Field:INVOICESELECTED Type: BOOLEAN
Field:BATCHFILENO Type: DOUBLE
Field:EXTERNALINVOICEID Type: VARCHAR Length: 100
Field:EXTERNALERROR Type: BLOB
Field:LEDGERCODESMISSING Type: BOOLEAN
Field:CREDITTERM Type: VARCHAR Length: 20
Field:EXTERNALCREDITTERM Type: VARCHAR Length: 20
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:EXCHANGERATE Type: DOUBLE
Field:INVOICENETTTOTAL Type: DOUBLE
Field:INVOICETAXTOTAL Type: DOUBLE
Field:INVOICETOTAL Type: DOUBLE
Field:APPLYTOINVOICE Type: BOOLEAN
Field:APPLYTOINVOICENUMBER Type: VARCHAR Length: 15
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:RETRYCOUNT Type: INTEGER