IIS UZERİNDEN LOGO OBJECTSTE YETKİLENDİRME HATASI VARSA

On By semt20In LOGO ERP, LOGO OBJECTSLeave a comment

HATA:Retrieving the COM class factory for component with CLSID {72DB412A-6BF5-4920-A002-2AAC679951DF} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

ÇÖZÜM:WEB.CONFIGE SYSTEM.WEB IN ALTI aşağısı gibi olur ve iis stop start yapılır

  <system.web>
    <compilation targetFramework="4.7.2" />
    <httpRuntime targetFramework="4.7.2" />
    <identity impersonate="true" userName="domain\username" password="password"/>
  </system.web>

LOGO OBJECT DESIGNER – LOD NOTLAR

On By semt20In LOD, LOGO ERP, LOGO OBJECTSLeave a comment

İlk çalışmada project-options-team membersi aşağıdaki şekilde yap şifre sorarsa logo

tasarımda yavaş hareket et yoksa arka planda başka objectler oluşturmakta

lod combobox bilgilerini burda tutar (20 COMBOBOXDUR) içeriği kodlanmıştır : select * from L_CDBTMP WHERE INFOTYPE=20

lodda tablo yaratıldığında sistemden firmalardan ilgili firmaya sağ tıklayıp uyarlama tablolarını sil ve oluştur yapılmalıdır

lod tasarımlarını logoda görebilmek için rol tanımlanıp rol üzerinden lod çalışmaları eklenip istenilen kullanıcıya o rol tanımlanmalıdır

lodda yapılan tabloları databasede LG_XT olarak yaratılır

LOD EXTENDED FORM ÇAĞIRMA

Sub ButtonClick(ctrl as String)
        if ctrl="LButton1" then
'Malzeme Kartındaki Ürünün Logicalrefini alır
       ' AppTables[1].GetIntFieldR(RecHandle,"LOGICALREF",intLref)
       ' warn(intLref)
'Custom Formu Açar        
        CreateQForm("CUSTENTR2", 1,3, 1, CstForm)
        CstForm.ShowForm(1)
        end if
End Sub

Sub FormShow()
        'TableName=Application.GetTableName(",Application.CompanyId,Application.FiscPerdId)
        mgrid="LGridList1"
        SqlTxt="select DISTINCT TARIH,SONSATINALMAFIYATI,INDIRIMLIFIYAT,KDVDAHILMALIYET,NMALIYET,PROMOSYONMALIYETI,SATISFIYATI from BM_XT001_120"
        CreateQuery(qry)
        qry.SetSqlText(SqlTxt)
        qry.ExecuteDirect()
        i=0
         _breakpoint
        if qry.Ready=1 then
         res=qry.First()
         do while res=1
         ' GetFieldValue(fieldOrder as Integer, valTyp as Integer, value as Variant)
         'Order of the field in the select statement valType(in) Type of the field 1 for INTEGER 2 for DATE (Logo format) 3 for FLOAT 4 for
         'TEXT value(out) Value of the field Example Qry.GetFieldValue(1, 1, logRef)
          qry.GetFieldValue(1,2,TARIH)
          qry.GetFieldValue(2,3,SONSATINALMAFIYATI)
          qry.GetFieldValue(3,3,INDIRIMLIFIYAT)
          qry.GetFieldValue(4,3,KDVDAHILMALIYET)
          qry.GetFieldValue(5,3,NMALIYET)
          qry.GetFieldValue(6,3,PROMOSYONMALIYETI)
          qry.GetFieldValue(7,3,SATISFIYATI)
          SetMGridRow(mgrid,i)
          InsertGridRow(mgrid,1)
          SetCellInt(mgrid,i,10000,TARIH)
          SetCellFloat(mgrid,i,10001,SONSATINALMAFIYATI)
          SetCellFloat(mgrid,i,10002,INDIRIMLIFIYAT)
          SetCellFloat(mgrid,i,10003,KDVDAHILMALIYET)
          SetCellFloat(mgrid,i,10004,NMALIYET)
          SetCellFloat(mgrid,i,10006,PROMOSYONMALIYETI)
          SetCellFloat(mgrid,i,10007,SATISFIYATI)
          InvalidateGrid(mgrid)
          RefreshControl(mgrid,1)
          i=i+1
          res=qry.next() 
         loop

        end if 
