Interface Table (Withholding Tax Open Interface)


	Previous	Next		Contents	Index	Glossary	Library

Interface Table (Withholding Tax Open Interface)

The JE_ES_MODELO_190 table stores external withholding tax transactions. This table is also used to store Oracle Financials withholding tax transactions.

The open interface only supports the insertion or deletion of external withholding tax transactions via the APIs that are provided. The open interface does not support direct SQL*PLUS manipulation of this table.

In this column…
Oracle Payables stores…
FIN_IND
The source of this record such as:
S - Oracle Payables
Anything else - External System
REMUN_TYPE
Remuneration Type:
G - Self Employed Remuneration
A - Employee Expense Remuneration
C, D, E, F, H, I, J, K, L - Other types of remunerations
VENDOR_NIF
Supplier's taxpayer ID.
VENDOR_NAME
Supplier's name.
GL_DATE
General Ledger date.
DATE_PAID
Date paid.
NET_AMOUNT
Net amount.
WITHHOLDING_TAX_AMOUNT
Withholding tax amount (absolute value).
ZIP_ELECTRONIC
Postal code/country.
NUM_CHILDREN
Number of children.
SIGN
Sign of net amount. If the sign is negative N, otherwise null or blank.
TAX_RATE
Withholding tax rate.
YEAR_DUE
Year the withholding became due.
Other columns exist in this table, but are not supported by the Open Interface.

Contents

Index

Glossary

Library

In this column…	Oracle Payables stores…
FIN_IND	The source of this record such as: S - Oracle Payables Anything else - External System
REMUN_TYPE	Remuneration Type: G - Self Employed Remuneration A - Employee Expense Remuneration C, D, E, F, H, I, J, K, L - Other types of remunerations
VENDOR_NIF	Supplier's taxpayer ID.
VENDOR_NAME	Supplier's name.
GL_DATE	General Ledger date.
DATE_PAID	Date paid.
NET_AMOUNT	Net amount.
WITHHOLDING_TAX_AMOUNT	Withholding tax amount (absolute value).
ZIP_ELECTRONIC	Postal code/country.
NUM_CHILDREN	Number of children.
SIGN	Sign of net amount. If the sign is negative N, otherwise null or blank.
TAX_RATE	Withholding tax rate.
YEAR_DUE	Year the withholding became due.