| 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 | BalanceAct | Asset Balance Sheet Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 4 | ClrAcqAct | Acquisition Clearing Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 5 | RevResvAct | Revaluation Reserve | nvarchar | 15 | 0 | | | | Allow NULL? |
| 6 | OrdDprAct | Ordinary Depreciation | nvarchar | 15 | 0 | | | | Allow NULL? |
| 7 | OrdDprAcc | Accumulated Ordinary Depr. | nvarchar | 15 | 0 | | | | Allow NULL? |
| 8 | UnpDprAct | Unplanned Depreciation | nvarchar | 15 | 0 | | | | Allow NULL? |
| 9 | UnpDprAcc | Accumulated Unplanned Depr. | nvarchar | 15 | 0 | | | | Allow NULL? |
| 10 | SpDprAct | Special Depreciation | nvarchar | 15 | 0 | | | | Allow NULL? |
| 11 | SpDprAcc | Accumulated Special Depr. | nvarchar | 15 | 0 | | | | Allow NULL? |
| 12 | SaRevNAct | Revenue from Asset Sales (Net) | nvarchar | 15 | 0 | | | | Allow NULL? |
| 13 | ReExpNAct | Retirement with Expense (Net) | nvarchar | 15 | 0 | | | | Allow NULL? |
| 14 | ReRevNAct | Retirement with Revenue (Net) | nvarchar | 15 | 0 | | | | Allow NULL? |
| 15 | ReNBVeAct | NBV Retirement Expense (Gross) | nvarchar | 15 | 0 | | | | Allow NULL? |
| 16 | ReNBVrAct | NBV Retirement Revenue (Gross) | nvarchar | 15 | 0 | | | | Allow NULL? |
| 17 | ClrDscAct | Cash Discount Clearing Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 18 | RevReAct | Revenue Account for Retirement | nvarchar | 15 | 0 | | | | Allow NULL? |
| 19 | 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? |
| 20 | UserSign | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 21 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 22 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 23 | UserSign2 | Updating User | int | 6 | 0 | | | | Allow NULL? |
| 24 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 25 | ClearAccRe | Revenue Clearing Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 26 | RevResvClr | Revaluation Reserve Clearing | nvarchar | 15 | 0 | | | | Allow NULL? |
| 27 | SnapshotId | Snapshot ID | int | 11 | 0 | | 0 | | Allow NULL? |
