ACV_NDTPL_IDACV_TPL_DITM_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT T.ACV_NDTPL_ID , F.DATA_ITEM_ID FROM PS_ACV_TPL_DFLD_VW T , PS_CUST_DATA_FIELD F WHERE T.DATA_FIELD_ID = F.DATA_FIELD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACV_NDTPL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Node Template ID |
| 2 | DATA_ITEM_ID | Character(8) | VARCHAR2(8) NOT NULL | Data Item ID |