|
|
DTW Fixed Assets Depreciation Types
API Depreciation Types Service / Depreciation Type
ODTP - Fixed Assets Depreciation Types Table
Depreciation Type DepreciationType Object· Table: ODTP
Parent: Depreciation Types Service DepreciationTypesService Service· Table: ODTP
Depreciation Types Service DepreciationTypesService Service· Table: ODTP
Fixed Assets Depreciation Types ODTP SQL Table
Depreciation Type Pools ODPP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 15 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Descr | Description | nVarChar | 100 | |||||
| DprMeth | Depreciation Method | nVarChar | 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 | 2 | NO | |||
| DprTo | Minimum Depreciated Value | Num | 20 | |||||
| Rounding | Round Year End Book Value | VarChar | Y) Yes N) No | 1 | Y | |||
| InclSalv | Include Salvage Value in Depr. | VarChar | Y) Yes N) No | 1 | N | |||
| SalvPerc | Percentage for Salvage Value | Num | 20 | |||||
| PerAcq | Period Control for Acquisition | nVarChar | PR) Pro Rata Temporis HY) First Year Convention 6M) Half Year FY) Full Year | 2 | PR | |||
| PerSubAcq | Period Control Subacquisition | nVarChar | PR) Pro Rata Temporis YR) Half Year Convention FY) Full Year | 2 | PR | |||
| PerRet | Period Control for Retirement | nVarChar | PR) Pro Rata Temporis YR) Half Year Convention EL) After End of Useful Life | 2 | PR | |||
| AcqPRTyp | Type of PRT for Acquisition | nVarChar | EDB) Exact Daily Base FCP) First Day of Current Period FNP) First Day of Next Period | 3 | EDB | |||
| SubPRTyp | Type of PR for Subacquisition | nVarChar | EDB) Exact Daily Base FCP) First Day of Current Period FNP) First Day of Next Period | 3 | EDB | |||
| RetPRTyp | Type of PR for Retirement | nVarChar | EDB) Exact Daily Base LPP) Last Day of Prior Period LCP) Last Day of Current Period | 3 | EDB | |||
| PerDpRev | Depreciation to Be Reversed % | Num | 20 | |||||
| ValidFrom | Valid From | Date | 8 | 19000101 | ||||
| ValidTo | Valid To | Date | 8 | 20991231 | ||||
| sCalcMeth | Calc. Method for Straight Line | nVarChar | APC) Acquisition Value/Total Useful Life PRC) Percentage of Acquisition Value NBV) Net Book Value/Remaining Life | 3 | APC | |||
| sPercent | Percentage for Straight Line | Num | 20 | |||||
| dBase | Base for Declining Balance | nVarChar | NBV) Net Book Value | 3 | NBV | |||
| dPercent | Percentage for Decl. Balance | Num | 20 | |||||
| dFactor | Factor for Declining Balance | Num | 20 | 1 | ||||
| dAltDprTyp | Auto. Change Depreciation Type | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| maDecBase | Reduce Depreciation Base | VarChar | Y) Yes N) No | 1 | Y | |||
| spMeth | Calc. Method for Special Depr. | VarChar | D) Additional A) Alternative | 1 | D | |||
| spConcPer | Concession Period in Years | Int | 11 | |||||
| spMaxPerc | Maximum Percentage | Num | 20 | |||||
| spAdDpr | Normal Depreciation | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| spAlDpr | Alternative Depreciation | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| PoolID | Depreciation Type Pool ID | nVarChar | 2 | ODPP Depreciation Type Pools | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Create Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| DprPer | Depreciation Periods | VarChar | S) Standard I) Individual | 1 | S | |||
| PerFactor | Period Factor | Num | 20 | 1 | ||||
| spMaxAmnt | Maximum Amount | Num | 20 | |||||
| spMaxFlag | Max. [Percentage\Amount] | VarChar | P) Percentage A) Amount | 1 | P | |||
| CalcBase | Calculation Base | VarChar | Y) Yearly M) Monthly | 1 | Y | |||
| DeprEndLFY | Depr. End at Last Full Year | VarChar | Y) Yes N) No | 1 | N | |||
| AccuPriorP | Accu. Depr. of Prior Periods | VarChar | Y) Yes N) No | 1 | N | |||
| DeltaCoeff | Delta Coefficient | Int | 11 | 0 | ||||
| MaxDepr | Maximum Depreciable Value | Num | 20 | |||||
| FactorFFY | Factor Only Relevant to FFY | VarChar | Y) Yes N) No | 1 | N | |||
| SnapshotId | Snapshot ID | Int | 11 | 0 | ||||
| PerTranSou | Period Control Transfer Source | nVarChar | PR) Pro Rata Temporis | 2 | PR | |||
| PerTranTar | Period Control Transfer Target | nVarChar | PR) Pro Rata Temporis | 2 | PR | |||
| TranSPRTyp | Type of PR for Transfer Source | nVarChar | EDB) Exact Daily Base LPP) Last Day of Prior Period LCP) Last Day of Current Period | 3 | EDB | |||
| TranTPRTyp | Type of PR for Transfer Target | nVarChar | EDB) Exact Daily Base FCP) First Day of Current Period FNP) First Day of Next Period | 3 | EDB |
Table relationship map
SELECT statement
SELECT
ODTP.Code AS 'Code',
ODTP.Descr AS 'Description',
ODTP.DprMeth AS 'Depreciation Method',
ODTP.DprTo AS 'Minimum Depreciated Value',
ODTP.Rounding AS 'Round Year End Book Value',
ODTP.InclSalv AS 'Include Salvage Value in Depr.',
ODTP.SalvPerc AS 'Percentage for Salvage Value',
ODTP.PerAcq AS 'Period Control for Acquisition',
ODTP.PerSubAcq AS 'Period Control Subacquisition',
ODTP.PerRet AS 'Period Control for Retirement',
ODTP.AcqPRTyp AS 'Type of PRT for Acquisition',
ODTP.SubPRTyp AS 'Type of PR for Subacquisition',
ODTP.RetPRTyp AS 'Type of PR for Retirement',
ODTP.PerDpRev AS 'Depreciation to Be Reversed %',
ODTP.ValidFrom AS 'Valid From',
ODTP.ValidTo AS 'Valid To',
ODTP.sCalcMeth AS 'Calc. Method for Straight Line',
ODTP.sPercent AS 'Percentage for Straight Line',
ODTP.dBase AS 'Base for Declining Balance',
ODTP.dPercent AS 'Percentage for Decl. Balance',
ODTP.dFactor AS 'Factor for Declining Balance',
ODTP.dAltDprTyp AS 'Auto. Change Depreciation Type',
ODTP.maDecBase AS 'Reduce Depreciation Base',
ODTP.spMeth AS 'Calc. Method for Special Depr.',
ODTP.spConcPer AS 'Concession Period in Years',
ODTP.spMaxPerc AS 'Maximum Percentage',
ODTP.spAdDpr AS 'Normal Depreciation',
ODTP.spAlDpr AS 'Alternative Depreciation',
ODTP.PoolID AS 'Depreciation Type Pool ID',
ODTP.DataSource AS 'Data Source',
ODTP.UserSign AS 'User Signature',
ODTP.LogInstanc AS 'Log Instance',
ODTP.CreateDate AS 'Create Date',
ODTP.UserSign2 AS 'Updating User',
ODTP.UpdateDate AS 'Date of Update',
ODTP.DprPer AS 'Depreciation Periods',
ODTP.PerFactor AS 'Period Factor',
ODTP.spMaxAmnt AS 'Maximum Amount',
ODTP.spMaxFlag AS 'Max. [Percentage\Amount]',
ODTP.CalcBase AS 'Calculation Base',
ODTP.DeprEndLFY AS 'Depr. End at Last Full Year',
ODTP.AccuPriorP AS 'Accu. Depr. of Prior Periods',
ODTP.DeltaCoeff AS 'Delta Coefficient',
ODTP.MaxDepr AS 'Maximum Depreciable Value',
ODTP.FactorFFY AS 'Factor Only Relevant to FFY',
ODTP.SnapshotId AS 'Snapshot ID',
ODTP.PerTranSou AS 'Period Control Transfer Source',
ODTP.PerTranTar AS 'Period Control Transfer Target',
ODTP.TranSPRTyp AS 'Type of PR for Transfer Source',
ODTP.TranTPRTyp AS 'Type of PR for Transfer Target'
FROM ODTP AS ODTP
Related information
Depreciation Type DepreciationType Object· Table: ODTP
In SAP Business One, you can use depreciation types to define different depreciation calculation methods for your fixed assets.
After you create a depreciation type, you can assign it to a specific depreciation area of an asset class. Then, by...
Parent: Depreciation Types Service DepreciationTypesService Service· Table: ODTP Depreciation Types Service DepreciationTypesService Service· Table: ODTP
The DepreciationTypesService service enables you to create, update, and view depreciation types.
Source table: ODTP.
Fixed Assets Depreciation Types ODTP SQL Table
Depreciation Type Pools ODPP SQL Table
Users OUSR SQL Table
DepreciationTypesService
Object
DepreciationType
Collection
Enumeration
Method
Property
Code
DB
Description
DB
ValidFrom
DB
ValidTo
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
