Data Dictionary -- Stock Analysis

Srl. No.	Table Name	Comment
1	STA_STAABCDTL_ABC_ANLY_DTL	STA_STAABCDTL_ABC_ANLY_DTL
2	Sta_StaCRP_RplPrm_Calc_Hdr	Sta_StaCRP_RplPrm_Calc_Hdr
3	STA_STADTL_PRT_STK_VALUE_INFO	STA_STADTL_PRT_STK_VALUE_INFO
4	StA_StADtl_Stk_Analysis_Dtl	StA_StADtl_Stk_Analysis_Dtl
5	STA_STAFSNDTL_FSN_ANLY_DTL	STA_STAFSNDTL_FSN_ANLY_DTL
6	StA_StAHdr_Stk_Analysis_Hdr	StA_StAHdr_Stk_Analysis_Hdr
7	StA_StAOpt_Option_Settings	StA_StAOpt_Option_Settings
8	StA_StAPrm_Parameter_Dtl	StA_StAPrm_Parameter_Dtl
9	Sta_StaRprt_Repl_Part_Dtl	Sta_StaRprt_Repl_Part_Dtl
10	Sta_StaSLF_Srv_Lvl_Factor	Sta_StaSLF_Srv_Lvl_Factor
11	Sta_StaSRP_Repln_Prm_Set	Sta_StaSRP_Repln_Prm_Set
12	STA_STASRP_REPLN_PRM_SET_HDR	STA_STASRP_REPLN_PRM_SET_HDR
13	STA_STAVEDDTL_VED_ANLY_DTL	STA_STAVEDDTL_VED_ANLY_DTL
14	STA_STAXYZDTL_XYZ_ANLY_DTL	STA_STAXYZDTL_XYZ_ANLY_DTL

Table Name :	STA_STAABCDTL_ABC_ANLY_DTL
Comment :	STA_STAABCDTL_ABC_ANLY_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STAABCDTL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU Instance	Yes
STAABCDTL_ANALYSIS_NO	udd_documentno	varchar(40)	No	Analysis Number	Yes
STAABCDTL_PART_NO	udd_partno	varchar(40)	No	Part Number	Yes
STAABCDTL_PART_PLN_OU	udd_ctxt_ouinstance	int(4)	No	Part Planning OU	Yes
STAABCDTL_PART_CRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU	No
STAABCDTL_VALUE	udd_amount	numeric(13)	Yes	Value	No
STAABCDTL_CUM_VALUE	udd_amount	numeric(13)	Yes	Cumulative value	No
STAABCDTL_VALUE_INPERC	udd_amount	numeric(13)	Yes	Value in Percent	No
STAABCDTL_CUM_VALUE_INPERC	udd_amount	numeric(13)	Yes	Cumulative value in Percent	No
STAABCDTL_CURR_ClassType	udd_designparamcode	varchar(5)	Yes	Class Type	No
STAABCDTL_NEW_ClassType	udd_designparamcode	varchar(5)	Yes	New Class Type	No
STAABCDTL_CURR_STKVALUE	udd_rate	numeric(13)	Yes	Stock Value	No

Table Name :	Sta_StaCRP_RplPrm_Calc_Hdr
Comment :	Sta_StaCRP_RplPrm_Calc_Hdr

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StaCRP_Compute_Seq_no	udd_seqno	int(4)	No	Sequence Number	No
StaCRP_Compute_Lvl	udd_designparamcode	varchar(5)	Yes	Compute Level	No
StaCRP_Loc_StkAdmn_Ou	udd_ctxt_ouinstance	int(4)	Yes	Location OU	No
StaCRP_Warehouse_no	udd_warehouse	varchar(10)	Yes	Warehouse	No
StaCRP_Part_no	udd_partno	varchar(40)	Yes	Part Number	No
StaCRP_Part_Grp	udd_customer_id	varchar(18)	Yes	Part Group	No
StaCRP_SrvLvl_Percent	udd_quantity	numeric(13)	Yes	Srv Lvl Percent	No
StaCRP_SrvLvl_Factor	udd_factor	numeric(13)	Yes	Srv Lvl Factor	No
StaCRP_Per_Order_Cost	udd_amount	numeric(13)	Yes	Per Order Cost	No
StaCRP_CryCost_Pct_StdPr	udd_amount	numeric(13)	Yes	Cry Cost Pct Std Price	No
StaCRP_Anul_Consumption	udd_numericparamval	numeric(13)	Yes	Annual Consumption	No
StaCRP_Forecast_Factor	udd_usage	numeric(13)	Yes	Forecast Factor	No
StaCRP_Lead_Time	udd_timeunit	numeric(9)	Yes	Lead time	No
StaCRP_Lead_Time_unit	udd_designparamcode	varchar(5)	Yes	Lead time Unit	No
StaCRP_From_date	_datetime_8	datetime(8)	Yes	From Date	No
StaCRP_To_date	_datetime_8	datetime(8)	Yes	To Date	No
StaCRP_Max_Tolerance_Pct	udd_percentage	decimal(9)	Yes	Maximum Tolerance Percent	No
StaCRP_Min_Tolerance_Pct	udd_percentage	decimal(9)	Yes	Minimum Tolerance Percent	No
StaCRP_Reorder_Qty_Flg	udd_designparamcode	varchar(5)	Yes	Reorder Quantity Flag	No
StaCRP_Reorder_Lvl_Flg	udd_designparamcode	varchar(5)	Yes	ReOrder Level Flag	No
StaCRP_Safety_Stock_Flg	udd_designparamcode	varchar(5)	Yes	Safety Stock Flag	No
StaCRP_MinMax_Min_Qty	udd_designparamcode	varchar(5)	Yes	Min-Max Minimum Qty	No
StaCRP_Update_Input_Prm	udd_designparamcode	varchar(5)	Yes	Update Input Prm	No
StaCRP_Itm_Compute_Cnt	udd_denomination	decimal(9)	Yes	Compute Cnt	No
StaCRP_Itm_Revise_Cnt	udd_denomination	decimal(9)	Yes	Item Revise Cnt	No
StaCRP_Itm_Update_Cnt	udd_denomination	decimal(9)	Yes	Item Update Cnt	No
StaCRP_created_datetime	_datetime_8	datetime(8)	Yes	Created Date	No
StaCRP_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
StaCRP_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
StaCRP_modified_datetime	_datetime_8	datetime(8)	Yes	Modified Date	No
StaCRP_Timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
STACRP_CONS_ST	udd_designparamcode	varchar(5)	Yes	Cons_st	No
STACRP_COMP_STATUS	udd_designparamcode	varchar(5)	Yes	Comp Status	No
REPLICATION_KEY	_datetime_8	datetime(8)	No	Replication key	Yes

Table Name :	STA_STADTL_PRT_STK_VALUE_INFO
Comment :	STA_STADTL_PRT_STK_VALUE_INFO

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STA_STADTL_PRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part OU instance	No
STA_STADTL_PRT_PRTNO	udd_partno	varchar(40)	Yes	Part number	No
STA_STADTL_PRT_NEW_STK_VALUE	udd_amount	numeric(13)	Yes	Part New Stock Value	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	Replication Key	Yes

Table Name :	StA_StADtl_Stk_Analysis_Dtl
Comment :	StA_StADtl_Stk_Analysis_Dtl

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StADtl_OUInstance	udd_ctxt_ouinstance	int(4)	No	OU Instance	Yes
StADtl_Analysis_No	udd_documentno	varchar(40)	No	Analysis Number	Yes
StADtl_Part_No	udd_partno	varchar(40)	No	Part Number	Yes
StADtl_Part_Crt_OU	udd_ctxt_ouinstance	int(4)	No	Part Created OU	Yes
StADtl_Location	udd_reasoncode	varchar(10)	No	Location	Yes
StADtl_ABC_Curr_ClsTyp	udd_designparamcode	varchar(5)	Yes	ABC Current class type	No
StADtl_ABC_New_ClsTyp	udd_designparamcode	varchar(5)	Yes	ABC New class type	No
StADtl_XYZ_Curr_ClsTyp	udd_designparamcode	varchar(5)	Yes	XYZ Current class type	No
StADtl_XYZ_New_ClsTyp	udd_designparamcode	varchar(5)	Yes	XYZ New class type	No
StADtl_FSN_Curr_ClsTyp	udd_designparamcode	varchar(5)	Yes	FSN Current class type	No
StADtl_FSN_New_ClsTyp	udd_designparamcode	varchar(5)	Yes	FSN New class type	No
StADtl_VED_Curr_ClsTyp	udd_designparamcode	varchar(5)	Yes	VED Current class type	No
StADtl_StockQty	udd_quantity	numeric(13)	Yes	Stock Quantity	No
StADtl_Value	udd_rate	numeric(13)	Yes	Value	No
StADtl_Row_no	udd_count	int(4)	Yes	Row Number	No

