Data Dictionary - Part Price List
Table Name Ppl_Parameter_Details
Table Comment To store the parameter details of part pricelist
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	component name	Yes	No
ParamCategory	varchar(10)	NOT NULL	parameter category	Yes	No
ParamType	varchar(25)	NOT NULL	parameter type	Yes	No
ParamCode	varchar(5)	NOT NULL	parameter code	Yes	No
ParamDesc	varchar(80)	NOT NULL	parameter Description	No	No
Langid	int	NOT NULL	language id	No	No
Sortby	int	NOT NULL	sort by	No	No
CreationDate	datetime	NOT NULL	created date	No	No
Table Name Ppl_Partop_Options
Table Comment To store the set option details of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Partop_OUInstance	int	NOT NULL	instance	Yes	No
Partop_Approval	varchar(5)	NOT NULL	approval of partprice list on creation/approval values will be Required Not required Reqd only for revisions	No	No
Partop_Timestamp	int	NOT NULL	timestamp for not allowing more than one user to use the same data	No	No
Partop_Created_By	varchar(30)	NOT NULL	created by	No	No
Partop_Created_Date	datetime	NOT NULL	created date	No	No
Partop_BasPlNo	varchar(80)	NULL	basic part price list no	No	No
Partop_Modified_By	varchar(30)	NOT NULL	Modified by	No	No
Partop_Modified_Date	datetime	NOT NULL	Modified Date	No	No
Table Name Ppl_PartPlg_Group
Table Comment To store the part group details of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlg_OUInstance	int	NOT NULL	instance	Yes	No
PartPlg_SNO	int	NOT NULL	part group serial no	Yes	No
PartPlg_PlNo	varchar(40)	NOT NULL	part price list no	Yes	No
PartPlg_RevNo	varchar(40)	NOT NULL	part price list revision no	Yes	No
PartPlg_Part_Grp	varchar(20)	NOT NULL	part group name	No	No
PartPlg_Condition	varchar(5)	NOT NULL	part condition values will be like new over hauled phased out servicable unservicable	No	No
PartPlg_Price_Factor	numeric	NOT NULL	price factor for the part group defined	No	No
PartPlg_Emb_Factor	numeric	NULL	embodiment factor for the partgroup defined	No	No
PartPlg_Created_By	varchar(30)	NOT NULL	part group created by	No	No
PartPlg_Created_Date	datetime	NOT NULL	part group created date	No	No
PartPlg_Modified_By	varchar(30)	NOT NULL	part group modified by	No	No
PartPlg_Modified_Date	datetime	NOT NULL	part group modified date	No	No
Table Name Ppl_PartPlgh_Group_Hist
Table Comment To store the part group history details of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlgH_Price_Factor	numeric	NOT NULL	pricing factor from application table	No	No
PartPlgH_Emb_Factor	numeric	NULL	embodiment factor from application table	No	No
PartPlgH_Condition	varchar(5)	NOT NULL	part condition from application table	No	No
PartPlgH_Part_Grp	varchar(20)	NOT NULL	Part group defined from application table	No	No
PartPlgH_Modified_By	varchar(30)	NOT NULL	modified by from application table	No	No
PartPlgH_Created_By	varchar(30)	NOT NULL	created by from application table	No	No
PartPlgH_Created_Date	datetime	NOT NULL	created date from application table	No	No
PartPlgH_Modified_Date	datetime	NOT NULL	modified date from application table	No	No
PartPlgH_OUInstance	int	NOT NULL	part group instance	Yes	No
PartPlgH_SNO	int	NOT NULL	part group serial no	Yes	No
PartPlhH_OUInstance	int	NOT NULL	part price list instance	Yes	Yes
PartPlgH_RevNo	varchar(40)	NOT NULL	Part price list revision no	Yes	No
Table Name Ppl_PartPlh_Hdr
Table Comment To store the main information of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlh_OUInstance	int	NOT NULL	part price list instance	No	No
PartPlh_PlNo	varchar(40)	NOT NULL	part price list no	No	No
PartPlh_RevNo	varchar(40)	NOT NULL	part price list revision no auto generated for every revision	No	No
PartPlh_Desc	varchar(150)	NOT NULL	part pricelist description	No	No
PartPlh_Part_Sale	varchar(5)	NOT NULL	usage of part price list if of partsale type then 1 else 0	No	No
PartPlh_Service_Sale	varchar(5)	NOT NULL	usage of part price list if of service sale type then 1 else 0	No	No
PartPlh_Category	varchar(40)	NULL	part category for the part price list	No	No
PartPlh_Status	varchar(5)	NOT NULL	part pricelist status	No	No
PartPlh_Eff_Date	datetime	NOT NULL	effectivity date from for the price list no for the revision no mentioned	No	No
PartPlh_Exp_Date	datetime	NULL	effectivity date to for the price list no for the revision no mentioned	No	No
PartPlh_Remarks	varchar(255)	NULL	part price list remarks	No	No
PartPlh_Price_Basis	varchar(5)	NOT NULL	pricing basis for the pricelist . Values can be flat part group part no part type	No	No
PartPlh_Price_Method	varchar(5)	NOT NULL	price method for pricelist values will be factored factored on std price list	No	No
PartPlh_Price_Factor	numeric	NULL	pricing factor for the price list	No	No
PartPlh_Emb_Factor	numeric	NULL	embodiment factor for the pricelist	No	No
PartPlh_Std_PlNo	varchar(40)	NULL	standard pricelist	No	No
PartPlh_Currency	varchar(20)	NOT NULL	currency for the price list no	No	No
PartPlh_Oth_Currency	varchar(5)	NOT NULL	other currency applicability values will be applicable not applicable	No	No
PartPlh_Price_Type	varchar(5)	NOT NULL	Price type for the price list value can be OEM Regular	No	No
PartPlh_OEMID	nvarchar(90)	NULL	if price type is selected as OEM then OEM name should be given Name of OEM	No	No
PartPlh_InActPrevRev	varchar(25)	NULL	previous inactive revision no	No	No
PartPlh_File_Name	varchar(50)	NULL	file name	No	No
PartPlh_Comments	varchar(255)	NULL	pricelist comments	No	No
PartPlh_App_Comments	varchar(255)	NULL	approved comments	No	No
PartPlh_Timestamp	int	NOT NULL	timestamp &nbspused for not allowing more than one user to access the same data	No	No
PartPlh_Approved_By	numeric(13)	NULL	part price list approved by	No	No
PartPlh_Approved_Date	datetime	NULL	part price list approved date	No	No
PartPlh_Confirmed_By	numeric(13)	NULL	part price list confirmed by	No	No
PartPlh_Confirmed_Date	datetime	NULL	part price list confirmed date	No	No
PartPlh_Created_By	numeric(13)	NOT NULL	part price list created by	No	No
PartPlh_Created_Date	datetime	NOT NULL	part price list created date	No	No
PartPlh_Modified_By	numeric(13)	NOT NULL	part price list modified by	No	No
PartPlh_Modified_Date	datetime	NOT NULL	part price list modified date	No	No
Table Name Ppl_PartPlhH_Hdr_Hist
Table Comment To store the main information history of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlhH_OUInstance	int	NOT NULL	instance from application table	Yes	No
PartPlhH_PlNo	varchar(40)	NOT NULL	pricelist no from application table	Yes	No
PartPlhH_RevNo	varchar(40)	NOT NULL	revision no from application table	Yes	No
PartPlhH_Desc	varchar(150)	NOT NULL	pricelist description &nbspfrom application table	No	No
PartPlhH_Part_Sale	varchar(5)	NOT NULL	part sale value from application table	No	No
PartPlhH_Service_Sale	varchar(5)	NOT NULL	service sale from application table	No	No
PartPlhH_Category	varchar(40)	NULL	pricelist category from application table	No	No
PartPlhH_Status	varchar(5)	NOT NULL	price list status from application table	No	No
PartPlhH_Eff_Date	datetime	NOT NULL	effectivity from &nbspdate from application table	No	No
PartPlhH_Exp_Date	datetime	NULL	effectivity to date from application table	No	No
PartPlhH_Remarks	varchar(255)	NULL	remarks from application table	No	No
PartPlhH_Price_Basis	varchar(5)	NOT NULL	price basis from application table	No	No
PartPlhH_Price_Method	varchar(5)	NOT NULL	price method from application table	No	No
PartPlhH_Price_Factor	numeric	NULL	price factor from application table	No	No
PartPlhH_Emb_Factor	numeric	NULL	embodiment factor from application table	No	No
PartPlhH_Std_PlNo	varchar(40)	NULL	standard part price list from application table	No	No
PartPlhH_Currency	varchar(20)	NOT NULL	currency for price list from application table	No	No
PartPlhH_Oth_Currency	varchar(5)	NOT NULL	other currency applicability from application table	No	No
PartPlhH_Price_Type	varchar(5)	NOT NULL	price type from application table	No	No
PartPlhH_OEMID	nvarchar(90)	NULL	oem id from application table	No	No
PartPlhH_InActPrevRev	varchar(25)	NULL	inactive previous revison from application table	No	No
PartPlhH_File_Name	varchar(50)	NULL	file name from application table	No	No
PartPlhH_Comments	varchar(255)	NULL	comments from application table	No	No
PartPlhH_App_Comments	varchar(255)	NULL	approved coments from application table	No	No
PartPlhH_Timestamp	int	NOT NULL	timestamp from application table	No	No
PartPlhH_Approved_By	varchar(30)	NULL	approved by &nbspfrom application table	No	No
PartPlhH_Approved_Date	datetime	NULL	approved date from application table	No	No
PartPlhH_Confirmed_By	varchar(30)	NULL	confirmed by from application table	No	No
PartPlhH_Confirmed_Date	datetime	NULL	confirmed date from application table	No	No
PartPlhH_Created_By	varchar(30)	NOT NULL	created by from application table	No	No
PartPlhH_Created_Date	datetime	NOT NULL	created date from application table	No	No
PartPlhH_Modified_By	varchar(30)	NOT NULL	modified by from application table	No	No
PartPlhH_Modified_Date	datetime	NOT NULL	modified date from application table	No	No
Table Name Ppl_PartPlp_Part
Table Comment To store the part details of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlp_OUInstance	int	NOT NULL	instance	Yes	No
PartPlp_SNo	int	NOT NULL	serial no	Yes	No
PartPlp_PlNo	varchar(40)	NOT NULL	part price list no	Yes	No
PartPlp_RevNo	varchar(40)	NOT NULL	part price list revision no	Yes	No
PartPlp_Part_No	varchar(40)	NOT NULL	part no	No	No
PartPlp_Condition	varchar(5)	NOT NULL	part condition values may be new overhauled servicable unservicable Phased-out	No	No
PartPlp_Min_Qty	numeric	NULL	minimum quantity of part	No	No
PartPlp_Max_Qty	numeric	NULL	maximum quantity	No	No
PartPlp_Uom	varchar(10)	NOT NULL	uom of part	No	No
PartPlp_Unit_Price	numeric	NULL	unit price of part	No	No
PartPlp_Emb_Fee	numeric	NULL	embodiment fee of part	No	No
PartPlp_Price_Factor	numeric	NULL	price factor for the part	No	No
PartPlp_Emb_Factor	numeric	NULL	embodiment factor for part	No	No
PartPlp_Apply_Factor	varchar(5)	NULL	apply factor	No	No
PartPlp_Created_By	varchar(30)	NOT NULL	created by	No	No
PartPlp_Created_Date	datetime	NOT NULL	created date	No	No
PartPlp_Modified_By	varchar(30)	NOT NULL	modified by	No	No
PartPlp_Modified_Date	datetime	NOT NULL	modified date	No	No
Table Name Ppl_PartPlpH_Part_Hist
Table Comment To store the part history of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlhH_OUInstance	int	NOT NULL	instance from application table	Yes	Yes
PartPlpH_OUInstance	int	NOT NULL	instance &nbspfrom application table	Yes	No
PartPlpH_SNo	int	NOT NULL	sno &nbspfrom application table	Yes	No
PartPlhH_PlNo	varchar(40)	NOT NULL	plno &nbspfrom application table	Yes	Yes
PartPlpH_PlNo	varchar(40)	NOT NULL	part price list no &nbspfrom application table	Yes	No
PartPlpH_RevNo	varchar(40)	NOT NULL	revision no from application table	Yes	No
PartPlpH_Part_No	varchar(40)	NOT NULL	part no &nbspfrom application table	No	No
PartPlpH_Condition	varchar(5)	NOT NULL	part condition &nbspfrom application table	No	No
PartPlpH_Min_Qty	numeric	NULL	minimum qty &nbspfrom application table	No	No
PartPlpH_Max_Qty	numeric	NULL	Maximum Quantity	No	No
PartPlpH_Uom	varchar(10)	NOT NULL	uom &nbspfrom application table	No	No
PartPlpH_Unit_Price	numeric	NULL	unit price &nbspfrom application table	No	No
PartPlpH_Emb_Fee	numeric	NULL	embodiment fee &nbspfrom application table	No	No
PartPlpH_Price_Factor	numeric	NULL	price factor &nbspfrom application table	No	No
PartPlpH_Emb_Factor	numeric	NULL	embodiment factor &nbspfrom application table	No	No
PartPlpH_Apply_Factor	varchar(5)	NULL	apply factor &nbspfrom application table	No	No
PartPlpH_Created_By	varchar(30)	NOT NULL	created by &nbspfrom application table	No	No
PartPlpH_Created_Date	datetime	NOT NULL	created date &nbspfrom application tabl	No	No
PartPlpH_Modified_By	varchar(30)	NOT NULL	modified by &nbspfrom application table	No	No
PartPlpH_Modified_Date	datetime	NOT NULL	modified date &nbspfrom application table	No	No
Table Name Ppl_PartPlt_Type
Table Comment To store the part type details of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPlt_OUInstance	int	NOT NULL	instance	Yes	No
PartPlt_PlNo	varchar(40)	NOT NULL	part list no	Yes	No
PartPlt_RevNo	varchar(40)	NOT NULL	revision no	Yes	No
PartPlt_Part_Type	varchar(5)	NOT NULL	type &nbspof part values &nbspwill be consumable kit miscelleneous component raw materials tools	Yes	No
PartPlt_Price_Factor	numeric	NOT NULL	price factor &nbspfor the part	No	No
PartPlt_Emb_Factor	numeric	NULL	embodiment factor for the part	No	No
PartPlt_Created_By	varchar(30)	NOT NULL	created by	No	No
PartPlt_Created_Date	datetime	NOT NULL	created date	No	No
PartPlt_Modified_By	varchar(30)	NOT NULL	modified by	No	No
PartPlt_Modified_Date	datetime	NOT NULL	modified date	No	No
Table Name Ppl_PartPltH_Type_Hist
Table Comment To store the part type history details of part pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PartPltH_OUInstance	int	NOT NULL	instance from application table	Yes	No
PartPltH_PlNo	varchar(5)	NOT NULL	price list no from application table	Yes	No
PartPltH_RevNo	varchar(40)	NOT NULL	revision no from application table	Yes	No
PartPltH_Part_Type	varchar(5)	NOT NULL	part type from application table	Yes	No
PartPltH_Price_Factor	numeric	NOT NULL	price factor from application table	No	No
PartPltH_Emb_Factor	numeric	NULL	embodiment factor from application table	No	No
PartPltH_Created_By	varchar(30)	NOT NULL	created by from application table	No	No
PartPltH_Created_Date	datetime	NOT NULL	created date from application table	No	No
PartPltH_Modified_By	varchar(30)	NOT NULL	modified by from application table	No	No
PartPltH_Modified_Date	datetime	NOT NULL	modified date from application table	No	No