WORKSHEET_IDFR_ELEMENT_IDPrompt Table: FR_ELMT_TBL
BUSINESS_UNITFR_WORKSHT_GRID(SQL Table) |
Index Back |
|---|---|
Cash Flows Worksheet LinesCash Flows Worksheet Lines |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORKSHEET_ID |
Character(20) | VARCHAR2(20) NOT NULL | Cash Flows Worksheet ID |
| 2 | FR_ELEMENT_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Element ID
Prompt Table: FR_ELMT_TBL |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | BEGINNING_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement beginning balance for a given bank account. |
| 5 | ENDING_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The bank statement end of day account balance |
| 6 | TOTAL_NET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Net Amount |
| 7 | OVERRIDE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Override amount |
| 8 | FR_FX_ADJUSTMENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign Currency Exchange Adjustment Amount |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 11 | DTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |