View source | View content page | Page history | Printable version   

Projects:Assetsmanagement/Advanced Asset Management/Application Dictionary

Warning.png   This document is still a work in progress. It may contain inaccuracies or errors.

Contents

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

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Assetsmanagement/Advanced_Asset_Management/Application_Dictionary"

This page has been accessed 5,580 times. This page was last modified on 8 June 2012, at 05:26. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.