| 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 |