Jiwa SO Lines tables

[SBarnes]

Hi Guys

Can you explain the difference between the following tables in the database?

SO_LineDetails

SO_LineExtra

SO_LineSerials

[Scott.Pearce]

SO_LineDetails - Represents individual stock lines taken by the sales order line. For example, a sales order line may take a quantity of 10 - but 5 of that amount comes from this bunch of stock over here with an expiry date of 01/01/2017, and the rest comes from this older pile of stock over there that has an expiry date of 01/12/2016.

SO_LineExtra - Legacy, not used (retired in August 2002 v6.3.8). I suspect that a column limit was reached in the bad old days, so this was an extension to the SO_Lines table. The columns have since been moved into SO_Lines proper.

SO_LineSerials - This is used by the standard plugin titled "Manual Serial Numbers". In Jiwa v6 this functionality was in native code, hence the table still exists as a standard table. This plugin (and it's SO_LineSerials table) allows arbitrary serial numbers to be associated with a sales order line (regardless of whether those serial numbers actually exist in stock).

[SBarnes]

Thanks Scott

Must be close to the response record time.

[Scott.Pearce]