dbo.ShoppingCartItem
Cart items
TableType TUsage USERDATARows 0SizeMB 0.144
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_ShoppingCartItem | varchar(38) | no | Cart item | PKUID |
UID_ITShopOrg | varchar(38) | yes | Product | FKUID |
UID_PersonInserted | varchar(38) | no | Requester | FKUID |
UID_AccProduct | varchar(38) | no | Service item | FKUID |
UID_PersonOrdered | varchar(38) | no | Recipient | FKUID |
Quantity | float(8) | yes | Quantity | |
IsActivated | bit(1) | yes | §§Request | |
SortOrder | int(4) | yes | Sort order | |
OrderReason | nvarchar(-1) | yes | Reason | |
OrderDate | datetime(8) | yes | Request date | |
DisplayOrg | nvarchar(512) | yes | Product | |
ValidFrom | datetime(8) | yes | Valid from | |
ValidUntil | datetime(8) | yes | Valid until | |
AdditionalData | nvarchar(-1) | yes | Additional information | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XUserInserted | nvarchar(128) | yes | Created by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
UID_ShoppingCartItemParent | varchar(38) | yes | Parent cart item | FKUID |
IsOptionalChild | bit(1) | yes | Extras | |
UID_ShoppingCartOrder | varchar(38) | yes | Cart | FKUID |
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 | |
UID_PersonWantsOrg | varchar(38) | yes | Request procedure | FKUID |
MethodName | nvarchar(128) | yes | Task names | limited |
MethodParameters | nvarchar(-1) | yes | Method parameter | |
ObjectKeyOrdered | varchar(138) | yes | Object key | |
PositionNumber | int(4) | yes | Item number | |
ObjectKeyAssignment | varchar(138) | yes | Object key | |
UID_Department | varchar(38) | yes | Department | FKUID |
UID_ProfitCenter | varchar(38) | yes | Cost center | FKUID |
OrderDetail1 | nvarchar(-1) | yes | Additional request data | |
OrderDetail2 | nvarchar(128) | yes | Additional request data 2 | |
UID_WorkDeskOrdered | varchar(38) | yes | Workdesk | FKUID |
IsOrderForWorkDesk | bit(1) | yes | Workdesk request | |
DisplayObjectKeyAssignment | nvarchar(512) | yes | Assignment | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
PWOPriority | int(4) | yes | Priority | limited |
CheckResult | int(4) | yes | Check result | limited |
CheckResultDetail | nvarchar(-1) | yes | Check detail | |
ObjectKeyOrgUsedInAssign | varchar(138) | yes | Role/organization | |
ObjectKeyElementUsedInAssign | varchar(138) | yes | Assigned product | |
UID_QERJustificationOrder | varchar(38) | yes | Standard reason for requesting | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1141 | ShoppingCartItem.UID_QERJustificationOrder | QERJustification.UID_QERJustification |
| QER_RFRL1804 | ShoppingCartItem.UID_Department | BaseTree.UID_Org |
| QER_RFRL4204 | ShoppingCartItem.UID_WorkDeskOrdered | WorkDesk.UID_WorkDesk |
Triggers
GEN_T1C55DA64CBBD1170C3DF3A929 SQL_TRIGGER
GEN_T281A1B36D942EA78BB1D128B8 SQL_TRIGGER
GEN_T35658369B5FC5D909A2224C94 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.QER_ZITShopDeleteClosed | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C3D78466F05DE84C333B3E26 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C55DA64CBBD1170C3DF3A929 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T281A1B36D942EA78BB1D128B8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C2630021CB14906358C7D203 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T31EC3716F8EE9DF11DE8931FF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T380DEA238A283A0D5F954A670 | SQL expression dependency | OBJECT_OR_COLUMN |
| QERJustification | referenced by foreign key from table | QER_RFRL1141: ShoppingCartItem.UID_QERJustificationOrder -> QERJustification.UID_QERJustification |
| BaseTree | referenced by foreign key from table | QER_RFRL1804: ShoppingCartItem.UID_Department -> BaseTree.UID_Org |
| WorkDesk | referenced by foreign key from table | QER_RFRL4204: ShoppingCartItem.UID_WorkDeskOrdered -> WorkDesk.UID_WorkDesk |
| dbo.QER_ZITShopDeleteClosed | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-cpl-compositionapi-cpl-compositionapi-itshop-cartcompliancecheck.cs | decompiled C# reference | classes CartComplianceCheck, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass12_0, _003C_003Ec__DisplayClass17_0; methods MoveNext, SetStateMachine, _003CGetViolationsAsync_003Eb__1, _003CGetViolationsAsync_003Eb__2, _003CSetExceptionApproverFlagsAsync_003Eb__1, _003CCheckOrgAssignmentComplianceAsync_003Eb__3; references AERole, ComplianceRule, ComplianceSubRule, Department, ESet, HelperPWOPersonHasObject; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| 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-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 |