Field Listing for Table BOMMASTER
| Field: | ASSEMBLYCODE | Type: | VARCHAR Length: 50 |
| Field: | ASSEMBLYVERSION | Type: | VARCHAR Length: 20 |
| Field: | VERSIONDESCRIPTION | Type: | VARCHAR Length: 100 |
| Field: | VERSIONSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | ITEMUNIT | Type: | VARCHAR Length: 15 |
| Field: | ITEMSTATUS | Type: | VARCHAR Length: 20 |
| 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: | AVGRUNQTYFORSETUP | Type: | DOUBLE |
| Field: | ISAPHANTOM | Type: | BOOLEAN |
| Field: | LEVELCODE | Type: | INTEGER |
| Field: | BOMITEMCOST | Type: | DOUBLE |
| Field: | BOMDESCRIPTORCOST | Type: | DOUBLE |
| Field: | BOMLABOURCOST | Type: | DOUBLE |
| Field: | BOMLABOURCOSTDIRECT | Type: | DOUBLE |
| Field: | BOMLABOURCOSTFIXEDOH | Type: | DOUBLE |
| Field: | BOMLABOURCOSTVAROH | Type: | DOUBLE |
| Field: | BOMROLLEDUPCOST | Type: | DOUBLE |
| Field: | BOMROLLEDUPDATE | Type: | DATE |
| Field: | THISITEMCOST | Type: | DOUBLE |
| Field: | THISDESCRIPTORCOST | Type: | DOUBLE |
| Field: | THISLABOURCOST | Type: | DOUBLE |
| Field: | THISLABOURCOSTDIRECT | Type: | DOUBLE |
| Field: | THISLABOURCOSTFIXEDOH | Type: | DOUBLE |
| Field: | THISLABOURCOSTVAROH | Type: | DOUBLE |
| Field: | LOWERITEMCOST | Type: | DOUBLE |
| Field: | LOWERDESCRIPTORCOST | Type: | DOUBLE |
| Field: | LOWERLABOURCOST | Type: | DOUBLE |
| Field: | LOWERLABOURCOSTDIRECT | Type: | DOUBLE |
| Field: | LOWERLABOURCOSTFIXEDOH | Type: | DOUBLE |
| Field: | LOWERLABOURCOSTVAROH | Type: | DOUBLE |
| Field: | CREATIONMETHOD | Type: | VARCHAR Length: 30 |
| Field: | BATCHQTY | Type: | DOUBLE |
| Field: | PLANNEDMARKUPERCENT | Type: | DOUBLE |
| Field: | PLANNEDUNITPRICE | Type: | DOUBLE |
| Field: | BOMROLLEDUPUNITCOST | Type: | DOUBLE |
| Field: | COMPONENTLEADTIME | Type: | INTEGER |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_5 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_6 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_7 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_8 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_3 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_4 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_5 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_6 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_7 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_8 | Type: | DATE |
| Field: | VERSIONSTATUSCHANGEDATE | Type: | DATE |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |