PROCESS_INSTANCEPrompt Table: %EDITTABLE3
FS_BP_XLCF_AET(SQL Table) |
Index Back |
|---|---|
BP - Translate CF's State RecThe following state record is used in the FS Budget Processor (FS_BP). This state record contains the state record work fields for the ChartField translation sub-program. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 4 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table: %EDITTABLE3 |
| 5 | PARENT_TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL | Parent Tree Level. |
| 6 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 7 | TREE_LEVEL_NUM2 | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 8 | SQLROWS_CFTAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 9 | SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |