Overview of balance structure in DC1

Related topics

Balances are any accumulated values on period level which are updated and stored in the Balance file according to the combination Balance type/Statistic key/Period. In most companies, a thorough knowledge of the underlying cost structure is essential. The balance structure in DC1 provides good management of information and allows easy extraction and utilisation of this information.

All balances can be retrieved and used/viewed in the following:

• Reports you create via the Profitability Analysis tool.
• Reports you create via DC1 Report Writer.
• Analysed via the Balances and transactions enquiry.

You define, in various files/tables in DC1, what the different values (i.e. costs, quantities, etc.) should be for a specific transaction/event (e.g. Sales order line cost, Purchase order cost, Quotation cost, Resolution cost, Warehouse handling costs, etc). During the actual transaction event (i.e. invoicing, reception, etc.) the values are also updated for the balance types. Note: If you are using the Group reporting feature, the values are also updated in the reporting companies’ statistic and balance files.

Balance groups

Balance groups simplify the implementation of the Balance structure in DC1. Several are preloaded at installation. These groups have been logically categorised according to the application and/or module in which balances are generated.

Balance groups are connected to the following information:

• The Base level that holds the valid pre-defined System statistic key.
• Balance types. One or more base levels can be connected to a balance group via a Balance type.

Base level

Base levels are the detail level where all necessary keys for one transaction file are stored. They are connected to the Balance types and Statistic keys. Note: Statistic key 189 (Originating company) MUST exist on all base levels, even if you are not using the Group reporting feature.

Balance types

Balance types are things which hold a balance value (e.g., quantity, amount, asset, etc.) and consist of the following:

System balance types

There are 400 reserved System balance types. A number of them are pre-loaded at installation. These balance types are connected to the valid pre-defined System statistic keys (via the Base level). These System balance types are grouped together into logical, pre-defined Balance groups.

Distributed balance types

You can manually create up to 400 Distributed Balance types and retrieve values and keys from existing balance types to distribute across the Distributed Balance type. Note: A Distributed Balance type can be distributed across both System Balance types and Custom Balance types.

Custom balance types

In the event of customer modifications, you can manually create up to 200 Custom balance types. You can use these balance types to, for example, accumulate values from any external system (e.g., payroll, marketing system).

Statistic keys

System statistic keys

The Keys that can be used on which to select and sort data are defined in the System statistic key definitions table. This table is preloaded at installation with a number of keys. (Every Balance type is connected to a Base level which defines and holds the keys applicable for the balance type.)

How values are updated in the Balance file

Whenever a transaction occurs in the system which carries a cost, quantity, etc., the value is updated in the applicable “Transaction file” during the applicable event (e.g., Sales order cost is updated during invoicing, Purchase order cost is updated during reception, etc). The update of these cost values into the Balance file must be done manually in some cases; but others can be updated automatically as described below.

1. The cost values for the balances types which are connected to the following Balance groups must be manually updated via the Start periodical balance update:
• ATC = Average tied-up capital
• QTC = Quotation costs
• WHC = Warehousing costs
• HLC = Request and Return costs
2. The SMS rebate claim statistic must be updated manually into the Balance file via the Transfer SMS rebate claim statistic program (menu SMSPER). This will transfer the SMS rebate claim statistic from the detailed statistic stored in files SRORBT (SMS rebate transactions) and SRORBTC (SMS credit rebate claim transactions) to the balance file ANOBAL for balance group SMSSTS.

   Note: It will only transfer SMS rebate transaction records (from file SRORBT) that have Rebate trans status = C (i.e. claimed) and SMS credit rebate claim transaction records (from file SRORBTC) that have been finalised (i.e. invoiced for claim method A/R or transferred to A/P for claim method A/P). During the transfer a flag on the originating records in file SRORBT and SRORBTC will be set to Transfer to Report Generator = Y. This is to control that these records are only transferred once to the balance file.

3. The Customer/Supplier rebate statistics must be updated manually into the Balance file via the Transfer customer rebate statistics or Transfer supplier rebate statistics programs (menu RBTPER). This will transfer the customer/supplier rebate statistics from the detailed statistic stored in files SRORTSLF (Rebate transactions, statistical log file) to the balance file ANOBAL for balance groups RBTCUSTSTS/RBTSUPPSTS.

   Note: During the transfer a flag on the originating records in file SRORTSLF will be set to Transfer to Report Generator = Y. This is to control that these records are only transferred once to the balance file.

