Database Schema for

Data Dictionary -- Part Price List 5.5

Srl. No.	Table Name	Comment
1	ppl_Direct_pricing_dtl	Part Price List Direct Pricing for Parts
2	ppl_factored_pricing_dtl	Part Price List Factored Pricing for Parts
3	Ppl_Maxpr_dtl	Part Price List Maximum Price Details
4	Ppl_Parameter_Details	Part Price List - Metadata Table
5	Ppl_Partop_Options	Part Price List Set Option for Part Price List
6	ppl_pricelist_hdr	Part Price List Header Information
7	ppl_profile_dtl	Part Price List Profile details
8	ppl_ref_priority	Part Price List Reference Part Price list details


Table Name :	ppl_Direct_pricing_dtl
Comment :	Part Price List Direct Pricing for Parts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Dir_ppl_no	fin_documentno	varchar(40)	Yes	Part Price List Number	No
Dir_revision	fin_int	int(4)	Yes	Part Price List Revision Number	No
Dir_ou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
Dir_line_no	fin_int	int(4)	Yes	Line Number	No
Dir_element	fin_designparamcode	varchar(5)	Yes	Part Price Element	No
Dir_partno	fin_partno	varchar(40)	Yes	Part Number	No
Dir_mfg_part_no	fin_partno	varchar(40)	Yes	Manufacture Part Number	No
Dir_mfg_no	fin_itemflowbom	varchar(45)	Yes	Manufacture Number	No
Dir_part_cond	fin_designparamcode	varchar(5)	Yes	Part Condition	No
Dir_part_status	fin_partno	varchar(40)	Yes	Part Status	No
Dir_price	fin_amount	numeric(13)	Yes	Part Price	No
Dir_notes	fin_text255	varchar(255)	Yes	Part Price Notes	No
Dir_Vendor	fin_flag50	varchar(50)	Yes	Supplier Code	No
Dir_Uom	fin_uomcode	varchar(10)	Yes	Unit of Measurement	No
Dir_EffectiveFrom	fin_date	datetime(8)	Yes	Effectivity From	No
Dir_EffectiveTo	fin_date	datetime(8)	Yes	Effectivity To	No
Dir_currency	fin_currency	varchar(5)	Yes	Currency Code	No


Table Name :	ppl_factored_pricing_dtl
Comment :	Part Price List Factored Pricing for Parts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fac_ppl_no	fin_documentno	varchar(40)	Yes	Part Price List Number	No
fac_revision	fin_int	int(4)	Yes	Part Price List Revision Number	No
fac_ou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
fac_line_no	fin_int	int(4)	Yes	Line Number	No
fac_proc_seq	fin_int	int(4)	Yes	Factor Process Sequence Number	No
fac_element	fin_designparamcode	varchar(5)	Yes	Factored Element	No
fac_llp	fin_designparamcode	varchar(5)	Yes	LLP Part Applicability?	No
fac_Rep_typ	fin_designparamcode	varchar(5)	Yes	Replacement Type	No
fac_part_type	fin_designparamcode	varchar(5)	Yes	Part Type	No
fac_part_group	fin_partno	varchar(40)	Yes	Factor Part Group	No
fac_part_class	fin_designparamcode	varchar(5)	Yes	Part Class	No
fac_part_cond	fin_designparamcode	varchar(5)	Yes	Part Condition	No
fac_part_status	fin_partno	varchar(40)	Yes	Part Status	No
fac_prorated	fin_designparamcode	varchar(5)	Yes	Factored Prorated?	No
fac_factored_on	fin_designparamcode	varchar(5)	Yes	Factored On	No
fac_basadj_fac	fin_amount	numeric(13)	Yes	Base Adjustment Factor	No
fac_price_fac	fin_amount	numeric(13)	Yes	Pricing Factor	No
fac_Pricefac_on	fin_designparamcode	varchar(5)	Yes	Price Factor On	No
fac_effect_fac	fin_amount	numeric(13)	Yes	Effectivity Factor	No
fac_Price_desc	fin_text255	varchar(255)	Yes	Factor Pricing Description	No
fac_notes	fin_text255	varchar(255)	Yes	Factor Notes	No
fac_Ref_Catalogue_Id	fin_designparamcode	varchar(5)	Yes	Reference Pricing Catalogue ID	No
fac_MulPrc	fin_designparamcode	varchar(5)	Yes	Factored Multi Price factor applicable	No


