Previous  Next          Contents  Index  Glossary  Library

Column Headings (AR Third Party Operations Electronic Transfer)

The column headings listed below provide information on the contents of each column of the temporary table JE_ES_MODEL_ 347.

In this column
Oracle Receivables prints
TIPO
The type of operation. The column must contain one of the following values:
spn90000.gif A - Purchases (also populated by Oracle Payables)
spn90000.gif B - Sales (also populated by Oracle Receivables)
spn90000.gif C - Mediations
spn90000.gif D - Non Business Purchases by Public Bodies
spn90000.gif E - Grants or Subsidies
IMPORTE
The amount in Spanish Pesetas (without decimals).
NOMBRE
The surnames and first name or registered name of the declaree. If this is a person, the first surname, a space, the second surname, a space, and the whole first name should be entered. If this is a company, the registered name or title should be entered with no acronyms.
NIF
The declaree's taxpayer ID.
SIGLA
No longer used.
MUNICIPIO
No longer used.
CODIGO_POSTAL
A part of the postal code of the declaree's registered office. For domestic third parties, this column must contain the first two characters of the postal code (such as the numeric code for the province) followed by three zeros (000). For third parties whose registered office is outside Spain, it must contain ninety-nine (99) followed by the 3 digit numeric code for the country as defined by the Spanish Government in the B.O.E. 31-Dec-1992.
VIA_PUBLICA
No longer used.
NUMERO
No longer used.
FIN_IND
The letter S if the row comes from Oracle Financials (Oracle Payables or Oracle Receivables).
COMENTARIO
No longer used.


         Previous  Next          Contents  Index  Glossary  Library