| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | OFTT | | | Allow NULL? |
| 2 | LineNum | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | FileName | Data Definition File Name | nvarchar | 254 | 0 | | | | Allow NULL? |
| 4 | ReleaDate | Release Date | date | 8 | 0 | | | | |
| 5 | Descript | Description | nvarchar | 100 | 0 | | | | Allow NULL? |
| 6 | Localizat | Localization | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | ChartAcct | Chart of Accounts | nvarchar | 128 | 0 | | | | Allow NULL? |
| 8 | 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? |
| 9 | DimCode | Dimension Code | int | 11 | 0 | ODIM | | | Allow NULL? |