AM
AMProdMatlSplit2
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMBatNbr | nvarchar(15) | AM Batch Nbr | - | |
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 | - | ||
Description:No description available | ||||
BaseQtyComplete | decimal | - | ||
Description:No description available | ||||
BaseQtyReceived | decimal | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
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 | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineID | int | Line Nbr. | - | |
Description:No description available | ||||
LocationID | int | Location | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
OperationID | int | Operation ID | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | - | |
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. | - | |
Description:No description available | ||||
POOrderType | char(2) | PO Type | - | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | - | |
Description:No description available | ||||
POReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
ParentSplitLineNbr | int | Parent Allocation ID | - | |
Description:No description available | ||||
PlanID | bigint | Plan ID | - | |
Description:No description available | ||||
ProdCreate | bit | Mark for Production | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | - | |
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
QtyComplete | decimal | Qty. Complete | - | |
Description:No description available | ||||
QtyReceived | decimal | Qty. Received | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
SiteID | int | Alloc.Warehouse | - | |
Description:No description available | ||||
SplitLineNbr | int | Allocation ID | - | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TranDate | datetime | Allocation Date | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||