Table Name :	STA_STAFSNDTL_FSN_ANLY_DTL
Comment :	STA_STAFSNDTL_FSN_ANLY_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STAFSNDTL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU Instance	Yes
STAFSNDTL_ANALYSIS_NO	udd_documentno	varchar(40)	No	Analysis Number	Yes
STAFSNDTL_PART_NO	udd_partno	varchar(40)	No	Part number	Yes
STAFSNDTL_PART_PLN_OU	udd_ctxt_ouinstance	int(4)	No	Part Planning OU	Yes
STAFSNDTL_PART_CRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU	No
STAFSNDTL_AVGSTAY	udd_duration	numeric(13)	Yes	Average stay	No
STAFSNDTL_AVGSTAY_INPERC	udd_duration	numeric(13)	Yes	Average stay in Percent	No
STAFSNDTL_CUM_AVGSTAY	udd_duration	numeric(13)	Yes	cummulative Avg stay	No
STAFSNDTL_CUM_AVGSTAY_INPERC	udd_duration	numeric(13)	Yes	cummulative Avg stay in Percent	No
STAFSNDTL_AVGSTAY_FSN	udd_designparamcode	varchar(5)	Yes	Avg stay FSN	No
STAFSNDTL_CONS_RATE	udd_rate	numeric(13)	Yes	const Rate	No
STAFSNDTL_CONS_RATE_INPERC	udd_rate	numeric(13)	Yes	const rate in percent	No
STAFSNDTL_CUM_CONS_RATE	udd_price	numeric(13)	Yes	cumulative const rate	No
STAFSNDTL_CUM_CRATE_INPERC	udd_rate	numeric(13)	Yes	cumulative const rate in percent	No
STAFSNDTL_CONS_RATE_FSN	udd_designparamcode	varchar(5)	Yes	const rate FSN	No
STAFSNDTL_CURR_STKVALUE	udd_rate	numeric(13)	Yes	Current Stk Value	No
STAFSNDTL_CURR_ClassType	udd_designparamcode	varchar(5)	Yes	Current class type	No
STAFSNDTL_NEW_ClassType	udd_designparamcode	varchar(5)	Yes	New Class Type	No
STAFSNDTL_STK_QTY	udd_quantity	numeric(13)	Yes	Stock quantity	No
STAFSNDTL_STK_UOM	udd_uom	varchar(15)	Yes	Stock UOM	No
STAFSNDTL_NEW_STKVALUE	udd_rate	numeric(13)	Yes	New Stock Value	No

Table Name :	StA_StAHdr_Stk_Analysis_Hdr
Comment :	StA_StAHdr_Stk_Analysis_Hdr

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StAHdr_OUInstance	udd_ctxt_ouinstance	int(4)	No	OU Instance	Yes
StAHdr_Analysis_No	udd_documentno	varchar(40)	No	Analysis Number	Yes
StAHdr_ABC_Analysis_Type	udd_designparamcode	varchar(5)	Yes	abc analysis type	No
StAHdr_XYZ_Analysis_Type	udd_designparamcode	varchar(5)	Yes	xyz analysis type	No
StAHdr_FSN_Analysis_Type	udd_designparamcode	varchar(5)	Yes	FSN Analysis type	No
StAHdr_VED_Analysis_Type	udd_designparamcode	varchar(5)	Yes	VED analysis type	No
StAHdr_All_ClsTyp_Flag	udd_designparamcode	varchar(5)	Yes	All Class type flag	No
StAHdr_Analysis_Level	udd_designparamcode	varchar(5)	Yes	Analysis level	No
StAHdr_Planned_By	udd_ctxt_user	varchar(30)	Yes	Planned by	No
StAHdr_Location	udd_reasoncode	varchar(10)	Yes	location	No
StAHdr_WareHouse_OU	udd_ctxt_ouinstance	int(4)	Yes	warehouse ou	No
StAHdr_WareHouse_Id	udd_warehouse	varchar(10)	Yes	warehouse id	No
StAHdr_Part_Category	udd_quickcodes	varchar(25)	Yes	part category	No
StAHdr_Part_Group	udd_flag1	varchar(25)	Yes	part group	No
StAHdr_PrtTyp_All_Flag	udd_designparamcode	varchar(5)	Yes	part typ all flag	No
StAHdr_PrtTyp_RM_Flag	udd_designparamcode	varchar(5)	Yes	Part type RM flag	No
StAHdr_PrtTyp_Tool_Flag	udd_designparamcode	varchar(5)	Yes	Part type tool flag	No
StAHdr_PrtTyp_Kit_Flag	udd_designparamcode	varchar(5)	Yes	Part type kit flag	No
StAHdr_PrtTyp_Exp_Flag	udd_designparamcode	varchar(5)	Yes	part type exp flag	No
StAHdr_PrtTyp_Comp_Flag	udd_designparamcode	varchar(5)	Yes	part type comp flag	No
StAHdr_PrtTyp_Cons_Flag	udd_designparamcode	varchar(5)	Yes	part type cons flag	No
StAHdr_PrtTyp_Misc_Flag	udd_designparamcode	varchar(5)	Yes	part type miscellaneous flag	No
StAHdr_PartType_Flag	udd_parttype	varchar(25)	Yes	part type flag	No
StAHdr_Expense_Type	udd_flag	varchar(25)	Yes	expense type	No
StAHdr_Period_Type	udd_designparamcode	varchar(5)	Yes	period type	No
StAHdr_Financial_Year	udd_financeyearrange	varchar(40)	Yes	financial year	No
StAHdr_Financial_Period	udd_financeperiodrange	varchar(40)	Yes	financial period	No
StAHdr_Analyze_From_Date	_Datetime_8	datetime(8)	Yes	analyze from date	No
StAHdr_Analyze_To_Date	_Datetime_8	datetime(8)	Yes	analyze to date	No
StAHdr_Upd_Flag	udd_designparamcode	varchar(5)	Yes	UPD flag	No
StAHdr_Remarks	udd_txt255	varchar(255)	Yes	remarks	No
StAHdr_Created_By	udd_ctxt_user	varchar(30)	Yes	created by	No
StAHdr_Created_DateTime	_Datetime_8	datetime(8)	Yes	created date	No
StAHdr_Timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
STAHDR_ANALYSIS_STATUS	udd_designparamcode	varchar(5)	Yes	analysis status	No
STAHDR_CONSIDER_ST	udd_designparamcode	varchar(5)	Yes	consider st	No
StAHdr_modified_By	udd_ctxt_user	varchar(30)	Yes	modified by	No
StAHdr_modified_DateTime	_Datetime_8	datetime(8)	Yes	modified date	No

Table Name :	StA_StAOpt_Option_Settings
Comment :	StA_StAOpt_Option_Settings

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StAOpt_OUInstance	udd_ctxt_ouinstance	int(4)	No	ou Instance	Yes
StAOpt_Option_Id	udd_optionsettingsinteger	numeric(9)	No	option id	Yes
StAOpt_Opt_Status	udd_designparamcode	varchar(5)	Yes	option status	No
StAOpt_A_Cls_Perc	udd_amount	numeric(13)	Yes	A Class Percent	No
StAOpt_B_Cls_Perc	udd_amount	numeric(13)	Yes	B Class Percent	No
StAOpt_C_Cls_Perc	udd_amount	numeric(13)	Yes	C Class Percent	No
StAOpt_F_Cls_AvgSty_Perc	udd_amount	numeric(13)	Yes	F class Avg Sty Percent	No
StAOpt_S_Cls_AvgSty_Perc	udd_amount	numeric(13)	Yes	S class Avg Sty Percent	No
StAOpt_N_Cls_AvgSty_Perc	udd_amount	numeric(13)	Yes	N class Avg Sty Percent	No
StAOpt_F_Cls_CnsRate_Perc	udd_amount	numeric(13)	Yes	F class Cons Rate Percent	No
StAOpt_S_Cls_CnsRate_Perc	udd_amount	numeric(13)	Yes	S class Cons Rate Percent	No
StAOpt_N_Cls_CnsRate_Perc	udd_amount	numeric(13)	Yes	N class Cons Rate Percent	No
StAOpt_X_Cls_Perc	udd_amount	numeric(13)	Yes	X Class Percent	No
StAOpt_Y_Cls_Perc	udd_amount	numeric(13)	Yes	Y Class Percent	No
StAOpt_Z_Cls_Perc	udd_amount	numeric(13)	Yes	Z Class Percent	No
StAOpt_PrtFlt_Allow_Flag	udd_designparamcode	varchar(5)	Yes	Part Flt Allow flag	No
StAOpt_ExpTypPrts_ValMet	udd_designparamcode	varchar(5)	Yes	Part Expense type	No
StAOpt_Created_By	udd_ctxt_user	varchar(30)	Yes	Created by	No
StAOpt_Created_Datetime	_datetime_8	datetime(8)	Yes	Created Date	No
StAOpt_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified By	No
StAOpt_Modified_Datetime	_datetime_8	datetime(8)	Yes	Modified Date	No
StAOpt_Timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
STAOPT_EXCH_ORDER	udd_checkyesno	varchar(3)	Yes	Exchange Order option	No
STAOPT_LOAN_ORDER	udd_checkyesno	varchar(3)	Yes	Loan Order option	No
STAOPT_RENTAL_ORDER	udd_checkyesno	varchar(3)	Yes	Rental Order option	No
STAOPT_PACK_SLIP	udd_checkyesno	varchar(3)	Yes	Pack Slip Option	No
STAOPT_UNPLND_TRAN	udd_checkyesno	varchar(3)	Yes	Unplanned transaction	No

