rv_cof_detailassetmaintain

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
documentno varchar 30 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
datetrx timestamp 29,6 √ null
ad_user_id numeric 10 √ null
description varchar 255 √ null
docstatus varchar 2 √ null
processed bpchar 1 √ null
a_asset_id numeric 10 √ null
a_asset.a_asset_id Implied Constraint R
a_asset_group_id numeric 10 √ null
a_asset_group.a_asset_group_id Implied Constraint R
mp_ot_request_id numeric 10 √ null
mp_ot_request.mp_ot_request_id Implied Constraint R
ot_request_type varchar 2 √ null
seqno numeric 10 √ null
ottdescription varchar 255 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
duration numeric 0 √ null
status varchar 2 √ null
resourcetype varchar 2 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
s_resource_id numeric 10 √ null
s_resource.s_resource_id Implied Constraint R
resourceqty numeric 0 √ null
costamt numeric 0 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views