Field Listing for Table JOBISSUES

Field:ISSUEBATCHNO Type: INTEGER
Field:ISSUESTATUS Type: VARCHAR Length: 20
Field:ISSUEREFERENCE Type: VARCHAR Length: 50
Field:ISSUEDATE Type: DATE
Field:ISSUESTYLE Type: VARCHAR Length: 10
Field:APPROVALSTATUS Type: VARCHAR Length: 20
Field:APPROVALDATE Type: DATE
Field:APPROVALUSERNAME Type: VARCHAR Length: 30
Field:ISSUENOTES Type: BLOB
Field:OVERRIDEDEFAULTLOCATION Type: BOOLEAN
Field:DEFAULTWAREHOUSE Type: VARCHAR Length: 20
Field:DEFAULTLOCATION Type: VARCHAR Length: 20
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:SHIPPINGMETHOD Type: VARCHAR Length: 20
Field:SHIPPINGREFERENCE Type: VARCHAR Length: 30
Field:WORKFLOWSTATUS Type: VARCHAR Length: 20
Field:TRACKINGCOLOUR Type: INTEGER
Field:CALCULATEDWEIGHT Type: DOUBLE
Field:CALCULATEDVOLUME Type: DOUBLE
Field:PICKEDWEIGHT Type: DOUBLE
Field:PICKEDVOLUME Type: DOUBLE
Field:ACTUALWEIGHT Type: DOUBLE
Field:ACTUALVOLUME Type: DOUBLE
Field:CUSTOMERORSUPPLIER Type: VARCHAR Length: 10
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: 30
Field:DELIVERYPHONE Type: VARCHAR Length: 20
Field:DELIVERYFAX Type: VARCHAR Length: 20
Field:DELIVERYEMAIL Type: VARCHAR Length: 100
Field:NOOFSHIPPINGPIECES Type: INTEGER
Field:PICKPRINTSTATUS Type: VARCHAR Length: 20
Field:PICKLISTPRINTEDBY Type: VARCHAR Length: 30
Field:PICKPRINTDATEANDTIME Type: TIMESTAMP
Field:PICKEDSTATUS Type: VARCHAR Length: 20
Field:PICKEDBY Type: VARCHAR Length: 30
Field:PICKEDDATEANDTIME Type: TIMESTAMP
Field:PACKEDSTATUS Type: VARCHAR Length: 20
Field:PACKEDBY Type: VARCHAR Length: 30
Field:PACKEDDATEANDTIME Type: TIMESTAMP
Field:LABELPRINTSTATUS Type: VARCHAR Length: 20
Field:LABELPRINTEDBY Type: VARCHAR Length: 30
Field:LABELPRINTDATEANDTIME Type: TIMESTAMP
Field:DELIVERYPRINTSTATUS Type: VARCHAR Length: 20
Field:DELIVERYPRINTEDBY Type: VARCHAR Length: 30
Field:DELIVERYPRINTDATEANDTIME Type: TIMESTAMP
Field:SHIPPINGSTATUS Type: VARCHAR Length: 20
Field:SHIPPINGBY Type: VARCHAR Length: 30
Field:SHIPPINGDATEANDTIME Type: TIMESTAMP
Field:PICKPRINTDATE Type: DATE
Field:PICKEDDATE Type: DATE
Field:PACKEDDATE Type: DATE
Field:LABELPRINTDATE Type: DATE
Field:DELIVERYPRINTDATE Type: DATE
Field:SHIPPINGDATE Type: DATE
Field:PICKPRINTTIME Type: TIME
Field:PICKEDTIME Type: TIME
Field:PACKEDTIME Type: TIME
Field:LABELPRINTTIME Type: TIME
Field:DELIVERYPRINTTIME Type: TIME
Field:SHIPPINGTIME Type: TIME
Field:NOPOSTINGOFISSUES Type: BOOLEAN
Field:ISSUELEVEL Type: VARCHAR Length: 30
Field:KITSETISSUELEVEL 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