FALocationHistory

PX.Objects.FA

35 of 35 fields

	Field Name	Type	Display Name	Foreign Key
	`AssetID`	`int`	AssetID	FixedAsset
Description:A reference to FixedAsset. This field is a part of the primary key. The full primary key contains the AssetID and the RevisionID fields. By default, the value is set to the current fixed asset identifier.
	`RevisionID`	`int`		-
Description:The number of the location revision. This field is a part of the primary key. The full primary key contains the AssetID and the RevisionID fields. A unique integer autoincremented number.
	`AccumulatedDepreciationAccountID`Default Navigation	`int`	Accumulated Depreciation Account	Account
Description:No description available
	`AccumulatedDepreciationSubID`Default Navigation	`int`	Accumulated Depreciation Sub.	Sub
Description:The Accumulated Depreciation subaccount associated with the Accumulated Depreciation account (FAAccountID). A reference to Sub. An integer identifier of the subaccount. This is a required field if FixedAsset.Depreciable flag is set to "true". By default, the value is set to the Accumulated Depreciation subaccount of the fixed asset (FixedAsset.FASubID).
	`BuildingID`Default Navigation	`int`	Building	-
Description:No description available
	`ClassID`Default Navigation	`int`	Asset Class	FixedAsset
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`Custodian`Obsolete	`uniqueidentifier`		-
Description:The user of custodian of the fixed asset. A reference to SM.Users. A GUID identifier of the user.
	`Department`Default Navigation	`nvarchar(10)`	Department	EPDepartment
Description:The department of the fixed asset. A reference to EPDepartment. Changing this field leads to the creation of a revision of the asset location. An integer identifier of the department. This is a required field. By default, the value is set to the custodian department.
	`DepreciatedExpenseAccountID`Default Navigation	`int`	Depreciation Expense Account	Account
Description:The Depreciation Expense account. A reference to Account. An integer identifier of the account. This is a required field if FixedAsset.Depreciable flag is set to "true". By default, the value is set to the Depreciation Expense account of the fixed asset (FixedAsset.DepreciatedExpenseAccountID).
	`DepreciatedExpenseSubID`Default Navigation	`int`	Depreciation Expense Sub.	Sub
Description:The Depreciation Expense subaccount associated with the Depreciation Expense account (DepreciatedExpenseAccountID). A reference to Sub. An integer identifier of the subaccount. This is a required field if FixedAsset.Depreciable flag is set to "true". By default, the value is set to the Depreciation Expense subaccount of the fixed asset (FixedAsset.DepreciatedExpenseSubID).
	`DisposalAccountID`Default Navigation	`int`	Proceeds Account	Account
Description:No description available
	`DisposalSubID`Default Navigation	`int`	Proceeds Sub.	Sub
Description:The Disposal subaccount associated with the Disposal account (DisposalAccountID). A reference to Sub. An integer identifier of the subaccount. By default, the value is set to the Disposal subaccount of the fixed asset (FixedAsset.DisposalSubID).
	`EmployeeID`Default Navigation	`int`	Custodian	Vendor
Description:The custodian of the fixed asset. A reference to EPEmployee. Changing this field leads to the creation of a revision of the asset location. An integer identifier of the employee.
	`FAAccountID`Default Navigation	`int`	Fixed Assets Account	Account
Description:The Fixed Assets account. A reference to Account. An integer identifier of the account. This is a required field. By default, the value is set to the Fixed Assets account of the fixed asset (FixedAsset.FAAccountID).
	`FASubID`Default Navigation	`int`	Fixed Assets Sub.	Sub
Description:The Fixed Assets subaccount associated with the Fixed Assets account (FAAccountID). A reference to Sub. An integer identifier of the subaccount. By default, the value is set to the Fixed Assets subaccount of the fixed asset (FixedAsset.FASubID).
	`Floor`	`nvarchar(5)`	Floor	-
Description:The floor on which the fixed asset is physically located. Changing this field leads to the creation of a revision of the asset location.
	`GainAcctID`Default Navigation	`int`	Gain Account	Account
Description:The Gain account. A reference to Account. An integer identifier of the account. This is a required field. By default, the value is set to the Gain account of the fixed asset (FixedAsset.GainAcctID).
	`GainSubID`Default Navigation	`int`	Gain Sub.	Sub
Description:The Gain subaccount associated with the Gain account (GainAccountID). A reference to Sub. An integer identifier of the subaccount. This is a required field. By default, the value is set to the Gain subaccount of the fixed asset (FixedAsset.GainSubID).
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Modification Date	-
Description:No description available
	`LocationID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`LossAcctID`Default Navigation	`int`	Loss Account	Account
Description:The Loss account. A reference to Account. An integer identifier of the account. This is a required field. By default, the value is set to the Loss account of the fixed asset (FixedAsset.LossAcctID).
	`LossSubID`Default Navigation	`int`	Loss Sub.	Sub
Description:The Loss subaccount associated with the Loss account (LossAccountID). A reference to Sub. An integer identifier of the subaccount. This is a required field. By default, the value is set to the Loss subaccount of the fixed asset (FixedAsset.LossSubID).
	`PeriodID`	`char(6)`	Period ID	-
Description:The financial period when the asset location was changed.
	`PrevRevisionID`	`int`		-
Description:The number of the previous revision of the asset location. This is the unbound calculated field which contains the decremented number of the active revision (RevisionID).
	`Reason`	`nvarchar(30)`	Reason	-
Description:The reason of the change of the asset location. The information field, which value is entered manually.
	`RefNbr`Default Navigation	`nvarchar(15)`	Transfer Document Nbr.	-
Description:The reference number of the related transfer document. A reference to FARegister. An integer identifier of the fixed asset document. By default, the value is set to the number of the current document.
	`Room`	`nvarchar(5)`	Room	-
Description:The room in which the fixed asset is physically located. Changing this field leads to the creation of a revision of the asset location.
	`TransactionDate`	`datetime`	Transaction Date	-
Description:The date when the asset location was changed.
	`TransactionType`	`char(1)`	Transaction Type	-
Description:The type of the change of the asset location. The field can have one of the values described in transactionType.ListAttribute. By default, the value is set to transactionType.Displacement.
	`tstamp`	`timestamp`		-
Description:No description available