AM
AMClockItem
PX.Objects.AM39 of 39 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
EmployeeID | int | Employee ID | Vendor | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | Base Qty | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CostCenterID | int | Cost Center | INLotSerialStatusByCostCenter | |
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 | ||||
EndTime | datetime2 | End Time | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | Multiplier | - | |
Description:No description available | ||||
IsClockedInNonexistent in DB | bit | Is Clocked In | - | |
Description:No description available | ||||
LaborTimeNonexistent in DB | int | Duration | - | |
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 | ||||
LastOper | bit | Is Last Oper | - | |
Description:No description available | ||||
LineCntr | int | - | ||
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 | ||||
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 | ||||
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 | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShiftCD | nvarchar(15) | Shift | EPShiftCode | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
StartTime | datetime2 | Start Time | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TranDate | datetime2 | Transaction Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Tran Description | - | |
Description:No description available | ||||
TranType | nchar(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||