Loading content, please wait.. loading..

Developed and Extracted By
MGBSS
GENERAL LEDGER SETUP DETAILS REPORT

EXTRACT DATE CUSTOMER NAME
16-SEP-2011 VISION CORPORATION

INSTANCE_NAME HOST_NAME DATABASE_VERSION APPLICATION_VERSION
VIS linuxr12.com 11.1.0.7.0 12.1.1

INDEX
1.Ledgers
2.Ledger Sets
3.Ledgers attached to Ledger Sets
4.Period Set and Period Type definitions attached to ledgers
5.Calendars
6.Currency
7.Currency Conversion Type
8.Data Access Set
9.Data Definition Access Set
10.Data Definition Access Set Assignments
11.Journal Source
12.Journal Category
13.Encumbrance Type
14.Transaction Calendars
15.Autopost Criteria Set
16.Auto Reversal Criteria Set
17.Statistical Units of Measure
18.Chart of Accounts Structures
19.Segments
20.Value Sets
21.Segment Values
22.Child Ranges
23.Rollup Groups
24.Security Rules
25.Security Rules Assignments
26.Cross Validation Rules
27.Cross Validation Rule Lines
28.Account Generator Processes
29.Budgets
30.Budget Organization and Range Assignments
31.Summary Templates
32.FSG Row Set
33.FSG Column Set
34.FSG Content Set
35.FSG Row Order
36.FSG Display Set
37.FSG Display Group
38.FSG Reports
39.FSG Report Sets
40.Mass Allocation Batch - Formula - Lines
41.Recurring Journal Formula
42.Consolidation
43.Consolidation Mapping with Segment Rule
44.Consolidation Mapping with Account Rule
45.Consolidation Set
46.Elimination Set and Journals
47.Elimination Set Balancing Options


1.Ledgers [Top-Index]

