Try This Example:
USE [TEST_01_05_2020]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[SP_OUTBOUNDDELIVERYNOTE]
@MAWB = N'0700000064',
@EXTERNORDERKEY = N'0700000064',
@EXTERNLINENO = N'900001',
@BILLTOKEY = N'''''',
@DELIVERYDATE = N'20191205',
@CONSIGNEEKEY = N'0000005691',
@C_COMPANY = N'Samsonite Philippines (DS)',
@C_ADDRESS1 = N'2/F ENZO Building, 399 Sen. Gi',
@C_ADDRESS2 = N'''''',
@C_ZIP = N'1200',
@C_CITY = N'Makati',
@REFERENCENUM = N'''''',
@ODREFERENCENUM = N'4500581905',
@EXTERNALORDERKEY2 = N'4500581905',
@SKU = N'000000000000033824',
@ALTSKU = N'1041',
@LOTTABLE01 = N'1INU',
@CONVERTEDQTY = 10.00,
@UNITPRICE = 72.03,
@SUSR1 = N'PHP',
@OSUSR1 = N'''''',
@SCHEDULEDDELVDATE = N'20191210',
@ORDERSID = N'''''',
@TRADINGPARTNER = N'''''',
@PACKNOTES = N'''''',
@HUNDREDWEIGHT = 27.330,
@PRODUCT_WEIGHT = 22.670,
@PRODUCT_CUBE = 511.290,
@OSUSR2 = N'CDM',
@RETAILSKU = N'''''',
@NOTES = N'''''',
@CREATEDON = N'20191210',
@TYPE = N'SAL',
@NOTES2 = N'''''',
@OSUSR4 = N'5690',
@OSUSR5 = N'0001'
SELECT 'Return Value' = @return_value
GO
No comments:
Post a Comment