0038724: It is not possible to set a reason for price modification

diff --git a/src-db/database/model/modifiedTables/C_ORDERLINE.xml b/src-db/database/model/modifiedTables/C_ORDERLINE.xml --- a/src-db/database/model/modifiedTables/C_ORDERLINE.xml +++ b/src-db/database/model/modifiedTables/C_ORDERLINE.xml @@ -21,6 +21,13 @@ <default/> <onCreateDefault/> </column> + <column name="EM_OBPOS_PRICEREASON_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <foreign-key foreignTable="OBPOS_PRICEREASON" name="EM_OBPOS_ORDERLINE_PR"> + <reference local="EM_OBPOS_PRICEREASON_ID" foreign="OBPOS_PRICEREASON_ID"/> + </foreign-key> <index name="EM_OBPOS_DELIVEREDQTY" unique="false"> <index-column name="C_ORDER_ID"/> <index-column name="QTYDELIVERED"/> @@ -29,6 +36,10 @@ <index-column name="C_ORDER_ID"/> <index-column name="QTYORDERED"/> </index> + <index name="EM_OBPOS_ORDERLINE_PRICE" unique="false"> + <index-column name="EM_OBPOS_PRICEREASON_ID"/> + <whereClause><![CDATA[EM_OBPOS_PRICEREASON_ID IS NOT NULL]]></whereClause> + </index> <check name="EM_OBPOS_ISDELETED_OL_CHECK"><![CDATA[EM_OBPOS_ISDELETED IN ('Y', 'N')]]></check> <check name="EM_OBPOS_SERVICE_PROPOSED_CHK"><![CDATA[EM_OBPOS_SERVICE_PROPOSED IN ('Y', 'N')]]></check> </table> diff --git a/src-db/database/model/tables/OBPOS_PRICEREASON.xml b/src-db/database/model/tables/OBPOS_PRICEREASON.xml new file mode 100644 --- /dev/null +++ b/src-db/database/model/tables/OBPOS_PRICEREASON.xml @@ -0,0 +1,56 @@ +<?xml version="1.0"?> + <database name="TABLE OBPOS_PRICEREASON"> + <table name="OBPOS_PRICEREASON" primaryKey="OBPOS_PRICEREASON_KEY"> + <column name="OBPOS_PRICEREASON_ID" primaryKey="true" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="AD_CLIENT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="AD_ORG_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="ISACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> + <default><![CDATA[Y]]></default> + <onCreateDefault/> + </column> + <column name="CREATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false"> + <default><![CDATA[SYSDATE]]></default> + <onCreateDefault/> + </column> + <column name="CREATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="UPDATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false"> + <default><![CDATA[SYSDATE]]></default> + <onCreateDefault/> + </column> + <column name="UPDATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="NAME" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="DESCRIPTION" primaryKey="false" required="false" type="VARCHAR" size="200" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="SEQNO" primaryKey="false" required="true" type="DECIMAL" size="10,0" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <foreign-key foreignTable="AD_CLIENT" name="OBPOS_PRICEREASON_AD_CLIENT"> + <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/> + </foreign-key> + <foreign-key foreignTable="AD_ORG" name="OBPOS_PRICEREASON_AD_ORG"> + <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> + </foreign-key> + <check name="OBPOS_PRICEREASON_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> + </table> + </database> diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml +++ b/src-db/database/sourcedata/AD_COLUMN.xml @@ -419,6 +419,44 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[048D0A26F0D34AF4B10D86C56238D364]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Updated By]]></NAME> + <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION> + <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP> + <COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[80]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[8]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[04BBAEFD66D649F9AC769477B0551EA8]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -3596,6 +3634,45 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[22F96EA2524F44A58CADD73AEC26CC0F]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Updated]]></NAME> + <DESCRIPTION><![CDATA[The date that this record was last updated]]></DESCRIPTION> + <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP> + <COLUMNNAME><![CDATA[Updated]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> + <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[70]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[7]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[2327B614E9D14A94A0DA92E5C1C9C681]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -5675,6 +5752,45 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[3AE4ACD085FE48C2B14EA1E587A7F11D]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Client]]></NAME> + <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION> + <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP> + <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> + <DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[20]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[2]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[3AE968994E24427AA47D1AAFEC1F8606]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -7542,6 +7658,44 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[5685AC7242EC4DDCBC08668B90EF62F9]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Created By]]></NAME> + <DESCRIPTION><![CDATA[User who created this records]]></DESCRIPTION> + <HELP><![CDATA[The Created By field indicates the user who created this record.]]></HELP> + <COLUMNNAME><![CDATA[Createdby]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[60]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[246]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[6]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[569A02B13FD04CE0965210AFE8AEFDCB]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -12036,6 +12190,47 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[90016B8E423E4E78B1A4FAFD3BF8441B]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Active]]></NAME> + <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION> + <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: +(1) The system requires the record for auditing purposes. +(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP> + <COLUMNNAME><![CDATA[Isactive]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH> + <DEFAULTVALUE><![CDATA[Y]]></DEFAULTVALUE> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[40]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[4]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[9051A14069BA480CBFD296EA41B7EB8E]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -12379,6 +12574,45 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[93A3D1A3658F4CE8B13F28BFEEC35419]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Sequence Number]]></NAME> + <DESCRIPTION><![CDATA[The sequence indicates the priority of the grid configuration.]]></DESCRIPTION> + <HELP><![CDATA[The grid configuration which has the highest sequence number will be the one which applies.]]></HELP> + <COLUMNNAME><![CDATA[Seqno]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH> + <DEFAULTVALUE><![CDATA[@SQL=SELECT COALESCE(MAX(SEQNO),0)+10 AS DefaultValue FROM OBPOS_PRICEREASON WHERE AD_Client_ID=@AD_Client_ID@]]></DEFAULTVALUE> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[120]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[C9C41FA962E34C52B1BC48C2879371BA]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[12]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[93F5667B9B9E46B6B296494FFDF239D4]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14431,6 +14665,43 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[AD14A402A17743BE9D107FFB457B9AF4]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Organization]]></NAME> + <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> + <DEFAULTVALUE><![CDATA[@AD_ORG_ID@]]></DEFAULTVALUE> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[30]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[314D557225BB42C2BE1F312928AB6FFA]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[3]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[AD446CBE59334BC985318902A8FFE5FD]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14820,6 +15091,45 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[B08FCDC9A07743B7BCB62761694C43D5]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Creation Date]]></NAME> + <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION> + <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP> + <COLUMNNAME><![CDATA[Created]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> + <DEFAULTVALUE><![CDATA[@#Date@]]></DEFAULTVALUE> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[50]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[5]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[B1BAB56967304DB2B843A24C6E6632FF]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14972,6 +15282,44 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[B3A75BD561574397A9C9350DD90EBE57]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Description]]></NAME> + <DESCRIPTION><![CDATA[A space to write additional related information.]]></DESCRIPTION> + <HELP><![CDATA[A description is limited to 255 characters.]]></HELP> + <COLUMNNAME><![CDATA[Description]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[14]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[200]]></FIELDLENGTH> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[N]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[110]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[275]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[11]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[B3C50444835F4AD6AF62C0F98D04CD6D]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -17540,6 +17888,44 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[D8374216975044FDA5DAA69773F454C7]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Name]]></NAME> + <DESCRIPTION><![CDATA[A non-unique identifier for a record/document often used as a search tool.]]></DESCRIPTION> + <HELP><![CDATA[A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.]]></HELP> + <COLUMNNAME><![CDATA[Name]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> + <SEQNO><![CDATA[90]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[469]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[9]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[D8DD5F42308E4A7893E5766DA2B0C383]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -17813,6 +18199,42 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[DA704B2954774F9797E11E72CEC49BE8]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[OBPOS_PriceReason_ID]]></NAME> + <COLUMNNAME><![CDATA[OBPOS_PriceReason_ID]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID> + <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> + <ISKEY><![CDATA[Y]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[10]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[ACCF96BD281342889927E7451CD0ACB4]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[1]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[DC3A6F2D52644F8A95EC64061C8FDAE7]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -20655,6 +21077,45 @@  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> </AD_COLUMN> +<AD_COLUMN> + <AD_COLUMN_ID><![CDATA[FB8BCDA7BC004BB2A78DCCAD8E20A48D]]></AD_COLUMN_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[EM_OBPOS_Price Modification Reason]]></NAME> + <DESCRIPTION><![CDATA[Reason of the Price Modification of the OrderLine]]></DESCRIPTION> + <HELP><![CDATA[Reason of the Price Modification of the OrderLine]]></HELP> + <COLUMNNAME><![CDATA[EM_OBPOS_PriceReason_ID]]></COLUMNNAME> + <AD_TABLE_ID><![CDATA[260]]></AD_TABLE_ID> + <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID> + <AD_REFERENCE_VALUE_ID><![CDATA[B965F4658CB1417DA9EF1D467911525B]]></AD_REFERENCE_VALUE_ID> + <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> + <ISKEY><![CDATA[N]]></ISKEY> + <ISPARENT><![CDATA[N]]></ISPARENT> + <ISMANDATORY><![CDATA[N]]></ISMANDATORY> + <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> + <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> + <SEQNO><![CDATA[394]]></SEQNO> + <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> + <AD_ELEMENT_ID><![CDATA[3C6762983087406EAE0E697909584A58]]></AD_ELEMENT_ID> + <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> + <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> + <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <POSITION><![CDATA[94]]></POSITION> + <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> + <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> + <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> + <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> + <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> + <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING> + <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING> + <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK> +</AD_COLUMN> + <AD_COLUMN>  <AD_COLUMN_ID><![CDATA[FC1D7E9D9AB741B888B0EC28512900B1]]></AD_COLUMN_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_DATASET_TABLE.xml b/src-db/database/sourcedata/AD_DATASET_TABLE.xml --- a/src-db/database/sourcedata/AD_DATASET_TABLE.xml +++ b/src-db/database/sourcedata/AD_DATASET_TABLE.xml @@ -70,6 +70,20 @@  <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> </AD_DATASET_TABLE> +<AD_DATASET_TABLE> + <AD_DATASET_TABLE_ID><![CDATA[4CB535187A2D45CEA53900FA8D39302A]]></AD_DATASET_TABLE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> + <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE> + <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> + <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> +</AD_DATASET_TABLE> + <AD_DATASET_TABLE>  <AD_DATASET_TABLE_ID><![CDATA[5487D5C836914A3CAA5F37B613369E0C]]></AD_DATASET_TABLE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_ELEMENT.xml b/src-db/database/sourcedata/AD_ELEMENT.xml --- a/src-db/database/sourcedata/AD_ELEMENT.xml +++ b/src-db/database/sourcedata/AD_ELEMENT.xml @@ -603,6 +603,20 @@  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> </AD_ELEMENT> +<AD_ELEMENT> + <AD_ELEMENT_ID><![CDATA[3C6762983087406EAE0E697909584A58]]></AD_ELEMENT_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <COLUMNNAME><![CDATA[EM_OBPOS_PriceReason_ID]]></COLUMNNAME> + <NAME><![CDATA[Price Modification Reason]]></NAME> + <PRINTNAME><![CDATA[Price Modification Reason]]></PRINTNAME> + <DESCRIPTION><![CDATA[Reason of the Price Modification of the OrderLine]]></DESCRIPTION> + <HELP><![CDATA[Reason of the Price Modification of the OrderLine]]></HELP> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> +</AD_ELEMENT> + <AD_ELEMENT>  <AD_ELEMENT_ID><![CDATA[3D48B22F266346378E86F394F50F7D2A]]></AD_ELEMENT_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -2096,6 +2110,18 @@  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> </AD_ELEMENT> +<AD_ELEMENT> + <AD_ELEMENT_ID><![CDATA[ACCF96BD281342889927E7451CD0ACB4]]></AD_ELEMENT_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <COLUMNNAME><![CDATA[OBPOS_PriceReason_ID]]></COLUMNNAME> + <NAME><![CDATA[OBPOS_PriceReason_ID]]></NAME> + <PRINTNAME><![CDATA[OBPOS_PriceReason_ID]]></PRINTNAME> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> +</AD_ELEMENT> + <AD_ELEMENT>  <AD_ELEMENT_ID><![CDATA[AD97CD1387524386938EE78B7BDE8BE0]]></AD_ELEMENT_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_FIELD.xml b/src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml +++ b/src-db/database/sourcedata/AD_FIELD.xml @@ -87,6 +87,33 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[00AB23BD30FD49F6A8FE7222987CFFF2]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Client]]></NAME> + <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION> + <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[3AE4ACD085FE48C2B14EA1E587A7F11D]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[00BF273D2E3A4308B0ED31A46BD4AC52]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -541,6 +568,31 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[0858C2622B934546AE19C9FACEA8C8AB]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[OBPOS_PriceReason_ID]]></NAME> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[DA704B2954774F9797E11E72CEC49BE8]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[08A032070CBA44AE8D0413C6F3FD3ABD]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -2089,6 +2141,34 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[285A468E61A04B179B835D9C267E1CBB]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Price Modification Reason]]></NAME> + <DESCRIPTION><![CDATA[Reason of the Price Modification of the OrderLine]]></DESCRIPTION> + <HELP><![CDATA[Reason of the Price Modification of the OrderLine]]></HELP> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[187]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[FB8BCDA7BC004BB2A78DCCAD8E20A48D]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[Y]]></ISREADONLY> + <SEQNO><![CDATA[400]]></SEQNO> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[28BAC15CEA7A4832B611D10283951F82]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -3380,6 +3460,34 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[42EEF488E6F042D984B965732BC42B88]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Name]]></NAME> + <DESCRIPTION><![CDATA[A non-unique identifier for a record/document often used as a search tool.]]></DESCRIPTION> + <HELP><![CDATA[A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.]]></HELP> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[D8374216975044FDA5DAA69773F454C7]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <SEQNO><![CDATA[20]]></SEQNO> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[437E74966B7644A7AFA2153693B08784]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -3465,6 +3573,32 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[43D63B82DEE3425986D49C8D3FC208CC]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Organization]]></NAME> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[AD14A402A17743BE9D107FFB457B9AF4]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <SEQNO><![CDATA[10]]></SEQNO> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[444F8F9BFB5F4ACC92814CFAAA63D79A]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -6417,6 +6551,34 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[865A1F60996F47F58FDBEAA204210654]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Description]]></NAME> + <DESCRIPTION><![CDATA[A space to write additional related information.]]></DESCRIPTION> + <HELP><![CDATA[A description is limited to 255 characters.]]></HELP> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[B3A75BD561574397A9C9350DD90EBE57]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[200]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <SEQNO><![CDATA[50]]></SEQNO> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[86E0D04F1F4247CEBBA6BC9844DED695]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -11196,6 +11358,35 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[E6ADC41945964F448A4F2D4469D94017]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Sequence Number]]></NAME> + <DESCRIPTION><![CDATA[The sequence indicates the priority of the grid configuration.]]></DESCRIPTION> + <HELP><![CDATA[The grid configuration which has the highest sequence number will be the one which applies.]]></HELP> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[93A3D1A3658F4CE8B13F28BFEEC35419]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <SEQNO><![CDATA[30]]></SEQNO> + <SORTNO><![CDATA[1]]></SORTNO> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[E6ADCB6F397F49B0A6C3D942DC5538F1]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -11839,6 +12030,36 @@  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> </AD_FIELD> +<AD_FIELD> + <AD_FIELD_ID><![CDATA[F7B1B8350FFE4D9CB1675ECB2F42EF5E]]></AD_FIELD_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Active]]></NAME> + <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION> + <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: +(1) The system requires the record for auditing purposes. +(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP> + <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_COLUMN_ID><![CDATA[90016B8E423E4E78B1A4FAFD3BF8441B]]></AD_COLUMN_ID> + <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD> + <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> + <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <SEQNO><![CDATA[40]]></SEQNO> + <ISSAMELINE><![CDATA[N]]></ISSAMELINE> + <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> + <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> + <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> + <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> + <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> + <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> + <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +</AD_FIELD> + <AD_FIELD>  <AD_FIELD_ID><![CDATA[FB1FD77847E448A6B30FEAC151521974]]></AD_FIELD_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_MENU.xml b/src-db/database/sourcedata/AD_MENU.xml --- a/src-db/database/sourcedata/AD_MENU.xml +++ b/src-db/database/sourcedata/AD_MENU.xml @@ -14,6 +14,20 @@  <OPENLINKINBROWSER><![CDATA[N]]></OPENLINKINBROWSER> </AD_MENU> +<AD_MENU> + <AD_MENU_ID><![CDATA[25DDE33B06BC45F39C22A5365717C8A3]]></AD_MENU_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Price Modification Reasons]]></NAME> + <DESCRIPTION><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></DESCRIPTION> + <ISSUMMARY><![CDATA[N]]></ISSUMMARY> + <ACTION><![CDATA[W]]></ACTION> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <OPENLINKINBROWSER><![CDATA[N]]></OPENLINKINBROWSER> +</AD_MENU> + <AD_MENU>  <AD_MENU_ID><![CDATA[35A29F0B17514096A67D9F33E5FEE761]]></AD_MENU_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_MESSAGE.xml b/src-db/database/sourcedata/AD_MESSAGE.xml --- a/src-db/database/sourcedata/AD_MESSAGE.xml +++ b/src-db/database/sourcedata/AD_MESSAGE.xml @@ -2114,6 +2114,18 @@  <ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N> </AD_MESSAGE> +<AD_MESSAGE> + <AD_MESSAGE_ID><![CDATA[3525641939C848099F8C7267E9ED7E60]]></AD_MESSAGE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <VALUE><![CDATA[OBPOS_approval.setPriceMessage]]></VALUE> + <MSGTEXT><![CDATA[Price of product %0 changed from %1 to %2]]></MSGTEXT> + <MSGTYPE><![CDATA[I]]></MSGTYPE> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N> +</AD_MESSAGE> + <AD_MESSAGE>  <AD_MESSAGE_ID><![CDATA[35275E8E5F1E4EC890AB3C2DA1127914]]></AD_MESSAGE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -2426,6 +2438,18 @@  <ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N> </AD_MESSAGE> +<AD_MESSAGE> + <AD_MESSAGE_ID><![CDATA[3AE2C03C27BD457D92FB657A83719419]]></AD_MESSAGE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <VALUE><![CDATA[OBPOS_PriceModification]]></VALUE> + <MSGTEXT><![CDATA[Price Modification]]></MSGTEXT> + <MSGTYPE><![CDATA[I]]></MSGTYPE> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N> +</AD_MESSAGE> + <AD_MESSAGE>  <AD_MESSAGE_ID><![CDATA[3AEE277A5F2543558720992E1CED2C2C]]></AD_MESSAGE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -4923,6 +4947,18 @@  <ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N> </AD_MESSAGE> +<AD_MESSAGE> + <AD_MESSAGE_ID><![CDATA[78A3356B425C49E4A6FC46F94941A54E]]></AD_MESSAGE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <VALUE><![CDATA[OBPOS_lblPriceModification]]></VALUE> + <MSGTEXT><![CDATA[Modification Reason]]></MSGTEXT> + <MSGTYPE><![CDATA[I]]></MSGTYPE> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N> +</AD_MESSAGE> + <AD_MESSAGE>  <AD_MESSAGE_ID><![CDATA[78BEBCD00FBF4548BC48D8D426317198]]></AD_MESSAGE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_PREFERENCE.xml b/src-db/database/sourcedata/AD_PREFERENCE.xml --- a/src-db/database/sourcedata/AD_PREFERENCE.xml +++ b/src-db/database/sourcedata/AD_PREFERENCE.xml @@ -517,6 +517,17 @@  <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> </AD_PREFERENCE> +<AD_PREFERENCE> + <AD_PREFERENCE_ID><![CDATA[4C432B2032AD438A8B8EB578987DA128]]></AD_PREFERENCE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <VALUE><![CDATA[N]]></VALUE> + <PROPERTY><![CDATA[OBPOS_ModifyPriceVerifiedReturns]]></PROPERTY> + <ISPROPERTYLIST><![CDATA[Y]]></ISPROPERTYLIST> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> +</AD_PREFERENCE> + <AD_PREFERENCE>  <AD_PREFERENCE_ID><![CDATA[4E24580021EE4D7DAE9C94A17ED4A917]]></AD_PREFERENCE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_REFERENCE.xml b/src-db/database/sourcedata/AD_REFERENCE.xml --- a/src-db/database/sourcedata/AD_REFERENCE.xml +++ b/src-db/database/sourcedata/AD_REFERENCE.xml @@ -265,6 +265,20 @@  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> </AD_REFERENCE> +<AD_REFERENCE> + <AD_REFERENCE_ID><![CDATA[B965F4658CB1417DA9EF1D467911525B]]></AD_REFERENCE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Price Modification Reason]]></NAME> + <DESCRIPTION><![CDATA[Price Modification Reason Reference]]></DESCRIPTION> + <HELP><![CDATA[Price Modification Reason Reference]]></HELP> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE> + <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID> + <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> +</AD_REFERENCE> + <AD_REFERENCE>  <AD_REFERENCE_ID><![CDATA[BDA324CB4B8847C3A1D2318E978BA08A]]></AD_REFERENCE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_REF_LIST.xml b/src-db/database/sourcedata/AD_REF_LIST.xml --- a/src-db/database/sourcedata/AD_REF_LIST.xml +++ b/src-db/database/sourcedata/AD_REF_LIST.xml @@ -962,6 +962,18 @@  <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> </AD_REF_LIST> +<AD_REF_LIST> + <AD_REF_LIST_ID><![CDATA[5548479CBE0A4A168868AA7A7ABC7C92]]></AD_REF_LIST_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <VALUE><![CDATA[OBPOS_ModifyPriceVerifiedReturns]]></VALUE> + <NAME><![CDATA[WebPOS Allow Price Modification in Verified Returns]]></NAME> + <DESCRIPTION><![CDATA[Allow Price Modification in Verified Returns. It will allow only to return less amount]]></DESCRIPTION> + <AD_REFERENCE_ID><![CDATA[A26BA480E2014707B47257024C3CBFF7]]></AD_REFERENCE_ID> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> +</AD_REF_LIST> + <AD_REF_LIST>  <AD_REF_LIST_ID><![CDATA[55D40DCFE3FE49C39AAB6E0607094A6C]]></AD_REF_LIST_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_REF_TABLE.xml b/src-db/database/sourcedata/AD_REF_TABLE.xml --- a/src-db/database/sourcedata/AD_REF_TABLE.xml +++ b/src-db/database/sourcedata/AD_REF_TABLE.xml @@ -68,6 +68,17 @@  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> </AD_REF_TABLE> +<AD_REF_TABLE> + <AD_REFERENCE_ID><![CDATA[B965F4658CB1417DA9EF1D467911525B]]></AD_REFERENCE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_KEY><![CDATA[DA704B2954774F9797E11E72CEC49BE8]]></AD_KEY> + <AD_DISPLAY><![CDATA[D8374216975044FDA5DAA69773F454C7]]></AD_DISPLAY> + <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> +</AD_REF_TABLE> + <AD_REF_TABLE>  <AD_REFERENCE_ID><![CDATA[BDA324CB4B8847C3A1D2318E978BA08A]]></AD_REFERENCE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_TAB.xml b/src-db/database/sourcedata/AD_TAB.xml --- a/src-db/database/sourcedata/AD_TAB.xml +++ b/src-db/database/sourcedata/AD_TAB.xml @@ -1,5 +1,36 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<AD_TAB> + <AD_TAB_ID><![CDATA[010D6AA1C8D1410EB941C3C061F069DD]]></AD_TAB_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Price Modification Reasons]]></NAME> + <DESCRIPTION><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></DESCRIPTION> + <HELP><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></HELP> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <SEQNO><![CDATA[10]]></SEQNO> + <TABLEVEL><![CDATA[0]]></TABLEVEL> + <ISSINGLEROW><![CDATA[N]]></ISSINGLEROW> + <ISINFOTAB><![CDATA[N]]></ISINFOTAB> + <ISTRANSLATIONTAB><![CDATA[N]]></ISTRANSLATIONTAB> + <ISREADONLY><![CDATA[N]]></ISREADONLY> + <HASTREE><![CDATA[N]]></HASTREE> + <PROCESSING><![CDATA[N]]></PROCESSING> + <IMPORTFIELDS><![CDATA[N]]></IMPORTFIELDS> + <ISSORTTAB><![CDATA[N]]></ISSORTTAB> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <UIPATTERN><![CDATA[STD]]></UIPATTERN> + <SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS> + <DISABLE_PARENT_KEY_PROPERTY><![CDATA[N]]></DISABLE_PARENT_KEY_PROPERTY> + <ISREADONLYTREE><![CDATA[N]]></ISREADONLYTREE> + <ISSHOWTREENODEICONS><![CDATA[Y]]></ISSHOWTREENODEICONS> + <EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD> + <EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE> + <EM_OBUIAPP_SHOW_SELECT><![CDATA[Y]]></EM_OBUIAPP_SHOW_SELECT> +</AD_TAB> + <AD_TAB>  <AD_TAB_ID><![CDATA[027E3BB9B7114CA68F976D0C0133E682]]></AD_TAB_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_TABLE.xml b/src-db/database/sourcedata/AD_TABLE.xml --- a/src-db/database/sourcedata/AD_TABLE.xml +++ b/src-db/database/sourcedata/AD_TABLE.xml @@ -67,6 +67,31 @@  <ISTREE><![CDATA[N]]></ISTREE> </AD_TABLE> +<AD_TABLE> + <AD_TABLE_ID><![CDATA[0C2C95843DC24540A81B867A0609B6E4]]></AD_TABLE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[OBPOS_PriceReason]]></NAME> + <DESCRIPTION><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></DESCRIPTION> + <HELP><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></HELP> + <TABLENAME><![CDATA[OBPOS_PriceReason]]></TABLENAME> + <CLASSNAME><![CDATA[OBPOSPriceReason]]></CLASSNAME> + <ISVIEW><![CDATA[N]]></ISVIEW> + <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED> + <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE> + <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME> + <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE> + <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG> + <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT> + <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> + <AD_PACKAGE_ID><![CDATA[FF808181326CC34901326D58E1CA002A]]></AD_PACKAGE_ID> + <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE> + <ISTREE><![CDATA[N]]></ISTREE> +</AD_TABLE> + <AD_TABLE>  <AD_TABLE_ID><![CDATA[11E84F99CFDF4B43804FE7BD8766D003]]></AD_TABLE_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/AD_TREENODE.xml b/src-db/database/sourcedata/AD_TREENODE.xml --- a/src-db/database/sourcedata/AD_TREENODE.xml +++ b/src-db/database/sourcedata/AD_TREENODE.xml @@ -77,6 +77,17 @@  <SEQNO><![CDATA[70]]></SEQNO> </AD_TREENODE> +<AD_TREENODE> + <AD_TREENODE_ID><![CDATA[AAAD7F184C40425790B5142487D547FD]]></AD_TREENODE_ID> + <AD_TREE_ID><![CDATA[10]]></AD_TREE_ID> + <NODE_ID><![CDATA[25DDE33B06BC45F39C22A5365717C8A3]]></NODE_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <PARENT_ID><![CDATA[896AC285FD8F4C25A869689D4A98DD8E]]></PARENT_ID> + <SEQNO><![CDATA[80]]></SEQNO> +</AD_TREENODE> + <AD_TREENODE>  <AD_TREENODE_ID><![CDATA[D9163EBFF1184AFE9A275A1A78AA80B3]]></AD_TREENODE_ID>  <AD_TREE_ID><![CDATA[10]]></AD_TREE_ID> diff --git a/src-db/database/sourcedata/AD_WINDOW.xml b/src-db/database/sourcedata/AD_WINDOW.xml --- a/src-db/database/sourcedata/AD_WINDOW.xml +++ b/src-db/database/sourcedata/AD_WINDOW.xml @@ -85,6 +85,23 @@  <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE> </AD_WINDOW> +<AD_WINDOW> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <NAME><![CDATA[Price Modification Reasons]]></NAME> + <DESCRIPTION><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></DESCRIPTION> + <HELP><![CDATA[Here you define the reason when modifying the price of a line in WebPOS]]></HELP> + <WINDOWTYPE><![CDATA[M]]></WINDOWTYPE> + <ISSOTRX><![CDATA[Y]]></ISSOTRX> + <PROCESSING><![CDATA[N]]></PROCESSING> + <ISDEFAULT><![CDATA[N]]></ISDEFAULT> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISTHREADSAFE><![CDATA[N]]></ISTHREADSAFE> + <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE> +</AD_WINDOW> + <AD_WINDOW>  <AD_WINDOW_ID><![CDATA[8AC4D0AC73A44547ACE1FC6A39D00F7F]]></AD_WINDOW_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/OBMOBC_SERVICES.xml b/src-db/database/sourcedata/OBMOBC_SERVICES.xml --- a/src-db/database/sourcedata/OBMOBC_SERVICES.xml +++ b/src-db/database/sourcedata/OBMOBC_SERVICES.xml @@ -700,6 +700,18 @@  <SERVER_RUNTIME><![CDATA[OBSTSYN_ON_CENTRAL]]></SERVER_RUNTIME> </OBMOBC_SERVICES> +<OBMOBC_SERVICES> + <OBMOBC_SERVICES_ID><![CDATA[AAE56687FAD44D77B1CF1A413CBD27BD]]></OBMOBC_SERVICES_ID> + <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <AD_MODULE_ID><![CDATA[FF808181326CC34901326D53DBCF0018]]></AD_MODULE_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <SERVICE><![CDATA[org.openbravo.retail.posterminal.term.PriceModificationReason]]></SERVICE> + <DESCRIPTION><![CDATA[Query service for Price Modification Reasons]]></DESCRIPTION> + <ROUTINGTYPE><![CDATA[Failover]]></ROUTINGTYPE> + <SERVER_RUNTIME><![CDATA[OBSTSYN_ON_CENTRAL]]></SERVER_RUNTIME> +</OBMOBC_SERVICES> + <OBMOBC_SERVICES>  <OBMOBC_SERVICES_ID><![CDATA[B13DD11B1B074140A1098197A6857E34]]></OBMOBC_SERVICES_ID>  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java b/src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java --- a/src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java +++ b/src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java @@ -174,6 +174,7 @@ "components/modalcreateorderfromquotation", "components/modalreactivatequotation", "components/modalrejectquotation", + "components/modalPriceModification", // Detection of change in context "components/modalcontextchanged", "components/modalproductcharacteristic", diff --git a/src/org/openbravo/retail/posterminal/term/PriceModificationReason.java b/src/org/openbravo/retail/posterminal/term/PriceModificationReason.java new file mode 100644 --- /dev/null +++ b/src/org/openbravo/retail/posterminal/term/PriceModificationReason.java @@ -0,0 +1,44 @@ +/* + ************************************************************************************ + * Copyright (C) 2018 Openbravo S.L.U. + * Licensed under the Openbravo Commercial License version 1.0 + * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html + * or in the legal folder of this module distribution. + ************************************************************************************ + */ +package org.openbravo.retail.posterminal.term; + +import java.util.Arrays; +import java.util.List; + +import org.codehaus.jettison.json.JSONException; +import org.codehaus.jettison.json.JSONObject; + +public class PriceModificationReason extends QueryTerminalProperty { + + @Override + protected boolean isAdminMode() { + return true; + } + + @Override + protected List<String> getQuery(JSONObject jsonsent) throws JSONException { + return Arrays + .asList(new String[] { "from OBPOS_PriceReason where $readableSimpleCriteria and $activeCriteria order by sequenceNumber" }); + } + + @Override + protected boolean bypassPreferenceCheck() { + return true; + } + + @Override + public String getProperty() { + return "priceModificationReasons"; + } + + @Override + public boolean returnList() { + return false; + } +} \ No newline at end of file diff --git a/web/org.openbravo.retail.posterminal/css/obpos-main.css b/web/org.openbravo.retail.posterminal/css/obpos-main.css --- a/web/org.openbravo.retail.posterminal/css/obpos-main.css +++ b/web/org.openbravo.retail.posterminal/css/obpos-main.css @@ -810,4 +810,12 @@ .input-login::placeholder { color: #bbbbbb; font-style: italic; +} + +.modal-body-label { + text-align: right; + padding-right:10px; + width: 40%; + height: 40px; + float: left; } \ No newline at end of file diff --git a/web/org.openbravo.retail.posterminal/js/components/modalPriceModification.js b/web/org.openbravo.retail.posterminal/js/components/modalPriceModification.js new file mode 100644 --- /dev/null +++ b/web/org.openbravo.retail.posterminal/js/components/modalPriceModification.js @@ -0,0 +1,119 @@ +/* + ************************************************************************************ + * Copyright (C) 2018 Openbravo S.L.U. + * Licensed under the Openbravo Commercial License version 1.0 + * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html + * or in the legal folder of this module distribution. + ************************************************************************************ + */ + +/*global B, Backbone, $, _, enyo */ + +enyo.kind({ + kind: 'OB.UI.ModalDialogButton', + name: 'OB.OBPOSPointOfSale.UI.Modals.btnModalPriceModificationCancel', + i18nContent: 'OBMOBC_LblCancel', + tap: function () { + this.doHideThisPopup(); + } +}); + +enyo.kind({ + kind: 'OB.UI.ModalDialogButton', + name: 'OB.OBPOSPointOfSale.UI.Modals.btnModalPriceModificationAccept', + i18nContent: 'OBMOBC_LblOk', + events: { + onPriceModificationDone: '' + }, + tap: function () { + this.doPriceModificationDone(); + this.doHideThisPopup(); + } +}); + +enyo.kind({ + kind: 'OB.UI.List', + name: 'OB.UI.ModalPriceModificationReason', + classes: 'combo', + style: 'width: 80%', + renderLine: enyo.kind({ + kind: 'enyo.Option', + initComponents: function () { + this.inherited(arguments); + this.setValue(this.model.get('id')); + this.setContent(this.model.get('_identifier')); + } + }), + renderEmpty: 'enyo.Control', + initComponents: function () { + this.setCollection(new Backbone.Collection()); + } +}); + +enyo.kind({ + kind: 'OB.UI.ModalAction', + name: 'OB.UI.ModalPriceModification', + myId: 'modalPriceModification', + autoDismiss: false, + closeOnEscKey: false, + bodyContent: { + components: [{ + name: 'labelPriceModification', + classes: 'modal-body-label' + }, { + style: 'width: 50%; float: left;', + kind: 'OB.UI.ModalPriceModificationReason', + name: 'priceModificationReason' + }] + }, + i18nHeader: 'OBPOS_PriceModification', + bodyButtons: { + components: [{ + kind: 'OB.OBPOSPointOfSale.UI.Modals.btnModalPriceModificationAccept' + }, { + kind: 'OB.OBPOSPointOfSale.UI.Modals.btnModalPriceModificationCancel' + }] + }, + events: { + onPriceModification: '' + }, + handlers: { + onPriceModificationDone: 'doPriceModificationDone' + }, + doPriceModificationDone: function () { + var me = this, + i; + if (this.args.selectedModels.length > 1) { + for (i = 0; i < this.args.selectedModels.length; i++) { + this.args.selectedModels[i].set('oBPOSPriceModificationReason', me.$.bodyContent.$.priceModificationReason.getValue()); + } + } else { + this.args.line.set('oBPOSPriceModificationReason', me.$.bodyContent.$.priceModificationReason.getValue()); + } + this.args.callback(); + }, + executeOnShow: function () { + var i; + if (this.args.selectedModels.length <= 1 && this.args.line.get('oBPOSPriceModificationReason')) { + for (i = 0; i < OB.MobileApp.model.get('priceModificationReasons').length; i++) { + if (OB.MobileApp.model.get('priceModificationReasons')[i].id === this.args.line.get('oBPOSPriceModificationReason')) { + this.$.bodyContent.$.priceModificationReason.setSelected(i); + break; + } + } + } + }, + initComponents: function () { + this.inherited(arguments); + this.$.bodyContent.$.labelPriceModification.setContent(OB.I18N.getLabel('OBPOS_lblPriceModification')); + var priceModificationReasonCollection = []; + _.each(OB.MobileApp.model.get('priceModificationReasons'), function (reason) { + priceModificationReasonCollection.push(new Backbone.Model({ + id: reason.id, + _identifier: reason[OB.Constants.IDENTIFIER] + })); + }); + this.$.bodyContent.$.priceModificationReason.getCollection().reset(priceModificationReasonCollection); + this.$.headerCloseButton.hide(); + } +}); \ No newline at end of file diff --git a/web/org.openbravo.retail.posterminal/js/components/modalreceiptlineproperties.js b/web/org.openbravo.retail.posterminal/js/components/modalreceiptlineproperties.js --- a/web/org.openbravo.retail.posterminal/js/components/modalreceiptlineproperties.js +++ b/web/org.openbravo.retail.posterminal/js/components/modalreceiptlineproperties.js @@ -1,6 +1,6 @@ /* ************************************************************************************ - * Copyright (C) 2012-2017 Openbravo S.L.U. + * Copyright (C) 2012-2018 Openbravo S.L.U. * Licensed under the Openbravo Commercial License version 1.0 * You may obtain a copy of the License at http://www.openbravo.com/legal/obcl.html * or in the legal folder of this module distribution. @@ -144,6 +144,49 @@ modelProperty: 'description', i18nLabel: 'OBPOS_LblDescription', maxLength: 255 + }, { + kind: 'OB.UI.renderComboProperty', + name: 'priceReason', + modelProperty: 'oBPOSPriceModificationReason', + i18nLabel: 'OBPOS_PriceModification', + retrievedPropertyForValue: 'id', + retrievedPropertyForText: '_identifier', + init: function (model) { + this.model = model; + this.collection = new Backbone.Collection(); + this.$.renderCombo.setCollection(this.collection); + var i = 0; + for (i; i < OB.MobileApp.model.get('priceModificationReasons').length; i++) { + model = new Backbone.Model(OB.MobileApp.model.get('priceModificationReasons')[i]); + this.collection.add(model); + } + }, + loadValue: function (inSender, inEvent) { + if (inEvent.modelProperty === this.modelProperty) { + if (inEvent.model.get('oBPOSPriceModificationReason')) { + var i; + for (i = 0; i < OB.MobileApp.model.get('priceModificationReasons').length; i++) { + if (inEvent.model.get('oBPOSPriceModificationReason') === OB.MobileApp.model.get('priceModificationReasons')[i].id) { + this.$.renderCombo.setSelected(i); + break; + } + } + } else { + this.$.renderCombo.setSelected(0); + } + } + }, + applyValue: function (inSender, inEvent) { + inSender.set(this.modelProperty, this.$.renderCombo.getValue()); + return true; + }, + showProperty: function (orderline, callback) { + if (orderline.get('oBPOSPriceModificationReason') && OB.MobileApp.model.get('priceModificationReasons').length > 0) { + callback(true); + } else { + callback(false); + } + } }] }); diff --git a/web/org.openbravo.retail.posterminal/js/model/order.js b/web/org.openbravo.retail.posterminal/js/model/order.js --- a/web/org.openbravo.retail.posterminal/js/model/order.js +++ b/web/org.openbravo.retail.posterminal/js/model/order.js @@ -1259,7 +1259,8 @@ options = args.options || {}; options.setUndo = (_.isUndefined(options.setUndo) || _.isNull(options.setUndo) || options.setUndo !== false) ? true : options.setUndo; - if (!args.line.get('isEditable')) { + var allowModifyVerifyReturnLinePrice = OB.MobileApp.model.hasPermission('OBPOS_ModifyPriceVerifiedReturns', true) && args.line.get('originalDocumentNo') && !args.context.get('isPaid'); + if (!args.line.get('isEditable') && !(allowModifyVerifyReturnLinePrice && args.price < args.line.get('price'))) { OB.UTIL.showError(OB.I18N.getLabel('OBPOS_CannotChangePrice')); } else if (args.line.get('replacedorderline') && args.line.get('qty') < 0) { OB.UTIL.showConfirmation.display(OB.I18N.getLabel('OBMOBC_Error'), OB.I18N.getLabel('OBPOS_CancelReplaceReturnPriceChange')); diff --git a/web/org.openbravo.retail.posterminal/js/pointofsale/model/pointofsale-model.js b/web/org.openbravo.retail.posterminal/js/pointofsale/model/pointofsale-model.js --- a/web/org.openbravo.retail.posterminal/js/pointofsale/model/pointofsale-model.js +++ b/web/org.openbravo.retail.posterminal/js/pointofsale/model/pointofsale-model.js @@ -1182,51 +1182,30 @@ * in backend for audit purposes. */ approvedRequest: function (approved, supervisor, approvalType, callback) { - var order = this.get('order'), - newApprovals = [], - approvals, approval, i, date, callbackFunc, hasPermission = false; + var newApprovals, approvals, approval, i, date, callbackFunc, hasPermission = false, + saveApproval, executeHook, request, me = this; - callbackFunc = function () { - if (enyo.isFunction(callback)) { - callback(approved, supervisor, approvalType); - } - }; + saveApproval = function (order, silent) { + date = new Date().getTime(); + newApprovals = []; - if (_.isArray(approvalType)) { - hasPermission = _.every(approvalType, function (a) { - return OB.MobileApp.model.hasPermission(a, true); - }); - } else if (!OB.UTIL.isNullOrUndefined(approvalType)) { - hasPermission = OB.MobileApp.model.hasPermission(approvalType, true); - } else { - callbackFunc(); - return; - } - if (hasPermission) { - callbackFunc(); - return; - } + approvals = order.get('approvals') || []; + if (!Array.isArray(approvalType)) { + approvalType = [approvalType]; + } - approvals = order.get('approvals') || []; - if (!Array.isArray(approvalType)) { - approvalType = [approvalType]; - } + _.each(approvals, function (appr) { + var results; + results = _.find(approvalType, function (apprType) { + return apprType === appr.approvalType; + }); - _.each(approvals, function (appr) { - var results; - results = _.find(approvalType, function (apprType) { - return apprType === appr.approvalType; + if (_.isUndefined(results)) { + newApprovals.push(appr); + } + }); - if (_.isUndefined(results)) { - newApprovals.push(appr); - } - - }); - - if (approved) { - date = new Date(); - date = date.getTime(); for (i = 0; i < approvalType.length; i++) { approval = { approvalType: approvalType[i], @@ -1235,13 +1214,74 @@ }; newApprovals.push(approval); } - order.set('approvals', newApprovals); - } + order.set('approvals', newApprovals, { + silent: silent + }); + }; + + callbackFunc = function () { + if (enyo.isFunction(callback)) { + callback(approved, supervisor, approvalType); + } + }; + executeHook = function (approvalType, finalCallback) { + OB.UTIL.HookManager.executeHooks('OBPOS_PostRequestApproval_' + approvalType, { + approved: approved, + supervisor: supervisor, + approvalType: approvalType, + callbackApproval: callback, + context: me + }, function (args) { + finalCallback(args); + }); + }; - this.trigger('approvalChecked', { - approved: approved - }); - callbackFunc(); + request = function (args) { + if (_.isArray(approvalType)) { + hasPermission = _.every(approvalType, function (a) { + return OB.MobileApp.model.hasPermission(a, true); + }); + } else if (!OB.UTIL.isNullOrUndefined(approvalType)) { + hasPermission = OB.MobileApp.model.hasPermission(approvalType, true); + } else { + callbackFunc(); + return; + } + if (hasPermission) { + callbackFunc(); + return; + } + + if (approved) { + if (me.get('leftColumnViewManager').isOrder()) { + saveApproval(me.get('order')); + } else { + me.get('multiOrders').get('multiOrdersList').forEach(function (order) { + saveApproval(order, true); + }); + } + } + + me.trigger('approvalChecked', { + approved: approved + }); + callbackFunc(); + }; + + if (_.isArray(approvalType)) { + var afterExecuteHook = _.after(approvalType.length, function (args) { + request(args); + }); + _.each(approvalType, function (type) { + executeHook(type.approval, function (args) { + afterExecuteHook(args); + }); + }); + } else { + executeHook(approvalType, function (args) { + request(args); + }); + } } }); \ No newline at end of file diff --git a/web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js b/web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js --- a/web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js +++ b/web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js @@ -248,27 +248,44 @@ var changePrice = function (keyboardComponent, keyboard, price) { var cancelChange = false; - if (keyboardComponent.selectedModels.length > 1) { - keyboard.receipt.set('undo', null); - keyboard.receipt.set('multipleUndo', true); - _.each(keyboardComponent.selectedModels, function (model) { - if (model.get('replacedorderline') && model.get('qty') < 0) { - cancelChange = true; + + var setPrice = function () { + if (keyboardComponent.selectedModels.length > 1) { + keyboard.receipt.set('undo', null); + keyboard.receipt.set('multipleUndo', true); + _.each(keyboardComponent.selectedModels, function (model) { + if (model.get('replacedorderline') && model.get('qty') < 0) { + cancelChange = true; + } + }); + if (cancelChange) { + OB.UTIL.showConfirmation.display(OB.I18N.getLabel('OBMOBC_Error'), OB.I18N.getLabel('OBPOS_CancelReplaceReturnPriceChange')); + return; + } + _.each(keyboardComponent.selectedModels, function (model) { + keyboard.receipt.setPrice(model, price); + }); + keyboard.receipt.set('multipleUndo', null); + } else { + keyboard.receipt.setPrice(keyboard.line, price); + } + keyboard.receipt.calculateReceipt(); + keyboard.receipt.trigger('scan'); + }; + + if (OB.MobileApp.model.get('priceModificationReasons').length > 0) { + me.doShowPopup({ + popup: 'modalPriceModification', + args: { + callback: setPrice, + selectedModels: me.selectedModels, + receipt: keyboard.receipt, + line: keyboard.line } }); - if (cancelChange) { - OB.UTIL.showConfirmation.display(OB.I18N.getLabel('OBMOBC_Error'), OB.I18N.getLabel('OBPOS_CancelReplaceReturnPriceChange')); - return; - } - _.each(keyboardComponent.selectedModels, function (model) { - keyboard.receipt.setPrice(model, price); - }); - keyboard.receipt.set('multipleUndo', null); } else { - keyboard.receipt.setPrice(keyboard.line, price); + setPrice(); } - keyboard.receipt.calculateReceipt(); - keyboard.receipt.trigger('scan'); }; var changeQuantity = function (keyboardComponent, keyboard, value) { @@ -344,6 +361,18 @@ OB.UTIL.Approval.requestApproval( me.model, 'OBPOS_approval.setPrice', function (approved, supervisor, approvalType) { if (approved) { + var approvals = keyboard.receipt.get('approvals') || [], + approval = { + approvalType: { + approval: 'OBPOS_approval.setPrice', + message: 'OBPOS_approval.setPriceMessage', + params: [keyboard.line.get('product').get('_identifier'), OB.I18N.formatCurrency(keyboard.line.getGross()), OB.I18N.formatCurrency(price)] + }, + userContact: supervisor.get('id'), + created: (new Date()).getTime() + }; + approvals.push(approval); + keyboard.receipt.set('approvals', approvals); changePrice(me, keyboard, price); } }); diff --git a/web/org.openbravo.retail.posterminal/js/pointofsale/view/pointofsale.js b/web/org.openbravo.retail.posterminal/js/pointofsale/view/pointofsale.js --- a/web/org.openbravo.retail.posterminal/js/pointofsale/view/pointofsale.js +++ b/web/org.openbravo.retail.posterminal/js/pointofsale/view/pointofsale.js @@ -186,6 +186,9 @@ kind: 'OB.UI.ModalRejectQuotation', name: 'modalRejectQuotation' }, { + kind: 'OB.UI.ModalPriceModification', + name: 'modalPriceModification' + }, { kind: 'OB.UI.ModalReceiptPropertiesImpl', name: 'receiptPropertiesDialog' }, {

