BOOK_STAGE(SQL Table) |
Index Back |
---|---|
Financial BookAM Book Information |
# | 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 | DTTM_STAMP | DateTime(26) | TIMESTAMP | 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. |
5 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
6 | AM_TRANS_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Differentiate data source for transaction staging tables.
AWF=AM Workflow |
7 | IN_SERVICE_DT | Date(10) | DATE | In Service Date |
8 | IN_SERVICE_PD | Number(3,0) | SMALLINT NOT NULL | In service Period |
9 | IN_SERVICE_FY | Number(4,0) | SMALLINT NOT NULL | In Service Fiscal Year |
10 | 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 |
11 | BEGIN_DEPR_DT | Date(10) | DATE | Begin Depr Date |
12 | BEGIN_DEPR_PD | Number(3,0) | SMALLINT NOT NULL | Begin Depreciation Period |
13 | BEGIN_DEPR_FY | Number(4,0) | SMALLINT NOT NULL | Begin Depreciation Fiscal Year |
14 | BEGIN_FRACTION | Signed Number(17,13) | DECIMAL(15,13) NOT NULL | Begin Depr Period Fraction |
15 | DEPR_CALC_SW | Character(1) | VARCHAR2(1) NOT NULL | Depreciation Calculation Sw |
16 | BEGIN_CALC_DT | Date(10) | DATE | Begin Depreciation Calc Date |
17 | BEGIN_CALC_PD | Number(3,0) | SMALLINT NOT NULL | Begin Calculation Period |
18 | BEGIN_CALC_FY | Number(4,0) | SMALLINT NOT NULL | Begin Calculation Fiscal Yr |
19 | CALCULATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Type
L=Life-to-Date R=Remaining Value Default Value: R |
20 | LAST_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Last Calculation Type |
21 | RSV_FRACTION | Signed Number(17,13) | DECIMAL(15,13) NOT NULL | Reserve Fraction (RSV/Cost) |
22 | RECALC_RSV_SW | Character(1) | VARCHAR2(1) NOT NULL | Recalculate RSV Fraction (Y/N) |
23 | SCHED_FRACTION | Signed Number(17,13) | DECIMAL(15,13) NOT NULL | Fraction of Schedule Elapsed |
24 | YEAR_REM_FRACTION | Signed Number(17,13) | DECIMAL(15,13) NOT NULL | Year Remaining Fraction |
25 | DEPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Status
D=Depreciable N=Non Depreciable |
26 | 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 |
27 | RECOVERY_LIFE | Number(4,1) | DECIMAL(3,1) NOT NULL | Recovery Life |
28 | RECOVERY_SUBTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Recovery SubType
LI=Low-Income Housing PU=Public Utility Property |
29 | FUTURE_DEPR_YEARS | Number(3,0) | SMALLINT NOT NULL | No of Future Depreciation Year |
30 | CONVENTION | Character(2) | VARCHAR2(2) NOT NULL |
Book Depreciation Convention
or Cost Convention
Prompt Table: CONV_BOOK_VW |
31 | LIFE | Number(4,0) | SMALLINT NOT NULL | Useful Life |
32 | LIFE_REMAINING | Signed Number(17,11) | DECIMAL(15,11) NOT NULL | Remaining Life |
33 | TAX_CLASS_AM | Character(6) | VARCHAR2(6) NOT NULL |
Guideline Tax Class
Prompt Table: TAX_CLASS_AM |
34 | DEPR_PERCENT | Number(10,8) | DECIMAL(9,8) NOT NULL | Depreciation Percent |
35 | DB_PERCENT | Number(16,14) | DECIMAL(15,14) NOT NULL | Declining Balance Percent |
36 | 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 |
37 | DEPR_SCHED_CD | Character(10) | VARCHAR2(10) NOT NULL |
Schedule Code
Prompt Table: DEPR_SCHED_TBL |
38 | DEPR_LIMIT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Depreciation Limit Code
Prompt Table: DEPR_LIM_TBL |
39 | PROPERTY_CD | Character(1) | VARCHAR2(1) NOT NULL |
Property Code
1=1245 Property 2=1250 Property Default Value: 1 |
40 | PROPERTY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Property Type
P=Personal R=Non-Residential Real S=Residential Real Default Value: P |
41 | SALVAGE_VAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Salvage Value |
42 | SALVAGE_PCT | Number(16,14) | DECIMAL(15,14) NOT NULL | Salvage Percentage |
43 | TAX_CREDIT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Tax Credit Switch
Default Value: N |
44 | BASIS_RED_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Credit Basis Reduction Total |
45 | BASIS_RED_RECAP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Basis Reduction Recapture |
46 | 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 |
47 | SEC179_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Section 179 Taken Amount |
48 | LIFE_END_DT | Date(10) | DATE | Useful Life End Date |
49 | DEPR_LOW_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Depr Low Limit Amount |
50 | SUSPEND_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Suspend Status
N=Depreciation Has Been Resumed Y=Depreciation Is Suspended |
51 | SUSPEND_DT | Date(10) | DATE | Suspend Date |
52 | RESUME_DT | Date(10) | DATE | Resume Date |
53 | SUSPENDED_PERIODS | Number(4,0) | SMALLINT NOT NULL | Number of Suspended Periods |
54 | COST_BASIS_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cost Basis Limit |
55 | DEPR_AVG_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Depreciation Averaging Option
M=Monthly Averaging N=No Averaging Y=Yearly Averaging Default Value: N |
56 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Group Asset ID
Prompt Table: BU_GRP_ASSET_VW |
57 | UOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Units of Production ID
Prompt Table: UOP_TBL |
58 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
59 | INCLUDE_CAP_GAINS | Character(1) | VARCHAR2(1) NOT NULL |
CGT Applicable
Y/N Table Edit Default Value: Y |
60 | UD_METHOD_ID | Character(5) | VARCHAR2(5) NOT NULL |
Method ID
Prompt Table: UD_METHOD |
61 | PERIOD_DEPR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Depreciate By Period
Y/N Table Edit Default Value: N |
62 | ACCOUNTING_MTHD | Character(3) | VARCHAR2(3) NOT NULL |
Accounting Method
ALL=Allowance EXP=Expense RES=Reserve |
63 | DEPR_PASS_LIFE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Depreciate Pass Life SW
Y/N Table Edit Default Value: N |
64 | LISTED_PROP | Character(1) | VARCHAR2(1) NOT NULL |
Listed Property?
Y/N Table Edit Default Value: N |
65 | 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 |
66 | BUS_USE_PERCENT | Number(10,8) | DECIMAL(9,8) NOT NULL | Business Use % |
67 | CHILD_TK_PARENT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Child Inherits Parent's Life
Y/N Table Edit Default Value: N |
68 | ARCHIVE_ID | Character(8) | VARCHAR2(8) NOT NULL | Archive ID |
69 | SEC_291 | Character(1) | VARCHAR2(1) NOT NULL |
Corporation Sec.291
N=Not Corporation Sec291 Y=Corporation Sec291 |
70 | DEPR_LIMIT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Depreciation Limit Percent |
71 | 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 |
72 | 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. |
73 | SPECIAL_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Special Terms
Prompt Table: DEPR_TERMS_TBL |
74 | ACCELERATED_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Accelerated Terms
Prompt Table: DEPR_TERMS_TBL |
75 | INITIAL_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Initial Terms
Prompt Table: DEPR_TERMS_TBL |
76 | INCREASE_RATE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Increased Rate |
77 | SPECIAL_DEPR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Special Depreciation
Y/N Table Edit Default Value: N |
78 | LIFE_IN_YRS | Number(6,1) | DECIMAL(5,1) NOT NULL | Life in Years |
79 | RETIREMENT_DT | Date(10) | DATE | Projected Retirement Date |
80 | YEAR_CHANGE | Number(4,0) | SMALLINT NOT NULL | Year of change |
81 | LOW_VALUE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Low Value Asset Only
Y/N Table Edit Default Value: N |
82 | BUSINESS_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Business Tax
Y/N Table Edit Default Value: N |
83 | BUSINESS_TAX_BASIS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Business Tax Basis |
84 | LAST_BK_DTTM_STAMP | DateTime(26) | TIMESTAMP | Last Book Dttm Stamp |
85 | LAST_TRANS_DT | Date(10) | DATE | Last Transaction Date |
86 | LAST_ACCOUNTING_DT | Date(10) | DATE | Last Accounting Date |
87 | IUT_DEPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Depreciation Status
H=Hold Depreciation N=None |
88 | SUS_DEPR_ACCUM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Suspended Depreciation Accum |
89 | SUS_DEPR_YTD | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Suspend Depreciation YTD |
90 | SUS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Suspend DateTime Stamp |
91 | AM_BK_UD_CHAR1 | Character(10) | VARCHAR2(10) NOT NULL | User Defined Char Field1 |
92 | AM_BK_UD_CHAR2 | Character(10) | VARCHAR2(10) NOT NULL | User Defined Char Field2 |
93 | AM_BK_UD_DATE1 | Date(10) | DATE | User Defined Date Field1 |
94 | AM_BK_UD_NUM1 | Number(19,3) | DECIMAL(18,3) NOT NULL | User Defined Number Field1 |
95 | AM_BK_UD_NUM2 | Number(19,3) | DECIMAL(18,3) NOT NULL | User Defined Number Field2 |
96 | DEROGATORY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Derogatory Depreciation
Y/N Table Edit Default Value: N |
97 | CCA_50_FLG | Character(1) | VARCHAR2(1) NOT NULL |
g
Y/N Table Edit Default Value: Y |
98 | CF_SEQNO_LAST | Number(6,0) | INTEGER NOT NULL | Last Chartfield Sequence Numbe |
99 | END_DEPR_DT | Date(10) | DATE | End Depreciation Date |
100 | END_DEPR_FY | Number(4,0) | SMALLINT NOT NULL | End Depreciation Year |
101 | END_DEPR_PD | Number(3,0) | SMALLINT NOT NULL | End Depreciation Period |
102 | RETIRED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Retired
Y/N Table Edit Default Value: N |
103 | RETIRE_CONVENTION | Character(2) | VARCHAR2(2) NOT NULL |
Retirement Convention
Prompt Table: CONV_BOOK_VW |
104 | 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 |
105 | DEPR_BONUS_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Depreciation Bonus Percent |
106 | TOT_OBLIGATION | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Lease Total Obligation |
107 | IMPAIR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Impairment Process |
108 | LAST_IMPAIR_DT | Date(10) | DATE | Last Impairment Date |
109 | ADJUST_CONVENTION | Character(2) | VARCHAR2(2) NOT NULL |
Adjustment Convention
Default Value: AM Prompt Table: CONV_BOOK_VW |
110 | LAST_REVALUE_DT | Date(10) | DATE | Last Revaluation Date |
111 | 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 |
112 | BK_CAP_THRSHLD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Threshold ID
Prompt Table: CAP_THR_DFN2_VW |
113 | AM_CAP_STATUS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Physical Book Cost
Y/N Table Edit Default Value: Y |