Asset Retirement Master (FA00700)

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

Product: Fixed Assets (309)
Series: Financial

Display Name: Asset Retirement Master
Physical Name: FA00700
Technical Name: FA_Retirement_MSTR

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	RETIREMENTINDX	Retirement Index	LI_14	Long Integer	4	14
2	RETIRESEQ	Retirement Sequence	INT3_RZ0_U	Integer	2	3
3	RETIREEVENT	Retirement Event	LI_14	Long Integer	4	14
4	ASSETINDEX	Asset Index	LI9_Asset_Index	Long Integer	4	9
	Key to the Asset General Information Master (FA00100). Click to show/hide SELECT ['Asset Retirement Master'].ASSETINDEX AS 'Asset Retirement Master-Asset Index' ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN FA00100 AS ['Asset General Information Master'] ON ['Asset Retirement Master'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
5	ASSETID	Asset ID	STR15_Asset_ID	String	16	15
6	RETDATESTAMP	Retirement Date Stamp	DT	Date	4	8
7	RETTIMESTAMP	Retirement Time Stamp	TM6	Time	4	6
8	RETIREMENTTYPE	Retirement Type	DDL_Retirement_Type	Integer	2	0
9	RETIREMENTDATE	Retirement Date	DT	Date	4	8
10	RETIREMENTCODE	Retirement Code	STR8_Retirement_Code	String	10	8
11	CASHPROCEEDS	Cash Proceeds	DLR17_RBS0_STR$	Currency	10	17
12	Orig_Cash_Proceeds	Originating Cash Proceeds	DLR17_RBS0_STR$	Currency	10	17
13	NONCASHPROCEEDS	Non Cash Proceeds	DLR17_RBS0_STR$	Currency	10	17
14	Orig_Non_Cash_Proceeds	Originating Non Cash Proceeds	DLR17_RBS0_STR$	Currency	10	17
15	EXPOFSALE	Expenses of Sale	DLR17_RBS0_STR$	Currency	10	17
16	Orig_Expenses_of_Sale	Originating Expenses of Sale	DLR17_RBS0_STR$	Currency	10	17
17	PARTIALQTY	Partial Quantity	LI6_ST0	Long Integer	4	6
18	PARTIALCOST	Partial Cost	DLR17_RBS0_STR$	Currency	10	17
19	PARTIALPCT	Partial Percentage	INT5_%2	Integer	2	5
20	ASSETINDXAFTRET	Asset Index After Retire	LI9_Asset_Index	Long Integer	4	9
21	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Asset Retirement Master'].NOTEINDX AS 'Asset Retirement Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Asset Retirement Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
22	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Asset Retirement Master'].CURNCYID AS 'Asset Retirement Master-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Asset Retirement Master'].CURNCYID = ['Currency Setup'].CURNCYID
23	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Asset Retirement Master'].CURRNIDX AS 'Asset Retirement Master-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Asset Retirement Master'].CURRNIDX = ['Currency Setup'].CURRNIDX
24	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
25	EXCHDATE	Exchange Date	DT_Date	Date	4	6
26	TIME1	Time	TM6	Time	4	6
27	EXGTBLID	Exchange Table ID	STR15_Exchange_Table_ID	String	16	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Asset Retirement Master'].EXGTBLID AS 'Asset Retirement Master-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Asset Retirement Master'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
28	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Asset Retirement Master'].RATETPID AS 'Asset Retirement Master-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Asset Retirement Master'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
29	RTCLCMTD	Rate Calculation Method	GB	Integer	2	0
30	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
31	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
32	LASTMNTDDATE	Last Maintained Date	DT	Date	4	8
33	LASTMNTDTIME	Last Maintained Time	TM6	Time	4	6
34	LASTMNTDUSERID	Last Maintained User ID	User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Asset Retirement Master'].LASTMNTDUSERID AS 'Asset Retirement Master-Last Maintained User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM FA00700 AS ['Asset Retirement Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Asset Retirement Master'].LASTMNTDUSERID = ['Users Master'].USERID
35	DEX_ROW_ID		int	int	10	10
	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.