Bank Certificates of Deposits Zeroes by alu10603

VIEWS: 20 PAGES: 44

Bank Certificates of Deposits Zeroes document sample

More Info
									Use this file to load Opening Balances for Balance Sheet and Profit and Loss GL Accounts (use another for opening Creditor and D
To use -
Have the 'import spreadsheet' open in another window. (This is the file already filled by the user containing the list of open items.)
Set the 'static data' as required at the top of the GL_Import sheet (output file name and path, journal description etc).
Note that you must also specify whether this file contains Debtor or Creditor data. It must be one or the other.
  'Add Desc' is a prefix that will be added to the value in column E and used as the transaction description. Set it to (eg) 'Old Accou
  GL Code is of course the 'suspense account' GL code that will be used as the contra entry to all these postings.
1.) Refresh the 'Master Data' tabs by pressing the 'Refresh Masters' button. If necessary, when prompted for the Globe database to
2.) Clear any old data from previous imports by pressing the 'Clear old import data' button.
3.) Select and copy the data from the import spreadsheet - only the detail lines from 'Journal' onwards - and paste into cell C12
  Don't select 'wider' than you need from the import spreadsheet. Be careful not to overwrite the formulas to the right of th
4.) Press the 'Extend formulas' button. (This fills the 'test-for-errors' formulas for as many lines as were pasted in at step 3.)
5.) Press the 'Check Errors' button. (This checks the results of the 'test-for-errors' formulas and summarises them in column A.)
  The 'Check errors' button can be pressed repeatedly, for instance after modifying cells to correct errors with missing data you can
  The 'Copy a static value' button can be used to fill a column with a single value - for instance to insert the base currency on all row
     (Of course this can also be done manually but when there are thousands of lines, this button is convenient.)
  The 'Master Data' tabs can be examined to check what data is on file - this may be more convenient than looking in Globe itself.
5a.) Note that sometimes the lookups on data can return a 'false negative' because the list of (say) GL Codes is a list of numbers b
  These errors can usually be corrected by setting the data to be imported as Text.
  This can be tedious because not only must the cell be formatted as text,
  but also the contents of the cell must be re-entered by opening the cell and pressing return.
  However there is now a macro to help with this - select the first cell (row 12) in the column to be reformatted and then press the bu

5b.) Note that this problem when Master_Data is NOT formatted as text has now been corrected (v14) .

6.) Finally, using the 'Create XML' button, generate the XML file and test the import
  Note that with errors in column A the XML file can still be created, but not if there are errors in column B because the 'journal type



  Version history
v12        Allow lookups using numbers to succeed in matching to text equivalents by using the TEXT(A1,"general") construct for t
             Also make sure all codes that may have leading spaces (GL Codes, Account Codes) are extracted by SQL using LTR
             Can get a false 'true' on concatenated GL/CC lookup because of 15-digit limit on numbers - cure by adding 'X' to force
v13        Count errors and tell user how many there are and on how many lines.
           NOTE - if using Accounts with leading zeroes this spreadsheet may give 'false negatives'.
             Correcting this issue is possible but tricky - a start has been made but the formulas needed are complex and i
             because they may not be used in practice. (As always, I advise against using accounts with leading zeroes.) If
             PPJ
v14        Insert separate columns (Y / Z) for GL Code, Cost Centre and Cost Unit converted to text, for use in lookups etc
             (Attempt to simplify the amendments described in v12 above.)
             This should cure the 'leading zeroes' problem, at least on the codes named above - creditors and debtors with
v15        Cure the problem of leading-zero items and projects giving false negatives by using the ISNUMBER test to decide wheth
             There could still be potential problems with journals if they're set up with leading zeroes; all those lookups ma
v16        Also stop missing or invalid CC's and CU's being double counted as missing links by testing if the GL or CC/CU is blank
             Check Cash journals as well as Bank journals when testing to see if a cash instrument has been set up. (Column AI.)
             Test that projects are Active, as well as on file / not blank.
v17        Extend formula for CU/CC lookup - did 'only' check 10,000 rows, inadequate for some databases. Now 60k.
ounts (use another for opening Creditor and Debtor balances.)

y the user containing the list of open items.)
d path, journal description etc).
 a. It must be one or the other.
 nsaction description. Set it to (eg) 'Old Account -' if E contains the old GL code for instance.
a entry to all these postings.
ary, when prompted for the Globe database to use, select the target database .

 ournal' onwards - and paste into cell C12
  to overwrite the formulas to the right of the data. These are in column W onwards.
any lines as were pasted in at step 3.)
mulas and summarises them in column A.)
 lls to correct errors with missing data you can re-check to see what errors remain.
 instance to insert the base currency on all rows, or the booking date.
 this button is convenient.)
more convenient than looking in Globe itself.
 e list of (say) GL Codes is a list of numbers but the GL code on the Master_Data tab is formatted as text .



 olumn to be reformatted and then press the button




e errors in column B because the 'journal type' changes the structure of the XML file.




y using the TEXT(A1,"general") construct for the value to be searched for…
 ount Codes) are extracted by SQL using LTRIM.
t limit on numbers - cure by adding 'X' to force string comparison not number

 ive 'false negatives'.
 but the formulas needed are complex and if possible, I would rather ignore the (potential) problem,
 nst using accounts with leading zeroes.) If they must be used then it is possible the sheet may be changed.

 nverted to text, for use in lookups etc

  named above - creditors and debtors with leading zeroes may still give false negatives.
 by using the ISNUMBER test to decide whether to look up using TEXT() or not.
p with leading zeroes; all those lookups may well fail.
ng links by testing if the GL or CC/CU is blank or gives a lookup error before testing the link exists.
 sh instrument has been set up. (Column AI.)

 te for some databases. Now 60k.
This sheet contains the data that will be loaded into Exact Globe
Most recent Master Data is from:            'Contra' data
Co. No. / Version          005 / 394        GL Code           99600012
Name            Exact Test and Demo Company Resource
Date / time            10/12/2009 15:39
Description                                 Creditor codes? Yes
                   Import BS Opening Balances
                                            Debtor codes?     Yes
