* IDEMPIERE-5567 Support of UUID as Key (FHCA-4195)
- Manage translation for UUID based tables
- Enable 2Pack Import UUID based tables with translation
- Create ad_package_imp_detail.Record_UU
- Create test table TestUU_Trl
* - Fix Synchronize Doc Translation
* IDEMPIERE-4262 on some condition, record insert by direct sql missing UUID
Solve AD_Element_Trl, AD_Process_Para_Trl, AD_PrintForm
* Add AcctSchemaDefaultCopy *_Acct tables, M_Product_PO, Fact_Reconciliation
* IDEMPIERE-4262 on some condition, record insert by direct sql missing UUID / fix role access uuids
* more on AD_Document_Action_Access
* Improve performance for trl recreate or insert - using update instead of record by record
* - add AD_PInstance_Log.AD_PInstance_Log_UU
There are two scripts in this commit:
* 202008040100_IDEMPIERE-3862.sql - updates the whole core as of today, changing the columns VARCHAR2...BYTE and NVARCHAR2 to VARCHAR2...CHAR
* 202008040114_IDEMPIERE-3862.sql - updates the non-core tables, same algorithm, the first script was generated using this second for the core
** in case somebody doesn't want the second script to run on their database can simply change the line 39 to ->dryrun varchar2(1) := 'Y';
Carlos Ruiz
Nicolas Micoud
Nicolas Micoud
Juan David Arboleda
mjudd