ProcessWorkOrdersOperationMaterialSubstituteMaterial
ProcessWorkOrdersOperationMaterialSubstituteMaterial
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | ProcessWorkOrdersWorkOrderId | |
| OperationWorkOrderOperationId [KEY] | Long | OperationWorkOrderOperationId | |
| MaterialWorkOrderOperationMaterialId [KEY] | Long | MaterialWorkOrderOperationMaterialId | |
| OrganizationId | Long | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderBySerialNumber, WorkOrderByWorkAreaWorkCenter, WorkOrderByWorkOrderNumber | OrganizationId |
| OrganizationCode | String | OrganizationCode | |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByModifiedDate, WorkOrderByWorkAreaWorkCenter | InventoryItemId |
| ItemNumber | String | WorkOrderB2BCM | ItemNumber |
| WorkOrderOperationMaterialId | Long | WorkOrderOperationMaterialId | |
| WorkOrderOperationSubstituteMaterialId [KEY] | Long | WorkOrderOperationSubstituteMaterialId | |
| Priority | Decimal | Priority | |
| InverseQuantity | Decimal | InverseQuantity | |
| QuantityPERProduct | Decimal | QuantityPERProduct | |
| RequiredQuantity | Decimal | RequiredQuantity | |
| SubstituteFlag | Bool | SubstituteFlag | |
| UOMCode | String | UOMCode | |
| UnitOfMeasure | String | UnitOfMeasure | |
| CreatedBy | String | CreatedBy | |
| CreationDate | Datetime | CreationDate | |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy | |
| OnhandQuantity | Decimal | OnhandQuantity | |
| AvailableToTransact | Decimal | AvailableToTransact | |
| Description | String | Description | |
| EnforceIntRequirements | String | EnforceIntRequirements | |
| ExtendedQuantity | Decimal | ExtendedQuantity | |
| EnforceIntegerRequirementsMeaning | String | EnforceIntegerRequirementsMeaning | |
| BackToBackFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | backtobackflag |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | contractmfgflag |
| DueDays | Int | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | duedays |
| Finder | String | finder | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | firmplannedflag |
| MaterialItemId | Long | WorkOrderByComponent | materialitemid |
| PlannedCompletionDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | plannedcompletiondate |
| PlannedStartDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | plannedstartdate |
| ProductSerialId | Long | WorkOrderBySerial | productserialid |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | resourceid |
| SerialNumber | String | WorkOrderBySerialNumber | serialnumber |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | sourceheaderreferenceid |
| SourceHeaderRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | sourceheaderrefid |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | sourcelinereferenceid |
| SourceLineRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | sourcelinerefid |
| SourceSystemId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | sourcesystemid |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | tolerance |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | woprojectnumber |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | workareaid |
| WorkCenterId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | workcenterid |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | workorderid |
| WorkOrderNumber | String | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkOrderNumber | workordernumber |
| WorkOrderStatusId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | workorderstatusid |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | wotasknumber |