Jiwa

I'm just trying to figure out what the customer is doing with their pricing, and I notice a decent chunk of records in IN_DebtorClassificationSpecificPrice have no value (DB NULL) for DebtorClassificationID.

A quick scan through the decompiler shows me that Jiwa is happy to load these records, but I can't see where a "debtor classification price" with no debtor classification is referenced in the code, nor can I imagine a scenario where they would be useful.

What have I missed?

pricerc wrote:I'm just trying to figure out what the customer is doing with their pricing, and I notice a decent chunk of records in IN_DebtorClassificationSpecificPrice have no value (DB NULL) for DebtorClassificationID.

A quick scan through the decompiler shows me that Jiwa is happy to load these records, but I can't see where a "debtor classification price" with no debtor classification is referenced in the code, nor can I imagine a scenario where they would be useful.

What have I missed?

NULL just means all debtor classifications.

For example, you might want a promotional price of 10% off for the month of June for everyone who buys 5 or more 5L tubs of personal lubricant, and so you just add a debtor classification price to the product with 10% off, start and end date and no debtor classification.