Macola Table question - OELINCMT_SQL

[DBergkamp10]

Hi,

I am currently working on a project to update records in the table OELINCMT_SQL, and I was wondering if someone could answer a question about the functionality of this table - namely, I don't understand the purpose of the field LINE_SEQ_NO.

I've noticed that the majority of them have the value 0, but there are some that have different values - 1, 14, 17, 20 and so on.

Does anyone understand its purpose? Any help would be greatly appreciated, and Thanks in advance!

Regards

Ivan

 

[dgillz]

Line sequence 0 means it is an order header comment. Line Sequences other that that means the comment belongs the the corresponding record in the OEORDLIN table with the same order type, order no, and line sequence number, which is in fact the primary relationship between the 2 tables.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[DBergkamp10]

Dgillz - thanks so much - you are a star, much appreciated!

 

[abaldwin]

The line seq in the OE line......if my memory serves me properly (which may be an issue in and of itself at the moment), isn't that a number that gets changed as lines are added/deleted? Just an FYI as that may effect your project.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[dgillz]

Yes,in the event of a partial shipment - only 3 of 5 lines get shipped for example - the line_seq_no in both the OEORDLIN and OELINCMT get renumbered.

The line_no field in the OEORDLIN does not.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[stravis]

The oelincmt_sql.line_seq_no was assigned the wrong name during development; it should have been oelincmt_sql.line_no. Dgillz is correct that a oelincmt_sql.line_seq_no = 0 is for a header comment but any number greater than 0 corresponds to the oeordlin_sql.line_no field not the oeordlin_sql.line_seq_no. The linkage between the two tables for line item comments uses the following fields:

oeordlin_sql.ord_type = oelincmt_sql.ord_type AND
oeordlin_sql.ord_no = oelincmt_sql.ord_no AND
oeordlin_sql.line_no = oelincmt_sql.line_seq_no

The oeordlin_sql.line_no does not get reordered like the oeordline_sql.line_seq_no field and therefore the oelincmt_sql.line_seq_no field is not reordered either.

Scott Travis

http://www.infospring.net