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 |