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 |