eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: JE.JE_ES_MODELO_190_ALL#

Source

View Text - Preformatted


select ORG_ID ORG_ID, CONC_REQ_ID CONC_REQ_ID, FIN_IND FIN_IND, REMUN_TYPE REMUN_TYPE, VENDOR_NIF VENDOR_NIF, VENDOR_NAME VENDOR_NAME, INVOICE_ID INVOICE_ID, INVOICE_NUM INVOICE_NUM, INV_DOC_SEQ_NUM INV_DOC_SEQ_NUM, INVOICE_DATE INVOICE_DATE, GL_DATE GL_DATE, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, DATE_PAID DATE_PAID, NET_AMOUNT NET_AMOUNT, WITHHOLDING_TAX_AMOUNT WITHHOLDING_TAX_AMOUNT, ZIP_ELECTRONIC ZIP_ELECTRONIC, ZIP_LEGAL ZIP_LEGAL, CITY_LEGAL CITY_LEGAL, NUM_CHILDREN NUM_CHILDREN, SIGN SIGN, TAX_RATE TAX_RATE, TAX_NAME TAX_NAME, YEAR_DUE YEAR_DUE, SUB_REMUN_TYPE SUB_REMUN_TYPE, WITHHOLDABLE_AMT_IN_KIND WITHHOLDABLE_AMT_IN_KIND, WITHHOLDABLE_AMT_IN_KIND_SIGN WITHHOLDABLE_AMT_IN_KIND_SIGN, WITHHELD_AMT_IN_KIND WITHHELD_AMT_IN_KIND, WITHHELD_PYMT_AMT_IN_KIND WITHHELD_PYMT_AMT_IN_KIND, EARNED_AMOUNTS EARNED_AMOUNTS, CONTRACT_TYPE CONTRACT_TYPE, BIRTH_YEAR BIRTH_YEAR, DISABLED DISABLED, FAMILY_SITUATION FAMILY_SITUATION, PARTNER_FISCAL_CODE PARTNER_FISCAL_CODE, DESCENDANT_LT_3 DESCENDANT_LT_3, DESCENDANT_BT_3_16 DESCENDANT_BT_3_16, DESCENDANT_BT_16_25 DESCENDANT_BT_16_25, DISABLE_DESC_BT_33_65 DISABLE_DESC_BT_33_65, DISABLE_DESC_GT_65 DISABLE_DESC_GT_65, DESCENDANT_TOTAL DESCENDANT_TOTAL, DEDUCTIONS DEDUCTIONS, EXPENSES EXPENSES, SPOUSE_MAINTENANCE_AMT SPOUSE_MAINTENANCE_AMT, CHILDREN_MAINTENANCE_AMT CHILDREN_MAINTENANCE_AMT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID from "JE"."JE_ES_MODELO_190_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, CONC_REQ_ID CONC_REQ_ID
, FIN_IND FIN_IND
, REMUN_TYPE REMUN_TYPE
, VENDOR_NIF VENDOR_NIF
, VENDOR_NAME VENDOR_NAME
, INVOICE_ID INVOICE_ID
, INVOICE_NUM INVOICE_NUM
, INV_DOC_SEQ_NUM INV_DOC_SEQ_NUM
, INVOICE_DATE INVOICE_DATE
, GL_DATE GL_DATE
, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, DATE_PAID DATE_PAID
, NET_AMOUNT NET_AMOUNT
, WITHHOLDING_TAX_AMOUNT WITHHOLDING_TAX_AMOUNT
, ZIP_ELECTRONIC ZIP_ELECTRONIC
, ZIP_LEGAL ZIP_LEGAL
, CITY_LEGAL CITY_LEGAL
, NUM_CHILDREN NUM_CHILDREN
, SIGN SIGN
, TAX_RATE TAX_RATE
, TAX_NAME TAX_NAME
, YEAR_DUE YEAR_DUE
, SUB_REMUN_TYPE SUB_REMUN_TYPE
, WITHHOLDABLE_AMT_IN_KIND WITHHOLDABLE_AMT_IN_KIND
, WITHHOLDABLE_AMT_IN_KIND_SIGN WITHHOLDABLE_AMT_IN_KIND_SIGN
, WITHHELD_AMT_IN_KIND WITHHELD_AMT_IN_KIND
, WITHHELD_PYMT_AMT_IN_KIND WITHHELD_PYMT_AMT_IN_KIND
, EARNED_AMOUNTS EARNED_AMOUNTS
, CONTRACT_TYPE CONTRACT_TYPE
, BIRTH_YEAR BIRTH_YEAR
, DISABLED DISABLED
, FAMILY_SITUATION FAMILY_SITUATION
, PARTNER_FISCAL_CODE PARTNER_FISCAL_CODE
, DESCENDANT_LT_3 DESCENDANT_LT_3
, DESCENDANT_BT_3_16 DESCENDANT_BT_3_16
, DESCENDANT_BT_16_25 DESCENDANT_BT_16_25
, DISABLE_DESC_BT_33_65 DISABLE_DESC_BT_33_65
, DISABLE_DESC_GT_65 DISABLE_DESC_GT_65
, DESCENDANT_TOTAL DESCENDANT_TOTAL
, DEDUCTIONS DEDUCTIONS
, EXPENSES EXPENSES
, SPOUSE_MAINTENANCE_AMT SPOUSE_MAINTENANCE_AMT
, CHILDREN_MAINTENANCE_AMT CHILDREN_MAINTENANCE_AMT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
FROM "JE"."JE_ES_MODELO_190_ALL"