diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-11-16 11:58:43 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-11-16 11:58:43 +0700 |
| commit | 3cb5193b5e9fdbb38d387b99d88e51847aef34f7 (patch) | |
| tree | 6775d2e23611753fc47881c2d73d4a831f95af59 | |
| parent | c5667baea89c18694e05b44f9b94e62133069fa9 (diff) | |
add import parent id in partner
| -rw-r--r-- | import_partner.ktr | 7 | ||||
| -rw-r--r-- | import_sale_order.ktr | 5 |
2 files changed, 11 insertions, 1 deletions
diff --git a/import_partner.ktr b/import_partner.ktr index 1ecc7ea..3dfa132 100644 --- a/import_partner.ktr +++ b/import_partner.ktr @@ -622,6 +622,11 @@ <rename>is_potential</rename> <update>Y</update> </value> + <value> + <name>parent_id</name> + <rename>parent_id</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -649,7 +654,7 @@ <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 + <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id, is_potential, parent_id from res_partner where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> diff --git a/import_sale_order.ktr b/import_sale_order.ktr index 3817cc5..2e9189f 100644 --- a/import_sale_order.ktr +++ b/import_sale_order.ktr @@ -687,6 +687,11 @@ <rename>source_so</rename> <update>Y</update> </value> + <value> + <name>vendor</name> + <rename>vendor</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> |