| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | BoxCode | Code | nvarchar | 30 | 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, T=Manual Text Input, 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, X=BAS Report - Empty Effective Date Holder | Allow NULL? |
| 10 | Inactive | Inactive | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 11 | EffecDate | Effective From | date | 8 | 0 | | | | |
| 12 | DecLoc | Declaration Location | char | 1 | 0 | | B | A=Azores, B, C=Continent, M=Madeira | Allow NULL? |
| 13 | BosCode | Box Set Code | int | 11 | 0 | OBOS | | | Allow NULL? |
| 14 | Position | Position in Report | nvarchar | 250 | 0 | | | | Allow NULL? |
| 15 | PostToAct | Post-To Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 16 | PostToOffA | Post-To Offset Account | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
