biuan SAP® BUSINESS ONE SDK
SQL Others / Resource Master Data - Log
API ARSC
ARSC - Resource Master Data - Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ResCode KEY UNIQUEInternal CodenVarChar
20
PRIMARYYes
VisResCodeResource No.nVarChar
20
SeriesSeriesInt
6NNM1
Documents Numbering - Series
NumberNumberInt
11
CodeBarsBar CodenVarChar
127
ResName KEYResource DescriptionnVarChar
100
ITEM_NAMENo
FrgnNameDescription in Foreign Lang.nVarChar
100
ResTypeResource TypeVarChar
M) Machine
L) Labor
O) Other
1
M
ResGrpCodResource GroupInt
6ORSB
Resource Groups		1
UnitOfMsrUnit of MeasurenVarChar
100
PrchseRes KEYPurchase Resource [Yes/No]VarChar
Y) Yes
N) No
1
YSALENo
SellRes KEYSales Resource [Yes/No]VarChar
Y) Yes
N) No
1
YPURCHASENo
ProdRes KEYProduction Resource [Yes/No]VarChar
Y) Yes
N) No
1
YPRODUCTIONNo
CardCodePreferred VendornVarChar
15OCRD
Business Partner
NoDiscountNo DiscountsVarChar
Y) Yes
N) No
1
N
IssueMthdIssue MethodVarChar
B) Backflush
M) Manual
1
B
StdCost1Resource Cost 1Num
20
StdCost2Resource Cost 2Num
20
StdCost3Resource Cost 3Num
20
StdCost4Resource Cost 4Num
20
StdCost5Resource Cost 5Num
20
StdCost6Resource Cost 6Num
20
StdCost7Resource Cost 7Num
20
StdCost8Resource Cost 8Num
20
StdCost9Resource Cost 9Num
20
StdCost10Resource Cost 10Num
20
validForActiveVarChar
Y) Yes
N) No
1
N
validFromActive FromDate
8
validToActive ToDate
8
frozenForInactiveVarChar
Y) Yes
N) No
1
N
frozenFromInactive FromDate
8
frozenToInactive ToDate
8
DfltWHDefault WarehousenVarChar
8
QueryGroupPropertiesInt
11
0
PicturNamePicturenVarChar
127
UserTextItem RemarksText
16
QryGroup1Property 1VarChar
Y) Yes
N) No
1
N
QryGroup2Property 2VarChar
Y) Yes
N) No
1
N
QryGroup3Property 3VarChar
Y) Yes
N) No
1
N
QryGroup4Property 4VarChar
Y) Yes
N) No
1
N
QryGroup5Property 5VarChar
Y) Yes
N) No
1
N
QryGroup6Property 6VarChar
Y) Yes
N) No
1
N
QryGroup7Property 7VarChar
Y) Yes
N) No
1
N
QryGroup8Property 8VarChar
Y) Yes
N) No
1
N
QryGroup9Property 9VarChar
Y) Yes
N) No
1
N
QryGroup10Property 10VarChar
Y) Yes
N) No
1
N
QryGroup11Property 11VarChar
Y) Yes
N) No
1
N
QryGroup12Property 12VarChar
Y) Yes
N) No
1
N
QryGroup13Property 13VarChar
Y) Yes
N) No
1
N
QryGroup14Property 14VarChar
Y) Yes
N) No
1
N
QryGroup15Property 15VarChar
Y) Yes
N) No
1
N
QryGroup16Property 16VarChar
Y) Yes
N) No
1
N
QryGroup17Property 17VarChar
Y) Yes
N) No
1
N
QryGroup18Property 18VarChar
Y) Yes
N) No
1
N
QryGroup19Property 19VarChar
Y) Yes
N) No
1
N
QryGroup20Property 20VarChar
Y) Yes
N) No
1
N
QryGroup21Property 21VarChar
Y) Yes
N) No
1
N
QryGroup22Property 22VarChar
Y) Yes
N) No
1
N
QryGroup23Property 23VarChar
Y) Yes
N) No
1
N
QryGroup24Property 24VarChar
Y) Yes
N) No
1
N
QryGroup25Property 25VarChar
Y) Yes
N) No
1
N
QryGroup26Property 26VarChar
Y) Yes
N) No
1
N
QryGroup27Property 27VarChar
Y) Yes
N) No
1
N
QryGroup28Property 28VarChar
Y) Yes
N) No
1
N
QryGroup29Property 29VarChar
Y) Yes
N) No
1
N
QryGroup30Property 30VarChar
Y) Yes
N) No
1
N
QryGroup31Property 31VarChar
Y) Yes
N) No
1
N
QryGroup32Property 32VarChar
Y) Yes
N) No
1
N
QryGroup33Property 33VarChar
Y) Yes
N) No
1
N
QryGroup34Property 34VarChar
Y) Yes
N) No
1
N
QryGroup35Property 35VarChar
Y) Yes
N) No
1
N
QryGroup36Property 36VarChar
Y) Yes
N) No
1
N
QryGroup37Property 37VarChar
Y) Yes
N) No
1
N
QryGroup38Property 38VarChar
Y) Yes
N) No
1
N
QryGroup39Property 39VarChar
Y) Yes
N) No
1
N
QryGroup40Property 40VarChar
Y) Yes
N) No
1
N
QryGroup41Property 41VarChar
Y) Yes
N) No
1
N
QryGroup42Property 42VarChar
Y) Yes
N) No
1
N
QryGroup43Property 43VarChar
Y) Yes
N) No
1
N
QryGroup44Property 44VarChar
Y) Yes
N) No
1
N
QryGroup45Property 45VarChar
Y) Yes
N) No
1
N
QryGroup46Property 46VarChar
Y) Yes
N) No
1
N
QryGroup47Property 47VarChar
Y) Yes
N) No
1
N
QryGroup48Property 48VarChar
Y) Yes
N) No
1
N
QryGroup49Property 49VarChar
Y) Yes
N) No
1
N
QryGroup50Property 50VarChar
Y) Yes
N) No
1
N
QryGroup51Property 51VarChar
Y) Yes
N) No
1
N
QryGroup52Property 52VarChar
Y) Yes
N) No
1
N
QryGroup53Property 53VarChar
Y) Yes
N) No
1
N
QryGroup54Property 54VarChar
Y) Yes
N) No
1
N
QryGroup55Property 55VarChar
Y) Yes
N) No
1
N
QryGroup56Property 56VarChar
Y) Yes
N) No
1
N
QryGroup57Property 57VarChar
Y) Yes
N) No
1
N
QryGroup58Property 58VarChar
Y) Yes
N) No
1
N
QryGroup59Property 59VarChar
Y) Yes
N) No
1
N
QryGroup60Property 60VarChar
Y) Yes
N) No
1
N
QryGroup61Property 61VarChar
Y) Yes
N) No
1
N
QryGroup62Property 62VarChar
Y) Yes
N) No
1
N
QryGroup63Property 63VarChar
Y) Yes
N) No
1
N
QryGroup64Property 64VarChar
Y) Yes
N) No
1
N
CreateDateDate of CreationDate
8
UpdateDateDate of UpdateDate
8
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
ValidCommActive RemarksnVarChar
30
FrozenCommInactive RemarksnVarChar
30
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20
290
DeletedDeletedVarChar
Y) Yes
N) No
1
N
UserSign2Updating UserInt
6
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
LastPurPrcLast Purchase PriceNum
20
LastPurCurLast Purchase CurrencynVarChar
3
LastPurDatLast Purchase DateDate
8
LstEvlPricLast Evaluated PriceNum
20
LstEvlDateDate of Last Reval. PriceDate
8
NumResUnitNo. of Resource UnitsInt
11
1
TimeResUnTime per Resource UnitsInt
11
ResAllocResource AllocationVarChar
D) On Due Date
B) Automatic
1
D

