Product: | JE - European Localizations |
---|---|
Description: | View for Spanish Withholding Tax Extract (Modelo 190) |
Implementation/DBA Data: | Not implemented in this database |
SELECT ORG_ID
, CONC_REQ_ID
, FIN_IND
, REMUN_TYPE
, SUB_REMUN_TYPE
, VENDOR_NIF
, VENDOR_NAME
, INVOICE_ID
, INVOICE_NUM
, INV_DOC_SEQ_NUM
, INVOICE_DATE
, GL_DATE
, INVOICE_PAYMENT_ID
, DATE_PAID
, NET_AMOUNT
, WITHHOLDING_TAX_AMOUNT
, WITHHOLDABLE_AMT_IN_KIND
, WITHHOLDABLE_AMT_IN_KIND_SIGN
, WITHHELD_AMT_IN_KIND
, WITHHELD_PYMT_AMT_IN_KIND
, EARNED_AMOUNTS
, ZIP_ELECTRONIC
, ZIP_LEGAL
, CITY_LEGAL
, NUM_CHILDREN
, SIGN
, TAX_RATE
, TAX_NAME
, YEAR_DUE
, CONTRACT_TYPE
, BIRTH_YEAR
, DISABLED
, FAMILY_SITUATION
, PARTNER_FISCAL_CODE
, DESCENDANT_LT_3
, DESCENDANT_BT_3_16
, DESCENDANT_BT_16_25
, DISABLE_DESC_BT_33_65
, DISABLE_DESC_GT_65
, DESCENDANT_TOTAL
, DEDUCTIONS
, EXPENSES
, SPOUSE_MAINTENANCE_AMT
, CHILDREN_MAINTENANCE_AMT
FROM JE_ES_MODELO_190_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)