Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00111
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Site Defaults Group Display Name: Inventory Site Setup
Physical Name: IV00111
Technical Name: ivRPSiteDefaults
Group Technical Name: Inventory Site Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Site Defaults'].LOCNCODE AS 'Site Defaults-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV00111 AS ['Site Defaults']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Site Defaults'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
2 | ORDERPOLICY | Order Policy | Integer | DDL_Order_Policy | 0 | |
3 | FXDORDRQTY | Fixed Order Qty | Currency | DLR17_QTY_RBS0_UTR | 17 | |
4 | NMBROFDYS | Number of Days | Integer | INT3_U0 | 3 | |
5 | ORDRPNTQTY | Order Point Qty | Currency | DLR17_QTY_RBS0_UTR | 17 | |
6 | REPLENISHMENTMETHOD | Replenishment Method | Integer | DDL_Replenishment_Method | 0 | |
7 | PRCHSNGLDTM | Purchasing Lead Time | Currency | DLR4_U2 | 9 | |
8 | MNFCTRNGFXDLDTM | Manufacturing Fixed Lead Time | Currency | DLR4_U2 | 9 | |
9 | MNFCTRNGVRBLLDTM | Manufacturing Variable Lead Time | Currency | DLR3_U4 | 8 | |
10 | STAGINGLDTME | Staging Lead Time | Currency | DLR4_U2 | 9 | |
11 | PLNNNGTMFNCDYS | Planning Time Fence Days | Integer | INT3_U0 | 3 | |
12 | DMNDTMFNCPRDS | Demand Time Fence Periods | Integer | INT3_U0 | 3 | |
13 | BUYERID | Buyer ID | String | STR15_User_ID | 15 | |
14 | PLANNERID | Planner ID | String | STR15_User_ID | 15 | |
15 | FRCSTCNSMPTNPRD | Forecast Consumption Period | Integer | DDL_Forecast_Consumption_Period | 0 | |
16 | INCLDDINPLNNNG | Included in Planning | Boolean | CB | 0 | |
17 | CALCULATEATP | Calculate ATP | Boolean | CB | 0 | |
18 | AUTOCHKATP | Auto Check ATP | Boolean | CB | 0 | |
19 | PLNFNLPAB | Plan Final PAB | Boolean | CB | 0 | |
20 | Move_Out_Fence | Move-Out Fence | Integer | INT3_U0 | 3 |