USP_DATAFORMTEMPLATE_VIEW_STOCKSALEGLDISTRIBUTIONS

The load procedure used by the view dataform template "Stock Sale GL Distributions View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@GLDISTRIBUTION	xml	INOUT	GL distribution

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STOCKSALEGLDISTRIBUTIONS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @GLDISTRIBUTION xml = null output
                )
                as
                begin
                    set nocount on

                    select  @DATALOADED = 1,
                            @GLDISTRIBUTION = dbo.UFN_REVENUE_GETSTOCKSALEGLDISTRIBUTION_TOITEMLISTXML(ID)
                    from dbo.STOCKSALE
                    where ID = @ID

                    set @GLDISTRIBUTION = (
                        select
                            T.c.value('(ACCOUNT)[1]','nvarchar(100)') AS 'ACCOUNT',
                            T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
                            T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
                            T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID',
                            T.c.value('(DEBITCREDIT)[1]','nvarchar(6)') AS 'DEBITCREDIT',
                            T.c.value('(GLPAYMENTMETHODREVENUETYPEMAPPINGID)[1]','uniqueidentifier') AS 'GLPAYMENTMETHODREVENUETYPEMAPPINGID',
                            T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                            T.c.value('(MAPPINGTYPE)[1]','nvarchar(100)') AS 'MAPPINGTYPE',
                            T.c.value('(ORGANIZATIONAMOUNT)[1]','money') AS 'ORGANIZATIONAMOUNT',
                            T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
                            T.c.value('(PROJECT)[1]','nvarchar(100)') AS 'PROJECT',
                            T.c.value('(REFERENCE)[1]','nvarchar(255)') AS 'REFERENCE',
                            T.c.value('(STOCKSALEID)[1]','uniqueidentifier') AS 'STOCKSALEID',
                            T.c.value('(TRANSACTIONAMOUNT)[1]','money') AS 'TRANSACTIONAMOUNT',
                            T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
                            T.c.value('(TRANSACTIONTYPECODE)[1]','tinyint') AS 'TRANSACTIONTYPECODE',
                            T.c.value('(AMOUNT)[1]','money') AS 'BASEAMOUNT',
                            dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() 'ORGANIZATIONCURRENCYID'
                        from @GLDISTRIBUTION.nodes('/GLDISTRIBUTION/ITEM') T(c)
                        for xml raw('ITEM'),type,elements,root('GLDISTRIBUTION'),BINARY BASE64
                    )

                    return 0
                end