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 TypeLength
1SETUPKEY SearchSetup KeyINTInteger0
2USCATDSC SearchUser Category DescriptionsSTR15String15
3USCATDSC_1 SearchUser Category Descriptions[1]STR15String15
4USCATDSC_2 SearchUser Category Descriptions[2]STR15String15
5USCATDSC_3 SearchUser Category Descriptions[3]STR15String15
6USCATDSC_4 SearchUser Category Descriptions[4]STR15String15
7USCATDSC_5 SearchUser Category Descriptions[5]STR15String15
8USCATDSC_6 SearchUser Category Descriptions[6]STR15String15
9DCDCRADJ SearchDisplay Cost For Decrease AdjustmentsCB_Display_CostBoolean0
10ACSGFLOC SearchAccount Segment For LocationsINT1Integer1
11MAINLOCN SearchMain LocationSTR10_Location_CodeString10
12DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
13DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
14NXADJDOC SearchNext Adjustment Document NumberSTR20_Next_Document_NumberString17
15TXTRDNUM SearchNext Transfer Document NumberSTR20_Next_Document_NumberString17
16NXTVDNUM SearchNext Variance Document NumberSTR20_Next_Document_NumberString17
17NXPRDNUM SearchNext Production Document NumberSTR20_Next_Document_NumberString17
18ALADJOVR SearchAllow Adjustment OverridesCB_Allow_Adjustment_OverridesBoolean0
19AVAROVRD SearchAllow Variance OverridesCB_Allow_Variance_OverridesBoolean0
20ATRSOVRD SearchAllow Transfer OverridesCB_Allow_Transfer_OverridesBoolean0
21ATPSTVRNC SearchAuto Post VarianceCB_Autopost_VarianceBoolean0
22ENABLEMULTIBIN SearchEnable Multi BinCB_EnableMultiBinBoolean0
23ENPICKSHORTTSK SearchEnable Picking Shortage TasksCB_EnablePickingShortageTasksBoolean0
24USERID SearchUser IDSTR15_User_IDString15
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_DisableAvgPerpetualValuationAdjustmentsBoolean0
26DISABLEPERPADJ SearchDisable Perpetual Valuation AdjustmentsCB_DisablePerpetualValuationAdjustmentsBoolean0
27ALLEXPLOTSIV SearchAllow Expired Lots IVCB_Allow_Expired_Lots_IVBoolean0
28ALLEXPLOTSIVPASS SearchAllow Expired Lots IV PasswordPasswordString10
29ALLEXPLOTSOTHER SearchAllow Expired Lots OtherCB_Allow_Expired_Lots_OtherBoolean0
30ALLEXPLOTOTHERPASS SearchAllow Expired Lots Other PasswordPasswordString10
31USEEXISTINGSNLOTS SearchUse Only Existing Serials LotsCB_Use_Only_Existing_Serials_LotsBoolean0
32ASSIGNLOTNUMBY SearchAssign Lot Numbers ByCB_Assign_Lot_Numbers_ByInteger0
33NXTSPNUM SearchNext Two Step Transfer NumberSTR15_LBAUString15
34VIALOCN SearchVia LocationSTR10_Location_CodeString10
35Next_Bin_XFer_Doc_Number SearchNext Bin Transfer Document NumberSTR20_Next_Bin_Transfer_Doc_NumberString20
36DEX_ROW_ID Searchintint10

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 *