dbo.QER_FTPWOOrderPerson
SQL_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:17:27.457 · modified 2026-04-14T23:17:27.457 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@UID_PersonOrdered | varchar | no |
@UID_ITShopOrgPR | varchar | no |
@UID_ACCProduct | varchar | no |
@ValidFrom | datetime | no |
@ValidUntil | datetime | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | QER_FTPWOOrderPerson_000 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_001 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_010 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_011 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_100 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_101 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_110 | OBJECT_OR_COLUMN | |
| dbo | QER_FTPWOOrderPerson_111 | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1create function dbo.QER_FTPWOOrderPerson (@UID_PersonOrdered varchar(38) , @UID_ITShopOrgPR varchar(38) , @UID_ACCProduct varchar(38) , @ValidFrom 2 datetime , @ValidUntil datetime ) returns @erg table (UID_PersonOrdered varchar(38) collate database_default , UID_ITShopOrgPR varchar(38) collate 3 database_default , UID_ITShopOrgBO varchar(38) collate database_default , UID_ITShopOrgSH varchar(38) collate database_default , UID_AccProduct varchar 4(38) collate database_default , IsReusePossible bit , Ident_AccProduct nvarchar(256) collate database_default , Description nvarchar(max) collate database_default 5 , UID_AccproductGroup varchar(38) collate database_default ) as begin if @UID_PersonOrdered is null and @UID_ITShopOrgPR is null and @UID_ACCProduct 6 is null begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct 7 , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible 8, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_000(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom 9, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered is null and @UID_ITShopOrgPR is null and @UID_ACCProduct > ' ' begin insert into @erg 10 (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup 11 ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup 12 from dbo.QER_FTPWOOrderPerson_001(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered 13 is null and @UID_ITShopOrgPR > ' ' and @UID_ACCProduct is null begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH 14 , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO 15 , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_010(@UID_PersonOrdered 16, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered is null and @UID_ITShopOrgPR > ' ' and 17 @UID_ACCProduct > ' ' begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible 18, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct 19, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_011(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct 20,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR is null and @UID_ACCProduct is null begin insert 21 into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , 22 UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct 23 , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_100(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824 24) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR is null and @UID_ACCProduct > ' ' begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR 25 , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered 26 , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_101 27(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR 28 > ' ' and @UID_ACCProduct is null begin insert into @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible 29, Ident_AccProduct , Description , UID_AccproductGroup ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct 30, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup from dbo.QER_FTPWOOrderPerson_110(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct 31,@ValidFrom, @ValidUntil, 1073741824) goto endLabel end if @UID_PersonOrdered > ' ' and @UID_ITShopOrgPR > ' ' and @UID_ACCProduct > ' ' begin insert into 32 @erg (UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup 33 ) select UID_PersonOrdered , UID_ITShopOrgPR , UID_ITShopOrgBO , UID_ITShopOrgSH , UID_AccProduct, IsReusePossible, Ident_AccProduct , Description , UID_AccproductGroup 34 from dbo.QER_FTPWOOrderPerson_111(@UID_PersonOrdered, @UID_ITShopOrgPR, @UID_ACCProduct,@ValidFrom, @ValidUntil, 1073741824) end endlabel: return end 35 36
Module relation graph
Loading module relation graph…
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:17:27.457
None extracted.
Summary: writes INSERT into; reads/joins QER_FTPWOOrderPerson_000, QER_FTPWOOrderPerson_001, QER_FTPWOOrderPerson_010, QER_FTPWOOrderPerson_011, QER_FTPWOOrderPerson_100…
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@UID_PersonOrdered | varchar(38) | input |
@UID_ITShopOrgPR | varchar(38) | input |
@UID_ACCProduct | varchar(38) | input |
@ValidFrom | datetime | input |
@ValidUntil | datetime | input |
DML targets
INSERT intoCalled routines
None extracted.
Read/join references
SQL dependency metadata
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @UID_PersonOrdered @UID_ITShopOrgPR @UID_ACCProduct @ValidFrom @ValidUntil @erg
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
No reverse dependencies extracted.