📚 SAP Business One SDK Help

Table Name: ORSC

Table Description: Resources

Field Description Type Size Related Default Value Constraints
ResCode Internal Code nVarChar 50 -      
VisResCode Resource No. nVarChar 50 -      
Series Series Int 11 NNM1      
Number Number Int 11 -      
CodeBars Bar Code nVarChar 254 -      
ResName Resource Description nVarChar 200 -      
FrgnName Description in Foreign Lang. nVarChar 200 -      
ResType Resource Type VarChar 1 - M M Machine
            L Labor
            O Other
ResGrpCod Resource Group Int 6 ORSB 1    
UnitOfMsr Unit of Measure nVarChar 100 -      
PrchseRes Purchase Resource [Yes/No] VarChar 1 - Y Y Yes
            N No
SellRes Sales Resource [Yes/No] VarChar 1 - Y Y Yes
            N No
ProdRes Production Resource [Yes/No] VarChar 1 - Y Y Yes
            N No
CardCode Preferred Vendor nVarChar 15 OCRD      
NoDiscount No Discounts VarChar 1 - N Y Yes
            N No
IssueMthd Issue Method VarChar 1 - B B Backflush
            M Manual
StdCost1 Resource Cost 1 Num 19.6 -      
StdCost2 Resource Cost 2 Num 19.6 -      
StdCost3 Resource Cost 3 Num 19.6 -      
StdCost4 Resource Cost 4 Num 19.6 -      
StdCost5 Resource Cost 5 Num 19.6 -      
StdCost6 Resource Cost 6 Num 19.6 -      
StdCost7 Resource Cost 7 Num 19.6 -      
StdCost8 Resource Cost 8 Num 19.6 -      
StdCost9 Resource Cost 9 Num 19.6 -      
StdCost10 Resource Cost 10 Num 19.6 -      
validFor Active VarChar 1 - N Y Yes
            N No
validFrom Active From Date 8 -      
validTo Active To Date 8 -      
frozenFor Inactive VarChar 1 - N Y Yes
            N No
frozenFrom Inactive From Date 8 -      
frozenTo Inactive To Date 8 -      
DfltWH Default Warehouse nVarChar 8 -      
QueryGroup Properties Int 11 - 0    
PicturName Picture nVarChar 200 -      
UserText Item Remarks Text 16 -      
QryGroup1 Property 1 VarChar 1 - N Y Yes
            N No
QryGroup2 Property 2 VarChar 1 - N Y Yes
            N No
QryGroup3 Property 3 VarChar 1 - N Y Yes
            N No
QryGroup4 Property 4 VarChar 1 - N Y Yes
            N No
QryGroup5 Property 5 VarChar 1 - N Y Yes
            N No
QryGroup6 Property 6 VarChar 1 - N Y Yes
            N No
QryGroup7 Property 7 VarChar 1 - N Y Yes
            N No
QryGroup8 Property 8 VarChar 1 - N Y Yes
            N No
QryGroup9 Property 9 VarChar 1 - N Y Yes
            N No
QryGroup10 Property 10 VarChar 1 - N Y Yes
            N No
QryGroup11 Property 11 VarChar 1 - N Y Yes
            N No
QryGroup12 Property 12 VarChar 1 - N Y Yes
            N No
QryGroup13 Property 13 VarChar 1 - N Y Yes
            N No
QryGroup14 Property 14 VarChar 1 - N Y Yes
            N No
QryGroup15 Property 15 VarChar 1 - N Y Yes
            N No
QryGroup16 Property 16 VarChar 1 - N Y Yes
            N No
QryGroup17 Property 17 VarChar 1 - N Y Yes
            N No
QryGroup18 Property 18 VarChar 1 - N Y Yes
            N No
QryGroup19 Property 19 VarChar 1 - N Y Yes
            N No
QryGroup20 Property 20 VarChar 1 - N Y Yes
            N No
QryGroup21 Property 21 VarChar 1 - N Y Yes
            N No
QryGroup22 Property 22 VarChar 1 - N Y Yes
            N No
QryGroup23 Property 23 VarChar 1 - N Y Yes
            N No
QryGroup24 Property 24 VarChar 1 - N Y Yes
            N No
QryGroup25 Property 25 VarChar 1 - N Y Yes
            N No
QryGroup26 Property 26 VarChar 1 - N Y Yes
            N No
QryGroup27 Property 27 VarChar 1 - N Y Yes
            N No
QryGroup28 Property 28 VarChar 1 - N Y Yes
            N No
QryGroup29 Property 29 VarChar 1 - N Y Yes
            N No
