Reason Codes Setup (IV40300)

Easily find this page again using the shortlink:

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Reason Codes Setup
Physical Name: IV40300
Technical Name: IV_Reason_Code_SETP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Reason_Code SearchReason CodeSTR15_LBAUString15
2Reason_Code_Description SearchReason Code DescriptionSTR30String30
3INACTIVE SearchInactiveCB_InactiveBoolean0
4Types_of_Adj_Var SearchTypes of Adjustments/VariancesDDL_Types_of_Adj_VarInteger0
5Adjustment SearchAdjustmentCB_AdjustmentBoolean0
6Variance SearchVarianceCB_VarianceBoolean0
7OFFINDX SearchOffset Account IndexLI_14Long Integer14
8Item_Transfer SearchItem TransferCB_Item_TransferBoolean0
9InTransit_Transfer SearchIn-Transit TransferCB_In-Transit_TransferBoolean0
10Item_Bin_Transfer SearchItem Bin TransferCB_Item_Bin_TransferBoolean0
11NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

       ['Reason Codes Setup'].NOTEINDX AS 'Reason Codes Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
       IV40300 AS ['Reason Codes Setup']
       SY03900 AS ['Record Notes Master']
                     ['Reason Codes Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
12CREATDDT SearchCreated DateDTDate8
13DEX_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 *