AM
MaterialLinkedProdOrder
DAC used for the View in Prod Link Panel
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AutoBackwardReporting | bit | Automatic Backward Reporting | - | |
Description:Override Auto backward reporting value for the order. | ||||
BOMEffDate | datetime | Source Date | - | |
Description:No description available | ||||
BOMID | nvarchar(15) | BOM ID | AMBomItemActive2 | |
Description:No description available | ||||
BOMRevisionID | 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 | 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 | datetime | Constraint | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:Cost center id selected project, task and warehouse | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
CostMethod | 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 | 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 | nvarchar(256) | Order Description | - | |
Description:No description available | ||||
DetailSource | 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 | datetime | End Date | - | |
Description:No description available | ||||
EstimateID | nvarchar(15) | Estimate ID | AMEstimateItem | |
Description:No description available | ||||
EstimateRevisionID | nvarchar(10) | Estimate Revision | AMEstimateItem | |
Description:No description available | ||||
ExcludeFromMRP | bit | Exclude from MRP | - | |
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
FMLTMRPOrdorOP | bit | Use Order Start Date for MRP | - | |
Description:No description available | ||||
FMLTime | 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 | bit | Hold | - | |
Description:No description available | ||||
InventoryID | 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 | 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 | int | SO Line Nbr. | - | |
Description:No description available | ||||
OrdNbr | nvarchar(15) | SO Order Nbr. | SOOrder | |
Description:No description available | ||||
OrdTypeRef | char(2) | SO Order Type | - | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ParentLotSerialRequired | nvarchar(1) | Require Parent Lot/Serial Number | - | |
Description:Parent lot number is/isn't required for material transactions | ||||
ParentOrdID | nvarchar(19) | Parent Production Nbr. | AMProdItem | |
Description:No description available | ||||
ParentOrderType | 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 | bit | Allow Preassigning Lot/Serial Numbers | - | |
Description:Allow pre-assigning of lot/serial numbers | ||||
ProdDate | datetime | Order Date | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | Contact | |
Description:No description available | ||||
ProductOrdID | nvarchar(19) | Product Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProductOrderType | char(2) | Product Order Type | AMOrderType | |
Description:No description available | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:Selected Project fot the Production Order | ||||
QtyComplete | decimal | Qty. Complete | - | |
Description:No description available | ||||
QtyRemainingNonexistent in DB | decimal? | Qty. Remaining | - | |
Description:Quantity remaining to be completed on the production order | ||||
QtyScrapped | decimal | Qty. Scrapped | - | |
Description:No description available | ||||
QtytoProd | 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 | smallint | Dispatch Priority | - | |
Description:Scheduling/dispatch priority from 1 (high) to 10 (low) | ||||
ScheduleStatus | char(1) | Schedule Status | - | |
Description:No description available | ||||
SchedulingMethod | char(1) | Scheduling Method | - | |
Description:No description available | ||||
ScrapLocationID | int | Scrap Location | INLocation | |
Description:No description available | ||||
ScrapOverride | bit | Scrap Override | - | |
Description:No description available | ||||
ScrapSiteID | int | Scrap Warehouse | INSite | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SourceOrderType | char(2) | Source Order Type | AMOrderType | |
Description:No description available | ||||
SourceProductionNbr | nvarchar(19) | Source Production Nbr | AMProdItem | |
Description:No description available | ||||
SplitLineCntr | int | - | ||
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
StatusID | char(1) | Status | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
SupplyType | int | Supply Type | - | |
Description:No description available | ||||
TaskID | 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 | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnassignedQty | decimal | - | ||
Description:No description available | ||||
UpdateProject | bit | Update Project | - | |
Description:No description available | ||||
WIPAcctID | 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 | int | WIP Subaccount | Sub | |
Description:No description available | ||||
WIPTotal | decimal | WIP Total | - | |
Description:No description available | ||||
WIPVarianceAcctID | int | WIP Variance Account | Account | |
Description:No description available | ||||
WIPVarianceSubID | int | WIP Variance Subaccount | Sub | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||