diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-20 10:49:12 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-20 10:49:12 +0700 |
| commit | 378be935ef27121019d2e648212e34b05e02fe3b (patch) | |
| tree | ac82a2482e9ed746b2d7645f6302612892b83374 /import_leadtime_so_send.ktr | |
| parent | c6aa658ff158e8758065649e4cb7162bdd0315b3 (diff) | |
migrate to gcp (test)
Diffstat (limited to 'import_leadtime_so_send.ktr')
| -rw-r--r-- | import_leadtime_so_send.ktr | 39 |
1 files changed, 9 insertions, 30 deletions
diff --git a/import_leadtime_so_send.ktr b/import_leadtime_so_send.ktr index c34183d..a82b9b8 100644 --- a/import_leadtime_so_send.ktr +++ b/import_leadtime_so_send.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -478,7 +478,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -487,8 +487,8 @@ </attributes> </connection> <connection> - <name>erp indoteknik production</name> - <server>34.101.171.249</server> + <name>erp indoteknik production (localhost)</name> + <server>10.148.0.3</server> <type>POSTGRESQL</type> <access>Native</access> <database>erp_indoteknik</database> @@ -529,7 +529,7 @@ </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -560,7 +560,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> @@ -706,87 +706,66 @@ <fields> <field> <name>id</name> - <rename/> </field> <field> <name>so_number</name> - <rename/> </field> <field> <name>customer</name> - <rename/> </field> <field> <name>date_so_approved</name> - <rename/> </field> <field> <name>date_po_approved</name> - <rename/> </field> <field> <name>date_last_received</name> - <rename/> </field> <field> <name>date_last_send</name> - <rename/> </field> <field> <name>diff_po_so</name> - <rename/> </field> <field> <name>diff_po_so_in_hour</name> - <rename/> </field> <field> <name>diff_received_po</name> - <rename/> </field> <field> <name>diff_received_po_in_day</name> - <rename/> </field> <field> <name>diff_received_send</name> - <rename/> </field> <field> <name>diff_received_send_in_hour</name> - <rename/> </field> <field> <name>diff_received_send_in_day</name> - <rename/> </field> <field> <name>diff_so_send</name> - <rename/> </field> <field> <name>diff_so_send_in_day</name> - <rename/> </field> <field> <name>year_month</name> - <rename/> </field> <field> <name>year</name> - <rename/> </field> <field> <name>month</name> - <rename/> </field> <field> <name>day</name> - <rename/> </field> <field> <name>diff_po_so_in_day</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -815,7 +794,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>erp indoteknik production</connection> + <connection>erp indoteknik production (localhost)</connection> <sql>select * from v_leadtime_so_to_send_wf</sql> <limit>0</limit> <lookup/> |