Data Dictionary -- Supplier Rating

Srl. No.	Table Name	Comment
1	Vrep_MC_Part_dtl_tbl	Vrep_MC_Part_dtl_tbl
2	Vr_MntVenRate_PARAMETERPOEXCL_Dtl	This table has been added to hold the PO types that are to be excluded while calcuating Vendor Rating
3	VR_PARAMETER_DETAILS	This tables holds the metada of combo values and documente statuses of the component vendor rating
4	VR_VRCOMPRAT_PRM_WT_INDEX	VR_VRCOMPRAT_PRM_WT_INDEX
5	VR_VRDLVRY_RATING	This table holds the vendor ratings for each document pertaining to the Organisation unit
6	VR_VRMNTVENRATE_COMPRAT_DTL	Detail table for Computation of Vendor Rating.
7	VR_VRMNTVENRATE_COMPRAT_HDR	Header table for Computation of Vendor Rating.
8	VR_VRMNTWT_MNTWT_HDR	This table stores weightage details of User and System parameters.
9	VR_VROPTSET_OPTION_SETTINGS	Stores the Set Options for this Component.
10	VR_VRPRICE_RATING	This table holds the Vendor price rating documentwise
11	VR_VRPRMIND_PRM_INDICES	VR_VRPRMIND_PRM_INDICES
12	VR_VRQLTY_RATING	This table holds the Vendor ratings GR documentwise
13	VR_VRUSPRM_USRPRM_LIST	This table holds the User Defined Parameter Details.

Table Name :	Vrep_MC_Part_dtl_tbl
Comment :	Vrep_MC_Part_dtl_tbl

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mainguid	udd_guid	varchar(40)	Yes	mainguid	No
GUID	udd_guid	varchar(40)	Yes	GUID	No
Techlogno	udd_documentno	varchar(40)	Yes	Techlogno	No
techlogou	udd_ctxt_ouinstance	int(4)	Yes	techlogou	No
Acregno	_varchar_30	varchar(30)	Yes	Acregno	No
WrkCntr	_varchar_30	varchar(30)	Yes	WrkCntr	No
wou	udd_ctxt_ouinstance	int(4)	Yes	wou	No
wuno	udd_documentno	varchar(40)	Yes	wuno	No
wrevno	udd_documentno	varchar(40)	Yes	wrevno	No
wtype	_varchar_25	Varchar(25)	Yes	wtype	No
partno	udd_documentno	varchar(40)	Yes	partno	No
Partqty	udd_quantity	numeric(13)	Yes	Partqty	No
stdvalue	_decimal_18_2	decimal(18)	Yes	stdvalue	No
Issqty	udd_quantity	numeric(13)	Yes	Issqty	No
IssValue	_decimal_18_2	decimal(18)	Yes	IssValue	No
stkstatus	_varchar_25	Varchar(25)	Yes	stkstatus	No

Table Name :	Vr_MntVenRate_PARAMETERPOEXCL_Dtl
Comment :	This table has been added to hold the PO types that are to be excluded while calcuating Vendor Rating

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Vr_MntVenRate_POEX_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	This field holds the ouinstance in which the document is created	No
Vr_MntVenRate_POEX_PARAMCODE	udd_designparamcode	varchar(5)	No	To store the parameter code of the PO type to be excluded	No
Vr_MntVenRate_POEX_PARAMTYPE	udd_txt80	varchar(80)	No	To store the parameter description of the PO type	No
Vr_MntVenRate_POEX_PartRatPDVFlag	udd_txt80	varchar(80)	No	To store the flag which indicates Exclusions when price rating basis is PDV	No
Vr_MntVenRate_POEX_PartRatVIVFlag	udd_txt80	varchar(80)	No	To store the flag which indicates Exclusions when price rating basis is VIV	No
Vr_MntVenRate_POEX_SerRatFlag	udd_txt80	varchar(80)	No	To store the flag which indicates Exclusions when Service rating is done	No

Table Name :	VR_PARAMETER_DETAILS
Comment :	This tables holds the metada of combo values and documente statuses of the component vendor rating

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_20	varchar(20)	No	This field holds the Name of the component.	Yes
PARAM_CATEGORY	_varchar_10	varchar(10)	No	This field will holds the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes
PARAM_TYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes
PARAM_CODE	_varchar_40	varchar(40)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes
PARAM_DESC	_varchar_80	varchar(80)	Yes	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
LANG_ID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
CREATION_DATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose	No
SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No
TIMESTAMP	_decimal_8_0	decimal(8)	Yes	Timestamp for Concurrency check	No

