Efatura UBL 2.1 GEÇİŞİ

7,04 için bunu çaly?tyrmalysynyz. 8 üstü için dbupdate,

ALTER TABLE TBLEFATPRM ADD EFATTEVKOD TDBINTEGER NULL

GO

ALTER TABLE TBLEFATPRM ADD UBLVERSION TDBBYTE DEFAULT 0

GO

DROP VIEW EFATPRM

GO

CREATE VIEW EFATPRM AS
SELECT TBLEFATPRM.* FROM TBLEFATPRM WITH(NOLOCK)
INNER JOIN TBLSUBELER WITH (NOLOCK) ON TBLEFATPRM.SUBE_KODU=TBLSUBELER.SUBE_KODU
INNER JOIN NETCONTEXT WITH (NOLOCK) ON
     NETCONTEXT.V$SUBE_KODU= TBLEFATPRM.SUBE_KODU OR
     NETCONTEXT.V$HOLDINGMI=1 OR
     (NETCONTEXT.V$MERKEZMI=1 AND NETCONTEXT.V$ISLETME_KODU=TBLSUBELER.ISLETME_KODU)

GO
     
CREATE TABLE TBLEFATOZELKOD
(        
       CONSTRAINT TBLEFATOZELKOD_PKEY PRIMARY KEY(KOD),
       TIP TDBBYTE NOT NULL,
       KOD INT NOT NULL,
       ACIKLAMA VARCHAR(150) NULL,
       IYEDEK1 INT NULL,
       SYEDEK1 VARCHAR(50) NULL
)

GO

CREATE VIEW EFATOZELKOD AS SELECT * FROM TBLEFATOZELKOD

GO

CREATE VIEW EFATOZELKODEKR
               (TIPACK,KOD,ACIKLAMA,TIP)
               AS SELECT
                               CASE WHEN TBLEFATOZELKOD.TIP=1 THEN 'Özel Matrah'
                                    WHEN TBLEFATOZELKOD.TIP=2 THEN 'Ystisna Kodlary'
                                    WHEN TBLEFATOZELKOD.TIP=3 THEN 'Kysmi Ystisna Kodlary'
                                    WHEN TBLEFATOZELKOD.TIP=4 THEN 'Tevkifat Kodlary'
                                             ELSE ''
                               END,
               TBLEFATOZELKOD.KOD,
               TBLEFATOZELKOD.ACIKLAMA,
               TBLEFATOZELKOD.TIP
               FROM TBLEFATOZELKOD
                    
GO



ALTER TABLE TBLEFATMASTAX ADD TAXEXEMPTIONREASONCODE INT
GO
ALTER TABLE TBLEFATKALEMTAX ADD TAXEXEMPTIONREASONCODE INT
GO
ALTER TABLE TBLEFATMAS ADD TAXEXEMPTIONREASON VARCHAR(500) NULL
GO
ALTER TABLE TBLEFATKALEM ADD TAXEXEMPTIONREASON VARCHAR(500) NULL
GO
ALTER TABLE TBLEFATMAS ADD TAXEXEMPTIONREASONCODE INT
GO
ALTER TABLE TBLEFATKALEM ADD TAXEXEMPTIONREASONCODE INT
GO


INSERT INTO NETSIS..PROGRAM(MODUL_NO,PROGRAM_NO,PROGRAM_AD) VALUES(1,107,5477)          

          

DLL leri güncellediniz mi?

EFATURA.DLL,
Güncellediniz peki registry ettiniz mi?