Data Dictionary -- Stock Return

Srl. No.	Table Name	Comment
1	RTN_SRTNPRM_PARAMETER_DTL	Stores meta data Parameter detail information.
2	RTN_SRTNQC_QUICK_CODE	this table used to store the quick code values
3	SRTN_OWNERSHIP_CHG_LOG	To maintain the ownership change information on return
4	SRTN_RTNADL_STK_RETURN_ADL	table which is used to store the storage information for the returned parts
5	SRTN_RTNDA_DOC_ATTACH_DTL	This table allows you to store the reference information for the return.
6	SRTN_RTNDTL_STK_RETURN_DTL	This will have the returned part details of the Return Document. Note: Issue details will be NULL for unplanned Returns.
7	SRTN_RTNMN_STK_RETURN_HDR	This table has the details of all kinds of returns - Inventory, Maintenance and Unplanned Returns..
8	SRTN_URTDTL_UPL_STKRTN_DTL	This will have the returned part details of the Return Document. Note: Issue details will be NULL for unplanned Returns
9	SRTN_WOCOST_SUMMARY	Table to maintain the Work order summary information
10	SRTN_WOCOST_SUMMARY_MIGRATION	Table to maintain the Work order summary Migration information

Table Name :	RTN_SRTNPRM_PARAMETER_DTL
Comment :	Stores meta data Parameter detail information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SRTNPRM_COMPONENTNAME	_varchar_20	varchar(20)	No	Component Code.	Yes
SRTNPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc..	Yes
SRTNPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows. .	Yes
SRTNPRM_PARAMCODE	_varchar_5	varchar(5)	No	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component. List of Codes & Description TLOG -- Techlog HWO -- Hangar Work Order MC -- Main Co	Yes
SRTNPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record..	Yes
SRTNPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Description of the Param Code.	No
SRTNPRM_SORT_BY	_decimal_10_0	decimal(10)	Yes	The order in which the values are populated..	No
SRTNPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	Date of Creation.	No

Table Name :	RTN_SRTNQC_QUICK_CODE
Comment :	this table used to store the quick code values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SRTNQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Quick Code OU.	Yes
SRTNQC_QUICK_CODE	_varchar_25	Varchar(25)	No	Quick Code Value	Yes
SRTNQC_TYPE	_varchar_25	Varchar(25)	No	the quick code type for which quick codes have to be defined. The system provides the option Return Category and Return User Status	Yes
SRTNQC_DESC	_varchar_80	varchar(80)	Yes	A textual description for the quick code	No
SRTNQC_STATUS	_varchar_20	varchar(20)	Yes	Status of the Quick Code. Will have Active and Inactive as Values.	No
SRTNQC_CREATEDDATE	_datetime_8	datetime(8)	Yes	Date on which Quick Code was created.	No
SRTNQC_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	User who has created the Quick Code.	No
SRTNQC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date on which Quick code was modified.	No
SRTNQC_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	User who has modified the quick code.	No
SRTNQC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	TimeStamp.	No

Table Name :	SRTN_OWNERSHIP_CHG_LOG
Comment :	To maintain the ownership change information on return

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTNO_RTN_NO	udd_documentno	varchar(40)	Yes	Return document Number	No
RTNO_RTN_OU	udd_ctxt_ouinstance	int(4)	Yes	Return document OU	No
RTNO_RTN_LINENO	udd_seqno	int(4)	Yes	Line Numer	No
RTNO_RTN_SRL_NO	udd_partserialnumber	varchar(40)	Yes	Return Serial Number	No
RTNO_RTN_MFRSRL_NO	udd_partserialnumber	varchar(40)	Yes	Return Manufacturer Serial Number	No
RTNO_RTN_LOT_NO	udd_lotno	varchar(18)	Yes	Return Lot Number	No
RTNO_RTN_MFRLOT_NO	udd_lotno	varchar(18)	Yes	Return Manufacturer Lot Number	No
RTNO_FRM_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	From Owing Agency	No
RTNO_TO_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	To Owing Agency	No
RTNO_DATE	udd_time	datetime(8)	Yes	Updated date	No

