|
|
SQL Finance / Box Definition
API OBOX
OBOX - Box Definition Table
OBOX SQL Table
Box Set Definition OBOS SQL Table
G/L Accounts OACT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BoxCode KEY UNIQUE | Code | nVarChar | 30 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BoxName | Name | nVarChar | 127 | |||||
| BoxType | Type | VarChar | V) VAT Group B) Box A) Account M) Manual Input T) Manual Text Input F) Formula S) Single Choice | 1 | V | |||
| SummayFld | Summary Field | VarChar | B) Base Amount T) Tax Amount Q) EQ Base Amount E) EQ Tax Amount N) Non-Deductible Amount S) | 1 | S | |||
| DbtCrdt | Debit/Credit | VarChar | D) Debit Side C) Credit Side B) Debit Side and Credit Side S) | 1 | S | |||
| Formula | Formula Syntax | nVarChar | 127 | |||||
| SortOrder | Sort Order | Int | 11 | |||||
| AbsolutVa | Absolute Value | VarChar | Y) Yes N) No | 1 | N | |||
| ReportType | Report Type | VarChar | B) Box Declaration S) BAS Report X) BAS Report - Empty Effective Date Holder | 1 | B | |||
| Inactive | Inactive | VarChar | Y) Yes N) No | 1 | N | |||
| EffecDate | Effective From | Date | 8 | |||||
| DecLoc | Declaration Location | VarChar | B) C) Continent M) Madeira A) Azores | 1 | B | |||
| BosCode | Box Set Code | Int | 11 | OBOS Box Set Definition | ||||
| Position | Position in Report | nVarChar | 127 | |||||
| PostToAct | Post-To Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PostToOffA | Post-To Offset Account | nVarChar | 15 | OACT G/L Accounts |
Table relationship map
SELECT statement
SELECT
OBOX.BoxCode AS 'Code',
OBOX.BoxName AS 'Name',
OBOX.BoxType AS 'Type',
OBOX.SummayFld AS 'Summary Field',
OBOX.DbtCrdt AS 'Debit/Credit',
OBOX.Formula AS 'Formula Syntax',
OBOX.SortOrder AS 'Sort Order',
OBOX.AbsolutVa AS 'Absolute Value',
OBOX.ReportType AS 'Report Type',
OBOX.Inactive AS 'Inactive',
OBOX.EffecDate AS 'Effective From',
OBOX.DecLoc AS 'Declaration Location',
OBOX.BosCode AS 'Box Set Code',
OBOX.Position AS 'Position in Report',
OBOX.PostToAct AS 'Post-To Account',
OBOX.PostToOffA AS 'Post-To Offset Account'
FROM OBOX AS OBOX
Related information
OBOX SQL Table
Box Set Definition OBOS SQL Table
G/L Accounts OACT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
