MIS QUESTION [message #89697] |
Mon, 28 June 2004 07:30 |
gary
Messages: 35 Registered: January 2001
|
Member |
|
|
One great challenge question of sorting and db.
Here is the following:
1. invoice number, 2. invoice date,3. shipment lot 4. sutomer name/code, 5 sales group, 6. contract no/Lot, 7 item code, 8.Qty shipped, 9. Vessel name /Voy, 10. on board date, 11. FX, 12. Unit Price, 13. Charges/deductions amt, 14. Invoice amount, 15. Export LC no. 16, LC Tendor, 17 Negotiation bank, 18. Bank in date, 19. Bills umber, 20 Due date, 21. Payment date.
AS u can see the sorting for the question
sort by invoice no.=invoice no. +item no.
sort by contract no. =s/o no. +???? + ??? + ????
sort by Sales Group = sales group +???? + ??? + ????
sort by item code = item code+???? + ??? + ????
sort by bank in date =bank in date+???? + ??? + ????
sort by accepted date/not accepted = accepted date +???? + ??? + ????
Pls note: beware that accepted date = blank always sort before accepted date note = blank
sort by paid/not paid. = paid day +???? + ??? + ????
|
|
|