FA49900 - Company Setup | Prospr - Dynamics GP Table Reference

FA49900 - Company Setup

Query Builder

Select * from FA49900

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMPANYID	Company ID	Integer	2	View
ORGSEGMENT	Organization Segment	Integer	2	View
ACCTSEGMENT	Account Segment	Integer	2	View
PROJSEGMENT	Project Segment	Integer	2	View
CORPBOOKINDX	Corp Book Index	Long Integer	4	View
USERDATAAUTOFMT	User Data Auto Format	Boolean	2	View
REQACCOUNT	Require Account	Boolean	2	View
USRFLD1PROMPT	User Field 1 Prompt	String	18	View
USRFIELD1FMT	User Field 1 Format	Integer	2	View
USRFLD2PROMPT	User Field 2 Prompt	String	18	View
USRFIELD2FMT	User Field 2 Format	Integer	2	View
USRFLD3PROMPT	User Field 3 Prompt	String	18	View
USRFIELD3FMT	User Field 3 Format	Integer	2	View
USRFLD4PROMPT	User Field 4 Prompt	String	18	View
USRFIELD4FMT	User Field 4 Format	Integer	2	View
USRFLD5PROMPT	User Field 5 Prompt	String	18	View
USRFIELD5FMT	User Field 5 Format	Integer	2	View
USRFLD6PROMPT	User Field 6 Prompt	String	18	View
USRFIELD6FMT	User Field 6 Format	Integer	2	View
USRFLD7PROMPT	User Field 7 Prompt	String	18	View
USRFIELD7FMT	User Field 7 Format	Integer	2	View
USRFLD8PROMPT	User Field 8 Prompt	String	18	View
USRFIELD8FMT	User Field 8 Format	Integer	2	View
USRFLD9PROMPT	User Field 9 Prompt	String	18	View
USRFIELD9FMT	User Field 9 Format	Integer	2	View
USRFLD10PROMPT	User Field 10 Prompt	String	18	View
USRFIELD10FMT	User Field 10 Format	Integer	2	View
USRFLD11PROMPT	User Field 11 Prompt	String	18	View
USRFIELD11FMT	User Field 11 Format	Integer	2	View
USRFLD12PROMPT	User Field 12 Prompt	String	18	View
USRFIELD12FMT	User Field 12 Format	Integer	2	View
USRFLD13PROMPT	User Field 13 Prompt	String	18	View
USRFIELD13FMT	User Field 13 Format	Integer	2	View
USRFLD14PROMPT	User Field 14 Prompt	String	18	View
USRFIELD14FMT	User Field 14 Format	Integer	2	View
USRFLD15PROMPT	User Field 15 Prompt	String	18	View
USRFIELD15FMT	User Field 15 Format	Integer	2	View
ListValidValues_1	List Valid Values[1]	Boolean	2	View
ListValidValues_2	List Valid Values[2]	Boolean	2	View
ListValidValues_3	List Valid Values[3]	Boolean	2	View
ListValidValues_4	List Valid Values[4]	Boolean	2	View
ListValidValues_5	List Valid Values[5]	Boolean	2	View
ListValidValues_6	List Valid Values[6]	Boolean	2	View
ListValidValues_7	List Valid Values[7]	Boolean	2	View
ListValidValues_8	List Valid Values[8]	Boolean	2	View
ListValidValues_9	List Valid Values[9]	Boolean	2	View
ListValidValues_10	List Valid Values[10]	Boolean	2	View
ValidDate_1	Valid Date[1]	Boolean	2	View
ValidDate_2	Valid Date[2]	Boolean	2	View
ValidDate_3	Valid Date[3]	Boolean	2	View
ValidDate_4	Valid Date[4]	Boolean	2	View
Post_Table_Delete_Option	Post Table Delete Option	Boolean	2	View
PO_System_Used	PO System Used	Integer	2	View
AP_Post_Option	AP Post Option	Boolean	2	View
FA_Post_From_POP	FA Post From POP	Boolean	2	View
POP_Post_Option	POP Post Option	Integer	2	View
Include_Matching_Invoice	Include Matching Invoices	Boolean	2	View
FA_Country	FA Country	Integer	2	View
Auto_Add_Book_Info	Auto Add Book Info	Boolean	2	View
Deflt_Asset_Lbl_from_ID	Default Asset Label from Asset ID	Boolean	2	View
Validate_Custodian	Validate Custodian	Boolean	2	View
DEPREXPACCTINDX	Depreciation Expense Account Index	Long Integer	4	View
DEPRRESVACCTINDX	Depreciation Reserve Account Index	Long Integer	4	View
PRIORYRDEPRACCTINDX	Prior Year Depreciation Account Index	Long Integer	4	View
ASSETCOSTACCTINDX	Asset Cost Account Index	Long Integer	4	View
PROCEEDSACCTINDX	Proceeds Account Index	Long Integer	4	View
RECGAINLOSSACCTINDX	Recognized Gain Loss Account Index	Long Integer	4	View
NONRECGAINLOSSACCTINDX	Non Recognized Gain Loss Account Index	Long Integer	4	View
CLEARINGACCTINDX	Clearing Account Index	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
LASTMNTDDATE	Last Maintained Date	Date	4	View
LASTMNTDTIME	Last Maintained Time	Time	4	View
LASTMNTDUSERID	Last Maintained User ID	String	16	View
FA_Allow_Reporting_Ledge	FA_Allow Reporting Ledgers	Boolean	2	View
FA_Reset_History_In_Deta	FA Reset History In Detail	Boolean	2	View
POSTINDETAIL	Post In Detail	Boolean	2	View
NXTASSETIDFLG	Auto_Next_ID	Boolean	2	View
NXTASSETID	Next_Asset_ID	String	16	View

FA49900 - Company Setup

Query Builder

Customer Service

Information

My Account

Contact Us