biuan SAP® BUSINESS ONE SDK
API ASC2
ASC2 - Service Call Inventory Expenses - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SrcvCallID KEY UNIQUEService Call No. - HistoryInt
11OSCL
Service Calls
PRIMARYYes
LineRow - HistoryInt
6
-1
ItemCodeItem No. - HistorynVarChar
20OITM
Items
ItemNameItem Description - HistorynVarChar
100
TransToTecTransfer to Technician - HistoryNum
20
DeliveredDelivered - HistoryNum
20
RetFromTecReturned from Technician - HistoryNum
20
ReturnedReturned - HistoryNum
20
BillBill - HistoryVarChar
Y) Yes
N) No
1
Y
QtyToBillQuantity to Bill - HistoryNum
20
QtyToInvInvoiced Qty - HistoryNum
20
ObjectTypeObject Type - HistorynVarChar
20
191
LogInstancLog Instance - HistoryInt
11
UserSignUser Signature - HistoryInt
6OUSR
Users
CreateDateCreation Date - HistoryDate
8
UserSign2User Signature 2 - HistoryInt
6OUSR
Users
UpdateDateDate of Update - HistoryDate
8
VisOrderVisual OrderInt
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates