Field Listing for Table SCHEDULEORDERS
Field: | ASSEMBLYORJOB | Type: | VARCHAR Length: 15 |
Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | REQUIREDDATE | Type: | DATE |
Field: | ORDERDATE | Type: | DATE |
Field: | LEADTIME | Type: | INTEGER |
Field: | SCHEDULEHOURS | Type: | DOUBLE |
Field: | SCHEDULETIME | Type: | TIMESTAMP |
Field: | SCHEDULEENDTIME | Type: | TIMESTAMP |
Field: | GENERATEDSEQ | Type: | INTEGER |
Field: | SCHEDULESEQ | Type: | INTEGER |
Field: | ORDERSETUPDURATION | Type: | DOUBLE |
Field: | SETUPDURATIONSCALE | Type: | VARCHAR Length: 10 |
Field: | ORDERSTARTDATE | Type: | DATE |
Field: | ORDERFINISHDATE | Type: | DATE |
Field: | ORDERQTY | Type: | DOUBLE |
Field: | COMPLETEQTY | Type: | DOUBLE |
Field: | SCRAPEDQTY | Type: | DOUBLE |
Field: | REMAININGQTY | Type: | DOUBLE |
Field: | SCHEDULEFIXED | Type: | BOOLEAN |
Field: | MINSTARTDATE | Type: | DATE |
Field: | ORDERDESCRIPTION | Type: | VARCHAR Length: 200 |
Field: | ORDERSEQUENCENUMBER | Type: | INTEGER |
Field: | ORDERSTARTED | Type: | BOOLEAN |
Field: | ORDERPRIORITY | Type: | INTEGER |
Field: | CRITICALRATIO | Type: | DOUBLE |
Field: | ORDERSYSUNIQUEID | Type: | DOUBLE |
Field: | WORKFLOWSTATUS | Type: | VARCHAR Length: 20 |
Field: | TRACKINGCOLOUR | Type: | INTEGER |
Field: | EXCLUDEORDER | Type: | BOOLEAN |
Field: | EXCLUDEFIRM | Type: | BOOLEAN |
Field: | FIRMORDER | Type: | BOOLEAN |
Field: | SOURCEREFERENCE | Type: | VARCHAR Length: 50 |
Field: | SOURCENAME | Type: | VARCHAR Length: 50 |
Field: | UPDATESTATICDATA | Type: | INTEGER |
Field: | PARENTORDER | Type: | VARCHAR Length: 30 |
Field: | PARENTDESCRIPTION | Type: | VARCHAR Length: 200 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |