INSTALLATION_TE(SQL Table) |
Index Back |
|---|---|
Installation Mobile T&EContains fields to define how data is filtered when it is synced. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL | Country | |
| 2 | TE_EXP_DAYS | Number(3,0) | SMALLINT NOT NULL |
Expense Reports
Default Value: 60 |
| 3 | TE_TIME_DAYS | Number(3,0) | SMALLINT NOT NULL |
Time Reports
Default Value: 60 |
| 4 | TE_CNTRL_DAYS | Number(3,0) | SMALLINT NOT NULL |
Setup Data
Default Value: 60 |
| 5 | TE_CURR_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Allow currency selection
Y/N Table Edit Default Value: N |
| 6 | TE_PROJECT_MAX | Number(3,0) | SMALLINT NOT NULL |
Maximum Number of Projects
Default Value: 25 |
| 7 | TE_LOCATION_MAX | Number(3,0) | SMALLINT NOT NULL |
Maximum Number of Locations
Default Value: 25 |
| 8 | TE_FILTER_SYNC | Character(1) | VARCHAR2(1) NOT NULL |
Turn on Filtered Sync.
Y/N Table Edit Default Value: Y |