FO_AMT_OFF_VW

(SQL View)
 Index Back

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 = 'AMT' AND REV_RECOG_METHOD = '4' AND RENEWABLE <> 'Y' AND CA_AP_TMPL_ID = ' ' AND CA_BP_TMPL_ID = ' ' 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