| procedure | type | parameter | datatype | length | in/out | comment |
|---|---|---|---|---|---|---|
| byroyalty | P | @percentage | int | 4 | in | |
| history_proc | P | @stor_id | char | 4 | in | |
| insert_sales_proc | P | @stor_id | char | 4 | in | |
| insert_sales_proc | P | @ordernum | varchar | 20 | in | |
| insert_sales_proc | P | @orderdate | varchar | 40 | in | |
| insert_salesdetail_proc | P | @stor_id | char | 4 | in | |
| insert_salesdetail_proc | P | @ord_num | varchar | 20 | in | |
| insert_salesdetail_proc | P | @title_id | tid | 6 | in | |
| insert_salesdetail_proc | P | @qty | smallint | 2 | in | |
| insert_salesdetail_proc | P | @discount | float | 8 | in | |
| storeid_proc | P | @stor_id | char | 4 | in | |
| storename_proc | P | @stor_name | varchar | 40 | in | |
| title_proc | P | @title | varchar | 80 | in | |
| titleid_proc | P | @title_id | varchar | 80 | in |