DBA Data[Home] [Help] [Dependency Information]

TABLE: JE.JE_ES_MODELO_190_ALL

Object Details
Object Name: JE_ES_MODELO_190_ALL
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_ES_MODELO_190_ALL
Subobject Name:
Status: VALID


JE_ES_MODELO_190_ALL contains information relating to Spanish
Withholding Tax processing.
During each processing, records from previous processing are first
deleted before new records are inserted.
Scope: public
Product: JE
Lifecycle: active
Display Name: Spanish Withholding Tax Interface
Category: BUSINESS_ENTITY JE_ES_WHT


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_ES_MODELO_190_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONC_REQ_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER

Organization identifier
CONC_REQ_ID NUMBER

Concurrent request identifier
FIN_IND VARCHAR2 (1) Yes Record source ("S" is for Payables)
REMUN_TYPE VARCHAR2 (1) Yes Remuneration type
VENDOR_NIF VARCHAR2 (9) Yes Supplier taxpayer identifier
VENDOR_NAME VARCHAR2 (240) Yes Supplier name
INVOICE_ID NUMBER

Invoice identifier
INVOICE_NUM VARCHAR2 (50)
Invoice number
INV_DOC_SEQ_NUM VARCHAR2 (100)
Invoice document sequence number
INVOICE_DATE DATE

Invoice date
GL_DATE DATE

General Ledger date
INVOICE_PAYMENT_ID NUMBER

Invoice payment identifier
DATE_PAID DATE

Date invoice paid
NET_AMOUNT NUMBER
Yes Net amount
WITHHOLDING_TAX_AMOUNT NUMBER
Yes Withholding tax amount
ZIP_ELECTRONIC VARCHAR2 (5)
Postal code/country
ZIP_LEGAL VARCHAR2 (5)
Postal code
CITY_LEGAL VARCHAR2 (25)
City
NUM_CHILDREN NUMBER

Number of children
SIGN VARCHAR2 (1)
Sign of net amount
TAX_RATE NUMBER

Tax rate
TAX_NAME VARCHAR2 (15)
Tax name
YEAR_DUE NUMBER

Year withholding tax is due
SUB_REMUN_TYPE VARCHAR2 (2)
Subtype of remuneration
WITHHOLDABLE_AMT_IN_KIND NUMBER

Withholdable amount in kind
WITHHOLDABLE_AMT_IN_KIND_SIGN VARCHAR2 (1)
Withholding tax amount sign
WITHHELD_AMT_IN_KIND NUMBER

Withheld amount in kind
WITHHELD_PYMT_AMT_IN_KIND NUMBER

Withheld amount for payments in kind
EARNED_AMOUNTS NUMBER

Amounts earned in Ceuta or Melilla
CONTRACT_TYPE NUMBER

Type of contract
BIRTH_YEAR NUMBER

Year of birth
DISABLED NUMBER

Disabled
FAMILY_SITUATION NUMBER

Family situation
PARTNER_FISCAL_CODE VARCHAR2 (15)
Partner's fiscal code
DESCENDANT_LT_3 NUMBER

Descendants less than 3 years old
DESCENDANT_BT_3_16 NUMBER

Descendants between 3 and 16 years old
DESCENDANT_BT_16_25 NUMBER

Descendants between 16 and 25 years old
DISABLE_DESC_BT_33_65 NUMBER

Disabled descendants between 33% and 65%
DISABLE_DESC_GT_65 NUMBER

Disabled descendants more than 65%
DESCENDANT_TOTAL NUMBER

Total number of descendants
DEDUCTIONS NUMBER

Deductions
EXPENSES NUMBER

Expenses
SPOUSE_MAINTENANCE_AMT NUMBER

Maintenance of spouse
CHILDREN_MAINTENANCE_AMT NUMBER

Maintenance of children
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      CONC_REQ_ID
,      FIN_IND
,      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
,      ZIP_ELECTRONIC
,      ZIP_LEGAL
,      CITY_LEGAL
,      NUM_CHILDREN
,      SIGN
,      TAX_RATE
,      TAX_NAME
,      YEAR_DUE
,      SUB_REMUN_TYPE
,      WITHHOLDABLE_AMT_IN_KIND
,      WITHHOLDABLE_AMT_IN_KIND_SIGN
,      WITHHELD_AMT_IN_KIND
,      WITHHELD_PYMT_AMT_IN_KIND
,      EARNED_AMOUNTS
,      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
,      LEGAL_ENTITY_ID
FROM JE.JE_ES_MODELO_190_ALL;

Dependencies

[top of page]

JE.JE_ES_MODELO_190_ALL does not reference any database object

JE.JE_ES_MODELO_190_ALL is referenced by following:

SchemaAPPS
SynonymJE_ES_MODELO_190_ALL