FS_BP_LGRP_AET(SQL Table) |
Index Back |
|---|---|
BP - KK Ledger Group StateBudget Process - State record that contain data related to the commitment control ledger group being processed by the Do Select in FS_BP_BULD. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 | KK_LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Control Budget Ledger Group
Prompt Table:
SP_KKBDLG_NONVW
|
| 5 | EE_GL_BUD | Character(1) | VARCHAR2(1) NOT NULL |
Entry Event Options GL Budgets
N=Disabled O=Optional R=Required |
| 6 | KK_DETAIL_LED | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Detail Ledger
Y/N Table Edit |
| 7 | LEDGER_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | Ledger Template |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 9 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 10 | CONCAT_STRING2 | Character(60) | VARCHAR2(60) NOT NULL | Concat String |