FO_RATE_OFF_VW

(SQL View)

SELECT SETID , PRODUCT_ID , DESCR , PRODUCT_KIT_FLAG , EFF_STATUS , REV_RECOG_METHOD , INV_ITEM_ID , PRODUCT_USE , THIRD_PARTY_FLG , RENEWABLE , PERCENTAGE , APPLIES_TO , CA_AP_TMPL_ID , CA_BP_TMPL_ID , BP_DTL_TMPL_ID , RNW_TEMPLATE_ID , TAX_TRANS_TYPE , TAX_TRANS_SUB_TYPE FROM PS_PROD_ITEM WHERE PRODUCT_USE IN ('2', '3') AND PRICING_STRUCTURE = 'RATE' AND RENEWABLE <> 'Y' AND PRODUCT_KIT_FLAG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue

7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

8 PRODUCT_USE Character(1) VARCHAR2(1) NOT NULL Field for distinguishing which products can use a product definition.
1=General Use Excluding Contract
2=Contracts Only
3=General Use Including Contract

9 THIRD_PARTY_FLG Character(1) VARCHAR2(1) NOT NULL Third Party Flag

10 RENEWABLE Character(1) VARCHAR2(1) NOT NULL Renewable

11 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

12 APPLIES_TO Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
HDR=% of Total Contract Amount
LINE=% of Contract Lines

13 CA_AP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Revenue Plan Template
Prompt Table: CA_AP_TMPL_VW

14 CA_BP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Template
Prompt Table: CA_BP_TMPL_VW

15 BP_DTL_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Detail Template ID
Prompt Table: CA_BP_DTL_TMPL

16 RNW_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Renewal Plan Template
Prompt Table: CA_RNW_TEMPLATE

17 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return

18 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	PRODUCT_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Kit
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	REV_RECOG_METHOD	Character(4)	VARCHAR2(4) NOT NULL	Revenue Recognition Method 1=As Incurred 2=Apportionment 3=Percent Complete 4=Milestone 5=Billing Manages Revenue
7	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
8	PRODUCT_USE	Character(1)	VARCHAR2(1) NOT NULL	Field for distinguishing which products can use a product definition. 1=General Use Excluding Contract 2=Contracts Only 3=General Use Including Contract
9	THIRD_PARTY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Third Party Flag
10	RENEWABLE	Character(1)	VARCHAR2(1) NOT NULL	Renewable
11	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
12	APPLIES_TO	Character(4)	VARCHAR2(4) NOT NULL	PSIRS-KK HDR=% of Total Contract Amount LINE=% of Contract Lines
13	CA_AP_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Plan Template Prompt Table: CA_AP_TMPL_VW
14	CA_BP_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Plan Template Prompt Table: CA_BP_TMPL_VW
15	BP_DTL_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Plan Detail Template ID Prompt Table: CA_BP_DTL_TMPL
16	RNW_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Renewal Plan Template Prompt Table: CA_RNW_TEMPLATE
17	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
18	TAX_TRANS_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Sub Type 1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None