4. All other costs for the remaining Balance types/Balance groups are automatically updated from the applicable “Transaction file”, via a built-in interface. See (BIW) Sample update from Invoice File and (BIW) Sample update from G/L Transaction File for an explanation of the update.

System balance types

The following system balance types are preloaded and logically grouped into Balance groups holding the base levels and pre-defined System Statistic keys. Note: When applicable, the calculation of the value for the Balance type is given.

Sales balances

Balance group: SSTS
Base level: A01
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
001	Sales net value	N/A	Originating company Item Unit Rep order type Primary segment Country Sales order type Item segment 1-6 Warehouse Country of origin Cust/supp number Business partner category 1-6 Commodity code Debtor number Area Cust commission grp Supplier number Division Item commission group Handler Route Serial number Holding company Parent company Shipping agent Destination Cost centre Service item group Salesman Item type Item class Item responsible Item family Cust/supp group Item sector Cust/supp acc group Item group Discount group Item discount group Project Item account group Project phase Item price group Contract number Item category 1-6 Project cost code 1 -2 Delivery type Invoicing type External request code Internal request code Resolution code Action code Volume value code Movability code Promotion/Price/Disc
002	Sales gross value	Sales price * Invoiced quantity Sales unit
003	Sales cost value	Quantity * Cost price
004	Sales quantity	N/A
005	Sales net weight	Invoiced Quantity Sales Unit * Net weight
006	Sales gross weight	Invoiced Quantity Sales Unit * Gross weight
007	Sales net volume	Invoiced Quantity Sales Unit * Net volume
008	Sales gross volume	Invoiced Quantity Sales Unit * Gross volume
009	Sales order line cost	Sales order line cost * Order line cost factor
041	Margin cost value basis	N/A
042	Standard net purchase price cost value	Invoiced Quantity * (Standard purchase price / Conversion factor of cost unit)
043	Standard cost value	Invoiced Quantity * (Standard cost / Conversion factor of cost unit)
044	Standard cost sales value	Invoiced Quantity * (Standard cost / Conversion factor of cost unit)
091	Number of sales order lines	There is a counter of +1. This means that the result is equivalent to the number of order lines.
092	Number of return sales order lines	Same as 091 above.
093	Number of sales order lines delayed	Dispatch date – Requested dispatch date
094	Number of days delayed, sales order lines	Same as 091 above
095	Number of sales order lines delayed, promised	Same as 091 above
096	Number of days delayed, sales order lines, promised	Dispatch date – Promised dispatch date
097	Number of sales order lines, back ordered	Same as 091 above
098	Sales order fulfilment lead time	(Order Date – Dispatch Date) * Quantity
281	Number of sales orders	There is a counter of +1. This means that the result is equivalent to the number of sales orders.
282	Number of credit notes	Same as 281 above
283	Number of transport notes	Same as 281 above
284	Number of invoices	Same as 281 above
285	Number of incidents	Same as 281 above

IRO sales balances

Balance group: IROSSTS
Base level: A01
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
011	IRO sales net value	N/A	Same as Sales balances
012	IRO sales gross value	Sales price * Invoiced quantity Sales unit
013	IRO sales cost value	Quantity * Cost price
014	IRO sales quantity	N/A
015	IRO sales net weight	Invoiced Quantity Sales unit * Net weight
016	IRO sales gross weight	Invoiced Quantity Sales unit * Gross weight
017	IRO sales net volume	Invoiced Quantity Sales unit * Net volume
018	IRO sales gross volume	Invoiced Quantity Sales unit * Gross volume
019	IRO sales order line cost	Sales order line cost * Order line cost factor
045	IRO margin cost value basis	N/A
046	IRO standard net purchase price cost value	Invoiced Quantity * (Standard purchase price / Conversion factor of cost unit)
047	IRO standard cost value	Invoiced Quantity * (Standard cost / Conversion factor of cost unit)
048	IRO standard cost sales value	Invoiced Quantity * (Standard cost / Conversion factor of cost unit)

Purchase balances

