<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/ti/onlinemanual/000397" xml:lang="en">
   <Header>
      <Title>Data mapping: import data from Microsoft Project to PCS</Title>
      <Keyword type="header" order="d1e2078720">
         <Level1>PCS</Level1>
         <Level2>integration with Microsoft Project</Level2>
      </Keyword>
      <Keyword type="header" order="d1e2078725">
         <Level1>Microsoft Project</Level1>
      </Keyword>
   </Header>
   <GeneralSection>
      <Paragraph>If you work on Microsoft Project, use the <Link href="/baanerp/ti/pcs/tipcs4172m000" role="session">
            <GUIRef href="/baanerp/ti/pcs/tipcs4172m000" role="session">Export / Import PCS Activities via XML (tipcs4172m000)</GUIRef>
         </Link> session to transfer
		project data from Microsoft Project to <GUIRef href="/baanerp/ti/pcs" role="module">Project Control</GUIRef> in LN. The table shows how
		data in Microsoft Project matches the data in . <GUIRef href="/baanerp/ti/pcs" role="module">Project Control</GUIRef>. Only a limited number of fields in <GUIRef href="/baanerp/ti/pcs" role="module">Project Control</GUIRef> is
		updated.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated">
         <TBODY noTR="11">
            <TR no="1" isLast="false">
               <TH width="198" rowspan="1" colspan="1">Microsoft
				Project task field (in XML)</TH>
               <TH width="277" rowspan="1" colspan="1">LN activity field code</TH>
               <TH width="237" rowspan="1" colspan="1">LN field name</TH>
            </TR>
            <TR no="2" isLast="false">
               <TD width="198" rowspan="1" colspan="1">EarlyStart</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.esdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.esdt" role="manual">Earliest Start Date</GUIRef>
               </TD>
            </TR>
            <TR no="3" isLast="false">
               <TD width="198" rowspan="1" colspan="1">LateStart</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.lsdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.lsdt" role="manual">Latest Start Date</GUIRef>
               </TD>
            </TR>
            <TR no="4" isLast="false">
               <TD width="198" rowspan="1" colspan="1">EarlyFinish</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.efdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.efdt" role="manual">Earliest End Date</GUIRef>
               </TD>
            </TR>
            <TR no="5" isLast="false">
               <TD width="198" rowspan="1" colspan="1">LateFinish</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.lfdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.lfdt" role="manual">Latest End Date</GUIRef>
               </TD>
            </TR>
            <TR no="6" isLast="false">
               <TD width="198" rowspan="1" colspan="1">Start</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.dsdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dsdt" role="manual">Desired Start Date</GUIRef>
               </TD>
            </TR>
            <TR no="7" isLast="false">
               <TD width="198" rowspan="1" colspan="1">Finish</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.dfdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.dfdt" role="manual">Desired End Date</GUIRef>
               </TD>
            </TR>
            <TR no="8" isLast="false">
               <TD width="720" colspan="3" rowspan="1">The following fields are
				only updated if the <Link href="/baanerp/ti/pcs/tipcs4502m000#tipcs400.aupc" role="formfield">Automatic Update</Link> check box in the <GUIRef href="/baanerp/ti/pcs/tipcs4502m000" role="session">Activity Overview by Project (tipcs4502m000)</GUIRef> session is cleared:</TD>
            </TR>
            <TR no="9" isLast="false">
               <TD width="198" rowspan="1" colspan="1">PercentComplete</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.pctc</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.pctc" role="manual">Automatic Update of Percentage Completed</GUIRef>
               </TD>
            </TR>
            <TR no="10" isLast="false">
               <TD width="198" rowspan="1" colspan="1">ActualStart</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.asdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.asdt" role="manual">Actual Start Date</GUIRef>
               </TD>
            </TR>
            <TR no="11" isLast="true">
               <TD width="198" rowspan="1" colspan="1">ActualFinish</TD>
               <TD width="277" rowspan="1" colspan="1">tipcs400.afdt</TD>
               <TD width="237" rowspan="1" colspan="1">
                  <GUIRef href="/baanerp/ti/pcs/tipcs4101m000#tipcs400.afdt" role="manual">Actual End Date</GUIRef>
               </TD>
            </TR>
         </TBODY>
      </TABLE>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/ti/onlinemanual/000395" role="manual">Integration between PCS and Microsoft Project</Link>
      </RelTopic>
      <RelTopic>
         <Link href="/baanerp/ti/onlinemanual/000396" role="manual">Data mapping: export data from PCS to Microsoft Project</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>