MOC_OPTIONS_TBL

(SQL Table)
Index Back

Syncronisation options table.

Mobile default product options syncronisation base table. This table stores the maximum Image size and Attachment size values.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ATTACH_LAPTOP_SZ Number(16,3) DECIMAL(15,3) NOT NULL Attachment size for laptop
2 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.
3 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
4 ATTACH_PDA_SZ Number(16,3) DECIMAL(15,3) NOT NULL Attachment size for PDA
5 SYNC_LAPTOP_ATTCH Character(1) VARCHAR2(1) NOT NULL sync laptop attachment
A=All Attachments
C=Custom Size
N=No Attachments

Default Value: N

6 SYNC_PDA_ATTCH Character(1) VARCHAR2(1) NOT NULL sync PDA attachment
A=All Attachments
C=Custom Size
N=No Attachments

Default Value: N

7 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

8 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