Asset Disposal

ADISP

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	adisp_accounting_info_dtl	This table will store all retire asset details will be stored.	timestamp	int	Time Stamp	No	No
			ou_id		Organization Unit Id
			tran_number	sql_variant	Transaction Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			currency		Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			account_type	sql_variant	Account Type
			ussage_id		Usage Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			newast_flag	sql_variant	newast flag
			modifieddate	datetime	Modified Date
			asset_class	sql_variant	asset class
	Adisp_APhOu_Ast_Phse_Out_TMP		APhOu_guid	sql_variant	Asset Phasing Out Guid
			APhOu_ou_id	int	Asset Phasing Out Organization Unit Id
			APhOu_tran_type	sql_variant	Asset Phasing Out Transaction Type
			APhOu_tran_number		Asset Phasing Out Transaction Number
			APhOu_tran_date	datetime	Asset Phasing Out Transaction Date
			APhOu_asset_number	sql_variant	Asset Phasing Out Asset Number
			APhOu_tag_number	int	Asset Phasing Out Tag Number
			APhOu_remarks	sql_variant	Asset Phasing Out Remarks
			APhOu_comments		Asset Phasing Out Comments
			APhOu_flag		Asset Phasing Out Flag
			APhOu_createdby		Asset Phasing Out Created By
			APhOu_createddate	datetime	Asset Phasing Out Created Date
			APhOu_modifiedby	sql_variant	Asset Phasing Out Modified By
			APhOu_modifieddate	datetime	Asset Phasing Out Modified Date
	adisp_interfb_rep_dtl	This table will store all Inter fb details will be stored.	timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			asset_desc		Asset Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			transfer_number		Transfer Number
			transfer_date	datetime	Transfer Date
			tag_cost	bigint	Tag Cost
			cum_depr_amount		Cumulative Depreciation Amount
			asset_book_value		Asset Book Value
			source_fb	sql_variant	Source Finance Book
			destination_fb		Destination Finance Book
			transfer_status		Transfer Status.Values TR-Transfered,IT-InTransfer,CM-Confirmed,RJ-Rejected,RV-Reversed,TO-Transfer Out
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_is_adepp_BkCode_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			asset_number		Asset Number
			tag_number	int	Tag Number
			process_date	datetime	Process Date
			fb_id	sql_variant	Finance Book Id
			asset_class		Asset Class
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			srno	int	Serial Number
			depr_procupto_date	datetime	Depreciation Process Up to Date
			depr_book_code	sql_variant	Depreciation Book Code
			depr_deprflag		Depreciation Flag
			SRLNO	int	Serial Number
	adisp_is_adepp_tmp		timestamp		Time Stamp
			guid	sql_variant	Guid
			asset_number		Asset Number
			tag_number	int	Tag Number
			process_date	datetime	Process Date
			fb_id	sql_variant	Finance Book Id
			asset_class		Asset Class
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			srno	int	Serial Number
			SRLNO
	adisp_is_ainq_tmp		timestamp		Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			component_id		Component Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			bu_id	sql_variant	Business Unit Id
			tran_number		Transaction Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			currency		Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			account_type	sql_variant	Account Type
			ussage_id		Usage Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_is_asset_tag_dtl	This table will store all retire asset tag &nbspdetails will be stored.	guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			fb_id	sql_variant	Finance Book Id
			timestamp	int	Time Stamp	No
			cap_number	sql_variant	Capitalization
			proposal_number		Proposal Number
			tag_status		Tag Status.Values FR-Fresh,AC-Active
			dest_fbid		Destination Finance Book Id
			transfer_date	datetime	Transfer Date
			asset_location	sql_variant	Asset Location
			cost_center		Cost Center
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_is_cdi_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			tran_type	sql_variant	Transaction Type
			tran_status		Transaction Status
			tran_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			asset_class		Asset Class
			customer_code		Customer Code
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			receipt_method	sql_variant	Receipt Method
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			fasusp_account	sql_variant	Fixed Asset Suspense Account
			proposal_number		Proposal Number
			remarks		Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_notes_dtl	This table will store all retire asset note &nbspdetails will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			notes_desc	sql_variant	Notes Description
			transfer_no		Transfer Number
			retirement_no		Retirement Number
			reversal_no		Reversal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_notes_dtl_his		timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			notes_desc	sql_variant	Notes Description
			transfer_no		Transfer Number
			retirement_no		Retirement Number
			reversal_no		Reversal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_notes_dtl_tmp		guid	sql_variant	Guid	Yes
			timestamp	int	Time Stamp	No
			notes_id	sql_variant	Notes Id
			notes_desc		Notes Description
			notes		Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_process_parameter_sys	This table will store all asset retire process parameter details will be stored.	ou_id	int	Organization Unit Id	Yes
			parameter_type	sql_variant	Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			timestamp	int	Time Stamp	No
			parameter_text	sql_variant	Parameter Text
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_ret_rep_dtl		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			tag_cost	bigint	Tag Cost
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			retirement_number		Retirement Number
			retirement_date	datetime	Retirement Date
			proposal_number	sql_variant	Proposal Number
			asset_book_value	bigint	Asset Book Value
			sale_value		Sale Value
			gain_loss		Gain Loss
			cum_depr		Cumulative Depreciation
			reval_cost		Revalue Cost
			reval_cum_depr		Revalue Cumulative Depreciation
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_retirement_dtl	This table will store all Retire asset &nbspdetails will be stored.	asset_number	sql_variant	Asset Number	Yes
			tag_number	int	Tag Number
			ou_id		Organization Unit Id
			retirement_number	sql_variant	Retirement Number
			timestamp	int	Time Stamp	No
			asset_location	sql_variant	Asset Location
			asset_class		Asset Class
			cost_center		Cost Center
			asset_cost	bigint	Asset Cost
			cum_depr_amount		Cumulative Depreciation Amount
			asset_book_value		Asset Book Value
			retirement_mode	sql_variant	Retirement Mode
			retirement_date	datetime	Retirement Date
			customer	sql_variant	Customer
			claim_insurance		Claim Insurance
			sale_value	bigint	Sale Value
			gain_loss		Gain Loss
			remarks	sql_variant	Remarks
			tag_status		Tag Status.Values -FR-Fresh,AC-Active
			reversal_number		Reversal Number
			reverse_remarks		Reverse Remarks
			invoice_number		Invoice Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_retirement_hdr		ou_id	int	Organization Unit Id	Yes
			retirement_number	sql_variant	Retirement Number
			timestamp	int	Time Stamp	No
			retirement_date	datetime	Retirement Date
			fb_id	sql_variant	Finance Book Id
			num_type		Numbering Type
			pay_category		Pay Category
			proposal_number		Proposal Number
			gen_auth_invoice		Generate Authorized Invoice
			retirement_status		Retirement Status.Values "RT-Retired"
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			currency_code	sql_variant	Currency Code
	adisp_retirement_tmp		guid		Guid
			ou_id	int	Organization Unit Id
			retirement_number	sql_variant	Retirement Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp
			asset_location	sql_variant	Asset Location
			asset_class		Asset Class
			cost_center		Cost Center
			asset_cost	bigint	Asset Cost
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			cum_depr_amount	bigint	Cumulative Depreciation Amount
			asset_book_value		Asset Book Value
			retirement_mode	sql_variant	Retirement Mode
			retirement_date	datetime	Retirement Date
			customer	sql_variant	Customer
			claim_insurance		Claim Insurance
			sale_value	bigint	Sale Value
			gain_loss		Gain Loss
			remarks	sql_variant	Remarks
			tag_status		Tag Status
			reversal_number		Reversal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			SRLNO	int	Serial Number
	adisp_reverse_ret_dtl	This table will store all Reverse retire asset &nbspdetails will be stored.	asset_number	sql_variant	Asset Number	Yes
			tag_number	int	Tag Number
			ou_id		Organization Unit Id
			reversal_number	sql_variant	Reversal Number
			timestamp	int	Time Stamp	No
			asset_location	sql_variant	Asset Location
			asset_class		Asset Class
			cost_center		Cost Center
			asset_cost	bigint	Cost Cost
			cum_depr_amount		Cumulative Depreciation Amount
			asset_book_value		Asset Book Value
			retirement_mode	sql_variant	Retirement Mode
			retirement_date	datetime	Retirement Date
			customer	sql_variant	Customer
			claim_insurance		Claim Insurance
			sale_value	bigint	Sale Value
			gain_loss		Gain Loss
			remarks	sql_variant	Remarks
			tag_status		Tag Status.Values FR-Fresh,AC-Active
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_reverse_ret_hdr		ou_id	int	Organization Unit	Yes
			reversal_number	sql_variant	Reversal Number
			timestamp	int	Time Stamp	No
			reversal_date	datetime	Reversal Date
			fb_id	sql_variant	Finance Book Id
			num_type		Numbering Type
			reversal_status		Reversal Status.Values "FR-Fresh"
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	adisp_rrt_rev_ret_tmp		ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			retirement_number	sql_variant	Retirement Number
			asset_location		Asset Location
			asset_class		Asset Class
			reversal_number		Reversal Number
			depr_book		Depreciation Book
			guid		Guid
	adisp_transfer_dtl	This table will store all Transfer asset details will be stored.	transfer_number		Transfer Number	Yes
			ou_id	int	Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			asset_grp	sql_variant	Asset Group
			asset_class		Asset Class
			asset_location		Asset Location
			cost_center		Cost Center
			asset_cost	bigint	Asset Cost
			cum_depr_amount		Cumulative Depreciation Amount
			asset_book_value		Asset Book Value
			remarks	sql_variant	Remarks
			receiving_location		Receiving Location
			receiving_cost_center		Receiving Cost Center
			receipt_remarks		Receipt Remarks
			transfer_status		Transfer Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			depr_category	sql_variant	depreciation category
			src_assetclass	sql_variant	Source asset class
			new_assetno	sql_variant	new asset number
			new_tagno	int	new tag number
	adisp_transfer_hdr		ou_id	int	Organization Unit Id	Yes
			transfer_number	sql_variant	Transfer Number
			timestamp	int	Time Stamp	No
			transfer_date	datetime	Transfer Date
			transfer_status	sql_variant	Transfer Status.values "TR-Transfered,IT-InTransfer,CM-Confirmed,RJ-Rejected,RV-Reversed,TO-Transfer Out".
			num_type		Numbering Type
			source_fb_id		Source Finance Book Id
			destination_fb_id		Destination Finance Book Id
			confirmation_date	datetime	Confirmation Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			transfer_type	sql_variant	Transfer Type
			modifieddate	datetime	Modified Date
	adisp_transfer_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			transfer_number	sql_variant	Transfer Number
			asset_number		Asset Number
			asset_desc		Asset Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			asset_grp		Asset Group
			asset_class		Asset Class
			asset_location		Asset Location
			cost_center		Cost Center
			asset_cost	bigint	Asset Cost
			cum_depr_amount		Cumulative Depreciation Amount
			asset_book_value		Asset Book Value
			remarks	sql_variant	Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	FAM_IS_BKUPD_TMP		guid	sql_variant	Guid
			asset_number		Asset Number
			tag_number		Tag Number
			retirement_date	datetime	Retirement Date
			status	sql_variant	Status

ADISP