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 |