dbo.FirmPartner
Business partners
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_FirmPartner | varchar(38) | no | Company | PKUID |
Ident_FirmPartner | nvarchar(128) | no | Company | |
Name1 | nvarchar(-1) | yes | Name | |
Name2 | nvarchar(128) | yes | Surname prefix | |
Street | nvarchar(-1) | yes | Street | |
City | nvarchar(128) | yes | City | |
ZIPCode | nvarchar(32) | yes | Zip code | |
ShortName | nvarchar(64) | yes | Short name | |
Phone | nvarchar(-1) | yes | Phone | |
Fax | nvarchar(-1) | yes | Fax | |
Remarks | nvarchar(-1) | yes | Remarks | |
CustomerNumber | nvarchar(64) | yes | Customer number (partner) | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
EMail | nvarchar(512) | yes | Email address | |
FirmPartnerURL | nvarchar(-1) | yes | Web page | |
Contact | nvarchar(-1) | yes | Contact | |
IsLeasingPartner | bit(1) | yes | Leasing partner | |
VendorNumber | nvarchar(128) | yes | Customer number (supplier) | |
IsManufacturer | bit(1) | yes | Manufacturer | |
IsVendor | bit(1) | yes | Supplier | |
IsPartner | bit(1) | yes | Partner | |
Building | nvarchar(64) | yes | Building | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
UID_DialogCountry | varchar(38) | yes | Country | FKUID |
UID_DialogState | varchar(38) | yes | §§State | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1299 | AccProduct.UID_FirmPartner | FirmPartner.UID_FirmPartner |
| QER_RFRL1471 | Person.UID_FirmPartner | FirmPartner.UID_FirmPartner |
| QER_RFRL1995 | FirmPartner.UID_DialogState | DialogState.UID_DialogState |
| QER_RFRL1996 | FirmPartner.UID_DialogCountry | DialogCountry.UID_DialogCountry |
| QER_RFRL3352 | HardwareType.UID_FirmPartnerDefaultVendor | FirmPartner.UID_FirmPartner |
| QER_RFRL768 | Hardware.UID_FirmPartnerManufacturer | FirmPartner.UID_FirmPartner |
| QER_RFRL848 | HardwareType.UID_FirmPartner | FirmPartner.UID_FirmPartner |
Triggers
GEN_T20516405ABC8E971E94F4DFBC SQL_TRIGGER
GEN_T4E0DB2DF6F93D6899D14FA23E SQL_TRIGGER
GEN_T5DDC3978183ACC3A5025878D1 SQL_TRIGGER
GEN_T681D4F81C6E5A47FA3FDD6BE8 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_T10DDEB8F8C0DA1E8C82D8396B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T27B05EC761EFF8DD7BC5DC73A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5DDC3978183ACC3A5025878D1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVFirstUnicodeChar | SQL expression dependency | OBJECT_OR_COLUMN |
| AccProduct | foreign key references table | QER_RFRL1299: AccProduct.UID_FirmPartner -> FirmPartner.UID_FirmPartner |
| Person | foreign key references table | QER_RFRL1471: Person.UID_FirmPartner -> FirmPartner.UID_FirmPartner |
| DialogState | referenced by foreign key from table | QER_RFRL1995: FirmPartner.UID_DialogState -> DialogState.UID_DialogState |
| DialogCountry | referenced by foreign key from table | QER_RFRL1996: FirmPartner.UID_DialogCountry -> DialogCountry.UID_DialogCountry |
| HardwareType | foreign key references table | QER_RFRL3352: HardwareType.UID_FirmPartnerDefaultVendor -> FirmPartner.UID_FirmPartner |
| Hardware | foreign key references table | QER_RFRL768: Hardware.UID_FirmPartnerManufacturer -> FirmPartner.UID_FirmPartner |
| HardwareType | foreign key references table | QER_RFRL848: HardwareType.UID_FirmPartner -> FirmPartner.UID_FirmPartner |