Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0033235 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
feature request | [Retail Modules] Web POS | minor | have not tried | 2016-06-13 15:40 | 2016-07-01 07:34 | |||
Reporter | mtaal | View Status | public | |||||
Assigned To | mtaal | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | c25bf7094080 | ||||
Projection | none | ETA | none | Target Version | RR16Q3 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | migueldejuana | |||||||
OBNetwork customer | No | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0033235: Replicating transactions - research a different way to execute transactions in a multi-server environment | |||||||
Description | See: http://wiki.openbravo.com/wiki/Projects:Store_Server_Replicating_Transactional_Tables_Research [^] | |||||||
Steps To Reproduce | See Description | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() diff --git a/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml b/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml --- a/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml +++ b/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml @@ -78,6 +78,22 @@ <!--2688D55E07D341E2B80F3B465111D5AB--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--2688D55E07D341E2B80F3B465111D5AB--></STRSYNC_SYNCHRONIZEDTABLE> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--><STRSYNC_SYNCHRONIZEDTABLE> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[2F7ADF513EE34AF490FD55E54AA20FB0]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <AD_TABLE_ID><![CDATA[FF80818132AF937F0132AF9E94FF0013]]></AD_TABLE_ID> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <AD_MODULE_ID><![CDATA[16134DEBE87D4D138BE37FFDB750E609]]></AD_MODULE_ID> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--2F7ADF513EE34AF490FD55E54AA20FB0--></STRSYNC_SYNCHRONIZEDTABLE> + <!--3FB8E591B8AB4AB2B52533A660C221ED--><STRSYNC_SYNCHRONIZEDTABLE> <!--3FB8E591B8AB4AB2B52533A660C221ED--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[3FB8E591B8AB4AB2B52533A660C221ED]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--3FB8E591B8AB4AB2B52533A660C221ED--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -94,6 +110,22 @@ <!--3FB8E591B8AB4AB2B52533A660C221ED--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--3FB8E591B8AB4AB2B52533A660C221ED--></STRSYNC_SYNCHRONIZEDTABLE> +<!--41B846019E794234B738D76598F57DE3--><STRSYNC_SYNCHRONIZEDTABLE> +<!--41B846019E794234B738D76598F57DE3--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[41B846019E794234B738D76598F57DE3]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--41B846019E794234B738D76598F57DE3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--41B846019E794234B738D76598F57DE3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--41B846019E794234B738D76598F57DE3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--41B846019E794234B738D76598F57DE3--> <AD_TABLE_ID><![CDATA[ED5114AC204A4A999FBA44A7A6C7ED84]]></AD_TABLE_ID> +<!--41B846019E794234B738D76598F57DE3--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--41B846019E794234B738D76598F57DE3--> <AD_MODULE_ID><![CDATA[16134DEBE87D4D138BE37FFDB750E609]]></AD_MODULE_ID> +<!--41B846019E794234B738D76598F57DE3--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--41B846019E794234B738D76598F57DE3--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--41B846019E794234B738D76598F57DE3--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--41B846019E794234B738D76598F57DE3--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--41B846019E794234B738D76598F57DE3--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--41B846019E794234B738D76598F57DE3--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--41B846019E794234B738D76598F57DE3--></STRSYNC_SYNCHRONIZEDTABLE> + <!--59C5034417C046E1B5C379172FD9C9B4--><STRSYNC_SYNCHRONIZEDTABLE> <!--59C5034417C046E1B5C379172FD9C9B4--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[59C5034417C046E1B5C379172FD9C9B4]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--59C5034417C046E1B5C379172FD9C9B4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -172,6 +204,22 @@ <!--65E54332A7854EE8972C4734A9074452--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F802B14A1254153BE91A77A0E0D1389]]></STRSYNC_CUSTOM_ROUTER_ID> <!--65E54332A7854EE8972C4734A9074452--></STRSYNC_SYNCHRONIZEDTABLE> +<!--8659E7CB29414836BBD2F0250F6C99DD--><STRSYNC_SYNCHRONIZEDTABLE> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[8659E7CB29414836BBD2F0250F6C99DD]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <AD_TABLE_ID><![CDATA[99906E8B7B8F4F3BA60757C7A1E96DDE]]></AD_TABLE_ID> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <AD_MODULE_ID><![CDATA[16134DEBE87D4D138BE37FFDB750E609]]></AD_MODULE_ID> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--8659E7CB29414836BBD2F0250F6C99DD--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--8659E7CB29414836BBD2F0250F6C99DD--></STRSYNC_SYNCHRONIZEDTABLE> + <!--8F90AC8CD0F841D9AD43EDE08F5273C7--><STRSYNC_SYNCHRONIZEDTABLE> <!--8F90AC8CD0F841D9AD43EDE08F5273C7--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[8F90AC8CD0F841D9AD43EDE08F5273C7]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--8F90AC8CD0F841D9AD43EDE08F5273C7--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -204,6 +252,22 @@ <!--95B1146A5D84426D9675CB7C8C78BC46--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--95B1146A5D84426D9675CB7C8C78BC46--></STRSYNC_SYNCHRONIZEDTABLE> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--><STRSYNC_SYNCHRONIZEDTABLE> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[9C9B674A9AFC4D849E1C6B4D5712A8D4]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <AD_TABLE_ID><![CDATA[0A0F3465048B411A96629B35EBE0B22A]]></AD_TABLE_ID> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <AD_MODULE_ID><![CDATA[16134DEBE87D4D138BE37FFDB750E609]]></AD_MODULE_ID> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--9C9B674A9AFC4D849E1C6B4D5712A8D4--></STRSYNC_SYNCHRONIZEDTABLE> + <!--ABA0170ED3FC425CB386DDEE539689A3--><STRSYNC_SYNCHRONIZEDTABLE> <!--ABA0170ED3FC425CB386DDEE539689A3--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[ABA0170ED3FC425CB386DDEE539689A3]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--ABA0170ED3FC425CB386DDEE539689A3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -282,6 +346,22 @@ <!--E044D56A27C542288BE59069D721AC2B--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--E044D56A27C542288BE59069D721AC2B--></STRSYNC_SYNCHRONIZEDTABLE> +<!--E7B488E9A8D1419E85602B650C8FDE39--><STRSYNC_SYNCHRONIZEDTABLE> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[E7B488E9A8D1419E85602B650C8FDE39]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <AD_TABLE_ID><![CDATA[71E0A195D8F14C759286DFF4971B662B]]></AD_TABLE_ID> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <AD_MODULE_ID><![CDATA[16134DEBE87D4D138BE37FFDB750E609]]></AD_MODULE_ID> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--E7B488E9A8D1419E85602B650C8FDE39--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--E7B488E9A8D1419E85602B650C8FDE39--></STRSYNC_SYNCHRONIZEDTABLE> + <!--EFAA5C064670470CBE79C571DA73FF60--><STRSYNC_SYNCHRONIZEDTABLE> <!--EFAA5C064670470CBE79C571DA73FF60--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[EFAA5C064670470CBE79C571DA73FF60]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--EFAA5C064670470CBE79C571DA73FF60--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -313,6 +393,22 @@ <!--F5D4113F877C47F3B888AF438519407F--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F802B14A1254153BE91A77A0E0D1389]]></STRSYNC_CUSTOM_ROUTER_ID> <!--F5D4113F877C47F3B888AF438519407F--></STRSYNC_SYNCHRONIZEDTABLE> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--><STRSYNC_SYNCHRONIZEDTABLE> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[FAC24F8CE04E4CD6A51D4BC57ACD3090]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <AD_TABLE_ID><![CDATA[3099A57126F24DC6BAFF15EDBF2B969D]]></AD_TABLE_ID> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <AD_MODULE_ID><![CDATA[16134DEBE87D4D138BE37FFDB750E609]]></AD_MODULE_ID> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--FAC24F8CE04E4CD6A51D4BC57ACD3090--></STRSYNC_SYNCHRONIZEDTABLE> + <!--FE656FBA11C64821A38C4F9CAD1949F9--><STRSYNC_SYNCHRONIZEDTABLE> <!--FE656FBA11C64821A38C4F9CAD1949F9--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[FE656FBA11C64821A38C4F9CAD1949F9]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--FE656FBA11C64821A38C4F9CAD1949F9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ![]() diff --git a/src-db/database/model/triggers/C_ORDERDISCOUNT_TRG.xml b/src-db/database/model/triggers/C_ORDERDISCOUNT_TRG.xml --- a/src-db/database/model/triggers/C_ORDERDISCOUNT_TRG.xml +++ b/src-db/database/model/triggers/C_ORDERDISCOUNT_TRG.xml @@ -22,6 +22,10 @@ v_RO NUMBER; v_Processed CHAR(1) ; BEGIN + + IF AD_isTriggerEnabled()='N' THEN RETURN; + END IF; + IF UPDATING THEN SELECT PROCESSED INTO v_Processed ![]() 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 @@ -779,6 +779,20 @@ <!--50DD0182196946F0906BB1B073E622F2--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> <!--50DD0182196946F0906BB1B073E622F2--></AD_DATASET_TABLE> +<!--5189E07BF8DF4051AABC31E9E3E392C8--><AD_DATASET_TABLE> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <AD_DATASET_TABLE_ID><![CDATA[5189E07BF8DF4051AABC31E9E3E392C8]]></AD_DATASET_TABLE_ID> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <AD_DATASET_ID><![CDATA[8930335BAE1D454CAB1CC5208B14B3F0]]></AD_DATASET_ID> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <AD_TABLE_ID><![CDATA[329]]></AD_TABLE_ID> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <WHERECLAUSE><![CDATA[ad_org_id in (@orgsInNaturalTree@)]]></WHERECLAUSE> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> +<!--5189E07BF8DF4051AABC31E9E3E392C8--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--5189E07BF8DF4051AABC31E9E3E392C8--></AD_DATASET_TABLE> + <!--589854F5ED3E408294957EF1A3868C6E--><AD_DATASET_TABLE> <!--589854F5ED3E408294957EF1A3868C6E--> <AD_DATASET_TABLE_ID><![CDATA[589854F5ED3E408294957EF1A3868C6E]]></AD_DATASET_TABLE_ID> <!--589854F5ED3E408294957EF1A3868C6E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1041,6 +1055,20 @@ <!--6FAFDB0EE31C4D0B8D89CE5535EAA350--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> <!--6FAFDB0EE31C4D0B8D89CE5535EAA350--></AD_DATASET_TABLE> +<!--6FFDFBD919E9459489D16530A1C5412B--><AD_DATASET_TABLE> +<!--6FFDFBD919E9459489D16530A1C5412B--> <AD_DATASET_TABLE_ID><![CDATA[6FFDFBD919E9459489D16530A1C5412B]]></AD_DATASET_TABLE_ID> +<!--6FFDFBD919E9459489D16530A1C5412B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--6FFDFBD919E9459489D16530A1C5412B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--6FFDFBD919E9459489D16530A1C5412B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--6FFDFBD919E9459489D16530A1C5412B--> <AD_DATASET_ID><![CDATA[8930335BAE1D454CAB1CC5208B14B3F0]]></AD_DATASET_ID> +<!--6FFDFBD919E9459489D16530A1C5412B--> <AD_TABLE_ID><![CDATA[3D6BB7D6D0F74610B7FA67B2D8471028]]></AD_TABLE_ID> +<!--6FFDFBD919E9459489D16530A1C5412B--> <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> +<!--6FFDFBD919E9459489D16530A1C5412B--> <WHERECLAUSE><![CDATA[ad_org_id in (@orgsInNaturalTree@)]]></WHERECLAUSE> +<!--6FFDFBD919E9459489D16530A1C5412B--> <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> +<!--6FFDFBD919E9459489D16530A1C5412B--> <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> +<!--6FFDFBD919E9459489D16530A1C5412B--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--6FFDFBD919E9459489D16530A1C5412B--></AD_DATASET_TABLE> + <!--7160166CA8334536A4BDB33B62957BC1--><AD_DATASET_TABLE> <!--7160166CA8334536A4BDB33B62957BC1--> <AD_DATASET_TABLE_ID><![CDATA[7160166CA8334536A4BDB33B62957BC1]]></AD_DATASET_TABLE_ID> <!--7160166CA8334536A4BDB33B62957BC1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1302,6 +1330,19 @@ <!--82B67F54B3394BE3BE4DABDA0A60F48B--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> <!--82B67F54B3394BE3BE4DABDA0A60F48B--></AD_DATASET_TABLE> +<!--830D8DAC70C34546B5ADF81900FDCA97--><AD_DATASET_TABLE> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <AD_DATASET_TABLE_ID><![CDATA[830D8DAC70C34546B5ADF81900FDCA97]]></AD_DATASET_TABLE_ID> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <AD_DATASET_ID><![CDATA[8930335BAE1D454CAB1CC5208B14B3F0]]></AD_DATASET_ID> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <AD_TABLE_ID><![CDATA[800170]]></AD_TABLE_ID> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT> +<!--830D8DAC70C34546B5ADF81900FDCA97--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--830D8DAC70C34546B5ADF81900FDCA97--></AD_DATASET_TABLE> + <!--8774CE2D240842AA8B13E1A5BA0C405E--><AD_DATASET_TABLE> <!--8774CE2D240842AA8B13E1A5BA0C405E--> <AD_DATASET_TABLE_ID><![CDATA[8774CE2D240842AA8B13E1A5BA0C405E]]></AD_DATASET_TABLE_ID> <!--8774CE2D240842AA8B13E1A5BA0C405E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml b/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml --- a/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml +++ b/src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml @@ -64,6 +64,22 @@ <!--09F5C04D36C845DD9B7A97E775D7AEC9--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--09F5C04D36C845DD9B7A97E775D7AEC9--></STRSYNC_SYNCHRONIZEDTABLE> +<!--0C9B8C47A5234CDF945D70F235A4AED4--><STRSYNC_SYNCHRONIZEDTABLE> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[0C9B8C47A5234CDF945D70F235A4AED4]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <AD_TABLE_ID><![CDATA[BF86157D495D474C8B82D92EA85A1BB2]]></AD_TABLE_ID> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--0C9B8C47A5234CDF945D70F235A4AED4--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--0C9B8C47A5234CDF945D70F235A4AED4--></STRSYNC_SYNCHRONIZEDTABLE> + <!--0E753207B9CB4E27BAE1A33412739521--><STRSYNC_SYNCHRONIZEDTABLE> <!--0E753207B9CB4E27BAE1A33412739521--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[0E753207B9CB4E27BAE1A33412739521]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--0E753207B9CB4E27BAE1A33412739521--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -96,6 +112,22 @@ <!--15451C0272F34B80AAEBF8DBBF348021--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--15451C0272F34B80AAEBF8DBBF348021--></STRSYNC_SYNCHRONIZEDTABLE> +<!--169936108C854DC79C177320F8EE95A8--><STRSYNC_SYNCHRONIZEDTABLE> +<!--169936108C854DC79C177320F8EE95A8--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[169936108C854DC79C177320F8EE95A8]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--169936108C854DC79C177320F8EE95A8--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--169936108C854DC79C177320F8EE95A8--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--169936108C854DC79C177320F8EE95A8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--169936108C854DC79C177320F8EE95A8--> <AD_TABLE_ID><![CDATA[333]]></AD_TABLE_ID> +<!--169936108C854DC79C177320F8EE95A8--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--169936108C854DC79C177320F8EE95A8--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--169936108C854DC79C177320F8EE95A8--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--169936108C854DC79C177320F8EE95A8--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--169936108C854DC79C177320F8EE95A8--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--169936108C854DC79C177320F8EE95A8--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--169936108C854DC79C177320F8EE95A8--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--169936108C854DC79C177320F8EE95A8--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--169936108C854DC79C177320F8EE95A8--></STRSYNC_SYNCHRONIZEDTABLE> + <!--1952790299254101A2FECF9E28994C6A--><STRSYNC_SYNCHRONIZEDTABLE> <!--1952790299254101A2FECF9E28994C6A--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[1952790299254101A2FECF9E28994C6A]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--1952790299254101A2FECF9E28994C6A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -144,6 +176,22 @@ <!--1C1DC31E9FD14C819480B4B1952A1C35--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--1C1DC31E9FD14C819480B4B1952A1C35--></STRSYNC_SYNCHRONIZEDTABLE> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--><STRSYNC_SYNCHRONIZEDTABLE> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[1C28FC2F69D5416BB0D1C1A96A2C1DF3]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <AD_TABLE_ID><![CDATA[259]]></AD_TABLE_ID> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--1C28FC2F69D5416BB0D1C1A96A2C1DF3--></STRSYNC_SYNCHRONIZEDTABLE> + <!--1CB718384E9343F591DCEB0B4DA7A53E--><STRSYNC_SYNCHRONIZEDTABLE> <!--1CB718384E9343F591DCEB0B4DA7A53E--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[1CB718384E9343F591DCEB0B4DA7A53E]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--1CB718384E9343F591DCEB0B4DA7A53E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -176,6 +224,22 @@ <!--21B280C23E164BD3AF63DB654A9D1A3B--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--21B280C23E164BD3AF63DB654A9D1A3B--></STRSYNC_SYNCHRONIZEDTABLE> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--><STRSYNC_SYNCHRONIZEDTABLE> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[25560E25CA1145DBB47A2D0C92AA1ADB]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <AD_TABLE_ID><![CDATA[800186]]></AD_TABLE_ID> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--25560E25CA1145DBB47A2D0C92AA1ADB--></STRSYNC_SYNCHRONIZEDTABLE> + <!--2556A162C8E84828B88F97A85687E408--><STRSYNC_SYNCHRONIZEDTABLE> <!--2556A162C8E84828B88F97A85687E408--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[2556A162C8E84828B88F97A85687E408]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--2556A162C8E84828B88F97A85687E408--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -219,7 +283,7 @@ <!--26C3DD1CAF6B441A903EAE06C27C7272--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> <!--26C3DD1CAF6B441A903EAE06C27C7272--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> <!--26C3DD1CAF6B441A903EAE06C27C7272--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> -<!--26C3DD1CAF6B441A903EAE06C27C7272--> <SYNCH_DIR><![CDATA[CentralToStore]]></SYNCH_DIR> +<!--26C3DD1CAF6B441A903EAE06C27C7272--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> <!--26C3DD1CAF6B441A903EAE06C27C7272--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> <!--26C3DD1CAF6B441A903EAE06C27C7272--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--26C3DD1CAF6B441A903EAE06C27C7272--></STRSYNC_SYNCHRONIZEDTABLE> @@ -272,6 +336,38 @@ <!--29E229E0FE114B3E8C7B1140D1C103EE--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--29E229E0FE114B3E8C7B1140D1C103EE--></STRSYNC_SYNCHRONIZEDTABLE> +<!--29F177A203774C289509CF70789BBA7F--><STRSYNC_SYNCHRONIZEDTABLE> +<!--29F177A203774C289509CF70789BBA7F--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[29F177A203774C289509CF70789BBA7F]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--29F177A203774C289509CF70789BBA7F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--29F177A203774C289509CF70789BBA7F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--29F177A203774C289509CF70789BBA7F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--29F177A203774C289509CF70789BBA7F--> <AD_TABLE_ID><![CDATA[334]]></AD_TABLE_ID> +<!--29F177A203774C289509CF70789BBA7F--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--29F177A203774C289509CF70789BBA7F--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--29F177A203774C289509CF70789BBA7F--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--29F177A203774C289509CF70789BBA7F--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--29F177A203774C289509CF70789BBA7F--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--29F177A203774C289509CF70789BBA7F--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--29F177A203774C289509CF70789BBA7F--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--29F177A203774C289509CF70789BBA7F--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--29F177A203774C289509CF70789BBA7F--></STRSYNC_SYNCHRONIZEDTABLE> + +<!--2A2A26CC34314090AC3408DD01FB7510--><STRSYNC_SYNCHRONIZEDTABLE> +<!--2A2A26CC34314090AC3408DD01FB7510--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[2A2A26CC34314090AC3408DD01FB7510]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--2A2A26CC34314090AC3408DD01FB7510--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--2A2A26CC34314090AC3408DD01FB7510--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--2A2A26CC34314090AC3408DD01FB7510--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--2A2A26CC34314090AC3408DD01FB7510--> <AD_TABLE_ID><![CDATA[260]]></AD_TABLE_ID> +<!--2A2A26CC34314090AC3408DD01FB7510--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--2A2A26CC34314090AC3408DD01FB7510--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--2A2A26CC34314090AC3408DD01FB7510--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--2A2A26CC34314090AC3408DD01FB7510--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--2A2A26CC34314090AC3408DD01FB7510--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--2A2A26CC34314090AC3408DD01FB7510--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--2A2A26CC34314090AC3408DD01FB7510--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--2A2A26CC34314090AC3408DD01FB7510--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--2A2A26CC34314090AC3408DD01FB7510--></STRSYNC_SYNCHRONIZEDTABLE> + <!--2D803E371F2347BD94017A8601731B86--><STRSYNC_SYNCHRONIZEDTABLE> <!--2D803E371F2347BD94017A8601731B86--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[2D803E371F2347BD94017A8601731B86]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--2D803E371F2347BD94017A8601731B86--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -352,6 +448,22 @@ <!--30B957AD66334CCE80C7F320C6C0EAFA--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--30B957AD66334CCE80C7F320C6C0EAFA--></STRSYNC_SYNCHRONIZEDTABLE> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--><STRSYNC_SYNCHRONIZEDTABLE> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[310C93560D2D402DB8A9C9DCC72F1FAB]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <AD_TABLE_ID><![CDATA[DBCD072881ED4F6199659347F39645EA]]></AD_TABLE_ID> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--310C93560D2D402DB8A9C9DCC72F1FAB--></STRSYNC_SYNCHRONIZEDTABLE> + <!--31E2AADDCC4C43A1955E2F072420E74C--><STRSYNC_SYNCHRONIZEDTABLE> <!--31E2AADDCC4C43A1955E2F072420E74C--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[31E2AADDCC4C43A1955E2F072420E74C]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--31E2AADDCC4C43A1955E2F072420E74C--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -432,6 +544,22 @@ <!--3D5B7DE473FA4509A06D8D4307CAE69F--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--3D5B7DE473FA4509A06D8D4307CAE69F--></STRSYNC_SYNCHRONIZEDTABLE> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--><STRSYNC_SYNCHRONIZEDTABLE> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[3EFA738CCA484ECF9E31B7E299FF6F52]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <AD_TABLE_ID><![CDATA[C0233061EA504EFEAB0483E836BBAF31]]></AD_TABLE_ID> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--3EFA738CCA484ECF9E31B7E299FF6F52--></STRSYNC_SYNCHRONIZEDTABLE> + <!--409040870C814C49A6F15ED47E6F8B20--><STRSYNC_SYNCHRONIZEDTABLE> <!--409040870C814C49A6F15ED47E6F8B20--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[409040870C814C49A6F15ED47E6F8B20]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--409040870C814C49A6F15ED47E6F8B20--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -512,6 +640,22 @@ <!--491879DC3D944B9CA56ED64D737725F7--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--491879DC3D944B9CA56ED64D737725F7--></STRSYNC_SYNCHRONIZEDTABLE> +<!--4B6EFC752673451482874618DDF52FBD--><STRSYNC_SYNCHRONIZEDTABLE> +<!--4B6EFC752673451482874618DDF52FBD--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[4B6EFC752673451482874618DDF52FBD]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--4B6EFC752673451482874618DDF52FBD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--4B6EFC752673451482874618DDF52FBD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--4B6EFC752673451482874618DDF52FBD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--4B6EFC752673451482874618DDF52FBD--> <AD_TABLE_ID><![CDATA[713AF6B2E0494BD98FEC066CEC1A48B9]]></AD_TABLE_ID> +<!--4B6EFC752673451482874618DDF52FBD--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--4B6EFC752673451482874618DDF52FBD--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--4B6EFC752673451482874618DDF52FBD--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--4B6EFC752673451482874618DDF52FBD--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--4B6EFC752673451482874618DDF52FBD--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--4B6EFC752673451482874618DDF52FBD--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--4B6EFC752673451482874618DDF52FBD--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--4B6EFC752673451482874618DDF52FBD--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--4B6EFC752673451482874618DDF52FBD--></STRSYNC_SYNCHRONIZEDTABLE> + <!--4E94AB9EDA2B44DC97ACA2A626A0F2D7--><STRSYNC_SYNCHRONIZEDTABLE> <!--4E94AB9EDA2B44DC97ACA2A626A0F2D7--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[4E94AB9EDA2B44DC97ACA2A626A0F2D7]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--4E94AB9EDA2B44DC97ACA2A626A0F2D7--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -560,6 +704,22 @@ <!--4F876C24FB0C47B59AA28E2CEDC8F9D3--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--4F876C24FB0C47B59AA28E2CEDC8F9D3--></STRSYNC_SYNCHRONIZEDTABLE> +<!--513C5F5D7AF846CB93D380373C3FA3FF--><STRSYNC_SYNCHRONIZEDTABLE> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[513C5F5D7AF846CB93D380373C3FA3FF]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <AD_TABLE_ID><![CDATA[B1B7075C46934F0A9FD4C4D0F1457B42]]></AD_TABLE_ID> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--513C5F5D7AF846CB93D380373C3FA3FF--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--513C5F5D7AF846CB93D380373C3FA3FF--></STRSYNC_SYNCHRONIZEDTABLE> + <!--514E3C3DE1FD46A6A9C78B5C6CC647FC--><STRSYNC_SYNCHRONIZEDTABLE> <!--514E3C3DE1FD46A6A9C78B5C6CC647FC--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[514E3C3DE1FD46A6A9C78B5C6CC647FC]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--514E3C3DE1FD46A6A9C78B5C6CC647FC--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -624,6 +784,22 @@ <!--5316F305438B495D84C4B434B5522078--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--5316F305438B495D84C4B434B5522078--></STRSYNC_SYNCHRONIZEDTABLE> +<!--5448F52D9CC7404585DE0A189C12ED32--><STRSYNC_SYNCHRONIZEDTABLE> +<!--5448F52D9CC7404585DE0A189C12ED32--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[5448F52D9CC7404585DE0A189C12ED32]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--5448F52D9CC7404585DE0A189C12ED32--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5448F52D9CC7404585DE0A189C12ED32--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5448F52D9CC7404585DE0A189C12ED32--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5448F52D9CC7404585DE0A189C12ED32--> <AD_TABLE_ID><![CDATA[314]]></AD_TABLE_ID> +<!--5448F52D9CC7404585DE0A189C12ED32--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--5448F52D9CC7404585DE0A189C12ED32--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--5448F52D9CC7404585DE0A189C12ED32--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--5448F52D9CC7404585DE0A189C12ED32--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--5448F52D9CC7404585DE0A189C12ED32--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--5448F52D9CC7404585DE0A189C12ED32--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--5448F52D9CC7404585DE0A189C12ED32--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--5448F52D9CC7404585DE0A189C12ED32--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--5448F52D9CC7404585DE0A189C12ED32--></STRSYNC_SYNCHRONIZEDTABLE> + <!--54556E0642684B07BB4A743CDE2B4DD6--><STRSYNC_SYNCHRONIZEDTABLE> <!--54556E0642684B07BB4A743CDE2B4DD6--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[54556E0642684B07BB4A743CDE2B4DD6]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--54556E0642684B07BB4A743CDE2B4DD6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -656,6 +832,22 @@ <!--568EF404A5394638A1360B68C5B485F5--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--568EF404A5394638A1360B68C5B485F5--></STRSYNC_SYNCHRONIZEDTABLE> +<!--57313DACFF804B2AA05AF1D2402C726E--><STRSYNC_SYNCHRONIZEDTABLE> +<!--57313DACFF804B2AA05AF1D2402C726E--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[57313DACFF804B2AA05AF1D2402C726E]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--57313DACFF804B2AA05AF1D2402C726E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--57313DACFF804B2AA05AF1D2402C726E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--57313DACFF804B2AA05AF1D2402C726E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--57313DACFF804B2AA05AF1D2402C726E--> <AD_TABLE_ID><![CDATA[060F457B82494B81B7F3DE4DE60B3DC9]]></AD_TABLE_ID> +<!--57313DACFF804B2AA05AF1D2402C726E--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--57313DACFF804B2AA05AF1D2402C726E--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--57313DACFF804B2AA05AF1D2402C726E--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--57313DACFF804B2AA05AF1D2402C726E--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--57313DACFF804B2AA05AF1D2402C726E--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--57313DACFF804B2AA05AF1D2402C726E--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--57313DACFF804B2AA05AF1D2402C726E--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--57313DACFF804B2AA05AF1D2402C726E--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--57313DACFF804B2AA05AF1D2402C726E--></STRSYNC_SYNCHRONIZEDTABLE> + <!--57E629C3218B4DE8AA06BAB5FD556A1A--><STRSYNC_SYNCHRONIZEDTABLE> <!--57E629C3218B4DE8AA06BAB5FD556A1A--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[57E629C3218B4DE8AA06BAB5FD556A1A]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--57E629C3218B4DE8AA06BAB5FD556A1A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -880,6 +1072,38 @@ <!--6F07ED7D4D8449CCA02589AA9270C182--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--6F07ED7D4D8449CCA02589AA9270C182--></STRSYNC_SYNCHRONIZEDTABLE> +<!--6F49691F351D4D51815B87E226456CCE--><STRSYNC_SYNCHRONIZEDTABLE> +<!--6F49691F351D4D51815B87E226456CCE--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[6F49691F351D4D51815B87E226456CCE]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--6F49691F351D4D51815B87E226456CCE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--6F49691F351D4D51815B87E226456CCE--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--6F49691F351D4D51815B87E226456CCE--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--6F49691F351D4D51815B87E226456CCE--> <AD_TABLE_ID><![CDATA[800037]]></AD_TABLE_ID> +<!--6F49691F351D4D51815B87E226456CCE--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--6F49691F351D4D51815B87E226456CCE--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--6F49691F351D4D51815B87E226456CCE--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--6F49691F351D4D51815B87E226456CCE--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--6F49691F351D4D51815B87E226456CCE--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--6F49691F351D4D51815B87E226456CCE--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--6F49691F351D4D51815B87E226456CCE--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--6F49691F351D4D51815B87E226456CCE--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--6F49691F351D4D51815B87E226456CCE--></STRSYNC_SYNCHRONIZEDTABLE> + +<!--6F835CD4138D49669D5C85CABF9DC3D5--><STRSYNC_SYNCHRONIZEDTABLE> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[6F835CD4138D49669D5C85CABF9DC3D5]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <AD_TABLE_ID><![CDATA[CE9AFF5F51B846AEAB0B6CBF829092CD]]></AD_TABLE_ID> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--6F835CD4138D49669D5C85CABF9DC3D5--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--6F835CD4138D49669D5C85CABF9DC3D5--></STRSYNC_SYNCHRONIZEDTABLE> + <!--6FE3CB0EB3D14D60B62513019FA52F57--><STRSYNC_SYNCHRONIZEDTABLE> <!--6FE3CB0EB3D14D60B62513019FA52F57--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[6FE3CB0EB3D14D60B62513019FA52F57]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--6FE3CB0EB3D14D60B62513019FA52F57--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1008,6 +1232,54 @@ <!--77B293D24F984753983261D62B3D68ED--> <CLR_EXT_REFERENCES><![CDATA[Y]]></CLR_EXT_REFERENCES> <!--77B293D24F984753983261D62B3D68ED--></STRSYNC_SYNCHRONIZEDTABLE> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--><STRSYNC_SYNCHRONIZEDTABLE> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[7AC83EEA75C34B0A9A670F717D1EFA4A]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <AD_TABLE_ID><![CDATA[318]]></AD_TABLE_ID> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--7AC83EEA75C34B0A9A670F717D1EFA4A--></STRSYNC_SYNCHRONIZEDTABLE> + +<!--7B2C3041D9E34D849B7BC13193EB2F73--><STRSYNC_SYNCHRONIZEDTABLE> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[7B2C3041D9E34D849B7BC13193EB2F73]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <AD_TABLE_ID><![CDATA[800185]]></AD_TABLE_ID> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--7B2C3041D9E34D849B7BC13193EB2F73--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--7B2C3041D9E34D849B7BC13193EB2F73--></STRSYNC_SYNCHRONIZEDTABLE> + +<!--7B7683BFAA344E139F1F1C254EFCDEFB--><STRSYNC_SYNCHRONIZEDTABLE> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[7B7683BFAA344E139F1F1C254EFCDEFB]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <AD_TABLE_ID><![CDATA[320]]></AD_TABLE_ID> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--7B7683BFAA344E139F1F1C254EFCDEFB--></STRSYNC_SYNCHRONIZEDTABLE> + <!--7C0E1D47E9DD4EAFB7C8AAE5378F4229--><STRSYNC_SYNCHRONIZEDTABLE> <!--7C0E1D47E9DD4EAFB7C8AAE5378F4229--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[7C0E1D47E9DD4EAFB7C8AAE5378F4229]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--7C0E1D47E9DD4EAFB7C8AAE5378F4229--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1040,6 +1312,22 @@ <!--82542E114B3F469FBED0275EAF4BBE4A--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--82542E114B3F469FBED0275EAF4BBE4A--></STRSYNC_SYNCHRONIZEDTABLE> +<!--832459104E754CBA854EC2A2CB230E0B--><STRSYNC_SYNCHRONIZEDTABLE> +<!--832459104E754CBA854EC2A2CB230E0B--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[832459104E754CBA854EC2A2CB230E0B]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--832459104E754CBA854EC2A2CB230E0B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--832459104E754CBA854EC2A2CB230E0B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--832459104E754CBA854EC2A2CB230E0B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--832459104E754CBA854EC2A2CB230E0B--> <AD_TABLE_ID><![CDATA[800013]]></AD_TABLE_ID> +<!--832459104E754CBA854EC2A2CB230E0B--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--832459104E754CBA854EC2A2CB230E0B--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--832459104E754CBA854EC2A2CB230E0B--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--832459104E754CBA854EC2A2CB230E0B--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--832459104E754CBA854EC2A2CB230E0B--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--832459104E754CBA854EC2A2CB230E0B--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--832459104E754CBA854EC2A2CB230E0B--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--832459104E754CBA854EC2A2CB230E0B--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--832459104E754CBA854EC2A2CB230E0B--></STRSYNC_SYNCHRONIZEDTABLE> + <!--86112764E7324532BB12772A23E0002D--><STRSYNC_SYNCHRONIZEDTABLE> <!--86112764E7324532BB12772A23E0002D--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[86112764E7324532BB12772A23E0002D]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--86112764E7324532BB12772A23E0002D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1104,6 +1392,22 @@ <!--8BF1C08823554882B7B0736FEF48BC20--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--8BF1C08823554882B7B0736FEF48BC20--></STRSYNC_SYNCHRONIZEDTABLE> +<!--8CCC735185E54BC5B586D45B05DF6158--><STRSYNC_SYNCHRONIZEDTABLE> +<!--8CCC735185E54BC5B586D45B05DF6158--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[8CCC735185E54BC5B586D45B05DF6158]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--8CCC735185E54BC5B586D45B05DF6158--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--8CCC735185E54BC5B586D45B05DF6158--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--8CCC735185E54BC5B586D45B05DF6158--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--8CCC735185E54BC5B586D45B05DF6158--> <AD_TABLE_ID><![CDATA[B7ABE839A5F64A39ADCEE86817AA272F]]></AD_TABLE_ID> +<!--8CCC735185E54BC5B586D45B05DF6158--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--8CCC735185E54BC5B586D45B05DF6158--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--8CCC735185E54BC5B586D45B05DF6158--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--8CCC735185E54BC5B586D45B05DF6158--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--8CCC735185E54BC5B586D45B05DF6158--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--8CCC735185E54BC5B586D45B05DF6158--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--8CCC735185E54BC5B586D45B05DF6158--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--8CCC735185E54BC5B586D45B05DF6158--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--8CCC735185E54BC5B586D45B05DF6158--></STRSYNC_SYNCHRONIZEDTABLE> + <!--8EA390404DE04D7AB1C9FAF714453C15--><STRSYNC_SYNCHRONIZEDTABLE> <!--8EA390404DE04D7AB1C9FAF714453C15--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[8EA390404DE04D7AB1C9FAF714453C15]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--8EA390404DE04D7AB1C9FAF714453C15--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1376,6 +1680,22 @@ <!--A226519742EE428796A5AB34AEB16DAF--> <CLR_EXT_REFERENCES><![CDATA[Y]]></CLR_EXT_REFERENCES> <!--A226519742EE428796A5AB34AEB16DAF--></STRSYNC_SYNCHRONIZEDTABLE> +<!--A5027292B8E94EAFBBE829D2B596046D--><STRSYNC_SYNCHRONIZEDTABLE> +<!--A5027292B8E94EAFBBE829D2B596046D--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[A5027292B8E94EAFBBE829D2B596046D]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--A5027292B8E94EAFBBE829D2B596046D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--A5027292B8E94EAFBBE829D2B596046D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--A5027292B8E94EAFBBE829D2B596046D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--A5027292B8E94EAFBBE829D2B596046D--> <AD_TABLE_ID><![CDATA[E42DDB42FF0B4F82B1CF3C711B3F0DC0]]></AD_TABLE_ID> +<!--A5027292B8E94EAFBBE829D2B596046D--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--A5027292B8E94EAFBBE829D2B596046D--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--A5027292B8E94EAFBBE829D2B596046D--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--A5027292B8E94EAFBBE829D2B596046D--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--A5027292B8E94EAFBBE829D2B596046D--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--A5027292B8E94EAFBBE829D2B596046D--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--A5027292B8E94EAFBBE829D2B596046D--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--A5027292B8E94EAFBBE829D2B596046D--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--A5027292B8E94EAFBBE829D2B596046D--></STRSYNC_SYNCHRONIZEDTABLE> + <!--A5C436B625F04EDAB6F69B50C7DBE99E--><STRSYNC_SYNCHRONIZEDTABLE> <!--A5C436B625F04EDAB6F69B50C7DBE99E--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[A5C436B625F04EDAB6F69B50C7DBE99E]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--A5C436B625F04EDAB6F69B50C7DBE99E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1392,6 +1712,22 @@ <!--A5C436B625F04EDAB6F69B50C7DBE99E--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--A5C436B625F04EDAB6F69B50C7DBE99E--></STRSYNC_SYNCHRONIZEDTABLE> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--><STRSYNC_SYNCHRONIZEDTABLE> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[A5E091B10BAF46F3B6F5154FD62B7C70]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <AD_TABLE_ID><![CDATA[1011100000]]></AD_TABLE_ID> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--A5E091B10BAF46F3B6F5154FD62B7C70--></STRSYNC_SYNCHRONIZEDTABLE> + <!--A5F8CF12D3764684A023BE48DDA80BC3--><STRSYNC_SYNCHRONIZEDTABLE> <!--A5F8CF12D3764684A023BE48DDA80BC3--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[A5F8CF12D3764684A023BE48DDA80BC3]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--A5F8CF12D3764684A023BE48DDA80BC3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1424,6 +1760,22 @@ <!--A603BF1F2AEE4599AF33B635BEDBD1D3--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--A603BF1F2AEE4599AF33B635BEDBD1D3--></STRSYNC_SYNCHRONIZEDTABLE> +<!--A6EE80209EE045D29F3D1731D6F28E45--><STRSYNC_SYNCHRONIZEDTABLE> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[A6EE80209EE045D29F3D1731D6F28E45]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <AD_TABLE_ID><![CDATA[800045]]></AD_TABLE_ID> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--A6EE80209EE045D29F3D1731D6F28E45--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--A6EE80209EE045D29F3D1731D6F28E45--></STRSYNC_SYNCHRONIZEDTABLE> + <!--A6FBD36DC57B4C118F44B9D151368B91--><STRSYNC_SYNCHRONIZEDTABLE> <!--A6FBD36DC57B4C118F44B9D151368B91--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[A6FBD36DC57B4C118F44B9D151368B91]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--A6FBD36DC57B4C118F44B9D151368B91--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1520,6 +1872,22 @@ <!--AE0F84CDF01B47828232E1DDBD810823--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--AE0F84CDF01B47828232E1DDBD810823--></STRSYNC_SYNCHRONIZEDTABLE> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--><STRSYNC_SYNCHRONIZEDTABLE> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[B0E7CB5E71244A1B80B2C73F77C55F8D]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <AD_TABLE_ID><![CDATA[319]]></AD_TABLE_ID> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--B0E7CB5E71244A1B80B2C73F77C55F8D--></STRSYNC_SYNCHRONIZEDTABLE> + <!--B279F389851B41F5857AADAB079D82B4--><STRSYNC_SYNCHRONIZEDTABLE> <!--B279F389851B41F5857AADAB079D82B4--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[B279F389851B41F5857AADAB079D82B4]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--B279F389851B41F5857AADAB079D82B4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1616,6 +1984,22 @@ <!--BCEDF161BC804026815C71870E8881DF--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--BCEDF161BC804026815C71870E8881DF--></STRSYNC_SYNCHRONIZEDTABLE> +<!--BD46C495C8BA424CB1BA710A597D0207--><STRSYNC_SYNCHRONIZEDTABLE> +<!--BD46C495C8BA424CB1BA710A597D0207--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[BD46C495C8BA424CB1BA710A597D0207]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--BD46C495C8BA424CB1BA710A597D0207--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--BD46C495C8BA424CB1BA710A597D0207--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--BD46C495C8BA424CB1BA710A597D0207--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--BD46C495C8BA424CB1BA710A597D0207--> <AD_TABLE_ID><![CDATA[329]]></AD_TABLE_ID> +<!--BD46C495C8BA424CB1BA710A597D0207--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--BD46C495C8BA424CB1BA710A597D0207--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--BD46C495C8BA424CB1BA710A597D0207--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--BD46C495C8BA424CB1BA710A597D0207--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--BD46C495C8BA424CB1BA710A597D0207--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--BD46C495C8BA424CB1BA710A597D0207--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--BD46C495C8BA424CB1BA710A597D0207--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--BD46C495C8BA424CB1BA710A597D0207--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--BD46C495C8BA424CB1BA710A597D0207--></STRSYNC_SYNCHRONIZEDTABLE> + <!--BDB6A0F9320C4A109C44CFDA1890F294--><STRSYNC_SYNCHRONIZEDTABLE> <!--BDB6A0F9320C4A109C44CFDA1890F294--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[BDB6A0F9320C4A109C44CFDA1890F294]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--BDB6A0F9320C4A109C44CFDA1890F294--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1760,6 +2144,22 @@ <!--C53E495B8737448BB6CDF43013604706--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--C53E495B8737448BB6CDF43013604706--></STRSYNC_SYNCHRONIZEDTABLE> +<!--C609994A99404539BA2971C32A77E39B--><STRSYNC_SYNCHRONIZEDTABLE> +<!--C609994A99404539BA2971C32A77E39B--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[C609994A99404539BA2971C32A77E39B]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--C609994A99404539BA2971C32A77E39B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C609994A99404539BA2971C32A77E39B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C609994A99404539BA2971C32A77E39B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C609994A99404539BA2971C32A77E39B--> <AD_TABLE_ID><![CDATA[3D6BB7D6D0F74610B7FA67B2D8471028]]></AD_TABLE_ID> +<!--C609994A99404539BA2971C32A77E39B--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--C609994A99404539BA2971C32A77E39B--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--C609994A99404539BA2971C32A77E39B--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--C609994A99404539BA2971C32A77E39B--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--C609994A99404539BA2971C32A77E39B--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--C609994A99404539BA2971C32A77E39B--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--C609994A99404539BA2971C32A77E39B--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--C609994A99404539BA2971C32A77E39B--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--C609994A99404539BA2971C32A77E39B--></STRSYNC_SYNCHRONIZEDTABLE> + <!--C757C672AA4A49799FF2DDA7F0F63397--><STRSYNC_SYNCHRONIZEDTABLE> <!--C757C672AA4A49799FF2DDA7F0F63397--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[C757C672AA4A49799FF2DDA7F0F63397]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--C757C672AA4A49799FF2DDA7F0F63397--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1840,6 +2240,22 @@ <!--CAE1C164F52444128B09A0D8EBD82F1D--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--CAE1C164F52444128B09A0D8EBD82F1D--></STRSYNC_SYNCHRONIZEDTABLE> +<!--CB9D6CED061A4377AA609F3F1F01413B--><STRSYNC_SYNCHRONIZEDTABLE> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[CB9D6CED061A4377AA609F3F1F01413B]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <AD_TABLE_ID><![CDATA[2C75DEA0B5914305B4D789F76FCFD276]]></AD_TABLE_ID> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--CB9D6CED061A4377AA609F3F1F01413B--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--CB9D6CED061A4377AA609F3F1F01413B--></STRSYNC_SYNCHRONIZEDTABLE> + <!--CD48793C2D96491092CE060F7B05A1C0--><STRSYNC_SYNCHRONIZEDTABLE> <!--CD48793C2D96491092CE060F7B05A1C0--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[CD48793C2D96491092CE060F7B05A1C0]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--CD48793C2D96491092CE060F7B05A1C0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1888,6 +2304,22 @@ <!--CE36989B55ED42ED9F8353838A265764--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--CE36989B55ED42ED9F8353838A265764--></STRSYNC_SYNCHRONIZEDTABLE> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--><STRSYNC_SYNCHRONIZEDTABLE> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[D29A3D7FBC9548A99B5BA77155CF34E4]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <AD_TABLE_ID><![CDATA[5C77283492354D759049C14C9D4B7769]]></AD_TABLE_ID> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--D29A3D7FBC9548A99B5BA77155CF34E4--></STRSYNC_SYNCHRONIZEDTABLE> + <!--D51689D047AF4372BC367676BF041427--><STRSYNC_SYNCHRONIZEDTABLE> <!--D51689D047AF4372BC367676BF041427--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[D51689D047AF4372BC367676BF041427]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--D51689D047AF4372BC367676BF041427--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -2160,6 +2592,38 @@ <!--E849D9D240B3446FA44686044A16DBF5--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--E849D9D240B3446FA44686044A16DBF5--></STRSYNC_SYNCHRONIZEDTABLE> +<!--E992230833F445C8A2E4B43741572E07--><STRSYNC_SYNCHRONIZEDTABLE> +<!--E992230833F445C8A2E4B43741572E07--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[E992230833F445C8A2E4B43741572E07]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--E992230833F445C8A2E4B43741572E07--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E992230833F445C8A2E4B43741572E07--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E992230833F445C8A2E4B43741572E07--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E992230833F445C8A2E4B43741572E07--> <AD_TABLE_ID><![CDATA[D1A97202E832470285C9B1EB026D54E2]]></AD_TABLE_ID> +<!--E992230833F445C8A2E4B43741572E07--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--E992230833F445C8A2E4B43741572E07--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--E992230833F445C8A2E4B43741572E07--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--E992230833F445C8A2E4B43741572E07--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--E992230833F445C8A2E4B43741572E07--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--E992230833F445C8A2E4B43741572E07--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--E992230833F445C8A2E4B43741572E07--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--E992230833F445C8A2E4B43741572E07--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--E992230833F445C8A2E4B43741572E07--></STRSYNC_SYNCHRONIZEDTABLE> + +<!--E9979FABF77F4B1F85694D0E2451EA1E--><STRSYNC_SYNCHRONIZEDTABLE> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[E9979FABF77F4B1F85694D0E2451EA1E]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <AD_TABLE_ID><![CDATA[47475EB0CD6542A98C6E1B3B0E914BD7]]></AD_TABLE_ID> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--E9979FABF77F4B1F85694D0E2451EA1E--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--E9979FABF77F4B1F85694D0E2451EA1E--></STRSYNC_SYNCHRONIZEDTABLE> + <!--EDFB2E943D4248D482B7F7CD72F94520--><STRSYNC_SYNCHRONIZEDTABLE> <!--EDFB2E943D4248D482B7F7CD72F94520--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[EDFB2E943D4248D482B7F7CD72F94520]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--EDFB2E943D4248D482B7F7CD72F94520--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -2192,6 +2656,22 @@ <!--EE400D6F87AA4478B2854BC45EB25EF8--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> <!--EE400D6F87AA4478B2854BC45EB25EF8--></STRSYNC_SYNCHRONIZEDTABLE> +<!--F43CD7A0FD3648F4BF509636C5E90524--><STRSYNC_SYNCHRONIZEDTABLE> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[F43CD7A0FD3648F4BF509636C5E90524]]></STRSYNC_SYNCHRONIZEDTABLE_ID> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <AD_TABLE_ID><![CDATA[3E44B34E1EEA4B9CB10E2968CD022AB5]]></AD_TABLE_ID> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <CHANNEL><![CDATA[ECC2BD9D893C4351998193C9A398374E]]></CHANNEL> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <AD_MODULE_ID><![CDATA[C7EC0756A4044DD48BF6BB6A1CDD7734]]></AD_MODULE_ID> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <SYNCH_INSERTS><![CDATA[Y]]></SYNCH_INSERTS> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <SYNCH_UPDATES><![CDATA[Y]]></SYNCH_UPDATES> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <SYNCH_DELETES><![CDATA[Y]]></SYNCH_DELETES> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <SYNCH_DIR><![CDATA[Bidirectional]]></SYNCH_DIR> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <STRSYNC_CUSTOM_ROUTER_ID><![CDATA[0F4B04F492064EB1B297496CC8A8A957]]></STRSYNC_CUSTOM_ROUTER_ID> +<!--F43CD7A0FD3648F4BF509636C5E90524--> <CLR_EXT_REFERENCES><![CDATA[N]]></CLR_EXT_REFERENCES> +<!--F43CD7A0FD3648F4BF509636C5E90524--></STRSYNC_SYNCHRONIZEDTABLE> + <!--F5D751B16DA14A2BA88F64DB4B5ABABE--><STRSYNC_SYNCHRONIZEDTABLE> <!--F5D751B16DA14A2BA88F64DB4B5ABABE--> <STRSYNC_SYNCHRONIZEDTABLE_ID><![CDATA[F5D751B16DA14A2BA88F64DB4B5ABABE]]></STRSYNC_SYNCHRONIZEDTABLE_ID> <!--F5D751B16DA14A2BA88F64DB4B5ABABE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src/org/openbravo/retail/storeserver/synchronization/ImportEntryWriterFilterAdapter.java b/src/org/openbravo/retail/storeserver/synchronization/ImportEntryWriterFilterAdapter.java --- a/src/org/openbravo/retail/storeserver/synchronization/ImportEntryWriterFilterAdapter.java +++ b/src/org/openbravo/retail/storeserver/synchronization/ImportEntryWriterFilterAdapter.java @@ -22,6 +22,7 @@ import org.jumpmind.symmetric.io.data.DataContext; import org.jumpmind.symmetric.io.data.writer.DatabaseWriterFilterAdapter; +import org.openbravo.replication.symmetricds.extensions.NamedExtensionPoint; import org.openbravo.service.importprocess.ImportEntryManager; /** @@ -29,7 +30,17 @@ * * @author mtaal */ -public class ImportEntryWriterFilterAdapter extends DatabaseWriterFilterAdapter { +public class ImportEntryWriterFilterAdapter extends DatabaseWriterFilterAdapter implements + NamedExtensionPoint { + + @Override + public String getName() { + return this.getClass().getSimpleName(); + } + + @Override + public void initialize() { + } @Override public void batchCommitted(DataContext context) { diff --git a/src/org/openbravo/retail/storeserver/synchronization/InventoryWriterFilterAdapter.java b/src/org/openbravo/retail/storeserver/synchronization/InventoryWriterFilterAdapter.java new file mode 100644 --- /dev/null +++ b/src/org/openbravo/retail/storeserver/synchronization/InventoryWriterFilterAdapter.java @@ -0,0 +1,86 @@ +/* + ************************************************************************* + * Openbravo DB Synchronization module for Retail + * Copyright (C) 2016 Openbravo SLU + * + * The content of this file is free software: you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + ************************************************************************ + */ + +package org.openbravo.retail.storeserver.synchronization; + +import java.math.BigDecimal; +import java.util.ArrayList; +import java.util.List; + +import org.jumpmind.db.model.Table; +import org.jumpmind.symmetric.io.data.CsvData; +import org.jumpmind.symmetric.io.data.DataContext; +import org.jumpmind.symmetric.io.data.writer.DatabaseWriterFilterAdapter; +import org.openbravo.replication.symmetricds.extensions.NamedExtensionPoint; + +/** + * Recompute inventory after each m_transaction record replication. + * + * @author mtaal + */ +public class InventoryWriterFilterAdapter extends DatabaseWriterFilterAdapter implements + NamedExtensionPoint { + + @Override + public String getName() { + return this.getClass().getSimpleName(); + } + + @Override + public void initialize() { + } + + @Override + public void afterWrite(DataContext context, Table table, CsvData data) { + if (table.getName().toUpperCase().equals("M_TRANSACTION")) { + final String[] parsedData = data.getParsedData(CsvData.ROW_DATA); + final String sql = "select M_UPDATE_INVENTORY (?,?,?,?,?,?,?,?,?,?,?,?,?);"; + final List<Object> params = new ArrayList<Object>(); + params.add(parsedData[table.getColumnIndex("ad_client_id")]); + params.add(parsedData[table.getColumnIndex("ad_org_id")]); + params.add("0"); + params.add(parsedData[table.getColumnIndex("m_product_id")]); + params.add(parsedData[table.getColumnIndex("m_locator_id")]); + params.add(parsedData[table.getColumnIndex("m_attributesetinstance_id")]); + params.add(parsedData[table.getColumnIndex("c_uom_id")]); + params.add(null); + String movementQtyStr = parsedData[table.getColumnIndex("movementqty")]; + if (movementQtyStr != null && movementQtyStr.length() > 0) { + params.add(new BigDecimal(movementQtyStr)); + } else { + params.add(null); + } + String quantityOrderStr = parsedData[table.getColumnIndex("quantityorder")]; + if (quantityOrderStr != null && quantityOrderStr.length() > 0) { + params.add(new BigDecimal(quantityOrderStr)); + } else { + params.add(null); + } + params.add(null); + params.add(BigDecimal.ZERO); + if (quantityOrderStr != null && quantityOrderStr.length() > 0) { + params.add(new BigDecimal(quantityOrderStr).multiply(new BigDecimal("-1"))); + } else { + params.add(null); + } + context.findTransaction().prepareAndExecute(sql, params.toArray()); + } + } +} diff --git a/src/org/openbravo/retail/storeserver/synchronization/MultiServerJSONSymmetricDSStarter.java b/src/org/openbravo/retail/storeserver/synchronization/MultiServerJSONSymmetricDSStarter.java new file mode 100644 --- /dev/null +++ b/src/org/openbravo/retail/storeserver/synchronization/MultiServerJSONSymmetricDSStarter.java @@ -0,0 +1,69 @@ +/* + ************************************************************************* + * Openbravo DB Synchronization module for Retail + * Copyright (C) 2016 Openbravo SLU + * + * The content of this file is free software: you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + ************************************************************************ + */ + +package org.openbravo.retail.storeserver.synchronization; + +import org.codehaus.jettison.json.JSONObject; +import org.openbravo.mobile.core.servercontroller.MobileServerController; +import org.openbravo.mobile.core.servercontroller.MultiServerJSONProcess.MultiServerJSONProcessHook; +import org.openbravo.replication.symmetricds.SynchronizationEngineProvider; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +/** + * Hook which gives Symmetric DS a kick to start processing right away. + * + * @author mtaal + */ +public class MultiServerJSONSymmetricDSStarter extends MultiServerJSONProcessHook { + + private static final Logger log = LoggerFactory + .getLogger(MultiServerJSONSymmetricDSStarter.class); + + @Override + public void doAction(JSONObject json) { + if (!MobileServerController.getInstance().isThisACentralServer()) { + return; + } + // use a separate thread to not block the main thread which needs to + // return values + try { + final Runnable runnable = new Runnable() { + + @Override + public void run() { + + try { + SynchronizationEngineProvider.getInstance().getEngine().route(); + SynchronizationEngineProvider.getInstance().getEngine().push(); + } catch (Throwable logIt) { + log.error(logIt.getMessage(), logIt); + } + } + }; + final Thread thread = new Thread(runnable); + thread.setDaemon(true); + thread.run(); + } catch (Throwable logIt) { + log.error(logIt.getMessage(), logIt); + } + } + +} diff --git a/src/org/openbravo/retail/storeserver/synchronization/OrderDocumentNoWriterFilterAdapter.java b/src/org/openbravo/retail/storeserver/synchronization/OrderDocumentNoWriterFilterAdapter.java new file mode 100644 --- /dev/null +++ b/src/org/openbravo/retail/storeserver/synchronization/OrderDocumentNoWriterFilterAdapter.java @@ -0,0 +1,141 @@ +/* + ************************************************************************* + * Openbravo DB Synchronization module for Retail + * Copyright (C) 2016 Openbravo SLU + * + * The content of this file is free software: you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + ************************************************************************ + */ + +package org.openbravo.retail.storeserver.synchronization; + +import org.jumpmind.db.model.Table; +import org.jumpmind.symmetric.io.data.CsvData; +import org.jumpmind.symmetric.io.data.DataContext; +import org.jumpmind.symmetric.io.data.writer.DatabaseWriterFilterAdapter; +import org.openbravo.dal.core.OBContext; +import org.openbravo.dal.service.OBDal; +import org.openbravo.replication.symmetricds.extensions.NamedExtensionPoint; +import org.openbravo.retail.posterminal.OBPOSApplications; + +/** + * Recompute last assigned number field in obposapplications. + * + * @author mtaal + */ +public class OrderDocumentNoWriterFilterAdapter extends DatabaseWriterFilterAdapter implements + NamedExtensionPoint { + + @Override + public String getName() { + return this.getClass().getSimpleName(); + } + + @Override + public void initialize() { + } + + @Override + public void afterWrite(DataContext context, Table table, CsvData data) { + if (table.getName().toUpperCase().equals("C_ORDER")) { + OBContext.setAdminMode(); + try { + + final String[] parsedData = data.getParsedData(CsvData.ROW_DATA); + // params.add(parsedData[table.getColumnIndex("ad_client_id")]); + + final String terminalId = parsedData[table.getColumnIndex("em_obpos_applications_id")]; + if (terminalId == null) { + // no webpos, nothing to do here + return; + } + + // NOTE NOTE NOTE: we can use DAL for reading, NOT for updating data + final OBPOSApplications terminal = OBDal.getInstance().get(OBPOSApplications.class, + terminalId); + + final String documentNo = parsedData[table.getColumnIndex("documentno")]; + final String documentTypeId = parsedData[table.getColumnIndex("c_doctype_id")]; + final boolean isReturn = documentTypeId.equals(terminal.getObposTerminaltype() + .getDocumentTypeForReturns().getId()); + + final boolean isQuotation = null != parsedData[table.getColumnIndex("quotation_id")]; + String updateColumn = null; + long updateValue = -1; + if (documentNo.indexOf("/") > -1) { + long documentNumber = Long + .parseLong(documentNo.substring(documentNo.lastIndexOf("/") + 1)); + updateValue = documentNumber; + if (isQuotation) { + if (terminal.getQuotationslastassignednum() == null + || documentNumber > terminal.getQuotationslastassignednum()) { + updateColumn = "quotationslastassignednum"; + } + } else if (isReturn) { + if (terminal.getReturnslastassignednum() == null + || documentNumber > terminal.getReturnslastassignednum()) { + updateColumn = "returnslastassignednum"; + } + } else { + if (terminal.getLastassignednum() == null + || documentNumber > terminal.getLastassignednum()) { + updateColumn = "lastassignednum"; + } + } + } else { + if (isQuotation) { + if (null != terminal.getQuotationdocnoPrefix()) { + long documentNumber = Long.parseLong(documentNo.replace( + terminal.getQuotationdocnoPrefix(), "")); + if (terminal.getQuotationslastassignednum() == null + || documentNumber > terminal.getQuotationslastassignednum()) { + updateColumn = "quotationslastassignednum"; + updateValue = documentNumber; + } + } + } + if (isReturn) { + if (null != terminal.getReturndocnoPrefix()) { + long documentNumber = Long.parseLong(documentNo.replace( + terminal.getReturndocnoPrefix(), "")); + if (terminal.getReturnslastassignednum() == null + || documentNumber > terminal.getReturnslastassignednum()) { + updateColumn = "returnslastassignednum"; + updateValue = documentNumber; + } + } + } else { + if (null != terminal.getOrderdocnoPrefix()) { + long documentNumber = Long.parseLong(documentNo.replace( + terminal.getOrderdocnoPrefix(), "")); + if (terminal.getLastassignednum() == null + || documentNumber > terminal.getLastassignednum()) { + updateColumn = "lastassignednum"; + updateValue = documentNumber; + } + } + } + } + + if (updateColumn != null) { + context.findTransaction().execute( + "UPDATE OBPOS_APPLICATIONS SET " + updateColumn + "=" + updateValue + + " WHERE obpos_applications_id='" + terminalId + "'"); + } + } finally { + OBContext.restorePreviousMode(); + } + } + } +} ![]() diff --git a/src/org/openbravo/mobile/core/servercontroller/MultiServerJSONProcess.java b/src/org/openbravo/mobile/core/servercontroller/MultiServerJSONProcess.java --- a/src/org/openbravo/mobile/core/servercontroller/MultiServerJSONProcess.java +++ b/src/org/openbravo/mobile/core/servercontroller/MultiServerJSONProcess.java @@ -37,6 +37,7 @@ import org.openbravo.model.common.enterprise.Organization; import org.openbravo.service.importprocess.ImportEntry; import org.openbravo.service.importprocess.ImportEntryArchive; +import org.openbravo.service.importprocess.ImportEntryArchivePreProcessor; import org.openbravo.service.importprocess.ImportEntryManager; import org.openbravo.service.importprocess.ImportEntryPreProcessor; import org.openbravo.service.json.JsonConstants; @@ -70,6 +71,11 @@ * * The source of the sending of the json is obtained from the json itself. * + * Note, additional features: if the _executeInOneServer property is passed in the json then an + * action is executed at most in one server, first central and if central is not available then in + * the store. No import entries are created to be replicated, the assumption is that the + * transactional tables are replicated. + * * For more information see this wiki page: * http://wiki.openbravo.com/wiki/Retail:Store_Server#Synchronized_Transactions * @@ -79,6 +85,7 @@ public static final String CALL_CENTRAL_PROP = "_tryCentralFromStore"; public static final String CALL_ONLY_CENTRAL_PROP = "_onlyDoCentralFromStore"; + public static final String EXECUTE_IN_ONE_SERVER = "_executeInOneServer"; public static final String RESULT_PROP = "_result"; public static final String SOURCE_PROP = "_source"; public static final String SOURCE_WEBPOS = "WEBPOS"; @@ -92,12 +99,20 @@ ImportEntryArchive.ENTITY_NAME); @Inject + @Any + private Instance<ImportEntryArchivePreProcessor> archiveEntryPreProcessors; + + @Inject private ImportEntryManager importEntryManager; @Inject @Any private Instance<ImportEntryPreProcessor> entryPreProcessors; + @Inject + @Any + private Instance<MultiServerJSONProcessHook> processHooks; + @Override public JSONObject exec(JSONObject jsonSent) { // logTime is used to relate log statements in begin and end to eachother @@ -269,6 +284,10 @@ setImportEntryId(null); } + for (MultiServerJSONProcessHook processor : processHooks) { + processor.doAction(returnResult); + } + // we get here if no exception was thrown in the inner code above return returnResult; } @@ -292,7 +311,7 @@ // back to the store server final JSONObject result = executeLocal(jsonSent); - if (!isErrorJson(result)) { + if (!isErrorJson(result) && !executeInOneServer(jsonSent)) { final JSONObject json = new JSONObject(jsonSent.toString()); // sent along from the central to store, set the source to CENTRAL json.put(SOURCE_PROP, SOURCE_CENTRAL); @@ -368,8 +387,10 @@ if (isErrorJson(result)) { return result; } - createImportEntry(messageId, jsonSent, result, null); - // processed is set in finally block of main loop + if (!executeInOneServer(jsonSent)) { + createImportEntry(messageId, jsonSent, result, null); + // processed is set in finally block of main loop + } return result; } @@ -381,7 +402,7 @@ } // a webrequest, create local copy for local processing - if (getImportEntryId() == null) { + if (getImportEntryId() == null && !executeInOneServer(jsonSent)) { // local copy final JSONObject json = new JSONObject(jsonSent.toString()); // set the source to central has it already was processed there, so @@ -409,8 +430,11 @@ if (isErrorJson(result)) { return result; } - createImportEntry(messageId, jsonSent, result, null); - // processed is set in finally block of main loop + if (!executeInOneServer(jsonSent)) { + // import entry will be replicated to central to be executed there + createImportEntry(messageId, jsonSent, result, null); + // processed is set in finally block of main loop + } return result; } @@ -425,6 +449,14 @@ } /** + * Execute the action in one server at most, assume that any transactions are replicated through + * other means than import entry. + */ + protected boolean executeInOneServer(JSONObject json) throws JSONException { + return json.has(EXECUTE_IN_ONE_SERVER) && json.getBoolean(EXECUTE_IN_ONE_SERVER); + } + + /** * Controls if the store should first call central and then create a local import entry for local * transactions. */ @@ -468,46 +500,12 @@ OBContext.setAdminMode(true); try { - // check if it is not there already or already archived - { - final Query qry = SessionHandler.getInstance().getSession() - .createQuery("select count(*) from " + ImportEntry.ENTITY_NAME + " where id=:id"); - qry.setParameter("id", messageId); - if (((Number) qry.uniqueResult()).intValue() > 0) { - log.debug("Entry already exists, ignoring it, id/typeofdata " + messageId + "/" - + getImportEntryDataType() + " json " + result); - return; - } - } - { - final Query qry = SessionHandler - .getInstance() - .getSession() - .createQuery("select count(*) from " + ImportEntryArchive.ENTITY_NAME + " where id=:id"); - qry.setParameter("id", messageId); - if (((Number) qry.uniqueResult()).intValue() > 0) { - log.debug("Entry already archived, ignoring it, id/typeofdata " + messageId + "/" - + getImportEntryDataType() + " json " + result); - return; - } + if (doesImportEntryExist(messageId)) { + return; } - ImportEntry importEntry = OBProvider.getInstance().get(ImportEntry.class); - importEntry.setId(messageId); - importEntry.setRole(OBDal.getInstance().get(Role.class, - OBContext.getOBContext().getRole().getId())); - importEntry.setNewOBObject(true); - importEntry.setImportStatus("Initial"); - importEntry.setImported(null); - importEntry.setTypeofdata(getImportEntryDataType()); - importEntry.setJsonInfo(result.toString()); - if (organization != null) { - importEntry.setOrganization(organization); - } + final ImportEntry importEntry = localCreateImportEntry(messageId, result, organization); - for (ImportEntryPreProcessor processor : entryPreProcessors) { - processor.beforeCreate(importEntry); - } OBDal.getInstance().save(importEntry); } finally { OBContext.restorePreviousMode(); @@ -515,6 +513,96 @@ // note: set to processed is done in a finally block later } + private ImportEntry localCreateImportEntry(String messageId, JSONObject json, + Organization organization) { + + ImportEntry importEntry = OBProvider.getInstance().get(ImportEntry.class); + importEntry.setId(messageId); + importEntry.setRole(OBDal.getInstance().get(Role.class, + OBContext.getOBContext().getRole().getId())); + importEntry.setNewOBObject(true); + importEntry.setImportStatus("Initial"); + importEntry.setImported(null); + importEntry.setTypeofdata(getImportEntryDataType()); + importEntry.setJsonInfo(json.toString()); + if (organization != null) { + importEntry.setOrganization(organization); + } + + for (ImportEntryPreProcessor processor : entryPreProcessors) { + processor.beforeCreate(importEntry); + } + return importEntry; + } + + private boolean doesImportEntryExist(String id) { + // check if it is not there already or already archived + { + final Query qry = SessionHandler.getInstance().getSession() + .createQuery("select count(*) from " + ImportEntry.ENTITY_NAME + " where id=:id"); + qry.setParameter("id", id); + if (((Number) qry.uniqueResult()).intValue() > 0) { + return true; + } + } + { + final Query qry = SessionHandler.getInstance().getSession() + .createQuery("select count(*) from " + ImportEntryArchive.ENTITY_NAME + " where id=:id"); + qry.setParameter("id", id); + if (((Number) qry.uniqueResult()).intValue() > 0) { + return true; + } + } + return false; + } + + /** + * Create an archive entry to log what has been done. + */ + protected void createArchiveEntry(String id, JSONObject json) throws JSONException { + if (doesImportEntryExist(id)) { + return; + } + // note import entry should only be created and not saved as then it would be replicated + // to other servers + final ImportEntry importEntry = localCreateImportEntry(id, json, null); + + OBContext.setAdminMode(true); + try { + // create the archive + final ImportEntryArchive archiveEntry = OBProvider.getInstance() + .get(ImportEntryArchive.class); + // copy properties with the same name + for (Property sourceProperty : entryEntity.getProperties()) { + // ignore these ones + if (sourceProperty.isOneToMany() || !archiveEntity.hasProperty(sourceProperty.getName())) { + continue; + } + Property targetProperty = archiveEntity.getProperty(sourceProperty.getName()); + // should be the same type + if (targetProperty.getDomainType().getClass() != sourceProperty.getDomainType().getClass()) { + continue; + } + try { + archiveEntry + .set(targetProperty.getName(), importEntry.getValue(sourceProperty.getName())); + } catch (Exception e) { + throw new OBException(e); + } + } + + for (ImportEntryArchivePreProcessor processor : archiveEntryPreProcessors) { + processor.beforeArchive(importEntry, archiveEntry); + } + + // as the id is also copied set it explicitly to new + archiveEntry.setNewOBObject(true); + OBDal.getInstance().save(archiveEntry); + } finally { + OBContext.restorePreviousMode(); + } + } + protected JSONObject executeLocal(JSONObject jsonSent) throws Exception { final JSONObject result = execute(jsonSent); @@ -545,46 +633,6 @@ JsonConstants.RPCREQUEST_STATUS_FAILURE); } - private void createArchiveEntry(String id, JSONObject json) throws JSONException { - // create an import entry through the import entry manager as it has - // some post processors which can add data, but don't commit it - importEntryManager.createImportEntry(id, getImportEntryDataType(), json.toString(), false); - final ImportEntry importEntry = OBDal.getInstance().get(ImportEntry.class, id); - - if (importEntry == null) { - // special case, the create above didn't create an import entry - // because it already existed in archive - // no need to create another archive import entry - return; - } - - // create the archive - final ImportEntryArchive archiveEntry = OBProvider.getInstance().get(ImportEntryArchive.class); - // copy properties with the same name - for (Property sourceProperty : entryEntity.getProperties()) { - // ignore these ones - if (sourceProperty.isOneToMany() || !archiveEntity.hasProperty(sourceProperty.getName())) { - continue; - } - Property targetProperty = archiveEntity.getProperty(sourceProperty.getName()); - // should be the same type - if (targetProperty.getDomainType().getClass() != sourceProperty.getDomainType().getClass()) { - continue; - } - try { - archiveEntry.set(targetProperty.getName(), importEntry.getValue(sourceProperty.getName())); - } catch (Exception e) { - throw new OBException(e); - } - } - // as the id is also copied set it explicitly to new - archiveEntry.setNewOBObject(true); - - OBDal.getInstance().save(archiveEntry); - // remove the import entry not needed anymore - OBDal.getInstance().remove(importEntry); - } - protected boolean bypassSecurity() { return true; } @@ -593,4 +641,8 @@ return true; } + public static abstract class MultiServerJSONProcessHook { + public abstract void doAction(JSONObject json); + } + } diff --git a/web/org.openbravo.mobile.core/source/data/ob-datasource.js b/web/org.openbravo.mobile.core/source/data/ob-datasource.js --- a/web/org.openbravo.mobile.core/source/data/ob-datasource.js +++ b/web/org.openbravo.mobile.core/source/data/ob-datasource.js @@ -235,6 +235,7 @@ var syncData = { messageId: params.messageId ? params.messageId : OB.UTIL.get_UUID(), _source: 'WEBPOS', + _executeInOneServer: true, posTerminal: OB.MobileApp.model.get('terminal').id, data: contentData }; diff --git a/web/org.openbravo.mobile.core/source/model/ob-terminal-model.js b/web/org.openbravo.mobile.core/source/model/ob-terminal-model.js --- a/web/org.openbravo.mobile.core/source/model/ob-terminal-model.js +++ b/web/org.openbravo.mobile.core/source/model/ob-terminal-model.js @@ -956,6 +956,7 @@ var syncData = { messageId: OB.UTIL.get_UUID(), _source: 'WEBPOS', + _executeInOneServer: true, posTerminal: OB.MobileApp.model.get('terminal').id, data: me.synchronizedData }; | |||||||
![]() |
||||||||
|
![]() |
|
(0087760) hgbot (developer) 2016-06-22 00:53 |
Repository: erp/pmods/org.openbravo.mobile.core Changeset: c25bf709408039c95d9f8bb32b202f65d3ccf88f Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Jun 22 00:53:07 2016 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c25bf709408039c95d9f8bb32b202f65d3ccf88f [^] Fixes issue 33235: Replicating transactions - research a different way to execute transactions in a multi-server environment DataSynchronizationProcess.java --> display the causing exception message in synchronized mode MultiServerJSONProcess.java --> execute a transaction in only one server if the correct json parameter was set, create archived import entry in a different way to prevent it interfering with any replication mechanism javascript changes --> send in the right parameter to force execution on one server. --- M src/org/openbravo/mobile/core/process/DataSynchronizationProcess.java M src/org/openbravo/mobile/core/servercontroller/MultiServerJSONProcess.java M web/org.openbravo.mobile.core/source/data/ob-datasource.js M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js --- |
(0087761) hgbot (developer) 2016-06-22 01:08 |
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization.but Changeset: 8c16380354a303c569b462358b87b8c24d5672c2 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Jun 22 01:08:16 2016 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/rev/8c16380354a303c569b462358b87b8c24d5672c2 [^] Related to issue 33235: Replicating transactions - research a different way to execute transactions in a multi-server environment Add specific transactional tables to the synchronized table --- M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml --- |
(0087762) hgbot (developer) 2016-06-22 01:10 |
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization Changeset: 917636f6cb987db465215007cdc7eb0901b283eb Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Jun 22 01:10:29 2016 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/917636f6cb987db465215007cdc7eb0901b283eb [^] Related to issue 33235: Replicating transactions - research a different way to execute transactions in a multi-server environment Implement writer filter adapters to update computed fields after replication. Add a multi-server json hook to give symmetric ds a kick. Added new tables to the synchronized table and store server dataset --- M src-db/database/sourcedata/AD_DATASET_COLUMN.xml M src-db/database/sourcedata/AD_DATASET_TABLE.xml M src-db/database/sourcedata/STRSYNC_EXCLUDEDCOL.xml M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml M src/org/openbravo/retail/storeserver/synchronization/ImportEntryWriterFilterAdapter.java A src/org/openbravo/retail/storeserver/synchronization/CustomerCreditWriterFilterAdapter.java A src/org/openbravo/retail/storeserver/synchronization/InventoryWriterFilterAdapter.java A src/org/openbravo/retail/storeserver/synchronization/MultiServerJSONSymmetricDSStarter.java A src/org/openbravo/retail/storeserver/synchronization/OrderDocumentNoWriterFilterAdapter.java --- |
(0088123) migueldejuana (viewer) 2016-07-01 07:34 |
Tested and reviewed |
![]() |
|||
Date Modified | Username | Field | Change |
2016-06-13 15:40 | mtaal | New Issue | |
2016-06-13 15:40 | mtaal | Assigned To | => mtaal |
2016-06-13 15:40 | mtaal | OBNetwork customer | => No |
2016-06-13 15:40 | mtaal | Triggers an Emergency Pack | => No |
2016-06-16 23:22 | mtaal | File Added: retail.storeserver.synchronization.but.diff | |
2016-06-16 23:22 | mtaal | File Added: retail.storeserver.synchronization.diff | |
2016-06-16 23:22 | mtaal | File Added: mobile-core.diff | |
2016-06-16 23:22 | mtaal | File Added: erp-core.diff | |
2016-06-17 08:44 | mtaal | File Deleted: mobile-core.diff | |
2016-06-17 08:44 | mtaal | File Deleted: retail.storeserver.synchronization.diff | |
2016-06-17 08:44 | mtaal | File Added: retail.storeserver.synchronization.diff | |
2016-06-17 08:45 | mtaal | File Added: mobile-core.diff | |
2016-06-22 00:50 | mtaal | Target Version | RR16Q4 => RR16Q3 |
2016-06-22 00:53 | hgbot | Checkin | |
2016-06-22 00:53 | hgbot | Note Added: 0087760 | |
2016-06-22 00:53 | hgbot | Status | new => resolved |
2016-06-22 00:53 | hgbot | Resolution | open => fixed |
2016-06-22 00:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c25bf709408039c95d9f8bb32b202f65d3ccf88f [^] |
2016-06-22 01:08 | hgbot | Checkin | |
2016-06-22 01:08 | hgbot | Note Added: 0087761 | |
2016-06-22 01:10 | hgbot | Checkin | |
2016-06-22 01:10 | hgbot | Note Added: 0087762 | |
2016-06-30 18:33 | AugustoMauch | Relationship added | causes 0033396 |
2016-07-01 07:34 | migueldejuana | Review Assigned To | => migueldejuana |
2016-07-01 07:34 | migueldejuana | Note Added: 0088123 | |
2016-07-01 07:34 | migueldejuana | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |