弹性域数据字典

1、 FND_FLEX_VALUE_SETS名称可为空类型描述FLEX_VALUE_SETJD(PK)NNUMBER(IO)值集ID（自增）FLEX_VALUE_SET_NAMENVARCHAR2(60)值集名称VALIDATION.TYPENVARCHAR2(1)验证类型PROTECTED_FLAGNVARCHAR2(1)保护标识SECURITY_ENABLED_FLAGNVARCHAR2(1)安全启用标识LONGLIST.FLAGNVARCHAR2(1)FORMAT_TYPENVARCHAR2(1)格式类型MAXIMUM.SIZENNUMBERS)最大尺寸ALPHANUMERICALLOWED

2、NVARCHAR2(1)“右对齐标识FLAGUPPERCASE_ONLY_FLAGNVARCHAR2(1)“大写字母”标识NUMERICMODEENABLEDNVARCHAR2(1)“数字标识标识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标准who列Last_Update_ByNNumber(15)标准who列Creation_DateNDate标准who列Created_ByNNumber(15)标准who列LastUpdateLoginNNumber(15)标准who列FND_FLEX_VALUES名称可为空类型描述FLEX_VALUE_SETJDNNUMBER(IO)值集IDFLEX.VALUEJD(PK)NNUMBER(15)值ID（自增）FLEX.VALUENVARCHAR2(150值ENAB

4、LED.FLAGNVARCHAR2(1)“启用”标识SUMMARY.FLAGNVARCHAR2(1)标识是否是父START_DATE_ACTIVEYDATE启用开始时间END_DATE_ACTIVEYDATE启用终止时间PARENT_FLEX_VALUE_LOWYVARCHAR2(60)依靠段的依赖值PARENT_FLEX_VALUE_HIGHYVARCHAR2(60)此字段不常用STRUCTUREDHIERARCHYLYNUMBER(15)“组”字段EVELHIERARCHY_LEVELYVARCHAR2(30)层次Last_Update_DateNDate标准who列Last_Update

5、_ByNNumber(15)标准who列Creation_DateNDate标准who列Created_ByNNumber(15)标准who列Last_Update_LoginNNumber(15)标准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标准who列Last_Update_ByNNumber(15)标准who列Creation_DateNDate标准who列Created_ByNNumber(15)标准who列LastUpdateLoginYNumber(15)标准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启用开始时间END_DATE_ACTIVEYDATE启用终止时间Last_Update_DateNDate标准who列Last_Update_ByNNumber(15)标准who列Creation_DateNDate标准who列Created_ByNNumber

8、(15)标准who列LastUpdateLoginNNumber(15)标准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启用开始时间END_DATE_ACTIVEYDATE启用终止时间Last_Update_DateNDate

9、标准who列Last_Update_ByNNumber(15)标准who歹!1Creation_DateNDate标准who列Created_ByNNumber(15)标准who列LastUpdateLoginNNumber(15)标准who列FNDJD_FLEXS名称可为空类型描述Application_Id(PK)NNumber(lO)应用程序标识ID_Flex_Code(PK)NVarchar2(4)关键弹性域代码ID_Flex_NameNVarchar2(30)关键弹性域标题Last_Update_DateNDate标准who列Last_Update_ByNNumber(15)标准wh

10、o列Creation_DateNDate标准who列Created_ByNNumber(15)标准who列Last_Update_LoginYNumber(15)标准who列Table_Application_IdNNumber(lO)表应用标识Application_Tabe_NameNVarchar2(30)连接表名称Allowd_ValueSetsNVarchar2(l)允许标识值集标書Dynamic_Insert_Feasible_FlagNVarchar2(1)动态插入可行性标-i-fIndex_FIagNVarchar2(l)连接表插入独占标志（Unique_Id_Column_N

11、ameNVarchar2(30)连接表唯一标识列名称DescriptionYVarchar2(240)关键弹性域说明Application_Table_TypeYVarchar2(1)连接表类型标志Set_Defining_Column_NameYVarchar2(30)结构列Maximum_Concatenation_LenYNumber(15)弹性域允许连接组合的最大长度Concatenation_Len_WarningYVarchar2(240)当弹性域连接段的长度大丁最大长度时的警告信息FNDJDFLEXSTRUCTURES名称可为空类型描述Application_Id(PK)NNum

12、ber(lO)应用程序标识ID_Flex_Code(PK)NVarchar2(4)关键弹性域代码ID_Flex_Num(PK)NNumber15关键弹性域结构号标准who歹ijLast_Update_DateNDateLast_Update_ByNNumber(15)标准who歹ijCreation_DateNDate标准who歹ijCreated_ByNNumber(15)标准who歹ijLast_Update_LoginYNumber(l10)标准who歹ijConcatenated_Segment_DelimiterNVarchar2(1)段分割符Cross_Segment_Valida

13、tion_FlagNVarchar2(l)交义段验证标書Dynamic_Inserts_Allowed_FlagNVarchar2(l)动态插入标志Enabled_FlagNVarchar2(1)启用标志Freeze_Flex_Definition_FlagNVarchar2(l)冻结弹性域定义标/忐Freeze_Structured_Hier_FlagNVarchar2(l)冻结累计组标書Shorthnad_Enabled_FlagNVarchar2(1)结构别名允许标it；站名的显示长度Shorthand_LengthYNumber(3)Structure_View_NameYVarcha

14、r2(30)结构试图名称IdFlexStructureCodeNVarchar2(30)弹性域结构代码FNDD_FLEX_SEGMENTS名称可为空类型描述Application_Id(PK)NNumber(lO)应用程序标识ID_Flex_Code(PK)NVarchar2(4)关键弹性域代码ID_Flex_Num(PK)NNumber(15)关键弹性域结构号列名称Application_Column_Name(PK)NVarchar2(3O)Segment_NameNVarchar2(3O)段名称Last_Update_DateNDate标准who列Last_Update_ByNNumbe

15、r(15)标准who列Creation_DateNDate标准who列Created_ByNNumber(15)标准who列Last_Update_LoginYNumber(15)标准who列Segment_NumNNumber(3)段编号Application_Column_Index_FINVarchar2(l)索引标志agEnabled_FlagNVarchar2(l)启用标恵Required_FlagNVarchar2(1)要求标志DisplayFlagNVarchar2(l)显示标志Display_SizeNNumber(3)显示大小Security_Enabled_FlagNVar

16、char2(1)启用安全性标志Maximum_Description_LenNNumber(3)说明大小Concatenation_Description_LeNNumber(3)连接说明大小11Flex_Value_Set_IDYNumber(lO)值集标识Range_CodeYVarchar2(1)范围Default_TypeYVarchar2(1)默认类型Default.ValueYVarchar2(2000)默认值FND_F1EX_VALIDATION_RULES名称可为空类型描述Application_Id(PK)NNumber(lO)应用程序标识ID_Flex_Code(PK)NV

17、archar2(4)关键弹性域代码ID_Flex_Num(PK)NNumber(15)关键弹性域结构号交义验证规则名称标准who歹1Flex_VaIidation_Rule_Name(PK)NVarchat2(15)Last_Update_DateNDateLast_Update_ByNNumber(15)标准who歹1Creation_DateNDate标准who歹1Created_ByNNumber(15)标准who歹1Last_Update_LoginYNumber(15)标准who歹1Enabled_FlagNVarchar2(l)启用标志Error_Segment_Column_Na

18、meYVarchar2(3O)验证失败段Start_Date_ActiveYDate规则生效起始日期规则生效截止日期End_Date_ActiveYDateFND_FLEX_VALIDATION_RULE_LINES名称可为空类型描述RuIe_Line_Id(PK)NNumber(15)交义验证耍索标识冷用程序标识Application_IdNNumber(lO)ID_Flcx_CodeNVarchar2(4)关键弹性域代码ID_Flex_NumNNumber(15)关键弹性域结构号交义验证规则名称标准who歹ijFlex_Validation_Rule_NameNVarchat2(15)La

19、st_Update_DateNDateLast_Update_ByNNumber(15)标准who歹ijCreation_DateNDate标准who歹ijCreated_ByNNumber(15)标准who歹ijLast_Update_LoginYNumber(15)标准who歹ijEnabled_FlagNVarchar2(l)启用标志Concatenated_Segnients_LowNVarchar2(2000)连接段下限Concatenated_Segments_HighNVarchar2(2000)连接段上限Include.ExcludedicatorNVarchar2(l)包含排

20、除标识DescriptionYVarchar2(240)说明FND_FLEX_EXCLUDE_RULE_LINES名称可为空类型描述RuIe_Line_Id(PK)NNumber(15)交义验证要素标识Application_IdNNumber(lO)应用程序标识ID_Flcx_CodeNVarchar2(4)关键弹性域代码ID_Flex_NumNNumber(15)关键弹性域结构号Flex_Validation_Rule_NameNVarchat2(15)交义验证规则名称Enabled_FlagNVarchar2(l)启用标志Last_Update_DateNDate标准who歹ijLast

21、_Update_ByNNumber(15)标准who歹ijCreation_DateNDate标准who歹ijCreated_ByNNumber(15)标准who歹ijLast_Update_LoginNNumber(15)标准who歹ijSegmentljowYVarchar2(150)排除的最小值Segmentl_HighYVarchar2(150)排除的最大值Segment30_LowNVarchar2(150)排除的最小值Segment30HighYVarchar2(150)排除的最小值FND_FLEXJNCLUDE_RULE_LINES名称可为空类型描述RuIe_Line_Id(PK

22、)NNumber(15)交义验证耍索标识Application_IdNNumber(lO)应用程序标识ID_Flcx_CodeNVarchar2(4)关键弹性域代码ID_Flex_NumNNumber(15)关键弹性域结构号Flex_Validation_Rule_NameNVarchat2(15)交义验证规则名称EnabledFlagNVarchar2(l)启用标志Last_Update_DateNDate标准who列Last_Update_ByNNumber(15)标准who列Creation_DateNDate标准who列Created_ByNNumber(15)标准who列Last_U