QryGroup30 Property 30 VarChar 1 - N Y Yes
            N No
QryGroup31 Property 31 VarChar 1 - N Y Yes
            N No
QryGroup32 Property 32 VarChar 1 - N Y Yes
            N No
QryGroup33 Property 33 VarChar 1 - N Y Yes
            N No
QryGroup34 Property 34 VarChar 1 - N Y Yes
            N No
QryGroup35 Property 35 VarChar 1 - N Y Yes
            N No
QryGroup36 Property 36 VarChar 1 - N Y Yes
            N No
QryGroup37 Property 37 VarChar 1 - N Y Yes
            N No
QryGroup38 Property 38 VarChar 1 - N Y Yes
            N No
QryGroup39 Property 39 VarChar 1 - N Y Yes
            N No
QryGroup40 Property 40 VarChar 1 - N Y Yes
            N No
QryGroup41 Property 41 VarChar 1 - N Y Yes
            N No
QryGroup42 Property 42 VarChar 1 - N Y Yes
            N No
QryGroup43 Property 43 VarChar 1 - N Y Yes
            N No
QryGroup44 Property 44 VarChar 1 - N Y Yes
            N No
QryGroup45 Property 45 VarChar 1 - N Y Yes
            N No
QryGroup46 Property 46 VarChar 1 - N Y Yes
            N No
QryGroup47 Property 47 VarChar 1 - N Y Yes
            N No
QryGroup48 Property 48 VarChar 1 - N Y Yes
            N No
QryGroup49 Property 49 VarChar 1 - N Y Yes
            N No
QryGroup50 Property 50 VarChar 1 - N Y Yes
            N No
QryGroup51 Property 51 VarChar 1 - N Y Yes
            N No
QryGroup52 Property 52 VarChar 1 - N Y Yes
            N No
QryGroup53 Property 53 VarChar 1 - N Y Yes
            N No
QryGroup54 Property 54 VarChar 1 - N Y Yes
            N No
QryGroup55 Property 55 VarChar 1 - N Y Yes
            N No
QryGroup56 Property 56 VarChar 1 - N Y Yes
            N No
QryGroup57 Property 57 VarChar 1 - N Y Yes
            N No
QryGroup58 Property 58 VarChar 1 - N Y Yes
            N No
QryGroup59 Property 59 VarChar 1 - N Y Yes
            N No
QryGroup60 Property 60 VarChar 1 - N Y Yes
            N No
QryGroup61 Property 61 VarChar 1 - N Y Yes
            N No
QryGroup62 Property 62 VarChar 1 - N Y Yes
            N No
QryGroup63 Property 63 VarChar 1 - N Y Yes
            N No
QryGroup64 Property 64 VarChar 1 - N Y Yes
            N No
CreateDate Date of Creation Date 8 -      
UpdateDate Date of Update Date 8 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
ValidComm Active Remarks nVarChar 30 -      
FrozenComm Inactive Remarks nVarChar 30 -      
LogInstanc Log Instance Int 11 - 0    
ObjType Object Type nVarChar 20 - 290    
Deleted Deleted VarChar 1 - N Y Yes
            N No
UserSign2 Updating User Int 6 -      
Attachment Attachment Text 16 -      
AtcEntry Attachment Entry Int 11 -      
LastPurPrc Last Purchase Price Num 19.6 -      
LastPurCur Last Purchase Currency nVarChar 3 -      
LastPurDat Last Purchase Date Date 8 -      
LstEvlPric Last Evaluated Price Num 19.6 -      
LstEvlDate Date of Last Reval. Price Date 8 -      
NumResUnit No. of Resource Units Int 11 - 1    
TimeResUn Time per Resource Units Int 11 -      
ResAlloc Resource Allocation VarChar 1 - S S On Start Date
            D On End Date
            F Start Date Forwards
            B End Date Backwards
LinkItm Linked Item nVarChar 50 OITM      
RelCap1 Relevant to single run capacity 1 VarChar 1 - Y Y Yes
            N No
RelCap2 Relevant to single run capacity 2 VarChar 1 - Y Y Yes
            N No
RelCap3 Relevant to single run capacity 3 VarChar 1 - Y Y Yes
            N No
RelCap4 Relevant to single run capacity 4 VarChar 1 - Y Y Yes
            N No
UserSign User Signature Int 6 OUSR      
Key Unique Field
PRIMARY Yes ResCode
RES_CODE Yes VisResCode
ITEM_NAME No ResName
SALE No PrchseRes
PURCHASE No SellRes
PRODUCTION No ProdRes