BOOK_REVERSE_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BU_BK_NONVW
4	IN_SERVICE_DT	Date(10)	DATE	In Service Date
5	IN_SERVICE_PD	Number(3,0)	SMALLINT NOT NULL	In service Period
6	IN_SERVICE_FY	Number(4,0)	SMALLINT NOT NULL	In Service Fiscal Year
7	DEPR_IN_SERVICE_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate When In Service N=No X=Used to be set to 'Y' Y=Yes Default Value: N
8	BEGIN_DEPR_DT	Date(10)	DATE	Begin Depr Date
9	BEGIN_DEPR_PD	Number(3,0)	SMALLINT NOT NULL	Begin Depreciation Period
10	BEGIN_DEPR_FY	Number(4,0)	SMALLINT NOT NULL	Begin Depreciation Fiscal Year
11	BEGIN_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Begin Depr Period Fraction
12	DEPR_CALC_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Calculation Sw
13	BEGIN_CALC_DT	Date(10)	DATE	Begin Depreciation Calc Date
14	BEGIN_CALC_PD	Number(3,0)	SMALLINT NOT NULL	Begin Calculation Period
15	BEGIN_CALC_FY	Number(4,0)	SMALLINT NOT NULL	Begin Calculation Fiscal Yr
16	CALCULATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Type L=Life-to-Date R=Remaining Value Default Value: R
17	LAST_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Last Calculation Type
18	RSV_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Reserve Fraction (RSV/Cost)
19	RECALC_RSV_SW	Character(1)	VARCHAR2(1) NOT NULL	Recalculate RSV Fraction (Y/N)
20	SCHED_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Fraction of Schedule Elapsed
21	YEAR_REM_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Year Remaining Fraction
22	DEPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Status D=Depreciable N=Non Depreciable
23	REGULATION	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Regulation A=Accelerated Cost Recovery Sys D=Asset Depreciation Range F=Conventional/Facts& Circumstan G=Guideline M=Modified Accel Cost Recovery
24	RECOVERY_LIFE	Number(4,1)	DECIMAL(3,1) NOT NULL	Recovery Life
25	RECOVERY_SUBTYPE	Character(2)	VARCHAR2(2) NOT NULL	Recovery SubType LI=Low-Income Housing PU=Public Utility Property
26	FUTURE_DEPR_YEARS	Number(3,0)	SMALLINT NOT NULL	No of Future Depreciation Year
27	CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Book Depreciation Convention or Cost Convention Prompt Table: CONV_BOOK_VW
28	LIFE	Number(4,0)	SMALLINT NOT NULL	Useful Life
29	LIFE_REMAINING	Signed Number(17,11)	DECIMAL(15,11) NOT NULL	Remaining Life
30	TAX_CLASS_AM	Character(6)	VARCHAR2(6) NOT NULL	Guideline Tax Class Prompt Table: TAX_CLASS_AM
31	DEPR_PERCENT	Number(10,8)	DECIMAL(9,8) NOT NULL	Depreciation Percent
32	DB_PERCENT	Number(16,14)	DECIMAL(15,14) NOT NULL	Declining Balance Percent
33	METHOD	Character(2)	VARCHAR2(2) NOT NULL	Method DL=DB w/SL By Limit% DX=Declining Balance w/SL F1=France Derogatory Balance FL=Flat Rate % G1=Germany Staffel Method J1=Japan- Tangible/Declining Bal J2=Japan- Tangible/Strt Line J3=Japan- Intangible/Strt Line J4=Japan - Lease Depreciation J5=Japan-Changes DB to SL J6=Japan - Changes DB to SL 250 J7=Japan-Tangible/Strt Line Rev J8=Japan - Changes DB to SL 200 J9=JPN - Changes 200/250 DB to SL JE=Japan - Extended/Strt Line MN=Manual Depreciation PC=Declining Balance SC=Depreciation Schedule SL=Straight Line SP=Straight Line Percent SY=Sum of the Years UD=User Defined Method UP=Units of Production
34	DEPR_SCHED_CD	Character(10)	VARCHAR2(10) NOT NULL	Schedule Code Prompt Table: DEPR_SCHED_TBL
35	DEPR_LIMIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Depreciation Limit Code Prompt Table: DEPR_LIM_TBL
36	PROPERTY_CD	Character(1)	VARCHAR2(1) NOT NULL	Property Code 1=1245 Property 2=1250 Property Default Value: 1
37	PROPERTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Property Type P=Personal R=Non-Residential Real S=Residential Real Default Value: P
38	SALVAGE_VAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Salvage Value
39	SALVAGE_PCT	Number(16,14)	DECIMAL(15,14) NOT NULL	Salvage Percentage
40	TAX_CREDIT_SW	Character(1)	VARCHAR2(1) NOT NULL	Tax Credit Switch Default Value: N
41	BASIS_RED_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Basis Reduction Total
42	BASIS_RED_RECAP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Basis Reduction Recapture
43	SEC179_TAKEN_SW	Character(1)	VARCHAR2(1) NOT NULL	Section 179 Taken switch N=Section 179 Expense not taken Y=Section 179 Expense Taken Default Value: N
44	SEC179_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Section 179 Taken Amount
45	LIFE_END_DT	Date(10)	DATE	Useful Life End Date
46	DEPR_LOW_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Depr Low Limit Amount
47	SUSPEND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Suspend Status N=Depreciation Has Been Resumed Y=Depreciation Is Suspended
48	SUSPEND_DT	Date(10)	DATE	Suspend Date
49	RESUME_DT	Date(10)	DATE	Resume Date
50	SUSPENDED_PERIODS	Number(4,0)	SMALLINT NOT NULL	Number of Suspended Periods
51	COST_BASIS_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cost Basis Limit
52	DEPR_AVG_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Averaging Option M=Monthly Averaging N=No Averaging Y=Yearly Averaging Default Value: N
53	GROUP_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Group Asset ID Prompt Table: BU_GRP_ASSET_VW
54	UOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Units of Production ID Prompt Table: UOP_TBL
55	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
56	INCLUDE_CAP_GAINS	Character(1)	VARCHAR2(1) NOT NULL	CGT Applicable Y/N Table Edit Default Value: Y
57	UD_METHOD_ID	Character(5)	VARCHAR2(5) NOT NULL	Method ID Prompt Table: UD_METHOD
58	PERIOD_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate By Period Y/N Table Edit Default Value: N
59	ACCOUNTING_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Accounting Method ALL=Allowance EXP=Expense RES=Reserve
60	DEPR_PASS_LIFE_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate Pass Life SW Y/N Table Edit Default Value: N
61	LISTED_PROP	Character(1)	VARCHAR2(1) NOT NULL	Listed Property? Y/N Table Edit Default Value: N
62	LISTED_PROP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Listed Property Type A=Automobiles B=Other Passenger Vehicles C=Computer and Periph Equipment E=Entertain and Recr Equipment O=Other Listed Property T=Cellular Telephones
63	BUS_USE_PERCENT	Number(10,8)	DECIMAL(9,8) NOT NULL	Business Use %
64	CHILD_TK_PARENT_SW	Character(1)	VARCHAR2(1) NOT NULL	Child Inherits Parent's Life Y/N Table Edit Default Value: N
65	ARCHIVE_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID
66	SEC_291	Character(1)	VARCHAR2(1) NOT NULL	Corporation Sec.291 N=Not Corporation Sec291 Y=Corporation Sec291
67	DEPR_LIMIT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Depreciation Limit Percent
68	MULTI_SHIFT_CODE	Character(6)	VARCHAR2(6) NOT NULL	Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation. Prompt Table: MULTI_SHIFT_TBL
69	MULTI_SHIFT_NBR	Number(1,0)	SMALLINT NOT NULL	This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.
70	SPECIAL_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Special Terms Prompt Table: DEPR_TERMS_TBL
71	ACCELERATED_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Accelerated Terms Prompt Table: DEPR_TERMS_TBL
72	INITIAL_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Initial Terms Prompt Table: DEPR_TERMS_TBL
73	INCREASE_RATE	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Increased Rate
74	SPECIAL_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Special Depreciation Y/N Table Edit Default Value: N
75	LIFE_IN_YRS	Number(6,1)	DECIMAL(5,1) NOT NULL	Life in Years
76	RETIREMENT_DT	Date(10)	DATE	Projected Retirement Date
77	YEAR_CHANGE	Number(4,0)	SMALLINT NOT NULL	Year of change
78	LOW_VALUE_SW	Character(1)	VARCHAR2(1) NOT NULL	Low Value Asset Only Y/N Table Edit Default Value: N
79	BUSINESS_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Business Tax Y/N Table Edit Default Value: N
80	BUSINESS_TAX_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Business Tax Basis
81	LAST_BK_DTTM_STAMP	DateTime(26)	TIMESTAMP	Last Book Dttm Stamp
82	LAST_TRANS_DT	Date(10)	DATE	Last Transaction Date
83	LAST_ACCOUNTING_DT	Date(10)	DATE	Last Accounting Date
84	IUT_DEPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Depreciation Status H=Hold Depreciation N=None
85	SUS_DEPR_ACCUM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Suspended Depreciation Accum
86	SUS_DEPR_YTD	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Suspend Depreciation YTD
87	SUS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Suspend DateTime Stamp
88	AM_BK_UD_CHAR1	Character(10)	VARCHAR2(10) NOT NULL	User Defined Char Field1
89	AM_BK_UD_CHAR2	Character(10)	VARCHAR2(10) NOT NULL	User Defined Char Field2
90	AM_BK_UD_DATE1	Date(10)	DATE	User Defined Date Field1
91	AM_BK_UD_NUM1	Number(19,3)	DECIMAL(18,3) NOT NULL	User Defined Number Field1
92	AM_BK_UD_NUM2	Number(19,3)	DECIMAL(18,3) NOT NULL	User Defined Number Field2
93	DEROGATORY_SW	Character(1)	VARCHAR2(1) NOT NULL	Derogatory Depreciation Y/N Table Edit Default Value: N
94	CCA_50_FLG	Character(1)	VARCHAR2(1) NOT NULL	g Y/N Table Edit Default Value: Y
95	CF_SEQNO_LAST	Number(6,0)	INTEGER NOT NULL	Last Chartfield Sequence Numbe
96	END_DEPR_DT	Date(10)	DATE	End Depreciation Date
97	END_DEPR_FY	Number(4,0)	SMALLINT NOT NULL	End Depreciation Year
98	END_DEPR_PD	Number(3,0)	SMALLINT NOT NULL	End Depreciation Period
99	RETIRED_SW	Character(1)	VARCHAR2(1) NOT NULL	Retired Y/N Table Edit Default Value: N
100	RETIRE_CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Retirement Convention Prompt Table: CONV_BOOK_VW
101	DEPR_BONUS_SW	Character(3)	VARCHAR2(3) NOT NULL	Resolution Date Description -------------- ------- ------------------ 753343 03/13/08 New depreciation bonus:Stimulus Act is added. 0=None 1=Section 101 - Federal 2=New York Liberty Zone 3=Section 101 - Local 4=Gulf Opportunity Zone 5=Stimulus Act 6=American Recovery&Reinvestment Default Value: 0 Prompt Table: AM_DEPR_BONUS
102	DEPR_BONUS_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Depreciation Bonus Percent
103	TOT_OBLIGATION	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Lease Total Obligation
104	IMPAIR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Impairment Process
105	LAST_IMPAIR_DT	Date(10)	DATE	Last Impairment Date
106	ADJUST_CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Adjustment Convention Default Value: AM Prompt Table: CONV_BOOK_VW
107	LAST_REVALUE_DT	Date(10)	DATE	Last Revaluation Date
108	FULLY_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Retire As Fully Depreciated SW F=Fully Depr with Future Expense N=Calculate Gain/Loss Y=Fully Depr no Future Expense Default Value: N
109	BK_CAP_THRSHLD_ID	Character(10)	VARCHAR2(10) NOT NULL	Threshold ID
110	AM_CAP_STATUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Physical Book Cost