FS_MAP_IDFS_MAP_FLD_NAMEFS_MAP_DATA_TYPES=Source
T=Target
FS_MAP_FLD_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FS_MAP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Map ID |
| 2 | FS_MAP_FLD_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Field Name |
| 3 | FS_MAP_DATA_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Data Type
S=Source T=Target |
| 4 | FS_MAP_SEQ | Number(5,0) | INTEGER NOT NULL | Sequence |
| 5 | FS_MAP_NODE | Character(220) | VARCHAR2(220) NOT NULL | Map Node |
| 6 | FS_MAP_NODE_PRE | Character(254) | VARCHAR2(254) NOT NULL | Map Pre Node |
| 7 | FS_MAP_FLD_DISP | Character(254) | VARCHAR2(254) NOT NULL | Display Name |
| 8 | FS_MAP_CURCTL | Character(254) | VARCHAR2(254) NOT NULL | Control Currency |
| 9 | FS_MAP_LEVEL | Number(4,0) | SMALLINT NOT NULL | Level |