Transfer Pricing Rule

8.9.2.4 Transfer Pricing Rule - Detail

Table 8-99 Transfer Pricing Rule - Detail

Report Name	Assumptions - Transfer Pricing Rule - Detail
Description	This report displays the Transfer Pricing Rule details.
Dashboards Prompts	Prompt - Folder Name Folder Name Prompt -Transfer Pricing Rule Transfer Pricing Rule Prompt -Product Hierarchy Name (Transfer price Rule) Product Hierarchy Name Prompt - Product (TP Rule) Product Name Prompt - Currency (TP Rule) Currency Prompt - Condtion Sys Id Conditional Sys Id Prompt - MLS Code MLS - Code
Report Criteria	"Dim Products (Assumptions)"."Product Name", "Dim Products (Assumptions)"."Display Order Name", "Dim Products (Assumptions)"."Is Leaf", "Dim Currency"."Currency Cd", case when cast("Fact Transfer Price Rule"."Cond Sys Id" as char) = '-1' then 'NO' else 'YES' end, "Dim - TP Method"."Tp Calc Method", "Fact Transfer Price Rule"."Interest Rate Code", "Dim - Data Source"."Data Source", "Fact Transfer Price Rule"."Holiday Calculation Option", "Fact Transfer Price Rule"."Holiday Calendar", "Fact Transfer Price Rule"."Holiday Rolling Convention", case when "Fact Transfer Price Rule"."Mid Period Reprice Flg"=0 then 'No' when "Fact Transfer Price Rule"."Mid Period Reprice Flg"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Output Audit Flag"=0 then 'No' when "Fact Transfer Price Rule"."Output Audit Flag"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Across Org Unit Flg"=0 then 'No' when "Fact Transfer Price Rule"."Across Org Unit Flg"=1 then 'Yes' else null end, "Dim - Assignment Date"."Assignment Date", "Fact Transfer Price Rule"."Cashflow Discount Method", "Fact Transfer Price Rule"."Cash Flow Type", "Fact Transfer Price Rule"."Caterpillar Method", "Fact Transfer Price Rule"."Constant Rate", "Fact Transfer Price Rule"."Economic Value Cash Flow Interest Type", case when "Fact Transfer Price Rule"."Economic Value Exclude Accrued Interest Flag"=0 then 'No' when "Fact Transfer Price Rule"."Economic Value Exclude Accrued Interest Flag"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Economic Value Interest Only Flag"=0 then 'No' when "Fact Transfer Price Rule"."Economic Value Interest Only Flag"=1 then 'Yes' else null end, "Dim IRCS"."Interest Rate Name", case when "Fact Transfer Price Rule"."Economic Value TP Rate Calculation Flag"=0 then 'No' when "Fact Transfer Price Rule"."Economic Value TP Rate Calculation Flag"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Gross Rate Flg"=0 then 'No' when "Fact Transfer Price Rule"."Gross Rate Flg"=1 then 'Yes' else NULL end, "Fact Transfer Price Rule"."Historical Term", "Fact Transfer Price Rule"."Historical Mult", "Fact Transfer Price Rule"."Lag Term", case when "Fact Transfer Price Rule"."Option Cost Method Cd"=0 then 'No' when "Fact Transfer Price Rule"."Option Cost Method Cd"=1 then 'Yes' else NULL end, case when "Fact Transfer Price Rule"."Output Avg Life To Inst Flg"=0 then 'No' when "Fact Transfer Price Rule"."Output Avg Life To Inst Flg"=1 then 'Yes' else NULL end, case when "Fact Transfer Price Rule"."Output Dur To Inst Flg"=0 then 'No' when "Fact Transfer Price Rule"."Output Dur To Inst Flg"=1 then 'Yes' else NULL end, "Fact Transfer Price Rule"."Behavior Pattern", "Fact Transfer Price Rule"."Rate Spread", "Fact Transfer Price Rule"."Single Rate Discount", "Fact Transfer Price Rule"."Target Balance", "Fact Transfer Price Rule"."Transfer Price Rate Term", "Fact Transfer Price Rule"."Transfer Price Term Adjustment Amount", "Fact Transfer Price Rule"."Transfer Price Term Operator", "Fact Transfer Price Rule"."Weighted Term Cash Flow Code", "Fact Transfer Price Rule"."Yield Curve Term", "Fact Transfer Price Rule"."Yield Curve Mult", "Fact Transfer Price Rule"."Transfer Price Sys Id", "Dim Object Definition"."Short Desc"