Balance group: PSTS
Base level: A02
Balance type	Description	Calculation of value for balance type	Valid statistics keys for all
021	Purchase net value	N/A	Originating company Item Business partner category 1-6 Commodity code Primary segment Area Planner Item segment 1-6 Division Item class Cust/supp number Cost centre Supplier number Item type Handler Item family Item responsible Item sector Cust/supp group Item group Cust/supp acc group Item discount group Project Item account group Project phase Item price group Contract number Item price code Unit Item category 1-6 Country Rep order type Warehouse Country of origin Unit Holding company Parent company Delivery type
022	Purchase gross value	Purchase price * Received quantity Purchase unit
023	Purchase cost value	Quantity * Cost price
024	Purchase quantity	N/A
025	Purchase net weight	Received Quantity Purchase Unit * Net weight
026	Purchase gross weight	Received Quantity Purchase Unit * Gross weight
027	Purchase net volume	Received Quantity Purchase Unit * Net volume
028	Purchase gross volume	Received Quantity Purchase Unit * Gross volume
101	Number of purchase order lines	Purchase order line cost * Order line cost factor
102	Number of return purchase order lines	There is a counter of +1. This means that the result is equivalent to the number of order lines.
103	Number of purchase order lines delayed	Same as 102 above.
104	Number of days, delayed purchase order lines	Dispatch Date – Requested Dispatch Date
105	Quantity control, approved quantity	Same as 102 above.
106	Quantity control, rejected quantity	Received Quantity – Approved Quantity
107	Number of purchase order lines delayed, promised	Same as 102 above
108	Number of days delayed, purchase order lines, promised	Dispatch Date – Confirmation Date
109	Purchase order fulfilment lead time	(Order Date – Arrival Date) * Quantity
286	Number of purchase orders	There is a counter of +1. This means that the result is equivalent to the number of purchase orders.
287	Number of purchase credit notes	Same as 286 above

IRO purchase balances

Balance group: IROPSTS
Base level: A02
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
031	IRO Purchase net value	N/A	Same as Purchase balances except for Delivery type which does not apply.
032	IRO Purchase gross value	Purchase price * Received quantity Purchase unit
033	IRO Purchase cost value	Quantity * Cost price
034	IRO Purchase quantity	N/A
035	IRO Purchase net weight	Received quantity Purchase unit * Net weight
036	IRO Purchase gross weight	Received quantity Purchase unit * Gross weight
037	IRO Purchase net volume	Received quantity Purchase unit * Net volume
038	IRO Purchase gross volume	Received quantity Purchase unit * Gross volume

Sales fees balances

Balance group: SFEES
Base level: A03
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
061	Invoice fee	N/A	Originating company Cust/supp number Debtor number Handler Salesman Cust/supp group Cust/supp acc group Discount group Country Business partner category 1-6 Area Sales order type Invoicing type
062	Postage fee	N/A
063	Insurance fee	N/A
064	Administration fee	N/A
065	Freight fee	N/A
066	Sales order cost	N/A
067	Cash sales, fee 1	N/A
068	Cash sales, fee 2	N/A
069	Cash sales, fee 3

IRO sales fees balances

Balance group: IROSFEES
Base level: A03
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
071	IRO Invoice fee	N/A	Same as Sales fees balances
072	IRO Postage fee	N/A
073	IRO Insurance fee	N/A
074	IRO Administration fee	N/A
075	IRO Freight fee	N/A
076	IRO Sales order cost	N/A

Average tied-up capital

Balance group: ATC
Base level: A04
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
081	Average tied-up cost	OLD PERIOD = UPDATE (Cost Price * (Quantity Period / Days)) * (Annual Rate / Normal Number of Periods) OR NEW PERIOD = ADD (Cost Price * Quantity On Hand) * (Annual Rate / 100)	Originating company Item Cust/supp number Country Warehouse Item group Item account group Item category 1-6 Item class
082	Average tied-up capital	OLD PERIOD = UPDATE Cost Price * (Quantity Period / Days) OR NEW PERIOD = ADD Cost Price * Quantity On Hand

Quotation costs

Balance group: QTC
Base level: A01
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
083	Quotation cost	Quotation Line Cost	Same as Sales Balances

Request and Return costs

Balance group: HLC
Base level: A01
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
084	Request cost	(Resolution Cost + (Cost per Hour * Total Acc Hours)) / Number of Lines	Same as Sales balances

Warehousing costs

