BizTalk Map Documentation

From Schema(s): MyCompany.Project.Integration.Finance.Schemas.Journal_v1
To Schema: MyCompany.Project.Integration.Finance.Schemas.Dynamics.GeneralJournal.AXGeneralJournalCreate
Functoids Constant Values

Direct Node-to-Node Links (No Functoids)

Page 1: Journal

Collapse

From To Label
Journal/Body/Batch/Invoice/TransactionDate IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/TransDate
Journal/Body/Batch/Invoice/Analysis/AccountNumber IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/AccountNum
Journal/Body/Batch/Invoice/Analysis/AccountType/1 IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/AccountType
Journal/Body/Batch/Invoice/Analysis/OffsetAccountNumber IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/OffsetAccount
Journal/Body/Batch/Invoice/Analysis/AccountType/2 IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/OffsetAccountType
Journal/Body/Batch/Invoice/InvoiceNumber IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFInvoice
Journal/Body/Batch/Invoice/Analysis/VatGroup IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INVIFItemVATGroup
Journal/Body/Batch/Invoice/Analysis/VatAmount IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFCorrectedVATAmount
Journal/Body/Batch/Invoice/Text IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/Txt
Journal/Body/Batch/Invoice/OriginalInvoiceNumber IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFOriginalInvoiceNumber
Journal/Body/Batch/Invoice/ReasonCode IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFReasonCode
Journal/Body/Batch/Invoice/ReasonComment IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFReasonComment
Journal/Body/Batch/BatchNumber IntIfGeneralJournal/LedgerJournalTable_1/INTIFBatchId
Journal/Body/Batch/Invoice/DocumentDate IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFDocumentDate
Journal/Body/Batch/Invoice/Currency IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/CurrencyCode
Journal/Header/Systems IntIfGeneralJournal/LedgerJournalTable_1/JournalName

Top

Functoid Mappings

Page 1: Journal

Collapse

Functoid Sequence Destination Node Labels
Looping ( Journal/Body/Batch/Invoice/Analysis )
IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1
Lowercase ( "create" )
IntIfGeneralJournal/LedgerJournalTable_1/action
Lowercase ( "create" )
IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/action
Scripting
<xsl:template name="DynamicsDimensionsXsltTemplate"> <xsl:param name="param1" /> <xsl:param name="param2" /> <xsl:param name="param3" /> <xsl:param name="param4" /> <xsl:param name="param5" /> <xsl:param name="param6" /> <xsl:element name="ns0:Dimension"> <xsl:element name="ns0:element"><xsl:value-of select="$param1" /></xsl:element> <xsl:element name="ns0:element"><xsl:value-of select="$param2" /></xsl:element> <xsl:element name="ns0:element"><xsl:value-of select="$param3" /></xsl:element> <xsl:element name="ns0:element"><xsl:value-of select="$param4" /></xsl:element> <xsl:element name="ns0:element"><xsl:value-of select="$param5" /></xsl:element> <xsl:element name="ns0:element"><xsl:value-of select="$param6" /></xsl:element> </xsl:element> </xsl:template>

(
"",
"",
"",
"",
   Journal/Body/Batch/Invoice/Analysis/CostCentreCode,
   Journal/Body/Batch/Invoice/Analysis/ActivityCode
)
IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/Dimension
Scripting
<xsl:template name="DebitAmountXsltTemplate"> <xsl:param name="paramDebitOrCredit" /> <xsl:param name="paramAmount" /> <xsl:element name="ns0:AmountCurDebit"> <xsl:choose> <xsl:when test="$paramDebitOrCredit = 'Debit' "> <xsl:value-of select="$paramAmount" /> </xsl:when> <xsl:otherwise> <xsl:value-of select="0" /> </xsl:otherwise> </xsl:choose> </xsl:element> </xsl:template>

(
   Journal/Body/Batch/Invoice/Analysis/AmountSign,
   Journal/Body/Batch/Invoice/Analysis/Amount
)
IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/AmountCurDebit
Scripting
<xsl:template name="CreditAmountXsltTemplate"> <xsl:param name="paramDebitOrCredit" /> <xsl:param name="paramAmount" /> <xsl:element name="ns0:AmountCurCredit"> <xsl:choose> <xsl:when test="$paramDebitOrCredit = 'Credit' "> <xsl:value-of select="$paramAmount" /> </xsl:when> <xsl:otherwise> <xsl:value-of select="0" /> </xsl:otherwise> </xsl:choose> </xsl:element> </xsl:template>

(
   Journal/Body/Batch/Invoice/Analysis/AmountSign,
   Journal/Body/Batch/Invoice/Analysis/Amount
)
IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/AmountCurCredit

Top

Constant Values

Collapse

Value Destination Node
Yes IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFApproved
1 IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFQantity