Field Listing for Table OSTDEF_JOB_SIGNATURES

Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:SIGNATUREID Type: VARCHAR Length: 36
Field:CUSTOMERNAME Type: VARCHAR Length: 100
Field:SIGNERNAME Type: VARCHAR Length: 100
Field:SIGNEREMAIL Type: VARCHAR Length: 200
Field:SIGNERPHONE Type: VARCHAR Length: 20
Field:SIGNINGMETHOD Type: VARCHAR Length: 20
Field:SIGNATUREPATH Type: VARCHAR Length: 500
Field:SIGNATUREMIME Type: VARCHAR Length: 50
Field:SIGNATUREIMAGE Type: BLOB
Field:SCOPESUMMARY Type: BLOB
Field:TERMSVERSION Type: VARCHAR Length: 50
Field:TERMSHASH Type: VARCHAR Length: 64
Field:TECHNICIANNAME Type: VARCHAR Length: 30
Field:SIGNEDAT Type: VARCHAR Length: 30
Field:IPADDRESS Type: VARCHAR Length: 50
Field:USERAGENT Type: VARCHAR Length: 300
Field:GPSLATITUDE Type: DOUBLE
Field:GPSLONGITUDE Type: DOUBLE
Field:GPSACCURACY Type: DOUBLE
Field:DEVICEID Type: VARCHAR Length: 100
Field:STATUS Type: VARCHAR Length: 20
Field:SIGNINGCAPACITY Type: VARCHAR Length: 20
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30