HIST_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	DTTM_STAMP	DateTime(26)	TIMESTAMP NOT NULL	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BU_BK_NONVW
5	BOOK_CHANGE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Book Change Type ADD=Add LFE=Life Ext. MTH=Method MUL=Multi Chng OTH=Other RCL=Recalc RES=Resume RRC=Rate Change SUS=Suspend TRF=Transfer
6	TRANS_DT	Date(10)	DATE	Transaction Date
7	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
8	IN_SERVICE_DT	Date(10)	DATE	In Service Date
9	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
10	DEPR_CALC_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Calculation Sw
11	CALCULATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Type L=Life-to-Date R=Remaining Value Default Value: R
12	DEPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Status D=Depreciable N=Non Depreciable
13	CONVENTION	Character(2)	VARCHAR2(2) NOT NULL	Book Depreciation Convention or Cost Convention Prompt Table: CONV_BOOK_VW
14	LIFE	Number(4,0)	SMALLINT NOT NULL	Useful Life
15	DEPR_PERCENT	Number(10,8)	DECIMAL(9,8) NOT NULL	Depreciation Percent
16	DB_PERCENT	Number(16,14)	DECIMAL(15,14) NOT NULL	Declining Balance Percent
17	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
18	DEPR_SCHED_CD	Character(10)	VARCHAR2(10) NOT NULL	Schedule Code Prompt Table: DEPR_SCHED_TBL
19	DEPR_LIMIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Depreciation Limit Code Prompt Table: DEPR_LIM_TBL
20	LIFE_END_DT	Date(10)	DATE	Useful Life End Date
21	DEPR_LOW_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Depr Low Limit Amount
22	SUSPEND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Suspend Status N=Depreciation Has Been Resumed Y=Depreciation Is Suspended
23	SUSPEND_DT	Date(10)	DATE	Suspend Date
24	RESUME_DT	Date(10)	DATE	Resume Date
25	SUSPENDED_PERIODS	Number(4,0)	SMALLINT NOT NULL	Number of Suspended Periods
26	COST_BASIS_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cost Basis Limit
27	DEPR_AVG_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Depreciation Averaging Option M=Monthly Averaging N=No Averaging Y=Yearly Averaging Default Value: N
28	UOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Units of Production ID Prompt Table: UOP_TBL
29	GROUP_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Group Asset ID Prompt Table: BK_GRP_ASSET_VW
30	UD_METHOD_ID	Character(5)	VARCHAR2(5) NOT NULL	Method ID Prompt Table: UD_METHOD
31	PERIOD_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate By Period Y/N Table Edit Default Value: N
32	DEPR_PASS_LIFE_SW	Character(1)	VARCHAR2(1) NOT NULL	Depreciate Pass Life SW Y/N Table Edit Default Value: N
33	DEPR_LIMIT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Depreciation Limit Percent
34	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
35	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.
36	ACCOUNTING_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Accounting Method ALL=Allowance EXP=Expense RES=Reserve
37	SPECIAL_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Special Terms Prompt Table: DEPR_TERMS_TBL
38	ACCELERATED_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Accelerated Terms Prompt Table: DEPR_TERMS_TBL
39	INITIAL_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Initial Terms Prompt Table: DEPR_TERMS_TBL
40	INCREASE_RATE	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Increased Rate
41	SPECIAL_DEPR_SW	Character(1)	VARCHAR2(1) NOT NULL	Special Depreciation Y/N Table Edit Default Value: N
42	LIFE_IN_YRS	Number(6,1)	DECIMAL(5,1) NOT NULL	Life in Years
43	RETIREMENT_DT	Date(10)	DATE	Projected Retirement Date
44	YEAR_CHANGE	Number(4,0)	SMALLINT NOT NULL	Year of change
45	LOW_VALUE_SW	Character(1)	VARCHAR2(1) NOT NULL	Low Value Asset Only Y/N Table Edit Default Value: N
46	BUSINESS_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Business Tax Default Value: N
47	BUSINESS_TAX_BASIS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Business Tax Basis
48	DEROGATORY_SW	Character(1)	VARCHAR2(1) NOT NULL	Derogatory Depreciation Y/N Table Edit Default Value: N
49	CCA_50_FLG	Character(1)	VARCHAR2(1) NOT NULL	g
50	FUTURE_DEPR_YEARS	Number(3,0)	SMALLINT NOT NULL	No of Future Depreciation Year
51	BEGIN_DEPR_DT	Date(10)	DATE	Begin Depr Date
52	BEGIN_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Begin Depr Period Fraction
53	RSV_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Reserve Fraction (RSV/Cost)
54	SCHED_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Fraction of Schedule Elapsed
55	YEAR_REM_FRACTION	Signed Number(17,13)	DECIMAL(15,13) NOT NULL	Year Remaining Fraction
56	LIFE_REMAINING	Signed Number(17,11)	DECIMAL(15,11) NOT NULL	Remaining Life
57	SALVAGE_VAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Salvage Value
58	SALVAGE_PCT	Number(16,14)	DECIMAL(15,14) NOT NULL	Salvage Percentage
59	BASIS_RED_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Basis Reduction Total
60	BASIS_RED_RECAP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Basis Reduction Recapture
61	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
62	SEC179_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Section 179 Taken Amount
63	INCLUDE_CAP_GAINS	Character(1)	VARCHAR2(1) NOT NULL	CGT Applicable Y/N Table Edit Default Value: Y
64	BUS_USE_PERCENT	Number(10,8)	DECIMAL(9,8) NOT NULL	Business Use %
65	SEC_291	Character(1)	VARCHAR2(1) NOT NULL	Corporation Sec.291 N=Not Corporation Sec291 Y=Corporation Sec291
66	END_DEPR_DT	Date(10)	DATE	End Depreciation Date
67	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
68	DEPR_BONUS_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Depreciation Bonus Percent
69	IMPAIR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Impairment Process
70	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
71	BK_CAP_THRSHLD_ID	Character(10)	VARCHAR2(10) NOT NULL	Threshold ID Prompt Table: CAP_THR_DFN2_VW
72	AM_CAP_STATUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Physical Book Cost Y/N Table Edit Default Value: Y
73	TRANS_REV_SW	Character(1)	VARCHAR2(1) NOT NULL	3/10/2015 If Switch has a value 'Y' it denotes that BKS transaction can be reversed. This is important as we are adding new fields to BOOK_HIST table. Hence BKS cannot be reversed as long as there are atleast two rows in BOOK_HIST with value for newly added fields .