Skip to main content
Question

Migration Job field flags

  • Sep 28, 2022 5:12 AM UTC
  • 3 replies
  • 638 views

Forum|alt.badge.img+2

Whats the different between P and K field flags in a migration job?

I thought P stood for Primary key?

3 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • Sep 28, 2022 5:43 AM UTC

Hi @signils ,

 

“Attribute types retrieved from the view definition in IFS/Foundation. P = Parent Key. Means that this column is retrieved from somewhere else. K = Key. Means that this is a key column in this view. M = Mandatory. Column must have a value. I = Insert allowed U = Update allowed.”

 

Kind Regards

Ozgun Bal


Forum|alt.badge.img+2
  • Author
  • Sidekick
  • Sep 28, 2022 6:28 AM UTC

Hi @signils ,

 

“Attribute types retrieved from the view definition in IFS/Foundation. P = Parent Key. Means that this column is retrieved from somewhere else. K = Key. Means that this is a key column in this view. M = Mandatory. Column must have a value. I = Insert allowed U = Update allowed.”

 

Kind Regards

Ozgun Bal

Thanks but just need more clarification about :

 

 P = Parent Key. Means that this column is retrieved from somewhere else. 

 

Somewhere else as in?


Forum|alt.badge.img+4
  • Do Gooder (Employee)
  • Oct 20, 2022 7:39 PM UTC

Example:  ORDER_NO on customer order line is a P.  This means that ORDER_NO is retrieved from the parent Customer Order.