Question

Excel Migration

  • 3 May 2021
  • 1 reply
  • 147 views

Badge +4

Hello guys ..

i want to ask..

When placing a shop order, the fields below will be filled automatically.

 

how do I get the value automatically on the migration job according to the existing function in that column?


This topic has been closed for comments

1 reply

Userlevel 3
Badge +5

Hi @rendywinata_  when creating a migration job template for SHOP_ORD view there are two columns 'ORDER_CODE’ and 'ORDER_CODE_DB’ when you using excel migration 'ORDER_CODE’ column will be a dropdown value but 'ORDER_CODE_DB’ is always you have to manually enter for example for Manufacturing its 'M’ likewise depending on your type. Next two columns are ‘ENG_CHG_LEVEL’ and 'ROUTING_REVISION’ these values you needs to manually enter. Hope this is what you referring for..