CMF_IDCMF_TRNS_SEQ_NUMCMF_KEY_SEQ_NUMRBC_REQST_REC_V(SQL View) |
Index Back |
|---|
| SELECT CMF_ID , CMF_TRNS_SEQ_NUM , CMF_KEY_SEQ_NUM , RECNAME , PNLGRPNAME , MARKET FROM PS_RBC_REQST_REC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CMF_ID |
Character(36) | VARCHAR2(36) NOT NULL | Correspondence ID |
| 2 | CMF_TRNS_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Correspondence Management Package Sequence Number |
| 3 | CMF_KEY_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Correspondence Management Package Sequence Number |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 6 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |