PROCESS_INSTANCED=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
1=Include
2=Exclude
3=Default
FS_BP_BULD_AET(SQL Table) |
Index Back |
|---|---|
FS BP: Bus Unit/Ledg Grp DataThe following state record is used in the FS Budget Processor (FS_BP). This state record contains data related to the GLBU//Ledger/Ledger Group combination being processed at any given point. |
| # | 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_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | COMMITMENT_CNTL | Character(1) | VARCHAR2(1) NOT NULL | Enable Commitment Control |
| 6 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |
| 7 | DETAIL_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL | Detail Calendar |
| 8 | KK_ERR_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Stop Budget Check at 1st Error |
| 9 | KK_ALLOW_INC_SA | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Allow Increase Spending Authority |
| 10 | KK_INCLUDE_PRE_ENC | Character(1) | VARCHAR2(1) NOT NULL |
Indicator - Include Pre-Encumbrance in RSA
1=Include 2=Exclude 3=Default |
| 11 | KK_GEN_PARENT | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Generate Parent Budgets |
| 12 | PARENT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Parent Ledger Group |
| 13 | EFFDT_SOURCE | Date(10) | DATE | Effective Date for Journal Source |
| 14 | SQLROWS_STAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 15 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |