Table Reports : Table/Owner (returnslip.ER1, Wednesday, March 14, 2007 08:12:28, 108 rows)

Table/Owner

Table Owner Table Name Table Comment Table Column Name Table Column Datatype Table Column Comment Table Column Is PK Table Column Is FK

dbo RTS_PARAMETER_DETAILS RTS_COMPONENT_NAME varchar(20) Yes No

RTS_PARAM_CAT varchar(40)

RTS_PARAM_TYPE

RTS_PARAM_CODE varchar(5)

RTS_PARAM_DESC varchar(80) No

RTS_LANGID decimal(10)

RTS_PREFIX_SORT_BY

rts_retslp_ref_docs_det This table is to store the Reference Document(VP/WO/Task Seq) for each Return Slip Line item. rtsrd_ouinstance numeric(10) OU Instance Yes

rtsrd_returnslipno varchar(40) Return Slip #

rtsrd_lineno numeric(10) Return Slip Line No

rtsrd_visitpackno varchar(40) Visit Package #

rtsrd_workorderno Work Order #(If Reference is Visit Package then Work Order # will be ##)

rtsrd_seqno numeric(10) Task Seq #(If Reference is Visit Package or Work Order, then this will be 0)

rtsrd_refdoctype varchar(6) Reference Document type for the RS Line # T - Task HWO - Hangar Work Order VP - Visit Package No

rtsrd_workcenterno varchar(30) Work Center of the Reference Document

rtsrd_uom varchar(10) UOM

rtsrd_issuedqty numeric(28,8) Issued Quantity

rtsrd_returnedqty Returned Quantity for this RS line # - Reference Document)

rtsrd_pendretqty Pending Return Quantity at the time of creation of Return Slip

rts_rsfin_finance_info This table holds the information required for financial postings rsfin_ouinstance decimal(28,8) OUinstance Yes Yes

rsfin_return_slip_no varchar(40) Rteurn Slip Number

rsfin_line_no numeric(10) Return Slip Line # No

rsfin_fin_book_id varchar(20) finance book id No

rsfin_tran_type varchar(25) transaction type

rsfin_bu_code varchar(20) Business unit code

rsfin_company_code varchar(10) Company Code

rsfin_erate_type varchar(80) Erate Type

rsfin_parallel_base_cerate numeric(28,8) Base Cerate

rsfin_base_currency varchar(5) Base currency

rsfin_parallel_base_currency Base Currency

rsfin_con_cosr_acc_code varchar(32) Code

rsfin_con_cosr_cntacc_type varchar(40) Account Type

rsfin_con_cosr_aptacc_type

rsfin_con_cosr_anal_code varchar(5) Anal Code

rsfin_con_cosr_sub_anal_code Sub Anal Code

rsfin_WIPSusp_acc_Code varchar(32) Account Code

rsfin_WIPSusp_CntAc_Type varchar(40) Account Type

rsfin_WIPSusp_aptacc_Type

rsfin_WIPSusp_anal_Code varchar(5) Anal Code

rsfin_WIPSusp_Sub_anal_Code Sub_anal_code

rsfin_WIPSusp_acc_curr currency

rsfin_ref_docno varchar(40) Reference Document for this RS

rsfin_ref_doctype varchar(25) Reference Document Type

rsfin_parttype Part Type

rsfin_partno varchar(40) Part #

rsfin_account_type varchar(25) Account Type

rsfin_account_code varchar(32) Account Code

rsfin_serial_no numeric(10) Serial #

rsfin_prt_quantity numeric(28,8) part Quantity

rsfin_costcenter_code varchar(10) Cost Center Code

rsfin_prt_ret_value numeric(28,8) Part Return Value

rsfin_analysis_code varchar(5) Analysis Code

rsfin_subanalysis_code Sub Analysis Code

rts_rtsdet_return_slip_det This table holds information about return slip details rtsdet_ouinstance numeric(10) Ouinstance Yes Yes

rtsdet_return_slip_no varchar(40) Return Slip No

