BUSINESS_UNITLEDGER_GROUPLEDGERD=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
SETIDB=Budget Calendar
D=Detail Calendar
I=Summary Budget Period Calendar
P=Budget Period Calendar
S=Summary Calendar
T=Promo Mgmt Sales Calendar
OI_CAL_CONFIG(SQL View) |
Index Back |
|---|---|
Calendar Configuration MappingCalendar Configuration Mapping table |
| SELECT DISTINCT BULED.BUSINESS_UNIT ,LEDGRP.LEDGER_GROUP ,LEDGRP.LEDGER ,BULED.LEDGER_TYPE ,SET2.SETID ,BULED.CALENDAR_ID ,CAL.CALENDAR_TYPE FROM PS_LED_GRP_LED_TBL LEDGRP ,PS_BU_LED_GRP_TBL BULED ,PS_BU_LED_TBL LEDTBL ,PS_CAL_DEFN_TBL CAL ,PS_SET_CNTRL_REC SET1 ,PS_SET_CNTRL_REC SET2 WHERE LEDGRP.SETID = SET1.SETID AND BULED.LEDGER_GROUP = LEDGRP.LEDGER_GROUP AND LEDTBL.BUSINESS_UNIT = BULED.BUSINESS_UNIT AND LEDTBL.LEDGER_GROUP = BULED.LEDGER_GROUP AND SET1.SETCNTRLVALUE = BULED.BUSINESS_UNIT AND SET1.RECNAME ='LED_GRP_LED_TBL' AND SET2.SETCNTRLVALUE = BULED.BUSINESS_UNIT AND SET2.RECNAME = 'CAL_DEFN_TBL' AND BULED.CALENDAR_ID = CAL.CALENDAR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 4 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |
| 5 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 7 | 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 |