<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/bc/mtc/bcmtc1119m000" xml:lang="en">
   <Header>
      <Title>Conversion Table for Items (bcmtc1119m000)</Title>
   </Header>
   <HelpTopic>
      <AimSection>
         <Paragraph>Table is created to determine which items to migrate, for
		  example to prevent migrating items twice and causing duplicates in ERP LN 6.1.</Paragraph>
      </AimSection>
      <GeneralSection>
         <SectionTitle>Preparation</SectionTitle>
         <Paragraph>Fill table by premigration run.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Execution</SectionTitle>
         <Paragraph>It is always mandatory to run this session.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Process logic</SectionTitle>
         <Paragraph>Because some queries are not supported by the database a
		  workaround has been created. All items from MANDB.IM and FINDB.PROMAS are
		  placed in the mapping table for items <GUIRef href="" role="manual">bcmtc119</GUIRef>. Some items
		  appear in both manman tables. ERP LN 6.1 only needs one version of each item. After running the specific
		  command <GUIRef href="" role="manual">Determine Items to Migrate</GUIRef> it is garanteed that no
		  duplicate items will exist among items with migrate flag switched on. The data
		  cannot be changed manually: the user can only execute Specific command.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Duration</SectionTitle>
         <Paragraph>Session will take some time depending on the number of items
		  in table <GUIRef href="" role="manual">bcmtc119</GUIRef>.</Paragraph>
      </GeneralSection>
   </HelpTopic>
   <Fields>
      <FieldHelp ID="bcmtc119.orig">
         <Header>
            <Title>MANMAN Origin Table</Title>
         </Header>
         <FuncDesc>Field is filled during premigration and cannot be edited by
		  user.</FuncDesc>
         <AllowedValues>
            <SectionTitle>Allowed values</SectionTitle>
            <Paragraph>FINDB_PROMAS or MANDB_IM</Paragraph>
         </AllowedValues>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.item">
         <Header>
            <Title>MANMAN Item Code</Title>
         </Header>
         <FuncDesc>Field is filled during premigration and cannot be edited by
		  user.</FuncDesc>
         <AllowedValues>
            <SectionTitle>Allowed values</SectionTitle>
            <Paragraph>Items from tables FINDB.PROMAS and MANDB.IM</Paragraph>
         </AllowedValues>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.dsca">
         <Header>
            <Title>MANMAN Item Description</Title>
         </Header>
         <FuncDesc>The description of the Item.</FuncDesc>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.cuni">
         <Header>
            <Title>Unit</Title>
         </Header>
         <FuncDesc/>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.ptyp">
         <Header>
            <Title>Item Product Type</Title>
         </Header>
         <FuncDesc/>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.acti">
         <Header>
            <Title>Product Active</Title>
         </Header>
         <FuncDesc/>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.ctyo">
         <Header>
            <Title>Country of Origin</Title>
         </Header>
         <FuncDesc/>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.ccde">
         <Header>
            <Title>Commodity Code</Title>
         </Header>
         <FuncDesc/>
      </FieldHelp>
      <FieldHelp ID="bcmtc119.migr">
         <Header>
            <Title>Migrate</Title>
         </Header>
         <FuncDesc>Field is filled by executing specic command <GUIRef href="" role="manual">Determine Items to Migrate</GUIRef> and cannot be edited by user.</FuncDesc>
         <AllowedValues>
            <SectionTitle>Allowed values</SectionTitle>
            <Paragraph>The allowed values are Yes or No.</Paragraph>
         </AllowedValues>
      </FieldHelp>
   </Fields>
   <FormCommands>
      <CommandHelp ID="validate.record">
         <Header>
            <Title>Validate</Title>
         </Header>
         <FuncDesc>Click <GUIRef href="" role="manual">Validate</GUIRef> to check references, duplicates
		  and if all mandatory fields are filled. A so called integrity check of the
		  supplied data. It is mandatory to run validate.</FuncDesc>
      </CommandHelp>
      <CommandHelp ID="find.items.to.migrate">
         <Header>
            <Title>Determine Items to Migrate</Title>
         </Header>
         <FuncDesc>This Specific command will switch on the migrate flag for all
		  items that need migration.</FuncDesc>
      </CommandHelp>
   </FormCommands>
</Session>