rtsdet_Line_No numeric(10) Line no No

rtsdet_issue_part_no varchar(40) Issue part no No

rtsdet_issue_part_ou numeric(10) Issue part ou

rtsdet_issue_quantity numeric(28,8) Issue_quantity

rtsdet_issue_uom varchar(10) Issue_Uom

rtsdet_return_part_no varchar(40) Return Part no

rtsdet_return_part_ou numeric(10) Return part ou

rtsdet_return_quantity numeric(28,8) Return quantity

rtsdet_return_wh_code varchar(10) wh_code

rtsdet_return_type varchar(25) return_type RTN Returnable NORTN Non-Returnable CORE Core Returnable EXS Excess

rtsdet_returned_value numeric(28,8) Returned_value

rtsdet_ret_qty_in_stk_uom Qty _in_stock_uom

rtsdet_issue_stk_status varchar(40) Issue stock status

rtsdet_return_stk_status Return stock status. It is taken from udss component

rtsdet_issue_wh_code varchar(10) Issue_wh_code

RTSDET_ACC_USAGE varchar(20) account usuage

RTSDET_CC_USAGE cc usuage

rtsdet_addlpartflag varchar(5) Additional Part Flag. For Additional Part reported this flag will be Y for Normal parts this will be N

rts_rtshdr_return_slip_hdr This table holds information about return slip header rtshdr_ouinstance numeric(10) OUinstance Yes

rtshdr_return_slip_no varchar(40) Rteurn Slip Number

RTSHDR_RETURN_TYPE varchar(25) Return type RTN Returnable NORTN Non-Returnable CORE Core Returnable EXS Excess No

RTSHDR_PART_TYPE Part type B Blank CM Component CNSMB Consumable KIT Kit RWMTR Raw Material SP Expendable TOOL Tool MISC Miscellaneous

rtshdr_num_type_no varchar(5) Numbering type number used to generate the document number

rtshdr_work_centre varchar(30) work center

RTSHDR_WARE_HOUSE varchar(10) ware_house

rtshdr_status varchar(15) status of the return slip

rtshdr_ref_doc_type varchar(25) Reference Document Type VP Visit Package HWO Hangar Work Order

rtshdr_comments varchar(150) comments

rtshdr_created_by varchar(30) created by

rtshdr_createddate datetime created date

rtshdr_modified_by varchar(30) modified by

rtshdr_modifieddate datetime modified date

rtshdr_approved_by varchar(30) approved by

RTSHDR_APPROVEDDATE datetime approved date

rtshdr_returned_by varchar(30) returned by

rtshdr_returneddate datetime returned date

rtshdr_timestamp numeric(10) timestamp

RTSHDR_WH_OU Warehouse ou

RTSHDR_REMARKS varchar(255) Remarks

rtshdr_multiple_rd_flag varchar(5) This is the flag for Multiline Reference document. This flag will be Y, if the return slip is created with Multiple reference document.

rts_rtslot_return_slip_lot This table holds information about Return Slip Lot rtslot_Line_No numeric(10) Line no Yes Yes

rtslot_ouinstance Ouinstance

rtslot_return_slip_no varchar(40) Return slip no

RTSLOT_LINENO numeric(10) line no No

rtslot_return_part_no varchar(40) return part no

rtslot_return_serial_no return serial no

rtslot_return_lot_no varchar(18) return lot numbet

rtslot_issue_part_no varchar(40) issue part no No

rtslot_issue_serial_no issue serial no

rtslot_issue_lot_no varchar(18) issue lot no

rtslot_stock_status varchar(40) It is taken from UDSS component

RTSLOT_RETURN_QUANTITY numeric(28,8) return quantity

RTSLOT_RETURN_COST return cost

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	RTS_PARAMETER_DETAILS		RTS_COMPONENT_NAME	varchar(20)		Yes	No
			RTS_PARAM_CAT	varchar(40)
			RTS_PARAM_TYPE
			RTS_PARAM_CODE	varchar(5)
			RTS_PARAM_DESC	varchar(80)		No
			RTS_LANGID	decimal(10)
			RTS_PREFIX_SORT_BY
	rts_retslp_ref_docs_det	This table is to store the Reference Document(VP/WO/Task Seq) for each Return Slip Line item.	rtsrd_ouinstance	numeric(10)	OU Instance	Yes
			rtsrd_returnslipno	varchar(40)	Return Slip #
			rtsrd_lineno	numeric(10)	Return Slip Line No
			rtsrd_visitpackno	varchar(40)	Visit Package #
			rtsrd_workorderno		Work Order #(If Reference is Visit Package then Work Order # will be ##)
			rtsrd_seqno	numeric(10)	Task Seq #(If Reference is Visit Package or Work Order, then this will be 0)
			rtsrd_refdoctype	varchar(6)	Reference Document type for the RS Line # T - Task HWO - Hangar Work Order VP - Visit Package	No
			rtsrd_workcenterno	varchar(30)	Work Center of the Reference Document
			rtsrd_uom	varchar(10)	UOM
			rtsrd_issuedqty	numeric(28,8)	Issued Quantity
			rtsrd_returnedqty		Returned Quantity for this RS line # - Reference Document)
			rtsrd_pendretqty		Pending Return Quantity at the time of creation of Return Slip
	rts_rsfin_finance_info	This table holds the information required for financial postings	rsfin_ouinstance	decimal(28,8)	OUinstance	Yes	Yes
			rsfin_return_slip_no	varchar(40)	Rteurn Slip Number
			rsfin_line_no	numeric(10)	Return Slip Line #		No
			rsfin_fin_book_id	varchar(20)	finance book id	No
			rsfin_tran_type	varchar(25)	transaction type
			rsfin_bu_code	varchar(20)	Business unit code
			rsfin_company_code	varchar(10)	Company Code
			rsfin_erate_type	varchar(80)	Erate Type
			rsfin_parallel_base_cerate	numeric(28,8)	Base Cerate
			rsfin_base_currency	varchar(5)	Base currency
			rsfin_parallel_base_currency		Base Currency
			rsfin_con_cosr_acc_code	varchar(32)	Code
			rsfin_con_cosr_cntacc_type	varchar(40)	Account Type
			rsfin_con_cosr_aptacc_type
			rsfin_con_cosr_anal_code	varchar(5)	Anal Code
			rsfin_con_cosr_sub_anal_code		Sub Anal Code
			rsfin_WIPSusp_acc_Code	varchar(32)	Account Code
			rsfin_WIPSusp_CntAc_Type	varchar(40)	Account Type
			rsfin_WIPSusp_aptacc_Type
			rsfin_WIPSusp_anal_Code	varchar(5)	Anal Code
			rsfin_WIPSusp_Sub_anal_Code		Sub_anal_code
			rsfin_WIPSusp_acc_curr		currency
			rsfin_ref_docno	varchar(40)	Reference Document for this RS
			rsfin_ref_doctype	varchar(25)	Reference Document Type
			rsfin_parttype		Part Type
			rsfin_partno	varchar(40)	Part #
			rsfin_account_type	varchar(25)	Account Type
			rsfin_account_code	varchar(32)	Account Code
			rsfin_serial_no	numeric(10)	Serial #
			rsfin_prt_quantity	numeric(28,8)	part Quantity
			rsfin_costcenter_code	varchar(10)	Cost Center Code
			rsfin_prt_ret_value	numeric(28,8)	Part Return Value
			rsfin_analysis_code	varchar(5)	Analysis Code
			rsfin_subanalysis_code		Sub Analysis Code
	rts_rtsdet_return_slip_det	This table holds information about return slip details	rtsdet_ouinstance	numeric(10)	Ouinstance	Yes	Yes
			rtsdet_return_slip_no	varchar(40)	Return Slip No
			rtsdet_Line_No	numeric(10)	Line no		No
			rtsdet_issue_part_no	varchar(40)	Issue part no	No
			rtsdet_issue_part_ou	numeric(10)	Issue part ou
			rtsdet_issue_quantity	numeric(28,8)	Issue_quantity
			rtsdet_issue_uom	varchar(10)	Issue_Uom
			rtsdet_return_part_no	varchar(40)	Return Part no
			rtsdet_return_part_ou	numeric(10)	Return part ou
			rtsdet_return_quantity	numeric(28,8)	Return quantity
			rtsdet_return_wh_code	varchar(10)	wh_code
			rtsdet_return_type	varchar(25)	return_type RTN Returnable NORTN Non-Returnable CORE Core Returnable EXS Excess
			rtsdet_returned_value	numeric(28,8)	Returned_value
			rtsdet_ret_qty_in_stk_uom		Qty _in_stock_uom
			rtsdet_issue_stk_status	varchar(40)	Issue stock status
			rtsdet_return_stk_status		Return stock status. It is taken from udss component
			rtsdet_issue_wh_code	varchar(10)	Issue_wh_code
			RTSDET_ACC_USAGE	varchar(20)	account usuage
			RTSDET_CC_USAGE		cc usuage
			rtsdet_addlpartflag	varchar(5)	Additional Part Flag. For Additional Part reported this flag will be Y for Normal parts this will be N
	rts_rtshdr_return_slip_hdr	This table holds information about return slip header	rtshdr_ouinstance	numeric(10)	OUinstance	Yes
			rtshdr_return_slip_no	varchar(40)	Rteurn Slip Number
			RTSHDR_RETURN_TYPE	varchar(25)	Return type RTN Returnable NORTN Non-Returnable CORE Core Returnable EXS Excess	No
			RTSHDR_PART_TYPE		Part type B Blank CM Component CNSMB Consumable KIT Kit RWMTR Raw Material SP Expendable TOOL Tool MISC Miscellaneous
			rtshdr_num_type_no	varchar(5)	Numbering type number used to generate the document number
			rtshdr_work_centre	varchar(30)	work center
			RTSHDR_WARE_HOUSE	varchar(10)	ware_house
			rtshdr_status	varchar(15)	status of the return slip
			rtshdr_ref_doc_type	varchar(25)	Reference Document Type VP Visit Package HWO Hangar Work Order
			rtshdr_comments	varchar(150)	comments
			rtshdr_created_by	varchar(30)	created by
			rtshdr_createddate	datetime	created date
			rtshdr_modified_by	varchar(30)	modified by
			rtshdr_modifieddate	datetime	modified date
			rtshdr_approved_by	varchar(30)	approved by
			RTSHDR_APPROVEDDATE	datetime	approved date
			rtshdr_returned_by	varchar(30)	returned by
			rtshdr_returneddate	datetime	returned date
			rtshdr_timestamp	numeric(10)	timestamp
			RTSHDR_WH_OU		Warehouse ou
			RTSHDR_REMARKS	varchar(255)	Remarks
			rtshdr_multiple_rd_flag	varchar(5)	This is the flag for Multiline Reference document. This flag will be Y, if the return slip is created with Multiple reference document.
	rts_rtslot_return_slip_lot	This table holds information about Return Slip Lot	rtslot_Line_No	numeric(10)	Line no	Yes	Yes
			rtslot_ouinstance		Ouinstance
			rtslot_return_slip_no	varchar(40)	Return slip no
			RTSLOT_LINENO	numeric(10)	line no		No
			rtslot_return_part_no	varchar(40)	return part no
			rtslot_return_serial_no		return serial no
			rtslot_return_lot_no	varchar(18)	return lot numbet
			rtslot_issue_part_no	varchar(40)	issue part no	No
			rtslot_issue_serial_no		issue serial no
			rtslot_issue_lot_no	varchar(18)	issue lot no
			rtslot_stock_status	varchar(40)	It is taken from UDSS component
			RTSLOT_RETURN_QUANTITY	numeric(28,8)	return quantity
			RTSLOT_RETURN_COST		return cost