AM
AMProdMatlSplit2
PX.Objects.AM48 of 48 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 | ||||
SplitLineNbr | int | Allocation ID | - | |
Description:No description available | ||||
AMBatNbr | nvarchar(15) | AM Batch Nbr | AMBatch | |
Description:No description available | ||||
AMDocType | char(1) | AM Document Type | - | |
Description:No description available | ||||
AMOrderType | char(2) | Sub. Assy. Order Type | - | |
Description:No description available | ||||
AMProdOrdID | nvarchar(19) | Sub. Assy. Production Nbr. | - | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQtyComplete | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQtyReceived | decimal(25, 6) | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsAllocated | bit | Allocated | - | |
Description:No description available | ||||
IsStockItem | bit | Stock Item | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
ParentSplitLineNbr | int | Parent Allocation ID | - | |
Description:No description available | ||||
PlanID | bigint | Plan ID | INItemPlan | |
Description:No description available | ||||
POCancelled | bit | - | ||
Description:No description available | ||||
POCompleted | bit | - | ||
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
POOrderNbr | nvarchar(15) | PO Order Nbr. | POOrder | |
Description:No description available | ||||
POOrderType | char(2) | PO Type | - | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
POReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
ProdCreate | bit | Mark for Production | - | |
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
QtyComplete | decimal(25, 6) | Qty. Complete | - | |
Description:No description available | ||||
QtyReceived | decimal(25, 6) | Qty. Received | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
SiteID | int | Alloc.Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TranDate | datetime2 | Allocation Date | - | |
Description:No description available | ||||
TranType | nchar(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
VendorID | int | - | ||
Description:No description available | ||||