Case Study: Stock

 ..to previous page [S_a] 
Answers to questions
  • Will you include GST in the database ?
    • No as it is calculated data.
      BUT, in a commercial database you need to be able to handle changing GST values ( In NZ GST started at 10% before moving to 12.5%)
    •
Possible field characteristics
Key Field Name Data Type Description Field Size Required
Yes PartId Number Part Id Long Integer Yes
. PartName Text . 30 Yes
. Quantity Number . Integer No
. Price Number . Currency
2dp		 No
. GST . Not Required . .
. ReOrder Text Y or N 1 No
  • Note
  • GST is displayed on a form or report as Price * 12.5%.

[Rev 24/06/00 ] 26/4/00 © 2000 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.