CSFL_RPT_IDCSFL_LINE_NOSEQNBRDefault Value: 0
Prompt Table: CNAO_CSFL_ITEM
0=Label Item
1=Detail Item
2=Derived Item
CNAO_CSFL_RPT_I(SQL Table) |
Index Back |
|---|---|
CNAO Cash Flow Rpt LinesCNAO cash flow statement lines table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CSFL_RPT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Cash Flow Report ID |
| 2 | CSFL_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Line Number |
| 3 | SEQNBR |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 0 |
| 4 | CSFL_ITEM_NO | Character(60) | VARCHAR2(60) NOT NULL |
Cash Flow Item ID
Prompt Table: CNAO_CSFL_ITEM |
| 5 | CALC_SEQ | Number(2,0) | SMALLINT NOT NULL | Calculation Sequence |
| 6 | CSFL_ITEM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Item Type
0=Label Item 1=Detail Item 2=Derived Item |
| 7 | CALC_FORMULA | Character(254) | VARCHAR2(254) NOT NULL | Calculation Formula |