Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SEE30303
Product: HITB Report (5597)
Series:
Display Name: Inventory Transaction History Detail
Physical Name: SEE30303
Technical Name: ivHITBDetailSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR 
Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Inventory Transaction History Detail'].ITEMNMBR AS 'Inventory Transaction History Detail-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SEE30303 AS ['Inventory Transaction History Detail']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Inventory Transaction History Detail'].ITEMNMBR = ['Item Master'].ITEMNMBR2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 DOCDATE Document Date Date DT 8 4 GLPOSTDT GL Posting Date Date DT 8 5 DOCNUMBR Document Number String STR20_Document_Number 20 6 DOCTYPE Document Type Integer DDL_Document_Type 0 7 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Inventory Transaction History Detail'].LOCNCODE AS 'Inventory Transaction History Detail-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SEE30303 AS ['Inventory Transaction History Detail']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Inventory Transaction History Detail'].LOCNCODE = ['Site Setup'].LOCNCODE8 RCPTNMBR Receipt Number String STR20_Document_Number 20 9 RCTSEQNM Receipt SEQ Number Long Integer long 8 10 PCHSRCTY Purchase Receipt Type Integer DDL_Purchase_Receipt_Type 0 11 QTYTYPE QTY Type Integer DDL_QTY_Type 0 12 UOFM U Of M String U_Of_M 8 13 TRXQTYInBase TRX QTY In Base Currency DLR17_QTY_RBS0_STR 17 14 TRXQTY TRX QTY Currency DLR17_QTY_RBS0_STR 17 15 VARIANCEQTY Variance Qty Currency DLR17_QTY_RBS0_STR 17 16 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 17 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 18 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 19 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 20 IsOverrideReceipt IsOverrideReceipt Boolean Boolean 0 21 IsOverrideRelieved IsOverrideRelieved Boolean Boolean 0 22 OverrideRelievedDate OverrideRelievedDate Date DT 8 23 RCPTNMBR1 Originating Revalued Receipt Number String STR20_Document_Number 20 24 HSTMODUL History Module String STR3 3 25 ORTRXSRC Originating TRX Source String STR13 13 26 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 27 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 28 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10 29 SRCRFRNCNMBR Source Reference Number String STR30 30 30 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Inventory Transaction History Detail'].VENDORID AS 'Inventory Transaction History Detail-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SEE30303 AS ['Inventory Transaction History Detail']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Inventory Transaction History Detail'].VENDORID = ['PM Vendor Master File'].VENDORID31 PONUMBER PO Number String STR17_POP_Number 17 32 TRXREFERENCE Transaction Reference Integer Transaction Reference 0 33 VCTNMTHD Valuation Method Integer DDL_Valuation_Method 0 34 IVIVINDX IV IV Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Inventory Transaction History Detail'].IVIVINDX AS 'Inventory Transaction History Detail-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
SEE30303 AS ['Inventory Transaction History Detail']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Inventory Transaction History Detail'].IVIVINDX = ['Account Index Master'].ACTINDX35 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Inventory Transaction History Detail'].IVIVOFIX AS 'Inventory Transaction History Detail-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
SEE30303 AS ['Inventory Transaction History Detail']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Inventory Transaction History Detail'].IVIVOFIX = ['Account Index Master'].ACTINDX36 JRNENTRY Journal Entry Long Integer LI8_U0 8 37 TRXSORCE TRX Source String STR13 13 38 DEBITAMT Debit Amount Currency DLR19_$S2 19 39 CRDTAMNT Credit Amount Currency DLR19_$S2 19 40 DATE1 Date Date DT6 6 41 TIME1 Time Time TM6 6