FISCAL_YEARAM_CHART_D_WRK(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 2 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 3 | COST1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 4 | ACCUM_DEPR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accumulated Depreciation |
| 5 | ACCUM_DEPR1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accumulated Depreciation |
| 6 | NET_BK_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Book Value |
| 7 | NET_BK_VALUE1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Book Value |
| 8 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | DEPR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Depreciation Amt |
| 11 | WHAT_IF_DEPR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | What IF Depreciation Amount |