Table Name :	SRTN_RTNADL_STK_RETURN_ADL
Comment :	table which is used to store the storage information for the returned parts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTNADL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID of the Return transaction	Yes
RTNADL_RETURN_NO	_varchar_18	varchar(18)	No	System generated number for the Return transaction based on the Numbering Type choosen	Yes
RTNADL_RTN_SYSLINE_NO	_decimal_10_0	decimal(10)	No	Line no generated for each part return instance of the return document	Yes
RTNADL_SEQ_NO	_decimal_10_0	decimal(10)	No	Seqno is the unique number generated for each return at zone-bin level for the ReturnDoc-LineNo combination	Yes
RTNADL_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone Id to where the Part is getting returned	No
RTNADL_BIN_ID	_varchar_10	varchar(10)	Yes	Zone-Bin Id to where the part is getting returned This will be NULL if the Zone is a free Zone	No
RTNADL_RET_QTY	_decimal_28_8	decimal(28)	Yes	Quantity that is getting returned to the Zone or Zone-bin	No
RTNADL_RET_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Quantity returned (in stock uom) to the Zone or Zone-bin	No
RTNADL_RTN_COST	_decimal_28_8	decimal(28)	Yes	Return Cost at Wh-Zone-Bin level	No
RTNADL_ISSUE_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Issue Quantity in Stock uom at the time of Return document creation	No
RTNADL_ISSUE_COST	_decimal_28_8	decimal(28)	Yes	Issue Cost for the Issued quantity	No
RTNADL_ISS_COMPUTED_COST	_decimal_28_8	decimal(28)	Yes	issued part rate	No
RTNADL_ISS_COMPUTED_DATE	_datetime_8	datetime(8)	Yes	date on which issued part rate is getting calculated	No
RTNADL_PART_COST	udd_amount	numeric(13)	Yes	Part Cost	No

Table Name :	SRTN_RTNDA_DOC_ATTACH_DTL
Comment :	This table allows you to store the reference information for the return.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTNDA_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU	Yes
RTNDA_RETURN_NO	_varchar_40	varchar(40)	No	Return Number	Yes
RTNDA_REF_DOC_TYPE	_varchar_15	varchar(15)	No	Reference Document Type	Yes
RTNDA_DOC_ID	udd_documentno	varchar(40)	No	Document ID	Yes
RTNDA_FILE_NAME	_varchar_50	varchar(50)	Yes	File Name	No
RTNDA_REMARKS	_varchar_255	varchar(255)	Yes	Unique Number	No

