AM
AMMTran
PX.Objects.AM89 of 89 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatNbr | nvarchar(15) | Batch Nbr. | AMBatch | |
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 | Branch | |
Description:No description available | ||||
Closeflg | bit | Complete | - | |
Description:No description available | ||||
CostCenterID | int | INLotSerialStatusByCostCenter | ||
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 | Users | |
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 | ||||
EndTime | datetime2 | End Time | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
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 | ||||
HasReferenceNonexistent in DB | bit | - | ||
Description:No description available | ||||
INBatNbr | nvarchar(15) | IN Ref Nbr | INRegister | |
Description:No description available | ||||
INDocType | char(1) | IN Doc Type | - | |
Description:No description available | ||||
INLineNbr | int | IN Line Nbr | INTran | |
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 | ||||
IsByproduct | bit | By-product | - | |
Description:No description available | ||||
IsGLEntry | bit | Is GL Entry | - | |
Description:No description available | ||||
IsLotSerialPreassigned | bit | Lot/Serial Nbr. Preassigned | - | |
Description:No description available | ||||
IsScrap | bit | Qty is Scrap | - | |
Description:No description available | ||||
IsSplitUnitCost | bit | Is Split Unit Cost | - | |
Description:No description available | ||||
IsWIPDebit | bit | WIP Is Debit | - | |
Description:No description available | ||||
LaborCodeID | nvarchar(15) | Labor Code | AMLaborCode | |
Description:No description available | ||||
LaborRate | decimal(19, 4) | Labor Rate | - | |
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 | 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 | ||||
LineCntrAttribute | int | LineCntrAttribute | - | |
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 ID | 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 | ||||
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 | ||||
ParentLotSerialNbr | nvarchar(100) | Parent Lot/Serial Nbr. | - | |
Description:No description available | ||||
POReceiptLineNbr | int | - | ||
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt 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 | ||||
QtyScrapped | decimal(25, 6) | Qty Scrapped | - | |
Description:No description available | ||||
ReasonCodeID | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
ReceiptNbr | nvarchar(15) | Receipt Nbr. | - | |
Description:No description available | ||||
ReferenceCostID | nvarchar(30) | Ref. Cost ID | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ScrapAction | int | Scrap Action | - | |
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 | ||||
SubcontractSource | int | Subcontract Source | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TimeCardStatus | int | Time Card Status | - | |
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 | ||||
TranTypeChangedNonexistent in DB | bit | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnassignedQty | decimal(25, 6) | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
WIPAcctID | int | WIP Account | Account | |
Description:No description available | ||||
WIPSubID | int | WIP Subaccount | Sub | |
Description:No description available | ||||