End Sub

'Sağ tuş tetikleme işlemini DoPopupAction method unu kullanarak gerçekleştirebilirsiniz. 
'Aşağıdaki şekilde kullanımı mevcuttur 1. parametresi PopupMenu ismi 2. parametre seçeneğin index bilgisi.
DoPopupAction("StBrwPopupMenu", 14)

Sub FormShow()
        MNAddItem("OrdBrwPopup","-",-10001)
        MNAddItem("OrdBrwPopup","FlashTech Gönder",1001) 
        MNAddItem("OrdBrwPopup","FlashTech Sipariş İptal Et",1002)
        MNAddItem("OrdBrwPopup","-",-1003)
        MNAddItem("OrdBrwPopup","Dolum Fişi Yazdır",1003)
        MNAddItem("OrdBrwPopup","-",-1004)
        MNAddItem("OrdBrwPopup","Mühür Girişi",1004)
End Sub

Sub PopupMenuClick(ctrl as String, index as Integer, result as Integer)
        if ctrl="OrdBrwPopup" and index=1001 then
        warn("FlashTech Gönder")
        end if
End Sub

‘ Gridde ilgili rowun recidsini alma

DBGGetRecAdr(“OrdFicheDataGrid”,ITR)

'GRIDDEN ILGILI ROWUN LOGICALREFINE GORE TABLOSUNDA BILGI CEKME
Sub FormShow()
        MNAddItem("OrdBrwPopup","-",-10001)
        MNAddItem("OrdBrwPopup","FlashTech Gönder",1001) 
        MNAddItem("OrdBrwPopup","FlashTech Sipariş İptal Et",1002)
        MNAddItem("OrdBrwPopup","-",-1003)
        MNAddItem("OrdBrwPopup","Dolum Fişi Yazdır",1003)
        MNAddItem("OrdBrwPopup","-",-1004)
        MNAddItem("OrdBrwPopup","Mühür Girişi",1004)
End Sub

Sub PopupMenuClick(ctrl as String, index as Integer, result as Integer)
        if ctrl="OrdBrwPopup" and index=1001 then
        'ILGILI GRID ROWUN LOGICALREFINI ALIR
        DBGGetRecAdr("OrdFicheDataGrid",ORDFICHEREF)
        AppTables[12].SearchByRef(ORDFICHEREF) '12:ORFICHE
        AppTables[12].GetTxtField("DOCTRACKINGNR", DOCTRACKINGNR)
        warn(DOCTRACKINGNR)  
        end if
End Sub

set popup menu to grid SetPopup(“LGridList1″,”LPopupMenu1”)

lod hariciye firma bilgilerini gönderme;

Lodda logo viewi üzerinden işlem yapma:

MyQryTable = Application.GetViewName(10, Application.CompanyId, Application.FiscPerdId) ‘GNTOTCL

1 : LV_FFF_PP_BNFLINE  

2 : LV_FFF_PP_CLCARD  

3 : LV_FFF_PP_CLEKSTRE  

4 : LV_FFF_PP_CLFLINE  

5 : LV_FFF_PP_CSCARD  

6 : LV_FFF_PP_EMUHTOT  

7 : LV_FFF_PP_EMUHTOTV1  

8 : LV_FFF_PP_EMUHTOTV2  

9 : LV_FFF_PP_EMUHTOTV3  

10 : LV_FFF_PP_GNTOTCL  

11 : LV_FFF_PP_GNTOTST  

12 : LV_FFF_PP_GNTOTVRNT  

13 : LV_FFF_PP_ORFLINE  

