AM
AMProdItem
Master table for a production order.
View API Entity: ProductionOrder
/entity/MANUFACTURING/25.100.001/ProductionOrder| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AutoBackwardReporting API | bit | Automatic Backward Reporting | - | |
Description:Override Auto backward reporting value for the order. | ||||
BOMEffDate API | datetime | Source Date | - | |
Description:No description available | ||||
BOMID API | nvarchar(15) | BOM ID | AMBomItemActive2 | |
Description:No description available | ||||
BOMRevisionID API | nvarchar(10) | BOM Revision | AMBomItem | |
Description:No description available | ||||
BaseQtyComplete | decimal | Base Qty Complete | - | |
Description:No description available | ||||
BaseQtyRemainingNonexistent in DB | decimal? | Base Qty Remaining | - | |
Description:No description available | ||||
BaseQtyScrapped | decimal | - | ||
Description:No description available | ||||
BaseQtytoProd | decimal | Base Qty to Produce | - | |
Description:No description available | ||||
BranchID API | int | Branch | - | |
Description:No description available | ||||
BuildProductionBomNonexistent in DB | bool? | - | ||
Description:No description available | ||||
Canceled | bit | Canceled | - | |
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
ConstDate API | datetime | Constraint | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:Cost center id selected project, task and warehouse | ||||
CostCodeID API | int | Cost Code | - | |
Description:No description available | ||||
CostMethod API | int | Costing Method | - | |
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 | ||||
CustomerID API | int | Customer | BAccount | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
DemandPlanID | bigint | Demand Plan ID | - | |
Description:No description available | ||||
Descr API | nvarchar(256) | Order Description | - | |
Description:No description available | ||||
DetailSource API | int | Source | - | |
Description:Indicates where the production detail source comes from. | ||||
DueDate | datetime | Due Date | - | |
Description:Date production order is due. Date comes from a linked order. | ||||
DueDateDiff | int | Due Date Diff. | - | |
Description:The difference in days from DueDate and EndDate. | ||||
EndDate API | datetime | End Date | - | |
Description:No description available | ||||
EstimateID API | nvarchar(15) | Estimate ID | AMEstimateItem | |
Description:No description available | ||||
EstimateRevisionID API | nvarchar(10) | Estimate Revision | AMEstimateItem | |
Description:No description available | ||||
ExcludeFromMRP API | bit | Exclude from MRP | - | |
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
FMLTMRPOrdorOP API | bit | Use Order Start Date for MRP | - | |
Description:No description available | ||||
FMLTime API | bit | Use Fixed Mfg Lead Times for Order Dates | - | |
Description:No description available | ||||
FirmSchedule | bit | Firm Schedule | - | |
Description:No description available | ||||
FirstOperationID | int | First Operation ID | AMProdOper | |
Description:No description available | ||||
Function | int | Function | - | |
Description:No description available | ||||
HasTransactions | bit | HasTransactions | - | |
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsConfigurableNonexistent in DB | bool? | Is Configurable | - | |
Description:Indicates whether it's possible to configure this production item. | ||||
IsOnTimeOverhead | bit | On-Time Overhead | - | |
Description:When is the overhead posted to the production order. When false, it is the old way of posting all overheads until the move transaction is posted. When true and using new release process (AMPSetup.UseNewReleaseProcess), overheads based on labor or material will post at the time of the transaction and not wait until the move. | ||||
IsOpen | bit | IsOpen | - | |
Description:No description available | ||||
IsProcessMFG | bit | Process Manufacturing | - | |
Description:Is the document linked to the Process Manufacturing feature. | ||||
IsReportPrinted | bit | Report Printed | - | |
Description:Indicates if the current production order report has been printed. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastOperationID | int | Last Operation ID | AMProdOper | |
Description:No description available | ||||
LineCntrAttribute | int | - | ||
Description:No description available | ||||
LineCntrEvnt | int | Event Line Cntr | - | |
Description:No description available | ||||
LineCntrOperation | int | Operation Line Cntr | - | |
Description:No description available | ||||
LineQtyAvailNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
LineQtyHardAvailNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
LocationID API | int | Location | INLocation | |
Description:No description available | ||||
Locked | bit | Locked | - | |
Description:Production Order Locked Status | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrdLineRef API | int | SO Line Nbr. | - | |
Description:No description available | ||||
OrdNbr API | nvarchar(15) | SO Order Nbr. | SOOrder | |
Description:No description available | ||||
OrdTypeRef API | char(2) | SO Order Type | - | |
Description:No description available | ||||
OrderType API | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ParentLotSerialRequired API | nvarchar(1) | Require Parent Lot/Serial Number | - | |
Description:Parent lot number is/isn't required for material transactions | ||||
ParentOrdID API | nvarchar(19) | Parent Production Nbr. | AMProdItem | |
Description:No description available | ||||
ParentOrderType API | char(2) | Parent Order Type | AMOrderType | |
Description:No description available | ||||
PerClose | char(6) | Period Closed | - | |
Description:No description available | ||||
PerEnt | string | Entered Period | - | |
Description:No description available | ||||
PreassignLotSerial API | bit | Allow Preassigning Lot/Serial Numbers | - | |
Description:Allow pre-assigning of lot/serial numbers | ||||
ProdDate API | datetime | Order Date | - | |
Description:No description available | ||||
ProdOrdID API | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProductManagerID API | int | Product Manager | Contact | |
Description:No description available | ||||
ProductOrdID API | nvarchar(19) | Product Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProductOrderType API | char(2) | Product Order Type | AMOrderType | |
Description:No description available | ||||
ProductWorkgroupID API | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProjectID API | int | Project | - | |
Description:Selected Project fot the Production Order | ||||
QtyComplete API | decimal | Qty. Complete | - | |
Description:No description available | ||||
decimal? | Qty. Remaining | - | ||
Description:Quantity remaining to be completed on the production order | ||||
QtyScrapped API | decimal | Qty. Scrapped | - | |
Description:No description available | ||||
QtytoProd API | decimal | Qty. to Produce | - | |
Description:No description available | ||||
RelDate | datetime | Release Date | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
RescheduleNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SchPriority API | smallint | Dispatch Priority | - | |
Description:Scheduling/dispatch priority from 1 (high) to 10 (low) | ||||
ScheduleStatus API | char(1) | Schedule Status | - | |
Description:No description available | ||||
SchedulingMethod API | char(1) | Scheduling Method | - | |
Description:No description available | ||||
ScrapLocationID API | int | Scrap Location | INLocation | |
Description:No description available | ||||
ScrapOverride API | bit | Scrap Override | - | |
Description:No description available | ||||
ScrapSiteID API | int | Scrap Warehouse | INSite | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SourceOrderType API | char(2) | Source Order Type | AMOrderType | |
Description:No description available | ||||
SourceProductionNbr API | nvarchar(19) | Source Production Nbr | AMProdItem | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
StartDate API | datetime | Start Date | - | |
Description:No description available | ||||
StatusID API | char(1) | Status | - | |
Description:No description available | ||||
SubItemID API | int | Subitem | INSubItem | |
Description:No description available | ||||
SupplyType | int | Supply Type | - | |
Description:No description available | ||||
TaskID API | int | Project Task | - | |
Description:No description available | ||||
TranDateNonexistent in DB | DateTime? | Tran. Date | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
UOM API | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UpdateProject API | bit | Update Project | - | |
Description:No description available | ||||
WIPAcctID API | int | WIP Account | Account | |
Description:No description available | ||||
WIPBalanceNonexistent in DB | decimal? | WIP Balance | - | |
Description:No description available | ||||
WIPComp | decimal | MFG to Inventory | - | |
Description:No description available | ||||
WIPSubID API | int | WIP Subaccount | Sub | |
Description:No description available | ||||
WIPTotal | decimal | WIP Total | - | |
Description:No description available | ||||
WIPVarianceAcctID API | int | WIP Variance Account | Account | |
Description:No description available | ||||
WIPVarianceSubID API | int | WIP Variance Subaccount | Sub | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||