Resource Type

S_ResourceType

Overview

Table NameS_ResourceType
Access LevelClient Only
Entity TypeD
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableAD_Client
WikiView on iDempiere Wiki

Columns (29)

Column Type Required Default Description
AD_Client_ID Table Direct(22) Yes @#AD_Client_ID@ Tenant for this installation.
AD_Org_ID Table Direct(22) Yes @#AD_Org_ID@ Organizational entity within tenant
AllowUoMFractions Yes-No(1) Yes N Allow Unit of Measure Fractions
ChargeableQty Integer(22) No - -
Created Date+Time(7) Yes SYSDATE Date this record was created
CreatedBy Search(22) Yes - User who created this records
C_TaxCategory_ID Table Direct(22) Yes - Tax Category
C_UOM_ID Table Direct(22) Yes - Unit of Measure
Description String(255) No - Optional short description of the record
IsActive Yes-No(1) Yes Y The record is active in the system
IsDateSlot Yes-No(1) Yes - Resource has day slot availability
IsSingleAssignment Yes-No(1) Yes - Only one assignment at a time (no double-booking or overlapping)
IsTimeSlot Yes-No(1) Yes - Resource has time slot availability
M_Product_Category_ID Table Direct(22) Yes - Category of a Product
OnFriday Yes-No(1) Yes Y Available on Fridays
OnMonday Yes-No(1) Yes Y Available on Mondays
OnSaturday Yes-No(1) Yes - Available on Saturday
OnSunday Yes-No(1) Yes - Available on Sundays
OnThursday Yes-No(1) Yes Y Available on Thursdays
OnTuesday Yes-No(1) Yes Y Available on Tuesdays
OnWednesday Yes-No(1) Yes Y Available on Wednesdays
S_ResourceType_ID ID(22) Yes - -
TimeSlotEnd Time(7) No - Time when timeslot ends
TimeSlotStart Time(7) No - Time when timeslot starts
Updated Date+Time(7) Yes SYSDATE Date this record was updated
UpdatedBy Search(22) Yes - User who updated this records
Value String(40) Yes - Search key for the record in the format required - must be unique
Name String(60) Yes - Alphanumeric identifier of the entity
S_ResourceType_UU String(36) No - -

Foreign Keys

Column References Description
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant
C_TaxCategory_ID C_TaxCategory.C_TaxCategory_ID Tax Category
C_UOM_ID C_UOM.C_UOM_ID Unit of Measure
M_Product_Category_ID M_Product_Category.M_Product_Category_ID Category of a Product

Generated on 2026-05-03T17:56:35.934339780Z