|
|
API BOX2
BOX2 - Box Definition - Accounts Table
G/L Accounts OACT SQL 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 | |||
| Account | Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SeqNum | Sequence Number | Int | 11 | |||||
| EffecDate | Effective From | Date | 8 | |||||
| BosCode | Box Set Code | Int | 11 | OBOS Box Set Definition |
Table relationship map
SELECT statement
SELECT
BOX2.BoxCode AS 'Group Code',
BOX2.ReportType AS 'Report Type',
BOX2.Account AS 'Account',
BOX2.SeqNum AS 'Sequence Number',
BOX2.EffecDate AS 'Effective From',
BOX2.BosCode AS 'Box Set Code'
FROM BOX2 AS BOX2
Related information
G/L Accounts OACT SQL Table
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