diff --git a/src-test/org/openbravo/test/mobile/core/utils/AllowedErrorsHelper.java b/src-test/org/openbravo/test/mobile/core/utils/AllowedErrorsHelper.java --- a/src-test/org/openbravo/test/mobile/core/utils/AllowedErrorsHelper.java +++ b/src-test/org/openbravo/test/mobile/core/utils/AllowedErrorsHelper.java @@ -457,6 +457,9 @@ // Forgot Password testsAllowedToHaveJavascriptErrors.add("FP090_ForgotPasswordOffline"); + // Price Modification Reason + testsAllowedToHaveJavascriptErrors.add("I38724_AllowPriceModificationVerifiedReturns"); + return testsAllowedToHaveJavascriptErrors; } @@ -501,6 +504,8 @@ javascriptAllowedErrors .add("Failed to load resource: the server responded with a status of 500 (Server Error)"); + javascriptAllowedErrors.add("You cannot change the price of a line from original receipt"); + // ServiceWorkers may trigger this message when a resource fails: javascriptAllowedErrors.add("Error in fetching the application sources"); return javascriptAllowedErrors; @@ -609,6 +614,9 @@ // Forgot Password testsAllowedToHaveLogclientErrors.add("FP090_ForgotPasswordOffline"); + // Price Modification Reason + testsAllowedToHaveLogclientErrors.add("I38724_AllowPriceModificationVerifiedReturns"); + return testsAllowedToHaveLogclientErrors; } diff --git a/src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java b/src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java --- a/src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java +++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java @@ -87,6 +87,10 @@ "theButton_buttonDelete", EnyoKind.BUTTON); // public static TestIdConstructor BUTTON_DELETERECEIPT_CONFIRM = new TestIdConstructor( "bodyButtons_btnModalApplyDelete", EnyoKind.BUTTON); // + public static TestIdConstructor BUTTON_PRICEREASON_CONFIRM = new TestIdConstructor( + "bodyButtons_btnModalPriceModificationAccept", EnyoKind.BUTTON); // + public static TestIdConstructor SELECT_PRICEMODIFICATION_REASON = new TestIdConstructor( + "bodyContent_priceModificationReason", EnyoKind.BUTTON); // public static TestIdConstructor BUTTON_PAY = new TestIdConstructor("theButton_btnTotalToPay", EnyoKind.BUTTON); // public static TestIdConstructor BUTTON_PAY_AMOUNT = new TestIdConstructor( diff --git a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_AllowPriceModificationVerifiedReturns.java b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_AllowPriceModificationVerifiedReturns.java new file mode 100644 --- /dev/null +++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_AllowPriceModificationVerifiedReturns.java @@ -0,0 +1,107 @@ +/* + ************************************************************************* + * The contents of this file are subject to the Openbravo Public License + * Version 1.0 (the "License"), being the Mozilla Public License + * Version 1.1 with a permitted attribution clause; you may not use this + * file except in compliance with the License. You may obtain a copy of + * the License at http://www.openbravo.com/legal/license.html + * Software distributed under the License is distributed on an "AS IS" + * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the + * License for the specific language governing rights and limitations + * under the License. + * The Original Code is Openbravo ERP. + * The Initial Developer of the Original Code is Openbravo S.L.U. + * All portions are Copyright (C) 2018 Openbravo S.L.U. + * All Rights Reserved. + * Contributor(s): + ************************************************************************ + * + * @author GIG + * + */ + +package org.openbravo.test.mobile.retail.pack.selenium.tests.receipts; + +import org.junit.Test; +import org.openbravo.test.mobile.retail.mobilecore.annotations.TestClassAnnotations; +import org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperInsertUpdateOrDelete; +import org.openbravo.test.mobile.retail.mobilecore.javascript.BackboneHelper; +import org.openbravo.test.mobile.retail.mobilecore.utils.RetailUtils; +import org.openbravo.test.mobile.retail.pack.API.WebPOSAPI; +import org.openbravo.test.mobile.retail.pack.selenium.TestIdPack; +import org.openbravo.test.mobile.retail.pack.selenium.terminals.WebPOSTerminalHelper; + +@TestClassAnnotations(isHighVolumeCompatible = true) +public class I38724_AllowPriceModificationVerifiedReturns extends WebPOSTerminalHelper { + + String receiptNo; + private final String preferenceId = RetailUtils.getRandomUUID(); + + @Test + public void test() { + try { + createPriceModificationPreference(); + + reload(); + + final String receiptNo1 = BackboneHelper.getDocumentNo(); + final String customer = get(TestIdPack.BUTTON_RECEIPT_CUSTOMER); + tap(TestIdPack.BUTTON_SEARCH); + write(TestIdPack.FIELD_SEARCH_TEXT, + TestIdPack.BUTTON_SEARCHPRODUCT_BASECAMPLANTERN.getRowName()); + tap(TestIdPack.BUTTON_SEARCH_EXECUTE); + tap(TestIdPack.BUTTON_SEARCHPRODUCT_BASECAMPLANTERN); + verify(TestIdPack.LABEL_TOTALTOPAY, "55.50"); + tap(TestIdPack.BUTTON_PAY); + tap(TestIdPack.BUTTON_PAY_EXACT); + tap(TestIdPack.BUTTON_PAY_DONE); + verify(TestIdPack.LABEL_TOTALTOPAY, "0.00"); + tap(TestIdPack.BUTTON_MENU); + tap(TestIdPack.BUTTON_MENU_VERIFIEDRETURN); + write(TestIdPack.FIELD_VERIFIED_RETURNS_FILTER_TXT, receiptNo1); + tap(TestIdPack.BUTTON_VERIFIEDRETURNS_SEARCH); + verify(TestIdPack.LABEL_VERIFIED_RETURNS_SEARCH_RESULT_ROW1_DOCUMENTNO, receiptNo1); + verify(TestIdPack.LABEL_VERIFIED_RETURNS_SEARCH_RESULT_ROW1_CUSTOMER, customer); + tap(TestIdPack.BUTTON_VERIFIEDRETURNS_ROW1); + verify(TestIdPack.LABEL_POPUP_DOCUMENTNO, receiptNo1); + tap(TestIdPack.BUTTON_VERIFIEDRETURNS_LINES_CHECKROW1); + tap(TestIdPack.BUTTON_POPUP_APPLY); + verify(TestIdPack.LABEL_TOTALTOPAY, "-55.50"); + tap(TestIdPack.BUTTON_EDIT); + WebPOSAPI.tapKeypad(this, 60); + tap(TestIdPack.BUTTON_KEYPAD_PRICE); + verify(TestIdPack.LABEL_TOTALTOPAY, "-55.50"); + tap(TestIdPack.BUTTON_EDIT); + WebPOSAPI.tapKeypad(this, 50); + tap(TestIdPack.BUTTON_KEYPAD_PRICE); + verify(TestIdPack.LABEL_TOTALTOPAY, "-50.00"); + tap(TestIdPack.BUTTON_PAY); + tap(TestIdPack.BUTTON_PAY_EXACT); + tap(TestIdPack.BUTTON_PAY_DONE); + verify(TestIdPack.LABEL_TOTALTOPAY, "0.00"); + } finally { + deletePriceModificationPreference(); + reload(); + } + } + + private void createPriceModificationPreference() { + final String clientId = BackboneHelper.getTerminalValue("client"); + final String prefereceName = "OBPOS_ModifyPriceVerifiedReturns"; + final String adUserId = "3073EDF96A3C42CC86C7069E379522D2"; + + final String SQL = String + .format( + "insert into ad_preference(ad_preference_id, ad_client_id, ad_org_id, createdby, updatedby, value, property, ispropertylist, ad_user_id) " + + "values('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", preferenceId, + clientId, "0", "100", "100", "Y", prefereceName, "Y", adUserId); + + new DatabaseHelperInsertUpdateOrDelete().execute(SQL, 1); + } + + private void deletePriceModificationPreference() { + new DatabaseHelperInsertUpdateOrDelete().execute( + String.format("delete from ad_preference where ad_preference_id = '%s'", preferenceId), 1); + } + +} diff --git a/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_PriceModificationReason.java b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_PriceModificationReason.java new file mode 100644 --- /dev/null +++ b/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_PriceModificationReason.java @@ -0,0 +1,118 @@ +/* + ************************************************************************* + * The contents of this file are subject to the Openbravo Public License + * Version 1.0 (the "License"), being the Mozilla Public License + * Version 1.1 with a permitted attribution clause; you may not use this + * file except in compliance with the License. You may obtain a copy of + * the License at http://www.openbravo.com/legal/license.html + * Software distributed under the License is distributed on an "AS IS" + * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the + * License for the specific language governing rights and limitations + * under the License. + * The Original Code is Openbravo ERP. + * The Initial Developer of the Original Code is Openbravo S.L.U. + * All portions are Copyright (C) 2018 Openbravo S.L.U. + * All Rights Reserved. + * Contributor(s): + ************************************************************************ + * + * @author GIG + * + */ + +package org.openbravo.test.mobile.retail.pack.selenium.tests.receipts; + +import static org.hamcrest.CoreMatchers.equalTo; +import static org.hamcrest.MatcherAssert.assertThat; + +import java.sql.ResultSet; +import java.sql.SQLException; + +import org.junit.Test; +import org.openbravo.test.mobile.retail.extmodules.selenium.TestIdExtModules; +import org.openbravo.test.mobile.retail.mobilecore.annotations.TestClassAnnotations; +import org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperInsertUpdateOrDelete; +import org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect; +import org.openbravo.test.mobile.retail.mobilecore.javascript.BackboneHelper; +import org.openbravo.test.mobile.retail.pack.API.WebPOSAPI; +import org.openbravo.test.mobile.retail.pack.selenium.TestIdPack; +import org.openbravo.test.mobile.retail.pack.selenium.terminals.WebPOSTerminalHelper; + +@TestClassAnnotations(isHighVolumeCompatible = true) +public class I38724_PriceModificationReason extends WebPOSTerminalHelper { + + String receiptNo; + String avalancheKey = "WVG/M0019"; + String cramponsKey = "WVG/M0003"; + + @Test + public void test() { + try { + new DatabaseHelperInsertUpdateOrDelete().execute( + String.format("update obpos_pricereason set isactive = '%s'", "Y"), 2); + + reload(); + + receiptNo = BackboneHelper.getDocumentNo(); + + tap(TestIdExtModules.BUTTON_SEARCH); + write(TestIdExtModules.FIELD_SEARCH_TEXT, avalancheKey); + tap(TestIdExtModules.BUTTON_SEARCH_EXECUTE); + tap(TestIdExtModules.BUTTON_SEARCHPRODUCT_FIRSTROW); + tap(TestIdPack.BUTTON_EDIT); + WebPOSAPI.tapKeypad(this, 50); + tap(TestIdPack.BUTTON_KEYPAD_PRICE); + TestIdPack.SELECT_PRICEMODIFICATION_REASON.enyoNode().executeExtension(".setSelected(0)"); + tap(TestIdPack.BUTTON_PRICEREASON_CONFIRM); + verify(TestIdPack.LABEL_TOTALTOPAY, "50.00"); + + tap(TestIdExtModules.BUTTON_SEARCH); + write(TestIdExtModules.FIELD_SEARCH_TEXT, cramponsKey); + tap(TestIdExtModules.BUTTON_SEARCH_EXECUTE); + tap(TestIdExtModules.BUTTON_SEARCHPRODUCT_FIRSTROW); + tap(TestIdPack.BUTTON_EDIT); + WebPOSAPI.tapKeypad(this, 20); + tap(TestIdPack.BUTTON_KEYPAD_PRICE); + TestIdPack.SELECT_PRICEMODIFICATION_REASON.enyoNode().executeExtension(".setSelected(1)"); + tap(TestIdPack.BUTTON_PRICEREASON_CONFIRM); + verify(TestIdPack.LABEL_TOTALTOPAY, "70.00"); + + tap(TestIdPack.BUTTON_PAY); + tap(TestIdPack.BUTTON_PAY_EXACT); + tap(TestIdPack.BUTTON_PAY_DONE); + verify(TestIdPack.LABEL_TOTALTOPAY, "0.00"); + + // Verify in Backend + final String sql = String + .format( + "SELECT cl.em_obpos_PriceReason_id FROM c_orderline cl " + + "join c_order co on co.c_order_id = cl.c_order_id WHERE co.documentno = '%s' order by line asc", + receiptNo); + new DatabaseHelperSelect() { + private int count = 0; + + @Override + protected void yieldResultSet(final ResultSet rs) throws SQLException { + count++; + final String priceReason = rs.getString("em_obpos_PriceReason_id"); + switch (count) { + case 1: + assertThat(priceReason, equalTo("8279708139F143B8ACAEA907B43E84BA")); + break; + case 2: + assertThat(priceReason, equalTo("96440397D4914547874393CB982B64E0")); + break; + default: + throw new IllegalArgumentException("The returned resulset is missing the assertions"); + } + } + }.execute(sql, 2); + + } finally { + new DatabaseHelperInsertUpdateOrDelete().execute( + String.format("update obpos_pricereason set isactive = '%s'", "N"), 2); + reload(); + } + } + +}

