---

Demandes module definition

DemPurchase business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
demReqType	enum(100) using REQUESTTYPE list				-

Lists

• REQUESTTYPE
  • PURCHASE Purchase
  • RENTAL Rental

DemUser business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
usr_image_id	image		yes	yes	Picture
usr_login	regexp(100)	yes*	yes	yes	Login
usr_first_name	char(50)		yes	yes	First name
usr_last_name	char(50)		yes	yes	Last name
usr_email	email(100)		yes	yes	Email address
usr_cell_num	phone(20)		yes	yes	Mobile/cellular phone number
demDemuserRole	enum(10) using DEM_DEMUSER_ROLE list		yes		-

Lists

• DEM_DEMUSER_ROLE
  • A Administrator
  • M Manager
  • U User

DemRequestHistoric business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
row_ref_id link to DemRequest	id	yes*			Record row ID
row_idx	int(11)	yes*	yes		History record index
created_by_hist	char(100)	yes*			Created by
created_dt_hist	datetime	yes*			Created date
demReqRejectedReasonManager	multi(500) using DEMREQUESTREJECTEDREASONMANAGER list				-
demReqRejectedReasonAdministrator	multi(500) using DEMREQREJECTEDREASONADMINISTRATOR list				-
demReqStatus	enum(20) using REQUESTSTATUS list		yes		-

Lists

• DEMREQUESTREJECTEDREASONMANAGER
  • NOBUDGET No budget
  • NOTNECESSARY Not necessary
• DEMREQREJECTEDREASONADMINISTRATOR
  • NOBUDGET No budget
  • UNAVAILABLE Unavailable
• REQUESTSTATUS
  • DRAFT Draft
  • PENDING Pending
  • VALIDATED Validated
  • REJECTED Rejected
  • REQUESTFUTHERINFO Request for futher information
  • PROCESSING Processing
  • CLOSED Closed
  • CANCELLED Cancelled

DemRequest business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
demReqReference	char(12)	yes*			-
demReqTitle	char(100)		yes		-
demReqType	enum(100) using REQUESTTYPE list				-
demReqStatus	enum(20) using REQUESTSTATUS list		yes		-
demReqRejectedReason	multi(500) using DEMREQREJECTEDREASONADMINISTRATOR list				-
demReqFutherInformation	notepad(500)		yes		-
demReqRequestDate	date				-
demReqSupplyType	enum(10) using SUPPLYTYPE-REQ list	yes	yes		-
demReqDemUserId link to DemUser	id		yes		-
demReqDesc	html(1000)		yes		-
Ref. demReqDemUserId.usr_login	regexp(100)			yes	Login
Ref. demReqDemUserId.usr_first_name	char(50)			yes	First name
Ref. demReqDemUserId.usr_last_name	char(50)			yes	Last name
Ref. demReqDemUserId.usr_email	email(100)			yes	Email address

Lists

• REQUESTTYPE
  • PURCHASE Purchase
  • RENTAL Rental
• REQUESTSTATUS
  • DRAFT Draft
  • PENDING Pending
  • VALIDATED Validated
  • REJECTED Rejected
  • REQUESTFUTHERINFO Request for futher information
  • PROCESSING Processing
  • CLOSED Closed
  • CANCELLED Cancelled
• DEMREQREJECTEDREASONADMINISTRATOR
  • NOBUDGET No budget
  • UNAVAILABLE Unavailable
• SUPPLYTYPE-REQ
  • FURNITURE Furniture
  • IT IT
  • OFFICE Office supplies

DemRental business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
demRenStartDate	datetime	yes	yes		-
demRenEndDate	datetime	yes	yes		-
demRenEquipmentCondition	char(100)		yes		-
demReqType	enum(100) using REQUESTTYPE list				-
demReqStatus	enum(20) using REQUESTSTATUS list		yes		-
demReqRejectedReason	multi(500) using DEMREQREJECTEDREASONADMINISTRATOR list				-
demReqSupplyType	enum(10) using SUPPLYTYPE-REQ list	yes	yes		-

Lists

• REQUESTTYPE
  • PURCHASE Purchase
  • RENTAL Rental
• REQUESTSTATUS
  • DRAFT Draft
  • PENDING Pending
  • VALIDATED Validated
  • REJECTED Rejected
  • REQUESTFUTHERINFO Request for futher information
  • PROCESSING Processing
  • CLOSED Closed
  • CANCELLED Cancelled
• DEMREQREJECTEDREASONADMINISTRATOR
  • NOBUDGET No budget
  • UNAVAILABLE Unavailable
• SUPPLYTYPE-REQ
  • FURNITURE Furniture
  • IT IT
  • OFFICE Office supplies

DemSupplier business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
demSprName	char(100)	yes*	yes		-
demSprContactLastName	char(100)		yes		-
demSprContactName	char(100)		yes		-
demSprContactEmail	char(100)		yes		-
demSprContactPhone	char(100)		yes		-

DemSupply business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
demSupReference	char(100)	yes*			-
demSupName	char(100)		yes		-
demSupType	enum(100) using SUPPLYTYPE list	yes	yes		-
demSupDescription	text(500)		yes		-
demSupDeliveryTimeDays	int(10)		yes		-
demSupStockQuantity	int(10)		yes		-
demSupPrice	float(10, 0)		yes		-
demSupAllocation	enum(10) using REQSUPALLOCATION list		yes		-
demSupSprId link to DemSupplier	id	yes*	yes		-
Ref. demSupSprId.demSprName	char(100)				-

Lists

• SUPPLYTYPE
  • FURNITURE Furniture
  • IT IT
  • OFFICE Office supplies
• REQSUPALLOCATION
  • PURCHASE Purchase
  • RENTAL Rental

DemReqSup business object definition

Fields

Name	Type	Required	Updatable	Personal	Description
demReqsupReqId link to DemRequest	id	yes*	yes		-
Ref. demReqsupReqId.demReqReference	char(12)				-
Ref. demReqsupReqId.demReqTitle	char(100)				-
Ref. demReqsupReqId.demReqType	enum(100) using REQUESTTYPE list				-
Ref. demReqsupReqId.demReqSupplyType	enum(10) using SUPPLYTYPE-REQ list				-
demReqsupSupId link to DemSupply	id	yes*	yes		-
Ref. demReqsupSupId.demSupReference	char(100)				-
Ref. demReqsupSupId.demSupStockQuantity	int(10)				-
Ref. demReqsupSupId.demSupSprId	id				-
Ref. demSupSprId.demSprName	char(100)				-
Ref. demReqsupSupId.demSupName	char(100)				-
Ref. demReqsupSupId.demSupType	enum(100) using SUPPLYTYPE list				-
Ref. demReqsupSupId.demSupAllocation	enum(10) using REQSUPALLOCATION list				-
demReqsupOrderChoice	multi(100) using DEMREQSUPORDERCHOICE list		yes		-
demReqsupQuantityOrdered	int(100)		yes		-
demReqsupQuantityRequired	int(10)	yes	yes		-

Lists

• REQUESTTYPE
  • PURCHASE Purchase
  • RENTAL Rental
• SUPPLYTYPE-REQ
  • FURNITURE Furniture
  • IT IT
  • OFFICE Office supplies
• SUPPLYTYPE
  • FURNITURE Furniture
  • IT IT
  • OFFICE Office supplies
• REQSUPALLOCATION
  • PURCHASE Purchase
  • RENTAL Rental
• DEMREQSUPORDERCHOICE
  • DECREASESTOCK Decrease stock
  • ORDER Order

DemRentalAgenda external object definition