CCR_LED_GRP_LED(SQL Table) |
Index Back |
|---|---|
Ledger Analysis Resutls |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ANALYSIS_ID |
Character(10) | VARCHAR2(10) NOT NULL | Analysis ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | 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 |
| 7 | INHERIT_BASE_CUR | Character(1) | VARCHAR2(1) NOT NULL |
Inherit Base Currency
Y/N Table Edit |
| 8 | 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. " |
| 9 | DISPLAY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Display Currency |
| 10 | TRANSL_LEDGER | Character(1) | VARCHAR2(1) NOT NULL |
Currency Translation Ledger
Y/N Table Edit |
| 11 | OPEN_ITEM_LEDGER | Character(1) | VARCHAR2(1) NOT NULL |
Maintain OpenItem Balances
Y/N Table Edit |
| 12 | NEW_LEDGER | Character(10) | VARCHAR2(10) NOT NULL | New Ledger |
| 13 | NEW_SETID | Character(5) | VARCHAR2(5) NOT NULL | New SetID |
| 14 | NEW_PRIMARY_LEDGER | Character(1) | VARCHAR2(1) NOT NULL |
New Primary Ledger
Y/N Table Edit |
| 15 | NEW_IN_BASE_CUR | Character(1) | VARCHAR2(1) NOT NULL |
New Inherit Base Currency
Y/N Table Edit |
| 16 | NEW_BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | New Base Currency |
| 17 | NEW_DISP_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | New Base Currency |
| 18 | NEW_TRANSLATE_LED | Character(1) | VARCHAR2(1) NOT NULL |
New Translate Ledger
Y/N Table Edit |
| 19 | LEDGER_GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Group Type
A=Average Daily Balance B=Budget E=Commitment Control Expense R=Commitment Control Revenue S=Standard T=Translation |
| 20 | DROP_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | Drop Ledger |
| 21 | TEMP_LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Temp. Ledger |