BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
REFUND_DATEREFUND_REV_ODVW(SQL View) |
Index Back |
|---|---|
Refund Reversal - Org By DateSelect Distinct Refund Dates from REFUND_HDR |
| SELECT DISTINCT BUSINESS_UNIT , %DatePart(REFUND_DTTM) FROM PS_REFUND_HDR WHERE EXT_ORG_ID <> ' ' AND REFUND_STATUS IN ('A','B','C','D','P','S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | REFUND_DATE |
Date(10) | DATE | Refund Date |