Table Name :	Ppl_Maxpr_dtl
Comment :	Part Price List Maximum Price Details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Mxpr_ppl_no	fin_documentno	varchar(40)	No	Max. Price Part Price List Number	Yes
Mxpr_rev_no	fin_rev_no	Int(4)	No	Max. Price Revision Number	Yes
Mxpr_ou	fin_int	int(4)	No	Ouinstance ID	Yes
Mxpr_line_no	fin_lineno	Int(4)	No	Max. Price Line Number	Yes
Mxprc_fac_line_no	fin_lineno	Int(4)	No	Max. Price Factor Line Number	No
Mxpr_pric_elemt	fin_designparamcode	varchar(5)	No	Max. Price Pricing Number	No
Mxprc_refpplno	fin_documentno	varchar(40)	No	Max. Price Reference Part Price List Number	No
Mxprc_prfac	fin_amount	numeric(13)	No	Max. Price Pricing Factor	No
mxprc_effect_fac	fin_amount	numeric(13)	No	Max. Price Effectivity Number	No
Mxprc_ref_catlog	fin_description	Char(100)	No	Max. Price Refrence Catalogue	No
Mxprc_lndtl	fin_comments	varchar(256)	No	Max. Price Line Detail	No


Table Name :	Ppl_Parameter_Details
Comment :	Part Price List - Metadata Table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ComponentName	udd_ctxt_component	varchar(20)	No	Component Name	Yes
ParamCategory	udd_paramcategory	varchar(10)	No	Parameter Category	Yes
ParamType	udd_paramtype	varchar(25)	No	Parameter Type	Yes
ParamCode	udd_designparamcode	varchar(5)	No	Parameter Code	Yes
ParamDesc	udd_gtext	varchar(80)	No	Parameter Description	No
Langid	udd_ctxt_language	int(4)	No	Language ID	No
Sortby	udd_count	int(4)	No	Sort Order By	No
CreationDate	_datetime_8	datetime(8)	No	Creation Date	No


Table Name :	Ppl_Partop_Options
Comment :	Part Price List Set Option for Part Price List


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Partop_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance ID	Yes
Partop_Approval	udd_designparamcode	varchar(5)	No	Activation of Service Price list Required or Not	No
Partop_Timestamp	udd_timestamp	int(4)	No	Timestamp	No
Partop_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
Partop_Created_Date	_datetime_8	datetime(8)	No	Creation Date	No
Partop_BasPlNo	UDD_DocumentNo2	Varchar(80)	Yes	Base Part Price List Number	No
Partop_Modified_By	udd_ctxt_user	varchar(30)	No	Modified By	No
Partop_Modified_Date	_datetime_8	datetime(8)	No	Modified Date	No
Partop_Rest_Rev	fin_designparamcode	varchar(5)	Yes	Part Price list Set Option Revision Number	No


