Field Listing for Table POSHEADER

Field:SALENUMBER Type: VARCHAR Length: 15
Field:SALESTATUS Type: VARCHAR Length: 20
Field:SALEDATE Type: DATE
Field:SALETIME Type: TIME
Field:COMPANYSITE Type: VARCHAR Length: 50
Field:OPERATORNAME Type: VARCHAR Length: 30
Field:STATIONID Type: VARCHAR Length: 3
Field:SALESPERSON Type: VARCHAR Length: 30
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:BILLINGCONTACT Type: VARCHAR Length: 100
Field:BILLINGPHONE Type: VARCHAR Length: 20
Field:BILLINGFAX Type: VARCHAR Length: 20
Field:BILLINGEMAIL Type: VARCHAR Length: 100
Field:DELIVERYCUSTOMER Type: VARCHAR Length: 50
Field:DELIVERYADDRESS1 Type: VARCHAR Length: 50
Field:DELIVERYADDRESS2 Type: VARCHAR Length: 50
Field:DELIVERYADDRESS3 Type: VARCHAR Length: 50
Field:DELIVERYPOSTALCODE Type: VARCHAR Length: 20
Field:DELIVERYSTATE Type: VARCHAR Length: 20
Field:DELIVERYCITY Type: VARCHAR Length: 30
Field:DELIVERYCOUNTRY Type: VARCHAR Length: 30
Field:DELIVERYCONTACT Type: VARCHAR Length: 100
Field:DELIVERYPHONE Type: VARCHAR Length: 20
Field:DELIVERYFAX Type: VARCHAR Length: 20
Field:DELIVERYEMAIL Type: VARCHAR Length: 100
Field:TAXGROUP Type: VARCHAR Length: 10
Field:PURCHASEREFERENCE Type: VARCHAR Length: 30
Field:CREDITTERM Type: VARCHAR Length: 20
Field:LINEDISCOUNTPERCENT Type: DOUBLE
Field:LINEDISCOUNTAMOUNT Type: DOUBLE
Field:SALENETTAMOUNT Type: DOUBLE
Field:SALETAXAMOUNT Type: DOUBLE
Field:SALETOTALAMOUNT Type: DOUBLE
Field:DELIVERYSTYLE Type: VARCHAR Length: 20
Field:ORDERTYPE Type: VARCHAR Length: 20
Field:SALENOTES Type: BLOB
Field:POSPAYMENTSTYLE Type: VARCHAR Length: 10
Field:POSPRINTSTYLE Type: VARCHAR Length: 20
Field:SALEROUNDINGAMOUNT Type: DOUBLE
Field:SALEDUEAMOUNT Type: DOUBLE
Field:SALERECEIVEDAMOUNT Type: DOUBLE
Field:SALECHANGEAMOUNT Type: DOUBLE
Field:APPLYCHANGETOACCOUNT Type: BOOLEAN
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:FIRSTDATE Type: DATE
Field:SECONDDATE Type: DATE
Field:THIRDDATE Type: DATE
Field:SALESMODE Type: VARCHAR Length: 10
Field:DELIVERYMODE Type: VARCHAR Length: 10
Field:POSREFERENCE Type: VARCHAR Length: 50
Field:RENTALPERIOD Type: DOUBLE
Field:RENTALUNIT Type: VARCHAR Length: 15
Field:SALEREMAININGAMOUNT Type: DOUBLE
Field:INVOICENOTES Type: BLOB
Field:INVOICENUMBER Type: VARCHAR Length: 15
Field:INTERNALNOTES Type: BLOB
Field:WORKFLOWSTATUS Type: VARCHAR Length: 20
Field:TRACKINGCOLOUR Type: INTEGER
Field:WORKFINISHED Type: BOOLEAN
Field:POSEODNUMBER Type: INTEGER
Field:ORDERSCRIPTRUN Type: BOOLEAN
Field:POSMESSAGE Type: VARCHAR Length: 200
Field:ORDERSTYLE Type: VARCHAR Length: 10
Field:QUOTATIONDATE Type: DATE
Field:CHARGEAMOUNT Type: DOUBLE
Field:CHARGEPERCENT Type: DOUBLE
Field:EXCLUDEFROMPRICINGMATRIX Type: BOOLEAN
Field:ORIGINALSALENUMBER Type: VARCHAR Length: 15
Field:ORDERNETTAMOUNT Type: DOUBLE
Field:ORDERTAXAMOUNT Type: DOUBLE
Field:ORDERTOTALAMOUNT Type: DOUBLE
Field:SUFFIXNUMBER Type: INTEGER
Field:LEADSOURCE Type: VARCHAR Length: 20
Field:FINANCIALCATEGORY Type: VARCHAR Length: 200
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