Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV30300
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Inventory Transaction Amounts History Group Display Name: Inventory Transaction History
Physical Name: IV30300
Technical Name: IV_TRX_HIST_LINE
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 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
| 3 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 4 | DOCDATE | Document Date | Date | DT | 8 | |
| 5 | HSTMODUL | History Module | String | STR3 | 3 | |
| 6 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['Inventory Transaction Amounts History'].CUSTNMBR AS 'Inventory Transaction Amounts History-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
IV30300 AS ['Inventory Transaction Amounts History']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Inventory Transaction Amounts History'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 7 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Inventory Transaction Amounts History'].ITEMNMBR AS 'Inventory Transaction Amounts History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IV30300 AS ['Inventory Transaction Amounts History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Inventory Transaction Amounts History'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 8 | LNSEQNBR | Line SEQ Number | Currency | Sequence_Number | 19 | |
| 9 | UOFM | U Of M | String | U_Of_M | 8 | |
| The unit of measure. The value in this field must exist in Inventory. | ||||||
| 10 | TRXQTY | TRX QTY | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 11 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 12 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 13 | TRXLOCTN | TRX Location | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Inventory Transaction Amounts History'].TRXLOCTN AS 'Inventory Transaction Amounts History-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV30300 AS ['Inventory Transaction Amounts History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Inventory Transaction Amounts History'].TRXLOCTN = ['Site Setup'].LOCNCODE | ||||||
| 14 | TRNSTLOC | Transfer To Location | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Inventory Transaction Amounts History'].TRNSTLOC AS 'Inventory Transaction Amounts History-Transfer To Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV30300 AS ['Inventory Transaction Amounts History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Inventory Transaction Amounts History'].TRNSTLOC = ['Site Setup'].LOCNCODE | ||||||
| 15 | TRFQTYTY | Transfer From QTY Type | Integer | DDL_QTY_Type | 0 | |
| 16 | TRTQTYTY | Transfer To QTY Type | Integer | DDL_QTY_Type | 0 | |
| 17 | IVIVINDX | IV IV Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Inventory Transaction Amounts History'].IVIVINDX AS 'Inventory Transaction Amounts History-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IV30300 AS ['Inventory Transaction Amounts History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Inventory Transaction Amounts History'].IVIVINDX = ['Account Index Master'].ACTINDX | ||||||
| 18 | IVIVOFIX | IV IV Offset Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Inventory Transaction Amounts History'].IVIVOFIX AS 'Inventory Transaction Amounts History-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
IV30300 AS ['Inventory Transaction Amounts History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Inventory Transaction Amounts History'].IVIVOFIX = ['Account Index Master'].ACTINDX | ||||||
| 19 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
| 20 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
| 21 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 | |
| 22 | Reason_Code | Reason Code | String | STR15_LBAU | 15 | |