FUS_CF_VS_VALMT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VALUE_ID | Signed Number(19,0) | DECIMAL(18) NOT NULL | VALUE_ID |
| 2 | VALUE_SET_ID | Signed Number(19,0) | DECIMAL(18) NOT NULL | VALUE_SET_ID |
| 3 | VALUE_SET_CODE | Character(60) | VARCHAR2(60) NOT NULL | Fusion Value Set Code |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | VALUE150 | Character(150) | VARCHAR2(150) NOT NULL | Fusion Value Set Value |
| 7 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 9 | END_DATE | Date(10) | DATE | End Date |
| 10 | DESCR240 | Character(240) | VARCHAR2(240) NOT NULL | Description |
| 11 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag indicates whether this row is enabled or not. |
| 12 | SUMMARY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Summary Flag |
| 13 | ATTRIBUTE_CATEGORY | Character(240) | VARCHAR2(240) NOT NULL | Attr Category |
| 14 | FLEX_VALUE_ATTR1 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 1 |
| 15 | FLEX_VALUE_ATTR2 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 2 |
| 16 | FLEX_VALUE_ATTR3 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 3 |
| 17 | FLEX_VALUE_ATTR4 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 4 |
| 18 | FLEX_VALUE_ATTR5 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 5 |
| 19 | FLEX_VALUE_ATTR6 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 6 |
| 20 | FLEX_VALUE_ATTR7 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 7 |
| 21 | FLEX_VALUE_ATTR8 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 8 |
| 22 | FLEX_VALUE_ATTR9 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 9 |
| 23 | FLEX_VALUE_ATTR10 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 10 |
| 24 | FLEX_VALUE_ATTR11 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 11 |
| 25 | FLEX_VALUE_ATTR12 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 12 |
| 26 | FLEX_VALUE_ATTR13 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 13 |
| 27 | FLEX_VALUE_ATTR14 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 14 |
| 28 | FLEX_VALUE_ATTR15 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 15 |
| 29 | FLEX_VALUE_ATTR16 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 16 |
| 30 | FLEX_VALUE_ATTR17 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 17 |
| 31 | FLEX_VALUE_ATTR18 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 18 |
| 32 | FLEX_VALUE_ATTR19 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 19 |
| 33 | FLEX_VALUE_ATTR20 | Character(30) | VARCHAR2(30) NOT NULL | Flex Attribute 20 |
| 34 | ENTERPRISE_ID | Signed Number(19,0) | DECIMAL(18) NOT NULL | ENTERPRISE_ID |