FR_DATA_SOURCE(SQL Table) |
Index Back |
|---|---|
Cash Flow Statement Data SrcCash Flow Statement Data Source |
| # | 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 |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |
| 4 | FR_SRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cash Flow Statement Data Source Type
0=Ledger 1=Transaction Table Default Value: 0 |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 6 | LEDGER_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Template
Prompt Table: LED_TMPLT_TBL |
| 7 | FIELDNAME_ACCTDATE | Character(18) | VARCHAR2(18) NOT NULL |
Accounting Date field name
Prompt Table: RECFLDDB_VW |
| 8 | FIELDNAME_BU_GL | Character(18) | VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
Prompt Table: RECFLDDB_VW |
| 9 | FIELDNAME_FRN_AMT | Character(18) | VARCHAR2(18) NOT NULL |
Foreign Amount
Prompt Table: RECFLDDB_VW |
| 10 | FLDNAME_FRN_AMT_CR | Character(18) | VARCHAR2(18) NOT NULL | Credit Foreign Amount |
| 11 | FLDNAME_FRN_AMT_DR | Character(18) | VARCHAR2(18) NOT NULL | Debit Foreign Amount |
| 12 | FIELDNAME_FRN_CUR | Character(18) | VARCHAR2(18) NOT NULL |
Foreign Currency
Prompt Table: RECFLDDB_VW |
| 13 | FIELDNAME_BASE_CUR | Character(18) | VARCHAR2(18) NOT NULL |
Base Currency
Prompt Table: RECFLDDB_VW |
| 14 | FIELDNAME_BASE_AMT | Character(18) | VARCHAR2(18) NOT NULL |
Base Amount
Prompt Table: RECFLDDB_VW |
| 15 | FLDNAME_BAS_AMT_CR | Character(18) | VARCHAR2(18) NOT NULL | Credit Base Amount |
| 16 | FLDNAME_BAS_AMT_DR | Character(18) | VARCHAR2(18) NOT NULL | Debit Base Amount |