saya newbie programming t-sql SQLServer2000, mendapat kesulitan membuat trigger untuk tabel
SALES_ORDER (Jual) dgn field
- Sales_Order_Number,
- Work_Order_Date,
- Employee_Code,
- External_Document_Number,
- Order_Date,
- Code_Customer,
- Expected_Shipment_Date,
- Code_Item --> ( foreign key ) link ke Tabel ITEM
- Quantity_Out --> Mengurangi Stock di Tabel ITEM
WAREHOUSE_RECEIPT (Barang Masuk) dgn field
- Receipt_Number
- Receipt_Date
- Employee_Code
- Purchase_Order_Number
- External_Number
- Warehouse_Code
- Code_Item --> ( foreign key ) link ke Tabel ITEM
- Quantity_In --> (menambah jumlah stock di Tabel ITEM)
ITEM
- Code_Item
--> ( primary key )
- Item_Description
- Stock
Terima Kasih Semuanya.
Apakah Anda Yahoo!?
Kunjungi halaman depan Yahoo! Indonesia yang baru! __._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Indonesia phone card | Programmer | Indonesia tour |
| Indonesia travel | Indonesia flower |
Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
