Company Setup (FA49900)

Easily find this page again using the shortlink: http://gpt.azrcrv.co.uk/FA49900

Product: Fixed Assets (309)
Series: Financial

Display Name: Company Setup
Physical Name: FA49900
Technical Name: FA_Company_SETP

Group Display Name: Fixed Assets Setup
Group Technical Name: Fixed Assets Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide example SQL

SELECT
       ['Company Setup'].CMPANYID AS 'Company Setup-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Company Setup'].CMPANYID = ['Company Master'].CMPANYID
2ORGSEGMENT SearchOrganization SegmentINT1_U0Integer21
3ACCTSEGMENT SearchAccount SegmentINT1_U0Integer21
4PROJSEGMENT SearchProject SegmentINT1_U0Integer21
5CORPBOOKINDX SearchCorp Book IndexLI_14Long Integer414
6USERDATAAUTOFMT SearchUser Data Auto FormatCB_User_Data_Auto_FormatBoolean20
7REQACCOUNT SearchRequire AccountCB_Require_AccountBoolean20
8USRFLD1PROMPT SearchUser Field 1 PromptSTR17_User_Field_PromptString1817
9USRFIELD1FMT SearchUser Field 1 FormatDDL_User_Field_1_FormatInteger20
10USRFLD2PROMPT SearchUser Field 2 PromptSTR17_User_Field_PromptString1817
11USRFIELD2FMT SearchUser Field 2 FormatDDL_User_Field_2_FormatInteger20
12USRFLD3PROMPT SearchUser Field 3 PromptSTR17_User_Field_PromptString1817
13USRFIELD3FMT SearchUser Field 3 FormatDDL_User_Field_3_FormatInteger20
14USRFLD4PROMPT SearchUser Field 4 PromptSTR17_User_Field_PromptString1817
15USRFIELD4FMT SearchUser Field 4 FormatDDL_User_Field_4_FormatInteger20
16USRFLD5PROMPT SearchUser Field 5 PromptSTR17_User_Field_PromptString1817
17USRFIELD5FMT SearchUser Field 5 FormatDDL_User_Field_5_FormatInteger20
18USRFLD6PROMPT SearchUser Field 6 PromptSTR17_User_Field_PromptString1817
19USRFIELD6FMT SearchUser Field 6 FormatDDL_User_Field_6_FormatInteger20
20USRFLD7PROMPT SearchUser Field 7 PromptSTR17_User_Field_PromptString1817
21USRFIELD7FMT SearchUser Field 7 FormatDDL_User_Field_7_FormatInteger20
22USRFLD8PROMPT SearchUser Field 8 PromptSTR17_User_Field_PromptString1817
23USRFIELD8FMT SearchUser Field 8 FormatDDL_User_Field_8_FormatInteger20
24USRFLD9PROMPT SearchUser Field 9 PromptSTR17_User_Field_PromptString1817
25USRFIELD9FMT SearchUser Field 9 FormatDDL_User_Field_9_FormatInteger20
26USRFLD10PROMPT SearchUser Field 10 PromptSTR17_User_Field_PromptString1817
27USRFIELD10FMT SearchUser Field 10 FormatDDL_User_Field_10_FormatInteger20
28USRFLD11PROMPT SearchUser Field 11 PromptSTR17_User_Field_PromptString1817
29USRFIELD11FMT SearchUser Field 11 FormatDDL_User_Field_11_FormatInteger20
30USRFLD12PROMPT SearchUser Field 12 PromptSTR17_User_Field_PromptString1817
31USRFIELD12FMT SearchUser Field 12 FormatDDL_User_Field_12_FormatInteger20
32USRFLD13PROMPT SearchUser Field 13 PromptSTR17_User_Field_PromptString1817
33USRFIELD13FMT SearchUser Field 13 FormatDDL_User_Field_13_FormatInteger20
34USRFLD14PROMPT SearchUser Field 14 PromptSTR17_User_Field_PromptString1817
35USRFIELD14FMT SearchUser Field 14 FormatDDL_User_Field_14_FormatInteger20
36USRFLD15PROMPT SearchUser Field 15 PromptSTR17_User_Field_PromptString1817
37USRFIELD15FMT SearchUser Field 15 FormatDDL_User_Field_15_FormatInteger20
38ListValidValues SearchList Valid ValuesCB_ListValidValuesBoolean20
39ListValidValues_1 SearchList Valid Values[1]CB_ListValidValuesBoolean20
40ListValidValues_2 SearchList Valid Values[2]CB_ListValidValuesBoolean20
41ListValidValues_3 SearchList Valid Values[3]CB_ListValidValuesBoolean20
42ListValidValues_4 SearchList Valid Values[4]CB_ListValidValuesBoolean20
43ListValidValues_5 SearchList Valid Values[5]CB_ListValidValuesBoolean20
44ListValidValues_6 SearchList Valid Values[6]CB_ListValidValuesBoolean20
45ListValidValues_7 SearchList Valid Values[7]CB_ListValidValuesBoolean20
46ListValidValues_8 SearchList Valid Values[8]CB_ListValidValuesBoolean20
47ListValidValues_9 SearchList Valid Values[9]CB_ListValidValuesBoolean20
48ListValidValues_10 SearchList Valid Values[10]CB_ListValidValuesBoolean20
49ValidDate SearchValid DateCB_ValidDateBoolean20
50ValidDate_1 SearchValid Date[1]CB_ValidDateBoolean20
51ValidDate_2 SearchValid Date[2]CB_ValidDateBoolean20
52ValidDate_3 SearchValid Date[3]CB_ValidDateBoolean20
53ValidDate_4 SearchValid Date[4]CB_ValidDateBoolean20
54Post_Table_Delete_Option SearchPost Table Delete OptionCB_Post_Table_Delete_OptionBoolean20
55PO_System_Used SearchPO System UsedDDL_PO_System_UsedInteger20
56AP_Post_Option SearchAP Post OptionCB_AP_Post_OptionBoolean20
57FA_Post_From_POP SearchFA Post From POPCB_Post_From_POPBoolean20
58POP_Post_Option SearchPOP Post OptionRG_POP_Post_OptionInteger20
59Include_Matching_Invoice SearchInclude Matching InvoicesCB_Include_Matching_InvoicesBoolean20
60FA_Country SearchFA CountryDDL_FA_CountryInteger20
61Auto_Add_Book_Info SearchAuto Add Book InfoCB_Auto_Add_Book_InfoBoolean20
62Deflt_Asset_Lbl_from_ID SearchDefault Asset Label from Asset IDCB_Default_Asset_Label_from_Asset_IDBoolean20
63Validate_Custodian SearchValidate CustodianCB_Validate_CustodianBoolean20
64DEPREXPACCTINDX SearchDepreciation Expense Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].DEPREXPACCTINDX AS 'Company Setup-Depreciation Expense Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].DEPREXPACCTINDX = ['Account Index Master'].ACTINDX
65DEPRRESVACCTINDX SearchDepreciation Reserve Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].DEPRRESVACCTINDX AS 'Company Setup-Depreciation Reserve Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].DEPRRESVACCTINDX = ['Account Index Master'].ACTINDX
66PRIORYRDEPRACCTINDX SearchPrior Year Depreciation Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].PRIORYRDEPRACCTINDX AS 'Company Setup-Prior Year Depreciation Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].PRIORYRDEPRACCTINDX = ['Account Index Master'].ACTINDX
67ASSETCOSTACCTINDX SearchAsset Cost Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].ASSETCOSTACCTINDX AS 'Company Setup-Asset Cost Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].ASSETCOSTACCTINDX = ['Account Index Master'].ACTINDX
68PROCEEDSACCTINDX SearchProceeds Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].PROCEEDSACCTINDX AS 'Company Setup-Proceeds Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].PROCEEDSACCTINDX = ['Account Index Master'].ACTINDX
69RECGAINLOSSACCTINDX SearchRecognized Gain Loss Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].RECGAINLOSSACCTINDX AS 'Company Setup-Recognized Gain Loss Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].RECGAINLOSSACCTINDX = ['Account Index Master'].ACTINDX
70NONRECGAINLOSSACCTINDX SearchNon Recognized Gain Loss Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].NONRECGAINLOSSACCTINDX AS 'Company Setup-Non Recognized Gain Loss Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].NONRECGAINLOSSACCTINDX = ['Account Index Master'].ACTINDX
71CLEARINGACCTINDX SearchClearing Account IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide example SQL

