BUSINESS_UNITSRBT_IDEND_DATESRBT_END_VW2(SQL View) |
Index Back |
|---|---|
Sales Rebate End Dt Prompt VwSales Rebate End Dt Prompt Vw |
| SELECT A.business_unit , A.SRBT_ID , b.END_DT FROM PS_SRBT_TBL A , ps_cal_DETp_tbl b WHERE A.CALENDAR_ID = b.calendar_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SRBT_ID |
Character(6) | VARCHAR2(6) NOT NULL | Sales Rebate ID |
| 3 | END_DATE |
Date(10) | DATE | End Date |