<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tf/onlinemanual/cus300" xml:lang="en">
   <Header>
      <Title>Master Data Setup</Title>
      <Keyword type="header" order="d1e1649281">
         <Level1>Master Data</Level1>
      </Keyword>
   </Header>
   <AimSection>
      <Paragraph/>
   </AimSection>
   <GeneralSection>
      <SectionTitle>Initialization script</SectionTitle>
      <Paragraph>An initialization script has to be written which uses the DAL
		(DAL.NEW) of the involved tables to create rows in the database tables
		mentioned in the sections below.</Paragraph>
      <Paragraph>It is important that the naming conventions mentioned in this
		document should be strictly adhered to. Otherwise, mixing up with (future)
		standard data cannot be excluded.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Business objects (tfgld454)</SectionTitle>
      <Paragraph>This table lists the business objects that will be part of
		integration transactions (among others, visible in the <GUIRef href="/baanerp/tf/gld/tfgld4582m000" role="session">Integration Transactions (tfgld4582m000)</GUIRef> session).</Paragraph>
      <TABLE width="100%" border="1" borderstyle="default"
             space-and-orientation="indented-estimated">
         <TBODY noTR="4">
            <TR no="1" isLast="false">
               <TH rowspan="1" colspan="1">Field</TH>
               <TH rowspan="1" colspan="1">Description</TH>
               <TH rowspan="1" colspan="1">Format</TH>
               <TH rowspan="1" colspan="1">Domain</TH>
               <TH rowspan="1" colspan="1">Mandatory*</TH>
               <TH rowspan="1" colspan="1">Remarks</TH>
            </TR>
            <TR no="2" isLast="false">
               <TD rowspan="1" colspan="1">bona</TD>
               <TD rowspan="1" colspan="1">business object</TD>
               <TD rowspan="1" colspan="1">str(17)</TD>
               <TD rowspan="1" colspan="1">tcbona</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">must start with the "#"-character; other characters are free to
				choose; this name will, among others, be displayed in session <GUIRef href="/baanerp/tf/gld/tfgld4582m000" role="session">Integration Transactions (tfgld4582m000)</GUIRef>
               </TD>
            </TR>
            <TR no="3" isLast="false">
               <TD rowspan="1" colspan="1">lita</TD>
               <TD rowspan="1" colspan="1">transaction logging allowed</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="4" isLast="true">
               <TD rowspan="1" colspan="1">maal</TD>
               <TD rowspan="1" colspan="1">mapping allowed</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no</TD>
            </TR>
         </TBODY>
      </TABLE>
      <Paragraph>* The Mandatory option for external data can deviate from the
		table field’s property.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Elements (tfgld456)</SectionTitle>
      <Paragraph>This table contains the elements that will be logged related to
		integration transactions, and will be primarily used for ledger account and
		dimension mapping (among others, visible during the setting up of the mapping
		scheme).</Paragraph>
      <TABLE width="100%" border="1" borderstyle="default"
             space-and-orientation="indented-estimated">
         <TBODY noTR="10">
            <TR no="1" isLast="false">
               <TH rowspan="1" colspan="1">Field</TH>
               <TH rowspan="1" colspan="1">Description</TH>
               <TH rowspan="1" colspan="1">Format</TH>
               <TH rowspan="1" colspan="1">Domain</TH>
               <TH rowspan="1" colspan="1">Mandatory*</TH>
               <TH rowspan="1" colspan="1">Remarks</TH>
            </TR>
            <TR no="2" isLast="false">
               <TD rowspan="1" colspan="1">elcd</TD>
               <TD rowspan="1" colspan="1">element code</TD>
               <TD rowspan="1" colspan="1">str(12)</TD>
               <TD rowspan="1" colspan="1">tfgld.elcd</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">must start with the string "EXT"; other characters must be
				numeric</TD>
            </TR>
            <TR no="3" isLast="false">
               <TD rowspan="1" colspan="1">bonm</TD>
               <TD rowspan="1" colspan="1">business object</TD>
               <TD rowspan="1" colspan="1">str(17)</TD>
               <TD rowspan="1" colspan="1">tcbona</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">(softly) refers to tfgld454.bona</TD>
            </TR>
            <TR no="4" isLast="false">
               <TD rowspan="1" colspan="1">boat</TD>
               <TD rowspan="1" colspan="1">business object attribute</TD>
               <TD rowspan="1" colspan="1">str(17)</TD>
               <TD rowspan="1" colspan="1">tcboat</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">must start with the "#"-character; other characters are free to
				choose; this name will be visible while maintaining the mapping scheme</TD>
            </TR>
            <TR no="5" isLast="false">
               <TD rowspan="1" colspan="1">elds</TD>
               <TD rowspan="1" colspan="1">element description</TD>
               <TD rowspan="1" colspan="1">str(30)</TD>
               <TD rowspan="1" colspan="1">tcdsca</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">description of the element that will be visible to the user</TD>
            </TR>
            <TR no="6" isLast="false">
               <TD rowspan="1" colspan="1">levl</TD>
               <TD rowspan="1" colspan="1">element level</TD>
               <TD rowspan="1" colspan="1">byte</TD>
               <TD rowspan="1" colspan="1">tfgld.srno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: 1</TD>
            </TR>
            <TR no="7" isLast="false">
               <TD rowspan="1" colspan="1">pecd</TD>
               <TD rowspan="1" colspan="1">parent element</TD>
               <TD rowspan="1" colspan="1">str(12)</TD>
               <TD rowspan="1" colspan="1">tfgld.elcd</TD>
               <TD rowspan="1" colspan="1">no</TD>
               <TD rowspan="1" colspan="1">should be left empty (not used externally)</TD>
            </TR>
            <TR no="8" isLast="false">
               <TD rowspan="1" colspan="1">rcel</TD>
               <TD rowspan="1" colspan="1">reconciliation element</TD>
               <TD rowspan="1" colspan="1">str(12)</TD>
               <TD rowspan="1" colspan="1">tcrelc</TD>
               <TD rowspan="1" colspan="1">no</TD>
               <TD rowspan="1" colspan="1">should be left empty (not used externally)</TD>
            </TR>
            <TR no="9" isLast="false">
               <TD rowspan="1" colspan="1">bpyn</TD>
               <TD rowspan="1" colspan="1">business partner</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no (not used externally)</TD>
            </TR>
            <TR no="10" isLast="true">
               <TD rowspan="1" colspan="1">expi</TD>
               <TD rowspan="1" colspan="1">expired y/n</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no</TD>
            </TR>
         </TBODY>
      </TABLE>
      <Paragraph>* The Mandatory option for external data can deviate from the
		table field’s property.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Integration document types (tfgld457)</SectionTitle>
      <Paragraph>This table contains the integration document types that will be
		part of integration transactions (among others, visible in the <GUIRef href="/baanerp/tf/gld/tfgld4582m000" role="session">Integration Transactions (tfgld4582m000)</GUIRef> session).</Paragraph>
      <TABLE width="100%" border="1" borderstyle="default"
             space-and-orientation="indented-estimated">
         <TBODY noTR="13">
            <TR no="1" isLast="false">
               <TH rowspan="1" colspan="1">Field</TH>
               <TH rowspan="1" colspan="1">Description</TH>
               <TH rowspan="1" colspan="1">Format</TH>
               <TH rowspan="1" colspan="1">Domain</TH>
               <TH rowspan="1" colspan="1">Mandatory*</TH>
               <TH rowspan="1" colspan="1">Remarks</TH>
            </TR>
            <TR no="2" isLast="false">
               <TD rowspan="1" colspan="1">idtc</TD>
               <TD rowspan="1" colspan="1">integration document type</TD>
               <TD rowspan="1" colspan="1">str(8)</TD>
               <TD rowspan="1" colspan="1">tcidty</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">must start with the string "EXT"; other characters must be
				numeric</TD>
            </TR>
            <TR no="3" isLast="false">
               <TD rowspan="1" colspan="1">idtd</TD>
               <TD rowspan="1" colspan="1">integration document type description</TD>
               <TD rowspan="1" colspan="1">str(30)</TD>
               <TD rowspan="1" colspan="1">tcdsca</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">must start with the "#"-character; other characters are free to
				choose; this name will, among others, be displayed in session <GUIRef href="/baanerp/tf/gld/tfgld4582m000" role="session">Integration Transactions (tfgld4582m000)</GUIRef>
               </TD>
            </TR>
            <TR no="4" isLast="false">
               <TD rowspan="1" colspan="1">bonm</TD>
               <TD rowspan="1" colspan="1">business object</TD>
               <TD rowspan="1" colspan="1">str(17)</TD>
               <TD rowspan="1" colspan="1">tcbona</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">(softly) refers to tfgld454.bona</TD>
            </TR>
            <TR no="5" isLast="false">
               <TD rowspan="1" colspan="1">secd</TD>
               <TD rowspan="1" colspan="1">sort element</TD>
               <TD rowspan="1" colspan="1">str(12)</TD>
               <TD rowspan="1" colspan="1">tfgld.elcd</TD>
               <TD rowspan="1" colspan="1">no</TD>
               <TD rowspan="1" colspan="1">(softly) refers to tfgld456.elcd; must only be filled if the sort
				element functionality is used</TD>
            </TR>
            <TR no="6" isLast="false">
               <TD rowspan="1" colspan="1">modt</TD>
               <TD rowspan="1" colspan="1">modifiable document type</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no</TD>
            </TR>
            <TR no="7" isLast="false">
               <TD rowspan="1" colspan="1">ppdt</TD>
               <TD rowspan="1" colspan="1">publish posting details</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no (not used externally)</TD>
            </TR>
            <TR no="8" isLast="false">
               <TD rowspan="1" colspan="1">expi</TD>
               <TD rowspan="1" colspan="1">expired y/n</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no</TD>
            </TR>
            <TR no="9" isLast="false">
               <TD rowspan="1" colspan="1">lemm</TD>
               <TD rowspan="1" colspan="1">ledger mapping mandatory</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="10" isLast="false">
               <TD rowspan="1" colspan="1">dlae</TD>
               <TD rowspan="1" colspan="1">log all elements debit</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="11" isLast="false">
               <TD rowspan="1" colspan="1">clae</TD>
               <TD rowspan="1" colspan="1">log all elements credit</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="12" isLast="false">
               <TD rowspan="1" colspan="1">maal</TD>
               <TD rowspan="1" colspan="1">mapping allowed</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="13" isLast="true">
               <TD rowspan="1" colspan="1">ltia</TD>
               <TD rowspan="1" colspan="1">linked to integration account</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
         </TBODY>
      </TABLE>
      <Paragraph>* The Mandatory option for external data can deviate from the
		table field’s property.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Elements by integration document type
		(tfgld458)</SectionTitle>
      <Paragraph>This table contains the elements that will be logged for a
		particular integration document type, and that can be used within the mapping
		scheme for ledger account and dimension mapping.</Paragraph>
      <TABLE width="100%" border="1" borderstyle="default"
             space-and-orientation="indented-estimated">
         <TBODY noTR="7">
            <TR no="1" isLast="false">
               <TH rowspan="1" colspan="1">Field</TH>
               <TH rowspan="1" colspan="1">Description</TH>
               <TH rowspan="1" colspan="1">Format</TH>
               <TH rowspan="1" colspan="1">Domain</TH>
               <TH rowspan="1" colspan="1">Mandatory*</TH>
               <TH rowspan="1" colspan="1">Remarks</TH>
            </TR>
            <TR no="2" isLast="false">
               <TD rowspan="1" colspan="1">idtc</TD>
               <TD rowspan="1" colspan="1">integration document type</TD>
               <TD rowspan="1" colspan="1">str(8)</TD>
               <TD rowspan="1" colspan="1">tcidty</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">refers to tfgld457.idtc</TD>
            </TR>
            <TR no="3" isLast="false">
               <TD rowspan="1" colspan="1">elcd</TD>
               <TD rowspan="1" colspan="1">element code</TD>
               <TD rowspan="1" colspan="1">str(12)</TD>
               <TD rowspan="1" colspan="1">tfgld.elcd</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">refers to tfgld456.elcd</TD>
            </TR>
            <TR no="4" isLast="false">
               <TD rowspan="1" colspan="1">dele</TD>
               <TD rowspan="1" colspan="1">debit ledger mapping applicable</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="5" isLast="false">
               <TD rowspan="1" colspan="1">crle</TD>
               <TD rowspan="1" colspan="1">credit ledger mapping applicable</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.yes</TD>
            </TR>
            <TR no="6" isLast="false">
               <TD rowspan="1" colspan="1">nefi</TD>
               <TD rowspan="1" colspan="1">never filled</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no</TD>
            </TR>
            <TR no="7" isLast="true">
               <TD rowspan="1" colspan="1">bpgl</TD>
               <TD rowspan="1" colspan="1">business partner for general ledger</TD>
               <TD rowspan="1" colspan="1">enum</TD>
               <TD rowspan="1" colspan="1">tcyesno</TD>
               <TD rowspan="1" colspan="1">yes</TD>
               <TD rowspan="1" colspan="1">value: tcyesno.no (not used externally)</TD>
            </TR>
         </TBODY>
      </TABLE>
      <Paragraph>* The Mandatory option for external data can deviate from the
		table field’s property.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Additional procedure steps</SectionTitle>
      <Paragraph>After running the initialization script, in the <GUIRef href="/baanerp/tf/gld/tfgld4150s000" role="session">Integration Parameters (tfgld4150s000)</GUIRef> session, on the <GUIRef href="" role="manual">Specific</GUIRef> menu, select Initialize Descriptions to renew the business object and
		integration document type language dependent descriptions.</Paragraph>
      <Paragraph>Subsequently, in the <GUIRef href="/baanerp/tf/gld/tfgld4579m000" role="session">Period Handling by Integration Document Type (tfgld4579m000)</GUIRef> session, for each external
		integration document type – debit/credit combination, set the Closed Period
		Handling value to either Post to next open period, or Post to current period,
		because exception handling is only applicable for internal business objects.
		Because table tfgld479 must be shared for all financial companies (please
		check!), you do not need to repeat the latter action for each individual
		financial company.</Paragraph>
   </GeneralSection>
</ManualTopic>