Using Formatted Search on SAP B1

Using Formatted Search on SAP B1
Format SAP

SAP B1 provides complete fields in its modules. But the need for additional fields according to the company's internal needs is certainly inevitable. SAP B1 has anticipated this by providing UDF facilities (regarding UDF you can read in my previous article on #UDT & UDF on SAP B1). On this occasion I will discuss how to fill in fields automatically by using the Formatted Search (FS) facility. We can use FS to fill in the default SAP B1 fields or our own custom fields (UDF).

This automatic field filling is done to simplify and speed up the data input process. For example, we have a project with the code "PROJECT-1", the fields related to the project (eg area, project area, company, document format, etc.) will be automatically filled after we press the Tab key (note SAP B1 use the Tab key to move between fields, not the Enter key).

FS can be used for calculation operations or copy the contents of a field to another field. For example in the Banking Module -> Outgoing Payment, all we need to do is write Remarks and then press the Tab key automatically, the contents will be copied into the Journal Remarks field below. In the following simple example we will implement it. Follow the steps below:

• Make a simple query using a query generator (about the details of how to use the query generator you can read in my previous post in #Name Table & Field in SAP B1 - Part1), write the query in the Select column: SELECT LEFT ($ [OVPM.Comments ], 50), then click the Execute button and ignore the error message that appears. Save the query by clicking the Save button and name it FS_JURNALREMARKS.

• Place the mouse cursor position in the Journal Remarks field by clicking on the field, then pressing Alt + Shift + F2 together, the "User Defined Values ​​- Setup" dialog form is displayed
• Choose the third option which is "Search in Existing User-Defined Values ​​according to Saved Query"

• Press the "Open Saved Query" button then look for the query that you created (FS_JURNALREMARKS) then click OK.
• The "User-Defined Values ​​- Setup" dialog form is displayed again with the query selected. Check the "Auto Refresh When Field Changes" option and in the drop down box look for the "Remarks" field, click the "Display Saved User-Defined Values" option then click the Update button.

When you click in the Journal Remarks field there will be a "magnifying glass" sign that indicates that the field is an FS. To try it write a word such as "Testing FS" then press the Tab key, the contents will automatically be copied in the Journal Remarks field below.

Hopefully useful, enjoy

Shortcut Used in SAP Business One

Shortcut Used in SAP 

Use of Shortcuts in SAP Business one is used to facilitate the user in opening the display more efficiently

General Shortcut

Display the Main Menu in SAP Business One	CTRL + 0 (zero)
Print a document	CTRL + P
Display Journal Transactions	CTRL + J
Exit SAP Business One	CTRL + Q
Undo	CTRL + Z
Redo	CTRL + SHIFT + Z
Cut	CTRL + X
Copy	CTRL + C
Paste	CTRL + V
Showing Customer Name or Item that starts with a certain letter	Enter the name at the end of the * sign, then Tab
Select multiple items at once	CTRL / SHIFT and select Item
Showing User Defined Fields (Additional fields)	CTRL + SHIFT + U
Showing Next Record / Document	CTRL + Right Arrow
Showing Previous Records / Documents	CTRL + Left Arrow
Change Mode to ADD	CTRL + A
Change Mode to Find	CTRL + F
Change Field Name	CTRL + Double Click
Fill in today's date	Input Any character then Tab
Close the Form that appears	Esq
Add Rows	CTRL + I
Line Duplication	CTRL + M
Delete Row	CTRL + K
Sort the Ascending and Descending Columns	Double Click on the Column header
Showing Row Details	CTRL + L
Return to First Line	CTRL + H
Return to the Last Row	CTRL + E
Copy from the line above	CTRL + ↑ / CTRL + ↓
Calculation of Gross Profit	CTRL + G
Open Document Base	CTRL + N
Opening Target Documents	CTRL + T
Go to the Customer Code Field	CTRL + U
Go to Field Remarks	CTRL + R
Open the Batch / Serial Number Form	CTRL + Tab In the Quantity column
Showing the Last Price	CTRL + Tab In the Price column
Display the Alternate Item	CTRL + Tab In the Item column
Showing the amount of stock in the warehouse	CTRL + Tab In the Warehouse column
Open the Settings Form	CTRL + SHIFT + S

Error Message SAP Business One

Error Message SAP Business One

Note: If the error message you are experiencing is not here, please send the error to the comment provided


When we want to do Data Input or when opening SAP Business One we often find errors. Therefore I will help you to provide a solution if you meet Error Message as follows.

Global

Event: When logging in
Error: You Cannot open Window [683] Message with your current license
Problem: Because you do not have licenses to use SAP
Solution: Buy a license, then install the license (ask your partner to install the license)
If you already have a license, the next step is to ask your boss who has a Superuser ID to check the Module Administration - License - License administration

Click Button Update, and congratulations on using SAP.

All Transaction

Event: When Transaction Add
Error: No Matching records found G / L Accounts
Problem: There is an account that has not been set
Solution: Please setup the account on the Item Group / Warehouse / Master Data Items depending on the G / L account setup by https://sapbusinessonesap.blogspot.com/

Incoming Payment


Event: When You Want to Open the Incoming Payment Form
Error: Primary sales account linking has not been completed
Problem: There is an account that has not been setup in GL Account determination
Solution: Account Setup in Administration - Setup - Financial - GL Account Determination Field (Domestic Account Receivable, Foreign Accounts Receivable, Revenue Account)

List of Visual Basic General Error Traps

Trap errors can occur when your application is running. Some pitfalls of errors can also occur during development or when compiling an application that you create. You can test and respond to errors that occur using the "On Error" statement and the Err object. Error numbers in the range of 1 to 1000 have been provided for use in Visual Basic in later periods.

The list of error traps below is a common error trap in Visual Basic coupled with general errors related to a certain general object, while for some other objects, such as ADO, or Datagrid, or others, have their own list of error traps, separate from the list of error traps below.

Code Message / Description

3 Return without GoSub
5 Invalid procedure call
6 Overflow
7 Out of memory
9 Subscript out of range
10 This array is fixed or temporarily locked
11 Division by zero
13 Type mismatch
14 Out of string space
16 Expression too complex
17 can 't perform requested operation
18 User interrupt occurred
20 Resume without error
28 Out of stack space
35 Sub, Function, or Property not defined
47 Too many DLL application clients
48 Error in loading DLL
49 Bad DLL calling convention
51 Internal Error
52 Bad file name or number
53 file Not found
54 Bad file mode
55 File already open
57 Device I/O error
58 File already exists
59 Bad record length
61 Disk full
62 Input past end of file
63 Bad record number
67 Too many files
68 Device unavailable
70 Permission denied
71 Disk Not Ready
74 can 't rename with different drive
75 Path/File access error
76 Path Not found
91 Object variable or With block variable not set
92 For loop not initialized
93 Invalid pattern string
94 Invalid use of Null
97 can 't call Friend procedure on an object that is not an instance of the defining class
98 A property or method call cannot include a reference to a private object, either as an argument or as a return value
260 No timer available
282 No foreign application responded to a DDE initiate
285 Foreign application won't perform DDE method or operation
286 Timeout while waiting for DDE response
287 User pressed Escape key during DDE operation
288 Destination is busy
290 Data in wrong format
293 DDE Method invoked with no channel open
294 Invalid DDE Link format
295 Message queue filled; DDE message lost
296 PasteLink already performed on this control
297 can 't set LinkMode; invalid LinkTopic
298 System DLL 'dll' could not be loaded
320 can 't use character device names in file names: 'item'
321 Invalid file format
322 Can’t create necessary temporary file
325 Invalid format in resource file
326 Resource with identifier 'item' not found
327 Data value named not found
328 Illegal parameter; can't write arrays
335 Could not access system registry
336 Component not correctly registered
337 component Not found
338 Component did not run correctly
339 object server 'item' not correctly registered
or not found (Error 339)
340 Control array element 'item' doesn't exist
341 Invalid control array index
342 Not enough room to allocate control array 'item'
343 Object not an array
344 Must specify index for object array
345 Reached limit: cannot create any more controls on this form
360 Object already loaded
361 can 't load or unload this object
362 can 't unload controls created at design time
363 ActiveX Control 'item' not found
364 Object was unloaded
365 Unable to unload within this context
366 No MDI form available to load
367 can 't load (or register) ActiveX control: 'item'
368 the file 'item' is out of date. This program requires a newer version
369 Operation not valid in a DLL
370 The ActiveX Designer's Type Information does not match what was saved. Unable to Load
371 The specified object can't be used as an owner form for Show()
378 'item' cannot be set while loading
379 You can 't put a Default or Cancel button on a Property Page
380 Invalid property value
381 Invalid property array index
382 'Item' property cannot be set at run time
383 'Item' property is read-only
384 A form can't be moved or sized while minimized or maximized
385 Must specify index when using property array
387 'Item' property can't be set on this control
388 can 't set Visible property from a parent menu
389 invalid Key
393 'Item' property cannot be read at run time
394 'Item' property is write-only
395 Cannot use separator bar as menu name for this control
396 'Item' property cannot be set within a page
397 can 't load, unload, or set Visible property for top level menus while they are merged
398 client Not Site
399 You can 't put a Default or Cancel button on a User Control unless its DefaultCancel property is set
400 Form already displayed; can't show modally
401 can 't show non-modal form when modal form is displayed
402 Must close or hide topmost modal form first
403 MDI forms cannot be shown modally
404 MDI child forms cannot be shown modally
405 Unable to show modal form within this context
406 Non-modal forms cannot be displayed in this host application from an ActiveX DLL
419 Permission to use object denied
422 Property not found
423 Property or method not found
424 object required
425 Invalid object use
426 Only one MDI Form allowed
427 Invalid object type; Menu control required
428 Popup menu must have at least one submenu
429 License information for this component not found. You do not have an appropriate license to use this functionality in the design environment
430 Class doesn 't support Automation
432 File name or class name not found during Automation operation
438 object doesn 't support this property or method
440 Automation Error
442 Connection to type library or object library for remote process has been lost
443 Automation object doesn't have a default value
444 Method not applicable in this context
445 object doesn 't support this action
446 object doesn 't support named arguments
447 object doesn 't support current locale setting
448 Named Not argument
449 Argument not optional or invalid property assignment
450 Wrong number of arguments or invalid property assignment
451 Object not a collection
452 invalid ordinal
453 Specified Not found
454 Code Not Resource
455 Code resource lock error
457 This key is already associated with an element of this collection
458 Variable uses a type not supported in Visual Basic
459 This component doesn't support the set of events
460 Invalid Clipboard format
461 Method or data member not found
462 The remote server machine does not exist or is unavailable
463 Class not registered on local machine
480 can 't create AutoRedraw image
481 invalid Picture
482 Printer Error
483 Printer driver does not support specified property
484 Problem getting printer information from the system. Make sure the printer is set up correctly
485 Invalid picture type
486 can 't print form image to this type of printer
490 Top-level or invalid menu specified as PopupMenu default
520 can 't empty Clipboard
521 can 't open Clipboard
523 The data binding DLL, 'item', could not be loaded
524 'item'
525 Data Access Error
527 The given bookmark was invalid
536 Could not lock the database
537 Could not access the desired Column
541 Could not lock the database
542 The row has been deleted since the update was started
545 Unable to bind to field: 'item'
672 DataObject formats list may not be cleared or expanded outside of the OLEStartDrag event
673 Expected at least one argument
674 Illegal recursive invocation of OLE drag and drop
675 Non-intrinsic OLE drag and drop formats used with SetData require Byte array data. GetData may return more bytes than were given to SetData
676 Requested data was not supplied to the DataObject during the OLESetData event
688 Failure in AsyncRead
689 PropertyName parameter conflicts with the PropertyName of an AsyncRead in progress
690 can 't find or load the required file urlmon.dll
693 An unknown protocol was specified in Target parameter
735 can 't save file to TEMP directory
744 Search Not text
746 Replacements too long
31001 Out of memory
31004 no object
31018 Class is not set
31027 Unable to activate object
31032 Unable to create embedded object
31036 Error saving to file
31037 Error loading from file

Daftar Perangkap Error CommonDialog
Berikut daftar perangkap error untuk object CommonDialog

Code Message / Description

20476 The FileName buffer is too small to store the selected file name(s)
20477 invalid filename
20478 An attempt to subclass a ListBox failed due to insufficient memory
24574 No fonts exist
28660 The [devices] section of the file WIN.INI did not contain an entry for the requested printer
28661 The PrintDlg function failed when it attempted to create an Information context
28662 The data in the DEVMODE and DEVNAMES data structures describes two different printers
28663 A default printer does not exist
28664 No printer device drivers were found
28665 The PrintDlg function failed during initialization
28666 The printer device driver failed to initialize a DEVMODE data structure
28667 The PrintDlg function failed to load the specified printer's Device driver
28668 The PD_RETURNDEFAULT flag was set in the Flags member of the PRINTDLG data structure but either the hDevMode or hDevNames field were nonzero
28669 The common dialog function failed to parse the strings in the [devices] section of the file WIN.INI
28670 Load of required resources failed
28671 The PD_RETURNDEFAULT flag was set in the Flags member of the PRINTDLG data structure, but either the hDevMode or hDevNames field were nonzero
31001 Out of memory
32751 Help call fail. Check Help properties.
32752 Low on memory! Can't bring up the dialog!
32753 couldn 't determine procedure address(es). \nSelect a different DLL.
32754 DLL selected couldn't be loaded
32755 Cancel was selected
32756 The ENABLEHOOK flag was set in the Flags member of a common dialog data structure but the application failed to provide a pointer to a corresponding hook function
32757 The common dialog function was unable to lock the memory associated with a handle
32758 The common dialog function was unable to allocate memory for internal data structures
32759 The common dialog function failed to lock a specified resource
32760 The common dialog function failed to load a specified resource
32761 The common dialog function failed to find a specified resource
32762 The common dialog function failed to load a specified string
32763 The ENABLETEMPLATE flag was set in the Flags member of a common dialog data structure but the application failed to provide a corresponding instance handle
32764 The ENABLETEMPLATE flag was set in the Flags member of a common dialog data structure but the application failed to provide a corresponding template
32765 The common dialog function failed during initialization
32766 The lStructSize member of the corresponding common dialog Data structure Is invalid

Make a Query in SAP business One

Cara membuat Query Di SAP business One

Cara Membuat Query di Query Generator SAP Business One

1. Understand how to create and conceptualize database structures, if you don't understand this, maybe this link http://www.w3schools.com/sql/default.asp can help you, or other links

2. Knowing the Table Name and Field in SAP

• Display System Information in advance (View - System information Or Shortcut CTRL + SHIFT + I)

• Open one of the documents that you will display in the query, for example I want to create a query to display the Sales Order

• Place the Cursor Position on the Field that will be displayed, then information about the Field and the name of the table will be displayed as shown below. Position is below the left

• After you know the Table Name and Field, the next step is to create the query. How to Tools - Query - Query Generator

• Then Forms Like This Will Be Displayed

• You Simply Fill in a Table Name In a field like the picture above Ex (OITM) then Tab, then a list will appear showing all the fields in the table

• Double Click the Field that will be displayed in the Query

Column Select - displays all fields that will be displayed in the Query
Column From - Table Name
Column Where - To fill in the Parameters / do Filters, you can click the Condition button below. see the next step
Sort By Field - Data displayed will be sorted by the Field selected
Group By - column If the data you want to display will be grouped.

Then click Execute, then the Form parameter that is registered will be displayed

Then select the item to be filtered and click the OK button and please enjoy the query that you created.

How to display the Save Query 
1.Select Tools - Queries - User Queries or on the toolbar click the image as below

will display the entire list of queries that have been saved

How to Edit a Save Query
1. Open the Query to edit, click the Pencil image

2. Edit the Query in the field as drawn.

3. Click Execute Button to see the results of query changes
4. Click Save Button to save the edited query

Authorization Query Manager SAP Business One

Authorization - Query Manager

In SAP Business One has several special functions to provide authorization to each user
In this case I will explain the authorization related to Query manager and Export Excell, SAP Query Grouping only provides up to 15 Groups.

Per Group Query manager authorization. To do the Setup Query manager what to do is :
1. Open the Query manager that has been saved
2. click the manage Category button

3. Group Category per Group,

For example
Group 1 may only be opened by the Purchasing section
Group 2 may only be opened by the Sales department
And so on, according to the grouping needed







4. After grouping, the next step is to give authorization rights to each user by opening the Administration module - System initialization - Authorization

5. Select the user who will be given authorization for the Group that has been determined. for example I chose user 01ACC01 for Group 1

6. After selecting the user in the right column, select Reports - Query generator - Give Full Authorization only for Group 1

7. Click Button Update. Then User 01ACC01 can only see all Queries in Group 1

 Export Excel Authorization

So that the user cannot use the Excel Export Function Simply provide the authorization that is on
Administration - System initialization - Authorization
1. Open the Administration module - System initialization - Authorization

2. Select the User who will be given authorization
3. In the right column click the black arrow on General - MS-Excel
4. Select Full Authorization if the user is allowed to export data to Excel and authorize if the user is not allowed to access export data to Excel.

5. Click Button Update.

Related Table in SAP Business One

Related Table in SAP Business One

Related Table In SAP BUSINESS ONE
Can function to help friends in Join Table.

Object From	Object To	Join String
CPN1	CPN1	CPN1 T0
CPN1	OCRD	CPN1 T0 INNER JOIN OCRD T1 ON T0.BpCode = T1.CardCode
CPN1	OCRD	CPN1 T0 INNER JOIN OCRD T1 ON T0."BpCode" = T1."CardCode"
CRD1	OCRD	CRD1 T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
CRD1	OCRD	CRD1 T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
CTR1	CTR1	CTR1 T0
CTR1	OCRD	CTR1 T0 INNER JOIN  OCTR T2 ON T0.ContractID = T2.ContractID INNER JOIN OCRD T1 ON T2.CstmrCode = T1.CardCode
CTR1	OCRD	CTR1 T0 INNER JOIN OCTR T2 ON T0."ContractID" = T2."ContractID" INNER JOIN OCRD T1 ON T2."CstmrCode" = T1."CardCode"
CTR1	OCTR	CTR1 T0 INNER JOIN OCTR T1 ON T0.ContractID = T1.ContractID
CTR1	OCTR	CTR1 T0 INNER JOIN OCTR T1 ON T0."ContractID" = T1."ContractID"
CTR1	OINS	CTR1 T0 INNER JOIN OINS T1 ON T0.InsID = T1.insID
CTR1	OINS	CTR1 T0 INNER JOIN OINS T1 ON T0."InsID" = T1."insID"
CTR1	OITB	CTR1 T0 INNER JOIN OITB T1 ON T0.ItemGroup = T1.ItmsGrpCod
CTR1	OITB	CTR1 T0 INNER JOIN OITB T1 ON T0."ItemGroup" = T1."ItmsGrpCod"
CTR1	OITM	CTR1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
CTR1	OITM	CTR1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DLN1	DLN1	DLN1 T0
DLN1	DPI1	DLN1 T0 INNER JOIN DPI1 T1 ON T1.BaseEntry = T0.DocEntry AND T1.BaseType = 15 AND T1.BaseLine = T0.LineNum
DLN1	DPI1	DLN1 T0 INNER JOIN DPI1 T1 ON T1."BaseEntry" = T0."DocEntry" AND T1."BaseType" = 15 AND T1."BaseLine" = T0."LineNum"
DLN1	INV1	DLN1 T0 INNER JOIN INV1 T1 ON T1.BaseEntry = T0.DocEntry AND T1.BaseType = 15 AND T1.BaseLine = T0.LineNum
DLN1	INV1	DLN1 T0 INNER JOIN INV1 T1 ON T1."BaseEntry" = T0."DocEntry" AND T1."BaseType" = 15 AND T1."BaseLine" = T0."LineNum"
DLN1	OACT	DLN1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
DLN1	OACT	DLN1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
DLN1	OCLG	DLN1 T0 INNER JOIN  ODLN T2 ON T0.DocEntry = T2.DocEntry INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
DLN1	OCLG	DLN1 T0 INNER JOIN ODLN T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode" INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
DLN1	OCPR	DLN1 T0 INNER JOIN ODLN T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
DLN1	OCPR	DLN1 T0 INNER JOIN ODLN T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
DLN1	OCRD	DLN1 T0 INNER JOIN ODLN T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
DLN1	OCRD	DLN1 T0 INNER JOIN ODLN T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
DLN1	ODLN	DLN1 T0 INNER JOIN ODLN T1 ON T0.DocEntry = T1.DocEntry
DLN1	ODLN	DLN1 T0 INNER JOIN ODLN T1 ON T0."DocEntry" = T1."DocEntry"
DLN1	ODPI	ODPI T1 INNER JOIN DPI1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 15 AND T2.BaseLine = T0.LineNum
DLN1	ODPI	ODPI T1 INNER JOIN DPI1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 15 AND T2."BaseLine" = T0."LineNum"
DLN1	OINV	OINV T1 INNER JOIN INV1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 15 AND T2.BaseLine = T0.LineNum
DLN1	OINV	OINV T1 INNER JOIN INV1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 15 AND T2."BaseLine" = T0."LineNum"
DLN1	OITB	DLN1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
DLN1	OITB	DLN1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
DLN1	OITM	DLN1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
DLN1	OITM	DLN1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DLN1	OMRC	DLN1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
DLN1	OMRC	DLN1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
DLN1	OPRJ	DLN1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
DLN1	OPRJ	DLN1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
DLN1	ORDN	ORDN T1 INNER JOIN RDN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 15 AND T2.BaseLine = T0.LineNum
DLN1	ORDN	ORDN T1 INNER JOIN RDN1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 15 AND T2."BaseLine" = T0."LineNum"
DLN1	ORDR	ORDR T1 INNER JOIN RDR1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DLN1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 17 AND T0.BaseLine = T2.LineNum
DLN1	ORDR	ORDR T1 INNER JOIN RDR1  T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DLN1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 17 AND T0."BaseLine" = T2."LineNum"
DLN1	OSLP	DLN1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
DLN1	OSLP	DLN1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
DLN1	OWHS	DLN1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
DLN1	OWHS	DLN1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
DLN1	RDR1	NULL
DPI1	DLN1	DPI1 T0 INNER JOIN DLN1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 15 AND T0.BaseLine = T1.LineNum
DPI1	DLN1	DPI1 T0 INNER JOIN DLN1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 15 AND T0."BaseLine" = T1."LineNum"
DPI1	DPI1	DPI1 T0
DPI1	OACT	DPI1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
DPI1	OACT	DPI1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
DPI1	OCLG	DPI1 T0 INNER JOIN  ODPI T2 ON T0.DocEntry = T2.DocEntry INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
DPI1	OCLG	DPI1 T0 INNER JOIN ODPI T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode" INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
DPI1	OCPR	DPI1 T0 INNER JOIN ODPI T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
DPI1	OCPR	DPI1 T0 INNER JOIN ODPI T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
DPI1	OCRD	DPI1 T0 INNER JOIN ODPI T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
DPI1	OCRD	DPI1 T0 INNER JOIN ODPI T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
DPI1	ODLN	ODLN T1 INNER JOIN DLN1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DPI1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 15 AND T0.BaseLine = T2.LineNum
DPI1	ODLN	ODLN T1 INNER JOIN DLN1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DPI1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 15 AND T0."BaseLine" = T2."LineNum"
DPI1	ODPI	DPI1 T0 INNER JOIN ODPI T1 ON T0.DocEntry = T1.DocEntry
DPI1	ODPI	DPI1 T0 INNER JOIN ODPI T1 ON T0."DocEntry" = T1."DocEntry"
DPI1	OITB	DPI1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
DPI1	OITB	DPI1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
DPI1	OITM	DPI1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
DPI1	OITM	DPI1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DPI1	OMRC	DPI1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
DPI1	OMRC	DPI1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
DPI1	OPRJ	DPI1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
DPI1	OPRJ	DPI1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
DPI1	OQUT	OQUT T1 INNER JOIN QUT1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DPI1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 23 AND T0.BaseLine = T2.LineNum
DPI1	OQUT	OQUT T1 INNER JOIN QUT1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DPI1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 23 AND T0."BaseLine" = T2."LineNum"
DPI1	ORDR	ORDR T1 INNER JOIN RDR1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DPI1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 17 AND T0.BaseLine = T2.LineNum
DPI1	ORDR	ORDR T1 INNER JOIN RDR1 T2 ON T1."DocEntry" = T2."DocEntry"  INNER JOIN DPI1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 17 AND T0."BaseLine" = T2."LineNum"
DPI1	ORIN	ORIN T1 INNER JOIN RIN1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 203 AND T2.BaseLine = T0.LineNum
DPI1	ORIN	ORIN T1 INNER JOIN RIN1  T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 203 AND T2."BaseLine" = T0."LineNum"
DPI1	OSLP	DPI1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
DPI1	OSLP	DPI1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
DPI1	OWHS	DPI1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
DPI1	OWHS	DPI1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
DPI1	QUT1	DPI1 T0 INNER JOIN QUT1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 23 AND T0.BaseLine = T1.LineNum
DPI1	QUT1	DPI1 T0 INNER JOIN QUT1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 23 AND T0."BaseLine" = T1."LineNum"
DPI1	RDR1	DPI1 T0 INNER JOIN RDR1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 17 AND T0.BaseLine = T1.LineNum
DPI1	RDR1	DPI1 T0 INNER JOIN RDR1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 17 AND T0."BaseLine" = T1."LineNum"
DPO1	DPO1	DPO1 T0
DPO1	OACT	DPO1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
DPO1	OACT	DPO1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
DPO1	OCLG	DPO1 T0 INNER JOIN  ODPO T2 ON T0.DocEntry = T2.DocEntry INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
DPO1	OCLG	DPO1 T0 INNER JOIN ODPO T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode" INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
DPO1	OCPR	DPO1 T0 INNER JOIN ODPO T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
DPO1	OCPR	DPO1 T0 INNER JOIN ODPO T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
DPO1	OCRD	DPO1 T0 INNER JOIN ODPO T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
DPO1	OCRD	DPO1 T0 INNER JOIN ODPO T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
DPO1	ODPO	DPO1 T0 INNER JOIN ODPO T1 ON T0.DocEntry = T1.DocEntry
DPO1	ODPO	DPO1 T0 INNER JOIN ODPO T1 ON T0."DocEntry" = T1."DocEntry"
DPO1	OITB	DPO1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
DPO1	OITB	DPO1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
DPO1	OITM	DPO1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
DPO1	OITM	DPO1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DPO1	OMRC	DPO1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
DPO1	OMRC	DPO1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"  INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
DPO1	OPDN	OPDN T1 INNER JOIN PDN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DPO1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 204 AND T2.BaseLine = T0.LineNum
DPO1	OPDN	OPDN T1 INNER JOIN PDN1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DPO1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 204 AND T2."BaseLine" = T0."LineNum"
DPO1	OPOR	OPOR T1 INNER JOIN POR1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN  DPO1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 22 AND T0.BaseLine = T2.LineNum
DPO1	OPOR	OPOR T1 INNER JOIN POR1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN DPO1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 22 AND T0."BaseLine" = T2."LineNum"
DPO1	OPQT	OPQT T1 INNER JOIN PQT1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN DPO1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 540000006 AND T0.BaseLine = T2.LineNum
DPO1	OPRJ	DPO1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
DPO1	OPRJ	DPO1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
DPO1	OSLP	DPO1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
DPO1	OSLP	DPO1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
DPO1	OWHS	DPO1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
DPO1	OWHS	DPO1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
DPO1	PDN1	DPO1 T0 INNER JOIN PDN1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 20 AND T0.BaseLine = T1.LineNum
DPO1	PDN1	DPO1 T0 INNER JOIN PDN1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 20 AND T0."BaseLine" = T1."LineNum"
DPO1	POR1	DPO1 T0 INNER JOIN POR1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 22 AND T0.BaseLine = T1.LineNum
DPO1	POR1	DPO1 T0 INNER JOIN POR1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 22 AND T0."BaseLine" = T1."LineNum"
DPO1	PQT1	DPO1 T0 INNER JOIN PQT1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 540000006 AND T0.BaseLine = T1.LineNum
INV1	DLN1	INV1 T0 INNER JOIN DLN1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 15 AND T0.BaseLine = T1.LineNum
INV1	DLN1	INV1 T0 INNER JOIN DLN1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 15 AND T0."BaseLine" = T1."LineNum"
INV1	INV1	INV1 T0
INV1	OACT	INV1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
INV1	OACT	INV1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
INV1	OCLG	INV1 T0 INNER JOIN  OINV T2 ON T0.DocEntry = T2.DocEntry INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
INV1	OCLG	INV1 T0 INNER JOIN OINV T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode" INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
INV1	OCPR	INV1 T0 INNER JOIN OINV T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
INV1	OCPR	INV1 T0 INNER JOIN OINV T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
INV1	OCRD	INV1 T0 INNER JOIN OINV T2 ON T0.DocEntry = T2.DocEntry INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
INV1	OCRD	INV1 T0 INNER JOIN OINV T2 ON T0."DocEntry" = T2."DocEntry" INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
INV1	ODLN	ODLN T1 INNER JOIN DLN1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN INV1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 13 AND T2.BaseLine = T0.LineNum
INV1	ODLN	ODLN T1 INNER JOIN DLN1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN INV1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 13 AND T2."BaseLine" = T0."LineNum"
INV1	OINV	INV1 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry
INV1	OINV	INV1 T0 INNER JOIN OINV T1 ON T0."DocEntry" = T1."DocEntry"
INV1	OITB	INV1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
INV1	OITB	INV1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
INV1	OITM	INV1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
INV1	OITM	INV1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
INV1	OMRC	INV1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
INV1	OMRC	INV1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode" INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
INV1	OPRJ	INV1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
INV1	OPRJ	INV1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
INV1	OQUT	OQUT T1 INNER JOIN QUT1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN INV1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 23 AND T0.BaseLine = T2.LineNum
INV1	OQUT	OQUT T1 INNER JOIN QUT1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN INV1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 23 AND T0."BaseLine" = T2."LineNum"
INV1	ORDR	ORDR T1 INNER JOIN RDR1  T2 ON T1.DocEntry = T2.DocEntry INNER JOIN INV1 T0 ON T0.BaseEntry = T2.DocEntry AND T0.BaseType = 17 AND T0.BaseLine = T2.LineNum
INV1	ORDR	ORDR T1 INNER JOIN RDR1 T2 ON T1."DocEntry" = T2."DocEntry"  INNER JOIN INV1 T0 ON T0."BaseEntry" = T2."DocEntry" AND T0."BaseType" = 17 AND T0."BaseLine" = T2."LineNum"
INV1	ORIN	ORIN T1 INNER JOIN RIN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN INV1 T0 ON T2.BaseEntry = T0.DocEntry AND T2.BaseType = 13 AND T2.BaseLine = T0.LineNum
INV1	ORIN	ORIN T1 INNER JOIN RIN1 T2 ON T1."DocEntry" = T2."DocEntry" INNER JOIN INV1 T0 ON T2."BaseEntry" = T0."DocEntry" AND T2."BaseType" = 13 AND T2."BaseLine" = T0."LineNum"
INV1	OSLP	INV1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
INV1	OSLP	INV1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
INV1	OWHS	INV1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
INV1	OWHS	INV1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
INV1	QUT1	INV1 T0 INNER JOIN QUT1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 23 AND T0.BaseLine = T1.LineNum
INV1	QUT1	INV1 T0 INNER JOIN QUT1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 23 AND T0."BaseLine" = T1."LineNum"
INV1	RDR1	INV1 T0 INNER JOIN RDR1 T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType = 17 AND T0.BaseLine = T1.LineNum
INV1	RDR1	INV1 T0 INNER JOIN RDR1 T1 ON T0."BaseEntry" = T1."DocEntry" AND T0."BaseType" = 17 AND T0."BaseLine" = T1."LineNum"
JDT1	JDT1	JDT T0
JDT1	OACT	JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode
JDT1	OACT	JDT1 T0 INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
JDT1	OCRD	JDT1 T0 INNER JOIN  OCRD T1 ON T0.ShortName = T1.CardCode
JDT1	OCRD	JDT1 T0 INNER JOIN OCRD T1 ON T0."ShortName" = T1."CardCode"
JDT1	ODPI	JDT1 T0 INNER JOIN ODPI T1 ON T0.TransId = T1.TransId
JDT1	ODPI	JDT1 T0 INNER JOIN ODPI T1 ON T0."TransId" = T1."TransId"
JDT1	ODPO	JDT1 T0 INNER JOIN ODPO T1 ON T0.TransId = T1.TransId
JDT1	ODPO	JDT1 T0 INNER JOIN ODPO T1 ON T0."TransId" = T1."TransId"
JDT1	OINV	JDT1 T0 INNER JOIN OINV T1 ON T0.TransId = T1.TransId
JDT1	OINV	JDT1 T0 INNER JOIN OINV T1 ON T0."TransId" = T1."TransId"
JDT1	OJDT	JDT1 T0 INNER JOIN OJDT T1 ON T0.TransId = T1.TransId
JDT1	OJDT	JDT1 T0 INNER JOIN OJDT T1 ON T0."TransId" = T1."TransId"
JDT1	OPCH	JDT1 T0 INNER JOIN OPCH T1 ON T0.TransId = T1.TransId
JDT1	OPCH	JDT1 T0 INNER JOIN OPCH T1 ON T0."TransId" = T1."TransId"
JDT1	ORIN	JDT1 T0 INNER JOIN ORIN T1 ON T0.TransId = T1.TransId
JDT1	ORIN	JDT1 T0 INNER JOIN ORIN T1 ON T0."TransId" = T1."TransId"
JDT1	ORPC	JDT1 T0 INNER JOIN ORPC T1 ON T0.TransId = T1.TransId
JDT1	ORPC	JDT1 T0 INNER JOIN ORPC T1 ON T0."TransId" = T1."TransId"
OACT	DLN1	OACT T0 INNER JOIN DLN1 T1 ON T0.AcctCode = T1.AcctCode
OACT	DLN1	OACT T0 INNER JOIN DLN1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	DPI1	OACT T0 INNER JOIN DPI1 T1 ON T0.AcctCode = T1.AcctCode
OACT	DPI1	OACT T0 INNER JOIN DPI1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	DPO1	OACT T0 INNER JOIN DPO1 T1 ON T0.AcctCode = T1.AcctCode
OACT	DPO1	OACT T0 INNER JOIN DPO1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	INV1	OACT T0 INNER JOIN INV1 T1 ON T0.AcctCode = T1.AcctCode
OACT	INV1	OACT T0 INNER JOIN INV1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	JDT1	OACT T0 INNER JOIN JDT1 T1 ON T0.AcctCode = T1.Account
OACT	JDT1	OACT T0 INNER JOIN JDT1 T1 ON T0."AcctCode" = T1."Account"
OACT	OACT	OACT T0
OACT	OJDT	OACT T0 INNER JOIN JDT1 T2 ON T0.AcctCode = T2.Account INNER JOIN OJDT T1 ON T2.TransId = T1.TransId
OACT	OJDT	OACT T0 INNER JOIN JDT1 T2 ON T0."AcctCode" = T2."Account" INNER JOIN OJDT T1 ON T2."TransId" = T1."TransId"
OACT	PCH1	OACT T0 INNER JOIN PCH1 T1 ON T0.AcctCode = T1.AcctCode
OACT	PCH1	OACT T0 INNER JOIN PCH1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	PDN1	OACT T0 INNER JOIN PDN1 T1 ON T0.AcctCode = T1.AcctCode
OACT	PDN1	OACT T0 INNER JOIN PDN1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	POR1	OACT T0 INNER JOIN POR1 T1 ON T0.AcctCode = T1.AcctCode
OACT	POR1	OACT T0 INNER JOIN POR1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	PQT1	OACT T0 INNER JOIN PQT1 T1 ON T0.AcctCode = T1.AcctCode
OACT	QUT1	OACT T0 INNER JOIN QUT1 T1 ON T0.AcctCode = T1.AcctCode
OACT	QUT1	OACT T0 INNER JOIN QUT1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT	RDR1	OACT T0 INNER JOIN RDR1 T1 ON T0.AcctCode = T1.AcctCode
OACT	RDR1	OACT T0 INNER JOIN RDR1 T1 ON T0."AcctCode" = T1."AcctCode"
OAT1	OAT1	OAT1 T0
OAT1	OCRD	OAT1 T0 INNER JOIN OOAT T2 ON T0.AgrNo = T2.AbsID INNER JOIN OCRD T1 ON T2.BpCode = T1.CardCode
OAT1	OCRD	OAT1 T0 INNER JOIN OOAT T2 ON T0."AgrNo" = T2."AbsID" INNER JOIN OCRD T1 ON T2."BpCode" = T1."CardCode"
OAT1	OITB	OAT1 T0 INNER JOIN OITB T1 ON T0.ItemGroup = T1.ItmsGrpCod
OAT1	OITB	OAT1 T0 INNER JOIN OITB T1 ON T0."ItemGroup" = T1."ItmsGrpCod"
OAT1	OITM	OAT1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
OAT1	OITM	OAT1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
OAT1	OOAT	OAT1 T0 INNER JOIN OOAT T1 ON T0.AgrNo = T1.AbsID
OAT1	OOAT	OAT1 T0 INNER JOIN OOAT T1 ON T0."AgrNo" = T1."AbsID"
OCLG	DLN1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ODLN T3 ON T2.CardCode = T3.CardCode INNER JOIN DLN1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	DLN1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN ODLN T3 ON T2."CardCode" = T3."CardCode" INNER JOIN DLN1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	DPI1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ODPI T3 ON T2.CardCode = T3.CardCode INNER JOIN DPI1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	DPI1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN ODPI T3 ON T2."CardCode" = T3."CardCode" INNER JOIN DPI1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	DPO1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ODPO T3 ON T2.CardCode = T3.CardCode INNER JOIN DPO1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	DPO1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN ODPO T3 ON T2."CardCode" = T3."CardCode" INNER JOIN DPO1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	INV1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OINV T3 ON T2.CardCode = T3.CardCode INNER JOIN INV1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	INV1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN OINV T3 ON T2."CardCode" = T3."CardCode" INNER JOIN INV1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	OCLG	OCLG T0
OCLG	OCRD	OCLG T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
OCLG	OCRD	OCLG T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
OCLG	ODLN	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ODLN T1 ON T2.CardCode = T1.CardCode
OCLG	ODLN	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN ODLN T1 ON T2."CardCode" = T1."CardCode"
OCLG	ODPI	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ODPI T1 ON T2.CardCode = T1.CardCode
OCLG	ODPI	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN ODPI T1 ON T2."CardCode" = T1."CardCode"
OCLG	ODPO	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ODPO T1 ON T2.CardCode = T1.CardCode
OCLG	ODPO	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN ODPO T1 ON T2."CardCode" = T1."CardCode"
OCLG	OINV	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OINV T1 ON T2.CardCode = T1.CardCode
OCLG	OINV	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN OINV T1 ON T2."CardCode" = T1."CardCode"
OCLG	OPCH	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPCH T1 ON T2.CardCode = T1.CardCode
OCLG	OPCH	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN OPCH T1 ON T2."CardCode" = T1."CardCode"
OCLG	OPDN	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPDN T1 ON T2.CardCode = T1.CardCode
OCLG	OPDN	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN OPDN T1 ON T2."CardCode" = T1."CardCode"
OCLG	OPOR	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPOR T1 ON T2.CardCode = T1.CardCode
OCLG	OPOR	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN OPOR T1 ON T2."CardCode" = T1."CardCode"
OCLG	OPQT	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPQT T1 ON T2.CardCode = T1.CardCode
OCLG	OQUT	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OQUT T1 ON T2.CardCode = T1.CardCode
OCLG	OQUT	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN OQUT T1 ON T2."CardCode" = T1."CardCode"
OCLG	ORDR	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ORDR T1 ON T2.CardCode = T1.CardCode
OCLG	ORDR	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN ORDR T1 ON T2."CardCode" = T1."CardCode"
OCLG	PCH1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPCH T3 ON T2.CardCode = T3.CardCode INNER JOIN PCH1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	PCH1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN OPCH T3 ON T2."CardCode" = T3."CardCode" INNER JOIN PCH1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	PDN1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPDN T3 ON T2.CardCode = T3.CardCode INNER JOIN PDN1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	PDN1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN OPDN T3 ON T2."CardCode" = T3."CardCode" INNER JOIN PDN1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	POR1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPOR T3 ON T2.CardCode = T3.CardCode INNER JOIN POR1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	POR1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN OPOR T3 ON T2."CardCode" = T3."CardCode" INNER JOIN POR1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	PQT1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OPQT T3 ON T2.CardCode = T3.CardCode INNER JOIN PQT1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	QUT1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN OQUT T3 ON T2.CardCode = T3.CardCode INNER JOIN QUT1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	QUT1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN OQUT T3 ON T2."CardCode" = T3."CardCode" INNER JOIN QUT1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG	RDR1	OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN ORDR T3 ON T2.CardCode = T3.CardCode INNER JOIN RDR1 T1 ON T3.DocEntry = T1.DocEntry
OCLG	RDR1	OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode" INNER JOIN ORDR T3 ON T2."CardCode" = T3."CardCode" INNER JOIN RDR1 T1 ON T3."DocEntry" = T1."DocEntry"
OCPN	CPN1	OCPN T0 INNER JOIN CPN1 T1 ON T0.CpnNo = T1.CpnNo
OCPN	CPN1	OCPN T0 INNER JOIN CPN1 T1 ON T0."CpnNo" = T1."CpnNo"
OCPN	OCPN	OCPN T0
OCPN	OCRD	OCPN T0 INNER JOIN CPN1 T2 ON T0.CpnNo = T2.CpnNo INNER JOIN OCRD T1 ON T2.BpCode = T1.CardCode
OCPN	OCRD	OCPN T0 INNER JOIN CPN1 T2 ON T0."CpnNo" = T2."CpnNo" INNER JOIN OCRD T1 ON T2."BpCode" = T1."CardCode"
OCPN	OITM	OCPN T0 INNER JOIN CPN2 T2 ON T0.CpnNo = T2.CpnNo INNER JOIN OITM T1 ON T2.ItemCode = T1.ItemCode
OCPN	OITM	OCPN T0 INNER JOIN CPN2 T2 ON T0."CpnNo" = T2."CpnNo" INNER JOIN OITM T1 ON T2."ItemCode" = T1."ItemCode"
OCPN	OPRT	OCPN T0 INNER JOIN CPN3 T2 ON T0.CpnNo = T2.CpnNo INNER JOIN OPRT T1 ON T2.ParterId = T1.PrtId
OCPN	OPRT	OCPN T0 INNER JOIN CPN3 T2 ON T0."CpnNo" = T2."CpnNo" INNER JOIN OPRT T1 ON T2."ParterId" = T1."PrtId"
OCPN	OTGG	OCPN T0 INNER JOIN OTGG T1 ON T0.TargetGrp = T1.TargetCode
OCPN	OTGG	OCPN T0 INNER JOIN OTGG T1 ON T0."TargetGrp" = T1."TargetCode"
OCPR	DLN1	OCPR T0 INNER JOIN ODLN T2 ON T0.CntctCode = T2.CntctCode INNER JOIN DLN1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	DLN1	OCPR T0 INNER JOIN ODLN T2 ON T0."CntctCode" = T2."CntctCode"  INNER JOIN DLN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	DPI1	OCPR T0 INNER JOIN ODPI T2 ON T0.CntctCode = T2.CntctCode INNER JOIN DPI1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	DPI1	OCPR T0 INNER JOIN ODPI T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN DPI1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	DPO1	OCPR T0 INNER JOIN ODPO T2 ON T0.CntctCode = T2.CntctCode INNER JOIN DPO1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	DPO1	OCPR T0 INNER JOIN ODPO T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN DPO1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	INV1	OCPR T0 INNER JOIN OINV T2 ON T0.CntctCode = T2.CntctCode INNER JOIN INV1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	INV1	OCPR T0 INNER JOIN OINV T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN INV1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	OCPR	OCPR T0
OCPR	OCRD	OCPR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
OCPR	OCRD	OCPR T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
OCPR	OCTR	OCPR T0 INNER JOIN OCTR T1 ON T0.CntctCode = T1.CntctCode
OCPR	OCTR	OCPR T0 INNER JOIN OCTR T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	ODLN	OCPR T0 INNER JOIN ODLN T1 ON T0.CntctCode = T1.CntctCode
OCPR	ODLN	OCPR T0 INNER JOIN ODLN T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	ODPI	OCPR T0 INNER JOIN ODPI T1 ON T0.CntctCode = T1.CntctCode
OCPR	ODPI	OCPR T0 INNER JOIN ODPI T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	ODPO	OCPR T0 INNER JOIN ODPO T1 ON T0.CntctCode = T1.CntctCode
OCPR	ODPO	OCPR T0 INNER JOIN ODPO T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	OINS	OCPR T0 INNER JOIN OINS T1 ON T0.CntctCode = T1.contactCod
OCPR	OINS	OCPR T0 INNER JOIN OINS T1 ON T0."CntctCode" = T1."contactCod"
OCPR	OINV	OCPR T0 INNER JOIN OINV T1 ON T0.CntctCode = T1.CntctCode
OCPR	OINV	OCPR T0 INNER JOIN OINV T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	OPCH	OCPR T0 INNER JOIN OPCH T1 ON T0.CntctCode = T1.CntctCode
OCPR	OPCH	OCPR T0 INNER JOIN OPCH T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	OPDN	OCPR T0 INNER JOIN OPDN T1 ON T0.CntctCode = T1.CntctCode
OCPR	OPDN	OCPR T0 INNER JOIN OPDN T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	OPOR	OCPR T0 INNER JOIN OPOR T1 ON T0.CntctCode = T1.CntctCode
OCPR	OPOR	OCPR T0 INNER JOIN OPOR T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	OPQT	OCPR T0 INNER JOIN OPQT T1 ON T0.CntctCode = T1.CntctCode
OCPR	OQUT	OCPR T0 INNER JOIN OQUT T1 ON T0.CntctCode = T1.CntctCode
OCPR	OQUT	OCPR T0 INNER JOIN OQUT T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	ORDR	OCPR T0 INNER JOIN ORDR T1 ON T0.CntctCode = T1.CntctCode
OCPR	ORDR	OCPR T0 INNER JOIN ORDR T1 ON T0."CntctCode" = T1."CntctCode"
OCPR	OSCL	OCPR T0 INNER JOIN OSCL T1 ON T0.CntctCode = T1.contctCode
OCPR	OSCL	OCPR T0 INNER JOIN OSCL T1 ON T0."CntctCode" = T1."contctCode"
OCPR	PCH1	OCPR T0 INNER JOIN OPCH T2 ON T0.CntctCode = T2.CntctCode INNER JOIN PCH1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	PCH1	OCPR T0 INNER JOIN OPCH T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN PCH1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	PDN1	OCPR T0 INNER JOIN OPDN T2 ON T0.CntctCode = T2.CntctCode INNER JOIN PDN1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	PDN1	OCPR T0 INNER JOIN OPDN T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN PDN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	POR1	OCPR T0 INNER JOIN OPOR T2 ON T0.CntctCode = T2.CntctCode INNER JOIN POR1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	POR1	OCPR T0 INNER JOIN OPOR T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN POR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	PQT1	OCPR T0 INNER JOIN OPQT T2 ON T0.CntctCode = T2.CntctCode INNER JOIN PQT1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	QUT1	OCPR T0 INNER JOIN OQUT T2 ON T0.CntctCode = T2.CntctCode INNER JOIN QUT1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	QUT1	OCPR T0 INNER JOIN OQUT T2 ON T0."CntctCode" = T2."CntctCode" INNER JOIN QUT1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR	RDR1	OCPR T0 INNER JOIN ORDR T2 ON T0.CntctCode = T2.CntctCode INNER JOIN RDR1 T1 ON T2.DocEntry = T1.DocEntry
OCPR	RDR1	OCPR T0 INNER JOIN ORDR T2 ON T0."CntctCode" = T2."CntctCode"  INNER JOIN RDR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	CRD1	OCRD T0 INNER JOIN CRD1 T1 ON T0.CardCode = T1.CardCode
OCRD	CRD1	OCRD T0 INNER JOIN CRD1 T1 ON T0."CardCode" = T1."CardCode"
OCRD	CTR1	OCRD T0 INNER JOIN  OCTR T2 ON  T0.CardCode = T2.CstmrCode INNER JOIN CTR1 T1 ON T1.ContractID = T2.ContractID
OCRD	CTR1	OCRD T0 INNER JOIN OCTR T2 ON  T0."CardCode" = T2."CstmrCode" INNER JOIN CTR1 T1 ON T1."ContractID" = T2."ContractID"
OCRD	DLN1	OCRD T0 INNER JOIN ODLN T2 ON T0.CardCode = T2.CardCode INNER JOIN DLN1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	DLN1	OCRD T0 INNER JOIN ODLN T2 ON T0."CardCode" = T2."CardCode" INNER JOIN DLN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	DPI1	OCRD T0 INNER JOIN ODPI T2 ON T0.CardCode = T2.CardCode INNER JOIN DPI1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	DPI1	OCRD T0 INNER JOIN ODPI T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN DPI1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	DPO1	OCRD T0 INNER JOIN ODPO T2 ON T0.CardCode = T2.CardCode INNER JOIN DPO1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	DPO1	OCRD T0 INNER JOIN ODPO T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN DPO1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	INV1	OCRD T0 INNER JOIN OINV T2 ON T0.CardCode = T2.CardCode INNER JOIN INV1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	INV1	OCRD T0 INNER JOIN OINV T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN INV1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	JDT1	OCRD T0 INNER JOIN JDT1 T1 ON T1.ShortName = T0.CardCode
OCRD	JDT1	OCRD T0 INNER JOIN JDT1 T1 ON T1."ShortName" = T0."CardCode"
OCRD	OCLG	OCRD T0 INNER JOIN OCLG T1 ON T0.CardCode = T1.CardCode
OCRD	OCLG	OCRD T0 INNER JOIN OCLG T1 ON T0."CardCode" = T1."CardCode"
OCRD	OCPR	OCRD T0 INNER JOIN OCPR T1 ON T0.CardCode = T1.CardCode AND T0.CardCode = T1.CardCode
OCRD	OCPR	OCRD T0 INNER JOIN OCPR T1 ON T0."CardCode" = T1."CardCode" AND T0."CardCode" = T1."CardCode"
OCRD	OCRD	OCRD T0
OCRD	OCRG	OCRG T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode
OCRD	OCRG	OCRG T0 INNER JOIN OCRG T1 ON T0."GroupCode" = T1."GroupCode"
OCRD	OCTG	OCRD T0 INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum
OCRD	OCTG	OCRD T0 INNER JOIN OCTG T1 ON T0."GroupNum" = T1."GroupNum"
OCRD	OCTR	OCRD T0 INNER JOIN OCTR T1 ON T0.CardCode = T1.CstmrCode
OCRD	OCTR	OCRD T0 INNER JOIN OCTR T1 ON T0."CardCode" = T1."CstmrCode"
OCRD	ODLN	OCRD T0 INNER JOIN ODLN T1 ON T0.CardCode = T1.CardCode
OCRD	ODLN	OCRD T0 INNER JOIN ODLN T1 ON T0."CardCode" = T1."CardCode"
OCRD	ODPI	OCRD T0 INNER JOIN ODPI T1 ON T0.CardCode = T1.CardCode
OCRD	ODPI	OCRD T0 INNER JOIN ODPI T1 ON T0."CardCode" = T1."CardCode"
OCRD	ODPO	OCRD T0 INNER JOIN ODPO T1 ON T0.CardCode = T1.CardCode
OCRD	ODPO	OCRD T0 INNER JOIN ODPO T1 ON T0."CardCode" = T1."CardCode"
OCRD	OINS	OCRD T0 INNER JOIN OINS T1 ON T0.CardCode = T1.customer
OCRD	OINS	OCRD T0 INNER JOIN OINS T1 ON T0."CardCode" = T1."customer"
OCRD	OINV	OCRD T0 INNER JOIN OINV T1 ON T0.CardCode = T1.CardCode
OCRD	OINV	OCRD T0 INNER JOIN OINV T1 ON T0."CardCode" = T1."CardCode"
OCRD	OITM	OCRD T0 INNER JOIN OITM T1 ON T0.CardCode = T1.CardCode
OCRD	OITM	OCRD T0 INNER JOIN OITM T1 ON T0."CardCode" = T1."CardCode"
OCRD	OJDT	OJDT T1 INNER JOIN JDT1 T2 ON T1.TransId = T2.TransId INNER JOIN OCRD T0 ON T2.ShortName = T0.CardCode
OCRD	OJDT	OJDT T1 INNER JOIN JDT1 T2 ON T1."TransId" = T2."TransId" INNER JOIN OCRD T0 ON T2."ShortName" = T0."CardCode"
OCRD	OMRC	OINM T2 INNER JOIN  OCRD T0 ON T2.CardCode = T0.CardCode INNER JOIN  OMRC T1 INNER JOIN  OITM T3 ON T1.FirmCode = T3.FirmCode ON T2.ItemCode = T3.ItemCode
OCRD	OMRC	OINM T2 INNER JOIN OCRD T0 ON T2."CardCode" = T0."CardCode" INNER JOIN OMRC T1 INNER JOIN OITM T3 ON T1."FirmCode" = T3."FirmCode" ON T2."ItemCode" = T3."ItemCode"
OCRD	OPCH	OCRD T0 INNER JOIN OPCH T1 ON T0.CardCode = T1.CardCode
OCRD	OPCH	OCRD T0 INNER JOIN OPCH T1 ON T0."CardCode" = T1."CardCode"
OCRD	OPDN	OCRD T0 INNER JOIN OPDN T1 ON T0.CardCode = T1.CardCode
OCRD	OPDN	OCRD T0 INNER JOIN OPDN T1 ON T0."CardCode" = T1."CardCode"
OCRD	OPOR	OCRD T0 INNER JOIN OPOR T1 ON T0.CardCode = T1.CardCode
OCRD	OPOR	OCRD T0 INNER JOIN OPOR T1 ON T0."CardCode" = T1."CardCode"
OCRD	OPQT	OCRD T0 INNER JOIN OPQT T1 ON T0.CardCode = T1.CardCode
OCRD	OQUT	OCRD T0 INNER JOIN OQUT T1 ON T0.CardCode = T1.CardCode
OCRD	OQUT	OCRD T0 INNER JOIN OQUT T1 ON T0."CardCode" = T1."CardCode"
OCRD	ORDR	OCRD T0 INNER JOIN ORDR T1 ON T0.CardCode = T1.CardCode
OCRD	ORDR	OCRD T0 INNER JOIN ORDR T1 ON T0."CardCode" = T1."CardCode"
OCRD	OSCL	OCRD T0 INNER JOIN OSCL T1 ON T0.CardCode = T1.customer
OCRD	OSCL	OCRD T0 INNER JOIN OSCL T1 ON T0."CardCode" = T1."customer"
OCRD	OSLP	OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
OCRD	OSLP	OCRD T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
OCRD	PCH1	OCRD T0 INNER JOIN OPCH T2 ON T0.CardCode = T2.CardCode INNER JOIN PCH1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	PCH1	OCRD T0 INNER JOIN OPCH T2 ON T0."CardCode" = T2."CardCode" INNER JOIN PCH1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	PDN1	OCRD T0 INNER JOIN OPDN T2 ON T0.CardCode = T2.CardCode INNER JOIN PDN1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	PDN1	OCRD T0 INNER JOIN OPDN T2 ON T0."CardCode" = T2."CardCode" INNER JOIN PDN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	POR1	OCRD T0 INNER JOIN OPOR T2 ON T0.CardCode = T2.CardCode INNER JOIN POR1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	POR1	OCRD T0 INNER JOIN OPOR T2 ON T0."CardCode" = T2."CardCode" INNER JOIN POR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	PQT1	OCRD T0 INNER JOIN OPQT T2 ON T0.CardCode = T2.CardCode INNER JOIN PQT1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	QUT1	OCRD T0 INNER JOIN OQUT T2 ON T0.CardCode = T2.CardCode INNER JOIN QUT1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	QUT1	OCRD T0 INNER JOIN OQUT T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN QUT1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD	RDR1	OCRD T0 INNER JOIN ORDR T2 ON T0.CardCode = T2.CardCode INNER JOIN RDR1 T1 ON T2.DocEntry = T1.DocEntry
OCRD	RDR1	OCRD T0 INNER JOIN ORDR T2 ON T0."CardCode" = T2."CardCode"  INNER JOIN RDR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRG	OCLG	NULL
OCRG	OCRD	OCRG T0 INNER JOIN  OCRD T1 ON T0.GroupCode = T1.GroupCode
OCRG	OCRD	OCRG T0 INNER JOIN OCRD T1 ON T0."GroupCode" = T1."GroupCode"
OCRG	OCRG	OCRG T0
OCRG	ODLN	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  ODLN T1 ON T2.CardCode = T1.CardCode
OCRG	ODLN	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN ODLN T1 ON T2."CardCode" = T1."CardCode"
OCRG	ODPI	OCRG T0 INNER JOIN OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  ODPI T1 ON T2.CardCode = T1.CardCode
OCRG	ODPI	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN ODPI T1 ON T2."CardCode" = T1."CardCode"
OCRG	ODPO	OCRG T0 INNER JOIN OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  ODPO T1 ON T2.CardCode = T1.CardCode
OCRG	ODPO	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN ODPO T1 ON T2."CardCode" = T1."CardCode"
OCRG	OINV	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  OINV T1 ON T2.CardCode = T1.CardCode
OCRG	OINV	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"  INNER JOIN OINV T1 ON T2."CardCode" = T1."CardCode"
OCRG	OPCH	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  OPCH T1 ON T2.CardCode = T1.CardCode
OCRG	OPCH	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN OPCH T1 ON T2."CardCode" = T1."CardCode"
OCRG	OPDN	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  OPDN T1 ON T2.CardCode = T1.CardCode
OCRG	OPDN	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN OPDN T1 ON T2."CardCode" = T1."CardCode"
OCRG	OPOR	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  OPOR T1 ON T2.CardCode = T1.CardCode
OCRG	OPOR	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN OPOR T1 ON T2."CardCode" = T1."CardCode"
OCRG	OPQT	OCRG T0 INNER JOIN OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN OPQT T1 ON T2.CardCode = T1.CardCode
OCRG	OQUT	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  OQUT T1 ON T2.CardCode = T1.CardCode
OCRG	OQUT	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN OQUT T1 ON T2."CardCode" = T1."CardCode"
OCRG	ORDN	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  ORDN T1 ON T2.CardCode = T1.CardCode
OCRG	ORDN	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"  INNER JOIN ORDN T1 ON T2."CardCode" = T1."CardCode"
OCRG	ORDR	OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode INNER JOIN  ORDR T1 ON T2.CardCode = T1.CardCode
OCRG	ORDR	OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode" INNER JOIN ORDR T1 ON T2."CardCode" = T1."CardCode"
OCRG	RDR1	NULL
OCTG	OCRD	OCTG T0 INNER JOIN OCRD T1 ON T0.GroupNum = T1.GroupNum
OCTG	OCRD	OCTG T0 INNER JOIN OCRD T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	OCTG	OCTG T0
OCTG	ODLN	OCTG T0 INNER JOIN ODLN T1 ON T0.GroupNum = T1.GroupNum
OCTG	ODLN	OCTG T0 INNER JOIN ODLN T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	ODPI	OCTG T0 INNER JOIN ODPI T1 ON T0.GroupNum = T1.GroupNum
OCTG	ODPI	OCTG T0 INNER JOIN ODPI T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	ODPO	OCTG T0 INNER JOIN ODPO T1 ON T0.GroupNum = T1.GroupNum
OCTG	ODPO	OCTG T0 INNER JOIN ODPO T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	OINV	OCTG T0 INNER JOIN OINV T1 ON T0.GroupNum = T1.GroupNum
OCTG	OINV	OCTG T0 INNER JOIN OINV T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	OPCH	OCTG T0 INNER JOIN OPCH T1 ON T0.GroupNum = T1.GroupNum
OCTG	OPCH	OCTG T0 INNER JOIN OPCH T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	OPDN	OCTG T0 INNER JOIN OPDN T1 ON T0.GroupNum = T1.GroupNum
OCTG	OPDN	OCTG T0 INNER JOIN OPDN T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	OPOR	OCTG T0 INNER JOIN OPOR T1 ON T0.GroupNum = T1.GroupNum
OCTG	OPOR	OCTG T0 INNER JOIN OPOR T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	OPQT	OCTG T0 INNER JOIN OPQT T1 ON T0.GroupNum = T1.GroupNum
OCTG	OQUT	OCTG T0 INNER JOIN OQUT T1 ON T0.GroupNum = T1.GroupNum
OCTG	OQUT	OCTG T0 INNER JOIN OQUT T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	ORDR	OCTG T0 INNER JOIN ORDR T1 ON T0.GroupNum = T1.GroupNum
OCTG	ORDR	OCTG T0 INNER JOIN ORDR T1 ON T0."GroupNum" = T1."GroupNum"
OCTG	RDR1	NULL
OCTR	OCPR	OCTR T0 INNER JOIN OCPR T1 ON T0.CntctCode = T1.CntctCode
OCTR	OCPR	OCTR T0 INNER JOIN OCPR T1 ON T0."CntctCode" = T1."CntctCode"
OCTR	OCRD	OCTR T0 INNER JOIN OCRD T1 ON T0.CstmrCode = T1.CardCode
OCTR	OCRD	OCTR T0 INNER JOIN OCRD T1 ON T0."CstmrCode" = T1."CardCode"
OCTR	OCTR	OCTR T0
OCTR	OCTT	OCTR T0 INNER JOIN OCTT T1 ON T0.CntrcTmplt = T1.TmpltName
OCTR	OCTT	OCTR T0 INNER JOIN OCTT T1 ON T0."CntrcTmplt" = T1."TmpltName"
OCTR	OINS	OCTR T0 INNER JOIN CTR1 T2 ON T0.ContractID = T2.ContractID INNER JOIN OINS T1 ON T2.InsID = T1.insID
OCTR	OINS	OCTR T0 INNER JOIN CTR1 T2 ON T0."ContractID" = T2."ContractID" INNER JOIN OINS T1 ON T2."InsID" = T1."insID"
OCTR	OITB	OCTR T0 INNER JOIN CTR1 T2 ON T0.ContractID = T2.ContractID INNER JOIN OITB T1 ON T2.ItemGroup = T1.ItmsGrpCod
OCTR	OITB	OCTR T0 INNER JOIN CTR1 T2 ON T0."ContractID" = T2."ContractID" INNER JOIN OITB T1 ON T2."ItemGroup" = T1."ItmsGrpCod"
OCTR	OITM	OCTR T0 INNER JOIN CTR1 T2 ON T0.ContractID = T2.ContractID INNER JOIN OITM T1 ON T2.ItemCode = T1.ItemCode
OCTR	OITM	OCTR T0 INNER JOIN CTR1 T2 ON T0."ContractID" = T2."ContractID" INNER JOIN OITM T1 ON T2."ItemCode" = T1."ItemCode"
OCTR	OSCL	OCTR T0 INNER JOIN OSCL T1 ON T0.ContractID = T1.contractID
OCTR	OSCL	OCTR T0 INNER JOIN OSCL T1 ON T0."ContractID" = T1."contractID"
OCTT	OCTR	OCTT T0 INNER JOIN OCTR T1 ON T0.TmpltName = T1.CntrcTmplt
OCTT	OCTR	OCTT T0 INNER JOIN OCTR T1 ON T0."TmpltName" = T1."CntrcTmplt"
OCTT	OCTT	OCTT T0