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 | 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 | 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 |