Data Dictionary -- Service Price List 5.5

Srl. No.	Table Name	Comment
1	spl_diff_rates_dtl	differential Rates
2	spl_diff_rates_dtl	differential Rates
3	spl_nbc_non_billable_charges	Service Price List Non Billable Charges
4	spl_nbp_non_billable_parts	Service Price List Non Billable Part Details
5	spl_nbr_non_billable_resource	Service Price List Non Billable Resource details
6	spl_nbt_non_billable_tasks	Service Price List Non Billable Task Details
7	spl_parameter_details	Service Price List Parameter Details
8	spl_pfd_Price_factor_dtls	Service Pricelist Price Factor Details
9	spl_rcd_roster_code_details	Service Price List Roster Code Details
10	spl_rpp_resource_pricing_policy	Service Price List Resource Pricing Details
11	spl_rpp_resource_pricing_policy	resource pricing
12	spl_splh_service_price_list_hdr	Service Price List Information
13	spl_srvcop_options	Service Price List Set Options
14	spl_tac_task_additional_charge	Service Price List Additional Task Level Charges

Table Name :	spl_diff_rates_dtl
Comment :	differential Rates

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
difrt_ouinstance	fin_ctxt_ouinstance	int(4)	No	ou instance	Yes
difrt_pricelistno	fin_documentno	varchar(40)	No	Price list number	Yes
difrt_revno	fin_int	int(4)	No	revision number	Yes
difrt_lineno	fin_int	int(4)	No	line number	Yes
difrt_line_ref_no	fin_int	int(4)	No	reference line number	Yes
difrt_res_no	fin_description	varchar(100)	No	resource number	No
difrt_res_type	fin_description	varchar(100)	No	resource Type	No
difrt_usg_from	fin_int	int(4)	No	Usage From	No
difrt_usg_to	fin_int	int(4)	No	Usage to	No
difrt_slab_type	fin_description	varchar(100)	No	Slab Type	No
difrt_prc_type	fin_description	varchar(100)	No	Pricing Type	No
difrt_Base_rate	fin_amount	numeric(13)	No	Base rate	No
difrt_rate_for	fin_int	int(4)	No	Rate for	No
difrt_rate_uom	fin_description	varchar(100)	No	Uom	No
difrt_prc_notes	fin_notes	varchar(2000)	No	Pricing notes	No
difrt_eff_from	fin_date	datetime(8)	No	Effective From	No
difrt_eff_to	fin_date	datetime(8)	No	Effective to	No

Table Name :	spl_rpp_resource_pricing_policy
Comment :	resource pricing

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rpp_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
rpp_pricelistno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
rpp_revno	fin_int	int(4)	Yes	Service Price List Revision Number	No
rpp_lineno	fin_lineno	int(4)	Yes	Line Number	No
rpp_resource_type	fin_designparamcode	varchar(5)	Yes	Resource Type	No
rpp_resource_no	fin_resourcecode	varchar(40)	Yes	Resource Number	No
rpp_aircraftmodel_no	fin_model	varchar(20)	Yes	Aircraft Model Number	No
rpp_workcenter_no	fin_workunitcode	varchar(30)	Yes	Work Center Number	No
rpp_price_method	fin_designparamcode	varchar(5)	Yes	Pricing Method	No
rpp_rateuom	fin_workunitcode	varchar(30)	Yes	UOM Rate	No
rpp_rate_per_hr_nrm	fin_amount	numeric(13)	Yes	Rate per hour for Normal Timing	No
rpp_rate_per_hr_ot	fin_amount	numeric(13)	Yes	Rate per hour for OT	No
rpp_price_desc	fin_text255	varchar(255)	Yes	Pricing Description	No
rpp_price_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No
rpp_created_by	fin_ctxt_user	varchar(30)	Yes	Created By	No
rpp_created_date	fin_date	datetime(8)	Yes	Creation Date	No
rpp_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified By	No
rpp_modified_date	fin_date	datetime(8)	Yes	Modified Date	No
rpp_effectivefrom	fin_date	datetime(8)	Yes	Effectivity From	No
rpp_effectiveto	fin_date	datetime(8)	Yes	Effectivity To	No
rpp_repaircls	fin_repairclassification	varchar(25)	Yes	Repair Classification	No
rpp_tasktype	fin_types	varchar(30)	Yes	Task Type	No
rpp_exephase	fin_paramcode	varchar(30)	Yes	Execution Phase	No
rpp_factordets	fin_designparamcode	varchar(5)	Yes	factor details	No
rpp_baserate_normal	fin_amount	numeric(13)	Yes	Base Rate Normal	No
rpp_baserate_OT	fin_amount	numeric(13)	Yes	Base Rate Over Time	No
rpp_Pricefactor	fin_amount	numeric(13)	Yes	Price Factor	No
rpp_mrkup_normal	fin_amount	numeric(13)	Yes	MarkUp Normal	No
rpp_mrkup_OT	fin_amount	numeric(13)	Yes	MarkUp Over time	No
rpp_att_type	fin_description	varchar(100)	No	Attenance Type	No
rpp_Rate_for	fin_int	int(4)	No	Rate For	No

