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 KeyIntegerINT0
2USCATDSC_1 SearchUser Category Descriptions[1]StringSTR1515
3USCATDSC SearchUser Category DescriptionsSTR15String15
4USCATDSC_2 SearchUser Category Descriptions[2]StringSTR1515
5USCATDSC_3 SearchUser Category Descriptions[3]StringSTR1515
6USCATDSC_4 SearchUser Category Descriptions[4]StringSTR1515
7USCATDSC_5 SearchUser Category Descriptions[5]StringSTR1515
8USCATDSC_6 SearchUser Category Descriptions[6]StringSTR1515
9DCDCRADJ SearchDisplay Cost For Decrease AdjustmentsBooleanCB_Display_Cost0
10ACSGFLOC SearchAccount Segment For LocationsIntegerINT11
11MAINLOCN SearchMain LocationStringSTR10_Location_Code10
12DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
13DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
14NXADJDOC SearchNext Adjustment Document NumberStringSTR20_Next_Document_Number17
15TXTRDNUM SearchNext Transfer Document NumberStringSTR20_Next_Document_Number17
16NXTVDNUM SearchNext Variance Document NumberStringSTR20_Next_Document_Number17
17NXPRDNUM SearchNext Production Document NumberStringSTR20_Next_Document_Number17
18ALADJOVR SearchAllow Adjustment OverridesBooleanCB_Allow_Adjustment_Overrides0
19AVAROVRD SearchAllow Variance OverridesBooleanCB_Allow_Variance_Overrides0
20ATRSOVRD SearchAllow Transfer OverridesBooleanCB_Allow_Transfer_Overrides0
21ATPSTVRNC SearchAuto Post VarianceBooleanCB_Autopost_Variance0
22ENABLEMULTIBIN SearchEnable Multi BinBooleanCB_EnableMultiBin0
23ENPICKSHORTTSK SearchEnable Picking Shortage TasksBooleanCB_EnablePickingShortageTasks0
24USERID SearchUser IDStringSTR15_User_ID15
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 AdjustmentsBooleanCB_DisableAvgPerpetualValuationAdjustments0
26DISABLEPERPADJ SearchDisable Perpetual Valuation AdjustmentsBooleanCB_DisablePerpetualValuationAdjustments0
27ALLEXPLOTSIV SearchAllow Expired Lots IVBooleanCB_Allow_Expired_Lots_IV0
28ALLEXPLOTSIVPASS SearchAllow Expired Lots IV PasswordStringPassword10
29ALLEXPLOTSOTHER SearchAllow Expired Lots OtherBooleanCB_Allow_Expired_Lots_Other0
30ALLEXPLOTOTHERPASS SearchAllow Expired Lots Other PasswordStringPassword10
31USEEXISTINGSNLOTS SearchUse Only Existing Serials LotsBooleanCB_Use_Only_Existing_Serials_Lots0
32ASSIGNLOTNUMBY SearchAssign Lot Numbers ByIntegerCB_Assign_Lot_Numbers_By0
33NXTSPNUM SearchNext Two Step Transfer NumberStringSTR15_LBAU15
34VIALOCN SearchVia LocationStringSTR10_Location_Code10
35Next_Bin_XFer_Doc_Number SearchNext Bin Transfer Document NumberStringSTR20_Next_Bin_Transfer_Doc_Number20

Leave a Reply

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