Supplier Rating

Supplier Rating

Table Name Vr_MntVenRate_PARAMETERPOEXCL_Dtl

Table Comment This table has been added to hold the PO types that are to be excluded while calculating Vendor Rating
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Vr_MntVenRate_POEX_ouinstance	int	NULL	This field holds the ouinstance in which the document is created	No	No
Vr_MntVenRate_POEX_PARAMCODE	varchar(5)	NULL	To store the parameter code of the PO type to be excluded	No	No
Vr_MntVenRate_POEX_PARAMTYPE	varchar()	NULL	To store the parameter description of the PO type	No	No
Vr_MntVenRate_POEX_PartRatPDVFlag	varchar()	NULL	To store the flag which indicates Exclusions when price rating basis is PDV	No	No
Vr_MntVenRate_POEX_PartRatVIVFlag	varchar()	NULL	To store the flag which indicates Exclusions when price rating basis is VIV	No	No
Vr_MntVenRate_POEX_SerRatFlag	varchar(80)	NULL	To store the flag which indicates Exclusions when Service rating is done	No	No

Table Name vr_parameter_details

Table Comment This tables holds the metadata of combo values and documents statuses of the component vendor rating
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
componentname	varchar(20)	NOT NULL	This field holds the Name of the component.	Yes	No
param_category	varchar(10)	NOT NULL	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	No
param_type	varchar(25)	NOT NULL	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	No
param_code	varchar(40)	NOT NULL	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	No
lang_id	numeric(10)	NOT NULL	Language id. This is the language id of the record.	Yes	No
param_desc	varchar(80)	NULL	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	No
creation_date	datetime	NULL	This field holds the record created date for auditing purpose	No	No
sortby	numeric(10)	NULL	This field holds the default sort by code	No	No
timestamp	numeric(8)	NULL	Timestamp for Concurrency check	No	No

Table Name VR_VRDLVRY_RATING

Table Comment This table holds the vendor ratings for each document pertaining to the Organization unit
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
VRDLVRY_ORDER_DOC_OUINSTANCE	decimal(10)	NOT NULL	This field holds the ouinstance in which the document is created	No	No
VRDLVRY_ORDER_DOC_TYPE	varchar(25)	NOT NULL	This field holds the Reference document type	No	No
VRDLVRY_ORDER_DOC_NO	varchar(40)	NOT NULL	This field holds the Reference document number	No	No
VRDLVRY_PART_SERV_LINE_NO	decimal(10)	NOT NULL	This field holds the Reference document part line number	No	No
VRDLVRY_PART_SERV_NO	varchar(40)	NOT NULL	This field holds the Reference document part or service number	No	No
VRDLVRY_ORDER_DOC_DATE	datetime	NOT NULL	This field holds the Reference document date	No	No
VRDLVRY_SUPP_CODE	varchar(45)	NOT NULL	This field holds the Reference document Supplier code	No	No
VRDLVRY_SCH_NO	decimal(10)	NOT NULL	This field holds the Reference document schedule number	No	No
VRDLVRY_SCH_DATE	datetime	NULL	This field holds the Reference document schedule date	No	No
VRDLVRY_SCH_QTY	decimal(28,8)	NOT NULL	This field holds the Reference document schedule qty	No	No
VRDLVRY_DLVRY_DATE	datetime	NULL	This field holds the Reference document Delivery date	No	No
VRDLVRY_ACCEPTED_QTY	decimal(28,8)	NULL	This field holds the Reference document Accepted quantity	No	No
VRDLVRY_DELAY_EARLY_FLAG	varchar(25)	NULL	This field holds the flag for delay early	No	No
VRDLVRY_DELAY_EARLY_VALUE	decimal(28,8)	NULL	This field holds the value for delay early	No	No
VRDLVRY_DEL_FLAG	varchar(25)	NOT NULL	This field holds the flag to delete multiline record	No	No
VRDLVRY_MODIFIEDDATE	datetime	NOT NULL	This field holds the date when the Reference document is modified.	No	No
VRDLVRY_MODIFIED_BY	varchar(30)	NOT NULL	This field holds the user when the reference document is modified.	No	No
VRDLVRY_TIMESTAMP	decimal(8)	NULL	This field holds the integer value which identifies if any change has been made to the record.	No	No

Table Name vr_vrmntvenrate_comprat_dtl

Table Comment Detail table for Computation of Vendor Rating.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
vrmntvenrate_remarks	varchar(255)	NULL	This field holds the Remarks	No	No
vrmntvenrate_createddate	datetime	NOT NULL	This field holds the creation Date of the transaction.	No	No
vrmntvenrate_created_ou	numeric(10)	NULL	This field holds the Login Location ou	No	No
vrmntvenrate_overall_rating	decimal(28,8)	NULL	This field holds the Overall Rating based on Rating Type and Overall Vendor Rating Basis.	No	No
vrmntvenrate_modified_by	varchar(30)	NULL	This field holds the user who has Last modified the transaction.	No	No
vrmntvenrate_created_by	varchar(30)	NULL	This field holds the user who has created the transaction.	No	No
vrmntvenrate_modifieddate	datetime	NOT NULL	This field holds the last modified date of the transaction.	No	No
vrmntvenrate_timestamp	numeric(10)	NULL	This field holds the timestamp for concurrency check.	No	No
vrmntvenrate_ratingno	varchar(40)	NOT NULL	This field holds the Rating No.	Yes	Yes
vrmntvenrate_supp_code	varchar(45)	NOT NULL	Vendor Code - All Vendors satisfying the Supplier Category, Supplier Type and Vendor Rating Type.	Yes	No
vrmntvenrate_ouinstance	numeric(10)	NOT NULL	This field holds the login OUInstance	Yes	Yes
VRMNTVENRATE_SERVICE_QLTY_RATI	decimal(28,8)	NULL	This field holds the Computed Rating based on Quality for Service Items.	No	No
vrmntvenrate_delivery_rating	decimal(28,8)	NULL	This field holds the Computed Rating based on Delivery.	No	No
vrmntvenrate_price_rating	decimal(28,8)	NULL	This field holds the Computed Rating based on Price.	No	No
vrmntvenrate_quality_rating	decimal(28,8)	NULL	This field holds the Computed Rating based on Quality for Parts.	No	No

Table Name vr_vrmntvenrate_comprat_hdr

Table Comment Header table for Computation of Vendor Rating.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
vrmntvenrate_ouinstance	numeric(10)	NOT NULL	This field holds the Login OU	Yes	No
vrmntvenrate_ratingno	varchar(40)	NOT NULL	This field holds the Rating No.	Yes	No
vrmntvenrate_num_type_no	varchar(5)	NULL	This field holds the Numbering Type No.	No	No
vrmntvenrate_venrate_type	varchar(25)	NULL	This field holds the Vendor Rating Type as to Part, Service or Overall.	No	No
vrmntvenrate_location_ou	numeric(10)	NULL	This field holds the location at which Vendor Rating is to be performed.	No	No
vrmntvenrate_ratingby	varchar(30)	NULL	This field holds the Employee Code of the person rating.	No	No
vrmntvenrate_supp_type	varchar(25)	NULL	This field holds the type of Supplier as Normal, Miscellaneous and Blank.	No	No
vrmntvenrate_supp_category	varchar(25)	NULL	This field holds the supplier Category.	No	No
vrmntvenrate_from_date	datetime	NOT NULL	This field holds the from date - Starting date of the period during which Vendor is going to be rated.	No	No
vrmntvenrate_to_date	datetime	NOT NULL	This field holds the to Date - End date of the period during which Vendor is going to be rated.	No	No
vrmntvenrate_part_serv_no	varchar(40)	NULL	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	No
vrmntvenrate_remarks	varchar(255)	NULL	This field holds the Remarks	No	No
vrmntvenrate_ovr_rating_basis	varchar(5)	NULL	Overall Vendor Rating Basis at the time of Compute Vendor Rating is stored for use in View Vendor Rating screens.	No	No
vrmntvenrate_createddate	datetime	NOT NULL	Creation Date of the entry.	No	No
vrmntvenrate_createdby	varchar(30)	NULL	User who has created the entry.	No	No
vrmntvenrate_modifieddate	datetime	NOT NULL	Last Modified Date of the entry.	No	No
vrmntvenrate_modifiedby	varchar(30)	NULL	User who has last modified.	No	No
vrmntvenrate_timestamp	numeric(10)	NULL	Timestamp for Concurrency check.	No	No