Table Name :	SRTN_RTNDTL_STK_RETURN_DTL
Comment :	This will have the returned part details of the Return Document. Note: Issue details will be NULL for unplanned Returns.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTNDTL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU	Yes
RTNDTL_RETURN_NO	_varchar_18	varchar(18)	No	Return Number	Yes
RTNDTL_RTN_SYSLINE_NO	_decimal_10_0	decimal(10)	No	System line number	Yes
RTNDTL_RTN_DISPLAYLINE_NO	_decimal_10_0	decimal(10)	Yes	Display Line Number.	No
RTNDTL_ISSUE_OU	_decimal_10_0	decimal(10)	Yes	Issued OU	No
RTNDTL_ISSUE_DOC_NO	_varchar_18	varchar(18)	Yes	Issued Document Number	No
RTNDTL_ISSUE_LINE_NO	_decimal_10_0	decimal(10)	Yes	Issued Line Number	No
RTNDTL_ISSUE_WH_OU	_decimal_10_0	decimal(10)	Yes	Issued Warehouse OU	No
RTNDTL_ISSUE_WH_ID	_varchar_10	varchar(10)	Yes	issued WareHouse ID	No
RTNDTL_ISSUE_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created OU	No
RTNDTL_ISSUE_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
RTNDTL_ISSUE_PART_STATUS	_varchar_40	varchar(40)	Yes	Part Status.	No
RTNDTL_ISSUE_SRL_NO	_varchar_40	varchar(40)	Yes	Issue Part Serial No. All planned returns are made either against the issue document or across issue doc at IssuedWarehouse-IssuePart-Srl-Lot level.	No
RTNDTL_ISSUE_LOT_NO	_varchar_18	varchar(18)	Yes	Issue Part Lot No. All planned returns are made either against the issue document or across issue doc at IssuedWarehouse-IssuePart-Srl-Lot level.	No
RTNDTL_RETURN_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Created OU Id of the Return Part No.	No
RTNDTL_RETURN_PART_NO	_varchar_40	varchar(40)	Yes	The part number of the returned part.	No
RTNDTL_RETURN_QTY	_decimal_28_8	decimal(28)	Yes	The quantity of parts returned.	No
RTNDTL_RETURN_UOM	_varchar_10	varchar(10)	Yes	Uom of the quantity returned.	No
RTNDTL_RETURNED_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Quantity returned in stock uom.	No
RTNDTL_ISSUE_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Issue Quantity in Stock uom at the time of Return document creation.	No
RTNDTL_ISSUE_COST	_decimal_28_8	decimal(28)	Yes	Issue Cost for the Issued quantity.	No
RTNDTL_PART_CONDITION	_varchar_25	Varchar(25)	Yes	Condition of the part at the time of return.	No
RTNDTL_PART_STATUS	_varchar_40	varchar(40)	Yes	Status of the returned part at the time of return.	No
RTNDTL_LOT_NO	_varchar_18	varchar(18)	Yes	Returned Part Lot No.	No
RTNDTL_NEW_LOT_NO	_varchar_40	varchar(40)	Yes	System Generated Lot Number(after confirmation of Return Document).	No
RTNDTL_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number of Part involved in the Return Document(if any).	No
RTNDTL_RETURN_BASIS	_varchar_25	Varchar(25)	Yes	Returns can be done on the following basis (1) Core - Cr - When the returned part is different from that of the issued part, the return will be considered to be core returnable provided the p	No
RTNDTL_EXPIRY_DATE	_datetime_8	datetime(8)	Yes	The date of expiry of the part being returned	No
RTNDTL_ACC_USAGE	_varchar_20	varchar(20)	Yes	The type of the accounting usage.	No
RTNDTL_CC_USAGE	_varchar_20	varchar(20)	Yes	The type of the costing usage.	No
RTNDTL_FIN_BOOK	_varchar_20	varchar(20)	Yes	Finance Book.	No
RTNDTL_ACC_CODE	_varchar_32	varchar(32)	Yes	Accounting Code.	No
RTNDTL_ANLY_CODE	_varchar_5	varchar(5)	Yes	Analysis Code.	No
RTNDTL_SUBANLY_CODE	_varchar_5	varchar(5)	Yes	Sub Analysis Code.	No
RTNDTL_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	Cost Center Code.	No
RTNDTL_CREATED_BY	_varchar_30	varchar(30)	Yes	The name of the user who created the return document.	No
RTNDTL_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the return document was created.	No
RTNDTL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The name of the user who last modified the return document.	No
RTNDTL_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the return document was last modified.	No
RTNDTL_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Integer Timestamp which is maintained for concurrency.	No
RTNDTL_RTN_COST	_decimal_28_8	decimal(28)	Yes	Cost of the Part returned.	No
RTNDTL_REFERENCE_NO	_varchar_40	varchar(40)	Yes	The code identifying the reference document associated with the stock return document.	No
RTNDTL_REMARKS	_varchar_255	varchar(255)	Yes	Textual description of the comments.	No
RTNDTL_TASK_NO	_varchar_40	varchar(40)	Yes	The task associated with the work order for every part returned, if the reference document type is "Component Work Order".	No
RTNDTL_TASK_SEQ_NO	_decimal_12_0	decimal(12)	Yes	This field pertains to Task Serial Number.	No
RTNDTL_MAT_TYPE	_varchar_5	varchar(5)	Yes	The material type, which could be "Main Core" or "Regular".	No
RTNDTL_OWNERSHIP	_varchar_5	varchar(5)	Yes	The owner of the part, which could be "Customer", "Owned" or "Supplier".	No
RTNDTL_OWNINGAGENCY	_varchar_45	varchar(45)	Yes	The code identifying the agency that owns the part.	No
RTNDTL_OWNAGENCY_OU	_decimal_10_0	decimal(10)	Yes	The ou code identifying the agency that owns the part.	No
RTNDTL_NEW_PART_FLG	_varchar_5	varchar(5)	Yes	this is a flag which is used to identify whether new part has to be returned	No
RTNDTL_GEN_SERIAL_NO	_varchar_40	varchar(40)	Yes	part general serial no	No
RTNDTL_SERIAL_NO_PFX	_varchar_6	varchar(6)	Yes	serial no prefix	No
RTNDTL_SERIAL_NO_SFX	_varchar_6	varchar(6)	Yes	serial no suffix	No
RTNDTL_SERIAL_RUNNING_NO	_decimal_10_0	decimal(10)	Yes	Serial Running Number	No
RTNDTL_MCRTNPRTCHGDFLG	_varchar_5	varchar(5)	Yes	Flag	No
RTNADL_ISS_COMPUTED_COST	_decimal_28_8	decimal(28)	Yes	issued part rate	No
RTNADL_ISS_COMPUTED_DATE	_datetime_8	datetime(8)	Yes	date on which issued part rate is getting calculated	No
RTNADL_CERTDATE	udd_date	varchar(15)	Yes	The date on which the certificate was issued	No
RTNADL_CERTNO	udd_refdocno	varchar(40)	Yes	The number identifying the certificate.	No
RTNADL_CERTTYPE	udd_flag1	varchar(25)	Yes	The certificate type associated with the part.	No
RTNADL_RETLOTNOTYPE	udd_flag2	varchar(25)	Yes	The return lot type of the part.	No
RTNADL_MANUFLOTNO	udd_lotno	varchar(18)	Yes	A unique number identifying the lot number issued by the manufacturer.	No
RTNDTL_RETURN_CLS	udd_quickcode	varchar(25)	Yes	return classification	No
RTNDTL_OVERHAUL_VALUE	udd_amount	numeric(13)	Yes	Overhaul value	No
RTNDTL_LEADPARAM_VALUE	udd_amount	numeric(13)	Yes	LeadParam Value	No
RTNDTL_VARIABLE_VALUE	udd_amount	numeric(13)	Yes	Variable value	No
RTNDTL_TASK_PART_SEQ_NO	udd_seqno	int(4)	Yes	Task Part Sequence Number	No
RTNDTL_PART_COST	udd_amount	numeric(13)	Yes	Part Cost	No
RTNADL_MANUFSERIALNO	udd_partserialnumber	varchar(40)	Yes	To Store Manufacturer Serial No	No
RtnDtl_New_Serial_No	udd_partserialnumber	varchar(40)	Yes	To Store new serial no	No
RtnDtl_TaskNo_Editable_Flag	udd_designparamcode	varchar(5)	Yes	TaskNo Editable flag	No
RTNDTL_TO_PART_STATUS	udd_partstatus	varchar(40)	Yes	This column is used to store To Part Status	No
RTNDTL_SSC_NO	udd_documentno	varchar(40)	Yes	This column is used to save Stock Status conversion document	No
RTNDTL_SSC_LOT_NO	udd_lotno	varchar(18)	Yes	This column is used to save the newly Lot # generated	No
RTNDTL_EDITABLE_FLAG	udd_designparamcode	varchar(5)	Yes	Editable Flag	No
RTNDTL_FORCEPART_FLAG	udd_designparamcode	varchar(5)	Yes	Force flag part	No
RTNDTL_EXECTRANS_SEQNO	udd_seqno	int(4)	Yes	Sequence Number	No
RTNDTL_RETURN_STAGE	udd_designparamcode	varchar(5)	Yes	Return Stage	No
RTNDTL_CORE_FINAL_MOVEMENT	udd_txt255	varchar(255)	Yes	Core final Movement	No
RTNDTL_TASK_TRACKID	udd_unique_id	bigint(8)	Yes	Task track id	No
RTNDTL_REFDOC_UNIQUEID_LINK_NO	udd_unique_id	bigint(8)	Yes	Reference Document Unique ID Link Number	No
RTNDTL_REFDOC_UNIQUEID_DALINK_NO	udd_unique_id	bigint(8)	Yes	Reference Document Unique ID DALink Number	No
RTNDTL_ADL_REF_DOC_LINE_NO	udd_seqno	int(4)	Yes	Additional Reference document line Number	No
RTNDTL_CNTRLTYPE	udd_flag	varchar(25)	Yes	Part Control Type	No
RTNDTL_EX_SRC_UNIQUE_ID	udd_seqno	int(4)	Yes	Source Unique Id	No
RTNDTL_EXPENSETYPE	udd_flag	varchar(25)	Yes	Part Expense Type	No
RTNDTL_EXPENSING_POLICY	udd_designparamcode	varchar(5)	Yes	Part Expensing Policy	No
RTNDTL_ISSUEBASIS	udd_designparamcode	varchar(5)	Yes	Issue Basis	No
RTNDTL_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	To check Part is Out of Stock	No
RTNDTL_PARTTYPE	udd_parttype	varchar(25)	Yes	Part Type	No
RTNDTL_VALUATION_METHOD	udd_designparamcode	varchar(5)	Yes	Part Valuation Method	No
RTNDTL_WOCOST	udd_amount	numeric(13)	Yes	Work Order cost	No
RTNDTL_Scrap_NO	udd_documentno	varchar(40)	Yes	Scrap Number	No
RTNDTL_Scrap_LineNO	udd_rowno	int(4)	Yes	Scrap line Number	No
RTNDTL_PART_ACC_GRP	udd_customeraccountgroup	varchar(20)	Yes	PART ACCOUNT GROUP	No
RTNDTL_ADJ_ACT_COST	udd_flag	varchar(25)	Yes	ACTUAL COST	No
RTNDTL_LOT_NUMTYPE	udd_flag	varchar(25)	Yes	LOT NUMBERING TYPE	No
RTNDTL_SRL_NUMTYPE	udd_flag	varchar(25)	Yes	SERIAL NUMBERING TYPE	No
RTNDTL_SLNOLOGIC	udd_flag	varchar(25)	Yes	SERIAL NUMBER LOGIC	No
RTNDTL_TO_PART_TYPE	udd_parttype	varchar(25)	Yes	TO PART TYPE	No
RTNDTL_TO_CNTRLTYPE	udd_flag	varchar(25)	Yes	TO CONTROL TYPE	No
RTNDTL_TO_EXPENSETYPE	udd_flag	varchar(25)	Yes	TO EXPENSE TYPE	No
RTNDTL_TO_ISSUEBASIS	udd_designparamcode	varchar(5)	Yes	TO ISSUE BASIS	No
RTNDTL_TO_VALUATION_METHOD	udd_designparamcode	varchar(5)	Yes	TO VALUATION METHOD	No
RTNDTL_TO_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	TO NON STOCKABLLE FLAG	No
RTNDTL_TO_EXPENSING_POLICY	udd_designparamcode	varchar(5)	Yes	TO EXPENSING POLICY	No
RTNDTL_TO_PART_ACC_GRP	udd_customeraccountgroup	varchar(20)	Yes	TO PART ACCOUNT GROUP	No
RTNDTL_TO_ADJ_ACT_COST	udd_flag	varchar(25)	Yes	TO ACTUAL COST	No
RTNDTL_CURRENCY	udd_designparamcode	varchar(5)	Yes	CURRENCY	No
RTNDTL_CR_CORE_ID	bigint	Bigint(8)	Yes	Currency Core id	No

Table Name :	SRTN_RTNMN_STK_RETURN_HDR
Comment :	This table has the details of all kinds of returns - Inventory, Maintenance and Unplanned Returns..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RTNMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU ID of the Return transaction.	Yes
RTNMN_RETURN_NO	_varchar_18	varchar(18)	No	System generated number for the Return transaction based on the Numbering Type choosen.	Yes
RTNMN_RETURN_TYPE	_varchar_5	varchar(5)	Yes	This flag will indicate whether the Return document is against an inventory issue (inventory/unplanned issue) or maintenance issue or is an Unplanned Return This will have the following codes and values. Gen for General or Inventory Returns Mn	No
RTNMN_RETURN_STATUS	_varchar_5	varchar(5)	Yes	Following are be Return document status codes and their description. Draft - Drft Fresh - Frsh Cancelled - Canc Confirmed - Conf 1) Draft Whenever all details are not entered the transaction can be crea	No
RTNMN_CATEGORY	_varchar_25	Varchar(25)	Yes	User defined return categories.	No
RTNMN_USER_STATUS	_varchar_25	Varchar(25)	Yes	User defined statuses for the Return Document.	No
RTNMN_WAREHOUSE_OU	_int_0	int(0)	Yes	OU Id of the warehouse where the parts are returned..	No
RTNMN_WAREHOUSE	_varchar_10	varchar(10)	Yes	The warehouse to where the parts are returned.	No
RTNMN_RETURN_DATE	_datetime_8	datetime(8)	Yes	The date on which the parts are returned.	No
RTNMN_REF_DOC_TYPE	_varchar_10	varchar(10)	Yes	The type of the reference document. Tech Log - This indicates that a technical log has triggered the return document Component Work Order - This indicates that a component work order has triggered the return document. Return Slip - This	No
RTNMN_REF_DOC_OU	_int_0	int(0)	Yes	OU ID of the reference document no against which the return is made. .	No
RTNMN_REF_DOC_NO	_varchar_40	varchar(40)	Yes	A unique number identifying the reference document based on which this return is created	No
RTNMN_USER_DEF_1	_varchar_25	Varchar(25)	Yes	User-defined details of the parts returned.	No
RTNMN_USER_DEF_2	_varchar_25	Varchar(25)	Yes	User-defined details of the parts returned	No
RTNMN_REMARKS	_varchar_255	varchar(255)	Yes	Textual description of the comments.	No
RTNMN_RETURN_BY	_varchar_20	varchar(20)	Yes	The id of the person who returns the parts.	No
RTNMN_RETURN_BY_NAME	_varchar_150	varchar(150)	Yes	Name of the employee who returned the parts to inventory (just a reference name is captured if returned by code is not specified)	No
RTNMN_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	The name of the user who confirmed the return document.	No
RTNMN_CONFIRMED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the return document was confirmed.	No
RTNMN_RETURN_FLAG	_varchar_25	Varchar(25)	Yes	This indicates whether Return has been made at WorkOrder-Issue Doc Level or WorkOrder Level. The following will be the codes and values stored in this col Wo for WorkOrder based returns IsuWo for Issuwise return for the workorder	No
RTNMN_FILENAME	_varchar_50	varchar(50)	Yes	The file name of the reference document pertaining to the stock return.	No
RTNMN_ACC_USAGE	_varchar_20	varchar(20)	Yes	The type of the accounting usage.	No
RTMMN_OWNERSHIP_OU	_int_0	int(0)	Yes	ownership ou	No
RTNMN_OWNERSHIP	_varchar_40	varchar(40)	Yes	The owner of the part, which could be "Customer", "Owned" or "Supplier".	No
RTNMN_OWNERSHIP_CODE	_varchar_45	varchar(45)	Yes	The code identifying the agency that owns the part.	No
RTNMN_CC_USAGE	_varchar_20	varchar(20)	Yes	The type of the costing usage.	No
RTNMN_CREATED_BY	_varchar_30	varchar(30)	Yes	The name of the user who created the return document. .	No
RTNMN_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the return document was created.	No
RTNMN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The name of the user who last modified the return document.	No
RTNMN_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	The date on which the return document was last modified.	No
RTNMN_TIMESTAMP	_int_0	int(0)	Yes	Integer Timestamp which is maintained for concurrency.	No
RTNMN_TradingPartnerNo	udd_vendorcode	varchar(45)	Yes	The code identifying the trading partner.	No
RTNMN_TradingPartnerType	udd_flag2	varchar(25)	Yes	The type of the trading partner, which could be "Supplier" or "Customer".	No
RTNMN_TradingPartnerOU	udd_ctxt_ouinstance	int(4)	Yes	trading partner ou	No
RTNMN_AIRCRAFT_NO	udd_aircraftnumber	varchar(30)	Yes	Aircraft Number	No
RTNMN_COMP_ID	udd_componentid	varchar(90)	Yes	Component ID	No
RTNMN_ADL_REF_DOC_OU	ctxt_ouinstance	numeric(9)	Yes	Additional Reference document OU	No
RTNMN_ADL_REF_DOC_NO	udd_documentno	varchar(40)	Yes	Additional Reference document Number	No
RTNMN_ADL_REF_DOC_TYPE	udd_flag	varchar(25)	Yes	Additional Reference document Type	No
RTNMN_AUTOCONFIRM_FLAG	udd_designparamcode	varchar(5)	Yes	AUTO CONFIRM FLAG	No
RTNMN_RTN_FLWD_BY_ISU_FLAG	udd_designparamcode	varchar(5)	Yes	Return followed by issue flag	No
RTNMN_RTN_FLWD_BY_ISU_TYPE	udd_designparamcode	varchar(5)	Yes	Return followed by issue type	No

