tdpur051 - Purchase Order Line History - What do fields Seq. # and Record Type Mean?
On the table tdpur051 - purhase order lines history , there are two fields - Sequence Number (.sern) and Record Type (.ckor).
What do these fields stand for and how can they be used?
What does it mean when different records in the table have different combinations of these two fields?
.sern = 0 ; .ckor = 1
.sern = 0 ; .ckor = 2
.sern = 0 ; .ckor = 3
.sern = 1 ; .ckor = 1
.sern = 1 ; .ckor = 2
.sern = 1 ; .ckor = 3
ckor = 1 stands for an inserted orderline, ckor = 2 for a cancelled orderline and ckor = 3 is a processed (session process delivered salesorders) or invoiced orderline.
In case a salesorderline is changed by a user, Baan generates a "negative" entry in order to "cancel" the entry with the old value(s). This is a record with ckor = 1 and sern = 0. At the same time a second record is generated with ckor = 1 and sern = 1 and the new value(s) for the changed field(s) in tdsls041. Ok so far?
Just a simple example:
Thanks for the inputs.
My question was on purchase order lines but your explanation did provide insight into how Baan treats the CKOR and SERN fields.
sorry, my fault. But logic is the same in PUR as well as in SLS. Only the table contents are slightly different.
Sorry also for my example. It is not displayed like I entered it when I wrote my post. I've to ask the board master for this... :)
|All times are GMT +2. The time now is 22:21.|
©2001-2017 - Baanboard.com - Baanforums.com