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 Group Display Name: Inventory Transaction History
Physical Name: IV30200
Technical Name: IV_TRX_HIST_HDR
Group Technical Name: Inventory Transaction History
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | TRXSORCE  | TRX Source | String | STR13 | 13 | |
| 2 | IVDOCTYP | IV Document Type | Integer | DDL_IV_Document_Type | 0 | |
| 3 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 4 | DOCDATE | Document Date | Date | DT | 8 | |
| 5 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 6 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 7 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
| 8 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 9 | SRCRFRNCNMBR | Source Reference Number | String | STR30 | 30 | |
| 10 | SOURCEINDICATOR | Source Indicator | Integer | DDL_Source_Indicator | 0 | |