Implementing transfer price targets
The Solutions Framework includes a starter kit for implementing transfer price targets, deployed as a data table input app named ‘EXAMPLE – Transfer Price Targets’. While most of the functionality related to transfer price targets is contained in the Solutions Framework code libraries, the data table and app are fully customizable.
Overview of transfer price targets
Transfer price is implemented with the following components:
- Data Table APP_PROFITABILITYTARGETS, deployed during implementation.
- LTP code library, refer to Longview Developer’s Guide for details.
- Example Apps: EXAMPLE – Transfer Price Targets
Creating the APP_PROFITABILITYTARGETS data table
The Solutions Framework contains scripts for defining the APP_PROFITABILITYTARGETS data table. It is filled out with the standard columns but can be modified as required to suit the customer’s needs.
You will find the SQL script file in the DataServerRepositories\<Longview Identifier> within the installation folder. The file will be named
- SQL Server: APP_PROFITABILITYTARGETS_SQLServer.sql
- Oracle: APP_PROFITABILITYTARGETS_Oracle.sql
The following columns are deployed for the table, with key and optional columns indicated:
- TIMEPERIOD (KEY)
- ENTITIES (KEY)
- DETAILS (KEY, OPTIONAL)
- SEGMENTS (KEY, OPTIONAL)
- CONTROLS (KEY, OPTIONAL)
- COUNTERPARTY
- OFFSETACCOUNT
- METHOD
- ACCEPTMIN (OPTIONAL)
- TARGETMIN
- TARGET
- TARGETMAX
- ACCEPTMAX (OPTIONAL)
Note: If you are not using acceptable minimum/maximum you can hide the accounts LTP_MinA and LTP_MaxA in the transfer pricing adjustments view, but do not delete the accounts.If you choose to remove the any of the optional key columns, be sure to update the primary key in the script.