AM
AMDisassembleBatch
PX.Objects.AM92 of 92 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatchNbr | nvarchar(15) | Batch Nbr | AMBatch | |
Description:No description available | ||||
DocType | char(1) | Document Type | - | |
Description:No description available | ||||
AcctID | int | Account | Account | |
Description:No description available | ||||
BaseQty | decimal(25, 6) | - | ||
Description:No description available | ||||
BaseQtyScrapped | decimal(25, 6) | Base Qty Scrapped | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
Closeflg | bit | Complete | - | |
Description:No description available | ||||
ControlAmount | decimal(19, 4) | Control Amount | - | |
Description:No description available | ||||
ControlCost | decimal(19, 4) | Control Cost | - | |
Description:No description available | ||||
ControlQty | decimal(25, 6) | Control Qty. | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
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 | ||||
Date | datetime2 | Date | - | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
EditableBatchNonexistent in DB | bit | Editable Batch | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
ExtCost | decimal(19, 4) | - | ||
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
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 | ||||
Hold | bit | Hold | - | |
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 | - | |
Description:No description available | ||||
InventorySource | char(1) | - | ||
Description:No description available | ||||
InvtMult | smallint | Batch Multiplier | - | |
Description:No description available | ||||
IsByproduct | bit | By-product | - | |
Description:No description available | ||||
IsLotSerialPreassigned | bit | Lot/Serial Nbr. Preassigned | - | |
Description:No description available | ||||
IsScrap | bit | Qty is Scrap | - | |
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 | Last Oper | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineCntrAttribute | int | Line Cntr Attribute | - | |
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
LocationID | int | Location | - | |
Description:No description available | ||||
LotSerCntr | int | Lot Serial Cntr | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
MatlLineId | int | Material Line ID | - | |
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 | - | |
Description:No description available | ||||
OrigDocType | char(1) | Orig Doc Type | AMBatch | |
Description:No description available | ||||
OrigLineNbr | int | Orig Line Nbr. | - | |
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 | ||||
RefLineNbr | int | Ref Line Nbr. | - | |
Description:No description available | ||||
Released | bit | - | ||
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TaskID | int | Project Task | - | |
Description:No description available | ||||
TotalAmount | decimal(19, 4) | Total Amount | - | |
Description:No description available | ||||
TotalCost | decimal(19, 4) | Total Cost | - | |
Description:No description available | ||||
TotalQty | decimal(25, 6) | Total Qty. | - | |
Description:No description available | ||||
TranAmt | decimal(19, 4) | Ext. Cost | - | |
Description:No description available | ||||
TranBatchNbr | nvarchar(15) | - | ||
Description:No description available | ||||
TranBranchID | int | - | ||
Description:No description available | ||||
TranCreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
TranCreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
TranCreatedDateTime | datetime | - | ||
Description:No description available | ||||
TranDate | datetime2 | - | ||
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
TranDocType | char(1) | - | ||
Description:No description available | ||||
TranFinPeriodID | char(6) | - | ||
Description:No description available | ||||
TranLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
TranLastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
TranLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
TranNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
TranOrigBatNbr | nvarchar(15) | Orig Batch Nbr | - | |
Description:No description available | ||||
TranOrigDocType | char(1) | Orig Doc Type | - | |
Description:No description available | ||||
TranOverride | bit | Override | - | |
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranReleased | bit | Released | - | |
Description:No description available | ||||
TranTranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranTstamp | timestamp | - | ||
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 | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | - | |
Description:No description available | ||||
WIPAcctID | int | WIP Account | Account | |
Description:No description available | ||||
WIPSubID | int | WIP Subaccount | Sub | |
Description:No description available | ||||