dbo.QER_FTPWOOrderPerson_110
SQL_INLINE_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:17:27.417 · modified 2026-04-14T23:17:27.417 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@UID_PersonOrdered | varchar | no |
@UID_ITShopOrgPR | varchar | no |
@dummyUID_ACCProduct | varchar | no |
@ValidFrom | datetime | no |
@ValidUntil | datetime | no |
@CountRecords | int | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| AccProduct | OBJECT_OR_COLUMN | ||
| BaseTree | OBJECT_OR_COLUMN | ||
| BaseTreeAssign | OBJECT_OR_COLUMN | ||
| BaseTreeHasObject | OBJECT_OR_COLUMN | ||
| DialogTable | OBJECT_OR_COLUMN | ||
| PersonInBaseTree | OBJECT_OR_COLUMN | ||
| QERAssign | OBJECT_OR_COLUMN | ||
| dbo | QBM_FCVStringToInt | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN | |
| dbo | QER_FGIPwoValidDateRangesExist | OBJECT_OR_COLUMN |
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.417
None extracted.
Summary: reads/joins BaseTree, PersonInBaseTree, AccProduct, BaseTreeAssign, DialogTable…; uses config QER\ITShop\GapBehavior\GapFitting
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@UID_PersonOrdered | varchar(38) | input |
@UID_ITShopOrgPR | varchar(38) | input |
@dummyUID_ACCProduct | varchar(38) | input |
@ValidFrom | datetime | input |
@ValidUntil | datetime | input |
@CountRecords | int | input |
DML targets
None extracted.Called routines
None extracted.
Read/join references
SQL dependency metadata
Config/session
Config: QER\ITShop\GapBehavior\GapFitting
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @UID_PersonOrdered @UID_ITShopOrgPR @dummyUID_ACCProduct @ValidFrom @ValidUntil @CountRecords
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.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QER_FGIPWOOrderPerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_FGIPWOOrderPerson | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FTPWOOrderPerson | source text reference | SQL_TABLE_VALUED_FUNCTION |