DR_BUS_EVNT_UNP(SQL Table) |
Index Back |
|---|---|
Draft Event Unpost SettingsThis table holds the settings required by Receivable Update to unpost a Draft. This is a sibling to DR_BUS_EVNT_TBL. It is a distinct table so that the fields and sub-records can be reused. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 | Character(1) | VARCHAR2(1) NOT NULL |
Draft Post Action
A=Actual D=Dishonor Default Value: A |
|
| 3 | UNPOST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Unpost Flag
Y/N Table Edit |
| 4 | DRAFT_DOC_TYPE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Doc Type Option
C=Collection G=Group Type N=Not Reqd Default Value: N |
| 5 | DRAFT_STATUS_NEW | Character(1) | VARCHAR2(1) NOT NULL | New Draft Status |
| 6 | ITM_MULTIPLIER | Signed Number(2,0) | DECIMAL(1) NOT NULL | Posting Item Multiplier |
| 7 | DISCOUNT_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Discounts Exists Indicator
Y/N Table Edit Default Value: N |
| 8 | DISCOUNT_VALUE | Character(1) | VARCHAR2(1) NOT NULL | Discount Processed Value |
| 9 | RECON_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation Indicator
Y/N Table Edit Default Value: N |
| 10 | RECON_VALUE | Character(1) | VARCHAR2(1) NOT NULL | Reconciliation Value |