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
1CMPANYIDCompany 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
2ORGSEGMENTOrganization SegmentINT1_U0Integer21
3ACCTSEGMENTAccount SegmentINT1_U0Integer21
4PROJSEGMENTProject SegmentINT1_U0Integer21
5CORPBOOKINDXCorp Book IndexLI_14Long Integer414
6USERDATAAUTOFMTUser Data Auto FormatCB_User_Data_Auto_FormatBoolean20
7REQACCOUNTRequire AccountCB_Require_AccountBoolean20
8USRFLD1PROMPTUser Field 1 PromptSTR17_User_Field_PromptString1817
9USRFIELD1FMTUser Field 1 FormatDDL_User_Field_1_FormatInteger20
10USRFLD2PROMPTUser Field 2 PromptSTR17_User_Field_PromptString1817
11USRFIELD2FMTUser Field 2 FormatDDL_User_Field_2_FormatInteger20
12USRFLD3PROMPTUser Field 3 PromptSTR17_User_Field_PromptString1817
13USRFIELD3FMTUser Field 3 FormatDDL_User_Field_3_FormatInteger20
14USRFLD4PROMPTUser Field 4 PromptSTR17_User_Field_PromptString1817
15USRFIELD4FMTUser Field 4 FormatDDL_User_Field_4_FormatInteger20
16USRFLD5PROMPTUser Field 5 PromptSTR17_User_Field_PromptString1817
17USRFIELD5FMTUser Field 5 FormatDDL_User_Field_5_FormatInteger20
18USRFLD6PROMPTUser Field 6 PromptSTR17_User_Field_PromptString1817
19USRFIELD6FMTUser Field 6 FormatDDL_User_Field_6_FormatInteger20
20USRFLD7PROMPTUser Field 7 PromptSTR17_User_Field_PromptString1817
21USRFIELD7FMTUser Field 7 FormatDDL_User_Field_7_FormatInteger20
22USRFLD8PROMPTUser Field 8 PromptSTR17_User_Field_PromptString1817
23USRFIELD8FMTUser Field 8 FormatDDL_User_Field_8_FormatInteger20
24USRFLD9PROMPTUser Field 9 PromptSTR17_User_Field_PromptString1817
25USRFIELD9FMTUser Field 9 FormatDDL_User_Field_9_FormatInteger20
26USRFLD10PROMPTUser Field 10 PromptSTR17_User_Field_PromptString1817
27USRFIELD10FMTUser Field 10 FormatDDL_User_Field_10_FormatInteger20
28USRFLD11PROMPTUser Field 11 PromptSTR17_User_Field_PromptString1817
29USRFIELD11FMTUser Field 11 FormatDDL_User_Field_11_FormatInteger20
30USRFLD12PROMPTUser Field 12 PromptSTR17_User_Field_PromptString1817
31USRFIELD12FMTUser Field 12 FormatDDL_User_Field_12_FormatInteger20
32USRFLD13PROMPTUser Field 13 PromptSTR17_User_Field_PromptString1817
33USRFIELD13FMTUser Field 13 FormatDDL_User_Field_13_FormatInteger20
34USRFLD14PROMPTUser Field 14 PromptSTR17_User_Field_PromptString1817
35USRFIELD14FMTUser Field 14 FormatDDL_User_Field_14_FormatInteger20
36USRFLD15PROMPTUser Field 15 PromptSTR17_User_Field_PromptString1817
37USRFIELD15FMTUser Field 15 FormatDDL_User_Field_15_FormatInteger20
38ListValidValuesList Valid ValuesCB_ListValidValuesBoolean20
39ListValidValues_1List Valid Values[1]CB_ListValidValuesBoolean20
40ListValidValues_2List Valid Values[2]CB_ListValidValuesBoolean20
41ListValidValues_3List Valid Values[3]CB_ListValidValuesBoolean20
42ListValidValues_4List Valid Values[4]CB_ListValidValuesBoolean20
43ListValidValues_5List Valid Values[5]CB_ListValidValuesBoolean20
44ListValidValues_6List Valid Values[6]CB_ListValidValuesBoolean20
45ListValidValues_7List Valid Values[7]CB_ListValidValuesBoolean20
46ListValidValues_8List Valid Values[8]CB_ListValidValuesBoolean20
47ListValidValues_9List Valid Values[9]CB_ListValidValuesBoolean20
48ListValidValues_10List Valid Values[10]CB_ListValidValuesBoolean20
49ValidDateValid DateCB_ValidDateBoolean20
50ValidDate_1Valid Date[1]CB_ValidDateBoolean20
51ValidDate_2Valid Date[2]CB_ValidDateBoolean20
52ValidDate_3Valid Date[3]CB_ValidDateBoolean20
53ValidDate_4Valid Date[4]CB_ValidDateBoolean20
54Post_Table_Delete_OptionPost Table Delete OptionCB_Post_Table_Delete_OptionBoolean20
55PO_System_UsedPO System UsedDDL_PO_System_UsedInteger20
56AP_Post_OptionAP Post OptionCB_AP_Post_OptionBoolean20
57FA_Post_From_POPFA Post From POPCB_Post_From_POPBoolean20
58POP_Post_OptionPOP Post OptionRG_POP_Post_OptionInteger20
59Include_Matching_InvoiceInclude Matching InvoicesCB_Include_Matching_InvoicesBoolean20
60FA_CountryFA CountryDDL_FA_CountryInteger20
61Auto_Add_Book_InfoAuto Add Book InfoCB_Auto_Add_Book_InfoBoolean20
62Deflt_Asset_Lbl_from_IDDefault Asset Label from Asset IDCB_Default_Asset_Label_from_Asset_IDBoolean20
63Validate_CustodianValidate CustodianCB_Validate_CustodianBoolean20
64DEPREXPACCTINDXDepreciation 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
65DEPRRESVACCTINDXDepreciation 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
66PRIORYRDEPRACCTINDXPrior 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
67ASSETCOSTACCTINDXAsset 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
68PROCEEDSACCTINDXProceeds 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
69RECGAINLOSSACCTINDXRecognized 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
70NONRECGAINLOSSACCTINDXNon 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
71CLEARINGACCTINDXClearing 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
72NOTEINDXNote 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
73LASTMNTDDATELast Maintained DateDTDate48
74LASTMNTDTIMELast Maintained TimeTM6Time46
75LASTMNTDUSERIDLast 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_LedgeFA_Allow Reporting LedgersCB_FAReportingLedgersBoolean20
77FA_Reset_History_In_DetaFA Reset History In DetailCB_FAResetHistoryinDetailBoolean20
78POSTINDETAILPost In DetailCB_PostInDetailBoolean20
79NXTASSETIDFLGAuto_Next_IDCB_Next_Asset_IDBoolean20
80NXTASSETIDNext_Asset_IDSTR15_Asset_IDString1615
81IncludeTaxInAcqustCostInclude Tax in Acquisition CostCBIncludeTaxinAcquisitionCostBoolean20
82DEX_ROW_IDintint1010

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 *