Skip to main content

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

I thought P stood for Primary key?

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


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?


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


Reply