| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_NONVW
|
| 2 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table:
SP_BOOK_NONVW
|
| 3 |
REQUIRED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Book is Required
Y/N Table Edit
Default Value: Y
|
| 4 |
BOOK_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Book Type
A=U.S. AMT Book
F=Corporate Book
P=Corporate w/Tax Info
T=Main Tax Book
Default Value: F
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 6 |
CAPITALIZATION_MIN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Capitalization Minimum
|
| 7 |
LEASE_CAP_MIN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Lease Cap. Minimum
|
| 8 |
DISTRIBUTION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Switch
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 9 |
DISPOSAL_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by Disposal Code
Y/N Table Edit
Default Value: N
|
| 10 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 11 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_BU_GL5_NONVW
|
| 12 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_BU_GL2_NONVW
|
| 13 |
BUD_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Ledger Group
Prompt Table:
SP_BU_GL4_NONVW
|
| 14 |
BUDGET_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Ledger
Prompt Table:
SP_BU_GL3_NONVW
|
| 15 |
ACCT_ENT_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Entry Template ID
Default Value: INSTALLATION_AM.ACCT_ENT_TMPL_ID
Prompt Table:
AMAE_TMPLID_TBL
|
| 16 |
CAL_DEPR_PD |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar
Prompt Table:
CAL_DEFN_DPR_VW
|
| 17 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 18 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 19 |
GROUP_PROC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Asset Processing
Y/N Table Edit
|
| 20 |
CHILD_TK_PARENT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Inherits Parent's Life
Y/N Table Edit
Default Value: N
|
| 21 |
INFL_ADJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Inflation Processing
N=No
Y=Yes
Default Value: N
|
| 22 |
CALC_TYPE_INFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Type
A=Argentina Adjustment
B=Brazil Adjustment
C=Mexico Adjustments
Default Value: C
|
| 23 |
DAY_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Daily Calculation
N=No
Y=Yes
Default Value: N
|
| 24 |
COST_LIMIT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Limit Code
Prompt Table:
DEPR_CAP_TBL
|
| 25 |
DEROGATORY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Derogatory Depreciation
Y/N Table Edit
Default Value: N
|
| 26 |
BOOK_STATUTORY |
Character(10) |
VARCHAR2(10) NOT NULL |
Statutory Book
Prompt Table:
SP_BOOK_NONVW
|
| 27 |
ROUND_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Round Type
C=Currency
G=Generic
Default Value: C
|
| 28 |
ROUND_RULE_AM |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
Default Value: N
|
| 29 |
ROUND_PRECISION |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Rounding Precision
|
| 30 |
ROUND_FACTOR |
Number(15,7) |
DECIMAL(14,7) NOT NULL |
Rounding Factor
|
| 31 |
TRUNCATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Round Up. 'Y'es - truncate 1 decimal place past the round precision. 'N' - do not truncate
Y/N Table Edit
Default Value: Y
|
| 32 |
STORE_DEPR_BY_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
Store Depr By Period
Y/N Table Edit
Default Value: N
|
| 33 |
ALLOW_AUTO_RET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto-Retire Fully Depr Assets
N=No
Y=Yes
Y/N Table Edit
|
| 34 |
LOW_VALUE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Low Value Asset Only
Y/N Table Edit
|
| 35 |
ONLINE_RPT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
On-Line Reporting
Y/N Table Edit
|
| 36 |
TRANSLATE_GL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Translate Gain/Loss
Y/N Table Edit
|
| 37 |
TRANSLATE_ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Translate Account
Prompt Table:
GL_ACCT_CUR_VW
|
| 38 |
BKC_DIST_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Book Code Distribution Code
Prompt Table:
BKC_DST_GRP
|
| 39 |
IMPAIR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Impairment Process
Y/N Table Edit
Default Value: N
|
| 40 |
IMP_REVERSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Impairment Reversal
Y/N Table Edit
Default Value: N
|
| 41 |
IMP_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type For Impairment Loss
Prompt Table:
COST_TYPE_VW1
|
| 42 |
REVERSE_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type for Imp Reversal
Prompt Table:
COST_TYPE_VW1
|
| 43 |
NEG_DEPR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Stop Depr when NBV < Salvage
Y/N Table Edit
Default Value: N
|
| 44 |
REVALUE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Revaluation Process
Y/N Table Edit
Default Value: N
|
| 45 |
REVAL_WRT_OFF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Revaluation Write-Off
Y/N Table Edit
Default Value: N
|
| 46 |
REVAL_REVERSAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Revaluation Reversal
Y/N Table Edit
Default Value: N
|
| 47 |
REVAL_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type for Revaluation
Prompt Table:
COST_TYPE_VW
|
| 48 |
REVAL_WRTOFF_CS_TY |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type for Reval Write-Off
Prompt Table:
COST_TYPE_VW
|
| 49 |
IMP_REVER_CST_TY |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type For Reval Reversal
Prompt Table:
COST_TYPE_VW
|
| 50 |
REVALUE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Revaluation Method
C=Cost Based
D=Depr. Write-Off
I=Investment Property
|
| 51 |
REVAL_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rev. Trans. Code
Default Value: RV
Prompt Table:
TRANS_CODE_VW
|
| 52 |
INVEST_PROPERTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Investment Property
Y/N Table Edit
Default Value: N
|
| 53 |
INV_PROP_TRANS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Investment Property Trans Code
Prompt Table:
TRANS_CODE_VW
|
| 54 |
CHART_EDIT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield Edit Option
D=Default from Higher Level
K=Reject w/ edit error
N=No Edits
R=Recycle
S=Use suspense account
W=Warning
Default Value: N
|