Folder             C:\Documents and Settings\phel111085\My Documents\Global Refund 13432\Reporting\090827 - continue Fren


File Name         FR_064_PL_1.XML


Errors?                    #N/A          Journal           GL Account
                           #N/A
                   Add. Desc                                      OB -
                   Contra CC
                   Contra CU


5\My Documents\Global Refund 13432\Reporting\090827 - continue French Data migration and other XML work




                   Description                                    BookingDate      OurRef
                                                              1
                                                              2
                                                                          Colour coding
                                                                   Don't touch
                                                                            Mandatory
                                                                   Set once
                                                                   Set each time
                                                                           Import Data
                                                                   Set as required


                                                                   Not used


AmountDebit       AmountCredit       Curr   YourRef   Costcenter   Costunit    Item
              3
                                 3
                                                                                 Test the Contra GL Code
                                                                                Contra GL not exist
                                                                      Contra GL Code does Code is not neutral
                                                                        #N/A      TRUE




Project   Creditor   Debtor   F Curr Code F Curr Value   Textfield1
Test the Contra GL Code                                                                         If a particular cell has been filled in, does that d
          Contra GL Code is blocked
                    TRUE                                                                       Report3.Range
                                                                                     Report2.Range       Report4.Range


                                                Long error                        Given GL matchon file Centre Journal doesn't exist
                                                                                               not Cost GL, or is not on file
                                                                       Journal Code doesn't isGivengiven Given Cost Unit is not on file
                                                Short error            Inv. Jnl   Inv. GL     Inv. CC    Inv. CU
                                                Column to highlight             3         4           12         13

                                      Key numeric codes, expressed
                                               as strings

         GL Description               GL Code Cost Centre  Cost Unit            27         28          29           30
                   #N/A               GL AccountCostcenter Costunit      #N/A         #N/A        #N/A         #N/A
                   #N/A                                                  #N/A         TRUE        TRUE         TRUE
a particular cell has been filled in, does that data exist?                                        Have all Mandatory Fields been supplied?

                                Report6.Range
                      Report5.Range                 Report10.Range
                                          Report9.Range                                                Report2.Range
                                                                                             Report2.Range       Report2.Range
                                                                                                     5         6         7

                                  is not Project
                                              Given Creditor Code not on file GL is file
                                                        Given Debtor Code is Journal without Centre Instrument mandatory but but is
                                                                                                     is mandatory but mandatory
                      Given Item Given on file Code is not on file isBank/Cashnot on blankCosta CashCost Unit isItem is is blank is blank blank
                                                        I                      No GL
                      Inv. Item Inv. Proj Inv. Creditornv. Debtor No Cash Instrument No CC          No CU       No Item
                               14         15         16          17          3           4       12        13            14




                              31          32          33           34          35       36        37         38         39
                         #N/A        #N/A        #N/A         #N/A      #N/A        TRUE      TRUE       TRUE       TRUE
                         TRUE        TRUE        TRUE         TRUE      #N/A        FALSE     TRUE       TRUE       TRUE
all Mandatory Fields been supplied?                             CC Link    CU Link                                         Currency tests

                              Report2.Range
                    Report2.Range                 Report2.Range
                                        Report2.Range                                 Report2.Range
                            8         4         4        11                                   4

                                Creditor is mandatory but is blank Cost Centre / GL combination is invalid invalidthe FC Bank Journal currency
                                            Debtor is GL Code is blocked                 Bank Account GL
                                                                                                     Currency for use a Currency base
                                                                                                                If
                    Project is mandatory but is blankmandatory but is blank Cost Unit / GL combination is shouldamounts must be is given, an FC amou
                    No Proj                                                  I           W           Not
                                No CreditorNo Debtor GL blockedInv, CC Linknv. CU Link rong journal GBP No FC Value
                             15         16          17                    12          13          3         10          19




                          40         41         42         43         44         45         46         47     48
                      TRUE       TRUE       TRUE       TRUE       TRUE       TRUE       TRUE       FALSE #VALUE!
                      TRUE       TRUE       TRUE       TRUE       TRUE       TRUE       TRUE       FALSE  TRUE
   Currency tests

          Report12.Range
Report12.Range                Report1.Range
                    Report12.Range                Report6.Range
                                        Report2.Range
                  2         3         6         4

           F Curr Code Curr Active Journal does not GL should useexch Code
                                               Cash       variable a Cash Journal
F Curr Code not on fileF is notCode is not variable allow Given Project rates is not active
           F           FC Code invariableJnl Wrong journal not active
Inv FC Code C Code Inactive        Not FC                 Proj.
        18         18           18          3           3         15




       49        50          51           52        53          54
  #N/A       TRUE        TRUE        #N/A       TRUE        TRUE
  TRUE       TRUE        TRUE        TRUE       TRUE        TRUE
Last time this data was refreshed and what company it came from:

        Co_Name Co_Currency
Co_Number                    Version                      When_Refreshed
005                 GBP
        Exact Test and Demo Company                    394 10/12/2009 15:39



Journals                                                                                  GL Codes

Dagbknr    type_dgbk   reknr   oms25                       BnkJnl             Var_Exch    Reknr
10         V           90300   Sales                                                  1   01000
20         I           90800   Purchase                                               1   10000
40         B           90200   GBP Current Account         40                         0   10050
41         B           90211   USD Bank Account            41                         0   11000
42         B           90220   Euro Bank Account           42                         0   11001
50         K           90250   Cash                        50                         0   11010
90         M           99999   General                                                1   11011
91         M           99999   Revaluations only                                      1   11050
92         M           99999   Depreciation                                           0   12010
95         M           99999   Recurring / Reversing                                  0   12015
                                                                                          12020
                                                                                          12030
                                                                                          12035
                                                                                          12036
                                                                                          12037
                                                                                          12040
                                                                                          12050
                                                                                          12051
                                                                                          12060
                                                                                          12070
                                                                                          12080
                                                                                          12090
                                                                                          12100
                                                                                          12110
                                                                                          12120
                                                                                          12130
                                                                                          12140
                                                                                          12150
                                                                                          13005
                                                                                          13010
                                                                                          13020
                                                                                          13030
                                                                                          13040
                                                                                          13050
                                                                                          13052
                                                                                          13055
                                                                                          13060
                                                                                          13063
                                                                                          13065
                                                                                          13070
                                                                                          13080
                                                                                          13090
