Beispiel #1
0
        private void InitClass()
        {
            DataSetName        = "dsmeta";
            Prefix             = "";
            Namespace          = "http://tempuri.org/dsmeta.xsd";
            EnforceConstraints = false;

            #region create DataTables
            MetaTable T;
            //////////////////// PROVISIONDETAIL /////////////////////////////////
            var tprovisiondetail = new provisiondetailTable();
            tprovisiondetail.addBaseColumns("idprovision", "description", "amount", "cu", "ct", "lu", "lt", "rownum", "adate", "idaccmotive", "ydetail");
            Tables.Add(tprovisiondetail);
            tprovisiondetail.defineKey("idprovision", "rownum");

            //////////////////// PROVISION /////////////////////////////////
            var tprovision = new provisionTable();
            tprovision.addBaseColumns("idprovision", "description", "idreg", "idepexp", "ct", "cu", "lt", "lu", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "active", "adate");
            Tables.Add(tprovision);
            tprovision.defineKey("idprovision");

            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "active", "annotation", "badgecode", "birthdate", "cf", "ct", "cu", "extmatricula", "foreigncf", "forename", "gender", "idcategory", "idcentralizedcategory", "idcity", "idmaritalstatus", "idnation", "idregistryclass", "idtitle", "location", "lt", "lu", "maritalsurname", "p_iva", "rtf", "surname", "title", "txt", "residence", "idregistrykind", "authorization_free", "multi_cf", "toredirect", "idaccmotivedebit", "idaccmotivecredit", "ccp", "flagbankitaliaproceeds", "idexternal", "ipa_fe", "flag_pa", "sdi_norifamm", "sdi_defrifamm");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// ACCMOTIVEAPPLIED /////////////////////////////////
            var taccmotiveapplied = new accmotiveappliedTable();
            taccmotiveapplied.addBaseColumns("idaccmotive", "paridaccmotive", "codemotive", "motive", "cu", "ct", "lu", "lt", "active", "idepoperation", "epoperation", "in_use", "flagdep", "flagamm");
            Tables.Add(taccmotiveapplied);
            taccmotiveapplied.defineKey("idaccmotive");

            #endregion


            #region DataRelation creation
            DataColumn [] CPar;
            DataColumn [] CChild;
            this.defineRelation("registry_provision", "registry", "provision", "idreg");
            this.defineRelation("provision_provisiondetail", "provision", "provisiondetail", "idprovision");
            this.defineRelation("accmotiveapplied_provisiondetail", "accmotiveapplied", "provisiondetail", "idaccmotive");
            #endregion
        }
Beispiel #2
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "active", "annotation", "badgecode", "birthdate", "cf", "ct", "cu", "extmatricula", "foreigncf", "forename", "gender", "idcategory", "idcentralizedcategory", "idmaritalstatus", "idnation", "idregistryclass", "idtitle", "location", "lt", "lu", "maritalsurname", "p_iva", "residence", "rtf", "surname", "title", "txt");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// ACCOUNT /////////////////////////////////
            var taccount = new accountTable();
            taccount.addBaseColumns("idacc", "ayear", "codeacc", "ct", "cu", "flagregistry", "flagtransitory", "flagupb", "idaccountkind", "lt", "lu", "nlevel", "paridacc", "printingorder", "rtf", "title", "txt");
            Tables.Add(taccount);
            taccount.defineKey("idacc");

            //////////////////// EPACC /////////////////////////////////
            var tepacc = new MetaTable("epacc");
            tepacc.defineColumn("yepacc", typeof(short), false);
            tepacc.defineColumn("nepacc", typeof(int), false);
            tepacc.defineColumn("description", typeof(string), false);
            tepacc.defineColumn("idreg", typeof(int));
            tepacc.defineColumn("start", typeof(DateTime));
            tepacc.defineColumn("stop", typeof(DateTime));
            tepacc.defineColumn("txt", typeof(string));
            tepacc.defineColumn("rtf", typeof(Byte[]));
            tepacc.defineColumn("adate", typeof(DateTime), false);
            tepacc.defineColumn("ct", typeof(DateTime), false);
            tepacc.defineColumn("cu", typeof(string), false);
            tepacc.defineColumn("lt", typeof(DateTime), false);
            tepacc.defineColumn("lu", typeof(string), false);
            tepacc.defineColumn("doc", typeof(string));
            tepacc.defineColumn("docdate", typeof(DateTime));
            tepacc.defineColumn("idrelated", typeof(string));
            tepacc.defineColumn("idepacc", typeof(int), false);
            tepacc.defineColumn("paridepacc", typeof(int));
            tepacc.defineColumn("nphase", typeof(short), false);
            tepacc.defineColumn("idman", typeof(int));
            tepacc.defineColumn("flagvariation", typeof(string));
            tepacc.defineColumn("idaccmotive", typeof(string));
            Tables.Add(tepacc);
            tepacc.defineKey("idepacc");

            //////////////////// EPACCYEAR /////////////////////////////////
            var tepaccyear = new MetaTable("epaccyear");
            tepaccyear.defineColumn("idepacc", typeof(int), false);
            tepaccyear.defineColumn("ayear", typeof(short), false);
            tepaccyear.defineColumn("idupb", typeof(string), false);
            tepaccyear.defineColumn("idacc", typeof(string), false);
            tepaccyear.defineColumn("amount", typeof(decimal), false);
            tepaccyear.defineColumn("amount2", typeof(decimal));
            tepaccyear.defineColumn("amount3", typeof(decimal));
            tepaccyear.defineColumn("amount4", typeof(decimal));
            tepaccyear.defineColumn("amount5", typeof(decimal));
            tepaccyear.defineColumn("lt", typeof(DateTime));
            tepaccyear.defineColumn("lu", typeof(string));
            tepaccyear.defineColumn("ct", typeof(DateTime));
            tepaccyear.defineColumn("cu", typeof(string));
            Tables.Add(tepaccyear);
            tepaccyear.defineKey("idepacc", "ayear");

            //////////////////// EPACCVAR /////////////////////////////////
            var tepaccvar = new MetaTable("epaccvar");
            tepaccvar.defineColumn("idepacc", typeof(int), false);
            tepaccvar.defineColumn("nvar", typeof(int), false);
            tepaccvar.defineColumn("adate", typeof(DateTime), false);
            tepaccvar.defineColumn("amount", typeof(decimal), false);
            tepaccvar.defineColumn("description", typeof(string), false);
            tepaccvar.defineColumn("ct", typeof(DateTime), false);
            tepaccvar.defineColumn("cu", typeof(string), false);
            tepaccvar.defineColumn("lt", typeof(DateTime), false);
            tepaccvar.defineColumn("lu", typeof(string), false);
            tepaccvar.defineColumn("amount2", typeof(decimal));
            tepaccvar.defineColumn("amount3", typeof(decimal));
            tepaccvar.defineColumn("amount4", typeof(decimal));
            tepaccvar.defineColumn("amount5", typeof(decimal));
            tepaccvar.defineColumn("yvar", typeof(short), false);
            Tables.Add(tepaccvar);
            tepaccvar.defineKey("idepacc", "nvar");

            //////////////////// UPB /////////////////////////////////
            var tupb = new upbTable();
            tupb.addBaseColumns("idupb", "active", "assured", "codeupb", "ct", "cu", "expiration", "granted", "lt", "lu", "paridupb", "previousappropriation", "previousassessment", "printingorder", "requested", "rtf", "title", "txt", "idman", "idunderwriter", "cupcode", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "flagactivity", "flagkind", "newcodeupb", "idtreasurer", "start", "stop", "cigcode");
            Tables.Add(tupb);
            tupb.defineKey("idupb");

            //////////////////// MANAGER /////////////////////////////////
            var tmanager = new managerTable();
            tmanager.addBaseColumns("active", "ct", "cu", "email", "lt", "lu", "passwordweb", "phonenumber", "rtf", "title", "txt", "userweb", "idman", "iddivision", "wantswarn", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "newidman", "financeactive");
            Tables.Add(tmanager);
            tmanager.defineKey("idman");

            //////////////////// EPACCSORTING /////////////////////////////////
            var tepaccsorting = new MetaTable("epaccsorting");
            tepaccsorting.defineColumn("amount", typeof(decimal), false);
            tepaccsorting.defineColumn("adate", typeof(DateTime), false);
            tepaccsorting.defineColumn("description", typeof(string));
            tepaccsorting.defineColumn("ct", typeof(DateTime), false);
            tepaccsorting.defineColumn("cu", typeof(string), false);
            tepaccsorting.defineColumn("lt", typeof(DateTime), false);
            tepaccsorting.defineColumn("lu", typeof(string), false);
            tepaccsorting.defineColumn("idsor", typeof(int), false);
            tepaccsorting.defineColumn("idepacc", typeof(int), false);
            tepaccsorting.defineColumn("ayear", typeof(short), false);
            tepaccsorting.defineColumn("rownum", typeof(int), false);
            tepaccsorting.defineColumn("!percentuale", typeof(string));
            tepaccsorting.defineColumn("!sortingkind", typeof(string));
            tepaccsorting.defineColumn("!sortcode", typeof(string));
            tepaccsorting.defineColumn("!sorting", typeof(string));
            tepaccsorting.defineColumn("kind", typeof(string));
            Tables.Add(tepaccsorting);
            tepaccsorting.defineKey("idepacc", "rownum");

            //////////////////// SORTINGVIEW /////////////////////////////////
            var tsortingview = new MetaTable("sortingview");
            tsortingview.defineColumn("sortingkind", typeof(string), false);
            tsortingview.defineColumn("idsor", typeof(int), false);
            tsortingview.defineColumn("sortcode", typeof(string), false);
            tsortingview.defineColumn("description", typeof(string), false);
            tsortingview.defineColumn("idsorkind", typeof(int));
            Tables.Add(tsortingview);
            tsortingview.defineKey("idsor");

            //////////////////// EPACCSORTINGVIEW /////////////////////////////////
            var tepaccsortingview = new MetaTable("epaccsortingview");
            tepaccsortingview.defineColumn("idepacc", typeof(int), false);
            tepaccsortingview.defineColumn("rownum", typeof(int), false);
            tepaccsortingview.defineColumn("yepacc", typeof(short), false);
            tepaccsortingview.defineColumn("nepacc", typeof(int), false);
            tepaccsortingview.defineColumn("nphase", typeof(short), false);
            tepaccsortingview.defineColumn("description", typeof(string));
            tepaccsortingview.defineColumn("amount", typeof(decimal), false);
            tepaccsortingview.defineColumn("ayear", typeof(short), false);
            tepaccsortingview.defineColumn("adate", typeof(DateTime), false);
            tepaccsortingview.defineColumn("idsorkind", typeof(int), false);
            tepaccsortingview.defineColumn("idsor", typeof(int), false);
            tepaccsortingview.defineColumn("sortingkind", typeof(string), false);
            tepaccsortingview.defineColumn("sortcode", typeof(string), false);
            tepaccsortingview.defineColumn("sorting", typeof(string), false);
            tepaccsortingview.defineColumn("lt", typeof(DateTime), false);
            tepaccsortingview.defineColumn("lu", typeof(string), false);
            tepaccsortingview.defineColumn("ct", typeof(DateTime), false);
            tepaccsortingview.defineColumn("cu", typeof(string), false);
            tepaccsortingview.defineColumn("kind", typeof(string));
            Tables.Add(tepaccsortingview);
            tepaccsortingview.defineKey("idepacc", "rownum");

            //////////////////// EPACCTOTAL /////////////////////////////////
            var tepacctotal = new MetaTable("epacctotal");
            tepacctotal.defineColumn("idepacc", typeof(int), false);
            tepacctotal.defineColumn("ayear", typeof(short), false);
            tepacctotal.defineColumn("available", typeof(decimal));
            tepacctotal.defineColumn("available2", typeof(decimal));
            tepacctotal.defineColumn("available3", typeof(decimal));
            tepacctotal.defineColumn("available4", typeof(decimal));
            tepacctotal.defineColumn("available5", typeof(decimal));
            tepacctotal.defineColumn("curramount", typeof(decimal));
            tepacctotal.defineColumn("curramount2", typeof(decimal));
            tepacctotal.defineColumn("curramount3", typeof(decimal));
            tepacctotal.defineColumn("curramount4", typeof(decimal));
            tepacctotal.defineColumn("curramount5", typeof(decimal));
            Tables.Add(tepacctotal);
            tepacctotal.defineKey("idepacc", "ayear");

            //////////////////// ACCMOTIVE /////////////////////////////////
            var taccmotive = new accmotiveTable();
            taccmotive.addBaseColumns("idaccmotive", "active", "codemotive", "ct", "cu", "lt", "lu", "paridaccmotive", "title", "flagdep", "flagamm", "expensekind");
            Tables.Add(taccmotive);
            taccmotive.defineKey("idaccmotive");

            #endregion


            #region DataRelation creation
            this.defineRelation("sortingview_epaccsorting", "sortingview", "epaccsorting", "idsor");
            this.defineRelation("epacc_epaccsorting", "epacc", "epaccsorting", "idepacc");
            this.defineRelation("epacc_epaccvar", "epacc", "epaccvar", "idepacc");
            this.defineRelation("account_epaccyear", "account", "epaccyear", "idacc");
            this.defineRelation("upb_epaccyear", "upb", "epaccyear", "idupb");
            this.defineRelation("epacc_epaccyear", "epacc", "epaccyear", "idepacc");
            this.defineRelation("accmotive_epacc", "accmotive", "epacc", "idaccmotive");
            var cPar   = new [] { epacc.Columns["idepacc"] };
            var cChild = new [] { epacc.Columns["paridepacc"] };
            Relations.Add(new DataRelation("epacc_epacc", cPar, cChild, false));

            this.defineRelation("registry_epacc", "registry", "epacc", "idreg");
            this.defineRelation("manager_epacc", "manager", "epacc", "idman");
            #endregion
        }
