Field Listing for Table ORDERREQUIREMENTS
Field: | REQUIREDDATE | Type: | DATE |
Field: | DEMANDFROM | Type: | VARCHAR Length: 10 |
Field: | DEMANDORDERTYPE | Type: | VARCHAR Length: 10 |
Field: | DEMANDORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | DEMANDTASKORSTEP | Type: | VARCHAR Length: 20 |
Field: | DEMANDCODETYPE | Type: | VARCHAR Length: 20 |
Field: | DEMANDCODE | Type: | VARCHAR Length: 50 |
Field: | DEMANDCODEDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | DEMANDQTY | Type: | DOUBLE |
Field: | DEMANDUNIT | Type: | VARCHAR Length: 15 |
Field: | SUPPLYFROM | Type: | VARCHAR Length: 10 |
Field: | SUPPLYORDERTYPE | Type: | VARCHAR Length: 20 |
Field: | SUPPLYORDERDATE | Type: | DATE |
Field: | SUPPLYNAME | Type: | VARCHAR Length: 50 |
Field: | SUPPLYQTY | Type: | DOUBLE |
Field: | SUPPLYUNIT | Type: | VARCHAR Length: 15 |
Field: | CUSTOMPRODUCT | Type: | BOOLEAN |
Field: | CUSTOMPRODUCTBOMID | Type: | DOUBLE |
Field: | CUSTOMPRODUCTBATCHNO | Type: | VARCHAR Length: 20 |
Field: | SUPPLYUNITPRICE | Type: | DOUBLE |
Field: | SUPPLYFIXEDPRICE | Type: | BOOLEAN |
Field: | SUPPLYPURCHASESDIRECT | Type: | BOOLEAN |
Field: | SITENAME | Type: | VARCHAR Length: 50 |
Field: | LINESELECTED | Type: | BOOLEAN |
Field: | LINKEDCATALOGUENAME | Type: | VARCHAR Length: 20 |
Field: | PARENTORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | PARENTORDERTYPE | Type: | VARCHAR Length: 10 |
Field: | DEMANDORDERDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | DEMANDCOMPANYNAME | Type: | VARCHAR Length: 50 |
Field: | ASSEMBLYVERSION | Type: | VARCHAR Length: 20 |
Field: | DEMANDCATEGORY | Type: | VARCHAR Length: 20 |
Field: | DEMANDSUBCATEGORY | Type: | VARCHAR Length: 20 |
Field: | LINENUMBER | Type: | INTEGER |
Field: | HEADERSYSUNIQUEID | 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 |