BUSINESS_UNITVOUCHER_IDCONVER_HDR_SEQ_NUMCONVER_LN_SEQ_NUMAP_WC_SUPMSG(SQL View) |
Index Back |
|---|---|
Messages from Suppliers ViewMessages from Suppliers View for AP WorkCenter |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.CONVER_HDR_SEQ_NUM , A.CONVER_LN_SEQ_NUM , A.CONVER_HDR_DTTM , A.EM_MESSAGE_TOPIC , A.OPRID_FROM , A.OPRID_TO , A.OPRID , A.CONVER_LN_DTTM , B.DESCRLONG FROM PS_EM_CONVER_VW A , PS_EM_CONVER_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.CONVER_HDR_SEQ_NUM = B.CONVER_HDR_SEQ_NUM AND A.CONVER_LN_SEQ_NUM = B.CONVER_LN_SEQ_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | CONVER_HDR_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Conversation Header Sequence Number |
| 4 | CONVER_LN_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Conversation Sequence Number |
| 5 | CONVER_HDR_DTTM | DateTime(26) | TIMESTAMP | Conversation Datetime |
| 6 | EM_MESSAGE_TOPIC | Character(50) | VARCHAR2(50) NOT NULL | Message Topic |
| 7 | OPRID_FROM | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 8 | OPRID_TO | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | CONVER_LN_DTTM | DateTime(26) | TIMESTAMP | Conversation Datetime |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |