หน้าเว็บ

วันอังคารที่ 28 พฤษภาคม พ.ศ. 2562

Step Restore By zmbkpose FULL + INC

Step Restore By zmbkpose FULL + INC
***สำคัญ ใช้ zmbkpose Version ไหนต้องใช้ Version นั้น Restore เพราะ Code ไม่เหมือนกัน***
**** ต้องเตรียมไฟล์ให้พร้อม จาก Full จนถึงวันที่จะ Restore INC
เช่น
zimbra@zimbra:/TestRestore$ ls -la
total 80
drwxr-xr-x 5 root root 4096 May 27 16:15 .
drwxr-xr-x 25 root root 4096 May 27 16:09 ..
drwxr-xr-x 2 root root 4096 May 27 16:14 full-20190518180020
drwxr-xr-x 2 root root 20480 May 27 16:14 inc-20190520211002
drwxr-xr-x 2 root root 28672 May 27 16:14 inc-20190521211002
-rwxr-xr-x 1 root root 17778 May 27 16:14 sessions.txt


แตกไฟล์ inc ของวันต่าง ๆ ที่ต้องการ Restore ไว้
  1. tar -xvf Zimbra_Inc_20190521.tar.gz


1. ข้อมูลต้องมี ตามไฟล์ เช่น Full 20190518
- inc-20190520211002
- inc-20190521211002
- sessions.txt (ของวันที่ล่าสุด จะมี full เริ่มต้นและ Inc ของวันอื่นได ด้วย)

2. เช็คด้วยคำสั่ง zmbkpose -l
zmbkpose -l
full-20190518180020
inc-20190520211002
inc-20190521211002


3. Run คำสั่ง zmbkpose -restoreAccount เพื่อ Restore Data
  1. zmbkpose -restoreAccount suwit_j@sci.com,boonta_p@sci.com,seksan_k@sci.com

โปรแกรมก็จะเริ่ม Restore จาก Full และ INC ที่มีอยู่ รอจนกว่าจะเสร็จ ช้าขึ้นอยู่กับปริมาณข้อมูล

zmbkpose -restoreAccount suwit_j@sci.com,boonta_p@sci.com,seksan_k@sci.com
Sessions found full-20190518180020
inc-20190520211002
inc-20190521211002
Restoring from full-20190518180020
adding new entry "uid=suwit_j,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/suwit_j@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
suwit_j@sci.com restored from full-20190518180020
Restoring from inc-20190520211002
adding new entry "uid=suwit_j,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/suwit_j@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/suwit_j@sci.com/Trash. Reason:
<pre> Server Error</pre></p>
</body>
</html>
suwit_j@sci.com restored from inc-20190520211002
Restoring from inc-20190521211002
adding new entry "uid=suwit_j,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/suwit_j@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/suwit_j@sci.com/Trash. Reason:
<pre> Server Error</pre></p>
</body>
</html>
suwit_j@sci.com restored from inc-20190521211002
Sessions found full-20190518180020
inc-20190520211002
inc-20190521211002
Restoring from full-20190518180020
adding new entry "uid=boonta_p,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/boonta_p@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
boonta_p@sci.com restored from full-20190518180020
Restoring from inc-20190520211002
adding new entry "uid=boonta_p,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/boonta_p@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/boonta_p@sci.com/Trash. Reason:
<pre> Server Error</pre></p>
</body>
</html>
boonta_p@sci.com restored from inc-20190520211002
Restoring from inc-20190521211002
adding new entry "uid=boonta_p,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/boonta_p@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/boonta_p@sci.com/Trash. Reason:
<pre> Server Error</pre></p>
</body>
</html>
boonta_p@sci.com restored from inc-20190521211002
Sessions found full-20190518180020
inc-20190521211002
Restoring from full-20190518180020
adding new entry "uid=seksan_k,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/seksan_k@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
seksan_k@sci.com restored from full-20190518180020
Restoring from inc-20190521211002
adding new entry "uid=seksan_k,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/seksan_k@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/seksan_k@sci.com/Trash. Reason:
<pre> Server Error</pre></p>
</body>
</html>
seksan_k@sci.com restored from inc-20190521211002

ก็จะมี User และ Email ตามที่เรา Restore


Step Restore By zmbkpose FULL

Step Restore By zmbkpose FULL
***สำคัญ ใช้ zmbkpose Version ไหนต้องใช้ Version นั้น Restore เพราะ Code ไม่เหมือนกัน***
Mount จากไฟล์ ที่ Backup ไว้ได้เลย
  1. sudo mount -t cifs -o username=*******,password=******* //192.168.0.218/backup /DATA


1. ที่เราต้องมีคือ
- full-20190518180020 ข้อมูล Backup Full
- sessions.txt

2. นำ Foder Full และ ไฟล์ session.txt ไปไว้ ที่ Folder ที่ Config ไว้
  1. nano /etc/zmbkpose/zmbkpose.conf

ตรง WORKDIR=
ของจริงเอาไว้ใน WORKDIR=/DATA/zimbra_backup

3. Run คำสั่ง จะได้ ชื่อ Folder Full มา
เข้าเป็น
su zimbra
ก่อน Run
  1. zmbkpose -l


4. เริ่ม Restore ด้วยคำสั่ง
  1. zmbkpose -restoreAccount suwit_j@sci.com,boonta_p@sci.com,seksan_k@sci.com,.........(mail ของ user)

รอจนกว่าจะเสร็จครบทุก User อยู่ที่ข้อมูล ตัวอย่างลอง 3 USER
Sessions found full-20190518180020
Restoring from full-20190518180020
adding new entry "uid=suwit_j,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/suwit_j@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
suwit_j@sci.com restored from full-20190518180020
Sessions found full-20190518180020
Restoring from full-20190518180020
adding new entry "uid=boonta_p,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/boonta_p@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
boonta_p@sci.com restored from full-20190518180020
Sessions found full-20190518180020
Restoring from full-20190518180020
adding new entry "uid=seksan_k,ou=people,dc=sci,dc=com"

<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 Server Error</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /service/home/seksan_k@sci.com/Junk. Reason:
<pre> Server Error</pre></p>
</body>
</html>
seksan_k@sci.com restored from full-20190518180020


5. ทดลองที่ Member จะเห็น User เพิ่มขึ้นมา และ View Mail ดูจะมีเมล์วันที่ Restore มา


ชื่อเมล์เอาได้จากไฟล์ sessions.txt มาแบ่งแล้ว : แล้วใส่ Comma คันเพื่อไป Run ต่อในคำสั่ง zmbkpose -restoreAccount ได้เลย

Zimbra 8.8.11 install on Ubuntu 16.04

Zimbra 8.8.11 install on Ubuntu 16.04
1. ติดตั้ง Ubuntu 16.04 Set network , apt, ntp, update , upgrade ให้เรียบร้อย
2. Add Disk เข้า Ubuntu ตามข้อ 1. mount /opt
3. แก้ fstab
/dev/sdb1 /opt ext4 defaults 0 0

4. Download zimbra software Version ที่ต้องการ แล้วเอาไฟล์ไปไว้ Server ข้อ 1. ใช้ scp หรือ wget ก็ได้
https://www.zimbra.com/downloads/zimbra-collaboration-open-source/archives/
5. แตกไฟล์ ที่ Load มาได้
  1. tar -xvf zcs8.XXXXXX

6. ติดตั้ง Program ที่ต้องใช้
  1. apt-get update -y
  2. apt-get install -y software-properties-common
  3. apt-get install -y language-pack-en-base
  4. export LC_ALL=en_US.UTF-8 && export LANG=en_US.UTF-8
  5. apt-get update -y && apt-get install -y iputils-ping

7. แก้ hosts และ resolv.conf
  1. nano /etc/hosts
192.168.2.114 zimbra.sci.com zimbra

  1. nano /etc/resolv.conf
nameserver 8.8.8.8

8. ติดตั้ง dnsmasq
  1. apt-get install dnsmasq

แก้ config
  1. nano /etc/dnsmasq.conf

แก้ดังนี้
server=8.8.8.8
listen-address=127.0.0.1
domain=sci.com
mx-host=sci.com,zimbra.sci.com,0
address=/zimbra.sci.com/192.168.2.114
service dnsmasq restart

9. Test run
dig mx sci.com
dig zimbra.sci.com

10. สำคัญถ้าไม่ทำไม่ผ่าน
  1. nano /etc/apt/sources.list.d/zimbra.list
(เป็น http ถึงจะผ่าน ลบ s ออก)
สำหรับ ubuntu 16.04 ใช้เป็น xenial
8.8.7
deb [arch=amd64] http://repo.zimbra.com/apt/87 xenial zimbra
deb [arch=amd64] http://repo.zimbra.com/apt/zv1 xenial zimbra
deb-src [arch=amd64] http://repo.zimbra.com/apt/87 xenial zimbra


8.8.11
deb [arch=amd64] http://repo.zimbra.com/apt/87 xenial zimbra
deb [arch=amd64] http://repo.zimbra.com/apt/8811 xenial zimbra
deb-src [arch=amd64] http://repo.zimbra.com/apt/87 xenial zimbra


สำหรับ ubuntu 12.04, 14.04 ใช้เป็น trusty
8.8.11
deb [arch=amd64] http://repo.zimbra.com/apt/87 trusty zimbra
deb [arch=amd64] http://repo.zimbra.com/apt/8811 trusty zimbra
deb-src [arch=amd64] http://repo.zimbra.com/apt/87 trusty zimbra


เพิ่มเติม https://wiki.zimbra.com/wiki/Zimbra_Collaboration_repository

11. add key สำคัญ ต้องใช้ถ้าไม่ Run จะไม่ผ่าน ฟ้อง GPG key ไม่ผ่าน
  1. apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 9BE6ED79
  2.  

Error :
Importing Zimbra GPG key
ERROR: Unable to retrive Zimbra GPG key for package validation
Please fix system to allow normal package installation before proceeding

12. Test ว่าหา zimbra program เจอหรือไม่ ต้องมีค่าออกมาคือเจอ pack ที่ค้นหา
  1. apt-get install aptitude
  2. apt-get update
  3. aptitude search zimbra-nginx

13. เริ่มติดตั้ง เข้าไปที่ Folder ที่แตกไว้ในข้อ 5.
  1. ./install.sh

Y (ยอมรับเงือนไข)
N (*** สำคัญไม่ต้องตอบ Y เพราะ ถ้าตอบ Y sources list จะถูกแก้เป็น HTTPS จะ ลงไม่ได้)
Use Zimbra's package repository [Y] y
Configuring package repository
ERROR: Unable to install packages via apt-get
Please fix system to allow normal package installation before proceeding
(ไม่ผ่าน)

https://forums.zimbra.org/viewtopic.php?t=66069

Y ตาม Default หรือเลือกเอาว่าจะลงอะไรบ้าง รอ จนกว่าจะเสร็จ
No ตอนจะเปลี่ยน DNS และ Domain Name เพราะ Set ไว้ตั้งแต่ลง Ubuntu แล้ว
7 ---> 4 เปลี่ยนรหัส admin ตั้งตามที่ต้องการ แต่ห้ามซ้ำกับรหัส user root ทีใช้
r
5 เปลี่ยน DNS 192.168.0.253
แล้วsave yes modifile รอจนกว่าจะเสร็จ
14. ทดลองเข้า
https://192.168.2.114/7071

ข้อมูลเพิ่มเติม
https://blog.zimbra.com/2018/01/install-zimbra-collaboration-8-8-ubuntu-16-04-lts/https://blog.christosoft.de/2015/06/zimbra-redirect-http-to-https/

เข้าได้ใช้งานได้ Restore Data จาก Full backup
****ใช้ zmbkpose ต้องสร้างชื่อไว้ก่อนแล้วค่อยเอาเข้า****
https://intranet.sci.com/blog.php?u=3&b=389
https://intranet.sci.com/blog.php?u=3&b=390
ติดตั้ง Program อื่น ๆ เพิ่มเติม
https://intranet.sci.com/blog.php?u=281&b=627

Axapta : Update Costing PD ไม่ผ่านมี Error ฟ้อง

Axapta : Update Costing PD ไม่ผ่านมี Error ฟ้อง

Account number transaction type "" does not exist.

- เกิดจากการสร้าง Route --> Cost categeries ใหม่ แต่ไม่ได้ใส่ Account - WIP และ Account - Costing ที่เป็นตัวเลข 9000001 , 9000002
- แก้โดยไป Filter หาค่าว่างที่ช่อง นั้น แล้วใส่ ค่าเหมือนตัวอื่น 9000001 , 9000002
จากนั้นทดลอง Update Cost ใหม่จะผ่าน
เช่น 4533-5 xxxxx PMC16-6 ที่พึ่งเพิ่มเข้าไปใหม่


SonOff Basic : ติดตั้ง Tasmota Config HA ตั้งเวลา ขับสัญญาณกริ่ง

เดิมใช้ SonOff เขียน Code นับเวลาเอา ใช้ Arduino Flash
https://intranet.sci.com/blog.php?u=281&b=1443

พบปัญหา ใช้ไปนาน ๆ นับ วิ ไม่ตรง ทำให้กริ่ง ดังทีหลัง ไม่ตรงเวลา

จึงทำ SonOff ใหม่
- ใช้ Rom Tasmota
- ใช้ Home Assistant ทำ Automation สั่งงานตามเวลาที่ต้องการ

1. Download Tasmota มาแตกไฟล์ เตรียม Flash
https://github.com/arendst/Sonoff-Tasmota/releases

เลือก Source code ได้ไฟล์ แตก

2. Ubuntu ติดตั้ง Atom
https://intranet.sci.com/blog.php?u=281&b=1598

3. นำ Folder ที่ได้จากข้อ 1. Import เข้า Atom แล้วทำการแก้ไข
แก้ 2 ส่วนคือ
3.1. เข้าไปที่ sonoff --> my_user_config.h
#define WIFI_IP_ADDRESS "192.168.0.159" // [IpAddress1] Set to 0.0.0.0 for using DHCP or enter a static IP address
#define WIFI_GATEWAY "192.168.0.2" // [IpAddress2] If not using DHCP set Gateway IP address
#define WIFI_SUBNETMASK "255.255.255.0" // [IpAddress3] If not using DHCP set Network mask
#define WIFI_DNS "192.168.0.253" // [IpAddress4] If not using DHCP set DNS IP address (might be equal to WIFI_GATEWAY)

#define STA_SSID1 "SCI_EMP" // [Ssid1] Wifi SSID
#define STA_PASS1 "143265c911" // [Password1] Wifi password

#define MQTT_HOST "192.168.2.202" // [MqttHost]
#define NTP_SERVER1 "192.168.0.2" // [NtpServer1] Select first NTP server by name or IP address (129.250.35.250)

3.2. แก้ platformio.ini
เอา ; ออก จะเขียนใส่อุปกรณ์ไหนให้เลือกให้ตรง
env_default = sonoff-basic


ใส่ port ที่จะ Upload เดิมเป็น COM5
upload_port = /dev/ttyUSB0


4. ต่อสาย เพื่อ Flash ใช้ไฟ 3V และ TX RX สลับกัน

Flash ไม่ผ่าน ไม่มีสิทธิ์ cannot access tty/usb0 ให้ใช้คำสั่ง
  1. sudo usermod -a -G dialout $USER

แล้ว Log Off หรือ reboot เครื่องก่อนใช้งาน

Error 255 สายไม่ดีหรือต่อสาย TX RX ไม่ถูก ทำให้ Flash ไม่ผ่าน

5. ต่อเข้า USB ก่อน ต่อ USB กดปุ่มขายสายไฟ 3V ด้วย
6. โปรแกรม Atom เลือก Menu Platform IO เลือก Build และ Upload ตามลำดับ
7. ทดลองเข้า IP SonOff ที่กำหนดไว้ หรือ DHCP หาดูใน Firewall ถ้าเข้าได้ลองสั่งเปิดปิดได้หรือไม่ไฟจะติดจะดับ
8. ตั้งชื่อ Topic ของ sonoff ไม่ให้ซ้ำกับตัวอื่น
เข้าไปที่ Configure MQTT และใส่ User และ Password Mqtt ให้สอดคล้องกับ Server
ไฟล์ Backup Config ใช้งานจริง (เอาไป Restore )

9. ที่เครื่อง HA
- ตั้ง Automation
- และจัด Group

9.1. สร้าง Switch สำหรับลองปิดเปิด Sonoff ที่สร้างขั้น
  1. nano configuration.yaml
switch:
- platform: mqtt
name: "switch_sonoff_bell"
state_topic: "stat/sonoff2/POWER"
command_topic: "cmnd/sonoff2/POWER"

9.2. จัด Group ใช้เครื่อง HA กับสวน ฝพอ. แยกกันเป็นของใครของมันจะได้ไม่กดผิด
  1. nano groups.yaml
GardenManual:
name: GardenManual
#icon: mdi:account-multiple
#view: yes
entities:
- switch.Moisture_Mode
- switch.switch_sonOff_shrine
- switch.Timer_Mode
GardenScript:
name: GardenScript
#icon: mdi:account-multiple
#view: yes
entities:
- script.CloseAll
- script.Zone1
- script.Zone2
- script.Zone3
- script.Zone4
- script.sonoffshrine
BellManual:
name: BellManual
#icon: mdi:account-multiple
#view: yes
entities:
- switch.switch_sonoff_bell


9.3. สร้าง Automation ให้ทำงานเมื่อถึงเวลาที่กำหนด
  1. nano automations.yaml

- id: '1555639966304'
alias: Bell ON At 0:00
trigger:
- at: 0:00
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642007968'
alias: Bell ON At 0:30
trigger:
- at: 0:30
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642250951'
alias: Bell ON At 5:30
trigger:
- at: '5:30'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642348629'
alias: Bell ON At 6:00
trigger:
- at: '6:00'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642435310'
alias: Bell ON At 7:50
trigger:
- at: '7:50'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642541007'
alias: Bell ON At 8:00
trigger:
- at: '8:00'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642694769'
alias: Bell ON At 10:20
trigger:
- at: '10:20'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642822938'
alias: Bell ON At 12:00
trigger:
- at: '12:00'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555642916659'
alias: Bell ON At 12:50
trigger:
- at: '12:50'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555643327026'
alias: Bell ON At 13:00
trigger:
- at: '13:00'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555643430144'
alias: Bell ON At 17:40
trigger:
- at: '17:40'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555643548082'
alias: Bell ON At 18:00
trigger:
- at: '18:00'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true
- id: '1555643622243'
alias: Bell ON At 21:00
trigger:
- at: '21:00'
platform: time
condition: []
action:
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_on
- delay: 00:00:09
- data:
entity_id: switch.switch_sonoff_bell
service: switch.turn_off
hide_entity: true

ข้อมูลเพิ่มเติม
http://shuwernpi.blogspot.com/2018/02/sonoff-tasmota-firmware-sonoff-wifi.html

Axapta :: Dynamics Axapta All Table

