Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th October 2002, 18:46
ajitdon ajitdon is offline
Junior Member
 
Join Date: Aug 2002
Posts: 15
ajitdon is on a distinguished road
Baan: Baan 1Vc0 - DB: Oracle 8 - OS: UNIX (Sun Solaris)
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.
Reply With Quote
  #2  
Old 17th October 2002, 20:24
Martin Jung's Avatar
Martin Jung Martin Jung is offline
Guru
 
Join Date: Jan 2002
Location: Germany
Posts: 456
Martin Jung is on a distinguished road
Baan: Baan IV - DB: Oracle - OS: Unix
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
Reply With Quote
  #3  
Old 17th October 2002, 21:39
ajitdon ajitdon is offline
Junior Member
 
Join Date: Aug 2002
Posts: 15
ajitdon is on a distinguished road
Baan: Baan 1Vc0 - DB: Oracle 8 - OS: UNIX (Sun Solaris)
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.
Reply With Quote
  #4  
Old 18th October 2002, 06:20
Martin Jung's Avatar
Martin Jung Martin Jung is offline
Guru
 
Join Date: Jan 2002
Location: Germany
Posts: 456
Martin Jung is on a distinguished road
Baan: Baan IV - DB: Oracle - OS: Unix
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 22:40.


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