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 |