FO_OI_TG_IDFO_TGROUP_SRCH(SQL View) |
Index Back |
|---|---|
Transaction Group SearchTransaction Group Search Record |
| SELECT FO_OI_TG_ID , FO_OI_TG_NAME , FO_OI_TG_DESCR , FO_OI_TG_VER FROM PS_FO_TGROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_OI_TG_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Transaction Group ID |
| 2 | FO_OI_TG_NAME | Character(15) | VARCHAR2(15) NOT NULL | Transaction Group Name |
| 3 | FO_OI_TG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Transaction Group Description |
| 4 | FO_OI_TG_VER | Number(4,0) | SMALLINT NOT NULL | Transaction Group Version |