USP_DATAFORMTEMPLATE_PRELOAD_ADD_APPOSTTOGLPROCESS
The load procedure used by the edit dataform template "AP Post to GL Process Add Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@INVOICERECORDTYPEID | uniqueidentifier | INOUT | |
@DISBURSEMENTRECORDTYPEID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_APPOSTTOGLPROCESS
@INVOICERECORDTYPEID uniqueidentifier = null output,
@DISBURSEMENTRECORDTYPEID uniqueidentifier = null output
as
set nocount on;
select @INVOICERECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'FINANCIAL TRANSACTION';
select @DISBURSEMENTRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'DISBURSEMENT';
return 0;