Fixed Assets Batch Headers (FA15000)

azurecurveProductsFixed Assets (309)FinancialFixed Assets Batch Headers (FA15000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/FA15000

Product: Fixed Assets (309)
Series: Financial

Display Name: Fixed Assets Batch Headers
Physical Name: FA15000
Technical Name: FA_Batch_Headers

Group Display Name: Fixed Assets Master
Group Technical Name: Fixed Assets Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1GLINTBTCHNUM SearchGL Interface Batch NumberSTR15_LBAUString1615
2POSTED SearchPostedTrue/FalseBoolean20
3GLINTTRXDATE SearchGL Interface TRX DateDTDate48
4GL_Interface_Comment SearchGL Interface CommentSTR30_GL_Interface_CommentString3230
5GL_Intf_Begin_Period SearchGL Interface Begin PeriodINT3Integer23
6GL_Interface_Begin_Year SearchGL Interface Begin YearYearInteger24
7GL_Interface_End_Period SearchGL Interface End PeriodINT3Integer23
8GL_Interface_End_Year SearchGL Interface End YearYearInteger24
9SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString1210
10ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString1210
11Start_Asset_ID SearchStart Asset IDSTR15_Asset_IDString1615
12End_Asset_ID SearchEnd Asset IDSTR15_Asset_IDString1615
13Start_Asset_ID_Suffix SearchStart Asset ID SuffixINT3_U0Integer23
14End_Asset_ID_Suffix SearchEnd Asset ID SuffixINT3_U0Integer23
15STTCLSID SearchStart Class IDSTR15_LBAUString1615
16ENDCLSID SearchEnd Class IDSTR15_LBAUString1615
17BOOKINDX SearchBook IndexLI_14Long Integer414
18JRNENTRY SearchJournal EntryLI8_U0Long Integer48
19DEBITAMT SearchDebit AmountDLR19_$S2Currency1019
20CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
21USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Fixed Assets Batch Headers'].USERID AS 'Fixed Assets Batch Headers-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA15000 AS ['Fixed Assets Batch Headers']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Fixed Assets Batch Headers'].USERID = ['Users Master'].USERID
22DEX_ROW_ID Searchintint1010

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 Batch Headers (FA15000)

Leave a Reply

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