SCC_TRANSAC_CDPrompt Table: SCC_TRNSAC_DTLS
SCC_DA_TRNCD_VW(SQL View) |
Index Back |
|---|---|
Transaction Names Prompt ViewTransaction Names Prompt View |
| SELECT SCC_TRANSAC_CD , SCC_TRANSACTION FROM PS_SCC_TRNSAC_DTLS WHERE SCC_STATUS='A' AND SCC_SL_PARTITION='C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TRANSAC_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Transaction
Prompt Table: SCC_TRNSAC_DTLS |
| 2 | SCC_TRANSACTION | Character(30) | VARCHAR2(30) NOT NULL | Transaction Name |