SETIDDETAIL_CALENDARCALENDAR_IDB=Budget Calendar
D=Detail Calendar
I=Summary Budget Period Calendar
P=Budget Period Calendar
S=Summary Calendar
T=Promo Mgmt Sales Calendar
CAL_DTL_SUM_VW(SQL View) |
Index Back |
|---|---|
Summary cals per detail cals |
| SELECT SETID , DETAIL_CALENDAR , CALENDAR_ID , DESCR , CALENDAR_TYPE FROM PS_CAL_DEFN_TBL WHERE CALENDAR_TYPE IN('S') AND DETAIL_CALENDAR > ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DETAIL_CALENDAR |
Character(2) | VARCHAR2(2) NOT NULL | Detail Calendar |
| 3 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CALENDAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Calendar
B=Budget Calendar D=Detail Calendar I=Summary Budget Period Calendar P=Budget Period Calendar S=Summary Calendar T=Promo Mgmt Sales Calendar |