Project

General

Profile

Download (4.27 KB)

Feature #3777 » PFILOGENBOMMATCONVERT_20250909.sql

Tri Rizqiaty, 09/09/2025 02:02 PM

 
1 
??USE [MinovaES_Tulisan_Dev]
2
3 
GO
4
5 
/****** Object:  StoredProcedure [dbo].[PFILOGENBOMMATCONVERT]    Script Date: 09/09/2025 13.55.13 ******/
6
7 
SET ANSI_NULLS ON
8
9 
GO
10
11 
SET QUOTED_IDENTIFIER ON
12
13 
GO
14
15 
ALTER PROCEDURE [dbo].[PFILOGENBOMMATCONVERT]
16
17 
(
18
19 
	@MaterialID VARCHAR(10)
20
21 
	,@Quantity DECIMAL(18,2)
22
23 
)
24
25 
AS
26
27
28
29 
--DECLARE @MaterialID VARCHAR(10) = '00000050'
30
31 
--DECLARE @Quantity DECIMAL(18,2) = 2.5
32
33
34
35 
SELECT '' AS [DocNo]
36
37 
      ,'' AS [DocItemID]
38
39 
      ,'' AS [DocItemRef]
40
41 
      ,MaterialItemID AS [MaterialID]
42
43 
      ,'' AS [ItemNumber]
44
45 
      ,'0' AS [ItemType]
46
47 
      ,'ISSU' AS [ItemFlow]
48
49 
      ,[Quantity] * @Quantity AS Quantity
50
51 
      ,CONVERT(VARCHAR(8), mat1.[UnitMeasurement]) AS [UnitMeasurement]
52
53 
      ,'' AS [CustSoRef]
54
55 
      ,'' AS [CustSoItemRef]
56
57 
      ,'' AS [PORef]
58
59 
      ,'' AS [POItemRef]
60
61 
      ,'' AS [DeliveryRef]
62
63 
      ,'' AS [DeliveryItemRef]
64
65 
      ,'' AS [QualityInspectionResult]
66
67 
      ,'' AS [QualityAssuranceResult]
68
69 
      ,'' AS [Storage]
70
71 
      ,'' AS [Bin]
72
73 
      ,'' AS [Startdate]
74
75 
      ,'' AS [EndDate]
76
77 
      ,'0' AS [Valuation]
78
79 
      ,'' AS [RefDocTr]
80
81 
      ,'' AS [RefDocTy]
82
83 
      ,'' AS [RefDocID]
84
85 
      ,'' AS [CreateBy]
86
87 
      ,'' AS [CreateDate]
88
89 
      ,'' AS [ChangeBy]
90
91 
      ,'' AS [ChangeDate]
92
93 
      ,'' AS [Warehouse]
94
95 
      ,mat1.MaterialType AS [MaterialType]
96
97 
      --,CONVERT(VARCHAR(22),mat1.[MAP] * @Quantity) AS MAP
98
99 
	  ,CONVERT(VARCHAR(22),mat1.[MAP]) AS MAP
100
101 
      ,'0' AS [NetPrice]
102
103 
      ,'' AS [NoLot]
104
105 
      ,'' AS [UnitConversion]
106
107 
      ,0 AS [QuantityDua]
108
109 
      ,mat1.Description AS [MaterialDesc]
110
111 
      ,CONVERT(VARCHAR(30),mat1.MAP) AS[UnitPrice]
112
113 
      ,0 AS [QtyReal]
114
115 
      ,0 AS [QtyAdjust]
116
117 
      ,'' AS [StockStatus]
118
119 
      ,'' AS [Notes]
120
121 
      ,0 AS [DiscountDefect]
122
123 
      ,0 AS [PriceAmount]
124
125 
      ,0 AS [Discount]
126
127 
      ,0 AS [DiscountPercentage]
128
129 
      ,'' AS [Currency]
130
131 
      ,0 AS [TotAmount]
132
133 
      ,0 AS [Tax]
134
135 
      ,0 AS [NetTax]
136
137 
      ,0 AS [NetAmount]
138
139 
      ,0 AS [BiayaJasa]
140
141 
      ,0 AS [TaxPPh23]
142
143 
      ,mat1.ProductGroup AS [ProductGroup]
144
145 
FROM PMDMAT0006 AS mat6
146
147 
LEFT JOIN PMDMAT0001 AS mat1
148
149 
	ON mat1.MaterialID = mat6.MaterialItemID
150
151 
WHERE  mat6.MaterialID = @MaterialID
(5-5/5)