AM
AMProdMatlInventory
PX.Objects.AM81 of 81 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineID | int | Line Nbr. | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
BaseOperTotalQtyNonexistent in DB | decimal | Base Order Qty. | - | |
Description:No description available | ||||
BaseQtyActual | decimal | Base Qty Actual | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal | Base Qty Remaining | - | |
Description:No description available | ||||
BaseTotalQtyRequired | decimal | Base Total Required | - | |
Description:No description available | ||||
BatchSize | decimal | Batch Size | - | |
Description:No description available | ||||
BFlush | bit | Backflush Materials | - | |
Description:No description available | ||||
CompBOMID | nvarchar(15) | Comp BOM ID | AMBomItem | |
Description:No description available | ||||
CompBOMRevisionID | nvarchar(10) | Comp BOM Revision | AMBomItem | |
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
InventoryCD | nvarchar(MAX) | Inventory CD | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsByproductNonexistent in DB | bit | By-product | - | |
Description:No description available | ||||
IsFixedMaterialNonexistent in DB | bit | Fixed Material | - | |
Description:No description available | ||||
IsStockItem | bit | Is Stock Item | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:No description available | ||||
ItemDescr | nvarchar(256) | Item Description | - | |
Description:No description available | ||||
ItemStatus | char(2) | Item Status | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbrNonexistent in DB | int | Line Nbr | - | |
Description:No description available | ||||
LineQtyAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LineQtyHardAvailNonexistent in DB | decimal | - | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
MaterialType | int | Material Type | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationCD | nvarchar(10) | Operation ID | - | |
Description:No description available | ||||
PhantomRouting | int | Phantom Routing | - | |
Description:No description available | ||||
PhtmBOMID | nchar(15) | Phantom BOM ID | - | |
Description:No description available | ||||
PhtmBOMLineRef | int | Phantom BOM Ref Line Nbr | - | |
Description:No description available | ||||
PhtmBOMOperationID | int | Phantom Operation ID | - | |
Description:No description available | ||||
PhtmBOMRevisionID | nvarchar(10) | Phantom BOM Revision | - | |
Description:No description available | ||||
PhtmLevel | int | Phantom Level | - | |
Description:No description available | ||||
PhtmMatlBOMID | nchar(15) | Phantom Matl BOM ID | - | |
Description:No description available | ||||
PhtmMatlLineRef | int | Phantom Matl Line Nbr | - | |
Description:No description available | ||||
PhtmMatlOperationID | int | Phantom Matl Operation ID | - | |
Description:No description available | ||||
PhtmMatlRevisionID | nvarchar(10) | Phantom Matl Revision | - | |
Description:No description available | ||||
PlanCostNonexistent in DB | decimal | Planned Cost | - | |
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POLinkEnableNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProdCreate | bit | Mark for Production | - | |
Description:No description available | ||||
ProdLinkEnableNonexistent in DB | bit | - | ||
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:No description available | ||||
QtyActual | decimal | Qty Actual | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal | Qty Remaining | - | |
Description:No description available | ||||
QtyReq | decimal | Qty Required | - | |
Description:No description available | ||||
QtyReqWithScrapNonexistent in DB | decimal | Qty Required with Scrap | - | |
Description:No description available | ||||
QtyRoundUp | bit | Qty Round Up | - | |
Description:No description available | ||||
ScrapFactor | decimal | Scrap Factor | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
StatusID | char(1) | Material Status | - | |
Description:No description available | ||||
StkItem | bit | Stock Item | - | |
Description:No description available | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Task | - | |
Description:No description available | ||||
TotActCost | decimal | Total Actual Cost | - | |
Description:No description available | ||||
TotalQtyRequired | decimal | Total Required | - | |
Description:No description available | ||||
TranDate | datetime2 | Tran Date | - | |
Description:No description available | ||||
TranType | nchar(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UpdateProjectNonexistent in DB | bit | - | ||
Description:No description available | ||||
VendorID | int | Vendor | BAccount | |
Description:No description available | ||||
WarehouseOverride | bit | Warehouse Override | - | |
Description:No description available | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:No description available | ||||