Data Dictionary - Service Price List
Table Name spl_moef_model_effect
Table Comment To store the modal effectivity details of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
moef_ouinstance	int	NOT NULL	Ouinstance	Yes	No
moef_plno	varchar(40)	NOT NULL	model service price list	Yes	No
moef_revno	varchar(40)	NOT NULL	model service price list revision no	Yes	No
moef_lineno	int	NOT NULL	line no	Yes	No
moef_model_no	varchar(20)	NOT NULL	Model no	No	No
moef_model_ou	int	NOT NULL	Model Ouinstance	No	No
moef_created_by	varchar(30)	NOT NULL	Created by	No	No
moef_created_date	datetime	NOT NULL	created date	No	No
moef_modified_by	varchar(30)	NULL	Modified By	No	No
moef_modified_date	datetime	NULL	Modified Date	No	No
Table Name spl_moefH_model_effect_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
moefH_ouinstance	int	NOT NULL	instance &nbspfrom Application Table	Yes	No
moefH_plno	varchar(40)	NOT NULL	pricelist  &nbspfrom Application Table	Yes	No
moefH_revno	varchar(40)	NOT NULL	revision no &nbspfrom Application Table	Yes	No
moefH_lineno	int	NOT NULL	line no &nbspfrom Application Table	Yes	No
moefH_model_no	varchar(20)	NOT NULL	model no &nbspfrom Application Table	No	No
moefH_model_ou	int	NOT NULL	model instance &nbspfrom Application Table	No	No
moefH_created_by	varchar(30)	NOT NULL	created by &nbspfrom Application Table	No	No
moefH_created_date	datetime	NOT NULL	created date &nbspfrom Application Table	No	No
moefH_modified_by	varchar(30)	NULL	modified by &nbspfrom Application Table	No	No
moefH_modified_date	datetime	NULL	modified date &nbspfrom Application Table	No	No
Table Name spl_nbs_nbill_service
Table Comment To store the non billable service details of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
nbs_ouinstance	int	NOT NULL	instance	Yes	No
nbs_plno	varchar(40)	NOT NULL	service pricelist no	Yes	No
nbs_revno	varchar(40)	NOT NULL	service pricelist revision no	Yes	No
nbs_lineno	int	NOT NULL	line no for multi line reference	Yes	No
nbs_wkunit_ou	int	NOT NULL	workunit instance	No	No
nbs_wkunit_type	varchar(5)	NOT NULL	workunit type will be task standard procedure Aircraft work package component work Package Maint change request	No	No
nbs_wkunit_no	varchar(30)	NOT NULL	work unit no	No	No
nbs_auth_units	varchar(255)	NOT NULL	authorizing organisation unit	No	No
nbs_created_by	varchar(30)	NOT NULL	created by	No	No
nbs_created_date	datetime	NOT NULL	created date	No	No
nbs_modified_by	varchar(30)	NULL	modified by	No	No
nbs_modified_date	datetime	NULL	modified date	No	No
Table Name spl_nbsH_nbill_service_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
nbsH_ouinstance_	int	NULL	instance from application Table	No	No
nbsH_plno	varchar(40)	NULL	service price list from Application table	No	No
nbsH_revno	varchar(40)	NULL	revision no of service pricelist from application table	No	No
nbsH_lineno	int	NULL	line no from application table for multi line reference	No	No
nbsH_wkunit_ou	int	NULL	work unit instance from application table	No	No
nbsH_wkunit_type	varchar(5)	NULL	work unit type from application table	No	No
nbsH_wkunit_no	varchar(30)	NULL	wkunit_no from application table	No	No
nbsH_auth_units	varchar(255)	NULL	authorizing organization from application table	No	No
nbsH_created_by	varchar(30)	NULL	created by from application table	No	No
nbsH_created_date	datetime	NULL	created date from application table	No	No
nbsH_modified_by	int	NULL	Modified by from application table	No	No
nbsH_modified_date	datetime	NULL	Modified date from application table	No	No
Table Name spl_parameter_details
Table Comment To store the parameter details of service 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	No	No
ParamCategory	varchar(10)	NOT NULL	Parameter Category	No	No
ParamType	varchar(25)	NOT NULL	Parameter Type	No	No
ParamCode	varchar(5)	NOT NULL	Parameter code	No	No
ParamDesc	varchar(80)	NOT NULL	Parameter Description	No	No
Langid	int	NOT NULL	Language ID	No	No
Sortby	int	NOT NULL	used to sort the values . Numeric Value	No	No
CreationDate	datetime	NOT NULL	Created Date	No	No
Table Name spl_pref_part_effect
Table Comment To store the part effectivity details of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
pref_ouinstance	int	NOT NULL	ounistance	Yes	No
pref_plno	varchar(40)	NOT NULL	price list no	Yes	No
pref_revno	varchar(40)	NOT NULL	revision no	Yes	No
pref_lineno	int	NOT NULL	line no	Yes	No
srmpl_ouinstance	int	NULL	ounistance	No	Yes
pref_part_no	varchar(40)	NOT NULL	part no	No	No
pref_part_ou	int	NOT NULL	part created ou	No	No
pref_created_by	varchar(30)	NOT NULL	created by	No	No
pref_created_date	datetime	NOT NULL	created date	No	No
pref_modified_by	varchar(30)	NULL	modified by	No	No
pref_modified_date	datetime	NULL	modified date	No	No
Table Name spl_prefH_part_effect_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prefH_ouinstance	int	NOT NULL	instance	Yes	No
prefH_plno	varchar(40)	NOT NULL	price list no	Yes	No
prefH_revno	varchar(40)	NOT NULL	service price list revision no	Yes	No
prefH_lineno	int	NOT NULL	line no	Yes	No
prefH_part_no	varchar(40)	NOT NULL	part no	No	No
prefH_part_ou	int	NOT NULL	Part created ou	No	No
prefH_created_by	varchar(30)	NOT NULL	created by	No	No
prefH_created_date	datetime	NOT NULL	created date	No	No
prefH_modified_by	varchar(30)	NULL	Modified by	No	No
prefH_modified_date	datetime	NULL	Modified Date	No	No
Table Name spl_rcd_details
Table Comment Table stores the resource cost &nbspbreak up &nbspdepending on the time interval and the factor mentioned
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rcd_ouinstance	int	NOT NULL	To store current processing instance	Yes	No
rcd_plno	varchar(40)	NOT NULL	Service pricelist no to which the corresponding RCD details were stored	Yes	No
rcd_revno	varchar(40)	NOT NULL	for the mentioned servicepricelist’s revision no	Yes	No
rcd_lineno	int	NOT NULL	Unique field for line no to store Multiple RCD details for a service pricelist # , revision no combination	Yes	No
rcd_roster_code	varchar(25)	NULL	Quick code to store the roster code information	No	No
rcd_element	varchar(40)	NULL	For storing element information for the roster code defined	No	No
rcd_fromtime	varchar(15)	NULL	the starting time for the interval specification	No	No
rcd_totime	varchar(15)	NULL	To time	No	No
rcd_factor	numeric	NULL	Factor for the interval specified for the particular rcd and element combination	No	No
rcd_created_by	varchar(30)	NULL	created user id	No	No
rcd_created_date	datetime	NULL	created time	No	No
rcd_modified_by	varchar(30)	NULL	Modified user id	No	No
rcd_modified_date	datetime	NULL	Modified time	No	No
rcd_remarks	varchar(255)	NULL	Remarks for the rcd entry	No	No
rcd_day	varchar(5)	NULL	flag value to store whether the interval mentioned is full day or not	No	No
Table Name spl_rcdh_details_his
Table Comment History table for spl_rcd_details for movement of data during revising and activating the service pricelist no
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
rcdh_ouinstance	int	NOT NULL	processing instance	Yes	No
rcdh_plno	varchar(40)	NOT NULL	service pricelist no	Yes	No
rcdh_revno	varchar(40)	NOT NULL	revision no for the mentioned service pricelist no	Yes	No
rcdh_lineno	int	NOT NULL	unique field to have multiple RCD entries for the service pricelist# and revision no	Yes	No
rcdh_roster_code	varchar(25)	NOT NULL	Roster code for the service pricelist	No	No
rcdh_element	varchar(40)	NULL	Element defined for the roster code	No	No
rcdh_fromtime	varchar(15)	NULL	interval starting time	No	No
rcdh_totime	varchar(15)	NULL	interval ending time	No	No
rcdh_factor	numeric	NULL	factor defined for the interval	No	No
rcdh_created_by	varchar(30)	NULL	created user name	No	No
rcdh_created_date	datetime	NULL	created date	No	No
rcdh_modified_by	varchar(30)	NULL	modified user name	No	No
rcdh_modified_date	datetime	NULL	modified date	No	No
rcdh_remarks	varchar(255)	NULL	remarks given	No	No
rcdh_day	varchar(5)	NULL	flag value to store whether the interval mentioned is full day or not	No	No
Table Name spl_ropr_ro_price
Table Comment To store the repair pricing details of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ropr_mtrl_cost	numeric	NOT NULL	flat material cost for the repair	No	No
ropr_res_cost	numeric	NOT NULL	flat resource price rate /hr	No	No
ropr_rep_code	varchar(25)	NOT NULL	Repair process code Process codes from Logistics common master which are in active status	No	No
ropr_part_ou	int	NOT NULL	part created &nbspinstance	No	No
ropr_modified_by	varchar(30)	NULL	modified by	No	No
ropr_misc_cost	numeric	NOT NULL	miscellaneous cost	No	No
ropr_created_date	datetime	NOT NULL	created date	No	No
ropr_created_by	varchar(30)	NOT NULL	created by	No	No
ropr_modified_date	datetime	NULL	modified date	No	No
ropr_plno	varchar(40)	NOT NULL	service pricelist no	Yes	No
ropr_revno	varchar(4)	NOT NULL	service price list revision no	Yes	No
ropr_ouinstance	int	NOT NULL	instance	Yes	No
ropr_part_no	varchar(40)	NOT NULL	part no	No	No
ropr_lineno	int	NOT NULL	line no for multi line reference	Yes	No
Table Name spl_roprH_ro_price_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
roprH_ouinstance	int	NOT NULL	instance from Application Table	Yes	No
roprH_plno	varchar(40)	NOT NULL	pricelist no &nbspfrom Application Table	Yes	No
roprH_revno	varchar(40)	NOT NULL	revison no &nbspfrom Application Table	Yes	No
roprH_lineno	int	NOT NULL	line no &nbspfrom Application Table	Yes	No
roprH_part_no	varchar(40)	NOT NULL	part no &nbspfrom Application Table	No	No
roprH_part_ou	int	NOT NULL	part created instance &nbspfrom Application Table	No	No
roprH_rep_code	varchar(25)	NOT NULL	rep code &nbspfrom Application Table	No	No
roprH_mtrl_cost	numeric	NOT NULL	material cost &nbspfrom Application Table	No	No
roprH_res_cost	numeric	NOT NULL	resource cost &nbspfrom Application Table	No	No
roprH_misc_cost	numeric	NOT NULL	miscelaneous cost &nbspfrom Application Table	No	No
roprH_created_by	varchar(30)	NOT NULL	created by &nbspfrom Application Table	No	No
roprH_created_date	datetime	NOT NULL	created date &nbspfrom Application Table	No	No
roprH_modified_by	varchar(30)	NULL	modified by &nbspfrom Application Table	No	No
roprH_modified_date	datetime	NULL	modified date &nbspfrom Application Table	No	No
Table Name spl_srmpl_mtrl_policy
Table Comment To store the pricing policy for materials of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
srmpl_price_method	varchar(5)	NOT NULL	pricing method for the material can be direct workunitwise flat OEM price list customer wise pricelist	No	No
srmpl_part_plist	varchar(40)	NULL	part price list for the material	No	No
SRMPL_PRICING_FACTOR	numeric	NULL	pricing factor for the material	No	No
SRMPL_PART_CONDITION	varchar(25)	NULL	part condition of the material can be new servicable overhauled	No	No
srmpl_modified_by	varchar(30)	NULL	modified by	No	No
srmpl_part_plist_ou	int	NULL	part price list &nbspinstance	No	No
srmpl_created_date	datetime	NOT NULL	created date	No	No
srmpl_created_by	varchar(30)	NOT NULL	created by	No	No
srmpl_modified_date	datetime	NULL	modified date	No	No
srmpl_plno	varchar(40)	NOT NULL	service pricelist no	Yes	No
srmpl_revno	varchar(40)	NOT NULL	service pricelist revision no	Yes	No
srmpl_ouinstance	int	NOT NULL	instance	Yes	No
srmpl_part_type	varchar(5)	NOT NULL	part type of the material can be component expendable consumable	No	No
srmpl_lineno	int	NOT NULL	line no for multi reference	Yes	No
Table Name spl_srmplH_mtrl_policy_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
srmplH_ouinstance	int	NOT NULL	instance &nbspfrom application Table	No	No
srmplH_plno	varchar(40)	NOT NULL	price list no  &nbspfrom application Table	No	No
srmplH_revno	varchar(40)	NOT NULL	revision no  &nbspfrom application Table	No	No
srmplH_lineno	int	NOT NULL	line no  &nbspfrom application Table	No	No
srmplH_part_type	varchar(5)	NOT NULL	part type &nbspfrom application Table	No	No
SRMPLH_PART_CONDITION	varchar(25)	NULL	part condition &nbspfrom application Table	No	No
SRMPLH_PRICING_FACTOR	numeric	NULL	pricing factor &nbspfrom application Table	No	No
srmplH_price_method	varchar(5)	NOT NULL	price method  &nbspfrom application Table	No	No
srmplH_part_plist	varchar(40)	NULL	part list  &nbspfrom application Table	No	No
srmplH_part_plist_ou	int	NULL	part pricelist ou  &nbspfrom application Table	No	No
srmplH_created_by	varchar(30)	NOT NULL	created by  &nbspfrom application Table	No	No
srmplH_created_date	datetime	NOT NULL	created date &nbspfrom application Table	No	No
srmplH_modified_by	varchar(30)	NULL	Modified by &nbspfrom application Table	No	No
srmplH_modified_date	datetime	NULL	modified date &nbspfrom application Table	No	No
Table Name spl_srplh_hdr
Table Comment To store the main information of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
srplh_ouinstance	int	NOT NULL	current instance	Yes	No
srplh_plno	varchar(40)	NOT NULL	service price list no	Yes	No
srplh_revno	varchar(40)	NOT NULL	revision no auto generated	Yes	No
srplh_status	varchar(5)	NOT NULL	service price list status values &nbspwill be Confirmed Active InActive Fresh Returned Canceled Revised	No	No
srplh_desc	varchar(150)	NOT NULL	service price list description	No	No
srplh_pl_category	varchar(40)	NULL	service price list category defined in category master	No	No
srplh_category_ou	int	NULL	category instance	No	No
srplh_eff_from	datetime	NOT NULL	service price list effectivity from date	No	No
srplh_eff_to	datetime	NULL	service price list effectivity TO date	No	No
srplh_remarks	varchar(255)	NULL	Remarks on service price list	No	No
srplh_currency	varchar(5)	NOT NULL	currency for service price list	No	No
srplh_oth_currency	varchar(5)	NOT NULL	other currency change applicablility or not values will be applicable not applicable	No	No
srplh_price_basis	varchar(5)	NOT NULL	Pricing basis for the service price list values will be direct factored on service price list codes willbe stored	No	No
srplh_std_spl	varchar(40)	NULL	standard service pricelist	No	No
srplh_std_spl_ou	int	NULL	standard service pricelist instance	No	No
srplh_price_factor	numeric	NULL	Pricing factor for service price list defined	No	No
srplh_mtrl_cost	varchar(5)	NULL	material cost of service price list	No	No
srplh_std_res_rate	numeric	NULL	resource rate for spl	No	No
SRPLH_STD_LBR_RATE_NRM	numeric	NULL	standard Normal Labour rate / hour	No	No
SRPLH_STD_LBR_RATE_OT	numeric	NULL	standard Normal Labour rate / hour for over time	No	No
SRPLH_STD_FAC_RATE	numeric	NULL	standard Normal Facility &nbsprate / hour	No	No
SRPLH_STD_PPL_NO	varchar(40)	NULL	standard part price list no	No	No
SRPLH_STD_PRICING_BASIS	varchar(5)	NULL	standard pricing basis values will be Cost Incurred Cost Plus Margin codes will be stored	No	No
SRPLH_STD_PRICING_FACTOR	numeric	NULL	standard pricing factor &nbspfor external repair services	No	No
SRPLH_INACTPREVREV	varchar(25)	NULL	previous inactive revision no	No	No
srplh_file_name	varchar(50)	NULL	file name for reference	No	No
srplh_timestamp	int	NOT NULL	timestamp for not allowing more than &nbspone user to acces same data	No	No
srplh_cancelcomments	varchar(255)	NULL	service price list if canceled comments for canceling	No	No
srplh_appComments	varchar(255)	NULL	approval comments	No	No
srplh_created_by	varchar(30)	NOT NULL	Created By	No	No
srplh_created_date	varchar(30)	NOT NULL	created date	No	No
srplh_modified_by	varchar(30)	NULL	Modified By	No	No
srplh_modified_date	datetime	NULL	Modified Date	No	No
srplh_confirmed_by	varchar(30)	NULL	confirmed by	No	No
srplh_confirmed_date	datetime	NULL	confirmed date	No	No
srplh_approved_by	varchar(30)	NULL	approved by	No	No
srplh_approved_date	datetime	NULL	approved date	No	No
spl_skill_price	varchar(25)	NULL	SKILL PRICE : Holds the values " " and "Roster code" Added for RCN : Trn-6S105-Rcn-BasSerPriceList-Rel6-2-01	No	No
Table Name spl_srplhH_hdr_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
srplhH_ouinstance	int	NOT NULL	instance from application table	Yes	No
srplhH_plno	varchar(40)	NOT NULL	service pricelist no from application table	Yes	No
srplhH_revno	varchar(40)	NOT NULL	service revision no from application table	Yes	No
srplhH_status	varchar(5)	NOT NULL	status from application table	No	No
srplhH_desc	varchar(150)	NOT NULL	desc from application table	No	No
srplhH_pl_category	varchar(40)	NULL	category from application table	No	No
srplhH_category_ou	int	NULL	category ou from application table	No	No
srplhH_eff_from	datetime	NOT NULL	effective date from application table	No	No
srplhH_eff_to	datetime	NULL	effectivity date to from application table	No	No
srplhH_remarks	varchar(255)	NULL	remarks from application table	No	No
srplhH_currency	varchar(20)	NOT NULL	currency from application table	No	No
srplhH_oth_currency	varchar(5)	NOT NULL	other currency applicability from application table	No	No
srplhH_price_basis	varchar(5)	NOT NULL	price basis from application table	No	No
srplhH_std_spl	varchar(40)	NULL	standard spl from application table	No	No
srplhH_std_spl_ou	int	NULL	standard spl ou &nbspfrom application table	No	No
srplhH_price_factor	numeric	NULL	standard price factor from application table	No	No
srplhH_mtrl_cost	varchar(5)	NULL	material cost from application table	No	No
SRPLHH_STD_LBR_RATE_NRM	numeric	NULL	standard Normal labour rate &nbspfrom application table	No	No
SRPLHH_STD_LBR_RATE_OT	numeric	NULL	standard overtime labour rate from application table	No	No
SRPLHH_STD_FAC_RATE	numeric	NULL	standard facility rate from application table	No	No
SRPLHH_STD_PPL_NO	varchar(40)	NULL	standard part price list from application table	No	No
SRPLHH_STD_PRICING_BASIS	varchar(5)	NULL	standard pricing basis from application table	No	No
SRPLHH_STD_PRICING_FACTOR	numeric	NULL	standard pricing factor &nbspfrom application table	No	No
SRPLHH_INACTPREVREV	varchar(25)	NULL	inactive revision no from application table	No	No
srplhH_file_name	varchar(50)	NULL	file name from application table	No	No
srplhH_timestamp	int	NOT NULL	timestamp from application table	No	No
srplhH_cancelcomments	varchar(255)	NULL	cancel comments from application table	No	No
srplhH_appComments	varchar(255)	NULL	approved comments from application table	No	No
srplhH_created_by	varchar(30)	NOT NULL	created by from application table	No	No
srplhH_created_date	datetime	NOT NULL	created date from application table	No	No
srplhH_modified_by	varchar(30)	NULL	modified by from application table	No	No
srplhH_modified_date	datetime	NULL	Modified date from application table	No	No
srplhH_confirmed_by	varchar(30)	NULL	confirmed by from application table	No	No
srplhH_confirmed_date	datetime	NULL	confirmed date from application table	No	No
srplhH_approved_by	varchar(30)	NULL	approved by &nbspfrom application table	No	No
srplhH_approved_date	datetime	NULL	approved date from application table	No	No
srplhH_revisied_by	varchar(30)	NULL	revised by from application table	No	No
srplhH_revisied_date	datetime	NULL	revised date from application table	No	No
Table Name spl_srres_res_policy
Table Comment To store the pricing policy of resources of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SRRES_RATE_PER_HR_NRM	numeric	NULL	resource normal rate /hr	No	No
SRRES_RATE_PER_HR_OT	numeric	NULL	resourece rate / hr for over time	No	No
srres_price_method	varchar(5)	NOT NULL	service price list pricing method values will be direct work unit wise flat	No	No
srres_billable	varchar(5)	NOT NULL	billable or not should be given values will be yes or no	No	No
srres_resource_ou	int	NULL	resource instance	No	No
srres_modified_by	varchar(30)	NULL	modified by	No	No
srres_rate_per_hr	numeric	NOT NULL	rate per hour	No	No
srres_created_date	datetime	NOT NULL	created date	No	No
srres_created_by	varchar(30)	NOT NULL	created by	No	No
srres_modified_date	datetime	NULL	modified date	No	No
srres_revno	varchar(40)	NOT NULL	service price list revision no	Yes	No
srres_lineno	int	NOT NULL	line no for multi details reference	Yes	No
srres_plno	varchar(40)	NOT NULL	service price list no	Yes	No
srres_ouinstance	int	NOT NULL	repair pricing &nbspinstance	Yes	No
srres_resource_no	varchar(40)	NULL	resource no	No	No
srres_res_type	varchar(5)	NOT NULL	resource type for service price list values willbe equipment skills others tools	No	No
srplh_ouinstance	int	NULL	service pricelist instance	No	Yes
srplh_revno	varchar(40)	NULL	service pricelist revision no	No	Yes
srplh_plno	varchar(40)	NULL	service pricelist no	No	Yes
Table Name spl_srresH_res_policy_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
srresH_ouinstance	int	NOT NULL	instance from application table	No	No
srresH_plno	varchar(40)	NOT NULL	price list &nbspfrom application table	No	No
srresH_revno	varchar(40)	NOT NULL	price list revno &nbspfrom application table	No	No
srresH_lineno	int	NOT NULL	line no &nbspfrom application table	No	No
srresH_res_type	varchar(5)	NOT NULL	resource type &nbspfrom application table	No	No
srresH_resource_no	varchar(40)	NULL	resurce no  &nbspfrom application table	No	No
srresH_resource_ou	int	NULL	resource instance &nbspfrom application table	No	No
srresH_billable	varchar(5)	NOT NULL	billable &nbspfrom application table	No	No
srresH_price_method	varchar(5)	NOT NULL	price method &nbspfrom application table	No	No
SRRESH_RATE_PER_HR_NRM	numeric	NULL	normal rate per hour &nbspfrom application table	No	No
SRRESH_RATE_PER_HR_OT	numeric	NULL	over time rate per hour &nbspfrom application table	No	No
srresH_created_by	varchar(30)	NOT NULL	created by &nbspfrom application table	No	No
srresH_created_date	datetime	NOT NULL	created date &nbspfrom application table	No	No
srresH_modified_by	varchar(30)	NULL	modified by &nbspfrom application table	No	No
srresH_modified_date	datetime	NULL	modified date &nbspfrom application table	No	No
Table Name spl_srvcop_options
Table Comment To store the set options of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
srvcop_OUInstance	int	NOT NULL	instance	No	No
srvcop_Activation	varchar(5)	NOT NULL	whether activation of service price list on creation / revision no is to be given values will be like required not required required only for rvns	No	No
SRVCOP_BASE_PRTLIST	varchar(40)	NULL	base part price list	No	No
srvcop_Timestamp	int	NOT NULL	time stamp for not allowing more than one user to access the same data	No	No
srvcop_Created_By	varchar(30)	NOT NULL	created by	No	No
srvcop_Created_Date	datetime	NOT NULL	created date	No	No
srvcop_Modified_By	varchar(30)	NULL	modified by	No	No
srvcop_Modified_Date	datetime	NULL	modified date	No	No
srvcop_stksts_req	varchar(5)	NULL	To have the information of stock status is required or not Added for RCN ID : Trn-6S105-Rcn-BasSerPriceList-Rel6-2-01	No	No
Table Name spl_wkpr_wkunit_price
Table Comment To store the work unit price of service pricelist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wkpr_ouinstance	int	NOT NULL	current instance	Yes	No
wkpr_plno	varchar(40)	NOT NULL	service price list no	Yes	No
wkpr_revno	varchar(40)	NOT NULL	revision of service price list no	Yes	No
wkpr_lineno	int	NOT NULL	line no in multiline for work unit	Yes	No
ropr_ouinstance	int	NULL	instance	No	Yes
wkpr_wkunit_ou	int	NOT NULL	work unit instance	No	No
wkpr_wkunit_type	varchar(5)	NOT NULL	Type &nbspof workunit and values will be standard procedure task aircraft work package component Work package Maint change request	No	No
wkpr_wkunit_no	varchar(30)	NOT NULL	work unit no	No	No
wkpr_mtrl_cost	numeric	NOT NULL	material cost for the work unit	No	No
wkpr_res_cost	numeric	NOT NULL	resource cost for the work unit	No	No
wkpr_misc_cost	numeric	NULL	miscellaneous cost for work unit	No	No
WKPR_FAC_RATE	numeric	NOT NULL	facility rate for work unit	No	No
wkpr_auth_units	varchar(256)	NOT NULL	authorizing instance	No	No
wkpr_created_by	varchar(30)	NOT NULL	created by	No	No
wkpr_created_date	datetime	NOT NULL	created date	No	No
wkpr_modified_by	datetime	NULL	modified by	No	No
wkpr_modified_date	datetime	NULL	modified date	No	No
Table Name spl_wkprH_wkunit_price_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wkprH_ouinstance	int	NOT NULL	instance from application table	Yes	No
wkprH_plno	varchar(40)	NOT NULL	plno from application table	Yes	No
wkprH_revno	varchar(40)	NOT NULL	revno from application table	Yes	No
wkprH_lineno	int	NOT NULL	line no from application table	Yes	No
wkprH_wkunit_ou	int	NOT NULL	wrkunit ou from application table	No	No
wkprH_wkunit_type	varchar(5)	NOT NULL	wrkunt type from application table	No	No
wkprH_wkunit_no	varchar(30)	NOT NULL	wkunitno from application table	No	No
wkprH_mtrl_cost	numeric	NOT NULL	material cost from application table	No	No
wkprH_res_cost	numeric	NOT NULL	resource cost from application table	No	No
wkprH_misc_cost	numeric	NULL	misc cost from application table	No	No
WKPRH_FAC_RATE	numeric	NOT NULL	facility rate from application table	No	No
wkprH_auth_units	varchar(256)	NOT NULL	auth unit from application table	No	No
wkprH_created_by	varchar(30)	NOT NULL	created by from application table	No	No
wkprH_created_date	datetime	NOT NULL	created date from application table	No	No
wkprH_modified_by	varchar(30)	NULL	modified by from application table	No	No
wkprH_modified_date	datetime	NULL	modified date from application table	No	No