Table Name :	VR_VRCOMPRAT_PRM_WT_INDEX
Comment :	VR_VRCOMPRAT_PRM_WT_INDEX

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRCOMPRAT_OUINSTANCE	_decimal_10_0	decimal(10)	No	VRCOMPRAT_OUINSTANCE	Yes
VRCOMPRAT_RATINGNO	_varchar_40	varchar(40)	No	VRCOMPRAT_RATINGNO	Yes
VRCOMPRAT_SUPP_CODE	_varchar_45	varchar(45)	No	VRCOMPRAT_SUPP_CODE	Yes
VRCOMPRAT_PARAM_TYPE	_varchar_25	Varchar(25)	No	VRCOMPRAT_PARAM_TYPE	No
VRCOMPRAT_PARAM_CODE	_varchar_40	varchar(40)	No	VRCOMPRAT_PARAM_CODE	Yes
VRCOMPRAT_USRPRM_LINENO	_decimal_10_0	decimal(10)	No	VRCOMPRAT_USRPRM_LINENO	Yes
VRCOMPRAT_PARAM_INDEX	_decimal_28_8	decimal(28)	Yes	VRCOMPRAT_PARAM_INDEX	No
VRCOMPRAT_PARAM_WEIGHTAGE	_decimal_28_8	decimal(28)	Yes	VRCOMPRAT_PARAM_WEIGHTAGE	No
VRCOMPRAT_REMARKS	_varchar_255	varchar(255)	Yes	VRCOMPRAT_REMARKS	No
VRCOMPRAT_CREATED_BY	_varchar_30	varchar(30)	Yes	VRCOMPRAT_CREATED_BY	No
VRCOMPRAT_CREATEDDATE	_datetime_8	datetime(8)	No	VRCOMPRAT_CREATEDDATE	No
VRCOMPRAT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	VRCOMPRAT_MODIFIED_BY	No
VRCOMPRAT_MODIFIEDDATE	_datetime_8	datetime(8)	No	VRCOMPRAT_MODIFIEDDATE	No
VRCOMPRAT_TIMESTAMP	_decimal_10_0	decimal(10)	No	VRCOMPRAT_TIMESTAMP	No

Table Name :	VR_VRDLVRY_RATING
Comment :	This table holds the vendor ratings for each document pertaining to the Organisation unit

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRDLVRY_ORDER_DOC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the document is created	No
VRDLVRY_ORDER_DOC_TYPE	_varchar_25	Varchar(25)	No	This field holds the Reference document type	No
VRDLVRY_ORDER_DOC_NO	_varchar_40	varchar(40)	No	This field holds the Reference document number	No
VRDLVRY_PART_SERV_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Reference document part line number	No
VRDLVRY_PART_SERV_NO	_varchar_40	varchar(40)	No	This field holds the Reference document part or service number	No
VRDLVRY_ORDER_DOC_DATE	_datetime_8	datetime(8)	No	This field holds the Reference document date	No
VRDLVRY_SUPP_CODE	_varchar_45	varchar(45)	No	This field holds the Reference document Supplier code	No
VRDLVRY_SCH_NO	_decimal_10_0	decimal(10)	No	This field holds the Reference document schedule number	No
VRDLVRY_SCH_DATE	_datetime_8	datetime(8)	Yes	This field holds the Reference document schedule date	No
VRDLVRY_SCH_QTY	_decimal_28_8	decimal(28)	No	This field holds the Reference document schedule qty	No
VRDLVRY_DLVRY_DATE	_datetime_8	datetime(8)	Yes	This field holds the Reference document Delivery date	No
VRDLVRY_ACCEPTED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Reference document Accepted quantity	No
VRDLVRY_DELAY_EARLY_FLAG	_varchar_25	Varchar(25)	Yes	This field holds the flag for delay early	No
VRDLVRY_DELAY_EARLY_VALUE	_decimal_28_8	decimal(28)	Yes	This field holds the value for delay early	No
VRDLVRY_DEL_FLAG	_varchar_25	Varchar(25)	No	This field holds the flag to delete multline record	No
VRDLVRY_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field holds the date when the Reference document is modified.	No
VRDLVRY_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user when the reference document is modified.	No
VRDLVRY_TIMESTAMP	_decimal_8_0	decimal(8)	Yes	This field holds the integer value which identifies if any change has been made to the record.	No

