diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-11-17 09:31:09 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-11-17 09:31:09 +0700 |
| commit | 6d481d4f92e157c620818c446d15f50c5edde14e (patch) | |
| tree | eea9c8a3746fc7b9296f0b6947267d57015b61b7 /import_partner.ktr | |
| parent | 7ebd4feeb5dcb847cffdfbf8937200fad00b6ba6 (diff) | |
add mobile telp email while import partner, and import payment term and property
Diffstat (limited to 'import_partner.ktr')
| -rw-r--r-- | import_partner.ktr | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/import_partner.ktr b/import_partner.ktr index 3dfa132..4e8c277 100644 --- a/import_partner.ktr +++ b/import_partner.ktr @@ -627,6 +627,21 @@ <rename>parent_id</rename> <update>Y</update> </value> + <value> + <name>email</name> + <rename>email</rename> + <update>Y</update> + </value> + <value> + <name>phone</name> + <rename>phone</rename> + <update>Y</update> + </value> + <value> + <name>mobile</name> + <rename>mobile</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -654,7 +669,8 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id, is_potential, parent_id + <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, +kecamatan_id, kelurahan_id, is_potential, parent_id, email, phone, mobile from res_partner where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> |