USP_DATAFORMTEMPLATE_VIEW_SUBSIDIARYLEDGERTREASURYACCOUNTS
The load procedure used by the view dataform template "Subsidiary Ledger Treasury Accounts View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @TREASURYID | uniqueidentifier | INOUT | Treasury ID |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SUBSIDIARYLEDGERTREASURYACCOUNTS
(
@DATALOADED bit = 0 output,
--@PAYABLESID uniqueidentifier = null output,
@TREASURYID uniqueidentifier = null output
)
as
set nocount on;
set @DATALOADED = 1;
--select @PAYABLESID = ID from dbo.FINANCIALSYSTEM where NAME = 'Payables';
select @TREASURYID = ID from dbo.FINANCIALSYSTEM where NAME = 'Treasury';
return 0;