dbo.AccProduct
Service items
TableType TUsage USERDATARows 20SizeMB 0.096
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AccProduct | varchar(38) | no | Service item | PKUID |
UID_AccProductParamCategory | varchar(38) | yes | Request property | FKUID |
UID_FunctionalArea | varchar(38) | yes | Functional area | FKUID |
UID_PWODecisionMethod | varchar(38) | yes | Approval policy | FKUID |
UID_OrgRuler | varchar(38) | yes | Product owner | FKUID |
UID_ProfitCenter | varchar(38) | yes | Cost center | FKUID |
UID_AccProductGroup | varchar(38) | yes | Service category | FKUID |
Ident_AccProduct | nvarchar(512) | yes | Service item | |
Description | nvarchar(-1) | yes | Description | |
ModeOfCalculation | nvarchar(128) | yes | Calculation info | |
OrderNumber | nvarchar(128) | yes | Request number | |
ArticleCodeForeign | nvarchar(128) | yes | Product code (foreign) | |
ArticleCode | nvarchar(128) | yes | Product code | |
PurchasePrice | float(8) | yes | Purchase price | |
SalesPrice | float(8) | yes | Sales price | |
InternalPrice | float(8) | yes | Internal price | |
Currency | nvarchar(64) | yes | Currency | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
SortOrder | nvarchar(32) | yes | Sort order | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
IsSpecialProduct | bit(1) | yes | Special service item | |
XTouched | nchar(2) | yes | Processing status | |
IsCopyOnShopChange | bit(1) | yes | Retain service item assignment on relocation | |
VATPercent | float(8) | yes | Sales tax (%) | |
JPegPhoto | varbinary(-1) | yes | Picture | |
UID_FirmPartner | varchar(38) | yes | Manufacturer | FKUID |
SalesRentCharge | float(8) | yes | Rental rate (sales) | |
PurchaseRentCharge | float(8) | yes | Rental rate (purchasing) | |
InternalRentCharge | float(8) | yes | Rental rate (internal) | |
ProductURL | nvarchar(-1) | yes | Web page | |
MaxValidDays | int(4) | yes | Validity period (max. # days) | |
Availability | nvarchar(128) | yes | Availability | |
IsInActive | bit(1) | yes | Not available | |
XObjectKey | varchar(138) | no | Object key | |
UID_OrgAttestator | varchar(38) | yes | Attestor | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_QERTermsOfUse | varchar(38) | yes | Terms of use | FKUID |
IsNoCopyParametersPerson | bit(1) | yes | Request parameters must be defined separately per recipient | |
IsApproveRequiresMfa | bit(1) | yes | Approval by multi-factor authentication | |
ApproveReasonType | int(4) | yes | Reason type on approval | limited |
OrderReasonType | int(4) | yes | Reason type on request | limited |
DenyReasonType | int(4) | yes | Reason type on denial | limited |
IsToHideFromITShop | bit(1) | yes | Hide in service catalog |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL2143 | ADSGroup.UID_AccProduct | AccProduct.UID_AccProduct |
| LDP_RFRL1348 | LDAPGroup.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL1059 | AccProduct.UID_AccProductGroup | AccProductGroup.UID_AccProductGroup |
| QER_RFRL1084 | AccProductInAccProduct.UID_AccProductParent | AccProduct.UID_AccProduct |
| QER_RFRL1085 | AccProductInAccProduct.UID_AccProductChild | AccProduct.UID_AccProduct |
| QER_RFRL1284 | AccProductDependencies.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL1285 | HardwareType.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL1299 | AccProduct.UID_FirmPartner | FirmPartner.UID_FirmPartner |
| QER_RFRL1552 | ShoppingCartPatternItem.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL1631 | AccProduct.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| QER_RFRL1633 | AccProduct.UID_FunctionalArea | FunctionalArea.UID_FunctionalArea |
| QER_RFRL1643 | AccProductInBaseTree.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL1644 | AccProductInFunctionalArea.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL1736 | AccProduct.UID_OrgAttestator | BaseTree.UID_Org |
| QER_RFRL1795 | AccProduct.UID_AccProductParamCategory | AccProductParamCategory.UID_AccProductParamCategory |
| QER_RFRL2147 | BaseTree.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2524 | QERResource.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2525 | QERAssign.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2526 | QERReuse.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2527 | QERReuseUS.UID_AccProduct | AccProduct.UID_AccProduct |
| QER_RFRL2574 | AccProduct.UID_QERTermsOfUse | QERTermsOfUse.UID_QERTermsOfUse |
| RMS_RFRL1684 | ESet.UID_AccProduct | AccProduct.UID_AccProduct |
| RPS_RFRL4170 | RPSReport.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL1440 | UNSGroupB.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL2528 | TSBAccountDef.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL5440 | UNSGroupB1.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL6440 | UNSGroupB2.UID_AccProduct | AccProduct.UID_AccProduct |
| TSB_RFRL7440 | UNSGroupB3.UID_AccProduct | AccProduct.UID_AccProduct |
Triggers
ARS_TUAccProduct SQL_TRIGGER
ATT_TUAccProduct SQL_TRIGGER
GEN_T14B0103CF0D6B960B8771E367 SQL_TRIGGER
GEN_T243720095DAD0C876763C589C SQL_TRIGGER
GEN_T3779B9498CB85BB351AB00501 SQL_TRIGGER
GEN_T5939901692735BFFAA92CBFEC SQL_TRIGGER
QER_TUAccProduct SQL_TRIGGER
Referenced by / reverse relations
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.GEN_FT0044E9DC660D8FECCA25B039 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT2D1FA228B84AFBBC14771E3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT3B45AEE64517F17D7C3A20C5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT3EF28497CED27004B689D6F8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT71486EB9289E8C428D0BC8BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT9B840E61FC75310C8C9A83D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTB7B5BDD7AB99634CC7E45559 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE7DB900500A82E082B94D0A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEA1216AC32F7DDFD2F28A5A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTED9A51712E94DE99846FA141 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEOD74410BBDA5C1BE51102F6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEY06423E1553D20332D88F9A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_000 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_001 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_010 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_011 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_100 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_101 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_110 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTPWOOrderPerson_111 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIReasonTypeForACCProduct | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FGIReasonTypeForPWO | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PAfterMigrationTasks | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopOrderMove_bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopProductNodeCreate_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopDecisionMakerFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT08A14AE8F9D981AD09F553B0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT4EA9514908EF8B11861005B5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT5805F157C9E5F6CBA0D24CED | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT68D54919632B8399AA7F7A30 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT9C4D6102BCF4ED8AC1D655D7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTA591CB967B6EB7D1ABA2C46D | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTAEBCA0961E006D5B8C67FB78 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTE429BF64AFEA12BCCFC1AC2C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_FTMethodForPRNode | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TATTUADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T12D9AD495261CE0D4BDE6FB83 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C55DA64CBBD1170C3DF3A929 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1FFF140BA494B3D88D2C4663E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T21F6500A327433F3515292487 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T26BBE346F984496C7403790A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T281A1B36D942EA78BB1D128B8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5939901692735BFFAA92CBFEC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TATTULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUAccProductGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TATTUESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TATTURPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TURPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0304F2F5CD44FEB832B87AA7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0A0A71A674A33C86ABC06165 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA180FDBA5BB26AEF6CFCE1E19 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA28C7C4A4A651142C7F62A174 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA2F9B776C24E1559256351D92 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3638F4197155B3DD48DCC9A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3A80B1F4D49BE2AE83C3388F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA3D6340BD473F1101F857D97C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA691A74019F931301893A60DC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA6AE1CA27A16D5418224C6639 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA6CAAFB1A29425CB711D5AFAD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA796A1644453529766F9C9CCB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA94E9BB699A1A53034BFEC5C6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAADD713F6F96877EA914DF962 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAB3C833748C1FAD6D12F4C6FA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VAE9D76788F567D9F517F1E4D4 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VAccProductNotAssigned | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VITShopOrderForEmployee | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VITShopOrderForEmployee | SQL expression dependency | dbo · UID_AccProduct · OBJECT_OR_COLUMN |
| dbo.QER_VITShopOrderForEmployee | SQL expression dependency | dbo · Ident_AccProduct · OBJECT_OR_COLUMN |
| dbo.QER_VITShopOrderForEmployee | SQL expression dependency | dbo · Description · OBJECT_OR_COLUMN |
| dbo.QER_VITShopOrderForEmployee | SQL expression dependency | dbo · IsInActive · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · UID_AccProduct · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · UID_AccProductGroup · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · Ident_AccProduct · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · Description · OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderPersonBaseNoMulti | SQL expression dependency | dbo · IsInActive · OBJECT_OR_COLUMN |
| dbo.QERITShopOwnerUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSBVUNSGroupOwner | SQL expression dependency | OBJECT_OR_COLUMN |
| ADSGroup | foreign key references table | ADS_RFRL2143: ADSGroup.UID_AccProduct -> AccProduct.UID_AccProduct |
| LDAPGroup | foreign key references table | LDP_RFRL1348: LDAPGroup.UID_AccProduct -> AccProduct.UID_AccProduct |
| AccProductGroup | referenced by foreign key from table | QER_RFRL1059: AccProduct.UID_AccProductGroup -> AccProductGroup.UID_AccProductGroup |
| AccProductInAccProduct | foreign key references table | QER_RFRL1084: AccProductInAccProduct.UID_AccProductParent -> AccProduct.UID_AccProduct |
| AccProductInAccProduct | foreign key references table | QER_RFRL1085: AccProductInAccProduct.UID_AccProductChild -> AccProduct.UID_AccProduct |
| AccProductDependencies | foreign key references table | QER_RFRL1284: AccProductDependencies.UID_AccProduct -> AccProduct.UID_AccProduct |
| HardwareType | foreign key references table | QER_RFRL1285: HardwareType.UID_AccProduct -> AccProduct.UID_AccProduct |
| FirmPartner | referenced by foreign key from table | QER_RFRL1299: AccProduct.UID_FirmPartner -> FirmPartner.UID_FirmPartner |
| ShoppingCartPatternItem | foreign key references table | QER_RFRL1552: ShoppingCartPatternItem.UID_AccProduct -> AccProduct.UID_AccProduct |
| PWODecisionMethod | referenced by foreign key from table | QER_RFRL1631: AccProduct.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| FunctionalArea | referenced by foreign key from table | QER_RFRL1633: AccProduct.UID_FunctionalArea -> FunctionalArea.UID_FunctionalArea |
| AccProductInBaseTree | foreign key references table | QER_RFRL1643: AccProductInBaseTree.UID_AccProduct -> AccProduct.UID_AccProduct |
| AccProductInFunctionalArea | foreign key references table | QER_RFRL1644: AccProductInFunctionalArea.UID_AccProduct -> AccProduct.UID_AccProduct |
| BaseTree | referenced by foreign key from table | QER_RFRL1736: AccProduct.UID_OrgAttestator -> BaseTree.UID_Org |
| AccProductParamCategory | referenced by foreign key from table | QER_RFRL1795: AccProduct.UID_AccProductParamCategory -> AccProductParamCategory.UID_AccProductParamCategory |
| BaseTree | foreign key references table | QER_RFRL2147: BaseTree.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERResource | foreign key references table | QER_RFRL2524: QERResource.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERAssign | foreign key references table | QER_RFRL2525: QERAssign.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERReuse | foreign key references table | QER_RFRL2526: QERReuse.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERReuseUS | foreign key references table | QER_RFRL2527: QERReuseUS.UID_AccProduct -> AccProduct.UID_AccProduct |
| QERTermsOfUse | referenced by foreign key from table | QER_RFRL2574: AccProduct.UID_QERTermsOfUse -> QERTermsOfUse.UID_QERTermsOfUse |
| ESet | foreign key references table | RMS_RFRL1684: ESet.UID_AccProduct -> AccProduct.UID_AccProduct |
| RPSReport | foreign key references table | RPS_RFRL4170: RPSReport.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB | foreign key references table | TSB_RFRL1440: UNSGroupB.UID_AccProduct -> AccProduct.UID_AccProduct |
| TSBAccountDef | foreign key references table | TSB_RFRL2528: TSBAccountDef.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB1 | foreign key references table | TSB_RFRL5440: UNSGroupB1.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB2 | foreign key references table | TSB_RFRL6440: UNSGroupB2.UID_AccProduct -> AccProduct.UID_AccProduct |
| UNSGroupB3 | foreign key references table | TSB_RFRL7440: UNSGroupB3.UID_AccProduct -> AccProduct.UID_AccProduct |
| dbo.QER_FTPWOOrderPerson_000 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_001 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_010 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_011 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_100 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_101 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_110 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FTPWOOrderPerson_111 | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QER_FGIReasonTypeForACCProduct | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QER_FGIReasonTypeForPWO | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PAfterMigrationTasks | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_PITShopOrderMove_bulk | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_PITShopProductNodeCreate_b | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZITShopDecisionMakerFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_FTMethodForPRNode | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.ADS_TATTUADSGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUAdsGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERAssign | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERResource | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERReuse | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERReuseUS | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TATTULDAPGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUAccProductGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERAssign | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERResource | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERReuse | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERReuseUS | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TATTUESet | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUESet | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TATTURPSReport | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TURPSReport | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUTSBAccountDef | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB1 | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB2 | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB3 | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUTSBAccountDef | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB1 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB2 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB3 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-compositionapi-qer-compositionapi-itshop-shoppingcartsubmit.cs | decompiled C# reference | classes ShoppingCartSubmit, _003C_003Ec__DisplayClass15_0, _003C_003Ec__DisplayClass15_1, _003C_003Ec__DisplayClass15_2; methods _003CCheckAsync_003Eb__3, _003CCheckAsync_003Eb__0, _003CCheckAsync_003Eb__2, _003CCheckAsync_003Eb__4, MoveNext, SetStateMachine; references AccProduct, Person, PersonWantsOrg, ShoppingCartItem, ShoppingCartOrder; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-server-plugin-qer-compositionapi-itshop-requestunsubscribeapi.cs | decompiled C# reference | classes RequestUnsubscribeApi; methods Build; references AccProduct, ITShopOrg, Person, PersonWantsOrg, ShoppingCartItem, ShoppingCartOrder; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-compositionapi-server-plugin-qer-compositionapi-itshop-workflowapi.cs | decompiled C# reference | classes WorkflowApi, _003C_003Ec__DisplayClass1_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, _003CBuild_003Eb__2, _003CBuild_003Eb__3, _003CBuild_003Eb__4; references AccProduct, Delegation, ESet, Person, PersonWantsOrg; markers reads entity values, saves entities, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-itshophelperasync.cs | decompiled C# reference | classes ITShopHelperAsync, _003C_003Ec__DisplayClass14_0, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods _003C_CheckIsGroupAccount_003Eb__0, _003CHandlePersonHasAccountDef_003Eb__0, _003CGetValidAccountDef_003Eb__0, MoveNext, SetStateMachine, CreateAccountITShopOrder; references AccProduct, BasetreeAssign, BaseTreeHasObject, Delegation, DialogTable, ITShopOrg; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-itshopproductcustomizer.cs | decompiled C# reference | classes ITShopProductCustomizer, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods MoveNext, SetStateMachine, _003C_Check_UidAccProduct_003Eb__0, _003C_Check_UidAccProduct_003Eb__1, _003CGetRelationTo_003Eb__1, HasReadonlyMemberships; references AccProduct, ITShopOrg, ITShopSrc, Person, PersonWantsOrg, QERAccProductUsage; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-forms-qer-forms-formitshopdecideorder.cs | decompiled C# reference | classes FormITShopDecideOrder; methods OnInit, Proxy_NodeDoubleClick, OnDesignChanged, OnResetForm, _LoadComplianceExceptions, InitializeComponent; references AccProduct, ComplianceArea, ComplianceRule, Delegation, ESet, HelperPWOCompliance; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-forms-qer-forms-formitshoppersonprolongateorder.cs | decompiled C# reference | classes FormITShopPersonProlongateOrder; methods OnInit, OnResetForm, InitializeComponent, MainActivator_OnActivating, _HandleAssignmentOrderMode, OnFormLoad; references AccProduct, Department, ESet, Person, ProfitCenter, WorkDesk; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-forms-qer-forms-formitshopunsubscribeorder.cs | decompiled C# reference | classes FormITShopUnsubscribeOrder; methods OnInit, OnResetForm, OnFormLoad, FormTaskUnSubscribe, InitializeComponent, MainActivator_OnActivating; references AccProduct, Department, ESet, Person, ProfitCenter, WorkDesk; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-rms-customizer-rms-customizer-workdeskhaseset.cs | decompiled C# reference | classes WorkdeskHasESet; methods CreateITShopWorkdeskOrder; references AccProduct, ESet, Person, WorkDesk, WorkDeskHasESet; markers references DB/Dialog objects, IT Shop related markers |
| cs-rps-forms-rps-forms-formrpsreportmasterdata.cs | decompiled C# reference | classes FormRPSReportMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged, Task_Preview; references AccProduct, DialogParameter, DialogParameterSet, DialogReport, Person, RPSReport; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |