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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	SETUPKEY	Setup Key	INT	Integer	2	0
2	USCATDSC	User Category Descriptions	STR15	String	16	15
3	USCATDSC_1	User Category Descriptions[1]	STR15	String	16	15
4	USCATDSC_2	User Category Descriptions[2]	STR15	String	16	15
5	USCATDSC_3	User Category Descriptions[3]	STR15	String	16	15
6	USCATDSC_4	User Category Descriptions[4]	STR15	String	16	15
7	USCATDSC_5	User Category Descriptions[5]	STR15	String	16	15
8	USCATDSC_6	User Category Descriptions[6]	STR15	String	16	15
9	DCDCRADJ	Display Cost For Decrease Adjustments	CB_Display_Cost	Boolean	2	0
10	ACSGFLOC	Account Segment For Locations	INT1	Integer	2	1
11	MAINLOCN	Main Location	STR10_Location_Code	String	12	10
12	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	2	0
13	DECPLQTY	Decimal Places QTYS	DDL_Decimal_Places_QTYS	Integer	2	0
14	NXADJDOC	Next Adjustment Document Number	STR20_Next_Document_Number	String	22	17
15	TXTRDNUM	Next Transfer Document Number	STR20_Next_Document_Number	String	22	17
16	NXTVDNUM	Next Variance Document Number	STR20_Next_Document_Number	String	22	17
17	NXPRDNUM	Next Production Document Number	STR20_Next_Document_Number	String	22	17
18	ALADJOVR	Allow Adjustment Overrides	CB_Allow_Adjustment_Overrides	Boolean	2	0
19	AVAROVRD	Allow Variance Overrides	CB_Allow_Variance_Overrides	Boolean	2	0
20	ATRSOVRD	Allow Transfer Overrides	CB_Allow_Transfer_Overrides	Boolean	2	0
21	ATPSTVRNC	Auto Post Variance	CB_Autopost_Variance	Boolean	2	0
22	ENABLEMULTIBIN	Enable Multi Bin	CB_EnableMultiBin	Boolean	2	0
23	ENPICKSHORTTSK	Enable Picking Shortage Tasks	CB_EnablePickingShortageTasks	Boolean	2	0
24	USERID	User ID	STR15_User_ID	String	16	15
	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
25	DISABLEAVGPERPADJ	Disable Avg Perpetual Valuation Adjustments	CB_DisableAvgPerpetualValuationAdjustments	Boolean	2	0
26	DISABLEPERPADJ	Disable Perpetual Valuation Adjustments	CB_DisablePerpetualValuationAdjustments	Boolean	2	0
27	ALLEXPLOTSIV	Allow Expired Lots IV	CB_Allow_Expired_Lots_IV	Boolean	2	0
28	ALLEXPLOTSIVPASS	Allow Expired Lots IV Password	Password	String	12	10
29	ALLEXPLOTSOTHER	Allow Expired Lots Other	CB_Allow_Expired_Lots_Other	Boolean	2	0
30	ALLEXPLOTOTHERPASS	Allow Expired Lots Other Password	Password	String	12	10
31	USEEXISTINGSNLOTS	Use Only Existing Serials Lots	CB_Use_Only_Existing_Serials_Lots	Boolean	2	0
32	ASSIGNLOTNUMBY	Assign Lot Numbers By	CB_Assign_Lot_Numbers_By	Integer	2	0
33	NXTSPNUM	Next Two Step Transfer Number	STR15_LBAU	String	16	15
34	VIALOCN	Via Location	STR10_Location_Code	String	12	10
35	Next_Bin_XFer_Doc_Number	Next Bin Transfer Document Number	STR20_Next_Bin_Transfer_Doc_Number	String	22	20
36	DEX_ROW_ID		int	int	10	10
	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.

azurecurve Products Microsoft Dynamics GP (0)InventoryInventory Control Setup (IV40100)

Click to show/hide

Leave a Reply Cancel reply