Inventory Control Setup (IV40100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV40100

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Inventory Control Setup
Physical Name: IV40100
Technical Name: IV_SETP

Group Display Name: Inventory Control
Group Technical Name: Inventory Control

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SETUPKEY SearchSetup KeyINTInteger20
2USCATDSC SearchUser Category DescriptionsSTR15String1615
3USCATDSC_1 SearchUser Category Descriptions[1]STR15String1615
4USCATDSC_2 SearchUser Category Descriptions[2]STR15String1615
5USCATDSC_3 SearchUser Category Descriptions[3]STR15String1615
6USCATDSC_4 SearchUser Category Descriptions[4]STR15String1615
7USCATDSC_5 SearchUser Category Descriptions[5]STR15String1615
8USCATDSC_6 SearchUser Category Descriptions[6]STR15String1615
9DCDCRADJ SearchDisplay Cost For Decrease AdjustmentsCB_Display_CostBoolean20
10ACSGFLOC SearchAccount Segment For LocationsINT1Integer21
11MAINLOCN SearchMain LocationSTR10_Location_CodeString1210
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
13DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
14NXADJDOC SearchNext Adjustment Document NumberSTR20_Next_Document_NumberString2217
15TXTRDNUM SearchNext Transfer Document NumberSTR20_Next_Document_NumberString2217
16NXTVDNUM SearchNext Variance Document NumberSTR20_Next_Document_NumberString2217
17NXPRDNUM SearchNext Production Document NumberSTR20_Next_Document_NumberString2217
18ALADJOVR SearchAllow Adjustment OverridesCB_Allow_Adjustment_OverridesBoolean20
19AVAROVRD SearchAllow Variance OverridesCB_Allow_Variance_OverridesBoolean20
20ATRSOVRD SearchAllow Transfer OverridesCB_Allow_Transfer_OverridesBoolean20
21ATPSTVRNC SearchAuto Post VarianceCB_Autopost_VarianceBoolean20
22ENABLEMULTIBIN SearchEnable Multi BinCB_EnableMultiBinBoolean20
23ENPICKSHORTTSK SearchEnable Picking Shortage TasksCB_EnablePickingShortageTasksBoolean20
24USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Inventory Control Setup'].USERID AS 'Inventory Control Setup-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IV40100 AS ['Inventory Control Setup']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Inventory Control Setup'].USERID = ['Users Master'].USERID
25DISABLEAVGPERPADJ SearchDisable Avg Perpetual Valuation AdjustmentsCB_DisableAvgPerpetualValuationAdjustmentsBoolean20
26DISABLEPERPADJ SearchDisable Perpetual Valuation AdjustmentsCB_DisablePerpetualValuationAdjustmentsBoolean20
27ALLEXPLOTSIV SearchAllow Expired Lots IVCB_Allow_Expired_Lots_IVBoolean20
28ALLEXPLOTSIVPASS SearchAllow Expired Lots IV PasswordPasswordString1210
29ALLEXPLOTSOTHER SearchAllow Expired Lots OtherCB_Allow_Expired_Lots_OtherBoolean20
30ALLEXPLOTOTHERPASS SearchAllow Expired Lots Other PasswordPasswordString1210
31USEEXISTINGSNLOTS SearchUse Only Existing Serials LotsCB_Use_Only_Existing_Serials_LotsBoolean20
32ASSIGNLOTNUMBY SearchAssign Lot Numbers ByCB_Assign_Lot_Numbers_ByInteger20
33NXTSPNUM SearchNext Two Step Transfer NumberSTR15_LBAUString1615
34VIALOCN SearchVia LocationSTR10_Location_CodeString1210
35Next_Bin_XFer_Doc_Number SearchNext Bin Transfer Document NumberSTR20_Next_Bin_Transfer_Doc_NumberString2220
36DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *