SETID1Prompt Table: KK_BUDGET_TYPE
Prompt Table: KK_BUDGET_TYPE
LEDGERLEDGER_TYPE_KK0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
LG_S1(SQL Table) |
Index Back |
|---|---|
Work Record for Ledger MappingRel 9.1 for ledger mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID1 |
Character(5) | VARCHAR2(5) NOT NULL |
SetID Value
Prompt Table: KK_BUDGET_TYPE |
| 2 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: KK_BUDGET_TYPE |
| 3 | LEDGER_GROUP_2 | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | LEDGER_2 | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 6 | LEDGER_TYPE_KK |
Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Ledger Type
0=Budget 1=Expense or Recognized Revenue 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned |