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 }
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 }
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 }
private void initClass() { DataSetName = "dsmeta"; Prefix = ""; Namespace = "http://tempuri.org/dsmeta.xsd"; EnforceConstraints = false; #region create DataTables //////////////////// EXPENSEPHASE ///////////////////////////////// var texpensephase = new MetaTable("expensephase"); 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); texpensephase.defineColumn("nphase", typeof(byte), false); Tables.Add(texpensephase); texpensephase.defineKey("nphase"); //////////////////// EXPENSEVIEW ///////////////////////////////// var texpenseview = new MetaTable("expenseview"); texpenseview.defineColumn("idexp", typeof(int), false); texpenseview.defineColumn("nphase", typeof(byte), false); 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("formerymov", typeof(short)); texpenseview.defineColumn("formernmov", 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("idsor01", typeof(int)); texpenseview.defineColumn("idsor02", typeof(int)); texpenseview.defineColumn("idsor03", typeof(int)); texpenseview.defineColumn("idsor04", typeof(int)); texpenseview.defineColumn("idsor05", typeof(int)); texpenseview.defineColumn("idreg", typeof(int)); texpenseview.defineColumn("registry", typeof(string)); texpenseview.defineColumn("cf", typeof(string)); texpenseview.defineColumn("p_iva", typeof(string)); texpenseview.defineColumn("idman", typeof(int)); texpenseview.defineColumn("manager", typeof(string)); texpenseview.defineColumn("kpay", typeof(int)); texpenseview.defineColumn("ypay", typeof(short)); 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("codeser", 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("clawbackref", typeof(string)); texpenseview.defineColumn("nbill", typeof(int)); texpenseview.defineColumn("idpay", typeof(int)); texpenseview.defineColumn("npaymenttransmission", typeof(int)); texpenseview.defineColumn("transmissiondate", typeof(DateTime)); texpenseview.defineColumn("idaccdebit", typeof(string)); texpenseview.defineColumn("codeaccdebit", typeof(string)); texpenseview.defineColumn("cigcode", typeof(string)); texpenseview.defineColumn("cupcode", typeof(string)); 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); Tables.Add(texpenseview); //////////////////// CSA_CONTRACTKIND ///////////////////////////////// var tcsa_contractkind = new MetaTable("csa_contractkind"); tcsa_contractkind.defineColumn("idcsa_contractkind", typeof(int), false); tcsa_contractkind.defineColumn("contractkindcode", typeof(string), false); tcsa_contractkind.defineColumn("ct", typeof(DateTime), false); tcsa_contractkind.defineColumn("cu", typeof(string), false); tcsa_contractkind.defineColumn("description", typeof(string), false); tcsa_contractkind.defineColumn("flagcr", typeof(string), false); tcsa_contractkind.defineColumn("flagkeepalive", typeof(string)); tcsa_contractkind.defineColumn("lt", typeof(DateTime), false); tcsa_contractkind.defineColumn("lu", typeof(string), false); tcsa_contractkind.defineColumn("active", typeof(string)); tcsa_contractkind.defineColumn("idunderwriting", typeof(int)); Tables.Add(tcsa_contractkind); tcsa_contractkind.defineKey("idcsa_contractkind"); //////////////////// CSA_CONTRACTKINDYEAR ///////////////////////////////// var tcsa_contractkindyear = new MetaTable("csa_contractkindyear"); tcsa_contractkindyear.defineColumn("idcsa_contractkind", typeof(int), false); tcsa_contractkindyear.defineColumn("ayear", typeof(short), false); tcsa_contractkindyear.defineColumn("idupb", typeof(string)); tcsa_contractkindyear.defineColumn("idacc_main", typeof(string)); tcsa_contractkindyear.defineColumn("idfin_main", typeof(int)); tcsa_contractkindyear.defineColumn("ct", typeof(DateTime), false); tcsa_contractkindyear.defineColumn("cu", typeof(string), false); tcsa_contractkindyear.defineColumn("lt", typeof(DateTime), false); tcsa_contractkindyear.defineColumn("lu", typeof(string), false); tcsa_contractkindyear.defineColumn("idsor_siope_main", typeof(int)); Tables.Add(tcsa_contractkindyear); tcsa_contractkindyear.defineKey("idcsa_contractkind", "ayear"); //////////////////// CSA_CONTRACT_PARTITION ///////////////////////////////// var tcsa_contract_partition = new MetaTable("csa_contract_partition"); tcsa_contract_partition.defineColumn("idcsa_contract", typeof(int), false); tcsa_contract_partition.defineColumn("ayear", typeof(short), false); tcsa_contract_partition.defineColumn("ndetail", typeof(int), false); tcsa_contract_partition.defineColumn("quota", typeof(double)); tcsa_contract_partition.defineColumn("ct", typeof(DateTime), false); tcsa_contract_partition.defineColumn("lt", typeof(DateTime), false); tcsa_contract_partition.defineColumn("cu", typeof(string), false); tcsa_contract_partition.defineColumn("lu", typeof(string), false); tcsa_contract_partition.defineColumn("idepexp", typeof(int)); tcsa_contract_partition.defineColumn("idupb", typeof(string)); tcsa_contract_partition.defineColumn("idacc", typeof(string)); tcsa_contract_partition.defineColumn("idfin", typeof(int)); tcsa_contract_partition.defineColumn("idexp", typeof(int)); tcsa_contract_partition.defineColumn("idsor_siope", typeof(int)); Tables.Add(tcsa_contract_partition); tcsa_contract_partition.defineKey("idcsa_contract", "ayear", "ndetail"); //////////////////// EPEXPVIEW ///////////////////////////////// var tepexpview = new MetaTable("epexpview"); tepexpview.defineColumn("idepexp", typeof(int), false); tepexpview.defineColumn("yepexp", typeof(short), false); tepexpview.defineColumn("nepexp", typeof(int), false); tepexpview.defineColumn("nphase", typeof(short), false); tepexpview.defineColumn("phase", typeof(string), true, true); tepexpview.defineColumn("flagvariation", typeof(string)); tepexpview.defineColumn("description", typeof(string), false); tepexpview.defineColumn("amount", typeof(decimal), false); tepexpview.defineColumn("amount2", typeof(decimal)); tepexpview.defineColumn("amount3", typeof(decimal)); tepexpview.defineColumn("amount4", typeof(decimal)); tepexpview.defineColumn("amount5", typeof(decimal)); tepexpview.defineColumn("amountwithsign", typeof(decimal), true, true); tepexpview.defineColumn("amountwithsign2", typeof(decimal), true, true); tepexpview.defineColumn("amountwithsign3", typeof(decimal), true, true); tepexpview.defineColumn("amountwithsign4", typeof(decimal), true, true); tepexpview.defineColumn("amountwithsign5", typeof(decimal), true, true); tepexpview.defineColumn("totamount", typeof(decimal), true, true); tepexpview.defineColumn("curramount", typeof(decimal)); tepexpview.defineColumn("curramount2", typeof(decimal)); tepexpview.defineColumn("curramount3", typeof(decimal)); tepexpview.defineColumn("curramount4", typeof(decimal)); tepexpview.defineColumn("curramount5", typeof(decimal)); tepexpview.defineColumn("totcurramount", typeof(decimal), true, true); tepexpview.defineColumn("available", typeof(decimal), true, true); tepexpview.defineColumn("available2", typeof(decimal), true, true); tepexpview.defineColumn("available3", typeof(decimal), true, true); tepexpview.defineColumn("available4", typeof(decimal), true, true); tepexpview.defineColumn("available5", typeof(decimal), true, true); tepexpview.defineColumn("totavailable", typeof(decimal), true, true); tepexpview.defineColumn("totalcost", typeof(decimal), true, true); tepexpview.defineColumn("costavailable", typeof(decimal), true, true); tepexpview.defineColumn("totaldebit", typeof(decimal), true, true); tepexpview.defineColumn("ayear", typeof(short), false); tepexpview.defineColumn("idacc", typeof(string), false); tepexpview.defineColumn("codeacc", typeof(string), false); tepexpview.defineColumn("account", typeof(string), false); tepexpview.defineColumn("idupb", typeof(string), false); tepexpview.defineColumn("codeupb", typeof(string), false); tepexpview.defineColumn("upb", typeof(string), false); tepexpview.defineColumn("paridepexp", typeof(int)); tepexpview.defineColumn("parentyepexp", typeof(short)); tepexpview.defineColumn("parentnepexp", typeof(int)); tepexpview.defineColumn("yliv1", typeof(short), true, true); tepexpview.defineColumn("nliv1", typeof(int), true, true); tepexpview.defineColumn("start", typeof(DateTime)); tepexpview.defineColumn("stop", typeof(DateTime)); tepexpview.defineColumn("adate", typeof(DateTime), false); tepexpview.defineColumn("idreg", typeof(int)); tepexpview.defineColumn("registry", typeof(string)); tepexpview.defineColumn("doc", typeof(string)); tepexpview.defineColumn("docdate", typeof(DateTime)); tepexpview.defineColumn("idman", typeof(int)); tepexpview.defineColumn("manager", typeof(string)); tepexpview.defineColumn("idrelated", typeof(string)); tepexpview.defineColumn("flagaccountusage", typeof(int)); tepexpview.defineColumn("rateiattivi", typeof(string), true, true); tepexpview.defineColumn("rateipassivi", typeof(string), true, true); tepexpview.defineColumn("riscontiattivi", typeof(string), true, true); tepexpview.defineColumn("riscontipassivi", typeof(string), true, true); tepexpview.defineColumn("debit", typeof(string), true, true); tepexpview.defineColumn("credit", typeof(string), true, true); tepexpview.defineColumn("cost", typeof(string), true, true); tepexpview.defineColumn("revenue", typeof(string), true, true); tepexpview.defineColumn("fixedassets", typeof(string), true, true); tepexpview.defineColumn("freeusesurplus", typeof(string), true, true); tepexpview.defineColumn("captiveusesurplus", typeof(string), true, true); tepexpview.defineColumn("reserve", typeof(string), true, true); tepexpview.defineColumn("provision", typeof(string), true, true); tepexpview.defineColumn("idaccmotive", typeof(string)); tepexpview.defineColumn("codemotive", typeof(string)); tepexpview.defineColumn("lt", typeof(DateTime), false); tepexpview.defineColumn("lu", typeof(string), false); tepexpview.defineColumn("ct", typeof(DateTime), false); tepexpview.defineColumn("cu", typeof(string), false); tepexpview.defineColumn("idsor01", typeof(int)); tepexpview.defineColumn("idsor02", typeof(int)); tepexpview.defineColumn("idsor03", typeof(int)); tepexpview.defineColumn("idsor04", typeof(int)); tepexpview.defineColumn("idsor05", typeof(int)); Tables.Add(tepexpview); //////////////////// 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"); //////////////////// 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"); Tables.Add(tupb); tupb.defineKey("idupb"); //////////////////// FIN ///////////////////////////////// var tfin = new finTable(); tfin.addBaseColumns("ayear", "codefin", "ct", "cu", "lt", "lu", "printingorder", "rtf", "title", "txt", "idfin", "paridfin", "nlevel", "flag"); Tables.Add(tfin); tfin.defineKey("idfin"); //////////////////// FASE_EPEXP ///////////////////////////////// var tfase_epexp = new MetaTable("fase_epexp"); tfase_epexp.defineColumn("nphase", typeof(int), false); tfase_epexp.defineColumn("descrizione", typeof(string)); Tables.Add(tfase_epexp); tfase_epexp.defineKey("nphase"); //////////////////// SORTING ///////////////////////////////// var tsorting = new sortingTable(); tsorting.addBaseColumns("ct", "cu", "defaultN1", "defaultN2", "defaultN3", "defaultN4", "defaultN5", "defaultS1", "defaultS2", "defaultS3", "defaultS4", "defaultS5", "defaultv1", "defaultv2", "defaultv3", "defaultv4", "defaultv5", "description", "flagnodate", "lt", "lu", "movkind", "printingorder", "rtf", "sortcode", "txt", "idsorkind", "idsor", "paridsor", "nlevel", "start", "stop", "email", "idsor01", "idsor02", "idsor03", "idsor04", "idsor05"); Tables.Add(tsorting); tsorting.defineKey("idsor"); #endregion #region DataRelation creation this.defineRelation("FK_csa_contractkindyear_csa_contractkind", "csa_contractkind", "csa_contractkindyear", "idcsa_contractkind"); this.defineRelation("epexpview_csa_contract_partition", "epexpview", "csa_contract_partition", "idepexp", "ayear"); this.defineRelation("expenseview_csa_contract_partition", "expenseview", "csa_contract_partition", "idexp", "ayear"); this.defineRelation("account_csa_contract_partition", "account", "csa_contract_partition", "idacc"); this.defineRelation("upb_csa_contract_partition", "upb", "csa_contract_partition", "idupb"); var cPar = new [] { sorting.Columns["idsor"] }; var cChild = new [] { csa_contract_partition.Columns["idsor_siope"] }; Relations.Add(new DataRelation("sorting_csa_contract_partition", cPar, cChild, false)); this.defineRelation("fin_csa_contract_partition", "fin", "csa_contract_partition", "idfin"); #endregion }
private void initClass() { DataSetName = "dsmeta"; Prefix = ""; Namespace = "http://tempuri.org/dsmeta.xsd"; #region create DataTables //////////////////// CLAWBACKSETUP ///////////////////////////////// var tclawbacksetup = new MetaTable("clawbacksetup"); tclawbacksetup.defineColumn("idclawback", typeof(int), false); tclawbacksetup.defineColumn("ayear", typeof(short), false); tclawbacksetup.defineColumn("clawbackfinance", typeof(int)); tclawbacksetup.defineColumn("txt", typeof(string)); tclawbacksetup.defineColumn("rtf", typeof(Byte[])); tclawbacksetup.defineColumn("cu", typeof(string), false); tclawbacksetup.defineColumn("ct", typeof(DateTime), false); tclawbacksetup.defineColumn("lu", typeof(string), false); tclawbacksetup.defineColumn("lt", typeof(DateTime), false); tclawbacksetup.defineColumn("idaccmotive", typeof(string)); tclawbacksetup.defineColumn("idfin_s", typeof(int)); Tables.Add(tclawbacksetup); tclawbacksetup.defineKey("idclawback", "ayear"); //////////////////// FIN_E ///////////////////////////////// var tfin_e = new finTable(); tfin_e.TableName = "fin_e"; tfin_e.addBaseColumns("idfin", "ayear", "codefin", "paridfin", "nlevel", "printingorder", "title", "txt", "rtf", "cu", "ct", "lu", "lt"); tfin_e.ExtendedProperties["TableForReading"] = "fin"; Tables.Add(tfin_e); tfin_e.defineKey("idfin"); //////////////////// CLAWBACKSETUPVIEW ///////////////////////////////// var tclawbacksetupview = new MetaTable("clawbacksetupview"); tclawbacksetupview.defineColumn("idclawback", typeof(int), false); tclawbacksetupview.defineColumn("clawback", typeof(string), false); tclawbacksetupview.defineColumn("ayear", typeof(short), false); tclawbacksetupview.defineColumn("clawbackfinance", typeof(int)); tclawbacksetupview.defineColumn("codefin", typeof(string)); tclawbacksetupview.defineColumn("finance", typeof(string)); tclawbacksetupview.defineColumn("cu", typeof(string), false); tclawbacksetupview.defineColumn("ct", typeof(DateTime), false); tclawbacksetupview.defineColumn("lu", typeof(string), false); tclawbacksetupview.defineColumn("lt", typeof(DateTime), false); tclawbacksetupview.defineColumn("idaccmotive", typeof(string)); tclawbacksetupview.defineColumn("codemotive", typeof(string)); tclawbacksetupview.defineColumn("accmotive", typeof(string)); tclawbacksetupview.defineColumn("idfin_s", typeof(int)); tclawbacksetupview.defineColumn("codefin_s", typeof(string)); tclawbacksetupview.defineColumn("finance_s", typeof(string)); Tables.Add(tclawbacksetupview); tclawbacksetupview.defineKey("idclawback", "ayear"); //////////////////// 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("active", typeof(string)); tclawback.defineColumn("flagf24ep", typeof(string)); Tables.Add(tclawback); tclawback.defineKey("idclawback"); //////////////////// ACCMOTIVEAPPLIED ///////////////////////////////// var taccmotiveapplied = new accmotiveappliedTable(); taccmotiveapplied.addBaseColumns("idaccmotive", "paridaccmotive", "codemotive", "motive", "cu", "ct", "lu", "lt", "active", "idepoperation", "epoperation"); Tables.Add(taccmotiveapplied); taccmotiveapplied.defineKey("idaccmotive"); //////////////////// FIN_S ///////////////////////////////// var tfin_s = new finTable(); tfin_s.TableName = "fin_s"; tfin_s.addBaseColumns("idfin", "ayear", "codefin", "paridfin", "nlevel", "printingorder", "title", "txt", "rtf", "cu", "ct", "lu", "lt"); tfin_s.ExtendedProperties["TableForReading"] = "fin"; Tables.Add(tfin_s); tfin_s.defineKey("idfin"); #endregion #region DataRelation creation this.defineRelation("accmotiveappliedclawbacksetup", "accmotiveapplied", "clawbacksetup", "idaccmotive"); var cPar = new [] { fin_e.Columns["idfin"] }; var cChild = new [] { clawbacksetup.Columns["clawbackfinance"] }; Relations.Add(new DataRelation("finclawbacksetup", cPar, cChild, false)); this.defineRelation("clawbackclawbacksetup", "clawback", "clawbacksetup", "idclawback"); cPar = new [] { fin_s.Columns["idfin"] }; cChild = new [] { clawbacksetup.Columns["idfin_s"] }; Relations.Add(new DataRelation("fin_S_clawbacksetup", cPar, cChild, false)); #endregion }