AM
AMVendorShipLine
PX.Objects.AM39 of 39 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
ShipmentNbr | nvarchar(15) | Shipment Nbr. | AMVendorShipment | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | Base Qty | - | |
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
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 | datetime2 | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:No description available | ||||
InvtMult | smallint | Multiplier | - | |
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 | ||||
LineType | char(1) | Type | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerCntr | int | LotSerCntr | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
MatlLineID | int | Material Line Nbr. | AMProdMatl | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
POOrderNbr | nvarchar(15) | PO Order Nbr. | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TranDate | datetime2 | - | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Tran Description | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UOM | char(6) | UOM | INUnit | |
Description:No description available | ||||
UpdateProjectNonexistent in DB | bit | - | ||
Description:No description available | ||||