Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IS050000
Product: Manufacturing (346)
Series:
Display Name: Order Fulfillment Setup Group Display Name: Manufacturing SOP
Physical Name: IS050000
Technical Name: IC_SOP_Order_Fulfillment_SETP
Group Technical Name: Manufacturing SOP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
2 | SOPFOB_I | SOP_FOB | String | STR15 | 15 | |
3 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['Order Fulfillment Setup'].SHIPMTHD AS 'Order Fulfillment Setup-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
IS050000 AS ['Order Fulfillment Setup']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Order Fulfillment Setup'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
4 | SETUPKEY | Setup Key | Integer | INT | 0 | |
5 | SHIPPINGUOFM_I | Shipping U Of M | Integer | DDL_Shipping_UofM | 0 | |
6 | UPSZONE | UPS Zone | String | STR3 | 3 | |
7 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Order Fulfillment Setup'].USERID AS 'Order Fulfillment Setup-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IS050000 AS ['Order Fulfillment Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Order Fulfillment Setup'].USERID = ['Users Master'].USERID | ||||||
8 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
9 | Fulfillment_History_Edit | Fulfillment History Edit | String | STR30_LBAU | 30 | |
10 | Override_Freight_Charges | Override Freight Charges | Boolean | CB | 0 | |
11 | Override_Misc_Charges | Override Misc Charges | Boolean | CB | 0 | |
12 | Print_Pack_Slip | Print Pack Slip | Boolean | CB | 0 |