FS_BP_BJ_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 5 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 6 | SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |
| 7 | EFFDT_BD | Date(10) | DATE | Effective Date for Budget Defn |
| 8 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 9 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 10 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: KK_CF_TREE_DVW |
| 11 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table: %EDITTABLE4 |
| 12 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 13 | EFFDT_TREE | Date(10) | DATE | Tree Effective Date |
| 14 | VALUE_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Value Required
N=Not Required O=Optional Y=Required |