Table Name vr_vrmntwt_mntwt_hdr

Table Comment This table stores weightage details of User and System parameters.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
VRWTDET_PARAMETER_CODE	varchar(40)	NOT NULL	This field holds the Parameter code	Yes	No
VRWTDET_PARAMLINENO	numeric(10)	NOT NULL	This field holds the line number for parameter code	Yes	No
VRWTDET_OUINSTANCE	numeric(10)	NOT NULL	This field holds the Organization unit	Yes	No
vrwtdet_parameter_type	varchar(25)	NOT NULL	Parameter classification as User Defined or System Defined.	No	No
vrwtdet_weightage	decimal(28,8)	NULL	Weightage to the Parameter.	No	No
vrwtdet_remarks	varchar(255)	NULL	This field holds the Remarks	No	No
vrwtdet_createddate	datetime	NOT NULL	Creation Date of this entry.	No	No
vrwtdet_createdby	varchar(30)	NOT NULL	User who created this entry.	No	No
vrwtdet_modifieddate	datetime	NULL	Last modification date of this entry.	No	No
vrwtdet_modifiedby	varchar(30)	NULL	Last User who has modified.	No	No
vrwtdet_timestamp	numeric(10)	NOT NULL	Timestamp for concurrency.	No	No

Table Name vr_vroptset_option_settings

Table Comment Stores the Set Options for this Component.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
vroptset_ouinstance	numeric(10)	NOT NULL	This field holds the login OU Instance	Yes	No
vroptset_capital_items	varchar(25)	NOT NULL	Conveys whether Capital Items should be Included or Excluded for Rating.	No	No
VROPTSET_OVR_RATING_BASIS	varchar(25)	NOT NULL	This field holds the Overall rating basis	No	No
vroptset_price_index_basis	varchar(25)	NOT NULL	Captures Price should be taken as Purchase Document Value or Invoice Document Value	No	No
vroptset_price_rating_basis	varchar(25)	NOT NULL	Captures whether Rating basis is Std. Purchase Price or Weighted Avg. Price	No	No
vroptset_early_delivery	varchar(25)	NOT NULL	Captures whether Early Delivery should be penalised or not.	No	No
vroptset_problem_schdls	varchar(25)	NOT NULL	Whether Schedules having Rejected Qty. Should penalize the Vendor or not.	No	No
vroptset_modified_by	varchar(30)	NULL	Last User who has modified.	No	No
vroptset_modifieddate	datetime	NULL	Latest Modification date	No	No
vroptset_created_by	varchar(30)	NOT NULL	This field holds the user name of the creation	No	No
vroptset_createddate	datetime	NOT NULL	This field holds the date for created record	No	No
vroptset_timestamp	numeric(10)	NOT NULL	Timestamp for concurrency.	No	No

Table Name VR_VRPRICE_RATING

Table Comment This table holds the Vendor price rating documentwise
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
VRPRICE_ORDER_DOC_OUINSTANCE	decimal(10)	NOT NULL	This field holds the ouinstance in which the document is created	Yes	No
VRPRICE_ORDER_DOC_TYPE	varchar(40)	NOT NULL	This field holds the Reference document type	Yes	No
VRPRICE_ORDER_DOC_NO	varchar(25)	NOT NULL	This field holds the Reference document number	Yes	No
VRPRICE_PART_SERV_NO	varchar(40)	NOT NULL	This field holds the Reference document part line number	Yes	No
VRPRICE_PART_SERV_LINE_NO	decimal(10)	NOT NULL	This field holds the Reference document part or service number	Yes	No
VRPRICE_PART_CONDITION	varchar(5)	NULL	This field holds the part condition	No	No
VRPRICE_ORDER_DOC_DATE	datetime	NOT NULL	This field holds the Reference document date	No	No
VRPRICE_ORDER_QTY	decimal(28,8)	NOT NULL	This field holds the Order quantity of the part	No	No
VRPRICE_SUPP_CODE	varchar(45)	NOT NULL	This field holds the Reference document Supplier code	No	No
VRPRICE_ORDER_PRICE	decimal(28,8)	NOT NULL	This field holds the Reference document Order price	No	No
VRPRICE_INVOICE_PRICE	decimal(28,8)	NULL	This field holds the Reference document Invoice price	No	No
VRPRICE_MODIFIEDDATE	datetime	NOT NULL	This field holds the date when the Reference document is modified.	No	No
VRPRICE_MODIFIED_BY	varchar(30)	NOT NULL	This field holds the user when the reference document is modified.	No	No
VRPRICE_TIMESTAMP	decimal(8)	NOT NULL	This field holds the integer value which identifies if any change has been made to the record.	No	No

Table Name VR_VRQLTY_RATING

Table Comment This table holds the Vendor ratings GR documentwise
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
VRQLTY_GR_OUINSTANCE	decimal(10)	NOT NULL	This field holds the ouinstance in which the document is created	Yes	No
VRQLTY_GR_DOC_NO	varchar(25)	NOT NULL	This field holds the Document no. in which the GR document is created	Yes	No
VRQLTY_PART_NO	varchar(40)	NOT NULL	This field holds the Part no in which the document is created	Yes	No
VRQLTY_GR_DATE	datetime	NOT NULL	This field holds the GR date in which the document is created	No	No
VRQLTY_SUPP_CODE	varchar(45)	NOT NULL	This field holds the Supplier code in which the document is created	No	No
VRQLTY_RCVD_QTY	decimal(28,8)	NOT NULL	This field holds the Received quantity in which the document is created	No	No
VRQLTY_REJECTED_QTY	decimal(28,8)	NULL	This field holds the Rejected quantity in which the document is created	No	No
VRQLTY_MODIFIEDDATE	datetime	NOT NULL	This field holds the Modified date in which the document is created	No	No
VRQLTY_MODIFIED_BY	varchar(30)	NOT NULL	This field holds the username in which the document is created	No	No
VRQLTY_TIMESTAMP	decimal(8)	NOT NULL	This field holds the Timestamp for concurrency check	No	No

Table Name vr_vrusprm_usrprm_list

Table Comment This table holds the User Defined Parameter Details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
vrusprm_ouinstance	numeric(10)	NOT NULL	This field holds the login ouinstance.	Yes	No
vrusprm_locationou	numeric(10)	NOT NULL	Location Ou selected in the combo of Maintain User Defined Parameters screen.	Yes	No
vrusprm_lineno	numeric(10)	NOT NULL	This field holds the line number	Yes	No
vrusprm_parameter	varchar(40)	NOT NULL	User Defined Parameter will be defined here.	No	No
vrusprm_status	varchar(5)	NOT NULL	The Status of the parameter will be chosen as Active or Inactive.	No	No
vrusprm_remarks	varchar(255)	NULL	this field holds the remarks	No	No
vrusprm_createddate	datetime	NOT NULL	Parameter Creation Date.	No	No
vrusprm_created_by	varchar(30)	NOT NULL	User who created the Parameter.	No	No
vrusprm_modifieddate	datetime	NULL	Modification Date of the Parameter.	No	No
vrusprm_modified_by	varchar(30)	NULL	User who has modified the parameter.	No	No
vrusprm_timestamp	numeric(10)	NOT NULL	Timestamp for Concurrency.	No	No