📄 bills.htm
字号:
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Dragon SuperMart</title>
<style>
<!--
p.MsoNormal
{mso-style-parent:"";
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
margin-left:0in; margin-right:0in; margin-top:0in}
table.MsoTableGrid
{border:1.0pt solid windowtext;
font-size:10.0pt;
font-family:"Times New Roman"}
-->
</style>
</head>
<body>
<p class="MsoNormal" style="text-align: center">
<img border="0" src="dragon.jpg" width="100" height="56"></p>
<p class="MsoNormal" style="text-align: center"><b><i><u><font face="Book Antiqua" color="#800080" size="2">
Dragon Supermarket Shopping System</font></u></i></b></p>
<p class="MsoNormal" style="text-align: center"> </p>
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt"><b>Bills</b>
are generated by the Shopping Management system when a teller enters records of
purchases made by the customer. A typical bill contains the following
information:</font></p>
<p class="MsoNormal"> </p>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="488" id="AutoNumber1">
<tr>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in; background: #E0E0E0">
<p class="MsoNormal"><span style="font-size: 9pt; font-weight: 700">
<font face="Comic Sans MS">Column Name</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in; background: #E0E0E0">
<p class="MsoNormal"><span style="font-size: 9pt; font-weight: 700">
<font face="Comic Sans MS">Description</font></span></td>
</tr>
<tr>
<td width="103">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
BillNo </font></td>
<td width="382">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
Automatically generated Number of the Bill</font></td>
</tr>
<tr>
<td width="103">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
StockId </font></td>
<td width="382">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
Unique Stock id that identifies the stock the product belongs to</font></td>
</tr>
<tr>
<td width="103">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
Quantity </font></td>
<td width="382">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
Quantity of each of the items purchased</font></td>
</tr>
<tr>
<td width="103">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
SalePrice </font></td>
<td width="382">
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">
Selling price of each item</font></td>
</tr>
</table>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">These
details are stored in the <i>BillDetails</i> table.</font></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><font face="Comic Sans MS" style="font-size: 9pt">A record
of each bill generated is also stored in the <i>Bills</i> table which contains a
master list of all bills.</font></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><font style="font-size: 9pt" face="Comic Sans MS">This
table contains the following information:</font></p>
<p class="MsoNormal"> </p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; border: medium none; margin-left: .2in">
<tr>
<td width="60" valign="top" style="width: 45.35pt; border: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in; background: #E0E0E0">
<p class="MsoNormal"><span style="font-size: 9pt; font-weight: 700">
<font face="Comic Sans MS">Sl.No.</font></span></td>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in; background: #E0E0E0">
<p class="MsoNormal"><span style="font-size: 9pt; font-weight: 700">
<font face="Comic Sans MS">Column Name</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in; background: #E0E0E0">
<p class="MsoNormal"><span style="font-size: 9pt; font-weight: 700">
<font face="Comic Sans MS">Description</font></span></td>
</tr>
<tr>
<td width="60" valign="top" style="width: 45.35pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">1</font></span></td>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">BillNo</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">Bill Number</font></span></td>
</tr>
<tr>
<td width="60" valign="top" style="width: 45.35pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">2</font></span></td>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">BillDate</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">Date on which the customer purchases the goods</font></span></td>
</tr>
<tr>
<td width="60" valign="top" style="width: 45.35pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">3</font></span></td>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">UsrID</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">User id of the user who prepared the bill</font></span></td>
</tr>
<tr>
<td width="60" valign="top" style="width: 45.35pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">4</font></span></td>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">TotalBillAmt</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">Total amount of bill before applying discount</font></span></td>
</tr>
<tr>
<td width="60" valign="top" style="width: 45.35pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">5</font></span></td>
<td width="109" valign="top" style="width: 81.9pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">PaymentMode</font></span></td>
<td width="259" valign="top" style="width: 194.25pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoNormal"><span style="font-size: 9pt">
<font face="Comic Sans MS">One of the listed values: CASH, CREDIT</font></span></td>
</tr>
</table>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><font style="font-size: 9pt" face="Comic Sans MS">Only the
<b>teller</b> has authority to perform product sales and generate bill. The
Product Sales module under the Teller menu is used to enter details of purchases
and generate a bill. Bills Management module helps to manipulate bills.</font></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -