|
|
SQL Finance / Box Definition - Rows
API BOX1
BOX1 - Box Definition - Rows Table
Box Set Definition OBOS SQL Table
Box Definition OBOX SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BoxCode KEY UNIQUE | Group Code | nVarChar | 30 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BoxMember | Box Code | nVarChar | 30 | OBOX Box Definition | ||||
| VATMember | VAT Group | nVarChar | 8 | OVTG Tax Definition | ||||
| SeqNum | Sequence Number | Int | 11 | |||||
| FormulSign | Formula Sign | VarChar | P) + M) - | 1 | P | |||
| ReportType | Report Type | VarChar | B) Box Declaration S) BAS Reporting | 1 | B | |||
| EffecDate | Effective From | Date | 8 | |||||
| TaxType | Acquisition / Reverse Tax Type | VarChar | I) Input Tax O) Output Tax B) Input Tax and Output Tax | 1 | B | |||
| BosCode | Box Set Code | Int | 11 | OBOS Box Set Definition |
Table relationship map
SELECT statement
SELECT
BOX1.BoxCode AS 'Group Code',
BOX1.BoxMember AS 'Box Code',
BOX1.VATMember AS 'VAT Group',
BOX1.SeqNum AS 'Sequence Number',
BOX1.FormulSign AS 'Formula Sign',
BOX1.ReportType AS 'Report Type',
BOX1.EffecDate AS 'Effective From',
BOX1.TaxType AS 'Acquisition / Reverse Tax Type',
BOX1.BosCode AS 'Box Set Code'
FROM BOX1 AS BOX1
Related information
Box Set Definition OBOS SQL Table
Box Definition OBOX SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
