Inventory Transaction History Detail (SEE30303)

azurecurveProductsHITB Report (5597)InventoryInventory Transaction History Detail (SEE30303)

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: ivHITBDetail

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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'].ITEMNMBR
2SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
3DOCDATE SearchDocument DateDateDT8
4GLPOSTDT SearchGL Posting DateDateDT8
5DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
6DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
7LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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'].LOCNCODE
8RCPTNMBR SearchReceipt NumberStringSTR20_Document_Number20
9RCTSEQNM SearchReceipt SEQ NumberLong Integerlong8
10PCHSRCTY SearchPurchase Receipt TypeIntegerDDL_Purchase_Receipt_Type0
11QTYTYPE SearchQTY TypeIntegerDDL_QTY_Type0
12UOFM SearchU Of MStringU_Of_M8
13TRXQTYInBase SearchTRX QTY In BaseCurrencyDLR17_QTY_RBS0_STR17
14TRXQTY SearchTRX QTYCurrencyDLR17_QTY_RBS0_STR17
15VARIANCEQTY SearchVariance QtyCurrencyDLR17_QTY_RBS0_STR17
16UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
17EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
18DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
19DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
20IsOverrideReceipt SearchIsOverrideReceiptBooleanBoolean0
21IsOverrideRelieved SearchIsOverrideRelievedBooleanBoolean0
22OverrideRelievedDate SearchOverrideRelievedDateDateDT8
23RCPTNMBR1 SearchOriginating Revalued Receipt NumberStringSTR20_Document_Number20
24HSTMODUL SearchHistory ModuleStringSTR33
25ORTRXSRC SearchOriginating TRX SourceStringSTR1313
26LNSEQNBR SearchLine SEQ NumberCurrencySequence_Number19
27LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
28CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
29SRCRFRNCNMBR SearchSource Reference NumberStringSTR3030
30VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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'].VENDORID
31PONUMBER SearchPO NumberStringSTR17_POP_Number17
32TRXREFERENCE SearchTransaction ReferenceIntegerTransaction Reference0
33VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
34IVIVINDX SearchIV IV IndexLong IntegerLI_1414
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'].ACTINDX
35IVIVOFIX SearchIV IV Offset IndexLong IntegerLI_1414
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'].ACTINDX
36JRNENTRY SearchJournal EntryLong IntegerLI8_U08
37TRXSORCE SearchTRX SourceStringSTR1313
38DEBITAMT SearchDebit AmountCurrencyDLR19_$S219
39CRDTAMNT SearchCredit AmountCurrencyDLR19_$S219
40DATE1 SearchDateDateDT66
41TIME1 SearchTimeTimeTM66
azurecurveProductsHITB Report (5597)InventoryInventory Transaction History Detail (SEE30303)

Leave a Reply

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