| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Code | Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 2 | Descr | Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | DprMeth | Depreciation Method | nvarchar | 2 | 0 | | NO | CF=Accelerated, DB=Declining Balance, MD=Manual Depreciation, ML=Multilevel, NO=No Depreciation, SD=Special Depreciation, SL=Straight Line, SP=Straight Line Period Control, WO=Immediate Write-Off | Allow NULL? |
| 4 | DprTo | Minimum Depreciated Value | num | 19 | 6 | | | | Allow NULL? |
| 5 | Rounding | Round Year End Book Value | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 6 | InclSalv | Include Salvage Value in Depr. | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 7 | SalvPerc | Percentage for Salvage Value | num | 19 | 6 | | | | Allow NULL? |
| 8 | PerAcq | Period Control for Acquisition | nvarchar | 2 | 0 | | PR | 6M=Half Year, FY=Full Year, HY=First Year Convention, PR=Pro Rata Temporis | Allow NULL? |
| 9 | PerSubAcq | Period Control Subacquisition | nvarchar | 2 | 0 | | PR | FY=Full Year, PR=Pro Rata Temporis, YR=Half Year Convention | Allow NULL? |
| 10 | PerRet | Period Control for Retirement | nvarchar | 2 | 0 | | PR | EL=After End of Useful Life, PR=Pro Rata Temporis, YR=Half Year Convention | Allow NULL? |
| 11 | AcqPRTyp | Type of PRT for Acquisition | nvarchar | 3 | 0 | | EDB | EDB=Exact Daily Base, FCP=First Day of Current Period, FNP=First Day of Next Period | Allow NULL? |
| 12 | SubPRTyp | Type of PR for Subacquisition | nvarchar | 3 | 0 | | EDB | EDB=Exact Daily Base, FCP=First Day of Current Period, FNP=First Day of Next Period | Allow NULL? |
| 13 | RetPRTyp | Type of PR for Retirement | nvarchar | 3 | 0 | | EDB | EDB=Exact Daily Base, LCP=Last Day of Current Period, LPP=Last Day of Prior Period | Allow NULL? |
| 14 | PerDpRev | Depreciation to Be Reversed % | num | 19 | 6 | | | | Allow NULL? |
| 15 | ValidFrom | Valid From | date | 8 | 0 | | 19000101 | | Allow NULL? |
| 16 | ValidTo | Valid To | date | 8 | 0 | | 20991231 | | Allow NULL? |
| 17 | sCalcMeth | Calc. Method for Straight Line | nvarchar | 3 | 0 | | APC | APC=Acquisition Value/Total Useful Life, NBV=Net Book Value/Remaining Life, PRC=Percentage of Acquisition Value | Allow NULL? |
| 18 | sPercent | Percentage for Straight Line | num | 19 | 6 | | | | Allow NULL? |
| 19 | dBase | Base for Declining Balance | nvarchar | 3 | 0 | | NBV | NBV=Net Book Value | Allow NULL? |
| 20 | dPercent | Percentage for Decl. Balance | num | 19 | 6 | | | | Allow NULL? |
| 21 | dFactor | Factor for Declining Balance | num | 19 | 6 | | 1 | | Allow NULL? |
| 22 | dAltDprTyp | Auto. Change Depreciation Type | nvarchar | 15 | 0 | ODTP | | | Allow NULL? |
| 23 | maDecBase | Reduce Depreciation Base | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 24 | spMeth | Calc. Method for Special Depr. | char | 1 | 0 | | D | A=Alternative, D=Additional | Allow NULL? |
| 25 | spConcPer | Concession Period in Years | int | 11 | 0 | | | | Allow NULL? |
| 26 | spMaxPerc | Maximum Percentage | num | 19 | 6 | | | | Allow NULL? |
| 27 | spAdDpr | Normal Depreciation | nvarchar | 15 | 0 | ODTP | | | Allow NULL? |
| 28 | spAlDpr | Alternative Depreciation | nvarchar | 15 | 0 | ODTP | | | Allow NULL? |
| 29 | PoolID | Depreciation Type Pool ID | nvarchar | 2 | 0 | ODPP | | | Allow NULL? |
| 30 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 31 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 32 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 33 | CreateDate | Create Date | date | 8 | 0 | | | | |
| 34 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 35 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 36 | DprPer | Depreciation Periods | char | 1 | 0 | | S | I=Individual, S=Standard, U=Individual Usage | Allow NULL? |
| 37 | PerFactor | Period Factor | num | 19 | 6 | | 1 | | Allow NULL? |
| 38 | spMaxAmnt | Maximum Amount | num | 19 | 6 | | | | Allow NULL? |
| 39 | spMaxFlag | Max. [PercentageAmount] | char | 1 | 0 | | P | A=Amount, P=Percentage | Allow NULL? |
| 40 | CalcBase | Calculation Base | char | 1 | 0 | | Y | M=Monthly, Y=Yearly | Allow NULL? |
| 41 | DeprEndLFY | Depr. End at Last Full Year | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 42 | AccuPriorP | Accu. Depr. of Prior Periods | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 43 | DeltaCoeff | Delta Coefficient | int | 11 | 0 | | 0 | | Allow NULL? |
| 44 | MaxDepr | Maximum Depreciable Value | num | 19 | 6 | | | | Allow NULL? |
| 45 | FactorFFY | Factor Only Relevant to FFY | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 46 | SnapshotId | Snapshot ID | int | 11 | 0 | | 0 | | Allow NULL? |
| 47 | PerTranSou | Period Control Transfer Source | nvarchar | 2 | 0 | | PR | PR=Pro Rata Temporis | Allow NULL? |
| 48 | PerTranTar | Period Control Transfer Target | nvarchar | 2 | 0 | | PR | PR=Pro Rata Temporis | Allow NULL? |
| 49 | TranSPRTyp | Type of PR for Transfer Source | nvarchar | 3 | 0 | | EDB | EDB=Exact Daily Base, LCP=Last Day of Current Period, LPP=Last Day of Prior Period | Allow NULL? |
| 50 | TranTPRTyp | Type of PR for Transfer Target | nvarchar | 3 | 0 | | EDB | EDB=Exact Daily Base, FCP=First Day of Current Period, FNP=First Day of Next Period | Allow NULL? |
