The Subjob (which combines the Job number and the Subjob number) is an integer field, so the maximum number that this field can hold is: 2,147,483,647

- If you have a 3-digit Subjob number, then the maximum Job number you can have is 2147483
- If you have a 4-digit Subjob number, then the maximum Job number you can have is 214748

(actually we have a smart bit of code so that if you hit the maximum number, instead of throwing an error it uses the next job number but drops the length of the Subjob number down by one digit)

You can set the size (length) of the Subjob number manually via SQL. In the table ENPRISE_JOBCOST_SETUP there is a field SUBJOBRANGE. If this is set to 10000 then the Subjob numbers will be 4 digits and go up to 9999. If this is set to 1000 then the Subjob numbers will be 3 digits and go up to 999. If this is set to 100 then the Subjob numbers will be 2 digits and go up to 99.

## Comments

0 comments

Article is closed for comments.