FR_DATA_SOURCEPrompt Table: FR_DATA_SOURCE
FIELDNAMEPrompt Table: PSRECFIELDDB
FR_SRC_FLD_VW(SQL View) |
Index Back |
|---|
| SELECT a.fr_data_source , b.fieldname FROM ps_fr_data_source a , psrecfielddb b , PSDBFIELD c WHERE a.recname = b.recname AND b.fieldname = c.fieldname AND c.fieldtype IN (0, 2, 3) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FR_DATA_SOURCE |
Character(10) | VARCHAR2(10) NOT NULL |
Data Source Name
Used in Cash Flow Statement generation
Prompt Table: FR_DATA_SOURCE |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDDB |