| Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ORDERDATE | Type: | DATE |
| Field: | REQUIREDDATE | Type: | DATE |
| Field: | ORDERDESCRIPTION | Type: | VARCHAR Length: 100 |
| Field: | ORDERTYPE | Type: | VARCHAR Length: 20 |
| Field: | ORDERSTYLE | Type: | VARCHAR Length: 20 |
| Field: | PRINTSTATUS | Type: | VARCHAR Length: 20 |
| Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
| Field: | TRACKINGCOLOUR | Type: | INTEGER |
| Field: | CUSTOMER | Type: | VARCHAR Length: 50 |
| Field: | ORDERADDRESS1 | Type: | VARCHAR Length: 50 |
| Field: | ORDERADDRESS2 | Type: | VARCHAR Length: 50 |
| Field: | ORDERADDRESS3 | Type: | VARCHAR Length: 50 |
| Field: | ORDERPOSTALCODE | Type: | VARCHAR Length: 20 |
| Field: | ORDERSTATE | Type: | VARCHAR Length: 20 |
| Field: | ORDERCITY | Type: | VARCHAR Length: 30 |
| Field: | ORDERCOUNTRY | Type: | VARCHAR Length: 30 |
| Field: | ORDERCONTACT | Type: | VARCHAR Length: 100 |
| Field: | ORDERPHONE | Type: | VARCHAR Length: 20 |
| Field: | ORDERFAX | Type: | VARCHAR Length: 20 |
| Field: | ORDERMOBILE | Type: | VARCHAR Length: 20 |
| Field: | ORDEREMAIL | Type: | VARCHAR Length: 100 |
| Field: | BILLINGCUSTOMER | 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: | TAXGROUP | Type: | VARCHAR Length: 10 |
| Field: | SALESPERSON | Type: | VARCHAR Length: 30 |
| Field: | SHIPPINGMETHOD | Type: | VARCHAR Length: 20 |
| Field: | PURCHASEREFERENCE | Type: | VARCHAR Length: 30 |
| Field: | CREDITTERM | Type: | VARCHAR Length: 20 |
| 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: | LINEDISCOUNTPERCENT | Type: | DOUBLE |
| Field: | LINEDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | ORIGINALORDERAMOUNT | Type: | DOUBLE |
| Field: | ORIGINALTAXAMOUNTNOFREIGHT | Type: | DOUBLE |
| Field: | ORIGINALTOTALAMOUNTNOFREIGHT | Type: | DOUBLE |
| Field: | ORIGINALTAXAMOUNT | Type: | DOUBLE |
| Field: | ORIGINALTOTALAMOUNT | Type: | DOUBLE |
| Field: | INVOICEDNETTAMOUNT | Type: | DOUBLE |
| Field: | INVOICEDFREIGHTAMOUNT | Type: | DOUBLE |
| Field: | INVOICEDTAXAMOUNT | Type: | DOUBLE |
| Field: | INVOICEDTOTALAMOUNT | Type: | DOUBLE |
| Field: | ORDERNOTES | Type: | BLOB |
| Field: | INVOICENOTES | Type: | BLOB |
| Field: | QUOTEPRINTSTATUS | Type: | VARCHAR Length: 20 |
| Field: | QUOTEEXPIRY | Type: | DATE |
| Field: | QUOTELOSTREASON | Type: | VARCHAR Length: 20 |
| Field: | INVOICEPENDING | Type: | BOOLEAN |
| Field: | ORIGINATIONSOURCE | Type: | VARCHAR Length: 10 |
| 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: | CALLTICKETID | Type: | INTEGER |
| Field: | SUPPLYPURCHASESDIRECT | Type: | BOOLEAN |
| Field: | QUOTEHEADERNOTES | Type: | BLOB |
| Field: | QUOTEFOOTERNOTES | Type: | BLOB |
| Field: | QUOTESINGLELINEDESCRIPTION | Type: | VARCHAR Length: 200 |
| Field: | QUOTEPRINTSTYLE | Type: | VARCHAR Length: 10 |
| Field: | QUOTEPRINTLINES | Type: | VARCHAR Length: 20 |
| Field: | SITENAME | Type: | VARCHAR Length: 50 |
| Field: | RENTALORDER | Type: | BOOLEAN |
| Field: | RENTALSTARTDATE | Type: | DATE |
| Field: | RENTALRETURNDATE | Type: | DATE |
| Field: | RENTALITEMSISSUED | Type: | BOOLEAN |
| Field: | RENTALITEMSRETURNED | Type: | BOOLEAN |
| Field: | QUOTECONVERTDATE | Type: | DATE |
| Field: | ORDERSCRIPTRUN | Type: | BOOLEAN |
| Field: | STATUSCOLOUR | Type: | INTEGER |
| Field: | ORDERPRIORITY | Type: | BOOLEAN |
| Field: | FULLDELIVERYONLY | Type: | BOOLEAN |
| Field: | OVERRIDEPRICELEVELS | Type: | BOOLEAN |
| Field: | PRICELEVEL | Type: | VARCHAR Length: 20 |
| Field: | CURRENCYCODE | Type: | VARCHAR Length: 3 |
| Field: | EXCHANGERATE | Type: | DOUBLE |
| Field: | LOCALFREIGHTNETTAMOUNT | Type: | DOUBLE |
| Field: | LOCALFREIGHTTAXAMOUNT | Type: | DOUBLE |
| Field: | LOCALFREIGHTTOTALAMOUNT | Type: | DOUBLE |
| Field: | LOCALLINEDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | LOCALORIGINALORDERAMOUNT | Type: | DOUBLE |
| Field: | LOCALORIGTAXAMOUNTNOFREIGHT | Type: | DOUBLE |
| Field: | LOCALORIGTOTALAMOUNTNOFREIGHT | Type: | DOUBLE |
| Field: | LOCALORIGTAXAMOUNT | Type: | DOUBLE |
| Field: | LOCALORIGTOTALAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICEDNETTAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICEDFREIGHTAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICEDTAXAMOUNT | Type: | DOUBLE |
| Field: | LOCALINVOICEDTOTALAMOUNT | Type: | DOUBLE |
| Field: | OVERRIDELOCATIONS | Type: | BOOLEAN |
| Field: | DEFAULTISSUEWAREHOUSE | Type: | VARCHAR Length: 20 |
| Field: | DEFAULTISSUELOCATION | Type: | VARCHAR Length: 20 |
| Field: | ORIGINALQUOTEDATE | Type: | DATE |
| Field: | TOTALDEPOSITAMOUNT | Type: | DOUBLE |
| Field: | UNAPPLIEDDEPOSITAMOUNT | Type: | DOUBLE |
| Field: | ONESTEPPICKSTYLE | Type: | VARCHAR Length: 30 |
| Field: | AUTOAPPLYDEPOSIT | Type: | BOOLEAN |
| Field: | PLANNINGNOTE | Type: | VARCHAR Length: 200 |
| Field: | ONESTEPINVOICEDATE | Type: | VARCHAR Length: 20 |
| Field: | EXCLUDEFROMPRICINGMATRIX | Type: | BOOLEAN |
| Field: | CURRENTDUECOLOUR | Type: | INTEGER |
| Field: | XMLSENT | Type: | BOOLEAN |
| Field: | READINESSSTATUS | Type: | VARCHAR Length: 20 |
| Field: | QUOTEFOLLOWUPREQUIRED | Type: | BOOLEAN |
| Field: | QUOTEFOLLOWUPACTIONED | Type: | BOOLEAN |
| Field: | QUOTEFOLLOWUPREQDATE | Type: | DATE |
| Field: | QUOTEFOLLOWUPACTDATE | Type: | DATE |
| Field: | QUOTEFOLLOWUPEMAILED | Type: | BOOLEAN |
| Field: | QUOTEREVISIONNO | Type: | INTEGER |
| Field: | QUOTEPARENTNUMBER | Type: | VARCHAR Length: 15 |
| Field: | QUOTEREVISIONSTATUS | Type: | VARCHAR Length: 20 |
| Field: | QUOTEREVISONDATE | Type: | DATE |
| Field: | QUOTEREVISIONCOPY | Type: | BOOLEAN |
| Field: | QUOTESTATUS | Type: | VARCHAR Length: 30 |
| Field: | ONHOLDREASON | Type: | VARCHAR Length: 100 |
| Field: | LEADSOURCE | Type: | VARCHAR Length: 20 |
| Field: | FINANCIALCATEGORY | Type: | VARCHAR Length: 200 |
| Field: | SERVICEZONE | Type: | VARCHAR Length: 30 |
| Field: | ONDEMANDSUPPLYSTATUS | Type: | VARCHAR Length: 30 |
| Field: | CREATEDFROMSERVICESHEET | Type: | BOOLEAN |
| Field: | SERVICESHEETID | Type: | VARCHAR Length: 30 |
| Field: | CUSTOMERINVOICENAME | Type: | VARCHAR Length: 150 |
| Field: | CUSTOMERORDERNAME | Type: | VARCHAR Length: 150 |
| Field: | JOBORDERNUMBER | Type: | VARCHAR Length: 20 |
| Field: | JOBTASKNAME | Type: | VARCHAR Length: 20 |
| Field: | URGENTORDER | Type: | BOOLEAN |
| 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: | ADDITIONALFIELD_9 | Type: | VARCHAR Length: 100 |