Balance group: WHC
Base level: A04
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
111	Stock handling cost	ALL WAREHOUSING COSTS: It is defined in the Inventory transaction type table which code to use Calculation code 1 Stock Transaction Cost Calculation code 2 Cost Value of Inventory Transaction * -1 (is reversed) Calculation code 3 (Cost Value of Inventory Transaction * -1) + Stock Transaction Cost	Same as Average tied-up capital
112	Damage goods cost
113	Theft/lost goods cost
114	Internal use cost
115	Miscellaneous warehouse cost
116	Sales samples cost
117	Expired / obsolete items cost
118	Write off depreciation cost
119	Gain/loss returned goods cost
120	Rejected from production cost

Manufacturing balances

Balance group: MSTS
Base level: A06
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
151	Manufacturing, quantity ordered	N/A	Originating company Department section Item account group Item category 1 – 6 Item class Item Item family Item group Item responsible Item sector Item segment 1 – 6 Item type MFG order type Planner Primary segment Warehouse
152	Manufacturing, quantity reported	N/A
153	Manufacturing, quantity scrapped	N/A
154	Manufacturing, Pc. Total amount	N/A
155	Manufacturing, Cc. Total amount	N/A
156	Manufacturing, Pc. Material amount	N/A
157	Manufacturing, Cc. Material amount	N/A
158	Manufacturing, Pc. Operation amount	N/A
159	Manufacturing, Cc. Operation amount	N/A
160	Manufacturing, Pc. Run and labour time	N/A
161	Manufacturing, Cc. Run and labour time	N/A
162	Manufacturing, Pc. Machine time	N/A
163	Manufacturing, Cc. Machine time	N/A
164	Manufacturing, Pc. Set-up time internal	N/A
165	Manufacturing, Cc. Set-up time internal	N/A
166	Manufacturing, Pc. Set-up time external	N/A
167	Manufacturing, Cc. Set-up time external	N/A
168	Number of manufacturing orders	There is a counter of +1. This means that the result is equivalent to the number of manufacturing orders.
169	Number of manufacturing orders delayed, start	Same as 168, for orders where actual start > planned start
170	Number of days delayed, manufacturing orders, start	Actual start date – Planned start date
171	Number of manufacturing orders delayed, completion	Same as 168, for orders where actual compl > planned compl
172	Number of days delayed, manufacturing orders, completion	Actual completion date – Planned completion date

Routing balances

Balance group: RSTS
Base level: A07
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
181	Routing, quantity approved	N/A	Originating company Department Department section Foreman Item account group Item category 1 – 6 Item class Item Item family Item group Item responsible Item sector Item segment 1 – 6 Item type MFG order type Planner Primary segment Warehouse Work centre
182	Routing, quantity scrapped	N/A
183	Routing, Pc. Amount	N/A
184	Routing, Cc. Amount	N/A
185	Routing, Pc. Run and labour time	N/A
186	Routing, Cc. Run and labour time	N/A
187	Routing, Pc. Machine time	N/A
188	Routing, Cc. Machine time	N/A
189	Routing, Pc. Set-up time internal	N/A
190	Routing, Cc. Set-up time internal	N/A
191	Routing, Pc. Set-up time external	N/A
192	Routing, Cc. Set-up time external	N/A
193	Number of manufacturing order operations	There is a counter of +1. This means that the result is equivalent to the number of manufacturing order operations.
194	Number of manufacturing order operations delayed, start	Same as 193, for operations where actual start > planned start
195	Number of days delayed, manufacturing order operations, start	Actual start date – Planned start date
196	Number of manufacturing order operations delayed, completion	Same as 193, for operations where actual compl > planned compl
197	Number of days delayed, manufacturing order operations, completion	Actual completion date – Planned completion date

Project costs balances

Balance group: PRJC
Base level: A08
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
121	Project reported quantity	N/A	Item Primary segment Item segment 1-6 Project phase item Debtor number Supplier number Handler Salesman Item responsible Cust/supp group Cust/supp acc group Discount group Project Project phase Unit Country Warehouse Business partner category 1-6 Area Division Cost centre Item type Item family Item sector Item group Item discount group Item account group Item price group Item category 1-6 Project element type Project type Country of origin Commodity code Customer commission group Item commission group Service item group Project cost code 1-2 Item class Originating company
122	Project planned cost amount	N/A
123	Project actual cost amount	N/A

Sales and Operation Plan statistics balances

Balance group: SOP
Base level: A09
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
125	SOP Budget sales value	N/A	SOP Summary level Item family Item sector Item group Department section Originating company SOP unit
126	SOP Budget production value	N/A
127	SOP Inflow quantity	N/A
128	SOP Inflow hours	N/A
129	SOP Inflow cost price	N/A
130	SOP Inflow user value	N/A
131	SOP Order stock quantity	N/A
132	SOP Order stock hours	N/A
133	SOP Order stock cost price	N/A
134	SOP Order stock user value	N/A
135	SOP Dispatch quantity	N/A
136	SOP Dispatch hours	N/A
137	SOP Dispatch cost price	N/A
138	SOP Dispatch user value	N/A
139	SOP Warehouse quantity	N/A
140	SOP Warehouse hours	N/A
141	SOP Warehouse cost price	N/A
142	SOP Warehouse user value	N/A
143	SOP Production quantity	N/A
144	SOP Production hours	N/A
145	SOP Production cost price	N/A
146	SOP Production user value	N/A
147	SOP Work days	N/A
148	SOP Actual work hours	N/A
175	SOP Inflow sales price	N/A
176	SOP Order stock sales price	N/A
177	SOP Dispatch sales price	N/A
178	SOP Warehouse sales price	N/A
179	SOP Production sales price	N/A

Service balances

Balance group: SVCSTS
Base level: A05
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
201	Service total external net value	N/A	Originating company Item Item discount group Primary segment Item account group Item segment 1-6 Item price group Item object Item price code Cust/supp number Item category 1-6 Debtor number Rep order type Supplier number Sales order type Handler Country of origin Salesman Commodity code Item responsible Cust commission grp Serial number Holding company Parent company Object serial number Cust/supp group Item comm grp Cust/supp acc group Service item group Discount group Item class Debit code Project Project phase Contract number Engineer Agreement nbr/type Unit Country Warehouse Business partner category 1-6 Area/Division Cost centre Item type/family Item sector/group Invoicing type External request code Internal request code Resolution code Action code
202	Service total external gross value	Sales price * Invoiced quantity Sales unit
203	Service total external cost value	Actual Quantity in Stock Unit * Cost price
204	Service total external quantity	N/A
205	Service total external net weight	Invoiced quantity Sales unit * Net weight
206	Service total external gross weight	Invoiced quantity Sales unit * Gross weight
207	Service total external net volume	Invoiced quantity Sales unit * Net volume
208	Service total external gross volume	Invoiced quantity Sales unit * Gross volume
209	Service order line cost	Service Order Line Cost * Order Line Cost Factor
211	Service current account external net value	N/A
212	Service current account external gross value	Sales price * Invoiced quantity Sales unit
213	Service current account external cost value	Actual Quantity in Stock Unit * Cost price
214	Service current account external quantity	N/A
221	Service fixed external net value	N/A
222	Service fixed external gross value	Sales price * Invoiced quantity Sales unit
223	Service fixed external cost value	Actual Quantity in Stock Unit * Cost price
224	Service fixed external quantity	N/A
225	Service fixed external net as current value	Actual quantity in Sales unit * Sales price
231	Service recommended external net value	N/A
232	Service recommended external gross value	Sales price * Invoiced quantity Sales unit
233	Service recommended external cost value	Actual Quantity in Stock Unit * Cost price
234	Service recommended external quantity	N/A
235	Service recommended external net as current value	Recommended quantity in Sales unit * Sales price
241	Service internal net value	N/A
242	Service internal gross value	Sales price * Invoiced quantity Sales unit
243	Service internal cost value	Actual Quantity in Stock Unit * Cost price
244	Service internal quantity	N/A
245	SVC margin cost value basis	N/A	246	SVC standard net purchase price cost value	Actual Quantity * (Standard purchase price / Conversion factor of cost unit)	247	SVC standard cost value	Actual Quantity * (Standard cost / Conversion factor of cost unit)	248	SVC standard cost sales value	Actual Quantity * (Standard cost / Conversion factor of cost unit)
251	Service agreement net value	N/A
252	Service agreement gross value	Sales price * Invoiced quantity Sales unit
253	Service agreement cost of sales value	Quantity * Cost price
254	Service agreement fee value	N/A

Order received statistics