Table Name :	spl_diff_rates_dtl
Comment :	differential Rates

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
difrt_ouinstance	fin_ctxt_ouinstance	int(4)	No	ou instance	Yes
difrt_pricelistno	fin_documentno	varchar(40)	No	Price list number	Yes
difrt_revno	fin_int	int(4)	No	revision number	Yes
difrt_lineno	fin_int	int(4)	No	line number	Yes
difrt_line_ref_no	fin_int	int(4)	No	reference line number	Yes
difrt_res_no	fin_description	varchar(100)	No	resource number	No
difrt_res_type	fin_description	varchar(100)	No	resource Type	No
difrt_usg_from	fin_int	int(4)	No	Usage From	No
difrt_usg_to	fin_int	int(4)	No	Usage to	No
difrt_slab_type	fin_description	varchar(100)	No	Slab Type	No
difrt_prc_type	fin_description	varchar(100)	No	Pricing Type	No
difrt_Base_rate	fin_amount	numeric(13)	No	Base rate	No
difrt_rate_for	fin_int	int(4)	No	Rate for	No
difrt_rate_uom	fin_description	varchar(100)	No	Uom	No
difrt_prc_notes	fin_notes	varchar(2000)	No	Pricing notes	No
difrt_eff_from	fin_date	datetime(8)	No	Effective From	No
difrt_eff_to	fin_date	datetime(8)	No	Effective to	No

Table Name :	spl_nbc_non_billable_charges
Comment :	Service Price List Non Billable Charges

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
nbc_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
nbc_pricelistno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
nbc_revno	fin_int	int(4)	Yes	Service Price Revision Number	No
nbc_lineno	fin_lineno	int(4)	Yes	Line Number	No
nbc_charge_code	fin_tcdcodes	varchar(25)	Yes	Charge Code	No
nbc_pricing_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No
nbc_variant_code	fin_tcdcodes	varchar(25)	Yes	Variant Number	No

Table Name :	spl_nbp_non_billable_parts
Comment :	Service Price List Non Billable Part Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
nbp_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
nbp_pricelistno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
nbp_revno	fin_int	int(4)	Yes	Service Price List Revision Number	No
nbp_lineno	fin_lineno	int(4)	Yes	Line Number	No
nbp_partno	fin_partno	varchar(40)	Yes	Part Number	No
nbp_partgrp	fin_partgroup	varchar(40)	Yes	Part Group	No
nbp_parttype	fin_types	varchar(30)	Yes	Part Type	No
nbp_pricing_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No
nbp_mfg_part_no	fin_partno	varchar(40)	Yes	Manufacture Part Number	No
nbp_description	fin_description	varchar(100)	Yes	Billable Description	No
nbp_mfg_no	fin_partno	varchar(40)	Yes	Manufacture Number	No

