SFA_CR_DOC_TYPESFA_CR_DOCUMENT_IDSFA_CRC_EFT_VW(SQL View) |
Index Back |
|---|---|
CRC prompt view for Doc IDThis View is used for prompting on the Document ID. |
| SELECT SFA_CR_DOC_TYPE ,SFA_CR_DOCUMENT_ID , SFA_CR_DEST_NAME , SFA_CR_SRC_ID , SFA_CR_SRC_NAME , SFA_CR_CREATE_DTTM , SFA_CR_PS_IN_DTTM FROM PS_SFA_CRC_DOCUMNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFA_CR_DOC_TYPE |
Character(35) | VARCHAR2(35) NOT NULL | Document Type |
| 2 | SFA_CR_DOCUMENT_ID |
Character(34) | VARCHAR2(34) NOT NULL | Document ID |
| 3 | SFA_CR_DEST_NAME | Character(96) | VARCHAR2(96) NOT NULL | Destination Name |
| 4 | SFA_CR_SRC_ID | Character(8) | VARCHAR2(8) NOT NULL | Source ID |
| 5 | SFA_CR_SRC_NAME | Character(96) | VARCHAR2(96) NOT NULL | Source Name |
| 6 | SFA_CR_CREATE_DTTM | Character(22) | VARCHAR2(22) NOT NULL | Created Date & Time |
| 7 | SFA_CR_PS_IN_DTTM | DateTime(26) | TIMESTAMP | Inbound DateTime |