Balance group: OSTS
Base level: A10
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
261	Order received net value	N/A	Originating company Item Unit Country Replenishment order type Primary segment Sales order type Item segment 1-6 Warehouse Country of origin Cust/supp number Business partner category 1-6 Commodity code Debtor number Area Cust commission grp Supplier number Division Item commission group Handler Cost centre Salesman Item type Item class Item responsible Item family Cust/supp group Item sector Cust/supp acc group Item group Discount group Item discount group Project Item account group Project phase Project cost code 1 – 2 Item price group Item price code Contract number Serial number Holding company Parent company Item category 1-6 Route Destination Shipping agent External request code Internal request code Resolution code Action code
262	Order received gross value	Sales price * Order quantity Sales unit
263	Order received quantity	N/A

SMS rebate claim statistics

Balance group: SMSSTS
Base level: A22
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
271	SMS rebate amount	N/A	SMS agreement type Reb payer/receiver Item Primary segment Item segment 1-6 Item object Business partner Debtor number Supplier number Handler Salesman Item responsible Cust/supp group Cust/supp acc group Discount group Route Project Project phase Contract number Destination Shipping agent Unit Country Warehouse Business partner category 1-6 Area Cost centre Division Item type Item family Item sector Item group Item discount group Item account group Item price group Item price code Item category 1-6 Replenishment order type Sales order type Country of origin Commodity code Cust commission grp Item commission group Project cost code 1 – 2 Item class Originating company Serial number Holding company Parent company Object serial number
272	SMS rebate quantity	N/A

Stock balances

Balance group: STKBAL
Base level: A23
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
390	Inventory contract stock quantity	N/A	Item Handler Warehouse Stock acc trans type Bal/trade acc type Item group Item account group Originating company Cost centre
391	Normal stock quantity	N/A
392	Transit stock quantity	N/A
393	Goods in transfer stock quantity	N/A
394	Non-conforming stock quantity	N/A
395	Normal stock amount	Cost value of inventory transaction
396	Transit stock amount	Same as above
397	Goods in transfer stock amount	Same as above
398	Non-conforming stock amount	Same as above
399	Inventory contract stock amount	Same as above

Customer rebate balances

Balance group: RBTCUSTSTS
Base level: A25
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
278	Customer rebate amount	N/A	Rebate agreement group Rebate agreement Reb payer/receiver Item Primary segment Item segment 1-6 Item object Cust/Supp number Debtor number Supplier number Handler Salesman Item responsible Cust/supp group Cust/supp acc group Discount group Route Project Project phase Contract number Destination Shipping agent Promotion/Price/Disc Unit Country Warehouse Business partner category 1-6 Area Cost centre Division Item type Item family Item sector Item group Item discount group Item account group Item price group Item price code Item category 1-6 Replenishment order type Sales order type Country of origin Commodity code Movability code Cust commission grp Item commission group Volume value code Project cost code 1 – 2 Item class Originating company Serial number Holding company Parent company Delivery type Ext request code Int request code Resolution code Action code Invoicing type
279	Customer rebate amount, affect margin	N/A

Supplier rebate balances

Balance group: RBTSUPPSTS
Base level: A24
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
276	Supplier rebate amount	N/A	Rebate agreement group Rebate agreement Reb payer/receiver Item Primary segment Item segment 1-6 Item object Cust/Supp number Supplier number Handler Item responsible Cust/supp group Cust/supp acc group Project Project phase Contract number Unit Country Warehouse Business partner category 1-6 Area Cost centre Division Item type Item family Item sector Item group Item discount group Item account group Item price group Item price code Item category 1-6 Replenishment order type Country of origin Commodity code Planner Item class Originating company Holding company Parent company Delivery type
277	Supplier rebate amount, affect margin	N/A

G/L balances

Balance group: GLBAL
Base levels: A11, A12
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
Connected to Base level A11
301	System currency amounts	N/A	Originating company Main account part Main P/C CuGr PrGr Summary id part 1-4 Bal/trade acc type
304	Reporting currency amounts	N/A
305	Quantity	N/A
Connected to Base level A12
302	System currency amounts / transaction currency	N/A	Same as A11, plus Transaction currency
303	Transaction currency amounts	N/A

A/R customer balances

