dbo.AccProductGroup
Service categories
TableType TUsage USERDATARows 15SizeMB 0.08
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_AccProductGroup | varchar(38) | no | Service category | PKUID |
UID_AccProductParamCategory | varchar(38) | yes | Request property | FKUID |
UID_PWODecisionMethod | varchar(38) | yes | Approval policy | FKUID |
UID_OrgRuler | varchar(38) | yes | Product owner | FKUID |
SalesPrice | float(8) | yes | Sales price | |
InternalPrice | float(8) | yes | Internal price | |
PurchasePrice | float(8) | yes | Purchase price | |
Currency | nvarchar(64) | yes | Currency | |
Description | nvarchar(-1) | yes | Description | |
Ident_AccProductGroup | nvarchar(512) | yes | Service category | |
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 | |
Remarks | nvarchar(-1) | yes | Remarks | |
IsSpecialGroup | bit(1) | yes | Special service category | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
UID_AccProductGroupParent | varchar(38) | yes | Parent service category | FKUID |
JPegPhoto | varbinary(-1) | yes | Picture | |
UID_OrgAttestator | varchar(38) | yes | Attestor | FKUID |
FullPath | nvarchar(512) | yes | Full name | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
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 |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1059 | AccProduct.UID_AccProductGroup | AccProductGroup.UID_AccProductGroup |
| QER_RFRL1632 | AccProductGroup.UID_PWODecisionMethod | PWODecisionMethod.UID_PWODecisionMethod |
| QER_RFRL1737 | AccProductGroup.UID_OrgAttestator | BaseTree.UID_Org |
| QER_RFRL1794 | AccProductGroup.UID_AccProductParamCategory | AccProductParamCategory.UID_AccProductParamCategory |
| QER_RFRL451 | AccProductGroupCollection.UID_AccProductGroupChild | AccProductGroup.UID_AccProductGroup |
Triggers
ATT_TUAccProductGroup SQL_TRIGGER
GEN_T1046293E65EE4A8AB311F4E45 SQL_TRIGGER
GEN_T2C87AE1803CF635952A354967 SQL_TRIGGER
GEN_T3C199FAF75634949FA41FE0F2 SQL_TRIGGER
GEN_T592EA3307825DF838CD5A78B2 SQL_TRIGGER
QER_TDAccProductGroup SQL_TRIGGER
QER_TIAccProductGroup SQL_TRIGGER
QER_TUAccProductGroup 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_FTE7DB900500A82E082B94D0A7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTEFFAA41A2AB92F8FB75E91BD | 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.GEN_PSR4E8A0A9193D14A5E25E28B8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PAfterMigrationTasks | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PITShopProductNodeCreate_b | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAccProductGroupCollection | 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.GEN_T1046293E65EE4A8AB311F4E45 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T143AA19BE672633C8B9B6B245 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2AD72DEB63D549ED15235E0B9 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C87AE1803CF635952A354967 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C199FAF75634949FA41FE0F2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T592EA3307825DF838CD5A78B2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUAccProductGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA0304F2F5CD44FEB832B87AA7 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA28C7C4A4A651142C7F62A174 | 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_VA6AE1CA27A16D5418224C6639 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_VA6CAAFB1A29425CB711D5AFAD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERITShopOwnerUsage | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| AccProduct | foreign key references table | QER_RFRL1059: AccProduct.UID_AccProductGroup -> AccProductGroup.UID_AccProductGroup |
| PWODecisionMethod | referenced by foreign key from table | QER_RFRL1632: AccProductGroup.UID_PWODecisionMethod -> PWODecisionMethod.UID_PWODecisionMethod |
| BaseTree | referenced by foreign key from table | QER_RFRL1737: AccProductGroup.UID_OrgAttestator -> BaseTree.UID_Org |
| AccProductParamCategory | referenced by foreign key from table | QER_RFRL1794: AccProductGroup.UID_AccProductParamCategory -> AccProductParamCategory.UID_AccProductParamCategory |
| AccProductGroupCollection | foreign key references table | QER_RFRL451: AccProductGroupCollection.UID_AccProductGroupChild -> AccProductGroup.UID_AccProductGroup |
| 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_PITShopProductNodeCreate_b | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZAccProductGroupCollection | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QER_FTMethodForPRNode | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QER_TUAccProductGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |