|
|
| Definitions More Info. | | Definition ID | 919 | | Title | SQL | | Category | NOTES | | Definition | Tabloya aciklama-definition ekleme | | Definition Description | CREATE TABLE dbr.DBA_CompareInvoiceValueForReplication
(
ID int IDENTITY NOT NULL,
InvoiceID BIGINT NULL,
FullName NVARCHAR(100) NULL,
OfficeCode NVARCHAR(20) NULL,
InvoiceNumber NVARCHAR(30) NULL,
CurrAccCode NVARCHAR(40) NULL,
[VatRate%] NUMERIC NULL,
IsReturn INT NULL,
Quantitiy INT NULL,
Price NUMERIC(5,3) NULL,
Doc_LDiscountVITotal NUMERIC,
Doc_NetAmount NUMERIC,
NetAmount NUMERIC,
KDV NUMERIC,
RecordDate DATE
CONSTRAINT DF_NOW DEFAULT (getdate())
)
USE GURMEN
GO
EXEC sys.sp_addextendedproperty
@name=N'TblDescription',
@value=N'Bu tablo Nebim-ERP arasindaki fatura tutarlarini ve miktarkarini karsilastirmak icin olusturulmustur. Veriler SSIS ile ERP tarafindan cekilmektedir.' ,
@level0type=N'SCHEMA',
@level0name=N'dbr',
@level1type=N'TABLE',
@level1name=N'DBA_CompareInvoiceValueForReplication',
@level2type=N'COLUMN',
@level2name=N'TblDescription'
GO | | RecordBy | cunay | | Record Date | 08-03-2019 10:54:18 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|