Skip to main content
Question

Migration Job field flags

  • September 28, 2022
  • 3 replies
  • 478 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)
  • 102 replies
  • September 28, 2022

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
  • 10 replies
  • September 28, 2022

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)
  • 12 replies
  • October 20, 2022

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