WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
Columns
Name | Type | Description |
WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
WorkorderassemblycomponentWoOperationMaterialId [KEY] | Long | WorkorderassemblycomponentWoOperationMaterialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
WoOperationMaterialSerialId [KEY] | Long | WoOperationMaterialSerialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
OrganizationId | Long | OrganizationId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
WorkOrderId | Long | WorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
WoOperationMaterialId | Long | Value that uniquely identifies the reworked assembly. It is a primary key that the application generates when it creates the item. |
WoOperationMaterialLotId | Long | WoOperationMaterialLotId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
LotNumber | String | Lot number of the reworked assembly. |
InventoryItemId | Long | InventoryItemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial |
SerialNumber | String | Serial number that identifies the reworked assembly. |
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 |
ItemNumber | String | ItemNumber |
LastUpdateDate | Datetime | LastUpdateDate |
MaterialItemId | Long | MaterialItemId |
PlannedCompletionDate | Datetime | PlannedCompletionDate |
PlannedStartDate | Datetime | PlannedStartDate |
ProductSerialId | Long | ProductSerialId |
ResourceId | Long | ResourceId |
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 |