PROCESS_INSTANCEFS_BP_SETID_AET(SQL Table) |
Index Back |
|---|---|
BP: Setid StateState record used to store the SETID values for all commonly used record groups (e.g. Ledgers, Calendars, CFs...) |
| # | 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_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | SETID_LEDGER | Character(5) | VARCHAR2(5) NOT NULL | Ledger Table Setid |
| 4 | SETID1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 5 | SETID_CAL_DETP | Character(5) | VARCHAR2(5) NOT NULL | Calendar SetId |
| 6 | SETID_BPCAL | Character(5) | VARCHAR2(5) NOT NULL | Calendar Setid |
| 7 | SETID_ACCOUNT | Character(5) | VARCHAR2(5) NOT NULL | Account Table Setid |
| 8 | SETID_ACCTYPE | Character(5) | VARCHAR2(5) NOT NULL | Account Type Setid |
| 9 | SETID_TREE | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 10 | SETID_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 11 | SETID_EE | Character(5) | VARCHAR2(5) NOT NULL | Entry Event Setid |
| 12 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 13 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 14 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 15 | KK_LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Control Budget Ledger Group |