Purchased parts
WRDA_Parts
The WRDA_Parts view provides all purchased parts master data from Data Administration incl. folder structure.
Relations
| Field (WRDA_Parts) | Field | Table / View |
|---|---|---|
MassUnitID |
UnitID |
|
CustomsTariffNumberID |
CustomsTariffNumberID |
|
CreatorID |
DAUserID |
|
ModifierID |
DAUserID |
Field description
| Field | Description |
|---|---|
DAPartID |
int, not null Internal ID of the purchased part or purchased part folder. |
DAPartParentID |
int, not null Internal ID of the parent folder |
IsGroup |
bit, not null Returns the value 0 if the current data row is a purchased part, otherwise the value 1 is returned for a folder. |
PartName |
nvarchar(max), null Name of the purchased part in the Company language. |
PartName |
nvarchar(max), null Name of the purchased part in the language according to the country code. Example: PartName_EN for the English part name. |
PartIdentifier |
nvarchar(50), null Material number of the purchased part (characteristic). |
PartDescription |
nvarchar(max), null Description of the purchased part in the Company language. |
PartDescription_DE |
nvarchar(max), null German description of the purchased part. |
PartDescription_EN |
nvarchar(max), null English description of the purchased part. |
OrderNumber |
nvarchar(50), null Order number |
ProductGroup |
nvarchar(50), null Product group |
DIN |
nvarchar(50), null DIN identifier |
ISO |
nvarchar(50), null ISO identifier |
Rating |
nvarchar(50), null Rating |
Dimensionen |
nvarchar(50), null Dimension |
Refinement |
nvarchar(50), null Refinement |
Mass |
float, null Mass |
MassUnitID |
int, null Internal ID of the mass unit The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
|
Valid as of version 10.1 CustomsTariffNumberID |
int, null ID of the customs tariff number Information on the customs tariff number can be determined via the foreign key in the WRDA_CustomsTariffNumber view. |
DAPartType |
varchar(13), null Part type Returns either StandardPart or PurchasedPart. Also returns a value if it is a purchased part folder. |
CreatorID |
int, null Internal ID of the user who created the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view. |
CreationDateTime |
datetime, null Creation date of the data record |
ModifierID |
int, null Internal ID of the user who last updated the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view. |
LastUpdateDateTime |
datetime, null Modification date |
WRDA_PartPrices
The WRDA_PartPrices view provides the price information defined at the purchased part.
Relations
| Field (WRDA_PartPrices) | Field | Table / View |
|---|---|---|
DAPartID |
DAPartID |
|
DAOriginID |
DAOriginID |
|
CountryGroupID |
CountryGroupID |
|
UnitID |
UnitID |
|
CurrencyID |
UnitID |
|
CreatorID |
DAUserID |
|
ModifierID |
DAUserID |
Field description
| Field | Description |
|---|---|
DAPartPricesID |
int, not null Internal ID of the price row |
DAPartID |
int, not null Internal ID of the part (seeWRDA_Parts) |
DAOriginsID |
int, null Internal ID of the origin (see WRDA_Origins) |
|
Valid as of version 10.1 CountryGroupID |
int, null Internal ID of the country group (see WRDA_CountryGroup) |
Price |
decimal(28,9), null Value of the price |
Quantity |
int, null Quantity reference |
UnitID |
int, null ID for the unit of the price reference. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
CurrencyID |
int, null ID for the currency of the price. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
ValidFrom |
datetime, null Valid as of date |
ValidTo |
datetime, null Valid until date |
OriginType |
varchar(13), null Origin on the price System Supplier Facility Customer If no origin is assigned, the value null is returned. |
IsEstimation |
bit, null Returns the value 1 if the price was estimated, otherwise the value 0 is returned. |
MinAmount |
int, null Minimum purchase quantity |
Delivery |
char(10), null Delivery format |
CreatorID |
int, null Internal ID of the user who created the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view. |
CreationDateTime |
datetime, null Creation time of the price |
ModifierID |
int, null Internal ID of the user who last updated the price row The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view. |
LastUpdateDateTime |
datetime, null Modification date of the data row |