|
|
API ASC2
ASC2 - Service Call Inventory Expenses - History Table
Items OITM SQL Table
Service Calls OSCL SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | SrcvCallID KEY UNIQUE | Service Call No. - History | Int | 11 | OSCL Service Calls | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Line | Row - History | Int | 6 | -1 | ||||
| ItemCode | Item No. - History | nVarChar | 20 | OITM Items | ||||
| ItemName | Item Description - History | nVarChar | 100 | |||||
| TransToTec | Transfer to Technician - History | Num | 20 | |||||
| Delivered | Delivered - History | Num | 20 | |||||
| RetFromTec | Returned from Technician - History | Num | 20 | |||||
| Returned | Returned - History | Num | 20 | |||||
| Bill | Bill - History | VarChar | Y) Yes N) No | 1 | Y | |||
| QtyToBill | Quantity to Bill - History | Num | 20 | |||||
| QtyToInv | Invoiced Qty - History | Num | 20 | |||||
| ObjectType | Object Type - History | nVarChar | 20 | 191 | ||||
| LogInstanc | Log Instance - History | Int | 11 | |||||
| UserSign | User Signature - History | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date - History | Date | 8 | |||||
| UserSign2 | User Signature 2 - History | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update - History | Date | 8 | |||||
| VisOrder | Visual Order | Int | 11 |
Table relationship map
SELECT statement
SELECT
ASC2.SrcvCallID AS 'Service Call No. - History',
ASC2.Line AS 'Row - History',
ASC2.ItemCode AS 'Item No. - History',
ASC2.ItemName AS 'Item Description - History',
ASC2.TransToTec AS 'Transfer to Technician - History',
ASC2.Delivered AS 'Delivered - History',
ASC2.RetFromTec AS 'Returned from Technician - History',
ASC2.Returned AS 'Returned - History',
ASC2.Bill AS 'Bill - History',
ASC2.QtyToBill AS 'Quantity to Bill - History',
ASC2.QtyToInv AS 'Invoiced Qty - History',
ASC2.ObjectType AS 'Object Type - History',
ASC2.LogInstanc AS 'Log Instance - History',
ASC2.UserSign AS 'User Signature - History',
ASC2.CreateDate AS 'Creation Date - History',
ASC2.UserSign2 AS 'User Signature 2 - History',
ASC2.UpdateDate AS 'Date of Update - History',
ASC2.VisOrder AS 'Visual Order'
FROM ASC2 AS ASC2
Related information
Items OITM SQL Table
Service Calls OSCL 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