diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-10-31 13:09:47 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-10-31 13:09:47 +0700 |
| commit | f55c13bfc7eb34f5e4a713d6d3d8331366b129f9 (patch) | |
| tree | b86130b34c00fc3883c9f8a7ec8c3415597b332b /import_order_detail_altama.ktr | |
| parent | 80eb7ed96254273393459e0a275096d859e754ff (diff) | |
add order line while import soo altama
Diffstat (limited to 'import_order_detail_altama.ktr')
| -rw-r--r-- | import_order_detail_altama.ktr | 52 |
1 files changed, 42 insertions, 10 deletions
diff --git a/import_order_detail_altama.ktr b/import_order_detail_altama.ktr index ee2d2f3..273c45a 100644 --- a/import_order_detail_altama.ktr +++ b/import_order_detail_altama.ktr @@ -700,6 +700,18 @@ <decimal/> <group/> </field> + <field> + <name>Order Line</name> + <type>String</type> + <length>-1</length> + <precision>-1</precision> + <trim_type>none</trim_type> + <repeat>N</repeat> + <format/> + <currency/> + <decimal/> + <group/> + </field> </fields> <sheets> <sheet> @@ -809,7 +821,28 @@ <name>Serial No</name> <rename>serial</rename> </field> + <field> + <name>Order Line</name> + <rename>c_orderline_id</rename> + </field> <select_unspecified>N</select_unspecified> + <meta> + <name>c_orderline_id</name> + <rename>c_orderline_id</rename> + <type>Integer</type> + <length>-2</length> + <precision>-2</precision> + <conversion_mask/> + <date_format_lenient>false</date_format_lenient> + <date_format_locale/> + <date_format_timezone/> + <lenient_string_to_number>false</lenient_string_to_number> + <encoding/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + <storage_type/> + </meta> </fields> <attributes/> <cluster_schema/> @@ -843,14 +876,8 @@ <schema>public</schema> <table>soo_altama</table> <key> - <name>ref</name> - <field>ref</field> - <condition>=</condition> - <name2/> - </key> - <key> - <name>product</name> - <field>product</field> + <name>c_orderline_id</name> + <field>c_orderline_id</field> <condition>=</condition> <name2/> </key> @@ -862,7 +889,7 @@ <value> <name>ref</name> <rename>ref</rename> - <update>N</update> + <update>Y</update> </value> <value> <name>date_ordered</name> @@ -882,7 +909,7 @@ <value> <name>product</name> <rename>product</rename> - <update>N</update> + <update>Y</update> </value> <value> <name>price</name> @@ -924,6 +951,11 @@ <rename>serial</rename> <update>Y</update> </value> + <value> + <name>c_orderline_id</name> + <rename>c_orderline_id</rename> + <update>N</update> + </value> </lookup> <attributes/> <cluster_schema/> |