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.

Details

• Schema: FUSION

• Object owner: JE

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_NAME	VARCHAR2	30			Identifies the concurrent program
PROGRAM_APP_NAME	VARCHAR2	50			Identifies the Application name spawning the Concurrent Request
FIN_IND	VARCHAR2	1		Yes	Record source is for Accounts Payable
REMUN_TYPE	VARCHAR2	1		Yes	Remuneration type
VENDOR_NIF	VARCHAR2	9		Yes	Supplier taxpayer identifier
VENDOR_NAME	VARCHAR2	360		Yes	Name of supplier in the records.
VENDOR_ID	NUMBER		18		Supplier Identifier in the records.
VENDOR_TYPE	VARCHAR2	80			Type of the supplier in the records.
ORGANIZATION_TYPE	VARCHAR2	80			Organization type of the supplier in the records.
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	60			Postal Code associated with supplier.
CITY_LEGAL	VARCHAR2	60			City where the supplier is located.
NUM_CHILDREN	NUMBER				Number of children
SIGN	VARCHAR2	1			Sign of net amount
TAX_RATE	NUMBER				Tax rate
TAX_NAME	VARCHAR2	30			Name of the withholding tax for the supplier.
YEAR_DUE	NUMBER				Year withholding tax is due
SUB_REMUN_TYPE	VARCHAR2	2			Subtype of remuneration
WITHHOLDABLE_AMT_IN_KIND	NUMBER				Withholding Tax 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
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
JE_ES_MODELO_190_N1	Non Unique	Default	LEGAL_ENTITY_ID, ORG_ID