|
|
API BOX3
BOX3 - Box Definition - Choice Table
Box Set Definition OBOS 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 |
|---|---|---|---|---|---|---|---|---|
| ReportType | Report Type | VarChar | B) S) | 1 | B | |||
| Value | Value | nVarChar | 8 | |||||
| Descr | Description | nVarChar | 127 | |||||
| EffecDate | Effective From | Date | 8 | |||||
| BosCode | Box Set Code | Int | 11 | OBOS Box Set Definition | ||||
| IsDefault | Is Default | VarChar | Y) Yes N) No | 1 | N |
SELECT statement
SELECT
BOX3.BoxCode AS 'Group Code',
BOX3.ReportType AS 'Report Type',
BOX3.Value AS 'Value',
BOX3.Descr AS 'Description',
BOX3.EffecDate AS 'Effective From',
BOX3.BosCode AS 'Box Set Code',
BOX3.IsDefault AS 'Is Default'
FROM BOX3 AS BOX3
Related information
Box Set Definition OBOS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
