SV010001 PJ010001 SIS.sch CHGEN v9.0 CHGEN TT000001 SV010001 Supplier SU /*a supplier of some items we buy */ TT000002 SV010001 Warehouse WH /* where vendor stores items */ TT000003 SV010001 Item IT /* an item supplied by a vendor */ TA000001 TT000001 SUid NA c8 1 /* unique pkey of SUpplier */ /* Note that spaces are preserved in the final field above */ TA000002 TT000001 name NA c24 0 /* name of company we buy from */ TA000003 TT000001 expDate NA c10 0 /* last date price quotes are */ TA000004 TT000002 WHid NA c8 1 /* unique pkey of WareHouse */ TA000005 TT000002 SUid NA c24 0 /* unique fkey(xref to SUpplier*/ TA000006 TT000002 phone NA c10 0 /*warehouse phone number */ TA000007 TT000002 address NA t80 0 /* address of warehouse */ TA000008 TT000003 ITid NA c8 1 /* unique pkey of ITem */ TA000009 TT000003 WHid NA c8 1 /* unique fkey (xref to WareHou*/ TA000010 TT000003 ourItemNo NA i4 0 /* our integer part identifier*/ TA000011 TT000003 vendorCode NA c12 0 /* vendor?s item code */ TA000012 TT000003 unitPrice NA i4 0 /* vendor price in $/100 */ TA000013 TT000003 unitQuant NA i4 0 /* quantity in packag */ TA000014 TT000003 itemDesc NA t80 0 /* item description */