Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Distribution, Transportation & Warehousing (http://www.baanboard.com/baanboard/forumdisplay.php?f=6)
-   -   tdpur051 - Purchase Order Line History - What do fields Seq. # and Record Type Mean? (http://www.baanboard.com/baanboard/showthread.php?t=7221)

ajitdon 17th October 2002 18:46

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?

ex:

.sern = 0 ; .ckor = 1
.sern = 0 ; .ckor = 2
.sern = 0 ; .ckor = 3
.sern = 1 ; .ckor = 1
.sern = 1 ; .ckor = 2
.sern = 1 ; .ckor = 3

Thanks,
Ajit.

Martin Jung 17th October 2002 20:24

Hi,

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:
Code:

                                ckor  sern  itemcode  quantity

Newly entered salesoderline :  1        0        X            1
change itemcode from X to Y :  1        0        X            -1
                                1        1        Y            1

Hope that helps.

Martin

ajitdon 17th October 2002 21:39

Hi Martin,

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.

Thanks,
Ajit.

Martin Jung 18th October 2002 06:20

Hi ajitdon,

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... :)

Regards,

Martin


All times are GMT +2. The time now is 17:13.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com