Table erp.COMPIERE.A_ASSET

Generated by SchemaSpy

Implied relationships Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents A_ASSET_ID number 10 AD_ISSUE A_ASSET_ID AASSET_ADISSUE A_ASSET_ACCT A_ASSET_ID AASSET_AASSETACCT A_ASSET_ADDITION A_ASSET_ID AASSET_AASSETADDITION A_ASSET_CHANGE A_ASSET_ID AASSET_AASSETCHANGE A_ASSET_DELIVERY A_ASSET_ID AASSET_AASSETDELIVERY A_ASSET_RETIREMENT A_ASSET_ID AASSET_AASSETRETIREMENT A_ASSET_USE A_ASSET_ID AASSET_AASSETUSE A_REGISTRATION A_ASSET_ID AASSET_AREGISTRATION C_INVOICELINE A_ASSET_ID AASSET_CINVOICELINE FACT_ACCT A_ASSET_ID AASSET_FACTACCT M_OPERATIONRESOURCE A_ASSET_ID AASSET_MOPERATIONRESOURCE RV_ASSET_CUSTOMER A_ASSET_ID Implied Constraint RV_ASSET_DELIVERY A_ASSET_ID Implied Constraint RV_FACT_ACCT A_ASSET_ID Implied Constraint RV_FACT_ACCT_PERIOD A_ASSET_ID Implied Constraint R_ISSUEPROJECT A_ASSET_ID AASSET_RISSUEPROJECT R_ISSUESYSTEM A_ASSET_ID Implied Constraint R_REQUEST A_ASSET_ID AASSET_RREQUEST R_REQUESTACTION A_ASSET_ID AASSET_RREQUESTACTION T_TRIALBALANCE A_ASSET_ID Implied Constraint AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10 AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 VALUE nvarchar2 80 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null HELP nvarchar2 4000  √  null A_ASSET_GROUP_ID number 10 A_ASSET_GROUP A_ASSET_GROUP_ID AASSETGROUP_AASSET M_PRODUCT_ID number 10  √  null M_PRODUCT M_PRODUCT_ID MPRODUCT_AASSET SERNO nvarchar2 510  √  null LOT nvarchar2 510  √  null VERSIONNO nvarchar2 40  √  null GUARANTEEDATE date 7  √  null ASSETSERVICEDATE date 7  √  null ISOWNED char 1 'Y' ASSETDEPRECIATIONDATE date 7  √  null USELIFEYEARS number 10  √  null USELIFEMONTHS number 10  √  null LIFEUSEUNITS number 22  √  null USEUNITS number 22  √  null ISDISPOSED char 1 'N' ASSETDISPOSALDATE date 7  √  null ISINPOSESSION char 1 'Y' LOCATIONCOMMENT nvarchar2 510  √  null M_LOCATOR_ID number 10  √  null M_LOCATOR M_LOCATOR_ID MLOCATOR_AASSET C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_AASSET C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPLOCATION_AASSET C_LOCATION_ID number 10  √  null C_LOCATION C_LOCATION_ID CLOCATION_AASSET PROCESSING char 1  √  null ISDEPRECIATED char 1 'Y' ISFULLYDEPRECIATED char 1 'N' AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_AASSET M_ATTRIBUTESETINSTANCE_ID number 10  √  0 M_ATTRIBUTESETINSTANCE M_ATTRIBUTESETINSTANCE_ID MATTRIBUTESETINSTANCE_AASSET QTY number 22  √  null C_PROJECT_ID number 10  √  null C_PROJECT C_PROJECT_ID Implied Constraint C_BPARTNERSR_ID number 10  √  null M_INOUTLINE_ID number 10  √  null M_INOUTLINE M_INOUTLINE_ID Implied Constraint LASTMAINTENENCEDATE date 7  √  null NEXTMAINTENENCEDATE date 7  √  NULL LASTMAINTENANCEUSEUNIT number 10  √  null NEXTMAINTENANCEUSEUNIT number 10  √  null LEASETERMINATIONDATE date 7  √  NULL LEASE_BPARTNER_ID number 10  √  NULL LASTMAINTENANCENOTE nvarchar2 120  √  NULL LASTMAINTENANCEDATE date 7  √  NULL LASTMAINTENANCEUNIT number 10  √  NULL NEXTMAINTENENCEUNIT number 10  √  NULL Table contained 0 rows at Wed Mar 15 18:14 SAST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.