LED_DEFN_TBL(SQL Table) |
Index Back |
|---|---|
Ledger DefinitionContains valid Ledger Definitions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | LEDGER_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | Ledger Template |
| 5 | LEDGER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger K=Commitment Control Ledger S=Summary Ledger |
| 6 | BUDGET_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Budget Type
AL=Allotment Budget AP=Appropriation Budget IN=Initial Budget IS=Installment Budget OR=Organizational Budget OT=Other PR=Project/Grant Budget RE=Revenue Estimate SU=Supplemental Budget |
| 7 | SCENARIO | Character(10) | VARCHAR2(10) NOT NULL | Scenario |
| 8 | DETAIL_LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Detail Ledger ID |
| 9 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 10 | DETAIL_TMPLT | Character(10) | VARCHAR2(10) NOT NULL | Detail Template |