I am not too sure about the velocity script.
What's there to be unsure about?
The only problem I am having now is my csv upload. I receive an error that the data field basically isn't long enough to hold the code. Here is the exact description: "Value is greater than allowed for field". I have tried to locate more info on this but to no avail. I did not notice any section where I can input the 18 digit limit and assign it to the field.
Is there such a thing? is there a maximum?
The maximum length of a field is dictated by its data type.
If this is a numeric field, you can't insert 18 digits into it. The maximum value of a (signed) integer is 2147483647, which in addition to prohibiting any larger integers also means there can never be any values longer than 10 digits.
did text field work for you?
String fields can hold up to 255 chars, so you'll be fine.
did text field work instead?