DR_SUB_EVNT_TBL(SQL Table) |
Index Back |
|---|---|
Draft Sub-Events |
| # | 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.
Prompt Table: DR_BUS_EVNT_TBL |
| 2 | 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. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | NATURAL_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Natural Sign
N=Negative P=Positive U=Unsigned Default Value: U |
| 6 | SELECTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selected Flag
N=Not Selected Y=Seleted Y/N Table Edit Default Value: N |
| 7 | ADJUSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Adjusted Flag
H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Y/N Table Edit Default Value: N |
| 8 | WRITE_OFF_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Write-Off Flag
Y/N Table Edit Default Value: N |
| 9 | TOLERANCE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
jnw changed long description for planning phoenix - commit plan
10/18/02 JC (CN#PL880-1): Added TOLERANCE label
Y/N Table Edit Default Value: N |