彈性域數(shù)據(jù)字典

1、 FND_FLEX_VALUE_SETS名稱可為空類型描述FLEX_VALUE_SETJD(PK)NNUMBER(IO)值集ID（自增）FLEX_VALUE_SET_NAMENVARCHAR2(60)值集名稱VALIDATION.TYPENVARCHAR2(1)驗(yàn)證類型PROTECTED_FLAGNVARCHAR2(1)保護(hù)標(biāo)識SECURITY_ENABLED_FLAGNVARCHAR2(1)安全啟用標(biāo)識LONGLIST.FLAGNVARCHAR2(1)FORMAT_TYPENVARCHAR2(1)格式類型MAXIMUM.SIZENNUMBERS)最大尺寸ALPHANUMERICALLOWED

2、NVARCHAR2(1)“右對齊標(biāo)識FLAGUPPERCASE_ONLY_FLAGNVARCHAR2(1)“大寫字母”標(biāo)識NUMERICMODEENABLEDNVARCHAR2(1)“數(shù)字標(biāo)識標(biāo)識FLAGDESCRIPTIONYVARCHAR2(240描述DEPENDANTDEFAULTVALYVARCHAR2(60)依靠值集的缺省UE值DEPENDANTDEFAULTMEAYVARCHAR2(240依靠值集的缺省NING)值PARENTFLEXVALUESETIYNUMBER(IO)依靠值集的依賴D值MINIMUM.VALUEYVARCHAR2(150最小值MAXIMUM_VALUEYVAR

3、CHAR2(150最大值NUMBER_PRECISIONY)NUMBER(2)精確度Last_Update_DateNDate標(biāo)準(zhǔn)who列Last_Update_ByNNumber(15)標(biāo)準(zhǔn)who列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列LastUpdateLoginNNumber(15)標(biāo)準(zhǔn)who列FND_FLEX_VALUES名稱可為空類型描述FLEX_VALUE_SETJDNNUMBER(IO)值集IDFLEX.VALUEJD(PK)NNUMBER(15)值ID（自增）FLEX.VALUENVARCHAR2(150值ENAB

4、LED.FLAGNVARCHAR2(1)“啟用”標(biāo)識SUMMARY.FLAGNVARCHAR2(1)標(biāo)識是否是父START_DATE_ACTIVEYDATE啟用開始時(shí)間END_DATE_ACTIVEYDATE啟用終止時(shí)間PARENT_FLEX_VALUE_LOWYVARCHAR2(60)依靠段的依賴值PARENT_FLEX_VALUE_HIGHYVARCHAR2(60)此字段不常用STRUCTUREDHIERARCHYLYNUMBER(15)“組”字段EVELHIERARCHY_LEVELYVARCHAR2(30)層次Last_Update_DateNDate標(biāo)準(zhǔn)who列Last_Update

5、_ByNNumber(15)標(biāo)準(zhǔn)who列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列Last_Update_LoginNNumber(15)標(biāo)準(zhǔn)who列COMPILED_VALUE_ATTRIBUYVARCHAR2(200TES0)VALUECATEGORYYVARCHAR2(30)ATTRIBUTE1YVARCHAR2(240)ATTRIBUTE50YVARCHAR2(240)FND_FLEX_VALUES_TL名稱可為空類型描述FLEX_VALUEJD(PK)NVNUMBER(I5)値IDLANGUAGE(PK)NVARCHAR2(

6、4)語言DESCRIPTIONYVARCHAR2(240描述SOURCE.LANGNVARCHAR2(4)鏡像語言FLEX_VALUE_MEANINGYVARCHAR2(150值翻譯Last_Update_DateN)Date標(biāo)準(zhǔn)who列Last_Update_ByNNumber(15)標(biāo)準(zhǔn)who列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列LastUpdateLoginYNumber(15)標(biāo)準(zhǔn)who列FND_FLEX_VALUE_NORM_HIERARCHY名稱可為空類型描述FLEX_VALUE_SET_IDNNUMBER(IO)值

7、集IDPARENT_FLEX_VALUE(PK)NVARCHAR2(60)父值RANGE_ATTRIBUTE(PK)NVARCHAR2(1)范圍CHILDFLEXVALUELOWNVARCHAR2(60)最小值(PK)CHILDFLEXVALUEHIGHNVARCHAR2(60)最大值(PK)START_DATE_ACTIVEYDATE啟用開始時(shí)間END_DATE_ACTIVEYDATE啟用終止時(shí)間Last_Update_DateNDate標(biāo)準(zhǔn)who列Last_Update_ByNNumber(15)標(biāo)準(zhǔn)who列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber

8、(15)標(biāo)準(zhǔn)who列LastUpdateLoginNNumber(15)標(biāo)準(zhǔn)who列FND_FLEX_VALUE_HIERARCHIES名稱可為空類型描述FLEX_VALUE_SETJDNNUMBER(IO)值集IDPARENT_FLEX_VALUE(PK)NVARCHAR2(60)父值CHILDFLEXVALUE.LOWNVARCHAR2(60)最小子值(PK)CHILD_FLEX_VALUE_HIGHNVARCHAR2(60)最大子值(PK)START_DATE_ACTIVEYDATE啟用開始時(shí)間END_DATE_ACTIVEYDATE啟用終止時(shí)間Last_Update_DateNDate

9、標(biāo)準(zhǔn)who列Last_Update_ByNNumber(15)標(biāo)準(zhǔn)who歹!1Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列LastUpdateLoginNNumber(15)標(biāo)準(zhǔn)who列FNDJD_FLEXS名稱可為空類型描述Application_Id(PK)NNumber(lO)應(yīng)用程序標(biāo)識ID_Flex_Code(PK)NVarchar2(4)關(guān)鍵彈性域代碼ID_Flex_NameNVarchar2(30)關(guān)鍵彈性域標(biāo)題Last_Update_DateNDate標(biāo)準(zhǔn)who列Last_Update_ByNNumber(15)標(biāo)準(zhǔn)wh

10、o列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列Last_Update_LoginYNumber(15)標(biāo)準(zhǔn)who列Table_Application_IdNNumber(lO)表應(yīng)用標(biāo)識Application_Tabe_NameNVarchar2(30)連接表名稱Allowd_ValueSetsNVarchar2(l)允許標(biāo)識值集標(biāo)書Dynamic_Insert_Feasible_FlagNVarchar2(1)動態(tài)插入可行性標(biāo)-i-fIndex_FIagNVarchar2(l)連接表插入獨(dú)占標(biāo)志（Unique_Id_Column_N

11、ameNVarchar2(30)連接表唯一標(biāo)識列名稱DescriptionYVarchar2(240)關(guān)鍵彈性域說明Application_Table_TypeYVarchar2(1)連接表類型標(biāo)志Set_Defining_Column_NameYVarchar2(30)結(jié)構(gòu)列Maximum_Concatenation_LenYNumber(15)彈性域允許連接組合的最大長度Concatenation_Len_WarningYVarchar2(240)當(dāng)彈性域連接段的長度大丁最大長度時(shí)的警告信息FNDJDFLEXSTRUCTURES名稱可為空類型描述Application_Id(PK)NNum

12、ber(lO)應(yīng)用程序標(biāo)識ID_Flex_Code(PK)NVarchar2(4)關(guān)鍵彈性域代碼ID_Flex_Num(PK)NNumber15關(guān)鍵彈性域結(jié)構(gòu)號標(biāo)準(zhǔn)who歹ijLast_Update_DateNDateLast_Update_ByNNumber(15)標(biāo)準(zhǔn)who歹ijCreation_DateNDate標(biāo)準(zhǔn)who歹ijCreated_ByNNumber(15)標(biāo)準(zhǔn)who歹ijLast_Update_LoginYNumber(l10)標(biāo)準(zhǔn)who歹ijConcatenated_Segment_DelimiterNVarchar2(1)段分割符Cross_Segment_Valida

13、tion_FlagNVarchar2(l)交義段驗(yàn)證標(biāo)書Dynamic_Inserts_Allowed_FlagNVarchar2(l)動態(tài)插入標(biāo)志Enabled_FlagNVarchar2(1)啟用標(biāo)志Freeze_Flex_Definition_FlagNVarchar2(l)凍結(jié)彈性域定義標(biāo)/忐Freeze_Structured_Hier_FlagNVarchar2(l)凍結(jié)累計(jì)組標(biāo)書Shorthnad_Enabled_FlagNVarchar2(1)結(jié)構(gòu)別名允許標(biāo)it；站名的顯示長度Shorthand_LengthYNumber(3)Structure_View_NameYVarcha

14、r2(30)結(jié)構(gòu)試圖名稱IdFlexStructureCodeNVarchar2(30)彈性域結(jié)構(gòu)代碼FNDD_FLEX_SEGMENTS名稱可為空類型描述Application_Id(PK)NNumber(lO)應(yīng)用程序標(biāo)識ID_Flex_Code(PK)NVarchar2(4)關(guān)鍵彈性域代碼ID_Flex_Num(PK)NNumber(15)關(guān)鍵彈性域結(jié)構(gòu)號列名稱Application_Column_Name(PK)NVarchar2(3O)Segment_NameNVarchar2(3O)段名稱Last_Update_DateNDate標(biāo)準(zhǔn)who列Last_Update_ByNNumbe

15、r(15)標(biāo)準(zhǔn)who列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列Last_Update_LoginYNumber(15)標(biāo)準(zhǔn)who列Segment_NumNNumber(3)段編號Application_Column_Index_FINVarchar2(l)索引標(biāo)志agEnabled_FlagNVarchar2(l)啟用標(biāo)恵Required_FlagNVarchar2(1)要求標(biāo)志DisplayFlagNVarchar2(l)顯示標(biāo)志Display_SizeNNumber(3)顯示大小Security_Enabled_FlagNVar

16、char2(1)啟用安全性標(biāo)志Maximum_Description_LenNNumber(3)說明大小Concatenation_Description_LeNNumber(3)連接說明大小11Flex_Value_Set_IDYNumber(lO)值集標(biāo)識Range_CodeYVarchar2(1)范圍Default_TypeYVarchar2(1)默認(rèn)類型Default.ValueYVarchar2(2000)默認(rèn)值FND_F1EX_VALIDATION_RULES名稱可為空類型描述Application_Id(PK)NNumber(lO)應(yīng)用程序標(biāo)識ID_Flex_Code(PK)NV

17、archar2(4)關(guān)鍵彈性域代碼ID_Flex_Num(PK)NNumber(15)關(guān)鍵彈性域結(jié)構(gòu)號交義驗(yàn)證規(guī)則名稱標(biāo)準(zhǔn)who歹1Flex_VaIidation_Rule_Name(PK)NVarchat2(15)Last_Update_DateNDateLast_Update_ByNNumber(15)標(biāo)準(zhǔn)who歹1Creation_DateNDate標(biāo)準(zhǔn)who歹1Created_ByNNumber(15)標(biāo)準(zhǔn)who歹1Last_Update_LoginYNumber(15)標(biāo)準(zhǔn)who歹1Enabled_FlagNVarchar2(l)啟用標(biāo)志Error_Segment_Column_Na

18、meYVarchar2(3O)驗(yàn)證失敗段Start_Date_ActiveYDate規(guī)則生效起始日期規(guī)則生效截止日期End_Date_ActiveYDateFND_FLEX_VALIDATION_RULE_LINES名稱可為空類型描述RuIe_Line_Id(PK)NNumber(15)交義驗(yàn)證耍索標(biāo)識冷用程序標(biāo)識Application_IdNNumber(lO)ID_Flcx_CodeNVarchar2(4)關(guān)鍵彈性域代碼ID_Flex_NumNNumber(15)關(guān)鍵彈性域結(jié)構(gòu)號交義驗(yàn)證規(guī)則名稱標(biāo)準(zhǔn)who歹ijFlex_Validation_Rule_NameNVarchat2(15)La

19、st_Update_DateNDateLast_Update_ByNNumber(15)標(biāo)準(zhǔn)who歹ijCreation_DateNDate標(biāo)準(zhǔn)who歹ijCreated_ByNNumber(15)標(biāo)準(zhǔn)who歹ijLast_Update_LoginYNumber(15)標(biāo)準(zhǔn)who歹ijEnabled_FlagNVarchar2(l)啟用標(biāo)志Concatenated_Segnients_LowNVarchar2(2000)連接段下限Concatenated_Segments_HighNVarchar2(2000)連接段上限Include.ExcludedicatorNVarchar2(l)包含排

20、除標(biāo)識DescriptionYVarchar2(240)說明FND_FLEX_EXCLUDE_RULE_LINES名稱可為空類型描述RuIe_Line_Id(PK)NNumber(15)交義驗(yàn)證要素標(biāo)識Application_IdNNumber(lO)應(yīng)用程序標(biāo)識ID_Flcx_CodeNVarchar2(4)關(guān)鍵彈性域代碼ID_Flex_NumNNumber(15)關(guān)鍵彈性域結(jié)構(gòu)號Flex_Validation_Rule_NameNVarchat2(15)交義驗(yàn)證規(guī)則名稱Enabled_FlagNVarchar2(l)啟用標(biāo)志Last_Update_DateNDate標(biāo)準(zhǔn)who歹ijLast

21、_Update_ByNNumber(15)標(biāo)準(zhǔn)who歹ijCreation_DateNDate標(biāo)準(zhǔn)who歹ijCreated_ByNNumber(15)標(biāo)準(zhǔn)who歹ijLast_Update_LoginNNumber(15)標(biāo)準(zhǔn)who歹ijSegmentljowYVarchar2(150)排除的最小值Segmentl_HighYVarchar2(150)排除的最大值Segment30_LowNVarchar2(150)排除的最小值Segment30HighYVarchar2(150)排除的最小值FND_FLEXJNCLUDE_RULE_LINES名稱可為空類型描述RuIe_Line_Id(PK

22、)NNumber(15)交義驗(yàn)證耍索標(biāo)識Application_IdNNumber(lO)應(yīng)用程序標(biāo)識ID_Flcx_CodeNVarchar2(4)關(guān)鍵彈性域代碼ID_Flex_NumNNumber(15)關(guān)鍵彈性域結(jié)構(gòu)號Flex_Validation_Rule_NameNVarchat2(15)交義驗(yàn)證規(guī)則名稱EnabledFlagNVarchar2(l)啟用標(biāo)志Last_Update_DateNDate標(biāo)準(zhǔn)who列Last_Update_ByNNumber(15)標(biāo)準(zhǔn)who列Creation_DateNDate標(biāo)準(zhǔn)who列Created_ByNNumber(15)標(biāo)準(zhǔn)who列Last_U