Standart objenin aynısını kullanarak bu objeye yeni bir alan ekleme: Örneğin …/ycnproject/hybris/bin/custom/ycn/ycncore/resources/ycncore-items.xml dosyası için [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <itemtypes> <!– Category extending with new fields–> <itemtype code="Category" autocreate="false" generate="false"> <attributes> <attribute qualifier="assemblyCategory" type="java.lang.Boolean"> <description>Assembly Category</description> <defaultvalue>java.lang.Boolean.FALSE</defaultvalue> <modifiers optional="true"/> <persistence type="property"/> </attribute> </attributes> </itemtype> </itemtypes> </items> [/code] Bu adım sonrası CategoryModel’in içine yeni alan eklenmiş olur. Standart objenin aynısını farklı bir adlandırma ile kullanma: Örneğin …/ycnproject/hybris/bin/custom/ycn/ycncore/resources/ycncore-items.xml dosyası için [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <itemtypes> <!– Ycn Assembly Category type –> <itemtype code="YcnAssemblyCategory" extends="Category" autocreate="true" generate="true"></itemtype> </itemtypes> </items> [/code] Bu adım sonrası YcnAssemblyCategoryModel sınıfı elde edilmiş olur. Yeni bir obje tanımlama ve bileşik indeks tanımlama: Örneğin …/ycnproject/hybris/bin/custom/ycn/ycncore/resources/ycncore-items.xml dosyası için [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <itemtypes> <!– Product, ExplodedPict Assembly and Spare Part relations type –> <itemtype code="YcnExplodedPicture" extends="GenericItem" autocreate="true" generate="true"> <description>Exploded Picture, Assembly and Spare Part coordinates</description> <deployment table="YcnExplodedPicture" typecode="11199"/> <attributes> <attribute qualifier="productYcnCode" type="java.lang.String"> <description>Ycn Code of Product. Sample data: "000000000000110099"</description> <modifiers search="true" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(30)</value> </columntype> <columntype database="mysql"> <value>varchar(30)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(30)</value> </columntype> <columntype database="hsql"> <value>nvarchar(30)</value> </columntype> </persistence> </attribute> <attribute qualifier="productCode" type="java.lang.String"> <description>Code of Product. Sample data: "68649043B99"</description> <modifiers search="true" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(30)</value> </columntype> <columntype database="mysql"> <value>varchar(30)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(30)</value> </columntype> <columntype database="hsql"> <value>nvarchar(30)</value> </columntype> </persistence> </attribute> <attribute qualifier="assemblyRowNo" type="java.lang.Short"> <description>Row No of Assembly. Sample data: 1,2,3,4,5…32767</description> <modifiers search="false" optional="true" initial="false" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> <attribute qualifier="assemblyCode" type="java.lang.String"> <description>Code of Assembly Group. Sample data: "110099_1"</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(34)</value> </columntype> <columntype database="mysql"> <value>varchar(34)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(34)</value> </columntype> <columntype database="hsql"> <value>nvarchar(34)</value> </columntype> </persistence> </attribute> <attribute qualifier="assemblyDescription" type="java.lang.String"> <description>Description of Assembly. Sample data: "Kumanda Tertibat"</description> <modifiers search="true" optional="true" initial="false" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(150)</value> </columntype> <columntype database="mysql"> <value>varchar(150)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(150)</value> </columntype> <columntype database="hsql"> <value>nvarchar(150)</value> </columntype> </persistence> </attribute> <attribute qualifier="assemblyPictureFileName" type="java.lang.String"> <description>File Name of Assembly Picture. Sample data: "110099_1.jpg"</description> <modifiers search="true" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(41)</value> </columntype> <columntype database="mysql"> <value>varchar(41)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(41)</value> </columntype> <columntype database="hsql"> <value>nvarchar(41)</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartRowNo" type="java.lang.Short"> <description>Row No of Spare Part. Sample data: 1,2,3,4,5…32767</description> <modifiers search="false" optional="true" initial="false" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartYcnCode" type="java.lang.String"> <description>Ycn Code of Spare Part. Sample data: "000000000000150099"</description> <modifiers search="true" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(30)</value> </columntype> <columntype database="mysql"> <value>varchar(30)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(30)</value> </columntype> <columntype database="hsql"> <value>nvarchar(30)</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartCode" type="java.lang.String"> <description>Code of Spare Part. Sample data: "YF1231799"</description> <modifiers search="true" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(30)</value> </columntype> <columntype database="mysql"> <value>varchar(30)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(30)</value> </columntype> <columntype database="hsql"> <value>nvarchar(30)</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartAssemblyPictPosnCode" type="java.lang.String"> <description>Spare Part’s Position Code in the Picture of Assembly. Sample data: "4A","(2)","99"</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(5)</value> </columntype> <columntype database="mysql"> <value>varchar(5)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(5)</value> </columntype> <columntype database="hsql"> <value>nvarchar(5)</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartRectCoordX" type="java.lang.Short"> <description>Spare Part’s X coordinate value in the Picture of Assembly. Sample data: 377,1400…32767</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartRectCoordY" type="java.lang.Short"> <description>Spare Part’s Y coordinate value in the Picture of Assembly. Sample data: 50,98…32767</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartRectBrdrThickness" type="byte"> <description>Spare Part’s Rectangle Border Thickness Value in the Picture of Assembly. Sample data: 2,98…128</description> <modifiers search="false" optional="true" initial="false" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartRectBrdrWidth" type="java.lang.Short"> <description>Spare Part’s Rectangle Border Width Pixel Value in the Picture of Assembly. Sample data: 10,20…32767</description> <modifiers search="false" optional="true" initial="false" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> <attribute qualifier="spPartRectBrdrHeight" type="java.lang.Short"> <description>Spare Part’s Rectangle Border Height Pixel Value in the Picture of Assembly. Sample data: 10,20…32767</description> <modifiers search="false" optional="true" initial="false" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5)</value> </columntype> <columntype database="mysql"> <value>smallint</value> </columntype> <columntype database="sqlserver"> <value>smallint</value> </columntype> <columntype database="hsql"> <value>smallint</value> </columntype> </persistence> </attribute> </attributes> <indexes> <index name="productYcnCodeIDX" unique="false"> <key attribute="productYcnCode"/> </index> <index name="assemblyCodeIDX" unique="false"> <key attribute="assemblyCode"/> </index> <index name="spPartYcnCodeIDX" unique="false"> <key attribute="spPartYcnCode"/> </index> <index name="spPartRectCoordXIDX" unique="false"> <key attribute="spPartRectCoordX"/> </index> <index name="productYcnCodeAssemblyCodeSpPartYcnCodeSpPartRectCoordXIDX" unique="true"> <key attribute="productYcnCode"/> <key attribute="assemblyCode"/> <key attribute="spPartYcnCode"/> <key attribute="spPartRectCoordX"/> </index> </indexes> </itemtype> </itemtypes> </items> [/code] Bu adımda ise ant updatesytem komutu çalıştırarak veri tabanında tablonun oluşmasını sağlamalısınız veya hac-> platform-> update-> ycncore, ycninitialdata checked-> update Bu adım sonrası yeni obje ve beraberinde tablo oluşur, tabloda 4 alanın birleşmesiyle unique alan oluşur, bu alanlar tek başlarına unique olmayabilir ama 4’ü birden unique değer olarak saklanır. Yeni bir obje tanımlayıp, bir alanını indeksleme: Örneğin …/ycnproject/hybris/bin/custom/ycn/ycncore/resources/ycncore-items.xml dosyası için [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <itemtypes> <itemtype code="Customer" autocreate="true" generate="true"> <description>Customer</description> <deployment table="Customer" typecode="16199"></deployment> <attributes> <attribute qualifier="code" type="java.lang.String"> <description>Code</description> <modifiers optional="false"/> <persistence type="property"> <columntype> <value>nvarchar(100)</value> </columntype> </persistence> </attribute> <attribute qualifier="dealer" type="java.lang.String"> <description>Dealer</description> <modifiers optional="false"/> <persistence type="property"> <columntype> <value>nvarchar(100)</value> </columntype> </persistence> </attribute> </attributes> <indexes> <index name="code" unique="true"> <key attribute="code"/> </index> </indexes> </itemtype> </itemtypes> </items> [/code] Bu adım sonrası yeni obje, bu objenin tablosu oluşur ve code alanı indeklenir. Yeni bir objeden var olan alanı silme: [code language=”xml”] <!– Promotion Score Rule–> <itemtype code="PwrtoolProScoreRule" extends="GenericItem" autocreate="true" generate="true"> <description>Promotion Score Rules</description> <deployment table="PwrtoolProScoreRule" typecode="11127"/> <attributes> <attribute qualifier="transactionCode" type="java.lang.String"> <description>Transaction Code. Sample data: "01", "02", "03", …</description> <modifiers search="true" optional="false" initial="true" unique="true"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(2)</value> </columntype> <columntype database="mysql"> <value>varchar(2)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(2)</value> </columntype> <columntype database="hsql"> <value>nvarchar(2)</value> </columntype> <columntype database="postgresql"> <value>varchar(2)</value> </columntype> </persistence> </attribute> <attribute qualifier="transactionType" type="TransactionType"> <description>Transaction Type. Sample data: ADD, GET, UPDATE, REMOVE, …</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"/> </attribute> <attribute qualifier="description" type="localized:java.lang.String"> <description>Description of Transaction Code. Sample data: "Garanti Belgesi Doldurma", "Çek girisi" </description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(40)</value> </columntype> <columntype database="mysql"> <value>varchar(40)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(40)</value> </columntype> <columntype database="hsql"> <value>nvarchar(40)</value> </columntype> <columntype database="postgresql"> <value>varchar(40)</value> </columntype> </persistence> </attribute> <attribute qualifier="proScore" type="float"> <description>Score of transaction. Sample data: 3,4 4,5 1 2,00 10500,75</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5,2)</value> </columntype> <columntype database="mysql"> <value>float</value> </columntype> <columntype database="sqlserver"> <value>float(5)</value> </columntype> <columntype database="hsql"> <value>float</value> </columntype> <columntype database="postgresql"> <value>numeric(5,2)</value> </columntype> </persistence> </attribute> <!– <attribute qualifier="period" type="java.lang.String"> <description>Period of transaction code. Sample data: "02", "05"</description> <modifiers search="false" optional="true" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(2)</value> </columntype> <columntype database="mysql"> <value>varchar(2)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(2)</value> </columntype> <columntype database="hsql"> <value>nvarchar(2)</value> </columntype> <columntype database="postgresql"> <value>varchar(2)</value> </columntype> </persistence> </attribute> –> <attribute qualifier="periodType" type="ScorePeriodType"> <description>Score Period Type. Sample data: MONTHLY, EACH_PROCESS, YEARLY, CREATE, …</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"/> </attribute> </attributes> <indexes> <index name="transactionCodeIDX" unique="true"> <key attribute="transactionCode"/> </index> </indexes> </itemtype> [/code] örneğinde “period” alanını yorumlama dışı bırakabilirsiniz, sonrasında ant updatesystem çalıştırılmalı, impex basarken period ile ilgili kayıp alan hatası alınırsa backoffice’ten type içerisinden PwrtoolProScoreRule aratıp içerisinde period alanını için remove’u seçin, ImpEx çalıştırırken hata alınırsa bu işlemi yaptığınızı teyit edin. Items değişikliği sonrası artık aşağıdaki ImpEx yerine bir alttaki ImpEx çalıştırılmalıdır. İlgili obje için aşağıdaki gibi ImpEx çalıştırabilirsiniz. [code lang=”sql”] $langEn = en $langTr = tr $transactionTypeADD = ADD $transactionTypeGET = GET $transactionTypeEDIT = EDIT $transactionTypeREMOVE = REMOVE INSERT_UPDATE PwrtoolProScoreRule ; transactionCode[unique = true]; TransactionType(code) ; description[lang = $langEn] ; description[lang = $langTr] ; proScore ; period ; 01 ; $transactionTypeADD ; Filling guarantee form ; Garanti belgesi doldurma ; 3.00 ; 05 ; 02 ; $transactionTypeADD ; Filling first execution coupon ; İlk çalışma kuponu doldurma ; 2.00 ; 05 ; 03 ; $transactionTypeGET ; Downloading PurchaseSales reconciliation ; BaBs mutabakat formu indirme ; 3.00 ; 01 ; 04 ; $transactionTypeADD ; Entering Cheque ; Çek girişi ; 2.00 ; 02 ; 05 ; $transactionTypeADD ; Current balance reconciliation ; Cari hesap mutabakatı ; 50.00 ; 04 ; 06 ; $transactionTypeADD ; Credit card payment ; Kredi kartı ödemesi ; 0.40 ; 02 [/code] [code lang=”sql”] $langEn = en $langTr = tr $transactionTypeADD = ADD $transactionTypeGET = GET $transactionTypeEDIT = EDIT $transactionTypeREMOVE = REMOVE $periodTypeEACH_PROCESS = EACH_PROCESS $periodTypeCREATE = CREATE $periodTypeMONTHLY = MONTHLY $periodTypeYEARLY = YEARLY INSERT_UPDATE PwrtoolProScoreRule; transactionCode[unique = true]; TransactionType(code); description[lang = $langEn] ; description[lang = $langTr] ; proScore; periodType(code) ; 01 ; $transactionTypeADD ; Filling guarantee form ; Garanti belgesi doldurma ; 3.00 ; $periodTypeCREATE ; 02 ; $transactionTypeADD ; Filling first execution coupon ; İlk çalışma kuponu doldurma ; 2.00 ; $periodTypeCREATE ; 03 ; $transactionTypeGET ; Downloading PurchaseSales reconciliation ; BaBs mutabakat formu indirme ; 3.00 ; $periodTypeMONTHLY ; 04 ; $transactionTypeADD ; Entering Cheque ; Çek girişi ; 2.00 ; $periodTypeEACH_PROCESS ; 05 ; $transactionTypeGET ; Downloading Current balance reconciliation ; Cari hesap mutabakatı indirme ; 50.00 ; $periodTypeYEARLY ; 06 ; $transactionTypeADD ; Credit card payment ; Kredi kartı ödemesi ; 0.40 ; $periodTypeEACH_PROCESS [/code] Objede liste tanımlama: Örneğin …/ycnproject/hybris/bin/custom/ycn/ycncore/resources/ycncore-items.xml dosyası için [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <collectiontypes> <!– YcnAssemblyCat collections –> <collectiontype code="AssemblyCategoryColl" elementtype="YcnAssemblyCategory" autocreate="true" generate="true" type="list"/> </collectiontypes> <itemtypes> <!– Assembly Category type –> <itemtype code="YcnAssemblyCategory" extends="Category" autocreate="true" generate="true"></itemtype> <itemtype code="Product" autocreate="false" generate="false"> <attributes> <attribute qualifier="assemblies" type="AssemblyCategoryColl"> <description>Assembly Category List</description> <modifiers/> <persistence type="property"/> </attribute> </attributes> </itemtype> </itemtypes> </items> [/code] Bu adım sonrası Product objesi içerisinde YcnAssemblyCategory tipinde bir liste alanı eklenmiş olur. İki obje arasındaki alanların many-to-many olarak eşleme: Örneğin …/ycnproject/hybris/bin/custom/ycn/ycncore/resources/ycncore-items.xml dosyası için [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <collectiontypes> <!– YcnAssemblyCat collections –> <collectiontype code="AssemblyCategoryColl" elementtype="YcnAssemblyCategory" autocreate="true" generate="true" type="list"/> </collectiontypes> <itemtypes> <!– Assembly Category type –> <itemtype code="YcnAssemblyCategory" extends="Category" autocreate="true" generate="true"> <attributes> <attribute qualifier="productsAssemblyCat" type="Product"> <description>Product of Assembly Category List</description> <modifiers/> <persistence type="property"/> </attribute> </attributes> </itemtype> <itemtype code="Product" autocreate="false" generate="false"> <attributes> <attribute qualifier="assemblies" type="AssemblyCategoryColl"> <description>Assembly Category List</description> <modifiers/> <persistence type="property"/> </attribute> </attributes> </itemtype> </itemtypes> </items> [/code] yerine aşağıdaki gibi tanımlanan attribute’ler silinerek ilişkinin kurulduğu yerde alanlarda tanımlanmış oluyor. [code language=”xml”] <?xml version="1.0" encoding="ISO-8859-1"?> <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <relations> <!– YcnAssemblyCategory and Product relations –> <relation code="YcnAssemblyCategoryProductRelation" autocreate="true" generate="true" localized="false"> <deployment table="YcnAssyCat2ProdRel" typecode="11199"/> <sourceElement qualifier="assemblies" type="YcnAssemblyCategory" cardinality="many" ordered="false"> <description>Assembly List</description> <modifiers read="true" write="true" search="true" optional="true"/> </sourceElement> <!– collection type is default ‘set’ –> <targetElement qualifier="productsAssemblyCat" type="Product" cardinality="many" collectiontype="list" ordered="true"> <description>Products</description> <modifiers read="true" write="true" search="true" optional="true"/> </targetElement> </relation> </relations> <itemtypes> <!– Assembly Category type –> <itemtype code="YcnAssemblyCategory" extends="Category" autocreate="true" generate="true"> <!– <attributes> <attribute qualifier="productsAssemblyCat" type="Product"> <description>Product of Assembly Category List</description> <modifiers/> <persistence type="property"/> </attribute> </attributes> –> </itemtype> <itemtype code="Product" autocreate="false" generate="false"> <!– <attributes> <attribute qualifier="assemblies" type="AssemblyCategoryColl"> <description>Assembly Category List</description> <modifiers/> <persistence type="property"/> </attribute> </attributes> –> </itemtype> </itemtypes> </items> [/code] Bu adım sonrası Product objesi içerisinde YcnAssemblyCategory liste tipinde assemblies alanı tanımlanır, YcnAssemblyCategory objesi içerisinde Product liste tipinde productsAssemblyCat alanı tanımlanır, Product objesi içerisindeki assemblies alanı ile YcnAssemblyCategory objesi içerisindeki productsAssemblyCat alanları birbirine many-to-many olarak eşlenmiş olur. Enumaration tipi kullanımı: [code lang=”xml”] <items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="items.xsd"> <enumtypes> <!– Promotion Score Transaction Type –> <enumtype code="ProScoreTransactionType" generate="true" autocreate="true"> <description>Promotion Score Transaction Type</description> <value code="ADD"> <description>CREATE</description> </value> <value code="GET"> <description>READ</description> </value> <value code="EDIT"> <description>UPDATE</description> </value> <value code="REMOVE"> <description>DELETE</description> </value> </enumtype> </enumtypes> <itemtypes> <!– Add your item definitions here –> <typegroup name="Ycn"> <!– Promotion Score Rule–> <itemtype code="PwrtoolProScoreRule" extends="GenericItem" autocreate="true" generate="true"> <description>Promotion Score Rules</description> <deployment table="PwrtoolProScoreRule" typecode="11127"/> <attributes> <attribute qualifier="transactionCode" type="java.lang.String"> <description>Transaction Code. Sample data: "01", "02", "03", …</description> <modifiers search="true" optional="false" initial="true" unique="true"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(2)</value> </columntype> <columntype database="mysql"> <value>varchar(2)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(2)</value> </columntype> <columntype database="hsql"> <value>nvarchar(2)</value> </columntype> <columntype database="postgresql"> <value>varchar(2)</value> </columntype> </persistence> </attribute> <attribute qualifier="transactionType" type="ProScoreTransactionType"> <description>Transaction Type. Sample data: ADD, GET, UPDATE, REMOVE, …</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"/> </attribute> <attribute qualifier="description" type="java.lang.String"> <description>Description of Transaction Code. Sample data: "Garanti Belgesi Doldurma", "Çek girisi"</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(30)</value> </columntype> <columntype database="mysql"> <value>varchar(30)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(30)</value> </columntype> <columntype database="hsql"> <value>nvarchar(30)</value> </columntype> <columntype database="postgresql"> <value>varchar(30)</value> </columntype> </persistence> </attribute> <attribute qualifier="proScore" type="float"> <description>Score of transaction. Sample data: 3,4 4,5 1 2,00 10500,75</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>number(5,2)</value> </columntype> <columntype database="mysql"> <value>float</value> </columntype> <columntype database="sqlserver"> <value>float(5)</value> </columntype> <columntype database="hsql"> <value>float</value> </columntype> <columntype database="postgresql"> <value>numeric(5,2)</value> </columntype> </persistence> </attribute> <attribute qualifier="period" type="java.lang.String"> <description>Period of transaction code. Sample data: "02", "05"</description> <modifiers search="false" optional="false" initial="true" unique="false"/> <persistence type="property"> <columntype database="oracle"> <value>varchar2(2)</value> </columntype> <columntype database="mysql"> <value>varchar(2)</value> </columntype> <columntype database="sqlserver"> <value>nvarchar(2)</value> </columntype> <columntype database="hsql"> <value>nvarchar(2)</value> </columntype> <columntype database="postgresql"> <value>varchar(2)</value> </columntype> </persistence> </attribute> </attributes> <indexes> <index name="transactionCodeIDX" unique="true"> <key attribute="transactionCode"/> </index> </indexes> </itemtype> </typegroup> </itemtypes> [/code] ]]>