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 |