DEFINITIONS

Definitions More Info.
Definition ID887
TitleSQL_WORK
CategoryNOTES
DefinitionNEbim fatura sorgusu
Definition Description-- Faturalari kalem kalem doker

SELECT OfficeCode AS MAGAZA,CurrAccCode AS MUSTERIKODU,InvoiceNumber AS FATURA, InvoiceDate FATURATARIHI,Price AS TUTAR,Doc_LDiscountVITotal AS INDIRIM,Doc_NetAmount SATISTUTARI ,IsReturn AS IADE
FROM AllInvoices
WHERE OfficeCode IN('KBM','RCAP')
AND InvoiceDate BETWEEN '20180920'AND '20180920'
ORDER BY OfficeCode,InvoiceNumber

-- Fatura karsilastirma. KDV dahil topla satis tutari
RecordBycunay
Record Date24-09-2018 09:17:45
Düzenle
Kopyala
Sil