Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30905
Product: Project Accounting (258)
Series: Project
Display Name: PAInventory Transaction Bin Quantities History DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: PA30905
Technical Name: PA_ivTrxBinHistSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PAIV_Document_No PA IV Document No STR17_LBAU String 17 2 PAIV_Transfer_Type PA IV Transfer Type PA_DDL_IV_Transfer_Type Integer 0 3 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 4 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 5 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['PAInventory Transaction Bin Quantities History'].ITEMNMBR AS 'PAInventory Transaction Bin Quantities History-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
PA30905 AS ['PAInventory Transaction Bin Quantities History']
INNER JOIN
IV00101 AS ['Item Master']
ON
['PAInventory Transaction Bin Quantities History'].ITEMNMBR = ['Item Master'].ITEMNMBR
6 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['PAInventory Transaction Bin Quantities History'].LOCNCODE AS 'PAInventory Transaction Bin Quantities History-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PA30905 AS ['PAInventory Transaction Bin Quantities History']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['PAInventory Transaction Bin Quantities History'].LOCNCODE = ['Site Setup'].LOCNCODE
7 BIN Bin STR15_Bin String 15 8 TOBIN To Bin STR15_Bin String 15 9 QTYTYPE QTY Type DDL_QTY_Type Integer 0 10 QTYSLCTD QTY Selected DLR17_QTY_RBS0_UTR Currency 17 11 DEX_ROW_ID int int 10