Table Name :	VR_VRMNTVENRATE_COMPRAT_DTL
Comment :	Detail table for Computation of Vendor Rating.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRMNTVENRATE_RATINGNO	_varchar_40	varchar(40)	No	This field holds the Rating No.	Yes
VRMNTVENRATE_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the login OUInstance	Yes
VRMNTVENRATE_CREATEDDATE	_datetime_8	datetime(8)	No	Creation Date of the entry.	No
VRMNTVENRATE_SUPP_CODE	_varchar_45	varchar(45)	No	Vendor Code - All Vendors satisfying the Supplier Category, Supplier Type and Vendor Rating Type.	Yes
VRMNTVENRATE_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who has created the transaction.	No
VRMNTVENRATE_PRICE_RATING	_decimal_28_8	decimal(28)	Yes	This field holds the Computed Rating based on Price.	No
VRMNTVENRATE_QUALITY_RATING	_decimal_28_8	decimal(28)	Yes	This field holds the Computed Rating based on Quality for Parts.	No
VRMNTVENRATE_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field holds the last modified date of the transaction.	No
VRMNTVENRATE_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who has Last modified the transaction.	No
VRMNTVENRATE_DELIVERY_RATING	_decimal_28_8	decimal(28)	Yes	This field holds the Computed Rating based on Delivery.	No
VRMNTVENRATE_SERVICE_QLTY_RATI	_decimal_28_8	decimal(28)	Yes	This field holds the Computed Rating based on Quality for Service Items.	No
VRMNTVENRATE_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp for Concurrency check.	No
VRMNTVENRATE_OVERALL_RATING	_decimal_28_8	decimal(28)	Yes	This field holds the Overall Rating based on Rating Type and Overall Vendor Rating Basis.	No
VRMNTVENRATE_CREATED_OU	_decimal_10_0	decimal(10)	Yes	This field holds the Login Location ou	No
VRMNTVENRATE_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
VRMNTVENRATE_SEQNO	udd_seqno	int(4)	Yes	VRMNTVENRATE_SEQNO	No

Table Name :	VR_VRMNTVENRATE_COMPRAT_HDR
Comment :	Header table for Computation of Vendor Rating.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRMNTVENRATE_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the login OUInstance	Yes
VRMNTVENRATE_RATINGNO	_varchar_40	varchar(40)	No	This field holds the Rating No.	Yes
VRMNTVENRATE_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	This field holds the Numbering Type No.	No
VRMNTVENRATE_RATINGBY	_varchar_30	varchar(30)	Yes	This field holds the Employee Code of the person rating.	No
VRMNTVENRATE_VENRATE_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the Vendor Rating Type as to Part, Service or Overall.	No
VRMNTVENRATE_LOCATION_OU	_decimal_10_0	decimal(10)	Yes	This field holds the location at which Vendor Rating is to be performed.	No
VRMNTVENRATE_SUPP_TYPE	_varchar_25	Varchar(25)	Yes	This field holds the type of Supplier as Normal, Miscellaneous and Blank.	No
VRMNTVENRATE_SUPP_CATEGORY	_varchar_25	Varchar(25)	Yes	This field holds the supplier Category.	No
VRMNTVENRATE_FROM_DATE	_datetime_8	datetime(8)	No	This field holds the from date - Starting date of the period during which Vendor is going to be rated.	No
VRMNTVENRATE_TO_DATE	_datetime_8	datetime(8)	No	This field holds the to Date - End date of the period during which Vendor is going to be rated.	No
VRMNTVENRATE_PART_SERV_NO	_varchar_40	varchar(40)	Yes	This field holds the If Rating Type is Parts, Item of type Part will be stored, Service - Item of type Service will be stored and Overall Null will be stored.	No
VRMNTVENRATE_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
VRMNTVENRATE_CREATEDDATE	_datetime_8	datetime(8)	No	Creation Date of the entry.	No
VRMNTVENRATE_OVR_RATING_BASIS	_varchar_5	varchar(5)	Yes	Overall Vendor Rating Basis at the time of Compute Vendor Rating is stored for use in View Vendor Rating screens.	No
VRMNTVENRATE_MODIFIEDBY	_varchar_30	varchar(30)	Yes	User who has last modified.	No
VRMNTVENRATE_CREATEDBY	_varchar_30	varchar(30)	Yes	User who has created the entry.	No
VRMNTVENRATE_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp for Concurrency check.	No
VRMNTVENRATE_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field holds the last modified date of the transaction.	No

Table Name :	VR_VRMNTWT_MNTWT_HDR
Comment :	This table stores weightage details of User and System parameters.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRWTDET_PARAMETER_CODE	_varchar_40	varchar(40)	No	This field holds the Parameter code	Yes
VRWTDET_PARAMLINENO	_decimal_10_0	decimal(10)	No	This field holds the line number for parameter code	Yes
VRWTDET_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the Organisation unit	Yes
VRWTDET_PARAMETER_TYPE	_varchar_25	Varchar(25)	No	Parameter classification as User Defined or System Defined.	No
VRWTDET_WEIGHTAGE	_decimal_28_8	decimal(28)	Yes	Weightage to the Parameter.	No
VRWTDET_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the Remarks	No
VRWTDET_CREATEDDATE	_datetime_8	datetime(8)	No	Creation Date of this entry.	No
VRWTDET_CREATEDBY	_varchar_30	varchar(30)	No	User who created this entry.	No
VRWTDET_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modification date of this entry.	No
VRWTDET_MODIFIEDBY	_varchar_30	varchar(30)	Yes	Last User who has modified.	No
VRWTDET_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp for concurrency.	No

Table Name :	VR_VROPTSET_OPTION_SETTINGS
Comment :	Stores the Set Options for this Component.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VROPTSET_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the login OU Instance	Yes
VROPTSET_CAPITAL_ITEMS	_varchar_25	Varchar(25)	No	Conveys whether Capital Items should be Included or Excluded for Rating.	No
VROPTSET_OVR_RATING_BASIS	_varchar_25	Varchar(25)	No	This field holds the Overall rating basis	No
VROPTSET_PRICE_INDEX_BASIS	_varchar_25	Varchar(25)	No	Captures Price should be taken as Purchase Document Value or Invoice Document Value	No
VROPTSET_PRICE_RATING_BASIS	_varchar_25	Varchar(25)	No	Captures whether Rating basis is Std. Purchase Price or Weighted Avg. Price	No
VROPTSET_EARLY_DELIVERY	_varchar_25	Varchar(25)	No	Captures whether Early Delivery should be penalised or not.	No
VROPTSET_PROBLEM_SCHDLS	_varchar_25	Varchar(25)	No	Whether Schedules having Rejected Qty. should penalise the Vendor or not.	No
VROPTSET_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last User who has modified.	No
VROPTSET_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Latest Modification date	No
VROPTSET_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the user name of the creation	No
VROPTSET_CREATEDDATE	_datetime_8	datetime(8)	No	This field holds the date for created recod	No
VROPTSET_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp for concurrency.	No

Table Name :	VR_VRPRICE_RATING
Comment :	This table holds the Vendor price rating documentwise

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRPRICE_ORDER_DOC_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the document is created	Yes
VRPRICE_ORDER_DOC_NO	_varchar_25	Varchar(25)	No	This field holds the Reference document number	Yes
VRPRICE_PART_SERV_NO	_varchar_40	varchar(40)	No	This field holds the Reference document part line number	Yes
VRPRICE_PART_SERV_LINE_NO	_decimal_10_0	decimal(10)	No	This field holds the Reference document part or service number	Yes
VRPRICE_PART_CONDITION	_varchar_5	varchar(5)	Yes	This field holds the part condition	No
VRPRICE_ORDER_DOC_TYPE	_varchar_40	varchar(40)	No	This field holds the Reference document type	Yes
VRPRICE_ORDER_DOC_DATE	_datetime_8	datetime(8)	No	This field holds the Reference document date	No
VRPRICE_ORDER_QTY	_decimal_28_8	decimal(28)	No	This field holds the Order quanity of the part	No
VRPRICE_SUPP_CODE	_varchar_45	varchar(45)	No	This field holds the Reference document Supplier code	No
VRPRICE_ORDER_PRICE	_decimal_28_8	decimal(28)	No	This field holds the Reference document Order price	No
VRPRICE_INVOICE_PRICE	_decimal_28_8	decimal(28)	Yes	This field holds the Reference document Invoice price	No
VRPRICE_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field holds the date when the Reference document is modified.	No
VRPRICE_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user when the reference document is modified.	No
VRPRICE_TIMESTAMP	_decimal_8_0	decimal(8)	No	This field holds the integer value which identifies if any change has been made to the record.	No

