Data Dictionary
>
FPSAPP Tables
> FPSAPP.ETP_L3_E10_STATES
Table FPSAPP.ETP_L3_E10_STATES"
Industry standard level 3 E10 states.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: E10_STATE
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
E10_STATE |
VARCHAR2(3) |
N |
|
|
AVAILABILITY |
VARCHAR2(4) |
N |
|
|
BG_COLOR |
VARCHAR2(24) |
N |
Background color assigned. BG_COLOR is in English like red or blue or light green and we look up the HTML color like #FF0000 in the GEN_COLORS table. BG_COLOR must be set manually but the FPSADMIN view BLD_POPULATE_COLORS will generate queries to randomly set bg_color for all values in a table. (* from FPSINPUT.GEN_CUSTOMERS) |
|
E10_STATE_DISPLAY |
VARCHAR2(48) |
N |
|
|
LONG_DESCRIPTION |
VARCHAR2(1000) |
||
|
MFG_GROUP |
VARCHAR2(6) |
N |
|
|
SORT_WITHIN_AVAIL |
NUMBER(2) |
N |