Database Schema for

Data Dictionary -- Scrap Note

Srl. No.	Table Name	Comment
1	SCRP_SCRPPARAM_PARAMETER_DETAIL	Scrap Parameter Table
2	SCRP_SCRPSTS_STATUS_CHANGE_LOG	Scrap header status log table
3	SCRP_SNH_SCRAP_NOTE_HDR	Scrap header table
4	SCRP_SNPD_SCRAP_NOTE_PART_DTL	Scrap detail table


Table Name :	SCRP_SCRPPARAM_PARAMETER_DETAIL
Comment :	Scrap Parameter Table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SCRPPARAM_COMPONENTNAME	udd_component	varchar(16)	No	Componentname	Yes
SCRPPARAM_PARAMCATEGORY	udd_category	varchar(15)	No	Control type	Yes
SCRPPARAM_PARAMTYPE	udd_paramtype	varchar(25)	No	Param Type	Yes
SCRPPARAM_PARAMCODE	udd_paramcode	varchar(30)	No	Param code	Yes
SCRPPARAM_LANGID	udd_languageid	int(4)	Yes	Language id	No
SCRPPARAM_PARAMDESC	udd_txt80	varchar(80)	Yes	Param code description	No
SCRPPARAM_SORT_BY	udd_seqno	int(4)	Yes	SORT BY	No


Table Name :	SCRP_SCRPSTS_STATUS_CHANGE_LOG
Comment :	Scrap header status log table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SCRPSTS_SCRAP_note_no	udd_documentno	varchar(40)	Yes	Document no	No
SCRPSTS_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	OU Instance	No
SCRPSTS_Level_chg	udd_designparamcode	varchar(5)	Yes	Metadata Value	No
SCRPSTS_Part_Unique_id	udd_unique_id	bigint(8)	No	Scrap header unique id/Part level unique id	No
SCRPSTS_from_status	udd_designparamcode	varchar(5)	Yes	From status	No
SCRPSTS_to_status	udd_designparamcode	varchar(5)	Yes	To status	No
SCRPSTS_changed_by	udd_ctxt_user	varchar(30)	Yes	Changed by	No
SCRPSTS_changed_date	udd_datetime1	datetime(8)	Yes	Changed date	No


