Field Listing for Table SALESHEADER

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:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:URGENTORDER Type: BOOLEAN
Field:CUSTOMERINVOICENAME Type: VARCHAR Length: 150
Field:CUSTOMERORDERNAME Type: VARCHAR Length: 150