Inventory Transaction History (IV30200)

azurecurveProductsMicrosoft Dynamics GP (0)InventoryInventory Transaction History (IV30200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV30200

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Inventory Transaction History
Physical Name: IV30200
Technical Name: IV_TRX_HIST_HDR

Group Display Name: Inventory Transaction History
Group Technical Name: Inventory Transaction History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1TRXSORCE SearchTRX SourceStringSTR1313
2IVDOCTYP SearchIV Document TypeIntegerDDL_IV_Document_Type0
3DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
4DOCDATE SearchDocument DateDateDT8
5BCHSOURC SearchBatch SourceStringSTR1515
6BACHNUMB SearchBatch NumberStringSTR15_LBAU15
7NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Inventory Transaction History'].NOTEINDX AS 'Inventory Transaction History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV30200 AS ['Inventory Transaction History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Inventory Transaction History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
8GLPOSTDT SearchGL Posting DateDateDT8
9SRCRFRNCNMBR SearchSource Reference NumberStringSTR3030
10SOURCEINDICATOR SearchSource IndicatorIntegerDDL_Source_Indicator0
azurecurveProductsMicrosoft Dynamics GP (0)InventoryInventory Transaction History (IV30200)

Leave a Reply

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