tag:blogger.com,1999:blog-91039740214187671892024-03-06T10:05:30.783+07:00โปรพอประมาณแบ่งๆ กันรู้ แบ่งๆ กันดู จะได้รู้และพัฒนาไปพร้อมกันUnknownnoreply@blogger.comBlogger614125tag:blogger.com,1999:blog-9103974021418767189.post-62635480910628327632024-03-06T10:04:00.004+07:002024-03-06T10:04:39.939+07:00Alfresco มีปัญหา Load CPU เยอะค้นหาไม่ได้ Error <p>Alfresco มีปัญหา Run CPU เยอะค้นหาไม่ได้ Error<br />แก้ปัญหาโดย<br />ใช้วิธีตั้ง
Crontab ให้ Restart service ตอน 8.40 น. แต่บางวันก็ต้อง Restart Manual
อีกรอบ เป็นทุกวันตอนเช้า หลังจาก Restart ไป
ก็ใช้งานได้ทั้งวันและจะเป็นอีกทีในตอนเช้าของวันต่อไป<br />Error ค้นหาไฟล์ไม่พบ<br /></p><blockquote class="uncited"><div>search
failed due to system error: 0822154976 request failed 500
/solr/alfresco/alfresco?wt=json&fl=dbid%2cscore&rows=500&df=text&start=0&locale=en_us&fq=%7b%21afts%7dauthority_filter_from_json&fq=%7b%21afts%7dtenant_filter_from_json</div></blockquote><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirpXVADwyP0p_i-hzHcmtch210V6JmPtyENUag2kD97rYOAy5Uzkld_panGdiTuahDxgQoFE3Ma0vuzifwyGErvbRb8gm7qeOPkMMVNNoHkct3TnhPAAz5v4uB6Nlc2YE9bKBiN-IoGFXCcwfZmczKFD0tV6IWNucVt8XA9fYoM8aIoUP-nRy00592Pw4/s1534/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="438" data-original-width="1534" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirpXVADwyP0p_i-hzHcmtch210V6JmPtyENUag2kD97rYOAy5Uzkld_panGdiTuahDxgQoFE3Ma0vuzifwyGErvbRb8gm7qeOPkMMVNNoHkct3TnhPAAz5v4uB6Nlc2YE9bKBiN-IoGFXCcwfZmczKFD0tV6IWNucVt8XA9fYoM8aIoUP-nRy00592Pw4/s320/1.png" width="320" /></a></div></dl></div><p>ส่งผลให้ กิน CPU ที่ตัว Server Alfresco และตัว VMware</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipG1DNiR5qp59x5Dati3dyHwLuCGHj5mkUoCpO9aBOGhPQdEqXl_tTzxXMzOHosPGk_AC0VC4aGtxJyqVsqGrjENfoAic0d3Mvlvx-bgz9xtu_mxfmal_doTDYloJ0G79JVR-McdXmEvK_qMBDfpqaCGIXgg2jv5jlcvQhn60zlJhFPeAJKtYTOjUm_B4/s1570/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="498" data-original-width="1570" height="102" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipG1DNiR5qp59x5Dati3dyHwLuCGHj5mkUoCpO9aBOGhPQdEqXl_tTzxXMzOHosPGk_AC0VC4aGtxJyqVsqGrjENfoAic0d3Mvlvx-bgz9xtu_mxfmal_doTDYloJ0G79JVR-McdXmEvK_qMBDfpqaCGIXgg2jv5jlcvQhn60zlJhFPeAJKtYTOjUm_B4/s320/2.png" width="320" /></a></div><p>มี Process JAVA run CPU สูงผิดปกติ <br /></p><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgir_2JmL4gYV4hMlD9sNv38sZf370iSn5ksH9YJ8sEp6ITut5NxgUr7NHwqLhhZbqARdYKGbzaHDVHsybhkBfOtpQUD4G2lh0aLiqKU8ONDM4sbPX06F_GO5gOqCCiz34pAZFCbkmZ0Vt58xQhyphenhyphenL5A4rHFK3OUE85iSZxKVP2BmSQUFWcVZIClQ_Afhkk/s734/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="326" data-original-width="734" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgir_2JmL4gYV4hMlD9sNv38sZf370iSn5ksH9YJ8sEp6ITut5NxgUr7NHwqLhhZbqARdYKGbzaHDVHsybhkBfOtpQUD4G2lh0aLiqKU8ONDM4sbPX06F_GO5gOqCCiz34pAZFCbkmZ0Vt58xQhyphenhyphenL5A4rHFK3OUE85iSZxKVP2BmSQUFWcVZIClQ_Afhkk/s320/3.png" width="320" /></a></div></dl></div>Process บางตัว Run เป็นเวลานาน กว่า Process อื่น ๆ <br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqsloQMt0xziaBoU7qShmAB4pqkgZqFlS2liX-FlnWGYRu7LxvWEI0woCNEk1RFU-QMqLcW9tt8XJKFPWEKH7beC5m7PMzVSf0Ez9zgom4HT6B1FQJe68_GqT0watx0YJwzBpgxhnjtMdzJSCxmVZI3eFYHgDSRTUyLCwRe2innLxekeUInhaMYEHiBR4/s1917/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="51" data-original-width="1917" height="9" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqsloQMt0xziaBoU7qShmAB4pqkgZqFlS2liX-FlnWGYRu7LxvWEI0woCNEk1RFU-QMqLcW9tt8XJKFPWEKH7beC5m7PMzVSf0Ez9zgom4HT6B1FQJe68_GqT0watx0YJwzBpgxhnjtMdzJSCxmVZI3eFYHgDSRTUyLCwRe2innLxekeUInhaMYEHiBR4/s320/4.png" width="320" /></a></div></dl></div><blockquote class="uncited"><div>USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND<br />root
3703 52.5 18.7 2161208 1533760 ? Sl Mar05 372:14
/DATA/alfresco/java/bin/java
-Djava.util.logging.config.file=/DATA/alfresco/tomcat/conf/logging.properties
-XX:MaxPermSize=512m -Xms128m -Xmx1024m -XX:-DisableExplicitGC -D</div></blockquote><br />เมื่อ Restart service Alfresco process นี้จะเริ่ม Run ใหม่<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwJsSt7UlOGLH9HuMNRFrgFlQ8MF3yiPtWgOBLtF3It4hepwVJQFkhYFF7sJ2otzTca0RZMM2XKn0CRevPp402Qv0mhw0EVGiDKxUcmnwX5yiFD67R2j8mDoGOOA3ZjPSWO8l_F7XZxYd5A-1Sv8BOgfTBNP9uAQ53Gec5Qf_8YArWykurcS9ibjoEpBU/s1912/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="63" data-original-width="1912" height="11" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwJsSt7UlOGLH9HuMNRFrgFlQ8MF3yiPtWgOBLtF3It4hepwVJQFkhYFF7sJ2otzTca0RZMM2XKn0CRevPp402Qv0mhw0EVGiDKxUcmnwX5yiFD67R2j8mDoGOOA3ZjPSWO8l_F7XZxYd5A-1Sv8BOgfTBNP9uAQ53Gec5Qf_8YArWykurcS9ibjoEpBU/s320/5.png" width="320" /></a></div></dl></div><span style="font-weight: bold;">ทดลองวันที่ 20240306</span><br />แก้ปัญหาโดย<br />แก้ไฟล์ ctl.sh เพิ่ม MaxPermSize , Xms, Xmx<br /><blockquote class="uncited"><div>nano /DATA/alfresco/tomcat/scripts/ctl.sh</div></blockquote>เดิม<br /><blockquote class="uncited"><div>
#export JAVA_OPTS="-XX:MaxPermSize=512m -Xms128m -Xmx1024m
-XX:-DisableExplicitGC -Djava.awt.headless=true
-Dalfresco.home=/DATA/alfresco -Dcom.sun.management.jmxremote
-Dsun.security.ssl.allowUnsafeRenegotiation=true"</div></blockquote>แก้ใหม่<br /><blockquote class="uncited"><div>
export JAVA_OPTS="-XX:MaxPermSize=1024m -Xms512m -Xmx2048m
-XX:-DisableExplicitGC -Djava.awt.headless=true
-Dalfresco.home=/DATA/alfresco -Dcom.sun.management.jmxremote
-Dsun.security.ssl.allowUnsafeRenegotiation=true"</div></blockquote>และ<br />เดิม<br /><blockquote class="uncited"><div>
#export JAVA_OPTS="-XX:MaxPermSize=512m -Xms128m -Xmx1024m
-XX:-DisableExplicitGC -Djava.awt.headless=true
-Dalfresco.home=/DATA/alfresco -Dcom.sun.management.jmxremote
-Dsun.security.ssl.allowUnsafeRenegotiation=true"</div></blockquote>แก้ใหม่<br /><blockquote class="uncited"><div>
export JAVA_OPTS="-XX:MaxPermSize=1024m -Xms512m -Xmx2048m
-XX:-DisableExplicitGC -Djava.awt.headless=true
-Dalfresco.home=/DATA/alfresco -Dcom.sun.management.jmxremote
-Dsun.security.ssl.allowUnsafeRenegotiation=true"</div></blockquote><br /><br />กลับไปใช้ Crontab restart ทุกเช้า 5.30 น. เหมือนเดิม<br /><br /><a class="postlink" href="https://hub.alfresco.com/t5/alfresco-content-services-forum/java-heap-space-issue-on-solr4/m-p/57364#M3201">https://hub.alfresco.com/t5/alfresco-content-services-forum/java-heap-space-issue-on-solr4/m-p/57364#M3201</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-41949196774453895062024-02-08T09:50:00.001+07:002024-02-08T09:50:03.903+07:00jquery-ui ให้ข้อความแสดงด้านบน Texbox เมื่อพิ่มพ์ autocomplete <p> jquery-ui ให้ข้อความแสดงด้านบน Texbox เมื่อพิ่มพ์ autocomplete ถ้าไม่แก้ข้อความจะอยู่ข้างหลัง Box<br />ต้องแก้ ไฟล์ css ของ jquery-ui เช่น<br />jquery-ui-1.13.1-Custom.css<br />เพิ่ม <span style="color: red;">z-index</span> <br /></p><div class="codebox"><div class="codeholder"><div class="css" id="cb70796" style="font-family: monospace;"><ol><li class="li1"><span style="color: #6666ff;">.ui-autocomplete</span> <span style="color: #66cc66;">{</span></li><li class="li2"> <span style="color: black;">position</span>: <span style="color: #993333;">absolute</span>;</li><li class="li1"> <span style="color: black;">top</span>: <span style="color: #993333;">0</span>;</li><li class="li2"> <span style="color: black;">left</span>: <span style="color: #993333;">0</span>;</li><li class="li1"> <span style="color: black;">cursor</span>: <span style="color: #993333;">default</span>;</li><li class="li2"> <span style="color: black;">z-index</span>: <span style="color: #993333;">1500</span></li><li class="li1"><span style="color: #66cc66;">}</span></li></ol></div></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-42902352423111677422023-12-25T13:28:00.005+07:002023-12-25T13:28:45.034+07:00Ping Check Internet Switch Network Notification Line.<p>Ping Check Internet Switch Network Notification Line.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4_dAZ12L1nVpjLVJxAq4KM-Zd0xMnDvhEhFOXu8_JBx53pGKfinjFQmjF_bL55aWgpN2RVxbwyWjKIru49Fgn66J6DPurVPUdZf9MV4YgXg0XtuebkPZv7-47zPvxUnl-F95-TrR_NMem41uqWJfVQHSz7gj2rGSkIPZmDk7Gzpt7S-CvpCMj_tmsk_8/s1052/Screenshot_2023-12-25-11-41-31-585_jp.naver.line.android.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="1052" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4_dAZ12L1nVpjLVJxAq4KM-Zd0xMnDvhEhFOXu8_JBx53pGKfinjFQmjF_bL55aWgpN2RVxbwyWjKIru49Fgn66J6DPurVPUdZf9MV4YgXg0XtuebkPZv7-47zPvxUnl-F95-TrR_NMem41uqWJfVQHSz7gj2rGSkIPZmDk7Gzpt7S-CvpCMj_tmsk_8/s320/Screenshot_2023-12-25-11-41-31-585_jp.naver.line.android.png" width="320" /></a></div><p><span style="font-weight: bold;">1.</span> ใช้งานที่ เครื่อง VMware .2.99 <br /> 1.1.ลากสายจาก Router wifi Fttx เข้า VMware <br /> 1.2.ตั้งค่า Virtual switches ชื่อ FttxWifi<br /> 1.3.ตั้งค่า Add port group ชื่อ FttxWifi<br /><br /><span style="font-weight: bold;">2. </span>ติดตั้ง 22.04 add network 2 Adapter<br />- วง 2 DMZ<br />- และ FTTX รับ DHCP จาก FttxWifi<br />- update upgrade ตั้ง Time zone <br />set-timezone Asia/Bangkok<br /><br /><span style="font-weight: bold;">3.</span> config ip<br />nano /etc/netplan/00-installer-config.yaml<br /><br /></p><blockquote class="uncited"><div>network:<br /> ethernets:<br /> ens160: # Fix .2<br /> dhcp4: false<br /> addresses: [192.168.2.8/24]<br /> nameservers:<br /> addresses: [192.168.2.2,8.8.8.8]<br /> routes:<br /> - to: default<br /> via: 192.168.2.2<br /> ens192: # DHCP form fttx TOT.<br /> dhcp4: true<br /> version: 2</div></blockquote><br /><br /><br />3.1. fix ip .2<br />3.2. fttx รับ DHCP จาก FttxWifi Network (ข้อ 1.3)<br /><br /><span style="font-weight: bold;">4.</span> นำไปใช้ด้วยคำสั่ง หรือ reboot เครื่อง<br /><blockquote class="uncited"><div>netplan apply </div></blockquote><br /><span style="font-weight: bold;">5. </span>ตรวจเช็ค IP ดูว่าได้ IP ทั้งสองหรือไม่<br /><blockquote class="uncited"><div>ifconfig</div></blockquote><br /><br />(ขั้นตอนนี้อาจจะไม่ได้ใช้งาน)<br />ติดตั้ง network-manager แล้ว Reboot เครื่อง<br />apt-get install network-manager<br /><br /><span style="font-weight: bold;">6.</span> Code เช็ค และแจ้งเตือน XXXXXXXXXX คือ ID ของ Line ที่ต้องการส่งเข้า<br />CheckNet.sh<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb65952" style="font-family: monospace;"><ol><li class="li1">#!/bin/bash</li><li class="li2"> ping -c 1 -t 116 <a class="postlink" href="http://www.google.com">http://www.google.com</a></li><li class="li1"> if [[ "$?" == "1" ]] # 1 is internet is down.</li><li class="li2"> then</li><li class="li1"> # Net fttx down. change up to .2</li><li class="li2"> ifconfig ens160 up # .2</li><li class="li1"> ifconfig ens192 down # fttx</li><li class="li2"> sleep 5 # Wait switch network.</li><li class="li1"> </li><li class="li2"> ################## Test To Line ###############################</li><li class="li1">
#curl -X POST -H 'Authorization: Bearer XXXXXXXXXX' -F
'message=Internet FTTX down.Please check! From IP 192.168.2.8' <a class="postlink" href="https://notify-api.line.me/api/notify">https://notify-api.line.me/api/notify</a></li><li class="li2"> ################## To It Group ################################</li><li class="li1">
curl -X POST -H 'Authorization: Bearer XXXXXXXXXX' -F
'message=Internet FTTX down.Please check! From IP 192.168.2.8' <a class="postlink" href="https://notify-api.line.me/api/notify">https://notify-api.line.me/api/notify</a></li><li class="li2"> #else</li><li class="li1"> # Net fttx up. down .2</li><li class="li2"> #ifconfig ens192 up # fttx</li><li class="li1"> #ifconfig ens160 down # .2</li><li class="li2"> fi</li><li class="li1"> </li></ol></div></div></div><br /><span style="font-weight: bold;">7.</span> Code เมื่อตรวจสอบเสร็จแล้วกลับไปใช้ Network FttxWifi<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb50" style="font-family: monospace;"><ol><li class="li1">SwitchToFttx.sh</li><li class="li2">#!/bin/bash</li><li class="li1"> # Net fttx up. down .2</li><li class="li2"> ifconfig ens192 up # fttx</li><li class="li1"> ifconfig ens160 down # .2</li></ol></div></div></div><br /><br /><span style="font-weight: bold;">8.</span> Code สำหรับปิด DMZ เพื่อให้ใช้งาน FttxWifi<br />DownDMZ.sh<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb83510" style="font-family: monospace;"><ol><li class="li1">#!/bin/bash</li><li class="li2"> ifconfig ens160 down # .2</li></ol></div></div></div><br /><br /><span style="font-weight: bold;">9. </span>ใส่ ไว้ใน cron เพื่อให้ทำตอนเปิดเครื่อง<br />crontab -e เมื่อเปิดเครื่องให้ปิด DMZ เพื่อใช้ Network FttxWifi.<br /><blockquote class="uncited"><div>#Down DMZ Network When Start.<br />@reboot /home/sa/DownDMZ.sh<br /><br />#Check internet Fttx Wifi.<br />5 8-18 * * 1-6 bash /home/sa/CheckNet.sh<br /><br /># 1 Hour switch to fttx wifi disable dmz. For check Fttx again.<br />0 8-18 * * 1-6 bash /home/sa/SwitchToFttx.sh</div></blockquote><br /><br /><br /><span style="font-weight: bold;">การทำงาน</span><br /><span style="font-weight: bold;">1. </span>เปิดเครื่อง ปิด Network .2 เปิดใช้เฉพาะ FTTX<br /><span style="font-weight: bold;">2. </span>เช็ค
Ping ทุก 5 นาที วันจันทร์ - เสาร์ เวลา 8 - 18 น. ถ้า เน็ตเสีย ปิด
Network FTTX เปิด Network .2 เพื่อส่งแจ้งเตือนทาง Line คำสั่ง Check<br />bash CheckNet.sh<br />เมื่อได้รับเตือนต้องเข้าเช็ค ว่า Fttx เสียหรือไม่ ถ้าเช็ค Fttx ใช้งานได้แล้ว ให้ Run คำสั่ง<br />bash SwitchToFttx.sh <br />เพื่อกลับไปใช้ Network Fttx และปิด Network .2<br /><span style="font-weight: bold;">3.</span> กรณีไม่ได้เข้าเช็ครออีก 1 ชั่วโมง จะทำ Auto Switch<br />bash SwitchToFttx.sh<br />เพื่อกลับไปใช้เน็ต FTTX ปิดวง .2 <br />และเช็คซ้ำอีกครั้งและแจ้งเตือนถ้าเน็ต Fttx ยังเสียอยู่Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-73569139594331592122023-12-25T13:26:00.001+07:002023-12-25T13:26:25.882+07:00 Axapta กู้คืนข้อมูลบางส่วนย้อนหลัง<p> Axapta กู้คืนข้อมูลบางส่วนย้อนหลัง เช่น 30/11/2023 ปิด Inventory
แล้วข้อมูลมีปัญหา ต้องเอาข้อมูลย้อนหลัง 1 อาทิตย์ มากู้
แล้วทำการคีย์เอกสารใหม่<br /><br />โดยใช้วิธีดึงข้อมูลจาก Database ที่ต้องการมาใส่ Database ก้อนที่ใช้อยู่ปัจจุบัน ทำใน Local ก่อนแล้วค่อยดึงข้ามเครื่องทำในของจริง<br />เช่น Database AC_Local คือข้อมูลที่ต้องการเอา , Suwit_Local คือข้อมูลที่ใช้ปัจจุบัน<br />โดยฐานข้อมูลที่ใช้จะมี 2 ตัว<br />A. <span style="font-weight: bold;">Database ที่จะนำจะเอาข้อมูล</span>
AC_Local คือข้อมูลที่ใช้งาน ถึงวันที่ 11/12/2023 เป็นข้อมูลที่
Inventory ไม่ถูกต้อง
แต่ต้องการนำข้อมูลบางส่วนมาใช้เพื่อไม่ต้องคีย์เอกสารใหม่ทั้งหมด<br />B. <span style="font-weight: bold;">Database จริง</span> Suwit_Local คือข้อมูลวันที่ 1/12/2023 สั่งปิด Inventory ใหม่ ให้ข้อมูลถูกต้อง พร้อมที่จะดึงข้อมูลมาใส่เพิ่ม<br /></p><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS9pg98Q1Da3MOR0EMTkGiN-7_y1DdElUokdwAx5djmaKlS5XBNWcsNJOlniSUjMbPhYQ-_Mp8brQpnG5dmtMT979v9eb0S9_I3pyGzpztfmlGU0CndDDybCxJ8VB309i7rgE-16DsrhFl3M_78PIgpsQgO0RIrmtlkab4cMH4-Jx-bQfs9Vs40Al_Ki4/s400/0.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="287" data-original-width="400" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS9pg98Q1Da3MOR0EMTkGiN-7_y1DdElUokdwAx5djmaKlS5XBNWcsNJOlniSUjMbPhYQ-_Mp8brQpnG5dmtMT979v9eb0S9_I3pyGzpztfmlGU0CndDDybCxJ8VB309i7rgE-16DsrhFl3M_78PIgpsQgO0RIrmtlkab4cMH4-Jx-bQfs9Vs40Al_Ki4/s320/0.png" width="320" /></a></div><dt><br /></dt></dl></div><span style="font-weight: bold;">***** สำคัญ ******</span><br />A. จะให้ดีควรหยุดสร้างเอกสาร หยุด Post ทุกอย่างก่อน เลขที่ และ RecId จะได้ไม่ซ้ำ <br />B. แต่ถ้าจะมีการคีย์เอกสารเพิ่มเติม ต้องไปเปลี่ยน Number sequence เพื่อให้เลขที่สร้างมาใหม่ไม่ซ้ำกับเลขเดิม<br />เช่น เลขที่เอกสาร Movemenet, Transfer , PO, PD<br />IV_03 : Inventory jouranal number<br />PO_01 : Purchase order<br />PD_PD : Production order number<br />โดยดูข้อมูลจาก Database AC_Local ว่าเลขที่ของแต่ละเอกสาร Run ถึงไหนแล้ว + เพิ่มนิดหน่อย เพื่อไม่ให้เลขซ้ำกัน<br />C. แต่ถ้าทำไปแล้วต้องกรองเอกสารที่เลขที่ซ้ำออกไม่ต้องนำเข้าเพราะจะ Error แล้วให้คีย์เพิ่มเอง<br />เช่น เอกสาร Movement, Transfer มีการคีย์ Run ไปก่อนจึงต้องกรองออกใน Code <br /><br /><span style="font-weight: bold;">วิธี Import Data โดยใช้ SQL Server Enterprise Manager</span><br />ข้อมูลที่ต้องนำคืน คือช่วงวันที่<br />'2023-12-02 00:00:00'<br />'2023-12-11 00:00:00'<br />โดย <br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg58gUnFsCy5Puebs0_HNhtIw1oh16vL2W71BMH3-WKvy7j52nQcOYiArHR4mQuNqzqk0T5viUOOkiHCBY8WpkhAqfcd6yg_onCpdQCV_3WMdAPkn2AiBwU6U_FB92UhSsuwsK2pacbco9HREMevzg5zHlyG0bQk5Ck6i8vlUFRy-ovXf4UIhtm-iXhMzo/s400/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="287" data-original-width="400" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg58gUnFsCy5Puebs0_HNhtIw1oh16vL2W71BMH3-WKvy7j52nQcOYiArHR4mQuNqzqk0T5viUOOkiHCBY8WpkhAqfcd6yg_onCpdQCV_3WMdAPkn2AiBwU6U_FB92UhSsuwsK2pacbco9HREMevzg5zHlyG0bQk5Ck6i8vlUFRy-ovXf4UIhtm-iXhMzo/s320/1.png" width="320" /></a></div></dl></div><p>1. คลิ๊กขวาที่ ฐานข้อมูลปัจจุบัน เลือก All Tasks --> Import Data กด Next <br />2. เลือก Source ใส่ user : password กด Next</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgn5BLZc9hBiNIOiYdTnEHYqTMRXgQJP1nTN61cIp4KB3m5bmEssxB9nEWhY_d8HNUrEGUXxcSauougBpufCLsKUlVDIk-2LmwbSAMuwdsEjf2VkS_99filQM7uwIFJ8LtWzdZuwBsHIA6-RTeudAS4lwJ2oIL7U2ezoPcXoSbq0Fr8qfG_lmUMawaTYk/s504/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="384" data-original-width="504" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgn5BLZc9hBiNIOiYdTnEHYqTMRXgQJP1nTN61cIp4KB3m5bmEssxB9nEWhY_d8HNUrEGUXxcSauougBpufCLsKUlVDIk-2LmwbSAMuwdsEjf2VkS_99filQM7uwIFJ8LtWzdZuwBsHIA6-RTeudAS4lwJ2oIL7U2ezoPcXoSbq0Fr8qfG_lmUMawaTYk/s320/2.png" width="320" /></a></div><p>3. เลือก Destination</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkTBb4H-nG2-Uycp4tDb172VL7TxJYPP8X0vKeCG5Ozr6Czhi1sTcCaV-qdH91OyzvBaXgJ7Z_awa4tK4Nq5SPCDYwbm-OKbYXBjdgxzwcWknlXrOfX62nKEyECLtsXW64PlOOYqEVa2liFAkSvjkwHDA53Ar3ztkkzJbGgMwzQ4PtrgEoDhfiJZRcGxw/s500/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="382" data-original-width="500" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkTBb4H-nG2-Uycp4tDb172VL7TxJYPP8X0vKeCG5Ozr6Czhi1sTcCaV-qdH91OyzvBaXgJ7Z_awa4tK4Nq5SPCDYwbm-OKbYXBjdgxzwcWknlXrOfX62nKEyECLtsXW64PlOOYqEVa2liFAkSvjkwHDA53Ar3ztkkzJbGgMwzQ4PtrgEoDhfiJZRcGxw/s320/3.png" width="320" /></a></div><p>4. เลือกรูปแบบที่ต้องการใช้งาน</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioRMSSkFFGkVcAMaLWEYwutICzAswnYMK47mFToNSgvjXqHvWSD0CWPB_uOr6v7A2VVe39sm9Vn4aMbkYCysOPBoFoZgI22n9TyJPO7XoGhFjbYVOmRz0d2UvyRw7mkVhY_ZvX5mXyg-aZvIz9ywmxIJN_k4tky9CZWTFLjx6-htKqh_EvDcgl4tO9lck/s501/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="384" data-original-width="501" height="245" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioRMSSkFFGkVcAMaLWEYwutICzAswnYMK47mFToNSgvjXqHvWSD0CWPB_uOr6v7A2VVe39sm9Vn4aMbkYCysOPBoFoZgI22n9TyJPO7XoGhFjbYVOmRz0d2UvyRw7mkVhY_ZvX5mXyg-aZvIz9ywmxIJN_k4tky9CZWTFLjx6-htKqh_EvDcgl4tO9lck/s320/4.png" width="320" /></a></div><p>จะใช้ 2 ข้อนี้<br /><span style="font-weight: bold;">หัวข้อที่ 1</span><br />Copy table : สำหรับ Copy Table ทั้งหมดและ ข้อมูลไปอีก Table ใหม่ Table ที่จะรับข้อมูลต้องไม่มีข้อมูลหรือว่าง<br /><br /><span style="font-weight: bold;">หัวข้อที่ 2</span><br />Use a query : สำหรับใช้ query กรองข้อมูลบางส่วนที่เราต้องการ ไม่ได้เอาไปทั้งหมด<br />5. จะใช้ Query Builder หรือ เขียนคำสั่ง SQL ก็ได้แล้วใช้ปุ่ม Parse เพื่อเช็คความถูกต้อง กด Next</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxYyQaoeSD8fD8NN5Ac-NxPJ455jpbRHnhqrjEcaY03ExaPmo2WQUBvp-swwUcVKC1gHnVU1YfAItFj_aYW_ph-5OP61pxVGAubWAxUFGb9FtI7YGln4gYeRNryPnIwxh8ngN0AkEkY3thzXzHgkyY8SXntqw4PnvjDGdnIir4J5IN7UXTxMYXMwFR6BA/s501/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="389" data-original-width="501" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxYyQaoeSD8fD8NN5Ac-NxPJ455jpbRHnhqrjEcaY03ExaPmo2WQUBvp-swwUcVKC1gHnVU1YfAItFj_aYW_ph-5OP61pxVGAubWAxUFGb9FtI7YGln4gYeRNryPnIwxh8ngN0AkEkY3thzXzHgkyY8SXntqw4PnvjDGdnIir4J5IN7UXTxMYXMwFR6BA/s320/5.png" width="320" /></a></div><p><br />6. เลือก Table ที่ต้องการเก็บข้อมูล เช่น InventTable,
PurchTable หรือ Table อื่น ๆ ตามที่ต้องการ กดปุ่ม Preview
เพื่อดูข้อมูลบางส่วน ว่าถูกหรือไม่ แล้วกด Next</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5uFXm9TCvWcqpK8jdezX7HCfA2oDps1y_Xo289De9rcLaE8JAuXK4s3XDF4RxkieUXCGiuqrH21J-fotwLCDRTdcGzeCFPhnIalaP_9S3VrUwCl0GUxMQmtjNKGs4gEj4gRzOHRovh2_0BPaM79V3bPky2RDE95BXU4iEMXHD2cXmf7_sHo7d3bfAWZs/s501/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="383" data-original-width="501" height="245" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5uFXm9TCvWcqpK8jdezX7HCfA2oDps1y_Xo289De9rcLaE8JAuXK4s3XDF4RxkieUXCGiuqrH21J-fotwLCDRTdcGzeCFPhnIalaP_9S3VrUwCl0GUxMQmtjNKGs4gEj4gRzOHRovh2_0BPaM79V3bPky2RDE95BXU4iEMXHD2cXmf7_sHo7d3bfAWZs/s320/6.png" width="320" /></a></div><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzF53IcU8BM-EGyBoWT9K0Xdp8ObjyaUmt7vjSbXa6WmqBjHG-7zNcqHCsuEbKgRIz9wTYDCAJJ2hwYjoubtkTOsvBoDCP0dnZOMDJy0330rTiOayl-3iypO1ad3HtycLXQnjkkCiizNddUoIqcJN1Zopx_B-hz-gbgT4bCY8qVwm2O4ADwYaIt8oY3kw/s500/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="388" data-original-width="500" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzF53IcU8BM-EGyBoWT9K0Xdp8ObjyaUmt7vjSbXa6WmqBjHG-7zNcqHCsuEbKgRIz9wTYDCAJJ2hwYjoubtkTOsvBoDCP0dnZOMDJy0330rTiOayl-3iypO1ad3HtycLXQnjkkCiizNddUoIqcJN1Zopx_B-hz-gbgT4bCY8qVwm2O4ADwYaIt8oY3kw/s320/7.png" width="320" /></a></div>8. ดูข้อมูลว่าถูกต้องตามที่เราต้องการหรือไม่ เลือกจาก Database ไหน ไป ไหน Table อะไร แล้วกด Finish<p></p>ดูข้อมูลถ้าผ่านจะแสดงจำนวนที่นำเข้าข้อมูลได้<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoVSEMafQaVjs62G_NDcm3t4fAgEH-mNiPNOzpWEz2X8crOA0T8fq2_8sOEbP8Y0K0Xl2HLPGBvY-a2ANtP-LHBdpzLpfucefUA4xW6c9_KP2iL4IlatOkgWtgDMHdb8ymrcVv7huyCa8rGiXG8OPSJzwoMBxy4h1mzleJnHE8hPXOQBR46-xexfCtlbc/s400/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="309" data-original-width="400" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoVSEMafQaVjs62G_NDcm3t4fAgEH-mNiPNOzpWEz2X8crOA0T8fq2_8sOEbP8Y0K0Xl2HLPGBvY-a2ANtP-LHBdpzLpfucefUA4xW6c9_KP2iL4IlatOkgWtgDMHdb8ymrcVv7huyCa8rGiXG8OPSJzwoMBxy4h1mzleJnHE8hPXOQBR46-xexfCtlbc/s320/8.png" width="320" /></a></div></dl></div><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieNXK7EJhkR6sBYOwRoj8i7MWMdeAogqdX__jQy-Fs0t0hEgG5LakK5XdnNGFr60CswkiRYnJfjoEsz9fma2_vTBoCVBh7h97q3L1_3TP0MFZg34LaQmS2rtPZs0p1-Mfqi8yEVJYIOZ37yIIAtcuZq38-oj05wKs1ZcSHtGOyJIg-mEAuuNuhtv7n6qk/s400/8.1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="310" data-original-width="400" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieNXK7EJhkR6sBYOwRoj8i7MWMdeAogqdX__jQy-Fs0t0hEgG5LakK5XdnNGFr60CswkiRYnJfjoEsz9fma2_vTBoCVBh7h97q3L1_3TP0MFZg34LaQmS2rtPZs0p1-Mfqi8yEVJYIOZ37yIIAtcuZq38-oj05wKs1ZcSHtGOyJIg-mEAuuNuhtv7n6qk/s320/8.1.png" width="320" /></a></div><p></p><p>แต่ถ้า Error ต้องตรวจสอบว่า Error อะไรเช่น Key ซ้ำ หรือสาเหตุอื่น ๆ</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgB4JCOzFN6pdTtdEpi7bl0D7gHXKg-vZZ258tOHFp5J881vY05yyPBtvP-o7U2NaoO4Tz8d5cL7reqCY2M2YjA7C9zNt_DXXzWIMN4QtRvHxhgPwC8gww7TOj1Cvghvc-ulM9UaotzQj4iT-PHLZxbqUzvLqQtPSSN_4kKwfFaYtBnE0JtLXp9S9TiT-w/s495/8.2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="380" data-original-width="495" height="246" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgB4JCOzFN6pdTtdEpi7bl0D7gHXKg-vZZ258tOHFp5J881vY05yyPBtvP-o7U2NaoO4Tz8d5cL7reqCY2M2YjA7C9zNt_DXXzWIMN4QtRvHxhgPwC8gww7TOj1Cvghvc-ulM9UaotzQj4iT-PHLZxbqUzvLqQtPSSN_4kKwfFaYtBnE0JtLXp9S9TiT-w/s320/8.2.png" width="320" /></a><span style="font-weight: bold;"> <br /></span></div><p><span style="font-weight: bold;"></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6EP7Ni9DSukt3xH5BPdbTLfXmKUToExl2UUAGt2msfHyOvwRaXGEgrtcvxRrF3P6cbsV-jf9oQP8ZyhaMZY_Flz_GOr2GPLRHI8I4TFGJ_fqrEc52b0fC1CdMNocR0ul8nm_L9M_EmGlZpbq-04ZB_nMr3QM9U2P6urAl2FwU6xy92J9MyiZd9EuFBpM/s400/8.3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="284" data-original-width="400" height="227" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6EP7Ni9DSukt3xH5BPdbTLfXmKUToExl2UUAGt2msfHyOvwRaXGEgrtcvxRrF3P6cbsV-jf9oQP8ZyhaMZY_Flz_GOr2GPLRHI8I4TFGJ_fqrEc52b0fC1CdMNocR0ul8nm_L9M_EmGlZpbq-04ZB_nMr3QM9U2P6urAl2FwU6xy92J9MyiZd9EuFBpM/s320/8.3.png" width="320" /></a></div><p></p><p><span style="font-weight: bold;">ข้อมูลที่จะนำเข้า</span><br />A. Item : InventTable เอาเข้าเฉพาะ Item ส่วน Bom ให้ ฝอบ. คีย์เพิ่มเติม <br />ต้องเอาเข้า 3 Table<br />InventTable, InventTableModule, InventItemLocation<br />ทำตามข้อ 1 - 6 <br /><span style="font-weight: bold;">ข้อ 4 ใช้วิธี Query </span> <br /><span style="font-weight: bold;">RECID</span> นำมาจากข้อมูลที่มีใน Database จริง เทียบกับ Database ที่จะเอาข้อมูล ใช้ RecId เพราะไม่มี Field CreateDate<br /><span style="font-weight: bold;">Code Query Prodtable</span><br /></p><div class="codebox"><div class="codeholder"><div class="sql" id="cb43818" style="font-family: monospace;"><ol><li class="li1"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMNAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHMODEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WIDTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESMODEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COSTGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REQGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRIMARYVENDORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NETWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEPTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>UNITVOLUME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMUNITID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DENSITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SCRAPTYPEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION2_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION3_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COSTMODEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>USEALTITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INTRACODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMMANUALCONSUMP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMMANUALRECEIPT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STOPEXPLODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_COVPERINVENTLOCATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PHANTOM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INTRAUNIT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMLEVEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BATCHNUMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>AUTOREPORTFINISHED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ORIGCOUNTRYID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STATISTICSFACTOR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTCONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDCONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_CONFIGACTIVE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODPOOLID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PROPERTYID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCTIEUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCREVENUE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCVALUE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCCONTRIBUTIONMARGIN<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COMMISSIONGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_BARCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_BARCODETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CONFIGURABLE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESPERCENTMARKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESCONTRIBUTIONRATIO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESPRICEMODELBASIC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MINAVERAGESETTLE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NAMEALIAS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GROSSDEPTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GROSSWIDTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GROSSHEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SORTCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CONFIGSIMILAR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SERIALNUMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MODELGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMBUYERGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TAXPACKAGINGQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_TEMPLATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ORIGSTATEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STOPEXPLODEPRICE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TARAWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PACKAGINGGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCRAPVAR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCRAPCONST<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDINVENTCOLORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDINVENTSIZEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMDIMCOMBINATIONAUTOCREATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMDIMCOSTPRICE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTINVENTSIZEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTINVENTCOLORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTADJUSTNO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BODYMARK<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMESTWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESITEMTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESITEMSIZE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CASTMETHOD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTPOSITIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SANDPROCESS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CORETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEPOSITNOYES<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAINTING<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTMATERIAL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTLIFETIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTPIECE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTRECORD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HASDRAWING<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>USEREDITDRW<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LASTDATEEDITDRW<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MAXPO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKITEMONHAND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATELASTWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WEIGHTLAST<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMCORE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MATERIALGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ASTRAITEMTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DRWNO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTADJUSTDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTCOUNTDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FILENO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span>><span style="color: #cc66cc;">180919242</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMNAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHMODEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WIDTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESMODEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COSTGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REQGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRIMARYVENDORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NETWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEPTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>UNITVOLUME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMUNITID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DENSITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SCRAPTYPEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION2_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION3_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COSTMODEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>USEALTITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INTRACODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMMANUALCONSUMP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMMANUALRECEIPT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STOPEXPLODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_COVPERINVENTLOCATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PHANTOM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INTRAUNIT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMLEVEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BATCHNUMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>AUTOREPORTFINISHED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ORIGCOUNTRYID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STATISTICSFACTOR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTCONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDCONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_CONFIGACTIVE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODPOOLID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PROPERTYID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCTIEUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCREVENUE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCVALUE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ABCCONTRIBUTIONMARGIN<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COMMISSIONGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_BARCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_BARCODETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CONFIGURABLE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESPERCENTMARKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESCONTRIBUTIONRATIO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESPRICEMODELBASIC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MINAVERAGESETTLE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NAMEALIAS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GROSSDEPTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GROSSWIDTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GROSSHEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SORTCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CONFIGSIMILAR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SERIALNUMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MODELGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMBUYERGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TAXPACKAGINGQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_TEMPLATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ORIGSTATEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STOPEXPLODEPRICE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TARAWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PACKAGINGGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCRAPVAR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCRAPCONST<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDINVENTCOLORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDINVENTSIZEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMDIMCOMBINATIONAUTOCREATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMDIMCOSTPRICE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTINVENTSIZEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALTINVENTCOLORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTADJUSTNO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BODYMARK<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMESTWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESITEMTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESITEMSIZE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CASTMETHOD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTPOSITIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SANDPROCESS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CORETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEPOSITNOYES<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAINTING<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTMATERIAL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTLIFETIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTPIECE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PTRECORD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HASDRAWING<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>USEREDITDRW<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LASTDATEEDITDRW<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MAXPO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKITEMONHAND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATELASTWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WEIGHTLAST<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMCORE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MATERIALGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ASTRAITEMTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DRWNO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHWEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTADJUSTDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTCOUNTDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FILENO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li></ol></div></div></div><br /><span style="font-weight: bold;">Code Query InventTableModule</span><br /><div class="codebox"><div class="codeholder"><div class="sql" id="cb75597" style="font-family: monospace;"><ol><li class="li1"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MODULETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>UNITID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEUNIT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MARKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MULTILINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ENDDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QUANTITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LOWESTQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HIGHESTQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TAXITEMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BLOCKED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MANDATORYINVENTLOCATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MARKUPGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALLOCATEMARKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>OVERDELIVERYPCT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>UNDERDELIVERYPCT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SUPPITEMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CALENDARDAYS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEKGS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MINORDERDATE<span style="color: #66cc66;">]</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span>><span style="color: #cc66cc;">180919239</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MODULETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>UNITID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEUNIT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MARKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MULTILINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ENDDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QUANTITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LOWESTQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HIGHESTQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TAXITEMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BLOCKED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MANDATORYINVENTLOCATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STANDARDQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MARKUPGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEQTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ALLOCATEMARKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>OVERDELIVERYPCT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>UNDERDELIVERYPCT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SUPPITEMGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CALENDARDAYS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEKGS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTTABLEMODULE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MINORDERDATE<span style="color: #66cc66;">]</span></li><li class="li1"> </li></ol></div></div></div><br /><span style="font-weight: bold;">Code Query InventItemLocation</span><br /><div class="codebox"><div class="codeholder"><div class="sql" id="cb8863" style="font-family: monospace;"><ol><li class="li1"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_CONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_INVENTLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_COVRULE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_COVPERIOD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_MININVENTONHAND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_MAXINVENTONHAND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COUNTGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_DELIVERYTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSPICKINGLOCATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COUNTINGSTARTED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COUNTINGJOURNALID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSLOCATIONIDDEFAULTISSUE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSLOCATIONIDDEFAULTRECEIPT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTDIMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span>><span style="color: #cc66cc;">180919241</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_CONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_INVENTLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_COVRULE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_COVPERIOD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_MININVENTONHAND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_MAXINVENTONHAND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COUNTGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_DELIVERYTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSPICKINGLOCATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COUNTINGSTARTED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COUNTINGJOURNALID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSLOCATIONIDDEFAULTISSUE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WMSLOCATIONIDDEFAULTRECEIPT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTDIMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTITEMLOCATION<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li><li class="li1"> </li></ol></div></div></div><br /><br />2. PO : PurchTable เอาเข้าเฉพาะ เลขที่ PO ส่วน รายการ Purchline ให้ ฝจห. คีย์เพิ่มเติม<br />ทำตามข้อ 1 - 6 <br /><span style="font-weight: bold;">ข้อ 4 ใช้วิธี Query </span> <br />ใช้ CreateDate เป็นตัวกรอกข้อมูล<br /><span style="font-weight: bold;">Code Query</span><br /><div class="codebox"><div class="codeholder"><div class="sql" id="cb88790" style="font-family: monospace;"><ol><li class="li1"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHNAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ORDERACCOUNT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVOICEACCOUNT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FREIGHTZONE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>EMAIL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CURRENCYCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CASHDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHPLACER<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VENDGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DISCPERCENT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION2_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION3_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MULTILINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ENDDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYADDRESS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TAXGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVTERM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVMODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MARKUPGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHASETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>URL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>POSTINGPROFILE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TRANSACTIONCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYZIPCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVCOUNTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVCOUNTRY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVSTATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SETTLEVOUCHER<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYNAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COVSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENTSCHED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ONETIMEVENDOR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RETURNITEMNUM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FREIGHTSLIPTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DOCUMENTSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CONTACTPERSONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMINVOICEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMPACKINGSLIPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMPURCHASEORDERID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMRECEIPTSLISTID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMBUYERGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHPOOLID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VATNUM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PORT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_PURCHASEORDERORIGINALS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_PURCHASEORDERCOPIES<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INCLTAX<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NUMBERSEQUENCEGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LANGUAGEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>AUTOSUMMARYMODULETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TRANSPORT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRINTMODULETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMMODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMSPEC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FIXEDDUEDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYCITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYSTREET<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STATPROCID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REFDLVZIPCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VENDORREF<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKPO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKPLAN<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENTALL_DATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENTFIRST_DATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ETD_DATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CIFCOST<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COURIER<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span>>=<span style="color: red;">'2023-12-02'</span> <span style="color: #993333; font-weight: bold;">AND</span></li><li class="li2"><span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span><=<span style="color: red;">'2023-12-11'</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHNAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ORDERACCOUNT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVOICEACCOUNT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FREIGHTZONE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>EMAIL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CURRENCYCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CASHDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHPLACER<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VENDGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DISCPERCENT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION2_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION3_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRICEGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MULTILINEDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ENDDISC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYADDRESS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TAXGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVTERM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVMODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>MARKUPGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHASETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>URL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>POSTINGPROFILE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TRANSACTIONCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYZIPCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVCOUNTY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVCOUNTRY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVSTATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SETTLEVOUCHER<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYNAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COVSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENTSCHED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ONETIMEVENDOR<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RETURNITEMNUM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FREIGHTSLIPTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DOCUMENTSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CONTACTPERSONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMINVOICEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMPACKINGSLIPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMPURCHASEORDERID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTLOCATIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_SUMRECEIPTSLISTID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMBUYERGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PURCHPOOLID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VATNUM<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PORT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_PURCHASEORDERORIGINALS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_PURCHASEORDERCOPIES<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INCLTAX<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NUMBERSEQUENCEGROUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LANGUAGEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>AUTOSUMMARYMODULETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TRANSPORT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRINTMODULETYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMMODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMSPEC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FIXEDDUEDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYCITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELIVERYSTREET<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STATPROCID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REFDLVZIPCODE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VENDORREF<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKPO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKPLAN<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENTALL_DATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PAYMENTFIRST_DATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ETD_DATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CIFCOST<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COURIER<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PURCHTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li></ol></div></div></div><br /><br />3. PD : ProdTable จะใช้วิธีผ่าน Code เพื่อให้เกิด ProdBom และเกิด InventTrans ผ่านการ Insert Status จะเป็น Create ทั้งหมดโดย<br />*** สำคัญต้องรอ ฝอบ. สร้าง BOM และ Active BOM ให้เรียบร้อยก่อน จึงค่อยสร้าง ProdTable เพราะจะไม่เกิด ProdBom ***<br />3.1. ทำไฟล์ .CSV PD ที่จะนำเข้า โดยกรองข้อมูลเอาจากช่อง CreateDate ข้อมูลที่จะใช้ PordId,Qty<br /><div class="inline-attachment">
<dl class="file"><dt class="attach-image"><img alt="Selection_127.png" src="https://intranet.sci.com/blog.php?page=download&mode=download&id=3166" /></dt><dd>Selection_127.png (19.55 KB) Viewed 30 times</dd></dl>
</div><br />Code Query หรือจะไป Fielter จาก Table ProdTable ก็ได้<br /><div class="codebox"><div class="codeholder"><div class="sql" id="cb31853" style="font-family: monospace;"><ol><li class="li1">PRODTABLE</li><li class="li2"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NAME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODPRIO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODLOCKED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCHEDSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCHEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QTYSCHED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QTYSTUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>STUPDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>FINISHEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCHEDSTART<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCHEDEND<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HEIGHT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>WIDTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEPTH<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DENSITY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QTYCALC<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REALDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RESERVATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODPOSTINGTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTTRANSID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION2_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DIMENSION3_<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTREFTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTREFID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTREFTRANSID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COLLECTREFLEVEL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>COLLECTREFPRODID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BACKORDERSTATUS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODPOOLID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PROFITSET<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CALCDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ROUTEJOBS<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CHECKROUTE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PROPERTYID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMAININVENTPHYSICAL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BOMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ROUTEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_CONFIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REQPLANIDSCHED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REQPOID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REFLOOKUP<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LATESTSCHEDDIRECTION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LATESTSCHEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTDIMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCHEDTOTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SCHEDFROMTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LATESTSCHEDTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DLVTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PRODORIGID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>GANTTCOLORID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REFSALESID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ACTIONDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKPD<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESORDERLINE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESORDERLOT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PDEXTRA<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PLANT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QTY2014<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REPORTWEIGHTVALVE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>HASCHECKVALVE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REMARKPDASSEMBLY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CHECKUPWL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDBY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span>>=<span style="color: red;">'2023-12-02 00:00:00'</span> <span style="color: #993333; font-weight: bold;">AND</span></li><li class="li1"><span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDDATE<span style="color: #66cc66;">]</span><=<span style="color: red;">'2023-12-11 00:00:00'</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> <span style="color: #66cc66;">[</span>PRODTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li></ol></div></div></div><br />3.2.
สร้าง Table ที่ Axapta Database จริง ที่จะใช้งาน
เพื่อนำมาเปรียบเทียบข้อมูลและ Run Code นำเข้า Table ProdTable โดยสร้าง
Table ชื่อ ProdTable2023<br />3.3. <span style="font-weight: bold;">Import ข้อมูลโดยใช้วิธีข้อ 1 - 6 </span> <br />ข้อ 4 เลือกเป็น Copy table จาก AC_Local.ProdTable ไป Suwit_Local.ProdTable2023<br />3.4. เขียนโปรแกรมใน Job duplicateProdTable ตั้งชื่อไฟลื .CSV และนำไปไว้ที่ Path ที่ต้องการ <br />Code
ทำงานโดย เอา PD กับ QTY จาก CSV ไฟล์ ไปหา ProdTable2023 ที่ Copy
มาตามข้อ 3.3. เพื่อเอาข้อมูลที่ต้องการเข้า ProdTable ที่จะใช้งานจริง<br />Code<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb22586" style="font-family: monospace;"><ol><li class="li1">static void duplicateProdTable(Args _args)</li><li class="li2">{</li><li class="li1"> ProdTable2023 prodTable2023;</li><li class="li2"> ProdTable selectProdTable;</li><li class="li1"> ProdTable updateProdTable;</li><li class="li2"> InventTable item;</li><li class="li1"> int no;</li><li class="li2"> ProdTable2023 myProd;</li><li class="li1"> ProdTable tmpProdTable;</li><li class="li2"> </li><li class="li1"> AsciiIO myFile;</li><li class="li2"> str filename = "ProdTable_1";</li><li class="li1"> </li><li class="li2"> container RecData;</li><li class="li1"> int i;</li><li class="li2"> </li><li class="li1"> ProdId myProdId;</li><li class="li2"> ItemId myItemId;</li><li class="li1"> Qty myQty;</li><li class="li2"> ;</li><li class="li1">// CREATE NEW LINE</li><li class="li2"> </li><li class="li1"> myFile=new AsciiIO(strfmt("C:\\%1.csv", filename),"r");</li><li class="li2"> myfile.inFieldDelimiter(",");</li><li class="li1"> while(myFile.status() == IO_Status::Ok)</li><li class="li2"> RecData += myFile.read();</li><li class="li1"> myFile = null;</li><li class="li2"> </li><li class="li1"> </li><li class="li2"> ttsBegin;</li><li class="li1"> for(i=1; i <= conlen(RecData); i++){</li><li class="li2"> </li><li class="li1"> myProdId = conpeek(RecData, i);</li><li class="li2"> i++;</li><li class="li1"> </li><li class="li2"> myQty = conpeek(RecData, i);</li><li class="li1"> </li><li class="li2"> SELECT * FROM myProd WHERE myProd.ProdId == myProdId;</li><li class="li1"> </li><li class="li2"> item = InventTable::find(myProd.ItemId);</li><li class="li1"> </li><li class="li2"> tmpProdTable.clear();</li><li class="li1"> tmpProdTable.initValue();</li><li class="li2"> tmpProdTable.ProdId = myProd.ProdId;</li><li class="li1"> tmpProdTable.ItemId = item.ItemId;</li><li class="li2"> tmpProdTable.initFromInventTable(item);</li><li class="li1"> tmpProdTable.Name = myProd.Name;</li><li class="li2"> tmpProdTable.RefSalesId = myProd.RefSalesId;</li><li class="li1"> tmpProdTable.SalesOrderLine = myProd.SalesOrderLine;</li><li class="li2"> tmpProdTable.SalesOrderLot = myProd.SalesOrderLot;</li><li class="li1"> tmpProdTable.PdExtra = myProd.PdExtra;</li><li class="li2"> tmpProdTable.Plant = myProd.Plant;</li><li class="li1"> tmpProdTable.RemarkPD = myprod.RemarkPD;</li><li class="li2"> </li><li class="li1"> tmpProdTable.QtySched = myQty;</li><li class="li2"> tmpProdTable.RemainInventPhysical = myQty;</li><li class="li1"> tmpProdTable.BOMId = BOMVersion::findActive(tmpProdTable.ItemId,</li><li class="li2"> tmpProdTable.BOMDate,</li><li class="li1"> myQty).BOMId;</li><li class="li2"> tmpProdTable.RouteId = RouteVersion::findActive(tmpProdTable.ItemId,</li><li class="li1"> tmpProdTable.BOMDate,</li><li class="li2"> myQty).RouteId;</li><li class="li1"> tmpProdTable.initRouteVersion();</li><li class="li2"> tmpProdTable.initBOMVersion();</li><li class="li1"> tmpProdTable.ProdPostingType = ProdPostingType::ItemCategory;</li><li class="li2"> tmpProdTable.type().insert();</li><li class="li1"> </li><li class="li2"> no++;</li><li class="li1"> info(strfmt("%1 : %2 : %3 : %4 : %5", no, myProd.ProdId, myProd.ItemId, myQty, tmpProdTable.BOMId));</li><li class="li2"> }</li><li class="li1"> ttscommit;</li><li class="li2">}</li></ol></div></div></div><br /><br />4. เอกสาร Transfer, Movement : InventJournalTable, InventJournalTrans โดย<br />จะทำคล้ายกับ ProdTable <br />4.1. นำเข้าข้อมูล InventJournalTable ตามข้อ <span style="font-weight: bold;">Import ข้อมูลโดยใช้วิธีข้อ 1 - 6 </span> <br /><span style="font-weight: bold;">ข้อ 4 ใช้วิธี Query </span> <br />Code<br /><div class="codebox"><div class="codeholder"><div class="sql" id="cb88281" style="font-family: monospace;"><ol><li class="li1">INVENTJOURNALTABLE</li><li class="li2"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>JOURNALID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DESCRIPTION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>POSTED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RESERVATION<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SYSTEMBLOCKED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DEL_LOG<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BLOCKUSERID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>JOURNALTYPE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>JOURNALNAMEID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>INVENTDIMFIXED<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>EMPLID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>BLOCKUSERGROUPID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VOUCHERDRAW<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VOUCHERCHANGE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VOUCHERSEQID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SESSIONLOGINTIME<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SESSIONLOGINDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SESSIONID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>POSTEDUSERID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>POSTEDDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NUMOFLINES<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>JOURNALIDORIGNAL<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DETAILSUMMARY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DELETEPOSTEDLINES<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>LEDGERACCOUNTIDOFFSET<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>VENDACCOUNT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEBY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>SALESORDERLOT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECEIVEDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>REFSALESID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>ITEMID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>NOINSO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>QTYINSO<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>TRANSDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PLANT<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>PICKINGBY<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CAUSE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDATE<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>DATAAREAID<span style="color: #66cc66;">]</span>, <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">FROM</span> <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDATE<span style="color: #66cc66;">]</span>>=<span style="color: red;">'2023-11-02 00:00:00'</span> <span style="color: #993333; font-weight: bold;">AND</span></li><li class="li1"><span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>CREATEDATE<span style="color: #66cc66;">]</span><=<span style="color: red;">'2023-11-11 00:00:00'</span></li><li class="li2"><span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> <span style="color: #66cc66;">[</span>INVENTJOURNALTABLE<span style="color: #66cc66;">]</span>.<span style="color: #66cc66;">[</span>RECID<span style="color: #66cc66;">]</span></li></ol></div></div></div><br /><br />กรณีนี้มีการใช้เลขที่ไปแล้วต้องเพิ่มเงื่อนไข ตัดเลขที่ ที่ใช้ไปแล้วออก แล้วให้คีย์เอง<br />Code<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb90607" style="font-family: monospace;"><ol><li class="li1">SELECT JOURNALID, DESCRIPTION, POSTED, RESERVATION, SYSTEMBLOCKED, DEL_LOG, BLOCKUSERID, JOURNALTYPE, JOURNALNAMEID, </li><li class="li2"> INVENTDIMFIXED, EMPLID, BLOCKUSERGROUPID, VOUCHERDRAW, VOUCHERCHANGE, VOUCHERSEQID, SESSIONLOGINTIME, </li><li class="li1">
SESSIONLOGINDATE, SESSIONID, POSTEDUSERID,
POSTEDDATE, NUMOFLINES, JOURNALIDORIGNAL, DETAILSUMMARY,
DELETEPOSTEDLINES, </li><li class="li2">
LEDGERACCOUNTIDOFFSET, VENDACCOUNT, CREATEBY, SALESORDERLOT,
RECEIVEDATE, REFSALESID, ITEMID, NOINSO, QTYINSO, TRANSDATE, </li><li class="li1"> PLANT, PICKINGBY, CAUSE, CREATEDATE, DATAAREAID, RECID</li><li class="li2">FROM INVENTJOURNALTABLE</li><li class="li1">WHERE
(CREATEDATE >= '2023-12-02 00:00:00') AND (CREATEDATE <=
'2023-12-11 00:00:00') AND (JOURNALID <> '23-0020130') AND </li><li class="li2">
(JOURNALID <> '23-0020131') AND (JOURNALID
<> '23-0020125') AND (JOURNALID <> '23-0020127') AND
(JOURNALID <> '23-0020128') AND </li><li class="li1">
(JOURNALID <> '23-0020122') AND (JOURNALID
<> '23-0020119') AND (JOURNALID <> '23-0020120')</li><li class="li2">ORDER BY RECID</li></ol></div></div></div><br />4.2. เปลี่ยน Status รายการที่ Post แล้วให้เป็น Create และ User ที่ Post , วันที่ Post นำออก<br />Code<br /><div class="codebox"><div class="codeholder"><div class="sql" id="cb1845" style="font-family: monospace;"><ol><li class="li1"><span style="color: #993333; font-weight: bold;">UPDATE</span> INVENTJOURNALTABLE</li><li class="li2"><span style="color: #993333; font-weight: bold;">SET</span> POSTED = <span style="color: #cc66cc;">0</span>, POSTEDUSERID = <span style="color: red;">''</span>, POSTEDDATE = <span style="color: red;">'1900-01-01'</span></li><li class="li1"><span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #66cc66;">(</span>CREATEDATE >= <span style="color: red;">'2023-12-02 00:00:00'</span><span style="color: #66cc66;">)</span> <span style="color: #993333; font-weight: bold;">AND</span> <span style="color: #66cc66;">(</span>CREATEDATE <= <span style="color: red;">'2023-12-11 00:00:00'</span><span style="color: #66cc66;">)</span></li></ol></div></div></div><br />4.3. เตรียมข้อมูลที่จะดึงเข้า InventJournalTrans เพื่อให้เกิด Transaction <br />4.3.1. สร้าง Table InventJournalTrans2023, InventDim2023 ที่ Axapta ที่จะใช้งานจริง Suwit_Local<br />ต้องใช้ InventDim ด้วยเพราะมีการคีย์การลบ เปลี่ยนแปลงไปแล้ว แต่ถ้าสั่งหยุดคีย์หรือ Post ก็ไม่ต้องใช้ InventDim<br />4.3.2. นำเข้าข้อมูล InventJournalTrans ตามข้อ <span style="font-weight: bold;">Import ข้อมูลโดยใช้วิธีข้อ 1 - 6 </span> <br /><span style="font-weight: bold;">ข้อ 4 ใช้วิธี Copy Table </span> <br />ทั้ง AC_Local.InventJournalTrans --> Suwit_Local.InventJournalTranls<br />AC_Local.InventDim --> Suwit_Local.InventDim<br />4.3.3. เขียน Code Run Job นำข้อมูลเข้า InventJournalTrans<br />Code
ทำงานโดย กรองเอาเฉพาะเล่ม ใน InventJournalTable ที่อยู่ในช่วงวันที่
ที่ต้องการ เอา JournalId ไปหา InventJournalTrans2023
เพื่อเอาข้อมูลที่ต้องการ<br />InventDim2023 ใช้สร้าง InventDim ใหม่ กรณีหาไม่เจอเพราะมีการใช้งานและเปลี่ยนแปลง<br /><span style="font-weight: bold;">**** สำคัญ InventDim Code Form InventDimId กับ To InventDimId ดูให้ดี ถ้าเอาเข้าผิดต้อง Update ใหม่ ****</span><br />Code<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb54811" style="font-family: monospace;"><ol><li class="li1"> </li><li class="li2">static void duplicateInventJournalTrans(Args _args)</li><li class="li1">{</li><li class="li2"> </li><li class="li1"> InventJournalTrans2023 queryInventJournalTrans;</li><li class="li2"> //InventJournalTrans queryInventJournalTrans;</li><li class="li1"> InventJournalTrans updateInventJournalTrans;</li><li class="li2"> InventJournalTrans deleteInventJournalTrans;</li><li class="li1"> </li><li class="li2"> InventJournalTable myInventJournalTable;</li><li class="li1"> int no = 1;</li><li class="li2"> </li><li class="li1"> InventDim myInventDim;</li><li class="li2"> InventDim myInventDim2;</li><li class="li1"> </li><li class="li2"> InventDim FromInventDim;</li><li class="li1"> InventDim ToInventDim;</li><li class="li2"> </li><li class="li1"> InventDim2023 myInventDim2023;</li><li class="li2"> ;</li><li class="li1"> </li><li class="li2">ttsBegin;</li><li class="li1"> WHILE</li><li class="li2"> SELECT JournalId FROM myInventJournalTable</li><li class="li1"> WHERE myInventJournalTable.CreateDate >= str2date("02/12/2023", 123)</li><li class="li2"> && myInventJournalTable.CreateDate <= str2date("11/12/2023", 123)</li><li class="li1"> {</li><li class="li2"> WHILE</li><li class="li1"> SELECT * FROM queryInventJournalTrans</li><li class="li2"> WHERE queryInventJournalTrans.JournalId == myInventJournalTable.JournalId</li><li class="li1"> {</li><li class="li2"> //SELECT * FROM queryInventJournalTrans WHERE queryInventJournalTrans.RecId == inventJournalTrans2014.RecId;</li><li class="li1"> //SELECT FORUPDATE deleteInventJournalTrans WHERE deleteInventJournalTrans.RecId == queryInventJournalTrans.RecId;</li><li class="li2"> updateInventJournalTrans.clear();</li><li class="li1"> </li><li class="li2"> //insertInventJournalTrans.initFromInventJournalTrans(queryInventJournalTrans);</li><li class="li1"> insertInventJournalTrans.JournalId = queryInventJournalTrans.JournalId;</li><li class="li2"> insertInventJournalTrans.JournalType = queryInventJournalTrans.JournalType;</li><li class="li1"> insertInventJournalTrans.LineNum = queryInventJournalTrans.LineNum;</li><li class="li2"> insertInventJournalTrans.ItemId = queryInventJournalTrans.ItemId;</li><li class="li1"> insertInventJournalTrans.FinishedCode = queryInventJournalTrans.FinishedCode;</li><li class="li2"> insertInventJournalTrans.OrderQty = queryInventJournalTrans.OrderQty;</li><li class="li1"> insertInventJournalTrans.Qty = queryInventJournalTrans.Qty;</li><li class="li2"> insertInventJournalTrans.CostAmount = queryInventJournalTrans.CostAmount;</li><li class="li1"> </li><li class="li2"> SELECT * FROM myInventDim</li><li class="li1"> WHERE myInventDim.inventDimId == queryInventJournalTrans.InventDimId;</li><li class="li2"> </li><li class="li1"> if(myInventDim.inventDimId != ""){</li><li class="li2"> insertInventJournalTrans.InventDimId = queryInventJournalTrans.InventDimId;</li><li class="li1"> } else {</li><li class="li2"> </li><li class="li1"> SELECT * FROM myInventDim2023</li><li class="li2"> WHERE myInventDim2023.inventDimId == queryInventJournalTrans.InventDimId;</li><li class="li1"> </li><li class="li2"> FromInventDim.InventLocationId = myInventDim2023.InventLocationId;</li><li class="li1"> FromInventDim.wMSLocationId = myInventDim2023.wMSLocationId;</li><li class="li2"> FromInventDim.inventBatchId = "";</li><li class="li1"> FromInventDim.configId = "";</li><li class="li2"> FromInventDim.InventSizeId = "";</li><li class="li1"> FromInventDim.InventColorId = "";</li><li class="li2"> FromInventDim = InventDim::findOrCreate(FromInventDim);</li><li class="li1"> insertInventJournalTrans.InventDimId = FromInventDim.inventDimId;//Some line not invent batch fix use WH.</li><li class="li2"> </li><li class="li1"> }</li><li class="li2"> </li><li class="li1"> SELECT * FROM myInventDim2</li><li class="li2"> WHERE myInventDim2.inventDimId == queryInventJournalTrans.ToInventDimId;</li><li class="li1"> if(myInventDim2.inventDimId != ""){</li><li class="li2"> insertInventJournalTrans.ToInventDimId = queryInventJournalTrans.ToInventDimId;</li><li class="li1"> } else {</li><li class="li2"> SELECT * FROM myInventDim2023</li><li class="li1"> WHERE myInventDim2023.inventDimId == queryInventJournalTrans.ToInventDimId;</li><li class="li2"> </li><li class="li1"> ToInventDim.InventLocationId = myInventDim2023.InventLocationId;</li><li class="li2"> ToInventDim.wMSLocationId = myInventDim2023.wMSLocationId;</li><li class="li1"> ToInventDim.inventBatchId = "";</li><li class="li2"> ToInventDim.configId = "";</li><li class="li1"> ToInventDim.InventSizeId = "";</li><li class="li2"> ToInventDim.InventColorId = "";</li><li class="li1"> ToInventDim = InventDim::findOrCreate(ToInventDim);</li><li class="li2"> </li><li class="li1"> ttsBegin;</li><li class="li2"> SELECT FORUPDATE * FROM updateInventJournalTrans</li><li class="li1"> WHERE updateInventJournalTrans.JournalId == queryInventJournalTrans.JournalId</li><li class="li2"> && updateInventJournalTrans.ItemId == queryInventJournalTrans.ItemId</li><li class="li1"> && updateInventJournalTrans.LineNum == queryInventJournalTrans.LineNum;</li><li class="li2"> </li><li class="li1"> updateInventJournalTrans.ToInventDimId = ToInventDim.ToInventDimId;</li><li class="li2"> updateInventJournalTrans.update();</li><li class="li1"> </li><li class="li2"> ttsCommit;</li><li class="li1"> }</li><li class="li2"> </li><li class="li1"> //insertInventJournalTrans.InventDimId = " 06-00000001";</li><li class="li2"> //insertInventJournalTrans.ToInventDimId = " 06-00000010";</li><li class="li1"> </li><li class="li2"> insertInventJournalTrans.RefSalesId = queryInventJournalTrans.RefSalesId;</li><li class="li1"> insertInventJournalTrans.TransDate = queryInventJournalTrans.TransDate;</li><li class="li2"> //insertInventJournalTrans.TransDate = today();</li><li class="li1"> insertInventJournalTrans.DeliveryDate = queryInventJournalTrans.DeliveryDate;</li><li class="li2"> insertInventJournalTrans.Remark = queryInventJournalTrans.Remark;</li><li class="li1"> </li><li class="li2"> //deleteInventJournalTrans.delete();</li><li class="li1"> insertInventJournalTrans.insert();</li><li class="li2"> </li><li class="li1"> }</li><li class="li2"> info(strfmt("%1 : %2", no, myInventJournalTable.JournalId));</li><li class="li1"> no++;</li><li class="li2"> }</li><li class="li1">ttsCommit;</li><li class="li2">}</li><li class="li1"> </li></ol></div></div></div><br />4.3.4. เอกสารที่ เป็น Movement จะ Post ไม่ได้จะ Error Offset Account ต้องกรอก LedgerAccountOffet เป็น 9000000<br />Code Update<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb94785" style="font-family: monospace;"><ol><li class="li1">static void JobUpdateLedgerOffset(Args _args)</li><li class="li2">{</li><li class="li1"> InventJournalTable InventJournalTable;</li><li class="li2"> InventJournalTrans InventJournalTrans;</li><li class="li1"> InventJournalTrans updateInventJournalTrans;</li><li class="li2"> ;</li><li class="li1"> </li><li class="li2"> WHILE</li><li class="li1"> SELECT JournalId FROM InventJournalTable</li><li class="li2"> WHERE InventJournalTable.CreateDate >= str2date("02/12/2023", 123)</li><li class="li1"> && InventJournalTable.CreateDate <= str2date("11/12/2023", 123)</li><li class="li2"> && InventJournalTable.Posted == NoYes::No</li><li class="li1"> && InventJournalTable.JournalType == InventJournalType::Movement</li><li class="li2"> //&& InventJournalTable.JournalId == '23-0020140'</li><li class="li1"> {</li><li class="li2"> WHILE</li><li class="li1"> SELECT * FROM InventJournalTrans</li><li class="li2"> WHERE InventJournalTrans.JournalId == InventJournalTable.JournalId</li><li class="li1"> {</li><li class="li2"> ttsBegin;</li><li class="li1"> SELECT FORUPDATE * FROM updateInventJournalTrans</li><li class="li2"> WHERE updateInventJournalTrans.RecId == InventJournalTrans.RecId;</li><li class="li1"> </li><li class="li2"> updateInventJournalTrans.LedgerAccountIdOffset = '9000000';</li><li class="li1"> updateInventJournalTrans.update();</li><li class="li2"> ttsCommit;</li><li class="li1"> }</li><li class="li2"> }</li><li class="li1"> </li><li class="li2">}</li></ol></div></div></div><br /><br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-29895471226203829172023-12-09T10:39:00.005+07:002023-12-09T10:40:01.291+07:00 Windows 11 Auto on numlock pad<p> Windows 11 Auto on numlock pad<br />a. Press “Windows key + R” from keyboard.<br />b. Type “regedit” without quotes and hit enter.<br />c. Click on the “drop down arrow next to “Computer” (to make sure you see only “Computer” option is listed there).<br />d. Right click on the “Computer” option.<br />e. Select “Export” option and save the file on any external memory devices.<br /><br />Follow these steps to enable “Num lock” option on boot.<br /><br />a. Press “Windows key + R” from keyboard.<br />b. Type “regedit” without quotes and hit enter.<br />c. Navigate to “HKEY_USERS\.Default\Control Panel\Keyboard”.<br />d. Change the value for “InitialKeyboardIndicators” from 0 to 2.<br />e. Restart the computer and then check how it works.<br /><br /><a href="https://answers.microsoft.com/en-us/windows/forum/windows_8-desktop/permanent-num-lock/ba98e4d7-f52f-45c3-870e-82c2b48fbfe8">https://answers.microsoft.com/en-us/windows/forum/windows_8-desktop/permanent-num-lock/ba98e4d7-f52f-45c3-870e-82c2b48fbfe8</a></p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-42097768805615431742023-09-29T11:25:00.003+07:002023-09-29T11:25:10.096+07:00 X++ code to open a form or menuitem AXAPTA<p> X++ code to open a form or menuitem AXAPTA<br /><br />How to open a form by using x++ code.</p><div class="codebox"><div class="codeholder"><div class="text" id="cb19074" style="font-family: monospace;"><ol><li class="li1"> </li><li class="li2">static void OpenDisplayMenuItem()</li><li class="li1">{</li><li class="li2"> Args args = new Args();</li><li class="li1"> ;</li><li class="li2"> args.record(VendTable::find('A-CSK'));</li><li class="li1"> new MenuFunction(MenuItemDisplayStr(VendTable),MenuItemType::Display).run(Args);</li><li class="li2">}</li></ol></div></div></div><br /><br />This Job will get the same result but with different approach by using formrun class.<br /><br /><div class="codebox"><div class="codeholder"><div class="text" id="cb72224" style="font-family: monospace;"><ol><li class="li1">static void OpenForm()</li><li class="li2">{ </li><li class="li1"> FormRun formRun;</li><li class="li2"> Args args = new Args();</li><li class="li1"> ;</li><li class="li2"> args.name(formstr(VendTable));</li><li class="li1"> args.record(CustTable::find('A-CSK'));</li><li class="li2"> </li><li class="li1"> formRun = ClassFactory.formRunClass(args);</li><li class="li2"> formRun.init();</li><li class="li1"> formRun.run();</li><li class="li2"> formRun.wait();</li><li class="li1">}</li></ol></div></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-13505162611481971752023-09-25T11:28:00.006+07:002023-09-25T11:28:53.605+07:00 Raspberrypi PI400 ติดตั้ง และ Auto RDP to windows<p> Raspberrypi PI400 ติดตั้ง และ Auto RDP to windows<br /><br />1. โหลดและติดตั้ง ใส่ sd<br /><a class="postlink" href="https://www.raspberrypi.com/software/operating-systems/">https://www.raspberrypi.com/software/operating-systems/</a><br />1.1. เปิด SSH<br />1.2. ตั้งรหัส wifi <br /></p><div class="codebox"><div class="codeholder"><div class="text" id="cb92113" style="font-family: monospace;"><ol><li class="li1">nano /etc/wpa_supplicant/wpa_supplicant.conf</li></ol></div></div></div><br />เพิ่ม<br /><blockquote class="uncited"><div>network={<br />ssid="SCI_EMP"<br />psk="XXXXXX"<br />}</div></blockquote><p><br /><br />ใน Preferences --> Raspberry Pi Configuration หรือใช้คำสั่งผ่าน Terminal ก็ได้<br />sudo raspi-config<br />2. ตั้งค่า IP<br />3. ตั้งค่า Time zone<br />4. เปิด VNC ตั้งค่า Authentication เป็น VNC password ใส่รหัสสำหรับ Remote<br />5. เพิ่มตัวเปลี่ยนภาษาไทย<br />http://www.arduino-makerzone.com/article/59/raspberry-pi-tutorial-ep3-%E0%B8%95%E0%B8%B1%E0%B9%89%E0%B8%87%E0%B8%84%E0%B9%88%E0%B8%B2%E0%B8%A0%E0%B8%B2%E0%B8%A9%E0%B8%B2-%E0%B9%82%E0%B8%8B%E0%B8%99%E0%B9%80%E0%B8%A7%E0%B8%A5%E0%B8%B2-%E0%B8%84%E0%B8%B5%E0%B8%A2%E0%B9%8C%E0%B8%9A%E0%B8%AD%E0%B8%A3%E0%B9%8C%E0%B8%94</p><p><br />6. ติดตั้ง Remmina <br /></p><div class="codebox"><div class="codeholder"><div class="text" id="cb98761" style="font-family: monospace;"><ol><li class="li1">apt-get install remmina</li></ol></div></div></div><br /><br />7. สร้าง config สำหรับ Remote ไปเครื่องที่ต้องการใน remmina ให้ Remote ได้<br />7.1. ทดลองเรียกใช้งานผ่าน Terminal <br />remmina /home/pd1/.local/share/remmina/group_rdp_win7_192-168-0-28.remmina<br /><span style="font-weight: bold;">**** สำคัญ ให้ Run user ที่ไม่ใช่ root เพราะจะทำให้ รหัสในไฟล์เปลี่ยน ต้องกรอกรหัสใหม่*****</span><br /><br />8. auto start remmina automatic to rdp.<br />8.2. หน่วงเวลาให้ เปิด remmina ตอน Start เครื่อง ช้าลง เพราะ Wifi ยังไม่ขึ้น<br />สร้างไฟล์<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb46357" style="font-family: monospace;"><ol><li class="li1">nano .config/autostart/rdp.sh</li></ol></div></div></div><br />เพิ่ม code<br /><blockquote class="uncited"><div>#!/bin/bash<br />env sleep 5<br />remmina /home/pd1/.local/share/remmina/group_rdp_win7_192-168-0-28.remmina</div></blockquote><br /><br />8.3. เรียกใช้งานในไฟล์ bash ตอนเปิดเครื่องผ่านโปรแกรม remmina โดย<br />แก้<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb45759" style="font-family: monospace;"><ol><li class="li1">nano .config/autostart/remmina-applet.desktop </li></ol></div></div></div><br />แก้ Exec ให้ไปใช้งานไฟลืข้อ 8.2.<br />Exec=bash .config/autostart/rdp.sh<br /><br />ทดลอง Reboot เครื่อง ก็จะ Run และ เปิด RDP AutoUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-14600465704692370732023-09-25T11:27:00.004+07:002023-09-25T11:27:27.505+07:00linux mint : ไม่สามารถ SSH ไปบางเครื่องได้<p>linux mint : ไม่สามารถ SSH ไปบางเครื่องได้</p><div class="content"><blockquote class="uncited"><div>root@OD-SUWIT:/home/suwit_j# ssh <a href="mailto:sa@192.168.2.104">sa@192.168.2.104</a><br />Unable to negotiate with 192.168.2.104 port 22: no matching host key type found. Their offer: ssh-rsa,ssh-dss</div></blockquote><br /><span style="font-weight: bold;"><br />วิธีแก้</span><br />1. สร้างไฟล์<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb29625" style="font-family: monospace;"><ol><li class="li1">nano /etc/ssh/ssh_config.d/my.conf</li></ol></div></div></div><br />2. เอาข้อมูลนี้ไปใส่<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb74858" style="font-family: monospace;"><ol><li class="li1">HostKeyAlgorithms ssh-rsa,ssh-dss</li><li class="li2">PubkeyAcceptedKeyTypes ssh-rsa,ssh-dss</li><li class="li2"> </li></ol></div></div></div></div><div class="content">https://askubuntu.com/questions/836048/ssh-returns-no-matching-host-key-type-found-their-offer-ssh-dss<br /><br />แล้วลอง SSH ดู มันจะให้ลบ key เดิมที่เคยบันทึกไว้ออก ด้วยคำสั่ง<br /><blockquote class="uncited"><div>ssh-keygen -f "/home/suwit_j/.ssh/known_hosts" -R "192.168.2.104"</div></blockquote></div>
<p> </p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-77443338405552885162023-05-29T15:49:00.001+07:002023-05-29T15:49:08.678+07:00Bash get price cryto from binance.<p>All</p><p>https://api.binance.com/api/v3/ticker/price? </p><p>Some symbol<br /></p><p>https://api.binance.com/api/v3/ticker/price?symbol=LUNCUSDT<br /><br />code<br /><br />#!/usr/bin/env bash<br />btc=$(curl -sS https://api.binance.com/api/v3/ticker/price?symbol=BTCUSDT | jq -Mr '.price')<br />lunc=$(curl -sS https://api.binance.com/api/v3/ticker/price?symbol=LUNCUSDT | jq -Mr '.price')<br />shib=$(curl -sS https://api.binance.com/api/v3/ticker/price?symbol=SHIBUSDT | jq -Mr '.price')<br />xec=$(curl -sS https://api.binance.com/api/v3/ticker/price?symbol=XECUSDT | jq -Mr '.price')<br /><br />echo "B $btc | L $lunc | S $shib | X $xec"<br /><br /></p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-60463904677276817942022-09-05T15:12:00.003+07:002022-09-05T15:12:28.535+07:00ubuntu 22.04 Set IP<p> </p><div class="content"><span style="font-weight: bold;">ubuntu 22.04 Set IP</span><br />1. check name card<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb5660" style="font-family: monospace;"><ol><li class="li1">sudo ip a </li></ol></div></div></div><br />2. แก้ไฟล์<br /><blockquote class="uncited"><div>/etc/netplan/00-network-manager-all.yaml</div></blockquote><br />3. แก้ไฟล์ดังนี้ enp0s3 คือได้จากข้อ 1.<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb39403" style="font-family: monospace;"><ol><li class="li1">network:</li><li class="li2"> ethernets:</li><li class="li1"> enp0s3:</li><li class="li2"> dhcp4: false</li><li class="li1"> addresses: [192.168.2.1/24]</li><li class="li2"> gateway4: 192.168.2.2</li><li class="li1"> nameservers:</li><li class="li2"> addresses: [8.8.8.8,8.8.4.4,192.168.2.2]</li><li class="li1"> version: 2 </li></ol></div></div></div><br />4. ใช้คำสั่ง<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb61051" style="font-family: monospace;"><ol><li class="li1">sudo netplan apply</li></ol></div></div></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-84348667226274719882022-07-05T15:56:00.004+07:002022-07-05T15:56:24.116+07:00Axapta : Error Post Post Invoice Error Under delivery<p> Axapta : Error Post Post Invoice Error Under delivery<br /></p><blockquote class="uncited"><div>Under-delivery of line is 11.96 percent, but the allowe under-delivery is only percent.<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk2u9wO6hLOEG2NtF7zuAYQiJB_XkO9k3SgZWMBkLpVEignjL17zV2WQCrgJhtAQS7pT7QgK-sXbikk0slogaCSN4gz3F0CsKtnC6fTHNGH0TM8M9DhAvrRII5xKYKhhlGv4B7wnZkEoy3XQ8jO34JB3DtDN1X8G-9as3i91wdHSKtMq_AhwEp8LL6/s984/2022-07-05_133026.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="400" data-original-width="984" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk2u9wO6hLOEG2NtF7zuAYQiJB_XkO9k3SgZWMBkLpVEignjL17zV2WQCrgJhtAQS7pT7QgK-sXbikk0slogaCSN4gz3F0CsKtnC6fTHNGH0TM8M9DhAvrRII5xKYKhhlGv4B7wnZkEoy3XQ8jO34JB3DtDN1X8G-9as3i91wdHSKtMq_AhwEp8LL6/s320/2022-07-05_133026.png" width="320" /></a></div></div></blockquote><p>PO22-06889 : Item 901291407228-S<br />เกิดจากจำนวนที่จะทำรับ
ไม่สอดคล้องกับ จำนวน Deliver remainder เนื่องจากมีการใช้ Function
Deliver remainder จำนวนออก ต้องไล่ดูข้อมูล<br />ใน Table PurchParmLine</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7bnRtgZZ2n0tHmfNB7T302fCsEt2hhdSwA5p7fXmKhAZnZdmntufA8OhhuIbkcG849PEAK3jJPrW9hDwL22gJ6B-aD_uHohhDHjKy8L6stmNxDZfTyfjJ7Jk8EyPEkvFByNaxis8t42aEhfECMpY7-0-dy6knmc9Wcc15jgfrDbn_ljxkWLjunztz/s1681/2022-07-05_140015.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="354" data-original-width="1681" height="67" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7bnRtgZZ2n0tHmfNB7T302fCsEt2hhdSwA5p7fXmKhAZnZdmntufA8OhhuIbkcG849PEAK3jJPrW9hDwL22gJ6B-aD_uHohhDHjKy8L6stmNxDZfTyfjJ7Jk8EyPEkvFByNaxis8t42aEhfECMpY7-0-dy6knmc9Wcc15jgfrDbn_ljxkWLjunztz/s320/2022-07-05_140015.png" width="320" /></a><br /></div><p>จากรูปจะพบว่ายอดก่อนที่รับล่าสุด 200 ควรจะเหลือ 161 แต่เหลือ 100 ดู Database log พบว่ามีการปรับออก 61<br /></p><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_U294xCab7UkfRT86zjURFACugwTmGURsfq4U2vor3FgQWANs_dw0GuHE0Oh3V-kdUAi2WmDdRKDV_aVW7LmGqRlWM3WCEm4uYMLZqh1u-ulOZqvysRAmDew7i6ddukDpCidzDAP2YV-4RiXbsR9c_lyX_nvNBjOIuTijm1_5I8qMXGIqneZGoVZj/s818/2022-07-05_140928.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="596" data-original-width="818" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_U294xCab7UkfRT86zjURFACugwTmGURsfq4U2vor3FgQWANs_dw0GuHE0Oh3V-kdUAi2WmDdRKDV_aVW7LmGqRlWM3WCEm4uYMLZqh1u-ulOZqvysRAmDew7i6ddukDpCidzDAP2YV-4RiXbsR9c_lyX_nvNBjOIuTijm1_5I8qMXGIqneZGoVZj/s320/2022-07-05_140928.png" width="320" /></a></div></dl></div><span style="font-weight: bold;">วิธีแก้</span><br />ใช้ปุ่ม Function Deliver remainder ปรับยอดให้เป็นจำนวนที่ถูกคือ 161<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAHAi4PEzV8Z7vkS8reHs_er_dn4MEaV6YWsq32f4k34ntYIzqTB9q4-eoo742OqG-74G-Z1s6ZG2NSRK0mCtfUd5yBXuwwx0_8T2ZG6sTzYaY09VMl7n7q8G7A5xeCfxYIsyN0sVsjFb9MVv2iC1-38OPh6Yt6txeFZD_YBAFhhdx7D8HN72uFHvS/s863/2022-07-05_140954.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="805" data-original-width="863" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAHAi4PEzV8Z7vkS8reHs_er_dn4MEaV6YWsq32f4k34ntYIzqTB9q4-eoo742OqG-74G-Z1s6ZG2NSRK0mCtfUd5yBXuwwx0_8T2ZG6sTzYaY09VMl7n7q8G7A5xeCfxYIsyN0sVsjFb9MVv2iC1-38OPh6Yt6txeFZD_YBAFhhdx7D8HN72uFHvS/s320/2022-07-05_140954.png" width="320" /></a></div></dl></div>แล้ว Post PO จะผ่าน แล้วแจ้ง User
ว่ายอดที่รับเข้ามาจะใช้ทำรับเพิ่มหรือไม่ ถ้าไม่ให้ Cancel ออก Status
จะได้เป็น Invoice ถ้าต้องการใช้อยู่ก็ให้คงไว้<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-57657262176922571612022-06-30T13:34:00.006+07:002022-06-30T13:34:43.418+07:00How to disable firefox browser cache<p> How to disable firefox browser cache<br />เวลาเขียนโปรแกรม ตัวโปรแกรมถูกแต่ผลใน browser ไม่เปลี่ยนตาม จึงต้องปิดไม่ให้เก็บ cache<br /><br /><a class="postlink" href="https://support.mozilla.org/en-US/questions/905902">https://support.mozilla.org/en-US/questions/905902</a><br /><br />1. type in the address bar <span style="font-weight: bold;">about:config</span><br />2. then press the button<span style="font-weight: bold;"> i'l be careful i promise</span><br />3. then type in the bar <span style="font-weight: bold;">browser.cache.disk.enable</span><br />4. then double click on it, to make it <span style="font-weight: bold;">false</span><br />5. do the same with <span style="font-weight: bold;">browser.cache.memory.enable </span><br />6. exit firefox and restart-it.</p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-19899129345140359102022-06-25T11:14:00.000+07:002022-06-25T11:14:02.443+07:00Linux mint : Shutter hotkey<p>Linux mint : Shutter hotkey<br />https://shutter-project.org/faq-help/set-shutter-as-the-default-screenshot-tool/<br /><br />1. Keyboard --> Shortcuts --> Add custom shortcut<br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg_jl_ZMe1Bn5nF902M4a25evIVC7QeqlBNIaIC6q-pLWY2VyPGBxX5hbJDmtCJV0sgo0F3Tan5IYBEihrZmGQ2C-cTUsU8Ms6ySdGHPSkZ1fNlFjimZ_nad6qy52x9pkdIvhV0ggWYnkFjAMjKzuhUW_9Dgi2EJQET4sjMSsFXjRKgez-V7k46nii/s351/Selection_287.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="156" data-original-width="351" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg_jl_ZMe1Bn5nF902M4a25evIVC7QeqlBNIaIC6q-pLWY2VyPGBxX5hbJDmtCJV0sgo0F3Tan5IYBEihrZmGQ2C-cTUsU8Ms6ySdGHPSkZ1fNlFjimZ_nad6qy52x9pkdIvhV0ggWYnkFjAMjKzuhUW_9Dgi2EJQET4sjMSsFXjRKgez-V7k46nii/s320/Selection_287.png" width="320" /></a></div><p></p><p></p><p></p><p></p><p><br />2. แก้ด้านล่าง กด Key ที่เราต้องการ<br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJRbrih2vvcQau5dP6PtKrHyN6DrvF9XBbWAi-MjgTLa1Q1XFG0k4JxcoT5ygQ7qXxpF_Pp5CRvVLlJgdCJntTaa0tBvuSDqGwuSiPefq278bRf-jusd0xewM9hQoKI9VRAS9dx--fq4DQ9thnZf-C5eNGS5nDoS-BTLxjUTYCr7kQ3reRf-Dw8Hyp/s799/Selection_288.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="623" data-original-width="799" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJRbrih2vvcQau5dP6PtKrHyN6DrvF9XBbWAi-MjgTLa1Q1XFG0k4JxcoT5ygQ7qXxpF_Pp5CRvVLlJgdCJntTaa0tBvuSDqGwuSiPefq278bRf-jusd0xewM9hQoKI9VRAS9dx--fq4DQ9thnZf-C5eNGS5nDoS-BTLxjUTYCr7kQ3reRf-Dw8Hyp/s320/Selection_288.png" width="320" /></a></div><br /><br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-36091962363381671642022-06-10T16:40:00.005+07:002022-06-10T16:40:53.824+07:00Axapta : หาค่าสูงสูดในตัวแปร Max <p> </p><div class="content">Axapta : หาค่าสูงสูดในตัวแปร Max <div class="codebox"><div class="codeholder"><div class="text" id="cb45278" style="font-family: monospace;"><br /><ol><li class="li2">static void MyMaxJob(Args _args)</li><li class="li1">{ </li><li class="li2"> int test;</li><li class="li1">;</li><li class="li2"> </li><li class="li1"> test = max (100,120,300,400,500);</li><li class="li2"> </li><li class="li1"> info(int2str(test));</li><li class="li2">}</li></ol></div></div></div></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-10527355157494443762022-05-17T17:35:00.003+07:002022-05-17T17:35:17.119+07:00 Axapta : Job LibreOffice Copy Sheet <p> Axapta : Job LibreOffice Copy Sheet <br /><span style="font-weight: bold;">ตัวอย่าง</span><br /></p><div class="codebox"><div class="codeholder"><div class="text" id="cb17685" style="font-family: monospace;"><ol><li class="li1">static void CopySheetOffice(Args _args)</li><li class="li2">{</li><li class="li1"> </li><li class="li2">// ----------- OpenOffice -----------</li><li class="li1"> COM OpenOffice;</li><li class="li2"> COM oDeskTop;</li><li class="li1"> COM oDocument;</li><li class="li2"> COM oSheets;</li><li class="li1"> COM oSheet;</li><li class="li2"> COM oRange;</li><li class="li1"> COM BorderStruct;</li><li class="li2"> COMVariant arg;</li><li class="li1"> COMVariant byte;</li><li class="li2"> Array Arr = new Array(Types::Class);</li><li class="li1"> Array oArr = new Array(Types::Class);</li><li class="li2"> str url;</li><li class="li1"> str outFile;</li><li class="li2"> COM FileProperties;</li><li class="li1"> </li><li class="li2">// ----------- TABLE -----------</li><li class="li1"> CustTable custTable;</li><li class="li2"> </li><li class="li1">// ----------- VARIABLE -----------</li><li class="li2"> int rows = 1;</li><li class="li1"> int sheet = 2;</li><li class="li2"> </li><li class="li1">///##### Function Print Trans #####//</li><li class="li2"> void printTrans(){</li><li class="li1"> rows++;</li><li class="li2"> oRange = oSheet.getCellByPosition(0, rows);</li><li class="li1"> oRange.SetString("123456");</li><li class="li2"> }</li><li class="li1"> </li><li class="li2"> ;</li><li class="li1"> </li><li class="li2">// ##### Open template file ######</li><li class="li1"> url = strfmt("%1%2", templatePath(), "/IV/ItemNotTransferByDate.ods");</li><li class="li2"> OpenOffice = new Com("com.sun.star.ServiceManager");</li><li class="li1"> oDeskTop = OpenOffice.CreateInstance("com.sun.star.frame.Desktop");</li><li class="li2"> arg = COMVariant::createFromArray(arr);</li><li class="li1"> oDocument = oDeskTop.LoadComponentFromURL(url, "_blank", 0, arg);</li><li class="li2"> oSheets = oDocument.getSheets();</li><li class="li1"> oSheet = oSheets.getByIndex(0);</li><li class="li2"> </li><li class="li1"> BorderStruct = OpenOffice.Bridge_GetStruct('com.sun.star.table.BorderLine');</li><li class="li2"> BorderStruct.Color(24567057);</li><li class="li1"> BorderStruct.LineDistance(0);</li><li class="li2"> BorderStruct.InnerLineWidth(0);</li><li class="li1"> BorderStruct.OuterLineWidth(1);</li><li class="li2"> </li><li class="li1">// ##### Save as temp file ######</li><li class="li2"> DeleteFilesInFolder("C:/AxaptaSP4/Temp/IV/");</li><li class="li1"> outFile = strfmt("file:///C:/AxaptaSP4/Temp/IV/ItemNotTransferByDate-%1.ods", timenow());</li><li class="li2"> oDocument.storeAsURL(outFile, arg);</li><li class="li1">// #######################################################################################</li><li class="li2"> </li><li class="li1"> WHILE</li><li class="li2"> SELECT AccountNum FROM custTable</li><li class="li1"> ORDER BY Name</li><li class="li2"> WHERE custTable.CustGroup == "AUD"</li><li class="li1"> {</li><li class="li2"> oSheets.CopyByName("Template", custTable.AccountNum, sheet);</li><li class="li1"> oSheet = oSheets.getByIndex(sheet);</li><li class="li2"> </li><li class="li1"> printTrans();</li><li class="li2"> </li><li class="li1"> rows = 1;</li><li class="li2"> sheet++;</li><li class="li1"> }//Close While.</li><li class="li2"> </li><li class="li1">}</li></ol></div></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-33455205914743367542022-04-27T08:37:00.003+07:002022-04-27T08:37:31.712+07:00 Raspberry Pi Desktop install vmware tools<p> Raspberry Pi Desktop install vmware tools<br />1. ติดตั้ง <br /></p><div class="codebox"><div class="codeholder"><div class="text" id="cb28333" style="font-family: monospace;"><ol><li class="li1">sudo apt-get update</li><li class="li2">sudo apt-get install open-vm-tools</li></ol></div></div></div><br /><br />2. mount vmware tools ที่ VMware Actions --> Guest OS --> Install Vmware Tools<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSSPunAu5M9_XOZQL6rGPpMY3BZltbDQQLaAkdM8CNIr5-5kQhvJ54WNUGqIuaQ4GeQKWGFzt1sKprwR8D1VYjXCsiY_72oqLce_fX300AC3Zq1F9cEJCTJ-h3nlAIcmktRwkm46VxUNl495Aw5fcPtQdUMSt4ky9LGCDlaa9AIgXtcdHOk7XMYEsB/s798/vmware_tools_cdrom_contents.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="562" data-original-width="798" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSSPunAu5M9_XOZQL6rGPpMY3BZltbDQQLaAkdM8CNIr5-5kQhvJ54WNUGqIuaQ4GeQKWGFzt1sKprwR8D1VYjXCsiY_72oqLce_fX300AC3Zq1F9cEJCTJ-h3nlAIcmktRwkm46VxUNl495Aw5fcPtQdUMSt4ky9LGCDlaa9AIgXtcdHOk7XMYEsB/s320/vmware_tools_cdrom_contents.png" width="320" /></a></div><br /><dt><br /></dt></dl>
</div>3. Copy ไฟล์ .tar.gz ไปไว้ที่ /tem<br /><div class="codebox"><div class="codeholder"><div class="text" id="cb44402" style="font-family: monospace;"><ol><li class="li1">cp VMwareTools-10.2.0-XXXXX.tar.gz /tmp/</li><li class="li2">cd /tmp</li><li class="li1">tar -zxvf VMwareTools-10.2.0-XXXXXX.tar.gz</li><li class="li2">cd vmware-tools-distrib</li><li class="li1">sudo ./vmware-install.pl</li></ol></div></div></div><br />4. ขั้นตอน Install กด Enter ตอบตาม Default ที่โปรแกรมกำหนดมา<br />5. Reboot เครื่องUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-81870280077681601532022-02-15T09:13:00.001+07:002022-02-15T09:16:24.654+07:00TRP03 รายการและเล่มถูกลบหาย แต่ Transaction ยังค้างอยู่ ยอดที่จองไปไม่คืน ทำให้ไม่มียอดจองเมื่อสร้างเล่มใหม่ขึ้นมา<p> TRP03 รายการและเล่มถูกลบหาย แต่ Transaction ยังค้างอยู่ ยอดที่จองไปไม่คืน ทำให้ไม่มียอดจองเมื่อสร้างเล่มใหม่ขึ้นมา<br /><br />เช่น เล่ม 22-0002772 ถูกลบ และสร้าง 22-002916 มีรายการ Valve เหมือนกัน แต่ไม่มีของให้จอง <br /><br />วิธีแก้ (ทำใน Local ก่อนแก้ไนของจริง)<br />1. ต้องหา Item ให้ได้ก่อนว่าในเล่มนั้นมี Item อะไรจะได้ตามหาเลขที่ ของเอกสารได้ ต้องถาม User <br />2.
ได้ Item หาใน Transaction ว่าเอกสารที่ลบไปเลขที่เท่าไหร่ เช่น
2259022021010, 25902341425, 383022219018, 291020929019 เป็นต้น ดู
Transaction จะพบเล่ม แต่ Go to main ไปหาเล่มไม่ได้แล้ว<br />ตรวจสอบ Transaction ว่าเลขที่ 22-0002772 มีการจองของไว้</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgqh6MhQHjZ1EREipZff2WRhWEhvAL20DsnxcwPYxAlPuMmF8QM1N9OpIfEeXZekFd-tJHcHj-iNaAwR9PFNuIu1MhyFOKuUNWqjfqoBqlj1ose5dsMxKpc9b9a7d1bCXHPZ045uL7CeKyfbgm_wfZr5OdibuIVjGDKd39pyq01bVNS-2Vg6Lj9rLBg=s1401" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="396" data-original-width="1401" height="90" src="https://blogger.googleusercontent.com/img/a/AVvXsEgqh6MhQHjZ1EREipZff2WRhWEhvAL20DsnxcwPYxAlPuMmF8QM1N9OpIfEeXZekFd-tJHcHj-iNaAwR9PFNuIu1MhyFOKuUNWqjfqoBqlj1ose5dsMxKpc9b9a7d1bCXHPZ045uL7CeKyfbgm_wfZr5OdibuIVjGDKd39pyq01bVNS-2Vg6Lj9rLBg=s320" width="320" /></a></div>3. ค้นหาใน Database log ใส่ *เลขที่เอกสาร*
และเลือกรายการที่ถูกลบไปเฉพาะที่ต้องการ เพื่อให้รายการใน
InventJournalTrans กลับคืนมา<br />เลือกรายการทีละ รายการแล้วกด Reinsert<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhX_AydcVuoom6sCqEiIEHa8RMClav76Uhuj-KA3zEtFUTLhEeXcUwO440YzlUYfJZqVuuMGlfv1btKhXiWhaHnlgR4t3y3tzq4WcGRDC9eBXJRiVPM2OcgrLu9LdsOMla_iWWHz1df4tpVpgv-gCCsy5W6yrzOv4pLsosQwqZ1LvtAMrAVe06OEchu=s1293" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="212" data-original-width="1293" height="52" src="https://blogger.googleusercontent.com/img/a/AVvXsEhX_AydcVuoom6sCqEiIEHa8RMClav76Uhuj-KA3zEtFUTLhEeXcUwO440YzlUYfJZqVuuMGlfv1btKhXiWhaHnlgR4t3y3tzq4WcGRDC9eBXJRiVPM2OcgrLu9LdsOMla_iWWHz1df4tpVpgv-gCCsy5W6yrzOv4pLsosQwqZ1LvtAMrAVe06OEchu=s320" width="320" /></a></div><dt><br /></dt></dl></div>4. สร้าง เล่มเอกสารเล่มใหม่ขึ้นมา สร้างเฉพาะ เล่ม เช่น 22-0002935<br />ใช่ SQL Server Enterprise Run Code <br /><div class="codebox"><div class="codeholder"><div class="text" id="cb60127" style="font-family: monospace;"><ol><li class="li1">SELECT *</li><li class="li2">FROM INVENTJOURNALTABLE</li><li class="li1">WHERE (JOURNALID = '22-0002935')</li></ol></div></div></div><br />แล้วแก้ JOURNALID จาก 22-0002935 เป็นเลขที่หายไป 22-0002772<br /><br />5. เข้า Tab History กด Recalculation เพื่อให้เลข Run ใน Line Update<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhjIIO9Ipq9fjwT9EoBrcsUWcgldDxgIPjOveCSHAO8VX5tTAnXmXbN9Y1m1Urle0aYwhjf8HJa0cpIEhKTvlha3YjxcCehZqpDhmOGWWtgJjYdgRWHSYddrYWJlcPbUxbYXwMEY4HGAW-S5iWKSt1GfjdDgWIQyXrdCWF30r6NzeXs0OL02p_e44Jo=s846" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="298" data-original-width="846" height="113" src="https://blogger.googleusercontent.com/img/a/AVvXsEhjIIO9Ipq9fjwT9EoBrcsUWcgldDxgIPjOveCSHAO8VX5tTAnXmXbN9Y1m1Urle0aYwhjf8HJa0cpIEhKTvlha3YjxcCehZqpDhmOGWWtgJjYdgRWHSYddrYWJlcPbUxbYXwMEY4HGAW-S5iWKSt1GfjdDgWIQyXrdCWF30r6NzeXs0OL02p_e44Jo=s320" width="320" /></a></div></dl></div>6. ตรวจดูข้อมูลใน Line เข้าดูการ Reservation และ Validate ข้อมูลดู ว่ามี Error หรือไม่ <br />ดู Transaction กด Go to main จากเลขที่เอกสารมาหาเล่มได้<br />7. ลบรายการเล่มที่ไม่ได้ใช้ออกเช่น 22-002916<br />8. แจ้ง User ตรวจสอบความถูกต้องแล้วค่อย PostUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-17837441093294045342022-01-31T09:02:00.002+07:002022-01-31T09:03:51.487+07:00VB : VB Read Data To Array And Extract To Use Data. To Read Data Again<p> </p><div class="content">VB : VB Read Data To Array And Extract To Use Data. To Read Data Again<br />Example : <br /><div class="codebox"><div class="codeholder"><div class="text" id="cb48887" style="font-family: monospace;"><ol><li class="li1"> </li><li class="li2"> Dim ArrayBarCode As ArrayList</li><li class="li1"> ArrayBarCode = New ArrayList</li><li class="li2"> .</li><li class="li2"> .</li><li class="li2"> . <br /></li><li class="li1"> While myReader.Read()</li><li class="li2"> FirstCode = myReader.Item("FirstCode").ToString()</li><li class="li1"> AccountCode = myReader.Item("AccountCode").ToString()</li><li class="li2"> TypeCode = myReader.Item("TypeCode").ToString()</li><li class="li1"> SubTypeCode = myReader.Item("SubTypeCode").ToString()</li><li class="li2"> RunNo = myReader.Item("RunNo").ToString()</li><li class="li1"> </li><li class="li2"> If CheckBox_LastTransaction.Checked = True Then</li><li class="li1">
ArrayBarCode.Add(BarCode) '###### Add BarCode เข้า
Array เพื่อไป Loop ออกรายงานอีกรอบ เพราะ Reader ซ่อน Loop ไม่ได้</li><li class="li2"> End If</li><li class="li1"> End While</li><li class="li2"> myReader.Close()</li><li class="li1"> Dim m As Long</li><li class="li2"> line = 5</li><li class="li1"> If CheckBox_LastTransaction.Checked = True Then</li><li class="li2"> firstSheet.getCellByPosition(8, 4).String = "ประวัติการโอนย้ายครั้งล่าสุด"</li><li class="li1"> For m = 0 To ArrayBarCode.Count - 1</li><li class="li2"> '########## Select Data From Other Table Again #############'</li><li class="li1"> SQLTmp = "SELECT OldUser,Reason,EmpName FROM sci_ams.asset_move " _</li><li class="li2"> & " LEFT JOIN sci._employees ON _employees.EmpID= asset_move.OldUser " _</li><li class="li1"> & " WHERE BarCode = '" & ArrayBarCode(m) & "' AND End = 'Y' " _</li><li class="li2"> & " ORDER BY Id DESC"</li><li class="li1"> </li><li class="li2"> myCommand.CommandText = SQLTmp</li><li class="li1"> myAdapter.SelectCommand = myCommand</li><li class="li2"> myReader = myCommand.ExecuteReader</li><li class="li1"> If (myReader.Read()) Then</li><li class="li2">
LastTransaction =
myReader.Item("OldUser").ToString() & ":" &
myReader.Item("EmpName").ToString() & " : " &
myReader.Item("Reason").ToString()</li><li class="li1"> End If</li><li class="li2"> </li><li class="li1"> line = line + 1</li><li class="li2"> myReader.Close() '###### ต้อง Close ไม่อย่างนั้น ERROR เพราะอยู่ใน Loop อ่านจาก DB หลายรอบ</li><li class="li1"> Next</li></ol></div></div></div><br /> End If</div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-9103974021418767189.post-25011867765044425312022-01-22T17:08:00.007+07:002022-01-22T17:08:39.815+07:00Windows10 21H2 Add Printer ที่ Shared จากเครื่องอื่น ไม่ได้<p>Windows10 21H2 Add Printer ที่ Shared จากเครื่องอื่น ไม่ได้</p><p></p><p>How to Fix Windows Cannot Connect to Printer - Error 0x0000011b</p><p><br />วิธีแก้ไข เข้าไปที่<br />C:\Windows\regedit > HKEY LOCAL MACHINE > SYSTEM > CURRENTCONTROLSET > CONTROL > PRINT<br />คลิ้กที่ Print ใน Regedit แล้วคลิ้กขวา > New > DWORD (32-BIT)VALUE เปลี่ยนชื่อเป็น RpcAuthnLevelPrivacyEnabled แล้วก็กด Enter<br />เสร็จแล้วให้เราไป Restart Services Print Spooler จากนั้นก็เข้าไป Add Print แบบปกติจะรอนานหน่อยต้องรอจนกว่าจะเสร็จแล้วก็ Add Dirver เข้าไปตามชื่อ Printer ครับ<br /><br />ตัวอย่าง<br />https://www.youtube.com/watch?v=XouW14RUJxs</p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-6440292634696325622022-01-17T09:18:00.007+07:002022-01-17T09:18:36.363+07:00PHP : php ส่งค่าออก Libreoffice Calc ด้วย TBS<p>PHP : php ส่งค่าออก Libreoffice Calc ด้วย TBS<br />ตัวอย่าง<br /><a class="postlink" href="https://www.tinybutstrong.com/opentbs.php?demo">https://www.tinybutstrong.com/opentbs.php?demo</a><br /><br />ต้องการส่งค่า ตั้งค่า ใน Template<br />1. Sting ใช้เป็น [Block.<span style="color: red;">ArrayName</span>]<br />2. Date ต้องใส่ ;ope=tbs:date ต่อท้าย เช่น [Block.ArrayDate<span style="color: red;">;ope=tbs:date</span>]<br />3. Number ต้องใส่ ;ope=tbs:num ต่อท้าย เช่น [Block.ArrayDate<span style="color: red;">;ope=tbs:num</span>]<br />ข้อ 2, 3 ก็จะไม่มี ' และจัด Format ได้<br />4. ต้องการใส่เลข Run Line ใช้ #;ope=tbs:num ต่อท้าย เช่น [Block.<span style="color: red;">#;ope=tbs:num</span>]</p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-71496057143866462872021-11-17T13:27:00.004+07:002021-11-17T13:27:30.226+07:00 Axapta : Job เช็ค Item Id 12 หลักและแปลงหลักสุดท้ายให้ถูก<p> Axapta : Job เช็ค Item Id 12 หลักและแปลงหลักสุดท้ายให้ถูก<br /><br /></p><ol><li class="li1"> </li><li class="li2">static void CheckItemId12(Args _args)</li><li class="li1">{</li><li class="li2"> AsciiIO myFile;</li><li class="li1"> AsciiIO ItemFileConvert;</li><li class="li2"> AsciiIO ErrorFile;</li><li class="li1"> </li><li class="li2"> container RecData;</li><li class="li1"> container contTmp;</li><li class="li2"> </li><li class="li1"> ItemId myItemId;</li><li class="li2"> ItemId myItemIdConverted;</li><li class="li1"> int r = 1;</li><li class="li2"> </li><li class="li1"> int a,b,c,d,e,f,g,h,i,j,k,l;</li><li class="li2"> int a3,b3,c3,d3,e3,f3,g3,h3,i3,j3,k3,l3;</li><li class="li1"> int a4,b4,c4,d4,e4,f4,g4,h4,i4,j4,k4,l4;</li><li class="li2"> ;</li><li class="li1"> </li><li class="li2"> myFile=new AsciiIO("C:\\Item\\ItemCheckConvert.csv","r");</li><li class="li1"> myfile.inFieldDelimiter("|");</li><li class="li2"> while(myFile.status() == IO_Status::Ok)</li><li class="li1"> RecData += myFile.read();</li><li class="li2"> myFile = null;</li><li class="li1"> </li><li class="li2"> </li><li class="li1"> ItemFileConvert=new AsciiIO("C:\\Item\\ItemFileConvert.txt","a");</li><li class="li2"> ErrorFile=new AsciiIO("C:\\Item\\ErrorFile.txt","a");</li><li class="li1"> for(r=1; r <= conlen(RecData); r++){</li><li class="li2"> </li><li class="li1"> myItemId = conpeek(RecData, r);</li><li class="li2"> </li><li class="li1"> if(strlen(myItemId) == 12){</li><li class="li2"> a = str2int(substr(myItemId,1,1));</li><li class="li1"> b = str2int(substr(myItemId,2,1));</li><li class="li2"> c = str2int(substr(myItemId,3,1));</li><li class="li1"> d = str2int(substr(myItemId,4,1));</li><li class="li2"> e = str2int(substr(myItemId,5,1));</li><li class="li1"> f = str2int(substr(myItemId,6,1));</li><li class="li2"> g = str2int(substr(myItemId,7,1));</li><li class="li1"> h = str2int(substr(myItemId,8,1));</li><li class="li2"> i = str2int(substr(myItemId,9,1));</li><li class="li1"> j = str2int(substr(myItemId,10,1));</li><li class="li2"> k = str2int(substr(myItemId,11,1));</li><li class="li1"> l = str2int(substr(myItemId,12,1));</li><li class="li2"> </li><li class="li1"> a3 = (a * 2);</li><li class="li2"> b3 = b;</li><li class="li1"> c3 = (c * 2);</li><li class="li2"> d3 = d;</li><li class="li1"> e3 = (e * 2);</li><li class="li2"> f3 = f;</li><li class="li1"> g3 = (g * 2);</li><li class="li2"> h3 = h;</li><li class="li1"> i3 = (i * 2);</li><li class="li2"> j3 = j;</li><li class="li1"> k3 = (k * 2);</li><li class="li2"> </li><li class="li1"> a4 = (a3>9) ? str2int(substr(int2str(a3),1,1)) + str2int(substr(int2str(a3),2,1)) : a3;</li><li class="li2"> b4 = (b3>9) ? str2int(substr(int2str(b3),1,1)) + str2int(substr(int2str(b3),2,1)) : b3;</li><li class="li1"> c4 = (c3>9) ? str2int(substr(int2str(c3),1,1)) + str2int(substr(int2str(c3),2,1)) : c3;</li><li class="li2"> d4 = (d3>9) ? str2int(substr(int2str(d3),1,1)) + str2int(substr(int2str(d3),2,1)) : d3;</li><li class="li1"> e4 = (e3>9) ? str2int(substr(int2str(e3),1,1)) + str2int(substr(int2str(e3),2,1)) : e3;</li><li class="li2"> f4 = (f3>9) ? str2int(substr(int2str(f3),1,1)) + str2int(substr(int2str(f3),2,1)) : f3;</li><li class="li1"> g4 = (g3>9) ? str2int(substr(int2str(g3),1,1)) + str2int(substr(int2str(g3),2,1)) : g3;</li><li class="li2"> h4 = (h3>9) ? str2int(substr(int2str(h3),1,1)) + str2int(substr(int2str(h3),2,1)) : h3;</li><li class="li1"> i4 = (i3>9) ? str2int(substr(int2str(i3),1,1)) + str2int(substr(int2str(i3),2,1)) : i3;</li><li class="li2"> j4 = (j3>9) ? str2int(substr(int2str(j3),1,1)) + str2int(substr(int2str(j3),2,1)) : j3;</li><li class="li1"> k4 = (k3>9) ? str2int(substr(int2str(k3),1,1)) + str2int(substr(int2str(k3),2,1)) : k3;</li><li class="li2"> l4 = 10 -((a4 + b4 + c4 + d4 + e4 + f4 + g4 + h4 + i4 + j4 + k4) mod 10);</li><li class="li1"> l4 =( l4 == 10 ) ? 0 : l4;</li><li class="li2"> if(l4 != l){</li><li class="li1"> //Converted</li><li class="li2"> myItemIdConverted = strfmt("%1%2%3%4%5%6%7%8%9%10%11%12",a,b,c,d,e,f,g,h,i,j,k,l4);</li><li class="li1"> Print(strfmt("%1 : %2 \t Coverted", r, myItemid));</li><li class="li2"> ItemFileConvert.write(strfmt("%1|%2", myItemId, myItemIdConverted));</li><li class="li1"> } else {</li><li class="li2"> //Not Convert</li><li class="li1"> Print(strfmt("%1 : %2 \t Not Convert", r, myItemid));</li><li class="li2"> ItemFileConvert.write(strfmt("%1|%2", myItemId, myItemId));</li><li class="li1"> }//Close Else.</li><li class="li2"> } else {</li><li class="li1"> Print(strfmt("%1 : %2 \t Error", r, myItemid));</li><li class="li2"> ErrorFile.write(strfmt("%1",myItemId));</li><li class="li1"> }//Close Else.</li><li class="li2"> }//Close for.</li><li class="li1"> ItemFileConvert = null;</li><li class="li2"> ItemFileConvert = null;</li><li class="li1"> box::info("Complete","Converted");</li><li class="li2">}</li></ol>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-9044748678195061012021-10-11T15:51:00.003+07:002021-10-11T15:51:45.041+07:00Code Auto Remove Slack เปลี่ยน API ใหม่ Code เดิมลบไม่ได้<p>Python Auto Remove Slack Chet History. <br /></p><p> เปลี่ยน API</p><div class="codebox"><div class="codeholder"><div class="text" id="cb70928" style="font-family: monospace;"><ol><li class="li1">response = sc.api_call('<span style="color: red;">conversations.history</span>', channel=channel, <span style="color: red;">limit</span>=1000, oldest=oldest_ts, latest=latest_ts)</li></ol></div></div></div><br /><br />Code สำเร็จ<br /><ol><li class="li1"> </li><li class="li2"> </li><li class="li1"><span style="color: #ff7700; font-weight: bold;">from</span> slackclient <span style="color: #ff7700; font-weight: bold;">import</span> SlackClient</li><li class="li2"><span style="color: grey; font-style: italic;">#from time import sleep</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">import</span> <span style="color: crimson;">time</span></li><li class="li2"><span style="color: grey; font-style: italic;">#import datetime</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">from</span> <span style="color: crimson;">datetime</span> <span style="color: #ff7700; font-weight: bold;">import</span> <span style="color: crimson;">datetime</span>, timedelta</li><li class="li2"> </li><li class="li1">legacy_token = <span style="color: darkslateblue;">'XXXX'</span> <span style="color: grey; font-style: italic;"># don't if you share your code</span></li><li class="li2"><span style="color: grey; font-style: italic;">########## Chanel Camera ##############</span></li><li class="li1">channel = <span style="color: darkslateblue;">'XXXX'</span> <span style="color: grey; font-style: italic;"># Camera Channel.</span></li><li class="li2"> </li><li class="li1">sc = SlackClient<span style="color: black;">(</span>legacy_token<span style="color: black;">)</span></li><li class="li2">response = sc.<span style="color: black;">api_call</span><span style="color: black;">(</span><span style="color: darkslateblue;">'channels.info'</span>, channel=channel<span style="color: black;">)</span></li><li class="li1"> </li><li class="li2"><span style="color: grey; font-style: italic;">#oldest_ts = response['channel']['created']</span></li><li class="li1">date_days_ago = <span style="color: crimson;">datetime</span>.<span style="color: black;">now</span><span style="color: black;">(</span><span style="color: black;">)</span> - timedelta<span style="color: black;">(</span>days=<span style="color: orangered;">90</span><span style="color: black;">)</span></li><li class="li2">oldest_ts = <span style="color: crimson;">time</span>.<span style="color: black;">mktime</span><span style="color: black;">(</span>date_days_ago.<span style="color: black;">timetuple</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">print</span><span style="color: black;">(</span><span style="color: crimson;">datetime</span>.<span style="color: black;">fromtimestamp</span><span style="color: black;">(</span>oldest_ts<span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li2"> </li><li class="li1"><span style="color: grey; font-style: italic;">#date_days_ago = datetime.now() - timedelta(days=60) # Keep File On Slack 60 Day.</span></li><li class="li2">date_days_ago = <span style="color: crimson;">datetime</span>.<span style="color: black;">now</span><span style="color: black;">(</span><span style="color: black;">)</span> - timedelta<span style="color: black;">(</span>days=<span style="color: orangered;">7</span><span style="color: black;">)</span> <span style="color: grey; font-style: italic;"># Keep File On Slack 7 Day.</span></li><li class="li1">latest_ts = <span style="color: crimson;">time</span>.<span style="color: black;">mktime</span><span style="color: black;">(</span>date_days_ago.<span style="color: black;">timetuple</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li2"><span style="color: #ff7700; font-weight: bold;">print</span><span style="color: black;">(</span><span style="color: crimson;">datetime</span>.<span style="color: black;">fromtimestamp</span><span style="color: black;">(</span>latest_ts<span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li1"> </li><li class="li2"><span style="color: grey; font-style: italic;">#response = sc.api_call('channels.history', channel=channel, count=1000, oldest=oldest_ts, latest=latest_ts)</span></li><li class="li1">response = sc.<span style="color: black;">api_call</span><span style="color: black;">(</span><span style="color: darkslateblue;">'conversations.history'</span>, channel=channel, limit=<span style="color: orangered;">1000</span>, oldest=oldest_ts, latest=latest_ts<span style="color: black;">)</span></li><li class="li2">allmsgs = <span style="color: black;">[</span>item<span style="color: black;">[</span><span style="color: darkslateblue;">'ts'</span><span style="color: black;">]</span> <span style="color: #ff7700; font-weight: bold;">for</span> item <span style="color: #ff7700; font-weight: bold;">in</span> response<span style="color: black;">[</span><span style="color: darkslateblue;">'messages'</span><span style="color: black;">]</span><span style="color: black;">]</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">print</span><span style="color: black;">(</span><span style="color: green;">len</span><span style="color: black;">(</span>allmsgs<span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li2"><span style="color: #ff7700; font-weight: bold;">for</span> msg <span style="color: #ff7700; font-weight: bold;">in</span> allmsgs:</li><li class="li1"> sc.<span style="color: black;">api_call</span><span style="color: black;">(</span><span style="color: darkslateblue;">'chat.delete'</span>, channel=channel, ts=msg<span style="color: black;">)</span></li><li class="li2"> <span style="color: crimson;">time</span>.<span style="color: black;">sleep</span><span style="color: black;">(</span><span style="color: orangered;">1</span><span style="color: black;">)</span></li><li class="li1"> </li><li class="li2"><span style="color: grey; font-style: italic;">########### Chanel Server ###################</span></li><li class="li1">channel = <span style="color: darkslateblue;">'XXXXX'</span> <span style="color: grey; font-style: italic;"># Server Channel.</span></li><li class="li2"> </li><li class="li1">sc = SlackClient<span style="color: black;">(</span>legacy_token<span style="color: black;">)</span></li><li class="li2">response = sc.<span style="color: black;">api_call</span><span style="color: black;">(</span><span style="color: darkslateblue;">'channels.info'</span>, channel=channel<span style="color: black;">)</span></li><li class="li1"> </li><li class="li2"><span style="color: grey; font-style: italic;">#oldest_ts = response['channel']['created']</span></li><li class="li1">date_days_ago = <span style="color: crimson;">datetime</span>.<span style="color: black;">now</span><span style="color: black;">(</span><span style="color: black;">)</span> - timedelta<span style="color: black;">(</span>days=<span style="color: orangered;">90</span><span style="color: black;">)</span></li><li class="li2">oldest_ts = <span style="color: crimson;">time</span>.<span style="color: black;">mktime</span><span style="color: black;">(</span>date_days_ago.<span style="color: black;">timetuple</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">print</span><span style="color: black;">(</span><span style="color: crimson;">datetime</span>.<span style="color: black;">fromtimestamp</span><span style="color: black;">(</span>oldest_ts<span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li2"> </li><li class="li1">date_days_ago = <span style="color: crimson;">datetime</span>.<span style="color: black;">now</span><span style="color: black;">(</span><span style="color: black;">)</span> - timedelta<span style="color: black;">(</span>days=<span style="color: orangered;">60</span><span style="color: black;">)</span></li><li class="li2">latest_ts = <span style="color: crimson;">time</span>.<span style="color: black;">mktime</span><span style="color: black;">(</span>date_days_ago.<span style="color: black;">timetuple</span><span style="color: black;">(</span><span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">print</span><span style="color: black;">(</span><span style="color: crimson;">datetime</span>.<span style="color: black;">fromtimestamp</span><span style="color: black;">(</span>latest_ts<span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li2"><span style="color: grey; font-style: italic;">#response = sc.api_call('channels.history', channel=channel, count=1000, oldest=oldest_ts, latest=latest_ts)</span></li><li class="li1">response = sc.<span style="color: black;">api_call</span><span style="color: black;">(</span><span style="color: darkslateblue;">'conversations.history'</span>, channel=channel, limit=<span style="color: orangered;">1000</span>, oldest=oldest_ts, latest=latest_ts<span style="color: black;">)</span></li><li class="li2">allmsgs = <span style="color: black;">[</span>item<span style="color: black;">[</span><span style="color: darkslateblue;">'ts'</span><span style="color: black;">]</span> <span style="color: #ff7700; font-weight: bold;">for</span> item <span style="color: #ff7700; font-weight: bold;">in</span> response<span style="color: black;">[</span><span style="color: darkslateblue;">'messages'</span><span style="color: black;">]</span><span style="color: black;">]</span></li><li class="li1"><span style="color: #ff7700; font-weight: bold;">print</span><span style="color: black;">(</span><span style="color: green;">len</span><span style="color: black;">(</span>allmsgs<span style="color: black;">)</span><span style="color: black;">)</span></li><li class="li2"><span style="color: #ff7700; font-weight: bold;">for</span> msg <span style="color: #ff7700; font-weight: bold;">in</span> allmsgs:</li><li class="li1"> sc.<span style="color: black;">api_call</span><span style="color: black;">(</span><span style="color: darkslateblue;">'chat.delete'</span>, channel=channel, ts=msg<span style="color: black;">)</span></li><li class="li2"> <span style="color: crimson;">time</span>.<span style="color: black;">sleep</span><span style="color: black;">(</span><span style="color: orangered;">1</span><span style="color: black;">)</span></li></ol>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-60368129764836145302021-09-22T16:58:00.006+07:002021-09-22T16:59:51.399+07:00VMware : VMware ESXi 6.5 Disk ช้าเปลี่ยน HDD เป็น SSD ก็ยังช้าอยู่<p> VMware : VMware ESXi 6.5 Disk ช้าเปลี่ยน HDD เป็น SSD ก็ยังช้าอยู่<br />เครื่อง DL160 Gen8 การ์ด Raid b120i controller <br />ไม่รองรับ Vmware Version 6 ลง Vmware 6 แล้วไม่พบการ์ Raid แต่ลงตัว customize ของ HP ได้<br /><a href="https://porpramarn.blogspot.com/2021/04/server-vmware-vm70.html">https://porpramarn.blogspot.com/2021/04/server-vmware-vm70.html</a><br /><br />ปัญหาที่พบคือการทำงานของ Harddisk ช้า copy ข้อมูลช้า ความเร็วได้ประมาณ 2 - 5 M/s เปลี่ยนเป็น SSD ก็ยังช้าอยู่<br /><br />ทดลอง ติดตั้ง 5.5 ใช้งานได้ความเร็วตามปกติ<br />แต่ติดตั้ง 6.5 U3 ก็ช้าเหมือนเดิม<br /><br />จากการหาข้อมูลและทดลองแก้
พบมีปัญหา ที่ Driver การ์ด Raid b120i controller ถ้าใช้
ต้องถอดตัวที่อยู่ใน Version 6.5 ออกแล้วติดตั้งตัว 5.5 แทน<br />Stop all virtual machines before you continue.<br />Step-by-step solution<br />1.Open an SSH session to your ESXi server installation and log on as root. Same password as for the web interface / console.<br />2.Go into "Maintenance mode". Note that all virtual machines must be stopped first.<br /> </p><blockquote class="uncited"><div>esxcli system maintenanceMode set --enable true</div></blockquote><br />3.Allow outgoing HTTP requests through the ESXi firewall, to retrieve the necessary file.<br /> <blockquote class="uncited"><div>esxcli network firewall ruleset set -e true -r httpClient</div></blockquote><br />4.Go into /tmp folder so we don't leave a mess.<br /> <blockquote class="uncited"><div>cd /tmp</div></blockquote><br />5.Use wget to download the .zip file from HP website. Note that I'm using http:// and not <a class="postlink">https://</a>.<br />You can also use a program such as WinSCP to copy the file directly from your desktop PC to the ESXi server.<br /> <blockquote class="uncited"><div>wget http://downloads.hpe.com/pub/softlib2/software1/pubsw-linux/p1749737361/v98767/hpvsa-5.5.0-88.zip</div></blockquote><br />6. Unzip the file so we can get the .vib driver file we'll need.<br /> <blockquote class="uncited"><div>unzip hpvsa-5.5.0-88.zip</div></blockquote><br />7.Copy the file to a location where the installer can find it easily.<br /> <blockquote class="uncited"><div>cp scsi-hpvsa-5.5.0-88OEM.550.0.0.1331820.x86_64.vib /var/log/vmware/</div></blockquote><br />8.Uninstall the currently installed scsi-hpvsa driver. Be patient. Takes a minute.<br /> <blockquote class="uncited"><div>esxcli software vib remove -n scsi-hpvsa -f</div></blockquote><br />9.Install the old driver we just downloaded. Be patient. Takes a minute.<br /> <blockquote class="uncited"><div>esxcli software vib install -v file:scsi-hpvsa-5.5.0-88OEM.550.0.0.1331820.x86_64.vib --force --no-sig-check --maintenance-mode</div></blockquote><br />10.Now reboot your server.<br /> <blockquote class="uncited"><div>reboot</div></blockquote><br />11.Remember to disable "Maintenance mode". You can do this in vSphere Client or in the web interface.<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVoDC9zwm0fpLUyXvKfQYsCGwyscTtsU9pHvt8mstD2spXLoy_Uoa7QyC8BFlYatc1ecvOCnxzhkDQjTtX0t3c3rb8Ma_24su8HZiLbNKwOEVQL8bKPBCM4Losb3EgWa4Rp_IqTr6Hb94/s1189/Selection_068.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="516" data-original-width="1189" height="139" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVoDC9zwm0fpLUyXvKfQYsCGwyscTtsU9pHvt8mstD2spXLoy_Uoa7QyC8BFlYatc1ecvOCnxzhkDQjTtX0t3c3rb8Ma_24su8HZiLbNKwOEVQL8bKPBCM4Losb3EgWa4Rp_IqTr6Hb94/s320/Selection_068.png" width="320" /></a></div><dt> </dt><dt><a href="https://www.johandraaisma.nl/fix-vmware-esxi-6-slow-disk-performance-on-hp-b120i-controller/">https://www.johandraaisma.nl/fix-vmware-esxi-6-slow-disk-performance-on-hp-b120i-controller/</a><br /></dt></dl></div><br />ผลปรากฏว่า การทำงานของ Disk เร็วขึ้น Copy ข้อมูล และ Restore Database Axapta ได้เร็วขึ้นมาก<br />Speed Disk I/O rate ที่ กราฟ Performance เดิมไม่เกิน 5 M/s เป็น 200 - 500 M/sUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-29295236280311969012021-09-22T16:56:00.000+07:002021-09-22T16:56:00.260+07:00VMware : VMware ESXi เปลี่ยน Compatibility เป็น Version ใหม่<p> VMware : VMware ESXi เปลี่ยน Compatibility เป็น Version ใหม่<br />เช่น Compatibility ESXi 5.0 virtual machine ไปเป็น Compatibility ESXi 6.5 virtual machine ให้ตรงกับที่ Server Vmware run อยู่<br /></p><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW35qFY9GwTRUOOY7uhPKqU6tEnh3wJ_NPpPV3ed7FnlgziJ-9xRfchfHr0yKWwC2qKIDEIUKd0I_55hk9HiF5gJZH88EBraXbaV49b6yjT7Oxmq4mSjhECuo-ciN0OH4Iv-7uTiTlOzo/s428/Selection_065.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="118" data-original-width="428" height="88" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW35qFY9GwTRUOOY7uhPKqU6tEnh3wJ_NPpPV3ed7FnlgziJ-9xRfchfHr0yKWwC2qKIDEIUKd0I_55hk9HiF5gJZH88EBraXbaV49b6yjT7Oxmq4mSjhECuo-ciN0OH4Iv-7uTiTlOzo/s320/Selection_065.png" width="320" /></a></div><dt><br /></dt></dl></div>เป็น<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBgGxcZpSuuQmhkd8uU_sfJrZgjIXvaJTZ5cU1pUQTLEwsumwgVt2zgS5WqJR1owY0y4evaW7howZ28vhBpX9rOfs7V5RGR8lagQ_GcCb8Yu2R9VqJKNi7L1LmdSNzNQJFX46xqBk94h8/s417/Selection_066.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="94" data-original-width="417" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBgGxcZpSuuQmhkd8uU_sfJrZgjIXvaJTZ5cU1pUQTLEwsumwgVt2zgS5WqJR1owY0y4evaW7howZ28vhBpX9rOfs7V5RGR8lagQ_GcCb8Yu2R9VqJKNi7L1LmdSNzNQJFX46xqBk94h8/s320/Selection_066.png" width="320" /></a></div><dt><br /></dt></dl></div>1. ปิดเครื่องที่จะทำ<br />2. คลิกขวาที่เครื่อง VMware เลือก Upgrade VM Compatibility<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOI1JXkSc7guvOwHA8uJBgeOXycbygRMthdjrX3NwSBFA9RQXIgAa1beLw-_cCTBuTjcwo6mJS4Be1th-mDVSHcP1rXP44uwxZ6lCHX08eM2sD9G2VHQe13ij3oh_dhmEfpoCu7FNsUF4/s692/Selection_069.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="692" data-original-width="690" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOI1JXkSc7guvOwHA8uJBgeOXycbygRMthdjrX3NwSBFA9RQXIgAa1beLw-_cCTBuTjcwo6mJS4Be1th-mDVSHcP1rXP44uwxZ6lCHX08eM2sD9G2VHQe13ij3oh_dhmEfpoCu7FNsUF4/s320/Selection_069.png" width="319" /></a></div><dt><br /></dt></dl></div>3. เลือก Version Compatibility ที่ต้องการ แล้วกด Upgrade<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgkQ7d7Ee9U6tKaEHwGjN_i7AhkT10nJMJkbRN5-gcvYdaeqYnYRh00ggCtkSJOW_Omgkls-UgT3bYYhVvNlsMd-x9pukgRvAVCLl6_9RPHZZe_-tfXL-2gO0qMJimm0s6tnTItVGGfAk/s500/Selection_070.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="222" data-original-width="500" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgkQ7d7Ee9U6tKaEHwGjN_i7AhkT10nJMJkbRN5-gcvYdaeqYnYRh00ggCtkSJOW_Omgkls-UgT3bYYhVvNlsMd-x9pukgRvAVCLl6_9RPHZZe_-tfXL-2gO0qMJimm0s6tnTItVGGfAk/s320/Selection_070.png" width="320" /></a></div></dl></div>4. กด Yes<br /><div class="inline-attachment">
<dl class="thumbnail"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9D5qtLWSjhC4Itt3xLlAOA4WPzKgqFRHqRQfRPyWYUf_d_VJGx6UgsVnQPdsOp4Ju0K8XZJeWcSQfQas9zLWSsa7oe3uUGsmqG0pLcNdZQxi2AJAaHjS6eFBaT7kFybx3ofkZx7ciWRw/s499/Selection_064.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="227" data-original-width="499" height="146" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9D5qtLWSjhC4Itt3xLlAOA4WPzKgqFRHqRQfRPyWYUf_d_VJGx6UgsVnQPdsOp4Ju0K8XZJeWcSQfQas9zLWSsa7oe3uUGsmqG0pLcNdZQxi2AJAaHjS6eFBaT7kFybx3ofkZx7ciWRw/s320/Selection_064.png" width="320" /></a></div><dt><br /></dt></dl></div>แล้ว Compatibility ก็จะเป็น Version เราเลือก<br /><br /><a class="postlink" href="https://kb.vmware.com/s/article/1010675">https://kb.vmware.com/s/article/1010675</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-9103974021418767189.post-43580081085186054622021-09-20T10:04:00.003+07:002021-09-20T10:13:02.359+07:00Axapta : Sort Container หลายค่า เช่น ใน Container มี PO, Item, Qty ต้องการเรียงทั้ง 3 ตัว<p> Axapta : Sort Container หลายค่า เช่น ใน Container มี PO, Item, Qty ต้องการเรียงทั้ง 3 ตัว </p><p>อันดับแรกเอาค่ามาต่อกัน ตามที่เราจะเรียง เช่นต้องการเรียง PO, Item </p><p>แล้วค่อยนำค่าที่ไปแบ่ง | ใช้งาน <br /></p><div class="codebox"><div class="codeholder"><div class="text" id="cb39437" style="font-family: monospace;"><ol><li class="li1">static void SortContainer(Args _args)</li><li class="li2">{</li><li class="li1">container
con =
["PO21-12914|901930810009|1|C-KCH","PO21-12914|901930810001|3|C-KCH","PO21-11930|014019310003|3|C-KCH","PO21-11930|014019310003|3|C-KCH","PO21-12914|014019310001|4|C-KCH","PO21-11930|014019310002|3|C-KCH"];</li><li class="li2"> str temp1;</li><li class="li1"> str temp2;</li><li class="li2"> int i;</li><li class="li1"> int j;</li><li class="li2"> container sorCon;</li><li class="li1"> ;</li><li class="li2"> sorCon = con;</li><li class="li1"> // Sort the container</li><li class="li2"> for (i = 1; i <= conlen(sorCon) ; i++)</li><li class="li1"> {</li><li class="li2"> for (j = i + 1; j <= conlen(sorCon); j++)</li><li class="li1"> {</li><li class="li2"> temp1 = conpeek(sorCon, j);</li><li class="li1"> temp2 = conpeek(sorCon, i);</li><li class="li2"> if (temp1 < temp2)</li><li class="li1"> {</li><li class="li2"> sorCon = condel(sorCon, j, 1);</li><li class="li1"> sorCon = conins(sorCon, j, temp2);</li><li class="li2"> sorCon = condel(sorCon, i, 1);</li><li class="li1"> sorCon = conins(sorCon, i, temp1);</li><li class="li2"> }</li><li class="li1"> }</li><li class="li2"> }</li><li class="li1"> conview(sorCon);</li><li class="li2">}</li></ol></div></div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio_eYQa8yfoEBJeJvhjVkthpjEKs_8jKxp9F-RjXXCuG4gCuzjejWolluGwsRH8HP9mB4TL9OnjT4a5IT2Mzt_0EcGLDVtAoiM3wR-Bb5EqPAHsLkhy7vkvNFXtqZco4sGja8SF6X8dFs/s762/2021-09-20_100145.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="330" data-original-width="762" height="139" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio_eYQa8yfoEBJeJvhjVkthpjEKs_8jKxp9F-RjXXCuG4gCuzjejWolluGwsRH8HP9mB4TL9OnjT4a5IT2Mzt_0EcGLDVtAoiM3wR-Bb5EqPAHsLkhy7vkvNFXtqZco4sGja8SF6X8dFs/s320/2021-09-20_100145.png" width="320" /></a></div><p></p><p><a href="https://rahulmsdax.blogspot.com/2018/10/sort-order-by-asc-container-in-ax-x.html">https://rahulmsdax.blogspot.com/2018/10/sort-order-by-asc-container-in-ax-x.html</a><br /></p>Unknownnoreply@blogger.com0