| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
