Whats the different between P and K field flags in a migration job?
I thought P stood for Primary key?
Userlevel 4
+8
Hi
“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
“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?
+3
Example: ORDER_NO on customer order line is a P. This means that ORDER_NO is retrieved from the parent Customer Order.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.