﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="1.0.0.0" Name="PDDBHEADERSORA" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
  <Properties>
    <Property Name="WildCardCharacter" Type="System.String">%</Property>
  </Properties>
  <LobSystemInstances>
    <LobSystemInstance Name="PDSOHEADERS">
      <Properties>
        <Property Name="NumberOfConnections" Type="System.Int32">-1</Property>
        <Property Name="RdbConnectionData Source" Type="System.String">ORADB</Property>
        <Property Name="RdbConnectionOmit Oracle Connection Name" Type="System.String">True</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">Oracle</Property>
        <Property Name="SsoApplicationId" Type="System.String">ORA</Property>
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RdbCredentials</Property>
      </Properties>
    </LobSystemInstance>
  </LobSystemInstances>
  <Entities>
    <Entity EstimatedInstanceCount="10000" Name="PDSOHEADERS">
      <Properties>
        <Property Name="DefaultAction" Type="System.String">View Profile</Property>
      </Properties>
      <Identifiers>
        <Identifier TypeName="System.Decimal" Name="HEADER_ID" />
      </Identifiers>
      <Methods>
        <Method Name="GetPDSOHEADERS">
          <Properties>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
            <Property Name="RdbCommandText" Type="System.String">SELECT HEADER_ID, CUSTOMER_PO_NUMBER, ORDER_NUMBER, ORDER_ADMIN_NAME, ORDER_DATE, CUSTOMER_NAME, ORIG_SYSTEM_REFERENCE, PD_LAST_UPDATED_DATE, ORDER_ADMIN_EMAIL, CUSTOMER_REQUEST_DATE, EXPECTED_SHIP_DATE, ECEPTED_PROJECT_CLOSE_DATE, ACTUAL_PROJECT_CLOSE_DATE, PROJECT_MANAGER, SERVICE_STATUS, TRACKING_NUMBER, INSTALLED_AT, ORDER_STATUS, PROJECT_MNG_EMAIL FROM PD_SO_HEADERS WHERE (HEADER_ID &gt;= :GeneratedMinHEADER_ID) AND (HEADER_ID &lt;= :GeneratedMaxHEADER_ID)</Property>
          </Properties>
          <FilterDescriptors>
            <FilterDescriptor Type="ExactMatch" Name="HEADER_ID" />
          </FilterDescriptors>
          <Parameters>
            <Parameter Direction="In" Name=":GeneratedMinHEADER_ID">
              <TypeDescriptor TypeName="System.Decimal" IdentifierName="HEADER_ID" AssociatedFilter="HEADER_ID" Name="HEADER_ID">
                <DefaultValues>
                  <DefaultValue MethodInstanceName="PDSOHEADERSFinder" Type="System.Decimal">0</DefaultValue>
                  <DefaultValue MethodInstanceName="PDSOHEADERSSpecificFinder" Type="System.Decimal">0</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction="In" Name=":GeneratedMaxHEADER_ID">
              <TypeDescriptor TypeName="System.Decimal" IdentifierName="HEADER_ID" AssociatedFilter="HEADER_ID" Name="HEADER_ID">
                <DefaultValues>
                  <DefaultValue MethodInstanceName="PDSOHEADERSFinder" Type="System.Decimal">9999999</DefaultValue>
                  <DefaultValue MethodInstanceName="PDSOHEADERSSpecificFinder" Type="System.Decimal">9999999</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction="Return" TypeReflectorTypeName="Microsoft.Office.Server.ApplicationRegistry.Infrastructure.DotNetTypeReflector" Name="PD_SO_HEADERSs">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="PD_SO_HEADERSDataReader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="PD_SO_HEADERSDataRecord">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Decimal" IdentifierName="HEADER_ID" Name="HEADER_ID" />
                      <TypeDescriptor TypeName="System.String" Name="CUSTOMER_PO_NUMBER" />
                      <TypeDescriptor TypeName="System.Decimal" Name="ORDER_NUMBER" />
                      <TypeDescriptor TypeName="System.String" Name="ORDER_ADMIN_NAME" />
                      <TypeDescriptor TypeName="System.DateTime" Name="ORDER_DATE" />
                      <TypeDescriptor TypeName="System.String" Name="CUSTOMER_NAME" />
                      <TypeDescriptor TypeName="System.String" Name="ORIG_SYSTEM_REFERENCE" />
                      <TypeDescriptor TypeName="System.DateTime" Name="PD_LAST_UPDATED_DATE" />
                      <TypeDescriptor TypeName="System.String" Name="ORDER_ADMIN_EMAIL" />
                      <TypeDescriptor TypeName="System.DateTime" Name="CUSTOMER_REQUEST_DATE" />
                      <TypeDescriptor TypeName="System.DateTime" Name="EXPECTED_SHIP_DATE" />
                      <TypeDescriptor TypeName="System.DateTime" Name="ECEPTED_PROJECT_CLOSE_DATE" />
                      <TypeDescriptor TypeName="System.DateTime" Name="ACTUAL_PROJECT_CLOSE_DATE" />
                      <TypeDescriptor TypeName="System.String" Name="PROJECT_MANAGER" />
                      <TypeDescriptor TypeName="System.String" Name="SERVICE_STATUS" />
                      <TypeDescriptor TypeName="System.String" Name="TRACKING_NUMBER" />
                      <TypeDescriptor TypeName="System.String" Name="INSTALLED_AT" />
                      <TypeDescriptor TypeName="System.String" Name="ORDER_STATUS" />
                      <TypeDescriptor TypeName="System.String" Name="PROJECT_MNG_EMAIL" />
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="Finder" ReturnParameterName="PD_SO_HEADERSs" ReturnTypeDescriptorName="PD_SO_HEADERSDataReader" ReturnTypeDescriptorLevel="0" Name="PDSOHEADERSFinder" />
            <MethodInstance Type="SpecificFinder" ReturnParameterName="PD_SO_HEADERSs" ReturnTypeDescriptorName="PD_SO_HEADERSDataReader" ReturnTypeDescriptorLevel="0" Name="PDSOHEADERSSpecificFinder" />
          </MethodInstances>
        </Method>
      </Methods>
      <Actions>
        <Action Name="View Profile" Position="1" IsOpenedInNewWindow="false" Url="http://moss:45841/ssp/admin/Content/PDSOHEADERS.aspx?HEADER_ID={0}" ImageUrl="/_layouts/images/viewprof.gif">
          <ActionParameters>
            <ActionParameter Name="HEADER_ID" Index="0" />
          </ActionParameters>
        </Action>
      </Actions>
    </Entity>
  </Entities>
</LobSystem>