diff --git a/referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml b/referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml --- a/referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml +++ b/referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml @@ -4089,6 +4089,20 @@ </AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS> + <AD_WINDOW_ACCESS_ID><![CDATA[4010E99A3E504FF8B9534CC4BEE7CAC1]]></AD_WINDOW_ACCESS_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_ROLE_ID><![CDATA[463683CFA16C40C0A4EC8CF934114146]]></AD_ROLE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-11 17:30:22.0]]></CREATED> + <CREATEDBY><![CDATA[0]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-11 17:30:22.0]]></UPDATED> + <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <ISREADWRITE><![CDATA[Y]]></ISREADWRITE> +</AD_WINDOW_ACCESS> + +<AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS_ID><![CDATA[403E7B7FD9FC459BBCF649F24963AE73]]></AD_WINDOW_ACCESS_ID> <AD_WINDOW_ID><![CDATA[265]]></AD_WINDOW_ID> <AD_ROLE_ID><![CDATA[9556CBD6CE7E414D9E063701A069318C]]></AD_ROLE_ID> @@ -4229,6 +4243,20 @@ </AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS> + <AD_WINDOW_ACCESS_ID><![CDATA[41B1257A0E0444729B5EC3B2AEF4B7C3]]></AD_WINDOW_ACCESS_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_ROLE_ID><![CDATA[9556CBD6CE7E414D9E063701A069318C]]></AD_ROLE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-11 17:30:22.0]]></CREATED> + <CREATEDBY><![CDATA[0]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-11 17:30:22.0]]></UPDATED> + <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <ISREADWRITE><![CDATA[Y]]></ISREADWRITE> +</AD_WINDOW_ACCESS> + +<AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS_ID><![CDATA[41E42C027499463F92EE6EE99166C748]]></AD_WINDOW_ACCESS_ID> <AD_WINDOW_ID><![CDATA[256]]></AD_WINDOW_ID> <AD_ROLE_ID><![CDATA[5FA11B3DD8F04C0986C774624809C31E]]></AD_ROLE_ID> @@ -9017,6 +9045,20 @@ </AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS> + <AD_WINDOW_ACCESS_ID><![CDATA[89E66B68787A4030830B5FFB47733926]]></AD_WINDOW_ACCESS_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_ROLE_ID><![CDATA[41DAFA0C214D4954A6A9B383AF9A3D96]]></AD_ROLE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-11 17:30:22.0]]></CREATED> + <CREATEDBY><![CDATA[0]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-11 17:30:22.0]]></UPDATED> + <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <ISREADWRITE><![CDATA[Y]]></ISREADWRITE> +</AD_WINDOW_ACCESS> + +<AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS_ID><![CDATA[8A0B811726F942B0AFFDA0C90B3065C0]]></AD_WINDOW_ACCESS_ID> <AD_WINDOW_ID><![CDATA[167]]></AD_WINDOW_ID> <AD_ROLE_ID><![CDATA[41DAFA0C214D4954A6A9B383AF9A3D96]]></AD_ROLE_ID> @@ -12601,6 +12643,20 @@ </AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS> + <AD_WINDOW_ACCESS_ID><![CDATA[BA531B59DE704692811504D1D664230D]]></AD_WINDOW_ACCESS_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_ROLE_ID><![CDATA[D4045F23B4044A39BA2E8BAD707942AF]]></AD_ROLE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-11 17:30:22.0]]></CREATED> + <CREATEDBY><![CDATA[0]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-11 17:30:22.0]]></UPDATED> + <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <ISREADWRITE><![CDATA[Y]]></ISREADWRITE> +</AD_WINDOW_ACCESS> + +<AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS_ID><![CDATA[BA608083E2E04345AFFD0A33DAF56B7F]]></AD_WINDOW_ACCESS_ID> <AD_WINDOW_ID><![CDATA[131]]></AD_WINDOW_ID> <AD_ROLE_ID><![CDATA[463683CFA16C40C0A4EC8CF934114146]]></AD_ROLE_ID> @@ -14449,6 +14505,20 @@ </AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS> + <AD_WINDOW_ACCESS_ID><![CDATA[D382769062CC468ABB268983FEC02B48]]></AD_WINDOW_ACCESS_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_ROLE_ID><![CDATA[5FA11B3DD8F04C0986C774624809C31E]]></AD_ROLE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-11 17:30:22.0]]></CREATED> + <CREATEDBY><![CDATA[0]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-11 17:30:22.0]]></UPDATED> + <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <ISREADWRITE><![CDATA[Y]]></ISREADWRITE> +</AD_WINDOW_ACCESS> + +<AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS_ID><![CDATA[D3BF12306FCF4432A169DB3E940E1708]]></AD_WINDOW_ACCESS_ID> <AD_WINDOW_ID><![CDATA[B917E8A7B0864ACEA9D941E3B7494E53]]></AD_WINDOW_ID> <AD_ROLE_ID><![CDATA[5FA11B3DD8F04C0986C774624809C31E]]></AD_ROLE_ID> @@ -15331,6 +15401,20 @@ </AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS> + <AD_WINDOW_ACCESS_ID><![CDATA[E19E22D5E8D74573862C8BF0016CF905]]></AD_WINDOW_ACCESS_ID> + <AD_WINDOW_ID><![CDATA[7AD43D821D7B4972A108208A899D699A]]></AD_WINDOW_ID> + <AD_ROLE_ID><![CDATA[E717F902C44C455793463450495FF36B]]></AD_ROLE_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2018-10-11 17:30:22.0]]></CREATED> + <CREATEDBY><![CDATA[0]]></CREATEDBY> + <UPDATED><![CDATA[2018-10-11 17:30:22.0]]></UPDATED> + <UPDATEDBY><![CDATA[0]]></UPDATEDBY> + <ISREADWRITE><![CDATA[Y]]></ISREADWRITE> +</AD_WINDOW_ACCESS> + +<AD_WINDOW_ACCESS> <AD_WINDOW_ACCESS_ID><![CDATA[E237F6E688BE461CBE4CBF11B87087AC]]></AD_WINDOW_ACCESS_ID> <AD_WINDOW_ID><![CDATA[6734ACA433314C919BED80D473EA22E7]]></AD_WINDOW_ID> <AD_ROLE_ID><![CDATA[5FA11B3DD8F04C0986C774624809C31E]]></AD_ROLE_ID> diff --git a/referencedata/sampledata/The_White_Valley_Group/OBPOS_PRICEREASON.xml b/referencedata/sampledata/The_White_Valley_Group/OBPOS_PRICEREASON.xml new file mode 100644 --- /dev/null +++ b/referencedata/sampledata/The_White_Valley_Group/OBPOS_PRICEREASON.xml @@ -0,0 +1,29 @@ +<?xml version='1.0' encoding='UTF-8'?> +<data> +<OBPOS_PRICEREASON> + <OBPOS_PRICEREASON_ID><![CDATA[8279708139F143B8ACAEA907B43E84BA]]></OBPOS_PRICEREASON_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[N]]></ISACTIVE> + <CREATED><![CDATA[2018-06-11 07:01:09.634]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-06-11 07:01:23.849]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <NAME><![CDATA[Defective product]]></NAME> + <SEQNO><![CDATA[10]]></SEQNO> +</OBPOS_PRICEREASON> + +<OBPOS_PRICEREASON> + <OBPOS_PRICEREASON_ID><![CDATA[96440397D4914547874393CB982B64E0]]></OBPOS_PRICEREASON_ID> + <AD_CLIENT_ID><![CDATA[39363B0921BB4293B48383844325E84C]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> + <ISACTIVE><![CDATA[N]]></ISACTIVE> + <CREATED><![CDATA[2018-06-11 07:01:20.133]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2018-06-11 07:01:22.298]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <NAME><![CDATA[Commercial reason]]></NAME> + <SEQNO><![CDATA[20]]></SEQNO> +</OBPOS_PRICEREASON> + +</data>

Notes
(0107350) hgbot (developer) 2018-10-17 07:01	Repository: tools/automation/pi-mobile Changeset: d70601a764f2894bc4435084cf8741635266a510 Author: Guillermo Gil <guillermo.gil <at> openbravo.com> Date: Wed Oct 17 06:58:59 2018 +0200 URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/d70601a764f2894bc4435084cf8741635266a510 [^] Related to issue 38724: Added tests for Price Modification Reason --- M src-test/org/openbravo/test/mobile/core/utils/AllowedErrorsHelper.java M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_AllowPriceModificationVerifiedReturns.java A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38724_PriceModificationReason.java ---

(0107351) hgbot (developer) 2018-10-17 07:01	Repository: erp/pmods/org.openbravo.retail.sampledata Changeset: 21fd41fd9fc1938355f4a3d57853bc89ccccf392 Author: Guillermo Gil <guillermo.gil <at> openbravo.com> Date: Wed Oct 17 07:00:41 2018 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/21fd41fd9fc1938355f4a3d57853bc89ccccf392 [^] Related to issue 38724: Added Sampledata for Price Modification --- M referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml A referencedata/sampledata/The_White_Valley_Group/OBPOS_PRICEREASON.xml ---

(0107352) hgbot (developer) 2018-10-17 07:01	Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: fec7e877be463eb59a2e482cdb0d349d0c99347b Author: Guillermo Gil <guillermo.gil <at> openbravo.com> Date: Wed Oct 17 07:01:28 2018 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fec7e877be463eb59a2e482cdb0d349d0c99347b [^] Fixed Issue 38724: Price Modification Project Added tablaes to show Price Modification Added the possibility to modify the price of a verified return --- M src-db/database/model/modifiedTables/C_ORDERLINE.xml M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_DATASET_TABLE.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src-db/database/sourcedata/AD_MENU.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src-db/database/sourcedata/AD_PREFERENCE.xml M src-db/database/sourcedata/AD_REFERENCE.xml M src-db/database/sourcedata/AD_REF_LIST.xml M src-db/database/sourcedata/AD_REF_TABLE.xml M src-db/database/sourcedata/AD_TAB.xml M src-db/database/sourcedata/AD_TABLE.xml M src-db/database/sourcedata/AD_TREENODE.xml M src-db/database/sourcedata/AD_WINDOW.xml M src-db/database/sourcedata/OBMOBC_SERVICES.xml M src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java M web/org.openbravo.retail.posterminal/css/obpos-main.css M web/org.openbravo.retail.posterminal/js/components/modalreceiptlineproperties.js M web/org.openbravo.retail.posterminal/js/model/order.js M web/org.openbravo.retail.posterminal/js/pointofsale/model/pointofsale-model.js M web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js M web/org.openbravo.retail.posterminal/js/pointofsale/view/pointofsale.js A src-db/database/model/tables/OBPOS_PRICEREASON.xml A src/org/openbravo/retail/posterminal/term/PriceModificationReason.java A web/org.openbravo.retail.posterminal/js/components/modalPriceModification.js ---

Issue History
Date Modified	Username	Field	Change
2018-06-08 06:39	guillermogil	New Issue
2018-06-08 06:39	guillermogil	Assigned To	=> guillermogil
2018-06-08 06:39	guillermogil	Triggers an Emergency Pack	=> No
2018-06-08 06:40	guillermogil	File Added: issue38724.diff
2018-06-08 09:10	guillermogil	File Deleted: issue38724.diff
2018-06-08 09:10	guillermogil	File Added: issue38724.diff
2018-06-08 11:48	guillermogil	File Deleted: issue38724.diff
2018-06-08 11:48	guillermogil	File Added: issue38724.diff
2018-06-11 07:09	guillermogil	File Deleted: issue38724.diff
2018-06-11 07:10	guillermogil	File Added: issue38724.diff
2018-06-11 07:10	guillermogil	File Added: sampleData.diff
2018-06-11 08:56	guillermogil	File Added: testPriceReason.diff
2018-06-11 10:25	guillermogil	Description Updated	View Revisions
2018-07-02 15:28	guillermogil	File Added: approvalHook.diff
2018-10-09 14:43	guillermogil	File Added: issue0038724Final.diff
2018-10-11 07:42	guillermogil	File Deleted: issue38724.diff
2018-10-11 07:42	guillermogil	File Deleted: approvalHook.diff
2018-10-11 07:42	guillermogil	File Deleted: issue0038724Final.diff
2018-10-11 07:42	guillermogil	File Added: 38724.diff
2018-10-11 08:09	guillermogil	File Deleted: testPriceReason.diff
2018-10-11 08:10	guillermogil	File Added: tests.diff
2018-10-11 09:17	guillermogil	File Deleted: tests.diff
2018-10-11 09:17	guillermogil	File Added: tests
2018-10-11 11:01	guillermogil	File Deleted: tests
2018-10-11 11:01	guillermogil	File Deleted: 38724.diff
2018-10-11 11:01	guillermogil	File Added: 38724.diff
2018-10-11 11:01	guillermogil	File Added: tests
2018-10-11 11:42	guillermogil	File Deleted: 38724.diff
2018-10-11 11:42	guillermogil	File Added: 38724.diff
2018-10-16 07:16	guillermogil	File Added: PriceModificationReason.diff
2018-10-16 07:16	guillermogil	File Added: TestPriceModificationReason.diff
2018-10-16 07:16	guillermogil	File Added: SampledataPriceModificationReason.diff
2018-10-16 07:16	guillermogil	File Deleted: sampleData.diff
2018-10-16 07:17	guillermogil	File Deleted: tests
2018-10-16 07:17	guillermogil	File Deleted: 38724.diff
2018-10-17 07:01	hgbot	Checkin
2018-10-17 07:01	hgbot	Note Added: 0107350
2018-10-17 07:01	hgbot	Checkin
2018-10-17 07:01	hgbot	Note Added: 0107351
2018-10-17 07:01	hgbot	Checkin
2018-10-17 07:01	hgbot	Note Added: 0107352
2018-10-17 07:01	hgbot	Status	new => resolved
2018-10-17 07:01	hgbot	Resolution	open => fixed
2018-10-17 07:01	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fec7e877be463eb59a2e482cdb0d349d0c99347b [^]
2018-10-17 07:02	guillermogil	Review Assigned To	=> jorge-garcia
2018-10-29 11:35	marvintm	Status	resolved => closed
2018-10-29 11:35	marvintm	Fixed in Version	=> RR19Q1
2019-01-10 15:59	guillermogil	Relationship added	related to 0039917