Table Name :	spl_nbr_non_billable_resource
Comment :	Service Price List Non Billable Resource details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
nbr_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
nbr_pricelistno	fin_documentno	varchar(40)	Yes	Price List Number	No
nbr_revno	fin_int	int(4)	Yes	Price List Revision Number	No
nbr_lineno	fin_lineno	int(4)	Yes	Line Number	No
nbr_resource_type	fin_designparamcode	varchar(5)	Yes	Resource Type	No
nbr_resource	fin_resourcecode	varchar(40)	Yes	Resource Number	No
nbr_pricing_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No
nbr_AircraftModelNo	fin_aircraftmodel	varchar(20)	Yes	Aircraft Model Number	No
nbr_WorkcenterNo	fin_workcenter	varchar(80)	Yes	Work Center Number	No

Table Name :	spl_nbt_non_billable_tasks
Comment :	Service Price List Non Billable Task Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
nbt_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
nbt_pricelistno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
nbt_revno	fin_int	int(4)	Yes	Service Price List Revision Number	No
nbt_lineno	fin_lineno	int(4)	Yes	Line Number	No
nbt_taskno	fin_workunitcode	varchar(30)	Yes	Task Number	No
nbt_rel_tasks	fin_designparamcode	varchar(5)	Yes	Relative Task Number	No
nbt_exe_category	fin_flag	varchar(25)	Yes	Execution Category	No
nbt_task_type	fin_flag	varchar(25)	Yes	Task Type	No
nbt_repair_classification	fin_flag	varchar(25)	Yes	Repair Classification	No
nbt_pricing_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No

Table Name :	spl_parameter_details
Comment :	Service Price List Parameter Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ComponentName	udd_ctxt_component	varchar(20)	No	Component Name	No
ParamCategory	udd_paramcategory	varchar(10)	No	Parameter Category	No
ParamType	udd_paramtype	varchar(25)	No	Parameter Type	No
ParamCode	udd_designparamcode	varchar(5)	No	Parameter Code	No
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 :	spl_pfd_Price_factor_dtls
Comment :	Service Pricelist Price Factor Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
pfd_ouinstance	fin_ctxt_ouinstance	int(4)	No	Ouinstance ID	Yes
pfd_pricelistno	fin_documentno	varchar(40)	No	Service Price List Number	Yes
pfd_revno	fin_int	int(4)	No	Service Price List revision #	Yes
pfd_lineno	fin_lineno	int(4)	No	Line Number	Yes
pfd_res_type	fin_designparamcode	varchar(5)	No	Resource Type	Yes
pfd_line_dtls	fin_notes	varchar(2000)	Yes	Line details	No
pfd_factor_type	fin_designparamcode	varchar(5)	Yes	Factor Type	No
pfd_factor_Value	fin_amount	numeric(13)	Yes	Factor Value	No
pfd_applied_on	fin_designparamcode	varchar(5)	Yes	Appiled On	No
pfd_eff_price_factor	fin_amount	numeric(13)	Yes	Effective Price Factor	No
pfd_level_flg	fin_flag	varchar(25)	Yes	Level Flag	No
pfd_rrp_lineno	fin_lineno	int(4)	Yes	Resouce Line No	No

Table Name :	spl_rcd_roster_code_details
Comment :	Service Price List Roster Code Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rcd_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
rcd_plno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
rcd_revno	fin_int	int(4)	Yes	Service Price List Revision Number	No
rcd_lineno	fin_lineno	int(4)	Yes	Line Number	No
rcd_roster_code	fin_quickcodes	varchar(25)	Yes	Roster Code Factor	No
rcd_element	fin_designparamcode	varchar(5)	Yes	Roster Element	No
rcd_fromtime	fin_time	datetime(8)	Yes	From Time	No
rcd_totime	fin_time	datetime(8)	Yes	To Time	No
rcd_factor	fin_amount	numeric(13)	Yes	Factor	No
rcd_remarks	fin_text255	varchar(255)	Yes	Remarks	No
rcd_tottime	fin_amount	numeric(13)	Yes	Roster To Time	No
rcd_created_by	fin_ctxt_user	varchar(30)	Yes	Created By	No
rcd_created_date	fin_date	datetime(8)	Yes	Creation Date	No
rcd_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified By	No
rcd_modified_date	fin_date	datetime(8)	Yes	Modified Date	No
rcd_day	fin_designparamcode	varchar(5)	Yes	Days	No
rcd_roster_basis	fin_flag2	varchar(25)	Yes	Roster Basis	No

