<?xml version="1.0" encoding="utf-8"?><Database Name="EMR_SS_SSB" Class="LINQ_INVDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=18.138.168.108;Initial Catalog=EMR_SS_SSB;User ID=RGBDeveloper" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="EMR_SS_SingleConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.INV_StoreReceipt" Member="INV_StoreReceipts">
    <Type Name="INV_StoreReceipt">
      <Column Name="ReceiptID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ReceiptNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReceiptStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SRRefType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SRRefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SRRefNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Reason" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreReceiptView" Member="INV_StoreReceiptViews">
    <Type Name="INV_StoreReceiptView">
      <Column Name="ReceiptID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ReceiptNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReceiptStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SRRefType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SRRefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SRRefNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Reason" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SupplierName" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="ReceiptPersonName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ReceiptPersonCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_LocationMove" Member="INV_LocationMoves">
    <Type Name="INV_LocationMove">
      <Column Name="LocationMoveID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="MoveNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MoveDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationIDFrom" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationIDTo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_LocationMoveView" Member="INV_LocationMoveViews">
    <Type Name="INV_LocationMoveView">
      <Column Name="LocationMoveID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MoveNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MoveDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationIDFrom" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationIDTo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FromLocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="FromLocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="ToLocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ToLocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_AdjustmentItem" Member="INV_AdjustmentItems">
    <Type Name="INV_AdjustmentItem">
      <Column Name="AdjustmentItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="AdjustmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ActualQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="SystemQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_AdjustmentItemView" Member="INV_AdjustmentItemViews">
    <Type Name="INV_AdjustmentItemView">
      <Column Name="AdjustmentItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ActualQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="SystemQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AdjustmentDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustmentNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_LocationMoveItem" Member="INV_LocationMoveItems">
    <Type Name="INV_LocationMoveItem">
      <Column Name="LocationMoveItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="LocationMoveID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MoveQuantity" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalMoveQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_MR" Member="INV_MRs">
    <Type Name="INV_MR">
      <Column Name="MRID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="MRNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MRDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="MRType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestToID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MRStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SuperApprovedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedRemark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StatusRemark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockException" Member="INV_StockExceptions">
    <Type Name="INV_StockException">
      <Column Name="StockExceptionID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ExceptionNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Date" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="UserName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExceptionType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StatusBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StatusOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="FromLocation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ToLocation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromStation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ToStation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockExceptionView" Member="INV_StockExceptionViews">
    <Type Name="INV_StockExceptionView">
      <Column Name="StockExceptionID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Date" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="UserName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExceptionType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StatusOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ToLocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="FromLocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ToStationName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromStationName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromLocation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ToLocation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FromStation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ToStation" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="StatusBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StatusByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="ExceptionNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockExceptionItem" Member="INV_StockExceptionItems">
    <Type Name="INV_StockExceptionItem">
      <Column Name="StockExceptionItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="StockExceptionID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemUOMID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="QTY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Price" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Cost" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreReceiptItem" Member="INV_StoreReceiptItems">
    <Type Name="INV_StoreReceiptItem">
      <Column Name="ReceiptItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ReceiptID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalReceiptQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockFlow" Member="INV_StockFlows">
    <Type Name="INV_StockFlow">
      <Column Name="StockFlowID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="FlowOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="FlowBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FlowQty" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="FlowTitle" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FlowType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="OwnerRefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OwnerRefType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Channel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreIssue" Member="INV_StoreIssues">
    <Type Name="INV_StoreIssue">
      <Column Name="IssueID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IssueNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="MRID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="IssueStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_Adjustment" Member="INV_Adjustments">
    <Type Name="INV_Adjustment">
      <Column Name="AdjustmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="AdjustmentNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustmentDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_AdjustmentView" Member="INV_AdjustmentViews">
    <Type Name="INV_AdjustmentView">
      <Column Name="AdjustmentID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustmentNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="AdjustmentDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_LocationMoveItemView" Member="INV_LocationMoveItemViews">
    <Type Name="INV_LocationMoveItemView">
      <Column Name="LocationMoveItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationMoveID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MoveQuantity" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalMoveQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MoveNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockRequest" Member="INV_StockRequests">
    <Type Name="INV_StockRequest">
      <Column Name="StockRequestID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="RequestOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="RequestQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="TotalRequestQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalIssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="RemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalRemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="DefaultUnit" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestTitle" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationGroup" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockExceptionItemView" Member="INV_StockExceptionItemViews">
    <Type Name="INV_StockExceptionItemView">
      <Column Name="StockExceptionItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="QTY" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Cost" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Price" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockExceptionID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemUOMID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreReceiptItemView" Member="INV_StoreReceiptItemViews">
    <Type Name="INV_StoreReceiptItemView">
      <Column Name="ReceiptItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ReceiptID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ReceiptQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ReceiptNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ReceiptStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Reason" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ReceiptByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierName" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="ReceiptPersonName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="itemGroupType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemUOMID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(19,0) NOT NULL" CanBeNull="false" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalReceiptQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_ExpireIn" Member="INV_ExpireIns">
    <Type Name="INV_ExpireIn">
      <Column Name="ItemExpireID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ExpireDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Qty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="NewItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockflowID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.INV_ExpireInView" Member="INV_ExpireInViews">
    <Type Name="INV_ExpireInView">
      <Column Name="ItemExpireID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ExpireDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="Qty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="NewItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockflowID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ItemIDFromSI" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreIssueView" Member="INV_StoreIssueViews">
    <Type Name="INV_StoreIssueView">
      <Column Name="IssueID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IssueNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="MRID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="IssueStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MRNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssuePersonCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="IssuePersonName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_MRItem" Member="INV_MRItems">
    <Type Name="INV_MRItem">
      <Column Name="MRItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="MRID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="RemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalRemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="QTYBeforeApprove" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_MRItemView" Member="INV_MRItemViews">
    <Type Name="INV_MRItemView">
      <Column Name="MRItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MRID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="MRNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalRemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="MRDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="MRType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SuperApprovedByUser" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="MRStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AprrovedByUser" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="QTYBeforeApprove" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockInView" Member="INV_StockInViews">
    <Type Name="INV_StockInView">
      <Column Name="StockInID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StockInNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StockInStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SupplierName" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="SupplierCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInSupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_ExpireUniqRecordView" Member="INV_ExpireUniqRecordViews">
    <Type Name="INV_ExpireUniqRecordView">
      <Column Name="NewItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExpireDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreIssueItem" Member="INV_StoreIssueItems">
    <Type Name="INV_StoreIssueItem">
      <Column Name="IssueItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IssueID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssuedQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueBarcodes" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssuedUOM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueRemarks" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInHand" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalIssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="OtherIssue" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="OtherTotalIssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="StationBalanceQTY" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="RejectQTY" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ReceiveQTY" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockIn" Member="INV_StockIns">
    <Type Name="INV_StockIn">
      <Column Name="StockInID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="StockInNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InvoiceNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="StockInStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StockInSupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockInItem" Member="INV_StockInItems">
    <Type Name="INV_StockInItem">
      <Column Name="StockInItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="StockInID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalInQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Price" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="CurrencyExchangeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ManufactureID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StoreIssueItemView" Member="INV_StoreIssueItemViews">
    <Type Name="INV_StoreIssueItemView">
      <Column Name="IssueItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IssueID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssuedQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueBarcodes" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssuedUOM" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IssueRemarks" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="RequestQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueNo" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="IssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemUOMID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StockInHand" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalIssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalRemainQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="IssueOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="IssueStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="MRNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="MRID" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="OtherIssue" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="OtherTotalIssueQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="StationBalanceQTY" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="RejectQTY" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ReceiveQTY" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="PrimaryItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_StockInItemView" Member="INV_StockInItemViews">
    <Type Name="INV_StockInItemView">
      <Column Name="StockInItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StockInID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="InQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="UnitID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="DefaultUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalInQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Price" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="CurrencyExchangeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="StockInNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CurrencyExchangeCode" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="CurrencyExchangeName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="CurrencyExchangeRate" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="SupplierCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierName" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="ManufactureID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CountryName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IsNeedExpire" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="RefQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="PrimaryItemID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.INV_MRVIew" Member="INV_MRVIews">
    <Type Name="INV_MRVIew">
      <Column Name="MRID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="MRNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="MRDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="MRType" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestByID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestToID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ApprovedRemark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="CreatedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CreatedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedBy" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedOn" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="LastAction" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ModifiedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="CreatedByCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="RequestByUser" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="AprrovedByUser" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="MRStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StatusRemark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SuperApprovedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SuperApprovedByUser" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="RequestToUser" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Function Name="dbo.INV_Stock_Request_Summary_By_Item" Method="INV_Stock_Request_Summary_By_Item">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="stationId" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Request_Summary_By_ItemResult">
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ShortCode1" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="TotalRequest" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="RemainQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="TotalRequestQty" Type="System.String" DbType="NVarChar(81)" CanBeNull="true" />
      <Column Name="Remain" Type="System.String" DbType="NVarChar(81)" CanBeNull="true" />
      <Column Name="Closing" Type="System.String" DbType="NVarChar(81)" CanBeNull="true" />
      <Column Name="EstimateRemain" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_Request_Detail_By_Item" Method="INV_Stock_Request_Detail_By_Item">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="stationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Request_Detail_By_ItemResult">
      <Column Name="RefDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="itemid" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="RequestTitle" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RequestQty" Type="System.String" DbType="NVarChar(81)" CanBeNull="true" />
      <Column Name="IssueQty" Type="System.String" DbType="NVarChar(81)" CanBeNull="true" />
      <Column Name="RemainQty" Type="System.String" DbType="NVarChar(81)" CanBeNull="true" />
      <Column Name="ItemID1" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="StationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="StationName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_Flow_Summary" Method="INV_Stock_Flow_Summary">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="regionid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="stationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="townshipid" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Flow_SummaryResult">
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="WarningLevelQuantity" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Opening" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
      <Column Name="Opening_Label" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
      <Column Name="inqty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="In_Label" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="outQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Out_Label" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Closing" Type="System.Decimal" DbType="Decimal(22,2) NOT NULL" CanBeNull="false" />
      <Column Name="Closing_label" Type="System.Decimal" DbType="Decimal(22,2) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_Flow_Detail_By_Item" Method="INV_Stock_Flow_Detail_By_Item">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="regionid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="stationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="townshipid" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Flow_Detail_By_ItemResult">
      <Column Name="RefDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FlowType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="itemid" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FlowTitle" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="InQty" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="In_Label" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="OutQty" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Out_Label" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="ItemID1" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="balance" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_Flow_Summary_By_Item" Method="INV_Stock_Flow_Summary_By_Item">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Flow_Summary_By_ItemResult">
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="WarningLevelQuantity" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Opening" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
      <Column Name="Opening_Label" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
      <Column Name="inqty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="In_Label" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="outQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Out_Label" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Closing" Type="System.Decimal" DbType="Decimal(22,2) NOT NULL" CanBeNull="false" />
      <Column Name="Closing_label" Type="System.Decimal" DbType="Decimal(22,2) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Noti" Method="INV_Noti">
    <ElementType Name="INV_NotiResult">
      <Column Name="Type" Type="System.String" DbType="VarChar(14) NOT NULL" CanBeNull="false" />
      <Column Name="Noti" Type="System.Int32" DbType="Int" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_BalanceCheck" Method="INV_Stock_BalanceCheck">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_BalanceCheckResult">
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="WarningLevelQuantity" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Opening" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_Flow_SummaryForFFS" Method="INV_Stock_Flow_SummaryForFFS">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="regionid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="stationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="townshipid" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Flow_SummaryForFFSResult">
      <Column Name="ItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="WarningLevelQuantity" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Opening" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
      <Column Name="Opening_Label" Type="System.Decimal" DbType="Decimal(19,2) NOT NULL" CanBeNull="false" />
      <Column Name="inqty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="In_Label" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="outQty" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Out_Label" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="Closing" Type="System.Decimal" DbType="Decimal(22,2) NOT NULL" CanBeNull="false" />
      <Column Name="Closing_label" Type="System.Decimal" DbType="Decimal(22,2) NOT NULL" CanBeNull="false" />
    </ElementType>
  </Function>
  <Function Name="dbo.INV_Stock_Flow_Detail_By_Item_ForFFS" Method="INV_Stock_Flow_Detail_By_Item_ForFFS">
    <Parameter Name="fromdate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="toDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="itemid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="locationgroup" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="regionid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="stationid" Type="System.String" DbType="NVarChar(50)" />
    <Parameter Name="townshipid" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="INV_Stock_Flow_Detail_By_Item_ForFFSResult">
      <Column Name="RefDate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RefNo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SubRefID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="FlowType" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="itemid" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FlowTitle" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="InQty" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="In_Label" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="OutQty" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Out_Label" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="ItemID1" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ItemName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
      <Column Name="ItemGroupID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ItemGroupName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
      <Column Name="Remark" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="ShortCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="balance" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
      <Column Name="LocationID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LocationCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="LocationName" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
    </ElementType>
  </Function>
</Database>