biuan SAP® BUSINESS ONE SDK
SQL Others / Resource Groups - History
API ARSB
ARSB - Resource Groups - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ResGrpCod KEY UNIQUENumberInt
6
PRIMARYYes
ResGrpNam KEY UNIQUEGroup NamenVarChar
20
GROUP_NAMEYes
LockedLockedVarChar
N) Changeable
Y) Locked
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
ObjectObject Type - HistorynVarChar
20
292
logInstancLog Instance - HistoryInt
11
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6
updateDateDate of Update - HistoryDate
8
ResTypeResource TypeVarChar
M) Machine
L) Labor
O) Other
1
M
CostName1Resource Std Cost 1nVarChar
127
CostVal1Resource Std Cost 1Num
20
CostName2Resource Std Cost 2nVarChar
127
CostVal2Resource Std Cost 2Num
20
CostName3Resource Std Cost 3nVarChar
127
CostVal3Resource Std Cost 3Num
20
CostName4Resource Std Cost 4nVarChar
127
CostVal4Resource Std Cost 4Num
20
CostName5Resource Std Cost 5nVarChar
127
CostVal5Resource Std Cost 5Num
20
CostName6Resource Std Cost 2nVarChar
127
CostVal6Resource Std Cost 6Num
20
CostName7Resource Std Cost 7nVarChar
127
CostVal7Resource Std Cost 7Num
20
CostName8Resource Std Cost 8nVarChar
127
CostVal8Resource Std Cost 8Num
20
CostName9Resource Std Cost 9nVarChar
127
CostVal9Resource Std Cost 9Num
20
CostName10Resource Std Cost 10nVarChar
127
CostVal10Resource Std Cost 10Num
20
ResUoMResource Unit of MeasurementnVarChar
20

SELECT statement

SELECT ARSB.ResGrpCod AS 'Number', ARSB.ResGrpNam AS 'Group Name', ARSB.Locked AS 'Locked', ARSB.DataSource AS 'Data Source', ARSB.UserSign AS 'User Signature', ARSB.Object AS 'Object Type - History', ARSB.logInstanc AS 'Log Instance - History', ARSB.createDate AS 'Creation Date - History', ARSB.userSign2 AS 'Updating User - History', ARSB.updateDate AS 'Date of Update - History', ARSB.ResType AS 'Resource Type', ARSB.CostName1 AS 'Resource Std Cost 1', ARSB.CostVal1 AS 'Resource Std Cost 1', ARSB.CostName2 AS 'Resource Std Cost 2', ARSB.CostVal2 AS 'Resource Std Cost 2', ARSB.CostName3 AS 'Resource Std Cost 3', ARSB.CostVal3 AS 'Resource Std Cost 3', ARSB.CostName4 AS 'Resource Std Cost 4', ARSB.CostVal4 AS 'Resource Std Cost 4', ARSB.CostName5 AS 'Resource Std Cost 5', ARSB.CostVal5 AS 'Resource Std Cost 5', ARSB.CostName6 AS 'Resource Std Cost 2', ARSB.CostVal6 AS 'Resource Std Cost 6', ARSB.CostName7 AS 'Resource Std Cost 7', ARSB.CostVal7 AS 'Resource Std Cost 7', ARSB.CostName8 AS 'Resource Std Cost 8', ARSB.CostVal8 AS 'Resource Std Cost 8', ARSB.CostName9 AS 'Resource Std Cost 9', ARSB.CostVal9 AS 'Resource Std Cost 9', ARSB.CostName10 AS 'Resource Std Cost 10', ARSB.CostVal10 AS 'Resource Std Cost 10', ARSB.ResUoM AS 'Resource Unit of Measurement' FROM ARSB AS ARSB

Related information


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