Table Name :	ppl_pricelist_hdr
Comment :	Part Price List Header Information


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ppl_no	fin_documentno	varchar(40)	No	Part Price List Number	Yes
ppl_revision	fin_int	int(4)	No	Part Price List Revision Number	Yes
ppl_ou	fin_ctxt_ouinstance	int(4)	No	Ouinstance ID	Yes
ppl_status	fin_designparamcode	varchar(5)	Yes	Part Price List Status	No
ppl_effect_from	fin_date	datetime(8)	Yes	Part Price List Effectivity From	No
ppl_effect_to	fin_date	datetime(8)	Yes	Part Price Lice Effectivity To	No
ppl_usg_partsale	fin_int	int(4)	Yes	Part Sale Yes/No	No
ppl_usg_servicesale	fin_int	int(4)	Yes	Service Sales Yes/No	No
ppl_desc	fin_text255	varchar(255)	Yes	Part Price List Description	No
ppl_category	fin_quickcode	varchar(20)	Yes	Part Price List Category	No
ppl_type	fin_designparamcode	varchar(5)	Yes	Part Price List Type	No
oem_no	fin_text255	varchar(255)	Yes	OEM Price List Number	No
ppl_currency	fin_currency	varchar(5)	Yes	Part Price List Currency Code	No
ppl_other_cur_appl	fin_designparamcode	varchar(5)	Yes	Other Currency Applicability ?	No
ppl_direct_pricing	fin_designparamcode	varchar(5)	Yes	Type of Pricing Definition ( Factor , Direct, Factor and Direct(	No
ppl_pric_criteria	fin_flag	varchar(25)	Yes	Pricing Criteria	No
ppl_mult_crit_mat	fin_flag	varchar(25)	Yes	Multiple Criteria Match	No
ppl_remarks	fin_text255	varchar(255)	Yes	Remarks	No
ppl_comm	fin_text255	varchar(255)	Yes	Comments	No
ppl_created_by	fin_ctxt_user	varchar(30)	Yes	Created By	No
ppl_created_date	fin_date	datetime(8)	Yes	Creation Date	No
ppl_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified By	No
ppl_modified_date	fin_date	datetime(8)	Yes	Modified Date	No
ppl_confirmed_by	fin_ctxt_user	varchar(30)	Yes	Confirmed By	No
ppl_confirmed_date	fin_date	datetime(8)	Yes	Confirmed Date	No
ppl_Activated_by	fin_ctxt_user	varchar(30)	Yes	Activated By	No
ppl_Activated_date	fin_date	datetime(8)	Yes	Activated Date	No
ppl_timestamp	fin_int	int(4)	Yes	Timestamp	No
ppl_guid	fin_guid	varchar(40)	Yes	Guid	No
ppl_act_inact_flag	fin_guid	varchar(40)	Yes	Part Price List Active/Inactive Flag	No
ppl_Ref_Catalogue_Id	fin_designparamcode	varchar(5)	Yes	Part Price List Reference Catalogue ID	No
ppl_Rule_Sp	fin_txt255	varchar(255)	Yes	Part Price List Rule SP Name	No
ppl_Primary_catalogue	fin_designparamcode	varchar(5)	Yes	Primary Catalogue for Pricing	No
ppl_Maxprc_crit	fin_designparamcode	varchar(5)	Yes	Maximum Price Criteria	No


Table Name :	ppl_profile_dtl
Comment :	Part Price List Profile details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
prof_ppl_no	fin_documentno	varchar(40)	Yes	Part Price List Number	No
prof_revision	fin_int	int(4)	Yes	Part Price List Revision Number	No
prof_ou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
prof_Pricing_element	fin_designparamcode	varchar(5)	Yes	Pricing Element	No
prof_attr_type	fin_designparamcode	varchar(5)	Yes	Part Price List Attribute Type	No
prof_cat	fin_designparamcode	varchar(5)	Yes	Part Price List Category	No
prof_appl	fin_designparamcode	varchar(5)	Yes	Applicability Flag?	No


Table Name :	ppl_ref_priority
Comment :	Part Price List Reference Part Price list details


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Ref_ppl_no	fin_documentno	varchar(40)	Yes	Reference Part Price List Number	No
Ref_revision	fin_int	int(4)	Yes	Reference Part Price List Revision Number	No
Ref_ou	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
Ref_line_no	fin_int	int(4)	Yes	Line Number	No
Ref_Prim_Cat	fin_designparamcode	varchar(5)	Yes	Reference Primary Category	No
Ref_Alt_Cat	fin_designparamcode	varchar(5)	Yes	Reference Alternate Category	No
Ref_priority	fin_int	int(4)	Yes	Reference Pricelist Priority	No