Table Name :	StA_StAPrm_Parameter_Dtl
Comment :	StA_StAPrm_Parameter_Dtl

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StAPrm_ComponentName	udd_componentshortid	varchar(20)	No	Component Name	Yes
StAPrm_ParamCategory	udd_parametersource	varchar(10)	No	Parameter category	Yes
StAPrm_ParamType	udd_paramtype	varchar(25)	No	Parameter type	Yes
StAPrm_ParamCode	udd_designparamcode	varchar(5)	No	parameter Code	Yes
StAPrm_ParamDesc	udd_txt80	varchar(80)	Yes	Parameter Description	No
StAPrm_Langid	udd_ctxt_language	int(4)	Yes	Language Id	No
StAPrm_SortBy	udd_sortby	numeric(9)	Yes	Sort BY	No
StAPrm_CreationDate	_datetime_8	datetime(8)	Yes	Creation Date	No

Table Name :	Sta_StaRprt_Repl_Part_Dtl
Comment :	Sta_StaRprt_Repl_Part_Dtl

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StaRPrt_Compute_Seq_no	udd_seqno	int(4)	No	Compute Sequence number	No
StaRPrt_Loc_StkAdmn_Ou	udd_ctxt_ouinstance	int(4)	No	Stock Admin OU	No
StaRPrt_Warehouse_no	udd_warehouse	varchar(10)	No	Warehouse number	No
StaRPrt_Part_no	udd_partno	varchar(40)	No	Part number	No
StaRPrt_Part_Pln_Ou	udd_ctxt_ouinstance	int(4)	No	Part Planning OU	No
StaRPrt_Part_Crt_Ou	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU	No
StaRPrt_Reorder_Qty	udd_quantity	numeric(13)	Yes	Part Reorder quantity	No
StaRPrt_Reorder_Level	udd_quantity	numeric(13)	Yes	Reorder level	No
StaRPrt_Safety_Stock	udd_quantity	numeric(13)	Yes	Safety stock	No
StaRPrt_Update_flag	udd_designparamcode	varchar(5)	Yes	Update flag	No
StaRPrt_LeadtimeUnit	udd_designparamcode	varchar(5)	Yes	Lead time Unit	No
StaRPrt_Leadtime	udd_duration	numeric(13)	Yes	lead time	No
StaRPrt_Annual_Cons	udd_amount	numeric(13)	Yes	Annual consumption	No
StaRPrt_Carrying_cost	udd_amount	numeric(13)	Yes	Carrying cost	No
StaRPrt_Perorder_Cost	udd_amount	numeric(13)	Yes	Re order cost	No
StaRPrt_service_level	udd_numericparamval	numeric(13)	Yes	Service level	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	replication key	Yes

Table Name :	Sta_StaSLF_Srv_Lvl_Factor
Comment :	Sta_StaSLF_Srv_Lvl_Factor

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StaSLF_Service_Level	udd_quantity	numeric(13)	No	SLF service level	No
StaSLF_Service_Factor	udd_factor	numeric(13)	Yes	service factor	No
STASLF_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	ou Instance	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	replication key	Yes

