| Field: | INVOICENUMBER | Type: | VARCHAR Length: 15 |
| Field: | INVOICESTATUS | Type: | VARCHAR Length: 20 |
| Field: | INVOICEDATE | Type: | DATE |
| Field: | INVOICETYPE | Type: | VARCHAR Length: 20 |
| Field: | INVOICEORCREDIT | Type: | VARCHAR Length: 10 |
| Field: | PRINTSTATUS | Type: | VARCHAR Length: 20 |
| Field: | NOTONSTATEMENT | Type: | BOOLEAN |
| Field: | CREDITTERM | Type: | VARCHAR Length: 20 |
| Field: | INVOICEDUEDATE | Type: | DATE |
| Field: | CHARGEFREIGHT | Type: | BOOLEAN |
| Field: | FREIGHTTAXABLE | Type: | BOOLEAN |
| Field: | FREIGHTTAXCODE | Type: | VARCHAR Length: 10 |
| Field: | FREIGHTINCLUDESTAX | Type: | BOOLEAN |
| Field: | FREIGHTNETTAMOUNT | Type: | DOUBLE |
| Field: | FREIGHTTAXAMOUNT | Type: | DOUBLE |
| Field: | FREIGHTTOTALAMOUNT | Type: | DOUBLE |
| Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
| Field: | CUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | BILLINGADDRESS1 | Type: | VARCHAR Length: 50 |
| Field: | BILLINGADDRESS2 | Type: | VARCHAR Length: 50 |
| Field: | BILLINGADDRESS3 | Type: | VARCHAR Length: 50 |
| Field: | BILLINGPOSTALCODE | Type: | VARCHAR Length: 20 |
| Field: | BILLINGSTATE | Type: | VARCHAR Length: 20 |
| Field: | BILLINGCITY | Type: | VARCHAR Length: 30 |
| Field: | BILLINGCOUNTRY | Type: | VARCHAR Length: 30 |
| Field: | BILLINGPHONE | Type: | VARCHAR Length: 20 |
| Field: | BILLINGFAX | Type: | VARCHAR Length: 20 |
| Field: | BILLINGEMAIL | Type: | VARCHAR Length: 100 |
| Field: | CREDITREASON | Type: | VARCHAR Length: 50 |
| Field: | TAXGROUP | Type: | VARCHAR Length: 10 |
| Field: | SALESPERSON | Type: | VARCHAR Length: 30 |
| Field: | SHIPPINGMETHOD | Type: | VARCHAR Length: 20 |
| Field: | LINEDISCOUNTPERCENT | Type: | DOUBLE |
| Field: | LINEDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | RETENTIONNETTAMOUNT | Type: | DOUBLE |
| Field: | RETENTIONTAXAMOUNT | Type: | DOUBLE |
| Field: | RETENTIONTOTALAMOUNT | Type: | DOUBLE |
| Field: | INVOICENETTAMOUNT | Type: | DOUBLE |
| Field: | INVOICEFREIGHTAMOUNT | Type: | DOUBLE |
| Field: | INVOICETAXAMOUNT | Type: | DOUBLE |
| Field: | INVOICETOTALAMOUNT | Type: | DOUBLE |
| Field: | AMOUNTPAID | Type: | DOUBLE |
| Field: | BALANCEDUE | Type: | DOUBLE |
| Field: | INVOICENOTES | Type: | BLOB |
| Field: | INVOICEREVERSED | Type: | BOOLEAN |
| Field: | BEENPRINTEDONSTATEMENT | Type: | BOOLEAN |
| Field: | LASTPAYMENTDATE | Type: | DATE |
| Field: | RETENTIONINVOICE | Type: | BOOLEAN |
| Field: | DIRECTPURCHASEREF | Type: | VARCHAR Length: 30 |
| Field: | ACCOUNTINGBASIS | Type: | VARCHAR Length: 25 |
| Field: | SITENAME | Type: | VARCHAR Length: 50 |
| Field: | PAYMENTDISCOUNTAPPLIES | Type: | BOOLEAN |
| Field: | PAYMENTDISCOUNTDATE | Type: | DATE |
| Field: | PAYMENTDISCOUNTPERCENT | Type: | DOUBLE |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
| Field: | CURRENCYCODE | Type: | VARCHAR Length: 3 |
| Field: | EXCHANGERATE | Type: | DOUBLE |
| Field: | LOCALRETENTIONNETTAMOUNT | Type: | DOUBLE |
| Field: | LOCALRETENTIONTAXAMOUNT | Type: | DOUBLE |
| Field: | LOCALRETENTIONTOTALAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICENETTAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICEFREIGHTAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICETAXAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICETOTALAMOUNT | Type: | DOUBLE |
| Field: | LOCALAMOUNTPAID | Type: | DOUBLE |
| Field: | LOCALBALANCEDUE | Type: | DOUBLE |
| Field: | SENDTOCUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | DIFFERENTSENDTOCUSTOMER | Type: | BOOLEAN |
| Field: | SENDTOBILLINGADDRESS1 | Type: | VARCHAR Length: 50 |
| Field: | SENDTOBILLINGADDRESS2 | Type: | VARCHAR Length: 50 |
| Field: | SENDTOBILLINGADDRESS3 | Type: | VARCHAR Length: 50 |
| Field: | SENDTOBILLINGPOSTALCODE | Type: | VARCHAR Length: 20 |
| Field: | SENDTOBILLINGSTATE | Type: | VARCHAR Length: 20 |
| Field: | SENDTOBILLINGCITY | Type: | VARCHAR Length: 30 |
| Field: | SENDTOBILLINGCOUNTRY | Type: | VARCHAR Length: 30 |
| Field: | SENDTOBILLINGPHONE | Type: | VARCHAR Length: 20 |
| Field: | SENDTOBILLINGFAX | Type: | VARCHAR Length: 20 |
| Field: | SENDTOBILLINGEMAIL | Type: | VARCHAR Length: 100 |
| Field: | SENDTOCUSTOMERINVOICENAME | Type: | VARCHAR Length: 50 |
| Field: | PROJECTNAME | Type: | VARCHAR Length: 30 |
| Field: | GROUPORDERNUMBERS | Type: | VARCHAR Length: 100 |
| Field: | TAXROUNDING | Type: | DOUBLE |
| Field: | CREATIONSOURCE | Type: | VARCHAR Length: 10 |
| Field: | EXCLUDEFROMPRICINGMATRIX | Type: | BOOLEAN |
| Field: | DELIVERYCUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | CURRENTDUECOLOUR | Type: | INTEGER |
| Field: | CREATEDFROMSERVICESHEET | Type: | BOOLEAN |
| Field: | SERVICESHEETID | Type: | VARCHAR Length: 30 |
| Field: | FINANCIALCATEGORY | Type: | VARCHAR Length: 200 |
| 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: | CUSTOMERINVOICENAME | Type: | VARCHAR Length: 150 |