BUSINESS_UNITDefault Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
CONTRACT_LINE_NUMPrompt Table: CA_DETAIL
AMT=Amount
PCT=Percent
RATE=Rate
RCR=Recurring
Prompt Table: MEMBER_VW
CA_DETAIL_VW4(SQL View) |
Index Back |
|---|---|
Contract LinesContract Lines |
| SELECT HDR.BUSINESS_UNIT , HDR.CONTRACT_NUM , CD.CONTRACT_LINE_NUM , CD.PRODUCT_ID , CD.DESCR , CD.PRICING_STRUCTURE , HDR.CONTRACT_ADMIN FROM PS_CA_CONTR_HDR HDR , PS_CA_DETAIL CD WHERE HDR.CONTRACT_NUM = CD.CONTRACT_NUM AND CD.CHG_STATUS <> 'X' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 3 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL |
Contract Line Num
Prompt Table: CA_DETAIL |
| 4 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PRICING_STRUCTURE | Character(4) | VARCHAR2(4) NOT NULL |
Price Type
AMT=Amount PCT=Percent RATE=Rate RCR=Recurring |
| 7 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table: MEMBER_VW |