[clfr] Make createfromorders and createfrominouts columns mandatory
authorAlvaro Ferraz <alvaro.ferraz@openbravo.com>
Thu, 17 May 2018 12:27:28 +0200
changeset 34559 7d6426933ab5
parent 34558 99a467c3a77b
child 34560 fcde317d34ce
[clfr] Make createfromorders and createfrominouts columns mandatory
src-db/database/model/tables/C_INVOICE.xml
src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/model/tables/C_INVOICE.xml	Wed May 16 09:45:18 2018 -0400
+++ b/src-db/database/model/tables/C_INVOICE.xml	Thu May 17 12:27:28 2018 +0200
@@ -277,12 +277,12 @@
         <default><![CDATA[0]]></default>
         <onCreateDefault><![CDATA[0]]></onCreateDefault>
       </column>
-      <column name="CREATEFROMORDERS" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
-        <default/>
+      <column name="CREATEFROMORDERS" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
-      <column name="CREATEFROMINOUTS" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
-        <default/>
+      <column name="CREATEFROMINOUTS" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
       <foreign-key foreignTable="C_BPARTNER_LOCATION" name="C_BPLOCATION_CINVOICE">
@@ -383,6 +383,8 @@
         <index-column name="UPDATED"/>
       </index>
       <check name="C_INVOICE_CREATEFROM_CHECK"><![CDATA[CREATEFROM IN ('Y', 'N')]]></check>
+      <check name="C_INVOICE_CREATEFROMIO_CHEK"><![CDATA[CREATEFROMINOUTS IN ('Y', 'N')]]></check>
+      <check name="C_INVOICE_CREATEFROMO_CHEK"><![CDATA[CREATEFROMORDERS IN ('Y', 'N')]]></check>
       <check name="C_INVOICE_GENERATETO_CHECK"><![CDATA[GENERATETO IN ('Y', 'N')]]></check>
       <check name="C_INVOICE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="C_INVOICE_ISCASHVAT_CH"><![CDATA[ISCASHVAT IN ('Y', 'N')]]></check>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Wed May 16 09:45:18 2018 -0400
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Thu May 17 12:27:28 2018 +0200
@@ -259750,7 +259750,7 @@
 <!--35B6CA608E4544DABC461A352856483E-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
 <!--35B6CA608E4544DABC461A352856483E-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--35B6CA608E4544DABC461A352856483E-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--35B6CA608E4544DABC461A352856483E-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--35B6CA608E4544DABC461A352856483E-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--35B6CA608E4544DABC461A352856483E-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--35B6CA608E4544DABC461A352856483E-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--35B6CA608E4544DABC461A352856483E-->  <SEQNO><![CDATA[880]]></SEQNO>
@@ -376395,7 +376395,7 @@
 <!--E4657BAF62244FA786B4E5BD7C98E52B-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
 <!--E4657BAF62244FA786B4E5BD7C98E52B-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--E4657BAF62244FA786B4E5BD7C98E52B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--E4657BAF62244FA786B4E5BD7C98E52B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E4657BAF62244FA786B4E5BD7C98E52B-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--E4657BAF62244FA786B4E5BD7C98E52B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
 <!--E4657BAF62244FA786B4E5BD7C98E52B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--E4657BAF62244FA786B4E5BD7C98E52B-->  <SEQNO><![CDATA[870]]></SEQNO>