Projects:Assetsmanagement/Advanced Asset Management/Application Dictionary

Contents 1 New Columns in Existing Tabs 1.1 General Setup || Client || Information (Table: AD_Client_Info) 2 New Windows 2.1 Financial Management || Advanced Assets || Asset Card (Table: AAM_Asset_Card) 2.2 Financial Management || Advanced Assets || Asset Card || Asset (Table: AAM_ASSET) 2.3 Financial Management || Advanced Assets || Asset Card || Inventory (Table: AAM_INVENTORY) 2.4 Financial Management || Advanced Assets || Asset Card || Asset || Controlling (Table: AAM_CONTROLLING) 2.5 Financial Management || Advanced Assets || Asset Card || Asset || Accounting (Table: AAM_ASSET_ACCT) 2.6 Financial Management || Advanced Assets || Asset Card || Asset || Subsidy (Table: AAM_ASSETSUBSIDY) 2.7 Financial Management || Advanced Assets || Asset Card || Asset || Amortization (Table: AAM_AMORTIZATION) 2.8 Financial Management || Advanced Assets || Asset Class (Table: AAM_ASSETCLASS) 2.9 Financial Management || Advanced Assets || Asset Class || Accounting (Table: AAM_ASSETCLASS_ACCT) 2.10 Financial Management || Advanced Assets || Depreciation Method (Table: AAM_DEPRECIATIONMETHOD) 2.11 Financial Management || Advanced Assets || Depreciation Method || Depreciation Type (Table: AAM_DEPRECIATIONTYPE) 2.12 Financial Management || Advanced Assets || Depreciation Method || Depreciation Type || Depreciation Timing (Table: AAM_DEPRECIATIONTIMING) 2.13 Financial Management || Advanced Assets || Subsidy (Table: AAM_SUBSIDY) 2.14 Financial Management || Advanced Assets || To Do List (Table: AAM_TODOLIST) 2.15 Financial Management || Advanced Assets || Advanced Sequence (Table: AAM_SEQUENCE) 2.16 Financial Management || Advanced Assets || Advanced Sequence || Line (Table: AAM_SEQUENCELINE) 2.17 AAM_INVOICELINE_ASSETCARD 3 New Views 3.1 AAM_BOOKING_V

New Columns in Existing Tabs

General Setup || Client || Information (Table: AD_Client_Info)

Column	Name	Type	Field Group	More Options
EM_AAM_IsAutoInvNo	Automatic Inventory Number	YesNo
EM_AAM_InventoryLimit	Inventory Limit	Amount

Location: bottom of the window.

New Windows

Financial Management || Advanced Assets || Asset Card (Table: AAM_Asset_Card)

Column	Type	Name	Sequence Number	Options
AAM_Asset_Card_ID	ID	Asset Card	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
Name	String	No
Description	Text	Yes
AssetNo	String	Yes
InventoryNo	String	Yes

Financial Management || Advanced Assets || Asset Card || Asset (Table: AAM_ASSET)

Column	Type	Name	Sequence Number	Options
AAM_Asset_ID	ID	Asset	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_Asset_Card_ID	TableDir	No		Foreign key to AAM_Asset_Card.AAM_Asset_Card_ID
AAM_Asset_Class_ID	TableDir	No		Foreign key to AAM_Asset_Class.AAM_Asset_Class_ID
C_Currency_ID	TableDir	No		Foreign key to C_Currency.C_Currency_ID
Name	String	No
AssetNo	String	No
UseLifeYears	Amount	No
AmortizationValueAmt	Amount	No
DateCancelled	DateTime	Yes
ResidualAssetValueAmt	Amount	Yes
AnnualAmortizationPercentage	Amount	Yes
DatePurchased	DateTime	No
AmortizationStartDate	DateTime	No
AssetValueAmt	Amount	No
DepreciatedValue	Amount	No
DepreciatedPlan	Amount	No
AmortizationEndDate	DateTime	Yes
DepreciatedPreviousAmt	Amount	Yes
IsFullyDepreciated	YesNo	No
UseLifeMonths	Amount	No
Processed	YesNo	No	'N'
ParentView	char(60)	No	'N'
IsSummary	YesNo	No	'N'
MainAsset	TableDir	Yes		Foreign Key to AAM_Asset.AAM_Asset_ID
IsDepreciationRangeChanged	YesNo	'N'	No
HasSubsidy	YesNo	No	'N'
CommissioningDate	DateTime	Yes
OrganizationUnit	TableDir	Yes		Foreign Key to AD_Org.AD_Org_ID
OrgUnitRateOwner	TableDir	Yes		Foreign Key to AD_Org.AD_Org_ID
LastDepreciationDate	DateTime	Yes
CurrentTotalAmount	Amount	Yes

Financial Management || Advanced Assets || Asset Card || Inventory (Table: AAM_INVENTORY)

