Field Listing for Table SERVICESHEETCHECKLISTS
Field: | SERVICEID | Type: | VARCHAR Length: 30 |
Field: | SUBJECTTYPE | Type: | VARCHAR Length: 50 |
Field: | SUBJECTCAPTION | Type: | VARCHAR Length: 200 |
Field: | SUBJECTSUBCAPTION | Type: | VARCHAR Length: 200 |
Field: | SUBJECTRIGHT | Type: | VARCHAR Length: 200 |
Field: | CHECKNAME | Type: | VARCHAR Length: 50 |
Field: | CHECKDESCRIPTION | Type: | VARCHAR Length: 100 |
Field: | GROUPSEQ | Type: | INTEGER |
Field: | GROUPNAME | Type: | VARCHAR Length: 100 |
Field: | MANDATORYSTYLE | Type: | VARCHAR Length: 10 |
Field: | CHECKITEMSEQ | Type: | INTEGER |
Field: | CHECKITEM | Type: | VARCHAR Length: 200 |
Field: | CHECKITEMCODE | Type: | VARCHAR Length: 50 |
Field: | CHECKITEMTYPE | Type: | VARCHAR Length: 20 |
Field: | CHECKITEMOPTIONS | Type: | BLOB |
Field: | CHECKITEMTEXT | Type: | VARCHAR Length: 250 |
Field: | CHECKITEMDATE | Type: | DATE |
Field: | CHECKITEMINTEGER | Type: | INTEGER |
Field: | CHECKITEMNUMBER | Type: | DOUBLE |
Field: | CHECKITEMBOX | Type: | INTEGER |
Field: | CHECKITEMBLOB | Type: | BLOB |
Field: | CHECKITEMLIST | Type: | VARCHAR Length: 250 |
Field: | CHECKITEMSIGNATURE | Type: | BLOB |
Field: | CHECKITEMTIME | Type: | TIME |
Field: | CHECKITEMDISPLAY | Type: | BLOB |
Field: | CHECKITEMENTERED | Type: | INTEGER |
Field: | MANDATORYGROUPPASSED | Type: | INTEGER |
Field: | CREATIONORDER | Type: | INTEGER |
Field: | CONDITIONALNAME | Type: | VARCHAR Length: 20 |
Field: | ORIGINALCHECKNAME | Type: | VARCHAR Length: 50 |
Field: | CHECKTABLENAME | Type: | VARCHAR Length: 31 |
Field: | CHECKITEMVISIBLE | Type: | INTEGER |
Field: | CHECKGROUPINDEX | Type: | INTEGER |
Field: | CHECKITEMPHOTONOTE | Type: | BLOB |
Field: | CHECKITEMHELP | Type: | BLOB |
Field: | RECORDID | Type: | INTEGER |
Field: | RECORDTIMESTAMP | Type: | TIMESTAMP |
Field: | UNIQUEID | Type: | VARCHAR Length: 50 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |