details: https://code.openbravo.com/erp/devel/pi/rev/ae1ff625dc0f changeset: 13161:ae1ff625dc0f user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Fri Jul 15 10:04:47 2011 +0200 summary: Fixed issue 17895.Adds accounting view for financial account.
details: https://code.openbravo.com/erp/devel/pi/rev/03cffbd6c056 changeset: 13162:03cffbd6c056 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Fri Jul 15 11:36:40 2011 +0200 summary: Fixed issue 17898.Added accounting dimensions to GL Journal lines. details: https://code.openbravo.com/erp/devel/pi/rev/cc5c3490dc5b changeset: 13163:cc5c3490dc5b user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Fri Jul 15 11:48:55 2011 +0200 summary: merge details: https://code.openbravo.com/erp/devel/pi/rev/5133dc2e3407 changeset: 13164:5133dc2e3407 user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> date: Fri Jul 15 11:50:11 2011 +0200 summary: merge diffstat: modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml | 16 +- modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/AD_ORGINFO.xml | 9 + modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRX_FULL_ACCT_V.xml | 26 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml | 1697 +++++++++- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml | 26 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml | 1225 +++++++- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml | 14 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REF_LIST.xml | 24 + modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml | 34 +- modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml | 23 + modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java | 7 +- modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_Utility.java | 38 + src-db/database/model/tables/GL_JOURNALLINE.xml | 50 + src-db/database/sourcedata/AD_COLUMN.xml | 277 +- src-db/database/sourcedata/AD_FIELD.xml | 224 +- src-db/database/sourcedata/AD_TEXTINTERFACES.xml | 77 + src/org/openbravo/erpCommon/ad_forms/DocLineGLJournal_data.xsql | 11 +- 17 files changed, 3760 insertions(+), 18 deletions(-) diffs (truncated from 4537 to 300 lines): diff -r 047e3c5c51ab -r 5133dc2e3407 modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml Fri Jul 15 09:34:32 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml Fri Jul 15 11:50:11 2011 +0200 @@ -47,6 +47,7 @@ v_TotalLines NUMBER; v_PaymentMethod C_INVOICE.FIN_PAYMENTMETHOD_ID%TYPE; v_documentno C_INVOICE.DocumentNo%TYPE; +v_poreference C_INVOICE.POReference%TYPE; v_project_id c_invoice.c_project_id%TYPE; v_campaign_id c_invoice.c_campaign_id%TYPE; v_activity_id c_invoice.c_activity_id%TYPE; @@ -71,6 +72,7 @@ v_finpayment_desc FIN_Payment.Description%TYPE; v_orderno_trl AD_Message.MsgText%TYPE; v_invoiceno_trl AD_Message.MsgText%TYPE; +v_payment_desc AD_OrgInfo.em_aprm_payment_desc%TYPE; TYPE RECORD IS REF CURSOR; @@ -107,12 +109,12 @@ SELECT ad_client_id, ad_org_id, c_doctypetarget_id, IsSOTrx, grandtotal, C_PaymentTerm_ID, PaymentRule, C_Currency_ID, C_BPartner_ID, DateInvoiced, totallines, fin_paymentmethod_id, - fin_payment_priority_id, documentNo, + fin_payment_priority_id, documentNo, poreference, c_project_id, c_campaign_id, c_activity_id, user1_id, user2_id INTO v_Client_ID, v_Org_ID, v_DocTypeTarget_ID, v_IsSOTrx, v_GrandTotal, v_PaymentTerm, v_PaymentRule, v_Currency_ID, v_BPartner_ID, v_DateInvoiced, v_totallines, v_PaymentMethod, - v_PaymentPriority, v_documentno, + v_PaymentPriority, v_documentno, v_poreference, v_project_id, v_campaign_id, v_activity_id, v_user1, v_user2 FROM c_invoice WHERE c_invoice_id=p_record_id; @@ -501,6 +503,16 @@ FROM C_BPARTNER WHERE C_BPARTNER_ID = v_BPartner_ID; IF(v_Financial_Account_ID IS NOT NULL) THEN + SELECT MIN(em_aprm_payment_desc) INTO v_payment_desc + FROM ad_orginfo + WHERE ad_org_id = v_Org_ID + AND isactive = 'Y'; + + IF (v_payment_desc IS NOT NULL AND v_payment_desc='Supplier Reference' + AND coalesce(length(v_poreference), 0)>0) THEN + v_documentno := v_poreference; + END IF; + FOR cur_paymentschedule IN ( SELECT ps.fin_paymentmethod_id, ps.duedate, ps.c_currency_id, ps.ad_org_id, ps.fin_payment_schedule_id, coalesce(sum(psd.amount),0) as outstandingamt, psd.fin_payment_schedule_order diff -r 047e3c5c51ab -r 5133dc2e3407 modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/AD_ORGINFO.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/AD_ORGINFO.xml Fri Jul 15 11:50:11 2011 +0200 @@ -0,0 +1,9 @@ +<?xml version="1.0"?> + <database name="MODIFIED TABLE AD_ORGINFO"> + <table name="AD_ORGINFO" primaryKey="AD_ORGINFO_KEY"> + <column name="EM_APRM_PAYMENT_DESC" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false"> + <default><![CDATA[Invoice Document Number]]></default> + <onCreateDefault><![CDATA['Invoice Document Number']]></onCreateDefault> + </column> + </table> + </database> diff -r 047e3c5c51ab -r 5133dc2e3407 modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRX_FULL_ACCT_V.xml --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRX_FULL_ACCT_V.xml Fri Jul 15 11:50:11 2011 +0200 @@ -0,0 +1,26 @@ +<?xml version="1.0"?> + <database name="VIEW APRM_FINACC_TRX_FULL_ACCT_V"> + <view name="APRM_FINACC_TRX_FULL_ACCT_V"><![CDATA[SELECT fact_acct.fact_acct_id AS aprm_finacc_trx_full_acct_v_id, fact_acct.ad_client_id, fact_acct.ad_org_id, fact_acct.isactive, fact_acct.created, fact_acct.createdby, fact_acct.updated, fact_acct.updatedby, fact_acct.c_acctschema_id, fact_acct.account_id AS c_elementvalue_id, fact_acct.datetrx, fact_acct.dateacct, fact_acct.c_period_id, fact_acct.ad_table_id, +CASE +WHEN fact_acct.ad_table_id = '4D8C3B3C31D1410DA046140C9F024D17' THEN fact_acct.record_id +ELSE fact_acct.line_id +END AS fin_finacc_transaction_id, +CASE +WHEN fact_acct.ad_table_id = '4D8C3B3C31D1410DA046140C9F024D17' THEN NULL +ELSE fact_acct.record_id +END AS fin_reconciliation_id, +CASE +WHEN fact_acct.ad_table_id = '4D8C3B3C31D1410DA046140C9F024D17' THEN NULL +ELSE (SELECT fin_bankstatementline.fin_bankstatement_id +FROM fin_bankstatementline +WHERE fin_bankstatementline.fin_finacc_transaction_id = fact_acct.line_id) +END AS fin_bankstatement_id, +CASE +WHEN fact_acct.ad_table_id = '4D8C3B3C31D1410DA046140C9F024D17' THEN NULL +ELSE (SELECT fin_bankstatementline.line +FROM fin_bankstatementline +WHERE fin_bankstatementline.fin_finacc_transaction_id = fact_acct.line_id) +END AS line, fin_finacc_transaction.fin_financial_account_id, fact_acct.gl_category_id, fact_acct.c_tax_id, fact_acct.m_locator_id, fact_acct.postingtype, fact_acct.c_currency_id, fact_acct.amtsourcedr, fact_acct.amtsourcecr, fact_acct.amtacctdr, fact_acct.amtacctcr, fact_acct.c_uom_id, fact_acct.qty, fact_acct.m_product_id, fact_acct.c_bpartner_id, fact_acct.ad_orgtrx_id, fact_acct.c_locfrom_id, fact_acct.c_locto_id, fact_acct.c_salesregion_id, fact_acct.c_project_id, fact_acct.c_campaign_id, fact_acct.c_activity_id, fact_acct.user1_id, fact_acct.user2_id, fact_acct.description, fact_acct.a_asset_id, fact_acct.fact_acct_group_id, fact_acct.seqno, fact_acct.factaccttype, fact_acct.docbasetype, fact_acct.acctvalue, fact_acct.acctdescription, fact_acct.c_withholding_id +FROM fact_acct, fin_finacc_transaction +WHERE (fact_acct.record_id = fin_finacc_transaction.fin_finacc_transaction_id OR fact_acct.line_id = fin_finacc_transaction.fin_finacc_transaction_id) AND (fact_acct.ad_table_id IN ('4D8C3B3C31D1410DA046140C9F024D17', 'B1B7075C46934F0A9FD4C4D0F1457B42'))]]></view> + </database> diff -r 047e3c5c51ab -r 5133dc2e3407 modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml --- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml Fri Jul 15 09:34:32 2011 +0200 +++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml Fri Jul 15 11:50:11 2011 +0200 @@ -1,5 +1,38 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<!--046498C716474A6EAAEA0CA26E09C69D--><AD_COLUMN> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_COLUMN_ID><![CDATA[046498C716474A6EAAEA0CA26E09C69D]]></AD_COLUMN_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--046498C716474A6EAAEA0CA26E09C69D--> <NAME><![CDATA[Updated By]]></NAME> +<!--046498C716474A6EAAEA0CA26E09C69D--> <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION> +<!--046498C716474A6EAAEA0CA26E09C69D--> <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP> +<!--046498C716474A6EAAEA0CA26E09C69D--> <COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_TABLE_ID><![CDATA[FF80808130BB89090130BB8E3D7E0012]]></AD_TABLE_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISKEY><![CDATA[N]]></ISKEY> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--046498C716474A6EAAEA0CA26E09C69D--> <SEQNO><![CDATA[80]]></SEQNO> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--046498C716474A6EAAEA0CA26E09C69D--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--046498C716474A6EAAEA0CA26E09C69D--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--046498C716474A6EAAEA0CA26E09C69D--> <POSITION><![CDATA[8]]></POSITION> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--046498C716474A6EAAEA0CA26E09C69D--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--046498C716474A6EAAEA0CA26E09C69D--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--046498C716474A6EAAEA0CA26E09C69D--></AD_COLUMN> + <!--04DCCC7AAEDF4296941DD5ACB9164734--><AD_COLUMN> <!--04DCCC7AAEDF4296941DD5ACB9164734--> <AD_COLUMN_ID><![CDATA[04DCCC7AAEDF4296941DD5ACB9164734]]></AD_COLUMN_ID> <!--04DCCC7AAEDF4296941DD5ACB9164734--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -35,6 +68,72 @@ <!--04DCCC7AAEDF4296941DD5ACB9164734--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> <!--04DCCC7AAEDF4296941DD5ACB9164734--></AD_COLUMN> +<!--09A1C598D8134CAC92CB30E476A213B0--><AD_COLUMN> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_COLUMN_ID><![CDATA[09A1C598D8134CAC92CB30E476A213B0]]></AD_COLUMN_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--09A1C598D8134CAC92CB30E476A213B0--> <NAME><![CDATA[Accounting Date]]></NAME> +<!--09A1C598D8134CAC92CB30E476A213B0--> <DESCRIPTION><![CDATA[The date this transaction is recorded for in the general ledger.]]></DESCRIPTION> +<!--09A1C598D8134CAC92CB30E476A213B0--> <HELP><![CDATA[The date this transaction is recorded on in the general ledger. This date also indicates which accounting period within the fiscal year this transaction will be part of.]]></HELP> +<!--09A1C598D8134CAC92CB30E476A213B0--> <COLUMNNAME><![CDATA[Dateacct]]></COLUMNNAME> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_TABLE_ID><![CDATA[FF80808130BB89090130BB8E3D7E0012]]></AD_TABLE_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISKEY><![CDATA[N]]></ISKEY> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--09A1C598D8134CAC92CB30E476A213B0--> <SEQNO><![CDATA[120]]></SEQNO> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_ELEMENT_ID><![CDATA[263]]></AD_ELEMENT_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--09A1C598D8134CAC92CB30E476A213B0--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--09A1C598D8134CAC92CB30E476A213B0--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--09A1C598D8134CAC92CB30E476A213B0--> <POSITION><![CDATA[12]]></POSITION> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--09A1C598D8134CAC92CB30E476A213B0--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--09A1C598D8134CAC92CB30E476A213B0--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--09A1C598D8134CAC92CB30E476A213B0--></AD_COLUMN> + +<!--0CE41B7829C54AF3B7193B1FA52B3C62--><AD_COLUMN> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_COLUMN_ID><![CDATA[0CE41B7829C54AF3B7193B1FA52B3C62]]></AD_COLUMN_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <NAME><![CDATA[Transaction Date]]></NAME> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <DESCRIPTION><![CDATA[The date that a specified transaction is entered into the application.]]></DESCRIPTION> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <HELP><![CDATA[The Transaction Date indicates the date of the transaction.]]></HELP> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <COLUMNNAME><![CDATA[Datetrx]]></COLUMNNAME> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_TABLE_ID><![CDATA[FF80808130BB89090130BB8E3D7E0012]]></AD_TABLE_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISKEY><![CDATA[N]]></ISKEY> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <SEQNO><![CDATA[110]]></SEQNO> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_ELEMENT_ID><![CDATA[1297]]></AD_ELEMENT_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <POSITION><![CDATA[11]]></POSITION> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--0CE41B7829C54AF3B7193B1FA52B3C62--></AD_COLUMN> + <!--1309F42BE35D4E71A2185623688E5628--><AD_COLUMN> <!--1309F42BE35D4E71A2185623688E5628--> <AD_COLUMN_ID><![CDATA[1309F42BE35D4E71A2185623688E5628]]></AD_COLUMN_ID> <!--1309F42BE35D4E71A2185623688E5628--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -68,6 +167,40 @@ <!--1309F42BE35D4E71A2185623688E5628--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> <!--1309F42BE35D4E71A2185623688E5628--></AD_COLUMN> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--><AD_COLUMN> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_COLUMN_ID><![CDATA[1336389E95FA4A2B801DEE8DE3D7C3D3]]></AD_COLUMN_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <NAME><![CDATA[Business Partner]]></NAME> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <DESCRIPTION><![CDATA[Anyone who takes part in daily business operations by acting as a customer, employee, etc.]]></DESCRIPTION> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <HELP><![CDATA[A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.]]></HELP> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <COLUMNNAME><![CDATA[C_Bpartner_ID]]></COLUMNNAME> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_TABLE_ID><![CDATA[FF80808130BB89090130BB8E3D7E0012]]></AD_TABLE_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_REFERENCE_VALUE_ID><![CDATA[800057]]></AD_REFERENCE_VALUE_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISKEY><![CDATA[N]]></ISKEY> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <SEQNO><![CDATA[290]]></SEQNO> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_ELEMENT_ID><![CDATA[187]]></AD_ELEMENT_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <POSITION><![CDATA[32]]></POSITION> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--1336389E95FA4A2B801DEE8DE3D7C3D3--></AD_COLUMN> + <!--137DEB7F4BAF46A783F86044A1817D66--><AD_COLUMN> <!--137DEB7F4BAF46A783F86044A1817D66--> <AD_COLUMN_ID><![CDATA[137DEB7F4BAF46A783F86044A1817D66]]></AD_COLUMN_ID> <!--137DEB7F4BAF46A783F86044A1817D66--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -103,6 +236,109 @@ <!--137DEB7F4BAF46A783F86044A1817D66--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> <!--137DEB7F4BAF46A783F86044A1817D66--></AD_COLUMN> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--><AD_COLUMN> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_COLUMN_ID><![CDATA[1678A44C2B7543DD8393C8E4E32D6F3E]]></AD_COLUMN_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <NAME><![CDATA[UOM]]></NAME> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <DESCRIPTION><![CDATA[A non monetary unit of measure.]]></DESCRIPTION> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <HELP><![CDATA[The UOM defines a unique non monetary unit of measure]]></HELP> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <COLUMNNAME><![CDATA[C_Uom_ID]]></COLUMNNAME> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_TABLE_ID><![CDATA[FF80808130BB89090130BB8E3D7E0012]]></AD_TABLE_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISKEY><![CDATA[N]]></ISKEY> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <SEQNO><![CDATA[260]]></SEQNO> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_ELEMENT_ID><![CDATA[215]]></AD_ELEMENT_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <POSITION><![CDATA[29]]></POSITION> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--1678A44C2B7543DD8393C8E4E32D6F3E--></AD_COLUMN> + +<!--168A9EBEED3B444FAA83EDCCAE7716A9--><AD_COLUMN> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <AD_COLUMN_ID><![CDATA[168A9EBEED3B444FAA83EDCCAE7716A9]]></AD_COLUMN_ID> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <NAME><![CDATA[Creation Date]]></NAME> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <COLUMNNAME><![CDATA[Created]]></COLUMNNAME> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <AD_TABLE_ID><![CDATA[FF80808130BB89090130BB8E3D7E0012]]></AD_TABLE_ID> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH> +<!--168A9EBEED3B444FAA83EDCCAE7716A9--> <ISKEY><![CDATA[N]]></ISKEY> ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
