AM
AMTranCost
Manufacturing AM Transaction cost projection of AMMTran for cost transaction data.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctID | int | Account | Account | |
Description:No description available | ||||
BaseQty | decimal | Base Qty | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal | Base Qty Scrapped | - | |
Description:No description available | ||||
BatNbr | nvarchar(15) | Batch Nbr. | AMBatchCost | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:Cost Code assigned from the Production Order | ||||
CostRefNoteID | uniqueidentifier | Cost Ref Note ID | - | |
Description:Link back to source production cost entry by NoteID. This should be the same source as ReferenceCostID. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DocType | char(1) | AMBatchCost | ||
Description:No description available | ||||
EmployeeID | int | Employee ID | EPEmployee | |
Description:No description available | ||||
ExtCost | decimal | Labor Amount | - | |
Description:No description available | ||||
FinPeriodID | string? | - | ||
Description:No description available | ||||
GLBatNbr | nvarchar(15) | GL Batch Nbr | Batch | |
Description:Reference to journal transaction field GLTran.BatchNbr | ||||
GLLineNbr | int | GL Batch Line Nbr | - | |
Description:Reference to journal transaction field GLTran.LineNbr | ||||
GLModule | char(2) | GL Module | - | |
Description:Reference to journal transaction field GLTran.Module | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:The source of material for a transaction line. | ||||
InvtMult | smallint | Multiplier | - | |
Description:No description available | ||||
IsGLEntryNonexistent in DB | bool? | Is GL Entry | - | |
Description:Does the cost entry require a journal transaction. | ||||
IsWIPDebitNonexistent in DB | bool? | WIP Is Debit | - | |
Description:If IsGLEntry, then is the WIP entry debit (true) or credit (false). | ||||
LaborCodeID | nvarchar(15) | Labor Code | - | |
Description:No description available | ||||
LaborTime | int | Labor Time | - | |
Description:No description available | ||||
LaborTimeRawNonexistent in DB | int? | - | ||
Description:No description available | ||||
LaborType | char(1) | Labor Type | - | |
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 | ||||
LineNbr | int | Line 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 | - | |
Description:No description available | ||||
OrigBatNbr | nvarchar(15) | Orig Batch Nbr | - | |
Description:No description available | ||||
OrigDocType | char(1) | Orig Doc Type | - | |
Description:No description available | ||||
OrigLineNbr | int | Orig Line Nbr. | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:Project linked to the production order AMProdItem.ProjectID | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
QtyScrapped | decimal | Qty Scrapped | - | |
Description:No description available | ||||
ReasonCodeID | nvarchar(20) | Reason Code | - | |
Description:Scrap reason code selector for production transaction. Results are limited to ReasonCodeUsages.Production. | ||||
ReferenceCostID | nvarchar(30) | Ref. Cost ID | - | |
Description:Cost ID value such as Tool ID, Overhead ID, Machine ID, etc. | ||||
Released | bit | Released | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TaskID | int | Project Task | PMProject | |
Description:Task linked to the production order AMProdItem.TaskID | ||||
TranAmt | decimal | Ext. Cost | - | |
Description:No description available | ||||
TranDate | datetime | Tran. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Tran Description | - | |
Description:No description available | ||||
TranOverride | bit | Override | - | |
Description:No description available | ||||
TranPeriodID | string? | - | ||
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
WIPAcctID | int | WIP Account | - | |
Description:No description available | ||||
WIPSubID | int | WIP Subaccount | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||