DR_BUS_EVNT_PST(SQL Table) |
Index Back |
|---|---|
Draft Event Posting Settings |
| # | 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 | DRAFT_POST_ACTION |
Character(1) | VARCHAR2(1) NOT NULL |
Draft Post Action
A=Actual D=Dishonor Default Value: A |
| 3 | ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Template Status
A=Active I=Inactive Default Value: A |
| 4 | DR_CANC_REMIT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Include in Cancel Remittance
Y/N Table Edit Default Value: N |
| 5 | DR_SUB_EVENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use Sub-events?
Y/N Table Edit Default Value: N |
| 6 | DR_BATCH_EVENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Batch Triggered Event
Y/N Table Edit |
| 7 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 8 | DRAFT_DOC_TYPE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Doc Type Option
C=Collection G=Group Type N=Not Reqd Default Value: N |
| 9 | DRAFT_STATUS_NEW | Character(1) | VARCHAR2(1) NOT NULL | New Draft Status |
| 10 | ITM_MULTIPLIER | Signed Number(2,0) | DECIMAL(1) NOT NULL | Posting Item Multiplier |
| 11 | DISCOUNT_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Discounts Exists Indicator
Y/N Table Edit Default Value: N |
| 12 | DISCOUNT_VALUE | Character(1) | VARCHAR2(1) NOT NULL | Discount Processed Value |
| 13 | RECON_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation Indicator
Y/N Table Edit Default Value: N |
| 14 | RECON_VALUE | Character(1) | VARCHAR2(1) NOT NULL | Reconciliation Value |
| 15 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |