This content has been marked as final. Show 3 replies
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
Omkar Technologies Inc.
Independent Techno-functional Consultant
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.
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.
Edited by: user12009711 on Mar 1, 2010 7:31 AM
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
select 'No' as display_name, 'EXEMPT' as value
select 'Don''t Know' as display_name, 'SYSTEM' as value
hope this helps