SELECT
       ['Company Setup'].CLEARINGACCTINDX AS 'Company Setup-Clearing Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Company Setup'].CLEARINGACCTINDX = ['Account Index Master'].ACTINDX
72NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide example SQL

SELECT
       ['Company Setup'].NOTEINDX AS 'Company Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Company Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
73LASTMNTDDATE SearchLast Maintained DateDTDate48
74LASTMNTDTIME SearchLast Maintained TimeTM6Time46
75LASTMNTDUSERID SearchLast Maintained User IDUser_IDString1615
Key to the Users Master (SY01400).

Click to show/hide example SQL

SELECT
       ['Company Setup'].LASTMNTDUSERID AS 'Company Setup-Last Maintained User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA49900 AS ['Company Setup']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Company Setup'].LASTMNTDUSERID = ['Users Master'].USERID
76FA_Allow_Reporting_Ledge SearchFA_Allow Reporting LedgersCB_FAReportingLedgersBoolean20
77FA_Reset_History_In_Deta SearchFA Reset History In DetailCB_FAResetHistoryinDetailBoolean20
78POSTINDETAIL SearchPost In DetailCB_PostInDetailBoolean20
79NXTASSETIDFLG SearchAuto_Next_IDCB_Next_Asset_IDBoolean20
80NXTASSETID SearchNext_Asset_IDSTR15_Asset_IDString1615
81IncludeTaxInAcqustCost SearchInclude Tax in Acquisition CostCBIncludeTaxinAcquisitionCostBoolean20
82DEX_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.

Leave a Reply

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