SETID1Prompt Table: SP_SETID_NONVW
LEDGER_GROUPEFFDTCALENDAR_IDPrompt Table: CAL_BP_VW
BUDGET_PERIODPrompt Table: KK_TMP_BP_DVW
0=Open
1=Closed
2=Hold
3=Default
Default Value: 0
KK_BT_BP_VALUE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID1 |
Character(5) | VARCHAR2(5) NOT NULL |
SetID Value
Prompt Table: SP_SETID_NONVW |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: CAL_BP_VW |
| 5 | BUDGET_PERIOD |
Character(8) | VARCHAR2(8) NOT NULL |
Budget Period
Prompt Table: KK_TMP_BP_DVW |
| 6 | BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
0=Open 1=Closed 2=Hold 3=Default Default Value: 0 |