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 |