Field Listing for Table JOBLINEREQUIREMENTS
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | TASKNAME | Type: | VARCHAR Length: 20 |
Field: | LINENUMBER | Type: | INTEGER |
Field: | COMPONENTTYPE | Type: | VARCHAR Length: 20 |
Field: | COMPONENTCODE | Type: | VARCHAR Length: 50 |
Field: | COMPONENTDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | COMPONENTUNIT | Type: | VARCHAR Length: 15 |
Field: | ANALYSISGROUP | Type: | VARCHAR Length: 20 |
Field: | PERLINECOST | Type: | DOUBLE |
Field: | PERLINEQTY | Type: | DOUBLE |
Field: | TOTALREQUIREDQTY | Type: | DOUBLE |
Field: | TOTALISSUEDQTY | Type: | DOUBLE |
Field: | TOTALREMAININGQTY | Type: | DOUBLE |
Field: | ACTUALLINECOST | Type: | DOUBLE |
Field: | SKIPISSUE | Type: | BOOLEAN |
Field: | LINECREATION | Type: | VARCHAR Length: 15 |
Field: | PERLINESTDPRICE | Type: | DOUBLE |
Field: | EXTREQUIREDSTDPRICE | Type: | DOUBLE |
Field: | EXTISSUEDSTDPRICE | Type: | DOUBLE |
Field: | LINKEDCATALOGUENAME | Type: | VARCHAR Length: 20 |
Field: | OVERRIDESCHEDULECODE | Type: | BOOLEAN |
Field: | SCHEDULECODE | Type: | VARCHAR Length: 50 |
Field: | SCHEDULEFACTOR | Type: | DOUBLE |
Field: | PARENTLABOURCODE | Type: | VARCHAR Length: 50 |
Field: | CREATIONSOURCEID | Type: | DOUBLE |
Field: | HEADERSYSUNIQUEID | Type: | DOUBLE |
Field: | QUOTEDPRIMARYSUPPLIER | Type: | VARCHAR Length: 50 |
Field: | QUOTEDITEMREVISIONNO | Type: | VARCHAR Length: 10 |
Field: | QUOTEDCODESTATUS | Type: | VARCHAR Length: 20 |
Field: | QUOTEDBUYPRICE | Type: | DOUBLE |
Field: | QUOTEDUNITPRICE | Type: | DOUBLE |
Field: | QUOTEDUNITCOST | Type: | DOUBLE |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |