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 % |