Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV40300
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Reason Codes Setup
Physical Name: IV40300
Technical Name: IV_Reason_Code_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Reason_Code 
Reason Code String STR15_LBAU 15 2 Reason_Code_Description Reason Code Description String STR30 30 3 INACTIVE Inactive Boolean CB_Inactive 0 4 Types_of_Adj_Var Types of Adjustments/Variances Integer DDL_Types_of_Adj_Var 0 5 Adjustment Adjustment Boolean CB_Adjustment 0 6 Variance Variance Boolean CB_Variance 0 7 OFFINDX Offset Account Index Long Integer LI_14 14 8 Item_Transfer Item Transfer Boolean CB_Item_Transfer 0 9 InTransit_Transfer In-Transit Transfer Boolean CB_In-Transit_Transfer 0 10 Item_Bin_Transfer Item Bin Transfer Boolean CB_Item_Bin_Transfer 0 11 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Reason Codes Setup'].NOTEINDX AS 'Reason Codes Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
IV40300 AS ['Reason Codes Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Reason Codes Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX12 CREATDDT Created Date Date DT 8