Previous	Next		Contents	Index	Glossary	Library

In this column	Oracle Payables prints
Record Type	0 (first header record code).
Report Type	347.
Year	The year. The value for year is passed to the report as a parameter.
Tax Office	The numerical code of the tax office where the declaration is submitted. The value for tax office is passed to the report as a parameter.
NIF (Declarer)	Your taxpayer ID.
Registered Name	Your company name.
Type	The street type of your registered office's address.
Street	The street name of your registered office's address.
Number	The street number or kilometer of your registered office's address.
Postal Code	The postal code of your registered office.
Town or City	The town or city of your registered office.
Telephone Area Code	The telephone area code of the contact person. The value for telephone area code is passed to the report as a parameter.
Telephone Number	The contact person's telephone number. The value for telephone number is passed to the report as a parameter.
Total Number of Declarers	The total number of declarers in this file. This will always be 1.
Total Number of Declarees	The total number of declarees. This is the same as the number of rows in the table je_es_modelo_347 for the set of books.

The column headings listed below provide information about the contents of each column in the second header record

In this column	Oracle Payables prints
Record Type	1 (second header record code).
Report Type	Same as record type 0.
Year	Same as record type 0.
Tax Office	Same as record type 0.
NIF (Declarer)	Same as record type 0.
Registered Name	Same as record type 0.
Number of Purchase Declarations	The count of the number of the records of type 2 and operation type A .
Total of Purchase Declarations	The sum of the amount of the records of type 2 and operation type A.
Number of Sales Declarations	The count of the number of the records of type 2 and operation type B.
Total of Sales Declarations	The sum of the amount of the records of type 2 and operation type B .
Number of Mediation Declarations	The count of the number of the records of type 2 and operation type C.
Total of Mediation Declarations	The sum of the amount of the records of type 2 and operation type C. Number of Non Business Purchases by Public Bodies Oracle prints the count of the number of the records of type 2 and operation type D.
Total of Non Business Purchases by Public Bodies	The sum of the amount of the records of type 2 and operation type D.
Number of Grants or subsidies	The count of the number of the records of type 2 and operation type E.
Total of Grants or subsidies	The sum of the amount of the records of type 2 and operation type E.

The column headings listed below provide information about the contents of each column in the detail record

In this column	Oracle Receivables prints
Record Type	2 (detail record code).
Report Type	Same as record type 0.
Year	Same as record type 0.
Tax Office	Same as record type 0.
NIF (Declarer)	Same as record type 0.
Registered Name	Same as record type 0.
Type of Operation	The type of operation. The column must contain one of the following values: A - Purchases (also populated by Oracle Payables) B - Sales (also populated by Oracle Receivables) C - Mediations D - Non Business Purchases by Public Bodies E - Grants or Subsidies
NIF (Declaree)	The taxpayer ID for the third party
Legal Representative	Blank.
Postal Code / Country	For domestic third parties, the first two characters of the third party's 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.
Amount	The amount in Spanish Pesetas (without decimals).
Insurance Operation	Blank.
Rent	Blank.