Table Name :	SRTN_URTDTL_UPL_STKRTN_DTL
Comment :	This will have the returned part details of the Return Document. Note: Issue details will be NULL for unplanned Returns

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
URTDTL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU	Yes
URTDTL_RETURN_NO	_varchar_18	varchar(18)	No	Return Number	Yes
URTDTL_RTN_SYSLINE_NO	_decimal_10_0	decimal(10)	No	System line number	Yes
URTDTL_RETURN_PART_CRT_OU	_decimal_10_0	decimal(10)	Yes	Part Created OU	No
URTDTL_RETURN_PART_NO	_varchar_40	varchar(40)	Yes	Returned Part No	No
URTDTL_RETURN_QTY	_decimal_28_8	decimal(28)	Yes	Qty returned	No
URTDTL_RETURN_UOM	_varchar_10	varchar(10)	Yes	Uom of the quantity returned	No
URTDTL_RETURNED_QTY_INSTKUOM	_decimal_28_8	decimal(28)	Yes	Quantity returned in stock uom	No
URTDTL_PART_CONDITION	_varchar_25	Varchar(25)	Yes	Condition of the part at the time of return	No
URTDTL_PART_STATUS	_varchar_25	Varchar(25)	Yes	Status of the returned part at the time of return	No
URTDTL_LOT_NO	_varchar_40	varchar(40)	Yes	Returned Part Lot No	No
URTDTL_NEW_LOT_NO	_varchar_40	varchar(40)	Yes	New Lot Number	No
URTDTL_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
URTDTL_RETURN_BASIS	_varchar_25	Varchar(25)	Yes	Returns can be done on the following basis (1) Core - Cr - When the returned part is different from that of the issued part, the return will be considered to be core returnable provided the p	No
URTDTL_RETURN_CONDITION	_varchar_25	Varchar(25)	Yes	Return Condition	No
URTDTL_ZONE_ID	_varchar_10	varchar(10)	Yes	Zone where the part is getting returned. This will be NULL for free warehouse	No
URTDTL_BIN_ID	_varchar_10	varchar(10)	Yes	Bin where the part is getting returned. This will be NULL for Free Zones	No
URTDTL_PART_VALUE	_decimal_28_8	decimal(28)	Yes	Part Value	No
URTDTL_EXPIRY_DATE	_datetime_8	datetime(8)	Yes	Expiry Date can be reset for the component while returning	No
URTDTL_ACC_USAGE	_varchar_20	varchar(20)	Yes	The type of the accounting usage.	No
URTDTL_CC_USAGE	_varchar_20	varchar(20)	Yes	The type of the costing usage	No
URTDTL_FIN_BOOK	_varchar_20	varchar(20)	Yes	Finance Book	No
URTDTL_ACC_CODE	_varchar_32	varchar(32)	Yes	Accounting Code	No
URTDTL_ANLY_CODE	_varchar_5	varchar(5)	Yes	Analysis Code	No
URTDTL_SUBANLY_CODE	_varchar_5	varchar(5)	Yes	Sub Analysis Code	No
URTDTL_COSTCENTER_CODE	_varchar_10	varchar(10)	Yes	Cost Center Code	No
URTDTL_CREATED_BY	_varchar_30	varchar(30)	Yes	Created Login User Name	No
URTDTL_CREATED_DATETIME	_datetime_8	datetime(8)	Yes	Created date and time	No
URTDTL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified login user name	No
URTDTL_MODIFIED_DATETIME	_datetime_8	datetime(8)	Yes	Last Modified date and time	No
URTDTL_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Integer Timestamp which is maintained for concurrency	No
URTDTL_REFERENCE_NO	_varchar_40	varchar(40)	Yes	Reference Number	No
URTDTL_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
URTDTL_OWNERSHIP	_varchar_5	varchar(5)	Yes	The owner of the part, which could be "Customer", "Owned" or "Supplier".	No
URTDTL_OWNINGAGENCY	_varchar_45	varchar(45)	Yes	The code identifying the agency that owns the part.	No
URTDTL_OWNAGENCY_OU	_decimal_10_0	decimal(10)	Yes	ou code (The code identifying the agency )	No
URTDTL_COMPUTED_VALUE	_decimal_28_8	decimal(28)	Yes	the cost of the returned part	No
URTDTL_COMPUTED_DATE	_datetime_8	datetime(8)	Yes	returned part cost calculated date	No
URTDTL_RETURN_CLS	udd_quickcode	varchar(25)	Yes	return classification	No
URTDTL_OVERHAUL_VALUE	udd_amount	numeric(13)	Yes	Overhaul value	No
URTDTL_LEADPARAM_VALUE	udd_amount	numeric(13)	Yes	LeadParam Value	No
URTDTL_VARIABLE_VALUE	udd_amount	numeric(13)	Yes	Variable value	No
URTDTL_TRAN_VALUE	udd_amount	numeric(13)	Yes	transaction value	No
URTDTL_CNTRLTYPE	udd_flag	varchar(25)	Yes	Part Control Type	No
URTDTL_EXPENSETYPE	udd_flag	varchar(25)	Yes	Part Expense Type	No
URTDTL_EXPENSING_POLICY	udd_designparamcode	varchar(5)	Yes	Part Expensing Policy	No
URTDTL_ISSUEBASIS	udd_designparamcode	varchar(5)	Yes	Issue Basis	No
URTDTL_NONSTOCKABLE_FLAG	udd_flag	varchar(25)	Yes	To check Part is Out of Stock	No
URTDTL_PARTTYPE	udd_parttype	varchar(25)	Yes	Part Type	No
URTDTL_VALUATION_METHOD	udd_designparamcode	varchar(5)	Yes	Part Valuation Method	No
URTDTL_CURRENCY	udd_currency	varchar(20)	Yes	currency	No

Table Name :	SRTN_WOCOST_SUMMARY
Comment :	Table to maintain the Work order summary information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	SRTN_WOCOST_SUMMARY_MIGRATION
Comment :	Table to maintain the Work order summary Migration information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?