Balance group: ARBAL
Base levels: A13, A14, A15, A16, A17
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
Connected to Base level A13
311	Customer system currency amounts	N/A	Originating company Main account part Main P/C CuGr PrGr Cust/supp number Document type A/R-A/P group Division Cost centre Bal/trade acc type
Connected to Base level A14
312	Customer system curr amounts / transaction curr	N/A	Same as A13, plus Transaction currency
313	Customer transaction currency amounts	N/A
Connected to Base level A15
315	Customer VAT system currency amounts	VAT Transaction Currency Amount * Exchange Rate for the Transaction	Originating company Cust/supp number Document type A/R-A/P group Division Cost centre
317	Customer turnover system currency amounts	Turnover Transaction Currency Amount * Exchange Rate for the Transaction
Connected to Base level A16
316	Customer VAT transaction currency amounts	N/A	Same as A15, plus Transaction currency
318	Customer turnover transaction currency amounts	N/A
Connected to Base level A17
314	Customer primary currency amounts	N/A	Same as A15, plus Primary currency

A/P supplier balances

Balance group: APBAL
Base levels: A13, A14, A15, A16, A17
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
Connected to Base level A13
321	Supplier system currency amounts	N/A	Same as A13 in A/R Customer Balances
Connected to Base level A14
322	Supplier system curr amounts / transaction curr	N/A	Same as A14 in A/R Customer Balances
323	Supplier transaction currency amounts	N/A
Connected to Base level A15
325	Supplier VAT system currency amounts	VAT Transaction Currency Amount * Exchange Rate for the Transaction	Same as A15 in A/R Customer Balances
327	Supplier turnover system currency amounts	Turnover Transaction Currency Amount * Exchange Rate for the Transaction
Connected to Base level A16
326	Supplier VAT transaction currency amounts	N/A	Same as A16 in A/R Customer Balances
328	Supplier turnover transaction currency amounts	N/A
Connected to Base level A17
324	Supplier primary currency amounts	N/A	Same as A17 in A/R Customer Balances

A/R capital interest cost

Balance group: CCICBAL
Base level: A21
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
331	Customer capital interest cost		Originating company Cust/supp number Cust/supp acc group Discount group Country Business partner category 1-6 Area

ASM asset balances

Balance group: ASSET
Base level: A31
Balance type	Description	Calculation of value for the balance type	Valid statistics keys for all
340	Acquisition value, existing asset	N/A	Originating company ASM cost centre Asset number ASM responsible Budget/normal asset Asset sequence Acquisition type Disposal type Asset type Asset group Asset account group ASM location 1-8 ASM project ASM transaction origin Asset quality
341	Depreciation value seq 1, existing asset	N/A
342	Depreciation value seq 2, existing asset	N/A
343	Depreciation value seq 3, existing asset	N/A
344	Depreciation value seq 4, existing asset	N/A
345	Depreciation value seq 5, existing asset	N/A
346	Depreciation value seq 6, existing asset	N/A
347	Depreciation value seq 7, existing asset	N/A
348	Depreciation value seq 8, existing asset	N/A
349	Depreciation value seq 9, existing asset	N/A
350	Acquisition value, disposed asset	N/A
351	Depreciation value seq 1, disposed asset	N/A
352	Depreciation value seq 2, disposed asset	N/A
353	Depreciation value seq 3, disposed asset	N/A
354	Depreciation value seq 4, disposed asset	N/A
355	Depreciation value seq 5, disposed asset	N/A
356	Depreciation value seq 6, disposed asset	N/A
357	Depreciation value seq 7, disposed asset	N/A
358	Depreciation value seq 8, disposed asset	N/A
359	Depreciation value seq 9, disposed asset	N/A
360	Disposal value	N/A
361	Profit/loss value, main depreciation type	N/A
Connected to Base level A32
370	Acquisition value G/L		Originating company Main Cost Customer Prod Dpt Project M1 M2 Asset number Asset sequence Acquisition type Disposal type Bal/trade acc type Asset type Asset group ASM transaction origin
371	Depreciation value G/L seq 1
372	Depreciation value G/L seq 2
373	Depreciation value G/L seq 3
374	Depreciation value G/L seq 4
375	Depreciation value G/L seq 5
376	Depreciation value G/L seq 6
377	Depreciation value G/L seq 7
378	Depreciation value G/L seq 8
379	Depreciation value G/L seq 9
380	Disposal value G/L
381	Profit/loss value G/L, main depreciation type

Related topics

• (BIW) Balance flowchart
• (BIW) Sample update from Invoice File
• (BIW) Sample update from G/L Transaction File
• (BIW) Required system balance types