AM
AMBatchCost
Manufacturing AM Batch cost projection of AMBatch for cost transaction data.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BatNbr | nvarchar(15) | Batch Nbr. | - | |
Description:The reference number of the transaction. | ||||
BranchID | int | Branch | - | |
Description:The branch ID. | ||||
ControlAmount | decimal | Control Amount | - | |
Description:The control amount. | ||||
ControlCost | decimal | Control Cost | - | |
Description:The control cost of the transaction. | ||||
ControlQty | decimal | Control Qty. | - | |
Description:The control quantity of the transaction. | ||||
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) | Document Type | - | |
Description:The type of the manufacturing document or transaction. | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:The financial period that corresponds to the transaction date. | ||||
Hold | bit | Hold | - | |
Description:A Boolean value that indicates whether the batch is on hold. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineCntr | int | - | ||
Description:The line counter. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigBatNbr | nvarchar(15) | Orig Batch Nbr | - | |
Description:The batch number of th original transaction. | ||||
OrigDocType | char(1) | Orig Doc Type | - | |
Description:The document type of the original transaction. | ||||
Released | bit | Released | - | |
Description:A Boolean value that indicates whether the batch is released. | ||||
Status | char(1) | Status | - | |
Description:The status of the transaction set by the system. | ||||
TotalAmount | decimal | Total Amount | - | |
Description:The total amount of the transaction. | ||||
TotalCost | decimal | Total Cost | - | |
Description:The total cost of the transaction, which the system calculates as the sum of the values in AMMTran.ExtCost. | ||||
TotalQty | decimal | Total Qty. | - | |
Description:The total quantity of the transaction, which the system calculates as the sum of the values in AMMTran.Qty. | ||||
TranDate | datetime | Date | - | |
Description:The date when the transaction was created. | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:A brief description of the transaction. | ||||
TranPeriodID | char(6) | - | ||
Description:The financial period in which the transaction amount is posted. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||