Table Name :	SCRP_SNH_SCRAP_NOTE_HDR
Comment :	Scrap header table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SNH_Unique_no	udd_unique_id	bigint(8)	No	Identity Column	Yes
SNH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU Instance	No
SNH_SCRAP_note_no	udd_documentno	varchar(40)	No	document no	No
SNH_SCRAP_note_date	udd_datetime1	datetime(8)	Yes	date	No
SNH_Scrap_note_Status	udd_flag	varchar(25)	Yes	Scrap note status	No
SNH_Scrap_type	udd_flag	varchar(25)	Yes	Scrap type	No
SNH_Scrap_Priority	udd_flag	varchar(25)	Yes	scrap priority	No
SNH_Scrap_Category	udd_flag	varchar(25)	Yes	Scrap Category	No
SNH_Scrap_UserStatus	udd_flag	varchar(25)	Yes	User Status	No
SNH_Scrap_GenerationMode	udd_flag	varchar(25)	Yes	Generation mode	No
SCRP_SCRAP_Total_value	udd_value	numeric(13)	Yes	Sum(SNPD_SCRAP_Value) from SCRP_SNPD_SCRAP_NOTE_PART_DTL	No
SCRP_SCRAP_Value_Currency	udd_currency	varchar(20)	Yes	Value Currency	No
SNH_Material_control_group	udd_flag	varchar(25)	Yes	Buyer Code	No
SNH_Initiated_Employee	udd_empcode	varchar(15)	Yes	Employee code	No
SNH_Ref_Document_type	udd_flag	varchar(25)	Yes	Ref document type	No
SNH_Ref_Document_no	udd_documentno	varchar(40)	Yes	Ref document No	No
SNH_Ref_Document_OU	udd_ctxt_ouinstance	int(4)	Yes	Ref document OUInstance	No
SNH_Ref_Customer_Order	udd_documentno	varchar(40)	Yes	Customer order #	No
SNH_Ref_Work_Center_OU	udd_ctxt_ouinstance	int(4)	Yes	Work center OU Instance	No
SNH_Ref_Work_Center	udd_wccode	varchar(30)	Yes	Workcenter	No
SNH_Ref_Station_code	udd_documentno	varchar(40)	Yes	Station code	No
SNH_Ref_Oth_References	udd_documentno	varchar(40)	Yes	Ref Other References	No
SNH_Rem_Aircraft_Reg_no	udd_aircraftnumber	varchar(30)	Yes	Aircraft reg no	No
SNH_Rem_NHA_Part_no	udd_partno	varchar(40)	Yes	NHA part no	No
SNH_Rem_NHA_Serial_no	udd_partserialnumber	varchar(40)	Yes	NHA serial no	No
SNH_Rem_Component_id	udd_componentid	varchar(90)	Yes	NHAPart+NHA Serial Combination	No
SNH_trading_Parter_type	udd_flag	varchar(25)	Yes	Metadata Value	No
SNH_trading_Parter_No	udd_vendorcode	varchar(45)	Yes	Vender code	No
SNH_trading_Parter_OU	udd_ctxt_ouinstance	int(4)	Yes	Trading patner OU Instance	No
SNH_WH_Warehouse	udd_warehouse	varchar(10)	Yes	Warehouse	No
SNH_WH_Zone	udd_zone	varchar(10)	Yes	Zone	No
SNH_WH_Bin	udd_bin	varchar(10)	Yes	WH,Zone and Bin valid combination	No
SNH_Process_Date	udd_datetime1	datetime(8)	Yes	Process date	No
SNH_Process_Comments	udd_notes	varchar(2000)	Yes	Process comments	No
SNH_Process_Action	udd_flag	varchar(25)	Yes	Process action	No
SNH_Other_Comments	udd_notes	varchar(2000)	Yes	Comments	No
SNH_Timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
SNH_Created_Date	udd_datetime1	datetime(8)	Yes	Created date	No
SNH_Created_By	udd_ctxt_user	varchar(30)	Yes	Created by	No
SNH_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified date	No
SNH_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified by	No
SNH_Confirmed_Date	udd_datetime1	datetime(8)	Yes	Conformed date	No
SNH_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Conformed by	No
SNH_Processed_Date	udd_datetime1	datetime(8)	Yes	Processed date	No
SNH_Processed_By	udd_ctxt_user	varchar(30)	Yes	Processed by	No
SNH_Doc_key	wfdockey	varchar(128)	Yes	Document key	No
SNH_Auth_Status	wfstatename	varchar(10)	Yes	Authorization Status	No
SNH_Note_ID	udd_guid	varchar(40)	Yes	Guid	No
SNH_Expense_type	udd_flag	varchar(25)	Yes	Expense type	No
SNH_SrcDoc_Charge	udd_value	numeric(13)	Yes	Source doc charge	No


