SETIDPrompt Table: SP_SETID_NONVW
CALENDAR_IDCONVENTION1=Mid Month
2=Mid Quarter
3=Half Year
4=Full Year
5=End of Year
6=End of Quarter
7=End of Month
8=Following Month
9=User Defined
D=Actual Days of Period
M=Middle of Begin Depr Period
CONV_TBL_VW(SQL View) |
Index Back |
|---|---|
Depr Convention TBL View |
| SELECT SETID , CALENDAR_ID , CONVENTION , CONV_TYPE , DESCR , SYSTEM_MAINTAINED , BEGIN_DEPR_OPTION FROM PS_CONV_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 3 | CONVENTION |
Character(2) | VARCHAR2(2) NOT NULL | Book Depreciation Convention or Cost Convention |
| 4 | CONV_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Convention Type
1=Mid Month 2=Mid Quarter 3=Half Year 4=Full Year 5=End of Year 6=End of Quarter 7=End of Month 8=Following Month 9=User Defined |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SYSTEM_MAINTAINED | Character(1) | VARCHAR2(1) NOT NULL | System Maintained |
| 7 | BEGIN_DEPR_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Begin Depr-Pd Fraction Option
D=Actual Days of Period M=Middle of Begin Depr Period |