Column	Type	Name	Sequence Number	Options
AAM_Inventory_ID	ID	Inventory	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_AssetCard_ID	TableDir	No		Foreign key to AAM_AssetCard.AAM_AssetCard_ID
InventoryNo	String	No
Name	String	No
IsPrinted	YesNo	No	'N'
InventoryDate	DateTime	No
Status	char(60)	No
LocationBuilding	String	Yes
LocationFloor	String	Yes
LocationRoom	String	Yes
Factory	String	Yes
StockTakingDate1	DateTime	Yes
StockTakingDate2	DateTime	Yes
Labels	Amount	Yes
IsElectric	YesNo	No
Inspector	String	Yes
CheckDate1	DateTime	Yes
CheckDate2	DateTime	Yes
GuaranteeBegin	DateTime	Yes
GuaranteePeriod	String	Yes
GuaranteeEnd	DateTime	Yes
GuaranteeWarrantyBegin	DateTime	Yes
GuaranteeWarrantyPeriod	Amount	Yes
GuaranteeWarantyEnd	DateTime	Yes
MaintenanceContract	String	Yes
MaintenanceBegin	DateTime	Yes
MaintenanceInterval	String	Yes
MaintenancePeriodicalCost	String	Yes
InsuredAmt	Amount	Yes
PolicyNo	String	Yes
LeasingEnd	DateTime	Yes
Processed	YesNo	No

Financial Management || Advanced Assets || Asset Card || Asset || Controlling (Table: AAM_CONTROLLING)

Column	Type	Name	Sequence Number	Options
AAM_Controlling_ID	ID	Controlling	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_Asset_ID	TableDir	No		Foreign Key to AAM_Asset.AAM_Asset_ID
AAM_AssetClass_ID	TableDir	No		Foreign Key to AAM_AssetClass.AAM_AssetClass_ID
Name	String	No
IsSummary	YesNo	No	'N'
AAM_ParentAsset_ID	TableDir	Yes		Foreign key to AAM_Asset.AAM_Asset_ID
CurrentValue	Amount	No
DatePurchased	DateTime	Yes
ComissioningDate	DateTime	Yes
AmoritzationValueAmt	Amount	Yes
UseLifeMonths	Amount	Yes
UseLifeYears	Amount	Yes
DepreciationMethod	char(60)	Yes
DepreciationType	char(60)	Yes
DepreciationAccount_ID	TableDir	Yes		Foreign Key to C_ElementValue.C_ElementValue_ID
Processed	YesNo	No

Financial Management || Advanced Assets || Asset Card || Asset || Accounting (Table: AAM_ASSET_ACCT)

Column	Type	Name	Sequence Number	Options
AAM_ASSET_ACCT_ID	ID	Accounting	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_Asset_ID	TableDir	No		Foreign Key to AAM_Asset.AAM_Asset_ID
Name	String	No
AssetAccount_ID	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
AdjustmentAccount_ID	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
AccumulatedAdjustments_ID	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
CostFromAssetDisposal_ID	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
RevenueFromAssetDisposal_ID	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID

Financial Management || Advanced Assets || Asset Card || Asset || Subsidy (Table: AAM_ASSETSUBSIDY)

Column	Type	Name	Sequence Number	Options
AAM_AssetSubsidy_ID	ID	Subsidy	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_Subsidy_ID	TableDir	No		Foreign Key to AAM_Subsidy.AAM_Subsidy_ID
AAM_Asset_ID	TableDir	No		Foreign Key to AAM_Asset.AAM_Asset_ID
SubsidyDate	DateTime	No
SubsidyEntity	String	No
SubsidyPecentage	Amount	Yes
SubsidyAmt	Amount	Yes
DepreciationMethod	char(60)	No
DepreciationType	char(60)	No
DepreciationInterval	char(60)	No
CurrentValue	Amount	No
SubsidyAccount	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
AdjustmentAccount	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID

Financial Management || Advanced Assets || Asset Card || Asset || Amortization (Table: AAM_AMORTIZATION)

Column	Type	Name	Sequence Number	Options
AAM_Amortization_ID	ID	Amortization	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_Asset_ID	TableDir	No		Foreign Key to AAM_Asset.AAM_Asset_ID
C_Currency_ID	TableDir	No		Foreign Key to C_Currency.C_Currency_ID
Line	Amount	No
SeqNo	Amount	No
Percentage	Amount	No
Amount	Amount	No

Financial Management || Advanced Assets || Asset Class (Table: AAM_ASSETCLASS)

Column	Type	Name	Sequence Number	Options
AAM_AssetClass_ID	ID	Asset Class	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_DepreciationMethod_ID	TableDir	No		Foreign Key to AAM_DepreciationMethod.AAM_DepreciationMethod_ID
AAM_DepreciationType_ID	TableDir	No		Foreign Key to AAM_DepreciationType.AAM_DepreciationType_ID
AAM_DepreciationTimming_ID	TableDir	No		Foreign Key to AAM_DepreciationTimming_ID
Name	String	No
Description	Text	Yes
Help	Text	Yes

