<?xml version="1.0" encoding="utf-8"?><Database Name="EMR_SS_Single" Class="LINQ_FinanceDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=43.228.125.24;Initial Catalog=EMR_SS_Single;User ID=RGBDeveloper" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="EMR_SS_SingleConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.Fin_ExpenseSession" Member="Fin_ExpenseSessions">
    <Type Name="Fin_ExpenseSession">
      <Column Name="ExpenseSessionID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ExpenseCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="SessionTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="AccountCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="SearchWords" 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.Fin_ExpenseSessionView" Member="Fin_ExpenseSessionViews">
    <Type Name="Fin_ExpenseSessionView">
      <Column Name="ExpenseSessionID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ExpenseCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="SessionTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="AccountCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="SearchWords" 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" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_IncomeSession" Member="Fin_IncomeSessions">
    <Type Name="Fin_IncomeSession">
      <Column Name="IncomeSessionID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IncomeCode" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
      <Column Name="SessionTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="AccountCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="SearchWord" 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.Fin_IncomeSessionView" Member="Fin_IncomeSessionViews">
    <Type Name="Fin_IncomeSessionView">
      <Column Name="IncomeSessionID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IncomeCode" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
      <Column Name="SessionTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="AccountCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="SearchWord" 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="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.Fin_Income" Member="Fin_Incomes">
    <Type Name="Fin_Income">
      <Column Name="IncomeID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="IncomeCode" Type="System.String" DbType="NVarChar(300) NOT NULL" CanBeNull="false" />
      <Column Name="IncomeOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="IncomeNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IncomeSessionID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OperatorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CustomerID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IncomeStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AdminNote" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="HashKeys" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Amount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <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.Fin_IncomeView" Member="Fin_IncomeViews">
    <Type Name="Fin_IncomeView">
      <Column Name="IncomeID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="IncomeCode" Type="System.String" DbType="NVarChar(300) NOT NULL" CanBeNull="false" />
      <Column Name="IncomeOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="IncomeNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IncomeSessionID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OperatorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CustomerID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="IncomeStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AdminNote" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="HashKeys" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Active" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <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="OperatorName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="OperatorCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <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="SessionTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Amount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_PO" Member="Fin_POs">
    <Type Name="Fin_PO">
      <Column Name="POID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="PONo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="InternalPONo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PODate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="CreditDueDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SalePersonID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="TotalItemCost" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Other1Title" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Other1Amount" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Other2Title" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Other2Amount" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Currency" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="VoucherPayAmount" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CommercialTaxPercent" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="CommercialTax" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CreditPaidAmount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="PaymentStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <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="ApprovedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_POItem" Member="Fin_POItems">
    <Type Name="Fin_POItem">
      <Column Name="POItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="POID" 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="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="POQty" Type="System.Decimal" DbType="Decimal(18,1)" 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="TotalPOQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Price" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CurrencyExchangeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <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="FOCQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="DiscountPercentage" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalDiscount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FinalPrice" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="ReceivedQty" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="RemainingQty" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_POView" Member="Fin_POViews">
    <Type Name="Fin_POView">
      <Column Name="POID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PONo" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="InternalPONo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PODate" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
      <Column Name="CreditDueDate" Type="System.DateTime" DbType="Date" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="SalePersonID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Status" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="TotalItemCost" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Other1Title" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Other1Amount" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Other2Title" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="Other2Amount" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="Currency" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="VoucherPayAmount" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CreditPaidAmount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(18,2) NOT NULL" CanBeNull="false" />
      <Column Name="PaymentStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <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="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="SupplierCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierName" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="CommercialTax" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CommercialTaxPercent" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Received" Type="System.Decimal" DbType="Decimal(38,2)" CanBeNull="true" />
      <Column Name="Remain" Type="System.Decimal" DbType="Decimal(38,2)" CanBeNull="true" />
      <Column Name="TotalPOQty" Type="System.Decimal" DbType="Decimal(38,0)" CanBeNull="true" />
      <Column Name="ApprovedBy" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="UserName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_POItemView" Member="Fin_POItemViews">
    <Type Name="Fin_POItemView">
      <Column Name="POItemID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="POID" 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="GenericID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="POQty" Type="System.Decimal" DbType="Decimal(18,1)" 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="TotalPOQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Price" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="CurrencyExchangeID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="TotalCost" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <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="PONo" 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="GenericName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
      <Column Name="UomLabel" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CurrencyExchangeName" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="CurrencyExchangeCode" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="CurrencyExchangeRate" Type="System.Decimal" DbType="Decimal(18,2)" 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="UOMCombineLabels" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="UOMCombineIDs" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="FOCQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="DiscountPercentage" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="TotalDiscount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Balance" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="FinalPrice" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="ReceivedQty" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="RemainingQty" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="SupplierName" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="ApprovedByName" Type="System.String" DbType="NVarChar(150)" CanBeNull="true" />
      <Column Name="TotalUnitQty" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_Expense" Member="Fin_Expenses">
    <Type Name="Fin_Expense">
      <Column Name="ExpenseID" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="ExpenseCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ExpenseOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="ExpenseNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExpenseSessionID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OperatorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CustomerID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExpenseStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AdminNote" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Hashkeys" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Amount" 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="RefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.Fin_ExpenseView" Member="Fin_ExpenseViews">
    <Type Name="Fin_ExpenseView">
      <Column Name="ExpenseID" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="ExpenseCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="ExpenseOn" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Description" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="ExpenseNo" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExpenseSessionID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="OperatorID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="CustomerID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="SupplierID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ExpenseStatus" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="AdminNote" Type="System.String" DbType="NVarChar(1000)" CanBeNull="true" />
      <Column Name="Seq" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="Hashkeys" Type="System.String" DbType="NVarChar(300)" 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="OperatorName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <Column Name="OperatorCode" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
      <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="SessionTitle" Type="System.String" DbType="NVarChar(300)" CanBeNull="true" />
      <Column Name="Amount" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="RefID" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </Type>
  </Table>
  <Function Name="dbo.Monthly_Cash_Flow" Method="Monthly_Cash_Flow">
    <Parameter Name="StartDate" Parameter="startDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="EndDate" Parameter="endDate" Type="System.DateTime" DbType="Date" />
    <ElementType Name="Monthly_Cash_FlowResult">
      <Column Name="Label" Type="System.String" DbType="VarChar(7) NOT NULL" CanBeNull="false" />
      <Column Name="Income" Type="System.Decimal" DbType="Decimal(38,0)" CanBeNull="true" />
      <Column Name="Expense" Type="System.Decimal" DbType="Decimal(38,0)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Monthly_Cash_Flow_detail" Method="Monthly_Cash_Flow_detail">
    <Parameter Name="StartDate" Parameter="startDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="EndDate" Parameter="endDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="Type" Parameter="type" Type="System.String" DbType="NVarChar(50)" />
    <ElementType Name="Monthly_Cash_Flow_detailResult">
      <Column Name="datee" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Amount" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
      <Column Name="Label" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Monthly_session_income" Method="Monthly_session_income">
    <Parameter Name="StartDate" Parameter="startDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="EndDate" Parameter="endDate" Type="System.DateTime" DbType="Date" />
    <ElementType Name="Monthly_session_incomeResult">
      <Column Name="sessiones" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="per" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
    </ElementType>
  </Function>
  <Function Name="dbo.Monthly_session_expense" Method="Monthly_session_expense">
    <Parameter Name="StartDate" Parameter="startDate" Type="System.DateTime" DbType="Date" />
    <Parameter Name="EndDate" Parameter="endDate" Type="System.DateTime" DbType="Date" />
    <ElementType Name="Monthly_session_expenseResult">
      <Column Name="sessiones" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="per" Type="System.Decimal" DbType="Decimal(18,2)" CanBeNull="true" />
    </ElementType>
  </Function>
</Database>