PROCESS_INSTANCEY/N Table Edit
Y/N Table Edit
0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
FS_MC_LDGER_AET(SQL Table) |
Index Back |
|---|---|
FS MC - ledger state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 3 | PRIMARY_LEDGER | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
Y/N Table Edit |
| 4 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 5 | TRANSL_LEDGER | Character(1) | VARCHAR2(1) NOT NULL |
Currency Translation Ledger
Y/N Table Edit |
| 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 |