BO_TYPE_IDBO_TYPE_ABE_VW(SQL View) |
Index Back |
|---|---|
Address Book Configuration VwAddress Book Configuration View |
| SELECT BO_TYPE_ID , DESCR , DESCRSHORT , SYNCID , SYNCDTTM FROM PS_BO_TYPE WHERE BO_TYPE_ID IN (1, 2) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_TYPE_ID |
Number(6,0) | INTEGER NOT NULL | ID Type |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 5 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |