CSFL_ITEM_NO1=Level 1
2=Level 2
3=Level 3
4=Level 4
5=Level 5
6=Level 6
7=Level 7
0=Outflow
1=Inflow
2=Other
0=No
1=Yes
Prompt Table: CNAO_PARENT_CFI
0=Assistant Table/Appendix
1=Primary Table
CNAO_CSFL_ITEM(SQL Table) |
Index Back |
|---|---|
Cash Flow ItemsCNAO2 Use This Record to Define Cash Flow Items. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CSFL_ITEM_NO |
Character(60) | VARCHAR2(60) NOT NULL | Cash Flow Item ID |
| 2 | CSFL_ITEM_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Cash Flow Item Level
1=Level 1 2=Level 2 3=Level 3 4=Level 4 5=Level 5 6=Level 6 7=Level 7 |
| 3 | CSFL_ITEM_ATTR | Character(1) | VARCHAR2(1) NOT NULL |
Cash Flow Item Attribute
0=Outflow 1=Inflow 2=Other |
| 4 | CFI_BTM_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Last Level
0=No 1=Yes |
| 5 | CSFL_ITEM_NM | Character(200) | VARCHAR2(200) NOT NULL | Cash Flow Item Name |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | CFI_PARENT | Character(60) | VARCHAR2(60) NOT NULL |
Parent Cash Flow Item
Prompt Table: CNAO_PARENT_CFI |
| 8 | CFI_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Cash Flow Item Source
0=Assistant Table/Appendix 1=Primary Table |