Dimension Mapping (bcttf0110m000)

Use this session to view the additional fields from Baan IVc (=Elements in ERP LN 6.1) that are used to define the value on field Dimension. This session can also be used to change the Dimension that is used in the integration mapping scheme. The fields Dimension and To be Used can be changed on each view. At the first form the data about the originating Financial Transaction is visible. At the next forms the elements (i.e. item and warehouse) are visible that are used to determine the Dimension.

This maintain session prepares the input for session Migrate Mapping Scheme (bcttf0201m000). Dependent on the filled additional fields of Baan IVc, the element groups and the elements by element groups of dimension mapping are generated.

Preparation

Not applicable.

Execution

It is strongly advised to start this session to judge the dimensions and the indication ‘To be Used’ before running session Migrate Mapping Scheme (bcttf0201m000).

Process logic

If this session is started for the first time then the data from interim table bcttf006 is copied to the table bcttf010. A new field Business Object Name is filled based on the reconciliation group and the financial transaction. For example the Transaction Origin = Purchase will be connected to the ‘Purchase Order’. This Business Object Name is used to group the same elements in a priority. The Priority is filled with an increasing value per reconciliation group, companies, Dimension Type and Business Object Name.

In contrast with the ledger account mapping (session Ledger Mapping (bcttf0105m000) all lines will be flagged with To be Used = Yes. The reason is that dimension mapping can have overlapping ranges. The second reason is that it is not mandatory that dimensions of the debit and the credit postings that are ‘clearing’ interim accounts are the same.

Dependent on the reconciliation group the elements that can be used in ERP LN 6.1, are marked with ‘Yes’. Some elements can be filled with data from Baan IVc but can be marked with ‘No’ if this addition is not longer available in ERP LN 6.1. For example: For sales orders the elements Order Series, Item, Item Group, Statistic Group, Warehouse, Item Cost Component, Project, Customer, Financial B.P. Group (A/R), Employee, Trade Group, Country, Area, Line of Business, Order Type can be used.

Duration

Warning: Execution of this session takes some time if it is started for the first time. The next time it will be faster.

Restart

Not applicable.

Dimension Mapping

Reconciliation Group

The reconciliation group that is determined based on the Transaction Origin and Financial Transaction where the mapping data is defined.

Business Object Name

The business object name is filled based on the reconciliation group, Transaction Origin, Financial Transaction and Additional Type.

Dimension Type

The dimension type indicates which of the five types belongs to the Dimension.

Logistic Company

The logistic company for which the mapping will be used. If this field is filled with zero, then the mapping is applicable for all logistic companies.

Financial Company

The financial company for which the mapping will be used. If this field is filled with zero, then the mapping is applicable for all financial companies.

Priority

The priority of the mapping. A low number is found first in the mapping process.

Sequence

The sequence always has the value ‘1’.

Transaction Origin

The origin of the transaction for which the mapping will be used. Note that the values of this field are taken over from Baan IVc. In ERP LN 6.1 other values are applicable for this field.

Financial Transaction

The financial transaction for which the mapping will be used. Note that the values of this field are taken over from Baan IVc. In ERP LN 6.1 other values are applicable for this field.

Project Transaction

This field indicates whether the dimension originates from project specific mapping in Baan IVc.

Additional Type

This field contains an additional value to separate a mapping within one combination of transaction origin and financial transaction. The first 8 values of this field are taken over 1:1 from Baan IVc (Invoice Totals, Late Payment Surcharge, Order Discount, Material Costs, Operation Costs, Revenues, Rebate, Commission). The other values are new defined ones for example to separate between transactions that are split in ERP LN 6.1.

Debit/Credit

The indicator whether the mapping is used for the debit or for the credit side of the financial transaction.

To be used

This flag indicates whether the mapping – line will be used during generation of the mapping scheme.

Dimension

This dimension is used to map the financial transactions that originate from the several packages.

General

Item: This element Item is filled from the mapping by element or the mapping by range of Baan IVc, see session Maintain Options by Integration Element (tfgld4121m000). The ‘Yes/No’ flag indicates whether this element is available in ERP LN 6.1. Also a From and a To value is show. Note that for elements that are not used for mapping, the minimum and the maximum value are filled.
Item Group: The element Item Group is shown here.
Statistic Group: The element Statistic Group is shown here.
Warehouse: The element Warehouse is shown here.
Project: The element Project is shown here.
Item Cost Component: The element Item Cost Component is shown here.
Work Center: The element Work Center is shown here.
Order Series: The element Order Series is shown here.
Order Type: The element Order Type is shown here.
Country: The element Country is shown here.
Area: The element Area is shown here.
Line of Business: The element Line Of Business is shown here.
Employee: The element Employee is shown here.
Trade Group: The element Trade Group is shown here.
Transaction Type: The element Transaction Type is shown here.
Reason Code: The element Reason Code is shown here.
Container: The element Container is shown here.

Business Partner

Supplier: The element Supplier is shown here.
Financial B.P. Group (A/P): The element Business Partner Group Accounts Payable is shown here.
Customer: The element Customer is shown here.
Financial B.P. Group (A/R): The element Business Partner Group Accounts Receivable is shown here.
Financial B.P. Group (A/R) PCS Project: The element Business Partner Group Accounts Receivable of the PCS Project is shown here.
Financial B.P. Group (A/R) Service Contract: The element Business Partner Group Accounts Receivable of the service contract is shown here.

Production

Main Item: The element Main Item is shown here.
Main Item Group: The element Main Item Group is shown here.
Main Warehouse: The element Main Warehouse is shown here.
Main Work Center: The element Main Work Center is shown here.
Machine: The element “Machine” is shown here.

Service

Service Contract: The element Service Contract is shown here.
Service Contract Type: The element Service Contract Type is shown here.
Warranty: The element Warranty is shown here.
Service Order Type: The element Service Order Type is shown here.
Cost Type (TS): The element Cost Type of Service is shown here.
Cost Type Group: The element Cost Type Group is shown here.
Service Car: The element Service Car is shown here.
Cluster: The element Cluster is shown here.
Service Area: The element Service Area is shown here.
Installation: The element Installation is shown here.
Installation Type: The element Installation Type is shown here.
Cost Analysis Type: The element Cost Analysis Type is shown here.
Package Part: The element Package Part is shown here.
Servicing: The element Servicing is shown here.
Service Package: The element Service Package is shown here.

TP Project

Element: The element Element is shown here.
Cost Component: The element Cost Component of Project is shown here.
Category: The element Category is shown here.
Financing Method: The element Financing Method is shown here.
Acquisition Method: The element Acquisition Method is shown here.
Task: The element Task is shown here.
Equipment: The element Equipment is shown here.
Subcontracting: The element Subcontracting is shown here.
Sundry Cost: The element Sundry Cost is shown here.
Revenue Code: The element Revenue Code is shown here.

Commissions and Rebates

Commission/Rebate Group: The element Commission or Rebate Group is shown here.
Relation: The element Relation is shown here.
Agreement Group: The element Agreement Group is shown here.

Transportation

Transport Means Group: The element Transport Means Group is shown here.
Means of Transport 1: The element Means of Transport 1 is shown here.
Means of Transport 2: The element Means of Transport 2 is shown here.
Standard Route: The element Standard Route is shown here.
Transport Type: The element Transport Type is shown here.
Employee (Transportation): The element Employee of Transportation is shown here.
Employee Department: The element Employee Department is shown here.