diff --git a/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml b/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml--- a/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml+++ b/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml@@ -18,7 +18,7 @@ <foreign-key foreignTable="AD_ORG" name="AD_ORG_C_ACCTSCHEMA_TAB_DOC"> <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> </foreign-key>- <check name="C_ACCTSCH_TA_DOC_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>- <check name="C_ACCTSCH_TA_DOC_WNEGATIVE_CHECK"><![CDATA[ALLOWNEGATIVE IN ('Y', 'N')]]></check>+ <check name="C_ACCTSCH_TA_DO_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>+ <check name="C_ACCTSCH_TA_DO_NEGATIVE_CHECK"><![CDATA[ALLOWNEGATIVE IN ('Y', 'N')]]></check> </table> </database>diff --git a/database/sourcedata/AD_COLUMN.xml b/database/sourcedata/AD_COLUMN.xml--- a/database/sourcedata/AD_COLUMN.xml+++ b/database/sourcedata/AD_COLUMN.xml@@ -10794,7 +10794,7 @@ <HELP><![CDATA[Development Status defines the status of a table or a column. Ready means that this object is in use, Not Implemented Yet indicates that currently it is not in use but it is planned to be implemented and Deprecated are the objects that are going to be removed from the application in future versions.]]></HELP> </AD_COLUMN> <AD_COLUMN AD_COLUMN_ID="803867" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-05-15 12:26:23.0" UPDATED="2007-06-27 17:39:19.0" CREATEDBY="0" UPDATEDBY="0" NAME="JR Template name" HELP="Defines the name (including the extension) of the main tamplate (jrxml file) of the Jasper Report." VERSION="1" ENTITYTYPE="D" COLUMNNAME="Jrname" AD_TABLE_ID="284" AD_REFERENCE_ID="14" FIELDLENGTH="256" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="21" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800811" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />- <AD_COLUMN AD_COLUMN_ID="803868" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-05-15 12:26:23.0" UPDATED="2008-08-18 19:05:52.0" CREATEDBY="0" UPDATEDBY="100" NAME="Jasper Report" HELP="Defines that the report is a jasper report." VERSION="1" ENTITYTYPE="D" COLUMNNAME="IsJasper" AD_TABLE_ID="284" AD_REFERENCE_ID="20" FIELDLENGTH="1" DEFAULTVALUE="N" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="31" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800810" ISSYNCDATABASE="N" ISSESSIONATTR="Y" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />+ <AD_COLUMN AD_COLUMN_ID="803868" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-05-15 12:26:23.0" UPDATED="2009-06-03 18:16:19.0" CREATEDBY="0" UPDATEDBY="100" NAME="Jasper Report" HELP="
Defines that the report is a jasper report." VERSION="1" ENTITYTYPE="D" COLUMNNAME="IsJasper" AD_TABLE_ID="284" AD_REFERENCE_ID="20" FIELDLENGTH="1" DEFAULTVALUE="N" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="31" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800810" ISSYNCDATABASE="N" ISSESSIONATTR="Y" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" /> <AD_COLUMN AD_COLUMN_ID="803869" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-05-21 17:23:21.0" UPDATED="2007-06-15 15:24:59.0" CREATEDBY="0" UPDATEDBY="100" NAME="Send EMail" DESCRIPTION="Enable sending Document EMail" HELP="Send emails with document attached (e.g. Invoice, Delivery Note, etc.)" VERSION="1" ENTITYTYPE="D" COLUMNNAME="Sendemail" AD_TABLE_ID="592" AD_REFERENCE_ID="20" FIELDLENGTH="1" DEFAULTVALUE="N" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="130" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="1978" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" /> <AD_COLUMN AD_COLUMN_ID="803870" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-19 13:01:32.0" UPDATED="2007-06-19 16:43:07.0" CREATEDBY="0" UPDATEDBY="100" NAME="Default Client" DESCRIPTION="Default Session Client" HELP="Client that user will use by default when is logged" VERSION="1" ENTITYTYPE="D" COLUMNNAME="Default_Ad_Client_ID" AD_TABLE_ID="114" AD_REFERENCE_ID="18" AD_REFERENCE_VALUE_ID="129" AD_VAL_RULE_ID="800022" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="41" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800814" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" /> <AD_COLUMN AD_COLUMN_ID="803871" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-06-19 13:01:32.0" UPDATED="2007-06-19 18:03:11.0" CREATEDBY="0" UPDATEDBY="100" NAME="Default Organization" DESCRIPTION="Default Organization" HELP="Default organization when the user login" VERSION="1" ENTITYTYPE="D" COLUMNNAME="Default_Ad_Org_ID" AD_TABLE_ID="114" AD_REFERENCE_ID="18" AD_REFERENCE_VALUE_ID="276" AD_VAL_RULE_ID="800023" FIELDLENGTH="12" ISKEY="N" ISPARENT="N" ISMANDATORY="N" ISUPDATEABLE="Y" ISIDENTIFIER="N" SEQNO="51" ISTRANSLATED="N" ISENCRYPTED="N" ISSELECTIONCOLUMN="N" AD_ELEMENT_ID="800817" ISSYNCDATABASE="N" ISSESSIONATTR="N" ISSECONDARYKEY="N" ISDESENCRYPTABLE="N" DEVELOPMENTSTATUS="RE" />diff --git a/database/sourcedata/AD_FIELD.xml b/database/sourcedata/AD_FIELD.xml--- a/database/sourcedata/AD_FIELD.xml+++ b/database/sourcedata/AD_FIELD.xml@@ -1291,10 +1291,10 @@ <AD_FIELD AD_FIELD_ID="2190" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2006-03-22 09:29:32.0" UPDATEDBY="100" NAME="Name" DESCRIPTION="A identifier for a document which can be used as a search tool." HELP="The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in lenght." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="2960" ISDISPLAYED="Y" DISPLAYLENGTH="60" ISREADONLY="Y" SEQNO="40" SORTNO="1" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="N" /> <AD_FIELD AD_FIELD_ID="2191" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2006-03-22 09:29:32.0" UPDATEDBY="100" NAME="Phone" DESCRIPTION="A telephone number for a specified business partner." HELP="The Phone field identifies a telephone number" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="2964" ISDISPLAYED="Y" DISPLAYLENGTH="13" ISREADONLY="N" SEQNO="70" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" /> <AD_FIELD AD_FIELD_ID="2192" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2006-03-22 09:29:32.0" UPDATEDBY="100" NAME="Alternative Phone" DESCRIPTION="A second contact telephone number for a business partner." HELP="
The 2nd Phone field identifies an alternate telephone number." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="2965" ISDISPLAYED="Y" DISPLAYLENGTH="20" ISREADONLY="N" SEQNO="80" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="N" />- <AD_FIELD AD_FIELD_ID="2193" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:06:58.489249" UPDATEDBY="100" NAME="Bill to Address" DESCRIPTION="Indicates that this address is the Bill to Address" HELP="The Bill to Address checkbox indicates if this location is the Bill to Address for this Business Partner" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3090" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="110" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />- <AD_FIELD AD_FIELD_ID="2194" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:07:13.47724" UPDATEDBY="100" NAME="Pay from Address" DESCRIPTION="Business Partner pays from that address and we'll send dunning letters there" HELP="The Pay From Address checkbox indicates if this location is the address the Business Partner pays from." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3092" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="120" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />- <AD_FIELD AD_FIELD_ID="2195" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:07:29.687848" UPDATEDBY="100" NAME="Remit to Address" DESCRIPTION="Address we send payments to" HELP="The Remit to Address checkbox indicates if this location is the address to which we should send payments to this Business Partner." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3093" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="130" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />- <AD_FIELD AD_FIELD_ID="2196" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:06:43.516215" UPDATEDBY="100" NAME="Ship to Address" DESCRIPTION="Business Partner address to ship goods to" HELP="The Ship to Address checkbox indicates if this location is the address to use when shipping orders to this Business Partner." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3091" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="100" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />+ <AD_FIELD AD_FIELD_ID="2193" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:06:58.0" UPDATEDBY="100" NAME="Bill to Address" DESCRIPTION="Indicates that this address is the Bill to Address" HELP="The Bill to Address checkbox indicates if this location is the Bill to Address for this Business Partner" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3090" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="110" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />+ <AD_FIELD AD_FIELD_ID="2194" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:07:13.0" UPDATEDBY="100" NAME="Pay from Address" DESCRIPTION="Business Partner pays from that address and we'll send dunning letters there" HELP="The Pay From Address checkbox indicates if this location is the address the Business Partner pays from." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3092" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="120" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />+ <AD_FIELD AD_FIELD_ID="2195" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:07:29.0" UPDATEDBY="100" NAME="Remit to Address" DESCRIPTION="Address we send payments to" HELP="The Remit to Address checkbox indicates if this location is the address to which we should send payments to this Business Partner." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3093" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="130" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />+ <AD_FIELD AD_FIELD_ID="2196" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2009-03-26 20:06:43.0" UPDATEDBY="100" NAME="Ship to Address" DESCRIPTION="Business Partner address to ship goods to" HELP="The Ship to Address checkbox indicates if this location is the address to use when shipping orders to this Business Partner." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="222" AD_COLUMN_ID="3091" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="100" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" /> <AD_FIELD AD_FIELD_ID="2197" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2004-12-20 20:59:57.0" UPDATEDBY="100" NAME="Account No." DESCRIPTION="Account Number" HELP="The Account Number indicates the Number assigned to this account" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="226" AD_COLUMN_ID="3105" ISDISPLAYED="Y" DISPLAYLOGIC="@IsACH@='Y'" DISPLAYLENGTH="30" ISREADONLY="N" SEQNO="80" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" /> <AD_FIELD AD_FIELD_ID="2198" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2004-12-20 20:59:57.0" UPDATEDBY="100" NAME="Client" DESCRIPTION="Client for this installation." HELP="A Client is a company or a legal entity. You cannot share data between Clients." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="226" AD_COLUMN_ID="3095" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="N" SEQNO="10" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="N" /> <AD_FIELD AD_FIELD_ID="2199" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="1999-12-04 21:54:10.0" CREATEDBY="0" UPDATED="2004-12-20 20:59:57.0" UPDATEDBY="100" NAME="Organization" DESCRIPTION="Organizational entity within client" HELP="An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="226" AD_COLUMN_ID="3096" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="N" SEQNO="20" ISSAMELINE="Y" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="N" />@@ -2692,7 +2692,7 @@ <AD_FIELD AD_FIELD_ID="3913" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-12-18 22:13:52.0" CREATEDBY="0" UPDATED="2007-06-27 17:39:18.0" UPDATEDBY="0" NAME="Accounting Schema" DESCRIPTION="The structure used in accounting including costing methods, currencies, and the calendar." HELP="An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar" ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="323" AD_COLUMN_ID="4973" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="Y" SEQNO="40" SORTNO="1" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" /> <AD_FIELD AD_FIELD_ID="3914" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-12-18 22:13:52.0" CREATEDBY="0" UPDATED="2006-06-16 11:17:59.0" UPDATEDBY="100" NAME="Business Partner Category" DESCRIPTION="A classification of business partners based on defined similarities." HELP="The Business Partner Group ID provides a method of defining defaults to be used for individual Business Partners." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="323" AD_COLUMN_ID="4974" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="Y" SEQNO="30" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" /> <AD_FIELD AD_FIELD_ID="3915" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="N" CREATED="2000-12-18 22:13:52.0" CREATEDBY="0" UPDATED="2006-06-16 11:17:59.0" UPDATEDBY="100" NAME="Customer Prepayment" DESCRIPTION="x not implemented" HELP="The Customer Prepayment account indicates the account to be used for recording prepayments from a customer." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="323" AD_COLUMN_ID="4983" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="N" SEQNO="70" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />- <AD_FIELD AD_FIELD_ID="3916" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-12-18 22:13:52.0" CREATEDBY="0" UPDATED="2009-02-02 16:02:50.083161" UPDATEDBY="100" NAME="Customer Receivables No." DESCRIPTION="An account number in the general ledger to mark transactions with a business partner." HELP="The Customer Receivables Accounts indicates the account to be used for recording transaction for customers receivables." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="323" AD_COLUMN_ID="4982" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="N" SEQNO="60" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" />+ <AD_FIELD AD_FIELD_ID="3916" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-12-18 22:13:52.0" CREATEDBY="0" UPDATED="2009-02-02 16:02:50.0" UPDATEDBY="100" NAME="Customer Receivables No." DESCRIPTION="An account number in the general ledger to mark transactions with a business partner." HELP="The Customer Receivables Accounts indicates the account to be used for recording transaction for customers receivables." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="323" AD_COLUMN_ID="4982" ISDISPLAYED="Y" DISPLAYLENGTH="44" ISREADONLY="N" SEQNO="60" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y" /> <AD_FIELD AD_FIELD_ID="3918" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2000-12-18 22:13:52.0" CREATEDBY="0" UPDATED="2006-06-16 11:17:59.0" UPDATEDBY="100" NAME="Active" DESCRIPTION="A flag indicating whether this record is available for use or de-activated." ISCENTRALLYMAINTAINED="Y" AD_TAB_ID="323" AD_COLUMN_ID="4977" ISDISPLAYED="Y" DISPLAYLENGTH="1" ISREADONLY="N" SEQNO="50" ISSAMELINE="N" ISHEADING="N" ISFIELDONLY="N" ISENCRYPTED="N" ENTITYTYPE="D" SHOWINRELATION="Y"> <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 reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.]]></HELP> </AD_FIELD>diff --git a/database/sourcedata/AD_MESSAGE.xml b/database/sourcedata/AD_MESSAGE.xml--- a/database/sourcedata/AD_MESSAGE.xml+++ b/database/sourcedata/AD_MESSAGE.xml@@ -5495,8 +5495,8 @@ <AD_MESSAGE AD_MESSAGE_ID="1000600011" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 19:39:38.0" CREATEDBY="100" UPDATED="2007-10-21 19:39:38.0" UPDATEDBY="100" VALUE="CreateDocumentTypesFailed" MSGTEXT="Create document types process failed" MSGTYPE="E" ENTITYTYPE="U" /> <AD_MESSAGE AD_MESSAGE_ID="1000600012" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 19:40:41.0" CREATEDBY="100" UPDATED="2007-10-21 19:40:41.0" UPDATEDBY="100" VALUE="CreateMasterDataFailed" MSGTEXT="Create master data process failed" MSGTYPE="E" ENTITYTYPE="U" /> <AD_MESSAGE AD_MESSAGE_ID="1000600013" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 21:13:29.0" CREATEDBY="100" UPDATED="2007-10-21 21:13:29.0" UPDATEDBY="100" VALUE="MissingCashFlowStatements" MSGTEXT="There are missing cash flow statements. You should execute "Create cash flow statement" before running the report.
" MSGTYPE="E" ENTITYTYPE="U" />- <AD_MESSAGE AD_MESSAGE_ID="1000600014" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:36:32.689225" CREATEDBY="100" UPDATED="2009-02-27 13:36:32.689225" UPDATEDBY="100" VALUE="ManualDebtpayment" MSGTEXT="The manual payment" MSGTYPE="E" ENTITYTYPE="U" />- <AD_MESSAGE AD_MESSAGE_ID="1000600015" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:37:02.588627" CREATEDBY="100" UPDATED="2009-02-27 13:37:02.588627" UPDATEDBY="100" VALUE="CanNotBeSplit" MSGTEXT="can not be split, as it may cause inconsistent data in accounting. Please, reactivate the manual settlement were it was created and split it there.
" MSGTYPE="E" ENTITYTYPE="U" />+ <AD_MESSAGE AD_MESSAGE_ID="1000600014" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:36:32.0" CREATEDBY="100" UPDATED="2009-02-27 13:36:32.0" UPDATEDBY="100" VALUE="ManualDebtpayment" MSGTEXT="The manual payment" MSGTYPE="E" ENTITYTYPE="U" />+ <AD_MESSAGE AD_MESSAGE_ID="1000600015" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:37:02.0" CREATEDBY="100" UPDATED="2009-02-27 13:37:02.0" UPDATEDBY="100" VALUE="CanNotBeSplit" MSGTEXT="can not be split, as it may cause inconsistent data in accounting. Please, reactivate the manual settlement were it was created and split it there.
" MSGTYPE="E" ENTITYTYPE="U" /> <AD_MESSAGE AD_MESSAGE_ID="1001300000" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-12-02 11:23:58.0" CREATEDBY="100" UPDATED="2008-12-02 11:23:58.0" UPDATEDBY="100" VALUE="CodeBankBPErrorMultiple" MSGTEXT="has associated more than one bank accounts. Please deactivate all his bank accounts but the one to be used for the remittance." MSGTYPE="E" ENTITYTYPE="U" /> <!-- ************************diff --git a/database/sourcedata/AD_MESSAGE_TRL.xml b/database/sourcedata/AD_MESSAGE_TRL.xml--- a/database/sourcedata/AD_MESSAGE_TRL.xml+++ b/database/sourcedata/AD_MESSAGE_TRL.xml@@ -5494,8 +5494,8 @@ <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600011" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 19:39:38.0" CREATEDBY="100" UPDATED="2007-10-21 19:40:05.0" UPDATEDBY="100" MSGTEXT="La creación de los tipos de documentos fallo durante la ejecución" ISTRANSLATED="Y" /> <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600012" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 19:40:41.0" CREATEDBY="100" UPDATED="2007-10-21 19:41:04.0" UPDATEDBY="100" MSGTEXT="La creación de los datos maestros fallo durante la ejecución" ISTRANSLATED="Y" /> <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600013" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-10-21 21:13:29.0" CREATEDBY="100" UPDATED="2007-10-21 21:14:42.0" UPDATEDBY="100" MSGTEXT="Faltan datos para calcular el informe. Por favor ejecute el proceso "Generar cash flow statement" antes de lanzar el informe." ISTRANSLATED="Y" />- <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600014" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:36:32.689225" CREATEDBY="100" UPDATED="2009-02-27 16:17:57.559556" UPDATEDBY="100" MSGTEXT="El efecto manual" ISTRANSLATED="Y" />- <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600015" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:37:02.588627" CREATEDBY="100" UPDATED="2009-02-27 16:22:46.754889" UPDATEDBY="100" MSGTEXT="can not be split, as it may cause inconsistent data in accounting. Please, reactivate the manual settlement were it was created and split it there.
" MSGTIP="no puede ser dividido ya que esto puede crear inconsistencia en los datos contables. Por favor, reactive la liquidacion manual donde fue creado y divídalo allí." ISTRANSLATED="Y" />+ <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600014" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:36:32.0" CREATEDBY="100" UPDATED="2009-02-27 16:17:57.0" UPDATEDBY="100" MSGTEXT="El efecto manual" ISTRANSLATED="Y" />+ <AD_MESSAGE_TRL AD_MESSAGE_ID="1000600015" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2009-02-27 13:37:02.0" CREATEDBY="100" UPDATED="2009-02-27 16:22:46.0" UPDATEDBY="100" MSGTEXT="can not be split, as it may cause inconsistent data in accounting. Please, reactivate the manual settlement were it was created and split it there.
" MSGTIP="no puede ser dividido ya que esto puede crear inconsistencia en los datos contables. Por favor, reactive la liquidacion manual donde fue creado y divídalo allí." ISTRANSLATED="Y" /> <AD_MESSAGE_TRL AD_MESSAGE_ID="1001300000" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2008-12-02 11:23:58.0" CREATEDBY="100" UPDATED="2008-12-02 12:06:48.0" UPDATEDBY="100" MSGTEXT="tiene asociada más de una cuenta bancaria. Desactive, por favor, todas sus cuentas bancarias, excepto aquella que quiera usar en la remesa." ISTRANSLATED="Y" /> <!-- ************************diff --git a/database/sourcedata/AD_TEXTINTERFACES.xml b/database/sourcedata/AD_TEXTINTERFACES.xml--- a/database/sourcedata/AD_TEXTINTERFACES.xml+++ b/database/sourcedata/AD_TEXTINTERFACES.xml@@ -1307,7 +1307,7 @@ <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808480" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:22:30.0" CREATEDBY="0" UPDATED="2008-01-04 10:20:01.0" UPDATEDBY="0" TEXT="By Descending Quantity" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR.html" ISUSED="Y" /> <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808481" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:22:48.0" CREATEDBY="0" UPDATED="2008-01-04 10:20:35.0" UPDATEDBY="0" TEXT="Explode: phases:" FILENAME="/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml" ISUSED="Y" /> <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808482" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:22:48.0" CREATEDBY="0" UPDATED="2008-01-04 10:20:35.0" UPDATEDBY="0" TEXT="Secuence:" FILENAME="/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml" ISUSED="Y" />- <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808483" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:23:02.0" CREATEDBY="0" UPDATED="2008-01-04 10:21:14.0" UPDATEDBY="0" TEXT="Cutomer:" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml" ISUSED="Y" />+ <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808483" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:23:02.0" CREATEDBY="0" UPDATED="2008-01-04 10:21:14.0" UPDATEDBY="0" TEXT="Cutomer:" FILENAME="/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml" ISUSED="N" /> <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808484" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:23:02.0" CREATEDBY="0" UPDATED="2008-01-04 10:21:14.0" UPDATEDBY="0" TEXT="Acct. No." FILENAME="/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml" ISUSED="Y" /> <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808487" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:23:02.0" CREATEDBY="0" UPDATED="2008-01-04 10:22:10.0" UPDATEDBY="0" TEXT="Printed on" ISUSED="Y" /> <AD_TEXTINTERFACES AD_TEXTINTERFACES_ID="808488" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2007-07-10 19:23:02.0" CREATEDBY="0" UPDATED="2008-01-04 10:21:36.0" UPDATEDBY="0" TEXT="other footer data" ISUSED="Y" />