Information Systems:ASW Analyzer Appendix - Revision history

Norwinu at 21:54, 10 April 2017

2017-04-10T21:54:55Z

Norwinu: Norwinu moved page Information Systems:Analyser to Information Systems:ASW Analyzer Appendix

2017-01-25T21:54:29Z

Norwinu moved page Information Systems:Analyser to Information Systems:ASW Analyzer Appendix

Norwinu at 18:03, 17 January 2017

2017-01-17T18:03:14Z

Norwinu at 18:01, 17 January 2017

2017-01-17T18:01:55Z

Norwinu at 18:00, 17 January 2017

2017-01-17T18:00:47Z

Show changes

Sheilav: /* Statistic Keys */

2016-01-19T21:27:10Z

Statistic Keys

Sheilav: /* Summary Levels */

2015-10-19T18:21:46Z

Summary Levels

Show changes

Sheilav: /* System Base Levels */

2015-10-19T18:17:18Z

System Base Levels

Sheilav: /* Fields */

2015-10-19T18:15:13Z

Fields

Sheilav: /* Files */

2015-10-19T18:13:45Z

Files

← Older revision		Revision as of 21:54, 10 April 2017
Line 1,089:		Line 1,089:

	[[Category: ASW: Technical Reference]]		[[Category: ASW: Technical Reference]]
		+	[[Category: ASW Analyzer]]
	[[Category: BI Tasks]]		[[Category: BI Tasks]]

← Older revision		Revision as of 18:03, 17 January 2017
Line 1:		Line 1:
	==ASW Analyser==		==ASW Analyser==
		+	(a.k.a. ASW Analyzer)

	This is a ‘data warehouse’ for inventory and accounting, that is updated by every transaction. The totals are summarised by account period.		This is a ‘data warehouse’ for inventory and accounting, that is updated by every transaction. The totals are summarised by account period.

← Older revision		Revision as of 18:01, 17 January 2017
Line 1,088:		Line 1,088:

	[[Category: ASW: Technical Reference]]		[[Category: ASW: Technical Reference]]
−	[[Category: ~~Business~~ ~~Intelligence~~]]	+	[[Category: BI Tasks]]

← Older revision		Revision as of 21:27, 19 January 2016
Line 130:		Line 130:

	===Statistic Keys===		===Statistic Keys===
		+
		+	This can be found in file ANOSKD.

	Key Statistic key name Statistic Map Tbl		Key Statistic key name Statistic Map Tbl

@@ Line 458: / Line 458: @@
 These are accumulated from transactions; like SROISDPL, SRODTA, and SROLTA.
-'''Level A01 Sales order statistics'''
+====Level A01 Sales order statistics====
  KEMK01 – item number
@@ Line 501: / Line 501: @@
 Sales order line cost
-'''Level A02 Purchase/work order statistics'''
+====Level A02 Purchase/work order statistics====
  KEMK01 – item number
@@ Line 537: / Line 537: @@
 Purchase quantity
-'''Level A03 Sales fees statistics'''
+====Level A03 Sales fees statistics====
  KEMK10 – customer number
@@ Line 557: / Line 557: @@
 Sales order cost
-'''Level A04 Warehouse statistics'''
+====Level A04 Warehouse statistics====
  KEMK01 – item number
@@ Line 573: / Line 573: @@
 Average tied-up capital
-'''Level A11 G/L transactions'''
+====Level A11 G/L transactions====
  KEMK01 – G/L part 1 (Main)
@@ Line 590: / Line 590: @@
 System currency amounts
-'''Level A12 G/L transactions with TCUR'''
+====Level A12 G/L transactions with TCUR====
  KEMK01 – G/L part 1 (Main)
@@ Line 608: / Line 608: @@
 Transaction currency amounts
-'''Level A13 A/R-A/P combined with G/L transactions'''
+====Level A13 A/R-A/P combined with G/L transactions====
  KEMK01 – G/L part 1 (Main)
@@ Line 623: / Line 623: @@
 Supp system currency amounts
-'''Level A31 A/C transactions (assets)'''
+====Level A31 A/C transactions (assets)====
  KEMK01 – G/L part 4 (cost centre)
@@ Line 647: / Line 647: @@
 Profit/loss value, main depr type
-'''Level A32 A/C combined with G/L transactions (assets'''
+====Level A32 A/C combined with G/L transactions (assets)====
  KEMK02 – G/L part 1 (main)

← Older revision	Revision as of 21:54, 25 January 2017
(No difference)

@@ Line 379: / Line 379: @@
 ===Fields===
-'''SUTA - Base or summary level code'''
+====SUTA - Base or summary level code====
 Describes the key fields.  Part of link between ANOSTK and ANOBAL / ANOBOB
@@ Line 423: / Line 423: @@
 Detail sales summary for weeks onhand
-'''BATP - Balance type'''
+====BATP - Balance type====
 Describes the values that are kept.  On ANOBAL, ANOBUD, and ANOBOB.

@@ Line 7: / Line 7: @@
 There can be up to 60 key fields.  So that all these fields don’t have to be on every record, there is a separate key file (ANOSTK), with a level code and reference key (13 digit number) that link to the files that actually hold the values (ANOBOB – opening balances, ANOBAL – period balances).
-'''ANOSTK - Statistic value key file'''
+====ANOSTK - Statistic value key file====
  KESUTA            Base or summary level code                      3
@@ Line 72: / Line 72: @@
  KEREFK            Reference key                                  13    0
-'''ANOBAL - Balance value file'''
+====ANOBAL - Balance value file====
  BASUTA            Base or summary level code                      3
@@ Line 106: / Line 106: @@
  BACA13            Credit balance period 13                       19    4
-'''ANOBOB - Balance opening balance value file'''
+====ANOBOB - Balance opening balance value file====
  BOSUTA            Base or summary level code                      3
@@ Line 115: / Line 115: @@
  BOCAOB            Credit opening balance value                   21    4
-'''ANOSKD – Statistic key definitions'''
+====ANOSKD – Statistic key definitions====
  KDSKNO	    Statistic key number				 3    0