Fixed Assets Conversion Detail (FACNVDTL)

azurecurveProductsFixed Assets (309)FinancialFixed Assets Conversion Detail (FACNVDTL)

Easily find this page again using the shortlink:

Product: Fixed Assets (309)
Series: Financial

Display Name: Fixed Assets Conversion Detail
Physical Name: FACNVDTL
Technical Name: FA_Conversion_DTL

Group Display Name: Fixed Assets Conversion
Group Technical Name: Fixed Assets Conversion

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASSETID SearchAsset IDSTR15_Asset_IDString15
2ASSETIDSUF SearchAsset ID SuffixINT3_U0Integer3
3Import_Record_Type SearchImport Record TypeSTR10String10
4BOOKID SearchBook IDSTR15_Book_IDString15
5INDXLONG SearchIndexLongLong IntLong Integer8
6SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
7ERRICON SearchError IconVS_Error_IconsInteger0
8ERMSGTXT SearchError Message TextSTR255String255
9DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsFixed Assets (309)FinancialFixed Assets Conversion Detail (FACNVDTL)

Leave a Reply

Your email address will not be published. Required fields are marked *