Matt How

Matt How's Blog

Pipeline Parameters in Azure Data Factory V2

The second release of Azure Data Factory (ADF) includes several new features that vastly improve the quality of the service. One of which is the ability to pass parameters down the pipeline into datasets. In this blog I will show how we can use parameters to manipulate a generic pipeline structure to copy a SQL table into a blob. Whilst this is a new feature for ADF, this blog assumes some prior knowledge of ADF (V1 or V2)

 

Creating the Data Factory V2

One other major difference with ADF V2 is that we no longer need to chain datasets and pipelines to create a working solution. Whilst the concept of dependency still exists, that is no longer needed to run a pipeline, we can now just run them ad hoc. This is important for this demo because we want to run the job once, check it succeeds and then move onto the next table instead of managing any data slices. You can create a new V2 data factory either from the portal or using this command in PowerShell:

$df = Set-AzureRmDataFactoryV2 -ResourceGroupName <resource group> –Location <location> -Name <data factory name>


If you are familiar with the PowerShell cmdlets for ADF V1 then you can make use of nearly all of them in V2 by appending “V2” to the end of the cmdlet name.

ADF V2 Object Templates

Now we have a Data Factory to work with we can start deploying objects. In order to make use of parameters we need to firstly specify how we will receive the value of each parameter. Currently there are two ways:

1.      Via a parameter file specified when you invoke the pipeline

2.      Using a lookup activity to obtain a value and pass that into a parameter

This blog will focus on the simpler method using a parameter file. Later blogs will demonstrate the use of the lookup activity

image

When we invoke our pipeline, I will show how to reference that file but for now we know we are working with a single parameter called “tableName”.

Now we can move on to our pipeline definition which is where the parameter values are initially received. To do this we need to add an attribute called “parameters” to the definition file that will contain all the parameters that will be used within the pipeline. See below:

image

The same concept needs to be carried through to the dataset that we want to feed the parameters in to. Within the dataset definition we need to have the parameter attribute specified in the same way as in the pipeline.

Now that we have declared the parameters to the necessary objects I can show you how to pass data into a parameter. As mentioned before, the pipeline parameter will be populated by the parameter file however the dataset parameter will need to be populated from within the pipeline. Instead of simply referring to a dataset by name as in ADF V1 we now need the ability to supply more data and so the “inputs” and “outputs” section of our pipeline now looks like the below:

image

  1. Firstly, we declare the reference type, hence “DatasetReference”.
  2. We then give the reference name. This could be parameterised if needed
  3. Finally, for each parameter in our dataset (in this case there is only one called “tableName”) we supply the corresponding value from the pipelines parameter set. We can get the value of the pipeline parameter using the “@Pipeline.parameters.<parameter name>” syntax.

At this point we have received the values from a file, passed them through the pipeline into a dataset and now it is time to use that value to manipulate the behaviour of the dataset. Because we are using the parameter to define our file name we can use its value as part of the “fileName” attribute, see below:

image

Now we have the ability to input a table name and our pipeline will fetch that table from the database and copy it into a blob. Perhaps a diagram to help provide the big picture:

image

Now we have a complete working pipeline that is totally generic, meaning we can change the parameters we feed in but should never have to change the JSON definition files. A pipeline such as this could have many uses but in the next blog I will show how we can use a ForEach loop (another ADF v2 feature) to copy every table from a data base still only using a single pipeline and some parameters.

P.S. Use this link to see the entire json script used to create all the objects required for this blog.  http://bit.ly/2zwZFLB

Comments (12) -

  • Luis Gonzalez

    11/8/2017 6:24:09 PM | Reply

    Hey Matt - thanks for the post. I'm trying to genericize a dataset by passing it a table name parameter from a lookup (something you alluded to posting about in the future). I have a pipeline that starts with a lookup activity that references a dataset to which I pass a tableName of "ArchiveTables":

                {
                    "name": "LookupArchiveTables",
                    "description": "Reads all rows from the ArchiveTables table that have the Enabled column set to 1.",
                    "type": "Lookup",
                    "typeProperties":
                    {
                        "dataset":
                        {
                            "referenceName": "Dataset_AzureSqlTable_Generic",
                            "type": "DatasetReference",
                "parameters":
                {
                  "tableName":
                  {
                    "value": "ArchiveTables",
                    "type": "Expression"
                  }
                }
                        },
                        "source":
                        {
                          "type": "SqlSource",
                          "sqlReaderQuery": "SELECT TableName, DateTimeColumnName FROM ArchiveTables WHERE Enabled = 1"
                        },
                        "firstRowOnly": false
                    }
                },

    And then the dataset uses that to setup the "ArchiveTables" table name as the source table for the dataset.

    {
        "name": "Dataset_AzureSqlTable_Generic",
        "properties":
        {
            "type": "AzureSqlTable",
            "linkedServiceName":
            {
                "referenceName": "LinkedService_AzureSqlDatabase",
                "type": "LinkedServiceReference"
            },
            "typeProperties":
            {
                "tableName": "@dataset().parameters.tableName"
            },
        "parameters":
            {
                "tableName":
                {
                  "type": "String"
                }
            }
        }
    }


    but when it runs it errors that parameters is not valid:

    {
        "errorCode": "InvalidTemplate",
        "message": " 'The template language expression 'body('LookupArchiveTablesComposeRuntimeVariables')?.Dataset_AzureSQLTable_Genericfbdad42d28c04fa39f8f3c467647fde8.parameters.tableName' cannot be evaluated because property 'parameters' doesn't exist, available properties are 'tableName'.",
        "failureType": "UserError",
        "target": "LookupArchiveTables"
    }

    I must be overlooking something basic.

  • Luis Gonzalez

    11/9/2017 5:59:02 PM | Reply

    Along the lines of what you are doing here:

    I managed to create a "generic" dataset that I can pass a table parameter to. It actually works:

    {
        "name": "Dataset_AzureSqlTable_Generic",
        "properties":
        {
            "type": "AzureSqlTable",
            "typeProperties":
            {
                "tableName":
          {
            "value": "@dataset().TableName",
            "type": "Expression"
          }
            },
            "linkedServiceName":
            {
                "referenceName": "LinkedService_AzureSqlDatabase",
                "type": "LinkedServiceReference"
            },
        "parameters":
        {
          "TableName":
          {
            "type": "String"
          }
        }
        }
    }

    I use a Lookup activity in my master pipeline to get a list of tables I need to work on by calling that and passing an "ArchiveTables" parameter which is a table in the database that has the table list. That works great.

    The next activity in my master pipeline is an ExecutePipeLine activity, which references the values returned from the first lookup activity.

    {
        "name": "Pipeline_TriggerArchiveTables",
        "description": "Uses the LookupArchiveTables activity to get the tables to archive and passes that list down to the ArchiveTables pipeline.",
        "properties":
        {
            "activities":
            [
                {
                    "name": "LookupArchiveTables",
                    "description": "Reads all rows from the ArchiveTables table that have the Enabled column set to 1.",
                    "type": "Lookup",
                    "typeProperties":
                    {
                        "source":
                        {
                          "type": "SqlSource",
                          "sqlReaderQuery": "SELECT TableName, DateTimeColumnName FROM ArchiveTables WHERE Enabled = 1 ORDER BY TableName"
                        },
                        "dataset":
                        {
                            "referenceName": "Dataset_AzureSqlTable_Generic",
                            "type": "DatasetReference",
                "parameters":
                {
                  "TableName":
                  {
                    "value": "ArchiveTables",
                    "type": "Expression"
                  }
                }
                        },
                        "firstRowOnly": false
                    }
                },
                {
                    "name": "ExecuteArchiveTables",
                    "type": "ExecutePipeLine",
                    "typeProperties":
                    {
                        "pipeline":
                        {
                          "referenceName": "Pipeline_ArchiveTables",
                          "type": "PipelineReference"
                        },
                        "parameters":
                        {
                            "TableList":
                            {
                                "value": "@{activity('LookupArchiveTables').output.value}",
                                "type": "Expression"
                            }
                        },
                        "waitOnCompletion": true
                    },
                    "dependsOn":
                    [
                        {
                            "activity": "LookupArchiveTables",
                            "dependencyConditions": ["Succeeded"]
                        }
                    ]
          }
            ]
        }
    }

    That seems to all work as well. The pipeline "Pipeline_ArchiveTables" has a foreach activity that iterates through the table list. I followed the online examples from MS to the letter. I confirmed in the log that the table and column names were being properly passed into the TableList parameter so I know it's all good up to this pipeline. I kept it simple for troubleshooting by simply inserting the same lookup activity I know worked earlier to see if the foreach works, but it consistently fails with a 400 error. It complains about the inner activity, but I know that activity works. Just been staring at it wondering what the problem is. It seems rather cut and dry to me. It should do one iteration since there is only one table in the TableList parameter, and the lookup activity should be executed.

    {
        "errorCode": "400",
        "message": "Activity failed because an inner activity failed",
        "failureType": "UserError",
        "target": "IterateArchiveTables"
    }


    {    
        "name": "Pipeline_ArchiveTables",
        "properties":
        {
            "activities":
            [
                {
                    "name": "IterateArchiveTables",
                    "description": "Executes in parallel the ArchiveTable pipeline for each table passed to it from the TriggerArchiveTables pipeline.",
                    "type": "ForEach",
                    "typeProperties":
                    {
                        "isSequential": false,
                        "items":
              {
                "value": "@pipeline().parameters.TableList",
                "type": "Expression"
              },
                        "activities":
                        [
                {
                  "name": "LookupArchiveTables",
                  "description": "Reads all rows from the ArchiveTables table that have the Enabled column set to 1.",
                  "type": "Lookup",
                  "typeProperties":
                  {
                    "source":
                    {
                      "type": "SqlSource",
                      "sqlReaderQuery": "SELECT TableName, DateTimeColumnName FROM ArchiveTables WHERE Enabled = 1 ORDER BY TableName"
                    },
                    "dataset":
                    {
                      "referenceName": "Dataset_AzureSqlTable_Generic",
                      "type": "DatasetReference",
                      "parameters":
                      {
                        "TableName":
                        {
                          "value": "ArchiveTables",
                          "type": "Expression"
                        }
                      }
                    },
                    "firstRowOnly": false
                  }
                }
                        ]
                    }
                }
            ],
        "parameters":
        {
          "TableList":
          {
            "type": "Array"
          }
        }
        }
    }

    • matthow

      11/15/2017 9:36:57 AM | Reply

      Hi Luis, Thanks for your comments. I'm going to have a proper look at your issue shortly  but off the top of my head it looks like you are using an Array data type for the TableList parameter and I think you should try using an Object data type.

  • iPXUE

    12/12/2017 6:42:19 PM | Reply

    260582 398703This site   is my  breathing in,  real   wonderful  style  and perfect content material . 342366

  • uQZxo1iaoikdf

    2/24/2018 3:11:29 AM | Reply

    267451 432847I like  your writing style  truly   loving this internet site  . 825348

  • Mahlon Barrault

    3/29/2018 3:03:55 PM | Reply

    Any thoughts on generalizing the LinkedServiceReference in a dataset? I have to copy the same tables from several different databases, all on different servers.

    • Matt How

      4/4/2018 7:40:49 AM | Reply

      Hi Mahlon - You can pass parameters down into the dataset and then reference those parameters at any point in the dataset JSON, including the linked service reference. If the location is the same but only the server details change then you could also use an expression to concat the parameter server name and the location in the reference. Should find all the docs you need here: docs.microsoft.com/.../control-flow-expression-language-functions

  • Hemant Chandurkar

    4/4/2018 7:02:41 AM | Reply

    Thanks for Article. However I am looking for help how to run pipeline by passing parameters. Where I can keep parameter file? Basically I am creating U-SQL activity where I want to pass dynamic date as parameter to U-SQL so that proper files will be picked up.

    • Matt How

      4/4/2018 7:45:52 AM | Reply

      Hi Hemant - Depending on how you trigger the pipeline run you can store your startup parameters in a variety of locations. If you want to trigger from powershell or c# then you can use a JSON file to store and access the parameters. If you were to trigger the pipeline from an Azure Function then you could pass in a date using the request body and then just call the web service when you want to run your pipeline. Finally you can use a Lookup activity within your pipeline so that you can query for any runtime variables from SQL/JSON and then pass those down into ADLA(USQL). Hope this helps.

  • Stewart

    6/29/2018 2:24:13 PM | Reply

    Hi Matt, thanks for getting back to me.

    I have tried to put a parameter against the linkedService Reference name but that didn't work and I considered whether the parameter should be against the linked service itself for the database name but it seems the database  name is part of the encrypted Credential string.

    If this can be done, I am then wondering if its also possible to parameterize the Integration Runtime to use as well....

    Here is the source dataset

    {
        "name": "SourceDataset_emc",
        "properties": {
            "linkedServiceName": {
                "referenceName": "@CouldThis be a parameter?",
                "type": "LinkedServiceReference" --- should this be set to Expression?
            },
            "parameters": {
                "cw_structure": {
                    "type": "Array"
                },
                "cw_tableName": {
                    "type": "String"
                }
            },
            "type": "SqlServerTable",
            "structure": {
                "value": "@dataset().cw_structure",
                "type": "Expression"
            },
            "typeProperties": {
                "tableName": {
                    "value": "@dataset().cw_tableName",
                    "type": "Expression"
                }
            }
        },
        "type": "Microsoft.DataFactory/factories/datasets"
    }
    and the pipeline.........

    {
        "name": "#######",
        "properties": {
            "activities": [
                {
                    "name": "ForEach_894",
                    "type": "ForEach",
                    "typeProperties": {
                        "items": {
                            "value": "@pipeline().parameters.cw_items",
                            "type": "Expression"
                        },
                        "activities": [
                            {
                                "name": "Copy_894",
                                "type": "Copy",
                                "policy": {
                                    "timeout": "7.00:00:00",
                                    "retry": 0,
                                    "retryIntervalInSeconds": 30,
                                    "secureOutput": false
                                },
                                "userProperties": [
                                    {
                                        "name": "Source",
                                        "value": "@{item().source.tableName}"
                                    },
                                    {
                                        "name": "Destination",
                                        "value": "@{item().destination.tableName}"
                                    }
                                ],
                                "typeProperties": {
                                    "source": {
                                        "type": "SqlSource"
                                    },
                                    "sink": {
                                        "type": "SqlDWSink",
                                        "allowPolyBase": false,
                                        "writeBatchSize": 10000,
                                        "preCopyScript": {
                                            "value": "@item().copySink.preCopyScript",
                                            "type": "Expression"
                                        }
                                    },
                                    "enableStaging": false,
                                    "dataIntegrationUnits": 0
                                },
                                "inputs": [
                                    {
                                        "referenceName": "SourceDataset_emc",
                                        "type": "DatasetReference"
                                    }
                                ],
                                "outputs": [
                                    {
                                        "referenceName": "DestinationDataset_894",
                                        "type": "DatasetReference",
                                        "parameters": {
                                            "cw_structure": "@item().destination.structure",
                                            "cw_tableName": "@item().destination.tableName"
                                        }
                                    }
                                ]
                            }
                        ]
                    }
                }
            ],
            "parameters": {
                "cw_items": {
                    "type": "Array",
                    "defaultValue": [
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ACCOUNT_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_VALUE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_ACCOUNTUSERFIELDS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ACCOUNT_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_VALUE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_ACCOUNTUSERFIELDS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_ACCOUNTUSERFIELDS]', 'U') IS NULL CREATE TABLE [dbo].[D_ACCOUNTUSERFIELDS] ([ID] int,\n[ACCOUNT_ID] int,\n[USERFIELD_ID] int,\n[USERFIELD_VALUE] varchar(256));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "ID:ID, ACCOUNT_ID:ACCOUNT_ID, USERFIELD_ID:USERFIELD_ID, USERFIELD_VALUE:USERFIELD_VALUE"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[D_ACCTKEYS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[D_ACCTKEYS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_ACCTKEYS]', 'U') IS NULL CREATE TABLE [dbo].[D_ACCTKEYS] ([LEDGER] varchar(12),\n[ACCOUNT] varchar(12),\n[KEYVALUE] varchar(12),\n[KEYNAME] varchar(12),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, ACCOUNT:ACCOUNT, KEYVALUE:KEYVALUE, KEYNAME:KEYNAME, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAIL_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_VALUE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_DETAIL_USERFIELDS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAIL_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_VALUE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_DETAIL_USERFIELDS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_DETAIL_USERFIELDS]', 'U') IS NULL CREATE TABLE [dbo].[D_DETAIL_USERFIELDS] ([ID] int,\n[DETAIL_ID] int,\n[USERFIELD_ID] int,\n[USERFIELD_VALUE] varchar(256));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "ID:ID, DETAIL_IDLaughingETAIL_ID, USERFIELD_ID:USERFIELD_ID, USERFIELD_VALUE:USERFIELD_VALUE"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "TRANSACTIONTYPE",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "XLEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "XACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "VALUE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "NOMCURRENCY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ACCCURRENCY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DOCCURRENCY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "USERVALUE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DESCRIPTION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCNUM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REFNO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PAYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ALLOCATION",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DUEDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "DISCOUNT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "HIGHDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "HIGHYEAR",
                                        "type": "String"
                                    },
                                    {
                                        "name": "HIGHPERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "INPUTTIME",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "USERFIELD1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOC_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "AUTHUSER",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_DETAILS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "TRANSACTIONTYPE",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "XLEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "XACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "VALUE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "NOMCURRENCY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ACCCURRENCY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DOCCURRENCY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "USERVALUE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DESCRIPTION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCNUM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REFNO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PAYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ALLOCATION",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DUEDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "DISCOUNT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "HIGHDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "HIGHYEAR",
                                        "type": "String"
                                    },
                                    {
                                        "name": "HIGHPERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "INPUTTIME",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "USERFIELD1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOC_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "AUTHUSER",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_DETAILS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_DETAILS]', 'U') IS NULL CREATE TABLE [dbo].[D_DETAILS] ([TRANSACTIONTYPE] tinyint,\n[NOMINAL] varchar(12),\n[ACCOUNT] varchar(12),\n[XLEDGER] varchar(12),\n[XACCOUNT] varchar(12),\n[DOCDATE] datetime,\n[YEARCODE] varchar(10),\n[PERIOD] varchar(4),\n[VALUE] decimal(19,4),\n[NOMCURRENCY] decimal(19,4),\n[ACCCURRENCY] decimal(19,4),\n[DOCCURRENCY] decimal(19,4),\n[USERVALUE] decimal(19,4),\n[DESCRIPTION] varchar(30),\n[DOCTYPE] varchar(4),\n[DOCNUM] int,\n[DETAILSTATUS] char(1),\n[REFNO] int,\n[PAYLIST] varchar(12),\n[ALLOCATION] int,\n[DUEDATE] datetime,\n[DISCOUNT] decimal(19,4),\n[COMMID] int,\n[HIGHDATE] datetime,\n[HIGHYEAR] varchar(10),\n[HIGHPERIOD] varchar(4),\n[LEDGER] varchar(12),\n[INPUTDATE] datetime,\n[INPUTTIME] datetime,\n[USERFIELD1] varchar(30),\n[USERFIELD2] varchar(30),\n[USERFIELD3] varchar(30),\n[COMPANYCODE] varchar(12),\n[TAXTYPE] varchar(12),\n[DOC_ID] int,\n[ID] int,\n[AUTHUSER] varchar(24));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "TRANSACTIONTYPE:TRANSACTIONTYPE, NOMINAL:NOMINAL, ACCOUNT:ACCOUNT, XLEDGER:XLEDGER, XACCOUNT:XACCOUNT, DOCDATELaughingOCDATE, YEARCODE:YEARCODE, PERIODTongERIOD, VALUE:VALUE, NOMCURRENCY:NOMCURRENCY, ACCCURRENCY:ACCCURRENCY, DOCCURRENCYLaughingOCCURRENCY, USERVALUE:USERVALUE, DESCRIPTIONLaughingESCRIPTION, DOCTYPELaughingOCTYPE, DOCNUMLaughingOCNUM, DETAILSTATUSLaughingETAILSTATUS, REFNO:REFNO, PAYLISTTongAYLIST, ALLOCATION:ALLOCATION, DUEDATELaughingUEDATE, DISCOUNTLaughingISCOUNT, COMMID:COMMID, HIGHDATE:HIGHDATE, HIGHYEAR:HIGHYEAR, HIGHPERIOD:HIGHPERIOD, LEDGER:LEDGER, INPUTDATE:INPUTDATE, INPUTTIME:INPUTTIME, USERFIELD1:USERFIELD1, USERFIELD2:USERFIELD2, USERFIELD3:USERFIELD3, COMPANYCODE:COMPANYCODE, TAXTYPE:TAXTYPE, DOC_IDLaughingOC_ID, ID:ID, AUTHUSER:AUTHUSER"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLISTKEY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLISTNUMBER",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "KEYLISTVALUE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "KEYLISTTEXT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMPANY_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PARENT_NODE_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "FOLDER",
                                        "type": "Boolean"
                                    }
                                ],
                                "tableName": "[dbo].[D_KEYLISTKEY]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLISTKEY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLISTNUMBER",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "KEYLISTVALUE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "KEYLISTTEXT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMPANY_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PARENT_NODE_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "FOLDER",
                                        "type": "Boolean"
                                    }
                                ],
                                "tableName": "[dbo].[D_KEYLISTKEY]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_KEYLISTKEY]', 'U') IS NULL CREATE TABLE [dbo].[D_KEYLISTKEY] ([KEYLIST] varchar(12),\n[KEYLISTKEY] varchar(12),\n[TITLE] varchar(40),\n[KEYLISTNUMBER] int,\n[KEYLISTVALUE] decimal(19,4),\n[KEYLISTTEXT] varchar(40),\n[ID] int,\n[COMPANY_ID] int,\n[PARENT_NODE_ID] int,\n[FOLDER] bit);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "KEYLIST:KEYLIST, KEYLISTKEY:KEYLISTKEY, TITLE:TITLE, KEYLISTNUMBER:KEYLISTNUMBER, KEYLISTVALUE:KEYLISTVALUE, KEYLISTTEXT:KEYLISTTEXT, ID:ID, COMPANY_ID:COMPANY_ID, PARENT_NODE_IDTongARENT_NODE_ID, FOLDER:FOLDER"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_KEYVALUES]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_KEYVALUES]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_KEYVALUES]', 'U') IS NULL CREATE TABLE [dbo].[D_KEYVALUES] ([ID] int,\n[KEYNAME] varchar(12),\n[KEYVALUE] varchar(18),\n[TITLE] varchar(40));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "ID:ID, KEYNAME:KEYNAME, KEYVALUE:KEYVALUE, TITLE:TITLE"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BANKNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SORTCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BANKTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNTTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNTNUMBER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERREF",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[D_NAMEBANKINFO]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BANKNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SORTCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BANKTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNTTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNTNUMBER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERREF",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[D_NAMEBANKINFO]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_NAMEBANKINFO]', 'U') IS NULL CREATE TABLE [dbo].[D_NAMEBANKINFO] ([LEDGER] varchar(12),\n[ACCOUNT] varchar(12),\n[BANKNAME] varchar(12),\n[SORTCODE] varchar(12),\n[BANKTYPE] char(1),\n[ACCOUNTTYPE] char(1),\n[ACCOUNTNUMBER] varchar(12),\n[TITLE] varchar(150),\n[USERREF] varchar(18),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, ACCOUNT:ACCOUNT, BANKNAME:BANKNAME, SORTCODE:SORTCODE, BANKTYPE:BANKTYPE, ACCOUNTTYPE:ACCOUNTTYPE, ACCOUNTNUMBER:ACCOUNTNUMBER, TITLE:TITLE, USERREF:USERREF, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ANALYSISCODE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSFROM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "POSTO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "NAVIGATE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PROTECTED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REQUIRED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_NOMANALYSIS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ANALYSISCODE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSFROM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "POSTO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "NAVIGATE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PROTECTED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REQUIRED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[D_NOMANALYSIS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_NOMANALYSIS]', 'U') IS NULL CREATE TABLE [dbo].[D_NOMANALYSIS] ([ID] int,\n[ANALYSISCODE] int,\n[TITLE] varchar(40),\n[POSFROM] int,\n[POSTO] int,\n[NAVIGATE] int,\n[PROTECTED] char(1),\n[REQUIRED] char(1),\n[KEYLIST] varchar(12),\n[COMPANYCODE] varchar(12));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "ID:ID, ANALYSISCODE:ANALYSISCODE, TITLE:TITLE, POSFROMTongOSFROM, POSTOTongOSTO, NAVIGATE:NAVIGATE, PROTECTEDTongROTECTED, REQUIRED:REQUIRED, KEYLIST:KEYLIST, COMPANYCODE:COMPANYCODE"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[D_NOMKEYS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[D_NOMKEYS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[D_NOMKEYS]', 'U') IS NULL CREATE TABLE [dbo].[D_NOMKEYS] ([NOMINAL] varchar(12),\n[KEYVALUE] varchar(12),\n[KEYNAME] varchar(12),\n[COMPANYCODE] varchar(12),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "NOMINAL:NOMINAL, KEYVALUE:KEYVALUE, KEYNAME:KEYNAME, COMPANYCODE:COMPANYCODE, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "REFNOFROM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "REFNOTO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "LINKQTY",
                                        "type": "Decimal"
                                    }
                                ],
                                "tableName": "[dbo].[DP_DETAILREF]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "REFNOFROM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "REFNOTO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "LINKQTY",
                                        "type": "Decimal"
                                    }
                                ],
                                "tableName": "[dbo].[DP_DETAILREF]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[DP_DETAILREF]', 'U') IS NULL CREATE TABLE [dbo].[DP_DETAILREF] ([REFNOFROM] int,\n[REFNOTO] int,\n[LINKQTY] decimal(19,4));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "REFNOFROM:REFNOFROM, REFNOTO:REFNOTO, LINKQTY:LINKQTY"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "UPCOUNT",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCNUM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REFNO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DUEDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DESCRIPTION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ITEMSPERBATCH",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "QUANTITY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "PRICEPERBATCH",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DISCOUNTRATE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DISCOUNTAMOUNT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "TOTALCOST",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "VATRATE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "POPSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "STOCKTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "STOCKITEM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERID",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "INPUTTIME",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "PERSON",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PNOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACTIONEDQTY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "SHOWPRICES",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UNIT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOC_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "AUTHUSER",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[DP_DETAILS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "UPCOUNT",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCNUM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REFNO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DUEDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DESCRIPTION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ITEMSPERBATCH",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "QUANTITY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "PRICEPERBATCH",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DISCOUNTRATE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "DISCOUNTAMOUNT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "TOTALCOST",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "VATRATE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "POPSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "STOCKTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "STOCKITEM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERID",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTDATE",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "INPUTTIME",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "PERSON",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PNOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACTIONEDQTY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "SHOWPRICES",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UNIT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOC_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "AUTHUSER",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[DP_DETAILS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[DP_DETAILS]', 'U') IS NULL CREATE TABLE [dbo].[DP_DETAILS] ([UPCOUNT] int,\n[DOCTYPE] varchar(4),\n[DOCNUM] int,\n[DETAILSTATUS] varchar(1),\n[REFNO] int,\n[DOCDATE] datetime,\n[YEARCODE] varchar(10),\n[PERIOD] varchar(4),\n[DUEDATE] datetime,\n[NOMINAL] varchar(12),\n[ACCOUNT] varchar(14),\n[BUDGETCODE] varchar(12),\n[DESCRIPTION] varchar(30),\n[ITEMSPERBATCH] decimal(19,4),\n[QUANTITY] decimal(19,4),\n[PRICEPERBATCH] decimal(19,4),\n[DISCOUNTRATE] decimal(19,4),\n[DISCOUNTAMOUNT] decimal(19,4),\n[TOTALCOST] decimal(19,4),\n[VATRATE] decimal(19,4),\n[POPSTATUS] varchar(10),\n[STOCKTYPE] varchar(25),\n[STOCKITEM] varchar(25),\n[COMMID] int,\n[USERID] varchar(24),\n[INPUTDATE] datetime,\n[INPUTTIME] datetime,\n[PERSON] varchar(30),\n[USERFIELD1] varchar(30),\n[USERFIELD2] varchar(30),\n[USERFIELD3] varchar(30),\n[PNOMINAL] varchar(12),\n[PACCOUNT] varchar(12),\n[COMPANYCODE] varchar(12),\n[ACTIONEDQTY] decimal(19,4),\n[SHOWPRICES] char(1),\n[TAXTYPE] varchar(12),\n[UNIT] varchar(20),\n[DOC_ID] int,\n[ID] int,\n[AUTHUSER] varchar(24));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "UPCOUNT:UPCOUNT, DOCTYPELaughingOCTYPE, DOCNUMLaughingOCNUM, DETAILSTATUSLaughingETAILSTATUS, REFNO:REFNO, DOCDATELaughingOCDATE, YEARCODE:YEARCODE, PERIODTongERIOD, DUEDATELaughingUEDATE, NOMINAL:NOMINAL, ACCOUNT:ACCOUNT, BUDGETCODE:BUDGETCODE, DESCRIPTIONLaughingESCRIPTION, ITEMSPERBATCH:ITEMSPERBATCH, QUANTITY:QUANTITY, PRICEPERBATCHTongRICEPERBATCH, DISCOUNTRATELaughingISCOUNTRATE, DISCOUNTAMOUNTLaughingISCOUNTAMOUNT, TOTALCOST:TOTALCOST, VATRATE:VATRATE, POPSTATUSTongOPSTATUS, STOCKTYPE:STOCKTYPE, STOCKITEM:STOCKITEM, COMMID:COMMID, USERID:USERID, INPUTDATE:INPUTDATE, INPUTTIME:INPUTTIME, PERSONTongERSON, USERFIELD1:USERFIELD1, USERFIELD2:USERFIELD2, USERFIELD3:USERFIELD3, PNOMINALTongNOMINAL, PACCOUNTTongACCOUNT, COMPANYCODE:COMPANYCODE, ACTIONEDQTY:ACTIONEDQTY, SHOWPRICES:SHOWPRICES, TAXTYPE:TAXTYPE, UNIT:UNIT, DOC_IDLaughingOC_ID, ID:ID, AUTHUSER:AUTHUSER"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ALLOCATION",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "EXTERNALALLOC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ROLE_VIEW",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_POST",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[M_ACCOUNT]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ALLOCATION",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "EXTERNALALLOC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ROLE_VIEW",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_POST",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[M_ACCOUNT]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_ACCOUNT]', 'U') IS NULL CREATE TABLE [dbo].[M_ACCOUNT] ([LEDGER] varchar(12),\n[ACCOUNT] varchar(12),\n[TITLE] varchar(40),\n[TYPE] char(1),\n[ALLOCATION] int,\n[DETAILSTATUS] char(1),\n[EXTERNALALLOC] char(1),\n[CURRENCY] varchar(12),\n[ACCESS] int,\n[COMMID] int,\n[INPUTALLOWED] char(1),\n[LEDGER_ID] int,\n[ID] int,\n[ROLE_VIEW] varchar(12),\n[ROLE_MODIFY] varchar(12),\n[ROLE_POST] varchar(12));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, ACCOUNT:ACCOUNT, TITLE:TITLE, TYPE:TYPE, ALLOCATION:ALLOCATION, DETAILSTATUSLaughingETAILSTATUS, EXTERNALALLOC:EXTERNALALLOC, CURRENCY:CURRENCY, ACCESS:ACCESS, COMMID:COMMID, INPUTALLOWED:INPUTALLOWED, LEDGER_ID:LEDGER_ID, ID:ID, ROLE_VIEW:ROLE_VIEW, ROLE_MODIFY:ROLE_MODIFY, ROLE_POST:ROLE_POST"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "QUANTITY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_APBUDGET]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "QUANTITY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_APBUDGET]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_APBUDGET]', 'U') IS NULL CREATE TABLE [dbo].[M_APBUDGET] ([LEDGER] varchar(12),\n[NOMINAL] varchar(12),\n[ACCOUNT] varchar(12),\n[BUDGETCODE] varchar(12),\n[YEARCODE] varchar(10),\n[PERIOD] varchar(4),\n[BALANCE] decimal(19,4),\n[COMPANYCODE] varchar(12),\n[QUANTITY] decimal(19,4),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, NOMINAL:NOMINAL, ACCOUNT:ACCOUNT, BUDGETCODE:BUDGETCODE, YEARCODE:YEARCODE, PERIODTongERIOD, BALANCE:BALANCE, COMPANYCODE:COMPANYCODE, QUANTITY:QUANTITY, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "BANKACCT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SORTCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "LASTSHEET",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "BANKTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_BANKACCT]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "BANKACCT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SORTCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "LASTSHEET",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "BANKTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_BANKACCT]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_BANKACCT]', 'U') IS NULL CREATE TABLE [dbo].[M_BANKACCT] ([BANKACCT] varchar(12),\n[TITLE] varchar(40),\n[NOMINAL] varchar(12),\n[ACCOUNT] varchar(12),\n[SORTCODE] varchar(12),\n[BALANCE] decimal(19,4),\n[LASTSHEET] int,\n[BANKTYPE] char(1),\n[ACCESS] int,\n[COMMID] int,\n[INPUTALLOWED] char(1),\n[COMPANYCODE] varchar(12),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "BANKACCT:BANKACCT, TITLE:TITLE, NOMINAL:NOMINAL, ACCOUNT:ACCOUNT, SORTCODE:SORTCODE, BALANCE:BALANCE, LASTSHEET:LASTSHEET, BANKTYPE:BANKTYPE, ACCESS:ACCESS, COMMID:COMMID, INPUTALLOWED:INPUTALLOWED, COMPANYCODE:COMPANYCODE, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "TRANSACTIONAL",
                                        "type": "Boolean"
                                    }
                                ],
                                "tableName": "[dbo].[M_BUDGET]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "TRANSACTIONAL",
                                        "type": "Boolean"
                                    }
                                ],
                                "tableName": "[dbo].[M_BUDGET]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_BUDGET]', 'U') IS NULL CREATE TABLE [dbo].[M_BUDGET] ([BUDGETCODE] varchar(12),\n[TITLE] varchar(40),\n[ACCESS] int,\n[ID] int,\n[TRANSACTIONAL] bit);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "BUDGETCODE:BUDGETCODE, TITLE:TITLE, ACCESS:ACCESS, ID:ID, TRANSACTIONAL:TRANSACTIONAL"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "REFNO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCNUM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMITVAL",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAIL_ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_COMMITMENTS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "REFNO",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCNUM",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMITVAL",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAIL_ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_COMMITMENTS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_COMMITMENTS]', 'U') IS NULL CREATE TABLE [dbo].[M_COMMITMENTS] ([REFNO] int,\n[DOCNUM] int,\n[LEDGER] varchar(12),\n[NOMINAL] varchar(12),\n[ACCOUNT] varchar(12),\n[YEARCODE] varchar(10),\n[PERIOD] varchar(4),\n[COMMITVAL] decimal(19,4),\n[COMPANYCODE] varchar(12),\n[DOCTYPE] varchar(4),\n[NOMINAL_ID] int,\n[ID] int,\n[DETAIL_ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "REFNO:REFNO, DOCNUMLaughingOCNUM, LEDGER:LEDGER, NOMINAL:NOMINAL, ACCOUNT:ACCOUNT, YEARCODE:YEARCODE, PERIODTongERIOD, COMMITVAL:COMMITVAL, COMPANYCODE:COMPANYCODE, DOCTYPELaughingOCTYPE, NOMINAL_ID:NOMINAL_ID, ID:ID, DETAIL_IDLaughingETAIL_ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLETEMPLATE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USE_TAX",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_COMPANY]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLETEMPLATE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USE_TAX",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_COMPANY]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_COMPANY]', 'U') IS NULL CREATE TABLE [dbo].[M_COMPANY] ([COMPANYCODE] varchar(12),\n[TITLE] varchar(40),\n[TITLETEMPLATE] varchar(50),\n[USE_TAX] bit,\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "COMPANYCODE:COMPANYCODE, TITLE:TITLE, TITLETEMPLATE:TITLETEMPLATE, USE_TAX:USE_TAX, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "SYMBOL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DISPLAYDECIMALS",
                                        "type": "Int16"
                                    },
                                    {
                                        "name": "RATEDECIMALS",
                                        "type": "Int16"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_CURRENCY]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "SYMBOL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DISPLAYDECIMALS",
                                        "type": "Int16"
                                    },
                                    {
                                        "name": "RATEDECIMALS",
                                        "type": "Int16"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_CURRENCY]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_CURRENCY]', 'U') IS NULL CREATE TABLE [dbo].[M_CURRENCY] ([CURRENCY] varchar(12),\n[TITLE] varchar(40),\n[ACCESS] int,\n[COMMID] int,\n[SYMBOL] varchar(4),\n[DISPLAYDECIMALS] smallint,\n[RATEDECIMALS] smallint,\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "CURRENCY:CURRENCY, TITLE:TITLE, ACCESS:ACCESS, COMMID:COMMID, SYMBOL:SYMBOL, DISPLAYDECIMALSLaughingISPLAYDECIMALS, RATEDECIMALS:RATEDECIMALS, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "RANGETYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "REVERSAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REVERSALN",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "SHOWTURNOVER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCCOUNT",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "CALCDISCOUNTS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTFORM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REGISTERFORM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REGISTER",
                                        "type": "Int16"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "AUTOPRINTUDI",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "OUTPUTFORM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CHECK_MINIMUM_BALANCE",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "CHECK_MAXIMUM_BALANCE",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_DOCTYPE]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "RANGETYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "REVERSAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REVERSALN",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "SHOWTURNOVER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DOCCOUNT",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "CALCDISCOUNTS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTFORM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REGISTERFORM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "REGISTER",
                                        "type": "Int16"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "AUTOPRINTUDI",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "OUTPUTFORM",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CHECK_MINIMUM_BALANCE",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "CHECK_MAXIMUM_BALANCE",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_DOCTYPE]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_DOCTYPE]', 'U') IS NULL CREATE TABLE [dbo].[M_DOCTYPE] ([DOCTYPE] varchar(4),\n[TITLE] varchar(40),\n[RANGETYPE] char(1),\n[DETAILSTATUS] char(1),\n[CURRENCY] varchar(12),\n[ACCESS] int,\n[COMMID] int,\n[REVERSAL] char(1),\n[REVERSALN] int,\n[SHOWTURNOVER] char(1),\n[DOCCOUNT] int,\n[CALCDISCOUNTS] char(1),\n[INPUTFORM] varchar(32),\n[REGISTERFORM] varchar(32),\n[REGISTER] smallint,\n[INPUTALLOWED] char(1),\n[AUTOPRINTUDI] int,\n[OUTPUTFORM] varchar(33),\n[CHECK_MINIMUM_BALANCE] tinyint,\n[CHECK_MAXIMUM_BALANCE] tinyint,\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "DOCTYPELaughingOCTYPE, TITLE:TITLE, RANGETYPE:RANGETYPE, DETAILSTATUSLaughingETAILSTATUS, CURRENCY:CURRENCY, ACCESS:ACCESS, COMMID:COMMID, REVERSAL:REVERSAL, REVERSALN:REVERSALN, SHOWTURNOVER:SHOWTURNOVER, DOCCOUNTLaughingOCCOUNT, CALCDISCOUNTS:CALCDISCOUNTS, INPUTFORM:INPUTFORM, REGISTERFORM:REGISTERFORM, REGISTER:REGISTER, INPUTALLOWED:INPUTALLOWED, AUTOPRINTUDI:AUTOPRINTUDI, OUTPUTFORM:OUTPUTFORM, CHECK_MINIMUM_BALANCE:CHECK_MINIMUM_BALANCE, CHECK_MAXIMUM_BALANCE:CHECK_MAXIMUM_BALANCE, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "HIERARCHICAL",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_KEYLIST]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "HIERARCHICAL",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_KEYLIST]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_KEYLIST]', 'U') IS NULL CREATE TABLE [dbo].[M_KEYLIST] ([KEYLIST] varchar(12),\n[TITLE] varchar(40),\n[HIERARCHICAL] bit,\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "KEYLIST:KEYLIST, TITLE:TITLE, HIERARCHICAL:HIERARCHICAL, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYFIELD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYENTRIES",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYSTATE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_KEYS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "KEYNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYLEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYFIELD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYENTRIES",
                                        "type": "String"
                                    },
                                    {
                                        "name": "KEYSTATE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_KEYS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_KEYS]', 'U') IS NULL CREATE TABLE [dbo].[M_KEYS] ([KEYNAME] varchar(12),\n[TITLE] varchar(40),\n[KEYLEDGER] char(1),\n[LEDGER] varchar(12),\n[KEYFIELD] varchar(18),\n[KEYVALUE] char(1),\n[KEYENTRIES] char(1),\n[KEYSTATE] char(1),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "KEYNAME:KEYNAME, TITLE:TITLE, KEYLEDGER:KEYLEDGER, LEDGER:LEDGER, KEYFIELD:KEYFIELD, KEYVALUE:KEYVALUE, KEYENTRIES:KEYENTRIES, KEYSTATE:KEYSTATE, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNTRANGE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FROMACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TOACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "VATDEFCTRYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESSFORMAT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CHANGEREF",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "EXTERNALALLOC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "WRITEOFFLIMIT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "WRITEOFFDOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRDIFFDOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADVANCEDSEARCH",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "FLAGS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "VALIDATION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACC_DEFAULT_TAB",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BANK_DETAILS_REQUIRED",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "PAYMENT_TERMS_REQUIRED",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "ROLE_VIEW",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_POST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_VIEW_ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY_ACCOUNT",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[M_LEDGER]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNTRANGE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FROMACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TOACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "VATDEFCTRYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESSFORMAT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CHANGEREF",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "EXTERNALALLOC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "WRITEOFFLIMIT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "WRITEOFFDOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRDIFFDOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADVANCEDSEARCH",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "FLAGS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "VALIDATION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACC_DEFAULT_TAB",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BANK_DETAILS_REQUIRED",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "PAYMENT_TERMS_REQUIRED",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "ROLE_VIEW",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_POST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_VIEW_ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY_ACCOUNT",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[M_LEDGER]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_LEDGER]', 'U') IS NULL CREATE TABLE [dbo].[M_LEDGER] ([LEDGER] varchar(12),\n[TITLE] varchar(40),\n[TYPE] char(1),\n[NOMINAL] varchar(12),\n[ACCOUNTRANGE] char(1),\n[FROMACCOUNT] varchar(12),\n[TOACCOUNT] varchar(12),\n[ACCESS] int,\n[COMMID] int,\n[VATDEFCTRYCODE] varchar(2),\n[ADDRESSFORMAT] varchar(4),\n[CHANGEREF] int,\n[DETAILSTATUS] char(1),\n[EXTERNALALLOC] char(1),\n[WRITEOFFLIMIT] decimal(19,4),\n[WRITEOFFDOCTYPE] varchar(4),\n[CURRDIFFDOCTYPE] varchar(4),\n[INPUTALLOWED] char(1),\n[ADVANCEDSEARCH] varchar(1),\n[ID] int,\n[FLAGS] int,\n[VALIDATION] varchar(256),\n[ACC_DEFAULT_TAB] varchar(20),\n[BANK_DETAILS_REQUIRED] bit,\n[PAYMENT_TERMS_REQUIRED] bit,\n[ROLE_VIEW] varchar(12),\n[ROLE_MODIFY] varchar(12),\n[ROLE_POST] varchar(12),\n[ROLE_VIEW_ACCOUNT] varchar(12),\n[ROLE_MODIFY_ACCOUNT] varchar(12));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, TITLE:TITLE, TYPE:TYPE, NOMINAL:NOMINAL, ACCOUNTRANGE:ACCOUNTRANGE, FROMACCOUNT:FROMACCOUNT, TOACCOUNT:TOACCOUNT, ACCESS:ACCESS, COMMID:COMMID, VATDEFCTRYCODE:VATDEFCTRYCODE, ADDRESSFORMAT:ADDRESSFORMAT, CHANGEREF:CHANGEREF, DETAILSTATUSLaughingETAILSTATUS, EXTERNALALLOC:EXTERNALALLOC, WRITEOFFLIMIT:WRITEOFFLIMIT, WRITEOFFDOCTYPE:WRITEOFFDOCTYPE, CURRDIFFDOCTYPE:CURRDIFFDOCTYPE, INPUTALLOWED:INPUTALLOWED, ADVANCEDSEARCH:ADVANCEDSEARCH, ID:ID, FLAGS:FLAGS, VALIDATION:VALIDATION, ACC_DEFAULT_TAB:ACC_DEFAULT_TAB, BANK_DETAILS_REQUIRED:BANK_DETAILS_REQUIRED, PAYMENT_TERMS_REQUIREDTongAYMENT_TERMS_REQUIRED, ROLE_VIEW:ROLE_VIEW, ROLE_MODIFY:ROLE_MODIFY, ROLE_POST:ROLE_POST, ROLE_VIEW_ACCOUNT:ROLE_VIEW_ACCOUNT, ROLE_MODIFY_ACCOUNT:ROLE_MODIFY_ACCOUNT"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "MANDATORY",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "USERFIELD_POSITION",
                                        "type": "Int16"
                                    }
                                ],
                                "tableName": "[dbo].[M_LEDGERUSERFIELDS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERFIELD_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "MANDATORY",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "USERFIELD_POSITION",
                                        "type": "Int16"
                                    }
                                ],
                                "tableName": "[dbo].[M_LEDGERUSERFIELDS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_LEDGERUSERFIELDS]', 'U') IS NULL CREATE TABLE [dbo].[M_LEDGERUSERFIELDS] ([LEDGER_ID] int,\n[USERFIELD_ID] int,\n[MANDATORY] bit,\n[USERFIELD_POSITION] smallint);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER_ID:LEDGER_ID, USERFIELD_ID:USERFIELD_ID, MANDATORY:MANDATORY, USERFIELD_POSITION:USERFIELD_POSITION"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PRENAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESSNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESS1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESS2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESS3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSTTOWN",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COUNTY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSTCODE1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSTCODE2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COUNTRY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TELEPHONE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FAXNO",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXNUMBER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CONTACT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SALUTATION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "RSCOMMENT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FACTORLEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FACTORACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CREDITLIMIT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "TAXCTRYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESSFORMAT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TURNOVERLIMIT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "EMAIL_ADDRESS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_NAMEACCOUNT]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PRENAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESSNAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESS1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESS2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESS3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSTTOWN",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COUNTY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSTCODE1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "POSTCODE2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COUNTRY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TELEPHONE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FAXNO",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXNUMBER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CONTACT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SALUTATION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "RSCOMMENT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FACTORLEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FACTORACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CREDITLIMIT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "TAXCTRYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADDRESSFORMAT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TURNOVERLIMIT",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "EMAIL_ADDRESS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_NAMEACCOUNT]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_NAMEACCOUNT]', 'U') IS NULL CREATE TABLE [dbo].[M_NAMEACCOUNT] ([LEDGER] varchar(12),\n[ACCOUNT] varchar(12),\n[PRENAME] varchar(40),\n[ADDRESSNAME] varchar(45),\n[ADDRESS1] varchar(40),\n[ADDRESS2] varchar(40),\n[ADDRESS3] varchar(40),\n[POSTTOWN] varchar(40),\n[COUNTY] varchar(40),\n[POSTCODE1] varchar(20),\n[POSTCODE2] varchar(4),\n[COUNTRY] varchar(40),\n[TELEPHONE] varchar(32),\n[FAXNO] varchar(32),\n[TAXNUMBER] varchar(20),\n[CONTACT] varchar(40),\n[SALUTATION] varchar(30),\n[RSCOMMENT] varchar(40),\n[FACTORLEDGER] varchar(12),\n[FACTORACCOUNT] varchar(12),\n[CREDITLIMIT] decimal(19,4),\n[TAXCTRYCODE] varchar(2),\n[ADDRESSFORMAT] varchar(4),\n[TURNOVERLIMIT] decimal(19,4),\n[EMAIL_ADDRESS] varchar(256),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, ACCOUNT:ACCOUNT, PRENAMETongRENAME, ADDRESSNAME:ADDRESSNAME, ADDRESS1:ADDRESS1, ADDRESS2:ADDRESS2, ADDRESS3:ADDRESS3, POSTTOWNTongOSTTOWN, COUNTY:COUNTY, POSTCODE1TongOSTCODE1, POSTCODE2TongOSTCODE2, COUNTRY:COUNTRY, TELEPHONE:TELEPHONE, FAXNO:FAXNO, TAXNUMBER:TAXNUMBER, CONTACT:CONTACT, SALUTATION:SALUTATION, RSCOMMENT:RSCOMMENT, FACTORLEDGER:FACTORLEDGER, FACTORACCOUNT:FACTORACCOUNT, CREDITLIMIT:CREDITLIMIT, TAXCTRYCODE:TAXCTRYCODE, ADDRESSFORMAT:ADDRESSFORMAT, TURNOVERLIMIT:TURNOVERLIMIT, EMAIL_ADDRESS:EMAIL_ADDRESS, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ALLOCATION",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "EXTERNALALLOC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SHOWUSERVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN4",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN5",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN6",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN7",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN8",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN9",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN10",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PROFILE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USE_BALANCE_CHECK",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "MINIMUM_BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "MAXIMUM_BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ROLE_VIEW",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_ADD_LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_POST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD_SET_ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_NOMINAL]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ALLOCATION",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DETAILSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "EXTERNALALLOC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SHOWUSERVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CURRENCY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "INPUTALLOWED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN4",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN5",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN6",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN7",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN8",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN9",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMAN10",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PROFILE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USE_BALANCE_CHECK",
                                        "type": "Boolean"
                                    },
                                    {
                                        "name": "MINIMUM_BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "MAXIMUM_BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ROLE_VIEW",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_MODIFY",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_ADD_LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_POST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERFIELD_SET_ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_NOMINAL]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_NOMINAL]', 'U') IS NULL CREATE TABLE [dbo].[M_NOMINAL] ([NOMINAL] varchar(12),\n[TITLE] varchar(40),\n[LEDGER] varchar(12),\n[TYPE] char(1),\n[TAXCODE] varchar(12),\n[ALLOCATION] int,\n[DETAILSTATUS] char(1),\n[EXTERNALALLOC] char(1),\n[SHOWUSERVALUE] char(1),\n[CURRENCY] varchar(12),\n[ACCESS] int,\n[COMMID] int,\n[INPUTALLOWED] char(1),\n[COMPANYCODE] varchar(12),\n[NOMAN1] varchar(8),\n[NOMAN2] varchar(8),\n[NOMAN3] varchar(8),\n[NOMAN4] varchar(8),\n[NOMAN5] varchar(8),\n[NOMAN6] varchar(8),\n[NOMAN7] varchar(8),\n[NOMAN8] varchar(20),\n[NOMAN9] varchar(20),\n[NOMAN10] varchar(20),\n[PROFILE] varchar(12),\n[LEDGER_ID] int,\n[USE_BALANCE_CHECK] bit,\n[MINIMUM_BALANCE] decimal(19,4),\n[MAXIMUM_BALANCE] decimal(19,4),\n[ID] int,\n[ROLE_VIEW] varchar(12),\n[ROLE_MODIFY] varchar(12),\n[ROLE_ADD_LEDGER] varchar(12),\n[ROLE_POST] varchar(12),\n[USERFIELD_SET_ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "NOMINAL:NOMINAL, TITLE:TITLE, LEDGER:LEDGER, TYPE:TYPE, TAXCODE:TAXCODE, ALLOCATION:ALLOCATION, DETAILSTATUSLaughingETAILSTATUS, EXTERNALALLOC:EXTERNALALLOC, SHOWUSERVALUE:SHOWUSERVALUE, CURRENCY:CURRENCY, ACCESS:ACCESS, COMMID:COMMID, INPUTALLOWED:INPUTALLOWED, COMPANYCODE:COMPANYCODE, NOMAN1:NOMAN1, NOMAN2:NOMAN2, NOMAN3:NOMAN3, NOMAN4:NOMAN4, NOMAN5:NOMAN5, NOMAN6:NOMAN6, NOMAN7:NOMAN7, NOMAN8:NOMAN8, NOMAN9:NOMAN9, NOMAN10:NOMAN10, PROFILETongROFILE, LEDGER_ID:LEDGER_ID, USE_BALANCE_CHECK:USE_BALANCE_CHECK, MINIMUM_BALANCE:MINIMUM_BALANCE, MAXIMUM_BALANCE:MAXIMUM_BALANCE, ID:ID, ROLE_VIEW:ROLE_VIEW, ROLE_MODIFY:ROLE_MODIFY, ROLE_ADD_LEDGER:ROLE_ADD_LEDGER, ROLE_POST:ROLE_POST, USERFIELD_SET_ID:USERFIELD_SET_ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "QUANTITY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_NPBUDGET]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LEDGER",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BUDGETCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "BALANCE",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "QUANTITY",
                                        "type": "Decimal"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_NPBUDGET]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_NPBUDGET]', 'U') IS NULL CREATE TABLE [dbo].[M_NPBUDGET] ([LEDGER] varchar(12),\n[NOMINAL] varchar(12),\n[BUDGETCODE] varchar(12),\n[YEARCODE] varchar(10),\n[PERIOD] varchar(4),\n[BALANCE] decimal(19,4),\n[COMPANYCODE] varchar(12),\n[QUANTITY] decimal(19,4),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LEDGER:LEDGER, NOMINAL:NOMINAL, BUDGETCODE:BUDGETCODE, YEARCODE:YEARCODE, PERIODTongERIOD, BALANCE:BALANCE, COMPANYCODE:COMPANYCODE, QUANTITY:QUANTITY, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "PARAMKEY",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PARAMVALUE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "LOCKING",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_PARAMNUMS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "PARAMKEY",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "PARAMVALUE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "LOCKING",
                                        "type": "Byte"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_PARAMNUMS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_PARAMNUMS]', 'U') IS NULL CREATE TABLE [dbo].[M_PARAMNUMS] ([PARAMKEY] int,\n[PARAMVALUE] int,\n[LOCKING] tinyint,\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "PARAMKEYTongARAMKEY, PARAMVALUETongARAMVALUE, LOCKING:LOCKING, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIODEND",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "MNEMONIC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_PERIOD]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "YEARCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIOD",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PERIODEND",
                                        "type": "DateTime"
                                    },
                                    {
                                        "name": "ACCESS",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "MNEMONIC",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_PERIOD]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_PERIOD]', 'U') IS NULL CREATE TABLE [dbo].[M_PERIOD] ([YEARCODE] varchar(10),\n[PERIOD] varchar(4),\n[TITLE] varchar(40),\n[PERIODEND] datetime,\n[ACCESS] int,\n[MNEMONIC] varchar(6),\n[COMPANYCODE] varchar(12),\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "YEARCODE:YEARCODE, PERIODTongERIOD, TITLE:TITLE, PERIODENDTongERIODEND, ACCESS:ACCESS, MNEMONIC:MNEMONIC, COMPANYCODE:COMPANYCODE, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DATA_TYPE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DESCRIPTION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_USERFIELDS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DATA_TYPE",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "KEYLIST",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DESCRIPTION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "LEDGER_ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[M_USERFIELDS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_USERFIELDS]', 'U') IS NULL CREATE TABLE [dbo].[M_USERFIELDS] ([ID] int,\n[TITLE] varchar(40),\n[DATA_TYPE] int,\n[KEYLIST] varchar(12),\n[DESCRIPTION] varchar(64),\n[LEDGER_ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "ID:ID, TITLE:TITLE, DATA_TYPELaughingATA_TYPE, KEYLIST:KEYLIST, DESCRIPTIONLaughingESCRIPTION, LEDGER_ID:LEDGER_ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERGROUP",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_NAME",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[M_USERGROUP_ROLES]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "USERGROUP",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROLE_NAME",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[M_USERGROUP_ROLES]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[M_USERGROUP_ROLES]', 'U') IS NULL CREATE TABLE [dbo].[M_USERGROUP_ROLES] ([ID] int,\n[USERGROUP] varchar(8),\n[ROLE_NAME] varchar(12));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "ID:ID, USERGROUP:USERGROUP, ROLE_NAME:ROLE_NAME"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "POPSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETDETAILS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETDOCUMENT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETLINKED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "AUTOPRINT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMITAMOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FIXED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADVANCE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "STOCKLINK",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DISPUTE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCRUE_VALUE",
                                        "type": "Boolean"
                                    }
                                ],
                                "tableName": "[dbo].[MP_DOCSTATUS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "POPSTATUS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETDETAILS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETDOCUMENT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETLINKED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "AUTOPRINT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMITAMOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "FIXED",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ADVANCE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "STOCKLINK",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DISPUTE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCRUE_VALUE",
                                        "type": "Boolean"
                                    }
                                ],
                                "tableName": "[dbo].[MP_DOCSTATUS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[MP_DOCSTATUS]', 'U') IS NULL CREATE TABLE [dbo].[MP_DOCSTATUS] ([POPSTATUS] varchar(10),\n[TITLE] varchar(40),\n[SETDETAILS] char(1),\n[SETDOCUMENT] char(1),\n[SETLINKED] char(1),\n[AUTOPRINT] char(1),\n[COMMITAMOUNT] char(1),\n[FIXED] char(1),\n[ADVANCE] varchar(4),\n[STOCKLINK] varchar(4),\n[DISPUTE] varchar(6),\n[ACCRUE_VALUE] bit);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "POPSTATUSTongOPSTATUS, TITLE:TITLE, SETDETAILS:SETDETAILS, SETDOCUMENT:SETDOCUMENT, SETLINKED:SETLINKED, AUTOPRINT:AUTOPRINT, COMMITAMOUNT:COMMITAMOUNT, FIXED:FIXED, ADVANCE:ADVANCE, STOCKLINK:STOCKLINK, DISPUTELaughingISPUTE, ACCRUE_VALUE:ACCRUE_VALUE"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCCOUNT",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "UFNAME1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UFNAME2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UFNAME3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UFMAP1",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "UFMAP2",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "UFMAP3",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[MP_DOCTYPE]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "DOCTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMMID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "DOCCOUNT",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "UFNAME1",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UFNAME2",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UFNAME3",
                                        "type": "String"
                                    },
                                    {
                                        "name": "UFMAP1",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "UFMAP2",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "UFMAP3",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[MP_DOCTYPE]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[MP_DOCTYPE]', 'U') IS NULL CREATE TABLE [dbo].[MP_DOCTYPE] ([DOCTYPE] varchar(4),\n[TITLE] varchar(40),\n[COMMID] int,\n[DOCCOUNT] int,\n[UFNAME1] varchar(20),\n[UFNAME2] varchar(20),\n[UFNAME3] varchar(20),\n[UFMAP1] int,\n[UFMAP2] int,\n[UFMAP3] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "DOCTYPELaughingOCTYPE, TITLE:TITLE, COMMID:COMMID, DOCCOUNTLaughingOCCOUNT, UFNAME1:UFNAME1, UFNAME2:UFNAME2, UFNAME3:UFNAME3, UFMAP1:UFMAP1, UFMAP2:UFMAP2, UFMAP3:UFMAP3"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "LOCATION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PARENT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DELIVERYADDRESS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CONTACT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DELIVERYDETAILS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROUTE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "VAT_NOMINAL_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[MP_LOCATION]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "LOCATION",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TITLE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "PARENT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NAME",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "NOMINAL",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ACCOUNT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DELIVERYADDRESS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "CONTACT",
                                        "type": "String"
                                    },
                                    {
                                        "name": "DELIVERYDETAILS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "ROUTE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "TAXTYPE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "VAT_NOMINAL_ID",
                                        "type": "Int32"
                                    },
                                    {
                                        "name": "ID",
                                        "type": "Int32"
                                    }
                                ],
                                "tableName": "[dbo].[MP_LOCATION]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[MP_LOCATION]', 'U') IS NULL CREATE TABLE [dbo].[MP_LOCATION] ([LOCATION] varchar(14),\n[TITLE] varchar(40),\n[PARENT] varchar(12),\n[NAME] varchar(18),\n[NODE] varchar(12),\n[NOMINAL] varchar(12),\n[ACCOUNT] varchar(12),\n[DELIVERYADDRESS] varchar(254),\n[CONTACT] varchar(40),\n[DELIVERYDETAILS] varchar(254),\n[ROUTE] varchar(12),\n[COMPANYCODE] varchar(12),\n[TAXTYPE] varchar(12),\n[VAT_NOMINAL_ID] int,\n[ID] int);\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "LOCATION:LOCATION, TITLE:TITLE, PARENTTongARENT, NAME:NAME, NODE:NODE, NOMINAL:NOMINAL, ACCOUNT:ACCOUNT, DELIVERYADDRESSLaughingELIVERYADDRESS, CONTACT:CONTACT, DELIVERYDETAILSLaughingELIVERYDETAILS, ROUTE:ROUTE, COMPANYCODE:COMPANYCODE, TAXTYPE:TAXTYPE, VAT_NOMINAL_ID:VAT_NOMINAL_ID, ID:ID"
                                }
                            }
                        },
                        {
                            "source": {
                                "structure": [
                                    {
                                        "name": "SETTINGCLASS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETTING",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETTINGVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERID",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[PSF_SETTINGS]"
                            },
                            "destination": {
                                "structure": [
                                    {
                                        "name": "SETTINGCLASS",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETTING",
                                        "type": "String"
                                    },
                                    {
                                        "name": "COMPANYCODE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "SETTINGVALUE",
                                        "type": "String"
                                    },
                                    {
                                        "name": "USERID",
                                        "type": "String"
                                    }
                                ],
                                "tableName": "[dbo].[PSF_SETTINGS]"
                            },
                            "copySink": {
                                "preCopyScript": "BEGIN TRY\nIF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'dbo') EXEC('Create Schema [dbo]');\nEND TRY\nBEGIN CATCH\nif ERROR_NUMBER() <> 2714 throw;\nEND CATCH\n\nIF OBJECT_ID('[dbo].[PSF_SETTINGS]', 'U') IS NULL CREATE TABLE [dbo].[PSF_SETTINGS] ([SETTINGCLASS] varchar(50),\n[SETTING] varchar(50),\n[COMPANYCODE] varchar(12),\n[SETTINGVALUE] varchar(2000),\n[USERID] varchar(24));\n"
                            },
                            "copyActivity": {
                                "translator": {
                                    "type": "TabularTranslator",
                                    "columnMappings": "SETTINGCLASS:SETTINGCLASS, SETTING:SETTING, COMPANYCODE:COMPANYCODE, SETTINGVALUE:SETTINGVALUE, USERID:USERID"
                                }
                            }
                        }
                    ]
                },
                "lse_name": {
                    "type": "String",
                    "defaultValue": "########"
                }
            }
        },
        "type": "Microsoft.DataFactory/factories/pipelines"
    }

    and the linked service..

    {
        "name": "Lse########",
        "type": "Microsoft.DataFactory/factories/linkedservices",
        "properties": {
            "type": "SqlServer",
            "typeProperties": {
                "connectionString": {
                    "type": "SecureString",
                    "value": "**********"
                },
                "userName": ##########,
                "encryptedCredential": "eyJDcmVkZW50aWFsSWQiOiI1YzIzYjEzMC0yZWExLTQ4OWQtYjRmNi00MDhhY2VlODI4MjgiLCJWZXJzaW9uIjoiMi4wIiwiQ2xhc3NUeXBlIjoiTWljcm9zb2Z0LkRhdGFQcm94eS5Db3JlLkludGVyU2VydmljZURhdGFDb250cmFjdC5DcmVkZW50aWFsU1UwNkNZMTQifQ=="
            },
            "connectVia": {
                "referenceName": "IR-########,
                "type": "IntegrationRuntimeReference"
            }
        }
    }

  • Gagandeep Singh

    7/10/2018 10:33:36 AM | Reply

    Thanks Matt for the reply on Until activity earlier. Although I dont know why I am not able to see my reply here.

    Now I am aware about how to use body() tag in the UNTIL condition. However, do you have any idea how to update the pipeline parameter inside of the pipeline. Basically the response which I am getting through a web activity has pagination i.e. it gives the link/endpoint of the 2nd page inside the response of the first page. Hence if its the last page then the link tag in the response would be empty.

    Now that I have put the required condition in the UNTIL expression using body(), I am not sure how should I update the url parameter after the web activity with the url of the next page. Any idea?

  • levenyu

    9/3/2018 3:05:47 PM | Reply

    Hi Matt,
    RE: "P.S. Use this link to see the entire json script used to create all the objects required for this blog.  http://bit.ly/2zwZFLB";
    Please clarify where the following is defined?
    "parameters": {
                    "tableName": "@Pipeline().parameters.inputTableName"
                  }
    RE: "When we invoke our pipeline, I will show how to reference that file but for now we know we are working with a single parameter called “tableName”."
    Yet, I could not find where you explain how to use and reference that parameter file.

    Thank you.

Pingbacks and trackbacks (3)+

Loading