CONTRACT_NUMPrompt Table: CA_BU_SP_NONVW
Prompt Table: CA_DETAIL
AMT=Amount
PCT=Percent
RATE=Rate
RCR=Recurring
CA_LN_SRCH_VW(SQL View) |
Index Back |
|---|---|
Contract Lines Search ViewThis view can be used to bypass the Lookup dialogue - it immediately returns the search results - a list of all contract lines. |
| SELECT CONTRACT_NUM ,CONTRACT_LINE_NUM ,PRODUCT_ID ,DESCR ,PRICING_STRUCTURE FROM PS_CA_DETAIL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
| 2 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL |
Contract Line Num
Prompt Table: CA_DETAIL |
| 3 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PRICING_STRUCTURE | Character(4) | VARCHAR2(4) NOT NULL |
Price Type
AMT=Amount PCT=Percent RATE=Rate RCR=Recurring |