Difference between -1 and null in the targettype filed

[Qian]

Hi

Could anyone advise what is the difference between -1 and null in the targettype filed in marketing documents?

For example, in Sales Quotation - Rows (QUT1) table, I found for some open sales quotations, the field is null however the DB help file suggest the default value is -1 so I suppose it should be -1 for open documents.

Many thanks for your advisory.

[Former Member · Accepted solution]

Hi, Qian!

I investigated that "-1" value appears in targettype field in Sales Quotation Rows (QUT1 table) when you Dublicate a Sales Quotation document (Ctrl + D). And NULL value appears when you create a new document without dublicating.

In case you want to equal these 2 "empty"-values using T-SQL, you can use ISNULL(targettype, -1) function - this will give you -1 for both the "empty"-values

HTH!

Message was edited by: Aleksey Kuznetsov

[Qian · Accepted solution]

Hi Aleksey,

Thank you very much for your help!

Have a nice day.

Qian