Field Listing for Table ASSEMBLYHEADERCLOSE
Field: | ASSEMBLYSELECTED | Type: | BOOLEAN |
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
Field: | ORDERDATE | Type: | DATE |
Field: | ASSEMBLYCLOSEDATE | Type: | DATE |
Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | ITEMUNIT | Type: | VARCHAR Length: 15 |
Field: | REQUIREDDATE | Type: | DATE |
Field: | ORDERSTARTDATE | Type: | DATE |
Field: | ORDERFINISHDATE | Type: | DATE |
Field: | SOURCENAME | Type: | VARCHAR Length: 50 |
Field: | SOURCEREFERENCE | Type: | VARCHAR Length: 15 |
Field: | PLANNEDTOTALCOSTS | Type: | DOUBLE |
Field: | ACTUALTOTALCOSTS | Type: | DOUBLE |
Field: | WIPVALUE | Type: | DOUBLE |
Field: | ORDERQTY | Type: | DOUBLE |
Field: | COMPLETEQTY | Type: | DOUBLE |
Field: | SCRAPEDQTY | Type: | DOUBLE |
Field: | COPRODUCTORDERQTY | Type: | DOUBLE |
Field: | COPRODUCTCOMPLETEQTY | Type: | DOUBLE |
Field: | COPRODUCTSCRAPEDQTY | Type: | DOUBLE |
Field: | OUTSTANDINGPORECEIPTS | Type: | INTEGER |
Field: | ALLOWEDTOCLOSE | Type: | BOOLEAN |
Field: | SITENAME | Type: | VARCHAR Length: 50 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |