Home » Developer & Programmer » Designer » RDBMS
RDBMS [message #90651] Mon, 28 June 2004 07:11
gary
Messages: 35
Registered: January 2001
Member
A very chanllege question about sorting and database .

Here is the following:

1. contract num,2. customer name/code, 3. sales group, 4 item code, 5. FX(from contract), 6. Contract amount, 7. Unit price, 8. Export LC no, 9. L/C tendor 10. FX (FROM LC) 11. LC Amount, 12, LC Qty, 13. Status (open or completed),14. Issue Bank, 15 issue date, 16. Advising Bank, 17. Latest shipment, 18. Expiry date, 19. tolerance, 20. Presentation date, 21. Invoice Date, 22. Invoice no, 23. Shipment Lot, 24. Qty shipped, 25. Amount Invoiced 26. L/C balance.

Here need a sort by define sort by contract no =S/O NO. +??? +?????

sort by customer name = cusmoter name +??? +????

sort by item code = item code +??? +????

sort by issue bank = issue bank +??? +????

sort by LC status = LC Status +??? +????

sort by LC Latest Shipment Date = Latest Shipment Date  +??? +????

sort by LC Expiry Date = Latest shipment date +??? +????

Any one know the answer

thanks

 
Previous Topic: ORACLE ER VIEWER
Next Topic: Reverse Engineering
Goto Forum:
  


Current Time: Thu Mar 28 10:00:18 CDT 2024