using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.Query.PackNumber
{
    public static class PackNumberQB
    {
        public const string GET_SELECTLIST_PACKNUMBER = @"SELECT
                            PN.PACKNUMBERID AS PackNumberPicklistId,
                            PN.PACKNUMBER AS PackNumberPicklistNumber,
                            L.LOTNUMBER AS LotNumber,
                            PN.GOODQUANTITY AS Quantity,
                            PN.STATUS AS PackNumberStatus
                            FROM TPACKNUMBER PN
                            LEFT JOIN TLOT L ON PN.LOTID = L.LOTID;
                            ";
    }
}