Balance ID browse - Sorting order

A maximum of 10 fields to sort by in the format N=X or; N=X etc. where N = field number and X = either A for ascending or D for descending.

Logic:

A. Ascending

D. Descending

Fields:

MMS060MI.LstBalID / LstBalIDByOrd

1. Item number (ITNO)

2. Item name (ITDS)

3.Location (WHSL)

4. Lot number (BANO)

5. Container (CAMU)

6. Lot reference 1 (BREF)

7. Lot reference 2 (BRE2)

8. Remark (BREM)

9. Status - balance ID (STAS)

10. Allocatable (ALOC)

11. Stock zone (SLTP)

12. Location type (WHLT)

13. On-hand balance approved (STQT)

14. Movable net 1 (MVB1)

15. Movable net 2 (MVB2)

16. Allocated quantity - basic U/M (ALQT)

17. Basic unit of measure (UNMS)

18. Catch weight (CAW2)

19. Priority date (PRDT)

20. Last receipt date (IDDT)

21. Last issue date (ODDT)

22. Latest physical inventory date (INDT)

23. Physical inventory in progress (INON)

24. Reclassification date (RCLS)

25. Status item (STAT)

26. Receiving number (REPN)

31. Item description (FUDS)

32. Attribute 1 (ATV1)

33. Attribute 2 (ATV2)

34. Attribute 3 (ATV3)

35. Attribute 4 (ATV4)

36. Attribute 5 (ATV5)

MMS060MI.LstBalIDByOrd only

27. Expiration date (EXPI)

28. Sales date (SEDT)

29. Best before date (BBDT)

30. Valid balance identity (VLID)

Note: 
  • Fields 27-30 are only applicable if parameter Enable option to browse balance identities is set to 2 (Yes. List based on allocation rules) and Browse is triggered from Report Pick Line screen.
  • Item description (31) and Attribute fields (32-36) are available only for M3 16+