|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Box Definition - Rows
Table Name: BOX1
Table Description: Box Definition - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BoxCode | Group Code | nVarChar | 30 | - | Â | Â | Â |
| BoxMember | Box Code | nVarChar | 30 | OBOX | Â | Â | Â |
| VATMember | VAT Group | nVarChar | 8 | OVTG | Â | Â | Â |
| SeqNum | Sequence Number | Int | 11 | - | Â | Â | Â |
| FormulSign | Formula Sign | VarChar | 1 | - | P | P | + |
| Â | Â | Â | Â | Â | Â | M | - |
| ReportType | Report Type | VarChar | 1 | - | B | B | Box Declaration |
| Â | Â | Â | Â | Â | Â | S | BAS Reporting |
| EffecDate | Effective From | Date | 8 | - | Â | Â | Â |
| TaxType | Acquisition / Reverse Tax Type | VarChar | 1 | - | B | I | Input Tax |
| Â | Â | Â | Â | Â | Â | O | Output Tax |
| Â | Â | Â | Â | Â | Â | B | Input Tax and Output Tax |
| BosCode | Box Set Code | Int | 11 | OBOS | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | BoxCode |
| Â | Â | ReportType |
| Â | Â | SeqNum |
| Â | Â | BosCode |