IDC field to calculate company from Batch Type

You can change the view that is returned in the dropdown to include company and then grab it.
We only have one company but here is what I did for ship to address in SOA. I added the ship to number to the end of the dropdown with a pipe delimiter and then parse off to use in ECM. The

image

then to get the shiptonum field I do this calculation.

SPLITGETREV(FT_SHIP_TO_DESC, "|", 0)

I made a sample view in the IDC database with company in the name and Vend_Comp value field
image

1 Like