Field Listing for Table JOBBOMMASTER
Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | ITEMUNIT | Type: | VARCHAR Length: 15 |
Field: | ASSEMBLYINSTRUCTIONS | Type: | BLOB |
Field: | ASSEMBLYLEADTIME | Type: | INTEGER |
Field: | ASSEMBLYDURATION | Type: | DOUBLE |
Field: | ASSEMBLYDURATIONSCALE | Type: | VARCHAR Length: 10 |
Field: | ASSEMBLYDURATIONPER | Type: | DOUBLE |
Field: | SETUPDURATION | Type: | DOUBLE |
Field: | SETUPDURATIONSCALE | Type: | VARCHAR Length: 10 |
Field: | BOMITEMCOST | Type: | DOUBLE |
Field: | BOMDESCRIPTORCOST | Type: | DOUBLE |
Field: | BOMLABOURCOST | Type: | DOUBLE |
Field: | BOMROLLEDUPCOST | Type: | DOUBLE |
Field: | PLANNEDMARKUPERCENT | Type: | DOUBLE |
Field: | PLANNEDUNITPRICE | Type: | DOUBLE |
Field: | BOMROLLEDUPUNITCOST | Type: | DOUBLE |
Field: | AVGRUNQTYFORSETUP | Type: | DOUBLE |
Field: | UPDATEJOBLINECOST | Type: | BOOLEAN |
Field: | PLANNEDMARGINPERCENT | Type: | DOUBLE |
Field: | PLANNEDHOURS | Type: | DOUBLE |
Field: | JOBLINESYSUNIQUEID | Type: | DOUBLE |
Field: | SOURCESYSUNIQUEID | 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 |