DEFINITIONS

Definitions More Info.
Definition ID893
TitleSQL_WORK
CategoryNOTES
DefinitionGR e-ticaret faturalari
Definition Description-- OrganizationID
75349 : 'RAMSEY E-TİCARET MAĞAZA'
75348 : KİP E-TİCARET MAĞAZA'

-- '2018-09-04' tarihinden itibaren Erp'ye gelmiyor.

SELECT * FROM "ERP"."InventoryTransactionDetail" where "OrganizationID" in (75349,75348) AND "InventoryTransactionTypeID"=117 AND "Date">='2018-09-04'
SELECT * FROM "ERP"."InventoryTransaction" where "DocumentNo"='49919900'

-- NEBİMDE ERPdeki DocumentNo Series Number alanında yazıyor.

select * from trInvoiceHeader where SeriesNumber='49919900'

RecordBycunay
Record Date04-10-2018 10:43:39
Düzenle
Kopyala
Sil