Financial Management || Advanced Assets || Asset Class || Accounting (Table: AAM_ASSETCLASS_ACCT)

Column	Type	Name	Sequence Number	Options
AAM_AssetClass_Acct_ID	ID	Accounting	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_AssetClass_ID	TableDir	No		Foreign Key to AAM_AssetClass.AAM_AssetClass_ID
AssetAccount_ID	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
AdjustmentAccount	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
AccumulatedAdjustments	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
CostFromAssetDisposal	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID
RevenueFromAssetDisposal	TableDir	No		Foreign Key to C_ElementValue.C_ElementValue_ID

Financial Management || Advanced Assets || Depreciation Method (Table: AAM_DEPRECIATIONMETHOD)

Column	Type	Name	Sequence Number	Options
AAM_DepreciationMethod_ID	ID	Depreciation Method	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
Name	String	No
Description	Text	Yes
Help	Text	Yes
JavaClass	Text	No

Financial Management || Advanced Assets || Depreciation Method || Depreciation Type (Table: AAM_DEPRECIATIONTYPE)

Column	Type	Name	Sequence Number	Options
AAM_DepreciationType_ID	ID	Depreciation Type	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_DepreciationMethod_ID	TableDir	No		Foreign Key to AAM_DepreciationMethod.AAM_DepreciationMethod_ID
Name	String	No
Description	Text	Yes
Help	Text	Yes

Financial Management || Advanced Assets || Depreciation Method || Depreciation Type || Depreciation Timing (Table: AAM_DEPRECIATIONTIMING)

Column	Type	Name	Sequence Number	Options
AAM_DepreciationTiming_ID	ID	Depreciation Timing	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_DepreciationType_ID	TableDir	No		Foreign Key to AAM_DepreciationType.AAM_DepreciationType_ID
Name	String	No
Description	Text	Yes
Help	Text	Yes

Financial Management || Advanced Assets || Subsidy (Table: AAM_SUBSIDY)

Column	Type	Name	Sequence Number	Options
AAM_Subsidy_ID	ID	Subsidy	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
SubsidyEntity	Text	No
SubsidyDate	DateTime	No
SubsidyAmt	Amount	No

Financial Management || Advanced Assets || To Do List (Table: AAM_TODOLIST)

Column	Type	Name	Sequence Number	Options
AAM_ToDoList_ID	ID	To Do List	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
C_InvoiceLine_ID	TableDir	No		Foreign Key to C_InvoiceLine.C_InvoiceLine_ID
C_BPartner_ID	TableDir	No		Foreign Key to C_BPartner.C_BPartner_ID
C_GLItem_ID	TableDir	No		Foreign Key to C_GLItem.C_GLItem_ID
AAM_AssetCard_ID	TableDir	Yes		Foreign Key to AAM_AssetCard.AAM_AssetCard_ID
InvoiceNo	char(30)	No
Line	Amount	No
Processed	YesNo	No	'N'
InvoiceDate	DateTime	Yes
BookingDate	DateTime	Yes
Purpose	Text	No
InventoryNo	String	Yes
HasAssetCard	YesNo	No	'Y'
IsVerified	YesNo	No	'N'
IsSales	YesNo	No	'N'

Financial Management || Advanced Assets || Advanced Sequence (Table: AAM_SEQUENCE)

Column	Type	Name	Sequence Number	Options
AAM_Sequence_ID	ID	Advanced Sequence	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
Name	char(60)	No
	Description	Text	Yes
Type	char(60)	No

Financial Management || Advanced Assets || Advanced Sequence || Line (Table: AAM_SEQUENCELINE)

Column	Type	Name	Sequence Number	Options
AAM_SequenceLine_ID	ID	Sequence Line	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_Sequence_ID	TableDir	No		Foreign Key to AAM_Sequence.AAM_Sequence_ID
AD_Sequence_ID	TableDir	Yes		Foreign Key to AD_Sequence.AD_Sequence_ID
Type	char(60)	No
LineNo	Amount	No
Content	char(60)	No
TextField	char(60)	Yes

AAM_INVOICELINE_ASSETCARD

Column	Type	Nullable	Default	Keys
AAM_InvoiceLineAssetCard_ID	ID	Sequence Line	(Not Displayed)
AD_Client_ID	TableDir	Client	10	Validation=AD_Client Security validation
AD_Org_ID	TableDir	Trx Organization	20	Validation=AD_Org Security validation
Created	DateTime	Created	(Not Displayed)
CreatedBy	Search	Created By	(Not Displayed)
Updated	DateTime	Updated	(Not Displayed)
UpdatedBy	TableDir	Updated By	(Not Displayed)
IsActive	YesNo	Active	30
AAM_AssetCard_ID	char(32)	No		Foreign Key to AAM_AssetCard.AAM_AssetCard_ID
C_InvoiceLine_ID	char(32)	No		Foreign Key to C_InvoiceLine.C_InvoiceLine_ID

New Views

AAM_BOOKING_V

Category: WorkInProgress