INTERACTION_IDRBC_RECP_SEARCH(SQL View) |
Index Back |
|---|---|
Correspondence AttachmentsCorrespondence Request File Attachments |
| SELECT INTERACTION_ID , BO_NAME_CONTACT , CMF_ID , CMF_TRNS_SEQ_NUM , CMF_RECIP_SEQ_NUM FROM PS_RBC_RECIPIENT WHERE INTERACTION_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTERACTION_ID |
Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 2 | BO_NAME_CONTACT | Character(50) | VARCHAR2(50) NOT NULL | BO_NAME_CONTACT |
| 3 | CMF_ID | Character(36) | VARCHAR2(36) NOT NULL | Correspondence ID |
| 4 | CMF_TRNS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Correspondence Management Package Sequence Number |
| 5 | CMF_RECIP_SEQ_NUM | Number(18,0) | DECIMAL(18) NOT NULL | Correspondence Management Package Sequence Number |