Hi Guys,
I need a hand understanding receipts... heres the way I see it:
Many Customers can at Many Times, buy Many Products.
Resolution:
Customers to Times (or Instances) = Receipt (or Order)
Times (or Instances) to Products = LineItems
LineItems within Receipts within Customers
Fairly Straightforward.
Each product will have a number of describing fields Inlcuding Price. But this price is really only a StandardPrice, because venders must be able to change the actual sale price at will. Therefore when a product is selected as a LineItem, most times the StandardPrice is pre-populated into the SalePrice Field of the LineItem. This field is Un-Locked and Enabled, so as to allow for changes. The changed (or defaulted) SalePrice is recorded in the LineItem.
This process continues for EACH LineItem.
Heres my question... The total sale. Is this even recorded, or is it left in Dyna (meaning calculated in a query or form only and not Actually Recorded)???
If it is left in Dyna, how are we able to WRITE a TotalTaxAmount to the RECEIPT??
If it is NOT left in Dyna, do we put the sub-total in the Receipt? And if so, how do we WRITE that value to the receipt based on a SUM calculation of LineItems (Sub-Total).
I guess my questions really are... where does the WRITE related transition (calculation) take place between LineItem and Receipt??? And hows it done??
If I can understand this, it will clear up so much in understanding other elements of database design... any input is GREATLY APPRECIATED!!!
Thanks,
BG
I need a hand understanding receipts... heres the way I see it:
Many Customers can at Many Times, buy Many Products.
Resolution:
Customers to Times (or Instances) = Receipt (or Order)
Times (or Instances) to Products = LineItems
LineItems within Receipts within Customers
Fairly Straightforward.
Each product will have a number of describing fields Inlcuding Price. But this price is really only a StandardPrice, because venders must be able to change the actual sale price at will. Therefore when a product is selected as a LineItem, most times the StandardPrice is pre-populated into the SalePrice Field of the LineItem. This field is Un-Locked and Enabled, so as to allow for changes. The changed (or defaulted) SalePrice is recorded in the LineItem.
This process continues for EACH LineItem.
Heres my question... The total sale. Is this even recorded, or is it left in Dyna (meaning calculated in a query or form only and not Actually Recorded)???
If it is left in Dyna, how are we able to WRITE a TotalTaxAmount to the RECEIPT??
If it is NOT left in Dyna, do we put the sub-total in the Receipt? And if so, how do we WRITE that value to the receipt based on a SUM calculation of LineItems (Sub-Total).
I guess my questions really are... where does the WRITE related transition (calculation) take place between LineItem and Receipt??? And hows it done??
If I can understand this, it will clear up so much in understanding other elements of database design... any input is GREATLY APPRECIATED!!!
Thanks,
BG