LEDGER_ID NAME SHORT_NAME DESCRIPTION LEDGER_CATEGORY_CODE COMPLETION_STATUS_CODE CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE FIRST_LEDGER_PERIOD_NAME RET_EARN_CODE_COMBINATION_ID SUSPENSE_ALLOWED_FLAG ALLOW_INTERCOMPANY_POST_FLAG TRACK_ROUNDING_IMBALANCE_FLAG ENABLE_AVERAGE_BALANCES_FLAG CUM_TRANS_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID ENABLE_BUDGETARY_CONTROL_FLAG REQUIRE_BUDGET_JOURNALS_FLAG ENABLE_JE_APPROVAL_FLAG ENABLE_AUTOMATIC_TAX_FLAG CONSOLIDATION_LEDGER_FLAG TRANSLATE_EOD_FLAG TRANSLATE_QATD_FLAG TRANSLATE_YATD_FLAG TRANSACTION_CALENDAR_ID DAILY_TRANSLATION_RATE_TYPE AUTOMATICALLY_CREATED_FLAG BAL_SEG_VALUE_OPTION_CODE BAL_SEG_COLUMN_NAME MGT_SEG_VALUE_OPTION_CODE MGT_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID FUTURE_ENTERABLE_PERIODS_LIMIT LATEST_OPENED_PERIOD_NAME LATEST_ENCUMBRANCE_YEAR PERIOD_AVERAGE_RATE_TYPE PERIOD_END_RATE_TYPE BUDGET_PERIOD_AVG_RATE_TYPE BUDGET_PERIOD_END_RATE_TYPE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_DESCRIPTION_LANGUAGE SLA_ENTERED_CUR_BAL_SUS_CCID SLA_SEQUENCING_FLAG SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID ENABLE_SECONDARY_TRACK_FLAG ENABLE_REVAL_SS_TRACK_FLAG ENABLE_RECONCILIATION_FLAG CREATE_JE_FLAG SLA_LEDGER_CASH_BASIS_FLAG COMPLETE_FLAG COMMITMENT_BUDGET_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY
1024 2546RT FR Corp Ledger Set 2546RT FR Corp LS 2546Corporate Ledger Set SSC US and RT France Ledgers NONE   53213 X Accounting13 Month X -1 N N N N         N N N N N N N N     N I SEGMENT1 I   1020013   0                               N N       26-SEP-08 1322 26-SEP-08 1322
1018 2546RT France Ledger 2546RT Fran1018(EUR) Any Description text for primary Ledger PRIMARY   53213 EUR Accounting13 Month 12-05 136665 Y Y Y N 331043     136667 N N N N N N N N     N I SEGMENT1 A   1020013   1 12-05 2005 Period Average875 Period End875     STANDARD_ACCRUAL S US 136666   Y 136666     Y Y N Y   26-SEP-08 1322 26-SEP-08 1322
1019 2546RT France Ledger(USD) 2546RT France L(USD) RT France ledger ALC (USA) ALC   53213 USD Accounting13 Month 12-05 136665 Y Y Y N       136667 N N N N N N N N     N I SEGMENT1 A   1020013   1 12-05 2005         STANDARD_ACCRUAL S US 136666   Y 136666     Y Y N Y   26-SEP-08 1322 26-SEP-08 1322
1022 2546RT France Sec Ledger 2546RT Fran1022(EUR) Description Text for Secondary Ledger SECONDARY   53253 EUR Accounting13 Month 12-05 147437 Y Y Y N 147439 147440   147438 Y N N N N N N N     N I SEGMENT1 A   1020013   1 12-05 2005 Period Average875 Period End875     ENCUMBRANCE_ACCRUAL_IT C US 147436   Y 147436     N Y N Y   26-SEP-08 1322 26-SEP-08 1322
629 FED Set of Books FED ITSA FED ITSA Set of Books PRIMARY CONFIRMED 52594 USD 16 Period 165 ADJ1-97-98 121870 Y Y N N 121870 121871     Y Y Y N N N N N     N A SEGMENT2 A   1015695   16 Oct-04-05 2006         ENCUMBRANCE_ACCRUAL S US 121871 N N   N N Y Y N Y   03-MAY-04 1008228 11-AUG-06 1
393 GASB34 GASB34 Progress State and Local GASB 34 Reporting SECONDARY CONFIRMED 51088 USD GOV Calendar 21 JUL-01 84611 N Y N N   27509   28012 N N N N N N N N     N I SEGMENT1 A   1006755   4 OCT-09 2008         GASB ACCRUAL C US 28011 N N   N N Y Y N Y   24-APR-02 1000354 18-JAN-07 1000354
650 IAS Reporting Vision Ops Vision IFRS/IAS Ops International Financial Reporting Standards (IFRS/IAS) Sec. Ledger for Vision Op erations SECONDARY CONFIRMED 101 USD Accounting Month Dec-03 12827 Y Y Y N 12829     27120 N N N N N N N N     N I SEGMENT1 A   1002470   2 Dec-12 2008         STANDARD_ACCRUAL S US 12828 N N   N N Y Y N Y   28-JUN-04 1008481 11-SEP-06 1055
1056 MK Consolidation LS MKCLS   NONE   53556 X MK Calendar 186 X -1 N N N N         N N N N N N N N     N I SEGMENT1 I SEGMENT3 1025258 1025260 0                               N N       07-JUL-11 1013423 07-JUL-11 1013423
1054 MK Consolidation USA MK Consolid1054(USD)   PRIMARY   53556 USD MK Calendar 186 Apr-11 332073 N N N N         N N N N N N N N     N A SEGMENT1 A SEGMENT3 1025258 1025260 1 Aug-11 2012                       N N Y Y N Y   07-JUL-11 1013423 07-JUL-11 1013426
1053 MK Ledger Set MKLS MK Ledger Set NONE   53556 X MK Calendar 186 X -1 N N N N         N N N N N N N N     N I SEGMENT1 I SEGMENT3 1025258 1025260 0                               N N       01-JUL-11 1013423 01-JUL-11 1013423
1049 MK Primary MK Primary1049(INR)   PRIMARY   53556 INR MK Calendar 186 Apr-11 332073 N Y N N   332143     N N N N N N N N     N I SEGMENT1 A SEGMENT3 1025258 1025260 1 Aug-11 2012         STANDARD_ACCRUAL S US     N   N N Y Y N Y   01-JUL-11 1013423 09-JUL-11 1013423
1050 MK US Reporting Ledger MK US Repor1050(USD)   SECONDARY   53556 USD MK Calendar 186 Apr-11 332073 N N N N         N N N N N N N N     N I SEGMENT1 A SEGMENT3 1025258 1025260 1 Jul-11 2012                       N N Y Y N Y   01-JUL-11 1013423 01-JUL-11 1013423
1038 NKS_IND_PRIMARY_LEDGER NKS_IND_PRI1038(INR)   PRIMARY   53542 INR NKS_Calendar 185 Mar-11 332054 Y N Y N 332057     332056 N N N N N N N N     N I SEGMENT1 A   1025247   1 Jul-11 2011         NKS_SLA_METHOD C US     N       Y Y N Y   02-MAR-11 1013416 02-JUL-11 1013416
1044 NKS_SECONDARY_LEDGER NKS_SECONDA1044(INR)   SECONDARY   53542 INR NKS_Calendar 185 Mar-11 332054 N N N N         N N N N N N N N     N I SEGMENT1 A   1025247   1                               Y Y N Y   09-MAR-11 1013416 09-MAR-11 1013416
165 OPM US OPM US OPM US Books PRIMARY CONFIRMED 50671 USD OPM 64 JAN-00 21409 Y Y N N 21411       N N N Y N N N N     N A SEGMENT1 A   1005183   3 DEC-12 2005         STANDARD_ACCRUAL_OPM C US 21410 N N   N N Y Y N Y   03-SEP-99 1318 29-JAN-07 2330
352 PS Germany DE Amt Germany Public Sector PRIMARY CONFIRMED 51623 EUR Accounting13 Month 13-99 82102 Y Y N N 82103 100069   100068 Y N N N N N N N     N A SEGMENT1 A   1010797   3 10-08 2003 Period Average352 Period End352 Period Average B352 Period End B352 ENCUMBRANCE_ACCRUAL S US 100067 N N   N N Y Y N Y   08-FEB-02 2045 11-AUG-06 1
994 Progress All Ledgers Progress All Ledgers Progress State and Local - All Ledgers NONE   51088 X GOV Calendar 21 X -1 N N N N         N N N N N N N N     N I SEGMENT1 I   1006755   0                               N N       27-APR-07 1000354 27-APR-07 1000354
692 Progress Average Daily Balance Progress ADB Progress State & Local Average Daily Balance PRIMARY CONFIRMED 51088 USD GOV Calendar 21 JAN-05 30186 N Y N Y     128769   N N N N N Y N N 1 Corporate N A SEGMENT1 A   1006755   24 APR-07 2007         STANDARD_ACCRUAL S US   N N   N N Y Y N Y   29-MAR-05 1000354 11-AUG-06 1
733 Progress BE PS BE BE Public Sector PRIMARY CONFIRMED 52922 EUR Accounting13 Month 12-03 131009 N Y N N 131010 131011     Y Y N Y N N N N     N A SEGMENT1 A   1018757   4 07-05 2005 Period Average733 Period End733 Period Average B733 Period End B733 ENCUMBRANCE_ACCRUAL S US   N N   N N Y Y N Y   25-MAY-05 1001406 11-AUG-06 1
734 Progress BE (Cash) PS BE (Cash) BE Public Sector Cash SOB SECONDARY CONFIRMED 52922 EUR Accounting13 Month 12-03 131009 N Y N N 131010       N N N Y N N N N     N A SEGMENT1 A   1018757   4 06-05 2003 Period Average734 Period End734     STANDARD_CASH S US   N N   N N Y Y Y Y   25-MAY-05 1001406 11-AUG-06 1
591 Progress Canada Progress Canada Vision Progress Canada Set of Books PRIMARY CONFIRMED 52362 CAD Progress Canda Month MAR-01 114764 Y N N N 114766 114767     Y N N N N N N N     N A SEGMENT1 A   1014474   4 SEP-06 2006         ENCUMBRANCE_ACCRUAL S US 114765 N N   N N Y Y N Y   21-OCT-03 1318 11-AUG-06 1
413 Progress FR Progress France Public Sector SOB France PRIMARY CONFIRMED 51704 EUR Accounting13 Month 12-01 86132 Y N N N   86134     Y Y N N N N N N     N A SEGMENT3 A   1011161   1 10-08 2004 Period Average413 Period End413 Period Average B413 Period End B413 ENCUMBRANCE_ACCRUAL S US 86133 N N   N N Y Y N Y   01-AUG-02 1004072 11-AUG-06 1
268 Progress State and Local GOV Progress State & Local Set of Books PRIMARY CONFIRMED 51088 USD GOV Calendar 21 JUL-00 30186 Y Y N N   27509   28012 Y Y N N N N N N     N I SEGMENT1 A   1006755   24 OCT-09 2009         ENCUMBRANCE_ACCRUAL S US 28011 N N   N N Y Y N Y   08-AUG-00 1000314 27-APR-07 1000354
609 Progress State and Local Cash GOV CASH Progress State & Local Cash Basis Set of Books SECONDARY CONFIRMED 51088 USD GOV Calendar 21 JUL-04 30186 Y Y Y N   27509   28012 Y N N N N N N N     N I SEGMENT1 A   1006755   24 OCT-09 2008         ENCUMBRANCE_CASH S US 28011 N N   N N Y Y Y Y   24-MAR-04 1000354 22-APR-08 1000354
289 Progress UK Progress UK UK Public Services PRIMARY CONFIRMED 51213 GBP Fiscal - 14 104 OPEN-99/00 32111 Y N N N 32113 32266     Y N Y N N N N N     N A SEGMENT6 A   1007965   1 OCT-08/09 2009         PSUK_ENCUMBRANCE_ACCRUAL C US 32112 N N   N N Y Y N Y   07-FEB-01 1318 27-FEB-08 1001406
713 Progress UK Health Services UKHS UK Health Services PRIMARY CONFIRMED 52902 GBP Fiscal - 14 104 OPEN-04/05 130989 Y N N N         N N N N N N N N     N A SEGMENT1 A   1018696   6 JUL-05/06 2005         STANDARD_ACCRUAL S US 130990 N N   N N Y Y N Y   23-MAY-05 1001406 11-AUG-06 1
853 Progress UK WGA Consolidated WGA Progress UK WGA Consolidated PRIMARY CONFIRMED 53173 GBP Fiscal - 14 104 OPEN-05/06 135627 Y N N N         N N N N N N N N     N A SEGMENT1 A   1007965   1 DEC-05/06 2006         STANDARD_ACCRUAL S US 135587 N N   N N Y Y N Y   05-DEC-05 1001406 11-AUG-06 1
974 SSC All SSC All SSC All Ledgers Set (53213) NONE   53213 X Accounting13 Month X -1 N N N N         N N N N N N N N     N I SEGMENT1 I   1020013   0                               N N       11-SEP-06 1011771 11-SEP-06 1011771
875 SSC France SSC France SSC France PRIMARY CONFIRMED 53213 EUR Accounting13 Month 13-04 136665 Y Y Y N       136667 N N N N N N N N     N I SEGMENT1 A   1020013   1 10-08 2004 Period Average875 Period End875 Period Average B875 Period End B875 STANDARD_ACCRUAL S US 136666 N N   N N Y Y N Y   18-MAY-06 1011771 31-AUG-06 1011771
916 SSC France ALC (USD) SSC FR ALC (USD) SSC France Additional Ledger Currency (USD) ALC   53213 USD Accounting13 Month 12-04 136665 Y Y Y N       139428 N N N N N N N N     N I SEGMENT1 A   1020013   1 06-08 2004 Period Average875 Period End875     STANDARD_ACCRUAL S US 136666   N   N N Y Y N Y   31-AUG-06 1011771 31-AUG-06 1011771
914 SSC France SL (EUR) SSC FR SL (EUR) SSC France Secondary Ledger (EUR) (Differs fr. PL in Account & Nature segments) SECONDARY   53253 EUR Accounting13 Month 12-04 147437 Y Y Y N 147439 147440   147438 N N N N N N N N     N I SEGMENT1 A   1020013   1 12-08 2004 Corporate Corporate     FR_ACCRUAL C US 147436   N       N Y N Y   31-AUG-06 1011771 19-FEB-07 1011771
876 SSC Italy SSC Italy SSC Italy PRIMARY CONFIRMED 53213 EUR Accounting13 Month 13-04 136668 Y Y Y N       136670 N N N N N N N N     N I SEGMENT1 A   1020013   1 10-08 2004 Period Average876 Period End876 Period Average B876 Period End B876 STANDARD_ACCRUAL S US 136669 N N   N N Y Y N Y   18-MAY-06 1011771 31-AUG-06 1011771
919 SSC Italy ALC (USD) SSC IT ALC (USD) SSC Italy Additional Ledger Currency (USD) ALC   53213 USD Accounting13 Month 12-04 136668 Y Y Y N       139447 N N N N N N N N     N I SEGMENT1 A   1020013   1 06-08 2004 Period Average876 Period End876     STANDARD_ACCRUAL S US 136669   N   N N Y Y N Y   31-AUG-06 1011771 31-AUG-06 1011771
917 SSC Italy SL (EUR) SSC IT SL (EUR) SSC Italy Secondary Ledger (EUR) (Differs fr. PL in Account segment) SECONDARY   53254 EUR Accounting13 Month 12-04 147443 Y Y Y N 147446 147447   147445 Y N N N N N N N     N I SEGMENT1 A   1020013   1 12-08 2004 Corporate Corporate                       N Y N Y   31-AUG-06 1011771 31-AUG-06 1011771
874 SSC US SSC US SSC US PRIMARY CONFIRMED 53213 USD Accounting13 Month 13-04 136662 Y Y Y N       136664 N N N N N N N N     N I SEGMENT1 A   1020013   1 10-08 2004         STANDARD_ACCRUAL S US 136663 N N   N N Y Y N Y   18-MAY-06 1011771 11-AUG-06 1
1048 Test Ledger Test   NONE   53549 X Accounting13 Month X -1 N N N N         N N N N N N N N     N I SEGMENT1 I SEGMENT2 1002470 1002471 0                               N N       23-MAR-11 1318 23-MAR-11 1318
1046 Test Primary Ledger Test Primar1046(INR)   PRIMARY   53549 INR Accounting13 Month 12-98 332058 N N N N         N N N N N N N N     N A SEGMENT1 A SEGMENT2 1002470 1002471 1 03-11 1998         STANDARD_ACCRUAL S US     N       Y Y N Y   23-MAR-11 1318 29-MAR-11 1013419
332 US Federal USFED US Federal Set of Books PRIMARY CONFIRMED 51549 USD Federal 124 OCT-adj/98-99 321994 Y N Y N   321993   321993 Y Y N N N N N N     N I SEGMENT2 A   1010703   8 OCT/08-09 2008         UNITED_STATES_FEDERAL S US 321993 N N   N N Y Y N Y   04-FEB-02 1318 26-FEB-08 1003399
42 Vision ADB (USA) Vision ADB Vision ADB (USA) Set of Books PRIMARY CONFIRMED 50214 USD Accounting Month Dec-95 86163 Y Y N Y 86164   13928   N N Y N N Y N N 1 Spot N A SEGMENT1 A   1002722   1 Oct-08 2002 Period Average42 Period End42     BANKING_US_GAAP C US 86165 N N   N N Y Y N Y   02-FEB-96 1097 20-AUG-07 1012657
82 Vision ADB Holdings (UK) Vision ADB Holdings Vision ADB Holdings (UK) Consolidated Set of Books PRIMARY CONFIRMED 50274 GBP Accounting Month Dec-95 15534 Y Y N Y 15906   15537   N N N N Y Y N N   Spot N A SEGMENT1 A   1002722   1 Feb-05 1997         STANDARD_ACCRUAL S US 15535 N N   N N Y Y N Y   03-APR-97 1097 11-AUG-06 1
501 Vision Argentina Adjusted Vision Arg ADJ Vision Argentina Adjusted SOB SECONDARY CONFIRMED 51974 ARS Accounting13 Month 11-02 92130 Y Y N N 92132       N N N N N N N N     N A SEGMENT1 A   1002470   4 10-08 2002         STANDARD_ACCRUAL S US 92131 N N   N N Y Y N Y   31-JAN-03 1318 11-AUG-06 1
500 Vision Argentina Historic Vision Argentina Vision Argentina Historic SOB PRIMARY CONFIRMED 51974 ARS Accounting13 Month 11-02 92130 Y Y N N 92132       N N N N N N N N     N A SEGMENT1 A   1002470   4 10-08 2002         STANDARD_ACCRUAL S US 92131 N N   N N Y Y N Y   31-JAN-03 1318 11-AUG-06 1
330 Vision Australia AU Vision Australian Set of Books PRIMARY CONFIRMED 51306 AUD Accounting Month Jul-02 40613 Y Y N N 40615       N N N N N N N N     N A SEGMENT1 A   1008055   4 Oct-08 2002         STANDARD_ACCRUAL S US 40614 N N   N N Y Y N Y   06-MAR-01 1001365 11-AUG-06 1
248 Vision Bank - London (GBP) VBLGBP Vision Bank - London (GBP) Set of Books PRIMARY CONFIRMED 50978 GBP Accounting Month Jan-99 25369 Y Y N Y 25371   25372   N N N N N Y N N 1 Corporate N A SEGMENT1 A   1005692   2 Oct-08 1999         INSTITUTIONAL_BANKING_UK_GAAP C US 25370 N N   N N Y Y N Y   23-FEB-00 1238 20-AUG-07 1012657
250 Vision Bank - London MRC (EUR) VBLEUR Vision Bank - London MRC (EUR) ALC CONFIRMED 50978 EUR Accounting Month Dec-95 25369 Y Y N Y 25371   25372   N N N N N Y N N 1 Corporate N A SEGMENT1 A   1005692   2 Oct-08 1995         INSTITUTIONAL_BANKING_UK_GAAP C US 25370 N N   N N Y Y N Y   23-FEB-00 2653 23-AUG-07 1012657
249 Vision Bank - London MRC (USD) VBLUSD Vision Bank - London MRC (USD) ALC CONFIRMED 50978 USD Accounting Month Dec-95 25369 Y Y N Y 25371   25372   N N N N N Y N N 1 Corporate N A SEGMENT1 A   1005692   2 Oct-08 1995         INSTITUTIONAL_BANKING_UK_GAAP C US 25370 N N   N N Y Y N Y   23-FEB-00 2653 23-AUG-07 1012657
998 Vision Bank London (US GAAP) Vision Bank 998(USD) Vision Bank London (US GAAP) SECONDARY   50214 USD Accounting Month Feb-07 272796 Y Y Y Y 272797   272798 272795 N N N N N Y N N 1 Corporate N A SEGMENT1 A   1002722   1 Jan-08 2007 Corporate Corporate     BANKING_US_GAAP C US 272795   N       Y Y N Y   29-AUG-07 2653 29-AUG-07 1012657
186 Vision Belgium Vision BE Vision Belgium PRIMARY CONFIRMED 50714 EUR Accounting13 Month 12-98 21710 N Y N N 21711 21713     Y N N Y N N N N     N I SEGMENT1 A   1004962   4 10-08 2008 Period Average186 Period End186 Period Average B186 Period End B186 ENCUMBRANCE_ACCRUAL S US   N N   N N Y Y N Y   06-OCT-99 1318 11-AUG-06 1
205 Vision Brazil Vision BR Vision Brazil (BRL) Primary Set of Books PRIMARY CONFIRMED 50731 BRL Accounting13 Month 01-99 98280 Y Y Y N 98281 98283   98282 Y N N N N N N N     N I SEGMENT1 A   1005281   4 10-08 2007 1082 1083     ENCUMBRANCE_ACCRUAL S US 21733 N N   N N Y Y N Y   06-OCT-99 1318 05-SEP-06 2209
206 Vision Brazil (USD Report) Vision BR Rpt Vision Brazil (USD) Reporting Set of Books PRIMARY CONFIRMED 50731 BRL Accounting13 Month 12-98 98280 Y Y Y N 98281     98282 N N N N N N N N     N A SEGMENT1 A   1005281   4             STANDARD_ACCRUAL S US 21733 N N   N N Y Y N Y   06-OCT-99 1318 11-AUG-06 1
LEDGER_ID NAME SHORT_NAME DESCRIPTION LEDGER_CATEGORY_CODE COMPLETION_STATUS_CODE CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE FIRST_LEDGER_PERIOD_NAME RET_EARN_CODE_COMBINATION_ID SUSPENSE_ALLOWED_FLAG ALLOW_INTERCOMPANY_POST_FLAG TRACK_ROUNDING_IMBALANCE_FLAG ENABLE_AVERAGE_BALANCES_FLAG CUM_TRANS_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID ENABLE_BUDGETARY_CONTROL_FLAG REQUIRE_BUDGET_JOURNALS_FLAG ENABLE_JE_APPROVAL_FLAG ENABLE_AUTOMATIC_TAX_FLAG CONSOLIDATION_LEDGER_FLAG TRANSLATE_EOD_FLAG TRANSLATE_QATD_FLAG TRANSLATE_YATD_FLAG TRANSACTION_CALENDAR_ID DAILY_TRANSLATION_RATE_TYPE AUTOMATICALLY_CREATED_FLAG BAL_SEG_VALUE_OPTION_CODE BAL_SEG_COLUMN_NAME MGT_SEG_VALUE_OPTION_CODE MGT_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID FUTURE_ENTERABLE_PERIODS_LIMIT LATEST_OPENED_PERIOD_NAME LATEST_ENCUMBRANCE_YEAR PERIOD_AVERAGE_RATE_TYPE PERIOD_END_RATE_TYPE BUDGET_PERIOD_AVG_RATE_TYPE BUDGET_PERIOD_END_RATE_TYPE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_DESCRIPTION_LANGUAGE SLA_ENTERED_CUR_BAL_SUS_CCID SLA_SEQUENCING_FLAG SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID ENABLE_SECONDARY_TRACK_FLAG ENABLE_REVAL_SS_TRACK_FLAG ENABLE_RECONCILIATION_FLAG CREATE_JE_FLAG SLA_LEDGER_CASH_BASIS_FLAG COMPLETE_FLAG COMMITMENT_BUDGET_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY
954 Vision Brazil SL (USD) Vision BR SL (USD) Vision Brazil Secondary Ledger (USD) SECONDARY   101 USD Accounting Month Dec-04 150442 Y Y Y N 150445 150446   150444 Y N N N N N N N     N I SEGMENT1 A   1002470   1 Dec-08 2006 1083 1083                       Y Y N Y   01-SEP-06 2209 03-SEP-07 1318
540 Vision Chile Vision CL Vision Chile PRIMARY CONFIRMED 52074 CLP Accounting13 Month 11-02 99454 Y Y N N 99456       N N N N N N N N     N A SEGMENT1 A   1013217   4 10-08 2002         STANDARD_ACCRUAL S US 99455 N N   N N Y Y N Y   11-MAR-03 1005690 11-AUG-06 1
566 Vision China Vision CN Vision China Set of Books PRIMARY CONFIRMED 52342 CNY China Calendar 63 12-00 108281 N N N N 108282 108440     Y Y Y N N N N N     N A SEGMENT1 A   1014448   1 10-08 2003         STANDARD_ACCRUAL S US   N N   N N Y Y N Y   18-SEP-03 1318 11-AUG-06 1
546 Vision Columbia Colombia Vision Colombia PRIMARY CONFIRMED 52079 COP Accounting Month Adj-02 100190 N N N N 100191     100191 N N N N N N N N     N A SEGMENT1 A   1013221   2 Oct-08 2002         STANDARD_ACCRUAL S US   N N   N N Y Y N Y   30-MAY-03 1318 11-AUG-06 1
290 Vision Communications (USA) Vision Comms Vision Communications (USA) PRIMARY CONFIRMED 51286 USD Accounting Month Dec-98 32207 Y Y Y N 32209     32210 N N N N N N N N     N A SEGMENT1 A   1008105   4 Oct-08 1998         STANDARD_ACCRUAL S US 32208 N N   N N Y Y N Y   08-FEB-01 1318 11-AUG-06 1
567 Vision Consolidation Japan Vision Con-JP Vision Consolidation Japan Set of Books PRIMARY CONFIRMED 52341 JPY Japan Calendar Month MAR-02 108454 Y Y Y N 108456     108455 N N N Y N N N N     N A SEGMENT1 A   1005012   1 OCT-08 2005         STANDARD_ACCRUAL S US 108460 N N   N N Y Y N Y   23-SEP-03 2049 11-AUG-06 1
569 Vision Consolidation Korea Vision Cons KR Vision Consolidation Korea Set of Books PRIMARY CONFIRMED 50581 KRW Accounting13 Month 10-02 108283 Y Y N N 108285       N N N N N N N N     N A SEGMENT1 A   1004997   1 10-08 2002         STANDARD_ACCRUAL S US 114464 N N   N N Y Y N Y   17-OCT-03 2051 11-AUG-06 1
22 Vision Corporation (UK) Vision Corporation Vision Corporation (UK) Consolidated Set of Books PRIMARY CONFIRMED 50194 GBP Fiscal 21 April-95 13810 Y Y N N 13812       N N N N N N N N     N I SEGMENT1 A   1002477   3 Oct-09 1998 Period Average22 Period End22     STANDARD_ACCRUAL S US 13811 N N   N N Y Y N Y   04-JAN-96 1002 11-AUG-06 1
142 Vision Corporation Japan Vision C-JP Vision Corporation Japan Set of Books PRIMARY CONFIRMED 50589 JPY Japan Calendar Month MAR-02 108457 Y Y Y N 108458     108459 N N N Y N N N N     N A SEGMENT1 A   1005012   4 OCT-08 2005 Period Average142 Period End142     STANDARD_ACCRUAL S US 108344 N N   N N Y Y N Y   26-JUL-99 2049 11-AUG-06 1
455 Vision Czech CZ SOB Czech Republic Set of Books PRIMARY CONFIRMED 51847 CZK Accounting13 Month 01-04 91421 N N N N         N N N Y N N N N     N I SEGMENT1 A   1002470   2 10-08 2004         STANDARD_ACCRUAL S US 91422 N N   N N Y Y N Y   10-JAN-03 1318 11-AUG-06 1
541 Vision Denmark Vision DK Vision Denmark set of books PRIMARY CONFIRMED 52076 DKK Accounting13 Month 11-02 99457 N Y N N 99458       N N Y Y N N N N     N I SEGMENT1 A   1004962   1 10-08 2002         STANDARD_ACCRUAL S US   N N   N N Y Y N Y   11-MAR-03 1005691 11-AUG-06 1
21 Vision Distribution (SNG) Vision Distribution Vision Distribution (Singapore) Set of Books PRIMARY CONFIRMED 50195 SGD Accounting Month Dec-96 13806 Y Y N N 13808       N N N N N N N N     N I SEGMENT1 A   1002470   2 Oct-08 1996 Period Average21 Period End21     STANDARD_ACCRUAL S US 13807 N N   N N Y Y N Y   03-JAN-96 1002 11-AUG-06 1
480 Vision Finland Vision FI Vision Finland PRIMARY CONFIRMED 51933 EUR Accounting13 Month 01-04 91912 N N N N         N N N N N N N N     N I SEGMENT1 A   1004962   1 10-08 2004 Period Average480 Period End480     STANDARD_ACCRUAL S US   N N   N N Y Y N Y   24-JAN-03 1318 11-AUG-06 1
124 Vision France Vision FR Vision France PRIMARY CONFIRMED 50569 EUR Accounting13 Month 12-98 28688 Y Y N N 21062 21064     Y N N Y N N N N     N I SEGMENT1 A   1004962   4 10-08 2008 Period Average124 Period End124 Period Average B124 Period End B124 ENCUMBRANCE_ACCRUAL S US 21061 N N   N N Y Y N Y   23-JUL-99 2044 11-AUG-06 1
163 Vision France (FRF - Rpt.) Vision FR - FRF Vision France (FRF - Rpt.) ALC CONFIRMED 50569 FRF Accounting13 Month 12-98 21060 Y Y N N 21062 21064     N N N Y N N N N     N I SEGMENT1 A   1004962   1 09-03 2003 Period Average163 Period End163     STANDARD_ACCRUAL S US 21061 N N   N N Y Y N Y   02-APR-99 2044 11-AUG-06 1
126 Vision Germany Vision DE Vision Germany PRIMARY CONFIRMED 50577 EUR Accounting13 Month 12-98 21070 Y Y N N 21072       N N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 1999 Period Average126 Period End126 Period Average B126 Period End B126 STANDARD_ACCRUAL S US 21071 N N   N N Y Y N Y   23-JUL-99 2045 11-AUG-06 1
162 Vision Germany (DEM - Rpt.) Vision DE - DEM Vision Germany (DEM - Rpt.) ALC CONFIRMED 50577 DEM Accounting13 Month 12-98 21070 Y Y N N 21072       N N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 1998 Period Average162 Period End162     STANDARD_ACCRUAL S US 21071 N N   N N Y Y N Y   02-APR-99 2045 11-AUG-06 1
956 Vision Germany SL (USD) Vision DE SL (USD) Vision Germany Secondary Ledger (USD) SECONDARY   101 USD Accounting Month Dec-04 150452 Y Y Y N 150454     150453 N N N N N N N N     N I SEGMENT1 A   1002470   1 Dec-08 2004 Period Average126 Period End126     STANDARD_ACCRUAL_SL C US 150451   Y 150451     Y Y N Y   01-SEP-06 2045 11-JAN-07 2045
476 Vision Greece Vision Greece Vision Greece PRIMARY CONFIRMED 51868 EUR Accounting14 144 01-04 91562 Y N N N 91562       N N N N N N N N     N A SEGMENT1 A   1012786   3 10-08 2004 Period Average476 Period End476     STANDARD_ACCRUAL S US 91562 Y N   N N Y Y N Y   16-JAN-03 1318 11-AUG-06 1
670 Vision Health Services Vision Health Set of Books for Vision Health Services Group PRIMARY CONFIRMED 52695 USD Accounting Month Dec-02 130016 Y Y Y N 130018 134502   130019 Y N N N N N N N     N I SEGMENT1 A   1016816   3 Oct-08 2003         STANDARD_ACCRUAL S US 130017 N N   N N Y Y N Y   08-JUL-04 1318 11-AUG-06 1
542 Vision Hungary Vision HU Vision Hungary set of books PRIMARY CONFIRMED 52077 HUF Accounting13 Month 12-02 99459 N N N N         N N N Y N N N N     N I SEGMENT2 A   1004962   1 10-08 2002         ENCUMBRANCE_ACCRUAL S US   N N   N N Y Y N Y   11-MAR-03 1005692 11-AUG-06 1
753 Vision India India Vision India SOB PRIMARY CONFIRMED 53028 INR Progress Canda Month APR-01 134752 N N N N         N N N N N N N N     N A SEGMENT1 A   1019534   1 OCT-09 2001         STANDARD_ACCRUAL S US 134772 N N   N N Y Y N Y   09-JUN-05 1318 20-SEP-07 1011080
208 Vision Insurance Insurance Vision Insurance PRIMARY CONFIRMED 50957 USD Accounting Month Adj-98 24974 Y Y N N 24976       N N N N N N N N     N A SEGMENT1 A   1005631   2 Oct-08 1998         STANDARD_ACCRUAL S US 24975 N N   N N Y Y N Y   17-FEB-00 1318 11-AUG-06 1
230 Vision Insurance EUR Vis Ins EUR Vision Insurance Reporting Set Of Books (EUR) ALC CONFIRMED 50957 EUR Accounting Month Adj-98 24974 Y Y N N 24976       N N N N N N N N     N A SEGMENT1 A   1005631   2 Jul-02 1998 Period Average230 Period End230     STANDARD_ACCRUAL S US 24975 N N   N N Y Y N Y   17-FEB-00 1318 11-AUG-06 1
228 Vision Investment Services Investment Services Vision Investment Services Set of Books (USD) PRIMARY CONFIRMED 50958 USD Accounting Month Adj-98 25330 Y N N N 25332       N N N N N N N N     N A SEGMENT1 A   1005651   1 Oct-08 1998         STANDARD_ACCRUAL S US 24990 N N   N N Y Y N Y   17-FEB-00 1318 11-AUG-06 1
229 Vision Investment Services EUR Inv Serv EUR Vision Investment Services Reporting Set of Books (EUR) ALC CONFIRMED 50958 EUR Accounting Month Adj-98 25330 Y N N N 25332       N N N N N N N N     N A SEGMENT1 A   1005651   1 Nov-99 1998 Period Average229 Period End229     STANDARD_ACCRUAL S US 24990 N N   N N Y Y N Y   17-FEB-00 1318 11-AUG-06 1
187 Vision Italy Vision IT (ITL) Vision Italy (ITL) ALC CONFIRMED 50713 ITL Accounting13 Month 01-99 22911 Y Y Y N 22913 22915   23009 N N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 2002 Period Average187 Period End187 Period Average B187 Period End B187 STANDARD_ACCRUAL S US 22912 N N   N N Y Y N Y   06-OCT-99 1318 11-AUG-06 1
207 Vision Italy EUR Vision IT (EUR) Vision Italy (EUR) PRIMARY CONFIRMED 50713 EUR Accounting13 Month 01-99 22911 Y Y Y N 22913 22915   23009 Y N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 2008 Period Average207 Period End207 Period Average B207 Period End B207 ENCUMBRANCE_ACCRUAL S US 22912 N Y 22912 N N Y Y N Y   03-DEC-99 2190 11-AUG-06 1
127 Vision Korea Vision KR Vision Korea Set of Books PRIMARY CONFIRMED 50581 KRW Accounting13 Month 10-02 108283 N Y N N 108285 108286     Y Y N Y N N N N     N A SEGMENT1 A   1004997   3 10-08 2002         ENCUMBRANCE_ACCRUAL S US 108284 N N   N N Y Y N Y   23-JUL-99 2051 11-AUG-06 1
544 Vision Mexico Adjusted Vision MX-ADJ Vision Mexico set of books with journals in inflation adjusted amounts SECONDARY CONFIRMED 52075 MXP Accounting13 Month 12-98 99460 Y Y N N 99462       N N N N N N N N     N A SEGMENT1 A   1013217   4 10-08 1998         STANDARD_ACCRUAL S US 99461 N N   N N Y Y N Y   11-MAR-03 1005693 13-DEC-06 1005693
543 Vision Mexico Historical Vision MX VIsion Mexico set of books with journal entries in historical amounts PRIMARY CONFIRMED 52075 MXP Accounting13 Month 12-98 99460 Y Y N N 99462       N N N N N N N N     N A SEGMENT1 A   1013217   4 10-08 1998         STANDARD_ACCRUAL S US 99461 N N   N N Y Y N Y   11-MAR-03 1005693 13-DEC-06 1005693
123 Vision Netherlands Vision NL Vision Netherlands PRIMARY CONFIRMED 50560 EUR Accounting13 Month 01-99 24803 Y Y N N 21057 21059     N N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 2001 Period Average123 Period End123 Period Average B123 Period End B123 STANDARD_ACCRUAL S US 21056 N N   N N Y Y N Y   23-JUL-99 2047 11-AUG-06 1
164 Vision Netherlands (NLG-Rpt.) Vision NL - NLG Vision Netherlands (NLG-Rpt.) ALC CONFIRMED 50560 NLG Accounting13 Month 12-98 21055 N Y N N 21057 21059     N N N N N N N N     N A SEGMENT1 A   1004962   4 08-00 1998 Period Average164 Period End164     STANDARD_ACCRUAL S US 21056 N N   N N Y Y N Y   02-APR-99 2044 11-AUG-06 1
934 Vision Netherlands SL (USD) Vision NL SL (USD) Vision Netherlands Secondary ledger (USD) SECONDARY   101 USD Accounting Month Dec-04 149436 Y Y Y N 149439     149438 N N N N N N N N     N I SEGMENT1 A   1002470   1 Dec-08 2004 Period Average123 Period End123                       Y Y N Y   01-SEP-06 2047 01-SEP-06 2047
373 Vision New Zealand NZ Vision Vision New Zealand Limited - Set of Books PRIMARY CONFIRMED 51569 NZD Accounting Month Dec-95 83969 Y Y Y N 83971     83972 N N N N N N N N     N A SEGMENT1 A   1010723   4             STANDARD_ACCRUAL S US 83970 N N   N N Y Y N Y   28-FEB-02 1318 11-AUG-06 1
477 Vision Norway Vision NO Primary Set of Books for Vision Norway PRIMARY CONFIRMED 51869 NOK Accounting13 Month 01-04 91763 N N N N 91765       N N N Y N N N N     N I SEGMENT5 A   1004962   2 10-08 2004         STANDARD_ACCRUAL S US 91764 N N   N N Y Y N Y   21-JAN-03 1318 11-AUG-06 1
478 Vision Norway Cash Vision NO Cash Vision Norway Secondary Set of Books (Cash) SECONDARY CONFIRMED 51869 NOK Accounting13 Month 01-04 91763 N N N N 91765       N N N N N N N N     N I SEGMENT5 A   1004962   2 10-08 2004         STANDARD_CASH S US   N N   N N Y Y Y Y   21-JAN-03 1318 11-AUG-06 1
1 Vision Operations (USA) Vision Operations Vision Operations (USA) Ledger PRIMARY CONFIRMED 101 USD Accounting Month Dec-95 12827 Y Y Y N 12829     27120 N N N N N N N N     N I SEGMENT1 A   1002470   2 Dec-12 2008 Period Average1 Period End1     STANDARD_ACCRUAL S US 12828 N N   N N Y Y N Y   10-FEB-97 1002 11-SEP-06 1055
976 Vision Operations Corp. Ops Corp Vision Operations Corporation (101) NONE   101 X Accounting Month X -1 N N N N         N N N N N N N N     N I SEGMENT1 I   1002470   0                               N N       11-SEP-06 1055 11-SEP-06 1055
475 Vision Poland PL SOB Polish set of books PRIMARY CONFIRMED 51846 PLN Accounting13 Month 11-02 91447 Y Y Y N 91448 91450   91449 Y N N Y N N N N     N A SEGMENT1 A   1012715   6 10-08 2002         STANDARD_ACCRUAL_POLAND C US 91448 N N   N N Y Y N Y   13-JAN-03 1318 04-JAN-08 1004997
520 Vision Portugal Vision PT Portuguese Set of Books PRIMARY CONFIRMED 52034 EUR Accounting15 62 12-02 99334 Y Y N N 99335 99336     N N Y Y N N N N     N I SEGMENT1 A   1004962   1 10-08 2002 Period Average520 Period End520     STANDARD_ACCRUAL S US 99335 N N   N N Y Y N Y   04-MAR-03 1005650 11-AUG-06 1
568 Vision Project Mfg Projmfg Vision Project Manufacturing Set of Books (as defined for A&D Build) PRIMARY CONFIRMED 52369 USD 4-4-5 Calendar 21 DEC-01 113892 Y Y Y N       113893 N N N N N N N N     N A SEGMENT1 A   1003706   3 NOV-08 2003         STANDARD_ACCRUAL S US 113893 N N   N N Y Y N Y   07-OCT-03 1318 11-AUG-06 1
102 Vision Project Mfg (ANY Rpt) Project Mfg ANY Vision Project Manufacturing (MRC Reporting ANY) SoB ALC CONFIRMED 50317 ANY 4-4-5 Calendar 21 NOV-97 17648 Y Y Y N 17650     17649 N N N N N N N N     N A SEGMENT1 A   1003706   4 ADJ-12 1997 Period Average102 Period End102     STANDARD_ACCRUAL S US 17649 N N   N N Y Y N Y   07-DEC-97 1002 11-AUG-06 1
103 Vision Project Mfg (EUR) Project Mfg EURO Vision Project Manufacturing (MRC EURO Primary) SoB PRIMARY CONFIRMED 50317 EUR 4-4-5 Calendar 21 NOV-97 17648 Y Y Y N 17650     17649 N N N N N N N N     N A SEGMENT1 A   1003706   4 ADJ-12 1997 Period Average103 Period End103     STANDARD_ACCRUAL S US 17649 N N   N N Y Y N Y   07-DEC-97 1002 11-AUG-06 1
104 Vision Project Mfg (USA Rpt.) Project Mfg. USD Vision Project Manufacturing (MRC USD Reporting) SoB ALC CONFIRMED 50317 USD 4-4-5 Calendar 21 NOV-97 17648 Y Y N N 17650       N N N N N N N N     N A SEGMENT1 A   1003706   4 ADJ-12 1997         STANDARD_ACCRUAL S US 17649 N N   N N Y Y N Y   07-DEC-97 1002 11-AUG-06 1
793 Vision Romania Vision RO Vision Romania PRIMARY CONFIRMED 53108 RON Accounting13 Month 12-98 134442 N N N N         N N N N N N N N     N A SEGMENT1 A   1019501   1             STANDARD_ACCRUAL S US   N N   N N Y Y N Y   30-SEP-05 1011059 11-AUG-06 1
649 Vision Russia Vision RU Vision Russia Set of Books PRIMARY CONFIRMED 52634 RUR NUMERIC12 Month 12-02 122437 N N N N 122438       N N Y N N N N N     N A SEGMENT1 A   1015739   1 10-08 2002         STANDARD_ACCRUAL S US   N N   N N Y Y N Y   08-JUN-04 1318 11-AUG-06 1
62 Vision Services (USA) Vision Services Vision Services Set of Books PRIMARY CONFIRMED 50234 USD Weekly 21 DEC-95 14894 Y Y N N 14896       N N N N N N N N     N A SEGMENT1 A   1002475   4 ADJ-12 2009 Period Average62 Period End62     STANDARD_ACCRUAL S US 14895 N N   N N Y Y N Y   31-MAR-97 1002 11-AUG-06 1
143 Vision Services Japan Vision S-JP Vision Services Japan Set of Books PRIMARY CONFIRMED 50590 JPY Japan Calendar Month MAR-02 21085 Y Y N N 21087       N N N Y N N N N     N A SEGMENT1 A   1005016   4 OCT-08 2005 Period Average143 Period End143     STANDARD_ACCRUAL S US 21086 N N   N N Y Y N Y   26-JUL-99 2049 11-AUG-06 1
331 Vision Singapore Limited SG Vision Vision Singapore Limited Set of Books PRIMARY CONFIRMED 51505 SGD Accounting Month Dec-95 80234 N N N N         N N N N N N N N     N A SEGMENT1 A   1010607   1             STANDARD_ACCRUAL S US   N N   N N Y Y N Y   14-JAN-02 1318 11-AUG-06 1
LEDGER_ID NAME SHORT_NAME DESCRIPTION LEDGER_CATEGORY_CODE COMPLETION_STATUS_CODE CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE FIRST_LEDGER_PERIOD_NAME RET_EARN_CODE_COMBINATION_ID SUSPENSE_ALLOWED_FLAG ALLOW_INTERCOMPANY_POST_FLAG TRACK_ROUNDING_IMBALANCE_FLAG ENABLE_AVERAGE_BALANCES_FLAG CUM_TRANS_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID ENABLE_BUDGETARY_CONTROL_FLAG REQUIRE_BUDGET_JOURNALS_FLAG ENABLE_JE_APPROVAL_FLAG ENABLE_AUTOMATIC_TAX_FLAG CONSOLIDATION_LEDGER_FLAG TRANSLATE_EOD_FLAG TRANSLATE_QATD_FLAG TRANSLATE_YATD_FLAG TRANSACTION_CALENDAR_ID DAILY_TRANSLATION_RATE_TYPE AUTOMATICALLY_CREATED_FLAG BAL_SEG_VALUE_OPTION_CODE BAL_SEG_COLUMN_NAME MGT_SEG_VALUE_OPTION_CODE MGT_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID FUTURE_ENTERABLE_PERIODS_LIMIT LATEST_OPENED_PERIOD_NAME LATEST_ENCUMBRANCE_YEAR PERIOD_AVERAGE_RATE_TYPE PERIOD_END_RATE_TYPE BUDGET_PERIOD_AVG_RATE_TYPE BUDGET_PERIOD_END_RATE_TYPE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_DESCRIPTION_LANGUAGE SLA_ENTERED_CUR_BAL_SUS_CCID SLA_SEQUENCING_FLAG SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID ENABLE_SECONDARY_TRACK_FLAG ENABLE_REVAL_SS_TRACK_FLAG ENABLE_RECONCILIATION_FLAG CREATE_JE_FLAG SLA_LEDGER_CASH_BASIS_FLAG COMPLETE_FLAG COMMITMENT_BUDGET_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY
185 Vision Spain Vision ES Vision Spain PRIMARY CONFIRMED 50712 EUR Accounting13 Month 12-02 21704 N N N N 21706       N N N N N N N N     N I SEGMENT1 A   1004962   1 10-08 2002 Period Average185 Period End185 Period Average B185 Period End B185 STANDARD_ACCRUAL S US 21705 N N   N N Y Y N Y   06-OCT-99 1318 11-AUG-06 1
122 Vision Sweden Vision SE Vision Sweden PRIMARY CONFIRMED 50558 SEK Accounting13 Month 12-98 21051 Y Y N N 21053       N N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 2004 Period Average122 Period End122     STANDARD_ACCRUAL S US 21052 N N   N N Y Y N Y   23-JUL-99 2048 11-AUG-06 1
454 Vision Switzerland Vision CH Vision Switzerland PRIMARY CONFIRMED 51827 CHF Accounting13 Month 13-01 98045 N N N N         N N N N N N N N     N A SEGMENT1 A   1013003   1 10-08 2003         STANDARD_ACCRUAL S US   N N   N N Y Y N Y   07-JAN-03 1318 11-AUG-06 1
453 Vision Taiwan TWOPS Taiwanese set of books PRIMARY CONFIRMED 51845 NTD Accounting13 Month 01-04 91347 Y N Y N 91349     91911 N N N N N N N N     N A SEGMENT1 A   1002470   4 10-08 2004         STANDARD_ACCRUAL S US 91348 N N   N N Y Y N Y   07-JAN-03 1318 11-AUG-06 1
433 Vision Thailand Vision Thai Vision Thailand PRIMARY CONFIRMED 51825 BHT Accounting Month Jan-04 91327 Y Y Y N 91329     91330 N N N N N N N N     N A SEGMENT1 A   1002470   4 Oct-08 2004         STANDARD_ACCRUAL S US 91328 N N   N N Y Y N Y   06-JAN-03 1318 11-AUG-06 1
545 Vision Turkey Vision TR Vision Turkey set of books PRIMARY CONFIRMED 52078 TRL Accounting13 Month 01-04 99463 Y N N N         N N N N N N N N     N I SEGMENT1 A   1004962   1 10-08 2004         STANDARD_ACCRUAL S US 99464 N N   N N Y Y N Y   11-MAR-03 1005694 11-AUG-06 1
125 Vision UK Vision UK Vision UK PRIMARY CONFIRMED 50572 GBP Accounting13 Month 01-99 21065 Y Y N N 21067       N N N N N N N N     N I SEGMENT1 A   1004962   4 10-08 2002         STANDARD_ACCRUAL S US 21066 N N   N N Y Y N Y   23-JUL-99 1318 11-AUG-06 1
996 Vision Ukraine Vision Ukraine Vision Ukraine - Org 996 (UAH) PRIMARY   53380 UAH Accounting13 Month 12-06 245739 N Y Y Y   245741 245742 245740 Y Y Y N N N N N 1 Corporate N I SEGMENT1 A   1002470   3 10-08 2007   Corporate     ENCUMBRANCE_ACCRUAL S US     Y 245738     N Y N Y   16-JUL-07 1012664 31-JUL-07 1012664
288 Vision University Vision University Vision University Set of Books PRIMARY CONFIRMED 51253 USD Fiscal-13 21 Jul-00 32087 Y Y Y N 32088 32090   32354 Y N N N N N N N     N A SEGMENT1 A   1008005   4 Dec-09 2008         ENCUMBRANCE_ACCRUAL S US 32089 N N   N N Y Y N Y   01-FEB-01 1318 11-AUG-06 1
479 Vision Utilities UTILS Vision Utilities Set of Books PRIMARY CONFIRMED 51889 USD 4-4-5 Calendar 21 DEC-01 91808 Y Y Y N 91810     91809 N N Y N N N N N     N A SEGMENT1 A   1012953   4 NOV-08 2003         STANDARD_ACCRUAL S US 91809 N N   N N Y Y N Y   22-JAN-03 1318 11-AUG-06 1

