|
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-Confirmed,RE-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 |
|
|