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 | PROCESS_INSTANCE | 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 |