Asset Purge Detail (FA01002)

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

Product: Fixed Assets (309)
Series:

Display Name: Asset Purge Detail
Physical Name: FA01002
Technical Name: FA_Purge_DTL

Group Display Name: Fixed Assets Purge
Group Technical Name: Fixed Assets Purge

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PURGEDATE SearchPurge DateDateDT8
2PURGETIME SearchPurge TimeTimeTM66
3USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Asset Purge Detail'].USERID AS 'Asset Purge Detail-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA01002 AS ['Asset Purge Detail']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Asset Purge Detail'].USERID = ['Users Master'].USERID
4ASSETINDEX SearchAsset IndexLong IntegerLI9_Asset_Index9
Key to the Asset General Information Master (FA00100).

Click to show/hide

SELECT
       ['Asset Purge Detail'].ASSETINDEX AS 'Asset Purge Detail-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       FA01002 AS ['Asset Purge Detail']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['Asset Purge Detail'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
5ASSETID SearchAsset IDStringSTR15_Asset_ID15
6ASSETIDSUF SearchAsset ID SuffixIntegerINT3_U03
7ASSETDESC SearchAsset DescriptionStringSTR40_Asset_Description40
8ASSETSTATUS SearchAsset StatusIntegerVS_Asset_Status0
9ASSETSTATDT SearchAsset Status DateDateDT8

Leave a Reply

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