Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SCV00001
Product: Manufacturing (346)
Series:
Display Name: MFG_No_Proposed_Costs_VIEW Group Display Name: Manufacturing Inventory
Physical Name: SCV00001
Technical Name: MFG_No_Proposed_Costs_VIEW
Group Technical Name: Manufacturing Inventory
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['MFG_No_Proposed_Costs_VIEW'].ITEMNMBR AS 'MFG_No_Proposed_Costs_VIEW-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SCV00001 AS ['MFG_No_Proposed_Costs_VIEW']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MFG_No_Proposed_Costs_VIEW'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
2 | ITEMDESC | Item Description | String | STR100 | 100 | |
3 | ITMCLSCD | Item Class Code | String | STR10_Class_ID | 10 | |
Key to the Item Class Setup (IV40400).
Click to show/hideSELECT
['MFG_No_Proposed_Costs_VIEW'].ITMCLSCD AS 'MFG_No_Proposed_Costs_VIEW-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
SCV00001 AS ['MFG_No_Proposed_Costs_VIEW']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['MFG_No_Proposed_Costs_VIEW'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD | ||||||
4 | MAKEBUYEITHER_I | MakeBuyEither | String | STR6 | 6 | |
5 | BUYERID | Buyer ID | String | STR15_User_ID | 15 | |
6 | PLANNERCODE_I | Planner Code | String | STR3_UC | 3 |