Beispiel #3
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// PROCEEDS /////////////////////////////////
            var tproceeds = new proceedsTable();
            tproceeds.addBaseColumns("kpro", "ypro", "npro", "npro_treasurer", "kproceedstransmission", "idtreasurer", "flag", "idreg", "idfin", "idman", "adate", "printdate", "txt", "rtf", "cu", "ct", "lu", "lt", "annulmentdate", "idstamphandling", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05");
            Tables.Add(tproceeds);
            tproceeds.defineKey("kpro");

            //////////////////// FIN /////////////////////////////////
            var tfin = new finTable();
            tfin.addBaseColumns("idfin", "ayear", "codefin", "ct", "cu", "lt", "lu", "printingorder", "rtf", "title", "txt", "nlevel", "paridfin", "flag");
            Tables.Add(tfin);
            tfin.defineKey("idfin");

            //////////////////// MANAGER /////////////////////////////////
            var tmanager = new managerTable();
            tmanager.addBaseColumns("idman", "title", "iddivision", "email", "phonenumber", "userweb", "passwordweb", "txt", "rtf", "cu", "ct", "lu", "lt", "active", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05");
            Tables.Add(tmanager);
            tmanager.defineKey("idman");

            //////////////////// TREASURER /////////////////////////////////
            var ttreasurer = new treasurerTable();
            ttreasurer.addBaseColumns("idtreasurer", "description", "flagdefault", "cin", "idbank", "idcab", "cc", "address", "cap", "city", "country", "phoneprefix", "phonenumber", "faxprefix", "faxnumber", "flagfruitful", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "cu", "ct", "lu", "lt", "active");
            Tables.Add(ttreasurer);
            ttreasurer.defineKey("idtreasurer");

            //////////////////// PROCEEDSTRANSMISSION /////////////////////////////////
            var tproceedstransmission = new proceedstransmissionTable();
            tproceedstransmission.addBaseColumns("kproceedstransmission", "yproceedstransmission", "nproceedstransmission", "idman", "idtreasurer", "transmissiondate", "cu", "ct", "lu", "lt");
            Tables.Add(tproceedstransmission);
            tproceedstransmission.defineKey("kproceedstransmission");

            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "title", "cf", "p_iva", "residence", "annotation", "birthdate", "gender", "surname", "forename", "foreigncf", "active", "txt", "rtf", "cu", "ct", "lu", "lt");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// INCOMELASTVIEW /////////////////////////////////
            var tincomelastview = new MetaTable("incomelastview");
            tincomelastview.defineColumn("idinc", typeof(int), false);
            tincomelastview.defineColumn("nphase", typeof(byte), false);
            tincomelastview.defineColumn("phase", typeof(string), false);
            tincomelastview.defineColumn("ymov", typeof(short), false);
            tincomelastview.defineColumn("nmov", typeof(int), false);
            tincomelastview.defineColumn("parentymov", typeof(short));
            tincomelastview.defineColumn("parentnmov", typeof(int));
            tincomelastview.defineColumn("parentidinc", typeof(int));
            tincomelastview.defineColumn("ayear", typeof(short), false);
            tincomelastview.defineColumn("idfin", typeof(int));
            tincomelastview.defineColumn("codefin", typeof(string));
            tincomelastview.defineColumn("finance", typeof(string));
            tincomelastview.defineColumn("idupb", typeof(string));
            tincomelastview.defineColumn("codeupb", typeof(string));
            tincomelastview.defineColumn("upb", typeof(string));
            tincomelastview.defineColumn("idreg", typeof(int));
            tincomelastview.defineColumn("registry", typeof(string));
            tincomelastview.defineColumn("idman", typeof(int));
            tincomelastview.defineColumn("manager", typeof(string));
            tincomelastview.defineColumn("kpro", typeof(int));
            tincomelastview.defineColumn("ypro", typeof(short));
            tincomelastview.defineColumn("npro", typeof(int));
            tincomelastview.defineColumn("doc", typeof(string));
            tincomelastview.defineColumn("docdate", typeof(DateTime));
            tincomelastview.defineColumn("description", typeof(string), false);
            tincomelastview.defineColumn("amount", typeof(decimal));
            tincomelastview.defineColumn("ayearstartamount", typeof(decimal));
            tincomelastview.defineColumn("curramount", typeof(decimal));
            tincomelastview.defineColumn("available", typeof(decimal));
            tincomelastview.defineColumn("unpartitioned", typeof(decimal));
            tincomelastview.defineColumn("flag", typeof(byte));
            tincomelastview.defineColumn("totflag", typeof(byte), false);
            tincomelastview.defineColumn("flagarrear", typeof(string));
            tincomelastview.defineColumn("autokind", typeof(byte));
            tincomelastview.defineColumn("autocode", typeof(int));
            tincomelastview.defineColumn("idpayment", typeof(int));
            tincomelastview.defineColumn("expiration", typeof(DateTime));
            tincomelastview.defineColumn("adate", typeof(DateTime), false);
            tincomelastview.defineColumn("nbill", typeof(int));
            tincomelastview.defineColumn("idpro", typeof(int));
            tincomelastview.defineColumn("cu", typeof(string), false);
            tincomelastview.defineColumn("ct", typeof(DateTime), false);
            tincomelastview.defineColumn("lu", typeof(string), false);
            tincomelastview.defineColumn("lt", typeof(DateTime), false);
            tincomelastview.defineColumn("idsor01", typeof(int));
            tincomelastview.defineColumn("idsor02", typeof(int));
            tincomelastview.defineColumn("idsor03", typeof(int));
            tincomelastview.defineColumn("idsor04", typeof(int));
            tincomelastview.defineColumn("idsor05", typeof(int));
            Tables.Add(tincomelastview);
            tincomelastview.defineKey("idinc");

            //////////////////// INCOMEPHASE /////////////////////////////////
            var tincomephase = new MetaTable("incomephase");
            tincomephase.defineColumn("nphase", typeof(byte), false);
            tincomephase.defineColumn("description", typeof(string), false);
            tincomephase.defineColumn("cu", typeof(string), false);
            tincomephase.defineColumn("ct", typeof(DateTime), false);
            tincomephase.defineColumn("lu", typeof(string), false);
            tincomephase.defineColumn("lt", typeof(DateTime), false);
            Tables.Add(tincomephase);
            tincomephase.defineKey("nphase");

            //////////////////// INCOMEVAR /////////////////////////////////
            var tincomevar = new incomevarTable();
            tincomevar.addBaseColumns("idinc", "nvar", "yvar", "description", "amount", "doc", "docdate", "adate", "txt", "rtf", "cu", "ct", "lu", "lt", "autokind", "idinvkind", "ninv", "yinv");
            Tables.Add(tincomevar);
            tincomevar.defineKey("idinc", "nvar");

            //////////////////// BANKTRANSACTION /////////////////////////////////
            var tbanktransaction = new banktransactionTable();
            tbanktransaction.addBaseColumns("yban", "nban", "kpro", "kind", "bankreference", "transactiondate", "valuedate", "amount", "kpay", "cu", "ct", "lu", "lt", "idexp", "idinc", "idpay", "idpro", "idbankimport");
            tbanktransaction.defineColumn("!nmov", typeof(int));
            Tables.Add(tbanktransaction);
            tbanktransaction.defineKey("yban", "nban", "kpro");

            //////////////////// PROCEEDS_BANKVIEW /////////////////////////////////
            var tproceeds_bankview = new MetaTable("proceeds_bankview");
            tproceeds_bankview.defineColumn("kpro", typeof(int), false);
            tproceeds_bankview.defineColumn("ypro", typeof(short), false);
            tproceeds_bankview.defineColumn("npro", typeof(int), false);
            tproceeds_bankview.defineColumn("idpro", typeof(int), false);
            tproceeds_bankview.defineColumn("idreg", typeof(int), false);
            tproceeds_bankview.defineColumn("registry", typeof(string), false);
            tproceeds_bankview.defineColumn("description", typeof(string));
            tproceeds_bankview.defineColumn("amount", typeof(decimal), false);
            tproceeds_bankview.defineColumn("ct", typeof(DateTime), false);
            tproceeds_bankview.defineColumn("cu", typeof(string), false);
            tproceeds_bankview.defineColumn("lt", typeof(DateTime), false);
            tproceeds_bankview.defineColumn("lu", typeof(string), false);
            Tables.Add(tproceeds_bankview);
            tproceeds_bankview.defineKey("kpro", "idpro");

            //////////////////// SORTINGKIND /////////////////////////////////
            var tsortingkind = new sortingkindTable();
            tsortingkind.addBaseColumns("idsorkind", "active", "ct", "cu", "description", "flagdate", "flag", "forcedN1", "forcedN2", "forcedN3", "forcedN4", "forcedN5", "forcedS1", "forcedS2", "forcedS3", "forcedS4", "forcedS5", "forcedv1", "forcedv2", "forcedv3", "forcedv4", "forcedv5", "labelfordate", "labeln1", "labeln2", "labeln3", "labeln4", "labeln5", "labels1", "labels2", "labels3", "labels4", "labels5", "labelv1", "labelv2", "labelv3", "labelv4", "labelv5", "lockedN1", "lockedN2", "lockedN3", "lockedN4", "lockedN5", "lockedS1", "lockedS2", "lockedS3", "lockedS4", "lockedS5", "lockedv1", "lockedv2", "lockedv3", "lockedv4", "lockedv5", "lt", "lu", "nodatelabel", "nphaseexpense", "nphaseincome", "totalexpression");
            Tables.Add(tsortingkind);
            tsortingkind.defineKey("idsorkind");

            //////////////////// INCOMESORTED /////////////////////////////////
            var tincomesorted = new incomesortedTable();
            tincomesorted.addBaseColumns("idinc", "idsor", "idsubclass", "amount", "ayear", "ct", "cu", "description", "flagnodate", "lt", "lu", "paridsor", "paridsubclass", "rtf", "start", "stop", "tobecontinued", "txt", "valuen1", "valuen2", "valuen3", "valuen4", "valuen5", "values1", "values2", "values3", "values4", "values5", "valuev1", "valuev2", "valuev3", "valuev4", "valuev5");
            Tables.Add(tincomesorted);
            tincomesorted.defineKey("idinc", "idsor", "idsubclass");

            //////////////////// CONFIG /////////////////////////////////
            var tconfig = new configTable();
            tconfig.addBaseColumns("ayear", "automanagekind", "agencycode", "appname", "appropriationphasecode", "assessmentphasecode", "asset_flagnumbering", "asset_flagrestart", "flag_autodocnumbering", "assetload_flag", "boxpartitiontitle", "cashvaliditykind", "casualcontract_flagrestart", "ct", "cu", "currpartitiontitle", "deferredexpensephase", "deferredincomephase", "electronicimport", "electronictrasmission", "expense_expiringdays", "expensephase", "flag_paymentamount", "flagautopayment", "flagautoproceeds", "flagcredit", "flagepexp", "flagfruitful", "flagpayment", "flagproceeds", "flagrefund", "taxvaliditykind", "foreignhours", "idacc_accruedcost", "idacc_accruedrevenue", "idacc_customer", "idacc_deferredcost", "idacc_deferredcredit", "idacc_deferreddebit", "idacc_deferredrevenue", "idacc_ivapayment", "idacc_ivarefund", "idacc_patrimony", "idacc_pl", "idacc_supplier", "idaccmotive_admincar", "idaccmotive_foot", "idaccmotive_owncar", "idclawback", "idfinexpense", "idfinexpensesurplus", "idfinincomesurplus", "idfinivapayment", "idfinivarefund", "idivapayperiodicity", "idregauto", "idsortingkind1", "idsortingkind2", "idsortingkind3", "importappname", "income_expiringdays", "incomephase", "linktoinvoice", "lt", "lu", "minpayment", "minrefund", "motivelen", "motiveprefix", "motiveseparator", "payment_finlevel", "payment_flag", "payment_flagautoprintdate", "paymentagency", "flagbank_grouping", "fin_kind", "prevpartitiontitle", "proceeds_finlevel", "proceeds_flag", "proceeds_flagautoprintdate", "profservice_flagrestart", "refundagency", "wageaddition_flagrestart");
            Tables.Add(tconfig);
            tconfig.defineKey("ayear");

            //////////////////// INCOME1 /////////////////////////////////
            var tincome1 = new MetaTable("income1");
            tincome1.defineColumn("adate", typeof(DateTime), false);
            tincome1.defineColumn("ct", typeof(DateTime), false);
            tincome1.defineColumn("cu", typeof(string), false);
            tincome1.defineColumn("description", typeof(string), false);
            tincome1.defineColumn("doc", typeof(string));
            tincome1.defineColumn("docdate", typeof(DateTime));
            tincome1.defineColumn("expiration", typeof(DateTime));
            tincome1.defineColumn("idreg", typeof(int));
            tincome1.defineColumn("lt", typeof(DateTime), false);
            tincome1.defineColumn("lu", typeof(string), false);
            tincome1.defineColumn("nmov", typeof(int), false);
            tincome1.defineColumn("rtf", typeof(Byte[]));
            tincome1.defineColumn("txt", typeof(string));
            tincome1.defineColumn("ymov", typeof(short), false);
            tincome1.defineColumn("idman", typeof(int));
            tincome1.defineColumn("nphase", typeof(byte), false);
            tincome1.defineColumn("idpayment", typeof(int));
            tincome1.defineColumn("idinc", typeof(int), false);
            tincome1.defineColumn("parentidinc", typeof(int));
            tincome1.defineColumn("autokind", typeof(byte));
            tincome1.defineColumn("autocode", typeof(int));
            Tables.Add(tincome1);
            tincome1.defineKey("idinc");

            //////////////////// STAMPHANDLING /////////////////////////////////
            var tstamphandling = new MetaTable("stamphandling");
            tstamphandling.defineColumn("active", typeof(string));
            tstamphandling.defineColumn("ct", typeof(DateTime), false);
            tstamphandling.defineColumn("cu", typeof(string), false);
            tstamphandling.defineColumn("description", typeof(string), false);
            tstamphandling.defineColumn("flagdefault", typeof(string), false);
            tstamphandling.defineColumn("lt", typeof(DateTime), false);
            tstamphandling.defineColumn("lu", typeof(string), false);
            tstamphandling.defineColumn("handlingbankcode", typeof(string));
            tstamphandling.defineColumn("idstamphandling", typeof(int), false);
            Tables.Add(tstamphandling);
            tstamphandling.defineKey("idstamphandling");

            //////////////////// SORTING01 /////////////////////////////////
            var tsorting01 = new MetaTable("sorting01");
            tsorting01.defineColumn("ct", typeof(DateTime), false);
            tsorting01.defineColumn("cu", typeof(string), false);
            tsorting01.defineColumn("defaultN1", typeof(decimal));
            tsorting01.defineColumn("defaultN2", typeof(decimal));
            tsorting01.defineColumn("defaultN3", typeof(decimal));
            tsorting01.defineColumn("defaultN4", typeof(decimal));
            tsorting01.defineColumn("defaultN5", typeof(decimal));
            tsorting01.defineColumn("defaultS1", typeof(string));
            tsorting01.defineColumn("defaultS2", typeof(string));
            tsorting01.defineColumn("defaultS3", typeof(string));
            tsorting01.defineColumn("defaultS4", typeof(string));
            tsorting01.defineColumn("defaultS5", typeof(string));
            tsorting01.defineColumn("defaultv1", typeof(decimal));
            tsorting01.defineColumn("defaultv2", typeof(decimal));
            tsorting01.defineColumn("defaultv3", typeof(decimal));
            tsorting01.defineColumn("defaultv4", typeof(decimal));
            tsorting01.defineColumn("defaultv5", typeof(decimal));
            tsorting01.defineColumn("description", typeof(string), false);
            tsorting01.defineColumn("flagnodate", typeof(string));
            tsorting01.defineColumn("lt", typeof(DateTime), false);
            tsorting01.defineColumn("lu", typeof(string), false);
            tsorting01.defineColumn("movkind", typeof(string));
            tsorting01.defineColumn("printingorder", typeof(string));
            tsorting01.defineColumn("rtf", typeof(Byte[]));
            tsorting01.defineColumn("sortcode", typeof(string), false);
            tsorting01.defineColumn("txt", typeof(string));
            tsorting01.defineColumn("idsorkind", typeof(int), false);
            tsorting01.defineColumn("idsor", typeof(int), false);
            tsorting01.defineColumn("paridsor", typeof(int));
            tsorting01.defineColumn("nlevel", typeof(byte), false);
            tsorting01.defineColumn("start", typeof(short));
            tsorting01.defineColumn("stop", typeof(short));
            Tables.Add(tsorting01);
            tsorting01.defineKey("idsor");

            //////////////////// SORTING02 /////////////////////////////////
            var tsorting02 = new MetaTable("sorting02");
            tsorting02.defineColumn("ct", typeof(DateTime), false);
            tsorting02.defineColumn("cu", typeof(string), false);
            tsorting02.defineColumn("defaultN1", typeof(decimal));
            tsorting02.defineColumn("defaultN2", typeof(decimal));
            tsorting02.defineColumn("defaultN3", typeof(decimal));
            tsorting02.defineColumn("defaultN4", typeof(decimal));
            tsorting02.defineColumn("defaultN5", typeof(decimal));
            tsorting02.defineColumn("defaultS1", typeof(string));
            tsorting02.defineColumn("defaultS2", typeof(string));
            tsorting02.defineColumn("defaultS3", typeof(string));
            tsorting02.defineColumn("defaultS4", typeof(string));
            tsorting02.defineColumn("defaultS5", typeof(string));
            tsorting02.defineColumn("defaultv1", typeof(decimal));
            tsorting02.defineColumn("defaultv2", typeof(decimal));
            tsorting02.defineColumn("defaultv3", typeof(decimal));
            tsorting02.defineColumn("defaultv4", typeof(decimal));
            tsorting02.defineColumn("defaultv5", typeof(decimal));
            tsorting02.defineColumn("description", typeof(string), false);
            tsorting02.defineColumn("flagnodate", typeof(string));
            tsorting02.defineColumn("lt", typeof(DateTime), false);
            tsorting02.defineColumn("lu", typeof(string), false);
            tsorting02.defineColumn("movkind", typeof(string));
            tsorting02.defineColumn("printingorder", typeof(string));
            tsorting02.defineColumn("rtf", typeof(Byte[]));
            tsorting02.defineColumn("sortcode", typeof(string), false);
            tsorting02.defineColumn("txt", typeof(string));
            tsorting02.defineColumn("idsorkind", typeof(int), false);
            tsorting02.defineColumn("idsor", typeof(int), false);
            tsorting02.defineColumn("paridsor", typeof(int));
            tsorting02.defineColumn("nlevel", typeof(byte), false);
            tsorting02.defineColumn("start", typeof(short));
            tsorting02.defineColumn("stop", typeof(short));
            Tables.Add(tsorting02);
            tsorting02.defineKey("idsor");

            //////////////////// SORTING03 /////////////////////////////////
            var tsorting03 = new MetaTable("sorting03");
            tsorting03.defineColumn("ct", typeof(DateTime), false);
            tsorting03.defineColumn("cu", typeof(string), false);
            tsorting03.defineColumn("defaultN1", typeof(decimal));
            tsorting03.defineColumn("defaultN2", typeof(decimal));
            tsorting03.defineColumn("defaultN3", typeof(decimal));
            tsorting03.defineColumn("defaultN4", typeof(decimal));
            tsorting03.defineColumn("defaultN5", typeof(decimal));
            tsorting03.defineColumn("defaultS1", typeof(string));
            tsorting03.defineColumn("defaultS2", typeof(string));
            tsorting03.defineColumn("defaultS3", typeof(string));
            tsorting03.defineColumn("defaultS4", typeof(string));
            tsorting03.defineColumn("defaultS5", typeof(string));
            tsorting03.defineColumn("defaultv1", typeof(decimal));
            tsorting03.defineColumn("defaultv2", typeof(decimal));
            tsorting03.defineColumn("defaultv3", typeof(decimal));
            tsorting03.defineColumn("defaultv4", typeof(decimal));
            tsorting03.defineColumn("defaultv5", typeof(decimal));
            tsorting03.defineColumn("description", typeof(string), false);
            tsorting03.defineColumn("flagnodate", typeof(string));
            tsorting03.defineColumn("lt", typeof(DateTime), false);
            tsorting03.defineColumn("lu", typeof(string), false);
            tsorting03.defineColumn("movkind", typeof(string));
            tsorting03.defineColumn("printingorder", typeof(string));
            tsorting03.defineColumn("rtf", typeof(Byte[]));
            tsorting03.defineColumn("sortcode", typeof(string), false);
            tsorting03.defineColumn("txt", typeof(string));
            tsorting03.defineColumn("idsorkind", typeof(int), false);
            tsorting03.defineColumn("idsor", typeof(int), false);
            tsorting03.defineColumn("paridsor", typeof(int));
            tsorting03.defineColumn("nlevel", typeof(byte), false);
            tsorting03.defineColumn("start", typeof(short));
            tsorting03.defineColumn("stop", typeof(short));
            Tables.Add(tsorting03);
            tsorting03.defineKey("idsor");

            //////////////////// SORTING04 /////////////////////////////////
            var tsorting04 = new MetaTable("sorting04");
            tsorting04.defineColumn("ct", typeof(DateTime), false);
            tsorting04.defineColumn("cu", typeof(string), false);
            tsorting04.defineColumn("defaultN1", typeof(decimal));
            tsorting04.defineColumn("defaultN2", typeof(decimal));
            tsorting04.defineColumn("defaultN3", typeof(decimal));
            tsorting04.defineColumn("defaultN4", typeof(decimal));
            tsorting04.defineColumn("defaultN5", typeof(decimal));
            tsorting04.defineColumn("defaultS1", typeof(string));
            tsorting04.defineColumn("defaultS2", typeof(string));
            tsorting04.defineColumn("defaultS3", typeof(string));
            tsorting04.defineColumn("defaultS4", typeof(string));
            tsorting04.defineColumn("defaultS5", typeof(string));
            tsorting04.defineColumn("defaultv1", typeof(decimal));
            tsorting04.defineColumn("defaultv2", typeof(decimal));
            tsorting04.defineColumn("defaultv3", typeof(decimal));
            tsorting04.defineColumn("defaultv4", typeof(decimal));
            tsorting04.defineColumn("defaultv5", typeof(decimal));
            tsorting04.defineColumn("description", typeof(string), false);
            tsorting04.defineColumn("flagnodate", typeof(string));
            tsorting04.defineColumn("lt", typeof(DateTime), false);
            tsorting04.defineColumn("lu", typeof(string), false);
            tsorting04.defineColumn("movkind", typeof(string));
            tsorting04.defineColumn("printingorder", typeof(string));
            tsorting04.defineColumn("rtf", typeof(Byte[]));
            tsorting04.defineColumn("sortcode", typeof(string), false);
            tsorting04.defineColumn("txt", typeof(string));
            tsorting04.defineColumn("idsorkind", typeof(int), false);
            tsorting04.defineColumn("idsor", typeof(int), false);
            tsorting04.defineColumn("paridsor", typeof(int));
            tsorting04.defineColumn("nlevel", typeof(byte), false);
            tsorting04.defineColumn("start", typeof(short));
            tsorting04.defineColumn("stop", typeof(short));
            Tables.Add(tsorting04);
            tsorting04.defineKey("idsor");

            //////////////////// SORTING05 /////////////////////////////////
            var tsorting05 = new MetaTable("sorting05");
            tsorting05.defineColumn("ct", typeof(DateTime), false);
            tsorting05.defineColumn("cu", typeof(string), false);
            tsorting05.defineColumn("defaultN1", typeof(decimal));
            tsorting05.defineColumn("defaultN2", typeof(decimal));
            tsorting05.defineColumn("defaultN3", typeof(decimal));
            tsorting05.defineColumn("defaultN4", typeof(decimal));
            tsorting05.defineColumn("defaultN5", typeof(decimal));
            tsorting05.defineColumn("defaultS1", typeof(string));
            tsorting05.defineColumn("defaultS2", typeof(string));
            tsorting05.defineColumn("defaultS3", typeof(string));
            tsorting05.defineColumn("defaultS4", typeof(string));
            tsorting05.defineColumn("defaultS5", typeof(string));
            tsorting05.defineColumn("defaultv1", typeof(decimal));
            tsorting05.defineColumn("defaultv2", typeof(decimal));
            tsorting05.defineColumn("defaultv3", typeof(decimal));
            tsorting05.defineColumn("defaultv4", typeof(decimal));
            tsorting05.defineColumn("defaultv5", typeof(decimal));
            tsorting05.defineColumn("description", typeof(string), false);
            tsorting05.defineColumn("flagnodate", typeof(string));
            tsorting05.defineColumn("lt", typeof(DateTime), false);
            tsorting05.defineColumn("lu", typeof(string), false);
            tsorting05.defineColumn("movkind", typeof(string));
            tsorting05.defineColumn("printingorder", typeof(string));
            tsorting05.defineColumn("rtf", typeof(Byte[]));
            tsorting05.defineColumn("sortcode", typeof(string), false);
            tsorting05.defineColumn("txt", typeof(string));
            tsorting05.defineColumn("idsorkind", typeof(int), false);
            tsorting05.defineColumn("idsor", typeof(int), false);
            tsorting05.defineColumn("paridsor", typeof(int));
            tsorting05.defineColumn("nlevel", typeof(byte), false);
            tsorting05.defineColumn("start", typeof(short));
            tsorting05.defineColumn("stop", typeof(short));
            Tables.Add(tsorting05);
            tsorting05.defineKey("idsor");

            #endregion


            #region DataRelation creation
            this.defineRelation("incomelastview_incomesorted", "incomelastview", "incomesorted", "idinc");
            this.defineRelation("proceedsproceeds_bankview", "proceeds", "proceeds_bankview", "kpro");
            this.defineRelation("income1_banktransaction", "income1", "banktransaction", "idinc");
            this.defineRelation("proceedsbanktransaction", "proceeds", "banktransaction", "kpro");
            this.defineRelation("incomelastviewincomevar", "incomelastview", "incomevar", "idinc");
            this.defineRelation("proceedsincomelastview", "proceeds", "incomelastview", "kpro");
            var cPar   = new [] { sorting05.Columns["idsor"] };
            var cChild = new [] { proceeds.Columns["idsor05"] };
            Relations.Add(new DataRelation("sorting05_proceeds", cPar, cChild, false));

            cPar   = new [] { sorting04.Columns["idsor"] };
            cChild = new [] { proceeds.Columns["idsor04"] };
            Relations.Add(new DataRelation("sorting04_proceeds", cPar, cChild, false));

            cPar   = new [] { sorting03.Columns["idsor"] };
            cChild = new [] { proceeds.Columns["idsor03"] };
            Relations.Add(new DataRelation("sorting03_proceeds", cPar, cChild, false));

            cPar   = new [] { sorting02.Columns["idsor"] };
            cChild = new [] { proceeds.Columns["idsor02"] };
            Relations.Add(new DataRelation("sorting02_proceeds", cPar, cChild, false));

            cPar   = new [] { sorting01.Columns["idsor"] };
            cChild = new [] { proceeds.Columns["idsor01"] };
            Relations.Add(new DataRelation("sorting01_proceeds", cPar, cChild, false));

            this.defineRelation("treasurerproceeds", "treasurer", "proceeds", "idtreasurer");
            this.defineRelation("finproceeds", "fin", "proceeds", "idfin");
            this.defineRelation("registryproceeds", "registry", "proceeds", "idreg");
            this.defineRelation("managerproceeds", "manager", "proceeds", "idman");
            this.defineRelation("proceedstransmissionproceeds", "proceedstransmission", "proceeds", "kproceedstransmission");
            this.defineRelation("FK_stamphandling_proceeds", "stamphandling", "proceeds", "idstamphandling");
            #endregion
        }