110 rows selected.


2.Ledger Sets [Top-Index]

NAME SHORT_NAME DESCRIPTION CHART_OF_ACCOUNTS_NAME PERIOD_SET_NAME USER_PERIOD_TYPE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY
2546RT FR Corp Ledger Set 2546RT FR Corp LS 2546Corporate Ledger Set SSC US and RT France Ledgers Primary Ledger FLEX Accounting13 Month 26-SEP-08 1322 26-SEP-08 1322
MK Consolidation LS MKCLS   MK Accounting Flex MK Calendar MK Period 07-JUL-11 1013423 07-JUL-11 1013423
MK Ledger Set MKLS MK Ledger Set MK Accounting Flex MK Calendar MK Period 01-JUL-11 1013423 01-JUL-11 1013423
Progress All Ledgers Progress All Ledgers Progress State and Local - All Ledgers Progress Accounting Flexfield GOV Calendar Fiscal Month 27-APR-07 1000354 27-APR-07 1000354
SSC All SSC All SSC All Ledgers Set (53213) Primary Ledger FLEX Accounting13 Month 11-SEP-06 1011771 11-SEP-06 1011771
Test Ledger Test   TEST_ACCOUNTING_FLEX Accounting13 Month 23-MAR-11 1318 23-MAR-11 1318
Vision Operations Corp. Ops Corp Vision Operations Corporation (101) Operations Accounting Flex Accounting Month 11-SEP-06 1055 11-SEP-06 1055

7 rows selected.


3.Ledgers attached to Ledger Sets[Top-Index]

LEDGER_SET_ID LEDGER_SET_NAME LEDGER_ID LEDGER NAME START_DATE END_DATE STATUS_CODE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY
1024 2546RT FR Corp Ledger Set 1018 2546RT France Ledger       26-SEP-08 1322 26-SEP-08 1322
1024 2546RT FR Corp Ledger Set 1019 2546RT France Ledger(USD)       26-SEP-08 1322 26-SEP-08 1322
1024 2546RT FR Corp Ledger Set 874 SSC US       26-SEP-08 1322 26-SEP-08 1322
1056 MK Consolidation LS 1054 MK Consolidation USA       07-JUL-11 1013423 07-JUL-11 1013423
1053 MK Ledger Set 1050 MK US Reporting Ledger       01-JUL-11 1013423 01-JUL-11 1013423
1053 MK Ledger Set 1049 MK Primary       01-JUL-11 1013423 01-JUL-11 1013423
994 Progress All Ledgers 268 Progress State and Local       27-APR-07 1000354 27-APR-07 1000354
994 Progress All Ledgers 609 Progress State and Local Cash       27-APR-07 1000354 27-APR-07 1000354
994 Progress All Ledgers 393 GASB34       27-APR-07 1000354 27-APR-07 1000354
974 SSC All 919 SSC Italy ALC (USD)       11-SEP-06 1011771 11-SEP-06 1011771
974 SSC All 876 SSC Italy       11-SEP-06 1011771 11-SEP-06 1011771
974 SSC All 916 SSC France ALC (USD)       11-SEP-06 1011771 11-SEP-06 1011771
974 SSC All 874 SSC US       11-SEP-06 1011771 11-SEP-06 1011771
974 SSC All 875 SSC France       11-SEP-06 1011771 11-SEP-06 1011771
1048 Test Ledger 1046 Test Primary Ledger       23-MAR-11 1318 23-MAR-11 1318
976 Vision Operations Corp. 934 Vision Netherlands SL (USD)       11-SEP-06 1055 11-SEP-06 1055
976 Vision Operations Corp. 956 Vision Germany SL (USD)       11-SEP-06 1055 11-SEP-06 1055
976 Vision Operations Corp. 954 Vision Brazil SL (USD)       11-SEP-06 1055 11-SEP-06 1055
976 Vision Operations Corp. 1 Vision Operations (USA)       11-SEP-06 1055 11-SEP-06 1055
976 Vision Operations Corp. 650 IAS Reporting Vision Ops       11-SEP-06 1055 11-SEP-06 1055

20 rows selected.

....MORE....