Axapta :: Dynamics Axapta  All Table
Address (Alt. address)
AddressFormatHeading (Address format)
AddressFormatLines (Address format lines)
AssetBook (Value model by fixed asset)
AssetBookTable (Value models)
AssetBookTableDerived (Derived value models)
AssetBookTableDerivedJournal (Derived value models journal)
AssetBudget (Fixed asset budget transactions)
AssetConsumptionFactor (Consumption factor)
AssetConsumptionFactorLines (Consumption lines)
AssetConsumptionUnit (Consumption unit)
AssetDepreciationProfile (Depreciation table)
AssetDepreciationProfileSpec (Fixed asset depreciation profile schedules)
AssetDisposalParameters (Disposal parameters)
AssetGroup (Fixed asset groups)
AssetGroupBookSetup (Setup by fixed asset group/value model)
AssetInventTrans (Inventory transactions for fixed assets)
AssetLedger (Fixed asset posting profile)
AssetLedgerAccounts (Fixed asset ledger accounts)
AssetLending (Fixed assets on loan)
AssetLocation (Fixed asset location)
AssetParameters (Fixed asset parameters)
AssetReserveType (Provision types for fixed assets)
AssetRevaluationGroup (Revaluation groups for fixed assets)
AssetRevaluationGroupSpec (Revaluation factor for fixed assets)
AssetSorting (Fixed asset properties)
AssetStatementInterval
AssetStatementRow (Fixed asset statement rows)
AssetTable (Fixed assets)
AssetTrans (Fixed asset transactions)
BankAccountStatement (Bank account statement)
BankAccountTable (Bank accounts)
BankAccountTrans (Bank transactions)
BankCentralBankPurpose (Payment purpose codes)
BankChequeLayout (Check layout)
BankChequePaymTrans (Invoices paid by check)
BankChequeTable (Check table)
BankDeposit (Bank deposit)
BankGroup (Bank groups)
BankParameters (Bank parameters)
BankPromissoryNoteLayout (Promissory note layout)
BankPromissoryNoteTable (Promissory note table)
BankRemittanceFilesCust (Remittance files for customers)
BankRemittanceFilesVend (Remittance files for vendors)
BankTransactionTypeGroupHeader (Bank transaction groups)
BankTransType (Bank transaction type)
BankTransTypeGroupDetails (Bank transaction types)
BarcodeSetup (Bar code setup)
BASCalcCompanyCollection (Company collection for calculated field)
BASCalcRealFieldValue (Calculated value)
BASCalcTable (Calculated fields)
BASCalcUpdateLog (Update log)
BASCompanyCollectionEntry (Company in collection)
BASCompanyCollectionTable (Company collection)
BASEnumTable (Enumerated labels)
BASEnumValueLine (Enumerated value)
BASFieldLookup (Field lookup)
BASGroupingSpecLine (Intervals for grouping proposals)
BASGroupingSpecName (Group labels)
BASGroupingSpecTable (Individual groups)
BASGroupingTable (Grouping of field values)
BASGroupingValue (Table values)
BASParameters (Parameters)
BASTableCompanyHandler (Managing virtual companies)
BASTableDisplayMethod (Display methods)
BASTableLookup (Table lookup)
BASViewCalc (Calculated fields on view)
BASViewCompanyTable (Companies in the view)
BASViewDatasourceTable (View tables)
BASViewField (View fields)
BASViewFieldGrouping (Grouping table records)
BASViewTable (Business views)
Batch (Batch transactions)
BatchGroup (Batch groups)
BatchJournalLine (Batch journal lines)
BatchJournalName (Batch journal names)
BatchJournalType (Batch journal types)
BatchJournalTypeJob (Batch-journal jobs)
BMBatchRun (Benchmark batch run)
BMBuildTable
BMComputersAvailable (Computers available)
BMComputerTable (Computer setup)
BMControlTable (Benchmark control)
BMDBTrans (Database performance)
BMLabSeries
BMLabTable (Laboratory)
BMLaunchCMD (Send DOS commands)
BMMachineModelTable (Computer model)
BMModuleParm (Module parameters)
BMModuleTable (Benchmark module)
BMNetworkConnection (Network connection)
BMparm (Parameters used to create transactions)
BMPerfDetail (Performance test details)
BMPerfDetailPath (Performance test detail path reference)
BMPerfParm (Performance test parameters)
BMPerfReference (Performance reference)
BMPerfResult (Performance results)
BMPerfTable (Performance test)
BMProcessorTable (Processors)
BMRunConfig (Configuration)
BMRunLog (Benchmark run log)
BMrunScriptParmLine (User script parameter)
BMRunStat (Run statistics)
BMRunStepStat (Benchmark statistics)
BMRunTable (Benchmark run table)
BMScriptLine (Benchmark script lines)
BMScriptParmLine (Script parameters)
BMScriptTable (Benchmark scripts)
BMSetup
BMTableSetup (Benchmark table setup)
BMUserScriptTable (User script)
BMUserScriptTiming (Benchmark time measurement)
BOM (BOM lines)
BOMCalcTable (BOM calculation)
BOMCalcTrans (BOM calculation transactions)
BOMConfigRoute (Configuration route)
BOMConfigRule (Configuration rules)
BOMCostGroup (Cost groups)
BOMCostProfit (Profit-setting)
BOMParameters (BOM parameters)
BOMParmReportFinish (Report as finished)
BOMTable (Bills of material)
BOMVersion (BOM versions)
BudgetModel (Ledger budget models)
BusinessStatisticsData (Business statistics lines)
BusinessStatisticsDef (Business statistics)
CACAdminSalesTable (Allocation of sales and administration cost centers)
CACAllocCenter (Allocation centers)
CACAllocCenter2Purpose (Allocation center to purpose)
CACAllocPurpose2Purpose (Allocation purpose to purpose)
CACBABCompSum (Compressed sum)
CACBABGroup (EDS groups)
CACBABMainSum (Main sums)
CACCenter (Cost centers)
CACCenterParameters (Cost accounting parameters)
CACCostClassification (Cost classification)
CACDisAccount (Distribution account to cost centers)
CACDisAllocVersion (Allocation and distribution versions)
CACDistTmpEDSSum (Temporary distribution)
CACDivision (Divisions)
CACHierCenter (Hierarchy levels)
CACHierCenterModel (Hierarchy model)
CACHierPurpose (Purpose hierarchies)
CACHierPurposeModel (Hierarchy model)
CACLedger (Chart of accounts)
CACLedgerJournalTrans (Journal lines)
CACLedgerPeriod (Accounting periods)
CACLedgerTrans (Ledger transactions)
CACPerfList (Work units)
CACPerfListCenter (Setup work units)
CACPerfListPurpose (Define cost rates)
CACPurpose (Purpose)
CACPurposeAllocRefListCenter (Setup allocation center to purpose)
CACPurposeAllocRefListPurpose (Setup allocation purpose to purpose)
CACPurposeDivision (Divisions)
CACPurposeLine (Purpose line)
CACPurposeLineSum (Purpose line sums)
CACPurposeParameters (Cost purpose parameters)
CACPurposeReportdefinition (Purpose report definition)
CACPurposeTypeOfReport (Purpose report definition)
CACReferenceList (Reference list)
CACReferenceList_OnlyForCenter (Reference list)
CACRefListDefAccount (Setup distributions)
CACRefListDefAllCenter (Setup allocations)
CACRefListDefCenter (Reference settings)
CACRefListDefPurpose (Reference settings)
CACTempAllocation (Temporary allocation)
CACTempCalculates
CACTempClassification (Temporary classification)
CACTempDivisTrans
CACTempEdsBase
CACTempEdsReport
CACTempHierarchy
CACTempHPurpose
CACTempPurposeAllocationPurposeLine
CACTempPurposeCalculation
CACTempPurposeCenterTrans
CACTempPurposeTrans
CACTempPurposeWholeEnterpriseCalculation
CACTempTrans
CACTmpEDSGRoups
CACTmpLedgerBase
CashDisc (Cash discount)
CCDataLinkLine (Data links - Queries)
CCDataLinkTable (Data Links)
CCDataLinkTmpField (Data Links - temporary fields)
CCDataLinkTmpFilter (Data Links - temporary filters)
CCDataLinkTmpJoin (Data Links - temporary joins)
CCDataLinkTmpTable (Data Links - temporary tables)
CCTmpStatistics (Temporary generic statistics table)
CommissionCalc (Commission rates)
CommissionCustomerGroup (Commission customer group)
CommissionItemGroup (Commission item group)
CommissionSalesGroup (Commission sales group)
CommissionSalesRep (Commission sales rep.)
CommissionTrans (Commission transactions)
CompanyCurrencyConversion (Company currency conversion)
CompanyImage
CompanyInfo (Company information)
ConfigChoice (Configuration selection)
ConfigGroup (Configuration groups)
ConfigTable (Configuration table)
ContactPerson (Contact person)
Country (Country)
County (Counties)
Currency (Currency table)
CustBankAccount (Customer bank accounts)
CustBillOfExchangeInvoice (Bill of exchange invoices)
CustBillOfExchangeJour (Bill of exchange journal)
CustBillOfExchangeTrans (Bill of exchange lines)
CustCollectionLetterJour (Collection letter journal)
CustCollectionLetterLine (Collection letter lines)
CustCollectionLetterTable (Collection letter setup)
CustCollectionLetterTrans (Collection letter transactions)
CustConfirmJour (Confirmation journal)
CustConfirmSalesLink
CustConfirmTrans (Confirmation lines)
CustFormletterDocument (Customer form setup)
CustFormletterParameters (Customer form parameters)
CustGroup (Customer groups)
CustInterest (Terms of interest)
CustInterestFee (Interest fees)
CustInterestJour (Interest journal)
CustInterestTrans (Interest lines)
CustInvoiceBackorderLine (Backorder invoice lines)
CustInvoiceJour (Customer invoice journal)
CustInvoiceLine (Customer free text invoice lines)
CustInvoiceSalesLink
CustInvoiceTable (Customer free text invoice)
CustInvoiceTrans (Customer invoice lines)
CustLedger (Customer posting profiles)
CustLedgerAccounts (Customer ledger accounts)
CustPackingSlipBackorderLine (Backorder packing slip lines)
CustPackingSlipJour (Customer packing slips)
CustPackingSlipSalesLink
CustPackingSlipTrans (Customer - Packing slip lines)
CustParameters (Customer parameters)
CustPaymFee (Customer payment fee)
CustPaymFormat (File formats for methods of payment (customers))
CustPaymManFee (Payment fee)
CustPaymManFeeHist (History on payment fee)
CustPaymManFeeLines (Fee lines for payment)
CustPaymManFile (File extract)
CustPaymManParmTrans (Payment parameter transactions)
CustPaymManPostReq (Validation)
CustPaymManStepChange (Payment step process changed)
CustPaymManStepPosting (Payment step posting)
CustPaymManStepTable (Payment step process)
CustPaymManTrans (Payment transactions)
CustPaymManTransHist (History on payment)
CustPaymMethodVal (Payment control in customer journals)
CustPaymModeFee (Customer payment fee setup)
CustPaymModeFeeInterval
CustPaymModeSpec (Customer specifications)
CustPaymModeTable (Methods of payment - Customers)
CustPaymSched (Customer - Payment schedules)
CustPaymSchedLine (Customer payment schedule lines)
CustPickingListJour (Picking list journal)
CustPickingListSalesLink
CustPickingListTrans (Picking list journal lines)
CustQuotationJour (Quotation journal)
CustQuotationSalesLink
CustQuotationTrans (Quotation lines)
CustSettlement (Customer settlement)
CustStatisticsGroup (Statistics group)
CustTable (Customers)
CustTrans (Customer transactions)
CustTransCashDisc (Customer cash discount)
CustTransOpen (Open customer transactions)
CustVendExternalItem (External item descriptions)
CustVendItemGroup (External item description group)
CustVendPaymJournalFee (Payment journal fee)
CustVendPaymReconciliationFee
DEL_BMOSTable (Operating system)
DEL_BOMScrap (Scrap types)
DEL_CCSelectionLine (Selection lines)
DEL_CCSelectionTable (Selection)
DEL_CCSelectionTemplate (Selection templates)
DEL_HRMBranchCode (Trade codes)
DEL_HRMCompanyContactBranchCode (Trade codes)
DEL_HRMCompanyContactGroup (Company contact groups)
DEL_HRMCompanyContactProductType (Company contact - product types)
DEL_HRMCompanyContactTable (Company contact table)
DEL_HRMEmployeeCountType (Number of employees)
DEL_HRMJob (Jobs)
DEL_HRMProductGroup (Product groups)
DEL_HRMProductType (Product type)
DEL_HRMRevenueCode (Revenue codes)
DEL_HRMVirtualNetworkLanguageSkill (Language proficiency)
DEL_HRMVirtualNetworkRelationCode (Personal relation codes)
DEL_HRMVirtualNetworkRelationLine (Virtual network relation table)
DEL_HRMVirtualNetworkRelationTable (Personal relations)
DEL_HRMVirtualNetworkRelationType (Personal relation types)
DEL_HRMVirtualNetworkTablePicture (Virtual network table images)
DEL_InventJournalVoucher (*** OUTDATED ***)
DEL_KMConnectionJournal (Archiving in reference type)
DEL_KMGameplanTemplateJournalLine (Plan templates - archiving)
DEL_KMJournal (Journals)
DEL_KMJournalAttachmentFileType (Archiving - documents)
DEL_KMJournalAttachmentTableType (Archiving - tables)
DEL_KMJournalAttachmentType (Archiving types)
DEL_KMJournalParameters (Archiving parameters)
DEL_KMParameters (Knowledge management parameters)
del_OLAPQuery
del_OLAPSetupServer (OLAP servers)
DEL_ProdJournalVoucher (Production journal voucher)
DEL_ProjCategoryEmpl (Categories per employee)
DEL_ProjEmplSetup (Project list by employee)
DEL_ProjInventTransPosting (Inventory transaction posting in project)
DEL_ProjItemReq (Project item requirements)
DEL_ProjJournalTransWEB (*** OUTDATED ***)
DEL_ProjJournalVoucher (Project voucher)
DEL_ProjlValidateGroupEmpl
DEL_ProjRegistrationProposal (Registration proposals)
DEL_PurchWithholdingTable (*** OUTDATED ***)
DEL_PurchWithholdingTrans (*** OUTDATED ***)
DEL_smmTmpNumberSeqCreate (Number sequence)
DEL_SysApplObjectArchive (Application Object archive)
DEL_SysBestPracticesSetup
DEL_SysCodeProfilerParentMethodSum
DEL_SysEmailMessageTable (*** OUTDATED ***)
DEL_SysParameters (*** OUTDATED ***)
DEL_SysSecurityFormSetup (*** OUTDATED ***)
DEL_SysUtilManagement (Application management)
DEL_TmpReqExplosion (M. sched. explosion)
DEL_WMSCountingJournal (Inventory - Journal - Counting)
DestinationCode (Destination code)
Dimensions (Dimensions)
DlvMode (Mode of delivery)
DlvTerm (Terms of delivery)
DocuField (Document fields)
DocuOpenFile (Temporary files)
DocuParameters (Document management parameters)
DocuRef (Document references)
DocuTable (Document tables)
DocuTableEnabled (Active document tables)
DocuType (Document types)
DocuValue (Document value)
ECPCustSignUp (Sign up requests)
ECPParameters (Customer Self-Service parameters)
ECPPresentation (Presentations)
EmplTable (Employee)
EmplTask (Employee responsibilities.)
EmplWorkTask (Work task table)
EPDocuParameters (Enterprise Portal document parameters)
EPMyInfo (Favorites)
EPParameters (Enterprise Portal parameters)
EPPersonalize (Personalize)
EPPriceCalc (Price query)
EPTransactionSumTrans (Transaction summary)
EUSalesList (EU sales list)
ExchRates (Exchange rates)
ExtCodeTable (External code)
ExtCodeValueTable (External code value)
ForecastInvent (Inventory forecast)
ForecastItemAllocation (Item allocation keys)
ForecastItemAllocationLine (Item allocation transactions)
ForecastModel (Forecast models)
ForecastPurch (Purchase forecast)
ForecastSales (Sales forecast)
FormLetterRemarks (Form note)
FormLetterSortingParameters (Parameters for form sorting)
GanttColorTable (Gantt color)
GanttLine (Gantt transactions)
GanttTable (Gantt table)
GatewayChannel (Channels)
GatewayDocSetup (Document setup)
GatewayOrganization (Organizations)
GatewayOrgRef (Organization references)
GatewayParameters (Gateway parameters)
GatewayQueue (Gateway queue)
GatewaySchema (XML schema map)
GatewayTransport (Transport methods)
HRMAbsenceAdministrationReportTmp (Temporary absence administration table)
HRMAbsenceAdministrationTmp (Temporary absence administration table)
HRMAbsenceCode (Absence codes)
HRMAbsenceCodeGroup (Absence groups)
HRMAbsenceSetup (Absence setup)
HRMAbsenceStatusColumns (Absence status list - columns)
HRMAbsenceStatusHeader (Absence status list)
HRMAbsenceStatusListTmp
HRMAbsenceTable (Main absence table)
HRMAbsenceTrans (Absence transactions)
HRMApplicantInterview (Interview with applicants)
HRMApplicantRouting (Examination of applications)
HRMApplicantTable (Applicants)
HRMApplication (Applications)
HRMApplicationEmailTemplate (Application e-mail templates)
HRMApplicationWordBookmark (Application bookmarks)
HRMBenefitType (Benefit types)
HRMBonus (Bonus)
HRMCerficateType (Delete budget)
HRMCourseAgenda (Agenda)
HRMCourseAgendaLine (Sessions on agenda)
HRMCourseAttendee (Course participants)
HRMCourseAttendeeLine (Registration)
HRMCourseHotel (Hotel)
HRMCourseInstructor (Course instructors)
HRMCourseLocation (Course locations)
HRMCourseLocationPicture (Pictures of course locations)
HRMCourseNotes (Course description)
HRMCourseRoom (Classrooms)
HRMCourseRoomGroup (Classroom groups)
HRMCourseSession (Session)
HRMCourseSessionTrack (Track)
HRMCourseTable (Courses)
HRMCourseTableHotel (Hotel for course)
HRMCourseTableInstructor (Course instructors)
HRMCourseType (Course types)
HRMCourseTypeCertificateProfile (Course type - certificates)
HRMCourseTypeEducationProfile (Course type - education)
HRMCourseTypeGroup (Course groups)
HRMCourseTypeSkillProfile (Course type - skills)
HRMDevelopmentPlanType (Development plan types)
HRMEducationCenter (Institution)
HRMEducationDegree (Level of education)
HRMEducationGroup (Grouping of educational studies)
HRMEducationGroupType (Education-type/group-relation table)
HRMEducationType (Education types)
HRMEmplBankAccount (Employee bank accounts)
HRMEmplCategory (Personnel category)
HRMEmplHiringTerms (Employee - Terms of employment)
HRMEmplLeave (Employee leave)
HRMEmployeeBenefit (Benefits)
HRMEmployeeContact (Emergency contacts)
HRMEmplTaxInfo (Tax information)
HRMHiringTerms (Terms of employment)
HRMIncomeTaxCategory (Income tax category)
HRMIncomeTaxCode (Income tax code)
HRMInsurance (Insurance)
HRMInsuranceType (Insurance types)
HRMInterviewTable (Appraisal interviews)
HRMInterviewType (Interview types)
HRMLanguageCode (Language codes)
HRMLeaveType (Leave types)
HRMLoanTable (Loan items)
HRMLoanType (Loan types)
HRMMedia (Media)
HRMMediaType (Media types)
HRMMunicipal (County)
HRMOrganization (Organization)
HRMParameters (Personnel parameters)
HRMPayrollBasis (Base payroll)
HRMPayrollCategory (Payroll category)
HRMPayrollDeduction (Deduction)
HRMPayrollDeductionType (Salary deduction types)
HRMPayrollFrame (Wage groups)
HRMPayrollLine (Wage lines)
HRMPayrollPension (Retirement)
HRMPayrollPremium (Payroll allowance)
HRMPayrollScaleLevel (Payroll scale level)
HRMPosition (Positions)
HRMPositionCertificateProfile (Position - certificates)
HRMPositionEducationProfile (Position - education)
HRMPositionGroup (Position groups)
HRMPositionGroupCertificateProfile (Position group - certificates)
HRMPositionGroupEducationProfile (Position group - education)
HRMPositionGroupResponsibility (Areas of responsibility)
HRMPositionGroupSkillProfile (Position group - skills)
HRMPositionGroupTask (Work task table)
HRMPositionResponsibility (Position - areas of responsibility)
HRMPositionSkillProfile (Position - skills)
HRMPositionStatus (Position status)
HRMPositionTask (Position - job tasks)
HRMReasonCode (Reason codes)
HRMRecruitingLastNews (Recruitment - developments)
HRMRecruitingLine (Recruitment project lines)
HRMRecruitingMedia (Recruitment media)
HRMRecruitingTable (Recruitment table)
HRMReminderTable (Employee records)
HRMReminderType (Employee record types)
HRMResponsibility (Areas of responsibility)
HRMSkill (Skills)
HRMSkillMappingCertificate (Skill-mapping - certificates)
HRMSkillMappingEducation (Skill-mapping - education)
HRMSkillMappingLine (Skill-mapping - lines)
HRMSkillMappingRange (Skill-mapping - criteria)
HRMSkillMappingSkill (Skill-mapping - skills)
HRMSkillMappingTable (Skill-mapping - main)
HRMSkillType (Skill types)
HRMStaffingFrame (Head counts)
HRMStockOption (Create and update option plans)
HRMTask (Work tasks)
HRMTmpEmplReports (Temporary table for employee reports)
HRMTmpOrganizationMerge (Move employees)
HRMTmpSkillGapReports (Skills gap)
HRMUnions (Vocational organizations)
HRMVirtualNetworkCertificate (Certificates)
HRMVirtualNetworkDevelopmentPlanLine (Development plan lines)
HRMVirtualNetworkDevelopmentPlanTable (Development plans)
HRMVirtualNetworkEducation (Education)
HRMVirtualNetworkGroup (Network groups)
HRMVirtualNetworkGroupRelation (Virtual network group relation)
HRMVirtualNetworkHistory (Employment history)
HRMVirtualNetworkLoan (Loan)
HRMVirtualNetworkParameters (Network parameters)
HRMVirtualNetworkPrivateInfo (Position of trust)
HRMVirtualNetworkProject (Project experience)
HRMVirtualNetworkQualification (Professional experience)
HRMVirtualNetworkSkill (Skills)
HRMVirtualNetworkTable (Virtual network table)
Intrastat (Intrastat)
IntrastatCompressParameters
IntrastatItemCode (Commodity code)
IntrastatParameters (Foreign trade parameters)
IntrastatPort (Port)
IntrastatStatProc (Statistics procedure)
IntrastatTransactionCode (Transaction codes)
IntrastatTransportMode (Transport method)
InventBatch (Batches)
InventBuyerGroup (Buyer groups)
InventClosing (Inventory closing)
InventColor (Colors)
InventCostList (Calculation list)
InventCostListTrans (Lot level adjustments)
InventCountGroup (Counting groups)
InventCountJour (Counting journal)
InventDim (Inventory dimensions)
InventDimCombination (Item dimensions)
InventDimGroup (Inventory dimension groups)
InventDimParm (Dimension parameters)
InventDimSetup (Inventory dimension setup)
InventDimSetupGrid (View dimensions)
InventItemBarcode (Item - bar code)
InventItemGroup (Item groups)
InventItemLocation (Warehouse items)
InventJournalName (Inventory journal names)
InventJournalTable (Inventory journal table)
InventJournalTrans (Inventory journal lines)
InventJournalTrans_Tag (Tag counting)
InventLocation (Warehouses)
InventModelGroup (Inventory model groups)
InventNumGroup (Number groups)
InventPackagingGroup (Packing groups)
InventPackagingMaterialCode (Packing material code)
InventPackagingMaterialFee (Packing material fee)
InventPackagingMaterialTrans (Packing material transactions)
InventPackagingMaterialTransPurch (Packing material transactions - purchase)
InventPackagingUnit (Packing units)
InventPackagingUnitMaterial (Packing material)
InventParameters (Inventory parameters)
InventParmQuarantineOrder (Update parameters for quarantine orders)
InventPosting (Inventory, Ledger posting)
InventPostingParameters (Inventory transaction combinations)
InventPostPhysicalTable (Physical posting)
InventPostPhysicalTrans (Physical posting transactions)
InventProductGroup (Product groups)
InventProductGroupBOM (Product group structure)
InventProductGroupItem (Product group items)
InventQuarantineOrder (Quarantine order)
InventSerial (Serial numbers)
InventSettlement (Inventory settlement)
InventSize (Sizes)
InventSum (On-hand inventory)
InventSumLinkTTS (Transactions)
InventSumLogTTS (Transaction list)
InventSumSetupTTS (Setup)
InventSumTTSAdmin
InventTable (Item table)
InventTableCompany (Company item)
InventTableModule (Inventory module parameters)
InventTrans (Inventory transactions)
InventTransPosting (Inventory transaction posting)
InventTxt (Inventory texts)
JmgAbsenceCalendar (Absence registration)
JmgAssistance (Assistant)
JmgBulletinBoard (Notice board)
JmgBundleSlize (Bundle allocation)
JmgEmployee (Employee)
JmgEventCtrl (Switch code)
JmgFlexCorrection (Flex correction)
JmgGroupApprove (Groups)
JmgGroupCalc (Groups)
JmgGroupSigningLine (Collective registration)
JmgGroupSigningTable (Collective registration)
JmgIpcActivity (Activities)
JmgIpcCategory (Indirect activities)
JmgIpcLedgerJournal (IPC recording)
JmgIpcLedgerTrans (Ledger-posted IPC)
JmgOvertimeSlize (Overtime allocation)
JmgParameters (Shop Floor Control - Parameters)
JmgPayAddTable (Premium types)
JmgPayAddTrans (Premium lines)
JmgPayAdjustCostType (Pay adjustment)
JmgPayAdjustSetup (Pay adjustment pay types)
JmgPayAgreementLine (Pay agreements)
JmgPayAgreementOverride (Pay agreement)
JmgPayAgreementOverrideLine (Pay agreements)
JmgPayAgreementTable (Pay agreement)
JmgPayCountSum (Initialize base total in header and print in sum.)
JmgPayCountTable (Count unit)
JmgPayEmployee (Rates)
JmgPayEvents (Pay items)
JmgPayrollPeriodTable (Pay periods)
JmgPayrollPeriodTrans (Pay period records)
JmgPayStatConfig (Payroll statistics setup)
JmgPayStatGroup (Payroll statistics)
JmgPayStatTrans (Payroll statistics)
JmgPayTable (Pay types)
JmgPieceRateEmpl (View members of the piecework groups)
JmgPieceRateGroup (Piecework groups)
JmgPieceRateLine (Piecework productions)
JmgPieceRateTable (Piecework)
JmgProfileCalendar (Profile calendar)
JmgProfileDay (Profile start table)
JmgProfileGroup (Profile group)
JmgProfileOverride (Profile override)
JmgProfileOverrideSpec (Profile time override)
JmgProfileRelation (Profile relation)
JmgProfileSpec (Profile timetable)
JmgProfileTable (Profile table)
JmgStampJournalTable (Day's total)
JmgStampJournalTrans (Journal registrations)
JmgStampTrans (Journal registrations)
JmgTermReg (Raw registrations)
JmgTermRegTmp (Raw registrations)
JmgTermTable (Terminals)
JmgTermTask (Terminal tasks)
JmgTermTaskTerm (Terminals)
JmgTermTexts (Send statistics)
JmgTimeCalcParmeters (Calculation parameters)
JmgTmpAbsenceCalendarOutput (Temporary absence administration table)
JmgTmpJobContainer (Selected jobs)
JmgTmpPayExport (Temporary payment file)
JmgTmpTreeNode (Tree structure)
JournalError
KMAction (Actions)
KMActionAuto (Automatic actions)
KMActionGroup (Action groups)
KMActionPlanLine (Action plan - distribution)
KMActionPlanSplit (Actions - employee distribution)
KMActionPlanTable (Action plans)
KMActionResponseType (Actions - response types)
KMActionType (Action types)
KMActionTypeResponseType (Action types -- response types)
KMActionTypeTemplate (Action type templates)
KMActionTypeTemplateLine (Action type template lines)
KMAnswer (Answer)
KMAnswerCollection (Answer groups)
KMBusinessProcessManagementParameters (Business process management parameters)
KMCollection (Questionnaires)
KMCollectionQuestion (Questionnaire questions)
KMCollectionQuestionAnswer (Questionnaire answer counting group)
KMCollectionRights (Questionnaires - user rights)
KMCollectionTemplate (Questionnaire templates)
KMCollectionType (Questionnaire types)
KMConnectionDefaultRangeLine (Default line margins)
KMConnectionDefaultRangeTable (Default criteria)
KMConnectionType (Reference types)
KMConnectionTypeDataLinkLine (Automatic data links - lines)
KMConnectionTypeDataLinkTable (Automatic data links)
KMGameplan (Strategic plans)
KMGameplanSwot (SWOT)
KMGameplanTemplate (Plans for plan template)
KMGameplanTemplateActionLine (Plan templates - actions)
KMGameplanTemplateTable (Plans for plan template)
KMGameplanText (Strategic planning - developments)
KMGameplanType (Strategic plan types)
KMKnowledgeAnalogMeterSetup (Analogmeter setup - table)
KMKnowledgeAnalogMeterSetupLine (Analogmeter setup - lines)
KMKnowledgeBudget (Knowledge budget)
KMKnowledgeCockpitGroup (Cockpit groups)
KMKnowledgeCockpitGroupPersons (Persons/cockpit groups)
KMKnowledgeCockpitLine (Lines in cockpits)
KMKnowledgeCockpitTable (Cockpits)
KMKnowledgeCollectorParameters (Questionnaire parameters)
KMKnowledgeCollectorPlanningTable (Questionnaire planning - table)
KMKnowledgeCollectorPlanningType (Questionnaire planning - type)
KMKnowledgeFocusGroup (Focus groups)
KMKnowledgeJournalImportType (Knowledge journal import types)
KMKnowledgeJournalName (Knowledge journal names)
KMKnowledgeJournalTable (Knowledge journal tables)
KMKnowledgeJournalTrans (Knowledge journal lines)
KMKnowledgePeriodSetup (Knowledge periods)
KMKnowledgeReportAnalogMeter (Knowledge reporting - analogmeter setup)
KMKnowledgeReportLine (Knowledge reporting - lines)
KMKnowledgeReportTable (Knowledge reporting - table)
KMKnowledgeTable (Chart of knowledge accounts)
KMKnowledgeTableIndicator (Knowledge-account indicators)
KMKnowledgeTableIndicatorDates (Knowledge-account indicator dates)
KMKnowledgeTableIndicatorNormScore (Knowledge account indicators - normalized score)
KMKnowledgeTableIndicatorTrans (Knowledge transactions - indicator)
KMKnowledgeTrans (Knowledge transactions)
KMQuestion (Question)
KMQuestionMedia (Questionnaire media table)
KMQuestionnaireStatisticsLine (Questionnaire statistics - lines)
KMQuestionnaireStatisticsTable (Questionnaire statistics - main)
KMQuestionResultGroup (Question - result groups)
KMQuestionResultGroupText (Question - point distribution)
KMQuestionRow (Rows for question)
KMQuestionType (Question types)
KMTmpKnowledgePosting (Knowledge-accounting simulation)
KMTmpKnowledgeStatistics (Table for questionnaire statistics)
KMTmpQuestionFeedback
KMVirtualNetworkAnswerGroup (Group points in answered questionnaires)
KMVirtualNetworkAnswerLine (Lines on answered/planned questionnaires)
KMVirtualNetworkAnswerTable (Plan questionnaire)
LanguageTable (Languages)
LanguageTxt (Language texts)
LedgerAccountCov (Liquidity cashflow forecast)
LedgerAllocateKey (Period allocation key)
LedgerAllocateTrans (Period allocation line)
LedgerAllocation (Allocation key for ledger posting)
LedgerBalanceControl (Balance control accounts)
LedgerBalancesDimTrans (Ledger balances - Dimensions)
LedgerBalancesTrans (Ledger balance transactions)
LedgerBalColumns (Columns)
LedgerBalHeader (Ledger balance)
LedgerBudget (Ledger budget)
LedgerBudSettlement (Settlement accounts)
LedgerClosingSheet (Closing sheet)
LedgerClosingTable (Closing accounts)
LedgerClosingTrans (Closing transactions)
LedgerConsolidateHist
LedgerConsolidateHistRef
LedgerControlCurrencyCode (Currency posting control)
LedgerControlDimension (Dimension posting control)
LedgerControlPosting (Transaction type posting control)
LedgerControlUser (User posting control)
LedgerCov (Cashflow forecasts)
LedgerCurrencyReq (Currency requirement)
LedgerImportMode (Methods of importing account statements)
LedgerInterCompany (Intercompany accounting)
LedgerJournalControl (Journal control)
LedgerJournalizeReport (Ledger journal totals)
LedgerJournalName (Name of journal)
LedgerJournalTable (Ledger journal table)
LedgerJournalTrans (Journal lines)
LedgerJournalTxt (Ledger journal texts)
LedgerJournalVoucherChanged (Changed journal vouchers)
LedgerKeyAccounts (Key-figure accounts)
LedgerKeyTrans (Key-figure transactions)
LedgerLiquidity (Liquidity accounts)
LedgerParameters (Ledger parameters)
LedgerPeriod (Accounting periods)
LedgerPeriodCode (Date intervals)
LedgerPostingJournal (Posting journals)
LedgerPostingJournalControl (Journal posting control)
LedgerPostingJournalRegister (Posting journals register)
LedgerPostingJournalVoucherSeries (Posting journal and voucher series)
LedgerReportJournal_IT (Fiscal journal sum)
LedgerSystemAccounts (System accounts)
LedgerTable (Ledger chart of accounts)
LedgerTableAlternative (Financial statement rows (name))
LedgerTableAlternativeTrans (Financial statement rows (composition))
LedgerTableInterval (Account interval)
LedgerTrans (Ledger transactions)
LedgerTransFurtherPosting
LedgerTransSettlement (Ledger settlements)
LedgerVatReportA_IT
LedgerVatReportB_IT
LedgerVatReportPayment_IT (VAT payment)
LineOfBusiness (Line of business)
MailMessages
MarkupAutoLine (Auto-misc. charges)
MarkupAutoTable (Auto misc. charges transactions)
MarkupGroup (Misc. charges groups)
MarkupTable (Misc. charges codes)
MarkupTrans (Misc. charges transactions)
MSMQQueuedMessage
NumberSequenceGroup (Number sequence group)
NumberSequenceGroupRef (Number sequence group references)
NumberSequenceHistory (History)
NumberSequenceList (Number sequence list)
NumberSequenceReference (Number sequence references)
NumberSequenceTable (Number sequence)
NumberSequenceTTS (TTS)
OLAPAmount (Calculated amounts)
OLAPAxaptaTimeByDay (Date derivatives)
OLAPCalc (Calculated members)
OLAPCube (OLAP cubes)
OLAPCubeDatasource (OLAP cube data sources)
OLAPCubeDimensionTable (Cube dimension)
OLAPCubeInstance (Physical location of cube)
OLAPCubeMeasureTable (Cube measure)
OLAPCubeRelation (OLAP cube relations)
OLAPDatabaseCubeTable (Database cube)
OLAPDatabaseTable (OLAP database)
OLAPDatasource (OLAP data sources)
OLAPDatasourceField (OLAP fields)
OLAPDatasourceRange (OLAP ranges)
OLAPDatasourceRelation (OLAP relations)
OLAPDim (OLAP dimensions)
OLAPDSODatasourceTable (OLAP data sources)
OLAPEnum (OLAP enumerations)
OLAPLev (OLAP levels)
OLAPMeas (OLAP measures)
OLAPParameters (OLAP parameters)
OLAPServerTable (Multi-dimensional server)
OLAPSetup (OLAP Ids)
OLAPTimeByDay (OLAP time definitions)
OLAPTimeLev (OLAP time level setup)
OLAPTimeLevel (OLAP time levels)
OLAPViewFieldSetup (Default viewing)
OLAPViewSetupDimension (Dimension viewing)
OLAPViewSetupMeasure (Measure viewing)
OLAPViewSetupTable (Cube viewing)
PaymDay (Payment days)
PaymDayLine (Payment day lines)
PaymInstruction (Payment instruction)
PaymItemCode (Payment, Item code)
PaymManStepTable (Payment step)
PaymSched (Payment schedule)
PaymSchedLine (Payment schedule lines)
PaymTerm (Terms of payment)
PBABOMRouteOccurrence (BOM Route occurrence)
PBACustGroup (Product model group)
PBADefault (Default values)
PBADefaultRoute (Default route)
PBADefaultRouteTable (Default route)
PBADefaultVar (Default value)
PBAGroup (Product model group)
PBAInventItemGroup (Product model group)
PBALanguageTxt (Language texts)
PBAParameters (Product Builder Parameters)
PBAReuseBOMRoute (Reuse BOM & Route)
PBARule (Validation rule)
PBARuleAction (Action)
PBARuleActionValue (Value)
PBARuleActionValueCode (Value)
PBARuleLine (Rule)
PBARuleLineCode (Value)
PBARuleRemChoice (Exclusions)
PBATable (Product Model)
PBATableGenerateItemId (Generate item number)
PBATableGenerateItemVariables (Generate items)
PBATableGroup (Product model group)
PBATableInstance (Configuration details)
PBATablePBAInstance
PBATablePrice (Price combinations)
PBATablePriceCurrencySetup (Amount currency)
PBATablePriceSetup (Rule)
PBATablePriceSetupCode (Value)
PBATableVariable (Modelling variables)
PBATableVariableDefaultVal (Default value)
PBATableVariableVal (Outcomes)
PBATmpBomId
PBATmpBuildForm
PBATranslateConsistOf (Translation table)
PBATreeBOM (BOM lines)
PBATreeCase (Case node)
PBATreeCode (Code node)
PBATreeDefault (Default node)
PBATreeDocRef (Document handling)
PBATreeFor (FOR node)
PBATreeInfoLog (Message)
PBATreeInventDim (Inventory dimensions)
PBATreeNode (Modelling Tree)
PBATreeRoute (Route)
PBATreeRouteOpr (Operation relation)
PBATreeSimpel (Simple node)
PBATreeSwitch (Switch node)
PBATreeTable (Table node)
PBATreeTableSelect (Table node)
PBATreeTableVal (Table node)
PBAUserProfiles (User profile)
PBAVariable (Variables)
PBAVariableVal (Outcomes)
PBAVarPBAProfiles (User profiles)
PBAVersion (Product model version)
PBAWebParseControlChanges (Control type)
PBAWebParseControlTable (Control type)
PBAWebParseTable (Webform parser)
PersonTitleTable (Titles of persons)
PriceDiscAdmName (Price/discount agreement journal name)
PriceDiscAdmTable (Price/discount agreement journal table)
PriceDiscAdmTrans (Price/discount agreement journal lines)
PriceDiscGroup (Price groups)
PriceDiscTable (Price agreements)
PriceParameters (Price parameters)
ProdBOM (Production BOM)
ProdCalcTrans (Calculation)
ProdGroup (Production groups)
ProdJournalBOM (BOM journal transactions)
ProdJournalName (Production journals)
ProdJournalProd (Production journal transactions)
ProdJournalRoute (Routing journal transactions)
ProdJournalTable (Production journal table)
ProdParameters (Production parameters)
ProdParmBOMCalc (BOM calculation - Production)
ProdParmCostEstimation (Estimation)
ProdParmHistoricalCost (Costing)
ProdParmRelease (Release)
ProdParmReportFinished (Production report as finished)
ProdParmScheduling (Scheduling)
ProdParmSplit (Split)
ProdParmStartUp (Start)
ProdParmStatusDecrease (Reverse status)
ProdPool (Production pools)
ProdRoute (Production route)
ProdRouteJob (Route jobs)
ProdRouteJobJour (Route job journal)
ProdRouteTrans (Route transactions)
ProdTable (Production orders)
ProdTableJour (Journal)
ProjActivity (Activities)
ProjAllocateKey (Project allocation key)
ProjAllocateTrans (Project - Allocation transaction)
ProjBudgetCost (Cost estimates)
ProjBudgetEmpl (Hour estimates)
ProjBudgetRevenue (Project budget)
ProjCategory (Project category)
ProjCategoryGroup (Category group)
ProjControl (Control types)
ProjControlCategory (Categories for control types)
ProjControlCostGroup (Estimate template)
ProjControlPeriodCostGroup (Cost group)
ProjControlPeriodTable (Control periods)
ProjControlPeriodTrans (Work in process)
ProjCostSalesPrice (Project - Cost prices)
ProjCostTrans (Cost)
ProjEmplTrans (Hours)
ProjFormletterDocument (Project form setup)
ProjFormletterParameters (Project form parameters)
ProjGroup (Project groups)
ProjHourCostPrice (Project - Hour cost price)
ProjHourSalesPrice (Project - Hour sales price)
ProjInvoiceCost (Project - Invoice lines, cost)
ProjInvoiceCurrency (Fixed rate agreements)
ProjInvoiceEmpl (Project - Invoice lines, employee)
ProjInvoiceItem (Project - Invoice lines, items)
ProjInvoiceJour (Project invoice)
ProjInvoiceOnAcc (Project invoice lines on-account)
ProjInvoiceParmTable (Invoice posting)
ProjInvoiceRevenue (Project - Invoice lines, revenue)
ProjInvoiceTable (Project invoice table)
ProjItemTrans (Items)
ProjItemTransCost (Items - project expenses)
ProjJournalName (Project journal names)
ProjJournalStatusHistory (History on status)
ProjJournalStatusLine (Journal approval setup)
ProjJournalStatusTable (Journal approval)
ProjJournalTable (Project journal table)
ProjJournalTrans (Project journal)
ProjJournalTxt (Project journal texts)
ProjLineProperty (Line property)
ProjLinePropertySetup (Line property setup)
ProjOnAccTrans (On-account payments)
ProjParameters (Project parameters)
ProjPeriodEmpl (Project periods - Employee)
ProjPeriodLine (Project period lines)
ProjPeriodTable (Project periods)
ProjPosting (Ledger posting setup)
ProjPrintCopies (Project print management)
ProjProposalCost (Invoice proposal - Cost)
ProjProposalEmpl (Invoice proposal - Employee)
ProjProposalItem (Invoice proposal - Items)
ProjProposalJour (Invoice proposal)
ProjProposalOnAcc (Invoice proposal - On-account)
ProjProposalRevenue (Invoice proposal - Revenue)
ProjRevenueSalesPrice (Project - Revenue sales price)
ProjRevenueTrans (Revenue)
ProjSorting (Sorting)
ProjTable (Project table)
ProjTableStatusSetup (Project stage setup)
ProjTimeSheet (Hours registered via the Web)
ProjTransPosting (Project - Posting, Ledger)
ProjValEmplCategorySetUp (Employee validation group lines)
ProjValEmplCategoryTable (Employee/category validation group)
ProjValEmplProjSetup (Project validation group lines)
ProjValEmplProjTable (Employee/project validation group)
ProjValProjCategorySetUp (Category validation group lines)
ProjValProjCategoryTable (Project/category validation group)
ProjWIPTable (WIP projects)
PurchJournalAutoSummary (Purchase summary update)
PurchLine (Purchase lines)
PurchLineDelete (Voided purchase lines)
PurchParameters (Purchase parameters)
PurchParmLine (Purchase order line - Update table)
PurchParmSubTable (Purchase order header - Updating table)
PurchParmTable (Purchase order - Update table)
PurchParmUpdate
PurchPool (Purchase pools)
PurchPrintCopies (Purchase print management)
PurchSummaryParameters (Purchase summary update parameters)
PurchTable (Purchase table)
PurchTable2LineParameters (Purchase line update parameters)
PurchTableDelete (Voided purchase orders)
PurchTableLinks (Inter-attached purchase orders)
ReqGroup (Item coverage groups)
ReqItemJournalName (Item coverage journal names)
ReqItemJournalTable (Item coverage journal table)
ReqItemJournalTrans (Item coverage journal lines)
ReqItemTable (Item coverage)
ReqLog (Session log)
ReqParameters (Master planning parameters)
ReqPlan (Plans)
ReqPlanForecast (Forecast plan setup)
ReqPlanSched (Master plan setup)
ReqPO (Planned order)
ReqReduceKey (Reduction keys)
ReqReduceLine (Reduction lines)
ReqRoute (Requirement route)
ReqRouteJob (Requirement job)
ReqSafetyKey (Minimum/maximum keys)
ReqSafetyLine (Minimum/maximum key lines)
ReqTrans (Net requirements)
ReqTransCov (Requirement coverage)
ReqTransFirmLog (Firming log)
ReturnActionDefaults (Return action)
Route (Route)
RouteCostCategory (Cost categories)
RouteGroup (Routing groups)
RouteJobSetup (Route job types)
RouteOpr (Operation relation)
RouteOprTable (Operations)
RouteParameters (Route parameters)
RouteTable (Routes)
RouteVersion (Route versions)
SalesBasket (Sales basket)
SalesBasketLine (Sales basket lines)
SalesJournalAutoSummary (Sales summary update)
SalesLine (Order lines)
SalesLineDelete (Voided sales order lines)
SalesOrigin (Order origin codes)
SalesParameters (Sales parameters)
SalesParmLine (Sales order line - Update table)
SalesParmSubTable (Sales order header - Updating table)
SalesParmTable (Sales order - Update table)
SalesParmUpdate
SalesPickingListJournalLine (Picking list lines)
SalesPickingListJournalTable (Picking list)
SalesPool (Order pools)
SalesPrintCopies (Order print management)
SalesShippingStat (Shipping specification)
SalesSummaryParameters (Sales summary update parameters)
SalesTable (Sales orders)
SalesTable2LineParameters (Order line update parameters)
SalesTableDelete (Voided sales orders)
SalesTableLinks (Linked sales orders)
smmActivities (Activities table)
smmActivityPhaseGroup (Phase for quotation)
smmActivityPlanGroup (Activity plan table)
smmActivityTypeGroup (Activity Type)
smmBusRelChainGroup (Company chains)
smmBusRelFavorites (Favorite business relations)
smmBusRelSalesDistrictGroup (Sales districts)
smmBusRelSectorTable (Business relation sector table)
smmBusRelSegmentGroup (Segment table)
smmBusRelStatusGroup (Status table)
smmBusRelSubSegmentGroup (Subsegment table)
smmBusRelTable (Business relation table)
smmBusRelTypeGroup (Type table)
smmBusRelTypeUpgrade (Type upgrade table)
smmBusSectorGroup (Business sector table)
smmCampaignDocuRefRecId (Document references)
smmCampaignEmailAttachment (Campaign email attachment)
smmCampaignEmailTemplate (Campaign email template)
smmCampaignGroup (Campaign group)
smmCampaignMailMergeFile (Campaign mail merge file)
smmCampaignMediaType (Media type)
smmCampaignMediaTypeGroup (Media type)
smmCampaignQuery (Campaign queries)
smmCampaignQueryExpression (Campaign query expression)
smmCampaignReasonGroup (Campaign reason)
smmCampaignResponsesQuest (Campaign response quest)
smmCampaignResponsibilitiesGroup (Campaign responsibilities)
smmCampaignResponsibility (Campaign responsibility)
smmCampaignSelection (Campaign selections)
smmCampaignSelectionResult (Campaign temporary selections)
smmCampaignTable (Campaign table)
smmCampaignTargetTable (Campaign target)
smmCampaignTempSelection (Campaign temporary selections)
smmCampaignTypeGroup (Campaign type)
smmCharacterGroup (Contact characters)
smmContactGreetingsGroup (Complimentary close)
smmContactInterest (Contact interests)
smmContactIntroGroup (Complimentary close)
smmContactPersonDetails (Contact Person Details)
smmContactPersonSynchronize (Contact Person Synchronize)
smmContactTitleGroup (Title)
smmDecisionGroup (Decision table)
smmDeletedActivities (Deleted activities)
smmDeletedContactPersons (Deleted contact persons)
smmEmailCategoryGroup (Email category)
smmEmailGroups (Email groups)
smmEmailMembers (Group members)
smmEncyclopediaItems (Encyclopedia items)
smmFunctionGroup (Function)
smmImportBusSectorFileFields (Import business sector codes)
smmImportBusSectorJournal (Business sector)
smmImportContactPersonFileFields
smmImportContactPersonJournal (Contact person)
smmImportFileFormat (File format)
smmImportRecordGroup (Record group)
smmImportRelationJournal (Relation/Prospect journal)
smmImportRelationJournalFileFields (Relation journal file fields)
smmInterestGroup (Interests)
smmLoyaltyGroup (Loyalties)
smmMailingCategoryGroup (Mailing category)
smmMailingGroup (Mailing)
smmMailingHistory (Mailing history)
smmMailingMergeFile (Mailing merge file)
smmMailings (Mailing table)
smmMailingsQueryTmp (Temporary mailing table)
smmNoteItTable (Note it)
smmParametersTable (CRM parameters)
smmPhoneDevice (Line device name)
smmPhoneLog (Phone log)
smmPhoneParameters (Phone Parameters)
smmQuotationCompetitorGroup (Quotation competitor)
smmQuotationCompetitors (Quotation competitors)
smmQuotationDocuConclusionGroup (Document conclusions)
smmQuotationDocuIntroGroup (Document introductions)
smmQuotationDocuTitleGroup (Document titles)
smmQuotationLine (Quotation lines)
smmQuotationPhaseGroup (Quotation phase)
smmQuotationPriceSim (Quotation price simulation)
smmQuotationProbabilityGroup (Quotation probability)
smmQuotationPrognosisGroup (Quotation prognosis)
smmQuotationReasonGroup (Quotation reason)
smmQuotationRelations (Quotation relations)
smmQuotationTable (Quotation table)
smmQuotationTypeGroup (Quotation type)
smmRelationTable (Relation table)
smmReportActivityTypeGroup (Report activity type)
smmReportQuotationReasonGroup (Quotation reason)
smmReportSalesDistrictGroup (Sales districts for reports)
smmReportTMCallListTableStatus (Call list status table)
smmResponsibilities (Responsibilities)
smmResponsibilityGroup (Responsibility table)
smmSalesManagementGraphOptions (Sales management graph options)
smmSalesTarget (Sales targets)
smmSalesUnit (Sales management units)
smmSalesUnitMembers (Sales unit members)
smmTMCallListGroup (Call list group table)
smmTMCallListResponsibilities (Responsibility)
smmTMCallListTable (Call list table)
smmTMContactResponses (Telemarketing response)
SmmTmpCampaignMailingQuery (Temporary mailing table)
smmTmpOutlookContacts (Synchronize contact persons from Outlook)
smmTmpQuot2ProjItemReq (Convert quotation to project)
smmTmpQuot2ProjServices (Transfer of quotation services to project forecast hours)
smmTmpSMBusRelInvoiced (Business relation information)
smmTmpSMCampaignFrequency (Campaign response frequency)
smmTmpSMCustContribution (Contribution ratio)
smmTmpSMProductGroupTopTen (Item group top ten)
smmTmpSMProductTopTen (Item top ten)
smmTmpSMTelemarketingFrequency (Telemarketing frequency)
smmTmpUpgradeTable (Temporary upgrade table)
smmTMReasonGroup (Telemarketing reason)
smmTransLog (Transaction log)
SpecTrans (Specification)
SqlScanDictionary (SQL Dictionary maintenance)
State (States)
StatRepInterval (Statistics)
StatRepIntervalLine (Lines for setup of statistics)
SuppItemGroup (Supplementary item groups)
SuppItemTable (Supplementary items)
SysAction (Action)
SysActionList (Possible actions)
SysAOSMeasurement (AOS measurements)
SysASPClientDomainList (ASP client - Domain list)
SysASPClientTable (ASP clients)
SysASPClientTemplateList (ASP client - Template list)
SysASPCompanyParameters (ASP company account parameters)
SysASPLicenseReporting (ASP License reporting)
SysASPParameters (ASP parameters)
SysASPTemplateCompanyList (ASP company templates list)
SysASPTemplateCompanyTable (Company accounts templates)
SysASPTemplateTable (ASP templates)
SysASPTemplateUserGroupList (ASP user group templates list)
SysASPTemplateUserGroupTable (User group templates)
sysBestPracticeSummrizeStatisticsResult
sysBestPracticeSummrizeStatisticsTmp
SysBPParameters (Best Practice parameters)
SysCheckListItemTable
SysCheckListTable
SysCodeProfilerChildLineSum (Totals for called lines)
SysCodeProfilerChildMethodSum
SysCodeProfilerChildObjectSum
SysCodeProfilerLineSum
SysCodeProfilerMethodSum
SysCodeProfilerObjectSum
SysCodeProfilerObjectTable (Object-derived)
SysCodeProfilerParameters (Profiler parameters)
SysCodeProfilerPathTable (Path derived)
SysCodeProfilerRunLine (Run entries)
SysCodeProfilerRunSum
SysCodeProfilerRunTable (Profiler runs)
SysCountTable (Count of application objects in the system)
SysDataBaseLog (Database log)
SysDataSearch (Search parameters)
SysDataSearchDaemonTable (Data crawler engine setup)
SysDocCaptureForm
SysDocCaptureFormStep
SysEmailMessageSystemTable (System e-mail messages)
SysEmailMessageTable (E-mail messages)
SysEmailParameters (E-mail parameters)
SysEmailSystemTable (System e-mails)
SysEmailTable (E-mails)
SysEvent (System Events)
SysExpImpField (Field setup)
SysExpImpGroup (Define import/export groups)
SysExpImpTable (Definition of import/export tables)
SysExpImpTableQuery
SysImageTable (Images)
SysInetCSS (Cascading stylesheets)
SysINetPublishSetup (Publish Manager)
SysINetTable (Internet)
SysInetThemeTable (Themes)
SysInfolog
SysLabelInterval (Label intervals)
SysLabelLog (Changed labels)
SysLicenseCodeSort
SysPasswordParameters
SysRecordTemplateSystemTable (System record templates)
SysRecordTemplateTable (Record templates)
SysRenamedElements (Renamed application objects)
SysReportSelectionTable (Reports)
SysSearchName
SysSearchPath
SysSearchRef
SysSecurityFormControlTable (Layout security control setup)
SysSecurityFormTable (Layout security setups)
SysSetupCompanyLog (Company specific installation information)
SysSetupLog (Installation information)
SysSortOrder
SysSQLBlockingTmpMSSQLTable (Locking database users)
SysSQLBlockingTmpOracleTable (Locking database users)
SysTraceTable (Trace details)
SysTraceTableSQL (SQL statement trace log)
SysTraceTableSQLExecPlan (Statement Execution Plan)
SysTraceTableSQLTabRef (Referenced tables)
SysUserInfo (User information)
SysUserLog (User log)
SysUtilApprove (Approve version)
SysUtilManagementDeveloper (Responsible)
SysUtilManagementElement (Application elements)
SysUtilManagementTeam (Teams)
Tax1099Fields (1099 fields)
Tax1099FormLetter (1099 form)
Tax1099Reports (Reporting on 1099 forms)
TaxAuthorityAddress (Authority)
TaxCollectLimit (Sales tax limits)
TaxCorrectionsBE (Tax corrections)
TaxData (Sales tax details)
TaxDeclarationBoxCompsBEL (Sales tax box components)
TaxDeclarationBoxDetailBEL (Terms of sales tax boxes)
TaxDeclarationBoxesBEL (Sales tax boxes)
TaxDeclarationTransBEL (Sales tax declaration information)
TaxFringeVariationTable (BAS fringe benefit reason codes)
TaxGroupData (Sales tax group)
TaxGroupHeading (Sales tax group description)
TaxIncomingInvoiceBookBEL (Sales tax receivable invoice book)
TaxIncomingInvoiceBookLinkingBEL (Boxes in sales tax receivable invoice books.)
TaxItemGroupHeading (Item sales tax group)
TaxJournalTrans (Journalized, unposted sales tax)
TaxLedgerAccountGroup (Ledger posting groups)
TaxOnItem (Item sales tax group setup)
TaxOutgoingInvoiceBookBEL (Sales tax payable invoice book)
TaxOutgoingInvoiceBookLinkingBEL (Boxes in sales tax payable invoice books.)
TaxParameters (Sales tax parameters)
TaxPAYGVariationTable (BAS PAYG reason codes)
TaxPeriodHead (Sales tax period description)
TaxPurchaseTaxTable (Purchase duty)
TaxPurchaseTaxTrans (Purchase duty transactions)
TaxPurchaseTaxValue (Purchase duty value)
TaxQuarterListingBoxesTableBEL (Sales tax quarterly report boxes)
TaxRep347AddressAbbrev (Address abbreviation)
TaxReport347Table (Declaration 347)
TaxReport347Tenants (Declaration 347 tenants)
TaxReport347Trans (Declaration 347 declarations)
TaxReport349Table (Report 349)
TaxReport349Trans (Report 349 transactions)
TaxReportAdjustmentTrans (Posted sales tax corrections)
TaxReportCollection (Sales tax reporting codes)
TaxReportExtraFields (Additional BAS report fields)
TaxReportExtraFieldsBE (Additional sales tax report fields in Belgium)
TaxReportLedgerAccounts (Additional BAS reconciliation account)
TaxReportPeriod (Sales tax period setup)
TaxReportVoucher (Sales tax payments)
TaxTable (Sales tax codes)
TaxTrans (Posted sales tax)
TaxVATNumTable (Tax exempt number table)
TaxWorkRegulation (Adjusted sales tax amounts)
TaxYearListingTransBEL (Sales tax annual report amount)
TmpABC (ABC classification)
TmpAccountSum (Account totals)
TmpAddressCheck (Check address)
TmpAnalysis (Activities for analysis)
TmpAotImport (Application objects to be imported)
TmpAotLabelImport (Application objects and the labels they use)
TmpAssetConsumptionProposal (Consumption proposal for fixed asset)
TmpAssetGroupCOT
tmpAssetTableCOT
TmpAssetTrans (Fixed asset transactions)
TmpBankPaym2Invoice
TmpBankPromissoryNotePrintout (Print promissory note documents)
TmpBankTotal (Bank totals)
TmpBankTransTypeSum
TmpBarcodeEAN128
TmpBillOfExchangeStatistics
TmpBOM (BOM lines)
TmpBOMCalc (BOM calculation)
TmpBOMRouteTree (BOM setup)
TmpBudgetBalance (Budget balances)
TmpCashDiscMulti
TmpChequePrintout (Print checks)
TmpCompareText
TmpCompilerOutput (Compiler information)
TmpConfigId (Selected configurations)
TmpConfigValue (Configuration)
TmpCountry (Country)
TmpCurrencyReq (Currency requirement (work table))
TmpCustLedger (Reconcile with ledger)
TmpCustVendLedgerReconciliation
TmpCustVendOutPaymBatch (Temporary payment batch)
TmpCustVendOutPaymFile (Temporary payment file)
TmpCustVendPaymFee (Temporary payment fee)
TmpCustVendTrans
TmpCustVendTransOpen
TmpCustVendTransReorg
TmpCustVendVolume (Extent of sales and purchase)
TmpDatabaseLogWizard
TmpDatabaseNames (Database name)
TmpDateSum (Date totals)
TmpDateSumCode (Date totals)
TmpDefaultDataSetup
TmpDimension
TmpECPItemListPrice
TmpEPGroupSecurity
TmpExcelImport
TmpExcelImportField
TmpExcelTemplateField
TmpExchRates (Exchange adjustment)
TmpExchRateTxt
TmpFontName (Fonts)
TmpFormLookUp
TmpFrmVirtual
TmpGatewaySuspendedQueue (Suspended queue)
TmpHelpIndex
TmpIdRef
TmpInfolog
TmpInventAge (Inventory value and quantity by age)
TmpInventBalance (Item posting)
TmpInventClosing (Close)
TmpInventCountStatistics (Counting statistics)
TmpInventModel (Inventory model)
TmpInventTableModule
TmpInventTransMark
TmpInventTransWMS (Registration/picking)
TmpJobSelect (Batch-journal jobs)
TmpJoinDetail (Join detail)
TmpJoinMaster (Join master)
TmpLabelImport (Labels to be imported)
TmpLedgerAccountSumRef
TmpLedgerBalanceControl (Balance control)
TmpLedgerBalanceSheetAcc
TmpLedgerBalanceSheetCol (Ledger balance sheet)
TmpLedgerBalanceSheetSum
TmpLedgerBase
TmpLedgerBudget (LedgerBudgetTotals)
TmpLedgerConsBudget (Ledger budget totals - consolidated)
TmpLedgerConsCompany (Ledger - Consolidation)
TmpLedgerConsQuery (Ledger - Consolidation)
TmpLedgerConsTrans (Consolidations)
TmpLedgerJournalAccountMovement
TmpLedgerJournalSplitHeader
TmpLedgerJournalSplitLines
TmpLedgerPaymentControl (Payment control)
TmpLedgerPaymentControlCur (Currency distribution)
TmpLedgerReport (Ledger report)
TmpLedgerReport_IntraEU
TmpLedgerShowBalance (Balance)
TmpLedgerTable (Chart of accounts)
TmpLedgerTableInterval (Temporary account interval)
TmpLedgerTrans (Ledger transaction)
TmpNotes (Temporary notes)
TmpNumberSeqCreate
TmpPackMaterialFeeSum
TmpPaymDistribution (Payment distribution)
TmpPaymManOutputReport (Transactions)
TmpPaymManOutputTotals (Totals)
TmpPBAReference
TmpProdBalance (Production posting)
TmpProdEfficiency (Efficiency)
TmpProdRouteJobSched (Route jobs)
TmpProdRouteReporting
TmpProjAdjustment (Project adjustments)
TmpProjAdjustmentCreate (Project adjustments to create)
TmpProjControlActual (Project - Control Current, Temporary)
TmpProjControlCategory (Project - Control Category, Temporary)
TmpProjHourStatement (Hour statement)
TmpProjItemUpdate (Update)
TmpProjPeriodic (Project - Periodic, Temporary)
TmpProjPeriodicLedger
TmpProjProposalJour (Customer invoice)
TmpProjTransLedger (Transaction list)
TmpProjTransList (Transaction list)
TmpProjTransPosting (Project - Posting, Temporary Ledger)
TmpProjTransWIP (Operations transactions)
TmpProjTransWIPOperation (Balance - transactions)
TmpProjView (Project view)
TmpPromissoryNoteStatistics
TmpPropertySelection
TmpPurchLine
TmpQueryRangeValue
TmpRecId
TmpRecIdMap
TmpReference (Ledger reference)
TmpReqExplosionOnHand (Master schedule explosion, on-hand)
TmpReqExplosionTree (Display options)
TmpReqInventDim
TmpReqSetup
TmpSalesItemReq
TmpSalesLine
TmpSchedMasterData
TmpSearchResult
TmpSecurityTree
TmpSettleOverUnderReverseTax
TmpSetupComponents
TmpStatPer (Statistics periods)
TmpSum (Totals)
TmpSumDim (Sum dimensions)
TmpSumSpec (Total)
TmpSuppItem
TmpSysClass (Classes)
TmpSysConsistencyCheck
TmpSysLabel (Label)
TmpSysQuery (Criteria)
TmpSysRecordTemplate
TmpSysTableField (Fields)
TmpTableName
TmpTax (Sales tax)
TMPTaxDeclarationTableBEL
TmpTaxPeriodAmount
TmpTaxPurchLedger
TmpTaxReference
TmpTaxRegulation
TmpTaxReport_ES
TmpTaxReportById
TmpTaxSalesLedger
TmpTaxTotals (Sales tax totals)
TmpTaxTrans
TmpTaxTransInvoice
TmpTaxWorkTrans (Temporary sales tax transactions (work table))
TmpTransactionIdMap (Transaction ID)
TmpTree
TmpUtil
TmpVoucherSum
TmpWizardLink
TmpWMSAreaSetup (Store area)
TmpWMSAreaSetupBase (Store area selection)
TmpWMSAreaSetupChanges (Store area changes)
TmpWMSJournalCheck
TmpWMSLocation (Locations)
TmpWMSOnlineCounting (Online counting journal)
TmpWMSOrder (Summary order)
TmpWMSPallet (Possible picking pallets)
TmpWMSPalletTransport (Selected pallet transports)
TmpWrkCtrCapacity
TmpWrkCtrReservedSum (Capacity reservations)
TmpxRefReferences
TransactionLog (Audit trail)
TransactTxt (Ledger transaction text)
tutorial_AuctionBids
tutorial_AuctionItems (Auction items)
Tutorial_AuctionPoll
Tutorial_BattleshipsTable (Tutorial Battleships)
tutorial_GPSData
Tutorial_SushiItems (Sushi Items)
tutorial_SushiOrders (Sushi Orders)
tutorial_SushiTables (Tables)
tutorial_SushiWaiters (Waiters)
TutorialDefData (Tutorial default data)
TutorialJournalName
TutorialJournalTable
TutorialJournalTrans
Unit (Units)
UnitConvert (Unit conversion)
UnitParameters (Fixed units)
UnitTxt (Unit texts)
VendBankAccount (Vendor bank accounts)
VendFormletterDocument (Vendor form setup)
VendFormletterParameters (Vendor form parameters)
VendGroup (Vendor groups)

http://axaptaturk.blogcu.com/dynamics-axapta-tablolar/6260063