{
    "name": "Pipeline 1",
    "properties": {
        "activities": [
            {
                "name": "Copy data1",
                "type": "Copy",
                "dependsOn": [],
                "policy": {
                    "timeout": "0.12:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [],
                "typeProperties": {
                    "source": {
                        "type": "ExcelSource",
                        "storeSettings": {
                            "type": "AzureBlobFSReadSettings",
                            "recursive": true,
                            "enablePartitionDiscovery": false
                        }
                    },
                    "sink": {
                        "type": "SqlDWSink",
                        "allowCopyCommand": true
                    },
                    "enableStaging": true,
                    "stagingSettings": {
                        "linkedServiceName": {
                            "referenceName": "txcistgdwhsasql-WorkspaceDefaultStorage",
                            "type": "LinkedServiceReference"
                        },
                        "path": "logs/Recon KEPL"
                    },
                    "translator": {
                        "type": "TabularTranslator",
                        "mappings": [
                            {
                                "source": {
                                    "name": "Period",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Inward Return Month & Year",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Filing Period",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Filing Period",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Inv.Ref No",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Invoice Number from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Invoice Date",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Invoice Date from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "IGST-Amt",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "IGST Amount from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "CGST-Amt",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "CGST Amount from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "SGST-Amt",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "SGST Amount from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "CESS-Amount",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Cess from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Plc of Sply",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "POS from Inward",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Remark",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Match Status",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "EntityName",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "EntityName",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "FI Doc No",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "FIDocNo",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Profit Cntr",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "ProfitCntr",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "AcctDoc Po date",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "AcctDocPodate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "MIRO Docu No",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "MIRODocuNo",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "MIRO Pstng.Date",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "MIROPstngDate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Purchasing Docmnt",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "PurchasingDocmnt",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "PO Type",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "POType",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Item Number",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "ItemNumber",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Material No.",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "MaterialNo",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Material Dscp",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "MaterialDscp",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "HSN/SAC Code",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "HSNSACCode",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Material Type",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "MaterialType",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Heads of Prchs",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "HeadsofPrchs",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Sub Group",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "SubGroup",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "PO Text",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "POText",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Order Number",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "OrderNumber",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Valuation Type",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "ValuationType",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Cmpny Code",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "CmpnyCode",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "G/L Account",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GLAccount",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "G/L Account Description",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GLAccountDescription",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Transaction",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Transaction",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Plant",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Plant",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Bus.Place",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "BusPlace",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Fiscal Year",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "FiscalYear",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "TCODE",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TCODE",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Dstn Of Sply",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "DstnOfSply",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Ref.docu",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Refdocu",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": " Vendor Number",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "VendorNumber",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Vendor Name",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "VendorName",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Doc.Hdrtxt/PrtCode",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "DocHdrtxtPrtCode",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Ty.of docu",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Tyofdocu",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Ty.of Ac Docu",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TyofAcDocu",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "PAN No",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "PANNo",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "GSTIN No.of Vendor",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GSTINNoofVendor",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Cross GSTIN Chk",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "CrossGSTINChk",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Tax Code",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TaxCode",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "MIRO Item Tax Code",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "MIROItemTaxCode",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Tax Desp",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TaxDesp",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Tax Type",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TaxType",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Quantity",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Quantity",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Base UOM",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "BaseUOM",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "UQC",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "UQC",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Currency",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Currency",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Exchange Rate",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "ExchangeRate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Amnt/Ex-Works",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "AmntExWorks",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "IGST-Rate %",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "IGSTRate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "CGST-Rate %",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "CGSTRate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "SGST-Rate %",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "SGSTRate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "UGST-Rate %",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "UGSTRate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "UGST-Amount",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "UGSTAmount",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "CESS%",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "CESS",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "GST Comp. Cess",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GSTCompCess",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "GST Comp.Cess Value",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GSTCompCessValue",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "TCS Amt Manual",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TCSAmtManual",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Unplan Dlvr Cost",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "UnplanDlvrCost",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Gross pur amnt",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Grosspuramnt",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Total Taxes",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "TotalTaxes",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Vendor amnt",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Vendoramnt",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "GRN No",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GRNNo",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "GRN Date",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GRNDate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Year",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "Year",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "original Inv Ref Number",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "originalInvRefNumber",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Ref. Invoice Date",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "RefInvoiceDate",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Remarks for FI Doc",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "RemarksforFIDoc",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "GL Amount ",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "GLAmount",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Final Total Tax",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "FinalTotalTax",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Final Vendor Amount",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "FinalVendorAmount",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "IGST",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "IGST",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "CGST",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "CGST",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "SGST",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "SGST",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "UGST",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "UGST",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Remarks for Tax",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "RemarksforTax",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Financial Remarks"
                                },
                                "sink": {
                                    "name": "FinancialRemarks",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "Input Type",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "InputType",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "BSR Comments",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "BSRComments",
                                    "type": "String"
                                }
                            },
                            {
                                "source": {
                                    "name": "KEPL Reply",
                                    "type": "String"
                                },
                                "sink": {
                                    "name": "KEPLReply",
                                    "type": "String"
                                }
                            }
                        ]
                    }
                },
                "inputs": [
                    {
                        "referenceName": "Excel2",
                        "type": "DatasetReference",
                        "parameters": {
                            "Directory": "Rocncdm/KEPL Recon",
                            "FileName": {
                                "value": "ITC reco April-21.xlsx",
                                "type": "Expression"
                            }
                        }
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "AzureSynapseAnalyticsTable",
                        "type": "DatasetReference",
                        "parameters": {
                            "Table": "ReconciliationCDM",
                            "Schema": "dwh"
                        }
                    }
                ]
            }
        ],
        "annotations": []
    }
}