4 Replies Latest reply: Oct 28, 2010 6:00 AM by ErikYkema RSS

    Issued Quantity in RDW

    DexterC
      Hi All,

      Am new to RDW, we have a metric requiring Issued Quantity of Stock from Warehouse to Store.
      Is there any field avaialble in RDW for the same ? I could only find reserved Quantity field in INV_DEPT_LD_DM.F_I_ALLOC_RSV_QTY after serahcing the Data model guide.But as per functional definiation to the same, reserved quantity is not always the same as Issued Quantity.

      So how does this field(Issued Quanityt) gets trapped in RDW or how can i derive the Issued Quantity for Stocks from Warehouse to Store if its not available.

      Thanks for your help !

      Dhrubo
        • 1. Re: Issued Quantity in RDW
          ErikYkema
          You may find what you need in inv_tsf_item_ld_dm and/or inv_rcpts_item_ld_dm. (Using the RDW 13.1 datamodel on Oracle Support as a reference.)
          The reserved quantity I would skip as a candidate for your business requirement.
          If you want to know how this is 'trapped' (filled) in RDW, please lookup the RMS operations guide nr1 and/or study the RMS RETL extraction scripts.
          Best regards, Erik Ykema

          PS: the better forum for RDW related questions is the Oracle Retail forum at Retail This forum relates to the ORDM, which is not an Oracle Retail product (though of course of interest to retailers...)

          Edited by: ErikYkema on Oct 27, 2010 7:56 AM
          • 2. Re: Issued Quantity in RDW
            DexterC
            Thanks Erik !!
            • 3. Re: Issued Quantity in RDW
              718433
              Hi Dhrubo,
              Just check these tables DWB_INV_CNTRL_DOC, DWB_INV_CNTRL_DOC_LI, these capture movement of inventory in and out of warehouse.
              Regards,
              KSK

              Edited by: user8745296 on Oct 28, 2010 4:03 AM
              • 4. Re: Issued Quantity in RDW
                ErikYkema
                Hi Siva,
                Please note that Dhrubo relates his question to the ORDW product, while the tables you mention are from ORDM.
                Best regards, Erik