Inventory Transaction Work (IV10000)

azurecurveProductsMicrosoft Dynamics GP (0)InventoryInventory Transaction Work (IV10000)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Inventory Transaction Work
Physical Name: IV10000
Technical Name: IV_TRX_WORK_HDR

Group Display Name: Inventory Transaction Work
Group Technical Name: Inventory Transaction Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BACHNUMB SearchBatch NumberStringSTR15_LBAU15
2BCHSOURC SearchBatch SourceStringSTR1515
3IVDOCNBR SearchIV Document NumberStringSTR17_IV_Document_Number17
4RCDOCNUM SearchRecurring Document NumberStringSTR20_Document_Number20
5IVDOCTYP SearchIV Document TypeIntegerDDL_IV_Document_Type0
6DOCDATE SearchDocument DateDateDT8
7MODIFDT SearchModified DateDateDT8
8MDFUSRID SearchModified User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Inventory Transaction Work'].MDFUSRID AS 'Inventory Transaction Work-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IV10000 AS ['Inventory Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Inventory Transaction Work'].MDFUSRID = ['Users Master'].USERID
9POSTEDDT SearchPosted DateDateDATE6
10PTDUSRID SearchPosted User IDStringSTR1515
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Inventory Transaction Work'].PTDUSRID AS 'Inventory Transaction Work-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IV10000 AS ['Inventory Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Inventory Transaction Work'].PTDUSRID = ['Users Master'].USERID
11GLPOSTDT SearchGL Posting DateDateDT8
12PSTGSTUS SearchPosting StatusIntegerINT0
13TRXQTYTL SearchTRX QTY TotalCurrencyDLR17_QTY_RBS0_UTR17
14IVWHRMSG SearchIV WORK HDR MessagesLong IntegerIV_WORK_HDR_Messages0
15NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Inventory Transaction Work'].NOTEINDX AS 'Inventory Transaction Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV10000 AS ['Inventory Transaction Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Inventory Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
16SRCRFRNCNMBR SearchSource Reference NumberStringSTR3030
17SOURCEINDICATOR SearchSource IndicatorIntegerDDL_Source_Indicator0
azurecurveProductsMicrosoft Dynamics GP (0)InventoryInventory Transaction Work (IV10000)

Leave a Reply

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