MOC_OPTIONS_VW(SQL View) |
Index Back |
|---|---|
Product option table viewThis view is used to store the Product sync options of Attachments size and Images size. |
| SELECT A.SYNCID , A.ATTACH_LAPTOP_SZ , A.ATTACH_PDA_SZ , A.SYNC_LAPTOP_ATTCH , A.SYNC_PDA_ATTCH , A.IMAGE_SIZE_LAPTOP , A.IMAGE_SIZE_PDA , A.SYNCDTTM FROM PS_MOC_OPTIONS_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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. |
| 2 | ATTACH_LAPTOP_SZ | Number(16,3) | DECIMAL(15,3) NOT NULL | Attachment size for laptop |
| 3 | ATTACH_PDA_SZ | Number(16,3) | DECIMAL(15,3) NOT NULL | Attachment size for PDA |
| 4 | SYNC_LAPTOP_ATTCH | Character(1) | VARCHAR2(1) NOT NULL |
sync laptop attachment
A=All Attachments C=Custom Size N=No Attachments Default Value: N |
| 5 | SYNC_PDA_ATTCH | Character(1) | VARCHAR2(1) NOT NULL |
sync PDA attachment
A=All Attachments C=Custom Size N=No Attachments Default Value: N |
| 6 | IMAGE_SIZE_LAPTOP | Character(1) | VARCHAR2(1) NOT NULL |
Image size for Laptop
L=Large Image M=Medium Image N=No Image S=Small Image Z=Zoom Image Default Value: N |
| 7 | IMAGE_SIZE_PDA | Character(1) | VARCHAR2(1) NOT NULL |
Image size on PDA
L=Large Image M=Medium Image N=No Image S=Small Image Z=Zoom Image Default Value: N |
| 8 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |