biuan SAP® BUSINESS ONE SDK
SQL Service / Service Calls / Expense Documents
DTW Expense Documents
API Service Calls / Service Call Inventory Expenses
SCL4 - Expense Documents Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SrcvCallID KEY UNIQUEService Call No.Int
11OSCL
Service Calls		PRIMARYYes
LineRowInt
6
-1
PartTypePart TypeVarChar
I) Inventory
N) Travel/Labor
1
I
DocAbsDocument Internal NumberInt
11
ObjectDocument TypenVarChar
13) A/R Invoice
15) Delivery
16) Returns
67) Inventory Transfer
14) A/R Credit Memo
165) A/R Correction Invoice
0
17) Sales Order
20
13
DocPstDateDocument Posting DateDate
8
ObjectTypeObject TypenVarChar
20
191
LogInstancLog InstanceInt
11
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreation DateDate
8
UserSign2User Signature 2Int
6OUSR
Users
UpdateDateDate of UpdateDate
8
DocNumberDocument No.Int
11
TransferedTransferedVarChar
Y) Yes
N) No
1
Y
VisOrderVisual OrderInt
11
StckTrnDirInventory Transaction DirectionVarChar
T) Transfer to Technician
N) Transfer from Technician
1
InstanceInstanceInt
6
0

Table relationship map

SELECT statement

SELECT SCL4.SrcvCallID AS 'Service Call No.', SCL4.Line AS 'Row', SCL4.PartType AS 'Part Type', SCL4.DocAbs AS 'Document Internal Number', SCL4.Object AS 'Document Type', SCL4.DocPstDate AS 'Document Posting Date', SCL4.ObjectType AS 'Object Type', SCL4.LogInstanc AS 'Log Instance', SCL4.UserSign AS 'User Signature', SCL4.CreateDate AS 'Creation Date', SCL4.UserSign2 AS 'User Signature 2', SCL4.UpdateDate AS 'Date of Update', SCL4.DocNumber AS 'Document No.', SCL4.Transfered AS 'Transfered', SCL4.VisOrder AS 'Visual Order', SCL4.StckTrnDir AS 'Inventory Transaction Direction', SCL4.Instance AS 'Instance' FROM SCL4 AS SCL4

Related information


Service Call Inventory Expenses ServiceCallInventoryExpenses Object· Table: SCL4
ServiceCallInventoryExpenses is a child object of the ServiceCalls object in the Service module. Source table: SCL4.
   Parent: Service Calls ServiceCalls Object· Table: OSCL
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates