CAL_DETP_ALL_VW(SQL View) |
Index Back |
---|---|
Calendar Periods - No SetID |
SELECT DISTINCT CALENDAR_ID ,ACCOUNTING_PERIOD FROM PS_CAL_DETP_TBL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
2 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |