CNAO_REPORT_TPBALN=Balance Sheet Statement
CSFL=Cash Flow Statment
EQTY=Statement of Change in Equity
INCM=Income Statement
CNAO_REPORT_SET(SQL Table) |
Index Back |
|---|---|
CNAO Report Set |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNAO_REPORT_TP |
Character(4) | VARCHAR2(4) NOT NULL |
CNAO report type, includes 'BALN'( Balance Sheet), 'INCM' (Income Statement), 'CSFL' (Cash Flow Statement), 'EQTY' (Statment of Change in Equity).
BALN=Balance Sheet Statement CSFL=Cash Flow Statment EQTY=Statement of Change in Equity INCM=Income Statement |
| 2 | CNAO_REPORT_ID | Character(20) | VARCHAR2(20) NOT NULL | CNAO Report ID. |
| 3 | REPORT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Report Name |
| 4 | CURRENCY_UNIT | Character(30) | VARCHAR2(30) NOT NULL | Currency Unit |