[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JE_ES_MODELO_347_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JE |
| FND Design Data: |  JE.JE_ES_MODELO_347_ALL
|
| Subobject Name: | |
| Status: | VALID |
JE_ES_MODELO_347_ALL is a partitioned table that contains information
from Third Party Operations processing. The NOMBRE column stores the following information:
For a person, the first surname, a space, the second surname,
a space, and the whole first name
For a company, the registered name or title with no
acronyms.
The TIPO column stores one of the following:
A - Purchases (also populated by Oracle Payables)
C - Mediations
D - Non Business Purchases by Public Bodies
E - Grants or Subsidies
The CODIGO_POSTAL column stores one of the following:
For domestic third parties, 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,
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.
During each processing, records from previous processing are first
deleted before new ones are inserted.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IMPORTE | NUMBER | Yes | Amount in Spanish pesetas (without decimals) | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| TIPO | VARCHAR2 | (1) | Yes | Type of operation (A for Payables or B for Receivables) |
| NOMBRE | VARCHAR2 | (60) | Surnames, first name or registered name of declaree | |
| NIF | VARCHAR2 | (9) | Taxpayer identifier of declaree | |
| SIGLA | VARCHAR2 | (4) | Not currently used | |
| MUNICIPIO | VARCHAR2 | (50) | Not currently used | |
| CODIGO_POSTAL | VARCHAR2 | (5) | Postal code of declaree's registered office address | |
| FIN_IND | VARCHAR2 | (1) | Source (S for system created) | |
| VIA_PUBLICA | VARCHAR2 | (50) | Not currently used | |
| NUMERO | NUMBER | (5) | Not currently used | |
| COMENTARIO | VARCHAR2 | (130) | Not currently used | |
| FLAG_ARRENDA | VARCHAR2 | (1) | 'Y' means property rental | |
| ESCALERA | VARCHAR2 | (2) | Staircase number of rental property | |
| PISO | VARCHAR2 | (2) | Floor number of rental property | |
| PUERTA | VARCHAR2 | (2) | Door number of rental property | |
| REF_CATASTRAL | VARCHAR2 | (25) | Rates reference for rental property |
Cut, paste (and edit) the following text to query this object:
SELECT IMPORTE
, SET_OF_BOOKS_ID
, ORG_ID
, TIPO
, NOMBRE
, NIF
, SIGLA
, MUNICIPIO
, CODIGO_POSTAL
, FIN_IND
, VIA_PUBLICA
, NUMERO
, COMENTARIO
, FLAG_ARRENDA
, ESCALERA
, PISO
, PUERTA
, REF_CATASTRAL
FROM JE.JE_ES_MODELO_347_ALL;
JE.JE_ES_MODELO_347_ALL does not reference any database object
JE.JE_ES_MODELO_347_ALL is referenced by following:
APPS
JE_ES_MODELO_347_ALL
|
|
|
|