1. Tables and Views for Financials
  2. AR_XML_INVOICE_TAX_V

AR_XML_INVOICE_TAX_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CUSTOMER_TRX_LINE_ID

LINK_TO_CUSTOMER_TRX_LINE_ID

TAX_AMOUNT

TAXABLE_AMOUNT

CURRENCY_CODE

TAX_RATE

TAX_CODE

LINE_NUMBER

DESCRIPTION

TAX_USER_ONE

TAX_USER_TWO

TAX_USER_THREE

TAX_USER_FOUR

TAX_USER_FIVE

TAX_USER_SIX

TAX_USER_SEVEN

TAX_USER_EIGHT

TAX_USER_NINE

TAX_USER_TEN

TAX_USER_ELEVEN

TAX_USER_TWELVE

TAX_USER_THIRTEEN

TAX_USER_FOURTEEN

TAX_USER_FIFTEEN

TAX_USER_SIXTEEN

TAX_USER_SEVENTEEN

TAX_USER_EIGHTEEN

TAX_USER_NINETEEN

TAX_USER_TWENTY

TAX_USER_TWENTY_ONE

TAX_USER_TWENTY_TWO

TAX_USER_TWENTY_THREE

TAX_USER_TWENTY_FOUR

TAX_USER_TWENTY_FIVE

TAX_USER_TWENTY_SIX

TAX_USER_TWENTY_SEVEN

TAX_USER_TWENTY_EIGHT

TAX_USER_TWENTY_NINE

TAX_USER_THIRTY

TAX_NAME

EXEMPT_REASON_CODE

EXEMPT_REASON

TAX_REGIME_CODE

TAX_POINT_BASIS

TAX_RATE_TYPE

TAX_CURRENCY_CODE

TAX_AMT_TAX_CURR

TAX_AMT_FUNCL_CURR

TAXABLE_AMT_TAX_CURR

TAXABLE_AMT_FUNCL_CURR

TAX_CURRENCY_CONVERSION_DATE

TAX_EXEMPTION_ID

TAX_RATE_ID

TRX_DATE

TAX_STATUS_NAME

TAX_STATUS_CODE

LEGAL_JUSTIFICATION_TEXT

LEGAL_JUSTIFICATION_CODE

Query

SQL_Statement

SELECT

l.customer_trx_line_id CUSTOMER_TRX_LINE_ID,

l.link_to_cust_trx_Line_id LINK_TO_CUSTOMER_TRX_LINE_ID,

l.extended_amount TAX_AMOUNT,

l.taxable_amount TAXABLE_AMOUNT,

header.INVOICE_CURRENCY_CODE CURRENCY_CODE,

l.tax_rate TAX_RATE,

v.tax_rate_code TAX_CODE,

l.line_number LINE_NUMBER,

l.description DESCRIPTION,

ar_xml_view_functions.tax_function1 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_One,

ar_xml_view_functions.tax_function2 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Two,

ar_xml_view_functions.tax_function3 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Three,

ar_xml_view_functions.tax_function4 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Four,

ar_xml_view_functions.tax_function5 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Five,

ar_xml_view_functions.tax_function6 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Six,

ar_xml_view_functions.tax_function7 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Seven,

ar_xml_view_functions.tax_function8 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Eight,

ar_xml_view_functions.tax_function9 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Nine ,

ar_xml_view_functions.tax_function10 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Ten,

ar_xml_view_functions.tax_function11 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Eleven,

ar_xml_view_functions.tax_function12 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twelve,

ar_xml_view_functions.tax_function13 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Thirteen,

ar_xml_view_functions.tax_function14 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Fourteen,

ar_xml_view_functions.tax_function15 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Fifteen,

ar_xml_view_functions.tax_function16 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Sixteen,

ar_xml_view_functions.tax_function17 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Seventeen,

ar_xml_view_functions.tax_function18 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Eighteen,

ar_xml_view_functions.tax_function19 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Nineteen,

ar_xml_view_functions.tax_function20 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty,

ar_xml_view_functions.tax_function21 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_One,

ar_xml_view_functions.tax_function22 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Two,

ar_xml_view_functions.tax_function23 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Three,

ar_xml_view_functions.tax_function24 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Four,

ar_xml_view_functions.tax_function25 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Five,

ar_xml_view_functions.tax_function26 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Six,

ar_xml_view_functions.tax_function27 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Seven,

ar_xml_view_functions.tax_function28 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Eight,

ar_xml_view_functions.tax_function29 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Twenty_Nine,

ar_xml_view_functions.tax_function30 (l.customer_trx_id, l.customer_trx_line_id) Tax_User_Thirty,

v.TAX TAX_NAME,

v.EXEMPT_REASON_CODE EXEMPT_REASON_CODE,

v.EXEMPT_REASON EXEMPT_REASON,

v.TAX_REGIME_CODE TAX_REGIME_CODE,

v.TAX_POINT_BASIS,

v.TAX_RATE_TYPE,

v.TAX_CURRENCY_CODE,

v.TAX_AMT_TAX_CURR,

v.TAX_AMT_FUNCL_CURR,

v.TAXABLE_AMT_TAX_CURR,

v.TAXABLE_AMT_FUNCL_CURR,

v.TAX_CURRENCY_CONVERSION_DATE,

v.TAX_EXEMPTION_ID,

v.TAX_RATE_ID,

header.TRX_DATE,

v.TAX_STATUS_NAME,

v.TAX_STATUS_CODE,

rc.REPORTING_CODE_NAME LEGAL_JUSTIFICATION_TEXT,

rc.REPORTING_CODE_CHAR_VALUE LEGAL_JUSTIFICATION_CODE

from

ra_customer_trx_all header,

ra_customer_trx_lines_all l,

zx_lines_v v,

zx_reporting_codes_vl rc

WHERE

header.CUSTOMER_TRX_ID = l.CUSTOMER_TRX_ID

and l.tax_line_id = v.tax_line_id

and l.link_to_cust_trx_line_id is not null

and l.line_type = 'TAX'

and rc.reporting_code_id (+) = v.legal_message_rate

order by l.line_number