| PRIMARY KEY |
|
A_Asset_Change_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 |
| |
|
A_Asset_ID
NUMBER (10, 0) NOT NULL |
| A_Asset |
|
ChangeType
CHAR (1) NOT NULL |
| |
|
ChangeDate
DATE NOT NULL |
| |
|
ChangeAmt
NUMBER default: 0 |
| |
|
UseLifeYears
NUMBER (10, 0) |
| |
|
UseLifeMonths
NUMBER (10, 0) |
| |
|
LifeUseUnits
NUMBER |
| |
|
AssetDepreciationDate
DATE |
| |
|
A_Asset_Retirement_ID
NUMBER (10, 0) |
| A_Asset_Retirement |
|
A_Asset_Addition_ID
NUMBER (10, 0) |
| A_Asset_Addition |
|
SerNo
NVARCHAR2 (20) |
| |
|
Lot
NVARCHAR2 (20) |
| |
|
VersionNo
NVARCHAR2 (20) |
| |
FOREIGN KEY
AAAddition_AAChange: A_Asset_Addition_ID => A_Asset_Addition
AARetirement_AAChange: A_Asset_Retirement_ID => A_Asset_Retirement
AAsset_AAssetChange: A_Asset_ID => A_Asset
|
REFERENCED BY
A_Asset_Change_Amt |
|