Table SPAMOD347D
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SPAMOD347D | SPM347D | Spanish form 347 | Financials | KSP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPM347D | CPY+FIY+NUMDECL+CONTADOR | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ARRENLOCAL | Rental | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BLOQUE | Block | A | 3 | |||||
| CALIFNUM | Qualification code | A | 3 | |||||
| CLAOPE | Operation key | ADI | [ADI]CODE=329;CLAOPE | Block | ||||
| CODMUNIC | Municipality code | A | 4 | |||||
| CODPOSTAL | Postal code | A | 5 | |||||
| CODPROV | Province code | A | 2 | |||||
| COMPLEMENTO | Complementary field | A | 40 | |||||
| CONTADOR | Sequence number | L | 8 | |||||
| CPY | Company | CPY | [CPY]CPY0=[SPM347D]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SPM347D]CREUSR | Other | ||||
| CRNDECL | Taxpayer TIN | CRN | ||||||
| CRNDECL1 | Taxpayer TIN | CRN | ||||||
| CRNEUOPE | EU VAT no. | A | 17 | |||||
| CRNREP | Representative TIN | CRN | ||||||
| CSHVAT | Cash VAT | M | 4 | 1 | ||||
| EJERCPCONT | Fiscal year cash payment | C | 4 | |||||
| ESCALERA | Staircase | A | 3 | |||||
| FIY | Fiscal year | A | 4 | |||||
| IMPOPERAC | Annual total | DCB | 12.2 | |||||
| IMPORMETAL | Cash amount | DCB | 12.2 | |||||
| IMPORT1 | Q1 amount | DCB | 12.2 | |||||
| IMPORT2 | Q2 amount | DCB | 12.2 | |||||
| IMPORT3 | Q3 amount | DCB | 12.2 | |||||
| IMPORT4 | Q4 amount | DCB | 12.2 | |||||
| IMPORTETRA | Annual building transfer amount | DCB | 12.2 | |||||
| IMPTRAT1 | Q1 transfer amount | DCB | 12.2 | |||||
| IMPTRAT2 | Q2 transfer amount | DCB | 12.2 | |||||
| IMPTRAT3 | Q3 transfer amount | DCB | 12.2 | |||||
| IMPTRAT4 | Q4 transfer amount | DCB | 12.2 | |||||
| ISP | ISP reverse charge | M | 4 | 1 | ||||
| LOCALIDAD | Locality | A | 30 | |||||
| MUNICIPIO | Municipality | A | 30 | |||||
| NOMBREVIA | Street | A | 50 | |||||
| NUMCASA | Street number | L | 5 | |||||
| NUMDECL | Declaration number | C | 4 | |||||
| OPADUANAS | Customs information | M | 4 | 1 | ||||
| OPESEGURO | Insurance | M | 4 | 1 | ||||
| PAIS | Country | A | 2 | |||||
| PISO | Floor | A | 3 | |||||
| PORTAL | Portal | A | 3 | |||||
| PROVINCIA | Province | A | 2 | |||||
| PUERTA | Door | A | 3 | |||||
| RAZSOCDEC | BP name | A | 40 | |||||
| RAZSOCDEC1 | BP name | A | 40 | |||||
| REFERENCIA | Cadastre | A | 25 | |||||
| SITINMUEBL | Location | M | 12 | 3611 | ||||
| TIPOHOJA | Sheet | A | 1 | |||||
| TIPONUM | Type of location | A | 3 | |||||
| TIPOVIA | Type | A | 5 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SPM347D]UPDUSR | Other |