Table Name :	SCRP_SNPD_SCRAP_NOTE_PART_DTL
Comment :	Scrap detail table


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SNPD_SCRAP_Part_Unique_no	udd_unique_id	bigint(8)	No	Indentity Column	Yes
SNPD_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU Instance	No
SNPD_SCRAP_note_no	udd_documentno	varchar(40)	No	document no	No
SNPD_Line_no	udd_seqno	int(4)	No	Sequence no	No
SNPD_Line_Status	udd_flag	varchar(25)	Yes	Metadata Value	No
SNPD_Part_no	udd_partno	varchar(40)	Yes	Part No	No
SNPD_Part_description	udd_txt150	varchar(150)	Yes	For Miscellaneous part s	No
SNPD_Part_ou	udd_ctxt_ouinstance	int(4)	Yes	Part OU Instance	No
SNPD_Mft_Part_no	udd_partno	varchar(40)	Yes	Mfr Part No	No
SNPD_Mft_no	udd_vendorcode	varchar(45)	Yes	Manufacture no	No
SNPD_Part_Quantity	udd_quantity	numeric(13)	Yes	Quantity	No
SNPD_Part_UOM	udd_uom	varchar(15)	Yes	UOM Master	No
SNPD_Stock_status	udd_partstatus	varchar(40)	Yes	Stock status	No
SNPD_Part_Condition	udd_flag	varchar(25)	Yes	Part condition	No
SNPD_Reason_For_SCRAP	udd_flag	varchar(25)	Yes	Reason for scrap	No
SNPD_Repl_Action	udd_flag	varchar(25)	Yes	Replishment action	No
SNPD_Part_Serial	udd_partserialnumber	varchar(40)	Yes	Part serial	No
SNPD_Mft_Part_Serial	udd_partserialnumber	varchar(40)	Yes	Manufacture part serial no	No
SNPD_Part_Lot	udd_lotnumber	varchar(28)	Yes	Manufacture lot no	No
SNPD_Mft_Part_Lot	udd_lotnumber	varchar(28)	Yes	Manufacture part lot no	No
SNPD_Component_id	udd_componentid	varchar(90)	Yes	Part+Serail combination retrieved	No
SNPD_Remarks	udd_notes	varchar(2000)	Yes	Remarks	No
SNPD_Process_Comments	udd_notes	varchar(2000)	Yes	Process comments	No
SNPD_Process_Action	udd_flag	varchar(25)	Yes	Process action	No
SNPD_Zone	udd_zone	varchar(10)	Yes	zone	No
SNPD_Bin	udd_bin	varchar(10)	Yes	Bin	No
SNPD_Part_UnitCost	udd_value	numeric(13)	Yes	Part unit cost	No
SNPD_Other_Particulars	udd_notes	varchar(2000)	Yes	Other Particulars	No
SNPD_SCRAP_Value	udd_value	numeric(13)	Yes	Scrap value	No
SNPD_SCRAP_Currency	udd_currency	varchar(20)	Yes	Currency	No
SNPD_Filename	udd_filename	varchar(50)	Yes	Filename	No
SNPD_Line_STS_Flag	udd_flag	varchar(25)	Yes	Sts value	No
SNPD_CR_no	udd_documentno	varchar(40)	Yes	Latest CR # identified for the component	No
SNPD_CR_RemReason	udd_flag	varchar(25)	Yes	RemReason	No
SNPD_CR_SOSDisp	udd_flag	varchar(25)	Yes	SOSDisp	No
SNPD_Timestamp	udd_timestamp	int(4)	Yes	Record Statistics	No
SNPD_Process_Level	udd_flag	varchar(25)	Yes	Process_Level	No
SNPD_Created_Date	udd_datetime1	datetime(8)	Yes	Created_date	No
SNPD_Created_By	udd_ctxt_user	varchar(30)	Yes	Created_by	No
SNPD_Modified_Date	udd_datetime1	datetime(8)	Yes	Modified_date	No
SNPD_Modified_By	udd_ctxt_user	varchar(30)	Yes	Modified_by	No
SNPD_Confirmed_Date	udd_datetime1	datetime(8)	Yes	Conformed_date	No
SNPD_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Conformed_by	No
SNPD_Processed_Date	udd_datetime1	datetime(8)	Yes	Process_date	No
SNPD_Processed_By	udd_ctxt_user	varchar(30)	Yes	Processed_by	No
SNPD_Shortclosed_Qty	udd_quantity	numeric(13)	Yes	Scrap quantity - Replenished Qty	No
SNPD_Note_ID	udd_guid	varchar(40)	Yes	Note ID	No
SNPD_replenished_qty	udd_quantity	numeric(13)	Yes	Replinished Id	No
SNPD_Disposal_note	udd_txt2000	varchar(2000)	Yes	GUID	No
SNPD_Expense_type	udd_flag	varchar(25)	Yes	Part Expense type	No
SNPD_account_usage	fin_usageid	varchar(20)	Yes	Account usage	No
SNPD_costusage	fin_ccusage	varchar(20)	Yes	Costing usage	No
SNPD_Asset_number	fin_assetnumber	varchar(18)	Yes	Asset No	No
SNPD_Asset_tag	fin_assettagno	int(4)	Yes	Asset tag	No
SNPD_Book_Value	fin_amount	numeric(13)	Yes	Book Value	No
SNPD_To_Stock_status	udd_partstatus	varchar(40)	Yes	To stock status	No
SNPD_New_LotNo	udd_lotno	varchar(18)	Yes	New lot no	No
SNPD_Repl_Warehouse	udd_warehouse	varchar(10)	Yes	Replishment warehouse	No