CONV_TBL_BLK_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 WHERE CALENDAR_ID = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 |