UPG_DEPR_CONV(SQL Table) |
Index Back |
|---|---|
Depr Convention Upgrade Table |
| # | 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 |
| 8 | CONV_CALENDAR_ID_3 | Character(3) | VARCHAR2(3) NOT NULL |
Used in Depreciation Convention Upgrade Process. This field is used to indicate how to populate the new Calendar ID field in the CONV_TBL. While the regular Calendar ID was defined as Char 2, this field was defined as Char 3 because we could use 'ALL' to denote copy to ALL calendar.
Prompt Table: CAL_DEFN_TBL_VW |
| 9 | CONV_UPGRADE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Used in Depreciation Convention Upgrade Process. This field is used to indicate whether to upgrade the convention or not.
Y/N Table Edit |