ARSC6 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Others / Resources - Daily Capacities - Log

API ARSC6

ARSC6 - Resources - Daily Capacities - Log Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
ResCode ^KEY ^UNIQUE	Internal Resource ID	nVarChar		20	ORSC Resources		PRIMARY	Yes
WeekDay	Weekday No.	Int	1) First Day of Week 2) Second Day of Week 3) Third Day of Week 4) Fourth Day of Week 5) Fifth Day of Week 6) Sixth Day of Week 7) Seventh Day of Week	11
CapFactor1	Day 1 Capacity Factor 1	Num		20
CapFactor2	Day 1 Capacity Factor 2	Num		20
CapFactor3	Day 1 Capacity Factor 3	Num		20
CapFactor4	Day 1 Capacity Factor 4	Num		20
CapTotal	Total Daily Capacity	Num		20
Remarks	Remarks	nVarChar		100
LogInstanc	Log Instance	Int		11		0

SELECT statement

SELECT
   ARSC6.ResCode AS 'Internal Resource ID', 
   ARSC6.WeekDay AS 'Weekday No.', 
   ARSC6.CapFactor1 AS 'Day 1 Capacity Factor 1', 
   ARSC6.CapFactor2 AS 'Day 1 Capacity Factor 2', 
   ARSC6.CapFactor3 AS 'Day 1 Capacity Factor 3', 
   ARSC6.CapFactor4 AS 'Day 1 Capacity Factor 4', 
   ARSC6.CapTotal AS 'Total Daily Capacity', 
   ARSC6.Remarks AS 'Remarks', 
   ARSC6.LogInstanc AS 'Log Instance'
FROM ARSC6 AS ARSC6

Related information

ORSC SQL Table

biuan SAP® BUSINESS ONE

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