SETIDDRAFT_TYPEDRAFT_BUSN_EVENTPrompt Table: DR_BUS_EVNT_TBL
DRAFT_SUB_EVENTDR_SUBEVNT_A_VW(SQL View) |
Index Back |
|---|---|
Draft Sub-Events by Draft Type |
| SELECT D.SETID, D.DRAFT_TYPE, S.DRAFT_BUSN_EVENT, S.DRAFT_SUB_EVENT, S.DESCR, S.DESCRSHORT FROM PS_DR_SUB_EVNT_TBL S, PS_DR_ENTRYSUB_TBL D WHERE S.DRAFT_BUSN_EVENT = D.DRAFT_BUSN_EVENT AND S.DRAFT_SUB_EVENT = D.DRAFT_SUB_EVENT AND D.DRAFT_POST_ACTION = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DRAFT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2). |
| 3 | 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.
Prompt Table: DR_BUS_EVNT_TBL |
| 4 | DRAFT_SUB_EVENT |
Character(2) | VARCHAR2(2) NOT NULL | Defines specific types of activity that can be performed at the Draft Business Event. For example in the process of approving a Draft you can specify that you are paying an item putting an amount on acccount etc. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |