BOOK_SL

(SQL Table)
Index Back

Financial Book

# 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 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Prompt Table: CONV_TBL

27 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
28 LIFE_REMAINING Signed Number(17,11) DECIMAL(15,11) NOT NULL Remaining Life
29 TAX_CLASS_AM Character(6) VARCHAR2(6) NOT NULL Guideline Tax Class

Prompt Table: TAX_CLASS_AM

30 DEPR_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Depreciation Percent
31 DB_PERCENT Number(16,14) DECIMAL(15,14) NOT NULL Declining Balance Percent
32 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
33 DEPR_SCHED_CD Character(10) VARCHAR2(10) NOT NULL Schedule Code

Prompt Table: DEPR_SCHED_TBL

34 DEPR_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Depreciation Limit Code

Prompt Table: DEPR_LIM_TBL

35 PROPERTY_CD Character(1) VARCHAR2(1) NOT NULL Property Code
1=1245 Property
2=1250 Property

Default Value: 1

36 PROPERTY_TYPE Character(1) VARCHAR2(1) NOT NULL Property Type
P=Personal
R=Non-Residential Real
S=Residential Real

Default Value: P

37 SALVAGE_VAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
38 SALVAGE_PCT Number(16,14) DECIMAL(15,14) NOT NULL Salvage Percentage
39 TAX_CREDIT_SW Character(1) VARCHAR2(1) NOT NULL Tax Credit Switch

Default Value: N

40 BASIS_RED_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Basis Reduction Total
41 BASIS_RED_RECAP Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Reduction Recapture
42 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

43 SEC179_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Section 179 Taken Amount
44 LIFE_END_DT Date(10) DATE Useful Life End Date
45 DEPR_LOW_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Depr Low Limit Amount
46 SUSPEND_STATUS Character(1) VARCHAR2(1) NOT NULL Suspend Status
N=Depreciation Has Been Resumed
Y=Depreciation Is Suspended
47 SUSPEND_DT Date(10) DATE Suspend Date
48 RESUME_DT Date(10) DATE Resume Date
49 SUSPENDED_PERIODS Number(4,0) SMALLINT NOT NULL Number of Suspended Periods
50 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit
51 DEPR_AVG_OPTION Character(1) VARCHAR2(1) NOT NULL Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging

Default Value: N

52 UOP_ID Character(10) VARCHAR2(10) NOT NULL Units of Production ID

Prompt Table: UOP_TBL

53 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

Prompt Table: BK_GRP_ASSET_VW

54 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
55 INCLUDE_CAP_GAINS Character(1) VARCHAR2(1) NOT NULL CGT Applicable

Y/N Table Edit

Default Value: Y

56 UD_METHOD_ID Character(5) VARCHAR2(5) NOT NULL Method ID

Prompt Table: UD_METHOD

57 PERIOD_DEPR_SW Character(1) VARCHAR2(1) NOT NULL Depreciate By Period

Y/N Table Edit

Default Value: N

58 DEPR_PASS_LIFE_SW Character(1) VARCHAR2(1) NOT NULL Depreciate Pass Life SW

Y/N Table Edit

59 LISTED_PROP Character(1) VARCHAR2(1) NOT NULL Listed Property?

Y/N Table Edit

60 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
61 BUS_USE_PERCENT Number(10,8) DECIMAL(9,8) NOT NULL Business Use %