<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.infinite-erp.co.id/index.php?action=history&amp;feed=atom&amp;title=Projects%2FArchived_AUDIT_TRAIL_table_to_external_database</id>
	<title>Projects/Archived AUDIT TRAIL table to external database - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.infinite-erp.co.id/index.php?action=history&amp;feed=atom&amp;title=Projects%2FArchived_AUDIT_TRAIL_table_to_external_database"/>
	<link rel="alternate" type="text/html" href="https://wiki.infinite-erp.co.id/index.php?title=Projects/Archived_AUDIT_TRAIL_table_to_external_database&amp;action=history"/>
	<updated>2026-04-06T16:37:25Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.31.1</generator>
	<entry>
		<id>https://wiki.infinite-erp.co.id/index.php?title=Projects/Archived_AUDIT_TRAIL_table_to_external_database&amp;diff=3072&amp;oldid=prev</id>
		<title>Wikiadmin: /* Functional Specifications */</title>
		<link rel="alternate" type="text/html" href="https://wiki.infinite-erp.co.id/index.php?title=Projects/Archived_AUDIT_TRAIL_table_to_external_database&amp;diff=3072&amp;oldid=prev"/>
		<updated>2022-01-05T01:30:32Z</updated>

		<summary type="html">&lt;p&gt;‎&lt;span dir=&quot;auto&quot;&gt;&lt;span class=&quot;autocomment&quot;&gt;Functional Specifications&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;Revision as of 01:30, 5 January 2022&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l7&quot; &gt;Line 7:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 7:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;====Purpose====&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;====Purpose====&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;−&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;Table AD_AUDIT_TRAIL adalah table yang mencatat semua perubahan record yang dilakukan oleh User ERP.&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;+&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;Table &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;'''&lt;/ins&gt;AD_AUDIT_TRAIL&lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;''' &lt;/ins&gt;adalah table yang mencatat semua perubahan record yang dilakukan oleh User ERP.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;Peningkatan jumlah record setiap tahunnya bisa mencapai 5 kali lipat, sehingga berdampak pada beberapa proses sebagai berikut:&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;Peningkatan jumlah record setiap tahunnya bisa mencapai 5 kali lipat, sehingga berdampak pada beberapa proses sebagai berikut:&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* Proses backup database semakin lama&lt;/div&gt;&lt;/td&gt;&lt;td class='diff-marker'&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;* Proses backup database semakin lama&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Wikiadmin</name></author>
		
	</entry>
	<entry>
		<id>https://wiki.infinite-erp.co.id/index.php?title=Projects/Archived_AUDIT_TRAIL_table_to_external_database&amp;diff=3071&amp;oldid=prev</id>
		<title>Wikiadmin: Created page with &quot;{{WorkInProgress}}  == Functional Specifications ==  === Overview ===  ====Purpose====  Table AD_AUDIT_TRAIL adalah table yang mencatat semua perubahan record yang dilakukan o...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.infinite-erp.co.id/index.php?title=Projects/Archived_AUDIT_TRAIL_table_to_external_database&amp;diff=3071&amp;oldid=prev"/>
		<updated>2022-01-05T01:30:18Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;{{WorkInProgress}}  == Functional Specifications ==  === Overview ===  ====Purpose====  Table AD_AUDIT_TRAIL adalah table yang mencatat semua perubahan record yang dilakukan o...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;{{WorkInProgress}}&lt;br /&gt;
&lt;br /&gt;
== Functional Specifications ==&lt;br /&gt;
&lt;br /&gt;
=== Overview ===&lt;br /&gt;
&lt;br /&gt;
====Purpose====&lt;br /&gt;
&lt;br /&gt;
Table AD_AUDIT_TRAIL adalah table yang mencatat semua perubahan record yang dilakukan oleh User ERP.&lt;br /&gt;
Peningkatan jumlah record setiap tahunnya bisa mencapai 5 kali lipat, sehingga berdampak pada beberapa proses sebagai berikut:&lt;br /&gt;
* Proses backup database semakin lama&lt;br /&gt;
* Proses meng-akses data dari dalam sistem ERP juga semakin lama.&lt;br /&gt;
&lt;br /&gt;
Oleh karena itu, project ini bertujuan membuat fungsi archived pada table seperti halnya dilakukan oleh sistem lain seperti SAP.&lt;br /&gt;
Ide dasarnya adalah hanya menyimpan record 45 hari terakhir di ERP dan selebihnya dipindahkan ke database lain seperti Firebase Store di Google Cloud, kemudian menyediakan menu audit trail khusus agar user tetap bisa meng-akses data audit trail yang sudah di archived tersebut.&lt;br /&gt;
&amp;lt;br&amp;gt; &amp;lt;br&amp;gt;&lt;br /&gt;
Menu untuk mengakses audit trail yang sudah di archive berupa tombol icon berdekatan dengan tombot audit yang ada saat ini di ERP. &lt;br /&gt;
&lt;br /&gt;
===== Current Condition =====&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
====References====&lt;br /&gt;
None.&lt;br /&gt;
===Design Considerations===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
====Assumptions====&lt;br /&gt;
# It should be possible to operate this functionality in a pure multi-tenant implementation. In particular, this means that it should be possible for a user to initiate the creation of a new client applying an industry template in a self-service manner without having any prior access to the system and without being a system administrator.&lt;br /&gt;
&lt;br /&gt;
====Dependencies====&lt;br /&gt;
None.&lt;br /&gt;
&lt;br /&gt;
====Constraints====&lt;br /&gt;
&lt;br /&gt;
===Glossary===&lt;br /&gt;
* '''Pelanggan''' adalah orang pembeli yang melakukan transaksi pembelian untuk semua produk Yasmeera.&lt;br /&gt;
* '''User''' adalah pengguna aplikasi InfiniteERP.&lt;br /&gt;
&lt;br /&gt;
===Functional Requirements===&lt;br /&gt;
&lt;br /&gt;
====An Example====&lt;br /&gt;
=====The Scenario=====&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====InfiniteERP Implementation=====&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====The Industry Template=====&lt;br /&gt;
&lt;br /&gt;
====User roles &amp;amp; profiles====&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
====Business process definition====&lt;br /&gt;
&lt;br /&gt;
====User stories====&lt;br /&gt;
&lt;br /&gt;
====Functional requirements based on business processes====&lt;br /&gt;
&lt;br /&gt;
====User Interface Mockups====&lt;br /&gt;
TBD&lt;br /&gt;
&lt;br /&gt;
====Web Services API====&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=====Error Result=====&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Non-Functional Requirements===&lt;br /&gt;
;Performance: The initial client setup with the application of an industry template should complete within 30 minutes.&lt;br /&gt;
&lt;br /&gt;
===Open Discussion Items===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Closed Discussion Items===&lt;br /&gt;
&lt;br /&gt;
[[Category:Projects_ERP]]&lt;/div&gt;</summary>
		<author><name>Wikiadmin</name></author>
		
	</entry>
</feed>