DRAFT_BUSN_EVENTLANGUAGE_CDDR_BUS_EVT_LVW1(SQL View) |
Index Back |
|---|---|
Draft Doc Type Events (Bank)Lists draft business events that specify document type defaults by bank. |
| SELECT DRAFT_BUSN_EVENT , LANGUAGE_CD ,DESCR60 ,DRAFT_DESCR20 FROM PS_DR_BUS_EVNT_LG WHERE EXISTS ( SELECT 'X' FROM PS_DR_BUS_EVNT_PST WHERE DRAFT_BUSN_EVENT = PS_DR_BUS_EVNT_LG.DRAFT_BUSN_EVENT AND DRAFT_DOC_TYPE_OPT = 'C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DRAFT_BUSN_EVENT |
Character(2) | VARCHAR2(2) NOT NULL | Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft. |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 4 | DRAFT_DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description 20 characters, mixed case |