CONTRACT_NUMPrompt Table: CA_CONTR_HDR
APPLIES_TO_LINEPrompt Table: BUS_UNIT_TBL_CA
CA_LN_REVPRC_VW(SQL View) |
Index Back |
|---|---|
Contract Line Revenue Amount |
| SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , CURRENCY_CD , PRODUCT_ID , DESCR , BUNDLE_OFFERING , GROSS_AMT_REV FROM PS_CA_DETAIL WHERE PRICING_STRUCTURE = 'AMT' AND CA_LINE_STATUS IN ('A','R') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CONTR_HDR |
| 2 | APPLIES_TO_LINE |
Number(3,0) | SMALLINT NOT NULL | PSIRS-KK |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: BUS_UNIT_TBL_CA |
| 4 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | BUNDLE_OFFERING | Character(20) | VARCHAR2(20) NOT NULL | Bundle |
| 7 | GROSS_AMT_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Revenue Amount |