|
|
API Alternative Items / Alternative Item
OALI - Alternative Items 2 Table
Alternative Item AlternativeItem Object· Table: OALI
Parent: Alternative Items AlternativeItems Collection
Alternative Items Service AlternativeItemsService Service· Table: OALI
Items OITM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | OrigItem KEY UNIQUE | Original Item No. | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AltItem | Alternative Item No. | nVarChar | 20 | OITM Items | ||||
| Match | Match Factor | Num | 20 | |||||
| Remarks | Item Remarks | nVarChar | 50 |
SELECT statement
SELECT
OALI.OrigItem AS 'Original Item No.',
OALI.AltItem AS 'Alternative Item No.',
OALI.Match AS 'Match Factor',
OALI.Remarks AS 'Item Remarks'
FROM OALI AS OALI
Related information
Alternative Item AlternativeItem Object· Table: OALI
A data structure object related to the AlternativeItemsService service.
Source table: OALI.
Parent: Alternative Items AlternativeItems CollectionAlternative Items Service AlternativeItemsService Service· Table: OALI
This service manages alternative items in SAP Business One (add, delete, get by key, and update).
Source table: OALI.
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
