At our company we need information about the end-of-life for products.
https://en.wikipedia.org/wiki/Product_lifecycle#Phase_4:_Service
In our database we have a lot of old products which we can no longer sell to our customers as distributors do no longer deliver these products. Examples are:
| Mfg part number | DataSource SKU ID | Date of creation
(at our company) |
| 283266-B21 | S1192379 | 2004-02-21 |
| UR795E | S6662363 | 2009-11-07 |
| AT152A#0D1 | S14964478 | 2014-06-17 |
I wrote the following query:
SELECT
p.MfPN
,a.IsObsolete
FROM
CnetContent.dbo.cds_Catalog a WITH(READUNCOMMITTED)
INNER JOIN CnetContent.dbo.cds_Prod p WITH(READUNCOMMITTED) ON a.ProdID = p.ProdID
WHERE
p.MfPN IN ('283266-B21', 'UR795E', 'AT152A#0D1')
This gives me:
| MfPN | IsObsolete |
| 283266-B21 | 1 |
| AT152A#0D1 | 0 |
| UR795E | 0 |
Can you please give me further information on how 1WorldSync defines IsObsolete?
Is this term equivalent to end-of-life?