Table relationship map

SELECT statement

SELECT ARSC.ResCode AS 'Internal Code', ARSC.VisResCode AS 'Resource No.', ARSC.Series AS 'Series', ARSC.Number AS 'Number', ARSC.CodeBars AS 'Bar Code', ARSC.ResName AS 'Resource Description', ARSC.FrgnName AS 'Description in Foreign Lang.', ARSC.ResType AS 'Resource Type', ARSC.ResGrpCod AS 'Resource Group', ARSC.UnitOfMsr AS 'Unit of Measure', ARSC.PrchseRes AS 'Purchase Resource [Yes/No]', ARSC.SellRes AS 'Sales Resource [Yes/No]', ARSC.ProdRes AS 'Production Resource [Yes/No]', ARSC.CardCode AS 'Preferred Vendor', ARSC.NoDiscount AS 'No Discounts', ARSC.IssueMthd AS 'Issue Method', ARSC.StdCost1 AS 'Resource Cost 1', ARSC.StdCost2 AS 'Resource Cost 2', ARSC.StdCost3 AS 'Resource Cost 3', ARSC.StdCost4 AS 'Resource Cost 4', ARSC.StdCost5 AS 'Resource Cost 5', ARSC.StdCost6 AS 'Resource Cost 6', ARSC.StdCost7 AS 'Resource Cost 7', ARSC.StdCost8 AS 'Resource Cost 8', ARSC.StdCost9 AS 'Resource Cost 9', ARSC.StdCost10 AS 'Resource Cost 10', ARSC.validFor AS 'Active', ARSC.validFrom AS 'Active From', ARSC.validTo AS 'Active To', ARSC.frozenFor AS 'Inactive', ARSC.frozenFrom AS 'Inactive From', ARSC.frozenTo AS 'Inactive To', ARSC.DfltWH AS 'Default Warehouse', ARSC.QueryGroup AS 'Properties', ARSC.PicturName AS 'Picture', ARSC.UserText AS 'Item Remarks', ARSC.QryGroup1 AS 'Property 1', ARSC.QryGroup2 AS 'Property 2', ARSC.QryGroup3 AS 'Property 3', ARSC.QryGroup4 AS 'Property 4', ARSC.QryGroup5 AS 'Property 5', ARSC.QryGroup6 AS 'Property 6', ARSC.QryGroup7 AS 'Property 7', ARSC.QryGroup8 AS 'Property 8', ARSC.QryGroup9 AS 'Property 9', ARSC.QryGroup10 AS 'Property 10', ARSC.QryGroup11 AS 'Property 11', ARSC.QryGroup12 AS 'Property 12', ARSC.QryGroup13 AS 'Property 13', ARSC.QryGroup14 AS 'Property 14', ARSC.QryGroup15 AS 'Property 15', ARSC.QryGroup16 AS 'Property 16', ARSC.QryGroup17 AS 'Property 17', ARSC.QryGroup18 AS 'Property 18', ARSC.QryGroup19 AS 'Property 19', ARSC.QryGroup20 AS 'Property 20', ARSC.QryGroup21 AS 'Property 21', ARSC.QryGroup22 AS 'Property 22', ARSC.QryGroup23 AS 'Property 23', ARSC.QryGroup24 AS 'Property 24', ARSC.QryGroup25 AS 'Property 25', ARSC.QryGroup26 AS 'Property 26', ARSC.QryGroup27 AS 'Property 27', ARSC.QryGroup28 AS 'Property 28', ARSC.QryGroup29 AS 'Property 29', ARSC.QryGroup30 AS 'Property 30', ARSC.QryGroup31 AS 'Property 31', ARSC.QryGroup32 AS 'Property 32', ARSC.QryGroup33 AS 'Property 33', ARSC.QryGroup34 AS 'Property 34', ARSC.QryGroup35 AS 'Property 35', ARSC.QryGroup36 AS 'Property 36', ARSC.QryGroup37 AS 'Property 37', ARSC.QryGroup38 AS 'Property 38', ARSC.QryGroup39 AS 'Property 39', ARSC.QryGroup40 AS 'Property 40', ARSC.QryGroup41 AS 'Property 41', ARSC.QryGroup42 AS 'Property 42', ARSC.QryGroup43 AS 'Property 43', ARSC.QryGroup44 AS 'Property 44', ARSC.QryGroup45 AS 'Property 45', ARSC.QryGroup46 AS 'Property 46', ARSC.QryGroup47 AS 'Property 47', ARSC.QryGroup48 AS 'Property 48', ARSC.QryGroup49 AS 'Property 49', ARSC.QryGroup50 AS 'Property 50', ARSC.QryGroup51 AS 'Property 51', ARSC.QryGroup52 AS 'Property 52', ARSC.QryGroup53 AS 'Property 53', ARSC.QryGroup54 AS 'Property 54', ARSC.QryGroup55 AS 'Property 55', ARSC.QryGroup56 AS 'Property 56', ARSC.QryGroup57 AS 'Property 57', ARSC.QryGroup58 AS 'Property 58', ARSC.QryGroup59 AS 'Property 59', ARSC.QryGroup60 AS 'Property 60', ARSC.QryGroup61 AS 'Property 61', ARSC.QryGroup62 AS 'Property 62', ARSC.QryGroup63 AS 'Property 63', ARSC.QryGroup64 AS 'Property 64', ARSC.CreateDate AS 'Date of Creation', ARSC.UpdateDate AS 'Date of Update', ARSC.DataSource AS 'Data Source', ARSC.ValidComm AS 'Active Remarks', ARSC.FrozenComm AS 'Inactive Remarks', ARSC.LogInstanc AS 'Log Instance', ARSC.ObjType AS 'Object Type', ARSC.Deleted AS 'Deleted', ARSC.UserSign2 AS 'Updating User', ARSC.Attachment AS 'Attachment', ARSC.AtcEntry AS 'Attachment Entry', ARSC.LastPurPrc AS 'Last Purchase Price', ARSC.LastPurCur AS 'Last Purchase Currency', ARSC.LastPurDat AS 'Last Purchase Date', ARSC.LstEvlPric AS 'Last Evaluated Price', ARSC.LstEvlDate AS 'Date of Last Reval. Price', ARSC.NumResUnit AS 'No. of Resource Units', ARSC.TimeResUn AS 'Time per Resource Units', ARSC.ResAlloc AS 'Resource Allocation' FROM ARSC AS ARSC

Related information


Business Partner OCRD SQL Table

Resource Groups ORSB SQL Table

Documents Numbering - Series NNM1 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