|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Box Definition
Table Name: OBOX
Table Description: Box Definition
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BoxCode | Code | nVarChar | 30 | - | Â | Â | Â |
| BoxName | Name | nVarChar | 250 | - | Â | Â | Â |
| BoxType | Type | VarChar | 1 | - | V | V | VAT Group |
| Â | Â | Â | Â | Â | Â | B | Box |
| Â | Â | Â | Â | Â | Â | A | Account |
| Â | Â | Â | Â | Â | Â | M | Manual Input |
| Â | Â | Â | Â | Â | Â | T | Manual Text Input |
| Â | Â | Â | Â | Â | Â | F | Formula |
| Â | Â | Â | Â | Â | Â | S | Single Choice |
| SummayFld | Summary Field | VarChar | 1 | - | S | B | Base Amount |
| Â | Â | Â | Â | Â | Â | T | Tax Amount |
| Â | Â | Â | Â | Â | Â | Q | EQ Base Amount |
| Â | Â | Â | Â | Â | Â | E | EQ Tax Amount |
| Â | Â | Â | Â | Â | Â | N | Non-Deductible Amount |
| Â | Â | Â | Â | Â | Â | S | Â |
| DbtCrdt | Debit/Credit | VarChar | 1 | - | S | D | Debit Side |
| Â | Â | Â | Â | Â | Â | C | Credit Side |
| Â | Â | Â | Â | Â | Â | B | Debit Side and Credit Side |
| Â | Â | Â | Â | Â | Â | S | Â |
| Formula | Formula Syntax | Text | 16 | - | Â | Â | Â |
| SortOrder | Sort Order | Int | 11 | - | Â | Â | Â |
| AbsolutVa | Absolute Value | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ReportType | Report Type | VarChar | 1 | - | B | B | Box Declaration |
| Â | Â | Â | Â | Â | Â | S | BAS Report |
| Â | Â | Â | Â | Â | Â | X | BAS Report - Empty Effective Date Holder |
| Inactive | Inactive | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EffecDate | Effective From | Date | 8 | - | Â | Â | Â |
| DecLoc | Declaration Location | VarChar | 1 | - | B | B | Â |
| Â | Â | Â | Â | Â | Â | C | Continent |
| Â | Â | Â | Â | Â | Â | M | Madeira |
| Â | Â | Â | Â | Â | Â | A | Azores |
| BosCode | Box Set Code | Int | 11 | OBOS | Â | Â | Â |
| Position | Position in Report | nVarChar | 250 | - | Â | Â | Â |
| PostToAct | Post-To Account | nVarChar | 15 | OACT | Â | Â | Â |
| PostToOffA | Post-To Offset Account | nVarChar | 15 | OACT | Â | Â | Â |
| Remarks | Remarks | nVarChar | 254 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | BoxCode |
| Â | Â | ReportType |
| Â | Â | BosCode |