biuan SAP® BUSINESS ONE SDK
SQL Service / Service Call Travel/Labor Expenses - History
API ASC3
ASC3 - Service Call Travel/Labor Expenses - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SrcvCallID KEY UNIQUEService Call No.Int
11OSCL
Service Calls		PRIMARYYes
LineRowInt
6
-1
ItemCodeItem NumbernVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
HourFromDeliveredInt
6
HourToReturnedInt
6
QuantityQuantityNum
20
BillBillVarChar
Y) Yes
N) No
1
Y
QtyToBillQuantity to BillNum
20
QtyToInvInvoiced QtyNum
20
SaleUnitsSale UnitsnVarChar
5
ObjectTypeObject TypenVarChar
20
191
LogInstancLog InstanceInt
11
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreation DateDate
8
UserSign2User Signature 2Int
6OUSR
Users
UpdateDateDate of UpdateDate
8
VisOrderVisual OrderInt
11
DeliverdDeliveredNum
20
ReturnedReturnedNum
20

Table relationship map

SELECT statement

SELECT ASC3.SrcvCallID AS 'Service Call No.', ASC3.Line AS 'Row', ASC3.ItemCode AS 'Item Number', ASC3.ItemName AS 'Item Description', ASC3.HourFrom AS 'Delivered', ASC3.HourTo AS 'Returned', ASC3.Quantity AS 'Quantity', ASC3.Bill AS 'Bill', ASC3.QtyToBill AS 'Quantity to Bill', ASC3.QtyToInv AS 'Invoiced Qty', ASC3.SaleUnits AS 'Sale Units', ASC3.ObjectType AS 'Object Type', ASC3.LogInstanc AS 'Log Instance', ASC3.UserSign AS 'User Signature', ASC3.CreateDate AS 'Creation Date', ASC3.UserSign2 AS 'User Signature 2', ASC3.UpdateDate AS 'Date of Update', ASC3.VisOrder AS 'Visual Order', ASC3.Deliverd AS 'Delivered', ASC3.Returned AS 'Returned' FROM ASC3 AS ASC3

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