AINV

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	ainv_asset_cap_tmp		ou_id	int	Organization Unit Id	Yes	No
			asset_number	sql_variant	Asset Number
			timestamp	int	Time Stamp	No
			asset_description	sql_variant	Asset Description
			asset_tag_number	int	Asset Tag Number
			tag_description	sql_variant	Tag Description
			asset_loc_code		Asset Location Code
			inv_cycle		Invoice Cycle
			inv_due_date	datetime	Invoice Due Date
			asset_class_code	sql_variant	Asset Class Code
			asset_cost	bigint	Asset Cost
			cost_center	sql_variant	Cost Center
			bu_id		Business Unit Id
			asset_group_code		Asset Group Code
			asset_tag_status		Asset Tag Status
			asset_category		Asset Category
			inv_date	datetime	Invoice Date
			tag_status	sql_variant	Tag Status
			asset_value_type		Asset Value Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_asset_transfer_mst	This table will store all asset location details will be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			transfer_date	datetime	Transfer Date
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			recv_loc_code	sql_variant	Receiver Location Code
			recv_cost_center		Receiver Cost Code
			remarks		Remarks
			asset_loc_code		Asset Location Code
			cost_center		Cost Center
			asset_class_code		Asset Class Code
			asset_group_code		Asset Group Code
			asset_desc		Asset Description
			tag_desc		Tag Description
			confirm_reqd		Confirm Required
			confirm_date	datetime	Confirm Date
			confirm_status	sql_variant	Confirm Status.Values IT-Intransit,T-Transfered,R-Rejected.
			bu_id		Business Unit Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_barcode_tmp		ou_id	int	Organization Unit Id	Yes
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			bar_code	sql_variant	Bar Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_inventory_schedule_rpt	This table will store all asset inventory schedule details will be stored.	timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			inventory_sheet_no	sql_variant	Inventory Sheet Number
			sheet_date	datetime	Sheet Date
			inv_sheet_desc	sql_variant	Inventory Sheet Description
			inv_sheet_status		Inventory Sheet Status.Values OK-OK,DA-Damaged,MI-Missing,NW-Not Working,EX-Extra.
			asset_number		Asset Number
			asset_desc		Asset Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			asset_class		Asset Class
			asset_location		Asset Location
			asset_group		Asset Group
			fb_id		Finance Book Id
			cost_center		Cost Center
			tag_status		Tag Status.Values tag_status FR-Fresh,,FZ-Frozen,VE-Verified,CO-Confirmed,RE-Reconciled,CM-Complete
			inservice_date	datetime	Inservice Date
			transfer_date		Transfer Date
			inv_status	sql_variant	Invoice Status.Values OK-OK,DA-Damaged,MI-Missing,NW-Not Working,EX-Extra
			inv_result_remarks		Invoice Result Remarks
			recon_status		Reconcile Status.Values OK-OK,CL-Marked for Insurance Claim,TR-Marked for Transfer,RT-Marked for Retirement
			recon_remarks		Reconcile Remarks
			inv_due_date	datetime	Invoice Due Date
			inv_date		Invoice Date
			tag_cost	bigint	Tag Cost
			inv_cycle	sql_variant	Invoice Cycle
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_inventory_sheet_dtl	This table will store all asset inventory sheet details will be stored.	ou_id	int	Organization Unit Id	Yes
			inv_sheet_number	sql_variant	Invoice Sheet Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_loc_code		Asset Location Code
			inv_cycle		Invoice Cycle
			inv_due_date	datetime	Invoice Due Date
			asset_class_code	sql_variant	Asset Class Code
			asset_cost	bigint	Asset Cost
			cost_center	sql_variant	Cost Center
			bu_id		Business Unit Id
			asset_group_code		Asset Group Code
			asset_tag_status		Asset Tag Status.Values FR-Fresh,FZ-Frozen,VE-Verified,CO-ConfirmedRE-Reconciled,CM-Complete.
			inv_location		Invoice Location
			inv_date	datetime	Invoice Date
			inv_status	sql_variant	Invoice Status.Values OK-OK,DA-Damaged,MI-Missing,NW-Not Working,EX-Extra
			inv_result_remarks		Invoice Result Remarks
			recon_status		Reconcile Status.Values OK-OK,CL-Marked for Insurance Claim,TR-Marked for Transfer,RT-Marked for Retirement
			recon_remarks		Reconcile Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_inventory_sheet_hdr		ou_id	int	Organization Unit Id	Yes
			inv_sheet_number	sql_variant	Invoice Sheet Number
			timestamp	int	Time Stamp	No
			inv_sheet_desc	sql_variant	Invoice Sheet Description
			sheet_date	datetime	Sheet Date
			inv_sheet_status	sql_variant	Invoice Sheet Status.Values FR-Fresh,FZ-Frozen,VE-Verified,CO-ConfirmedRE-Reconciled,CM-Complete.
			numbering_typeno		Numbering Type Number
			createdby		Created By
			createddate	datetime	Create Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_inventory_sheet_hdr_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			inv_sheet_number	sql_variant	Invoice Sheet Number
			inv_sheet_desc		Invoice Sheet Description
			sheet_date	datetime	Sheet Date
			inv_sheet_status	sql_variant	Invoice Sheet Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_inventory_sheet_tmp		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
			inv_sheet_number	sql_variant	Invoice Sheet Number
			asset_desc		Asset Description
			tag_desc		Tag Description
			asset_loc_code		Asset Location Code
			inv_cycle		Invoice Cycle
			inv_due_date	datetime	Invoice Due Date
			asset_class_code	sql_variant	Asset Class Code
			asset_cost	bigint	Asset Cost
			cost_center	sql_variant	Cost Center
			bu_id		Business Unit Id
			asset_group_code		Asset Group Code
			asset_tag_status		Asset Tag Status
			inv_location		Invoice Location
			inv_date	datetime	Invoice Date
			inv_status	sql_variant	Invoice Status
			inv_result_remarks		Invoice Result Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_notes_dtl	This table will store all asset inventory sheet notes details will be stored.	timestamp	int	Time Stamp
			ouid		Organization Unit Id
			inventory_sheet_number	sql_variant	Inventory Sheet Number
			notes_desc		Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_notes_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			notes_id		Notes Id
			notes_desc		Notes Description
			notes		Notes
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_transfer_rpt	This table will store all asset inventory transfer 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_date	datetime	Transfer Date
			source_location	sql_variant	Source Location
			dest_location		Destination Location
			source_ccenter		Source Cost Center
			dest_ccenter		Destination Cost Center
			transfer_status		Transfer Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	ainv_updinvstatus_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			as_on_date	datetime	As On Date
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			tag_invstatus	sql_variant	Tag Invoice Status
			cost_center		Cost Center
			asset_location		Asset Location
			inv_cycle		Invoice Cycle
			inv_date	datetime	Invoice Date
			inv_duedate		Invoice Due Date
			dest_ouid	int	Destination Organization Unit Id
			dest_costcenter	sql_variant	Destination Cost Center
			dest_assetlocation		Destination Asset Location
			confirm_reqd		Confirmation Required
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			remarks	varchar(100)	Remarks