Difference between revisions of "Information Systems:ASW Analyzer Appendix"
Jump to navigation
Jump to search
m |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| 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. |
||
| Line 130: | Line 131: | ||
===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 1,084: | Line 1,087: | ||
311 Cust system currency amounts |
311 Cust system currency amounts |
||
321 Supp system currency amounts |
321 Supp system currency amounts |
||
| + | |||
| + | [[Category: ASW: Technical Reference]] |
||
| + | [[Category: ASW Analyzer]] |
||
| + | [[Category: BI Tasks]] |
||
Latest revision as of 14:54, 10 April 2017
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.
Files
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
KESUTA Base or summary level code 3 KEMK01 Mapped statistics key 01 35 KEMK02 Mapped statistics key 02 35 KEMK03 Mapped statistics key 03 35 KEMK04 Mapped statistics key 04 35 KEMK05 Mapped statistics key 05 35 KEMK06 Mapped statistics key 06 35 KEMK07 Mapped statistics key 07 35 KEMK08 Mapped statistics key 08 35 KEMK09 Mapped statistics key 09 35 KEMK10 Mapped statistics key 10 11 KEMK11 Mapped statistics key 11 11 KEMK12 Mapped statistics key 12 11 KEMK13 Mapped statistics key 13 10 KEMK14 Mapped statistics key 14 10 KEMK15 Mapped statistics key 15 10 KEMK16 Mapped statistics key 16 10 KEMK17 Mapped statistics key 17 10 KEMK18 Mapped statistics key 18 10 KEMK19 Mapped statistics key 19 10 KEMK20 Mapped statistics key 20 10 KEMK21 Mapped statistics key 21 10 KEMK22 Mapped statistics key 22 10 KEMK23 Mapped statistics key 23 10 KEMK24 Mapped statistics key 24 12 KEMK25 Mapped statistics key 25 10 KEMK26 Mapped statistics key 26 10 KEMK27 Mapped statistics key 27 4 KEMK28 Mapped statistics key 28 3 KEMK29 Mapped statistics key 29 6 KEMK30 Mapped statistics key 30 6 KEMK31 Mapped statistics key 31 6 KEMK32 Mapped statistics key 32 3 KEMK33 Mapped statistics key 33 8 KEMK34 Mapped statistics key 34 7 KEMK35 Mapped statistics key 35 5 KEMK36 Mapped statistics key 36 5 KEMK37 Mapped statistics key 37 5 KEMK38 Mapped statistics key 38 5 KEMK39 Mapped statistics key 39 5 KEMK40 Mapped statistics key 40 4 KEMK41 Mapped statistics key 41 5 KEMK42 Mapped statistics key 42 3 KEMK43 Mapped statistics key 43 5 KEMK44 Mapped statistics key 44 5 KEMK45 Mapped statistics key 45 5 KEMK46 Mapped statistics key 46 5 KEMK47 Mapped statistics key 47 5 KEMK48 Mapped statistics key 48 5 KEMK49 Mapped statistics key 49 2 KEMK50 Mapped statistics key 50 2 KEMK51 Mapped statistics key 51 5 KEMK52 Mapped statistics key 52 18 KEMK53 Mapped statistics key 53 10 KEMK54 Mapped statistics key 54 5 KEMK55 Mapped statistics key 55 5 KEMK56 Mapped statistics key 56 5 KEMK57 Mapped statistics key 57 3 KEMK58 Mapped statistics key 58 2 KEMK59 Mapped statistics key 59 1 KEMK60 Mapped statistics key 60 4 KEREFK Reference key 13 0
ANOBAL - Balance value file
BASUTA Base or summary level code 3 BAYEAR Year 4 0 BABATP Balance type 3 BAREFK Reference key 13 0 BAPRSQ Period sequence 2 0 BADA01 Debit balance period 1 19 4 BADA02 Debit balance period 2 19 4 BADA03 Debit balance period 3 19 4 BADA04 Debit balance period 4 19 4 BADA05 Debit balance period 5 19 4 BADA06 Debit balance period 6 19 4 BADA07 Debit balance period 7 19 4 BADA08 Debit balance period 8 19 4 BADA09 Debit balance period 9 19 4 BADA10 Debit balance period 10 19 4 BADA11 Debit balance period 11 19 4 BADA12 Debit balance period 12 19 4 BADA13 Debit balance period 13 19 4 BACA01 Credit balance period 1 19 4 BACA02 Credit balance period 2 19 4 BACA03 Credit balance period 3 19 4 BACA04 Credit balance period 4 19 4 BACA05 Credit balance period 5 19 4 BACA06 Credit balance period 6 19 4 BACA07 Credit balance period 7 19 4 BACA08 Credit balance period 8 19 4 BACA09 Credit balance period 9 19 4 BACA10 Credit balance period 10 19 4 BACA11 Credit balance period 11 19 4 BACA12 Credit balance period 12 19 4 BACA13 Credit balance period 13 19 4
ANOBOB - Balance opening balance value file
BOSUTA Base or summary level code 3 BOYEAR Year 4 0 BOBATP Balance type 3 BOREFK Reference key 13 0 BODAOB Debit opening balance value 21 4 BOCAOB Credit opening balance value 21 4
ANOSKD – Statistic key definitions
KDSKNO Statistic key number 3 0 KDSKTP Statistic key type 1 KDSKNM Statistic key name 20 KDHED1 Column heading 1 22 KDHED2 Column heading 2 22 KDSKEP Statistic key edit program name 10 KDSKWN Statistic key window 10 KDSKFN Statistic key FRF name 10 KDMKNO Statistics key mapped to ANOSTK field numb 2 0 KDVARQ Value required Y/N 1 KDTCIP Table controlled interval printing allowed 1
Statistic Keys
This can be found in file ANOSKD.
Key Statistic key name Statistic Map Tbl
no key FRF to int
name prt
100 A/R-A/P group ACGP 28 Y
101 Account part 1 ACP1 2 Y
102 Account part 2 ACP2 3 Y
103 Account part 3 ACP3 4 Y
104 Account part 4 ACP4 5 Y
105 Account part 5 ACP5 6 Y
106 Account part 6 ACP6 7 Y
107 Account part 7 ACP7 8 Y
108 Account part 8 ACP8 9 Y
109 Agreement number AGMT 24 Y
110 Agreement type AGTP 25 Y
111 Area AREA 32 Y
112 Bal/trade acc type STDR 37 Y
113 Contract number CONO 22 N
114 Cost centre CSTS 34 Y
115 Cost model COMO 56 N
116 Country COUN 27 Y
117 Cust/supp acc group AGRN 17 Y
118 Cust/supp group CGRN 16 Y
119 Cust/supp number NUM 10 Y
120 Debit code DEBI 19 Y
121 Debtor number DENO 11 Y
122 Department A2CD 54 N
123 Department section A1CD 55 N
124 Discount group DISG 18 Y
125 Division DIVN 33 Y
126 Document type DOTY 40 Y
127 Element line IONC 57 N
128 Engineer TECN 23 Y
129 Foreman ABVN 52 N
130 Handler HAND 13 Y
131 Item account group PAGR 40 Y
132 Item category 1 PCA1 43 Y
133 Item category 2 PCA2 44 Y
134 Item category 3 PCA3 45 Y
135 Item category 4 PCA4 46 Y
136 Item category 5 PCA5 47 Y
137 Item category 6 PCA6 48 Y
138 Item class PRCL 59 Y
139 Item PRDC 1 Y
140 Item discount group PDGR 39 Y
141 Item family PRFA 36 Y
142 Item group PPGN 38 Y
143 Item object OPRD 9 Y
144 Item price code PCOD 42 Y
145 Item price group PPGR 41 Y
146 Item responsible RESP 15 Y
147 Item sector PRSE 37 Y
148 Item segment 1 IS01 3 N
149 Item segment 2 IS02 4 N
150 Item segment 3 IS03 5 N
151 Item segment 4 IS04 6 N
152 Item segment 5 IS05 7 N
153 Item segment 6 IS06 8 N
154 Item type PTPE 35 Y
155 Main account part ACPM 1 Y
156 MFG order type EGCE 58 N
157 Name category 1 NCA1 29 Y
158 Name category 2 NCA2 30 Y
159 Name category 3 NCA3 31 Y
160 Sales order type ORDT 50 Y
161 Planner PLAN 53 Y
162 Primary currency PCUR 36 Y
163 Primary segment ISPR 2 N
164 Project DWBN 20 N
165 Project phase C7BN 21 N
166 Rep order type POTP 49 Y
167 Salesman SALE 14 Y
168 Statement section SD01 11 Y
169 Group#1 SD02 12 Y
170 Group#2 SD03 13 Y
171 KPMG Stmt section SD04 14 Y
172 Summary identity 05 SD05 15 Y
173 Summary identity 06 SD06 16 Y
174 Summary identity 07 SD07 17 Y
175 Summary identity 08 SD08 18 Y
176 Summary identity 09 SD09 19 Y
177 Summary identity 10 SD10 20 Y
178 Summary identity 11 SD11 21 Y
179 Summary identity 12 SD12 22 Y
180 Summary identity 13 SD13 23 Y
181 Summary identity 14 SD14 24 Y
182 Summary identity 15 SD15 25 Y
183 Summary identity 16 SD16 26 Y
184 Main Supplier SUNO 12 Y
185 Transaction currency TCUR 35 Y
186 Unit UNIT 26 Y
187 Warehouse SROM 28 Y
188 Work centre A3CD 51 N
189 Company code ACOM 58 Y
190 Country of origin OCOU 51 Y
191 Commodity code CSNO 52 Y
192 Cust commission grp CCGR 54 Y
193 Item commission grp PCGR 55 Y
194 Service item group SPGR 56 Y
195 Service code 1 SVC1 14 Y
196 Service code 2 SVC2 53 Y
197 Service code 3 SVC3 54 Y
198 Service code 4 SVC4 55 Y
199 Asset number ANUM 11 Y
200 Asset sequence ANSR 28 N
201 Asset type ASTP 40 Y
202 Asset group ASGR 41 N
203 Asset account group AAGP 42 Y
204 A/C Location 1 LOC1 43 Y
205 A/C Location 2 LOC2 44 Y
206 A/C Location 3 LOC3 45 Y
207 A/C Location 4 LOC4 46 Y
208 A/C Location 5 LOC5 47 Y
209 A/C Location 6 LOC6 48 Y
210 A/C Location 7 LOC7 51 Y
211 A/C Location 8 LOC8 54 Y
212 A/C Responsible RES1 23 Y
213 Asset quality ASQU 58 Y
214 Acquisition type ACTP 30 Y
216 Disposal type DITP 32 Y
217 A/C Project PRJC 52 Y
218 A/C Cost centre ACSC 1 Y
219 Budget/normal asset ENAT 27 Y
220 A/C Transact origin TRCO 57 Y
Sorted by mapped to field
218 A/C Cost centre ACSC 1 Y 155 Main account part ACPM 1 Y 139 Item PRDC 1 Y 163 Primary segment ISPR 2 N 101 Account part 1 ACP1 2 Y 148 Item segment 1 IS01 3 N 102 Account part 2 ACP2 3 Y 149 Item segment 2 IS02 4 N 103 Account part 3 ACP3 4 Y 150 Item segment 3 IS03 5 N 104 Account part 4 ACP4 5 Y 151 Item segment 4 IS04 6 N 105 Account part 5 ACP5 6 Y 152 Item segment 5 IS05 7 N 106 Account part 6 ACP6 7 Y 153 Item segment 6 IS06 8 N 107 Account part 7 ACP7 8 Y 108 Account part 8 ACP8 9 Y 143 Item object OPRD 9 Y 119 Cust/supp number NUM 10 Y 168 Statement section SD01 11 Y 199 Asset number ANUM 11 Y 121 Debtor number DENO 11 Y 169 Group#1 SD02 12 Y 184 Main Supplier SUNO 12 Y 170 Group#2 SD03 13 Y 130 Handler HAND 13 Y 195 Service code 1 SVC1 14 Y 167 Salesman SALE 14 Y 171 KPMG Stmt section SD04 14 Y 172 Summary identity 05 SD05 15 Y 146 Item responsible RESP 15 Y 118 Cust/supp group CGRN 16 Y 173 Summary identity 06 SD06 16 Y 174 Summary identity 07 SD07 17 Y 117 Cust/supp acc group AGRN 17 Y 124 Discount group DISG 18 Y 175 Summary identity 08 SD08 18 Y 176 Summary identity 09 SD09 19 Y 120 Debit code DEBI 19 Y 164 Project DWBN 20 N 177 Summary identity 10 SD10 20 Y 178 Summary identity 11 SD11 21 Y 165 Project phase C7BN 21 N 179 Summary identity 12 SD12 22 Y 113 Contract number CONO 22 N 212 A/C Responsible RES1 23 Y 128 Engineer TECN 23 Y 180 Summary identity 13 SD13 23 Y 109 Agreement number AGMT 24 Y 181 Summary identity 14 SD14 24 Y 182 Summary identity 15 SD15 25 Y 110 Agreement type AGTP 25 Y 183 Summary identity 16 SD16 26 Y 186 Unit UNIT 26 Y 219 Budget/normal asset ENAT 27 Y 116 Country COUN 27 Y 200 Asset sequence ANSR 28 N 187 Warehouse SROM 28 Y 100 A/R-A/P group ACGP 28 Y 157 Name category 1 NCA1 29 Y 214 Acquisition type ACTP 30 Y 158 Name category 2 NCA2 30 Y 159 Name category 3 NCA3 31 Y 216 Disposal type DITP 32 Y 111 Area AREA 32 Y 125 Division DIVN 33 Y 114 Cost centre CSTS 34 Y 185 Transaction currency TCUR 35 Y 154 Item type PTPE 35 Y 141 Item family PRFA 36 Y 162 Primary currency PCUR 36 Y 147 Item sector PRSE 37 Y 112 Bal/trade acc type STDR 37 Y 142 Item group PPGN 38 Y 140 Item discount group PDGR 39 Y 131 Item account group PAGR 40 Y 126 Document type DOTY 40 Y 201 Asset type ASTP 40 Y 202 Asset group ASGR 41 N 145 Item price group PPGR 41 Y 144 Item price code PCOD 42 Y 203 Asset account group AAGP 42 Y 204 A/C Location 1 LOC1 43 Y 132 Item category 1 PCA1 43 Y 133 Item category 2 PCA2 44 Y 205 A/C Location 2 LOC2 44 Y 206 A/C Location 3 LOC3 45 Y 134 Item category 3 PCA3 45 Y 135 Item category 4 PCA4 46 Y 207 A/C Location 4 LOC4 46 Y 208 A/C Location 5 LOC5 47 Y 136 Item category 5 PCA5 47 Y 137 Item category 6 PCA6 48 Y 209 A/C Location 6 LOC6 48 Y 166 Rep order type POTP 49 Y 160 Sales order type ORDT 50 Y 210 A/C Location 7 LOC7 51 Y 188 Work centre A3CD 51 N 190 Country of origin OCOU 51 Y 217 A/C Project PRJC 52 Y 191 Commodity code CSNO 52 Y 129 Foreman ABVN 52 N 161 Planner PLAN 53 Y 196 Service code 2 SVC2 53 Y 211 A/C Location 8 LOC8 54 Y 197 Service code 3 SVC3 54 Y 122 Department A2CD 54 N 192 Cust commission grp CCGR 54 Y 193 Item commission grp PCGR 55 Y 198 Service code 4 SVC4 55 Y 123 Department section A1CD 55 N 194 Service item group SPGR 56 Y 115 Cost model COMO 56 N 220 A/C Transact origin TRCO 57 Y 127 Element line IONC 57 N 156 MFG order type EGCE 58 N 189 Company code ACOM 58 Y 138 Item class PRCL 59 Y
Fields
SUTA - Base or summary level code
Describes the key fields. Part of link between ANOSTK and ANOBAL / ANOBOB
Base Levels (pre defined) A01 Sales order statistics A02 Purchase/work order statistics A03 Sales fee statistics A04 Warehouse statistics A11 G/L transactions A12 G/L transactions with transaction currency A13 A/R & A/P combined with G/L transactions A31 A/C (asset) transactions A32 A/C combined with G/L transactions
Summary Levels (user defined)
Accounting
001 Main, group, sub group, cost centre, project
002 Main, group, sub group, cost centre
003 Main, group, subgroup
004 Main, group
005 Main
006 Main, group #1, group #2
007 Main, group #1
008 Main, group #2
009 Main, cost centre, cub group, group #1, group #2
010 Cost centre summary identity group 1
011 Cost centre summary identity group 1, first two characters of main, main
012 first two characters of main, main
013 Main, cost centre
014 KPMG section, cost centre, main
Sales
100 Item group, item number
110 Item group, supplier
111 customer, item account group
113 Customer, item group
114 main supplier, item category 1, item
115 name category 3, customer, item category 1
117 item
905 Detail sales summary for weeks onhand
BATP - Balance type
Describes the values that are kept. On ANOBAL, ANOBUD, and ANOBOB.
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 081 Average tied-up capital cost 082 Average tied-up capital 301 System currency amounts 303 Transaction currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 340 Acquisition value, existing assets 341 Depreciation value, seq 1, existing 350 Acquisition value, disposed asssets 351 Depreciation value, seq 1, disposed 360 Disposal value 361 Profit/loss value, main depr type 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
System Base Levels
These are accumulated from transactions; like SROISDPL, SRODTA, and SROLTA.
Level A01 Sales order statistics
KEMK01 – item number
KEMK02 – primary segment
KEMK10 – customer number
KEMK11 – debtor number
KEMK12 – supplier number
KEMK13 – order entered by
KEMK14 – salesman
KEMK15 – item responsible (not populated as field was blank in
SROISDPL. Started populating 14Aug2013)
KEMK16 – customer group
KEMK17 – name account group
KEMK20 – project
KEMK21 – project phase
KEMK22 – contract number
KEMK26 – item unit of measure
KEMK27 – country
KEMK28 – warehouse
KEMK29 – customer category 1
KEMK30 – customer category 2
KEMK31 – customer category 3
KEMK32 – customer area
KEMK38 – item group
KEMK40 – item account group
KEMK42 – item price code
KEMK43 – item category 1 (class)
KEMK44 – item category 2 (brand)
KEMK45 – item category 3
KEMK46 – item category 4 (returnable?)
KEMK47 – item category 5
KEMK48 – item category 6
KEMK50 – sales order type
KEMK59 – item class
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost
Level A02 Purchase/work order statistics
KEMK01 – item number KEMK02 – item number KEMK10 – supplier number KEMK12 – supplier number KEMK13 – buyer KEMK15 – buyer KEMK16 – supplier category 1 KEMK17 – item account group KEMK20 – zeros? KEMK21 – zeros? KEMK22 – zeros? KEMK26 – item unit of measure KEMK27 – country KEMK28 – warehouse KEMK29 – supplier category 1 KEMK31 – supplier category 3 KEMK32 – supplier area KEMK38 – item group KEMK40 – item account group KEMK42 – ‘260’ cost source? KEMK43 – item category 1 (class) KEMK44 – item category 2 (brand) KEMK46 – item category 4 (returnable?) KEMK49 – purchase order type KEMK53 – buyer KEMK59 – 1=debit 2=credit
Balance Types -
021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity
Level A03 Sales fees statistics
KEMK10 – customer number KEMK11 – customer number KEMK13 – order handler KEMK14 – salesman KEMK16 – customer category 1 KEMK17 – item account group KEMK27 – country KEMK28 – warehouse KEMK29 – customer category 1 KEMK30 – customer category 2 KEMK31 – customer category 3 KEMK32 – customer area KEMK50 – sales order type
Balance Types -
066 Sales order cost
Level A04 Warehouse statistics
KEMK01 – item number KEMK28 – warehouse KEMK38 – item group KEMK40 – item account group KEMK43 – item category 1 (class) KEMK44 – item category 2 (brand) KEMK46 – item category 4 (returnable?) KEMK59 – 1=debit 2=credit
Balance Types -
081 Average tied-up capital cost 082 Average tied-up capital
Level A11 G/L transactions
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 1 (main) KEMK03 – G/L part 2 (group) KEMK04 – G/L part 3 (sub group) KEMK05 – G/L part 4 (cost centre) KEMK06 – G/L part 5 (project) KEMK11 – two digit G/L KEMK12 – group# 1 KEMK13 – group# 2 KEMK14 – KPMG statement section
Balance Types -
301 System currency amounts
Level A12 G/L transactions with TCUR
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 1 (main) KEMK03 – G/L part 2 (group) KEMK04 – G/L part 3 (sub group) KEMK05 – G/L part 4 (cost centre) KEMK06 – G/L part 5 (project) KEMK11 – two digit G/L KEMK12 – group# 1 KEMK13 – group# 2 KEMK14 – KPMG statement section KEMK35 – currency
Balance Types -
303 Transaction currency amounts
Level A13 A/R-A/P combined with G/L transactions
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 1 (main) KEMK10 – customer number KEMK27 – country KEMK28 – ‘01’ ‘04’ ? KEMK37 – ‘B’ ? KEMK40 – document type
Balance Types -
311 Cust system currency amounts 321 Supp system currency amounts
Level A31 A/C transactions (assets)
KEMK01 – G/L part 4 (cost centre) KEMK11 – asset number KEMK23 – asset owner KEMK27 – ‘N’ KEMK28 – ‘000’ KEMK30 – ‘OA’ KEMK40 – ‘BUI’ KEMK41 – ‘B-1’ KEMK42 – ‘B-1’ KEMK43 – ‘NN’ KEMK57 – ‘002’ KEMK58 – ‘1’
Balance Types -
340 Acquisition value, existing assets 341 Depreciation value, seq 1, existing 350 Acquisition value, disposed asssets 351 Depreciation value, seq 1, disposed 360 Disposal value 361 Profit/loss value, main depr type
Level A32 A/C combined with G/L transactions (assets)
KEMK02 – G/L part 1 (main) KEMK11 – asset number KEMK28 – ‘000’ KEMK30 – ‘OA’ KEMK37 – ‘B’ KEMK40 – ‘BUI’ KEMK41 – ‘B-1’ KEMK57 – ‘002’
Balance Types –
370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Summary Levels
These are accumulations of base levels; depending on the keys used.
Level 001 Main,Grou,Subg,Cost,Pro
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 2 (group) KEMK03 – G/L part 3 (sub group) KEMK04 – G/L part 4 (cost centre) KEMK05 – G/L part 5 (project)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 002 Main,Grou,Subg,Cost
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 2 (group) KEMK03 – G/L part 3 (sub group) KEMK04 – G/L part 4 (cost centre)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 003 Main,Grou,Subg
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 2 (group) KEMK03 – G/L part 3 (sub group)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 004 Main,Grou
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 2 (group)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 005 Main
KEMK01 – G/L part 1 (Main)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 006 Main, group#1, group#2
KEMK01 – G/L part 1 (Main) KEMK02 – Cost centre group 2 KEMK03 – Cost centre group 1
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 007 Main, group#1
KEMK01 – G/L part 1 (Main) KEMK02 – Cost centre group 1
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 008 Main, group#2
KEMK01 – G/L part 1 (Main) KEMK02 – Cost centre group 2
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 009 Main, cost, subg, Grp1, Grp2
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 3 (sub group) KEMK03 – G/L part 4 (cost) KEMK04 – Cost centre group 1 KEMK05 – Cost centre group 2
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 380 Disposal value G/L 381 Profit/loss value G/L, main depr type
Level 010 B/S Summary Level Balances
KEMK01 – Cost centre group 1
Balance Types -
301 System currency amounts 370 Acquisition value G/L 371 Depreciation value G/L, seq 1
Level 011 B/S Drill Down
KEMK01 – Cost centre group 1 KEMK02 – 2 digit G/L KEMK03 – G/L part 1 (main)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 012 O/S Row Number by Main
KEMK01 – 2 digit G/L KEMK02 – G/L part 1 (main)
Balance Types -
301 System currency amounts 311 Cust system currency amounts 321 Supp system currency amounts 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 013 Main, cost ctr
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 4 (cost centre)
Balance Types -
301 System currency amounts 321 Supp system currency amounts 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 014 KPMG,Cost ctr,main
KEMK01 – G/L part 1 (Main) KEMK02 – G/L part 4 (cost centre) KEMK03 – KPMG statement section
Balance Types -
301 System currency amounts 321 Supp system currency amounts 380 Disposal value G/L 381 Profit/loss value G/L, main depr ty
Level 100 ITEM GROUP / ITEM CODE
KEMK01 – item group KEMK02 – item number
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 081 Average tied-up capital cost 082 Average tied-up capital
Level 110 Item Group/Supplier
KEMK01 – item group KEMK02 – main supplier number KEMK03 – item number
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 081 Average tied-up capital cost 082 Average tied-up capital
Level 111 CUSTOMER/ITEM ACCOUNT GROUP
KEMK01 – customer number KEMK02 – item account group (or blank)
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 081 Average tied-up capital cost 082 Average tied-up capital 311 Cust system currency amounts 321 Supp system currency amounts
Level 112 MAIN SUPP,NCAT1,NCAT3
KEMK01 – main supplier number KEMK02 – sold to customer category 1 KEMK03 – sold to customer category 3
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 311 Cust system currency amounts
Level 113 CUSTOMER,ITEM CLASS(GROUP)
KEMK01 – customer number KEMK02 – item group
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 081 Average tied-up capital cost 082 Average tied-up capital 311 Cust system currency amounts 321 Supp system currency amounts
Level 114 MAIN SUPPLIER,ITEM CAT1,ITEM
KEMK01 – main supplier number KEMK02 – item category 1 (class) KEMK03 – item number
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 081 Average tied-up capital cost 082 Average tied-up capital 311 Cust system currency amounts
Level 115 NAME CAT3,CUST,ITEM CAT1
KEMK01 – customer number KEMK02 – item category 1 (class) KEMK03 – customer category 3 (banner)
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 081 Average tied-up capital cost 082 Average tied-up capital 311 Cust system currency amounts 321 Supp system currency amounts
Level 116 ITEM CAT 1/CUSTOMER
KEMK01 – customer number KEMK02 – item category 1 (class) or blank
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost
Level 117 ITEM
KEMK01 – item number
Balance Types -
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 081 Average tied-up capital cost 082 Average tied-up capital
Level 905 – Detail Sales Summary for Weeks Onhand
KEMK01 – Item KEMK02 – Item account group KEMK03 – Item group KEMK04 – Item category 1 KEMK05 – Item category 2 KEMK07 – Item responsible KEMK08 – Main Supplier KEMK09 – Warehouse
Balance Types –
001 Sales net value 002 Sales gross value 003 Sales cost value 004 Sales quantity 009 Sales order line cost 021 Purchase net value 022 Purchase gross value 023 Purchase cost value 024 Purchase quantity 066 Sales order cost 081 Average tied-up capital cost 082 Average tied-up capital 311 Cust system currency amounts 321 Supp system currency amounts