FA00700 - Asset Retirement Master | Prospr - Dynamics GP Table Reference

FA00700 - Asset Retirement Master

Query Builder

Select * from FA00700

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RETIREMENTINDX	Retirement Index	Long Integer	4	View
RETIRESEQ	Retirement Sequence	Integer	2	View
RETIREEVENT	Retirement Event	Long Integer	4	View
ASSETINDEX	Asset Index	Long Integer	4	View
ASSETID	Asset ID	String	16	View
RETDATESTAMP	Retirement Date Stamp	Date	4	View
RETTIMESTAMP	Retirement Time Stamp	Time	4	View
RETIREMENTTYPE	Retirement Type	Integer	2	View
RETIREMENTDATE	Retirement Date	Date	4	View
RETIREMENTCODE	Retirement Code	String	10	View
CASHPROCEEDS	Cash Proceeds	Currency	10	View
Orig_Cash_Proceeds	Originating Cash Proceeds	Currency	10	View
NONCASHPROCEEDS	Non Cash Proceeds	Currency	10	View
Orig_Non_Cash_Proceeds	Originating Non Cash Proceeds	Currency	10	View
EXPOFSALE	Expenses of Sale	Currency	10	View
Orig_Expenses_of_Sale	Originating Expenses of Sale	Currency	10	View
PARTIALQTY	Partial Quantity	Long Integer	4	View
PARTIALCOST	Partial Cost	Currency	10	View
PARTIALPCT	Partial Percentage	Integer	2	View
ASSETINDXAFTRET	Asset Index After Retire	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
EXGTBLID	Exchange Table ID	String	16	View
RATETPID	Rate Type ID	String	16	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
LASTMNTDDATE	Last Maintained Date	Date	4	View
LASTMNTDTIME	Last Maintained Time	Time	4	View
LASTMNTDUSERID	Last Maintained User ID	String	16	View

FA00700 - Asset Retirement Master

Query Builder

Customer Service

Information

My Account

Contact Us