AM
AMWrkMatl
PX.Objects.AM35 of 35 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AutoNbr | int | AutoNbr | - | |
Description:No description available | ||||
BaseMatlQty | decimal(25, 9) | Release Base Qty | - | |
Description:No description available | ||||
BaseQtyAvail | decimal(25, 9) | Available Qty | - | |
Description:No description available | ||||
BaseQtyAvailPjct | decimal(25, 9) | Available Qty for Project | - | |
Description:No description available | ||||
BaseQtyRemaining | decimal(25, 9) | Base Qty Remaining | - | |
Description:No description available | ||||
BaseQtyReq | decimal(25, 9) | Required Base Qty | - | |
Description:No description available | ||||
BaseUnreleasedBatchQty | decimal(25, 9) | Unreleased Batch Base Qty | - | |
Description:No description available | ||||
BFlush | bit | BFlush | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Descr | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
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(25, 9) | Release Qty | - | |
Description:No description available | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
OverIssueMaterial | nchar(1) | Over Issue Material | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
QtyAvail | decimal(25, 9) | Available Qty | - | |
Description:No description available | ||||
QtyRemaining | decimal(25, 9) | Qty Remaining | - | |
Description:No description available | ||||
QtyReq | decimal(25, 9) | Required Qty | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnreleasedBatchQty | decimal(25, 9) | Unreleased Batch Qty | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UpdateProjectNonexistent in DB | bit | Update Project | - | |
Description:No description available | ||||
UserID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||