BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW
LEDGER_GROUPDefault Value: OPR_DEF_TBL_GL.KK_LEDGER_GROUP
Prompt Table: SP_KKBULG_NONVW
KK_INQ_BDTL_VW(SQL View) |
Index Back |
|---|---|
Search record of KK_INQ_BD_DTLSearch record of KK_INQ_BD_DETAIL. Only include GL business unit and KK ledger group. |
| SELECT BUSINESS_UNIT , KK_LEDGER_GROUP LEDGER_GROUP FROM PS_BUL_CNTL_BUD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Default Value: OPR_DEF_TBL_GL.KK_LEDGER_GROUP Prompt Table: SP_KKBULG_NONVW |