14 : LV_FFF_PP_STINVENS  

15 : LV_FFF_PP_STINVTOT  

16 : LV_FFF_PP_STLINE  

17 : LV_FFF_PP_TRDGRP  

18 : LV_FFF_PP_VRNTINVENS  

19 : LV_FFF_PP_VRNTINVTOT  

20 : LV_FFF_CLCARD  

21 : LV_FFF_ITEMS  

22 : LV_FFF_ORDER_ITEMS  

23 : LV_FFF_ORDER_SERVICE  

24 : LV_FFF_SALES_ITEMS  3/3

25 : LV_FFF_SALES_ITEMS_TOTAL  

26 : LV_FFF_SALES_SERVICE  

27 : LV_FFF_SALES_SERVICE_TOTAL

Debug modu(https://docs.logo.com.tr/public/wua/logo-object-designer/lod-kuetuephanesi/lod-quilt):

1 – Object Designer uygulamasında Project Options > Release sekmesine gidin.

2 – Project configuration > Debug seçeneğini işaretleyin.

3 – Debugging info > Save Debugging info seçeneğini işaretleyin.

4 – Unity debug modu için Unity.exe /qd girin.

POWER BI KURULUM VE NOTLAR

On By semt20In POWER BILeave a comment

POWER BI DESKTOP MOBIL REPORT BUILDER VB. KISAYOL VE KURULU OLDUGU YERLERDEKI EXELERINI OZELLIKLERDEN ADMIN YETKISI VER

RAPORLARA SQL SERVERDEN VIEW OLUSTUR VIEW UZERINDEN RAPORLARI EKLE

MOBIL RAPOR EKLEMEK ICIN URLDEN DATASET EKLEMELISIN

POWER BI REPORTUN TELDE GORUNMESINI ISDERSEN DATASOURCE EKLERKEN DIRECT YERINE IMPORTU SEC AMA REPORT SERVER CONFIGURATION MANAGERDE USE ANOTHER ACCOUNTI SEC WINDOWS KULLANICI ADINI VE SIFRENI GIR

ORACLE KURULUM

On By semt20In ORACLELeave a comment

DOSYALAR İNDİRİLİR:

https://download.oracle.com/otn/nt/oracle19c/193000/WINDOWS.X64_193000_db_home.zip?AuthParam=1592287426_7fcb3e325f5f76edeb643f1813a545b7

https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-19.4.0.354.1759-x64.zip?AuthParam=1592293102_108c47fe233e3414d0b2167465c167db

ORACLEDA KURULUM İSDER AMA SQLDEVELOPERDA DİREK RARDAN CIKARILIP ÇALIŞTIRILABİLİR.

DATABASEE BAĞLANABİLMEK İÇİN DİKKAT EDİLMESİ GEREKEN ORACLEIN KURULUMUNDA BELİRLEMİŞ OLDUGUN ŞİFREYİ SYSDEN VE SYSDBA ROLDAN GİRMEKTİR:

YENİ DATABASE YARATMAK İÇİN: DATABASE CONFIGURATION ASSISTANT ORACLELA BERABER KURULUR

C++ NATIVE DLL C#DA ÇALIŞTIRMAK İÇİN

On By semt20In C SHARP, visual studioLeave a comment

Önce indir Dependency Walker ve dll içinde aç

c# tarafında bu şekilde tanımla

  public Login() {
            InitializeComponent();
            XAPI_Client_digits();
            // XAPI_Adjunct_start();
            //XAPI_Adjunct_stop();
            //XAPI_Client_answer();
            //XAPI_Client_bdp_answer();
            //XAPI_Client_bdp_intrude();
            //XAPI_Client_bdp_register();
            // XAPI_Client_callb();
            //XAPI_Client_clear();
            //XAPI_Client_conference();
            //XAPI_Client_deflect();
            //XAPI_Client_digits();
            //XAPI_Client_hold();
            //XAPI_Client_mailbox();
            //XAPI_Client_newcall();
            //XAPI_Client_record_start();
            //XAPI_Client_record_stop();
            //XAPI_Client_resume();
            //XAPI_Client_retrieve();
            //XAPI_Client_start();
            //XAPI_Client_start_Thread();
            //XAPI_Client_stop();
            //XAPI_Client_suspend();
            //XAPI_Client_transfer();
            //XAPI_Client_transfer_undo();
            //XAPI_Cmdr_start();
            //XAPI_Cmdr_stop();
            //XAPI_Stack_initialize();
            XAPI_Client_digits();
            string TEST = "";
        }
        [DllImport("XapiDll.dll", CharSet = CharSet.Unicode)]
        //[DllImport("XapiDll.dll", CharSet = CharSet.Unicode,CallingConvention =CallingConvention.Cdecl)]
        public static extern void XAPI_Client_digits();
       // public static extern void XAPI_Adjunct_start();
       // public static extern void XAPI_Adjunct_stop();
        //public static extern void XAPI_Client_answer();
        //public static extern void XAPI_Client_bdp_answer();
        //public static extern void XAPI_Client_bdp_intrude();
       // public static extern void XAPI_Client_bdp_register();
        //public static extern void XAPI_Client_callb();
        //public static extern void XAPI_Client_clear();
        //public static extern void XAPI_Client_conference();
        //public static extern void XAPI_Client_deflect();
        //public static extern void XAPI_Client_digits();
        //public static extern void XAPI_Client_hold();
        //public static extern void XAPI_Client_mailbox();
        //public static extern void XAPI_Client_newcall();
        //public static extern void XAPI_Client_record_start();
        //public static extern void XAPI_Client_record_stop();
        //public static extern void XAPI_Client_resume();
        //public static extern void XAPI_Client_retrieve();
        //public static extern void XAPI_Client_start();
        //public static extern void XAPI_Client_start_Thread();
        //public static extern void XAPI_Client_stop();
        //public static extern void XAPI_Client_suspend();
        //public static extern void XAPI_Client_transfer();
        //public static extern void XAPI_Client_transfer_undo();
        //public static extern void XAPI_Cmdr_start();
        //public static extern void XAPI_Cmdr_stop();
        //public static extern void XAPI_Stack_initialize();
      //  public static extern void XAPI_Stack_release();

C# LOGO OBJECTS REST PROJESİ

On By semt20In TOOLSLeave a comment

C# KISMINDA EĞER HERHANGİ BİR OBJECTIN CLASSI GEREKIRSE ONCE LOGODAN VERI AKTAR DIŞARI YAPILIR VE DOSYANIN İÇİNDEKİLER ÖNCE

http://www.utilities-online.info/xmltojson/ YAPIŞTIRILIP JSONA ÇEVİRİLİR KOPYALANIR VE https://jsonutils.com/ ‘A YAPIŞTIRILIP C# DA CLASS OLUŞTURULUR

EĞER TRANSACTIONLI BİRŞEY VARSA CLASSI DEĞİŞTİRMEK GEREKİR ALTTAKİ ÖRNEKLERDE ÖNCESİ VE SONRASI YANİ OLMASI GEREKENLER(SATIŞSİPARİŞİ İÇİN)

http://localhost:32001/api/v1/services/help?expandLevel=full&api_key=logotigerrestservice

ÖNCESİ

    public class CAMPAIGNINFOS
    {
        public object CAMPAIGN_INFO { get; set; }
    }

    public class TRANSACTION {
        public string TYPE { get; set; }
        public string MASTER_CODE { get; set; }
        public string QUANTITY { get; set; }
        public string PRICE { get; set; }
        public string TOTAL { get; set; }
        public string COST_DISTR { get; set; }
        public string DISCOUNT_DISTR { get; set; }
        public string EXPENSE_DISTR { get; set; }
        public string VAT_RATE { get; set; }
        public string VAT_AMOUNT { get; set; }
        public string VAT_BASE { get; set; }
        public string UNIT_CODE { get; set; }
        public string UNIT_CONV1 { get; set; }
        public string UNIT_CONV2 { get; set; }
        public string VAT_INCLUDED { get; set; }
        public string ORDER_RESERVE { get; set; }
        public string DUE_DATE { get; set; }
        public string CURR_PRICE { get; set; }
        public string PC_PRICE { get; set; }
        public string PAYMENT_CODE { get; set; }
        public string SOURCE_WH { get; set; }
        public string SOURCE_COST_GRP { get; set; }
        public string DIVISION { get; set; }
        public string DEPARTMENT { get; set; }
        public string TOTAL_NET { get; set; }
        public string DATA_REFERENCE { get; set; }
        public string DETAILS { get; set; }
        public CAMPAIGNINFOS CAMPAIGN_INFOS { get; set; }
        public string SALESMAN_CODE { get; set; }
        public string DEFNFLDS { get; set; }
        public string MULTI_ADD_TAX { get; set; }
        public string AFFECT_RISK { get; set; }
        public string EDT_PRICE { get; set; }
        public string EDT_CURR { get; set; }
        public string ORG_DUE_DATE { get; set; }
        public string ORG_QUANTITY { get; set; }
        public string ORG_PRICE { get; set; }
        public string RESERVE_DATE { get; set; }
        public string RESERVE_AMOUNT { get; set; }
        public string PRCLISTCODE { get; set; }
        public string PRCLISTTYPE { get; set; }
        public string PRODUCER_CODE { get; set; }
        public string GUID { get; set; }
        public string DISCOUNT_RATE { get; set; }
        public string DETAIL_LEVEL { get; set; }
        public string CALC_TYPE { get; set; }
    }

    public class TRANSACTIONS{	
								   
										 
			 
	     public IList<TRANSACTION> TRANSACTION { get; set; }										 
    }

    public class PAYMENT {
        public string DATE { get; set; }
        public string MODULENR { get; set; }
        public string TRCODE { get; set; }
        public string TOTAL { get; set; }
        public string DAYS { get; set; }
        public string PROCDATE { get; set; }
        public string DATA_REFERENCE { get; set; }
        public string DISCOUNT_DUEDATE { get; set; }
        public string PAY_NO { get; set; }
        public string DISCTRLIST { get; set; }
        public string DISCTRDELLIST { get; set; }
    }

    public class PAYMENTLIST {
        public PAYMENT PAYMENT { get; set; }
    }

    public class DEFNFLD {
        public string MODULENR { get; set; }
        public string PARENTREF { get; set; }
        public string TEXTFLDS1 { get; set; }
        public string TEXTFLDS3 { get; set; }
        public string XML_ATTRIBUTE { get; set; }
        public string DATA_REFERENCE { get; set; }
    }

    public class DEFNFLDSLIST {
        public DEFNFLD DEFNFLD { get; set; }
    }

															  
															   
																 
														   
		 
    public class ORDERSLIP {
        public string -DBOP { get; set; }
								
												  
																
			 
        public string NUMBER { get; set; }
        public string DATE { get; set; }
        public string TIME { get; set; }
        public string DOC_NUMBER { get; set; }
        public string ARP_CODE { get; set; }
        public string SOURCE_WH { get; set; }
        public string SOURCE_COST_GRP { get; set; }
        public string #text { get; set; }
        public string ADD_DISCOUNTS { get; set; }
        public string TOTAL_DISCOUNTS { get; set; }
        public string TOTAL_DISCOUNTED { get; set; }
        public string ADD_EXPENSES { get; set; }
        public string TOTAL_EXPENSES { get; set; }
        public string TOTAL_VAT { get; set; }
        public string TOTAL_GROSS { get; set; }
        public string TOTAL_NET { get; set; }
        public string PAYMENT_CODE { get; set; }
        public string PAYDEFREF { get; set; }
        public string PRINT_DATE { get; set; }
        public string DIVISION { get; set; }
        public string DEPARTMENT { get; set; }
        public string ORDER_STATUS { get; set; }
        public string CREATED_BY { get; set; }
        public string DATE_CREATED { get; set; }
        public string HOUR_CREATED { get; set; }
        public string MIN_CREATED { get; set; }
        public string SEC_CREATED { get; set; }
        public string MODIFIED_BY { get; set; }
        public string DATE_MODIFIED { get; set; }
        public string HOUR_MODIFIED { get; set; }
        public string MIN_MODIFIED { get; set; }
        public string SEC_MODIFIED { get; set; }
        public string SALESMAN_CODE { get; set; }
        public string CURRSEL_TOTAL { get; set; }
        public string TRADING_GRP { get; set; }
        public string DATA_REFERENCE { get; set; }
        public TRANSACTIONS TRANSACTIONS { get; set; }
        public string WITH_PAYMENT { get; set; }
        public PAYMENTLIST PAYMENT_LIST { get; set; }
        public DEFNFLDSLIST DEFNFLDSLIST { get; set; }
        public string UPD_CURR { get; set; }
        public string UPD_TRCURR { get; set; }
        public string AFFECT_RISK { get; set; }
        public string GUID { get; set; }
    }

    public class SALESORDERS {
        public ORDERSLIP ORDER_SLIP { get; set; }
    }

    public class MAIN {
        public SALESORDERS SALES_ORDERS { get; set; }
    }

SONRASI

   public class CAMPAIGNINFOS {
	 
            public object CAMPAIGN_INFO { get; set; }
        }

        public class Item {
            public string TYPE { get; set; }
            public string MASTER_CODE { get; set; }
            public string QUANTITY { get; set; }
            public string PRICE { get; set; }
            public string TOTAL { get; set; }
            public string COST_DISTR { get; set; }
            public string DISCOUNT_DISTR { get; set; }
            public string EXPENSE_DISTR { get; set; }
            public string VAT_RATE { get; set; }
            public string VAT_AMOUNT { get; set; }
            public string VAT_BASE { get; set; }
            public string UNIT_CODE { get; set; }
            public string UNIT_CONV1 { get; set; }
            public string UNIT_CONV2 { get; set; }
            public string VAT_INCLUDED { get; set; }
            public string ORDER_RESERVE { get; set; }
            public string DUE_DATE { get; set; }
            public string CURR_PRICE { get; set; }
            public string PC_PRICE { get; set; }
            public string PAYMENT_CODE { get; set; }
            public string SOURCE_WH { get; set; }
            public string SOURCE_COST_GRP { get; set; }
            public string DIVISION { get; set; }
            public string DEPARTMENT { get; set; }
            public string TOTAL_NET { get; set; }
            public string DATA_REFERENCE { get; set; }
            public string DETAILS { get; set; }
            public CAMPAIGNINFOS CAMPAIGN_INFOS { get; set; }
            public string SALESMAN_CODE { get; set; }
            public string DEFNFLDS { get; set; }
            public string MULTI_ADD_TAX { get; set; }
            public string AFFECT_RISK { get; set; }
            public string EDT_PRICE { get; set; }
            public string EDT_CURR { get; set; }
            public string ORG_DUE_DATE { get; set; }
            public string ORG_QUANTITY { get; set; }
            public string ORG_PRICE { get; set; }
            public string RESERVE_DATE { get; set; }
            public string RESERVE_AMOUNT { get; set; }
            public string PRCLISTCODE { get; set; }
            public string PRCLISTTYPE { get; set; }
            public string PRODUCER_CODE { get; set; }
            public string GUID { get; set; }
            public string DISCOUNT_RATE { get; set; }
            public string DETAIL_LEVEL { get; set; }
            public string CALC_TYPE { get; set; }
        }

        public class TRANSACTIONS{
            public TRANSACTIONS() {
                items = new List<Item>();
            }
            public IList<Item> items { get; set; }
        }

        public class PAYMENT {
            public string DATE { get; set; }
            public string MODULENR { get; set; }
            public string TRCODE { get; set; }
            public string TOTAL { get; set; }
            public string DAYS { get; set; }
            public string PROCDATE { get; set; }
            public string DATA_REFERENCE { get; set; }
            public string DISCOUNT_DUEDATE { get; set; }
            public string PAY_NO { get; set; }
            public string DISCTRLIST { get; set; }
            public string DISCTRDELLIST { get; set; }
        }

        public class PAYMENTLIST {
            public PAYMENT PAYMENT { get; set; }
        }

        public class DEFNFLD {
            public string MODULENR { get; set; }
            public string PARENTREF { get; set; }
            public string TEXTFLDS1 { get; set; }
            public string TEXTFLDS3 { get; set; }
            public string XML_ATTRIBUTE { get; set; }
            public string DATA_REFERENCE { get; set; }
        }

        public class DEFNFLDSLIST {
            public DEFNFLD DEFNFLD { get; set; }
        }
        public class DataObjectParameter {
            //public bool ApplyCampaignOnPreSave { get; set; }
            //public bool ApplyConditionOnPreSave { get; set; }
            //public bool FormSeriLotLinesOnPreSave { get; set; }
            public bool FillAccCodesOnPreSave { get; set; }
        }
        public class ORDERSLIP {
            public DataObjectParameter DataObjectParameter { get; set; }
            public ORDERSLIP() {
                TRANSACTIONS = new TRANSACTIONS();
                DataObjectParameter = new DataObjectParameter();
            }
            public string NUMBER { get; set; }
            public string DATE { get; set; }
            public string TIME { get; set; }
            public string DOC_NUMBER { get; set; }
            public string ARP_CODE { get; set; }
            public string SOURCE_WH { get; set; }
            public string SOURCE_COST_GRP { get; set; }
										 
            public string ADD_DISCOUNTS { get; set; }
            public string TOTAL_DISCOUNTS { get; set; }
            public string TOTAL_DISCOUNTED { get; set; }
            public string ADD_EXPENSES { get; set; }
            public string TOTAL_EXPENSES { get; set; }
            public string TOTAL_VAT { get; set; }
            public string TOTAL_GROSS { get; set; }
            public string TOTAL_NET { get; set; }
            public string PAYMENT_CODE { get; set; }
            public string PAYDEFREF { get; set; }
            public string PRINT_DATE { get; set; }
            public string DIVISION { get; set; }
            public string DEPARTMENT { get; set; }
            public string ORDER_STATUS { get; set; }
            public string CREATED_BY { get; set; }
            public string DATE_CREATED { get; set; }
            public string HOUR_CREATED { get; set; }
            public string MIN_CREATED { get; set; }
            public string SEC_CREATED { get; set; }
            public string MODIFIED_BY { get; set; }
            public string DATE_MODIFIED { get; set; }
            public string HOUR_MODIFIED { get; set; }
            public string MIN_MODIFIED { get; set; }
            public string SEC_MODIFIED { get; set; }
            public string SALESMAN_CODE { get; set; }
            public string CURRSEL_TOTAL { get; set; }
            public string TRADING_GRP { get; set; }
            public string DATA_REFERENCE { get; set; }
            public TRANSACTIONS TRANSACTIONS { get; set; }
            public string WITH_PAYMENT { get; set; }
            public PAYMENTLIST PAYMENT_LIST { get; set; }
            public DEFNFLDSLIST DEFNFLDSLIST { get; set; }
            public string UPD_CURR { get; set; }
            public string UPD_TRCURR { get; set; }
            public string AFFECT_RISK { get; set; }
            public string GUID { get; set; }
        }

        public class SALESORDERS {
            public ORDERSLIP ORDER_SLIP { get; set; }
        }

        public class MAIN {
            public SALESORDERS SALES_ORDERS { get; set; }
        }
    }