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 serviceable unserviceable |
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 used 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 from 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 date 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 revision 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 comments from application table |
No |
No |
|
PartPlhH_Timestamp |
int |
NOT NULL |
timestamp from application table |
No |
No |
|
PartPlhH_Approved_By |
varchar(30) |
NULL |
approved by from 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 serviceable unserviceable 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 from application table |
Yes |
No |
|
PartPlpH_SNo |
int |
NOT NULL |
sno from application table |
Yes |
No |
|
PartPlhH_PlNo |
varchar(40) |
NOT NULL |
plno from application table |
Yes |
Yes |
|
PartPlpH_PlNo |
varchar(40) |
NOT NULL |
part price list no from 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 from application table |
No |
No |
|
PartPlpH_Condition |
varchar(5) |
NOT NULL |
part condition from application table |
No |
No |
|
PartPlpH_Min_Qty |
numeric |
NULL |
minimum qty from application table |
No |
No |
|
PartPlpH_Max_Qty |
numeric |
NULL |
Maximum Quantity |
No |
No |
|
PartPlpH_Uom |
varchar(10) |
NOT NULL |
uom from application table |
No |
No |
|
PartPlpH_Unit_Price |
numeric |
NULL |
unit price from application table |
No |
No |
|
PartPlpH_Emb_Fee |
numeric |
NULL |
embodiment fee from application table |
No |
No |
|
PartPlpH_Price_Factor |
numeric |
NULL |
price factor from application table |
No |
No |
|
PartPlpH_Emb_Factor |
numeric |
NULL |
embodiment factor from application table |
No |
No |
|
PartPlpH_Apply_Factor |
varchar(5) |
NULL |
apply factor from application table |
No |
No |
|
PartPlpH_Created_By |
varchar(30) |
NOT NULL |
created by from application table |
No |
No |
|
PartPlpH_Created_Date |
datetime |
NOT NULL |
created date from application table |
No |
No |
|
PartPlpH_Modified_By |
varchar(30) |
NOT NULL |
modified by from application table |
No |
No |
|
PartPlpH_Modified_Date |
datetime |
NOT NULL |
modified date from 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 of part values pwill be consumable kit miscellaneous component raw materials tools |
Yes |
No |
|
PartPlt_Price_Factor |
numeric |
NOT NULL |
price factor for 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 |
|
|
|
|
|
|
|