Company Setup (FA49900)

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

Product: Fixed Assets (309)
Series:

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 TypeLength
1CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

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 SegmentIntegerINT1_U01
3ACCTSEGMENT SearchAccount SegmentIntegerINT1_U01
4PROJSEGMENT SearchProject SegmentIntegerINT1_U01
5CORPBOOKINDX SearchCorp Book IndexLong IntegerLI_1414
6USERDATAAUTOFMT SearchUser Data Auto FormatBooleanCB_User_Data_Auto_Format0
7REQACCOUNT SearchRequire AccountBooleanCB_Require_Account0
8USRFLD1PROMPT SearchUser Field 1 PromptStringSTR17_User_Field_Prompt17
9USRFIELD1FMT SearchUser Field 1 FormatIntegerDDL_User_Field_1_Format0
10USRFLD2PROMPT SearchUser Field 2 PromptStringSTR17_User_Field_Prompt17
11USRFIELD2FMT SearchUser Field 2 FormatIntegerDDL_User_Field_2_Format0
12USRFLD3PROMPT SearchUser Field 3 PromptStringSTR17_User_Field_Prompt17
13USRFIELD3FMT SearchUser Field 3 FormatIntegerDDL_User_Field_3_Format0
14USRFLD4PROMPT SearchUser Field 4 PromptStringSTR17_User_Field_Prompt17
15USRFIELD4FMT SearchUser Field 4 FormatIntegerDDL_User_Field_4_Format0
16USRFLD5PROMPT SearchUser Field 5 PromptStringSTR17_User_Field_Prompt17
17USRFIELD5FMT SearchUser Field 5 FormatIntegerDDL_User_Field_5_Format0
18USRFLD6PROMPT SearchUser Field 6 PromptStringSTR17_User_Field_Prompt17
19USRFIELD6FMT SearchUser Field 6 FormatIntegerDDL_User_Field_6_Format0
20USRFLD7PROMPT SearchUser Field 7 PromptStringSTR17_User_Field_Prompt17
21USRFIELD7FMT SearchUser Field 7 FormatIntegerDDL_User_Field_7_Format0
22USRFLD8PROMPT SearchUser Field 8 PromptStringSTR17_User_Field_Prompt17
23USRFIELD8FMT SearchUser Field 8 FormatIntegerDDL_User_Field_8_Format0
24USRFLD9PROMPT SearchUser Field 9 PromptStringSTR17_User_Field_Prompt17
25USRFIELD9FMT SearchUser Field 9 FormatIntegerDDL_User_Field_9_Format0
26USRFLD10PROMPT SearchUser Field 10 PromptStringSTR17_User_Field_Prompt17
27USRFIELD10FMT SearchUser Field 10 FormatIntegerDDL_User_Field_10_Format0
28USRFLD11PROMPT SearchUser Field 11 PromptStringSTR17_User_Field_Prompt17
29USRFIELD11FMT SearchUser Field 11 FormatIntegerDDL_User_Field_11_Format0
30USRFLD12PROMPT SearchUser Field 12 PromptStringSTR17_User_Field_Prompt17
31USRFIELD12FMT SearchUser Field 12 FormatIntegerDDL_User_Field_12_Format0
32USRFLD13PROMPT SearchUser Field 13 PromptStringSTR17_User_Field_Prompt17
33USRFIELD13FMT SearchUser Field 13 FormatIntegerDDL_User_Field_13_Format0
34USRFLD14PROMPT SearchUser Field 14 PromptStringSTR17_User_Field_Prompt17
35USRFIELD14FMT SearchUser Field 14 FormatIntegerDDL_User_Field_14_Format0
36USRFLD15PROMPT SearchUser Field 15 PromptStringSTR17_User_Field_Prompt17
37USRFIELD15FMT SearchUser Field 15 FormatIntegerDDL_User_Field_15_Format0
38ListValidValues_1 SearchList Valid Values[1]BooleanCB_ListValidValues0
39ListValidValues SearchList Valid ValuesCB_ListValidValuesBoolean0
40ListValidValues_2 SearchList Valid Values[2]BooleanCB_ListValidValues0
41ListValidValues_3 SearchList Valid Values[3]BooleanCB_ListValidValues0
42ListValidValues_4 SearchList Valid Values[4]BooleanCB_ListValidValues0
43ListValidValues_5 SearchList Valid Values[5]BooleanCB_ListValidValues0
44ListValidValues_6 SearchList Valid Values[6]BooleanCB_ListValidValues0
45ListValidValues_7 SearchList Valid Values[7]BooleanCB_ListValidValues0
46ListValidValues_8 SearchList Valid Values[8]BooleanCB_ListValidValues0
47ListValidValues_9 SearchList Valid Values[9]BooleanCB_ListValidValues0
48ListValidValues_10 SearchList Valid Values[10]BooleanCB_ListValidValues0
49ValidDate_1 SearchValid Date[1]BooleanCB_ValidDate0
50ValidDate_2 SearchValid Date[2]BooleanCB_ValidDate0
51ValidDate SearchValid DateCB_ValidDateBoolean0
52ValidDate_3 SearchValid Date[3]BooleanCB_ValidDate0
53ValidDate_4 SearchValid Date[4]BooleanCB_ValidDate0
54Post_Table_Delete_Option SearchPost Table Delete OptionBooleanCB_Post_Table_Delete_Option0
55PO_System_Used SearchPO System UsedIntegerDDL_PO_System_Used0
56AP_Post_Option SearchAP Post OptionBooleanCB_AP_Post_Option0
57FA_Post_From_POP SearchFA Post From POPBooleanCB_Post_From_POP0
58POP_Post_Option SearchPOP Post OptionIntegerRG_POP_Post_Option0
59Include_Matching_Invoice SearchInclude Matching InvoicesBooleanCB_Include_Matching_Invoices0
60FA_Country SearchFA CountryIntegerDDL_FA_Country0
61Auto_Add_Book_Info SearchAuto Add Book InfoBooleanCB_Auto_Add_Book_Info0
62Deflt_Asset_Lbl_from_ID SearchDefault Asset Label from Asset IDBooleanCB_Default_Asset_Label_from_Asset_ID0
63Validate_Custodian SearchValidate CustodianBooleanCB_Validate_Custodian0
64DEPREXPACCTINDX SearchDepreciation Expense Account IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

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 IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

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 DateDateDT8
74LASTMNTDTIME SearchLast Maintained TimeTimeTM66
75LASTMNTDUSERID SearchLast Maintained User IDStringUser_ID15
Key to the Users Master (SY01400).

Click to show/hide

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 LedgersBooleanCB_FAReportingLedgers0
77FA_Reset_History_In_Deta SearchFA Reset History In DetailBooleanCB_FAResetHistoryinDetail0
78POSTINDETAIL SearchPost In DetailBooleanCB_PostInDetail0
79NXTASSETIDFLG SearchAuto_Next_IDBooleanCB_Next_Asset_ID0
80NXTASSETID SearchNext_Asset_IDStringSTR15_Asset_ID15
81IncludeTaxInAcqustCost SearchInclude Tax in Acquisition CostBooleanCBIncludeTaxinAcquisitionCost0

Leave a Reply

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