14010
14011
14012
14013
14014
14015
14016
14017
14018
14020
14021
14022
14023
14030
14040
14050
14051
14060
15005
15010
15020
15030
15031
15040
15041
15050
15051
15055
15057
15060
15065
16010
16011
16012
16013
16014
16015
16020
16021
16025
16026
16030
16031
16032
16033
16034
16035
16036
16037
16038
16040
16041
16042
16043
16050
16060
16070
16090
16091
16092
16093
16094
16095
16096
16100
16110
16111
17010
17020
17030
17040
17041
18010
18011
18012
18013
18014
18017
18020
18021
18022
18023
18024
18025
18026
18027
18028
18029
18030
18031
18035
18040
18045
18050
18051
18052
18053
18054
19010
19020
19030
19040
19050
19060
19065
19080
19081
19085
19086
19090
20500
41008
51200
90000
90001
90100
90101
90102
90110
90111
90120
90121
90130
90131
90140
90141
90150
90151
90200
90201
90205
90210
90211
90212
90213
90220
90250
90255
90300
90305
90400
90401
90402
90410
90500
90501
90502
90505
90510
90511
90512
90513
90514
90515
90516
90517
90518
90519
90520
90550
90551
90560
90565
90567
90600
90610
90620
90630
90640
90650
90660
90670
90675
90680
90800
90801
90802
90810
90900
90905
90906
90910
90915
90920
90925
90930
90935
90940
90945
90950
90955
90960
90965
91100
91101
91102
91103
91104
91105
91107
91110
91200
91301
91302
91350
91351
91352
91353
91354
91355
91356
91358
91360
91361
91362
91363
91364
91365
91366
91367
91368
91369
91370
91371
91372
91390
91400
91401
91402
91500
91550
91600
91610
99995
99996
99997
99998
99999
oms25                             bal_vw   Type   CC_AC       CU_AC       UseItem       UseProject
Temp account - for reg invoices   B        N              0           0             0           0
Sales                             W        J              0           0             0           0
Intercompany Sales                W        J              0           0             0           0
Cost of Sales                     W        K              0           0             0           0
Std Cost Variance                 W        N              0           0             0           0
Std Cost Profit                   W        J              0           0             0           0
Std Cost Loss                     W        K              0           0             0           0
Intercompany Cost of Sales        W        K              0           0             0           0
Delivery Costs                    W        K              1           0             0           0
Inland Freight                    W        K              1           0             0           0
Advertising Allowance             W        K              1           0             0           0
Point of Sale Materials           W        K              1           0             0           0
Leaflets                          W        K              1           0             0           0
Managers Guide & SRF              W        K              1           0             0           0
Miscellaneous Printing            W        K              1           0             0           0
Specialised Packaging             W        K              1           0             0           0
Display Costs                     W        K              1           0             0           0
Inter-company Group Displays      W        K              1           0             0           0
Warehousing Costs                 W        K              1           0             0           0
Bonus certificates/Stamps         W        K              1           0             0           0
Licence Fees                      W        K              1           0             0           0
Travel                            W        K              1           0             0           0
Professional/Consultancy          W        K              1           0             0           0
Samples                           W        K              1           0             0           0
Temporary Staff                   W        K              1           0             0           0
Communications                    W        K              1           0             0           0
Manager's Incentives              W        K              1           0             0           0
DPE Miscellaneous                 W        K              1           0             0           0
Ex Gratia Payments                W        K              1           0             0           0
Gross Salaries                    W        K              0           0             0           0
Employer's NIC                    W        K              1           0             0           0
Bonuses                           W        K              0           0             0           0
Commissions                       W        K              0           0             0           0
Pensions                          W        K              0           0             0           0
new pensions account for demo     W        N              0           0             0           0
Life Assurance                    W        K              0           0             0           0
Medical Insurance                 W        K              0           0             0           0
Company Medical                   W        K              0           0             0           0
Temporary Staff                   W        K              0           0             0           0
Recruitment Fees                  W        K              0           0             0           0
Training Costs                    W        K              0           0             0           0
Relocation Costs                  W        K              0           0             0           0
Car Costs Fuel                   W   K   0   0   0   0
Service and Repairs              W   K   0   0   0   0
Vehicle Depreciation             W   K   0   0   1   0
Road Fund License                W   K   0   0   0   0
Car Hire                         W   K   0   0   0   0
Insurance                        W   K   0   0   0   0
Other Car Costs                  W   K   0   0   0   0
Leasing Costs                    W   K   0   0   0   0
Parking Costs                    W   K   0   0   0   0
Travel                           W   K   0   0   0   0
Mileage                          W   K   0   0   0   0
Other Travel                     W   K   0   0   0   0
Taxi                             W   K   0   0   0   0
Hotel                            W   K   0   0   0   0
Flights                          W   K   0   0   0   0
Staff Welfare                    W   K   0   0   0   0
Subsistence                      W   K   0   0   0   0
Entertaining                     W   K   0   0   0   0
Storage Rental                   W   K   0   0   0   0
Rent                             W   K   0   0   0   0
Rates                            W   K   0   0   0   0
Gas/Electricty                   W   K   0   0   0   0
Water                            W   K   0   0   0   0
Repairs and maintenance          W   K   0   0   0   0
Plant & Machinery Depreciation   W   K   0   0   0   0
Service Charges                  W   K   0   0   0   0
Indoor plant & flower Maintena   W   K   0   0   0   0
Building Insurance               W   K   0   0   0   0
Building Security                W   K   0   0   0   0
Leasehold Improvements Depn      W   K   0   0   0   0
Building Costs Miscellaneous     W   K   0   0   0   0
Stationery                       W   K   0   0   0   0
Office Supplies                  W   K   0   0   0   0
Tea, Coffee etc                  W   K   0   0   0   0
Donations                        W   K   0   0   0   0
Plant Hire & Maintenace          W   K   0   0   0   0
Leaflets                         W   K   0   0   0   0
Postage                          W   K   0   0   0   0
Couriers                         W   K   0   0   0   0
Freight Costs                    W   K   0   0   0   0
Freight Costs Holdings           W   K   0   0   0   0
Mobile Phones                    W   K   0   0   0   0
E Mail                           W   K   0   0   0   0
Fax                              W   K   0   0   0   0
Alarm                            W   K   0   0   0   0
Visa machine                     W   K   0   0   0   0
Phone Rent                       W   K   0   0   0   0
Fax                              W   K   0   0   0   0
Leased Line Rental               W   K   0   0   0   0
Internet Connection              W   K   0   0   0   0
Photocopier                      W   K   0   0   0   0
Mobile Phone Standing Charge     W   K   0   0   0   0
Mobile Phone Miscellaneous       W   K   0   0   0   0
Telephone Calls                  W   K   0   0   0   0
Office Furniture Depreciation    W   K   0   0   0   0
Office Equipment Depreciation    W   K   0   0   1   0
Computer Equipment Depreciatio   W   K   0   0   1   0
Cleaning                         W   K   0   0   0   0
Computer maintenance             W   K   0   0   0   0
Office equipment maintenance     W   K   0   0   0   0
Computer Software                W   K   0   0   0   0
Computer Equipment (non capita   W   K   0   0   0   0
Computer Licence Fees            W   K   0   0   0   0
IT Development                   W   K   0   0   0   0
Subscriptions                    W   K   0   0   0   0
Insurances                       W   K   0   0   0   0
Computer Insurance               W   K   0   0   0   0
Audit                            W   K   0   0   0   0
Taxation Fees                    W   K   0   0   0   0
Legal Fees                       W   K   0   0   0   0
Professional Fees                W   K   0   0   0   0
Consultancy                      W   K   0   0   0   0
Photography                      W   K   0   0   0   0
Design and Artwork               W   K   0   0   0   0
Transparancies                   W   K   0   0   0   0
Reprographic Costs               W   K   0   0   0   0
Printing                         W   K   0   0   0   0
Exhibitions                      W   K   0   0   0   0
Conferences                      W   K   0   0   0   0
Showcase                         W   K   0   0   0   0
Sales/Management meetings        W   K   0   0   0   0
Name Clearance                   W   K   0   0   0   0
Product Claims                   W   K   0   0   0   0
Samples                          W   K   0   0   0   0
Bar Code Generation              W   K   0   0   0   0
Safety Testing                   W   K   0   0   0   0
Translation Costs                W   K   0   0   0   0
Video Production                 W   K   0   0   0   0
Packaging Costs                  W   K   0   0   0   0
Market Research                  W   K   0   0   0   0
Quality Management               W   K   0   0   0   0
Group Display & BP Development   W   K   0   0   0   0
Group Packaging Development      W   K   0   0   0   0
Marketing                        W   K   0   0   0   0
Sales Development                W   K   0   0   0   0
Social Accountability/Quality    W   K   0   0   0   0
Pre Shipment Inspection          W   K   0   0   0   0
Capability Audits                W   K   0   0   0   0
Interest Received                W   J   0   0   0   0
Interest Paid                    W   K   0   0   0   0
Bank Charges                     W   K   0   0   0   0
Realised Exchange (Gain) Loss    W   K   0   0   0   0
Unrealised Exchange (Gain) Los   W   K   0   0   0   0
Sale of Fixed assets             W   J   0   0   0   0
Recharge of Overheads from Lon   W   N   0   0   0   0
Other Income/Expenses            W   N   0   0   0   0
Group Re-Allocation              W   N   0   0   0   0
Insurance Claims                 W   N   0   0   0   0
Purchase Ledger Write offs       W   N   0   0   0   0
Tax for Currrent Year            W   N   0   0   0   0
Unapproved expenses              B   N   0   0   0   0
Test Altavia 1 - sales           W   J   0   0   0   0
Test altavia 2 - COS             W   K   0   0   0   0
Technical account                W   N   0   0   0   0
Technical account                W   N   0   0   0   0
Leasehold Improvements - Cost    B   N   0   0   0   0
Leasehold Improvements - Depr    B   N   0   0   0   0
Freehold Assets - depr           B   N   0   0   0   0
Fixtures and Fittings - Cost     B   N   0   0   0   0
Fixtures and Fittings - Depr     B   N   0   0   0   0
Plant and Machinery - Cost       B   N   0   0   0   0
Plant and Machinery - Depr       B   N   0   0   0   0
Office Equipment - Cost          B   A   0   0   1   0
Office Equipment - Depr          B   A   0   0   1   0
Computer Equipment - Cost        B   A   0   0   1   0
Computer Equipment - Depr        B   A   0   0   1   0
Motor Vehicles -Cost             B   A   0   0   1   0
Motor Vehicles -Depr             B   A   0   0   1   0
Current Account                  B   B   0   0   0   0
Current Account                  B   B   0   0   0   0
Current Account London           B   N   0   0   0   0
Moneymaster                      B   N   0   0   0   0
US Dollar Account                B   B   0   0   0   0
US Dollar Deposit Account        B   N   0   0   0   0
Money Market Account             B   N   0   0   0   0
Euro Bank Account                B   B   0   0   0   0
Petty Cash                       B   S   0   0   0   0
Petty Cash Foreign               B   N   0   0   0   0
Trade Debtors                    B   D   0   0   0   0
Bad debt Provision               B   N   0   0   0   0
Stock                            B   G   0   0   0   0
Stock Purchases                  B   N   0   0   0   0
Stock Provisions                 B   N   0   0   0   0
Std Cost Price Offset            B   N   0   0   0   0
Sundry Debtors                   B   D   0   0   0   0
Recharges - External             B   N   0   0   0   0
Pre-Programme Expenses           B   N   0   0   0   0
Recharges - Internal             B   N   0   0   0   0
TCC USA                          B   N   0   0   0   0
TCC France                       B   N   0   0   0   0
TCC Germany                      B   N   0   0   0   0
TCC Holland                      B   N   0   0   0   0
TCC Hong Kong                    B   N   0   0   0   0
TCC Italy                        B   N   0   0   0   0
TCC Japan                        B   N   0   0   0   0
TCC Malaysia                     B   N   0   0   0   0
TCC New Zealand                  B   N   0   0   0   0
TCC Spain                        B   N   0   0   0   0
TCC Switzerland                  B   N   0   0   0   0
Deposits - Rent                  B   N   0   0   0   0
Deposits - Sundry                B   N   0   0   0   0
Sundry Debtors- Adv/Expenses     B   N   0   0   0   0
Sundry Debtors - Miscellaneous   B   N   0   0   0   0
Corporation Tax Asset            B   N   0   0   0   0
Prepaid Other                    B   N   0   0   0   0
Prepaid Rent                     B   N   0   0   0   0
Prepaid Service Charge           B   N   0   0   0   0
Prepaid Rates                    B   C   0   0   0   0
Prepaid Insurance                B   N   0   0   0   0
Prepaid Medical Cover            B   N   0   0   0   0
Prepaid PHI Cover                B   N   0   0   0   0
Prepaid Computer Maintenance     B   N   0   0   0   0
Prepaid VAC Sheets               B   N   0   0   0   0
Prepaid Professional Fees        B   N   0   0   0   0
Trade Creditors                  B   C   0   0   0   0
PL Settlement Discounts          B   N   0   0   0   0
GIN Accrual                      B   N   0   0   0   0
Other Creditors Due with 1 yea   B   N   0   0   0   0
Sourcing Company                 B   N   0   0   0   0
Interco with Chiswick            B   N   0   0   0   0
Interco with TCC Holland         B   N   0   0   0   0
Golf Continuity (Italy)          B   N   0   0   0   0
Promo Challenge (France)         B   N   0   0   0   0
TCC Spain                        B   N   0   0   0   0
Senata Marketing (Oper) Dutch    B   N   0   0   0   0
TCC Australia                    B   N   0   0   0   0
TCC New Zealand                  B   N   0   0   0   0
TCC Malaysia                     B   N   0   0   0   0
Hongkong Sales                   B   N   0   0   0   0
Senata Marketing (Holding)       B   N   0   0   0   0
Switzerland                      B   N   0   0   0   0
South Africa                     B   N   0   0   0   0
Sonata Re Belgium Deals          B   N   0   0   0   0
Net Pay Control                  B   G   0   0   0   0
PAYE                             B   N   0   0   0   0
Salary Advances                  B   N   0   0   0   0
Pensions                         B   N   0   0   0   0
SSP/SMP                          B   N   0   0   0   0
NI                               B   N   0   0   0   0
Tax credits                      B   N   0   0   0   0
Student Loan Deduction           B   N   0   0   0   0
Corporation Tax - Current Liab   B   N   0   0   0   0
Bonus Accruals                   B   N   0   0   0   0
Commission                       B   N   0   0   0   0
Sundry Accruals                  B   N   0   0   0   0
Electricity Accruals             B   N   0   0   0   0
Legal and Professional Accrual   B   N   0   0   0   0
Audit Fees Accruals              B   N   0   0   0   0
Tax Fees Accruals                     B   N   0   0   0   0
Telephone Accruals                    B   N   0   0   0   0
Trade Accruals                        B   N   0   0   0   0
Sundry Creditors                      B   N   0   0   0   0
DPE Acruals                           B   N   0   0   0   0
DPE Accrual - Unauthorised            B   N   0   0   0   0
DPE Accrual - JS Millenium Med        B   N   0   0   0   0
DPE Accrual - Tesco Strawberry        B   N   0   0   0   0
DPE Accrual - CRTG Sovereign T        B   N   0   0   0   0
DPE Accrual - Grahams Reward B        B   N   0   0   0   0
DPE Accrual - Lincoln Pyrex Na        B   N   0   0   0   0
DPE Accrual - Appleby Westward        B   N   0   0   0   0
DPE Accrual - Spar Ireland Cel        B   N   0   0   0   0
DPE Accrual - Elf Endangered S        B   N   0   0   0   0
DPE Accrual - CRTG Bouquet & B        B   N   0   0   0   0
DPE Accrual - CWS Northern Ire        B   N   0   0   0   0
DPE Accrual - Miscellaneous           B   N   0   0   0   0
Slaes Ledger Write Offs               B   N   0   0   0   0
VAT Control                           B   N   0   0   0   0
VAT Input                             B   C   0   0   0   0
VAT Output                            B   C   0   0   0   0
Other Creditors due after 1 ye        B   N   0   0   0   0
Long Term Provisions                  B   N   0   0   0   0
Previous Year Profit & Loss           B   N   0   0   0   0
Ordinary Share Capital                B   N   0   0   0   0
Unalloc cash (technical account)      B   N   0   0   0   0
Logistics suspense (technical account)B   N   0   0   0   0
Depreciation clearance                B   N   0   0   0   0
Sales Error Account                   W   N   0   0   0   0
Suspense                              B   N   0   0   0   0
          U
UseCreditor seDebtor blokkeer       Class_05
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
        0         0             0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0        555
0   0   0        555
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
0   0   0   <none>
Cost Centre Codes                                 Cost Unit Codes

CC       oms25                      Enabled       CU
_LOGISTC Logistics                            1   0100
001CC001 Default cost center                  1   200
601      Dep'n cost centre                    1   2008_TVN
ADMIN    Admin                                1   6777
CONSULT Consultancy                           1   EXACT
RND      Research and Development             1   RJ53 FKK
SALES    Sales Dept                           1   TRAIN
Cost Unit Codes                      Item Codes

         oms25                       ItemCode   Description_0
         CU 0100                     -          Std Shipping
         CU 200                      ~~10000    ~~10000
         San Antonio courses         ~~10010    ~~10010
         CU 6777                     ~~10020    ~~10020
         Globe training/reimplemen   ~~10030    ~~10030
         PPJ Ford Mondeo             ~~10040    ~~10040
         Training for sales team     ~~10050    ~~10050
                                     ~~10060    ~~10060
                                     ~~10070    ~~10070
                                     ~~10080
                                     ~~10090
                                     ~~10100
                                     ~~11000    ~~11000
                                     ~~12010    ~~12010
                                     ~~12015    ~~12015
                                     ~~12020    ~~12020
                                     ~~12024    ~~12024
                                     ~~12025    ~~12025
                                     ~~12026    ~~12026
                                     ~~12027    ~~12027
                                     ~~12030    ~~12030
                                     ~~12040    ~~12040
                                     ~~12045    ~~12045
                                     ~~12050    ~~12050
                                     ~~12060    ~~12060
                                     ~~12070    ~~12070
                                     ~~12080    ~~12080
                                     ~~12090    ~~12090
                                     ~~12100    ~~12100
                                     ~~12110    ~~12110
                                     ~~12120    ~~12120
                                     ~~12130    ~~12130
                                     ~~12140    ~~12140
                                     ~~12150    ~~12150
                                     ~~12160    ~~12160
                                     ~~12170    ~~12170
                                     ~~12175    ~~12175
                                     ~~12180    ~~12180
                                     ~~12190    ~~12190
                                     ~~50000    ~~50000
                                     ~~50010    ~~50010
                                     ~~50020    ~~50020
~~50030 ~~50030
~~50040 ~~50040
00        Payment condition 00
0001      Connector multipack
1001      Batch no'd Connector multipack
12020     Advertising & other services - AdvertisingAdvertisingAdverti
          21-char item code
123456789012345678901
1702605 Whitish Bath Towel
1702605-A Whitish Bath Towel at actual cost
1702606 Light Blue Bath Towel
1702607 Dark Blue Bath Towel
1702608 Red Bath Towel
1702609 Green Bath Towel
233640    Red Wine x4
233650    Champagne x4
233660    White Wine x4
454490    Set of 4 Red Wine glasses
454500    Made set of 4 White Wine glasses
454510    Set of 4 Champagne glasses
          20-char item
98765432109876543210code
COMM1 Commision type 1
DEFAULT DEFAULT
KIT1      Kit 1 - itself, serial numbered
KIT2_NS Kit 2 - itself, NOT serial numbered
KITBIT1 Kit Bit 1 - serial numbered
KITBIT2 Kit Bit 2 - serial numbered
LABOUR Time spent on the job
          Use a machine
MACHINE_USAGE
          T
MADE_ITEMest a made item for Tour Andersson
MAN_1     Manufactured top level
          SD Push Push, Open, SMT, 3.25mm Profile, PEG 0.7mm, Tray
MEM1050-00-325-01-B
          SD Push Pull,
MEM1055-00-280-01-B Open, SMT, 2.80mm Profle, PEG 0.5mm, Tray
          Micro SD Push Push, Open, SMT, 1.90mm Profile, No PEG, T&R
MEM2050-00-190-00-A
          PROJECT_TERM
PROJECT_TERM
RGTB900 Rituals Green Tea Bath Foam
RWTB900 Rituals White Tea Bath Foam
          Test wqrehouse 2
TEST WAREHOUSE
WPH       WPH
Project Numbers

ProjectNr prproject.Description prproject.Status
1         Glasses                 A
10                           10 A
13                           13 A
14        Project 14              A
15                           15 A
16                           16 A
17                           17 A
18                           18 P
19                           19 A
20        Made item - links?      A
210002                  210002 A
3         towels                  A
300001    Description of SO 31 A
300002    TEST INTRASTATS A
300003                  300003 A
300008                  300008 A
300009                  300009 A
300010    Test allocation         A
300011                  300011 A
300013                  300013 A
300021    Tess PO 5555            A
300022    TEST KIT1               A
454500                            P
          New project for Pyroban testing
5         Towels                  A
50601060 Project linked to s/n ...P
6         Wine glasses (cheap)A
7         Low price glasses       A
8         Aternative Del Addr A
          Change:                 A
BOM: 454500.001 Bill of materials 454500
          Change:                 A
BOM: 454500.002 Bill of materials 454500
          Change: Bill of materials KIT1
BOM: KIT1.001                     A
          Change: Bill            A
BOM: MADE_ITEM.001 of materials MADE_ITEM
          Change: Bill            A
BOM: MADE_ITEM.002 of materials MADE_ITEM
          Demo
CRM~GROUP:1                       A
          Intercompany
CRM~GROUP:25                      A
          Intercompany1
CRM~GROUP:26                      A
          TCC group
CRM~GROUP:27                      A
MRP       MRP                     A
          Netto
NETTO_G_01 Glassware promo        P
          Development of a new product line
NEW_LINE_DEV                      P
          TEST
PR0800000001 MADE ITEM P
          test
PR0800000002                      C
                        test
             PR0800000003                      P
             SPAR_G_1Spar glasses              P
             SPAR_G_2Further glasses promo     A
                        test stock count cost centre
             TEST_STOCK_COUNT                  A
             TEX_T_1 Texaco towels promo P
vertisingAdvertisingAdverti




5mm Profile, PEG 0.7mm, Tray
mm Profle, PEG 0.5mm, Tray
T, 1.90mm Profile, No PEG, T&R
CC Links                    CU Links

reknr      CC_Link          reknr      CU_Link
12030      12030_LOGISTCX
12030      12030ADMINX
12030      12030RNDX
12030      12030SALESX
12035      12035SALESX
12035      12035RNDX
12035      12035ADMINX
12035      12035_LOGISTCX
12036      12036_LOGISTCX
12036      12036ADMINX
12036      12036RNDX
12036      12036CONSULTX
12036      12036SALESX
12037      12037SALESX
12037      12037RNDX
12037      12037ADMINX
12037      12037_LOGISTCX
12040      12040_LOGISTCX
12040      12040ADMINX
12040      12040RNDX
12040      12040SALESX
12050      12050SALESX
12050      12050RNDX
12050      12050ADMINX
12050      12050_LOGISTCX
12051      12051_LOGISTCX
12051      12051ADMINX
12051      12051RNDX
12051      12051CONSULTX
12051      12051SALESX
12060      12060SALESX
12060      12060CONSULTX
12060      12060RNDX
12060      12060ADMINX
12060      12060_LOGISTCX
12070      12070_LOGISTCX
12070      12070ADMINX
12070      12070RNDX
12070      12070SALESX
12080      12080SALESX
12080      12080RNDX
12080      12080ADMINX
12080   12080_LOGISTCX
12090   12090ADMINX
12090   12090RNDX
12090   12090CONSULTX
12090   12090SALESX
12120   12120001CC001X
13005   13005SALESX
13005   13005CONSULTX
13005   13005RNDX
13005   13005ADMINX
13005   13005_LOGISTCX
13010   13010_LOGISTCX
13010   13010ADMINX
13010   13010RNDX
13010   13010CONSULTX
13010   13010SALESX
13015   13015SALESX
13015   13015RNDX
13015   13015ADMINX
13015   13015_LOGISTCX
13020   13020_LOGISTCX
13020   13020ADMINX
13020   13020RNDX
13020   13020CONSULTX
13020   13020SALESX
13030   13030SALESX
13030   13030CONSULTX
13030   13030RNDX
13030   13030ADMINX
13030   13030_LOGISTCX
13040   13040_LOGISTCX
13040   13040ADMINX
13040   13040RNDX
13040   13040CONSULTX
13040   13040SALESX
13050   13050SALESX
13050   13050CONSULTX
13050   13050RNDX
13050   13050ADMINX
13050   13050_LOGISTCX
13055   13055_LOGISTCX
13055   13055ADMINX
13055   13055RNDX
13055   13055CONSULTX
13055   13055SALESX
13060   13060SALESX
13060   13060CONSULTX
13060   13060RNDX
13060   13060ADMINX
13060   13060_LOGISTCX
13063   13063_LOGISTCX
13063   13063ADMINX
13063   13063RNDX
13063   13063CONSULTX
13063   13063SALESX
13065   13065SALESX
13065   13065CONSULTX
13065   13065RNDX
13065   13065ADMINX
13065   13065_LOGISTCX
13070   13070_LOGISTCX
13070   13070ADMINX
13070   13070RNDX
13070   13070CONSULTX
13070   13070SALESX
13080   13080SALESX
13080   13080CONSULTX
13080   13080RNDX
13080   13080ADMINX
13080   13080_LOGISTCX
13090   13090_LOGISTCX
13090   13090ADMINX
13090   13090RNDX
13090   13090CONSULTX
13090   13090SALESX
Currencies

valcode   active       Variable       oms30
ADP                0              0   Andorran Peseta
AED                0              0   Dihram - United Arab Emirates
AFN                0              0   Afghani
ALL                0              0   Lek
AMD                0              0   Armenian Dram
ANG                0              0   Netherlands Antillian Guilder
AOA                0              0   Kwanza
AOK                0              0   Kwanza
ARS                0              0   Argentina Peso
ATS                0              0   Schilling
AUD                0              0   Australian Dollar
AUS                0              0   AUS
AWG                0              0   Aruban Guilder
AZM                0              0   Azerbijan Manat
AZN                0              0   New Manat
BAM                0              0   Convertible Marks
BBD                0              0   Barbados Dollar
BDT                0              0   Taka
BEF                0              0   Belgian Franc
BGN                0              0   Lev
BHD                0              0   Bahraini Dinar
BIF                0              0   Burundi Franc
BMD                0              0   Bermudian Dollar
BND                0              0   Brunei Dollar
BOB                0              0   Boliviano
BRL                0              0   Real
BSD                0              0   Bahamian Dollar
BWP                0              0   Pula
BYR                0              0   Belarussian Ruble
BZD                0              0   Belize Dollar
CAD                0              0   Canadian Dollar
CDF                0              0   Franc Congolais
CHF                1              0   Swiss Franc
CLP                0              0   Chilean Peso
CNY                0              0   Yuan Renminbi
COP                0              0   Colombian Peso
CRC                0              0   Costa Rican Colon
CUP                0              0   Cuban Peso
CVE                0              0   Cape Verde Escudo
CYP                0              0   Cyprus Pound
CZK                0              0   Czech Republic Koruna
DEM                0              0   Deutsche Mark
DJF   0   0   Dijbouti Franc
DKK   0   0   Danish Krone
DOP   0   0   Dominican Peso
DZD   0   0   Algerian Dinar
EEK   0   0   Estonian Kroon
EGP   0   0   Egyptian Pound
ESP   0   0   Spanish Peseta
ETB   0   0   Ethiopian Birr
EUR   1   1   Euro
FIM   0   0   Markka
FJD   0   0   Fiji Dollar
FKP   0   0   Falkland Islands Pound
FRF   0   0   French Franc
GBP   1   0   Pound Sterling
GEL   0   0   Georgian Lari
GHC   0   0   Cedi
GIP   0   0   Gibraltar Pound
GMD   0   0   Dalasi
GNF   0   0   Guinea Franc
GRD   0   0   Drachma
GTQ   0   0   Quetzal
GWP   0   0   Guinea-Bissau Peso
GYD   0   0   Guyana Dollar
HKD   1   1   Hong Kong Dollar
HNL   0   0   Lempira
HRD   0   0   Croatian Dinar
HRK   0   0   Croatian Kuna
HTG   0   0   Gourde
HUF   0   0   Forint
IDR   0   0   Rupiah
IEP   0   0   Irish Pound
ILS   0   0   Shekel
INR   0   0   Indian Rupee
IQD   0   0   Iraqi Dinar
IRR   0   0   Iranian Rial
ISK   0   0   Iceland Krona
ITL   0   0   Italian Lira
JMD   0   0   Jamaican Dollar
JOD   0   0   Jordanian Dinar
JPY   0   0   Yen
KES   0   0   Kenyan Shilling
KGS   0   0   Kyrgyzstan Som
KHR   0   0   Riel
KMF   0   0   Comros Franc
KPW   0   0   North Korean Won
KRW   0   0   South Korean Won
KWD   0   0   Kuwaiti Dinar
KYD   0   0   Cayman Islands Dollar
KZT   0   0   Kazakhstan Tenge
LAK   0   0   Kip
LBP   0   0   Lebanese Pound
LKR   0   0   Sri Lanka Rupee
LRD   0   0   Liberian Dollar
LSL   0   0   Loti
LTL   0   0   Lithuanian Litas
LUF   0   0   Luxembourg Franc
LVL   0   0   Latvian Lat
LYD   0   0   Libyan Dinar
MAD   0   0   Moroccan Dirham
MCD   0   0   Macedonian Denar
MDL   0   0   Moldovan Leu
MGF   0   0   Malagasy Franc
MKD   0   0   Macedonian Denar
MMK   0   0   Kyat
MNT   0   0   Tugrik
MOP   0   0   Pataca
MRO   0   0   Ouguiya
MTL   0   0   Maltese Lira
MUR   0   0   Mauritius Rupee
MVR   0   0   Rufiyaa
MXN   0   0   Mexican Peso
MYR   0   0   Malaysian Ringgit
MZM   0   0   Metical
MZN   0   0   New Metical
NAD   0   0   Namibian Dollar
NGN   0   0   Naira
NIO   0   0   Cordoba Oro
NLG   0   0   Nederlandse gulden
NOK   0   0   Norwegian Krone
NPR   0   0   Nepalese Rupee
NZD   0   0   New Zealand Dollar
OMR   0   0   Rial Omani
PAB   0   0   Balboa
PEI   0   0   Inti
PEN   0   0   Peruvian New Sol
PGK   0   0   Kina
PHP   0   0   Philippine Peso
PKR   0   0   Pakistan Rupee
PLN   0   0   Zloty
PTE   0   0   Portuguese Escudo
PYG   0   0   Guarani
QAR   0   0   Quatari Rial
RON   0   0   Leu
RSD   0   0   Serbia Dinars
RUB   0   0   Russian Rouble
RWF   0   0   Rwanda Franc
SAR   0   0   Saudi Riyal
SBD   0   0   Solomon Islands Dollar
SCR   0   0   Seychelles Rupee
SDP   0   0   Sudanese Pound
SEK   0   0   Swedish Krona
SGD   0   0   Singapore Dollar
SHP   0   0   St. Helena Pound
SIT   0   0   Slovenian Tolar
SKK   0   0   Slovak Koruna
SLL   0   0   Leone
SOS   0   0   Somali Shilling
SRD   0   0   Surinam Dollar
SRG   0   0   Suriname Guilder
STD   0   0   Dobra
SVC   0   0   El Salvador Colon
SYP   0   0   Syrian Pound
SZL   0   0   Lilangeni
THB   0   0   Baht
TJS   0   0   Somoni
TMM   0   0   Turkmenistan Manat
TND   0   0   Tunisian Dinar
TOP   0   0   Pa'anga
TPE   0   0   Timor Escudo
TRL   0   0   Turkish Lira
TTD   0   0   Trinidad & Tobago Dollar
TWD   0   0   New Taiwan Dollar
TZS   0   0   Tanzanian Shilling
UAH   0   0   Ukraine Hryvnia
UGX   0   0   Uganda Shilling
USD   1   0   US Dollar
UYP   0   0   Uruguayan Peso
UZS   0   0   Uzbekistan Som
VEB   0   0   Bolivar
VND   0   0   Dong
VUV   0   0   Vatu
WST   0   0   Tala
XAF   0   0   CFA Franc BEAC
XCD   0   0   East Caribbean Dollar
XEU   0   0   European Currency Unit E.C.U.
XOF   0   0   CFA Franc BCEAO
XPF   0   0   CFP Franc
YDD   0   0   Yemeni Dinar
YER   0   0   Yemeni Rial
YUM   0   0   Yugoslavian Dinar
ZAR   0   0   Rand
ZMK   0   0   Kwacha
ZWD   0   0   Zimbabwe Dollar
Creditors                                       Debtors

Creditor    Cent_Acc   cicmpy.cmp_name          Debtor
1                      Peter Phelps-Jones       2756
2                      James Barrie             2757
3                      Iain Maynard Banks       2760
4                      Greg Bear                00010
5                      Stephen Donaldson        00034
6                      Ursula Kroeber Le Guin   00040
2750        90800      TNT                      00041
2752        90800      Eurozone Supplier        00147
2753        90800      HSBC                     02728
2754        90800      Premier Travel Inn       02746
2755        90800      Tudor Rose               02748
00012       90800      TCC HK                   29999
00020       90800      Exact UK                 30001
30003                  Healthcare 21 co 050     30002
000000      90800      Unknown creditor         000000
000002      90800      Tax creditor
cicmpy.cmp_name         GL
test lead
Binders Keepers
Make me a lead...
TCC Hong Kong
TCC Holland
TCC Switzerland
TCC France
Spar ireland
Texaco Head Office
Texaco branch in Leeds
Texaco branch in Huudersfield
US Debtor - number 29999
New test customer
TEST NEW CUST
Unknown debtor

								
To top