AM
AMClockTran
A manufacturing clock transaction.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AllowMultiClockEntry | bit | Multiple Entries Allowed | - | |
Description:A Boolean value that indicates whether multiple clock entries are allowed. | ||||
BaseQty | decimal | Base Qty | - | |
Description:The base quantity. | ||||
BaseQtyScrapped | decimal | Base Qty Scrapped | - | |
Description:The base quantity that is scrapped. | ||||
BranchID | int | Branch | - | |
Description:The branch ID. | ||||
Closeflg | bit | Approved | - | |
Description:A Boolean value that indicates whether the clock transaction is approved. | ||||
CostCenterIDNonexistent in DB | int? | Cost Center ID | - | |
Description:Cost center from the production order | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DurationNonexistent in DB | int? | Duration | - | |
Description:The duration. | ||||
EmployeeID | int | Employee ID | AMClockItem | |
Description:The identifier of the employee for whom the labor time is recorded. | ||||
EndTime | datetime | End Time | - | |
Description:The employee’s clock-out time for the production operation. | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:The expiration date of the specified quantity of the stock item. | ||||
FinPeriodID | string | Post Period | FinPeriod | |
Description:The financial period. | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:The item being produced, which is specified in the production order. | ||||
InvtMult | smallint | Multiplier | - | |
Description:A multiplier. | ||||
IsLotSerialPreassigned | bit | Lot/Serial Nbr. Preassigned | - | |
Description:A Boolean value that indicates whether the clock transaction has preassigned lot or serial number. | ||||
IsStockItemNonexistent in DB | bool? | Is stock | - | |
Description:A Boolean value that indicates whether the clock transaction is a stock item. | ||||
LaborTime | int | Labor Time | - | |
Description:The employee clock-in time that is automatically calculated for the production order operation. | ||||
LaborTimeSeconds | int | Labor Time Seconds | - | |
Description:The labor time in seconds. | ||||
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:The last operation. | ||||
LineNbr | int | Line Nbr. | - | |
Description:The line number. | ||||
LocationID | int | Location | INLocation | |
Description:The warehouse location to which the system moves the completed items to when the last routing operation is completed. | ||||
LotSerCntr | int | LotSerCntr | - | |
Description:A lot and serial counter. | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | CostCenter | |
Description:The lot or serial number. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:The production operation for which the labor time was recorded. | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:The type of the production order for which the labor time was recorded. | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:The reference number of the production order that contains the operation for which the labor time was recorded. | ||||
ProjectID | int | Project | PMProject | |
Description:The project. | ||||
Qty | decimal | Quantity | - | |
Description:The quantity of items completed for this operation. | ||||
QtyScrapped | decimal | Qty Scrapped | - | |
Description:The scrapped quantity. | ||||
ReasonCodeID | nvarchar(20) | Reason Code | ReasonCode | |
Description:Scrap reason code selector for production transaction. Results are limited to ReasonCodeUsages.Production. | ||||
ScrapAction | int | Scrap Action | - | |
Description:Scrap action. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShiftCD | nvarchar(15) | Shift | EPShiftCode | |
Description:The shift in which the employee worked when processing the items. | ||||
SiteID | int | Warehouse | INSite | |
Description:The warehouse to which the system moves the completed items to when the last routing operation is completed. | ||||
StartTime | datetime | Start Time | - | |
Description:The selected employee’s clock-in time for the production operation. | ||||
Status | char(1) | Status | - | |
Description:The status of the clock transaction. | ||||
SubItemID | int | Subitem | INSubItem | |
Description:The subitem of the item specified in InventoryID. | ||||
TaskID | int | Project Task | PMProject | |
Description:The task. | ||||
TranDate | datetime | Transaction Date | - | |
Description:The date when the clock entry has been created. | ||||
TranDesc | nvarchar(256) | Tran Description | - | |
Description:A transaction description. | ||||
TranType | char(3) | Tran. Type | - | |
Description:The transaction type. | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:The unit of measure for the item quantity specified in Qty. | ||||
UnassignedQty | decimal | - | ||
Description:The unassigned quantity. | ||||
WcID | nvarchar(20) | Work Center | AMWC | |
Description:The work center. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||