3 Replies Latest reply on Jul 5, 2010 7:29 PM by McGuru

    Taxable Field in IProc

    547241
      Hi

      Can anyone pelase tell me whether the value which we select for the field "Taxable" in IProc gets stored in any of the tables?


      Thanks
      SS
        • 1. Re: Taxable Field in IProc
          Sandeep Gandhi, Consultant
          The taxable flag itself does not get stored.
          However, if you mark a line as taxable, you have to enter a tax code. And that tax code is stored in po_requisition_lines_all.tax_code_id.
          So you can say that if that id is filled in, tax code = Y.

          Hope this answers your question
          Sandeep Gandhi
          Omkar Technologies Inc.
          Independent Techno-functional Consultant
          513-325-9026

          PS: I am not sure what information you are looking for but you can also see if po_requisition_lines_all.tax_status_indicator helps you get that. It kinda shows if the line is tax exempt or not.
          • 2. Re: Taxable Field in IProc
            user12009711
            Hey thanks Sandeep.

            But this is not exactly what am looking for. Actually i wanted to check whether the taxable field is 'Dont Know'.
            Any idea whether I can get this info.

            SS

            Edited by: user12009711 on Mar 1, 2010 7:31 AM
            • 3. Re: Taxable Field in IProc
              McGuru
              The flag ish stored at the line level in the TAX_STATUS_INDICATOR column. the values are mapped in the TaxableVO like so:
              select 'Yes' as display_name, 'NONEXEMPT' as value
              from dual
              union
              select 'No' as display_name, 'EXEMPT' as value
              from dual
              union
              select 'Don''t Know' as display_name, 'SYSTEM' as value
              from dual

              hope this helps