Table Name :	spl_rpp_resource_pricing_policy
Comment :	Service Price List Resource Pricing Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rpp_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
rpp_pricelistno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
rpp_revno	fin_int	int(4)	Yes	Service Price List Revision Number	No
rpp_lineno	fin_lineno	int(4)	Yes	Line Number	No
rpp_resource_type	fin_designparamcode	varchar(5)	Yes	Resource Type	No
rpp_resource_no	fin_resourcecode	varchar(40)	Yes	Resource Number	No
rpp_aircraftmodel_no	fin_model	varchar(20)	Yes	Aircraft Model Number	No
rpp_workcenter_no	fin_workunitcode	varchar(30)	Yes	Work Center Number	No
rpp_price_method	fin_designparamcode	varchar(5)	Yes	Pricing Method	No
rpp_rateuom	fin_workunitcode	varchar(30)	Yes	UOM Rate	No
rpp_rate_per_hr_nrm	fin_amount	numeric(13)	Yes	Rate per hour for Normal Timing	No
rpp_rate_per_hr_ot	fin_amount	numeric(13)	Yes	Rate per hour for OT	No
rpp_price_desc	fin_text255	varchar(255)	Yes	Pricing Description	No
rpp_price_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No
rpp_created_by	fin_ctxt_user	varchar(30)	Yes	Created By	No
rpp_created_date	fin_date	datetime(8)	Yes	Creation Date	No
rpp_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified By	No
rpp_modified_date	fin_date	datetime(8)	Yes	Modified Date	No
rpp_effectivefrom	fin_date	datetime(8)	Yes	Effectivity From	No
rpp_effectiveto	fin_date	datetime(8)	Yes	Effectivity To	No
rpp_repaircls	fin_repairclassification	varchar(25)	Yes	Repair Classification	No
rpp_tasktype	fin_types	varchar(30)	Yes	Task Type	No
rpp_exephase	fin_paramcode	varchar(30)	Yes	Execution Phase	No
rpp_factordets	fin_designparamcode	varchar(5)	Yes	factor details	No
rpp_baserate_normal	fin_amount	numeric(13)	Yes	Base Rate Normal	No
rpp_baserate_OT	fin_amount	numeric(13)	Yes	Base Rate Over Time	No
rpp_Pricefactor	fin_amount	numeric(13)	Yes	Price Factor	No
rpp_mrkup_normal	fin_amount	numeric(13)	Yes	MarkUp Normal	No
rpp_mrkup_OT	fin_amount	numeric(13)	Yes	MarkUp Over time	No
rpp_att_type	fin_description	varchar(100)	No	Attenance Type	No
rpp_Rate_for	fin_int	int(4)	No	Rate For	No

