AM
SelectedProdMatl
PX.Objects.AM98 of 98 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineID | int | Line Nbr. | - | |
Description:No description available | ||||
OperationID | int | Operation ID | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | - | |
Description:No description available | ||||
AMOrderTypeNonexistent in DB | nchar(2) | Sub. Assy. Order Type | AMOrderType | |
Description:No description available | ||||
AMProdOrdID | nvarchar(19) | Sub. Assy. 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 | - | |
Description:No description available | ||||
CompBOMRevisionID | nvarchar(10) | Comp BOM Revision | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
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 | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsAllocatedNonexistent in DB | bit | Allocated | - | |
Description:No description available | ||||
IsByproductNonexistent in DB | bit | By-product | - | |
Description:No description available | ||||
IsByproduct2Nonexistent in DB | bit | By-product | - | |
Description:No description available | ||||
IsFixedMaterialNonexistent in DB | bit | Fixed Material | - | |
Description:No description available | ||||
IsStockItem | bit | Is stock | - | |
Description:No description available | ||||
ItemClassIDNonexistent in DB | int | Item Class | INItemClass | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
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 | - | |
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 | ||||
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 | ||||
PlanIDNonexistent in DB | bigint | Plan ID | - | |
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POLinkEnableNonexistent in DB | bit | - | ||
Description:No description available | ||||
POOrderNbrNonexistent in DB | nvarchar(15) | PO Order Nbr. | POOrder | |
Description:No description available | ||||
PreferredVendorID | nvarchar(30) | Preferred Vendor ID | BAccount | |
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 | ||||
QtyAllocNonexistent in DB | decimal | Quantity | - | |
Description:No description available | ||||
QtyAvailNonexistent in DB | decimal | Qty. Available | - | |
Description:No description available | ||||
QtyHardAvailNonexistent in DB | decimal | Qty. Hard Available | - | |
Description:No description available | ||||
QtyOnHandNonexistent in DB | decimal | Qty On Hand | - | |
Description:No description available | ||||
QtyOnHandPjctNonexistent in DB | decimal | Qty On Hand for Project | - | |
Description:No description available | ||||
QtyProductionDemandNonexistent in DB | decimal | Qty. Production Demand | - | |
Description:No description available | ||||
QtyProductionDemandPreparedNonexistent in DB | decimal | Qty. Production Demand Prepared | - | |
Description:No description available | ||||
QtyProductionSupplyNonexistent in DB | decimal | Qty. Production Supply | - | |
Description:No description available | ||||
QtyProductionSupplyPreparedNonexistent in DB | decimal | Qty. Production Supply Prepared | - | |
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 | ||||
QtyShortNonexistent in DB | decimal | Qty Short | - | |
Description:No description available | ||||
QtyShortPjctNonexistent in DB | decimal | Qty Short for Project | - | |
Description:No description available | ||||
ReplenishmentSourceNonexistent in DB | nvarchar(1) | Replenishment Source | - | |
Description:No description available | ||||
ReplenishmentSourceSiteIDNonexistent in DB | int | Replenishment Warehouse | - | |
Description:No description available | ||||
RequiredDateNonexistent in DB | datetime | Required Date | - | |
Description:No description available | ||||
ScrapFactor | decimal | Scrap Factor | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SortOrder | int | Line Order | - | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
SplitLineNbrNonexistent in DB | int | Split Line Nbr | - | |
Description:No description available | ||||
StatusID | char(1) | Material Status | - | |
Description:No description available | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
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 | - | |
Description:No description available | ||||
UpdateProjectNonexistent in DB | bit | - | ||
Description:No description available | ||||
VendorID | int | Vendor | - | |
Description:No description available | ||||
WarehouseOverride | bit | Warehouse Override | - | |
Description:No description available | ||||