| PRIMARY KEY |
|
A_Asset_ID
NUMBER (10, 0) NOT NULL |
| |
|
|
AD_Client_ID
NUMBER (10, 0) NOT NULL |
| |
|
AD_Org_ID
NUMBER (10, 0) NOT NULL |
| |
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL |
| |
|
Created
DATE default: SYSDATE NOT NULL |
| |
|
CreatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Updated
DATE default: SYSDATE NOT NULL |
| |
|
UpdatedBy
NUMBER (10, 0) NOT NULL |
| |
|
Value
NVARCHAR2 (40) NOT NULL |
| |
|
Name
NVARCHAR2 (60) NOT NULL |
| |
|
Description
NVARCHAR2 (255) |
| |
|
Help
NVARCHAR2 (2000) |
| |
|
A_Asset_Group_ID
NUMBER (10, 0) NOT NULL |
| A_Asset_Group |
|
M_Product_ID
NUMBER (10, 0) |
| M_Product |
|
M_AttributeSetInstance_ID
NUMBER (10, 0) |
| M_AttributeSetInstance |
|
SerNo
NVARCHAR2 (20) |
| |
|
Lot
NVARCHAR2 (20) |
| |
|
VersionNo
NVARCHAR2 (20) |
| |
|
GuaranteeDate
DATE |
Guarantee Valid Unyil
| |
|
AssetServiceDate
DATE |
Date Last Serviced
| |
|
IsOwned
CHAR (1) default: 'Y' CHECK ( IsOwned in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsDepreciated
CHAR (1) default: 'Y' CHECK ( IsDepreciated in ( 'Y' , 'N' )) NOT NULL |
| |
|
IsFullyDepreciated
CHAR (1) default: 'N' CHECK ( IsFullyDepreciated in ( 'Y' , 'N' )) NOT NULL |
| |
|
AssetDepreciationDate
DATE |
Date Last Depreciated
| |
|
UseLifeYears
NUMBER (10, 0) |
| |
|
UseLifeMonths
NUMBER (10, 0) |
| |
|
LifeUseUnits
NUMBER |
| |
|
UseUnits
NUMBER |
| |
|
IsDisposed
CHAR (1) default: 'N' CHECK ( IsDisposed in ( 'Y' , 'N' )) NOT NULL |
| |
|
AssetDisposalDate
DATE |
| |
|
IsInPosession
CHAR (1) default: 'Y' CHECK ( IsInPosession in ( 'Y' , 'N' )) NOT NULL |
| |
|
LocationComment
NVARCHAR2 (255) |
| |
|
M_Locator_ID
NUMBER (10, 0) |
| M_Locator |
|
C_BPartner_ID
NUMBER (10, 0) |
| C_BPartner |
|
C_BPartner_Location_ID
NUMBER (10, 0) |
| C_BPartner_Location |
|
C_Location_ID
NUMBER (10, 0) |
| C_Location |
|
Processing
CHAR (1) |
| |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
FOREIGN KEY
AAssetGroup_AAsset: A_Asset_Group_ID => A_Asset_Group
ADUser_AAsset: AD_User_ID => AD_User
CBPartner_AAsset: C_BPartner_ID => C_BPartner
CBPLocation_AAsset: C_BPartner_Location_ID => C_BPartner_Location
CLocation_AAsset: C_Location_ID => C_Location
MAttributeSetInstance_AAsset: M_AttributeSetInstance_ID => M_AttributeSetInstance
MLocator_AAsset: M_Locator_ID => M_Locator
MProduct_AAsset: M_Product_ID => M_Product
|
REFERENCED BY
A_Asset_Acct,
A_Asset_Addition,
A_Asset_Change,
A_Asset_Delivery,
A_Asset_Retirement,
A_Asset_Use,
A_Registration,
C_InvoiceLine,
Fact_Acct,
R_Request |
|