HLSConnector-Aufträge
Aus Marburger Medien
| Zeile 44: | Zeile 44: | ||
:: where ap.DocEntry=k.DocEntry) = (select count(*) | :: where ap.DocEntry=k.DocEntry) = (select count(*) | ||
:: from rdr1 where LineStatus='O')) OR k.PartSupply='Y') | :: from rdr1 where LineStatus='O')) OR k.PartSupply='Y') | ||
| + | |||
| + | == dbo.@BOB_SBO2HLS_AuftragPositionen == | ||
| + | *Folgende Tabellen werden verwendet: | ||
| + | ** RDR1 (p) | ||
| + | ** ORDR (k) | ||
| + | * Folgende Datenfelder werden übertragen: | ||
| + | ** p.DocEntry | ||
| + | ** '17' + isnull(k.U_DU_PROFIT, '01') AS DocType, | ||
| + | ** p.VisOrder + 1 AS VisOrder, | ||
| + | ** p.ItemCode, | ||
| + | ** CAST(p.OpenQty AS int) AS Quantity, | ||
| + | ** ISNULL(p.FreeTxt, '') AS FreeTxt | ||
| + | * '''wenn folgende Bedingung erfüllt ist:''' | ||
| + | :(p.DocEntry = k.DocEntry) AND | ||
| + | :(p.LineStatus = 'O') AND | ||
| + | :(p.WhsCode = '10') AND | ||
| + | EXISTS (SELECT 1 FROM SMM_SBO2HLS_VLagerbestand lg | ||
| + | ::WHERE lg.ItemCode COLLATE SQL_Latin1_General_CP850_CI_AS = p.ItemCode AND | ||
| + | ::lg.Quantity >= CAST(p.Quantity as int)) | ||
| + | :ORDER BY VisOrder | ||
