GP Custom Function - GPNEWCUSTOMERID

When using the GPNEWCUSTOMERID custom function within the Workbench, [GPNEWCUSTOMERID( Connection, Prefix, SuffixDigits )], the below will assist to ensure successful usage:

Sample Assumption:

Connection = GP (Workbench target connection edited to GP)

Prefix = S2 (Workbench source field 2)

Suffix = 4 (default function value)

**Keep in mind that the required Customer_ID field in GP is a char(15) so if you are using a source field that has many characters, you may need to trim to constrain it to fit in the target field.

Sample Function Usage:

GPNEWCUSTOMERID( " GP" , LEFT(S2, 11), 4 )

The key in using this function is to ensure that the last two function parameter values (11, 4), when summed, do not exceed the char(15) schema definition within GP.

Posted by Rich R. on Sep 7 2011 9:14PM { U43 , F11 , T2196 , C6993 }

(1) Answer

Login