| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | BoxCode | Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 2 | BoxName | Name | nvarchar | 250 | 0 | | | | Allow NULL? |
| 3 | BoxType | Type | char | 1 | 0 | | V | A=Account, B=Box, F=Formula, M=Manual Input, S=Single Choice, V=VAT Group | Allow NULL? |
| 4 | SummayFld | Summary Field | char | 1 | 0 | | S | B=Base Amount, E=EQ Tax Amount, N=Non-Deductible Amount, Q=EQ Base Amount, S, T=Tax Amount | Allow NULL? |
| 5 | DbtCrdt | Debit/Credit | char | 1 | 0 | | S | B=Debit Side and Credit Side, C=Credit Side, D=Debit Side, S | Allow NULL? |
| 6 | Formula | Formula Syntax | nvarchar | 250 | 0 | | | | Allow NULL? |
| 7 | SortOrder | Sort Order | int | 11 | 0 | | | | Allow NULL? |
| 8 | AbsolutVa | Absolute Value | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 9 | ReportType | Report Type | char | 1 | 0 | | B | B=Box Declaration, S=BAS Report | Allow NULL? |