Table Name :	Sta_StaSRP_Repln_Prm_Set
Comment :	Sta_StaSRP_Repln_Prm_Set

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StaSRP_Class	udd_class_level_code	varchar(3)	No	Class	No
StaSRP_Anul_Ord_Cost	udd_amount	numeric(13)	Yes	Annual Order Cost	No
StaSRP_Anul_Ord_Count	udd_quantity	numeric(13)	Yes	Annual Order Count	No
StaSRP_CryCost_Pct_StdPr	udd_amount	numeric(13)	Yes	Carry cost	No
StaSRP_From_date	_Datetime_8	datetime(8)	Yes	From Date	No
StaSRP_To_Date	_Datetime_8	datetime(8)	Yes	To Date	No
StaSRP_SrvLvl_Percent	udd_numericparamval	numeric(13)	Yes	serial level percent	No
StaSRP_Created_by	udd_ctxt_user	varchar(30)	Yes	created by	No
StaSRP_Created_Datetime	_Datetime_8	datetime(8)	Yes	created date	No
StaSRP_Modified_By	udd_ctxt_user	varchar(30)	Yes	modified by	No
StaSRP_Modified_Datetime	_Datetime_8	datetime(8)	Yes	modified date	No
StaSRP_Timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
StaSRP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	ou Instance	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	replication key	Yes

Table Name :	STA_STASRP_REPLN_PRM_SET_HDR
Comment :	STA_STASRP_REPLN_PRM_SET_HDR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
StaSRP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	ou Instance	No
StaSRP_EXCH_ORDER	udd_checkyesno	varchar(3)	Yes	Exchange Order	No
StaSRP_LOAN_ORDER	udd_checkyesno	varchar(3)	Yes	Loan Order	No
StaSRP_RENTAL_ORDER	udd_checkyesno	varchar(3)	Yes	rental order	No
StaSRP_PACK_SLIP	udd_checkyesno	varchar(3)	Yes	pack slip	No
StaSRP_UNPLND_TRAN	udd_checkyesno	varchar(3)	Yes	Unplanned transaction	No
StaSRP_CONSDR_AOG_PO	udd_designparamcode	varchar(5)	Yes	Consider AOG PO	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	replication key	Yes

Table Name :	STA_STAVEDDTL_VED_ANLY_DTL
Comment :	STA_STAVEDDTL_VED_ANLY_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STAVEDDTL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ou Instance	Yes
STAVEDDTL_ANALYSIS_NO	udd_documentno	varchar(40)	No	Analysis Number	Yes
STAVEDDTL_PART_NO	udd_partno	varchar(40)	No	Part number	Yes
STAVEDDTL_PART_PLN_OU	udd_ctxt_ouinstance	int(4)	No	Part Planning OU	Yes
STAVEDDTL_PART_CRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU	No
STAVEDDTL_CURR_STKVALUE	udd_rate	numeric(13)	Yes	current stock value	No
STAVEDDTL_CURR_ClassType	udd_designparamcode	varchar(5)	Yes	current class type	No

Table Name :	STA_STAXYZDTL_XYZ_ANLY_DTL
Comment :	STA_STAXYZDTL_XYZ_ANLY_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STAXYZDTL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ou Instance	Yes
STAXYZDTL_ANALYSIS_NO	udd_documentno	varchar(40)	No	Analysis Number	Yes
STAXYZDTL_PART_NO	udd_partno	varchar(40)	No	Part number	Yes
STAXYZDTL_PART_PLN_OU	udd_ctxt_ouinstance	int(4)	No	Part Planning OU	Yes
STAXYZDTL_PART_CRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Created OU	No
STAXYZDTL_CURR_STKVALUE	udd_rate	numeric(13)	Yes	current stock value	No
STAXYZDTL_CUM_VALUE	udd_value	numeric(13)	Yes	cummulative value	No
STAXYZDTL_VALUE_INPERC	udd_value	numeric(13)	Yes	Value in Percent	No
STAXYZDTL_CUM_VALUE_INPERC	udd_value	numeric(13)	Yes	cummulatve value in percent	No
STAXYZDTL_CURR_ClassType	udd_designparamcode	varchar(5)	Yes	current class type	No
STAXYZDTL_NEW_ClassType	udd_designparamcode	varchar(5)	Yes	New Class Type	No