| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsId | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | Name | Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | DocType | Template Type | char | 1 | 0 | | B | A=Cost Accounting, B=Balance Sheet, C=Trial Balance, D=Profit Distribution, E=Asset Devalue Provision, F=Statement of Cash Flows, G=Others, H=Asset History Sheet, I=Taxable Profit and Loss, J=Appropriation of Net Profit, K=E-Asset History Sheet, L=e-Balance Sheet, O=e-Profit and Loss, P=Profit and Loss, R=Shareholder's Rights and Interests | Allow NULL? |
| 4 | FRTCounter | Financial Report Template Counter | int | 6 | 0 | | | | Allow NULL? |
| 5 | MoveChk1 | Move Chk1 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | MoveChk2 | Move Chk2 | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 7 | MoveTo_1 | Move To 1 | int | 6 | 0 | | 0 | | Allow NULL? |
| 8 | MoveTo_2 | Move To 2 | int | 6 | 0 | | 0 | | Allow NULL? |
| 9 | Title_1 | Title 1 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 10 | Title_2 | Title 2 | nvarchar | 100 | 0 | | | | Allow NULL? |
| 11 | ShowMiss | Display Missing Accounts | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 12 | ToTitle_1 | Move To Title 1 | int | 6 | 0 | | 0 | | Allow NULL? |
| 13 | ToTitle_2 | Move To Title 2 | int | 6 | 0 | | 0 | | Allow NULL? |
| 14 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 15 | DimCode | In Which Dimension | int | 11 | 0 | ODIM | | | Allow NULL? |
