WorkOrdersWorkOrderAssemblyComponent
WorkOrdersWorkOrderAssemblyComponent
Columns
Name | Type | Description |
WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderAssemblyComponent |
OrganizationId | Long | Value that uniquely identifies the inventory organization that's enabled for manufacturing. It is a primary key of the inventory organization. |
WorkOrderId | Long | Value that uniquely identifies the reworked work order. It is a primary key of the rework work order. |
WoOperationId | Long | Value that uniquely identifies the first count point operation of the rework that references this material. This material is an assembly that the work order will rework. It is a primary key of the work order operation. |
OperationSequenceNumber | Double | OperationSequenceNumber of WorkOrdersWorkOrderAssemblyComponent |
OperationName | String | OperationName of WorkOrdersWorkOrderAssemblyComponent |
WoOperationMaterialId [KEY] | Long | Value that uniquely identifies the rework that references the material. This material is an assembly that the work order will rework. It is a primary key of the material. |
InventoryItemId | Long | Value that uniquely identifies the item, product, or assembly in the inventory organization. |
ItemNumber | String | ItemNumber of WorkOrdersWorkOrderAssemblyComponent |
Quantity | Double | Planned quantity of the reworked assembly for the work order. This is equal to the work order quantity. |
UnitOfMeasure | String | UnitOfMeasure of WorkOrdersWorkOrderAssemblyComponent |
SupplySubinventory | String | Subinventory to use, by default, when the plant gets the material for rework. |
SupplyLocatorId | Long | Value that uniquely identifies the locator. It is a primary key that the application generates when it creates the locator. |
SupplyLocator | String | Locator in the subinventory to use, by default, when the plant gets the material for rework. |
ReservedQuantity | Double | ReservedQuantity of WorkOrdersWorkOrderAssemblyComponent |
IssuedQuantity | Double | Quantity of the reworked assembly that the application issues for the operation when it releases the work order. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
BackToBackFlag | String | BackToBackFlag |
ContractMfgFlag | String | ContractMfgFlag |
DueDays | Int | DueDays |
FirmPlannedFlag | String | FirmPlannedFlag |
LastUpdateDate | Datetime | LastUpdateDate |
MaterialItemId | Long | MaterialItemId |
PlannedCompletionDate | Datetime | PlannedCompletionDate |
PlannedStartDate | Datetime | PlannedStartDate |
ProductSerialId | Long | ProductSerialId |
ResourceId | Long | ResourceId |
SerialNumber | String | SerialNumber |
SourceHeaderRefId | Long | SourceHeaderRefId |
SourceHeaderReferenceId | Long | SourceHeaderReferenceId |
SourceLineRefId | Long | SourceLineRefId |
SourceLineReferenceId | Long | SourceLineReferenceId |
SourceSystemId | Long | SourceSystemId |
Tolerance | Int | Tolerance |
WoProjectNumber | String | WoProjectNumber |
WoTaskNumber | String | WoTaskNumber |
WorkAreaId | Long | WorkAreaId |
WorkCenterId | Long | WorkCenterId |
WorkOrderNumber | String | WorkOrderNumber |
WorkOrderStatusId | Long | WorkOrderStatusId |
Finder | String | finder |