AM
AMWrkMatl
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AutoNbr | int | - | ||
Description:No description available | ||||
BFlush | bit | BFlush | - | |
Description:No description available | ||||
BaseMatlQty | decimal | Release Base Qty | - | |
Description:Material batch release BASE qty to be processed in a material batch. | ||||
BaseQtyAvail | decimal | Available Qty | - | |
Description:No description available | ||||
BaseQtyAvailPjct | decimal | Available Qty for Project | - | |
Description:Calculated available material quantity based on the AMProdItem.UpdateProject and CostCenterID | ||||
BaseQtyRemaining | decimal | Base Qty Remaining | - | |
Description:No description available | ||||
BaseQtyReq | decimal | Required Base Qty | - | |
Description:Total required BASE quantity for the material line | ||||
BaseUnreleasedBatchQty | decimal | Unreleased Batch Base Qty | - | |
Description:Total Unreleased Batch BASE quantity for the material line | ||||
CostCenterID | int | - | ||
Description:Copied AMProdMatl.CostCenterID value from AMProdMatl | ||||
CostCodeID | int | Cost Code | - | |
Description:Copied AMProdItem.CostCodeID from AMProdItem | ||||
Descr | nvarchar(256) | Descr | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
IsByproduct | bit | By-product | - | |
Description:No description available | ||||
LineID | int | Line ID | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
MatlQty | decimal | Release Qty | - | |
Description:Material batch release qty to be processed in a material batch. | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:Operation CD | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
OverIssueMaterial | char(1) | Over Issue Material | - | |
Description:Check for over issued material | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:Copied Project from AMProdItem | ||||
QtyAvail | decimal | Available Qty | - | |
Description:No description available | ||||
QtyRemaining | decimal | Qty Remaining | - | |
Description:No description available | ||||
QtyReq | decimal | Required Qty | - | |
Description:Total required quantity for the material line | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
TaskID | int | Project Task | PMProject | |
Description:Copied Task from AMProdItem | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnreleasedBatchQty | decimal | Unreleased Batch Qty | - | |
Description:Total Unreleased Batch quantity for the material line | ||||
UpdateProjectNonexistent in DB | bool? | Update Project | - | |
Description:Copied AMProdItem.UpdateProject from AMProdItem | ||||
UserID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||