Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PK010033
Product: Manufacturing (346)
Series:
Display Name: Picklist File Group Display Name: Manufacturing MOP
Physical Name: PK010033
Technical Name: MOP_Item_MSTR
Group Technical Name: Manufacturing MOP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | MANUFACTUREORDER_I  | Manufacture Order | String | STR30_UC | 30 | |
| 2 | SEQ_I | Seq | Long Integer | LINT_10 | 10 | |
| 3 | MANUFACTUREORDERST_I | Manufacture Order Status | Integer | DDL_WO_Status | 0 | |
| 4 | PPN_I | PPN | String | STR30_UC | 30 | |
| 5 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Picklist File'].ITEMNMBR AS 'Picklist File-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
PK010033 AS ['Picklist File']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Picklist File'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 6 | POSITION_NUMBER | Position Number | Integer | INT4_RB_U0 | 4 | |
| 7 | ROUTINGNAME_I | RoutingName | String | STR30_Item_Number | 30 | |
| 8 | RTSEQNUM_I | rtseqnum | String | STR10 | 10 | |
| 9 | MRPAMOUNT_I | MRP_Amount | Currency | DLR_14_MRP | 14 | |
| 10 | MRPAMOUNT2_I | MRP_Amount2 | Currency | DLR_14_MRP | 14 | |
| 11 | SUGGESTEDQTY_I | Suggested QTY | Currency | DLR_14_MRP | 14 | |
| 12 | MRPISSUEDATE_I | MRP_Issue Date | Date | DATE | 6 | |
| 13 | MRPISSUETIME_I | MRP_Issue Time | Time | TM | 6 | |
| 14 | ALLOCATEDATEI | Allocate_Date | Date | DATE | 6 | |
| 15 | ALLOCATETIMEI | Allocate_Time | Time | TM | 6 | |
| 16 | WCID_I | WC ID | String | STR10_Location_Code | 10 | |
| 17 | BACKFLUSHITEM_I | Backflush Item | Boolean | CB_Backflush Item | 0 | |
| 18 | ICBACKORDER_I | IC Backorder | Boolean | CB | 0 | |
| 19 | ALTERNATE_I | Alternate | Boolean | CB | 0 | |
| 20 | ALTERNATEPARTFOR_I | Alternate Part For | String | STR30_Item_Number | 30 | |
| 21 | ALT_FOR_SEQ_I | Alternate For Sequence | Long Integer | LINT_10 | 10 | |
| 22 | SUBASSEMBLY_I | Subassembly | Boolean | CB | 0 | |
| 23 | SUBASSEMBLYOF_I | Subassembly Of | String | STR30 | 30 | |
| 24 | SUBASSEMBLY_OF_SEQ | Subassembly Of Seq | Long Integer | LINT_10 | 10 | |
| 25 | BOMENGAPPROVAL_I | BOM_Eng_Approval | Boolean | CB | 0 | |
| 26 | BOMSINGLELOT_I | BOM_Single_Lot | Boolean | CB | 0 | |
| 27 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Picklist File'].LOCNCODE AS 'Picklist File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PK010033 AS ['Picklist File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Picklist File'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 28 | ALLOCATED_I | Allocated | Boolean | CB | 0 | |
| 29 | ISSUED_I | Issued | Boolean | CB | 0 | |
| 30 | FLOORSTOCK_I | Floor Stock | Boolean | CB | 0 | |
| 31 | CALCMRP_I | Calc MRP | Boolean | CB | 0 | |
| 32 | PHANTOM_I | Phantom | Boolean | CB | 0 | |
| 33 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 34 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Picklist File'].USERID AS 'Picklist File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PK010033 AS ['Picklist File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Picklist File'].USERID = ['Users Master'].USERID | ||||||
| 35 | ALLOCATEUID_I | Allocate UID | String | STR15_User_ID | 15 | |
| 36 | ISSUEDUID_I | Issued UID | String | STR15_User_ID | 15 | |
| 37 | RELIEFCOST_I | Relief Cost | Currency | DLR17_RBSO_UTR$ | 17 | |
| 38 | RETURNTOSTOCK_I | Return To Stock | Currency | DLR_14_MRP | 14 | |
| 39 | NUMBERSCRAPPED_I | Number Scrapped | Currency | DLR_14_MRP | 14 | |
| 40 | ACTUAL_CONSUMED_I | Actual Consumed | Currency | DLR_14_MRP | 14 | |
| 41 | PORDNMBR | Purchase Order Number | String | Purchase Order Number | 20 | |
| 42 | POLINE_I | PO Line Item | Integer | INT3 | 3 | |
| 43 | QTY_ALLOWED_I | QTY Allowed | Currency | DLR_14_MRP | 14 | |
| 44 | CURRENT_CONSUMED_I | Current Consumed | Currency | DLR_14_MRP | 14 | |
| 45 | CURRENT_RTS_I | Current RTS | Currency | DLR_14_MRP | 14 | |
| 46 | CURRENT_SCRAPPED_I | Current Scrapped | Currency | DLR_14_MRP | 14 | |
| 47 | OPTIONED_ITEM_I | Optioned Item | Boolean | CB | 0 | |
| 48 | MRKDNAMT | Markdown Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 49 | BOMCAT_I | BOM Cat | Integer | DDL_BOM_Cat | 0 | |
| 50 | BOMNAME_I | BOM Name | String | STR15_LBU | 15 | |
| 51 | PROMOTION_ID_I | Promotion ID | String | STR30_UC | 30 | |
| 52 | ACTUAL_CONSUMED_CHECK_I | Actual Consumed Check | Boolean | CB | 0 | |
| 53 | REQDATE | Required Date | Date | DATE_L | 0 | |
| 54 | UOFM | U Of M | String | U_Of_M | 8 | |
| 55 | ATYALLOC | QTY Allocated | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 56 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 57 | NON_INV_CRED_ACCT_IDX_I | Non Inventory Credit Account Index | Long Integer | LI_14 | 14 | |
| 58 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 59 | QTY_ISSUED_I | QTY Issued | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 60 | QTY_BACKFLUSHED_I | QTY Backflushed | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 61 | NON_INV_ITEM_DESC_I | Non Inventory Item Description | String | STR50 | 50 | |
| 62 | LINK_TO_SEQUENCE_I | Link To Sequence | Long Integer | LINT_10 | 10 | |
| 63 | FIXED_QTY_I | Fixed Quantity | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 64 | LEADTIMEOFFSET_I | Lead Time Offset | Currency | DLR_10_3 | 18 | |
| 65 | OFFSET_FROM_I | Offset From | Integer | DDL_Offset_From | 0 | |
| 66 | BOMUSERDEF1_I | BOM User Def1 | String | STR30 | 30 | |
| 67 | BOMUSERDEF2_I | BOM User Def2 | String | STR_30 | 30 | |
| 68 | EXPLODE_QTY_I | Explode Quantity | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 69 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
| 70 | BOMSEQ_I | BOM Seq | Long Integer | LINT_10 | 10 | |
| 71 | POSITION_NUMBER2 | Position Number2 | Integer | INT4_RB_U0 | 4 | |