Report Name

Assumptions - Transfer Pricing Rule - Detail

Description

This report displays the Transfer Pricing Rule details.

Dashboards Prompts

Prompt - Folder Name

Folder Name

Prompt -Transfer Pricing Rule

Transfer Pricing Rule

Prompt -Product Hierarchy Name (Transfer price Rule)

Product Hierarchy Name

Prompt - Product (TP Rule)

Product Name

Prompt - Currency (TP Rule)

Currency

Prompt - Condtion Sys Id

Conditional Sys Id

Prompt - MLS Code

MLS - Code

Report Criteria

"Dim Products (Assumptions)"."Product Name", "Dim Products (Assumptions)"."Display Order Name", "Dim Products (Assumptions)"."Is Leaf", "Dim Currency"."Currency Cd", case when cast("Fact Transfer Price Rule"."Cond Sys Id" as char) = '-1' then 'NO' else 'YES' end, "Dim - TP Method"."Tp Calc Method", "Fact Transfer Price Rule"."Interest Rate Code", "Dim - Data Source"."Data Source", "Fact Transfer Price Rule"."Holiday Calculation Option", "Fact Transfer Price Rule"."Holiday Calendar", "Fact Transfer Price Rule"."Holiday Rolling Convention", case when "Fact Transfer Price Rule"."Mid Period Reprice Flg"=0 then 'No' when "Fact Transfer Price Rule"."Mid Period Reprice Flg"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Output Audit Flag"=0 then 'No' when "Fact Transfer Price Rule"."Output Audit Flag"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Across Org Unit Flg"=0 then 'No' when "Fact Transfer Price Rule"."Across Org Unit Flg"=1 then 'Yes' else null end, "Dim - Assignment Date"."Assignment Date", "Fact Transfer Price Rule"."Cashflow Discount Method", "Fact Transfer Price Rule"."Cash Flow Type", "Fact Transfer Price Rule"."Caterpillar Method", "Fact Transfer Price Rule"."Constant Rate", "Fact Transfer Price Rule"."Economic Value Cash Flow Interest Type", case when "Fact Transfer Price Rule"."Economic Value Exclude Accrued Interest Flag"=0 then 'No' when "Fact Transfer Price Rule"."Economic Value Exclude Accrued Interest Flag"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Economic Value Interest Only Flag"=0 then 'No' when "Fact Transfer Price Rule"."Economic Value Interest Only Flag"=1 then 'Yes' else null end, "Dim IRCS"."Interest Rate Name", case when "Fact Transfer Price Rule"."Economic Value TP Rate Calculation Flag"=0 then 'No' when "Fact Transfer Price Rule"."Economic Value TP Rate Calculation Flag"=1 then 'Yes' else null end, case when "Fact Transfer Price Rule"."Gross Rate Flg"=0 then 'No' when "Fact Transfer Price Rule"."Gross Rate Flg"=1 then 'Yes' else NULL end, "Fact Transfer Price Rule"."Historical Term", "Fact Transfer Price Rule"."Historical Mult", "Fact Transfer Price Rule"."Lag Term", case when "Fact Transfer Price Rule"."Option Cost Method Cd"=0 then 'No' when "Fact Transfer Price Rule"."Option Cost Method Cd"=1 then 'Yes' else NULL end, case when "Fact Transfer Price Rule"."Output Avg Life To Inst Flg"=0 then 'No' when "Fact Transfer Price Rule"."Output Avg Life To Inst Flg"=1 then 'Yes' else NULL end, case when "Fact Transfer Price Rule"."Output Dur To Inst Flg"=0 then 'No' when "Fact Transfer Price Rule"."Output Dur To Inst Flg"=1 then 'Yes' else NULL end, "Fact Transfer Price Rule"."Behavior Pattern", "Fact Transfer Price Rule"."Rate Spread", "Fact Transfer Price Rule"."Single Rate Discount", "Fact Transfer Price Rule"."Target Balance", "Fact Transfer Price Rule"."Transfer Price Rate Term", "Fact Transfer Price Rule"."Transfer Price Term Adjustment Amount", "Fact Transfer Price Rule"."Transfer Price Term Operator", "Fact Transfer Price Rule"."Weighted Term Cash Flow Code", "Fact Transfer Price Rule"."Yield Curve Term", "Fact Transfer Price Rule"."Yield Curve Mult", "Fact Transfer Price Rule"."Transfer Price Sys Id", "Dim Object Definition"."Short Desc"