Table Name :	VR_VRPRMIND_PRM_INDICES
Comment :	VR_VRPRMIND_PRM_INDICES

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRMNTVENRATE_SEQNO	_decimal_10_0	decimal(10)	No	VRMNTVENRATE_SEQNO	Yes
VRPRMIND_LOCATIONOU	_decimal_10_0	decimal(10)	No	VRPRMIND_LOCATIONOU	Yes
VRPRMIND_SUPP_CODE	_varchar_45	varchar(45)	No	VRPRMIND_SUPP_CODE	Yes
VRPRMIND_USRPRM_LINENO	_decimal_10_0	decimal(10)	No	VRPRMIND_USRPRM_LINENO	Yes
VRPRMIND_INDEX	_decimal_28_8	decimal(28)	Yes	VRPRMIND_INDEX	No
VRPRMIND_REMARKS	_varchar_255	varchar(255)	Yes	VRPRMIND_REMARKS	No
VRPRMIND_CREATEDDATE	_datetime_8	datetime(8)	Yes	VRPRMIND_CREATEDDATE	No
VRPRMIND_CREATED_BY	_varchar_30	varchar(30)	Yes	VRPRMIND_CREATED_BY	No
VRPRMIND_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	VRPRMIND_MODIFIEDDATE	No
VRPRMIND_MODIFIED_BY	_varchar_30	varchar(30)	Yes	VRPRMIND_MODIFIED_BY	No
VRPRMIND_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	VRPRMIND_TIMESTAMP	No

Table Name :	VR_VRQLTY_RATING
Comment :	This table holds the Vendor ratings GR documentwise

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRQLTY_GR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the ouinstance in which the document is created	Yes
VRQLTY_GR_DOC_NO	_varchar_25	Varchar(25)	No	This field holds the Document no. in which the GR document is created	Yes
VRQLTY_GR_DATE	_datetime_8	datetime(8)	No	This field holds the GR date in which the document is created	No
VRQLTY_SUPP_CODE	_varchar_45	varchar(45)	No	This field holds the Supplier code in which the document is created	No
VRQLTY_PART_NO	_varchar_40	varchar(40)	No	This field holds the Part no in which the document is created	Yes
VRQLTY_RCVD_QTY	_decimal_28_8	decimal(28)	No	This field holds the Received quantity in which the document is created	No
VRQLTY_REJECTED_QTY	_decimal_28_8	decimal(28)	Yes	This field holds the Rejected quantioty in which the document is created	No
VRQLTY_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field holds the Modified date in which the document is created	No
VRQLTY_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the username in which the document is created	No
VRQLTY_TIMESTAMP	_decimal_8_0	decimal(8)	No	This field holds the Timestamp for concurrency check	No

Table Name :	VR_VRUSPRM_USRPRM_LIST
Comment :	This table holds the User Defined Parameter Details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
VRUSPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the login ouinstance.	Yes
VRUSPRM_LOCATIONOU	_decimal_10_0	decimal(10)	No	Location Ou selected in the combo of Maintain User Defined Parameters screen.	Yes
VRUSPRM_LINENO	_decimal_10_0	decimal(10)	No	This field holds the line number	Yes
VRUSPRM_PARAMETER	_varchar_40	varchar(40)	No	User Defined Parameter will be defined here.	No
VRUSPRM_STATUS	_varchar_5	varchar(5)	No	The Status of the parameter will be chosen as Active or Inactive.	No
VRUSPRM_REMARKS	_varchar_255	varchar(255)	Yes	this field holds the remarks	No
VRUSPRM_CREATEDDATE	_datetime_8	datetime(8)	No	Parameter Creation Date.	No
VRUSPRM_CREATED_BY	_varchar_30	varchar(30)	No	User who created the Parameter.	No
VRUSPRM_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modification Date of the Parameter.	No
VRUSPRM_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who has modified the parameter.	No
VRUSPRM_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp for Concurrency.	No