DEPR_CAP_YR_TBL (SQL Table)	Index Back
Capitalization Yearly Limits

DEPR_CAP_YR_TBL

(SQL Table)

Capitalization Yearly Limits

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 COST_LIMIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Limit Code

3 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

4 LOW_VALUE_SW Character(1) VARCHAR2(1) NOT NULL Low Value Asset Only
Y/N Table Edit
Default Value: N

5 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	COST_LIMIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Cost Limit Code
3	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
4	LOW_VALUE_SW	Character(1)	VARCHAR2(1) NOT NULL	Low Value Asset Only Y/N Table Edit Default Value: N
5	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code