From Schema(s): | MyCompany.Project.Integration.Finance.Schemas.Journal_v1 |
To Schema: | MyCompany.Project.Integration.Finance.Schemas.Dynamics.GeneralJournal.AXGeneralJournalCreate |
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 |
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 |
Value | Destination Node |
---|---|
Yes | IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFApproved |
1 | IntIfGeneralJournal/LedgerJournalTable_1/LedgerJournalTrans_1/INTIFQantity |