|
|
API BOE1
BOE1 - Bill of Exchange for Payment - Rows Table
Bill of Exchange for Payment OBOE SQL Table
Tax Definition OVTG SQL Table
G/L Accounts OACT SQL Table
Currency Codes OCRN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BoeKey KEY UNIQUE | SBO Internal Key | Int | 11 | OBOE Bill of Exchange for Payment | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row No. | Int | 11 | |||||
| LineDitail | Row Details | nVarChar | 40 | |||||
| LineMoney | Row Total | Num | 20 | |||||
| LineCurr | Row Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| LineAcct | Row Account | nVarChar | 15 | |||||
| Line_A_C | BP/Account | VarChar | 1 | 0 | ||||
| Code | Tax Definition | nVarChar | 8 | OVTG Tax Definition | ||||
| CredAcct | Credited Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TotalLine | Row Total | Num | 20 | |||||
| VatPercent | Tax %: | Num | 20 | |||||
| UserSign | User Signature | Int | 11 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
BOE1.BoeKey AS 'SBO Internal Key',
BOE1.LineId AS 'Row No.',
BOE1.LineDitail AS 'Row Details',
BOE1.LineMoney AS 'Row Total',
BOE1.LineCurr AS 'Row Currency',
BOE1.LineAcct AS 'Row Account',
BOE1.Line_A_C AS 'BP/Account',
BOE1.Code AS 'Tax Definition',
BOE1.CredAcct AS 'Credited Account',
BOE1.TotalLine AS 'Row Total',
BOE1.VatPercent AS 'Tax %:',
BOE1.UserSign AS 'User Signature',
BOE1.LogInstanc AS 'Log Instance'
FROM BOE1 AS BOE1
Related information
Bill of Exchange for Payment OBOE SQL Table
Tax Definition OVTG SQL Table
G/L Accounts OACT SQL Table
Currency Codes OCRN SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
