Projects:Assetsmanagement/Advanced Asset Management/Application Dictionary
| This document is still a work in progress. It may contain inaccuracies or errors.
|
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