RB_TD_NDVIEW_VW(SQL View) |
Index Back |
|---|---|
Node ViewNode View |
| SELECT a.TREE_NODE_ID , a.VIEW_NAME ,a.ID_NAME ,b.FIELDNAME ,b.DISPLAY_FLAG ,b.ORDER_BY_FLG , b.DISPLAY_LENGTH ,b.DISPLAY_POSITION ,b.COL_DISPLAY_VALUE ,b.SETID_BASED , b.RECORDNAME ,b.COLUMN_ID FROM PS_RB_TD_VIEW a , PS_RB_TD_VW_FLDS b WHERE a.VIEW_NAME = b.VIEW_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NODE_ID | Character(15) | VARCHAR2(15) NOT NULL | Node ID |
| 2 | VIEW_NAME | Character(30) | VARCHAR2(30) NOT NULL | View Name |
| 3 | ID_NAME | Character(20) | VARCHAR2(20) NOT NULL | ID Fld in View |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | DISPLAY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Display on Chart |
| 6 | ORDER_BY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Order By Flag |
| 7 | DISPLAY_LENGTH | Number(2,0) | SMALLINT NOT NULL | Display Length |
| 8 | DISPLAY_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
Display In
D=Display In second Column (30) I=Display In First Column (20) N=Do Not Show |
| 9 | COL_DISPLAY_VALUE | Character(1) | VARCHAR2(1) NOT NULL |
Display Value
L=Long Translate R=Related Display S=Short Translate V=Value |
| 10 | SETID_BASED | Character(1) | VARCHAR2(1) NOT NULL | Setid Based |
| 11 | RECORDNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_VENDOR_EC 06=ITM_VNDR_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 11=MANUFACTURER_EC 12=ITEM_MFG_EC 13=EN_REVISION_EC |
| 12 | COLUMN_ID | Character(30) | VARCHAR2(30) NOT NULL | Column Name |