Fixed Assets Depreciation Types

Table Name: ODTP

Table Description: Fixed Assets Depreciation Types

Field	Description	Type	Size	Related	Default Value	Constraints
Code	Code	nVarChar	15	-
Descr	Description	nVarChar	100	-
DprMeth	Depreciation Method	nVarChar	2	-	NO	NO	No Depreciation
						SL	Straight Line
						SP	Straight Line Period Control
						DB	Declining Balance
						ML	Multilevel
						WO	Immediate Write-Off
						SD	Special Depreciation
						MD	Manual Depreciation
						CF	Accelerated
DprTo	Minimum Depreciated Value	Num	19.6	-
Rounding	Round Year End Book Value	VarChar	1	-	Y	Y	Yes
						N	No
InclSalv	Include Salvage Value in Depr.	VarChar	1	-	N	Y	Yes
						N	No
SalvPerc	Percentage for Salvage Value	Num	19.6	-
PerAcq	Period Control for Acquisition	nVarChar	2	-	PR	PR	Pro Rata Temporis
						HY	First Year Convention
						6M	Half Year
						FY	Full Year
PerSubAcq	Period Control Subacquisition	nVarChar	2	-	PR	PR	Pro Rata Temporis
						YR	Half Year Convention
						FY	Full Year
PerRet	Period Control for Retirement	nVarChar	2	-	PR	PR	Pro Rata Temporis
						YR	Half Year Convention
						EL	After End of Useful Life
AcqPRTyp	Type of PRT for Acquisition	nVarChar	3	-	EDB	EDB	Exact Daily Base
						FCP	First Day of Current Period
						FNP	First Day of Next Period
SubPRTyp	Type of PR for Subacquisition	nVarChar	3	-	EDB	EDB	Exact Daily Base
						FCP	First Day of Current Period
						FNP	First Day of Next Period
RetPRTyp	Type of PR for Retirement	nVarChar	3	-	EDB	EDB	Exact Daily Base
						LPP	Last Day of Prior Period
						LCP	Last Day of Current Period
PerDpRev	Depreciation to Be Reversed %	Num	19.6	-
ValidFrom	Valid From	Date	8	-	19000101
ValidTo	Valid To	Date	8	-	20991231
sCalcMeth	Calc. Method for Straight Line	nVarChar	3	-	APC	APC	Acquisition Value/Total Useful Life
						PRC	Percentage of Acquisition Value
						NBV	Net Book Value/Remaining Life
sPercent	Percentage for Straight Line	Num	19.6	-
dBase	Base for Declining Balance	nVarChar	3	-	NBV	NBV	Net Book Value
dPercent	Percentage for Decl. Balance	Num	19.6	-
dFactor	Factor for Declining Balance	Num	19.6	-	1
dAltDprTyp	Auto. Change Depreciation Type	nVarChar	15	ODTP
maDecBase	Reduce Depreciation Base	VarChar	1	-	Y	Y	Yes
						N	No
spMeth	Calc. Method for Special Depr.	VarChar	1	-	D	D	Additional
						A	Alternative
spConcPer	Concession Period in Years	Int	11	-
spMaxPerc	Maximum Percentage	Num	19.6	-
spAdDpr	Normal Depreciation	nVarChar	15	ODTP
spAlDpr	Alternative Depreciation	nVarChar	15	ODTP
PoolID	Depreciation Type Pool ID	nVarChar	2	ODPP
DataSource	Data Source	VarChar	1	-	N	N	Unknown
						I	Interface
						U	Update
						M	Import
						O	DI API
						S	Service Layer
						W	Web Client
						A	Doc. Generation Wizard
						D	Restore Wizard
						P	Partner Implementation
						T	Year Transfer
UserSign	User Signature	Int	6	OUSR
LogInstanc	Log Instance	Int	11	-	0
CreateDate	Create Date	Date	8	-
UserSign2	Updating User	Int	6	OUSR
UpdateDate	Date of Update	Date	8	-
DprPer	Depreciation Periods	VarChar	1	-	S	S	Standard
						I	Individual
						U	Individual Usage
PerFactor	Period Factor	Num	19.6	-	1
spMaxAmnt	Maximum Amount	Num	19.6	-
spMaxFlag	Max. [Percentage\Amount]	VarChar	1	-	P	P	Percentage
						A	Amount
CalcBase	Calculation Base	VarChar	1	-	Y	Y	Yearly
						M	Monthly
DeprEndLFY	Depr. End at Last Full Year	VarChar	1	-	N	Y	Yes
						N	No
AccuPriorP	Accu. Depr. of Prior Periods	VarChar	1	-	N	Y	Yes
						N	No
DeltaCoeff	Delta Coefficient	Int	11	-	0
MaxDepr	Maximum Depreciable Value	Num	19.6	-
FactorFFY	Factor Only Relevant to FFY	VarChar	1	-	N	Y	Yes
						N	No
SnapshotId	Snapshot ID	Int	11	-	0
PerTranSou	Period Control Transfer Source	nVarChar	2	-	PR	PR	Pro Rata Temporis
PerTranTar	Period Control Transfer Target	nVarChar	2	-	PR	PR	Pro Rata Temporis
TranSPRTyp	Type of PR for Transfer Source	nVarChar	3	-	EDB	EDB	Exact Daily Base
						LPP	Last Day of Prior Period
						LCP	Last Day of Current Period
TranTPRTyp	Type of PR for Transfer Target	nVarChar	3	-	EDB	EDB	Exact Daily Base
						FCP	First Day of Current Period
						FNP	First Day of Next Period
RoundMeth	Rounding Method	VarChar	1	-	N	N	Truncate to Integer
						U	Round Up to Integer
						D	Round Down to Integer

Key	Unique	Field
PRIMARY	Yes	Code