Operation numbering

unknown

Hi everybody,

 

   In the process to start using the MRP, we want to define operation numbering. Example, operation sequence number 1100 is always on a Gantry and 59999 is always route to store. But, we have an error message from Visual saying we can’t have an operation number greater than 32 767. Do you know where is this setting?

 

Thanks

 

Nancy

 

unknown

The number is a database constraint, not a limit set by the software. In the OPERATION table, SEQUENCE_NO has a datatype of smallint, which has a range of -32,768 to 32,767.



docs.microsoft.com/.../int-bigint-smallint-and-tinyint-transact-sql

BI-229 - Approach to List Objects.mp4