a_asset

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_id numeric 10 null
a_asset.a_parent_asset_id aparentasset_aasset R
a_asset_acct.a_asset_id aasset_aassetacct C
a_asset_addition.a_asset_id aasset_aassetaddition R
a_asset_change.a_asset_id aasset_aassetchange R
a_asset_change.a_parent_asset_id aparentasset_aassetchange R
a_asset_delivery.a_asset_id aasset_aassetdelivery R
a_asset_disposed.a_asset_id aasset_aassetdisposed R
a_asset_disposed.a_asset_trade_id aassettrade_aassetdisposed R
a_asset_info_fin.a_asset_id aasset_aassetinfofin R
a_asset_info_ins.a_asset_id Implied Constraint R
a_asset_info_lic.a_asset_id aasset_aassetinfolic R
a_asset_info_oth.a_asset_id Implied Constraint R
a_asset_info_tax.a_asset_id Implied Constraint R
a_asset_product.a_asset_id aasset_aassetproduct R
a_asset_retirement.a_asset_id aasset_aassetretirement R
a_asset_reval.a_asset_id aasset_aassetreval R
a_asset_split.a_asset_id Implied Constraint R
a_asset_split.a_asset_id_to aassetid_aassetsplit R
a_asset_transfer.a_asset_id aasset_aassettransfer R
a_asset_use.a_asset_id aasset_aassetuse R
a_depreciation_build.a_end_asset_id aendasset_adepreciationbuild R
a_depreciation_build.a_start_asset_id astartasset_adepreciationbuild R
a_depreciation_exp.a_asset_id aasset_adepreciationexp R
a_depreciation_forecast.a_end_asset_id aendasset_adepreciationforecas R
a_depreciation_forecast.a_start_asset_id astartasset_adepreciationforec R
a_depreciation_workfile.a_asset_id aasset_adepreciationworkfile R
a_registration.a_asset_id aasset_aregistration R
ad_issue.a_asset_id aasset_adissue N
c_invoiceline.a_asset_id aasset_cinvoiceline R
c_orderline.a_asset_id aasset_corderline R
cof_equipments.a_asset_id aasset_cofequipments R
cof_ordemservico.a_asset_id aasset_cofordemservico N
cof_pp_ferramenta.a_asset_id aasset_cofppferramenta R
cof_pp_recursos.a_asset_id aasset_cofpprecursos N
cof_products.a_asset_id aasset_cofproducts R
cof_rv_contract.a_asset_id Implied Constraint R
cof_rv_detalhesordemservico.a_asset_id Implied Constraint R
cof_rv_detalhesordemservicoapontamento.a_asset_id Implied Constraint R
cof_rv_ordemservico.a_asset_id Implied Constraint R
cof_rv_requestpartner.a_asset_id Implied Constraint R
fact_acct.a_asset_id aasset_factacct R
gl_journalline.a_asset_id aasset_gljournalline R
i_asset.a_asset_id Implied Constraint R
i_fajournal.a_asset_id Implied Constraint R
i_fixedasset.a_asset_id aasset_ifixedasset R
m_operationresource.a_asset_id aasset_moperationresource R
mp_assetmeter.a_asset_id aasset_mpassetmeter R
mp_assetmeter_log.a_asset_id aasset_mpassetmeterlog N
mp_jobstandar.a_asset_id aasset_mpjobstandar R
mp_maintain.a_asset_id aasset_mpmaintain R
mp_ot.a_asset_id aasset_mpot R
mp_ot_request.a_asset_id aasset_mpotrequest R
mp_prognosis.a_asset_id aasset_mpprognosis R
pp_order_node_asset.a_asset_id aasset_ppordernodeasset R
pp_wf_node_asset.a_asset_id aasset_ppwfnodeasset R
r_issueproject.a_asset_id aasset_rissueproject R
r_issuesystem.a_asset_id aasset_rissuesystem R
r_request.a_asset_id aasset_rrequest R
r_request_v.a_asset_id Implied Constraint R
r_requestaction.a_asset_id aasset_rrequestaction R
rv_asset_customer.a_asset_id Implied Constraint R
rv_asset_delivery.a_asset_id Implied Constraint R
rv_asset_summonth.a_asset_id Implied Constraint R
rv_cof_detailassetmaintain.a_asset_id Implied Constraint R
rv_fact_acct.a_asset_id Implied Constraint R
rv_fact_acct_day.a_asset_id Implied Constraint R
rv_fact_acct_period.a_asset_id Implied Constraint R
t_invoicegl_v.a_asset_id Implied Constraint R
t_rv_reconciliation.a_asset_id Implied Constraint R
t_trialbalance.a_asset_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
a_asset_group_id numeric 10 null
a_asset_group.a_asset_group_id aassetgroup_aasset R
m_product_id numeric 10 null
m_product.m_product_id mproduct_aasset R
serno varchar 255 √ null
lot varchar 255 √ null
versionno varchar 20 √ null
guaranteedate timestamp 29,6 √ null
assetservicedate timestamp 29,6 √ null
isowned bpchar 1 'Y'::bpchar
assetdepreciationdate timestamp 29,6 √ null
uselifeyears numeric 0 √ null
uselifemonths numeric 10 √ null
lifeuseunits numeric 0 √ null
useunits numeric 0 √ null
isdisposed bpchar 1 'N'::bpchar
assetdisposaldate timestamp 29,6 √ null
isinposession bpchar 1 'Y'::bpchar
locationcomment varchar 255 √ null
m_locator_id numeric 10 √ null
m_locator.m_locator_id mlocator_aasset R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_aasset R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbplocation_aasset R
c_location_id numeric 10 √ null
c_location.c_location_id clocation_aasset R
processing bpchar 1 √ 'N'::bpchar
isdepreciated bpchar 1 'Y'::bpchar
isfullydepreciated bpchar 1 'N'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_aasset R
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_aasset R
qty numeric 0 √ null
c_project_id numeric 10 √ null
c_project.c_project_id cproject_aasset R
c_bpartnersr_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartnersr_aasset R
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_aasset R
lastmaintenencedate timestamp 29,6 √ null
nextmaintenencedate timestamp 29,6 √ null
lastmaintenanceuseunit numeric 10 √ null
nextmaintenanceuseunit numeric 10 √ null
leaseterminationdate timestamp 29,6 √ null
lease_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id leasebpartner_aasset R
lastmaintenancenote varchar 60 √ null
lastmaintenancedate timestamp 29,6 √ null
lastmaintenanceunit numeric 10 √ null
nextmaintenenceunit numeric 10 √ null
a_asset_createdate timestamp 29,6 √ null
a_asset_revaldate timestamp 29,6 √ null
a_parent_asset_id numeric 10 √ null
a_asset.a_asset_id aparentasset_aasset R
a_qty_current numeric 0 √ null
a_qty_original numeric 0 √ null
a_asset_uu varchar 36 √ NULL::character varying
a_asset_class_id numeric 10 √ NULL::numeric
a_asset_class.a_asset_class_id aassetclass_aasset R
a_asset_status varchar 2 'NW'::character varying
a_asset_action varchar 2 'MD'::character varying
processed bpchar 1 'N'::bpchar
assetactivationdate timestamp 29,6 √ null
inventoryno varchar 30 √ NULL::character varying
a_asset_type_id numeric 10 √ null
a_asset_type.a_asset_type_id aassettype_aasset R
a_assettype varchar 3 'MFX'::character varying
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_aasset R
manufacturer varchar 30 √ NULL::character varying
manufacturedyear numeric 10 √ '1900'::numeric

Indexes

Constraint Name Type Sort Column(s)
a_asset_pkey Primary key Asc a_asset_id
a_asset_uu_idx Must be unique Asc a_asset_uu

Check Constraints

Constraint Name Constraint
a_asset_isdisposed_check ((isdisposed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_isinposession_check ((isinposession = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_isowned_check ((isowned = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation