AM
AMTranCost
PX.Objects.AM55 of 55 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatNbr | nvarchar(15) | Batch Nbr. | AMBatchCost | |
Description:No description available | ||||
DocType | char(1) | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | Base Qty | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal(25, 6) | Base Qty Scrapped | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
CostRefNoteID | uniqueidentifier | Cost Ref Note ID | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
EmployeeID | int | Employee ID | Vendor | |
Description:No description available | ||||
ExtCost | decimal(19, 4) | Labor Amount | - | |
Description:No description available | ||||
FinPeriodID | char(6) | - | ||
Description:No description available | ||||
GLBatNbr | nvarchar(15) | GL Batch Nbr | Batch | |
Description:No description available | ||||
GLLineNbr | int | GL Batch Line Nbr | - | |
Description:No description available | ||||
GLModule | char(2) | GL Module | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
InventorySource | char(1) | Inventory Source | - | |
Description:No description available | ||||
InvtMult | smallint | Multiplier | - | |
Description:No description available | ||||
IsGLEntry | bit | Is GL Entry | - | |
Description:No description available | ||||
IsWIPDebit | bit | WIP Is Debit | - | |
Description:No description available | ||||
LaborCodeID | nvarchar(15) | Labor Code | AMLaborCode | |
Description:No description available | ||||
LaborTime | int | Labor Time | - | |
Description:No description available | ||||
LaborTimeRawNonexistent in DB | int | LaborTimeRaw | - | |
Description:No description available | ||||
LaborType | char(1) | Labor Type | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
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 | ||||
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 | AMBatch | |
Description:No description available | ||||
OrigDocType | char(1) | Orig Doc Type | - | |
Description:No description available | ||||
OrigLineNbr | int | Orig Line Nbr. | AMMTran | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:No description available | ||||
Qty | decimal(25, 6) | Quantity | - | |
Description:No description available | ||||
QtyScrapped | decimal(25, 6) | Qty Scrapped | - | |
Description:No description available | ||||
ReasonCodeID | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
ReferenceCostID | nvarchar(30) | Ref. Cost ID | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TaskID | int | Project Task | - | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | Ext. Cost | - | |
Description:No description available | ||||
TranDate | datetime2 | Tran. Date | - | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Tran Description | - | |
Description:No description available | ||||
TranOverride | bit | Override | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranType | nchar(3) | Tran. Type | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
WIPAcctID | int | WIP Account | Account | |
Description:No description available | ||||
WIPSubID | int | WIP Subaccount | Sub | |
Description:No description available | ||||