Table Name :	spl_splh_service_price_list_hdr
Comment :	Service Price List Information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
splh_ouinstance	fin_ctxt_ouinstance	int(4)	No	Ouinstance ID	Yes
splh_pricelistno	fin_documentno	varchar(40)	No	Service Price List Number	Yes
splh_revno	fin_int	int(4)	No	Service Price List Revision Number	Yes
splh_effective_from	fin_date	datetime(8)	Yes	Effectivity From	No
splh_effective_to	fin_date	datetime(8)	Yes	Effectivity To	No
splh_ext_effective_from	fin_date	datetime(8)	Yes	Ext Effectivity From	No
splh_description	fin_text255	varchar(255)	Yes	Days	No
splh_status	fin_designparamcode	varchar(5)	Yes	Status	No
splh_category	fin_hrquickcodedes	varchar(40)	Yes	Category	No
splh_currency	fin_currency	varchar(5)	Yes	Currency Code	No
splh_oth_currency	fin_currency	varchar(5)	Yes	Other Currency Code	No
splh_remarks	fin_text255	varchar(255)	Yes	Remarks	No
splh_part_pricelist	fin_documentno	varchar(40)	Yes	Part Price List Number	No
splh_part_pricelist_revno	fin_int	int(4)	Yes	Part Pricing List Revision Number	No
splh_price_basis	fin_designparamcode	varchar(5)	Yes	Pricing Basis	No
splh_price_appliedon	fin_designparamcode	varchar(5)	Yes	Price Applied On	No
splh_price_factor	fin_factor	numeric(13)	Yes	Pricing Factor	No
splh_time_stamp	fin_timestamp	int(4)	Yes	Timestamp	No
splh_created_by	fin_ctxt_user	varchar(30)	Yes	Created By	No
splh_created_date	fin_date	datetime(8)	Yes	Creation Date	No
splh_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified By	No
splh_modified_date	fin_date	datetime(8)	Yes	Modified Date	No
splh_confirmed_by	fin_ctxt_user	varchar(30)	Yes	Confirmed By	No
splh_confirmed_date	fin_date	datetime(8)	Yes	Confirmed Date	No
splh_activated_by	fin_ctxt_user	varchar(30)	Yes	Activated By	No
splh_activated_date	fin_date	datetime(8)	Yes	Activated Date	No
splh_comments	fin_text255	varchar(255)	Yes	Comments	No
splh_Act_Inact_Flag	fin_guid	varchar(40)	Yes	Activate / Inactive Flag	No
splh_PF_facdtls	fin_designparamcode	varchar(5)	Yes	Price Factor Details	No
splh_PF_facdtls_at	fin_designparamcode	varchar(5)	Yes	Factor Details at	No

Table Name :	spl_srvcop_options
Comment :	Service Price List Set Options

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
srvcop_OUInstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance ID	No
srvcop_Activation	udd_designparamcode	varchar(5)	No	Activation of Service Price list Required or Not	No
SRVCOP_BASE_PRTLIST	udd_documentno	varchar(40)	Yes	Base Price List Number	No
srvcop_Timestamp	udd_timestamp	int(4)	No	Timestamp	No
srvcop_Created_By	udd_ctxt_user	varchar(30)	No	Created By	No
srvcop_Created_Date	_datetime_8	datetime(8)	No	Creation Date	No
srvcop_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
srvcop_Modified_Date	_datetime_8	datetime(8)	Yes	Modified Date	No
srvcop_stksts_req	udd_designparamcode	varchar(5)	Yes	Stock Status Request	No

Table Name :	spl_tac_task_additional_charge
Comment :	Service Price List Additional Task Level Charges

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tac_ouinstance	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
tac_pricelistno	fin_documentno	varchar(40)	Yes	Service Price List Number	No
tac_revno	fin_int	int(4)	Yes	Service Price List Revision Number	No
tac_lineno	fin_lineno	int(4)	Yes	Line Number	No
tac_task_no	fin_taskcode	varchar(30)	Yes	Task Number	No
tac_charge_code	fin_tcdcodes	varchar(25)	Yes	Charge Code	No
tac_variant_no	fin_taskcode	varchar(30)	Yes	Variant Number	No
tac_price_basis	fin_designparamcode	varchar(5)	Yes	Pricing Basis	No
tac_price	fin_amount	numeric(13)	Yes	Price	No
tac_price_factor	fin_amount	numeric(13)	Yes	Pricing Factor	No
tac_price_desc	fin_text255	varchar(255)	Yes	Pricing Description	No
tac_price_notes	fin_notes	varchar(2000)	Yes	Pricing Notes	No
tac_created_by	fin_ctxt_user	varchar(30)	Yes	Created By	No
tac_created_date	fin_date	datetime(8)	Yes	Creation Date	No
tac_modified_by	fin_ctxt_user	varchar(30)	Yes	Modified By	No
tac_modified_date	fin_date	datetime(8)	Yes	Modified Date	No
tac_effectivefrom	fin_date	datetime(8)	Yes	Effective From	No
tac_effectiveto	fin_date	datetime(8)	Yes	Effective To	No