Beispiel #4
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// CSA_IMPORT /////////////////////////////////
            var tcsa_import = new MetaTable("csa_import");
            tcsa_import.defineColumn("idcsa_import", typeof(int), false);
            tcsa_import.defineColumn("yimport", typeof(short), false);
            tcsa_import.defineColumn("nimport", typeof(int), false);
            tcsa_import.defineColumn("description", typeof(string), false);
            tcsa_import.defineColumn("adate", typeof(DateTime), false);
            tcsa_import.defineColumn("ybill_netti", typeof(short));
            tcsa_import.defineColumn("nbill_netti", typeof(int));
            tcsa_import.defineColumn("ybill_versamenti", typeof(short));
            tcsa_import.defineColumn("nbill_versamenti", typeof(int));
            tcsa_import.defineColumn("ct", typeof(DateTime), false);
            tcsa_import.defineColumn("cu", typeof(string), false);
            tcsa_import.defineColumn("lt", typeof(DateTime), false);
            tcsa_import.defineColumn("lu", typeof(string), false);
            Tables.Add(tcsa_import);
            tcsa_import.defineKey("idcsa_import");

            //////////////////// CSA_IMPORTVER /////////////////////////////////
            var tcsa_importver = new MetaTable("csa_importver");
            tcsa_importver.defineColumn("idcsa_import", typeof(int), false);
            tcsa_importver.defineColumn("idver", typeof(int), false);
            tcsa_importver.defineColumn("ruolocsa", typeof(string), false);
            tcsa_importver.defineColumn("capitolocsa", typeof(string), false);
            tcsa_importver.defineColumn("competenza", typeof(string), false);
            tcsa_importver.defineColumn("matricola", typeof(string), false);
            tcsa_importver.defineColumn("ente", typeof(string), false);
            tcsa_importver.defineColumn("vocecsa", typeof(string), false);
            tcsa_importver.defineColumn("importo", typeof(decimal), false);
            tcsa_importver.defineColumn("flagcr", typeof(string));
            tcsa_importver.defineColumn("ayear", typeof(int));
            tcsa_importver.defineColumn("idcsa_contractkind", typeof(int));
            tcsa_importver.defineColumn("idcsa_contract", typeof(int));
            tcsa_importver.defineColumn("idcsa_agency", typeof(int));
            tcsa_importver.defineColumn("idfin_income", typeof(int));
            tcsa_importver.defineColumn("idacc_debit", typeof(string));
            tcsa_importver.defineColumn("idfin_expense", typeof(int));
            tcsa_importver.defineColumn("idacc_expense", typeof(string));
            tcsa_importver.defineColumn("idfin_incomeclawback", typeof(int));
            tcsa_importver.defineColumn("idacc_internalcredit", typeof(string));
            tcsa_importver.defineColumn("idreg_agency", typeof(int));
            tcsa_importver.defineColumn("idcsa_agencypaymethod", typeof(int));
            tcsa_importver.defineColumn("idexp_cost", typeof(int));
            tcsa_importver.defineColumn("idfin_cost", typeof(int));
            tcsa_importver.defineColumn("idacc_cost", typeof(string));
            tcsa_importver.defineColumn("flagclawback", typeof(string));
            tcsa_importver.defineColumn("flagdirectcsaclawback", typeof(string));
            tcsa_importver.defineColumn("idreg", typeof(int));
            tcsa_importver.defineColumn("idupb", typeof(string));
            tcsa_importver.defineColumn("idcsa_contracttax", typeof(int));
            tcsa_importver.defineColumn("idcsa_contractkinddata", typeof(int));
            tcsa_importver.defineColumn("idcsa_incomesetup", typeof(int));
            tcsa_importver.defineColumn("lt", typeof(DateTime), false);
            tcsa_importver.defineColumn("lu", typeof(string), false);
            tcsa_importver.defineColumn("idepexp", typeof(int));
            tcsa_importver.defineColumn("idacc_revenue", typeof(string));
            tcsa_importver.defineColumn("idacc_agency_credit", typeof(string));
            tcsa_importver.defineColumn("idsor_siope_income", typeof(int));
            tcsa_importver.defineColumn("idsor_siope_expense", typeof(int));
            tcsa_importver.defineColumn("idsor_siope_incomeclawback", typeof(int));
            tcsa_importver.defineColumn("idsor_siope_cost", typeof(int));
            Tables.Add(tcsa_importver);
            tcsa_importver.defineKey("idcsa_import", "idver");

            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "active", "annotation", "badgecode", "birthdate", "cf", "ct", "cu", "extmatricula", "foreigncf", "forename", "gender", "idcategory", "idcentralizedcategory", "idcity", "idmaritalstatus", "idnation", "idregistryclass", "idtitle", "location", "lt", "lu", "maritalsurname", "p_iva", "rtf", "surname", "title", "txt", "residence", "idregistrykind", "authorization_free", "multi_cf", "toredirect", "idaccmotivedebit", "idaccmotivecredit");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// REGISTRY1 /////////////////////////////////
            var tregistry1 = new MetaTable("registry1");
            tregistry1.defineColumn("idreg", typeof(int), false);
            tregistry1.defineColumn("active", typeof(string), false);
            tregistry1.defineColumn("annotation", typeof(string));
            tregistry1.defineColumn("badgecode", typeof(string));
            tregistry1.defineColumn("birthdate", typeof(DateTime));
            tregistry1.defineColumn("cf", typeof(string));
            tregistry1.defineColumn("ct", typeof(DateTime), false);
            tregistry1.defineColumn("cu", typeof(string), false);
            tregistry1.defineColumn("extmatricula", typeof(string));
            tregistry1.defineColumn("foreigncf", typeof(string));
            tregistry1.defineColumn("forename", typeof(string));
            tregistry1.defineColumn("gender", typeof(string));
            tregistry1.defineColumn("idcategory", typeof(string));
            tregistry1.defineColumn("idcentralizedcategory", typeof(string));
            tregistry1.defineColumn("idcity", typeof(int));
            tregistry1.defineColumn("idmaritalstatus", typeof(string));
            tregistry1.defineColumn("idnation", typeof(int));
            tregistry1.defineColumn("idregistryclass", typeof(string));
            tregistry1.defineColumn("idtitle", typeof(string));
            tregistry1.defineColumn("location", typeof(string));
            tregistry1.defineColumn("lt", typeof(DateTime), false);
            tregistry1.defineColumn("lu", typeof(string), false);
            tregistry1.defineColumn("maritalsurname", typeof(string));
            tregistry1.defineColumn("p_iva", typeof(string));
            tregistry1.defineColumn("rtf", typeof(Byte[]));
            tregistry1.defineColumn("surname", typeof(string));
            tregistry1.defineColumn("title", typeof(string), false);
            tregistry1.defineColumn("txt", typeof(string));
            tregistry1.defineColumn("residence", typeof(int), false);
            tregistry1.defineColumn("idregistrykind", typeof(int));
            tregistry1.defineColumn("authorization_free", typeof(string));
            tregistry1.defineColumn("multi_cf", typeof(string));
            tregistry1.defineColumn("toredirect", typeof(int));
            tregistry1.defineColumn("idaccmotivedebit", typeof(string));
            tregistry1.defineColumn("idaccmotivecredit", typeof(string));
            Tables.Add(tregistry1);
            tregistry1.defineKey("idreg");

            //////////////////// EXPENSEVIEW /////////////////////////////////
            var texpenseview = new MetaTable("expenseview");
            texpenseview.defineColumn("idexp", typeof(int), false);
            texpenseview.defineColumn("!livprecedente", typeof(string));
            texpenseview.defineColumn("nphase", typeof(byte));
            texpenseview.defineColumn("phase", typeof(string), false);
            texpenseview.defineColumn("ymov", typeof(short), false);
            texpenseview.defineColumn("nmov", typeof(int), false);
            texpenseview.defineColumn("parentidexp", typeof(int));
            texpenseview.defineColumn("parentymov", typeof(short));
            texpenseview.defineColumn("parentnmov", typeof(int));
            texpenseview.defineColumn("idformerexpense", typeof(int));
            texpenseview.defineColumn("ayear", typeof(short), false);
            texpenseview.defineColumn("idfin", typeof(int));
            texpenseview.defineColumn("codefin", typeof(string));
            texpenseview.defineColumn("finance", typeof(string));
            texpenseview.defineColumn("idupb", typeof(string));
            texpenseview.defineColumn("codeupb", typeof(string));
            texpenseview.defineColumn("upb", typeof(string));
            texpenseview.defineColumn("idreg", typeof(int));
            texpenseview.defineColumn("registry", typeof(string));
            texpenseview.defineColumn("idman", typeof(int));
            texpenseview.defineColumn("manager", typeof(string));
            texpenseview.defineColumn("ypay", typeof(short), true, true);
            texpenseview.defineColumn("npay", typeof(int));
            texpenseview.defineColumn("paymentadate", typeof(DateTime));
            texpenseview.defineColumn("doc", typeof(string));
            texpenseview.defineColumn("docdate", typeof(DateTime));
            texpenseview.defineColumn("description", typeof(string), false);
            texpenseview.defineColumn("amount", typeof(decimal));
            texpenseview.defineColumn("ayearstartamount", typeof(decimal));
            texpenseview.defineColumn("curramount", typeof(decimal));
            texpenseview.defineColumn("available", typeof(decimal));
            texpenseview.defineColumn("idregistrypaymethod", typeof(int));
            texpenseview.defineColumn("idpaymethod", typeof(int));
            texpenseview.defineColumn("iban", typeof(string));
            texpenseview.defineColumn("cin", typeof(string));
            texpenseview.defineColumn("idbank", typeof(string));
            texpenseview.defineColumn("idcab", typeof(string));
            texpenseview.defineColumn("cc", typeof(string));
            texpenseview.defineColumn("iddeputy", typeof(int));
            texpenseview.defineColumn("deputy", typeof(string));
            texpenseview.defineColumn("refexternaldoc", typeof(string));
            texpenseview.defineColumn("paymentdescr", typeof(string));
            texpenseview.defineColumn("idser", typeof(int));
            texpenseview.defineColumn("service", typeof(string));
            texpenseview.defineColumn("servicestart", typeof(DateTime));
            texpenseview.defineColumn("servicestop", typeof(DateTime));
            texpenseview.defineColumn("ivaamount", typeof(decimal));
            texpenseview.defineColumn("flag", typeof(byte));
            texpenseview.defineColumn("totflag", typeof(byte));
            texpenseview.defineColumn("flagarrear", typeof(string), true, true);
            texpenseview.defineColumn("autokind", typeof(byte));
            texpenseview.defineColumn("idpayment", typeof(int));
            texpenseview.defineColumn("expiration", typeof(DateTime));
            texpenseview.defineColumn("adate", typeof(DateTime), false);
            texpenseview.defineColumn("autocode", typeof(int));
            texpenseview.defineColumn("idclawback", typeof(int));
            texpenseview.defineColumn("clawback", typeof(string));
            texpenseview.defineColumn("nbill", typeof(int));
            texpenseview.defineColumn("idpay", typeof(int));
            texpenseview.defineColumn("txt", typeof(string));
            texpenseview.defineColumn("cu", typeof(string), false);
            texpenseview.defineColumn("ct", typeof(DateTime), false);
            texpenseview.defineColumn("lu", typeof(string), false);
            texpenseview.defineColumn("lt", typeof(DateTime), false);
            texpenseview.defineColumn("biccode", typeof(string));
            texpenseview.defineColumn("paymethod_flag", typeof(int));
            texpenseview.defineColumn("paymethod_allowdeputy", typeof(string));
            texpenseview.defineColumn("extracode", typeof(string));
            texpenseview.defineColumn("idchargehandling", typeof(int));
            Tables.Add(texpenseview);

            //////////////////// INCOMEVIEW /////////////////////////////////
            var tincomeview = new MetaTable("incomeview");
            tincomeview.defineColumn("idinc", typeof(int), false);
            tincomeview.defineColumn("!livprecedente", typeof(string));
            tincomeview.defineColumn("nphase", typeof(byte));
            tincomeview.defineColumn("phase", typeof(string), false);
            tincomeview.defineColumn("ymov", typeof(short), false);
            tincomeview.defineColumn("nmov", typeof(int), false);
            tincomeview.defineColumn("parentymov", typeof(short));
            tincomeview.defineColumn("parentnmov", typeof(int));
            tincomeview.defineColumn("parentidinc", typeof(int));
            tincomeview.defineColumn("ayear", typeof(short), false);
            tincomeview.defineColumn("idfin", typeof(int));
            tincomeview.defineColumn("codefin", typeof(string));
            tincomeview.defineColumn("finance", typeof(string));
            tincomeview.defineColumn("idupb", typeof(string));
            tincomeview.defineColumn("codeupb", typeof(string));
            tincomeview.defineColumn("upb", typeof(string));
            tincomeview.defineColumn("idreg", typeof(int));
            tincomeview.defineColumn("registry", typeof(string));
            tincomeview.defineColumn("idman", typeof(int));
            tincomeview.defineColumn("manager", typeof(string));
            tincomeview.defineColumn("ypro", typeof(short));
            tincomeview.defineColumn("npro", typeof(int));
            tincomeview.defineColumn("doc", typeof(string));
            tincomeview.defineColumn("docdate", typeof(DateTime));
            tincomeview.defineColumn("description", typeof(string), false);
            tincomeview.defineColumn("amount", typeof(decimal));
            tincomeview.defineColumn("ayearstartamount", typeof(decimal));
            tincomeview.defineColumn("curramount", typeof(decimal));
            tincomeview.defineColumn("available", typeof(decimal));
            tincomeview.defineColumn("unpartitioned", typeof(decimal));
            tincomeview.defineColumn("flag", typeof(byte));
            tincomeview.defineColumn("totflag", typeof(byte), false);
            tincomeview.defineColumn("flagarrear", typeof(string));
            tincomeview.defineColumn("autokind", typeof(byte));
            tincomeview.defineColumn("autocode", typeof(int));
            tincomeview.defineColumn("idpayment", typeof(int));
            tincomeview.defineColumn("expiration", typeof(DateTime));
            tincomeview.defineColumn("adate", typeof(DateTime), false);
            tincomeview.defineColumn("nbill", typeof(int));
            tincomeview.defineColumn("idpro", typeof(int));
            tincomeview.defineColumn("cu", typeof(string), false);
            tincomeview.defineColumn("ct", typeof(DateTime), false);
            tincomeview.defineColumn("lu", typeof(string), false);
            tincomeview.defineColumn("lt", typeof(DateTime), false);
            Tables.Add(tincomeview);

            //////////////////// CSA_IMPORTVER_PARTITION /////////////////////////////////
            var tcsa_importver_partition = new MetaTable("csa_importver_partition");
            tcsa_importver_partition.defineColumn("idcsa_import", typeof(int), false);
            tcsa_importver_partition.defineColumn("idver", typeof(int), false);
            tcsa_importver_partition.defineColumn("ndetail", typeof(int), false);
            tcsa_importver_partition.defineColumn("idexp", typeof(int));
            tcsa_importver_partition.defineColumn("ct", typeof(DateTime));
            tcsa_importver_partition.defineColumn("cu", typeof(string));
            tcsa_importver_partition.defineColumn("lt", typeof(DateTime));
            tcsa_importver_partition.defineColumn("lu", typeof(string));
            tcsa_importver_partition.defineColumn("amount", typeof(decimal));
            tcsa_importver_partition.defineColumn("idupb", typeof(string));
            tcsa_importver_partition.defineColumn("idacc", typeof(string));
            tcsa_importver_partition.defineColumn("idfin", typeof(int));
            tcsa_importver_partition.defineColumn("idepexp", typeof(int));
            tcsa_importver_partition.defineColumn("idsor_siope", typeof(int));
            Tables.Add(tcsa_importver_partition);
            tcsa_importver_partition.defineKey("idcsa_import", "idver", "ndetail");

            //////////////////// CSA_IMPORTVER_PARTITIONVIEW /////////////////////////////////
            var tcsa_importver_partitionview = new MetaTable("csa_importver_partitionview");
            tcsa_importver_partitionview.defineColumn("ayear", typeof(short));
            tcsa_importver_partitionview.defineColumn("competency", typeof(int));
            tcsa_importver_partitionview.defineColumn("idcsa_import", typeof(int), false);
            tcsa_importver_partitionview.defineColumn("yimport", typeof(short), false);
            tcsa_importver_partitionview.defineColumn("nimport", typeof(int), false);
            tcsa_importver_partitionview.defineColumn("idver", typeof(int), false);
            tcsa_importver_partitionview.defineColumn("ndetail", typeof(int), false);
            tcsa_importver_partitionview.defineColumn("amount", typeof(decimal));
            tcsa_importver_partitionview.defineColumn("idcsa_contract", typeof(int));
            tcsa_importver_partitionview.defineColumn("ycontract", typeof(short));
            tcsa_importver_partitionview.defineColumn("ncontract", typeof(int));
            tcsa_importver_partitionview.defineColumn("idcsa_contractkind", typeof(int));
            tcsa_importver_partitionview.defineColumn("csa_contractkindcode", typeof(string));
            tcsa_importver_partitionview.defineColumn("csa_contractkind", typeof(string));
            tcsa_importver_partitionview.defineColumn("ruolocsa", typeof(string), false);
            tcsa_importver_partitionview.defineColumn("capitolocsa", typeof(string), false);
            tcsa_importver_partitionview.defineColumn("competenza", typeof(string), false);
            tcsa_importver_partitionview.defineColumn("matricola", typeof(string), false);
            tcsa_importver_partitionview.defineColumn("ente", typeof(string), false);
            tcsa_importver_partitionview.defineColumn("vocecsa", typeof(string), false);
            tcsa_importver_partitionview.defineColumn("vocecsaunified", typeof(string));
            tcsa_importver_partitionview.defineColumn("idreg", typeof(int));
            tcsa_importver_partitionview.defineColumn("registry", typeof(string));
            tcsa_importver_partitionview.defineColumn("idcsa_agency", typeof(int));
            tcsa_importver_partitionview.defineColumn("agency", typeof(string));
            tcsa_importver_partitionview.defineColumn("idreg_agency", typeof(int));
            tcsa_importver_partitionview.defineColumn("registry_agency", typeof(string));
            tcsa_importver_partitionview.defineColumn("idcsa_agencypaymethod", typeof(int));
            tcsa_importver_partitionview.defineColumn("idregistrypaymethod", typeof(int));
            tcsa_importver_partitionview.defineColumn("idcsa_contracttax", typeof(int));
            tcsa_importver_partitionview.defineColumn("idcsa_contractkinddata", typeof(int));
            tcsa_importver_partitionview.defineColumn("idcsa_incomesetup", typeof(int));
            tcsa_importver_partitionview.defineColumn("idacc_debit", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeacc_debit", typeof(string));
            tcsa_importver_partitionview.defineColumn("account_debit", typeof(string));
            tcsa_importver_partitionview.defineColumn("idacc_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeacc_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("account_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("idacc_internalcredit", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeacc_internalcredit", typeof(string));
            tcsa_importver_partitionview.defineColumn("account_internalcredit", typeof(string));
            tcsa_importver_partitionview.defineColumn("idacc_revenue", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeacc_revenue", typeof(string));
            tcsa_importver_partitionview.defineColumn("account_revenue", typeof(string));
            tcsa_importver_partitionview.defineColumn("idacc_agency_credit", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeacc_agency_credit", typeof(string));
            tcsa_importver_partitionview.defineColumn("account_agency_credit", typeof(string));
            tcsa_importver_partitionview.defineColumn("idfin_income", typeof(int));
            tcsa_importver_partitionview.defineColumn("codefin_income", typeof(string));
            tcsa_importver_partitionview.defineColumn("fin_income", typeof(string));
            tcsa_importver_partitionview.defineColumn("idfin_expense", typeof(int));
            tcsa_importver_partitionview.defineColumn("codefin_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("fin_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("idfin_incomeclawback", typeof(int));
            tcsa_importver_partitionview.defineColumn("codefin_incomeclawback", typeof(string));
            tcsa_importver_partitionview.defineColumn("fin_incomeclawback", typeof(string));
            tcsa_importver_partitionview.defineColumn("idsor_siope_income", typeof(int));
            tcsa_importver_partitionview.defineColumn("sortcode_income", typeof(string));
            tcsa_importver_partitionview.defineColumn("sorting_income", typeof(string));
            tcsa_importver_partitionview.defineColumn("idsor_siope_expense", typeof(int));
            tcsa_importver_partitionview.defineColumn("sortcode_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("sorting_expense", typeof(string));
            tcsa_importver_partitionview.defineColumn("idsor_siope_incomeclawback", typeof(int));
            tcsa_importver_partitionview.defineColumn("sortcode_incomeclawback", typeof(string));
            tcsa_importver_partitionview.defineColumn("sorting_incomeclawback", typeof(string));
            tcsa_importver_partitionview.defineColumn("idsor_siope_cost", typeof(int));
            tcsa_importver_partitionview.defineColumn("sortcode_cost", typeof(string));
            tcsa_importver_partitionview.defineColumn("sorting_cost", typeof(string));
            tcsa_importver_partitionview.defineColumn("idexp", typeof(int));
            tcsa_importver_partitionview.defineColumn("ymov", typeof(short));
            tcsa_importver_partitionview.defineColumn("nmov", typeof(int));
            tcsa_importver_partitionview.defineColumn("paridexp", typeof(int));
            tcsa_importver_partitionview.defineColumn("nphaseexpense", typeof(byte));
            tcsa_importver_partitionview.defineColumn("lu", typeof(string));
            tcsa_importver_partitionview.defineColumn("lt", typeof(DateTime));
            tcsa_importver_partitionview.defineColumn("cu", typeof(string));
            tcsa_importver_partitionview.defineColumn("ct", typeof(DateTime));
            tcsa_importver_partitionview.defineColumn("idepexp", typeof(int));
            tcsa_importver_partitionview.defineColumn("yepexp", typeof(short));
            tcsa_importver_partitionview.defineColumn("nepexp", typeof(int));
            tcsa_importver_partitionview.defineColumn("idrelated", typeof(string));
            tcsa_importver_partitionview.defineColumn("paridepexp", typeof(int));
            tcsa_importver_partitionview.defineColumn("nphaseepexp", typeof(short));
            tcsa_importver_partitionview.defineColumn("flagcr", typeof(string));
            tcsa_importver_partitionview.defineColumn("flagclawback", typeof(string));
            tcsa_importver_partitionview.defineColumn("flagdirectcsaclawback", typeof(string));
            tcsa_importver_partitionview.defineColumn("idunderwriting", typeof(int));
            tcsa_importver_partitionview.defineColumn("underwriting", typeof(string));
            tcsa_importver_partitionview.defineColumn("idupb", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeupb", typeof(string));
            tcsa_importver_partitionview.defineColumn("upb", typeof(string));
            tcsa_importver_partitionview.defineColumn("idacc_cost", typeof(string));
            tcsa_importver_partitionview.defineColumn("codeacc_cost", typeof(string));
            tcsa_importver_partitionview.defineColumn("account_cost", typeof(string));
            tcsa_importver_partitionview.defineColumn("idfin", typeof(int));
            tcsa_importver_partitionview.defineColumn("codefin", typeof(string));
            tcsa_importver_partitionview.defineColumn("fin", typeof(string));
            tcsa_importver_partitionview.defineColumn("idsorkind", typeof(string));
            tcsa_importver_partitionview.defineColumn("codesorkind", typeof(string));
            tcsa_importver_partitionview.defineColumn("sortingkind", typeof(string));
            tcsa_importver_partitionview.defineColumn("idsor_siope", typeof(string));
            tcsa_importver_partitionview.defineColumn("sortcode_siope", typeof(string));
            tcsa_importver_partitionview.defineColumn("sorting_siope", typeof(string));
            Tables.Add(tcsa_importver_partitionview);
            tcsa_importver_partitionview.defineKey("idcsa_import", "ndetail", "idver");

            //////////////////// BILL_NETTI /////////////////////////////////
            var tbill_netti = new MetaTable("bill_netti");
            tbill_netti.defineColumn("ybill", typeof(short), false);
            tbill_netti.defineColumn("nbill", typeof(int), false);
            tbill_netti.defineColumn("billkind", typeof(string), false);
            tbill_netti.defineColumn("registry", typeof(string));
            tbill_netti.defineColumn("covered", typeof(decimal));
            tbill_netti.defineColumn("total", typeof(decimal));
            tbill_netti.defineColumn("adate", typeof(DateTime));
            tbill_netti.defineColumn("active", typeof(string));
            tbill_netti.defineColumn("motive", typeof(string));
            tbill_netti.defineColumn("ct", typeof(DateTime), false);
            tbill_netti.defineColumn("cu", typeof(string), false);
            tbill_netti.defineColumn("lt", typeof(DateTime), false);
            tbill_netti.defineColumn("lu", typeof(string), false);
            tbill_netti.defineColumn("idtreasurer", typeof(int));
            tbill_netti.defineColumn("regularizationnote", typeof(string));
            tbill_netti.defineColumn("reduction", typeof(decimal));
            tbill_netti.defineColumn("banknum", typeof(int));
            tbill_netti.defineColumn("idbank", typeof(string));
            Tables.Add(tbill_netti);
            tbill_netti.defineKey("ybill", "nbill", "billkind");

            //////////////////// BILL_VERSAMENTI /////////////////////////////////
            var tbill_versamenti = new MetaTable("bill_versamenti");
            tbill_versamenti.defineColumn("ybill", typeof(short), false);
            tbill_versamenti.defineColumn("nbill", typeof(int), false);
            tbill_versamenti.defineColumn("billkind", typeof(string), false);
            tbill_versamenti.defineColumn("registry", typeof(string));
            tbill_versamenti.defineColumn("covered", typeof(decimal));
            tbill_versamenti.defineColumn("total", typeof(decimal));
            tbill_versamenti.defineColumn("adate", typeof(DateTime));
            tbill_versamenti.defineColumn("active", typeof(string));
            tbill_versamenti.defineColumn("motive", typeof(string));
            tbill_versamenti.defineColumn("ct", typeof(DateTime), false);
            tbill_versamenti.defineColumn("cu", typeof(string), false);
            tbill_versamenti.defineColumn("lt", typeof(DateTime), false);
            tbill_versamenti.defineColumn("lu", typeof(string), false);
            tbill_versamenti.defineColumn("idtreasurer", typeof(int));
            tbill_versamenti.defineColumn("regularizationnote", typeof(string));
            tbill_versamenti.defineColumn("reduction", typeof(decimal));
            tbill_versamenti.defineColumn("banknum", typeof(int));
            tbill_versamenti.defineColumn("idbank", typeof(string));
            Tables.Add(tbill_versamenti);
            tbill_versamenti.defineKey("ybill", "nbill", "billkind");

            //////////////////// CSA_BILL /////////////////////////////////
            var tcsa_bill = new MetaTable("csa_bill");
            tcsa_bill.defineColumn("idcsa_import", typeof(int), false);
            tcsa_bill.defineColumn("idcsa_bill", typeof(int), false);
            tcsa_bill.defineColumn("idreg", typeof(int), false);
            tcsa_bill.defineColumn("nbill", typeof(int), false);
            tcsa_bill.defineColumn("amount", typeof(decimal), false);
            tcsa_bill.defineColumn("lt", typeof(DateTime));
            tcsa_bill.defineColumn("lu", typeof(string));
            tcsa_bill.defineColumn("ct", typeof(DateTime));
            tcsa_bill.defineColumn("cu", typeof(string));
            tcsa_bill.defineColumn("!registry", typeof(string));
            tcsa_bill.defineColumn("!motive", typeof(string));
            tcsa_bill.defineColumn("!datasospeso", typeof(string));
            Tables.Add(tcsa_bill);
            tcsa_bill.defineKey("idcsa_import", "idcsa_bill");

            //////////////////// REGISTRY_SOSPESI /////////////////////////////////
            var tregistry_sospesi = new MetaTable("registry_sospesi");
            tregistry_sospesi.defineColumn("idreg", typeof(int), false);
            tregistry_sospesi.defineColumn("active", typeof(string), false);
            tregistry_sospesi.defineColumn("annotation", typeof(string));
            tregistry_sospesi.defineColumn("badgecode", typeof(string));
            tregistry_sospesi.defineColumn("birthdate", typeof(DateTime));
            tregistry_sospesi.defineColumn("cf", typeof(string));
            tregistry_sospesi.defineColumn("ct", typeof(DateTime), false);
            tregistry_sospesi.defineColumn("cu", typeof(string), false);
            tregistry_sospesi.defineColumn("extmatricula", typeof(string));
            tregistry_sospesi.defineColumn("foreigncf", typeof(string));
            tregistry_sospesi.defineColumn("forename", typeof(string));
            tregistry_sospesi.defineColumn("gender", typeof(string));
            tregistry_sospesi.defineColumn("idcategory", typeof(string));
            tregistry_sospesi.defineColumn("idcentralizedcategory", typeof(string));
            tregistry_sospesi.defineColumn("idcity", typeof(int));
            tregistry_sospesi.defineColumn("idmaritalstatus", typeof(string));
            tregistry_sospesi.defineColumn("idnation", typeof(int));
            tregistry_sospesi.defineColumn("idregistryclass", typeof(string));
            tregistry_sospesi.defineColumn("idtitle", typeof(string));
            tregistry_sospesi.defineColumn("location", typeof(string));
            tregistry_sospesi.defineColumn("lt", typeof(DateTime), false);
            tregistry_sospesi.defineColumn("lu", typeof(string), false);
            tregistry_sospesi.defineColumn("maritalsurname", typeof(string));
            tregistry_sospesi.defineColumn("p_iva", typeof(string));
            tregistry_sospesi.defineColumn("rtf", typeof(Byte[]));
            tregistry_sospesi.defineColumn("surname", typeof(string));
            tregistry_sospesi.defineColumn("title", typeof(string), false);
            tregistry_sospesi.defineColumn("txt", typeof(string));
            tregistry_sospesi.defineColumn("residence", typeof(int), false);
            tregistry_sospesi.defineColumn("idregistrykind", typeof(int));
            tregistry_sospesi.defineColumn("authorization_free", typeof(string));
            tregistry_sospesi.defineColumn("multi_cf", typeof(string));
            tregistry_sospesi.defineColumn("toredirect", typeof(int));
            tregistry_sospesi.defineColumn("idaccmotivedebit", typeof(string));
            tregistry_sospesi.defineColumn("idaccmotivecredit", typeof(string));
            tregistry_sospesi.defineColumn("ccp", typeof(string));
            tregistry_sospesi.defineColumn("flagbankitaliaproceeds", typeof(string));
            tregistry_sospesi.defineColumn("idexternal", typeof(int));
            tregistry_sospesi.defineColumn("ipa_fe", typeof(string));
            tregistry_sospesi.defineColumn("flag_pa", typeof(string));
            tregistry_sospesi.defineColumn("sdi_norifamm", typeof(string));
            tregistry_sospesi.defineColumn("sdi_defrifamm", typeof(string));
            Tables.Add(tregistry_sospesi);
            tregistry_sospesi.defineKey("idreg");

            //////////////////// BILL_RIPARTIZIONE /////////////////////////////////
            var tbill_ripartizione = new MetaTable("bill_ripartizione");
            tbill_ripartizione.defineColumn("ybill", typeof(short), false);
            tbill_ripartizione.defineColumn("nbill", typeof(int), false);
            tbill_ripartizione.defineColumn("billkind", typeof(string), false);
            tbill_ripartizione.defineColumn("registry", typeof(string));
            tbill_ripartizione.defineColumn("covered", typeof(decimal));
            tbill_ripartizione.defineColumn("total", typeof(decimal));
            tbill_ripartizione.defineColumn("adate", typeof(DateTime));
            tbill_ripartizione.defineColumn("active", typeof(string));
            tbill_ripartizione.defineColumn("motive", typeof(string));
            tbill_ripartizione.defineColumn("ct", typeof(DateTime), false);
            tbill_ripartizione.defineColumn("cu", typeof(string), false);
            tbill_ripartizione.defineColumn("lt", typeof(DateTime), false);
            tbill_ripartizione.defineColumn("lu", typeof(string), false);
            tbill_ripartizione.defineColumn("idtreasurer", typeof(int));
            tbill_ripartizione.defineColumn("regularizationnote", typeof(string));
            tbill_ripartizione.defineColumn("reduction", typeof(decimal));
            tbill_ripartizione.defineColumn("banknum", typeof(int));
            tbill_ripartizione.defineColumn("idbank", typeof(string));
            Tables.Add(tbill_ripartizione);
            tbill_ripartizione.defineKey("ybill", "nbill", "billkind");

            //////////////////// BILLVIEW /////////////////////////////////
            var tbillview = new MetaTable("billview");
            tbillview.defineColumn("ybill", typeof(short), false);
            tbillview.defineColumn("nbill", typeof(int), false);
            tbillview.defineColumn("billkind", typeof(string), false);
            tbillview.defineColumn("active", typeof(string));
            tbillview.defineColumn("adate", typeof(DateTime));
            tbillview.defineColumn("registry", typeof(string));
            tbillview.defineColumn("motive", typeof(string));
            tbillview.defineColumn("total", typeof(decimal));
            tbillview.defineColumn("covered", typeof(decimal));
            tbillview.defineColumn("cu", typeof(string), false);
            tbillview.defineColumn("ct", typeof(DateTime), false);
            tbillview.defineColumn("lu", typeof(string), false);
            tbillview.defineColumn("lt", typeof(DateTime), false);
            tbillview.defineColumn("idtreasurer", typeof(int));
            tbillview.defineColumn("treasurer", typeof(string));
            tbillview.defineColumn("regularizationnote", typeof(string));
            tbillview.defineColumn("idsor01", typeof(int));
            tbillview.defineColumn("idsor02", typeof(int));
            tbillview.defineColumn("idsor03", typeof(int));
            tbillview.defineColumn("idsor04", typeof(int));
            tbillview.defineColumn("idsor05", typeof(int));
            Tables.Add(tbillview);
            tbillview.defineKey("ybill", "nbill", "billkind");

            #endregion


            #region DataRelation creation
            this.defineRelation("csa_import_csa_importver", "csa_import", "csa_importver", "idcsa_import");
            this.defineRelation("csa_import_csa_importver_partition", "csa_import", "csa_importver_partition", "idcsa_import");
            var cPar   = new [] { bill_netti.Columns["ybill"], bill_netti.Columns["nbill"] };
            var cChild = new [] { csa_import.Columns["ybill_netti"], csa_import.Columns["nbill_netti"] };
            Relations.Add(new DataRelation("bill_netti_csa_import", cPar, cChild, false));

            cPar   = new [] { bill_versamenti.Columns["ybill"], bill_versamenti.Columns["nbill"] };
            cChild = new [] { csa_import.Columns["ybill_versamenti"], csa_import.Columns["nbill_versamenti"] };
            Relations.Add(new DataRelation("bill_versamenti_csa_import", cPar, cChild, false));

            this.defineRelation("csa_import_csa_bill", "csa_import", "csa_bill", "idcsa_import");
            this.defineRelation("registry_sospesi_csa_bill", "registry_sospesi", "csa_bill", "idreg");
            this.defineRelation("bill_csa_bill", "bill_ripartizione", "csa_bill", "nbill");
            #endregion
        }
Beispiel #5
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "active", "annotation", "badgecode", "birthdate", "cf", "ct", "cu", "extmatricula", "foreigncf", "forename", "gender", "idcategory", "idcentralizedcategory", "idmaritalstatus", "idnation", "idregistryclass", "idtitle", "location", "lt", "lu", "maritalsurname", "p_iva", "residence", "rtf", "surname", "title", "txt");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// ACCOUNT /////////////////////////////////
            var taccount = new accountTable();
            taccount.addBaseColumns("idacc", "ayear", "codeacc", "ct", "cu", "flagregistry", "flagtransitory", "flagupb", "idaccountkind", "lt", "lu", "nlevel", "paridacc", "printingorder", "rtf", "title", "txt");
            Tables.Add(taccount);
            taccount.defineKey("idacc");

            //////////////////// EPEXP /////////////////////////////////
            var tepexp = new epexpTable();
            tepexp.addBaseColumns("yepexp", "nepexp", "description", "idreg", "start", "stop", "txt", "rtf", "adate", "ct", "cu", "lt", "lu", "doc", "docdate", "idrelated", "idepexp", "paridepexp", "nphase", "idman", "flagvariation", "idaccmotive");
            Tables.Add(tepexp);
            tepexp.defineKey("idepexp");

            //////////////////// EPEXPYEAR /////////////////////////////////
            var tepexpyear = new MetaTable("epexpyear");
            tepexpyear.defineColumn("idepexp", typeof(int), false);
            tepexpyear.defineColumn("ayear", typeof(short), false);
            tepexpyear.defineColumn("idupb", typeof(string), false);
            tepexpyear.defineColumn("idacc", typeof(string), false);
            tepexpyear.defineColumn("amount", typeof(decimal), false);
            tepexpyear.defineColumn("amount2", typeof(decimal));
            tepexpyear.defineColumn("amount3", typeof(decimal));
            tepexpyear.defineColumn("amount4", typeof(decimal));
            tepexpyear.defineColumn("amount5", typeof(decimal));
            tepexpyear.defineColumn("lt", typeof(DateTime));
            tepexpyear.defineColumn("lu", typeof(string));
            tepexpyear.defineColumn("ct", typeof(DateTime));
            tepexpyear.defineColumn("cu", typeof(string));
            Tables.Add(tepexpyear);
            tepexpyear.defineKey("idepexp", "ayear");

            //////////////////// EPEXPVAR /////////////////////////////////
            var tepexpvar = new MetaTable("epexpvar");
            tepexpvar.defineColumn("idepexp", typeof(int), false);
            tepexpvar.defineColumn("nvar", typeof(int), false);
            tepexpvar.defineColumn("adate", typeof(DateTime), false);
            tepexpvar.defineColumn("amount", typeof(decimal), false);
            tepexpvar.defineColumn("description", typeof(string), false);
            tepexpvar.defineColumn("ct", typeof(DateTime), false);
            tepexpvar.defineColumn("cu", typeof(string), false);
            tepexpvar.defineColumn("lt", typeof(DateTime), false);
            tepexpvar.defineColumn("lu", typeof(string), false);
            tepexpvar.defineColumn("amount2", typeof(decimal));
            tepexpvar.defineColumn("amount3", typeof(decimal));
            tepexpvar.defineColumn("amount4", typeof(decimal));
            tepexpvar.defineColumn("amount5", typeof(decimal));
            tepexpvar.defineColumn("yvar", typeof(short), false);
            Tables.Add(tepexpvar);
            tepexpvar.defineKey("idepexp", "nvar");

            //////////////////// UPB /////////////////////////////////
            var tupb = new upbTable();
            tupb.addBaseColumns("idupb", "active", "assured", "codeupb", "ct", "cu", "expiration", "granted", "lt", "lu", "paridupb", "previousappropriation", "previousassessment", "printingorder", "requested", "rtf", "title", "txt", "idman", "idunderwriter", "cupcode", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "flagactivity", "flagkind", "newcodeupb", "idtreasurer", "start", "stop", "cigcode");
            Tables.Add(tupb);
            tupb.defineKey("idupb");

            //////////////////// MANAGER /////////////////////////////////
            var tmanager = new managerTable();
            tmanager.addBaseColumns("active", "ct", "cu", "email", "lt", "lu", "passwordweb", "phonenumber", "rtf", "title", "txt", "userweb", "idman", "iddivision", "wantswarn", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "newidman", "financeactive");
            Tables.Add(tmanager);
            tmanager.defineKey("idman");

            //////////////////// EPEXPSORTING /////////////////////////////////
            var tepexpsorting = new MetaTable("epexpsorting");
            tepexpsorting.defineColumn("amount", typeof(decimal), false);
            tepexpsorting.defineColumn("adate", typeof(DateTime), false);
            tepexpsorting.defineColumn("description", typeof(string));
            tepexpsorting.defineColumn("ct", typeof(DateTime), false);
            tepexpsorting.defineColumn("cu", typeof(string), false);
            tepexpsorting.defineColumn("lt", typeof(DateTime), false);
            tepexpsorting.defineColumn("lu", typeof(string), false);
            tepexpsorting.defineColumn("idsor", typeof(int), false);
            tepexpsorting.defineColumn("idepexp", typeof(int), false);
            tepexpsorting.defineColumn("ayear", typeof(short), false);
            tepexpsorting.defineColumn("rownum", typeof(int), false);
            tepexpsorting.defineColumn("!percentuale", typeof(string));
            tepexpsorting.defineColumn("!sortingkind", typeof(string));
            tepexpsorting.defineColumn("!sortcode", typeof(string));
            tepexpsorting.defineColumn("!sorting", typeof(string));
            tepexpsorting.defineColumn("kind", typeof(string));
            Tables.Add(tepexpsorting);
            tepexpsorting.defineKey("idepexp", "rownum");

            //////////////////// SORTINGVIEW /////////////////////////////////
            var tsortingview = new MetaTable("sortingview");
            tsortingview.defineColumn("sortingkind", typeof(string), false);
            tsortingview.defineColumn("idsor", typeof(int), false);
            tsortingview.defineColumn("sortcode", typeof(string), false);
            tsortingview.defineColumn("description", typeof(string), false);
            Tables.Add(tsortingview);
            tsortingview.defineKey("idsor");

            //////////////////// EPEXPSORTINGVIEW /////////////////////////////////
            var tepexpsortingview = new MetaTable("epexpsortingview");
            tepexpsortingview.defineColumn("idepexp", typeof(int), false);
            tepexpsortingview.defineColumn("rownum", typeof(int), false);
            tepexpsortingview.defineColumn("yepexp", typeof(short), false);
            tepexpsortingview.defineColumn("nepexp", typeof(int), false);
            tepexpsortingview.defineColumn("nphase", typeof(short), false);
            tepexpsortingview.defineColumn("description", typeof(string));
            tepexpsortingview.defineColumn("amount", typeof(decimal), false);
            tepexpsortingview.defineColumn("ayear", typeof(short), false);
            tepexpsortingview.defineColumn("adate", typeof(DateTime), false);
            tepexpsortingview.defineColumn("idsorkind", typeof(int), false);
            tepexpsortingview.defineColumn("idsor", typeof(int), false);
            tepexpsortingview.defineColumn("sortingkind", typeof(string), false);
            tepexpsortingview.defineColumn("sortcode", typeof(string), false);
            tepexpsortingview.defineColumn("sorting", typeof(string), false);
            tepexpsortingview.defineColumn("lt", typeof(DateTime), false);
            tepexpsortingview.defineColumn("lu", typeof(string), false);
            tepexpsortingview.defineColumn("ct", typeof(DateTime), false);
            tepexpsortingview.defineColumn("cu", typeof(string), false);
            tepexpsortingview.defineColumn("kind", typeof(string));
            Tables.Add(tepexpsortingview);
            tepexpsortingview.defineKey("idepexp", "rownum");

            //////////////////// MANDATEDETAIL /////////////////////////////////
            var tmandatedetail = new mandatedetailTable();
            tmandatedetail.addBaseColumns("idmankind", "nman", "rownum", "yman", "annotations", "assetkind", "competencystart", "competencystop", "ct", "cu", "detaildescription", "discount", "idupb", "lt", "lu", "ninvoiced", "number", "start", "stop", "tax", "taxable", "taxrate", "toinvoice", "flagmixed", "idaccmotive", "unabatable", "idgroup", "idreg", "idexp_taxable", "idexp_iva", "idinv", "idivakind", "idsor1", "idsor2", "idsor3", "idaccmotiveannulment", "flagactivity", "va3type", "applierannotations", "ivanotes", "idlist", "idunit", "idpackage", "unitsforpackage", "npackage", "cupcode", "cigcode", "flagto_unload", "epkind", "rownum_origin", "contractamount", "idavcp", "idavcp_choice", "avcp_startcontract", "avcp_stopcontract", "avcp_description", "idpccdebitmotive", "idpccdebitstatus", "idcostpartition", "expensekind", "idepexp");
            Tables.Add(tmandatedetail);
            tmandatedetail.defineKey("idmankind", "nman", "rownum", "yman");

            //////////////////// INVOICEDETAIL /////////////////////////////////
            var tinvoicedetail = new invoicedetailTable();
            tinvoicedetail.addBaseColumns("ninv", "rownum", "yinv", "annotations", "competencystart", "paymentcompetency", "competencystop", "ct", "cu", "detaildescription", "discount", "idaccmotive", "idmankind", "idupb", "lt", "lu", "manrownum", "nman", "number", "tax", "taxable", "unabatable", "yman", "idestimkind", "estimrownum", "nestim", "yestim", "idgroup", "idexp_taxable", "idexp_iva", "idinc_taxable", "idinc_iva", "ninv_main", "yinv_main", "idivakind", "idinvkind", "idsor1", "idsor2", "idsor3", "idintrastatcode", "idintrastatmeasure", "weight", "va3type", "intrastatoperationkind", "idintrastatservice", "idintrastatsupplymethod", "idlist", "idunit", "idpackage", "unitsforpackage", "npackage", "flag", "exception12", "intra12operationkind", "move12", "idupb_iva", "idinvkind_main", "leasing", "usedmodesospesometro", "resetresidualmandate", "idfetransfer", "fereferencerule", "cupcode", "cigcode", "idpccdebitstatus", "idpccdebitmotive", "idcostpartition", "expensekind", "rounding", "idepexp", "idepacc");
            Tables.Add(tinvoicedetail);
            tinvoicedetail.defineKey("ninv", "rownum", "yinv", "idinvkind");

            //////////////////// EPEXPTOTAL /////////////////////////////////
            var tepexptotal = new MetaTable("epexptotal");
            tepexptotal.defineColumn("idepexp", typeof(int), false);
            tepexptotal.defineColumn("ayear", typeof(short), false);
            tepexptotal.defineColumn("available", typeof(decimal));
            tepexptotal.defineColumn("available2", typeof(decimal));
            tepexptotal.defineColumn("available3", typeof(decimal));
            tepexptotal.defineColumn("available4", typeof(decimal));
            tepexptotal.defineColumn("available5", typeof(decimal));
            tepexptotal.defineColumn("curramount", typeof(decimal));
            tepexptotal.defineColumn("curramount2", typeof(decimal));
            tepexptotal.defineColumn("curramount3", typeof(decimal));
            tepexptotal.defineColumn("curramount4", typeof(decimal));
            tepexptotal.defineColumn("curramount5", typeof(decimal));
            Tables.Add(tepexptotal);
            tepexptotal.defineKey("idepexp", "ayear");

            //////////////////// ACCMOTIVE /////////////////////////////////
            var taccmotive = new accmotiveTable();
            taccmotive.addBaseColumns("idaccmotive", "active", "codemotive", "ct", "cu", "lt", "lu", "paridaccmotive", "title", "flagdep", "flagamm", "expensekind");
            Tables.Add(taccmotive);
            taccmotive.defineKey("idaccmotive");

            #endregion


            #region DataRelation creation
            this.defineRelation("epexp_invoicedetail", "epexp", "invoicedetail", "idepexp");
            this.defineRelation("epexp_mandatedetail", "epexp", "mandatedetail", "idepexp");
            this.defineRelation("epexp_epexpsorting", "epexp", "epexpsorting", "idepexp");
            this.defineRelation("sortingview_epexpsorting", "sortingview", "epexpsorting", "idsor");
            this.defineRelation("epexp_epexpvar", "epexp", "epexpvar", "idepexp");
            this.defineRelation("epexp_epexpyear", "epexp", "epexpyear", "idepexp");
            this.defineRelation("upb_epexpyear", "upb", "epexpyear", "idupb");
            this.defineRelation("account_epexpyear", "account", "epexpyear", "idacc");
            this.defineRelation("manager_epexp", "manager", "epexp", "idman");
            this.defineRelation("registry_epexp", "registry", "epexp", "idreg");
            var cPar   = new [] { epexp.Columns["idepexp"] };
            var cChild = new [] { epexp.Columns["paridepexp"] };
            Relations.Add(new DataRelation("epexp_epexp", cPar, cChild, false));

            this.defineRelation("accmotive_epexp", "accmotive", "epexp", "idaccmotive");
            #endregion
        }
Beispiel #6
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// INVOICEDETAIL /////////////////////////////////
            var tinvoicedetail = new invoicedetailTable();
            tinvoicedetail.addBaseColumns("idinvkind", "yinv", "ninv", "rownum", "idgroup", "idivakind", "detaildescription", "annotations", "taxable", "tax", "unabatable", "cu", "ct", "lu", "lt", "discount", "idmankind", "yman", "nman", "manrownum", "number", "idupb", "idsor1", "idsor2", "idsor3", "competencystart", "competencystop", "idexp_taxable", "idexp_iva", "idaccmotive", "idestimkind", "estimrownum", "nestim", "yestim", "idintrastatcode", "idintrastatmeasure", "weight", "va3type", "idlist", "idpackage", "idunit", "npackage", "unitsforpackage", "flag", "intrastatoperationkind", "intra12operationkind", "exception12", "move12", "idupb_iva", "idintrastatservice", "idintrastatsupplymethod", "leasing", "usedmodesospesometro", "resetresidualmandate", "idcostpartition", "idpccdebitmotive", "idpccdebitstatus", "expensekind", "rounding", "idepexp", "idepacc", "ycon", "ncon", "idsor_siope");
            tinvoicedetail.defineColumn("!codeupb", typeof(string));
            tinvoicedetail.defineColumn("!disponibile", typeof(decimal));
            tinvoicedetail.defineColumn("!idexptolink", typeof(string));
            tinvoicedetail.defineColumn("!monomandate", typeof(string));
            tinvoicedetail.defineColumn("!tipoiva", typeof(string));
            tinvoicedetail.defineColumn("!totaleriga", typeof(decimal));
            tinvoicedetail.defineColumn("!aliquota", typeof(decimal));
            tinvoicedetail.defineColumn("!codeupb_iva", typeof(string));
            Tables.Add(tinvoicedetail);
            tinvoicedetail.defineKey("idinvkind", "yinv", "ninv", "rownum");

            //////////////////// EXPENSEPHASE /////////////////////////////////
            var texpensephase = new MetaTable("expensephase");
            texpensephase.defineColumn("nphase", typeof(byte), false);
            texpensephase.defineColumn("ct", typeof(DateTime), false);
            texpensephase.defineColumn("cu", typeof(string), false);
            texpensephase.defineColumn("description", typeof(string), false);
            texpensephase.defineColumn("lt", typeof(DateTime), false);
            texpensephase.defineColumn("lu", typeof(string), false);
            Tables.Add(texpensephase);
            texpensephase.defineKey("nphase");

            //////////////////// INVOICEKIND /////////////////////////////////
            var tinvoicekind = new invoicekindTable();
            tinvoicekind.addBaseColumns("idinvkind", "flag", "ct", "cu", "description", "lt", "lu", "active", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05");
            Tables.Add(tinvoicekind);
            tinvoicekind.defineKey("idinvkind");

            //////////////////// IVAKIND /////////////////////////////////
            var tivakind = new ivakindTable();
            tivakind.addBaseColumns("idivakind", "ct", "cu", "description", "lt", "lu", "rate", "unabatabilitypercentage", "active");
            Tables.Add(tivakind);
            tivakind.defineKey("idivakind");

            //////////////////// EXPENSE /////////////////////////////////
            var texpense = new expenseTable();
            texpense.addBaseColumns("adate", "ct", "cu", "description", "doc", "docdate", "expiration", "idreg", "lt", "lu", "nmov", "rtf", "txt", "ymov", "idclawback", "idman", "nphase", "idexp", "parentidexp", "idpayment", "idformerexpense", "autokind", "autocode");
            Tables.Add(texpense);
            texpense.defineKey("idexp");

            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "active", "annotation", "badgecode", "birthdate", "cf", "ct", "cu", "extmatricula", "foreigncf", "forename", "gender", "idcategory", "idcentralizedcategory", "idcity", "idmaritalstatus", "idnation", "idregistryclass", "idtitle", "location", "lt", "lu", "maritalsurname", "p_iva", "residence", "rtf", "surname", "title", "txt");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// EXPENSEYEAR /////////////////////////////////
            var texpenseyear = new expenseyearTable();
            texpenseyear.addBaseColumns("ayear", "idexp", "amount", "ct", "cu", "idfin", "idupb", "lt", "lu");
            Tables.Add(texpenseyear);
            texpenseyear.defineKey("ayear", "idexp");

            //////////////////// FIN /////////////////////////////////
            var tfin = new finTable();
            tfin.addBaseColumns("idfin", "ayear", "flag", "codefin", "paridfin", "nlevel", "printingorder", "title", "cu", "ct", "lu", "lt");
            Tables.Add(tfin);
            tfin.defineKey("idfin");

            //////////////////// UPB /////////////////////////////////
            var tupb = new upbTable();
            tupb.addBaseColumns("idupb", "active", "assured", "codeupb", "ct", "cu", "expiration", "granted", "idman", "idunderwriter", "lt", "lu", "paridupb", "previousappropriation", "previousassessment", "printingorder", "requested", "rtf", "title", "txt", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05");
            Tables.Add(tupb);
            tupb.defineKey("idupb");

            //////////////////// TIPOMOVIMENTO /////////////////////////////////
            var ttipomovimento = new MetaTable("tipomovimento");
            ttipomovimento.defineColumn("idtipo", typeof(string), false);
            ttipomovimento.defineColumn("descrizione", typeof(string), false);
            Tables.Add(ttipomovimento);
            ttipomovimento.defineKey("idtipo");

            //////////////////// INVOICE /////////////////////////////////
            var tinvoice = new invoiceTable();
            tinvoice.addBaseColumns("idinvkind", "ninv", "yinv", "active", "adate", "ct", "cu", "description", "doc", "docdate", "exchangerate", "flagdeferred", "idcurrency", "idexpirationkind", "idreg", "lt", "lu", "officiallyprinted", "packinglistdate", "packinglistnum", "paymentexpiring", "registryreference", "rtf", "txt", "idaccmotivedebit", "idaccmotivedebit_crg", "flag", "idblacklist", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "flag_enable_split_payment", "flag_auto_split_payment", "requested_doc", "flagbit", "flagintracom");
            Tables.Add(tinvoice);
            tinvoice.defineKey("idinvkind", "ninv", "yinv");

            //////////////////// EXPENSEINVOICE /////////////////////////////////
            var texpenseinvoice = new MetaTable("expenseinvoice");
            texpenseinvoice.defineColumn("idexp", typeof(int), false);
            texpenseinvoice.defineColumn("idinvkind", typeof(int), false);
            texpenseinvoice.defineColumn("ninv", typeof(int), false);
            texpenseinvoice.defineColumn("yinv", typeof(short), false);
            texpenseinvoice.defineColumn("ct", typeof(DateTime), false);
            texpenseinvoice.defineColumn("cu", typeof(string), false);
            texpenseinvoice.defineColumn("lt", typeof(DateTime), false);
            texpenseinvoice.defineColumn("lu", typeof(string), false);
            texpenseinvoice.defineColumn("movkind", typeof(short));
            Tables.Add(texpenseinvoice);
            texpenseinvoice.defineKey("idexp", "idinvkind", "ninv", "yinv");

            //////////////////// EXPENSELAST /////////////////////////////////
            var texpenselast = new expenselastTable();
            texpenselast.addBaseColumns("idexp", "cc", "cin", "ct", "cu", "flag", "idbank", "idcab", "iddeputy", "idpay", "idpaymethod", "idregistrypaymethod", "idser", "ivaamount", "lt", "lu", "nbill", "paymentdescr", "servicestart", "servicestop", "refexternaldoc", "kpay", "iban", "idaccdebit", "biccode", "paymethod_flag", "paymethod_allowdeputy", "extracode", "idchargehandling");
            Tables.Add(texpenselast);
            texpenselast.defineKey("idexp");

            //////////////////// BILL /////////////////////////////////
            var tbill = new billTable();
            tbill.addBaseColumns("ybill", "nbill", "billkind", "registry", "covered", "total", "adate", "active", "motive", "cu", "ct", "lu", "lt");
            Tables.Add(tbill);
            tbill.defineKey("nbill");

            //////////////////// BILLVIEW /////////////////////////////////
            var tbillview = new MetaTable("billview");
            tbillview.defineColumn("ybill", typeof(short), false);
            tbillview.defineColumn("nbill", typeof(int), false);
            tbillview.defineColumn("billkind", typeof(string), false);
            tbillview.defineColumn("active", typeof(string));
            tbillview.defineColumn("adate", typeof(DateTime));
            tbillview.defineColumn("registry", typeof(string));
            tbillview.defineColumn("motive", typeof(string));
            tbillview.defineColumn("total", typeof(decimal));
            tbillview.defineColumn("covered", typeof(decimal));
            tbillview.defineColumn("cu", typeof(string), false);
            tbillview.defineColumn("ct", typeof(DateTime), false);
            tbillview.defineColumn("lu", typeof(string), false);
            tbillview.defineColumn("lt", typeof(DateTime), false);
            tbillview.defineColumn("idtreasurer", typeof(int));
            tbillview.defineColumn("treasurer", typeof(string));
            tbillview.defineColumn("regularizationnote", typeof(string));
            tbillview.defineColumn("idsor01", typeof(int));
            tbillview.defineColumn("idsor02", typeof(int));
            tbillview.defineColumn("idsor03", typeof(int));
            tbillview.defineColumn("idsor04", typeof(int));
            tbillview.defineColumn("idsor05", typeof(int));
            Tables.Add(tbillview);

            //////////////////// ACCOUNT /////////////////////////////////
            var taccount = new accountTable();
            taccount.addBaseColumns("idacc", "ayear", "codeacc", "ct", "cu", "flagregistry", "flagtransitory", "flagupb", "idaccountkind", "lt", "lu", "nlevel", "paridacc", "printingorder", "rtf", "title", "txt", "idpatrimony", "idplaccount", "flagprofit", "flagloss", "placcount_sign", "patrimony_sign", "flagcompetency", "flag");
            Tables.Add(taccount);
            taccount.defineKey("idacc");

            //////////////////// EXPENSECLAWBACK /////////////////////////////////
            var texpenseclawback = new MetaTable("expenseclawback");
            texpenseclawback.defineColumn("idexp", typeof(int), false);
            texpenseclawback.defineColumn("idclawback", typeof(int), false);
            texpenseclawback.defineColumn("amount", typeof(decimal));
            texpenseclawback.defineColumn("cu", typeof(string), false);
            texpenseclawback.defineColumn("ct", typeof(DateTime), false);
            texpenseclawback.defineColumn("lu", typeof(string), false);
            texpenseclawback.defineColumn("lt", typeof(DateTime), false);
            texpenseclawback.defineColumn("!clawbackref", typeof(string));
            texpenseclawback.defineColumn("fiscaltaxcode", typeof(string));
            texpenseclawback.defineColumn("identifying_marks", typeof(string));
            texpenseclawback.defineColumn("code", typeof(string));
            texpenseclawback.defineColumn("tiporiga", typeof(string));
            texpenseclawback.defineColumn("rifb_month", typeof(int));
            texpenseclawback.defineColumn("rifb_year", typeof(int));
            texpenseclawback.defineColumn("rifa_month", typeof(int));
            texpenseclawback.defineColumn("rifa_year", typeof(int));
            texpenseclawback.defineColumn("rifa", typeof(string));
            Tables.Add(texpenseclawback);
            texpenseclawback.defineKey("idexp", "idclawback");

            //////////////////// CLAWBACK /////////////////////////////////
            var tclawback = new MetaTable("clawback");
            tclawback.defineColumn("idclawback", typeof(int), false);
            tclawback.defineColumn("description", typeof(string), false);
            tclawback.defineColumn("cu", typeof(string), false);
            tclawback.defineColumn("ct", typeof(DateTime), false);
            tclawback.defineColumn("lu", typeof(string), false);
            tclawback.defineColumn("lt", typeof(DateTime), false);
            tclawback.defineColumn("clawbackref", typeof(string));
            tclawback.defineColumn("active", typeof(string));
            tclawback.defineColumn("flagf24ep", typeof(string));
            Tables.Add(tclawback);
            tclawback.defineKey("idclawback");

            //////////////////// CONFIG /////////////////////////////////
            var tconfig = new configTable();
            tconfig.addBaseColumns("ayear", "agencycode", "appname", "appropriationphasecode", "assessmentphasecode", "asset_flagnumbering", "asset_flagrestart", "assetload_flag", "boxpartitiontitle", "casualcontract_flagrestart", "ct", "cu", "currpartitiontitle", "deferredexpensephase", "deferredincomephase", "electronicimport", "electronictrasmission", "expense_expiringdays", "expensephase", "flagautopayment", "flagautoproceeds", "flagcredit", "flagepexp", "flagfruitful", "flagpayment", "flagproceeds", "flagrefund", "foreignhours", "idacc_accruedcost", "idacc_accruedrevenue", "idacc_customer", "idacc_deferredcost", "idacc_deferredcredit", "idacc_deferreddebit", "idacc_deferredrevenue", "idacc_ivapayment", "idacc_ivarefund", "idacc_patrimony", "idacc_pl", "idacc_supplier", "idaccmotive_admincar", "idaccmotive_foot", "idaccmotive_owncar", "idclawback", "idfinexpense", "idfinexpensesurplus", "idfinincomesurplus", "idfinivapayment", "idfinivarefund", "idregauto", "importappname", "income_expiringdays", "incomephase", "linktoinvoice", "lt", "lu", "minpayment", "minrefund", "motivelen", "motiveprefix", "motiveseparator", "payment_finlevel", "payment_flag", "payment_flagautoprintdate", "paymentagency", "prevpartitiontitle", "proceeds_finlevel", "proceeds_flag", "proceeds_flagautoprintdate", "profservice_flagrestart", "refundagency", "wageaddition_flagrestart", "idivapayperiodicity", "idsortingkind1", "idsortingkind2", "idsortingkind3", "fin_kind", "taxvaliditykind", "flag_paymentamount", "automanagekind", "flag_autodocnumbering", "flagbank_grouping", "cashvaliditykind");
            Tables.Add(tconfig);
            tconfig.defineKey("ayear");

            //////////////////// INVOICEDETAILDEFERRED /////////////////////////////////
            var tinvoicedetaildeferred = new MetaTable("invoicedetaildeferred");
            tinvoicedetaildeferred.defineColumn("idinvkind", typeof(int), false);
            tinvoicedetaildeferred.defineColumn("yinv", typeof(short), false);
            tinvoicedetaildeferred.defineColumn("ninv", typeof(int), false);
            tinvoicedetaildeferred.defineColumn("rownum", typeof(int), false);
            tinvoicedetaildeferred.defineColumn("yivapay", typeof(short), false);
            tinvoicedetaildeferred.defineColumn("nivapay", typeof(int), false);
            tinvoicedetaildeferred.defineColumn("ivatotalpayed", typeof(decimal));
            tinvoicedetaildeferred.defineColumn("taxable", typeof(decimal));
            tinvoicedetaildeferred.defineColumn("cu", typeof(string));
            tinvoicedetaildeferred.defineColumn("ct", typeof(DateTime));
            tinvoicedetaildeferred.defineColumn("lu", typeof(string));
            tinvoicedetaildeferred.defineColumn("lt", typeof(string));
            tinvoicedetaildeferred.defineColumn("idivaregisterkind", typeof(int), false);
            Tables.Add(tinvoicedetaildeferred);
            tinvoicedetaildeferred.defineKey("idinvkind", "yinv", "ninv", "rownum", "yivapay", "nivapay", "idivaregisterkind");

            //////////////////// EXPENSESORTED /////////////////////////////////
            var texpensesorted = new expensesortedTable();
            texpensesorted.addBaseColumns("idsor", "idexp", "idsubclass", "amount", "valuen1", "valuen2", "valuen3", "valuen4", "valuen5", "values1", "values2", "values3", "values4", "values5", "valuev1", "valuev2", "valuev3", "valuev4", "valuev5", "ayear", "description", "txt", "rtf", "cu", "ct", "lu", "lt", "flagnodate", "tobecontinued", "start", "stop", "paridsor", "paridsubclass");
            Tables.Add(texpensesorted);
            texpensesorted.defineKey("idexp", "idsor", "idsubclass");

            #endregion


            #region DataRelation creation
            this.defineRelation("invoicedetail_invoicedetaildeferred", "invoicedetail", "invoicedetaildeferred", "idinvkind", "yinv", "ninv", "rownum");
            this.defineRelation("expense_expenseclawback", "expense", "expenseclawback", "idexp");
            this.defineRelation("clawback_expenseclawback", "clawback", "expenseclawback", "idclawback");
            var cPar   = new [] { account.Columns["idacc"] };
            var cChild = new [] { expenselast.Columns["idaccdebit"] };
            Relations.Add(new DataRelation("account_expenselast", cPar, cChild, false));

            this.defineRelation("bill_expenselast", "bill", "expenselast", "nbill");
            this.defineRelation("expense_expenselast", "expense", "expenselast", "idexp");
            this.defineRelation("FK_expense_expenseinvoice", "expense", "expenseinvoice", "idexp");
            this.defineRelation("FK_invoice_expenseinvoice", "invoice", "expenseinvoice", "idinvkind", "ninv", "yinv");
            this.defineRelation("invoicekind_invoice", "invoicekind", "invoice", "idinvkind");
            this.defineRelation("upb_expenseyear", "upb", "expenseyear", "idupb");
            this.defineRelation("fin_expenseyear", "fin", "expenseyear", "idfin");
            this.defineRelation("expense_expenseyear", "expense", "expenseyear", "idexp");
            this.defineRelation("registry_expense", "registry", "expense", "idreg");
            cPar   = new [] { expense.Columns["idexp"] };
            cChild = new [] { expense.Columns["parentidexp"] };
            Relations.Add(new DataRelation("expense_expense", cPar, cChild, false));

            cPar   = new [] { expense.Columns["idexp"] };
            cChild = new [] { invoicedetail.Columns["idexp_iva"] };
            Relations.Add(new DataRelation("expense_invoicedetail1", cPar, cChild, false));

            this.defineRelation("invoice_invoicedetail", "invoice", "invoicedetail", "idinvkind", "ninv", "yinv");
            cPar   = new [] { expense.Columns["idexp"] };
            cChild = new [] { invoicedetail.Columns["idexp_taxable"] };
            Relations.Add(new DataRelation("expense_invoicedetail", cPar, cChild, false));

            this.defineRelation("ivakind_invoicedetail", "ivakind", "invoicedetail", "idivakind");
            this.defineRelation("expense_expensesorted", "expense", "expensesorted", "idexp");
            #endregion
        }
Beispiel #7
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// NO_TABLE /////////////////////////////////
            var tno_table = new MetaTable("no_table");
            tno_table.defineColumn("idnotable", typeof(string), false);
            Tables.Add(tno_table);
            tno_table.defineKey("idnotable");

            //////////////////// LICENSE /////////////////////////////////
            var tlicense = new MetaTable("license");
            tlicense.defineColumn("dummykey", typeof(string), false);
            tlicense.defineColumn("address1", typeof(string));
            tlicense.defineColumn("address2", typeof(string));
            tlicense.defineColumn("agency", typeof(string));
            tlicense.defineColumn("agencycode", typeof(string));
            tlicense.defineColumn("agencyname", typeof(string));
            tlicense.defineColumn("annotations", typeof(string));
            tlicense.defineColumn("cap", typeof(string));
            tlicense.defineColumn("cf", typeof(string));
            tlicense.defineColumn("checkbackup1", typeof(string));
            tlicense.defineColumn("checkbackup2", typeof(string));
            tlicense.defineColumn("checkflag", typeof(string));
            tlicense.defineColumn("checklic", typeof(string));
            tlicense.defineColumn("checkman", typeof(string));
            tlicense.defineColumn("country", typeof(string));
            tlicense.defineColumn("dbname", typeof(string));
            tlicense.defineColumn("department", typeof(string));
            tlicense.defineColumn("departmentcode", typeof(string));
            tlicense.defineColumn("departmentname", typeof(string));
            tlicense.defineColumn("email", typeof(string));
            tlicense.defineColumn("expiringlic", typeof(DateTime));
            tlicense.defineColumn("expiringman", typeof(DateTime));
            tlicense.defineColumn("fax", typeof(string));
            tlicense.defineColumn("idcity", typeof(int));
            tlicense.defineColumn("iddb", typeof(int));
            tlicense.defineColumn("idreg", typeof(int));
            tlicense.defineColumn("lickind", typeof(string));
            tlicense.defineColumn("licstatus", typeof(string));
            tlicense.defineColumn("location", typeof(string));
            tlicense.defineColumn("lt", typeof(DateTime));
            tlicense.defineColumn("lu", typeof(string));
            tlicense.defineColumn("mankind", typeof(string));
            tlicense.defineColumn("manstatus", typeof(string));
            tlicense.defineColumn("nmsgs", typeof(int));
            tlicense.defineColumn("p_iva", typeof(string));
            tlicense.defineColumn("phonenumber", typeof(string));
            tlicense.defineColumn("referent", typeof(string));
            tlicense.defineColumn("sent", typeof(string));
            tlicense.defineColumn("serverbackup1", typeof(string));
            tlicense.defineColumn("serverbackup2", typeof(string));
            tlicense.defineColumn("servername", typeof(string));
            tlicense.defineColumn("swmorecode", typeof(string));
            tlicense.defineColumn("swmoreflag", typeof(int));
            Tables.Add(tlicense);
            tlicense.defineKey("dummykey");

            //////////////////// CONFIG /////////////////////////////////
            var tconfig = new configTable();
            tconfig.addBaseColumns("ayear", "agencycode", "appname", "appropriationphasecode", "assessmentphasecode", "asset_flagnumbering", "asset_flagrestart", "assetload_flag", "boxpartitiontitle", "finvarofficial_default", "casualcontract_flagrestart", "ct", "cu", "currpartitiontitle", "deferredexpensephase", "deferredincomephase", "electronicimport", "electronictrasmission", "expense_expiringdays", "expensephase", "flagautopayment", "flagautoproceeds", "flagcredit", "flagepexp", "flagfruitful", "flagpayment", "flagproceeds", "flagrefund", "foreignhours", "idacc_accruedcost", "idacc_accruedrevenue", "idacc_customer", "idacc_deferredcost", "idacc_deferredcredit", "idacc_deferreddebit", "idacc_deferredrevenue", "idacc_ivapayment", "idacc_ivarefund", "idacc_patrimony", "idacc_pl", "idacc_supplier", "idaccmotive_admincar", "idaccmotive_foot", "idaccmotive_owncar", "idclawback", "idfinexpense", "idfinexpensesurplus", "idfinincomesurplus", "idfinivapayment", "idfinivarefund", "idregauto", "importappname", "income_expiringdays", "incomephase", "linktoinvoice", "lt", "lu", "minpayment", "minrefund", "motivelen", "motiveprefix", "motiveseparator", "payment_finlevel", "payment_flag", "payment_flagautoprintdate", "paymentagency", "prevpartitiontitle", "proceeds_finlevel", "proceeds_flag", "proceeds_flagautoprintdate", "profservice_flagrestart", "refundagency", "wageaddition_flagrestart", "idivapayperiodicity", "idsortingkind1", "idsortingkind2", "idsortingkind3", "fin_kind", "taxvaliditykind", "flag_paymentamount", "automanagekind", "flag_autodocnumbering", "flagbank_grouping", "cashvaliditykind", "wageimportappname", "balancekind", "idpaymethodabi", "idpaymethodnoabi", "iban_f24", "cudactivitycode", "startivabalance", "flagivapaybyrow", "idacc_unabatable", "idacc_unabatable_refund", "invoice_flagregister", "default_idfinvarstatus", "flagivaregphase", "mainflagpayment", "mainflagrefund", "mainidfinivapayment", "mainidfinivarefund", "mainminpayment", "mainminrefund", "mainpaymentagency", "mainrefundagency", "mainflagivaregphase", "mainstartivabalance", "mainidacc_unabatable", "mainidacc_unabatable_refund", "idacc_mainivapayment", "idacc_mainivapayment_internal", "idacc_mainivarefund", "idacc_mainivarefund_internal", "flagva3", "flagrefund12", "flagpayment12", "refundagency12", "paymentagency12", "idfinivarefund12", "idfinivapayment12", "minrefund12", "minpayment12", "idacc_ivapayment12", "idacc_ivarefund12", "idacc_mainivarefund12", "idacc_mainivapayment12", "idacc_mainivapayment_internal12", "idacc_mainivarefund_internal12", "startivabalance12", "mainrefundagency12", "mainpaymentagency12", "mainflagrefund12", "mainflagpayment12", "mainidfinivarefund12", "mainidfinivapayment12", "mainminrefund12", "mainminpayment12", "mainstartivabalance12", "idreg_csa", "finvar_warnmail", "flagdirectcsaclawback", "idacc_revenue_gross_csa", "idfinincome_gross_csa", "idsor1_stock", "idsor2_stock", "idsor3_stock", "idinpscenter", "idivapayperiodicity_instit", "idfin_store", "flagpcashautopayment", "flagpcashautoproceeds", "email", "lcard", "booking_on_invoice");
            Tables.Add(tconfig);
            tconfig.defineKey("ayear");

            //////////////////// ESTIMATEDETAIL /////////////////////////////////
            var testimatedetail = new estimatedetailTable();
            testimatedetail.addBaseColumns("idestimkind", "yestim", "nestim", "rownum", "annotations", "ct", "cu", "detaildescription", "discount", "idupb", "lt", "lu", "ninvoiced", "number", "start", "stop", "tax", "taxable", "taxrate", "toinvoice", "idaccmotive", "idreg", "idgroup", "competencystart", "competencystop", "idinc_taxable", "idinc_iva", "idivakind", "idsor1", "idsor2", "idsor3", "idaccmotiveannulment", "epkind", "idrevenuepartition", "idepacc", "idupb_iva", "idlist", "cigcode", "iduniqueformcode", "idfinmotive", "flag", "nform", "idsor_siope", "idepacc_pre");
            testimatedetail.defineColumn("!codeupb", typeof(string));
            testimatedetail.defineColumn("!codeupb_iva", typeof(string));
            testimatedetail.defineColumn("!registry", typeof(string));
            testimatedetail.defineColumn("!totaleriga", typeof(decimal));
            Tables.Add(testimatedetail);
            testimatedetail.defineKey("idestimkind", "yestim", "nestim", "rownum");

            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "active", "annotation", "badgecode", "birthdate", "cf", "ct", "cu", "extmatricula", "foreigncf", "forename", "gender", "idcategory", "idcentralizedcategory", "idcity", "idmaritalstatus", "idnation", "idregistryclass", "idtitle", "location", "lt", "lu", "maritalsurname", "p_iva", "rtf", "surname", "title", "txt", "residence", "idregistrykind", "authorization_free", "multi_cf", "toredirect", "idaccmotivedebit", "idaccmotivecredit", "ccp", "flagbankitaliaproceeds", "idexternal", "ipa_fe", "flag_pa", "sdi_norifamm", "sdi_defrifamm", "email_fe", "pec_fe");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// ESTIMATEKIND /////////////////////////////////
            var testimatekind = new estimatekindTable();
            testimatekind.addBaseColumns("idestimkind", "active", "ct", "cu", "description", "idupb", "lt", "lu", "rtf", "txt", "email", "faxnumber", "office", "phonenumber", "linktoinvoice", "multireg", "deltaamount", "deltapercentage", "flag_autodocnumbering", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "address", "header", "idivakind_forced", "flag");
            Tables.Add(testimatekind);
            testimatekind.defineKey("idestimkind");

            //////////////////// ESTIMATE /////////////////////////////////
            var testimate = new estimateTable();
            testimate.addBaseColumns("idestimkind", "yestim", "nestim", "active", "adate", "ct", "cu", "deliveryaddress", "deliveryexpiration", "description", "doc", "docdate", "exchangerate", "idreg", "lt", "lu", "officiallyprinted", "paymentexpiring", "registryreference", "txt", "idman", "idcurrency", "idexpirationkind", "flagintracom", "idaccmotivecredit", "idaccmotivecredit_crg", "idaccmotivecredit_datacrg", "idsor_underwriter", "idunderwriting", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "external_reference", "cigcode");
            Tables.Add(testimate);
            testimate.defineKey("idestimkind", "yestim", "nestim");

            //////////////////// INCOMEPHASE /////////////////////////////////
            var tincomephase = new MetaTable("incomephase");
            tincomephase.defineColumn("nphase", typeof(byte), false);
            tincomephase.defineColumn("description", typeof(string), false);
            tincomephase.defineColumn("cu", typeof(string), false);
            tincomephase.defineColumn("ct", typeof(DateTime), false);
            tincomephase.defineColumn("lu", typeof(string), false);
            tincomephase.defineColumn("lt", typeof(DateTime), false);
            Tables.Add(tincomephase);
            tincomephase.defineKey("nphase");

            //////////////////// INCOMELAST /////////////////////////////////
            var tincomelast = new incomelastTable();
            tincomelast.addBaseColumns("idinc", "ct", "cu", "flag", "idpro", "lt", "lu", "nbill", "kpro", "idacccredit");
            Tables.Add(tincomelast);
            tincomelast.defineKey("idinc");

            //////////////////// INCOMESORTED /////////////////////////////////
            var tincomesorted = new incomesortedTable();
            tincomesorted.addBaseColumns("idinc", "idsor", "idsubclass", "amount", "ayear", "ct", "cu", "description", "flagnodate", "lt", "lu", "paridsor", "paridsubclass", "rtf", "start", "stop", "tobecontinued", "txt", "valuen1", "valuen2", "valuen3", "valuen4", "valuen5", "values1", "values2", "values3", "values4", "values5", "valuev1", "valuev2", "valuev3", "valuev4", "valuev5");
            Tables.Add(tincomesorted);
            tincomesorted.defineKey("idinc", "idsor", "idsubclass");

            //////////////////// INCOME /////////////////////////////////
            var tincome = new incomeTable();
            tincome.addBaseColumns("idinc", "nphase", "ymov", "nmov", "parentidinc", "idreg", "idman", "doc", "docdate", "description", "idpayment", "expiration", "adate", "cu", "ct", "lu", "lt", "autokind", "autocode", "cupcode", "idunderwriting");
            Tables.Add(tincome);
            tincome.defineKey("idinc");

            //////////////////// INCOMEYEAR /////////////////////////////////
            var tincomeyear = new incomeyearTable();
            tincomeyear.addBaseColumns("idinc", "ayear", "idfin", "idupb", "amount", "cu", "ct", "lu", "lt");
            Tables.Add(tincomeyear);
            tincomeyear.defineKey("idinc", "ayear");

            //////////////////// UPB /////////////////////////////////
            var tupb = new upbTable();
            tupb.addBaseColumns("idupb", "codeupb", "title", "paridupb", "idunderwriter", "idman", "requested", "granted", "previousappropriation", "expiration", "txt", "rtf", "cu", "ct", "lu", "lt", "assured", "printingorder", "active", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "idtreasurer");
            Tables.Add(tupb);
            tupb.defineKey("idupb");

            //////////////////// FIN /////////////////////////////////
            var tfin = new finTable();
            tfin.addBaseColumns("idfin", "ayear", "flag", "codefin", "paridfin", "nlevel", "printingorder", "title", "cu", "ct", "lu", "lt");
            Tables.Add(tfin);
            tfin.defineKey("idfin");

            //////////////////// REGISTRY1 /////////////////////////////////
            var tregistry1 = new registryTable();
            tregistry1.TableName = "registry1";
            tregistry1.addBaseColumns("idreg", "title", "cf", "p_iva", "residence", "annotation", "birthdate", "gender", "surname", "forename", "foreigncf", "active", "txt", "rtf", "cu", "ct", "lu", "lt", "badgecode", "idcategory", "idcentralizedcategory", "idmaritalstatus", "idtitle", "idregistryclass", "maritalsurname", "idcity", "idnation", "location", "extmatricula");
            tregistry1.ExtendedProperties["TableForReading"] = "registry";
            Tables.Add(tregistry1);
            tregistry1.defineKey("idreg");

            //////////////////// INCOMEESTIMATE /////////////////////////////////
            var tincomeestimate = new MetaTable("incomeestimate");
            tincomeestimate.defineColumn("idestimkind", typeof(string), false);
            tincomeestimate.defineColumn("yestim", typeof(short), false);
            tincomeestimate.defineColumn("nestim", typeof(int), false);
            tincomeestimate.defineColumn("idinc", typeof(int), false);
            tincomeestimate.defineColumn("movkind", typeof(short));
            tincomeestimate.defineColumn("cu", typeof(string), false);
            tincomeestimate.defineColumn("ct", typeof(DateTime), false);
            tincomeestimate.defineColumn("lu", typeof(string), false);
            tincomeestimate.defineColumn("lt", typeof(DateTime), false);
            Tables.Add(tincomeestimate);
            tincomeestimate.defineKey("idestimkind", "yestim", "nestim", "idinc");

            //////////////////// FINMOTIVE /////////////////////////////////
            var tfinmotive = new MetaTable("finmotive");
            tfinmotive.defineColumn("idfinmotive", typeof(string), false);
            tfinmotive.defineColumn("active", typeof(string), false);
            tfinmotive.defineColumn("codemotive", typeof(string), false);
            tfinmotive.defineColumn("paridfinmotive", typeof(string));
            tfinmotive.defineColumn("title", typeof(string), false);
            tfinmotive.defineColumn("lt", typeof(DateTime));
            tfinmotive.defineColumn("lu", typeof(string));
            tfinmotive.defineColumn("ct", typeof(DateTime));
            tfinmotive.defineColumn("cu", typeof(string));
            Tables.Add(tfinmotive);
            tfinmotive.defineKey("idfinmotive");

            //////////////////// FINMOTIVEDETAIL /////////////////////////////////
            var tfinmotivedetail = new MetaTable("finmotivedetail");
            tfinmotivedetail.defineColumn("idfinmotive", typeof(string), false);
            tfinmotivedetail.defineColumn("idfin", typeof(int), false);
            tfinmotivedetail.defineColumn("ayear", typeof(short), false);
            tfinmotivedetail.defineColumn("lu", typeof(string));
            tfinmotivedetail.defineColumn("cu", typeof(string));
            tfinmotivedetail.defineColumn("ct", typeof(DateTime));
            tfinmotivedetail.defineColumn("lt", typeof(DateTime));
            Tables.Add(tfinmotivedetail);
            tfinmotivedetail.defineKey("idfinmotive", "idfin", "ayear");

            //////////////////// INCOMEVAR /////////////////////////////////
            var tincomevar = new incomevarTable();
            tincomevar.addBaseColumns("idinc", "nvar", "yvar", "description", "amount", "doc", "docdate", "adate", "txt", "rtf", "cu", "ct", "lu", "lt", "autokind", "idinvkind", "ninv", "yinv");
            Tables.Add(tincomevar);
            tincomevar.defineKey("idinc", "nvar");

            //////////////////// FLUSSOCREDITI /////////////////////////////////
            var tflussocrediti = new flussocreditiTable();
            tflussocrediti.addBaseColumns("idflusso", "cu", "ct", "lu", "lt", "datacreazioneflusso", "flusso", "istransmitted", "docdate", "idestimkind", "idsor03", "idsor02", "idsor01", "idsor04", "idsor05", "progday", "filename");
            Tables.Add(tflussocrediti);
            tflussocrediti.defineKey("idflusso");

            //////////////////// FLUSSOCREDITIDETAIL /////////////////////////////////
            var tflussocreditidetail = new flussocreditidetailTable();
            tflussocreditidetail.addBaseColumns("idflusso", "iddetail", "cu", "ct", "lu", "lt", "importoversamento", "idestimkind", "yestim", "nestim", "rownum", "idupb", "idfinmotive", "iduniqueformcode", "idaccmotiverevenue", "idaccmotivecredit", "idaccmotiveundotax", "idaccmotiveundotaxpost", "idreg", "nform", "stop", "competencystart", "competencystop", "description", "idinvkind", "yinv", "ninv", "invrownum", "cf", "annulment", "flag", "idunivoco", "idsor1", "idsor2", "idsor3", "idivakind", "tax", "number", "idlist", "p_iva", "annotations", "idupb_iva", "iuv");
            Tables.Add(tflussocreditidetail);
            tflussocreditidetail.defineKey("idflusso", "iddetail");

            //////////////////// INVOICE /////////////////////////////////
            var tinvoice = new invoiceTable();
            tinvoice.addBaseColumns("ninv", "yinv", "active", "adate", "ct", "cu", "description", "doc", "docdate", "exchangerate", "flagdeferred", "idreg", "lt", "lu", "officiallyprinted", "packinglistdate", "packinglistnum", "paymentexpiring", "registryreference", "rtf", "txt", "idinvkind", "idcurrency", "idexpirationkind", "idtreasurer", "flagintracom", "iso_origin", "iso_provenance", "iso_destination", "idcountry_origin", "idcountry_destination", "idintrastatkind", "idaccmotivedebit", "idaccmotivedebit_crg", "idaccmotivedebit_datacrg", "idintrastatpaymethod", "iso_payment", "flag_ddt", "flag", "idblacklist", "idinvkind_real", "yinv_real", "ninv_real", "autoinvoice", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "protocoldate", "idfepaymethodcondition", "idfepaymethod", "nelectronicinvoice", "yelectronicinvoice", "annotations", "arrivalprotocolnum", "toincludeinpaymentindicator", "resendingpcc", "touniqueregister", "idstampkind", "flag_auto_split_payment", "flag_enable_split_payment", "idsdi_acquisto", "idsdi_vendita", "flag_reverse_charge", "ipa_acq", "rifamm_acq", "ipa_ven_emittente", "rifamm_ven_emittente", "ipa_ven_cliente", "rifamm_ven_cliente", "ssntipospesa", "ssnflagtipospesa", "idinvkind_forwarder", "yinv_forwarder", "ninv_forwarder", "flagbit", "ssn_nprot", "requested_doc", "email_ven_cliente", "pec_ven_cliente");
            tinvoice.defineColumn("!registry", typeof(string));
            Tables.Add(tinvoice);
            tinvoice.defineKey("ninv", "yinv", "idinvkind");

            //////////////////// INVOICEDETAIL /////////////////////////////////
            var tinvoicedetail = new invoicedetailTable();
            tinvoicedetail.addBaseColumns("ninv", "rownum", "yinv", "annotations", "competencystart", "paymentcompetency", "competencystop", "ct", "cu", "detaildescription", "discount", "idaccmotive", "idmankind", "idupb", "lt", "lu", "manrownum", "nman", "number", "tax", "taxable", "unabatable", "yman", "idestimkind", "estimrownum", "nestim", "yestim", "idgroup", "idexp_taxable", "idexp_iva", "idinc_taxable", "idinc_iva", "ninv_main", "yinv_main", "idivakind", "idinvkind", "idsor1", "idsor2", "idsor3", "idintrastatcode", "idintrastatmeasure", "weight", "va3type", "intrastatoperationkind", "idintrastatservice", "idintrastatsupplymethod", "idlist", "idunit", "idpackage", "unitsforpackage", "npackage", "flag", "exception12", "intra12operationkind", "move12", "idupb_iva", "idinvkind_main", "leasing", "usedmodesospesometro", "resetresidualmandate", "idfetransfer", "fereferencerule", "cupcode", "cigcode", "idpccdebitstatus", "idpccdebitmotive", "idcostpartition", "expensekind", "rounding", "idepexp", "idepacc", "flagbit", "idfinmotive", "iduniqueformcode", "ycon", "ncon", "codicevalore", "codicetipo", "idsor_siope", "idepexp_pre");
            Tables.Add(tinvoicedetail);
            tinvoicedetail.defineKey("ninv", "rownum", "yinv", "idinvkind");

            //////////////////// INCOMEINVOICE /////////////////////////////////
            var tincomeinvoice = new MetaTable("incomeinvoice");
            tincomeinvoice.defineColumn("ninv", typeof(int), false);
            tincomeinvoice.defineColumn("yinv", typeof(short), false);
            tincomeinvoice.defineColumn("ct", typeof(DateTime), false);
            tincomeinvoice.defineColumn("cu", typeof(string), false);
            tincomeinvoice.defineColumn("lt", typeof(DateTime), false);
            tincomeinvoice.defineColumn("lu", typeof(string), false);
            tincomeinvoice.defineColumn("idinc", typeof(int), false);
            tincomeinvoice.defineColumn("idinvkind", typeof(int), false);
            tincomeinvoice.defineColumn("movkind", typeof(short), false);
            Tables.Add(tincomeinvoice);
            tincomeinvoice.defineKey("ninv", "yinv", "idinc", "idinvkind");

            //////////////////// FLUSSOINCASSI /////////////////////////////////
            var tflussoincassi = new flussoincassiTable();
            tflussoincassi.addBaseColumns("idflusso", "codiceflusso", "trn", "ct", "cu", "lt", "lu", "ayear", "causale", "dataincasso", "nbill", "importo", "to_complete", "elaborato", "active", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05");
            Tables.Add(tflussoincassi);
            tflussoincassi.defineKey("idflusso");

            //////////////////// FLUSSOINCASSIDETAIL /////////////////////////////////
            var tflussoincassidetail = new flussoincassidetailTable();
            tflussoincassidetail.addBaseColumns("idflusso", "iddetail", "iduniqueformcode", "iuv", "importo", "ct", "cu", "lt", "lu", "cf", "p_iva");
            Tables.Add(tflussoincassidetail);
            tflussoincassidetail.defineKey("idflusso", "iddetail");

            //////////////////// REGISTRYREFERENCE /////////////////////////////////
            var tregistryreference = new registryreferenceTable();
            tregistryreference.addBaseColumns("idreg", "idregistryreference", "referencename", "ct", "cu", "email", "faxnumber", "flagdefault", "lt", "lu", "mobilenumber", "passwordweb", "phonenumber", "registryreferencerole", "rtf", "txt", "userweb", "skypenumber", "msnnumber", "activeweb", "iterweb", "saltweb");
            Tables.Add(tregistryreference);
            tregistryreference.defineKey("idreg", "idregistryreference");

            //////////////////// INVOICEKIND /////////////////////////////////
            var tinvoicekind = new invoicekindTable();
            tinvoicekind.addBaseColumns("ct", "cu", "description", "lt", "lu", "codeinvkind", "idinvkind", "flag", "flag_autodocnumbering", "formatstring", "active", "idinvkind_auto", "printingcode", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05", "address", "header", "notes1", "notes2", "notes3", "ipa_fe", "riferimento_amministrazione", "enable_fe");
            Tables.Add(tinvoicekind);
            tinvoicekind.defineKey("idinvkind");

            //////////////////// CURRENCY /////////////////////////////////
            var tcurrency = new MetaTable("currency");
            tcurrency.defineColumn("ct", typeof(DateTime), false);
            tcurrency.defineColumn("cu", typeof(string), false);
            tcurrency.defineColumn("description", typeof(string), false);
            tcurrency.defineColumn("lt", typeof(DateTime), false);
            tcurrency.defineColumn("lu", typeof(string), false);
            tcurrency.defineColumn("codecurrency", typeof(string));
            tcurrency.defineColumn("idcurrency", typeof(int), false);
            Tables.Add(tcurrency);
            tcurrency.defineKey("idcurrency");

            //////////////////// IVAREGISTER /////////////////////////////////
            var tivaregister = new ivaregisterTable();
            tivaregister.addBaseColumns("nivaregister", "yivaregister", "ct", "cu", "lt", "lu", "ninv", "protocolnum", "yinv", "idinvkind", "idivaregisterkind");
            Tables.Add(tivaregister);
            tivaregister.defineKey("nivaregister", "yivaregister", "idivaregisterkind");

            //////////////////// LIST /////////////////////////////////
            var tlist = new listTable();
            tlist.addBaseColumns("idlist", "description", "intcode", "intbarcode", "extcode", "extbarcode", "validitystop", "active", "idpackage", "idunit", "unitsforpackage", "has_expiry", "cu", "ct", "lu", "lt", "idlistclass", "pic", "picext", "nmin", "ntoreorder", "tounload", "timesupply", "nmaxorder", "price", "insinfo", "descrforuser");
            Tables.Add(tlist);
            tlist.defineKey("idlist");

            //////////////////// INVOICEKINDREGISTERKIND /////////////////////////////////
            var tinvoicekindregisterkind = new MetaTable("invoicekindregisterkind");
            tinvoicekindregisterkind.defineColumn("ct", typeof(DateTime), false);
            tinvoicekindregisterkind.defineColumn("cu", typeof(string), false);
            tinvoicekindregisterkind.defineColumn("lt", typeof(DateTime), false);
            tinvoicekindregisterkind.defineColumn("lu", typeof(string), false);
            tinvoicekindregisterkind.defineColumn("idinvkind", typeof(int), false);
            tinvoicekindregisterkind.defineColumn("idivaregisterkind", typeof(int), false);
            Tables.Add(tinvoicekindregisterkind);
            tinvoicekindregisterkind.defineKey("idinvkind", "idivaregisterkind");

            //////////////////// IVAREGISTERKIND /////////////////////////////////
            var tivaregisterkind = new ivaregisterkindTable();
            tivaregisterkind.addBaseColumns("ct", "cu", "description", "lt", "lu", "registerclass", "idivaregisterkindunified", "flagactivity", "codeivaregisterkind", "idivaregisterkind", "compensation", "idtreasurer");
            Tables.Add(tivaregisterkind);
            tivaregisterkind.defineKey("idivaregisterkind");

            //////////////////// REPORT /////////////////////////////////
            var treport = new MetaTable("report");
            treport.defineColumn("modulename", typeof(string), false);
            treport.defineColumn("reportname", typeof(string), false);
            treport.defineColumn("description", typeof(string), false);
            treport.defineColumn("filename", typeof(string), false);
            treport.defineColumn("groupname", typeof(string));
            treport.defineColumn("orientation", typeof(string), false);
            treport.defineColumn("papersize", typeof(string));
            treport.defineColumn("sp_doupdate", typeof(string));
            treport.defineColumn("timeout", typeof(int));
            treport.defineColumn("webvisible", typeof(string));
            treport.defineColumn("active", typeof(string));
            treport.defineColumn("flag_both", typeof(string));
            treport.defineColumn("flag_cash", typeof(string));
            treport.defineColumn("flag_comp", typeof(string));
            treport.defineColumn("flag_credit", typeof(string));
            treport.defineColumn("flag_proceeds", typeof(string));
            Tables.Add(treport);
            treport.defineKey("reportname");

            //////////////////// WEBPAYMENT /////////////////////////////////
            var twebpayment = new webpaymentTable();
            twebpayment.addBaseColumns("idwebpayment", "cf", "ct", "cu", "email", "forename", "idcustomuser", "idlcard", "idman", "lt", "lu", "nwebpayment", "surname", "ywebpayment", "idwebpaymentstatus", "idreg", "iuv", "qrcode", "idflussocrediti", "adate");
            Tables.Add(twebpayment);
            twebpayment.defineKey("idwebpayment");

            //////////////////// WEBPAYMENTSTATUS /////////////////////////////////
            var twebpaymentstatus = new MetaTable("webpaymentstatus");
            twebpaymentstatus.defineColumn("idwebpaymentstatus", typeof(short), false);
            twebpaymentstatus.defineColumn("ct", typeof(DateTime), false);
            twebpaymentstatus.defineColumn("cu", typeof(string), false);
            twebpaymentstatus.defineColumn("description", typeof(string), false);
            twebpaymentstatus.defineColumn("listingorder", typeof(int));
            twebpaymentstatus.defineColumn("lt", typeof(DateTime), false);
            twebpaymentstatus.defineColumn("lu", typeof(string), false);
            Tables.Add(twebpaymentstatus);
            twebpaymentstatus.defineKey("idwebpaymentstatus");

            //////////////////// GENERALREPORTPARAMETER /////////////////////////////////
            var tgeneralreportparameter = new MetaTable("generalreportparameter");
            tgeneralreportparameter.defineColumn("idparam", typeof(string), false);
            tgeneralreportparameter.defineColumn("paramvalue", typeof(string));
            tgeneralreportparameter.defineColumn("description", typeof(string));
            tgeneralreportparameter.defineColumn("lt", typeof(DateTime));
            tgeneralreportparameter.defineColumn("lu", typeof(string));
            tgeneralreportparameter.defineColumn("stop", typeof(DateTime));
            tgeneralreportparameter.defineColumn("start", typeof(DateTime), false);
            Tables.Add(tgeneralreportparameter);
            tgeneralreportparameter.defineKey("idparam", "start");

            //////////////////// IVAKIND /////////////////////////////////
            var tivakind = new ivakindTable();
            tivakind.addBaseColumns("ct", "cu", "description", "lt", "lu", "rate", "unabatabilitypercentage", "active", "idivataxablekind", "idivakind", "codeivakind", "flag", "annotations", "idfenature");
            Tables.Add(tivakind);
            tivakind.defineKey("idivakind");

            #endregion


            #region DataRelation creation
            this.defineRelation("income_incomeinvoice", "income", "incomeinvoice", "idinc");
            var cPar   = new [] { income.Columns["idinc"] };
            var cChild = new [] { invoicedetail.Columns["idinc_taxable"] };
            Relations.Add(new DataRelation("income_invoicedetail", cPar, cChild, false));

            cPar   = new [] { income.Columns["idinc"] };
            cChild = new [] { invoicedetail.Columns["idinc_iva"] };
            Relations.Add(new DataRelation("income_invoicedetail1", cPar, cChild, false));

            this.defineRelation("flussocrediti_flussocreditidetail", "flussocrediti", "flussocreditidetail", "idflusso");
            this.defineRelation("registry_flussocreditidetail", "registry", "flussocreditidetail", "idreg");
            this.defineRelation("finmotive_finmotivedetail", "finmotive", "finmotivedetail", "idfinmotive");
            this.defineRelation("income_incomeestimate", "income", "incomeestimate", "idinc");
            this.defineRelation("estimate_incomeestimate", "estimate", "incomeestimate", "idestimkind", "yestim", "nestim");
            cPar   = new [] { income.Columns["idinc"] };
            cChild = new [] { income.Columns["parentidinc"] };
            Relations.Add(new DataRelation("incomeincome", cPar, cChild, false));

            this.defineRelation("FK_estimate_estimatekind", "estimatekind", "estimate", "idestimkind");
            this.defineRelation("FK_estimatedetail_estimatekind", "estimatekind", "estimatedetail", "idestimkind");
            this.defineRelation("FK_estimatedetail_estimate", "estimate", "estimatedetail", "idestimkind", "yestim", "nestim");
            this.defineRelation("registry_registryreference", "registry", "registryreference", "idreg");
            this.defineRelation("invoicekind_invoicedetail", "invoicekind", "invoicedetail", "idinvkind");
            this.defineRelation("currency_invoice", "currency", "invoice", "idcurrency");
            this.defineRelation("list_flussocreditidetail", "list", "flussocreditidetail", "idlist");
            this.defineRelation("ivaregisterkindivaregister", "ivaregisterkind", "ivaregister", "idivaregisterkind");
            cPar   = new [] { flussocrediti.Columns["idflusso"] };
            cChild = new [] { webpayment.Columns["idflussocrediti"] };
            Relations.Add(new DataRelation("flussocrediti_webpayment", cPar, cChild, false));

            this.defineRelation("webpaymentstatus_webpayment", "webpaymentstatus", "webpayment", "idwebpaymentstatus");
            this.defineRelation("invoice_incomeinvoice", "invoice", "incomeinvoice", "ninv", "yinv", "idinvkind");
            cPar   = new [] { invoicedetail.Columns["idinvkind"], invoicedetail.Columns["yinv"], invoicedetail.Columns["ninv"], invoicedetail.Columns["rownum"] };
            cChild = new [] { flussocreditidetail.Columns["idinvkind"], flussocreditidetail.Columns["yinv"], flussocreditidetail.Columns["ninv"], flussocreditidetail.Columns["invrownum"] };
            Relations.Add(new DataRelation("invoicedetail_flussocreditidetail", cPar, cChild, false));

            this.defineRelation("estimatedetail_flussocreditidetail", "estimatedetail", "flussocreditidetail", "idestimkind", "yestim", "nestim", "rownum");
            this.defineRelation("income_incomelast", "income", "incomelast", "idinc");
            this.defineRelation("income_incomesorted", "income", "incomesorted", "idinc");
            this.defineRelation("income_incomeyear", "income", "incomeyear", "idinc");
            this.defineRelation("FK_flussoincassi_flussoincassidetail", "flussoincassi", "flussoincassidetail", "idflusso");
            this.defineRelation("invoice_invoicedetail", "invoice", "invoicedetail", "idinvkind", "yinv", "ninv");
            this.defineRelation("ivaregisterinvoice", "invoice", "ivaregister", "idinvkind", "yinv", "ninv");
            cPar   = new [] { income.Columns["idinc"] };
            cChild = new [] { estimatedetail.Columns["idinc_taxable"] };
            Relations.Add(new DataRelation("income_estimatedetail", cPar, cChild, false));

            cPar   = new [] { income.Columns["idinc"] };
            cChild = new [] { estimatedetail.Columns["idinc_iva"] };
            Relations.Add(new DataRelation("income_estimatedetail1", cPar, cChild, false));

            this.defineRelation("income_incomevar", "income", "incomevar", "idinc");
            #endregion
        }
Beispiel #8
0
        private void initClass()
        {
            DataSetName = "dsmeta";
            Prefix      = "";
            Namespace   = "http://tempuri.org/dsmeta.xsd";

            #region create DataTables
            //////////////////// ASSETLOAD /////////////////////////////////
            var tassetload = new assetloadTable();
            tassetload.addBaseColumns("idassetload", "idassetloadkind", "yassetload", "nassetload", "idreg", "idmot", "doc", "docdate", "description", "enactment", "enactmentdate", "adate", "printdate", "ratificationdate", "txt", "rtf", "cu", "ct", "lu", "lt", "transmitted");
            Tables.Add(tassetload);
            tassetload.defineKey("idassetload");

            //////////////////// ASSETLOADKIND /////////////////////////////////
            var tassetloadkind = new assetloadkindTable();
            tassetloadkind.addBaseColumns("idassetloadkind", "description", "idinventory", "startnumber", "cu", "ct", "lu", "lt", "flag", "active", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05");
            Tables.Add(tassetloadkind);
            tassetloadkind.defineKey("idassetloadkind");

            //////////////////// REGISTRY /////////////////////////////////
            var tregistry = new registryTable();
            tregistry.addBaseColumns("idreg", "title", "cf", "p_iva", "residence", "annotation", "birthdate", "gender", "surname", "forename", "foreigncf", "active", "cu", "ct", "lu", "lt", "badgecode", "idcategory", "idcentralizedcategory", "idmaritalstatus", "idtitle", "idregistryclass", "maritalsurname", "idcity", "idnation", "location", "extmatricula");
            Tables.Add(tregistry);
            tregistry.defineKey("idreg");

            //////////////////// ASSETLOADMOTIVE /////////////////////////////////
            var tassetloadmotive = new MetaTable("assetloadmotive");
            tassetloadmotive.defineColumn("idmot", typeof(int), false);
            tassetloadmotive.defineColumn("description", typeof(string), false);
            tassetloadmotive.defineColumn("cu", typeof(string), false);
            tassetloadmotive.defineColumn("ct", typeof(DateTime), false);
            tassetloadmotive.defineColumn("lu", typeof(string), false);
            tassetloadmotive.defineColumn("lt", typeof(DateTime), false);
            tassetloadmotive.defineColumn("idaccmotive", typeof(string));
            tassetloadmotive.defineColumn("active", typeof(string));
            Tables.Add(tassetloadmotive);
            tassetloadmotive.defineKey("idmot");

            //////////////////// EXPENSEPHASE /////////////////////////////////
            var texpensephase = new MetaTable("expensephase");
            texpensephase.defineColumn("nphase", typeof(byte), false);
            texpensephase.defineColumn("description", typeof(string), false);
            texpensephase.defineColumn("cu", typeof(string), false);
            texpensephase.defineColumn("ct", typeof(DateTime), false);
            texpensephase.defineColumn("lu", typeof(string), false);
            texpensephase.defineColumn("lt", typeof(DateTime), false);
            Tables.Add(texpensephase);
            texpensephase.defineKey("nphase");

            //////////////////// ASSETACQUIREVIEW /////////////////////////////////
            var tassetacquireview = new MetaTable("assetacquireview");
            tassetacquireview.defineColumn("nassetacquire", typeof(int), false);
            tassetacquireview.defineColumn("yman", typeof(short));
            tassetacquireview.defineColumn("nman", typeof(int));
            tassetacquireview.defineColumn("rownum", typeof(int));
            tassetacquireview.defineColumn("idreg", typeof(int));
            tassetacquireview.defineColumn("registry", typeof(string));
            tassetacquireview.defineColumn("idmot", typeof(int), false);
            tassetacquireview.defineColumn("assetloadmotive", typeof(string));
            tassetacquireview.defineColumn("idinv", typeof(int), false);
            tassetacquireview.defineColumn("codeinv", typeof(string));
            tassetacquireview.defineColumn("inventorytree", typeof(string));
            tassetacquireview.defineColumn("description", typeof(string), false);
            tassetacquireview.defineColumn("idinventory", typeof(int), false);
            tassetacquireview.defineColumn("codeinventory", typeof(string));
            tassetacquireview.defineColumn("inventory", typeof(string));
            tassetacquireview.defineColumn("idassetloadkind", typeof(int));
            tassetacquireview.defineColumn("assetloadkind", typeof(string));
            tassetacquireview.defineColumn("yassetload", typeof(short));
            tassetacquireview.defineColumn("nassetload", typeof(int));
            tassetacquireview.defineColumn("number", typeof(int), false);
            tassetacquireview.defineColumn("taxable", typeof(decimal));
            tassetacquireview.defineColumn("taxrate", typeof(double));
            tassetacquireview.defineColumn("discount", typeof(double));
            tassetacquireview.defineColumn("total", typeof(decimal));
            tassetacquireview.defineColumn("abatable", typeof(decimal));
            tassetacquireview.defineColumn("startnumber", typeof(int));
            tassetacquireview.defineColumn("adate", typeof(DateTime), false);
            tassetacquireview.defineColumn("flag", typeof(byte), false);
            tassetacquireview.defineColumn("flagload", typeof(string), false);
            tassetacquireview.defineColumn("loadkind", typeof(string), false);
            tassetacquireview.defineColumn("ispieceacquire", typeof(string), false);
            tassetacquireview.defineColumn("cu", typeof(string), false);
            tassetacquireview.defineColumn("ct", typeof(DateTime), false);
            tassetacquireview.defineColumn("lu", typeof(string), false);
            tassetacquireview.defineColumn("lt", typeof(DateTime), false);
            tassetacquireview.defineColumn("transmitted", typeof(string));
            tassetacquireview.defineColumn("cost", typeof(decimal));
            tassetacquireview.defineColumn("idupb", typeof(string));
            tassetacquireview.defineColumn("idsor1", typeof(int));
            tassetacquireview.defineColumn("idsor2", typeof(int));
            tassetacquireview.defineColumn("idsor3", typeof(int));
            tassetacquireview.defineColumn("idassetload", typeof(int));
            tassetacquireview.defineColumn("!pieceorasset", typeof(string));
            tassetacquireview.defineColumn("idmankind", typeof(string));
            tassetacquireview.defineColumn("idsor01", typeof(int));
            tassetacquireview.defineColumn("idsor02", typeof(int));
            tassetacquireview.defineColumn("idsor03", typeof(int));
            tassetacquireview.defineColumn("idsor04", typeof(int));
            tassetacquireview.defineColumn("idsor05", typeof(int));
            tassetacquireview.defineColumn("intcode", typeof(string));
            tassetacquireview.defineColumn("list", typeof(string));
            tassetacquireview.defineColumn("yinv", typeof(int));
            tassetacquireview.defineColumn("ninv", typeof(int));
            tassetacquireview.defineColumn("idinvkind", typeof(int));
            tassetacquireview.defineColumn("invrownum", typeof(int));
            tassetacquireview.defineColumn("invoicekind", typeof(string));
            tassetacquireview.defineColumn("cost_discounted", typeof(decimal));
            tassetacquireview.defineColumn("historicalvalue", typeof(decimal));
            Tables.Add(tassetacquireview);
            tassetacquireview.defineKey("nassetacquire");

            //////////////////// ASSETLOADEXPENSE /////////////////////////////////
            var tassetloadexpense = new MetaTable("assetloadexpense");
            tassetloadexpense.defineColumn("idexp", typeof(int), false);
            tassetloadexpense.defineColumn("ct", typeof(DateTime));
            tassetloadexpense.defineColumn("cu", typeof(string));
            tassetloadexpense.defineColumn("lt", typeof(DateTime));
            tassetloadexpense.defineColumn("lu", typeof(string));
            tassetloadexpense.defineColumn("!ymov", typeof(short));
            tassetloadexpense.defineColumn("!nmov", typeof(int));
            tassetloadexpense.defineColumn("!expensedescription", typeof(string));
            tassetloadexpense.defineColumn("!npay", typeof(string));
            tassetloadexpense.defineColumn("!expensedoc", typeof(string));
            tassetloadexpense.defineColumn("!amount", typeof(string));
            tassetloadexpense.defineColumn("idassetload", typeof(int), false);
            Tables.Add(tassetloadexpense);
            tassetloadexpense.defineKey("idassetload", "idexp");

            //////////////////// CONFIG /////////////////////////////////
            var tconfig = new configTable();
            tconfig.addBaseColumns("ayear", "agencycode", "appname", "appropriationphasecode", "assessmentphasecode", "asset_flagnumbering", "asset_flagrestart", "assetload_flag", "boxpartitiontitle", "cashvaliditykind", "casualcontract_flagrestart", "ct", "cu", "currpartitiontitle", "deferredexpensephase", "deferredincomephase", "electronicimport", "electronictrasmission", "expense_expiringdays", "expensephase", "flagautopayment", "flagautoproceeds", "flagcredit", "flagepexp", "flagfruitful", "flagpayment", "flagproceeds", "flagrefund", "foreignhours", "idacc_accruedcost", "idacc_accruedrevenue", "idacc_customer", "idacc_deferredcost", "idacc_deferredcredit", "idacc_deferreddebit", "idacc_deferredrevenue", "idacc_ivapayment", "idacc_ivarefund", "idacc_patrimony", "idacc_pl", "idacc_supplier", "idaccmotive_admincar", "idaccmotive_foot", "idaccmotive_owncar", "idclawback", "idfinexpense", "idfinexpensesurplus", "idfinincomesurplus", "idfinivapayment", "idfinivarefund", "idivapayperiodicity", "idregauto", "idsortingkind1", "idsortingkind2", "idsortingkind3", "importappname", "income_expiringdays", "incomephase", "linktoinvoice", "lt", "lu", "minpayment", "minrefund", "motivelen", "motiveprefix", "motiveseparator", "payment_finlevel", "payment_flag", "payment_flagautoprintdate", "paymentagency", "prevpartitiontitle", "proceeds_finlevel", "proceeds_flag", "proceeds_flagautoprintdate", "profservice_flagrestart", "refundagency", "wageaddition_flagrestart");
            Tables.Add(tconfig);
            tconfig.defineKey("ayear");

            //////////////////// ASSETAMORTIZATIONUNLOADVIEW /////////////////////////////////
            var tassetamortizationunloadview = new MetaTable("assetamortizationunloadview");
            tassetamortizationunloadview.defineColumn("namortization", typeof(int), false);
            tassetamortizationunloadview.defineColumn("idasset", typeof(int), false);
            tassetamortizationunloadview.defineColumn("idpiece", typeof(int));
            tassetamortizationunloadview.defineColumn("idinventoryamortization", typeof(int), false);
            tassetamortizationunloadview.defineColumn("codeinventoryamortization", typeof(string), false);
            tassetamortizationunloadview.defineColumn("inventoryamortization", typeof(string), false);
            tassetamortizationunloadview.defineColumn("idinventory", typeof(int), false);
            tassetamortizationunloadview.defineColumn("inventory", typeof(string), false);
            tassetamortizationunloadview.defineColumn("ninventory", typeof(int));
            tassetamortizationunloadview.defineColumn("idlocation", typeof(int));
            tassetamortizationunloadview.defineColumn("locationcode", typeof(string));
            tassetamortizationunloadview.defineColumn("location", typeof(string));
            tassetamortizationunloadview.defineColumn("idcurrlocation", typeof(int));
            tassetamortizationunloadview.defineColumn("currlocationcode", typeof(string));
            tassetamortizationunloadview.defineColumn("currlocation", typeof(string));
            tassetamortizationunloadview.defineColumn("idman", typeof(int));
            tassetamortizationunloadview.defineColumn("manager", typeof(string));
            tassetamortizationunloadview.defineColumn("idcurrman", typeof(int));
            tassetamortizationunloadview.defineColumn("currmanager", typeof(string));
            tassetamortizationunloadview.defineColumn("nassetacquire", typeof(int), false);
            tassetamortizationunloadview.defineColumn("loaddescription", typeof(string), false);
            tassetamortizationunloadview.defineColumn("description", typeof(string), false);
            tassetamortizationunloadview.defineColumn("assetvalue", typeof(decimal));
            tassetamortizationunloadview.defineColumn("amortizationquota", typeof(double));
            tassetamortizationunloadview.defineColumn("amount", typeof(decimal), true, true);
            tassetamortizationunloadview.defineColumn("adate", typeof(DateTime), false);
            tassetamortizationunloadview.defineColumn("idassetunload", typeof(int));
            tassetamortizationunloadview.defineColumn("idassetunloadkind", typeof(int));
            tassetamortizationunloadview.defineColumn("assetunloadkind", typeof(string));
            tassetamortizationunloadview.defineColumn("yassetunload", typeof(short));
            tassetamortizationunloadview.defineColumn("nassetunload", typeof(int));
            tassetamortizationunloadview.defineColumn("idassetload", typeof(int));
            tassetamortizationunloadview.defineColumn("idassetloadkind", typeof(int));
            tassetamortizationunloadview.defineColumn("assetloadkind", typeof(string));
            tassetamortizationunloadview.defineColumn("yassetload", typeof(short));
            tassetamortizationunloadview.defineColumn("nassetload", typeof(int));
            tassetamortizationunloadview.defineColumn("flag", typeof(byte), false);
            tassetamortizationunloadview.defineColumn("flagunload", typeof(string), true, true);
            tassetamortizationunloadview.defineColumn("flagload", typeof(string), true, true);
            tassetamortizationunloadview.defineColumn("transmitted", typeof(string));
            tassetamortizationunloadview.defineColumn("cu", typeof(string), false);
            tassetamortizationunloadview.defineColumn("ct", typeof(DateTime), false);
            tassetamortizationunloadview.defineColumn("lu", typeof(string), false);
            tassetamortizationunloadview.defineColumn("lt", typeof(DateTime), false);
            Tables.Add(tassetamortizationunloadview);
            tassetamortizationunloadview.defineKey("namortization");

            //////////////////// HISTORYPAYMENTVIEW /////////////////////////////////
            var thistorypaymentview = new MetaTable("historypaymentview");
            thistorypaymentview.defineColumn("idexp", typeof(int), false);
            thistorypaymentview.defineColumn("ymov", typeof(short), false);
            thistorypaymentview.defineColumn("nmov", typeof(int), false);
            thistorypaymentview.defineColumn("adate", typeof(DateTime), false);
            thistorypaymentview.defineColumn("idreg", typeof(int));
            thistorypaymentview.defineColumn("idman", typeof(int));
            thistorypaymentview.defineColumn("doc", typeof(string));
            thistorypaymentview.defineColumn("docdate", typeof(DateTime));
            thistorypaymentview.defineColumn("description", typeof(string), false);
            thistorypaymentview.defineColumn("competencydate", typeof(DateTime));
            thistorypaymentview.defineColumn("amount", typeof(decimal));
            thistorypaymentview.defineColumn("curramount", typeof(decimal));
            thistorypaymentview.defineColumn("totflag", typeof(byte));
            thistorypaymentview.defineColumn("flagarrear", typeof(string));
            thistorypaymentview.defineColumn("kpay", typeof(int), false);
            thistorypaymentview.defineColumn("ypay", typeof(short), false);
            thistorypaymentview.defineColumn("npay", typeof(int), false);
            thistorypaymentview.defineColumn("idfin", typeof(int));
            thistorypaymentview.defineColumn("idupb", typeof(string));
            thistorypaymentview.defineColumn("idtreasurer", typeof(int));
            thistorypaymentview.defineColumn("codetreasurer", typeof(string), false);
            Tables.Add(thistorypaymentview);
            thistorypaymentview.defineKey("idexp");

            #endregion


            #region DataRelation creation
            this.defineRelation("assetload_assetamortizationunloadview", "assetload", "assetamortizationunloadview", "idassetload");
            this.defineRelation("assetloadassetloadexpense", "assetload", "assetloadexpense", "idassetload");
            this.defineRelation("historypaymentview_assetloadexpense", "historypaymentview", "assetloadexpense", "idexp");
            this.defineRelation("assetloadassetacquireview", "assetload", "assetacquireview", "idassetload");
            this.defineRelation("assetloadmotiveassetload", "assetloadmotive", "assetload", "idmot");
            this.defineRelation("assetloadkindassetload", "assetloadkind", "assetload", "idassetloadkind");
            this.defineRelation("registryassetload", "registry", "assetload", "idreg");
            #endregion
        }